This project aims to normalize occupation data from the U.S. BUREAU OF LABOR STATISTICS (BLS). An initial review of their tool seems to display a pivoted list of employment occupations / industry, employment categories, and corresponding employment titles. What we might want is the employment titles (third level of detail), matched with their corresponding occupation categories (second level summary), and occupations / industries (first level summary). We will find additional levels for some occupations. However, a visual inspection of the file suggests that going down three levels is enough. #Inception!
You can clone this project to your designated workspace:
git clone https://github.com/temiwale88/list-of-standardized-occupations-bls.git
Or you can just download the zip.
Your project tree will most likely look like this:
Employment
├─ employment_parser.ipynb
└─ Resources
├─ Cleaned_BLS_Employment_Categories.csv
└─ occupation.xlsx
The final output (and most likely what you need) is the Cleaned_BLS_Employment_Categories.csv file in the Employment/Resources folder.
Optional:
See the employment_parser.ipynb for an informative notebook on how this was created.
Feel free to modify the code to make it cleaner and more meaningful where possible! Nonetheless, this should be a good starting point.
This might be useful for some tasks including:
- Building an application with a form that requests employment title from end users. This allows you to standardize your employment database with nationally recognized titles and their respective industries or "occupations".
- Fuzzy matching existing job titles in your employment database with the BLS employment titles so as to categorize these into their respective recognized industries.