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.)