Question 21
Scenario 1: Restaurant Review Data Analysis
Context
A food delivery platform wants to analyze restaurant reviews to identify trending cuisines and customer satisfaction patterns. They have review data in CSV format with ratings, text comments, and timestamps.
Sample Data (restaurants.csv):
Based on the above data, answer the given subquestions.
To find the average rating for each cuisine type (Indian, Italian, Japanese), which pandas operation is most appropriate?
df.sort_values('cuisine')
df.groupby('cuisine')['rating'].mean()
df.filter('cuisine')
df.merge('cuisine', 'rating')