text_plain_output_1.png
import matplotlib.pyplot as plt

import pandas as pd

import plotly.express as px

df = pd.read_csv('/kaggle/input/indian-restaurants-2023/restaurants.csv')

df.isnull().sum()

df_rating = df.groupby('City')['Rating'].mean().reset_index()
df_rating = df_rating.sort_values('Rating')

average_cost = df.groupby(['City'])['Cost'].mean().reset_index()
fig = px.bar(average_cost, x='City', y='Cost', labels={'City': 'City', 'Name': 'Average Cost of Restaurants'},
             title='Average Cost in Each City', color = 'City')
fig.show()

avg_vote = df.groupby(['City'])['Votes'].mean().reset_index()
fig = px.bar(avg_vote, x='City', y='Votes', labels={'City': 'City', 'Name': 'Average Number of Votes of Restaurants'}, title='Average Votes in Each City', color='City')
fig.show()