Weekly Challenge
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit Feedback
A solution to last week’s challenge can be found here.
You received a dataset containing information about three top brands of ice cream and gelato: Ben & Jerry's, Häagen-Dazs, and Talenti.
Use the datasets to find out:
1. The average rating for each brand, and which brand is top-rated on average.
2. Which brands create ice cream flavors without the known allergens of "cream" and "peanuts" and the names of these ice cream flavors.
3. What are the best-rated and lowest-rated ice cream flavors for each brand.
Use the Sample tool to select one option for each brand.
Hint:
Rename the brands in the dataset ("bj," "hd," and "talenti") to their full names as mentioned earlier. Also, remember to clean the data. (For example, remove nulls and fix some of the letter characters in the ice cream names and descriptions.)
