Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

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.

SUBMIT YOUR IDEA

Challenge #448: Halloween Candy Survey

AYXAcademy
Alteryx
Alteryx

Banner 3.png

Hello Community Members,

 

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

 

As Halloween approaches, we have a fun and festive challenge submitted by our esteemed user Nathan Purvis (@DataNath).  Thank you, Nathan, for this sweet challenge!

 

With the holiday rush coming, a candy manufacturing company needs your help. Your task is to create a comprehensive final report with graphs that answer two key questions:

  • What are the five most popular Halloween chocolate candies, in order by win percentage?
  • Which candies require the most ingredients? (The ingredient values are chocolate, fruity, caramel, peanutyalmondy, nougat, and crispedricewafer.)

 

The dataset provided is based on a survey of over 250,000 respondents to determine the most popular Halloween candy. To collect the data, a website was created where participants were shown two fun-sized candies and asked to select the one they would prefer to receive. Here are some key details:

  • All binary fields in the dataset are coded as 1 = yes, 0 = no (for example, chocolate = 1 means the candy contains chocolate; pluribus = 0 means it is a single item rather than multiple items in a bag or box).
  • Sugarpercent represents the percentile of sugar content for each candy.
  • Pricepercent indicates the unit price percentile compared to other candies.
  • Winpercent shows the overall win percentage of each candy in all matchups.

 

Can you rise to the challenge and help the candy company prepare for the Halloween frenzy?

 

Need a refresher? Review the following lessons in Academy to gear up:

 

Happy Halloween!

 

Source:

https://www.kaggle.com/datasets/fivethirtyeight/the-ultimate-halloween-candy-power-ranking?resource=...

AkimasaKajitani
17 - Castor
17 - Castor

Happy Halloween!

 

Spoiler
image.png

image.png

 

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached,

 

Spoiler
image.png
mmontgomery
11 - Bolide
11 - Bolide

C448

Spoiler
c448.png
bwilgus
5 - Atom
Spoiler
 
 

image.png

MelGibson
10 - Fireball
Spoiler
448.png

Hub119
11 - Bolide
11 - Bolide

Happy Halloween!

Spoiler
WC448 Picture.png
balajilolla2
9 - Comet
Spoiler
Solution attached

Screenshot 2024-10-28 081618.jpg
lwolfie
11 - Bolide

I always enjoy a fun holiday challenge. 

Shelbey
Alteryx
Alteryx

Happy Halloween! 

 

Workflow:

Spoiler
Screenshot 2024-10-28 083116.png

Report (with a little extra Halloween flare):

Spoiler
Screenshot 2024-10-28 083152.png