Skip to content

Instantly share code, notes, and snippets.

@stucka

stucka/gist:37d993ac091999a5340d

Created November 20, 2014 15:04
Show Gist options
  • Save stucka/37d993ac091999a5340d to your computer and use it in GitHub Desktop.
Save stucka/37d993ac091999a5340d to your computer and use it in GitHub Desktop.
Download ZIP
Push BEA local personal income data into one national file with csvkit
Raw
gistfile1.txt
rem Have to force New Mexico into UTF-8.
del big1.csv
for /f %%f in ('dir /b CA04_??.csv') do csvgrep -c 2 -m "," %%f >>big1.csv
csvgrep -c 7 -m "Per capita personal income" big1.csv >big.csv
del big1.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment