Question 18
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 identify the most common words in negative reviews (rating < 3.0), which approach correctly combines filtering and text analysis?
Count all words in all reviews regardless of rating
Filter for low ratings, then extract and count words from the review_text column
Sort reviews by rating and manually read the bottom ones
Use only the rating numbers without looking at text