Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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 #205: Taynalysis

JamesCameron
8 - Asteroid
‎03-03-2020 02:12 AM

Here's my solution. I'm seeing the issues with numbers not quite agreeing too

 

Spoiler
Also had a discrepancy with should've in the top 10 lyrics, I've manually fixed that

JamesCameron_0-1583230260063.png

 

challenge_205_solution.yxmd
Reply
paulburrows
8 - Asteroid
‎03-03-2020 03:11 AM

I think my solution was a little round the houses, but enjoyed this one!

challenge_205_start_fileDone.yxmd
Reply
0 Likes
JennyMartin
9 - Comet
‎03-03-2020 04:22 AM
Spoiler
AWC205.PNG

Fun challenge but also had issues with the numbers for the unique/duplicate lines. See my video solution here: https://www.youtube.com/watch?v=zNDcDmTsT4c

 

 

AWC205.yxmd
Alteryx Weekly Challenge 205: Analysing Taylor Swift Lyrics
Alteryx Weekly Challenge 205: Analysing Taylor Swift Lyrics
youtube.com/watch?v=zNDcDmTsT4c
This week's challenge is certainly a fun one! We're using lots of summarise tools to help us to analyse some Taylor Swift songs. I'll build it in live time so hopefully you can see my thought process more clearly. Find the challenge here: ...
Reply
Amin
8 - Asteroid
‎03-03-2020 05:45 AM
Spoiler
205_Amin.PNG

Fun exercise! But couldn't match the repetitiveness of the lines index..

challenge_205_Amin.yxmd
Reply
0 Likes
HCowley
6 - Meteoroid
‎03-03-2020 06:13 AM

My attempt

challenge_205_start_file.yxmd
Reply
0 Likes
pasccout
8 - Asteroid
‎03-03-2020 10:29 AM

Here is my solution.  I was wondering why I was getting discrepencies... seems the others more or less have the same issues...

 

I'll check later on to see what I did wrong...

challenge_205_my_solution.yxmd
Reply
0 Likes
CarrieChen
5 - Atom
‎03-03-2020 11:11 AM

I got small variance too. My suspect is that I clean the data before calculating the unique and non-unique lyrics.  

Reply
0 Likes
kylemhabe
8 - Asteroid
‎03-03-2020 12:18 PM
Spoiler
kylemhabe_0-1583266663265.png

 

challenge_205_start_file.yxmd
Reply
0 Likes
RobertW
Alteryx
Alteryx
‎03-03-2020 01:19 PM

Spoiler

 

RobertW_1-1583270156827.png

 

 

challenge_205_start_file.yxmd
Reply
0 Likes
nitinsnow
Alteryx Alumni (Retired)
‎03-03-2020 09:39 PM
Spoiler
SpoilerCapture.PNG
challenge_205_Solution.yxmd
Reply
0 Likes