IDEAS WANTED
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit Feedback
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....
- 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....
Back from my holidays and another few challenges are there for the taking/tackling.
I found some minor differences, but I am unsure as to why.
