Skip to content

micro

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

micro

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
cps_example
cps_example
 
 
results
results
 
 
shapefiles
shapefiles
 
 
x13as
x13as
 
 
440710.csv
440710.csv
 
 
ACS_to_CZ_income_map.ipynb
ACS_to_CZ_income_map.ipynb
 
 
CBSA_2YR_Indicators.csv
CBSA_2YR_Indicators.csv
 
 
CBSA_Names.csv
CBSA_Names.csv
 
 
CBSA_Split.ipynb
CBSA_Split.ipynb
 
 
COVID_CPS.ipynb
COVID_CPS.ipynb
 
 
CPS-ASEC_Income-of-the-Aged.ipynb
CPS-ASEC_Income-of-the-Aged.ipynb
 
 
CPS-ASEC_poverty.ipynb
CPS-ASEC_poverty.ipynb
 
 
CPS_Disability_NILF_CBSA.ipynb
CPS_Disability_NILF_CBSA.ipynb
 
 
CPS_EPOP_Map_Example.ipynb
CPS_EPOP_Map_Example.ipynb
 
 
CPS_EPOP_P10wage_CBSA.ipynb
CPS_EPOP_P10wage_CBSA.ipynb
 
 
CPS_EPOP_P25Wage_CBSA.ipynb
CPS_EPOP_P25Wage_CBSA.ipynb
 
 
CPS_Example_Notebook_UPDATED.ipynb
CPS_Example_Notebook_UPDATED.ipynb
 
 
CPS_Family_Income.ipynb
CPS_Family_Income.ipynb
 
 
CPS_Matching_Flow_Disabled_to_Work.ipynb
CPS_Matching_Flow_Disabled_to_Work.ipynb
 
 
CPS_Matching_Flow_Retired_to_Work.ipynb
CPS_Matching_Flow_Retired_to_Work.ipynb
 
 
CPS_NILF.ipynb
CPS_NILF.ipynb
 
 
CPS_PECERT_Mapper.ipynb
CPS_PECERT_Mapper.ipynb
 
 
CPS_Scatter_CBSA.ipynb
CPS_Scatter_CBSA.ipynb
 
 
CPS_Wages.ipynb
CPS_Wages.ipynb
 
 
README.md
README.md
 
 
SCF_saving_income_percentile.ipynb
SCF_saving_income_percentile.ipynb
 
 
Trade_Network_example.ipynb
Trade_Network_example.ipynb
 
 
acs_cz_age.csv
acs_cz_age.csv
 
 
acs_map.pgf
acs_map.pgf
 
 
asec_income_distribution.csv
asec_income_distribution.csv
 
 
asec_poverty_composition.csv
asec_poverty_composition.csv
 
 
asec_poverty_gap_by_age.csv
asec_poverty_gap_by_age.csv
 
 
asec_poverty_rates.csv
asec_poverty_rates.csv
 
 
asec_poverty_totals.csv
asec_poverty_totals.csv
 
 
asec_spm_effects.csv
asec_spm_effects.csv
 
 
bd_CPS-age_cohorts.ipynb
bd_CPS-age_cohorts.ipynb
 
 
bd_CPS_HRSUSL1I.ipynb
bd_CPS_HRSUSL1I.ipynb
 
 
bd_CPS_INDM.ipynb
bd_CPS_INDM.ipynb
 
 
bd_CPS_ONET.ipynb
bd_CPS_ONET.ipynb
 
 
bd_CPS_benchmark.ipynb
bd_CPS_benchmark.ipynb
 
 
bd_CPS_codebook.ipynb
bd_CPS_codebook.ipynb
 
 
bd_CPS_flow_MM.ipynb
bd_CPS_flow_MM.ipynb
 
 
bd_CPS_flow_YY.ipynb
bd_CPS_flow_YY.ipynb
 
 
bd_CPS_headship.ipynb
bd_CPS_headship.ipynb
 
 
bd_CPS_ind_occ_wage.ipynb
bd_CPS_ind_occ_wage.ipynb
 
 
bd_CPS_retirement.ipynb
bd_CPS_retirement.ipynb
 
 
bd_CPS_same_job.ipynb
bd_CPS_same_job.ipynb
 
 
bd_CPS_seasonal_adjustment.ipynb
bd_CPS_seasonal_adjustment.ipynb
 
 
bd_CPS_value_labels.ipynb
bd_CPS_value_labels.ipynb
 
 
bd_CPS_zone.ipynb
bd_CPS_zone.ipynb
 
 
cpi.csv
cpi.csv
 
 
fed_hh_example.csv
fed_hh_example.csv
 
 
rec_dates.csv
rec_dates.csv
 
 

README.md

micro

BD Economics microdata examples

Updated: March 2, 2019

Contact: Brian Dew, twitter: @bd_econ; email: brian.w.dew@gmail.com

Goal: Working with public-use microdata using jupyter notebooks and python.

Some examples use the bd CPS, a set of annual CPS extracts.

Contents

  • CPS-ASEC_median_income.ipynb: Replicates (closely) the published median wage estimate from the Annual Social and Economic Supplement to the Current Population Survey. nbviewer

  • CPS_Disability_NILF_CBSA.ipynb: Generates a map showing share of age 16-64 population that is out of work due to disability, for each metro area in the US. Uses raw Current Population Survey monthly data. nbviewer

  • CPS_EPOP_P10wage_CBSA.ipynb: Generates a scatter plot showing the relationship between the employed share of the population and the first decile real hourly wage for each metro area. Uses bd CPS as the source. nbviewer

  • CPS_Example_Notebook_UPDATED.ipynb: Example of using the struct method to read a fixed-width format monthly Current Population Survey data file. nbviewer

  • CPS_Matching_Flow_Disabled_to_Work.ipynb: Example of matching one-year apart bd CPS observations to measure the employed share of age 25-54 people who were not working the year before due to disability or illness. nbviewer

  • CPS_NILF.ipynb: Create line chart showing contributions to labor force participation rate since March 2001. Uses bd CPS data. nbviewer

  • CPS_PECERT_Mapper.ipynb: Create a choropleth map of the US showing what percent of each state's population has a professional certification. Uses bd CPS as data source. nbviewer

  • bd_CPS_benchmark.ipynb: Several examples of benchmarking bd CPS results to published estimates. Used to check validity of bd CPS extract. nbviewer

  • bd_CPS_flow_MM.ipynb: Create line chart showing what percent of newly employed people were not in the labor force last month. Uses month-to-month matching of bd CPS data. nbviewer

  • bd_CPS_flow_YY.ipynb: Create a line share showing the share of unemployed people with a job one year later. Uses one-year apart matching of bd CPS data. nbviewer

  • bd_CPS_grapher.ipynb: Tool for graphing common labor economics statistics from bd CPS data. For example, the unemployment rate, union membership rate, share part-time for economic reasons, share retired, etc. nbviewer

  • bd_CPS_grapher_two_lines.ipynb: Draft version of bd_CPS_grapher.ipynb that can create more complex line charts from bd CPS data. nbviewer