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.
