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 Partner

 

First, for year 2008 the words "NEVER" and "ONE" each occur 19 times and are 10 and 11 on top 10 count. So,they both need to be included in the top 10 count. "ONE" needs to be added to 2008 top ten word list. 

 

Second, one of the strengths of Alteryx is it's ability to clean up dirty data. Why wouldn't the solution be represented by this process?

 

DataRangler_0-1583321289012.png

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution, thank's regex

Highlighted
8 - Asteroid

My solution attached. Off by a couple distinct lines for some albums.

Highlighted
Alteryx Certified Partner

I've got a better grasp on why I dislike Taylor Swift... Or perhaps why I stopped listening to the music that was written for her or by her...

 

Here's my take on parsing and counting these lyrics

 

Spoiler
205.jpg
Highlighted
5 - Atom

Hi folks - this is my first ever Alteryx Challenge! Let me know if I don't post this correctly!

 

Looking through others pictures, it looks like I have some opportunities to simplify, but not too bad overall.

 

I also had the challenge where my numbers don't 100% align to the answer, so interested to read more on why that is. I tried with and without cleaning steps to no avail.

 

Spoiler
alteryxchallenge.PNG

 

Thanks for the challenge,

Zak

Highlighted
7 - Meteor

Here is my proposed solutions, having a small discrepancies with the proposed output as well despite using the latest start file. Quite interested to see how my grouping function differs from the proposed solutions.

 

Workflow :

Spoiler
dkoenawan004_3-1583368949208.png

 


 

Highlighted
11 - Bolide

I'm not a much of a Taylor Swift fan, but when you work in the quick-service Restaurant industry, milkshakes are a frequent conversation topic. Getting "Shake It Off" stuck in your head is kind of an occupational hazard. 🥤

 

As others did, my solution has a few little differences from the provided solution. I'll be interested to see how it was solved!

 

Workflow (my solution is pretty similar to many others):

Spoiler
kelly_gilbert_0-1583376720477.png

Results:

Spoiler
For Taylor Swift, "should've" showed up in my top 10, but not in the solution. I would have considered that a stop word, but it wasn't in the provided list.

For Red, I had one more "just" (40) than "back" (39), so my top 10 words ;were in a different order than the solution.

In practice, I probably wouldn't have removed apostrophes in pre-processing, because it causes some issues (like the word ill being matched with the stop word I'll), however, removing the apostrophes seemed to give a better match to the provided solution.

kelly_gilbert_1-1583377236937.png

 

Highlighted
Alteryx Certified Partner

Here is my solution, but I can't quite got 2 albums' unique and duplicate lines numbers:

Spoiler
kelvinlaw_0-1583387658406.png

 

 

Highlighted
5 - Atom

First post ever!

 

I believe I got the correct answer, but am eager to hear other people's view on whether I was too roundabout in how I got my solution. Tried joining 3 different tables, one for each section of the question.

Highlighted
8 - Asteroid

Hi My Approach much similar with others.