Name: Zomato Restaurants Hyderabad
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Zomato Restaurants Hyderabad

Context

The story behind the data set is to identify the unique food culture and cuisines of Hyderabad. This place has a very balanced segmentation when it comes to food and drinks, both cosmopolitan (Italian, Chinese, North Indian) and heritage (mouth watering and ear burning biryanis).

Content

There are two separate files, while the columns are self explanatory. Below is a brief description:

Restaurant names and Metadata - This could help in clustering the restaurants into segments. Also the data has valuable information around cuisine and costing which can be used in cost vs. benefit analysis
Restaurant reviews - Data could be used for sentiment analysis. Also the metadata of reviewers can be used for identifying the critics in the industry.

Acknowledgements

The data was scraped entirely for educational purposes only. All copyrights for the data is owned by Zomato Media Pvt. Ltd..

Inspiration

Inspiration behind this is to identify how the culture is shifting in outdoor dining and also, what is the sentiment towards particular cuisines, in order to identify the following:

The upcoming trends in outdoor dining and influences
How junta (Indian slang for general public) perceives the newer cuisines vs Hyderabadi cuisine
What are the factors of achieving a good vs bad ratings

Tables

Restaurant Names And Metadata

@kaggle.batjoker_zomato_restaurants_hyderabad.restaurant_names_and_metadata

12.55 kB
105 rows
6 columns

CREATE TABLE restaurant_names_and_metadata (
  "name" VARCHAR,
  "links" VARCHAR,
  "cost" BIGINT,
  "collections" VARCHAR,
  "cuisines" VARCHAR,
  "timings" VARCHAR
);

Restaurant Reviews

@kaggle.batjoker_zomato_restaurants_hyderabad.restaurant_reviews

1.93 MB
10,000 rows
7 columns

CREATE TABLE restaurant_reviews (
  "restaurant" VARCHAR,
  "reviewer" VARCHAR,
  "review" VARCHAR,
  "rating" VARCHAR,
  "metadata" VARCHAR,
  "time" TIMESTAMP,
  "pictures" BIGINT
);