Challenge #222: Where There's a Whale There's a Way

[Tberney]

The only thing working **bleep** this one is my laptop - lots of records! Also the whales I guess

スポイラ

[phoebe_kelley]

Fun and quick 🙂

[kelly_gilbert]

There have been some really great challenges lately. I can't wait to do this one with my colleagues at work!

スポイラ

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).

[Sudha8990AI]

Very Easy and Interesting one.

[hamza_khan]

Whale.....that wasn't too hard !

[Inactive User]

My solution 🙂

[Gizzo1]

Just completed my first Weekly Challenge! Pretty fun, I'll definitely come back for next week's challenge!

スポイラ

[pasccout]

Here's my solution...

[jyothiganti]

Here is my solution.

[jmt214]

Gotta love whales!

スポイラ