Zomato

Data Analysis Project

@kaggle.rishikeshkonapure_zomato

Table List

1 table(142.26 MB)

Zomato

@kaggle.rishikeshkonapure_zomato.zomato

142.26 MB
51717 rows
17 columns

url Url	address Address	name Name	online_order Online Order	book_table Book Table	rate Rate	votes Votes	phone Phone	location Location	rest_type Rest Type	dish_liked Dish Liked	cuisines Cuisines	approx_cost_for_two_people Approx Cost(for Two People)	reviews_list Reviews List	menu_item Menu Item	listed_in_type Listed In(type)	listed_in_city Listed In(city)
https://www.zomato.com/bangalore/jalsa-banashankari?context=eyJzZSI6eyJlIjpbNTg2OTQsIjE4Mzc1NDc0IiwiNTkwOTAiLCIxODM4Mjk0NCIsIjE4MjI0Njc2IiwiNTkyODkiLCIxODM3MzM4NiJdLCJ0IjoiUmVzdGF1cmFudHMgaW4gQmFuYXNoYW5rYXJpIHNlcnZpbmcgQnVmZmV0In19	942, 21st Main Road, 2nd Stage, Banashankari, Bangalore	Jalsa	Yes	Yes	4.1/5	775	080 42297555 +91 9743772233	Banashankari	Casual Dining	Pasta, Lunch Buffet, Masala Papad, Paneer Lajawab, Tomato Shorba, Dum Biryani, Sweet Corn Soup	North Indian, Mughlai, Chinese	800	[('Rated 4.0', 'RATED\n A beautiful place to dine in.The interiors take you back to the Mughal era. The lightings are just perfect.We went there on the occasion of Christmas and so they had only limited items available. But the taste and service was not compromised at all.The only complaint is that…	[]	Buffet	Banashankari
https://www.zomato.com/bangalore/spice-elephant-banashankari?context=eyJzZSI6eyJlIjpbIjU4Njk0IiwxODM3NTQ3NCwiNTkwOTAiLCIxODM4Mjk0NCIsIjE4MjI0Njc2IiwiNTkyODkiLCIxODM3MzM4NiJdLCJ0IjoiUmVzdGF1cmFudHMgaW4gQmFuYXNoYW5rYXJpIHNlcnZpbmcgQnVmZmV0In19	2nd Floor, 80 Feet Road, Near Big Bazaar, 6th Block, Kathriguppe, 3rd Stage, Banashankari, Bangalore	Spice Elephant	Yes	No	4.1/5	787	080 41714161	Banashankari	Casual Dining	Momos, Lunch Buffet, Chocolate Nirvana, Thai Green Curry, Paneer Tikka, Dum Biryani, Chicken Biryani	Chinese, North Indian, Thai	800	[('Rated 4.0', 'RATED\n Had been here for dinner with family. Turned out to be a good choose suitable for all ages of people. Can try this place. We liked the most was their starters. Service is good. Prices are affordable. Will recommend this restaurant for early dinner. The place is little noisy.…	[]	Buffet	Banashankari
https://www.zomato.com/SanchurroBangalore?context=eyJzZSI6eyJlIjpbIjU4Njk0IiwiMTgzNzU0NzQiLDU5MDkwLCIxODM4Mjk0NCIsIjE4MjI0Njc2IiwiNTkyODkiLCIxODM3MzM4NiJdLCJ0IjoiUmVzdGF1cmFudHMgaW4gQmFuYXNoYW5rYXJpIHNlcnZpbmcgQnVmZmV0In19	1112, Next to KIMS Medical College, 17th Cross, 2nd Stage, Banashankari, Bangalore	San Churro Cafe	Yes	No	3.8/5	918	+91 9663487993	Banashankari	Cafe, Casual Dining	Churros, Cannelloni, Minestrone Soup, Hot Chocolate, Pink Sauce Pasta, Salsa, Veg Supreme Pizza	Cafe, Mexican, Italian	800	[('Rated 3.0', "RATED\n Ambience is not that good enough and it's not a pocket friendly cafe and the quantity is not that good and desserts are too good enough ??.."), ('Rated 3.0', "RATED\n \nWent there for a quick bite with friends.\nThe ambience had more of corporate feel. I would say it was uni…	[]	Buffet	Banashankari
https://www.zomato.com/bangalore/addhuri-udupi-bhojana-banashankari?context=eyJzZSI6eyJlIjpbIjU4Njk0IiwiMTgzNzU0NzQiLCI1OTA5MCIsMTgzODI5NDQsIjE4MjI0Njc2IiwiNTkyODkiLCIxODM3MzM4NiJdLCJ0IjoiUmVzdGF1cmFudHMgaW4gQmFuYXNoYW5rYXJpIHNlcnZpbmcgQnVmZmV0In19	1st Floor, Annakuteera, 3rd Stage, Banashankari, Bangalore	Addhuri Udupi Bhojana	No	No	3.7/5	88	+91 9620009302	Banashankari	Quick Bites	Masala Dosa	South Indian, North Indian	300	[('Rated 4.0', "RATED\n Great food and proper Karnataka style full meals. Been there twice and was fully satisfied.. Will give 5 stars if it's well managed............"), ('Rated 2.0', 'RATED\n Reached the place at 3pm on Saturday. Half of the items on the menu were over. What was annoying was is …	[]	Buffet	Banashankari
https://www.zomato.com/bangalore/grand-village-basavanagudi?context=eyJzZSI6eyJlIjpbIjU4Njk0IiwiMTgzNzU0NzQiLCI1OTA5MCIsIjE4MzgyOTQ0IiwxODIyNDY3NiwiNTkyODkiLCIxODM3MzM4NiJdLCJ0IjoiUmVzdGF1cmFudHMgaW4gQmFuYXNoYW5rYXJpIHNlcnZpbmcgQnVmZmV0In19	10, 3rd Floor, Lakshmi Associates, Gandhi Bazaar Main Road, Above Reliance Trends, Basavanagudi, Bangalore	Grand Village	No	No	3.8/5	166	+91 8026612447 +91 9901210005	Basavanagudi	Casual Dining	Panipuri, Gol Gappe	North Indian, Rajasthani	600	[('Rated 4.0', 'RATED\n Very good restaurant in neighbourhood. Buffet system is properly arranged. Variety of dishes along with garba dance and puppet show. Good spread of desserts. Live paratha / Kulcha making'), ('Rated 4.0', 'RATED\n Great service, overwhelming experience.\n\nOne of its kind ex…	[]	Buffet	Banashankari
https://www.zomato.com/bangalore/timepass-dinner-basavanagudi?context=eyJzZSI6eyJlIjpbIjE4Mzc1NDc0IiwiNTkwOTAiLCIxODM4Mjk0NCIsIjE4MjI0Njc2Iiw1OTI4OSwiMTgzNzMzODYiXSwidCI6IlJlc3RhdXJhbnRzIGluIEJhbmFzaGFua2FyaSBzZXJ2aW5nIEJ1ZmZldCJ9fQ==	37, 5-1, 4th Floor, Bosco Court, Gandhi Bazaar Main Road, Basavanagudi, Bangalore	Timepass Dinner	Yes	No	3.8/5	286	+91 9980040002 +91 9980063005	Basavanagudi	Casual Dining	Onion Rings, Pasta, Kadhai Paneer, Salads, Salad, Roti, Jeera Rice	North Indian	600	[('Rated 3.0', 'RATED\n Food 3/5\nAmbience 3/5\nService 3/5\n\nHad been here for family lunch. This place serves buffets too. We ordered soups, babycorn starters, butter naan, kadai panner, veg kohlapuri, pease pulav. Food was good. But the service is too slow. They will make you wait for 20 mins t…	[]	Buffet	Banashankari
https://www.zomato.com/bangalore/rosewood-international-hotel-bar-restaurant-mysore-road-bangalore?context=eyJzZSI6eyJlIjpbIjU5MDkwIiwiMTgzODI5NDQiLCIxODIyNDY3NiIsIjU5Mjg5IiwxODM3MzM4Nl0sInQiOiJSZXN0YXVyYW50cyBpbiBCYW5hc2hhbmthcmkgc2VydmluZyBCdWZmZXQifX0=	19/1, New Timberyard Layout, Beside Satellite Bus Stop, Mysore Road, Bangalore	Rosewood International Hotel - Bar & Restaurant	No	No	3.6/5	8	+91 9731716688 080 26740366	Mysore Road	Casual Dining	nan	North Indian, South Indian, Andhra, Chinese	800	[('Rated 5.0', 'RATED\n Awesome food ??Great serviceFriendly staffsGood quality of food\n# Complimentary Breakfast ??\n# Honey Lemon Chicken and Chicken Manchow Soup\nPerfect place too stay alone or with family ????Will stay whenever I will go Bangalore ????'), ('Rated 5.0', 'RATED\n Newly Launche…	[]	Buffet	Banashankari
https://www.zomato.com/bangalore/onesta-banashankari?context=eyJzZSI6eyJlIjpbMTg1NjU2NzksIjE4NTkzMDQ0IiwiMTgxNDg5NDEiLCIxODQ3MDc3MSIsIjE4NzE2MDYxIiwiMTg2MzI5NzciLCIxODIwMjk5NyIsIjU5MDkwIiwiMTg1NTkyMTEiLCIxODMyMzYzOSIsIjE4NTc0Mjc3Il0sInQiOiJDYWZcdTAwZTlzIGFuZCBEZWxpcyBpbiBCYW5hc2hhbmthcmkifX0=	2469, 3rd Floor, 24th Cross, Opposite BDA Complex, 2nd Stage, Banashankari, Bangalore	Onesta	Yes	Yes	4.6/5	2556	080 48653961 080 48655715	Banashankari	Casual Dining, Cafe	Farmhouse Pizza, Chocolate Banana, Virgin Mojito, Pasta, Paneer Tikka, Lime Soda, Prawn Pizza	Pizza, Cafe, Italian	600	[('Rated 5.0', 'RATED\n I personally really liked this place ! The ambience with the rooftop , plants , the music is great !\nThe starters are good and so were the pizzas.\nThe prices are pretty affordable! Must visit place !'), ('Rated 5.0', 'RATED\n Very good pizza... took unlimited pizza and co…	[]	Cafes	Banashankari
https://www.zomato.com/bangalore/penthouse-cafe-banashankari?context=eyJzZSI6eyJlIjpbIjE4NTY1Njc5IiwxODU5MzA0NCwiMTgxNDg5NDEiLCIxODQ3MDc3MSIsIjE4NzE2MDYxIiwiMTg2MzI5NzciLCIxODIwMjk5NyIsIjU5MDkwIiwiMTg1NTkyMTEiLCIxODMyMzYzOSIsIjE4NTc0Mjc3IiwiMTg3MjM0OTQiXSwidCI6IkNhZlx1MDBlOXMgYW5kIERlbGlzIGluIEJhbmF…	1, 30th Main Road, 3rd Stage, Banashankari, Bangalore	Penthouse Cafe	Yes	No	4.0/5	324	+91 8884135549 +91 9449449316	Banashankari	Cafe	Pizza, Mocktails, Coffee, Nachos, Salad, Pasta, Sandwiches	Cafe, Italian, Continental	700	[('Rated 3.0', "RATED\n I had been to this place with one of my friends, it's a very small place but decent. And nice place to hangout.\nFood-3.5/5\nAmbience-4/5\nValue for money 3.5/5"), ('Rated 4.0', "RATED\n Small, cosy, covered rooftop place provides just the right menu for quick bites as well…	[]	Cafes	Banashankari
https://www.zomato.com/bangalore/smacznego-banashankari?context=eyJzZSI6eyJlIjpbIjE4NTY1Njc5IiwiMTg1OTMwNDQiLDE4MTQ4OTQxLCIxODQ3MDc3MSIsIjE4NzE2MDYxIiwiMTg2MzI5NzciLCIxODIwMjk5NyIsIjU5MDkwIiwiMTg1NTkyMTEiLCIxODMyMzYzOSIsIjE4NTc0Mjc3IiwiMTg3MjM0OTQiLCIxODg2NzEyMiJdLCJ0IjoiQ2FmXHUwMGU5cyBhbmQgRGVsaXMg…	2470, 21 Main Road, 25th Cross, Banashankari, Bangalore	Smacznego	Yes	No	4.2/5	504	+91 9945230807 +91 9743804471	Banashankari	Cafe	Waffles, Pasta, Coleslaw Sandwich, Choco Waffle, Tacos, Momos, Cheese Nachos	Cafe, Mexican, Italian, Momos, Beverages	550	[('Rated 4.0', "RATED\n Easy to locate\nVFM 3.5/5\nTaste 5/5\nYummy cheesyyy fries ?\nDelicious pasta\nThey're a must try ??\nLoaded nachos and green fries are average!!"), ('Rated 4.0', 'RATED\n A tuck shop in Banashankari, slightly off the crowded Banashankari bda complex. The menu is interestin…	[]	Cafes	Banashankari


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
);