cancel
Showing results for 
Search instead for 
Did you mean: 

Challenge #205: Taynalysis

AYXAcademy
Alteryx

Challenge #205: Taynalysis

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.
Attachment
Download this attachment
Attachment
Download this attachment
325 REPLIES 325
AYXAcademy
Alteryx

Challenge #205: Taynalysis

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.
Attachment
Download this attachment
Attachment
Download this attachment
Kenda
16 - Nebula

Re: Challenge #205: Taynalysis

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

Re: Challenge #205: Taynalysis

whoops! You were correct, fixed. Thank you

Aaron_Harter
11 - Bolide

Re: Challenge #205: Taynalysis

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
Attachment
Download this attachment
Blake
Quasar

Re: Challenge #205: Taynalysis

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
Attachment
Download this attachment
RolandSchubert
16 - Nebula

Re: Challenge #205: Taynalysis

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

 

Spoiler
challenge205.png

 

Attachment
Download this attachment
T_Willins
14 - Magnetar

Re: Challenge #205: Taynalysis

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

 

 

Attachment
Download this attachment
ggruccio
ACE Emeritus

Re: Challenge #205: Taynalysis

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

 

 

Attachment
Download this attachment
sonyakasenkramer
Asteroid

Re: Challenge #205: Taynalysis

Spoiler
sonyakasenkramer_0-1583176882815.png

 

Attachment
Download this attachment
OllieClarke
16 - Nebula

Re: Challenge #205: Taynalysis

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

 

 

Attachment
Download this attachment