bdecon / econ_data

Python 3 examples of using economic data APIs and working with economic microdata. Includes bd CPS.
74 stars 38 forks source link

bd CPS: data type for year and month #226

Closed bdecon closed 3 years ago

bdecon commented 5 years ago

Consider either 1) allowing the YEAR and MONTH variables to be numeric, for example int16, or 2) require each categorical variable to include information related to all other categories of data, so that when two years of data are merged, the datatype is not converted from categorical to int64.

One example is the MONTH variable in cps2019.ft could be int8 or have a 'placeholder' for MONTH 6, 7, 8, 9, 10, 11, and 12, even though those months of data are not currently available.

bdecon commented 3 years ago

Work on this front should probably be in writing a small script that reads the bdCPS into a dataframe. Storing the two columns as they are now is probably the right approach.