Name: Zomato Restaurants In Metropolitan Areas Of India
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Zomato Restaurants In Metropolitan Areas Of India

About the Dataset

Zomato Scraped Data

The dataset contains information on restaurants in Metropolitan Areas as listed on Zomato.

What are the columns in the dataset?

1. Restaurant_Name- Holds the name of the Restaurant
2. Category - Type of Food the restaurant/cafe is serving.
3. Pricing_for_2 - The price of ordering/dine-in for 2 people (As per Zomato)
4. Locality - The locality/street where the restaurant is situated.

5. Dining_Rating - The average rating for the restaurant given by people who dine-in
6. Dining_Review_Count - Count of Dining_Ratings given.
7. Delivery_Rating - The average rating is given by people who order food online from the restaurant (if applicable)
8. Delivery_Rating_ Count - Count of Delivery Ratings given.

9. Website - The Zomato's URL for that particular restaurant
10. Address - Street Address for the restaurant.
11. Phn_no - Restaurant's Phone Number as listed on Zomato.
12. Latitude - Geographic Latitude coordinates for the restaurant.
13. Longitude - Geographic Longitude coordinates for the restaurant.

14. Known_For1 - What Restaurant is Famous for? (Ambience / Food) (Column 1)
15. Known_For2 - What Restaurant is Famous for? (Ambience / Food) (Column 2)

Tables

Bangalore Restaurants

@kaggle.aestheteaman01_zomato_restaurant_caf_dataset_pune_bangalore.bangalore_restaurants

544.26 kB
5,109 rows
13 columns

CREATE TABLE bangalore_restaurants (
  "restaurant_name" VARCHAR,
  "category" VARCHAR,
  "pricing_for_2" BIGINT,
  "locality" VARCHAR,
  "dining_rating" DOUBLE,
  "dining_review_count" DOUBLE,
  "delivery_rating" DOUBLE,
  "delivery_rating_count" DOUBLE,
  "website" VARCHAR,
  "address" VARCHAR,
  "phone_no" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Pune Restaurants

@kaggle.aestheteaman01_zomato_restaurant_caf_dataset_pune_bangalore.pune_restaurants

612.44 kB
4,797 rows
15 columns

CREATE TABLE pune_restaurants (
  "restaurant_name" VARCHAR,
  "category" VARCHAR,
  "pricing_for_2" BIGINT,
  "locality" VARCHAR,
  "dining_rating" DOUBLE,
  "dining_review_count" BIGINT,
  "delivery_rating" DOUBLE,
  "delivery_rating_count" BIGINT,
  "website" VARCHAR,
  "address" VARCHAR,
  "phone_no" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "known_for1" VARCHAR,
  "known_for2" VARCHAR
);