Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAGot a slightly different answer on one category than @ChristineB - but the rest matched.
Good exercise in data prep and cleaning!
Not too bad!
Probably not the fastest way to arrive at the solution, but it works!
Originally made it harder that it needed to be. Fun one!
Here's mine. I've tried both of the most common approaches. It seems that the below *spoiler* is the only way to work around the 'ID1119 issue'. Still not quite sure how and why... Happy to hear your feedback.