Challenge #120: Popular Baby Names

[Comicjess78]

And voilà! 

Spoiler

The part I like the most is to see how people resolved this but in so different ways :-)

Best regards,

Jessica

[Wouter]

My solution:

Spoiler

[EW1]

This was my first challenge! Thanks for posting these!

[asifk]

Hi ,

My solution as follows, i added a chart to see how the names compare.(Frequency vs  Count no. of Years)

Spoiler

 

[mceleavey]

Does anyone else feel all warm and fuzzy when they get to use Regex?

Anyone?

*gets coat*

Spoiler

I used the text to columns to split out the first field, then used Regex to parse out the 4 digit year from the filename using \d\d\d\d.
I then grouped the records by year and gender to find the maximum frequency and joined back on these fields to the main stream.
Then I simply split by gender and joined on the year.

 

[Lunalight]

My first challenge :) 

Spoiler

[Steven_Pocoroba2]

Solution attached, thanks!

[Bahouth12]

Here is my solution.

[Ruud]

Nothing fancy, my solution.

[CHarrison]

My solution :)