Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
alteryx Community

# 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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

## Challenge #291: A Winning Halloween Candy Basket

Alteryx

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.

- 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?

16 - Nebula

My solution.

Spoiler

16 - Nebula
Spoiler

6 - Meteoroid

A solution to Challenge 291.

Spoiler
17 - Castor
Spoiler

13 - Pulsar
Spoiler
15 - Aurora

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

Spoiler
8 - Asteroid
Spoiler

Here is my submission.

9 - Comet

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

Spoiler

16 - Nebula
Spoiler

My solution.