{ "cells": [ { "cell_type": "markdown", "id": "731499a9", "metadata": {}, "source": [ "# BLS MSA stats\n", "\n", "By Andy Wheeler\n", "\n", "See blog post, [Use circles instead of choropleth for MSAs](https://andrewpwheeler.com/2022/03/13/use-circles-instead-of-choropleth-for-msas/) for overview.\n", "\n", "This scrapes the data from BLS website for particular employment codes." ] }, { "cell_type": "code", "execution_count": 1, "id": "above-transformation", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | OCode | \n", "Desc | \n", "
---|---|---|
0 | \n", "110000 | \n", "Management Occupations | \n", "
1 | \n", "111011 | \n", "Chief Executives | \n", "
2 | \n", "111021 | \n", "General and Operations Managers | \n", "
3 | \n", "111031 | \n", "Legislators | \n", "
4 | \n", "112011 | \n", "Advertising and Promotions Managers | \n", "
... | \n", "... | \n", "... | \n", "
847 | \n", "537072 | \n", "Pump Operators, Except Wellhead Pumpers | \n", "
848 | \n", "537073 | \n", "Wellhead Pumpers | \n", "
849 | \n", "537081 | \n", "Refuse and Recyclable Material Collectors | \n", "
850 | \n", "537121 | \n", "Tank Car, Truck, and Ship Loaders | \n", "
851 | \n", "537199 | \n", "Material Moving Workers, All Other | \n", "
852 rows × 2 columns
\n", "\n", " | areaName | \n", "Employment | \n", "Annual mean wage | \n", "Annual 75th percentile wage | \n", "
---|---|---|---|---|
120 | \n", "New York-Newark-Jersey City, NY-NJ-PA | \n", "13860 | \n", "136040.0 | \n", "168040.0 | \n", "
156 | \n", "San Francisco-Oakland-Hayward, CA | \n", "8890 | \n", "152080.0 | \n", "175580.0 | \n", "
102 | \n", "Los Angeles-Long Beach-Anaheim, CA | \n", "7160 | \n", "120290.0 | \n", "147990.0 | \n", "
191 | \n", "Washington-Arlington-Alexandria, DC-VA-MD-WV | \n", "6720 | \n", "126160.0 | \n", "164530.0 | \n", "
33 | \n", "Chicago-Naperville-Elgin, IL-IN-WI | \n", "5100 | \n", "110800.0 | \n", "132900.0 | \n", "
44 | \n", "Dallas-Fort Worth-Arlington, TX | \n", "5040 | \n", "108090.0 | \n", "135290.0 | \n", "
157 | \n", "San Jose-Sunnyvale-Santa Clara, CA | \n", "4940 | \n", "233320.0 | \n", "NaN | \n", "
10 | \n", "Atlanta-Sandy Springs-Roswell, GA | \n", "4480 | \n", "110670.0 | \n", "134990.0 | \n", "
132 | \n", "Philadelphia-Camden-Wilmington, PA-NJ-DE-MD | \n", "3680 | \n", "109460.0 | \n", "135590.0 | \n", "
165 | \n", "Seattle-Tacoma-Bellevue, WA | \n", "3610 | \n", "142810.0 | \n", "174640.0 | \n", "