We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

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

Challenge #332: The more ice cream, the better!

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here.image_332.png

 

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

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
332.png
binuacs
17 - Castor
Spoiler
binuacs_0-1660570050252.png

 


 

MilindG
11 - Bolide
Spoiler
MilindG_0-1660570740816.png

 

Kenda
15 - Aurora
15 - Aurora
Spoiler
Kenda_0-1660570908530.png

 

AkimasaKajitani
15 - Aurora
15 - Aurora

My solution!

 

I want to eat ice creams...

Spoiler
AkimasaKajitani_0-1660571152276.png

 

ahsanaali
8 - Asteroid

 

Spoiler
Spoiler
ahsanaali_0-1660571878239.png
MichaelStaig
7 - Meteor
Spoiler
MichaelStaig_0-1660574553401.png 

A quick enjoyable one :) 

vnicoletgregoire
8 - Asteroid
Spoiler
vnicoletgregoire_0-1660575169618.png

 

TurboToad
8 - Asteroid

My solution, great data set!🍦

 

Spoiler
TurboToad_0-1660576633146.png