In this Project, going to analyze the Swiggy Restaurants dataset collected from every city in India. As Swiggy is one of the leading food delivery platforms with more than 100k restaurants listed all around India. We will analyze this dataset available on Kaggle and draw some conclusions.
DataSet URL https://www.kaggle.com/datasets/ashishjangra27/swiggy-restaurants-dataset
- Download the dataset and analyze the dataset in SQL.
- Data Preparation & Cleaning The Dataset.
- Perform exploratory analysis.
- Answer interesting questions from the dataset.
- What are the most Popular Cuisines served throughout the dataset?
- What are the top 5 most popular restaurant chains in India in terms of ratings given? Taking only those rating_count that are equal to or greater than 100.?
- Which are those Restaurants that have a maximum number of branches?
- What are the top 10 cities as per the number of restaurants listed?
- What are the Top 5 most popular restaurant chains in India?
- Which city is having the least expensive restaurant in terms of cost?
- Number of cities (including subregions) where Swiggy is having their restaurants listed?
- Restaurant chain with a maximum number of branches?
- The most popular cuisine is North India which is served in 13869 restaurants in India.
- The most popular restaurant chain in India in terms of ratings is SHRI KRISHNA FOOD ZONE.
- Domino's Pizza has 405 branches which is the maximum among all the restaurants in India.
- Bikaner has 756 restaurants listed in the city which is the highest all over India.
- The top 5 most popular chains are Apna Food Court AP's Kitchen, B Chom Ping, Bansal's Thali & Combo Meals, and Bento It.
- Kollam City is having the least expensive restaurant in terms of cost.
- Number of cities where Swiggy is having their restaurants listed is 774 cities.
- Restaurant chain with the maximum number of branches is Domino's Pizza.