Create a state supply table from the county supply table
In [1]:
import pandas as pd
In [6]:
countyFN = '../../Data/SupplyTable.csv'
In [7]:
dfCounty = pd.read_csv(countyFN,index_col=('YEAR','STATEFIPS'))
In [13]:
dfState = dfCounty.sum()
In [10]:
dfCounty['Supply'].unstack()
Out[10]: