We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #45: Parsing Bureau of Labor Data

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1619648561305.png

 

Cheers!

Phil

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission; the data is newer than the original but with the same data structure.

CandiceDB
Alteryx
Alteryx

My solution:

 

Spoiler
CandiceDB_0-1624479567806.png

 

Ajjay
8 - Asteroid
Spoiler
Ajjay_0-1624541540603.png

 

ExploreMore
8 - Asteroid

The current website that you download from seems to have a different data set than the one in the provided solution. It appears it has been updated over the last five years. So my formatting matches but I have 300 more records than the provided solution.

 

 

Spoiler
Screenshot 2021-07-25 173222.png
carmenrapariz
8 - Asteroid
Spoiler
Challenge 45.PNG
FredNajjar
9 - Comet

My results didn't perfectly match the solution provided, as the data has been refreshed to 2020-21. However, this challenge probably took over an hour to resolve, but totally worth the time! 

Spoiler
image.pngFredNajjar_0-1627869231379.png

 

carmenrapariz
8 - Asteroid
Spoiler
Challenge 45.PNG
MichaelPilotFreight
8 - Asteroid

Check out my solution!

Jotigautam
10 - Fireball
Spoiler
Jotigautam_0-1629458189515.png