Food delivery data analysis
Tadiwanashe J Chitombo and Kudzaishe A Chimbunde
2026-04-11
Introduction
Zomato is a popular online food delivery platform that helps users discover restaurants, explore menus, and order food. This project analyzes Zomato data to understand customer preferences, restaurant performance, and pricing trends. The goal is to identify key insights that can improve decision-making for both customers and businesses in the food industry.
- Load Libraries
library(dplyr) ## Warning: package 'dplyr' was built under R version 4.5.3##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unionlibrary(ggplot2) ## Warning: package 'ggplot2' was built under R version 4.5.3library(readr)
library(tidyr)## Warning: package 'tidyr' was built under R version 4.5.3library(janitor)## Warning: package 'janitor' was built under R version 4.5.3##
## Attaching package: 'janitor'## The following objects are masked from 'package:stats':
##
## chisq.test, fisher.testInterpretation: The library(dplyr), library(tidyr), and library(janitor) commands load packages required for data preprocessing. dplyr is used for data manipulation, tidyr is used for tidying and handling missing values, and janitor is used for cleaning column names and improving dataset structure.
- Load Zomato Dataset
zomato_data <- read.csv("zomato.csv", stringsAsFactors = FALSE)Interpretation: This command loads the Zomato dataset from the CSV file into R and stores it in a data frame named zomato_data, which will be used for further data preprocessing and analysis.
- Data Inspection
head(zomato_data) ## url
## 1 https://www.zomato.com/bangalore/jalsa-banashankari?context=eyJzZSI6eyJlIjpbNTg2OTQsIjE4Mzc1NDc0IiwiNTkwOTAiLCIxODM4Mjk0NCIsIjE4MjI0Njc2IiwiNTkyODkiLCIxODM3MzM4NiJdLCJ0IjoiUmVzdGF1cmFudHMgaW4gQmFuYXNoYW5rYXJpIHNlcnZpbmcgQnVmZmV0In19
## 2 https://www.zomato.com/bangalore/spice-elephant-banashankari?context=eyJzZSI6eyJlIjpbIjU4Njk0IiwxODM3NTQ3NCwiNTkwOTAiLCIxODM4Mjk0NCIsIjE4MjI0Njc2IiwiNTkyODkiLCIxODM3MzM4NiJdLCJ0IjoiUmVzdGF1cmFudHMgaW4gQmFuYXNoYW5rYXJpIHNlcnZpbmcgQnVmZmV0In19
## 3 https://www.zomato.com/SanchurroBangalore?context=eyJzZSI6eyJlIjpbIjU4Njk0IiwiMTgzNzU0NzQiLDU5MDkwLCIxODM4Mjk0NCIsIjE4MjI0Njc2IiwiNTkyODkiLCIxODM3MzM4NiJdLCJ0IjoiUmVzdGF1cmFudHMgaW4gQmFuYXNoYW5rYXJpIHNlcnZpbmcgQnVmZmV0In19
## 4 https://www.zomato.com/bangalore/addhuri-udupi-bhojana-banashankari?context=eyJzZSI6eyJlIjpbIjU4Njk0IiwiMTgzNzU0NzQiLCI1OTA5MCIsMTgzODI5NDQsIjE4MjI0Njc2IiwiNTkyODkiLCIxODM3MzM4NiJdLCJ0IjoiUmVzdGF1cmFudHMgaW4gQmFuYXNoYW5rYXJpIHNlcnZpbmcgQnVmZmV0In19
## 5 https://www.zomato.com/bangalore/grand-village-basavanagudi?context=eyJzZSI6eyJlIjpbIjU4Njk0IiwiMTgzNzU0NzQiLCI1OTA5MCIsIjE4MzgyOTQ0IiwxODIyNDY3NiwiNTkyODkiLCIxODM3MzM4NiJdLCJ0IjoiUmVzdGF1cmFudHMgaW4gQmFuYXNoYW5rYXJpIHNlcnZpbmcgQnVmZmV0In19
## 6 https://www.zomato.com/bangalore/timepass-dinner-basavanagudi?context=eyJzZSI6eyJlIjpbIjE4Mzc1NDc0IiwiNTkwOTAiLCIxODM4Mjk0NCIsIjE4MjI0Njc2Iiw1OTI4OSwiMTgzNzMzODYiXSwidCI6IlJlc3RhdXJhbnRzIGluIEJhbmFzaGFua2FyaSBzZXJ2aW5nIEJ1ZmZldCJ9fQ==
## address
## 1 942, 21st Main Road, 2nd Stage, Banashankari, Bangalore
## 2 2nd Floor, 80 Feet Road, Near Big Bazaar, 6th Block, Kathriguppe, 3rd Stage, Banashankari, Bangalore
## 3 1112, Next to KIMS Medical College, 17th Cross, 2nd Stage, Banashankari, Bangalore
## 4 1st Floor, Annakuteera, 3rd Stage, Banashankari, Bangalore
## 5 10, 3rd Floor, Lakshmi Associates, Gandhi Bazaar Main Road, Above Reliance Trends, Basavanagudi, Bangalore
## 6 37, 5-1, 4th Floor, Bosco Court, Gandhi Bazaar Main Road, Basavanagudi, Bangalore
## name online_order book_table rate votes
## 1 Jalsa Yes Yes 4.1/5 775
## 2 Spice Elephant Yes No 4.1/5 787
## 3 San Churro Cafe Yes No 3.8/5 918
## 4 Addhuri Udupi Bhojana No No 3.7/5 88
## 5 Grand Village No No 3.8/5 166
## 6 Timepass Dinner Yes No 3.8/5 286
## phone location rest_type
## 1 080 42297555\n+91 9743772233 Banashankari Casual Dining
## 2 080 41714161 Banashankari Casual Dining
## 3 +91 9663487993 Banashankari Cafe, Casual Dining
## 4 +91 9620009302 Banashankari Quick Bites
## 5 +91 8026612447\n+91 9901210005 Basavanagudi Casual Dining
## 6 +91 9980040002\n+91 9980063005 Basavanagudi Casual Dining
## dish_liked
## 1 Pasta, Lunch Buffet, Masala Papad, Paneer Lajawab, Tomato Shorba, Dum Biryani, Sweet Corn Soup
## 2 Momos, Lunch Buffet, Chocolate Nirvana, Thai Green Curry, Paneer Tikka, Dum Biryani, Chicken Biryani
## 3 Churros, Cannelloni, Minestrone Soup, Hot Chocolate, Pink Sauce Pasta, Salsa, Veg Supreme Pizza
## 4 Masala Dosa
## 5 Panipuri, Gol Gappe
## 6 Onion Rings, Pasta, Kadhai Paneer, Salads, Salad, Roti, Jeera Rice
## cuisines approx_cost.for.two.people.
## 1 North Indian, Mughlai, Chinese 800
## 2 Chinese, North Indian, Thai 800
## 3 Cafe, Mexican, Italian 800
## 4 South Indian, North Indian 300
## 5 North Indian, Rajasthani 600
## 6 North Indian 600
## reviews_list
## 1 [('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 the breads could have been better.Would surely like to come here again.'), ('Rated 4.0', 'RATED\\n I was here for dinner with my family on a weekday. The restaurant was completely empty. Ambience is good with some good old hindi music. Seating arrangement are good too. We ordered masala papad, panner and baby corn starters, lemon and corrionder soup, butter roti, olive and chilli paratha. Food was fresh and good, service is good too. Good for family hangout.\\nCheers'), ('Rated 2.0', 'RATED\\n Its a restaurant near to Banashankari BDA. Me along with few of my office friends visited to have buffet but unfortunately they only provide veg buffet. On inquiring they said this place is mostly visited by vegetarians. Anyways we ordered ala carte items which took ages to come. Food was ok ok. Definitely not visiting anymore.'), ('Rated 4.0', 'RATED\\n We went here on a weekend and one of us had the buffet while two of us took Ala Carte. Firstly the ambience and service of this place is great! The buffet had a lot of items and the good was good. We had a Pumpkin Halwa intm the dessert which was amazing. Must try! The kulchas are great here. Cheers!'), ('Rated 5.0', 'RATED\\n The best thing about the place is itÃ\u0083\\x83Ã\u0082\\x83Ã\u0083\\x82Ã\u0082\\x82Ã\u0083\\x83Ã\u0082\\x82Ã\u0083\\x82Ã\u0082\\x92s ambiance. Second best thing was yummy ? food. We try buffet and buffet food was not disappointed us.\\nTest ?. ?? ?? ?? ?? ??\\nQuality ?. ??????????.\\nService: Staff was very professional and friendly.\\n\\nOverall experience was excellent.\\n\\nsubirmajumder85.wixsite.com'), ('Rated 5.0', 'RATED\\n Great food and pleasant ambience. Expensive but Coll place to chill and relax......\\n\\nService is really very very good and friendly staff...\\n\\nFood : 5/5\\nService : 5/5\\nAmbience :5/5\\nOverall :5/5'), ('Rated 4.0', 'RATED\\n Good ambience with tasty food.\\nCheese chilli paratha with Bhutta palak methi curry is a good combo.\\nLemon Chicken in the starters is a must try item.\\nEgg fried rice was also quite tasty.\\nIn the mocktails, recommend "Alice in Junoon". Do not miss it.'), ('Rated 4.0', 'RATED\\n You canÃ\u0083\\x83Ã\u0082\\x83Ã\u0083\\x82Ã\u0082\\x82Ã\u0083\\x83Ã\u0082\\x82Ã\u0083\\x82Ã\u0082\\x92t go wrong with Jalsa. Never been a fan of their buffet and thus always order alacarteÃ\u0083\\x83Ã\u0082\\x83Ã\u0083\\x82Ã\u0082\\x82Ã\u0083\\x83Ã\u0082\\x82Ã\u0083\\x82Ã\u0082\\x92. Service at times can be on the slower side but food is worth the wait.'), ('Rated 5.0', 'RATED\\n Overdelighted by the service and food provided at this place. A royal and ethnic atmosphere builds a strong essence of being in India and also the quality and taste of food is truly authentic. I would totally recommend to visit this place once.'), ('Rated 4.0', 'RATED\\n The place is nice and comfortable. Food wise all jalea outlets maintain a good standard. The soya chaap was a standout dish. Clearly one of trademark dish as per me and a must try.\\n\\nThe only concern is the parking. It very congested and limited to just 5cars. The basement parking is very steep and makes it cumbersome'), ('Rated 4.0', 'RATED\\n The place is nice and comfortable. Food wise all jalea outlets maintain a good standard. The soya chaap was a standout dish. Clearly one of trademark dish as per me and a must try.\\n\\nThe only concern is the parking. It very congested and limited to just 5cars. The basement parking is very steep and makes it cumbersome'), ('Rated 4.0', 'RATED\\n The place is nice and comfortable. Food wise all jalea outlets maintain a good standard. The soya chaap was a standout dish. Clearly one of trademark dish as per me and a must try.\\n\\nThe only concern is the parking. It very congested and limited to just 5cars. The basement parking is very steep and makes it cumbersome')]
## 2 [('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.'), ('Rated 3.0', 'RATED\\n The ambience is really nice, staff is courteous. The price is pretty high for the quantity, but overall the experience was fine. The quality of food is nice but nothing extraordinary. They also have buffet(only veg)'), ('Rated 3.0', 'RATED\\n I felt good is little expensive for the quantity they serve and In terms of taste is decent. There is nothing much to talk about the ambience, regular casual dining restaurant where you can take your family for dinner or lunch. If they improve on that quantity or may be reduce the price a bit or may be improve the presentation of the food it might Manage to get more repeat customers.'), ('Rated 4.0', 'RATED\\n I was looking for a quite place to spend some time with family and as well wanted to try some new place. Since I was at Banashankari I thought of trying this place. The place had good rating and was part of Zomato gold. So I decided to try this place. It was a delite to see a very friendly staff and food we ordered was very tasty as well.\\n\\nFood : 4/5\\nAmbience :3/5\\nFriendly staff : 4/5\\nPocket friendly : 4/5\\n\\nWill definitely visit again ??'), ('Rated 4.0', "RATED\\n Nice place to dine and has a good ambiance... Food is good and the serving time is also good..neat restrooms and we'll arranged tables....only thing is we went at 12.30 for lunch...and we noticed that they kept on playing one music back to back which was a little annoying...\\n\\n1. Chicken biriyani was so good and the chicken was fresh and tender ,rice was well cooked and overall was great\\n\\n2. Mutton biriyani was very very good and tasty and It had plenty of mutton pieces..."), ('Rated 5.0', 'RATED\\n This place just cool ? with good ambience and slow music and having delicious food is where you find peace. Staff very friendly and they have maintained the place so clean. The price is average for what the quantity of food they serve.\\nThom yum Thai soup was best and was treat to mouth, roti was soft with that vilaythi paneer was perfect to have for veggie foodies, in rice we tried burnt garlic fried rice with vegetables and it was the perfect thing to end.'), ('Rated 4.0', "RATED\\n Quiet a good family type of place.. too calm and usually we don't find crowd here.. panner curry and the deserts is what we had tasted.. they wer really good but we found it a little expensive"), ('Rated 2.0', "RATED\\n I had a very bad experience here.\\nI don't know about a la carte, but the buffet was the worst. They gave us complementary drink and momos before the buffet. The momos were really good.\\nThe number of varieties first of all was very disappointing. The service was very slow. They refilled the food very slowly. The starters were okay. The main course also was so so. There was two gravies with roti and some rice with raitha. They had chats, sev puri and pan puri, which was average. But the desert was disappointing. They had gulab Jamun and chocolate cake. The jamun was not cooked inside. There was a cold blob of raw dough inside. The chocolate cake also was really hard and not that good.\\nOverall the buffet was a bad experience for me."), ('Rated 4.0', "RATED\\n Food: 8/10\\nAmbience:8/10\\nStaff:8/10\\nOne of the good places to try north Indian food...but depends on ur taste buds. Not everyone will like all the items here. Specially when u r particular abt sweet and spicy food.\\nThere's buffet available too.\\nWe had ordered paneer uttar dakshin and paneer kurchan..was amazing. The Gobi hara pyaz and mix veg were average."), ('Rated 3.0', 'RATED\\n A decent place for a family lunch or dinner.. well arranged in a simple manner. Food was tasty and the crew was very helpful and understanding..'), ('Rated 4.0', "RATED\\n Great place to have a heavy lunch. Good service.\\nThe chicken biryani was undoubtedly one of the best I've had. Biriyani and Lassi would be the suggested combo. Buffet is the talk of the place, so try according to your appetite. A nice place."), ('Rated 4.0', 'RATED\\n Its the one restaurant near katriguppe that i found was really good. Good variety of Chinese and thai dishes. Service is good and good place to hangout with family as its a peaceful place where noise is really less and good view.'), ('Rated 2.0', "RATED\\n Spice elephant soup SPL: almost manchow flavour soup.. Just above medium spicy\\n\\nLasooni fish tikka was awesome\\n\\nI don't remember the dessert name but I have attached the photo .. It had vanilla ice inside wafers... Wafer was hell hard, egg smell chewy ... Nightmare dessert !\\n\\nTable leg space was very bad... I was so uncomfortable, the whole time kept on adjusting my legs\\n\\nNo parking\\n\\nFor the taste felt this is too costly"), ('Rated 4.0', 'RATED\\n Zomato gold partner at this price. It was insane. They have really nice food. small place with very courteous staff and very cheap food for this ambience. Cost of soups is 80-100. Starters from 150-250. Main course 200-300. Cost for two was 800 for us.')]
## 3 [('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 unique.\\nTried nachos, pasta churros and lasagne.\\n\\nNachos were pathetic.( Seriously don't order)\\nPasta was okayish.\\nLasagne was good.\\nNutella churros were the best.\\nOverall an okayish experience!\\nPeace ??"), ('Rated 4.0', "RATED\\n First of all, a big thanks to the staff of this Cafe. Very polite and courteous.\\n\\nI was there 15mins before their closing time. Without any discomfort or hesitation, the staff welcomed me with a warm smile and said they're still open, though they were preparing to close the cafe for the day.\\n\\nQuickly ordered the Thai green curry, which is served with rice. They got it for me within 10mins, hot and freshly made.\\n\\nIt was tasty with the taste of coconut milk. Not very spicy, it was mild spicy.\\n\\nI saw they had yummy looking dessert menu, should go there to try them out!\\n\\nA good spacious place to hang out for coffee, pastas, pizza or Thai food."), ('Rated 3.0', "RATED\\n A place for people who love churos. Otherwise it's a normal simple cafe like any other in town . Can go and spend the evening there . The positive being it is one of the better cafes in and around Banashankari and also the place is not very crowded ."), ('Rated 3.0', 'RATED\\n Have been visiting this place since years. The quality has gone down drastically. Food quality has become very average from good. Service is also very bad of late.'), ('Rated 1.0', 'RATED\\n Really disappointed with the place.\\n\\nSeems like a old dusty store room stacked up with old sofas and chairs! The decor is soo disappointing that I cannot put it in words!\\nLastly the food was cherry on the cake to make it a complete worse meal.\\n\\nThis place is the last option you should ever consider.'), ('Rated 3.0', 'RATED\\n Congested atmosphere due to smoke from kitchen\\nAmbience was k\\nService was k .\\nChuros was a new experience recommended\\nNear to kims . Parking was not der'), ('Rated 1.0', "RATED\\n Cockroaches !! I Repeat cockroaches!!Bakasura was disappointed.\\nBeing in Banashankari, being a gold outlet and nesting them? who can even think of that. Thankfully it wasn't over bakasura's plate. The ambience was last cleaned a decade back i guess. A cockroach just walked over our table. As it was alive, and well moving , the bakasura couldnt take a pic of it. Then the staff had to actually take it out of our table. Such ambience ? like what are you upto?\\n\\nBakasura disapproves. I dont even want to talk about the food."), ('Rated 4.0', 'RATED\\n A nice place to hangout, this place looks professional and also cute. If anyone is trying churros for the first the time, this is the place to go. Cheesecake is pretty amazing too.\\nRecommended.'), ('Rated 4.0', 'RATED\\n 1) pizza mocktails shakes and churros really very good\\n2) staff good\\n3) ambience simple and nice good\\n4) location of San churro cafe very nice\\n5) over San churro cafe good....'), ('Rated 3.0', "RATED\\n One of my favourite places that I often visit in South bangalore , but quality has been reduced than before. Little unhappy with the food this time.\\nBut their churros never dissapointed me. Staff are too slow and do not respond easily.\\n\\nSoups:\\nMinestrone soup was like vegetable stock water with vegetables in it, not happy with it.\\n\\nChurros :\\nIt was great as usual. A must visit place if u love churros.\\n\\nStarters:\\n1. Africano panner -\\nIt was bit sweet and not happy with the dish!!\\n2. Loaded nachos -\\nThis happened to be their one of the best dishes, but now I take back my words. Very dissapointed with the dish.\\n\\nMain course:\\nsicilia pizza\\nPizza was too good, it's a must try dish.\\n\\nFinally I would recommend this place for churros and pizza .\\n\\nTaste : 6/10\\nAmbience :7/10\\nValue for money : 8/10\\n\\nOverall experience : 7.5/10"), ('Rated 4.0', 'RATED\\n Visited this place long before, place come to.notice with the decoration lights outside the cafe. We ordered churos, pizza and hot chocolate, all were good just I little priced more.'), ('Rated 4.0', 'RATED\\n Spain pictures of Churros triggered Nostalgia about it , which led to Google search for Churro places in city , lucky we to get the result as San Churro cafe , we had an delectable churros here along with hot chocolate and Nachos ! Thanks for fulfilling our thirst of Spanish Churros !\\nFood : ???\\nChurros ???\\nHot Chocolate ?\\nNachos ??\\n\\nService : ??\\n\\nAmbiance : ?\\n\\nCleanliness : ??\\n\\nOne drawback : Store had some flies, I hope they take care of them for our next tour ?'), ('Rated 3.0', 'RATED\\n Ã\u0083\\x83Ã\u0082\\x83Ã\u0083\\x82Ã\u0082\\x82Ã\u0083\\x83Ã\u0082\\x82Ã\u0083\\x82Ã\u0082\\x93Chocolaty and churroic experienceÃ\u0083\\x83Ã\u0082\\x83Ã\u0083\\x82Ã\u0082\\x82Ã\u0083\\x83Ã\u0082\\x82Ã\u0083\\x82Ã\u0082\\x94\\n\\nHit chocolate and churro with chocolate dip in the picture.\\n\\nMy first time at this restaurant and it has delivered in service, options as well as taste.'), ('Rated 4.0', 'RATED\\n Though very sadly the place looks in need of retouching, but the food was great! Especially when it was super cold outside and we were super hungry, the staff was nice. We ordered the pink pasta and a pizza. Both of them were pretty good. Was really tempted to try their Churros but we were stuffed. Worth a visit and try for sure!'), ('Rated 3.0', "RATED\\n Churros, the restaurant's eponymous offering, has to be tried. They're a Mexican snack and served with chocolate sauce. Milkshakes are good too. The interior walls have murals and writings all over. Haven't tried the pizzas here but the cakes and pastries were pretty good."), ('Rated 3.0', "RATED\\n Honestly, have only tried parcels and that too only starters and mains - never tried desserts. So this review is based on starters and mains only. The quality wasn't all that great, was pretty average."), ('Rated 4.0', "RATED\\n Visited this place for the first time, recently. The ambience was pretty good. We ordered two 'churros for two'. Having churros for the first time ever, I was way too excited and judgmental. But swear to Lord, the churros were heavenly! The chocolate sauce was the actual chocolate sauce and not nutella xD We had taken the Cross Country Ranch pizza. It was a thin crust pizza loaded with veggies.\\nThe place is famous for churros (the name suggests so). I would love to visit again to try all the other items out :')"), ('Rated 4.0', 'RATED\\n I love the desserts more than anything here !Good place and well served !:)\\nWe dint like the nachos here , it was not that good as we expected !\\nExcept nachos almost all dish were quite good!'), ('Rated 2.0', "RATED\\n 2nd time I have visited this place and I am surprised to see how it has declined. Churros was hard, pizza was pathetic, loaded nachos and masala Garlic bread were topped with cheese with MAYO! Yes mayonnese.. Soup has the bread crumbs in almost melted state, mocktails were average and our only Savior was pasta and caramel pudding... This place has high potential but let down by dull ambience, pretty slow and inattentive staff. Buffet price was listed as 399 but was charged 499, We still went ahead and took the deal to be very disappointed!! Most dishes were freshly cooked hence going with some starts else would rate them lower. I did not find a single person who seemed happy with their meal as moat complained about one thing or the other. That'll be my last visit San Churros.")]
## 4 [('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 the food was cold. The taste was also very average. Only dosa and holige were good. There were very few people in the restaurant and the service was still very slow. The waiters were all standing in one corner and talking. Had to call them repeatedly.'), ('Rated 4.0', 'RATED\\n Had been here, good food served and tasty,good place to go with freinds and family, should be first to get served well with all food. One of the good hotel there for this price.'), ('Rated 2.0', 'RATED\\n How can a Udupi restaurant be so dirty.the floor the walls the waiters are all stained in food.Why cant they clean it? The floor even had decorative colour paper every where and lot of food.Now coming to the taste of the food- it was pretty decent for what they chargw.What upset us was the menu says they serve thambuli, two variety of rice etc but they were all over at 2.45 but they still charged us full amount.Lastly if u r ok to b seated with random people and adjust with their table manners( burrping etc) then tis place is decent for a quick veg udupi meals'), ('Rated 4.0', 'RATED\\n Aadhuri Udupi bhojana is one of the best vegetarian hotel in and around Banashankari locality\\nwere we can enjoy the authentic south Karnataka style food.'), ('Rated 5.0', 'RATED\\n One of the best restaurants for unlimited food. Price for one full unlimited meal is ?150 and the service is awesome here. If youÃ\u0083\\x83Ã\u0082\\x83Ã\u0083\\x82Ã\u0082\\x82Ã\u0083\\x83Ã\u0082\\x82Ã\u0083\\x82Ã\u0082\\x92re a costalian you will love the food served here.'), ('Rated 4.0', "RATED\\n Been here a couple of times. Highly satisfying on both the ocassions. Great food. Decent service. At price of 160 per person it is of a great value. The staff here serves in a traditional Mysore style dresses. The food is authentic Karnataka meals. I really liked the pineapple pickle/chutney. They serve some 4 varities of rice of which you shouldn't try all as you would already be full. Roti, Dosa were decent. In the deserts, Payasam& Holige were good.\\nI think it is one the must try places to try some authentic south food even if you have been to the likes of Kamath etc. this one is a little different. :)"), ('Rated 5.0', 'RATED\\n Very good restorent good south Indian food very nice all food s are good we spent good time and food in this hotel value of money we loved it'), ('Rated 3.5', 'RATED\\n I went to this restaurant on Sunday afternoon.It was a bit crowded.\\n\\nIts located in the 1st floor Above anna kuteera kathriguppe\\n\\nYou need to take food coupon in the ground floor itself.\\nit was 160 rs.\\n\\nTaste wise it was good.\\nService was slow.\\nNothing exciting/different in the menu.\\nWhatever they serve its good.\\nWorth for money.'), ('Rated 5.0', 'RATED\\n Awesome place , worth with price , quality , quantity , service , hygiene and discipline I loved it ???? wish there were more rating stars to give I give 100 on 5 for sure'), ('Rated 3.5', 'RATED\\n Nice food, good ambiance, so many verity of food, this time i was in hurry so, next review will be detailed one. Its good to see all dishes at one place'), ('Rated 1.5', 'RATED\\n The food was not satisfactory. Not one item served could be eaten again . Only advantage is the price but even that is not going to be enough to make me visit the place again . Dear Udupi staff people wouldnÃ\u0083\\x83Ã\u0082\\x83Ã\u0083\\x82Ã\u0082\\x82Ã\u0083\\x83Ã\u0082\\x82Ã\u0083\\x82Ã\u0082\\x92t mind if the food quality was better for a higher price and please get more fans so that people wonÃ\u0083\\x83Ã\u0082\\x83Ã\u0083\\x82Ã\u0082\\x82Ã\u0083\\x83Ã\u0082\\x82Ã\u0083\\x82Ã\u0082\\x92t have to deal with another disappointment of sweating while eating.'), ('Rated 5.0', 'RATED\\n Excellent quality and taste, more variety of authentic south Indian food. Excellent service. Highly recommended. Worth the money we pay here.'), ('Rated 2.0', "RATED\\n I'm rating 2 only because of the large number of items they serve for the price they charge. While the taste is moderate, the biggest turn off is the poor service and totally unresponsive staff. They are either understaffed or poorly trained. I didn't get to taste a few items, thanks to their ever busy staff, and ended eating what was served. Please learn the crowd management from other peers like maiyya and roti ghar"), ('Rated 5.0', 'RATED\\n One of my colleagues suggested this place. Went there at 1 pm and place wasnt crowded. Ambience is decent and cool. A welcome drink "appekai saru" was served. Then started..typical "baale yele uta" . Diffrerent types of palya, kosambari and sides. Then came masala dosa, pulka,pulav, veg rice bath. Masala dosa was very very tasty. Service is bit fast as people will be coming, but they will make it slow if u tell them to. Then comes rice with sambar,rasam, daal,tambali. And yes, dont forget to eat holige,payasam and icecream. Service is very nice. One best thing is all of this comes in just 160 rs and its unlimited!!! What else you want!! A must visit place for south indian foodie!'), ('Rated 3.0', "RATED\\n Been here last week with high expectations based on few reviews. But utterly disappointed with the food quality & taste. I feel it's an overhyped place! There are many better places in the vicinity for Plantain leaf meal. There was too much of waiting & these staffs were too hurry in serving food & asking people to finish meal & leave quickly. I can understand there is a waiting and staffs should approach in a positive way. I will never go there again!\\n\\nbangaloreepicure.com"), ('Rated 4.0', 'RATED\\n I have a confession, being a south Indian I distaste south Indian food(not that I hate it, I don\\'t like it either).But still made up my mind on Sankaranti to have authentic south Indian food visited "Adduri Udupi Bhojana" because it was close to my place.I just had a look at the menu told myself that I can do it(I am not blessed with a tremendous appetite).welcomed with the mango soup followed by the wide variety of dishes served, I have developed the new love for Pongal(both sweet and Khara).I can still feel the taste of the ghee bursting in my mouth but it was"kai holige" that made my day, crisp and soft.not to forget food is served on a banana leaf that adds in more flavor and taste.waiters are attentive and responsive.The customer\\'s needs are monitored and addressed.so much variety for just 160Rs without compromising on quantity and quality and yes it is unlimited.This visit turned out to be a surprise package.'), ('Rated 3.5', 'RATED\\n Food is good.\\nNo parking\\nAmbience is average\\nOverall its value for money if you looking for south Indian food.\\nPreferred the tiffin items......'), ('Rated 3.0', "RATED\\n Been here last week with high expectations based on few reviews. But utterly disappointed with the food quality & taste. I feel it's an overhyped place! There are many better places in the vicinity for Plantain leaf meal. There was too much of waiting & these staffs were too hurry in serving food & asking people to finish meal & leave quickly. I can understand there is a waiting and staffs should approach in a positive way. I will never go there again!\\n\\nbangaloreepicure.com"), ('Rated 4.0', 'RATED\\n I have a confession, being a south Indian I distaste south Indian food(not that I hate it, I don\\'t like it either).But still made up my mind on Sankaranti to have authentic south Indian food visited "Adduri Udupi Bhojana" because it was close to my place.I just had a look at the menu told myself that I can do it(I am not blessed with a tremendous appetite).welcomed with the mango soup followed by the wide variety of dishes served, I have developed the new love for Pongal(both sweet and Khara).I can still feel the taste of the ghee bursting in my mouth but it was"kai holige" that made my day, crisp and soft.not to forget food is served on a banana leaf that adds in more flavor and taste.waiters are attentive and responsive.The customer\\'s needs are monitored and addressed.so much variety for just 160Rs without compromising on quantity and quality and yes it is unlimited.This visit turned out to be a surprise package.'), ('Rated 3.5', 'RATED\\n Food is good.\\nNo parking\\nAmbience is average\\nOverall its value for money if you looking for south Indian food.\\nPreferred the tiffin items......'), ('Rated 3.0', "RATED\\n Been here last week with high expectations based on few reviews. But utterly disappointed with the food quality & taste. I feel it's an overhyped place! There are many better places in the vicinity for Plantain leaf meal. There was too much of waiting & these staffs were too hurry in serving food & asking people to finish meal & leave quickly. I can understand there is a waiting and staffs should approach in a positive way. I will never go there again!\\n\\nbangaloreepicure.com"), ('Rated 4.0', 'RATED\\n I have a confession, being a south Indian I distaste south Indian food(not that I hate it, I don\\'t like it either).But still made up my mind on Sankaranti to have authentic south Indian food visited "Adduri Udupi Bhojana" because it was close to my place.I just had a look at the menu told myself that I can do it(I am not blessed with a tremendous appetite).welcomed with the mango soup followed by the wide variety of dishes served, I have developed the new love for Pongal(both sweet and Khara).I can still feel the taste of the ghee bursting in my mouth but it was"kai holige" that made my day, crisp and soft.not to forget food is served on a banana leaf that adds in more flavor and taste.waiters are attentive and responsive.The customer\\'s needs are monitored and addressed.so much variety for just 160Rs without compromising on quantity and quality and yes it is unlimited.This visit turned out to be a surprise package.'), ('Rated 3.5', 'RATED\\n Food is good.\\nNo parking\\nAmbience is average\\nOverall its value for money if you looking for south Indian food.\\nPreferred the tiffin items......'), ('Rated 3.0', "RATED\\n Been here last week with high expectations based on few reviews. But utterly disappointed with the food quality & taste. I feel it's an overhyped place! There are many better places in the vicinity for Plantain leaf meal. There was too much of waiting & these staffs were too hurry in serving food & asking people to finish meal & leave quickly. I can understand there is a waiting and staffs should approach in a positive way. I will never go there again!\\n\\nbangaloreepicure.com"), ('Rated 4.0', 'RATED\\n I have a confession, being a south Indian I distaste south Indian food(not that I hate it, I don\\'t like it either).But still made up my mind on Sankaranti to have authentic south Indian food visited "Adduri Udupi Bhojana" because it was close to my place.I just had a look at the menu told myself that I can do it(I am not blessed with a tremendous appetite).welcomed with the mango soup followed by the wide variety of dishes served, I have developed the new love for Pongal(both sweet and Khara).I can still feel the taste of the ghee bursting in my mouth but it was"kai holige" that made my day, crisp and soft.not to forget food is served on a banana leaf that adds in more flavor and taste.waiters are attentive and responsive.The customer\\'s needs are monitored and addressed.so much variety for just 160Rs without compromising on quantity and quality and yes it is unlimited.This visit turned out to be a surprise package.'), ('Rated 3.5', 'RATED\\n Food is good.\\nNo parking\\nAmbience is average\\nOverall its value for money if you looking for south Indian food.\\nPreferred the tiffin items......'), ('Rated 3.0', "RATED\\n Been here last week with high expectations based on few reviews. But utterly disappointed with the food quality & taste. I feel it's an overhyped place! There are many better places in the vicinity for Plantain leaf meal. There was too much of waiting & these staffs were too hurry in serving food & asking people to finish meal & leave quickly. I can understand there is a waiting and staffs should approach in a positive way. I will never go there again!\\n\\nbangaloreepicure.com"), ('Rated 4.0', 'RATED\\n I have a confession, being a south Indian I distaste south Indian food(not that I hate it, I don\\'t like it either).But still made up my mind on Sankaranti to have authentic south Indian food visited "Adduri Udupi Bhojana" because it was close to my place.I just had a look at the menu told myself that I can do it(I am not blessed with a tremendous appetite).welcomed with the mango soup followed by the wide variety of dishes served, I have developed the new love for Pongal(both sweet and Khara).I can still feel the taste of the ghee bursting in my mouth but it was"kai holige" that made my day, crisp and soft.not to forget food is served on a banana leaf that adds in more flavor and taste.waiters are attentive and responsive.The customer\\'s needs are monitored and addressed.so much variety for just 160Rs without compromising on quantity and quality and yes it is unlimited.This visit turned out to be a surprise package.'), ('Rated 3.5', 'RATED\\n Food is good.\\nNo parking\\nAmbience is average\\nOverall its value for money if you looking for south Indian food.\\nPreferred the tiffin items......'), ('Rated 4.0', "RATED\\n Had been on a week night for an authentic south Indian food. I personally love being served on banyan leaf. The waiters are all dressed up in traditional Mysore attire wearing with a peta. The food was delicious and definitely worth it's price. The waiters are friendly and serve u well with a smile. The food is prepared without garlic which is a plus point attracting many senior customers."), ('Rated 3.5', "RATED\\n Food is good and enjoyed. With 150 Rs. is very nice.\\nNote: (It happen with us)\\n - If you going TWO people, you may need to share the table there. Its almost crowed.\\n - You have to sit where they ask, you can't choose even if all the table are empty. \\nJust wait, eat and come back."), ('Rated 5.0', 'RATED\\n Excellent Ambience with delicious meals with 10-15 variety types. Worth paying for money and you can dine out if you are with more friends/relatives in home.'), ('Rated 4.5', 'RATED\\n Very good and Unlimited . especially masala dosa . Service and ambience was also good. will visit again with friends . very very reasonble and wholesome food'), ('Rated 3.5', 'RATED\\n Aaaa wt to tell, Unlimited food, food was like exactly like south indian marriage food, 2 soups, sides masala dosa, all were unlimited for just ?150, except ice cream in the end ?? they give a water bottle, and main thing is have patience to get place to sit..... ??,there is no parking place of this outlet, and difficult to park in front of the restaurants,')]
## 5 [('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 experience. Grand village offers you some very desi food options.\\n\\nJaljeera, buttermilk, chat papdi, bhajiya, dosa, pav bhaji, noodles, and so many curries kulcha, roti, and garama garam Jalebies, gulab jamuns.\\n\\nBeautiful ambience of village. People serving with smiles and with full heart !!\\n\\nSo here goes my overall ratings :\\nFood : 4/5\\nAmbience : 3.5/5\\nService : 4/5\\nPocket friendly : 4/5')]
## 6 [('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 to get the order. This place is apt for family hangout.\\n\\nCheers.')]
## menu_item listed_in.type. listed_in.city.
## 1 [] Buffet Banashankari
## 2 [] Buffet Banashankari
## 3 [] Buffet Banashankari
## 4 [] Buffet Banashankari
## 5 [] Buffet Banashankari
## 6 [] Buffet Banashankarisummary(zomato_data) ## url address name online_order
## Length:51717 Length:51717 Length:51717 Length:51717
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## book_table rate votes phone
## Length:51717 Length:51717 Min. : 0.0 Length:51717
## Class :character Class :character 1st Qu.: 7.0 Class :character
## Mode :character Mode :character Median : 41.0 Mode :character
## Mean : 283.7
## 3rd Qu.: 198.0
## Max. :16832.0
## location rest_type dish_liked cuisines
## Length:51717 Length:51717 Length:51717 Length:51717
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## approx_cost.for.two.people. reviews_list menu_item
## Length:51717 Length:51717 Length:51717
## Class :character Class :character Class :character
## Mode :character Mode :character Mode :character
##
##
##
## listed_in.type. listed_in.city.
## Length:51717 Length:51717
## Class :character Class :character
## Mode :character Mode :character
##
##
## nrow(zomato_data)## [1] 51717ncol(zomato_data)## [1] 17str(zomato_data) ## 'data.frame': 51717 obs. of 17 variables:
## $ url : chr "https://www.zomato.com/bangalore/jalsa-banashankari?context=eyJzZSI6eyJlIjpbNTg2OTQsIjE4Mzc1NDc0IiwiNTkwOTAiLCI"| __truncated__ "https://www.zomato.com/bangalore/spice-elephant-banashankari?context=eyJzZSI6eyJlIjpbIjU4Njk0IiwxODM3NTQ3NCwiNT"| __truncated__ "https://www.zomato.com/SanchurroBangalore?context=eyJzZSI6eyJlIjpbIjU4Njk0IiwiMTgzNzU0NzQiLDU5MDkwLCIxODM4Mjk0N"| __truncated__ "https://www.zomato.com/bangalore/addhuri-udupi-bhojana-banashankari?context=eyJzZSI6eyJlIjpbIjU4Njk0IiwiMTgzNzU"| __truncated__ ...
## $ address : chr "942, 21st Main Road, 2nd Stage, Banashankari, Bangalore" "2nd Floor, 80 Feet Road, Near Big Bazaar, 6th Block, Kathriguppe, 3rd Stage, Banashankari, Bangalore" "1112, Next to KIMS Medical College, 17th Cross, 2nd Stage, Banashankari, Bangalore" "1st Floor, Annakuteera, 3rd Stage, Banashankari, Bangalore" ...
## $ name : chr "Jalsa" "Spice Elephant" "San Churro Cafe" "Addhuri Udupi Bhojana" ...
## $ online_order : chr "Yes" "Yes" "Yes" "No" ...
## $ book_table : chr "Yes" "No" "No" "No" ...
## $ rate : chr "4.1/5" "4.1/5" "3.8/5" "3.7/5" ...
## $ votes : int 775 787 918 88 166 286 8 2556 324 504 ...
## $ phone : chr "080 42297555\n+91 9743772233" "080 41714161" "+91 9663487993" "+91 9620009302" ...
## $ location : chr "Banashankari" "Banashankari" "Banashankari" "Banashankari" ...
## $ rest_type : chr "Casual Dining" "Casual Dining" "Cafe, Casual Dining" "Quick Bites" ...
## $ dish_liked : chr "Pasta, Lunch Buffet, Masala Papad, Paneer Lajawab, Tomato Shorba, Dum Biryani, Sweet Corn Soup" "Momos, Lunch Buffet, Chocolate Nirvana, Thai Green Curry, Paneer Tikka, Dum Biryani, Chicken Biryani" "Churros, Cannelloni, Minestrone Soup, Hot Chocolate, Pink Sauce Pasta, Salsa, Veg Supreme Pizza" "Masala Dosa" ...
## $ cuisines : chr "North Indian, Mughlai, Chinese" "Chinese, North Indian, Thai" "Cafe, Mexican, Italian" "South Indian, North Indian" ...
## $ approx_cost.for.two.people.: chr "800" "800" "800" "300" ...
## $ reviews_list : chr "[('Rated 4.0', 'RATED\\n A beautiful place to dine in.The interiors take you back to the Mughal era. The light"| __truncated__ "[('Rated 4.0', 'RATED\\n Had been here for dinner with family. Turned out to be a good choose suitable for all"| __truncated__ "[('Rated 3.0', \"RATED\\n Ambience is not that good enough and it's not a pocket friendly cafe and the quantit"| __truncated__ "[('Rated 4.0', \"RATED\\n Great food and proper Karnataka style full meals. Been there twice and was fully sat"| __truncated__ ...
## $ menu_item : chr "[]" "[]" "[]" "[]" ...
## $ listed_in.type. : chr "Buffet" "Buffet" "Buffet" "Buffet" ...
## $ listed_in.city. : chr "Banashankari" "Banashankari" "Banashankari" "Banashankari" ...Interpretation: These functions were used to inspect the dataset before preprocessing. head() displays the first rows, summary() provides descriptive statistics, nrow() and ncol() show the dataset size, and str() reveals the structure and data types of the variables.
5.1 Cleaning Column Names
zomato_data <- clean_names(zomato_data)
names(zomato_data)## [1] "url" "address"
## [3] "name" "online_order"
## [5] "book_table" "rate"
## [7] "votes" "phone"
## [9] "location" "rest_type"
## [11] "dish_liked" "cuisines"
## [13] "approx_cost_for_two_people" "reviews_list"
## [15] "menu_item" "listed_in_type"
## [17] "listed_in_city"Interpretation: The clean_names() function from the janitor package is used to standardize the column names by converting them to lowercase and replacing spaces with underscores. The names() function is then used to display the updated column names of the dataset.
5.2 Handling Missing Values
colSums(is.na(zomato_data))## url address
## 0 0
## name online_order
## 0 0
## book_table rate
## 0 0
## votes phone
## 0 0
## location rest_type
## 0 0
## dish_liked cuisines
## 0 0
## approx_cost_for_two_people reviews_list
## 0 0
## menu_item listed_in_type
## 0 0
## listed_in_city
## 0zomato_data <- zomato_data %>%
mutate(across(where(is.numeric),
~ ifelse(is.na(.), mean(., na.rm = TRUE), .)))
zomato_data <- zomato_data %>%
mutate(across(where(is.character),
~ ifelse(is.na(.), "Unknown", .)))Interpretation:This step handles missing values in all numeric variables by replacing them with the mean of the respective column. This ensures that missing data does not affect the analysis and improves the quality of the dataset.
zomato_data <- zomato_data %>%
mutate(across(where(is.character),
~ ifelse(is.na(.), "Unknown", .)))Interpretation:This step replaces missing values in all categorical variables with the label “Unknown”. This ensures that missing text data does not affect the analysis and keeps the dataset consistent for further processing.
5.3 Remove Duplicates
zomato_data <- distinct(zomato_data)Interpretation:The distinct() function is used to remove duplicate rows from the dataset so that only unique observations remain. This improves data accuracy and prevents repeated records from affecting the analysis.
5.4 Cleaning rating column
zomato_data$rate <- gsub("/5", "", zomato_data$rate)
zomato_data$rate[zomato_data$rate == "NEW"] <- NA
zomato_data$rate[zomato_data$rate == "-"] <- NA
zomato_data$rate <- as.numeric(zomato_data$rate)5.5 Cleaning Cost Column
zomato_data$approx_cost_for_two_people <- gsub(",", "", zomato_data$approx_cost_for_two_people)
zomato_data$approx_cost_for_two_people <- as.numeric(zomato_data$approx_cost_for_two_people)5.6 Convert Votes
zomato_data$votes <- as.numeric(zomato_data$votes)5.7 Final Check
str(zomato_data)## 'data.frame': 51717 obs. of 17 variables:
## $ url : chr "https://www.zomato.com/bangalore/jalsa-banashankari?context=eyJzZSI6eyJlIjpbNTg2OTQsIjE4Mzc1NDc0IiwiNTkwOTAiLCI"| __truncated__ "https://www.zomato.com/bangalore/spice-elephant-banashankari?context=eyJzZSI6eyJlIjpbIjU4Njk0IiwxODM3NTQ3NCwiNT"| __truncated__ "https://www.zomato.com/SanchurroBangalore?context=eyJzZSI6eyJlIjpbIjU4Njk0IiwiMTgzNzU0NzQiLDU5MDkwLCIxODM4Mjk0N"| __truncated__ "https://www.zomato.com/bangalore/addhuri-udupi-bhojana-banashankari?context=eyJzZSI6eyJlIjpbIjU4Njk0IiwiMTgzNzU"| __truncated__ ...
## $ address : chr "942, 21st Main Road, 2nd Stage, Banashankari, Bangalore" "2nd Floor, 80 Feet Road, Near Big Bazaar, 6th Block, Kathriguppe, 3rd Stage, Banashankari, Bangalore" "1112, Next to KIMS Medical College, 17th Cross, 2nd Stage, Banashankari, Bangalore" "1st Floor, Annakuteera, 3rd Stage, Banashankari, Bangalore" ...
## $ name : chr "Jalsa" "Spice Elephant" "San Churro Cafe" "Addhuri Udupi Bhojana" ...
## $ online_order : chr "Yes" "Yes" "Yes" "No" ...
## $ book_table : chr "Yes" "No" "No" "No" ...
## $ rate : num 4.1 4.1 3.8 3.7 3.8 3.8 3.6 4.6 4 4.2 ...
## $ votes : num 775 787 918 88 166 ...
## $ phone : chr "080 42297555\n+91 9743772233" "080 41714161" "+91 9663487993" "+91 9620009302" ...
## $ location : chr "Banashankari" "Banashankari" "Banashankari" "Banashankari" ...
## $ rest_type : chr "Casual Dining" "Casual Dining" "Cafe, Casual Dining" "Quick Bites" ...
## $ dish_liked : chr "Pasta, Lunch Buffet, Masala Papad, Paneer Lajawab, Tomato Shorba, Dum Biryani, Sweet Corn Soup" "Momos, Lunch Buffet, Chocolate Nirvana, Thai Green Curry, Paneer Tikka, Dum Biryani, Chicken Biryani" "Churros, Cannelloni, Minestrone Soup, Hot Chocolate, Pink Sauce Pasta, Salsa, Veg Supreme Pizza" "Masala Dosa" ...
## $ cuisines : chr "North Indian, Mughlai, Chinese" "Chinese, North Indian, Thai" "Cafe, Mexican, Italian" "South Indian, North Indian" ...
## $ approx_cost_for_two_people: num 800 800 800 300 600 600 800 600 700 550 ...
## $ reviews_list : chr "[('Rated 4.0', 'RATED\\n A beautiful place to dine in.The interiors take you back to the Mughal era. The light"| __truncated__ "[('Rated 4.0', 'RATED\\n Had been here for dinner with family. Turned out to be a good choose suitable for all"| __truncated__ "[('Rated 3.0', \"RATED\\n Ambience is not that good enough and it's not a pocket friendly cafe and the quantit"| __truncated__ "[('Rated 4.0', \"RATED\\n Great food and proper Karnataka style full meals. Been there twice and was fully sat"| __truncated__ ...
## $ menu_item : chr "[]" "[]" "[]" "[]" ...
## $ listed_in_type : chr "Buffet" "Buffet" "Buffet" "Buffet" ...
## $ listed_in_city : chr "Banashankari" "Banashankari" "Banashankari" "Banashankari" ...summary(zomato_data)## url address name online_order
## Length:51717 Length:51717 Length:51717 Length:51717
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
##
## book_table rate votes phone
## Length:51717 Min. :1.8 Min. : 0.0 Length:51717
## Class :character 1st Qu.:3.4 1st Qu.: 7.0 Class :character
## Mode :character Median :3.7 Median : 41.0 Mode :character
## Mean :3.7 Mean : 283.7
## 3rd Qu.:4.0 3rd Qu.: 198.0
## Max. :4.9 Max. :16832.0
## NA's :10052
## location rest_type dish_liked cuisines
## Length:51717 Length:51717 Length:51717 Length:51717
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
##
## approx_cost_for_two_people reviews_list menu_item
## Min. : 40.0 Length:51717 Length:51717
## 1st Qu.: 300.0 Class :character Class :character
## Median : 400.0 Mode :character Mode :character
## Mean : 555.4
## 3rd Qu.: 650.0
## Max. :6000.0
## NA's :346
## listed_in_type listed_in_city
## Length:51717 Length:51717
## Class :character Class :character
## Mode :character Mode :character
##
##
##
## Interpretation:The str() function is used to examine the structure of the dataset and verify the data types of variables, while the summary() function provides descriptive statistics that help understand the distribution and key characteristics of the data.
- Exploratory Data Analysis
6.1 Top 15 Restaurant Location
zomato_data %>%
count(location, sort = TRUE) %>%
slice_head(n = 15) %>%
ggplot(aes(x = reorder(location, n), y = n)) +
geom_col(fill = "steelblue") +
coord_flip() +
labs(
title = "Top 15 Restaurant Locations",
x = "Location",
y = "Number of Restaurants"
)
Interpretation: The chart shows the top locations with the highest number of restaurants. A few locations have significantly more restaurants than others, indicating areas with higher restaurant density and stronger food delivery activity.
6.2 Online Order Availability
ggplot(zomato_data, aes(x = online_order)) +
geom_bar(fill = "darkgreen") +
geom_text(stat = "count", aes(label = ..count..), vjust = -0.5) +
labs(
title = "Availability of Online Ordering",
x = "Online Order Available",
y = "Number of Restaurants"
) ## Warning: The dot-dot notation (`..count..`) was deprecated in ggplot2 3.4.0.
## ℹ Please use `after_stat(count)` instead.
## This warning is displayed once per session.
## Call `lifecycle::last_lifecycle_warnings()` to see where this warning was
## generated.
Interpretation: The bar chart shows the distribution of restaurants based on online ordering availability. Restaurants that support online ordering appear more frequently than those that do not, indicating that online ordering is widely adopted among restaurants in the dataset.
6.3 Table Booking Availability
ggplot(zomato_data, aes(x = book_table)) +
geom_bar(fill = "purple") +
labs(title = "Table Booking Availability")
Interpretation: The bar chart illustrates the availability of table booking among restaurants. The results show that a larger number of restaurants do not provide table booking services compared to those that do, indicating that table reservations are less commonly offered.
6.4 Ratings Distribution
ggplot(zomato_data, aes(x = rate)) +
geom_histogram(binwidth = 0.5, fill = "orange", color = "black") +
labs(
title = "Distribution of Restaurant Ratings",
x = "Rating",
y = "Number of Restaurants"
)## Warning: Removed 10052 rows containing non-finite outside the scale range
## (`stat_bin()`).
Interpretaion: The histogram shows the distribution of restaurant ratings. Most restaurants have ratings concentrated around the middle to higher range, indicating that the majority of restaurants in the dataset receive moderate to good customer feedback.
6.5 Cost Distribution
ggplot(zomato_data, aes(x = approx_cost_for_two_people)) +
geom_histogram(binwidth = 100, fill = "red", color = "black") +
labs(
title = "Distribution of Approximate Cost for Two People",
x = "Approximate Cost for Two People",
y = "Number of Restaurants"
)## Warning: Removed 346 rows containing non-finite outside the scale range
## (`stat_bin()`).
Interpretation:The histogram shows the distribution of the approximate cost for two people across restaurants. Most restaurants fall within the lower to mid-price range, while fewer restaurants have very high costs. This indicates that the majority of restaurants are moderately priced and affordable for customers.
6.6 Votes vs Rating
ggplot(zomato_data, aes(x = votes, y = rate)) +
geom_point(alpha = 0.5) +
geom_smooth(method = "lm", color = "blue", se = TRUE) +
labs(
title = "Relationship Between Votes and Restaurant Rating",
x = "Number of Votes",
y = "Rating"
)## `geom_smooth()` using formula = 'y ~ x'## Warning: Removed 10052 rows containing non-finite outside the scale range
## (`stat_smooth()`).## Warning: Removed 10052 rows containing missing values or values outside the scale range
## (`geom_point()`).
Interpretation: The scatter plot shows the relationship between the number of votes and restaurant ratings. The regression line suggests that restaurants with more votes tend to have slightly higher ratings, indicating that popular restaurants often receive better customer feedback.
6.7 Top 10 Cuisines
zomato_data %>%
count(cuisines, sort = TRUE) %>%
slice_head(n = 10) %>%
ggplot(aes(x = reorder(cuisines, n), y = n)) +
geom_col(fill = "brown") +
coord_flip() +
labs(
title = "Top 10 Most Popular Cuisines",
x = "Cuisine Type",
y = "Number of Restaurants"
)
interpretation: The bar chart shows the most popular cuisines available in the dataset. A few cuisine types dominate the restaurant distribution, indicating higher demand and popularity among customers.
6.8 Restaurant Types
library(dplyr)
library(ggplot2)
zomato_data %>%
count(rest_type, sort = TRUE) %>%
slice_head(n = 10) %>%
ggplot(aes(x = reorder(rest_type, n), y = n)) +
geom_col(fill = "cyan") +
coord_flip() +
labs(
title = " Restaurant Types",
x = "Restaurant Type",
y = "Number of Restaurants"
)
interpretation:The chart shows the most common restaurant types in the dataset. A few restaurant categories appear far more frequently than others, indicating that certain dining formats dominate the food delivery market.
5.9 Rating vs. Online Order
ggplot(zomato_data, aes(x = online_order, y = rate, fill = online_order)) +
geom_boxplot() +
labs(title = "Does Online Ordering Affect Ratings?", y = "Rating")## Warning: Removed 10052 rows containing non-finite outside the scale range
## (`stat_boxplot()`).
Interpretation: This boxplot tests if restaurants offering online delivery have higher customer satisfaction than those that don’t.
6.10 Cost vs. Table Booking
ggplot(zomato_data,
aes(x = book_table,
y = approx_cost_for_two_people,
fill = book_table)) +
geom_boxplot(alpha = 0.7) +
labs(
title = "Cost Difference: Table Booking vs No Booking",
x = "Table Booking Availability",
y = "Approximate Cost for Two People"
) +
theme_minimal() +
theme(legend.position = "none")## Warning: Removed 346 rows containing non-finite outside the scale range
## (`stat_boxplot()`).
Interpretation:The boxplot compares the approximate cost for two people between restaurants that offer table booking and those that do not. Restaurants with table booking tend to have a higher median cost and a wider cost distribution, suggesting that table reservations are more common in mid-range to premium restaurants.
6.11 What are the top locations with the highest average restaurant ratings?
zomato_data %>%
group_by(location) %>%
summarise(avg_rating = mean(rate, na.rm = TRUE)) %>%
arrange(desc(avg_rating)) %>%
slice_head(n = 10) %>%
ggplot(aes(x = reorder(location, avg_rating), y = avg_rating)) +
geom_col(fill = "steelblue") +
coord_flip() +
labs(
title = "Top 10 Locations by Average Rating",
x = "Location",
y = "Average Rating"
)
interpretation:The chart shows the locations with the highest average restaurant ratings. These areas may have better-quality restaurants or stronger customer satisfaction.
6.12 Which cuisines receive the highest number of votes?
zomato_data %>%
group_by(cuisines) %>%
summarise(total_votes = sum(votes, na.rm = TRUE)) %>%
arrange(desc(total_votes)) %>%
slice_head(n = 10) %>%
ggplot(aes(x = reorder(cuisines, total_votes), y = total_votes)) +
geom_col(fill = "brown") +
coord_flip() +
labs(
title = "Top 10 Cuisines by Total Votes",
x = "Cuisine",
y = "Total Votes"
)
interepretation: This visualization highlights the top 10 most popular cuisines based on total customer votes. The cuisine with the longest bar represents the highest customer engagement/feedback, meaning it is the most appreciated or frequently reviewed cuisine in the dataset.
6.13 Do restaurants with online ordering receive more votes?
ggplot(zomato_data, aes(x = online_order, y = votes, fill = online_order)) +
geom_boxplot() +
labs(
title = "Votes Distribution by Online Order Availability",
x = "Online Order",
y = "Votes"
)
interpretation:The boxplot compares the distribution of customer votes for restaurants that offer online ordering and those that do not. Restaurants with online ordering tend to have a higher number of votes and greater variability, suggesting that online ordering increases customer engagement and popularity.
6.14 What is the relationship between cost and rating?
ggplot(zomato_data,
aes(x = approx_cost_for_two_people, y = rate)) +
geom_point(alpha = 0.4) +
geom_smooth(method = "lm", color = "red") +
labs(
title = "Cost vs Restaurant Rating",
x = "Approximate Cost for Two",
y = "Rating"
)## `geom_smooth()` using formula = 'y ~ x'## Warning: Removed 10299 rows containing non-finite outside the scale range
## (`stat_smooth()`).## Warning: Removed 10299 rows containing missing values or values outside the scale range
## (`geom_point()`).
Interpreatation:The scatter plot illustrates the relationship between the approximate cost for two people and restaurant ratings. The regression line indicates whether there is a positive or negative trend between price and rating. In many cases, ratings do not increase significantly with cost, suggesting that higher-priced restaurants do not always guarantee better customer satisfaction.
6.15 Which restaurant types have the highest average cost?
zomato_data %>%
group_by(rest_type) %>%
summarise(avg_cost = mean(approx_cost_for_two_people, na.rm = TRUE)) %>%
arrange(desc(avg_cost)) %>%
slice_head(n = 10) %>%
ggplot(aes(x = reorder(rest_type, avg_cost), y = avg_cost)) +
geom_col(fill = "blue") +
coord_flip() +
labs(
title = "Restaurant Types with Highest Average Cost",
x = "Restaurant Type",
y = "Average Cost for Two"
)
Interpretation:he visualization shows the restaurant types with the highest average cost for two people. Certain restaurant types have significantly higher prices compared to others, indicating premium dining experiences. These restaurant categories likely offer specialized menus, fine dining environments, or higher service quality.
6.16 How do ratings vary across 5 frequent restaurant types?
top5_types <- zomato_data %>%
filter(!is.na(rest_type), !is.na(rate)) %>%
count(rest_type, sort = TRUE) %>%
slice_head(n = 5)
zomato_data %>%
filter(!is.na(rest_type), !is.na(rate)) %>%
semi_join(top5_types, by = "rest_type") %>%
ggplot(aes(x = reorder(rest_type, rate, FUN = median), y = rate)) +
geom_boxplot(fill = "orange", alpha = 0.7, outlier.color = "red") +
coord_flip() +
labs(
title = "Rating Distribution Across Top 5 Frequent Restaurant Types",
subtitle = "Comparison based on median ratings and spread",
x = "Restaurant Type",
y = "Rating"
)
Interpretation:The ratings across the top 5 most frequent restaurant types show variation in both median values and spread. Some restaurant types consistently achieve higher median ratings, indicating better customer satisfaction, while others show wider variability, suggesting inconsistent service quality across outlets.
6.17 Which locations have the highest total votes?
zomato_data %>%
group_by(location) %>%
summarise(total_votes = sum(votes, na.rm = TRUE)) %>%
arrange(desc(total_votes)) %>%
slice_head(n = 10) %>%
ggplot(aes(x = reorder(location, total_votes), y = total_votes)) +
geom_col(fill = "purple") +
coord_flip() +
labs(
title = "Top Locations by Total Votes",
x = "Location",
y = "Total Votes"
)
Interpretation: Locations with the highest votes represent areas where restaurants receive the most customer engagement and popularity.
` 6. Conclusion The analysis of the Zomato dataset reveals that the Bangalore market is dominated by budget-friendly Quick Bites with a strong preference for online ordering. Restaurants with higher engagement (votes) tend to maintain better ratings, and there is a clear price premium associated with establishments that offer table reservations. These insights can help Zomato optimize their recommendation engines and help new partners choose the right location and pricing strategy.