Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #182: Word Sleuthing

Nicole_L
8 - Asteroid

I also get different results even after following the solution.

SueDonim
8 - Asteroid

Cool.  This was surprisingly simple (at least once I understood ....)

 

Spoiler
... how to deal with
- RegEx (still learning that)
- how to get rid of the truncation problem
- found the [Null] that was making my solution one record too many

Process:
- Tokenise on \<\w+\> (and split to rows)
- Group by word and count all instances of that word
- Sort - descending on count
- Sum of all words (sum of count)
- Append to Count
- Calculate % of each word
- Filter out the [Null]

Elementary....

MySolution.PNG


HarshGarg6135
6 - Meteoroid
 
JoshuaGostick
11 - Bolide

My solution 🙂

 

Spoiler
challenge_182.PNG
RichoBsJ
11 - Bolide

Hi! Here my solution 🙂

 

guys'n'gals enjoy Inspire Europe!

LordNeilLord
15 - Aurora
Spoiler
Capture.PNG
hueyor2
5 - Atom
Spoiler
challenge_182_Orion_Huey.PNG
RWvanLeeuwen
11 - Bolide

Back from my holidays and another few challenges are there for the taking/tackling.

Spoiler
182.png

I found some minor differences, but I am unsure as to why.

JonMcMillin
8 - Asteroid

Thanks for the challenge! pretty straightforward.

 

Spoiler
clipboard_image_0.png
Inactive User
Not applicable