This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.)