Categories: Uncategorized

BLS US Employment by Industry

https://public.tableau.com/profile/eric.a.stalee#!/vizhome/BLSUSEmploymentbyIndustry/Dashboard1

The Index of Employees by Industry shows an Industry’s relative growth in employees since the data origin of January 1st 1990. In this way the growth rates of individual sectors are made more graphically comparable. In other words, an index value of 600, represents that the amount of employees in that industry has grown 600% since January 1st, 1990.

Raw data gathered with a bit of python code to collect various .xlsx files on each industry, then including only the most granular data-sets possible (i.e. removing broader categorizations).

Compiled the various excel files with Power Query and made an index of employees in each industry to better compare growth across different industries.

Would like to learn how to use the BLS’s API properly, but instructions weren’t that user friendly for my use case. Additionally, the API limits a data-set to having at most 20 years of data, and I wanted a bit more history than that.

My python code kind of ‘hacks’ the web interface, in that it uses a POST request that a browser normally sends to request data-sets via BLS webpage. The code sends the same requests but then just via a command-line process and saves the requested files. Since it’s 889 requests it’s not really feasible to download them all manually.

Eric

Share
Published by
Eric

Recent Posts

For those who like details

My work mainly focused on generation of KPIs or on business process improvement. Creation and…

3 years ago

Why I consider advertising to be one of the more evil aspects of Marketing.

https://www.theregister.co.uk/2019/01/30/azure_sql_delete/

5 years ago

10 Excel Tips

Had a sick day...now unable to sleep after sleeping too much.  At least I don't…

7 years ago

Ring Around the Debt

http://www.reuters.com/article/us-eurozone-future-idUSKBN18Q23I One idea in the paper that did not involve any mutualization of debt was…

7 years ago

Doomed?

https://www.youtube.com/watch?v=pbeuHRdZWlc "I have, therefore, chosen this time and place to discuss a topic on which…

7 years ago

The goal of ‘Islamic’ terrorism and the danger in failing to understand it.

I think many people have the idea that violence committed by extremists of Islam (i.e., less…

7 years ago