Using Data

Merging Table Lookup and Shell Files

In order to get the proper titles for variables/cells in the data I needed to write a program to merge two Excel files. The two files are Sequence_Number_and_Table_Number_Lookup.xls and ACS2012_5-Year_TableShells.xls. The first one contains the sequence and line numbers so that I can get the values from the data-tables. The second one has indents in the cell titles so I know how to combine them to create a proper cell title. Very ugly, anything that can be done to fix this should be considered. Example given:

B99051 B99051001 Total

B99051 B99051002 Total:Native

B99051 B99051003 Total:Native:Imputed

B99051 B99051004 Total:Native:Not imputed

B99051 B99051005 Total:Foreign born

B99051 B99051006 Total:Foreign born:Imputed

B99051 B99051007 Total:Foreign born:Not imputed



0 votes
0 up votes
0 down votes
Idea No. 341