Challenge #205: Taynalysis

[alexnajm]

A slight challenge to figure out what characters to replace, but we got there eventually!

[ncrlelia]

Challenge 205

[euanwilson]

Spoiler

[TheOC]

I had to consult the Solution for this one - it was frustrating me I had differing numbers at the end...

Spoiler

Turns out it was pesky apostrophes, I started by cleansing both the lyric and stopwords:

And that seemed to work fine, but literally one album had 1 extra duplicate line... strange.

Having a look at the solution however, saw that replacing all punctuation apart from an apostrophe was the right way to go:

[Jonny]

my solution:

Spoiler

My numbers did not fully match, but I am happy with the approach I've taken.
REGEX_Replace gave me a big help here! I have checked my approach vs @RolandSchubert and I think I was vey close to his solution!

[Nvy]

Let me go listen to one of her songs now.

[Elias_Nordlinder]

Here is my solution, the count had some small decrepancy like for others:

Spoiler

[Erin]

Spoiler

Slight differences due to using a Cleanse tool for all punctuation vs formula tool for some punctuation. Close enough for Taylor I think.

[TimN]

Spoiler

Interesting one.  Used MD5_Hash to overcome my problems with "Should've"!

[Anmol97]

Here's my solution