Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
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.

Challenge #205: Taynalysis

Highlighted
Alteryx
Alteryx

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

 

Taynalysis: Analyzing Taylor Swift Lyrics

 

Whether you love her or hate her, Taylor Swift is one of the most popular musicians and songwriters of our time and her lyrics have been the source of both criticism and praise.
Her lyrics have also been the subject of a wide spectrum of analyses. Get in on the taynalysis by finding the top 10 words she uses in each album and then find out if her transformation from being a country singer to a pop star has affected the repetiveness of her albums.

 

Can't get enough of Taylor's lyrics? Take this Weekly Challenge up a notch by adding your own levels of analysis and reporting.

Check out these analyses for some swifspiration:
Text Analysis and Data Visualiztion with Taylor Swift Songs
Using Machine Learning to Analyze Taylor Swift's Lyrics

How Has Taylor Swift's Word Choice Changed Over Time?


giphy

 

 

 

 

 

 

 

 

 

 

 

 

*Note: As of 3-3-20 we uploaded a new start file. We realized the way we handled some grouping options and contractions created the discrepancy some people were experiencing.
Highlighted
14 - Magnetar
14 - Magnetar

I think the wrong start file might've been uploaded... 

Highlighted
Alteryx
Alteryx

whoops! You were correct, fixed. Thank you

Highlighted
Alteryx Certified Partner

I used a different approach to categorize the unique and duplicate lines.  Instead of using a Unique tool, I used a filter tool to separate unique lyrics with 1 count from all other lyrics, then performed my total counts and aggregated the results:

Spoiler
205.PNG

 

(edit 3/3 5:50 CDT) Video of solution overview:

Spoiler
Highlighted
Alteryx Certified Partner

I can't quite get my numbers to tie, I'll be interested to see the posted solution tomorrow. In the meantime, I'll just.... 

 

giphy.gif

 

Spoiler
205.png
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Wasn't quite clear how the numbers were calculated,  it ended up being easier as expected.

 

Spoiler
challenge205.png

 

Highlighted
13 - Pulsar

I am getting the same small discrepancies in my unique vs non-unique lyrics.  Total lyrics and Top 10 tie to provided solution.

 

Spoiler
Workflow 205.png

 

 

Highlighted
12 - Quasar
12 - Quasar

Tried two ways and got the same answer - which did not match the one provided (off by a few).   Looks like others have experienced the same...

 

 

Highlighted
8 - Asteroid
Spoiler
sonyakasenkramer_0-1583176882815.png

 

Highlighted
Alteryx Certified Partner

I had a few slight discrepancies, which is apparently not unique. I'll be interested to see the official solution

Spoiler
Got a slightly different top 10 lyrics for Taylor Swift (2006) - I had should've instead of beautiful. This isn't in the Stop Words, but should and shouldn't are, so maybe it should be

Also my percentages were very slightly out
Challenge 205.png