Challenge #182: Word Sleuthing

[deepaprash]

I got a different solution as well. I used text to columns instead of proposed solution of regex...but it should have the same result. Confused.

[balajilolla]

Spoiler

Solution Attached

[TomProwse]

Solution

Spoiler

[mhou]

🙂 approximate

[deviseetharaman]

Spoiler

[StellaBon]

Would have been faster if Data Cleansing had a "Remove Null Rows" option. Good practice using the summarize tool, Thanks!

[Mengdee]

hmmm interesting challenge... wasn't difficult per se (if you take note of the hint first).  i was scratching my head until i re-read the challenge notes.. hehe

[treepruner]

I got slightly different totals, but I think the difference is due to the way I stripped out punctuation in words with contractions.  I think I'd rather do the cleaning with an R package like tidytext or quanteda. than write a regEx expression for that!

[sumanthskumar]

Challenge #40: Didn't get the exact same answer. I removed all the special characters and numbers. I also converted all the words to lowercase.

Spoiler

[Blake]

I got a slightly different answer than the given one but I also standardized casing to make sure to capture "The" and "the" et al together. 

Spoiler