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

iamme012397
8 - Asteroid

I hope this is enough 

 

my rows dont match the number of rows in final output but okay

CKP
10 - Fireball

My solution

 

Spoiler
challenge_45_mysolution.jpg
Treyson
13 - Pulsar
13 - Pulsar

This challenge has been haunting me for several years now. I have gone back 5 or 6 times to attempt it and something has always come up as I work through it. I finally finished it! Results are different because of dates but it works.

Treyson Marks
Managing Partner
DCG Analytics
Sylvana
8 - Asteroid

My solution.

 

jarrod
ACE Emeritus
ACE Emeritus

some obvious updates to the data, but looks like it all parsed correctly.

Spoiler
jarrod_0-1591218148962.png

 

Parul_Kapoor
8 - Asteroid

Solution attached.

cc000072
8 - Asteroid

Here is my solution, there are some gaps downloaded data..

Spoiler
WeeklyChallenge_Ryohei_45.JPG
mattreynolds
9 - Comet

RegEx to the "regscue"!

 

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

Normster
8 - Asteroid

Glad to see I'm not the only one who had difficulty getting the same results as the solution due to differences in downloaded data.  Nevertheless, I think I got it (Browse tool).

 

Spoiler
Normster_0-1594389004453.png