We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

TonyAndriani
9 - Comet

Reposting to my new user ID.

binuacs
20 - Arcturus

solution attached

SylwiaDragon
8 - Asteroid

It looks like the page was moved.

I will have to skip this challenge :)

SylwiaDragon_0-1652279519957.png

 

usmanghayoor
8 - Asteroid
Spoiler



usmanghayoor_0-1652958830800.png

 

The Bureau has moved this data but got lucky and got the data from website archive list ! but frankly speaking there was nothing much to do in the challenge after that !

usmanghayoor
8 - Asteroid

Hi this is available if you want to give it a try, got it from the Bureau website archives!

mmontgomery
10 - Fireball

Challenge #45

FilipR
11 - Bolide

Solved.

 

Spoiler
FilipR_0-1654797719265.png

 

AliAb
Alteryx Alumni (Retired)

solution attached

Amol_Telore
11 - Bolide

Seems like this URL is not valid anymore..

When I tried to download data from "http://www.bls.gov/web/empsit/compaes.txt" it gave me HTTP code 301 Move Permanently along with new URL.

i.e. "https://www.bls.gov/web/empsit/compaes.txt"

But when I tried this new URL as well it returned 400 Bad Request HTTP Code. 

Does anyone have access to the actual raw data downloaded from above URL?

Albert_Vega
8 - Asteroid

Unfortunately, I'm unable to find the file to download either by the link provided or in the archives. There are posts with the xls file, but that somewhat defeats the purpose. I'd like to try this challenge if a valid url is posted in the future.

 

Albert_Vega_0-1658072208201.png