Yelp_​Project3_​Team9

Visualization 1: Total review count by restaurant category

Operation:

Grouped restaurants by category and aggregated their total review counts. Sorted results from highest to lowest.

Significance / Insight:

This bar chart shows which restaurant categories have the most total reviews, helping identify the most popular food types on Yelp.

Operation2: (NO GRAPH)

Selected the Top 10 restaurant categories ranked by total review count

after sorting them in descending order.

Significance / Insight:

This step identifies the most popular restaurant types on Yelp, helping

reveal which categories receive the highest customer engagement.

sorter: Operation:

Sorted restaurant categories by average star rating in descending order.

Significance / Insight:

This helps identify which types of restaurants receive the highest ratings on Yelp, showing the most appreciated cuisines.

Top K: Operation:

Selected the Top 5 highest-rated restaurant categories.

Significance:

These categories represent the most positively reviewed restaurant types on Yelp.

Operation 3: Count restaurants per category

• Grouped restaurants by categories

• Counted how many restaurants belong to each category

Insight:

This reveals which restaurant types appear most frequently in the dataset.

Visualization 4: Top 10 Most Common Restaurant Categories

Operation:

Counted the number of businesses within each restaurant category, sorted them in descending order, and selected the Top 10 most frequent categories.

Significance / Insight:

This visualization highlights which types of restaurants appear most frequently on Yelp, giving an overview of the dominant cuisine types in the city. It helps identify the most common dining options available to customers.

Operation5：Visualization 5

Filtered the dataset to keep reviews containing positive words like good, great, love, amazing, and delicious.

Grouped the data by business_id and counted how many positive reviews each business got.

Sorted the counts from highest to lowest and kept the top 10.

The bar chart displays which businesses have the most positive feedback.

Insight

The chart shows which businesses customers talk about most positively.

Businesses with more positive reviews are likely doing well in terms of quality or service.

This helps highlight the top places that customers enjoy the most.

Main Question: Which restaurant categories are the most popular and highest rated?