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.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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
10 - Fireball

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
10 - Fireball

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
Luisa_Bez
8 - Asteroid