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

The_Rad_Valentina
8 - Asteroid

This needs an updated link so that it will work with a download tool. Otherwise this is just a different type of exercise. 

Yoshiro_Fujimori
15 - Aurora

My solution.

As the URL is changed, I am not sure if this is the same solution as the original challenge.

 

Spoiler

Download tool was used to get .xlsx file.

The remaining workflow needs to be kicked after the download completes.

Yoshiro_Fujimori_0-1687065333177.png

 

ntakeda
11 - Bolide

My solution.

BS_THE_ANALYST
14 - Magnetar

@Towers helped me with the Wayback machine URL! 

Also: Dynamic Solution.

 

Towers
11 - Bolide

quite a challenging one, I had to use the Wayback machine to obtain the link to the data. I enjoyed it though! 

Spoiler
45.png

mithily
8 - Asteroid
Spoiler
Used the provided file from another user since the original link does not work; dynamic renames and splits
jennifer_owens
8 - Asteroid

Learned a lot on this one. 

 

https://web.archive.org/web/20160801000000*/https://www.bls.gov/web/empsit/compaes.txt

 

Go back in time to grab data since the link does not work! 

jennifer_owens
8 - Asteroid

Forgot the remove the "p"s!  Updated here. 

H_a_n_g_C_h_e_n__x3
8 - Asteroid

The link did not work. Used a source file and made a macro instead. No way to check for Accuracy as the Dates are off. 

jon_amanrich
8 - Asteroid

Realised that I made my life more complicated than necessary here 😅