Reads in the raw FMR spreadsheets, standardizes the FIPS code and FMR variables, removes unneeded variables, and counts the number of records per county.
process_fmr(raw_fmr_path)| raw_fmr_path | A character string with the file path of the raw FMR spreadsheet |
|---|
A data frame with the processed FMR data.
Counting the records per county is necessary because unlike the rest of the U.S, which uses groups of counties for FMR areas, New England states create FMR areas with county subdivisions, so a county can be in more than one FMR. This flags those records so we can deal with them further down the line.