Dataset: Zomato Reviews

About this Dataset

Zomato Reviews

You have to perform the following tasks:

Data Cleaning:
- Deleting redundant columns.
- Renaming the columns.
- Dropping duplicates.
- Cleaning individual columns.
- Remove the NaN values from the dataset
- Check for some more Transformations
Data Visualization:
- Restaurants delivering Online or not
- Restaurants allowing table booking or not
- Table booking Rate vs Rate
- Best Location
- Relation between Location and Rating
- Restaurant Type
- Gaussian Rest type and Rating
- Types of Services
- Relation between Type and Rating
- Cost of Restaurant
- No. of restaurants in a Location
- Restaurant type
- Most famous restaurant chains in Bengaluru
Regression Analysis:
- Linear Regression
- Decision Tree Regression
- Random Forest Regression

Tables

Zomato

@kaggle.prepinstaprime_tomato_reviews.zomato

142.26 MB
51717 rows
17 columns


CREATE TABLE zomato (
  "url" VARCHAR,
  "address" VARCHAR,
  "name" VARCHAR,
  "online_order" VARCHAR,
  "book_table" VARCHAR,
  "rate" VARCHAR,
  "votes" BIGINT,
  "phone" VARCHAR,
  "location" VARCHAR,
  "rest_type" VARCHAR,
  "dish_liked" VARCHAR,
  "cuisines" VARCHAR,
  "approx_cost_for_two_people" DOUBLE,
  "reviews_list" VARCHAR,
  "menu_item" VARCHAR,
  "listed_in_type" VARCHAR,
  "listed_in_city" VARCHAR
);