Free Trial

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

mpennington
11 - Bolide

Solution attached.  

 

Spoiler
MP45.png
SamDesk
11 - Bolide
Spoiler
SamDesk_0-1584619033806.png

 

Sam

aazimh
8 - Asteroid

This was quite the ride - almost punched something when I realized the columns weren't tab-separated 🙂 good fun though!

atcodedog05
22 - Nova
22 - Nova

On a spree to binge complete weekly challenges

 

Used Cache and Run option to speed up data download and execution 🙂

 

Spoiler
This is my solution

atcodedog05_0-1585313245006.png

 

kaianderson
8 - Asteroid

Here's my solution in terms of formatting. I don't think the output is actually possible to get to, given the difference in years of data provided...

aheikes
8 - Asteroid
Spoiler
Challenge45.JPG
dpencheva
8 - Asteroid

Here is my solution. Very interesting task!

AndrewS
11 - Bolide

#45

steven4320555
8 - Asteroid

The recent practices helped.

 

Spoiler

steven4320555_1-1587068508996.png

I also practiced adding annotations.


steven4320555_0-1587068972680.png

Note the data does update over time. I was dealing with 2010-2019 data. [data earlier than 2010 may need to be dug elsewhere.]



A bonus for me: Happy to see the data lineage information from the selection tool. 
steven4320555_0-1587068248122.png
 
 
 

 

 

 

 

 

Junya_Wang
8 - Asteroid
Spoiler
Junya_Wang_0-1588772460270.png

 

quite a few tools being used