Zomato Decoded — An Exploratory Data Analysis of Zomato Restaurants

Md Adnan
8 min readFeb 20, 2024

--

Image Source Link

More Than Just Food Delivery: Zomato’s Importance in Today’s World

In a world increasingly driven by convenience and technology, Zomato has become a more than just a food delivery app. It’s a platform transforming how we discover, explore, and experience dining. With over 1.4 million restaurants across 23 countries and 1.25 million daily orders, its popularity speaks for itself. But what makes Zomato truly significant?

Firstly, Zomato empowers informed choices. Through detailed restaurant listings, user reviews, and ratings, it democratizes access to information, allowing users to discover hidden gems or make informed decisions before stepping out. No longer are diners reliant on word-of-mouth or limited options — Zomato opens doors to a world of culinary possibilities.

Secondly, Zomato fosters convenience and saves time. In today’s fast-paced lives, the ability to order food online directly from a vast selection of restaurants, track its progress, and pay seamlessly is invaluable. This convenience extends beyond delivery — table reservations, restaurant search filters, and personalized recommendations offer a complete dining experience at your fingertips.

Thirdly, Zomato fuels the growth of the restaurant industry. By connecting restaurants with a wider audience and providing valuable data insights, Zomato helps them reach new customers, experiment with menus, and optimize their operations. This fosters a thriving culinary ecosystem, benefiting both restaurateurs and diners alike.

Finally, Zomato promotes exploration and cultural exchange. It allows users to delve into diverse cuisines, regional specialties, and hidden gems they might have otherwise missed. This exploration transcends geographical boundaries, connecting people with different cultures through the universal language of food.

In conclusion, Zomato’s significance goes beyond convenience or popularity. It empowers informed choices, fosters convenience, fuels industry growth, and promotes cultural exchange. In a world obsessed with innovation and experience, Zomato has become an essential ingredient in our culinary journey, one delicious bite at a time.

1. Objectives:

Global Reach:

  1. Identify the top 5 countries with the most restaurants on Zomato. This analysis can help Zomato understand its global reach and potential for expansion into new markets.
  2. Compare the average cost for two, price range, and aggregate rating across different countries. This can reveal market differences and inform pricing strategies.
  3. Analyze the distribution of different cuisine types across different countries. This can indicate popular local preferences and potential opportunities for specific cuisines in different regions.

Understanding User Preferences:

  1. Explore the relationship between online delivery availability and features like price range, cuisine type, and city. This can help Zomato identify factors influencing users’ choice of delivery restaurants.
  2. Analyze the top 5 cities with the highest and lowest delivery usage. This can reveal areas with high potential for delivery services and areas where improvement might be needed.

Exploring Restaurant Features:

  1. Investigate the correlation between aggregate rating and features like cuisine type, price range, and online delivery availability. This can help understand factors influencing customer satisfaction.
  2. Categorize and analyze the “Cuisines” column to identify emerging trends and niche markets. This can inform restaurant recommendations and targeted marketing campaigns.
  3. Explore the distribution of restaurant ratings across different cities and countries. This can reveal geographical variations in customer expectations and satisfaction.

2. Data Source Details

For this case study, I collected data from Kaggle, (Click to Link)

3. Data Set details

Restaurant Identification:

  • Restaurant ID: A unique identifier for each restaurant on Zomato.
  • Restaurant Name: The official name of the restaurant.

Location:

  • Country Code: The two-letter ISO code representing the country where the restaurant is located.
  • City: The city where the restaurant is located.
  • Address: The physical address of the restaurant.
  • Locality: The specific neighborhood or area within the city where the restaurant is located.
  • Locality Verbose: A more detailed description of the restaurant’s location, potentially including landmarks or surrounding areas.
  • Longitude: The geographic longitude coordinate of the restaurant.
  • Latitude: The geographic latitude coordinate of the restaurant.

Restaurant Features:

  • Cuisines: A list of the cuisines offered by the restaurant.
  • Average Cost for two: The approximate average cost for two people to dine at the restaurant, including food and drinks.
  • Currency: The currency used for the average cost.
  • Has Table booking: Indicates whether the restaurant offers online table booking through Zomato.
  • Has Online delivery: Indicates whether the restaurant offers online delivery through Zomato.
  • Is delivering now: Indicates whether the restaurant is currently offering online delivery at the time of data collection.
  • Switch to order menu: This is not entirely clear, but it might indicate whether the restaurant allows users to directly access their online menu through Zomato.
  • Price range: A categorical representation of the restaurant’s price range (e.g., budget, moderate, fine dining).

User Ratings and Reviews:

  • Aggregate rating: The average rating given to the restaurant by users on Zomato, typically on a scale of 1 to 5.
  • Rating color: The color associated with the aggregate rating, likely corresponding to different rating ranges (e.g., green for good, red for bad).
  • Rating text: The overall textual rating summary (e.g., “Excellent”, “Average”).
  • Votes: The number of users who have rated the restaurant.

4. EDA (Exploratory Data Analysis):

EDA is the most vital and important part for knowing and analysis the data. If we do not know what is there insight the data, we cant create a model. So we have to 1st know our data.

So for EDA, I have performed various steps, visualization to familiar with the data.

4.1 How the Data looks like :

There are 13 object columns and 8 Numeric columns are there

4.2 Null Checking :

So We can see there is no Null except in Cuisines column, only 9 Null values.

4.3 I’ve combined two datasets to unlock a global perspective on restaurants:

  1. Zomato’s rich restaurant data and
  2. Country Code info for valuable context. This fusion reveals fascinating insights into how cuisine preferences, ratings, delivery trends, and more vary across countries and cultures.​

4.4 Key Insight

Global Reach: Identifies which countries have the most restaurants on Zomato, indicating their popularity and potential market for expansion.

Observation : Zomato maximum records or Transaction are from India After that USA and then United Kingdom

4.5 Here I want to find out all relationship in rating column with respect to different different countries

Observation
  1. When Rating is between 4.5 to 4.9 — — -> Excellent
  2. When Ratings is between 4.0 to 4.4 — → Very Good
  3. When Rating is between 3.5 to 3.9 — — -> Good
  4. When Rating is between 3.0 to 3.4 — — -> Average
  5. When Rating is between 2.5 to 2.9 — — -> Average
  6. When Rating is between 2.0 to 2.4 — — -> Poor

Observation:

  1. Not Rated count is very high
  2. Maximum numbers of ratings are between 2.5 to 3.4

4.6 Unscored and undetected: A look at the countries missing from the map of Zomato

This analysis delves into the intriguing phenomenon of countries with no ratings on Zomato. Based on data, we explore potential reasons behind this, analyze regional trends, and discuss the implications for understanding user behavior on the platform.

Observation : Maximum number of 0 ratings are from Indian customers

4.7 Mapping Zomato’s Global Currency Landscape

4.8 Demystifying Zomato Online Delivery Availability Worldwide

Observation: Online deliveries are available in India and UAE
  • India and UAE are leading the way in online food delivery growth, with Zomato at the forefront.
  • These two countries offer a glimpse into the future of online food delivery, with diverse cuisines and tech-savvy customers.

“Note: Here we can see that some country names are repeated with one value ‘YES’ and also ‘NO’, this is because, if we take a example of India then we will see that there is maximum regions in India where there has Online delivery Option, but some of the regions of India has no option of online delivery.”

4.9 Regional Flavors on Demand: Top 5 Cities Craving Zomato Delivery

Next I have plotted the Pie chart to show the top 5 cities distribution

Pie chart to show top 5 cities distribution

As we can see that the top 5 cities are all from India, as we discussed above about it that India have the most restaurants on Zomato from all over worldwide which is 94.39%

4.10 Global Cravings Revealed: Unmasking the 10 Most Ordered Cuisines on Delivery Apps

Here I have plotted the Pie chart to show the top 10 Cuisines(food)

Dominant Cuisines and Popularity:

  • North Indian cuisine reigns supreme: With a commanding 936 restaurants, it represents nearly 20% of the listed establishments, reflecting a clear preference for familiar and regional flavors.
  • Chinese and Fast Food hold their ground: Both categories occupy roughly 7.5% each, indicating a strong demand for convenience and international options.
  • Combined cuisines show potential: North Indian with Mughlai and Chinese combinations suggest a trend towards restaurants catering to diverse palates and offering broader menus.

Beyond the Big Three:

  • Cafes and bakeries carve their niche: While not dominating, these categories still boast over 4% each, highlighting a dedicated consumer base for casual dining and sweet indulgences.
  • Street food finds its space: The presence of street food, though smaller than major categories, demonstrates the inclusion of diverse and potentially budget-friendly options, catering to wider demographics.

--

--