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

ed_hayter
12 - Quasar

Looked for similar data as the link is broken (As stated by others) There is an excel file circulating that some have used. This is what I used, seemed to be missing some information but still was a test of parsing skills.

Spoiler
Multiple tables into one table

Challenge 45 WF Image.png
mattnason1
9 - Comet

Had to use the excel file to make this work even the archive link people posted wasn't working.  So, not sure how close this is to the work required in the past since I'm not sure what parsing was needed.

tristank
10 - Fireball

Thanks for those who shared the excel file (Attached below)

 

Spoiler
Screenshot 2023-08-19 154847.png

 

gawa
15 - Aurora

Link was invalid so used alternative source

Spoiler
image.png
gawa
15 - Aurora

Solution attached

caltang
17 - Castor

Done

 

Spoiler
image.png
aaenugu
6 - Meteoroid

The URL is not working. Is there any alternate URL that is available??.

 

 

Screenshot 2023-09-13 151044.png

fluteman
8 - Asteroid

this link to data "http://www.bls.gov/web/empsit/compaes.txt" is broken; so instead I used this one:  "https://www.bls.gov/web/ecec/ececqrtn.txt" 

 

I did something similar breaking the title part into sections

and then creating a table from the first dataset.

 

A lot of TextToColumns and Cleansing tools used. The TABs are a doozy!

fluteman
8 - Asteroid

I saw that too. I found this instead to work with - same premise; chop up a data file!

 

"https://www.bls.gov/web/ecec/ececqrtn.txt" 

Rob-Silk
8 - Asteroid

My solution below - I used the shared XLSX file version of the updated dataset

Spoiler
challenge_45_RS_screencap.PNG