Obtaining and merging additional data
In the previous recipe, we found that additional data was needed to understand what the data in the CSV file actually represents, and this recipe will directly address this need.
Getting ready
We can find additional data on the BLS website at
http://www.bls.gov/cew/datatoc.htm
under the header Associated Codes and Titles
. There are five files there, which we will download to our computer. They are as follows:
agglevel_titles.csv
( http://www.bls.gov/cew/doc/titles/agglevel/agglevel_titles.csv )area_titles.csv
( http://www.bls.gov/cew/doc/titles/area/area_titles.csv )industry_titles.csv
( http://www.bls.gov/cew/doc/titles/industry/industry_titles.csv )ownership_titles.csv
( http://www.bls.gov/cew/doc/titles/ownership/ownership_titles.csv )size_titles.csv
( http://www.bls.gov/cew/doc/titles/size/size_titles.csv )
We download them to our computer, remembering where we stored them. We need to get ready to import them into R and merge them with our original...