Challenge #45: Parsing Bureau of Labor Data

[acarter881]

Here's my solution. Since the data aren't available via the URL in the challenge post, I used the Wayback Machine to download the text file from December 2016. It seems like it isn't the same file as the one the solution uses (mine has more years and hence more rows in the final output). 

Spoiler

[martinding]

Same issue with the input URL link.

Spoiler

 

[Thomas_Wells_2dot0]

Solution attached using the "compaes.xlsx" data shared by another user. 

Spoiler

 

[Kinga]

Hi,

The mentioned URL doesn't work for me as for many users. I've tried both options suggested (compaes.xlsx and Wayback Machine). Please find my solutions below:

Spoiler

[leonhekkert]

My solution based on the file that was provided by one of the other users.

Spoiler

[poushali96]

Attaching my solution for Challenge 45. As previously mentioned the URL link is not working. However, this one worked for me - http://www.bls.gov/web/empsit/compaes.xlsx.

[AndrewHoData]

Like others before me I also had trouble with the URL and used the compaes.xlsx file that another user had posted to solve this.

Spoiler

Please find both my workflow and compaes.xlsx file attached.

[grazitti_sapna]

Solution for this:

[geoff_zath]

Spoiler

[TimN]

Hi,

I think the file to be downloaded is now here:

https://bls.gov/pub/suppl/empsit/compaes.txt

Regards,

Tim