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 #291: A Winning Halloween Candy Basket

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here."Pumpkins Halloween 2013" by Mod Mischief is licensed under CC BY-SA 2.0"Pumpkins Halloween 2013" by Mod Mischief is licensed under CC BY-SA 2.0

 

Pumpkins abound, and squirrels are happy. It’s that time of the year! Halloween is in just a few days, and you need to get candy for trick-or-treaters.

 

This Halloween dataset contains 85 types of candy. Take a closer look at the columns:
- sugar percentage - The percentile of sugar it falls under within the data set.
- price percentage - The unit price percentile compared to the rest of the set.
- favorite percentage - The overall win percentage according to 269,000 matchups.


Your house is going to be a hit if your candy basket includes the following:
- The 5 candies with the lowest “sugar percentage”. An average trick or treater consumes 7,000 calories worth of candy, so you want to offer some healthy options.
- The 5 candies with the highest “favorite percentage”. Your neighbors know you are a people pleaser!
- The 5 candies with the lowest “price percentage”. The giant tarantula inflatables you bought weren’t cheap, so you need to save some money on the treats.

 

And no peanut or almond candies.
The teal pumpkins at your front door communicate that your candy basked is allergy-friendly. (Did you know that’s a “thing”?)

 

Hint

Make sure to filter out all candies that are not allergy friendly first.

 

Among the 85 types of candy from the dataset, what are the 15 candies to have in your basket?

AkimasaKajitani
15 - Aurora

My solution.

 

Spoiler
AkimasaKajitani_0-1635166697173.png

 

PhilipMannering
14 - Magnetar
14 - Magnetar
Spoiler
PhilipMannering_0-1635166755903.png

 

richardatherton
6 - Meteoroid

A solution to Challenge 291. 

 

Spoiler
challenge_291_richardatherton.PNG
patrick_digan
16 - Nebula
16 - Nebula
Spoiler
patrick_digan_0-1635166819434.png

 

DaisukeTsuchiya
12 - Quasar
Spoiler
キャプチャ.JPG
alexnajm
8 - Asteroid

I did not know there were even "teal" pumpkins, let alone that they help prevent allergic reactions. Very cool!

Spoiler
challenge_291_start_file_Alex Abi-Najm.PNG
JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission.

DeanWest
9 - Comet

Glad this Weekly Challenge was a treat and not a trick🍬

 

Spoiler
challenge_291_solution_DeanWest-snippet.png

 

 

RolandSchubert
15 - Aurora
15 - Aurora
Spoiler
291.jpg

My solution.