Pres.py

import pandas as pd
for i in range (1, 21):
    data = pd.read_csv('../' + str(i) + '.csv')
    delta = data["Total"] - data["First"] - data["Second"] - data["Third"]
    data['delta'] = delta
    data['one'] = 1
    Age = data.ix[data20['County']=='TPE'] 
    Age = pd.tools.pivot.pivot_table(Age, values='one', index=['delta'], columns=['Age'],aggfunc=np.sum, margins = False)
    print Age.T.plot()
    Age.T.plot().savefig('/path/to/figure.pdf')