Scribd
Upload
13 views9 pages

Zomato Restaurant Data Analysis

The document contains a Python script that processes and analyzes a dataset from Zomato, including restaurant ratings, votes, and costs. It cleans the data by converting ratings to a numerical format, checks for missing values, and visualizes various aspects of the data using plots and graphs. Key findings include identifying the restaurant with the maximum votes and creating a heatmap to show the relationship between restaurant types and online ordering options.

Uploaded by

baviskarp55
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
13 views9 pages

Zomato Restaurant Data Analysis

The document contains a Python script that processes and analyzes a dataset from Zomato, including restaurant ratings, votes, and costs. It cleans the data by converting ratings to a numerical format, checks for missing values, and visualizes various aspects of the data using plots and graphs. Key findings include identifying the restaurant with the maximum votes and creating a heatmap to show the relationship between restaurant types and online ordering options.

Uploaded by

baviskarp55
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

import pandas as pd

import numpy as np
import [Link] as plt
import seaborn as sns

dataframe = pd.read_csv("/content/[Link]")
print([Link]())

name online_order book_table rate votes \


0 Jalsa Yes Yes 4.1/5 775
1 Spice Elephant Yes No 4.1/5 787
2 San Churro Cafe Yes No 3.8/5 918
3 Addhuri Udupi Bhojana No No 3.7/5 88
4 Grand Village No No 3.8/5 166

approx_cost(for two people) listed_in(type)


0 800 Buffet
1 800 Buffet
2 800 Buffet
3 300 Buffet
4 600 Buffet

def handleRate(value):
value=str(value).split('/')
value=value[0];
return float(value)

dataframe['rate']=dataframe['rate'].apply(handleRate)
print([Link]())

name online_order book_table rate votes \


0 Jalsa Yes Yes 4.1 775
1 Spice Elephant Yes No 4.1 787
2 San Churro Cafe Yes No 3.8 918
3 Addhuri Udupi Bhojana No No 3.7 88
4 Grand Village No No 3.8 166

approx_cost(for two people) listed_in(type)


0 800 Buffet
1 800 Buffet
2 800 Buffet
3 300 Buffet
4 600 Buffet

[Link]()

<class '[Link]'>
RangeIndex: 148 entries, 0 to 147
Data columns (total 7 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 name 148 non-null object
1 online_order 148 non-null object
2 book_table 148 non-null object
3 rate 148 non-null float64
4 votes 148 non-null int64
5 approx_cost(for two people) 148 non-null int64
6 listed_in(type) 148 non-null object
dtypes: float64(1), int64(2), object(4)
memory usage: 8.2+ KB

# Checking for missing/null values in each column


print([Link]().sum())

name 0
online_order 0
book_table 0
rate 0
votes 0
approx_cost(for two people) 0
listed_in(type) 0
dtype: int64

[Link](x=dataframe['listed_in(type)'])
[Link]("Type of restaurant")

Text(0.5, 0, 'Type of restaurant')


grouped_data = [Link]('listed_in(type)')['votes'].sum()
result = [Link]({'votes': grouped_data})
[Link](result, c='green', marker='o')
[Link]('Type of restaurant', c='red', size=20)
[Link]('Votes', c='red', size=20)

Text(0, 0.5, 'Votes')


max_votes = dataframe['votes'].max()
restaurant_with_max_votes = [Link][dataframe['votes'] ==
max_votes, 'name']

print('Restaurant(s) with the maximum votes:')


print(restaurant_with_max_votes)

Restaurant(s) with the maximum votes:


38 Empire Restaurant
Name: name, dtype: object

[Link](x=dataframe['online_order'])

<Axes: xlabel='online_order', ylabel='count'>


[Link](dataframe['rate'],bins=5)
[Link]('Ratings Distribution')
[Link]()
couple_data=dataframe['approx_cost(for two people)']
[Link](x=couple_data)

<Axes: xlabel='approx_cost(for two people)', ylabel='count'>


[Link](figsize = (6,6))
[Link](x = 'online_order', y = 'rate', data = dataframe)

<Axes: xlabel='online_order', ylabel='rate'>


pivot_table = dataframe.pivot_table(index='listed_in(type)',
columns='online_order', aggfunc='size', fill_value=0)
[Link](pivot_table, annot=True, cmap='YlGnBu', fmt='d')
[Link]('Heatmap')
[Link]('Online Order')
[Link]('Listed In (Type)')
[Link]()

You might also like