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
SOLVED
This was fun 🙂
Spoiler
knock Knock Who's there? Irish! Irish Who? Irish you a happy St. Patrick's Day!
Here's the answer - with ice cream!
Spoiler
Process:
- Tokenize each character into new column (had to determine max columns needed first though)
- Transpose data into rows
- Group by Name (the former column headers) and take mode of each
- Convert Name to number by stripping out "data" from Name
- Sort Ascending
- Concatenate results (removing separator - I didn't know you could do that before....)
Process:
- Tokenize each character into new column (had to determine max columns needed first though)
- Transpose data into rows
- Group by Name (the former column headers) and take mode of each
- Convert Name to number by stripping out "data" from Name
- Sort Ascending
- Concatenate results (removing separator - I didn't know you could do that before....)
