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 #45: Parsing Bureau of Labor Data

Natasha
9 - Comet

Used generate rows and regex but in a slightly different order. Also the data is updated to contain 2016 vs 2015 data

Spoiler
Screen Shot 2017-10-29 at 22.07.07.png
JoshKushner
12 - Quasar

Thought it was going to be impossible, but it was actually not too bad!

samN
10 - Fireball

Got a few more rows than the solution file but i think its just updated. Fun little parsing challenge

ggruccio
ACE Emeritus
ACE Emeritus

Fairly challenging!  My data was from 2007 to 2016 also...great parsing exercise.

PhilipMannering
16 - Nebula
16 - Nebula

Regex to the rescue. I feel like I used fewer tools than most sooooooo..... go me.

 

Spoiler
Regex heavyRegex heavy
LandonG
8 - Asteroid

Solution attached.

jasperlch
12 - Quasar

Solution attached.

msicak
8 - Asteroid

the good old multi-row tool. And to think I did not understand/get its use the first time I came across it! 

 

Spoiler
challenge45.png
dominiklz
8 - Asteroid
Spoiler
Capture.PNG

that was quite something, messy data is messy, but cleaning it feels so rewarding :-)

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed