Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

JoBen
11 - Bolide

That was a lot of fun. Thanks for posting! Cheers!

chris_ramsay_dup_425
8 - Asteroid

Hi,

 

Please find my solution attached.

 

Thanks,

Chris

DavidP
17 - Castor
17 - Castor

My solution

 

challenge45.png

StevenBetts
8 - Asteroid

Here's my solution! :)

 

Spoiler
Challenge 45.jpg
yajing_wang
8 - Asteroid
Spoiler
Spoiler
Capture 2.PNG

Do not know how to deal with it initially, Good practice

pasccout
8 - Asteroid

Here is my solution...

 

The employment category and category though don't match the desired output since I don't have carriage returns...

 

Also, the final result does not contain the same record count since the source file has probably changed since this challenge was put in place...

kbwissi
8 - Asteroid

Done - really liked this one.

Kenda
16 - Nebula
16 - Nebula

This one was fun!

Spoiler
45.PNG
JoshuaGostick
11 - Bolide

Quite messy and a lot of investigation of the data was required but got there in the end! My solution.

 

Spoiler
challenge_45.PNG
jbranaum
8 - Asteroid

My solution