Exploratory Data Analysis of Zomato Restaurant
“A recipe has no soul. You, as the cook, must bring soul to the recipe.”
I really get fascinated by good quality food being served in the restaurants and would like to help the community find the best cuisines around their area.
Zomato API Analysis is one of the most useful analyses for foodies who want to taste the best cuisines of every part of the world which lies in their budget. This analysis is also for those who want to find value-for-money restaurants in various parts of the country for cuisines. Additionally, this analysis caters to the needs of people who are striving to get the best cuisine of the country and which locality of that country serves that cuisine with a maximum number of restaurants.♨️
Zomato is an Indian multinational restaurant aggregator and food delivery company founded by Deepinder Goyal, Pankaj Chaddah, and Gunjan Patidar in 2008. Zomato provides information, menus, and user reviews of restaurants as well as food delivery options from partner restaurants in select cities. As of 2019, the service is available in 24 countries and more than 10,000 cities.
Zomato was founded as Foodiebay in 2008 and was renamed Zomato on 18 January 2010 as Zomato Media Pvt. Ltd. In 2011, Zomato expanded across India to Delhi NCR, Mumbai, Bangalore, Chennai, Pune, and Kolkata. In 2012, the company expanded operations internationally in several countries, including the United Arab Emirates, Sri Lanka, Qatar, the United Kingdom, the Philippines, and South Africa. In 2013, Zomato was launched in New Zealand, Turkey, Brazil, and Indonesia, with its website and apps available in Turkish, Portuguese, Indonesian, and English languages. In April 2014, Zomato launched its services in Portugal, which was followed by launches in Canada, Lebanon, and Ireland in 2015.
In 2019, Zomato acquired Seattle-based food portal Urbanspoon, which led to the firm’s entry into the United States and Australia. This U.S.-expansion brought Zomato into direct competition with similar models such as Yelp and Foursquare.
Zomato had also made a name for itself for its prowess in digital marketing.
Like most other startups, India’s pioneering food tech unicorn Zomato has seen many peaks and troughs in its journey. While there were some illustrious moments and accomplishments, there were troubled times too, some that even brought the very existence of the company into question.
During the massive layoffs and losses of 2015, the chances of Zomato’s survival seemed slim. In a belt-tightening move, the company laid off about 300 employees — nearly 10% of its total headcount — to cut costs in its weaker business aspects and shift the focus to more revenue-generating areas like reservations.
However, in Zomato’s decade of existence, this was the biggest rough spot the company actually ever hit. The rest of the time, founder and CEO Deepinder Goyal and co-founder Pankaj Chaddah (who left Zomato in 2018) steadfastly held on to the reins of the company and kept it on the path of growth and expansion, making it India’s first food tech unicorn.
While Zomato competes with Swiggy, UberEats, and Ola-Foodpanda among others, the company continues to innovate offerings and expand in the manner it has been doing since the day it all started.
Dataset:
https://www.kaggle.com/shrutimehta/zomato-restaurants-data
Fetching the data:
• Data has been collected from the Zomato API in the form of .json files(raw data) using the url=”https://developers.zomato.com/api/v2.1/search?entity_id=1&entity_type=city&start=1&count=20"
• Raw data can be seen here
Data Collection:
Data collected can be seen as a raw .json file here
Data Storage:
The collected data has been stored in the Comma Separated Value file Zomato.csv. Each restaurant in the dataset is uniquely identified by its Restaurant Id. Every Restaurant contains the following variables:
• Restaurant Id: Unique id of every restaurant across various cities of the world
• Restaurant Name: Name of the restaurant
• Country Code: Country in which restaurant is located
• City: City in which restaurant is located
• Address: Address of the restaurant
• Locality: Location in the city
• Locality Verbose: Detailed description of the locality
• Longitude: Longitude coordinate of the restaurant’s location
• Latitude: Latitude coordinate of the restaurant’s location
• Cuisines: Cuisines offered by the restaurant
• Average Cost for two: Cost for two people in different currencies 👫
• Currency: Currency of the country
• Has Table booking: yes/no
• Has Online delivery: yes/ no
• Is delivering: yes/ no
• Switch to order menu: yes/no
• Price range: range of price of food
• Aggregate Rating: Average rating out of 5
• Rating color: depending upon the average rating color
• Rating text: text-based on the rating of rating
• Votes: Number of ratings cast by people
List of countries the survey is spread across:
List of countries the survey is spread across —
Philippines, Brazil, United States, Australia, Canada, Singapore, UAE, India, Indonesia, New Zealand, United Kingdom, Qatar, South Africa, Sri Lanka, Turkey.
The total number to the country is 15.
As Zomato is a startup from India hence it makes sense that it has maximum business spread across restaurants in India.
Understanding the Rating aggregate, color, and text:
The above information helps us to understand the relation between Aggregate rating, color, and text. We conclude the following color assigned to the ratings:
*Rating 0 — White — Not rated
*Rating 1.8 to 2.4 — Red — Poor
*Rating 2.5 to 3.4 — Orange — Average
*Rating 3.5 to 3.9 — Yellow — Good
*Rating 4.0 to 4.4 — Green — Very Good
*Rating 4.5 to 4.9 — Dark Green — Excellent
Let us try to understand the spread of ratings across restaurants.
The not rated count is very high, let's visualize what is cause.
India seems to have maximum unrated restaurants. In India the culture of ordering online food is still gaining momentum hence most of the restaurants are still unrated on Zomato as people might be preferring to visiting the restaurant for a meal.
Currency across the country:
Online Delivery:
It’s look’s like most of the hotel doesn’t have online delivery. Only 25.3% of restaurants have online delivery systems across the world. This data might be biased as we have the maximum number of restaurants listed here are from India.
Let us try to understand the coverage of the city:
We can see that in New Delhi, Gurgaon, Noida Zomato’s presence is very high.
Let’s analyze based on my home city Kolkata:
Kolkata — the Cultural Capital of India is a heaven for foodies and especially for people with sweet tooth. Bengali sweets are famous and certainly need no introduction, however; the spicy, tangy and absolutely mouth-watering street food of Kolkata will leave you undecided on whether you like the spicy Bengali cuisine more or the melting flavors of the sweetmeats. Add to that the traditional Chinese and Tibetan food that are found here and you’re spoilt for choices.
Bengali cuisine (Bengali: বাঙালি খাবার) is the culinary style of the Bengal region in the eastern part of the Indian subcontinent in Bangladesh and the Indian states of West Bengal, Tripura, and Assam’s Barak Valley. There is an emphasis on fish, meat, vegetables, and lentils with rice as a staple.
Many Bengali food traditions draw from social activities, such as adda, or the Mezban.
Bengali cuisine is known for its varied use of flavors, as well as the spread of its confectioneries and desserts. It has the only traditionally developed multi-course tradition from the cuisine of the Indian subcontinent that is analogous in structure to the modern service à la russe style of French cuisine, with food served in courses rather than all at once.
Specialties of Kolkata:
In Kolkata, many local street vendors own small shops from which they sell their own homemade goods. Items like cheeses (paneer) can be eaten as is or can be made into sweet Sandesh, rosogolla, or chanar payesh. Milk is especially used in Kolkata’s various types of payesh, differing in the use of different grains and additives like dates, figs, and berries. In addition to European foodstuffs like chocolate, Kolkata takes culinary influence from its Chinese diaspora. Puchka, also known as panipuri, is a common kind of Bengali street food made with a fried dough casing and a potato and chickpea filling, usually found in small stalls alongside bhelpuri, masala chai, ghugni and chaat stalls.
Bengali cuisine can be subdivided into four different types of dishes, charbya (Bengali: চর্ব্য), or food that is chewed, such as rice or fish; choṣya (Bengali: চোষ্য), or food that is sucked, such as ambal and tak; lehya (Bengali: লেহ্য), or foods that are meant to be licked, like chutney; and peya (Bengali: পেয়), which includes drinks, mainly milk.[20]
Traditional Culinary Delights Of Kolkata Cuisine
Kolkata Cuisine is known for its exquisite taste. These are some of the traditional dishes which one must taste and enjoy the authentic flavors of the ages-old Bengali delicacies.
- Macher Jhol — Exclusive Fish Curry
- Kolkata Biryani — Finely Flavoured Rice
- Kosha Mangsho — Special Mutton Curry
- Alur Torkari With Luchi — Kolkata Style Aloo Poori
- Shukto — Bowl Of Veggies
- Chelo Kebab — Unique Platter
- Mochar Ghonto — Flavorsome Bites
- Katla Kalia — Traditional Delicacy
- Macher Muri Ghonto — Bowl For Health
- Aloo Posto — For Potato Lovers
- Phuchka — Cute Paani Puri
- Telebhaja — Perfect Snack
- Jhalmuri — Healthy Munchings
- Chop — Spicy Cutlets
- Kathi Rolls — World Famous Wraps
- Roshogullas — Sweet Tooth Love
- Sandesh — Mandatory Bites
- Chom Chom — Delicious Amalgamation
- Mishti Doi — Fermented Sweet Yogurt
- Patisapta — Festive Delights
The highest number of restaurants under zomato services in Kolkata with online booking:
Highest 25 costly restaurants for 2 persons in Kolkata:
Average Cost for two vs Aggregate rating :
Kolkata is your best choice as the capital of West Bengal is one of the most affordable cities in the world to live in. Based on the cost of buying or renting a home, the cost of switching to and from the workplace, the cost of household utilities, the cost of childcare, and more, the cost of living in Kolkata ranges from Rs 10,000 to Rs 50,000 per month. The living cost in Kolkata is equal to that in Bangalore or Delhi, although the standard of living in Kolkata is higher. In general, most of the things needed in Kolkata are affordable.
Price range vs avg cost vs cities of India:
Note: Due to unavoidable circumstances we have to post the screanshot of this video graph plot. But this is actually a video where the points are moving. I’m uploading my code notebook to kaggle from there viewer can view this plot.
Inferences and Conclusions:
We’ve drawn many inferences from the survey. Here’s a summary of a few of them:
- The dataset is skewed towards India and doesn’t represent the complete data of restaurants worldwide.
- Restaurants rating is categorized into six categories
- Not Rated
- Average
- Good
- Very Good
- Excellent
- There is no relation between cost and rating. Some of the best-rated restaurants are low on cost and vice versa.
Project Link:
https://www.kaggle.com/soham27/exploratory-data-analysis-of-zomato-restaurant
