A solution to last week’s challenge can be found here.
Are you ready to explore a cheesy dataset?
This dataset provides information about the 2021 World Cheese Awards.
Your challenge is to:
- Find the category of cheese that has the highest average rating per category. Your answer must include the category number, the average rating, and the category name.
- Find all the companies that have a perfect rating of 4 in the category they entered. Your answer must include the company name, the average rating , and the count.
Hints:
You need to create a new rating system column based on the following:
SUPER GOLD = 4
GOLD = 3
SLIVER = 2
BRONZE = 1
In addition, create 2 new columns, category number and category name, using information from the category column.
