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.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

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

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

Submit Feedback

Challenge #205: Taynalysis

AYXAcademy
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.
Kenda
15 - Aurora
15 - Aurora

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

AYXAcademy
Alteryx
Alteryx

whoops! You were correct, fixed. Thank you

Aaron_Harter
11 - Bolide

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
Blake
12 - Quasar

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
RolandSchubert
15 - Aurora
15 - Aurora

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

 

Spoiler
challenge205.png

 

T_Willins
13 - Pulsar
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

 

 

ggruccio
13 - Pulsar
13 - Pulsar

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

 

 

sonyakasenkramer
8 - Asteroid
Spoiler
sonyakasenkramer_0-1583176882815.png

 

OllieClarke
13 - Pulsar
13 - Pulsar

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