Challenge #120: Popular Baby Names

[trodriguez91]

Spoiler

[simons]

Spoiler

 

[javila]

Took longer than I had hoped (make to change your strings to a different data type) but here is my solution! Pretty much the same as a few others here. 

[ggruccio]

Love challenges like these with large data sets.  

[estherb47]

Nothing like a weekly challenge to allay the post Inspire blues! I wanted to go a least tools route, so was determined to do all of the parsing in a single formula tool (which also let me rename and assign data types immediately)

Natural instinct is Regex_replace. But like @patrick_digan, noticed this was SLOW. So, used combinations of Left, Right, Substring, Length. Ugly formulas but they work and they're fast!

Only different approach I took was a Make Columns tool instead of the Filter/Join combo. Thanks @NicoleJohnson for introducing me to this tool in a challenge long ago.

Spoiler

[Ladarthure]

My version of the challenge, different from the others, used a summarize join instead of a sample first :) 

[LordNeilLord]

I went down the same route as @patrick_digan

Spoiler

[kat]

Spoiler

[haroon_sa]

Here is my workflow.

Spoiler