Zomato Bangalore Data (Clean)

The original Zomato dataset, but cleaned. Yes, no redundancies.

@kaggle.saranimje_zomato_data_clean

Table List

11 tables(2.15 MB)

Bengaluru House Data

Cuisine Location Rate

Poi

Zomato Test

@kaggle.saranimje_zomato_data_clean.zomato_test

293.95 KB
4189 rows
17 columns

index Index	name Name	address Address	location Location	listed_type Listed Type	votes Votes	num_rate Num Rate	online_order Online Order	book_table Book Table	cuisines Cuisines	rest_type Rest Type	cost Cost	bool_online_order Bool Online Order	prediction Prediction	predictions Predictions	predictions_tuned Predictions Tuned
10	Nellore Dosa Camp	931, 2nd Stage, 4th Cross Road, BTM	BTM	Dine-out	5	3.3	No	No	Andhra, South Indian	Quick Bites	70		1.831997236	0.233022944	1.460335833
12	Dtink Lab	32, 6th Cross Dwarakanagar, PESIT College, Ring Road Hosakerehalli, Banashankari, Bangalore	Banashankari	Dine-out			No	No	Beverages, Sandwich	Quick Bites	80		1.831997236	1.275515634	1.599866454
14	Lassi Shop	24th Main, JP Nagar, Bangalore	JP Nagar	Delivery			Yes	No	Ice Cream, Beverages	Dessert Parlor	80	1	2.912651699	2.070429509	2.779130203
17	Kulhad Junction	135, Sathyamma Layout, Kudlu, Electronic City, Bangalore	Electronic City	Cafes			No	No	Cafe	Cafe	100		1.510456432	1.562761905	1.990373224
25	Mumbai Badam Milk & Lassi Center	11/3, Old Market Road, V V Puram, Basavanagudi, Bangalore	Basavanagudi	Desserts	23	3.6	Yes	No	Beverages, Desserts	Kiosk	100	1	2.912651699	3.562962137	3.204034742
26	South Cool Point	Near Metro Station R.v.Road, Basavanagudi, Bangalore	Basavanagudi	Desserts			Yes	No	Beverages	Dessert Parlor	100	1	2.912651699	3.562962137	3.204034742
41	Mumbai Kulfi	13th Cross, Neeladri Nagar Main Road, Opposite Ajmera Infinity, Phase 1, Electronic City, Bangalore	Electronic City	Desserts	61	3.7	Yes	No	Ice Cream, Desserts	Dessert Parlor	100	1	2.912651699	2.986283333	2.787722033
54	Omm Sweets & Snacks	86, 17th B Main, HAL 2nd Stage, Indiranagar, Bangalore	Indiranagar	Desserts			Yes	No	Mithai, Street Food	Sweet Shop	100	1	2.912651699	3.248588095	2.962696496
56	Indira Sweets	Opposite Veeranjinaya Swamy Temple, BEML Main Road, New Thippasandra Main Road, Thippasandra, Bangalore	Thippasandra	Desserts			No	No	Street Food, Mithai	Kiosk	100		2.0625	3.290616667	2.095392474
61	Shree Mahalakshmi Sweets	120, Kalidas Road, Peace Layout, Kacharakanahalli, Kammanahalli, Bangalore	Kammanahalli	Desserts			Yes	No	Mithai, Street Food	Sweet Shop	100	1	2.912651699	3.167956349	2.820133507


CREATE TABLE zomato_test (
  "index" BIGINT,
  "name" VARCHAR,
  "address" VARCHAR,
  "location" VARCHAR,
  "listed_type" VARCHAR,
  "votes" BIGINT,
  "num_rate" DOUBLE,
  "online_order" VARCHAR,
  "book_table" VARCHAR,
  "cuisines" VARCHAR,
  "rest_type" VARCHAR,
  "cost" DOUBLE,
  "bool_online_order" BIGINT,
  "bool_book_table" BIGINT,
  "prediction" DOUBLE,
  "predictions" DOUBLE,
  "predictions_tuned" DOUBLE
);