๐ Analyzing over 100000 American Fast Food Restaurants Records
More Details: go to the Kaggle Kernel
The bar plot shows that "McDonald's" is the most popular fast food restaurants in the US. However, we can see there exist data entry error because "McDonalds" appearred again in the plot and so does Subway and SUBWAY. Hence, I used Edit-distance algorithm to find most similar words and they can possibily be included in the dataset due to error of data entry.
Looking at the bar plot again with updated, standardized restaurant names, we can observe that "Subway" is the most popular restaurant in the US followed by "Mc Donald's", "Taco Bell", and "Pizza Hut".
We have fast food restaurants entries from 2014 to 2019 with most entries from 2019. The dataset has data updated from December 2018 to May 2019.
After concatenating restaurant categories with underscore, I used wordcloud to help visualize the categories of top 50 mentioned restaurants. They things in common: American, Take out, and Hamburgers and Hot Dogs.
Columbus is the state capital and the most populous city in the U.S. State of Ohio. With a population of 892,533 as of 2018 estimates, it is the 14th-most populous city in the United States and one of the fastest growing large cities in the nation. From the below graph, we can see Columbus is populated with fast food restaurants.
Ohio state has the highest number of fast food restaurants record in the dataset.
In Columbus, Subway opened highest number of fast food restaurants.
In Indianapolis, Pizza Hut opened highest number of fast food restaurants.
In Birminham, Subway opened highest number of fast food restaurants.
Counting the number of fast food restaurants opened in each state, we can observe that the east of the
US has more fast food restaurants opened; California is the most fast food restaurants populated state.
The scatter plot on map shows that the east has clearly more red dots or fast food restaurants comparing to the west.
Divising the number of fast food restaurants by 2019 population in each state, we can see there exist strong positive correlation between the population in each state and the number of fast food restaurants opened in each state.