RIDE InSite financial analysis

In [ ]:
import re
import numpy as np
import scipy as sc
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
%matplotlib inline
In [ ]:
pd.set_option("display.max_rows",1000)
pd.get_option("display.max_rows")

2009

In [ ]:
fy09sb = pd.read_csv("../RIDE/In$site/Switchboard_Items_09.csv")
fy09sb['Year'] = 2009
print(fy09sb.shape)
print(fy09sb.columns)
fy09sb.head()
In [ ]:
fy09ac = pd.read_csv("../RIDE/In$site/tbl_alloc_categories_09.csv")
fy09ac['Year'] = 2009
print(fy09ac.shape)
print(fy09ac.columns)
fy09ac.head()
In [ ]:
fy09d = pd.read_csv("../RIDE/In$site/tbl_cd_district_09.csv")
fy09d['Year'] = 2009
print(fy09d.shape)
print(fy09d.columns)
fy09d.head()
In [ ]:
fy09el = pd.read_csv("../RIDE/In$site/tbl_cd_ed_level_09.csv")
fy09el['Year'] = 2009
print(fy09el.shape)
print(fy09el.columns)
fy09el.head()
In [ ]:
fy09f09 = pd.read_csv("../RIDE/In$site/tbl_cd_function_09.csv")
fy09f09['Year'] = 2009
print(fy09f09.shape)
print(fy09f09.columns)
fy09f09.head()
In [ ]:
fy09fX09 = pd.read_csv("../RIDE/In$site/tbl_cd_funcX_09.csv")
fy09fX09['Year'] = 2009
print(fy09fX09.shape)
print(fy09fX09.columns)
fy09fX09.head()
In [ ]:
fy09fund09 = pd.read_csv("../RIDE/In$site/tbl_cd_fund_09.csv")
fy09fund09['Year'] = 2009
print(fy09fund09.shape)
print(fy09fund09.columns)
fy09fund09.head()
In [ ]:
fy09pgm = pd.read_csv("../RIDE/In$site/tbl_cd_In$ite_program.csv")
fy09pgm['Year'] = 2009
print(fy09pgm.shape)
print(fy09pgm.columns)
fy09pgm.head()
In [ ]:
fy09l01 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy01_09.csv")
fy09l01['Year'] = 2009
print(fy09l01.shape)
print(fy09l01.columns)
fy09l01.head()
In [ ]:
fy09l02 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy02_09.csv")
fy09l02['Year'] = 2009
print(fy09l02.shape)
print(fy09l02.columns)
fy09l02.head()
In [ ]:
fy09d = pd.read_csv("../RIDE/In$site/tbl_cd_district_09.csv")
fy09d['Year'] = 2009
print(fy09d.shape)
print(fy09d.columns)
fy09d.head()
In [ ]:
fy09l03 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy03_09.csv")
fy09l03['Year'] = 2009
print(fy09l03.shape)
print(fy09l03.columns)
fy09l03.head()
In [ ]:
fy09l04 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy04_09.csv")
fy09l04['Year'] = 2009
print(fy09l04.shape)
print(fy09l04.columns)
fy09l04.head()
In [ ]:
fy09l05 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy05_09.csv")
fy09l05['Year'] = 2009
print(fy09l05.shape)
print(fy09l05.columns)
fy09l05.head()
In [ ]:
fy09l06 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy06_09.csv")
fy09l06['Year'] = 2009
print(fy09l06.shape)
print(fy09l06.columns)
fy09l06.head()
In [ ]:
fy09l07 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy07_09.csv")
fy09l07['Year'] = 2009
print(fy09l07.shape)
print(fy09l07.columns)
fy09l07.head()
In [ ]:
fy09l08 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy08_09.csv")
fy09l08['Year'] = 2009
print(fy09l08.shape)
print(fy09l08.columns)
fy09l08.head()
In [ ]:
fy09l09 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy09_09.csv")
fy09l09['Year'] = 2009
print(fy09l09.shape)
print(fy09l09.columns)
fy09l09.head()
In [ ]:
fy09l10 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy10_09.csv")
fy09l10['Year'] = 2009
print(fy09l10.shape)
print(fy09l10.columns)
fy09l10.head()
In [ ]:
fy09pgm = pd.read_csv("../RIDE/In$site/tbl_cd_program_09.csv")
fy09pgm['Year'] = 2009
print(fy09pgm.shape)
print(fy09pgm.columns)
fy09pgm.head()
In [ ]:
fy09progX = pd.read_csv("../RIDE/In$site/tbl_cd_progX_09.csv")
fy09progX['Year'] = 2009
print(fy09progX.shape)
print(fy09progX.columns)
fy09progX.head()
In [ ]:
fy09ld09 = pd.read_csv("../RIDE/In$site/tbl_legacy_detail_09.csv")
fy09ld09['Year'] = 2009
print(fy09ld09.shape)
print(fy09ld09.columns)
fy09ld09.head()
In [ ]:
fy09loc = pd.read_csv("../RIDE/In$site/tbl_location_09.csv")
fy09loc['Year'] = 2009
print(fy09loc.shape)
print(fy09loc.columns)
fy09loc.head()
In [ ]:
fy09enr = pd.read_csv("../RIDE/In$site/tbl_loc_pgm_enrollment_09.csv")
fy09enr['Year'] = 2009
print(fy09enr.shape)
print(fy09enr.columns)
fy09enr.head()
In [ ]:
fy09sum = pd.read_csv("../RIDE/In$site/tbl_summary_09.csv")
fy09sum['Year'] = 2009
print(fy09sum.shape)
print(fy09sum.columns)
fy09sum.head()

2008

In [ ]:
fy08sb = pd.read_csv("../RIDE/In$site/Switchboard_Items_08.csv")
fy08sb['Year'] = 2008
print(fy08sb.shape)
print(fy08sb.columns)
fy08sb.head()
In [ ]:
fy08ac = pd.read_csv("../RIDE/In$site/tbl_alloc_categories_08.csv")
fy08ac['Year'] = 2008
print(fy08ac.shape)
print(fy08ac.columns)
fy08ac.head()
In [ ]:
fy08d = pd.read_csv("../RIDE/In$site/tbl_cd_district_08.csv")
fy08d['Year'] = 2008
print(fy08d.shape)
print(fy08d.columns)
fy08d.head()
In [ ]:
fy08el = pd.read_csv("../RIDE/In$site/tbl_cd_ed_level_08.csv")
fy08el['Year'] = 2008
print(fy08el.shape)
print(fy08el.columns)
fy08el.head()
In [ ]:
fy08f09 = pd.read_csv("../RIDE/In$site/tbl_cd_function_08.csv")
fy08f09['Year'] = 2008
print(fy08f09.shape)
print(fy08f09.columns)
fy08f09.head()
In [ ]:
fy08fX09 = pd.read_csv("../RIDE/In$site/tbl_cd_funcX_08.csv")
fy08fX09['Year'] = 2008
print(fy08fX09.shape)
print(fy08fX09.columns)
fy08fX09.head()
In [ ]:
fy08fund09 = pd.read_csv("../RIDE/In$site/tbl_cd_fund_08.csv")
fy08fund09['Year'] = 2008
print(fy08fund09.shape)
print(fy08fund09.columns)
fy08fund09.head()
In [ ]:
fy08pgm = pd.read_csv("../RIDE/In$site/tbl_cd_In$ite_program.csv")
fy08pgm['Year'] = 2008
print(fy08pgm.shape)
print(fy08pgm.columns)
fy08pgm.head()
In [ ]:
fy08l01 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy01_08.csv")
fy08l01['Year'] = 2008
print(fy08l01.shape)
print(fy08l01.columns)
fy08l01.head()
In [ ]:
fy08l02 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy02_08.csv")
fy08l02['Year'] = 2008
print(fy08l02.shape)
print(fy08l02.columns)
fy08l02.head()
In [ ]:
fy08d = pd.read_csv("../RIDE/In$site/tbl_cd_district_08.csv")
fy08d['Year'] = 2008
print(fy08d.shape)
print(fy08d.columns)
fy08d.head()
In [ ]:
fy08l03 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy03_08.csv")
fy08l03['Year'] = 2008
print(fy08l03.shape)
print(fy08l03.columns)
fy08l03.head()
In [ ]:
fy08l04 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy04_08.csv")
fy08l04['Year'] = 2008
print(fy08l04.shape)
print(fy08l04.columns)
fy08l04.head()
In [ ]:
fy08l05 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy05_08.csv")
fy08l05['Year'] = 2008
print(fy08l05.shape)
print(fy08l05.columns)
fy08l05.head()
In [ ]:
fy08l06 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy06_08.csv")
fy08l06['Year'] = 2008
print(fy08l06.shape)
print(fy08l06.columns)
fy08l06.head()
In [ ]:
fy08l07 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy07_08.csv")
fy08l07['Year'] = 2008
print(fy08l07.shape)
print(fy08l07.columns)
fy08l07.head()
In [ ]:
fy08l08 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy08_08.csv")
fy08l08['Year'] = 2008
print(fy08l08.shape)
print(fy08l08.columns)
fy08l08.head()
In [ ]:
fy08l09 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy09_08.csv")
fy08l09['Year'] = 2008
print(fy08l09.shape)
print(fy08l09.columns)
fy08l09.head()
In [ ]:
fy08l10 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy10_08.csv")
fy08l10['Year'] = 2008
print(fy08l10.shape)
print(fy08l10.columns)
fy08l10.head()
In [ ]:
fy08pgm = pd.read_csv("../RIDE/In$site/tbl_cd_program_08.csv")
fy08pgm['Year'] = 2008
print(fy08pgm.shape)
print(fy08pgm.columns)
fy08pgm.head()
In [ ]:
fy08progX = pd.read_csv("../RIDE/In$site/tbl_cd_progX_08.csv")
fy08progX['Year'] = 2008
print(fy08progX.shape)
print(fy08progX.columns)
fy08progX.head()
In [ ]:
fy08ld09 = pd.read_csv("../RIDE/In$site/tbl_legacy_detail_08.csv")
fy08ld09['Year'] = 2008
print(fy08ld09.shape)
print(fy08ld09.columns)
fy08ld09.head()
In [ ]:
fy08loc = pd.read_csv("../RIDE/In$site/tbl_location_08.csv")
fy08loc['Year'] = 2008
print(fy08loc.shape)
print(fy08loc.columns)
fy08loc.head()
In [ ]:
fy08enr = pd.read_csv("../RIDE/In$site/tbl_loc_pgm_enrollment_08.csv")
fy08enr['Year'] = 2008
print(fy08enr.shape)
print(fy08enr.columns)
fy08enr.head()
In [ ]:
fy08sum = pd.read_csv("../RIDE/In$site/tbl_summary_08.csv")
fy08sum['Year'] = 2008
print(fy08sum.shape)
print(fy08sum.columns)
fy08sum.head()
In [ ]:
fy09EG = fy09sum.loc[fy09sum['district_id']==9]
fy09EG.shape
In [ ]:
fy09EG.groupby(fy09EG['Year']).sum()
In [ ]:
fy08sum = pd.read_csv("../RIDE/In$site/tbl_summary_08.csv")
fy08sum['Year'] = 2008
print(fy08sum.shape)
print(fy08sum.columns)
fy08sum.head()

2007

In [ ]:
fy07sb = pd.read_csv("../RIDE/In$site/Switchboard_Items_07.csv")
fy07sb['Year'] = 2007
print(fy07sb.shape)
print(fy07sb.columns)
fy07sb.head()
In [ ]:
fy07ac = pd.read_csv("../RIDE/In$site/tbl_alloc_categories_07.csv")
fy07ac['Year'] = 2007
print(fy07ac.shape)
print(fy07ac.columns)
fy07ac.head()
In [ ]:
fy07d = pd.read_csv("../RIDE/In$site/tbl_cd_district_07.csv")
fy07d['Year'] = 2007
print(fy07d.shape)
print(fy07d.columns)
fy07d.head()
In [ ]:
fy07el = pd.read_csv("../RIDE/In$site/tbl_cd_ed_level_07.csv")
fy07el['Year'] = 2007
print(fy07el.shape)
print(fy07el.columns)
fy07el.head()
In [ ]:
fy07f09 = pd.read_csv("../RIDE/In$site/tbl_cd_function_07.csv")
fy07f09['Year'] = 2007
print(fy07f09.shape)
print(fy07f09.columns)
fy07f09.head()
In [ ]:
fy07fX09 = pd.read_csv("../RIDE/In$site/tbl_cd_funcX_07.csv")
fy07fX09['Year'] = 2007
print(fy07fX09.shape)
print(fy07fX09.columns)
fy07fX09.head()
In [ ]:
fy07fund09 = pd.read_csv("../RIDE/In$site/tbl_cd_fund_07.csv")
fy07fund09['Year'] = 2007
print(fy07fund09.shape)
print(fy07fund09.columns)
fy07fund09.head()
In [ ]:
fy07pgm = pd.read_csv("../RIDE/In$site/tbl_cd_In$ite_program.csv")
fy07pgm['Year'] = 2007
print(fy07pgm.shape)
print(fy07pgm.columns)
fy07pgm.head()
In [ ]:
fy07l01 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy01_07.csv")
fy07l01['Year'] = 2007
print(fy07l01.shape)
print(fy07l01.columns)
fy07l01.head()
In [ ]:
fy07l02 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy02_07.csv")
fy07l02['Year'] = 2007
print(fy07l02.shape)
print(fy07l02.columns)
fy07l02.head()
In [ ]:
fy07d = pd.read_csv("../RIDE/In$site/tbl_cd_district_07.csv")
fy07d['Year'] = 2007
print(fy07d.shape)
print(fy07d.columns)
fy07d.head()
In [ ]:
fy07l03 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy03_07.csv")
fy07l03['Year'] = 2007
print(fy07l03.shape)
print(fy07l03.columns)
fy07l03.head()
In [ ]:
fy07l04 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy04_07.csv")
fy07l04['Year'] = 2007
print(fy07l04.shape)
print(fy07l04.columns)
fy07l04.head()
In [ ]:
fy07l05 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy05_07.csv")
fy07l05['Year'] = 2007
print(fy07l05.shape)
print(fy07l05.columns)
fy07l05.head()
In [ ]:
fy07l06 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy06_07.csv")
fy07l06['Year'] = 2007
print(fy07l06.shape)
print(fy07l06.columns)
fy07l06.head()
In [ ]:
fy07l07 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy07_07.csv")
fy07l07['Year'] = 2007
print(fy07l07.shape)
print(fy07l07.columns)
fy07l07.head()
In [ ]:
fy07l08 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy08_07.csv")
fy07l08['Year'] = 2007
print(fy07l08.shape)
print(fy07l08.columns)
fy07l08.head()
In [ ]:
fy07l09 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy09_07.csv")
fy07l09['Year'] = 2007
print(fy07l09.shape)
print(fy07l09.columns)
fy07l09.head()
In [ ]:
fy07l10 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy10_07.csv")
fy07l10['Year'] = 2007
print(fy07l10.shape)
print(fy07l10.columns)
fy07l10.head()
In [ ]:
fy07pgm = pd.read_csv("../RIDE/In$site/tbl_cd_program_07.csv")
fy07pgm['Year'] = 2007
print(fy07pgm.shape)
print(fy07pgm.columns)
fy07pgm.head()
In [ ]:
fy07progX = pd.read_csv("../RIDE/In$site/tbl_cd_progX_07.csv")
fy07progX['Year'] = 2007
print(fy07progX.shape)
print(fy07progX.columns)
fy07progX.head()
In [ ]:
fy07ld09 = pd.read_csv("../RIDE/In$site/tbl_legacy_detail_07.csv")
fy07ld09['Year'] = 2007
print(fy07ld09.shape)
print(fy07ld09.columns)
fy07ld09.head()
In [ ]:
fy07loc = pd.read_csv("../RIDE/In$site/tbl_location_07.csv")
fy07loc['Year'] = 2007
print(fy07loc.shape)
print(fy07loc.columns)
fy07loc.head()
In [ ]:
fy07enr = pd.read_csv("../RIDE/In$site/tbl_loc_pgm_enrollment_07.csv")
fy07enr['Year'] = 2007
print(fy07enr.shape)
print(fy07enr.columns)
fy07enr.head()
In [ ]:
fy07sum = pd.read_csv("../RIDE/In$site/tbl_summary_07.csv")
fy07sum['Year'] = 2007
print(fy07sum.shape)
print(fy07sum.columns)
fy07sum.head()

2006

In [ ]:
fy06sb = pd.read_csv("../RIDE/In$site/Switchboard_Items_06.csv")
fy06sb['Year'] = 2006
print(fy06sb.shape)
print(fy06sb.columns)
fy06sb.head()
In [ ]:
fy06ac = pd.read_csv("../RIDE/In$site/tbl_alloc_categories_06.csv")
fy06ac['Year'] = 2006
print(fy06ac.shape)
print(fy06ac.columns)
fy06ac.head()
In [ ]:
fy06d = pd.read_csv("../RIDE/In$site/tbl_cd_district_06.csv")
fy06d['Year'] = 2006
print(fy06d.shape)
print(fy06d.columns)
fy06d.head()
In [ ]:
fy06el = pd.read_csv("../RIDE/In$site/tbl_cd_ed_level_06.csv")
fy06el['Year'] = 2006
print(fy06el.shape)
print(fy06el.columns)
fy06el.head()
In [ ]:
fy06f09 = pd.read_csv("../RIDE/In$site/tbl_cd_function_06.csv")
fy06f09['Year'] = 2006
print(fy06f09.shape)
print(fy06f09.columns)
fy06f09.head()
In [ ]:
fy06fX09 = pd.read_csv("../RIDE/In$site/tbl_cd_funcX_06.csv")
fy06fX09['Year'] = 2006
print(fy06fX09.shape)
print(fy06fX09.columns)
fy06fX09.head()
In [ ]:
fy06fund09 = pd.read_csv("../RIDE/In$site/tbl_cd_fund_06.csv")
fy06fund09['Year'] = 2006
print(fy06fund09.shape)
print(fy06fund09.columns)
fy06fund09.head()
In [ ]:
fy06pgm = pd.read_csv("../RIDE/In$site/tbl_cd_In$ite_program.csv")
fy06pgm['Year'] = 2006
print(fy06pgm.shape)
print(fy06pgm.columns)
fy06pgm.head()
In [ ]:
fy06l01 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy01_06.csv")
fy06l01['Year'] = 2006
print(fy06l01.shape)
print(fy06l01.columns)
fy06l01.head()
In [ ]:
fy06l02 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy02_06.csv")
fy06l02['Year'] = 2006
print(fy06l02.shape)
print(fy06l02.columns)
fy06l02.head()
In [ ]:
fy06d = pd.read_csv("../RIDE/In$site/tbl_cd_district_06.csv")
fy06d['Year'] = 2006
print(fy06d.shape)
print(fy06d.columns)
fy06d.head()
In [ ]:
fy06l03 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy03_06.csv")
fy06l03['Year'] = 2006
print(fy06l03.shape)
print(fy06l03.columns)
fy06l03.head()
In [ ]:
fy06l04 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy04_06.csv")
fy06l04['Year'] = 2006
print(fy06l04.shape)
print(fy06l04.columns)
fy06l04.head()
In [ ]:
fy06l05 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy05_06.csv")
fy06l05['Year'] = 2006
print(fy06l05.shape)
print(fy06l05.columns)
fy06l05.head()
In [ ]:
fy06l06 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy06_06.csv")
fy06l06['Year'] = 2006
print(fy06l06.shape)
print(fy06l06.columns)
fy06l06.head()
In [ ]:
fy06l07 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy07_06.csv")
fy06l07['Year'] = 2006
print(fy06l07.shape)
print(fy06l07.columns)
fy06l07.head()
In [ ]:
fy06l08 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy08_06.csv")
fy06l08['Year'] = 2006
print(fy06l08.shape)
print(fy06l08.columns)
fy06l08.head()
In [ ]:
fy06l09 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy09_06.csv")
fy06l09['Year'] = 2006
print(fy06l09.shape)
print(fy06l09.columns)
fy06l09.head()
In [ ]:
fy06l10 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy10_06.csv")
fy06l10['Year'] = 2006
print(fy06l10.shape)
print(fy06l10.columns)
fy06l10.head()
In [ ]:
fy06pgm = pd.read_csv("../RIDE/In$site/tbl_cd_program_06.csv")
fy06pgm['Year'] = 2006
print(fy06pgm.shape)
print(fy06pgm.columns)
fy06pgm.head()
In [ ]:
fy06progX = pd.read_csv("../RIDE/In$site/tbl_cd_progX_06.csv")
fy06progX['Year'] = 2006
print(fy06progX.shape)
print(fy06progX.columns)
fy06progX.head()
In [ ]:
fy06ld09 = pd.read_csv("../RIDE/In$site/tbl_legacy_detail_06.csv")
fy06ld09['Year'] = 2006
print(fy06ld09.shape)
print(fy06ld09.columns)
fy06ld09.head()
In [ ]:
fy06loc = pd.read_csv("../RIDE/In$site/tbl_location_06.csv")
fy06loc['Year'] = 2006
print(fy06loc.shape)
print(fy06loc.columns)
fy06loc.head()
In [ ]:
fy06enr = pd.read_csv("../RIDE/In$site/tbl_loc_pgm_enrollment_06.csv")
fy06enr['Year'] = 2006
print(fy06enr.shape)
print(fy06enr.columns)
fy06enr.head()
In [ ]:
fy06sum = pd.read_csv("../RIDE/In$site/tbl_summary_06.csv")
fy06sum['Year'] = 2006
print(fy06sum.shape)
print(fy06sum.columns)
fy06sum.head()

2005

In [ ]:
fy05sb = pd.read_csv("../RIDE/In$site/Switchboard_Items_05.csv")
fy05sb['Year'] = 2005
print(fy05sb.shape)
print(fy05sb.columns)
fy05sb.head()
In [ ]:
fy05ac = pd.read_csv("../RIDE/In$site/tbl_alloc_categories_05.csv")
fy05ac['Year'] = 2005
print(fy05ac.shape)
print(fy05ac.columns)
fy05ac.head()
In [ ]:
fy05d = pd.read_csv("../RIDE/In$site/tbl_cd_district_05.csv")
fy05d['Year'] = 2005
print(fy05d.shape)
print(fy05d.columns)
fy05d.head()
In [ ]:
fy05el = pd.read_csv("../RIDE/In$site/tbl_cd_ed_level_05.csv")
fy05el['Year'] = 2005
print(fy05el.shape)
print(fy05el.columns)
fy05el.head()
In [ ]:
fy05f09 = pd.read_csv("../RIDE/In$site/tbl_cd_function_05.csv")
fy05f09['Year'] = 2005
print(fy05f09.shape)
print(fy05f09.columns)
fy05f09.head()
In [ ]:
fy05fX09 = pd.read_csv("../RIDE/In$site/tbl_cd_funcX_05.csv")
fy05fX09['Year'] = 2005
print(fy05fX09.shape)
print(fy05fX09.columns)
fy05fX09.head()
In [ ]:
fy05fund09 = pd.read_csv("../RIDE/In$site/tbl_cd_fund_05.csv")
fy05fund09['Year'] = 2005
print(fy05fund09.shape)
print(fy05fund09.columns)
fy05fund09.head()
In [ ]:
fy05pgm = pd.read_csv("../RIDE/In$site/tbl_cd_In$ite_program.csv")
fy05pgm['Year'] = 2005
print(fy05pgm.shape)
print(fy05pgm.columns)
fy05pgm.head()
In [ ]:
fy05l01 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy01_05.csv")
fy05l01['Year'] = 2005
print(fy05l01.shape)
print(fy05l01.columns)
fy05l01.head()
In [ ]:
fy05l02 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy02_05.csv")
fy05l02['Year'] = 2005
print(fy05l02.shape)
print(fy05l02.columns)
fy05l02.head()
In [ ]:
fy05d = pd.read_csv("../RIDE/In$site/tbl_cd_district_05.csv")
fy05d['Year'] = 2005
print(fy05d.shape)
print(fy05d.columns)
fy05d.head()
In [ ]:
fy05l03 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy03_05.csv")
fy05l03['Year'] = 2005
print(fy05l03.shape)
print(fy05l03.columns)
fy05l03.head()
In [ ]:
fy05l04 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy04_05.csv")
fy05l04['Year'] = 2005
print(fy05l04.shape)
print(fy05l04.columns)
fy05l04.head()
In [ ]:
fy05l05 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy05_05.csv")
fy05l05['Year'] = 2005
print(fy05l05.shape)
print(fy05l05.columns)
fy05l05.head()
In [ ]:
fy05l06 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy06_05.csv")
fy05l06['Year'] = 2005
print(fy05l06.shape)
print(fy05l06.columns)
fy05l06.head()
In [ ]:
fy05l07 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy07_05.csv")
fy05l07['Year'] = 2005
print(fy05l07.shape)
print(fy05l07.columns)
fy05l07.head()
In [ ]:
fy05l08 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy08_05.csv")
fy05l08['Year'] = 2005
print(fy05l08.shape)
print(fy05l08.columns)
fy05l08.head()
In [ ]:
fy05l09 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy09_05.csv")
fy05l09['Year'] = 2005
print(fy05l09.shape)
print(fy05l09.columns)
fy05l09.head()
In [ ]:
fy05l10 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy10_05.csv")
fy05l10['Year'] = 2005
print(fy05l10.shape)
print(fy05l10.columns)
fy05l10.head()
In [ ]:
fy05pgm = pd.read_csv("../RIDE/In$site/tbl_cd_program_05.csv")
fy05pgm['Year'] = 2005
print(fy05pgm.shape)
print(fy05pgm.columns)
fy05pgm.head()
In [ ]:
fy05progX = pd.read_csv("../RIDE/In$site/tbl_cd_progX_05.csv")
fy05progX['Year'] = 2005
print(fy05progX.shape)
print(fy05progX.columns)
fy05progX.head()
In [ ]:
fy05ld09 = pd.read_csv("../RIDE/In$site/tbl_legacy_detail_05.csv")
fy05ld09['Year'] = 2005
print(fy05ld09.shape)
print(fy05ld09.columns)
fy05ld09.head()
In [ ]:
fy05loc = pd.read_csv("../RIDE/In$site/tbl_location_05.csv")
fy05loc['Year'] = 2005
print(fy05loc.shape)
print(fy05loc.columns)
fy05loc.head()
In [ ]:
fy05enr = pd.read_csv("../RIDE/In$site/tbl_loc_pgm_enrollment_05.csv")
fy05enr['Year'] = 2005
print(fy05enr.shape)
print(fy05enr.columns)
fy05enr.head()
In [ ]:
fy05sum = pd.read_csv("../RIDE/In$site/tbl_summary_05.csv")
fy05sum['Year'] = 2005
print(fy05sum.shape)
print(fy05sum.columns)
fy05sum.head()

FY2004

In [ ]:
fy04sb = pd.read_csv("../RIDE/In$site/Switchboard_Items_04.csv")
fy04sb['Year'] = 2004
print(fy04sb.shape)
print(fy04sb.columns)
fy04sb.head()
In [ ]:
fy04ac = pd.read_csv("../RIDE/In$site/tbl_alloc_categories_04.csv")
fy04ac['Year'] = 2004
print(fy04ac.shape)
print(fy04ac.columns)
fy04ac.head()
In [ ]:
fy04d = pd.read_csv("../RIDE/In$site/tbl_cd_district_04.csv")
fy04d['Year'] = 2004
print(fy04d.shape)
print(fy04d.columns)
fy04d.head()
In [ ]:
fy04el = pd.read_csv("../RIDE/In$site/tbl_cd_ed_level_04.csv")
fy04el['Year'] = 2004
print(fy04el.shape)
print(fy04el.columns)
fy04el.head()
In [ ]:
fy04f09 = pd.read_csv("../RIDE/In$site/tbl_cd_function_04.csv")
fy04f09['Year'] = 2004
print(fy04f09.shape)
print(fy04f09.columns)
fy04f09.head()
In [ ]:
fy04fX09 = pd.read_csv("../RIDE/In$site/tbl_cd_funcX_04.csv")
fy04fX09['Year'] = 2004
print(fy04fX09.shape)
print(fy04fX09.columns)
fy04fX09.head()
In [ ]:
fy04fund09 = pd.read_csv("../RIDE/In$site/tbl_cd_fund_04.csv")
fy04fund09['Year'] = 2004
print(fy04fund09.shape)
print(fy04fund09.columns)
fy04fund09.head()
In [ ]:
fy04pgm = pd.read_csv("../RIDE/In$site/tbl_cd_In$ite_program.csv")
fy04pgm['Year'] = 2004
print(fy04pgm.shape)
print(fy04pgm.columns)
fy04pgm.head()
In [ ]:
fy04l01 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy01_04.csv")
fy04l01['Year'] = 2004
print(fy04l01.shape)
print(fy04l01.columns)
fy04l01.head()
In [ ]:
fy04l02 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy02_04.csv")
fy04l02['Year'] = 2004
print(fy04l02.shape)
print(fy04l02.columns)
fy04l02.head()
In [ ]:
fy04d = pd.read_csv("../RIDE/In$site/tbl_cd_district_04.csv")
fy04d['Year'] = 2004
print(fy04d.shape)
print(fy04d.columns)
fy04d.head()
In [ ]:
fy04l03 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy03_04.csv")
fy04l03['Year'] = 2004
print(fy04l03.shape)
print(fy04l03.columns)
fy04l03.head()
In [ ]:
fy04l04 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy04_04.csv")
fy04l04['Year'] = 2004
print(fy04l04.shape)
print(fy04l04.columns)
fy04l04.head()
In [ ]:
fy04l05 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy05_04.csv")
fy04l05['Year'] = 2004
print(fy04l05.shape)
print(fy04l05.columns)
fy04l05.head()
In [ ]:
fy04l06 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy06_04.csv")
fy04l06['Year'] = 2004
print(fy04l06.shape)
print(fy04l06.columns)
fy04l06.head()
In [ ]:
fy04l07 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy07_04.csv")
fy04l07['Year'] = 2004
print(fy04l07.shape)
print(fy04l07.columns)
fy04l07.head()
In [ ]:
fy04l08 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy08_04.csv")
fy04l08['Year'] = 2004
print(fy04l08.shape)
print(fy04l08.columns)
fy04l08.head()
In [ ]:
fy04l09 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy09_04.csv")
fy04l09['Year'] = 2004
print(fy04l09.shape)
print(fy04l09.columns)
fy04l09.head()
In [ ]:
fy04l10 = pd.read_csv("../RIDE/In$site/tbl_cd_legacy10_04.csv")
fy04l10['Year'] = 2004
print(fy04l10.shape)
print(fy04l10.columns)
fy04l10.head()
In [ ]:
fy04pgm = pd.read_csv("../RIDE/In$site/tbl_cd_program_04.csv")
fy04pgm['Year'] = 2004
print(fy04pgm.shape)
print(fy04pgm.columns)
fy04pgm.head()
In [ ]:
fy04progX = pd.read_csv("../RIDE/In$site/tbl_cd_progX_04.csv")
fy04progX['Year'] = 2004
print(fy04progX.shape)
print(fy04progX.columns)
fy04progX.head()
In [ ]:
fy04ld09 = pd.read_csv("../RIDE/In$site/tbl_legacy_detail_04.csv")
fy04ld09['Year'] = 2004
print(fy04ld09.shape)
print(fy04ld09.columns)
fy04ld09.head()
In [ ]:
fy04loc = pd.read_csv("../RIDE/In$site/tbl_location_04.csv")
fy04loc['Year'] = 2004
print(fy04loc.shape)
print(fy04loc.columns)
fy04loc.head()
In [ ]:
fy04enr = pd.read_csv("../RIDE/In$site/tbl_loc_pgm_enrollment_04.csv")
fy04enr['Year'] = 2004
print(fy04enr.shape)
print(fy04enr.columns)
fy04enr.head()
In [ ]:
fy04sum = pd.read_csv("../RIDE/In$site/tbl_summary_04.csv")
fy04sum['Year'] = 2004
print(fy04sum.shape)
print(fy04sum.columns)
fy04sum.head()

FY2003

In [ ]:
fy03sb = pd.read_csv("../RIDE/In$site/Switchboard_Items_03.csv")
fy03sb['Year'] = 2003
print(fy03sb.shape)
print(fy03sb.columns)
fy03sb.head()
In [ ]:
fy03ac = pd.read_csv("../RIDE/In$site/tbl_fr2_categories_03.csv")
fy03ac['Year'] = 2003
print(fy03ac.shape)
print(fy03ac.columns)
fy03ac.head()
In [ ]:
fy03d = pd.read_csv("../RIDE/In$site/tbl_cd_district_03.csv")
fy03d['Year'] = 2003
print(fy03d.shape)
print(fy03d.columns)
fy03d.head()
In [ ]:
fy03el = pd.read_csv("../RIDE/In$site/tbl_cd_ed_level_03.csv")
fy03el['Year'] = 2003
print(fy03el.shape)
print(fy03el.columns)
fy03el.head()
In [ ]:
fy03f09 = pd.read_csv("../RIDE/In$site/tbl_cd_function_03.csv")
fy03f09['Year'] = 2003
print(fy03f09.shape)
print(fy03f09.columns)
fy03f09.head()
In [ ]:
fy03fund09 = pd.read_csv("../RIDE/In$site/tbl_cd_fund_03.csv")
fy03fund09['Year'] = 2003
print(fy03fund09.shape)
print(fy03fund09.columns)
fy03fund09.head()
In [ ]:
fy03pgm = pd.read_csv("../RIDE/In$site/tbl_cd_In$ite_program.csv")
fy03pgm['Year'] = 2003
print(fy03pgm.shape)
print(fy03pgm.columns)
fy03pgm.head()
In [ ]:
fy03pgm = pd.read_csv("../RIDE/In$site/tbl_cd_program_03.csv")
fy03pgm['Year'] = 2003
print(fy03pgm.shape)
print(fy03pgm.columns)
fy03pgm.head()
In [ ]:
fy03ld09 = pd.read_csv("../RIDE/In$site/tbl_legacy_detail_03.csv")
fy03ld09['Year'] = 2003
print(fy03ld09.shape)
print(fy03ld09.columns)
fy03ld09.head()
In [ ]:
fy03loc = pd.read_csv("../RIDE/In$site/tbl_location_03.csv")
fy03loc['Year'] = 2003
print(fy03loc.shape)
print(fy03loc.columns)
fy03loc.head()
In [ ]:
fy03enr = pd.read_csv("../RIDE/In$site/tbl_loc_pgm_enrollment_03.csv")
fy03enr['Year'] = 2003
print(fy03enr.shape)
print(fy03enr.columns)
fy03enr.head()
In [ ]:
fy03sum = pd.read_csv("../RIDE/In$site/tbl_summary_03.csv")
fy03sum['Year'] = 2003
print(fy03sum.shape)
print(fy03sum.columns)
fy03sum.head()

FY2002

In [ ]:
fy02d = pd.read_csv("../RIDE/In$site/tbl_cd_district_02.csv")
fy02d['Year'] = 2002
print(fy02d.shape)
print(fy02d.columns)
fy02d.head()
In [ ]:
fy02el = pd.read_csv("../RIDE/In$site/tbl_cd_ed_level_02.csv")
fy02el['Year'] = 2002
print(fy02el.shape)
print(fy02el.columns)
fy02el.head()
In [ ]:
fy02f09 = pd.read_csv("../RIDE/In$site/tbl_cd_function_02.csv")
fy02f09['Year'] = 2002
print(fy02f09.shape)
print(fy02f09.columns)
fy02f09.head()
In [ ]:
fy02fund09 = pd.read_csv("../RIDE/In$site/tbl_cd_fund_02.csv")
fy02fund09['Year'] = 2002
print(fy02fund09.shape)
print(fy02fund09.columns)
fy02fund09.head()
In [ ]:
fy02pgm = pd.read_csv("../RIDE/In$site/tbl_cd_In$ite_program.csv")
fy02pgm['Year'] = 2002
print(fy02pgm.shape)
print(fy02pgm.columns)
fy02pgm.head()
In [ ]:
fy02d = pd.read_csv("../RIDE/In$site/tbl_cd_district_02.csv")
fy02d['Year'] = 2002
print(fy02d.shape)
print(fy02d.columns)
fy02d.head()
In [ ]:
fy02pgm = pd.read_csv("../RIDE/In$site/tbl_cd_program_02.csv")
fy02pgm['Year'] = 2002
print(fy02pgm.shape)
print(fy02pgm.columns)
fy02pgm.head()
In [ ]:
fy02ld09 = pd.read_csv("../RIDE/In$site/tbl_legacy_detail_02.csv")
fy02ld09['Year'] = 2002
print(fy02ld09.shape)
print(fy02ld09.columns)
fy02ld09.head()
In [ ]:
fy02loc = pd.read_csv("../RIDE/In$site/tbl_location_02.csv")
fy02loc['Year'] = 2002
print(fy02loc.shape)
print(fy02loc.columns)
fy02loc.head()
In [ ]:
fy02enr = pd.read_csv("../RIDE/In$site/tbl_loc_pgm_enrollment_02.csv")
fy02enr['Year'] = 2002
print(fy02enr.shape)
print(fy02enr.columns)
fy02enr.head()
In [ ]:
fy02sum = pd.read_csv("../RIDE/In$site/tbl_summary_02.csv")
fy02sum['Year'] = 2002
print(fy02sum.shape)
print(fy02sum.columns)
fy02sum.head()
In [ ]:
fy09EG = fy09sum.loc[fy09sum['district_id']==9]
fy09EG.shape
In [ ]:
fy09EG.groupby(fy09EG['Year']).sum()
In [ ]:
fy02sum = pd.read_csv("../RIDE/In$site/tbl_summary_08.csv")
fy02sum['Year'] = 2008
print(fy02sum.shape)
print(fy02sum.columns)
fy02sum.head()
In [ ]:
fy09EG = fy09sum.loc[fy09sum['district_id']==9]
fy09EG.shape
In [ ]:
fy09EG.groupby(fy09EG['Year']).sum()
In [ ]:
fy02sum = pd.read_csv("../RIDE/In$site/tbl_summary_08.csv")
fy02sum['Year'] = 2008
print(fy02sum.shape)
print(fy02sum.columns)
fy02sum.head()
In [ ]:
ride_sums = pd.concat([fy09sum,fy08sum,fy07sum,fy06sum,fy05sum,fy04sum,fy03sum,fy02sum])
In [ ]:
len(fy02ld09)+len(fy03ld09)+len(fy04ld09)+len(fy05ld09)+len(fy06ld09)+len(fy07ld09)+len(fy08ld09)+len(fy03ld09)
In [ ]:
EG_sums = ride_sums.loc[ride_sums['district_id']==9]
EG_sums.shape
In [ ]:
EG_sums.groupby(EG_sums['Year']).sum()