Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Challenge #120: Popular Baby Names

HarrietJack
7 - Meteor
 
SueDonim
8 - Asteroid

Not too bad - I'm a lot better at this when I don't have to parse dates....

 

These challenges are definitely improving my skills

 

Spoiler
Process:
- Parse name/**bleep**/number data
- Parse year
- Cleanup and sort (Year: Asc, **bleep**: Asc, Instances: Desc)
- Grab first instance (grouped by year and **bleep**
- Separate female from male
- Rename fields
- Join data for final output

MySolution.PNG
Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

jstokes1994
7 - Meteor
Spoiler
clipboard_image_0.png
nilaysameer
7 - Meteor

solved

DBourke19841
8 - Asteroid

Getting better with data cleansing thanks to these challenges!!

Spoiler
Weekly Challenge 120 Solution.PNG

 

blundebjerg
8 - Asteroid
 
Steph3388
7 - Meteor

I did it a little differently than the posted solution, but got there anyway!

mat_budden
8 - Asteroid

Hi All,

 

Please find my Result below.

 

Spoiler
Text to Columns, Select to Change data type, Regex for year Split Male and Female summarize to the Max, Join to get the name, Then join male and female back together.

 

Thanks

Mat

Inactive User
Not applicable