Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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 #364: Career-Minded Barbie

AYXAcademy
Alteryx
Alteryx

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

 

To solve this week’s challenge, use Designer Desktop, Designer Cloud, Designer Experience, or Designer Cloud, Trifacta Classic.

 

Over the years, Barbie, the doll made by Mattel, has had a lot of different jobs! She has been super busy. Did you know she ran for President of the United States 10 times? Quite impressive!

 

This dataset complies a list of Barbies that were released from 1959 through 2020. It includes the career name and type of career for that Barbie.

 

For this challenge, first determine which career Barbie had more than twice between the years 2017 and 2019.

Next, calculate by job type how many different types of jobs Barbie held over the years from 1959 through 2020, including the percentage of each.

 

Data Source: https://data.world/judkacag/barbies-careers-1959-2020 

MilindG
クエーサー
スポイラ
MilindG_0-1679928769518.png

 

Christina_H
マグネター

Nice and easy this week

スポイラ
Christina_H_1-1679928768768.png

 

Flo_P
コメット
スポイラ
Alteryx, It's fantastic!
Flo_P_0-1679928962315.png

 

benjimoser
コメット

My Solution

スポイラ
benjimoser_0-1679929092245.png

 

nSpire
ファイアボール
スポイラ
nSpire_0-1679929240784.pngnSpire_2-1679929284242.png

 


 

PhilipMannering
16 - Nebula
16 - Nebula

Solution Attached.

 

スポイラ
PhilipMannering_0-1679929850728.png

Python Tool...

スポイラ
PhilipMannering_0-1679930640306.png

 

 

gaoa
ボリード
スポイラ
gaoa_0-1679929895719.png 
Clifford_Coon
ボリード

My Solution:

スポイラ
Annotation 2023-03-27 111142.jpg

ggruccio
ACE Emeritus
ACE Emeritus

Solution assumes the NULL years are between 1959 and 2020

 

スポイラ
ggruccio_0-1679930184336.png