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
The only thing working **bleep** this one is my laptop - lots of records! Also the whales I guess
There have been some really great challenges lately. I can't wait to do this one with my colleagues at work!
Spoiler
My solution is like many others, with the exception of pre-summarizing the whale data by whale ID and year. My general rule is always to reduce rows and columns as early as possible in a workflow, and that definitely made a difference with a dataset of this size.
Avg run time without pre-summarizing = 3.7 s
Avg run time with pre-summarizing = 2.7 s
I was also intrigued by @PhilipMannering and others' solutions using Find/Replace. I never would have thought to use that tool for this! On my laptop, it was a good bit slower, though (avg 5.9 s).
Avg run time without pre-summarizing = 3.7 s
Avg run time with pre-summarizing = 2.7 s
I was also intrigued by @PhilipMannering and others' solutions using Find/Replace. I never would have thought to use that tool for this! On my laptop, it was a good bit slower, though (avg 5.9 s).
Just completed my first Weekly Challenge! Pretty fun, I'll definitely come back for next week's challenge!
