#Import Libraries
import numpy as np
import pandas as pd
import geopandas as gpd
from shapely.geometry import Point, Polygon
import json
import requests
import math
import os
import time

# Edit library options
pd.set_option('display.max_columns', 50)

# Import folders
data_folder = os.path.abspath('data')
# Set Output Folder
output_folder = os.path.abspath("output")
if not os.path.exists(output_folder):
    os.makedirs(output_folder)

# Read Constituency Data
ac_gdf = None
ac_filepath = os.path.join(data_folder, "AC", "India_AC.shp")
ac_gdf = gpd.read_file(ac_filepath)
ac_gdf

# Read Constituency Data
ac_file = os.path.join(data_folder, "General_Later_Ashoka_alldata.csv")
acdf = pd.read_csv(ac_file)
acdf['state_name'] = acdf['state_name'].str.replace("_", " ")
#acdf = acdf[['state_name', 'constituency_no', 'constituency_name', 'year', 'month']]
acdf = acdf.drop_duplicates(subset=None, keep="first", inplace=False).reset_index(drop=True)
acdf.loc[acdf['newstate_code'] == 36, 'newstate_code'] = 28 #Telangana  Fix
acdf = acdf[['state_name', 'state_code', 'constituency_no', 'year', 'month']]
acdf['day'] = 1
acdf['dyear'] = 0
acdf.loc[(acdf['month'] > 9) | (acdf['year'] == 2008), 'dyear'] = 1
acdf['dyear'] = acdf['year'] + acdf['dyear']
acdf['datetime'] = pd.to_datetime(acdf[['year', 'month', 'day']])
acdf = acdf.drop_duplicates().reset_index(drop=True)
acdf = pd.merge(acdf, ac_gdf,  how='inner', left_on=['state_code', 'constituency_no'], right_on = ['ST_CODE','AC_NO'])#[['ST_CODE', 'ST_NAME','DT_CODE', 'DIST_NAME', 'AC_NO', 'AC_NAME', 'PC_NO', 'PC_NAME']]
acdf = acdf[acdf.columns[:-5]]
acdf

# Read School Data
sc_file = os.path.join(data_folder, "Schools_Joined.csv")
sc_df = pd.read_csv(sc_file)
sc_df

C:\Users\sandyjones\AppData\Local\conda\conda\envs\geo\lib\site-packages\IPython\core\interactiveshell.py:2785: DtypeWarning: Columns (6) have mixed types. Specify dtype option on import or set low_memory=False.
  interactivity=interactivity, compiler=compiler, result=result)

# Read General Data
gen_file = os.path.join(data_folder, "GeneralData.csv")
gen_df = pd.read_csv(gen_file, usecols=[0,3,4,7,8,9,23,24,27,28,32,33,])
merge_df = pd.merge(sc_df, gen_df, on=['SCHCD', 'AC_YEAR'], how='inner')
merge_df['dyear'] = merge_df['AC_YEAR'].str.split("-").str[0].astype(int)
merge_df = merge_df[merge_df['dyear'] > 2000]
merge_df

C:\Users\sandyjones\AppData\Local\conda\conda\envs\geo\lib\site-packages\IPython\core\interactiveshell.py:2785: DtypeWarning: Columns (23) have mixed types. Specify dtype option on import or set low_memory=False.
  interactivity=interactivity, compiler=compiler, result=result)

merge_df.shape[0]

2315406

variables = [
    'total_school',
    'total_school1',
    'total_school2',
    'total_school3',
    'total_school4',
    'total_school5',
    'state_govt_school',
    'state_govt_school1',
    'state_govt_school2',
    'state_govt_school3',
    'state_govt_school4',
    'state_govt_school5',
    'local_govt_school',
    'local_govt_school1',
    'local_govt_school2',
    'local_govt_school3',
    'local_govt_school4',
    'local_govt_school5',
    'local_govt_school5',
    'private_school',
    'private_school1',
    'private_school2',
    'private_school3',
    'private_school4',
    'private_school5',
    'schools_opened',
    'schools_opened1',
    'schools_opened2',
    'schools_opened3',
    'schools_opened4',
    'schools_opened5',
    'state_govt_schools_opened',
    'state_govt_schools_opened1',
    'state_govt_schools_opened2',
    'state_govt_schools_opened3',
    'state_govt_schools_opened4',
    'state_govt_schools_opened5',
    'local_govt_schools_opened',
    'local_govt_schools_opened1',
    'local_govt_schools_opened2',
    'local_govt_schools_opened3',
    'local_govt_schools_opened4',
    'local_govt_schools_opened5',
    'private_schools_opened',
    'private_schools_opened1',
    'private_schools_opened2',
    'private_schools_opened3',
    'private_schools_opened4',
    'private_schools_opened5',
    'state_govt_funds',
    'state_govt_funds1',
    'state_govt_funds2',
    'state_govt_funds3',
    'state_govt_funds4',
    'state_govt_funds5',
    'state_govt_reciepts',
    'state_govt_reciepts1',
    'state_govt_reciepts2',
    'state_govt_reciepts3',
    'state_govt_reciepts4',
    'state_govt_reciepts5',
    'state_govt_expenditure',
    'state_govt_expenditure1',
    'state_govt_expenditure2',
    'state_govt_expenditure3',
    'state_govt_expenditure4',
    'state_govt_expenditure5',
    'local_govt_funds',
    'local_govt_funds1',
    'local_govt_funds2',
    'local_govt_funds3',
    'local_govt_funds4',
    'local_govt_funds5',
    'local_govt_reciepts',
    'local_govt_reciepts1',
    'local_govt_reciepts2',
    'local_govt_reciepts3',
    'local_govt_reciepts4',
    'local_govt_reciepts5',
    'local_govt_expenditure',
    'local_govt_expenditure1',
    'local_govt_expenditure2',
    'local_govt_expenditure3',
    'local_govt_expenditure4',
    'local_govt_expenditure5',
    'private_funds',
    'private_funds1',
    'private_funds2',
    'private_funds3',
    'private_funds4',
    'private_funds5',
    'private_reciepts',
    'private_reciepts1',
    'private_reciepts2',
    'private_reciepts3',
    'private_reciepts4',
    'private_reciepts5',
    'private_expenditure',
    'private_expenditure1',
    'private_expenditure2',
    'private_expenditure3',
    'private_expenditure4',
    'private_expenditure5',
    'total_funds',
    'total_funds1',
    'total_funds2',
    'total_funds3',
    'total_funds4',
    'total_funds5',
    'total_reciepts',
    'total_reciepts1',
    'total_reciepts2',
    'total_reciepts3',
    'total_reciepts4',
    'total_reciepts5',
    'total_expenditure',
    'total_expenditure1',
    'total_expenditure2',
    'total_expenditure3',
    'total_expenditure4',
    'total_expenditure5',
]
#Get all variables
def get_ac_variables(row):
    #print(pd.DataFrame(row).T)
    next_elect = acdf[(acdf['state_code'] == row['state_code']) & (acdf['constituency_no'] == row['constituency_no']) & (acdf['datetime'] > row['datetime'])][0:1]
    if len(next_elect) < 1:
        next_elect = pd.DataFrame(row).T
        next_elect['dyear'] = next_elect['dyear'] + 5
        next_elect['datetime'] = next_elect['datetime'] + pd.DateOffset(years=5)
    #print(next_elect)
    #delta_year = math.floor((next_elect['datetime'].dt.year - row['datetime'].year)/5)
    delta_year = 1
    if not delta_year:
        delta_year = 1
    #print(delta_year)
    #Starting of Election Term
    try:
        df1 = merge_df[(merge_df['ST_CODE'] == row['state_code']) & (merge_df['AC_NO'] == row['constituency_no'])]
        
        df_count = df1[['SCHCD', 'ESTDYEAR']].drop_duplicates(subset=None, keep='first', inplace=False)
        total_school = df_count.shape[0]
        total_school1 = df_count[df_count['ESTDYEAR'] <= (row['dyear'] + delta_year-1)].shape[0]
        total_school2 = df_count[df_count['ESTDYEAR'] <= (row['dyear'] + delta_year+0)].shape[0]
        total_school3 = df_count[df_count['ESTDYEAR'] <= (row['dyear'] + delta_year+1)].shape[0]
        total_school4 = df_count[df_count['ESTDYEAR'] <= (row['dyear'] + delta_year+2)].shape[0]
        total_school5 = df_count[df_count['ESTDYEAR'] <= (row['dyear'] + delta_year+3)].shape[0]       
        df11 = df1[df1['SCHMGT'].isin([1, 2])][['SCHCD', 'ESTDYEAR']].drop_duplicates(subset=None, keep='first', inplace=False)
        state_govt_school = df11.shape[0]
        state_govt_school1 = df11[df11['ESTDYEAR'] <= (row['dyear'] + delta_year-1)].shape[0]
        state_govt_school2 = df11[df11['ESTDYEAR'] <= (row['dyear'] + delta_year+0)].shape[0]
        state_govt_school3 = df11[df11['ESTDYEAR'] <= (row['dyear'] + delta_year+1)].shape[0]
        state_govt_school4 = df11[df11['ESTDYEAR'] <= (row['dyear'] + delta_year+2)].shape[0]
        state_govt_school5 = df11[df11['ESTDYEAR'] <= (row['dyear'] + delta_year+3)].shape[0]
        df12 = df1[df1['SCHMGT'].isin([3])][['SCHCD', 'ESTDYEAR']].drop_duplicates(subset=None, keep='first', inplace=False)
        local_govt_school = df12['SCHCD'].shape[0]
        local_govt_school1 = df12[df12['ESTDYEAR'] <= (row['dyear'] + delta_year-1)].shape[0]
        local_govt_school2 = df12[df12['ESTDYEAR'] <= (row['dyear'] + delta_year+0)].shape[0]
        local_govt_school3 = df12[df12['ESTDYEAR'] <= (row['dyear'] + delta_year+1)].shape[0]
        local_govt_school4 = df12[df12['ESTDYEAR'] <= (row['dyear'] + delta_year+2)].shape[0]
        local_govt_school5 = df12[df12['ESTDYEAR'] <= (row['dyear'] + delta_year+3)].shape[0]
        df13 = df1[df1['SCHMGT'].isin([4,5])][['SCHCD', 'ESTDYEAR']].drop_duplicates(subset=None, keep='first', inplace=False)
        private_school = df13['SCHCD'].shape[0]
        private_school1 = df13[df13['ESTDYEAR'] <= (row['dyear'] + delta_year-1)].shape[0]
        private_school2 = df13[df13['ESTDYEAR'] <= (row['dyear'] + delta_year+0)].shape[0]
        private_school3 = df13[df13['ESTDYEAR'] <= (row['dyear'] + delta_year+1)].shape[0]
        private_school4 = df13[df13['ESTDYEAR'] <= (row['dyear'] + delta_year+2)].shape[0]
        private_school5 = df13[df13['ESTDYEAR'] <= (row['dyear'] + delta_year+3)].shape[0]
        
        df2 = df1[(merge_df['ESTDYEAR'] >= row['dyear']) & (merge_df['ESTDYEAR'] < next_elect['dyear'].values[0])]
        schools_opened = df2.shape[0]
        schools_opened1 = df2[df2['ESTDYEAR'] == (row['dyear'] + delta_year-1)].shape[0]
        schools_opened2 = df2[df2['ESTDYEAR'] == (row['dyear'] + delta_year+0)].shape[0]
        schools_opened3 = df2[df2['ESTDYEAR'] == (row['dyear'] + delta_year+0)].shape[0]
        schools_opened4 = df2[df2['ESTDYEAR'] == (row['dyear'] + delta_year+2)].shape[0]
        schools_opened5 = df2[df2['ESTDYEAR'] >= (row['dyear'] + delta_year+3)].shape[0]
               
        df3 = df1[(merge_df['dyear'] >= row['dyear']) & (merge_df['dyear'] < next_elect['dyear'].values[0])]
        #print(df3['dyear'])
        
        total_funds = df3["FUNDS_R"].sum()
        total_funds1 = df3[df3['dyear'] == (row['dyear'] + delta_year-1)]["FUNDS_R"].sum()
        total_funds2 = df3[df3['dyear'] == (row['dyear'] + delta_year+0)]["FUNDS_R"].sum()
        total_funds3 = df3[df3['dyear'] == (row['dyear'] + delta_year+1)]["FUNDS_R"].sum()
        total_funds4 = df3[df3['dyear'] == (row['dyear'] + delta_year+2)]["FUNDS_R"].sum()
        total_funds5 = df3[df3['dyear'] >= (row['dyear'] + delta_year+3)]["FUNDS_R"].sum()
        
        total_reciepts = df3[["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        total_reciepts1 = df3[df3['dyear'] == (row['dyear'] + delta_year-1)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        total_reciepts2 = df3[df3['dyear'] == (row['dyear'] + delta_year+0)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        total_reciepts3 = df3[df3['dyear'] == (row['dyear'] + delta_year+1)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        total_reciepts4 = df3[df3['dyear'] == (row['dyear'] + delta_year+2)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        total_reciepts5 = df3[df3['dyear'] >= (row['dyear'] + delta_year+3)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        
        total_expenditure = df3[["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        total_expenditure1 = df3[df3['dyear'] == (row['dyear'] + delta_year-1)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        total_expenditure2 = df3[df3['dyear'] == (row['dyear'] + delta_year+0)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        total_expenditure3 = df3[df3['dyear'] == (row['dyear'] + delta_year+1)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        total_expenditure4 = df3[df3['dyear'] == (row['dyear'] + delta_year+2)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        total_expenditure5 = df3[df3['dyear'] >= (row['dyear'] + delta_year+3)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        
        df4 = df3[df3['SCHMGT'].isin([1, 2])]
            
        state_govt_schools_opened = df4[(df4['ESTDYEAR'] >= row['dyear']) & (df4['ESTDYEAR'] < next_elect['dyear'].values[0])].shape[0]
        state_govt_schools_opened1 = df4[df4['ESTDYEAR'] == (row['dyear'] + delta_year-1)].shape[0]
        state_govt_schools_opened2 = df4[df4['ESTDYEAR'] == (row['dyear'] + delta_year+0)].shape[0]
        state_govt_schools_opened3 = df4[df4['ESTDYEAR'] == (row['dyear'] + delta_year+0)].shape[0]
        state_govt_schools_opened4 = df4[df4['ESTDYEAR'] == (row['dyear'] + delta_year+2)].shape[0]
        state_govt_schools_opened5 = df4[df4['ESTDYEAR'] >= (row['dyear'] + delta_year+3)].shape[0]
        
        state_govt_funds = df4["FUNDS_R"].sum()
        state_govt_funds1 = df4[df4['dyear'] == (row['dyear'] + delta_year-1)]["FUNDS_R"].sum()
        state_govt_funds2 = df4[df4['dyear'] == (row['dyear'] + delta_year+0)]["FUNDS_R"].sum()
        state_govt_funds3 = df4[df4['dyear'] == (row['dyear'] + delta_year+1)]["FUNDS_R"].sum()
        state_govt_funds4 = df4[df4['dyear'] == (row['dyear'] + delta_year+2)]["FUNDS_R"].sum()
        state_govt_funds5 = df4[df4['dyear'] >= (row['dyear'] + delta_year+3)]["FUNDS_R"].sum()
        
        state_govt_reciepts = df4[["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        state_govt_reciepts1 = df4[df4['dyear'] == (row['dyear'] + delta_year-1)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        state_govt_reciepts2 = df4[df4['dyear'] == (row['dyear'] + delta_year+0)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        state_govt_reciepts3 = df4[df4['dyear'] == (row['dyear'] + delta_year+1)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        state_govt_reciepts4 = df4[df4['dyear'] == (row['dyear'] + delta_year+2)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        state_govt_reciepts5 = df4[df4['dyear'] >= (row['dyear'] + delta_year+3)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
 
        state_govt_expenditure = df4[["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        state_govt_expenditure1 = df4[df4['dyear'] == (row['dyear'] + delta_year-1)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        state_govt_expenditure2 = df4[df4['dyear'] == (row['dyear'] + delta_year+0)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        state_govt_expenditure3 = df4[df4['dyear'] == (row['dyear'] + delta_year+1)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        state_govt_expenditure4 = df4[df4['dyear'] == (row['dyear'] + delta_year+2)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        state_govt_expenditure5 = df4[df4['dyear'] >= (row['dyear'] + delta_year+3)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        
        df5 = df3[df3['SCHMGT'].isin([3])]
             
        local_govt_schools_opened = df5[(df5['ESTDYEAR'] >= row['dyear']) & (df4['ESTDYEAR'] < next_elect['dyear'].values[0])].shape[0]
        local_govt_schools_opened1 = df5[df5['ESTDYEAR'] == (row['dyear'] + delta_year-1)].shape[0]
        local_govt_schools_opened2 = df5[df5['ESTDYEAR'] == (row['dyear'] + delta_year+0)].shape[0]
        local_govt_schools_opened3 = df5[df5['ESTDYEAR'] == (row['dyear'] + delta_year+0)].shape[0]
        local_govt_schools_opened4 = df5[df5['ESTDYEAR'] == (row['dyear'] + delta_year+2)].shape[0]
        local_govt_schools_opened5 = df5[df5['ESTDYEAR'] >= (row['dyear'] + delta_year+3)].shape[0]
        
        local_govt_funds = df5["FUNDS_R"].sum()
        local_govt_funds1 = df5[df5['dyear'] == (row['dyear'] + delta_year-1)]["FUNDS_R"].sum()
        local_govt_funds2 = df5[df5['dyear'] == (row['dyear'] + delta_year+0)]["FUNDS_R"].sum()
        local_govt_funds3 = df5[df5['dyear'] == (row['dyear'] + delta_year+1)]["FUNDS_R"].sum()
        local_govt_funds4 = df5[df5['dyear'] == (row['dyear'] + delta_year+2)]["FUNDS_R"].sum()
        local_govt_funds5 = df5[df5['dyear'] >= (row['dyear'] + delta_year+3)]["FUNDS_R"].sum()
        
        local_govt_reciepts = df5[["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        local_govt_reciepts1 = df5[df5['dyear'] == (row['dyear'] + delta_year-1)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        local_govt_reciepts2 = df5[df5['dyear'] == (row['dyear'] + delta_year+0)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        local_govt_reciepts3 = df5[df5['dyear'] == (row['dyear'] + delta_year+1)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        local_govt_reciepts4 = df5[df5['dyear'] == (row['dyear'] + delta_year+2)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        local_govt_reciepts5 = df5[df5['dyear'] >= (row['dyear'] + delta_year+3)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
 
        local_govt_expenditure = df5[["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        local_govt_expenditure1 = df5[df5['dyear'] == (row['dyear'] + delta_year-1)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        local_govt_expenditure2 = df5[df5['dyear'] == (row['dyear'] + delta_year+0)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        local_govt_expenditure3 = df5[df5['dyear'] == (row['dyear'] + delta_year+1)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        local_govt_expenditure4 = df5[df5['dyear'] == (row['dyear'] + delta_year+2)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        local_govt_expenditure5 = df5[df5['dyear'] >= (row['dyear'] + delta_year+3)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        
        df6 = df3[df3['SCHMGT'].isin([4, 5])]
        
        private_schools_opened = df6[(df6['ESTDYEAR'] >= row['dyear']) & (df4['ESTDYEAR'] < next_elect['dyear'].values[0])].shape[0]
        private_schools_opened1 = df6[df6['ESTDYEAR'] == (row['dyear'] + delta_year-1)].shape[0]
        private_schools_opened2 = df6[df6['ESTDYEAR'] == (row['dyear'] + delta_year+0)].shape[0]
        private_schools_opened3 = df6[df6['ESTDYEAR'] == (row['dyear'] + delta_year+0)].shape[0]
        private_schools_opened4 = df6[df6['ESTDYEAR'] == (row['dyear'] + delta_year+2)].shape[0]
        private_schools_opened5 = df6[df6['ESTDYEAR'] >= (row['dyear'] + delta_year+3)].shape[0]
        
        private_funds = df6["FUNDS_R"].sum()
        private_funds1 = df6[df6['dyear'] == (row['dyear'] + delta_year-1)]["FUNDS_R"].sum()
        private_funds2 = df6[df6['dyear'] == (row['dyear'] + delta_year+0)]["FUNDS_R"].sum()
        private_funds3 = df6[df6['dyear'] == (row['dyear'] + delta_year+1)]["FUNDS_R"].sum()
        private_funds4 = df6[df6['dyear'] == (row['dyear'] + delta_year+2)]["FUNDS_R"].sum()
        private_funds5 = df6[df6['dyear'] >= (row['dyear'] + delta_year+3)]["FUNDS_R"].sum()
        
        private_reciepts = df6[["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        private_reciepts1 = df6[df6['dyear'] == (row['dyear'] + delta_year-1)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        private_reciepts2 = df6[df6['dyear'] == (row['dyear'] + delta_year+0)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        private_reciepts3 = df6[df6['dyear'] == (row['dyear'] + delta_year+1)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        private_reciepts4 = df6[df6['dyear'] == (row['dyear'] + delta_year+2)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
        private_reciepts5 = df6[df6['dyear'] >= (row['dyear'] + delta_year+3)][["CONTI_R", "SCHMNTCGRANT_R", "TLM_R"]].sum().sum()
 
        private_expenditure = df6[["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        private_expenditure1 = df6[df6['dyear'] == (row['dyear'] + delta_year-1)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        private_expenditure2 = df6[df6['dyear'] == (row['dyear'] + delta_year+0)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        private_expenditure3 = df6[df6['dyear'] == (row['dyear'] + delta_year+1)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        private_expenditure4 = df6[df6['dyear'] == (row['dyear'] + delta_year+2)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        private_expenditure5 = df6[df6['dyear'] >= (row['dyear'] + delta_year+3)][["CONTI_E", "FUNDS_E", "SCHMNTCGRANT_E", "TLM_GRANT_EXPND"]].sum().sum()
        
        #Return Now
        return total_school,total_school1,total_school2,total_school3,total_school4,total_school5,state_govt_school,    state_govt_school1,state_govt_school2,state_govt_school3,state_govt_school4,state_govt_school5,local_govt_school,local_govt_school1,local_govt_school2,local_govt_school3,local_govt_school4,local_govt_school5,local_govt_school5,private_school,private_school1,private_school2,private_school3,private_school4,private_school5,schools_opened,schools_opened1,schools_opened2,schools_opened3,schools_opened4,schools_opened5,state_govt_schools_opened,state_govt_schools_opened1,state_govt_schools_opened2,state_govt_schools_opened3,state_govt_schools_opened4,state_govt_schools_opened5,local_govt_schools_opened,local_govt_schools_opened1,local_govt_schools_opened2,local_govt_schools_opened3,local_govt_schools_opened4,local_govt_schools_opened5,private_schools_opened,private_schools_opened1,private_schools_opened2,private_schools_opened3,private_schools_opened4,private_schools_opened5,state_govt_funds,state_govt_funds1,state_govt_funds2,state_govt_funds3,state_govt_funds4,state_govt_funds5,state_govt_reciepts,state_govt_reciepts1,state_govt_reciepts2,state_govt_reciepts3,state_govt_reciepts4,state_govt_reciepts5,state_govt_expenditure,state_govt_expenditure1,state_govt_expenditure2,state_govt_expenditure3,state_govt_expenditure4,state_govt_expenditure5,local_govt_funds,local_govt_funds1,local_govt_funds2,local_govt_funds3,local_govt_funds4,local_govt_funds5,local_govt_reciepts,local_govt_reciepts1,local_govt_reciepts2,local_govt_reciepts3,local_govt_reciepts4,local_govt_reciepts5,local_govt_expenditure,local_govt_expenditure1,local_govt_expenditure2,local_govt_expenditure3,local_govt_expenditure4,local_govt_expenditure5,private_funds,private_funds1,private_funds2,private_funds3,private_funds4,private_funds5,private_reciepts,private_reciepts1,private_reciepts2,private_reciepts3,private_reciepts4,private_reciepts5,private_expenditure,private_expenditure1,private_expenditure2,private_expenditure3,private_expenditure4,private_expenditure5,total_funds,total_funds1,total_funds2,total_funds3,total_funds4,total_funds5,total_reciepts,total_reciepts1,total_reciepts2,total_reciepts3,total_reciepts4,total_reciepts5,total_expenditure,total_expenditure1,total_expenditure2,total_expenditure3,total_expenditure4,total_expenditure5 
    except:
        return 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
#Apply This Function
acdf[variables] = acdf.apply(get_ac_variables, axis=1, result_type='expand')
#acdf.head(50).apply(get_ac_variables, axis=1, result_type='expand')
acdf

C:\Users\sandyjones\AppData\Local\conda\conda\envs\geo\lib\site-packages\ipykernel_launcher.py:171: UserWarning: Boolean Series key will be reindexed to match DataFrame index.
C:\Users\sandyjones\AppData\Local\conda\conda\envs\geo\lib\site-packages\ipykernel_launcher.py:179: UserWarning: Boolean Series key will be reindexed to match DataFrame index.
C:\Users\sandyjones\AppData\Local\conda\conda\envs\geo\lib\site-packages\ipykernel_launcher.py:235: UserWarning: Boolean Series key will be reindexed to match DataFrame index.
C:\Users\sandyjones\AppData\Local\conda\conda\envs\geo\lib\site-packages\ipykernel_launcher.py:265: UserWarning: Boolean Series key will be reindexed to match DataFrame index.

# Output to CSV
acdf.to_csv(os.path.join(output_folder, "Assembly_Constituencies_Variables_Categories.csv"), encoding='utf-8', index=False)

	state_name	state_code	constituency_no	year	month	day	dyear	datetime	OBJECTID	ST_CODE	ST_NAME	DT_CODE	DIST_NAME	AC_NO	AC_NAME	PC_NO	PC_NAME
0	Jammu & Kashmir	1	1	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	1	KARNAH	1	BARAMULLA
1	Jammu & Kashmir	1	1	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	1	KARNAH	1	BARAMULLA
2	Jammu & Kashmir	1	2	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	2	KUPWARA	1	BARAMULLA
3	Jammu & Kashmir	1	2	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	2	KUPWARA	1	BARAMULLA
4	Jammu & Kashmir	1	3	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	3	LOLAB	1	BARAMULLA
5	Jammu & Kashmir	1	3	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	3	LOLAB	1	BARAMULLA
6	Jammu & Kashmir	1	4	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	4	HANDWARA	1	BARAMULLA
7	Jammu & Kashmir	1	4	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	4	HANDWARA	1	BARAMULLA
8	Jammu & Kashmir	1	5	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	5	LANGATE	1	BARAMULLA
9	Jammu & Kashmir	1	5	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	5	LANGATE	1	BARAMULLA
10	Jammu & Kashmir	1	6	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	6	URI	1	BARAMULLA
11	Jammu & Kashmir	1	6	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	6	URI	1	BARAMULLA
12	Jammu & Kashmir	1	7	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	7	RAFIABAD	1	BARAMULLA
13	Jammu & Kashmir	1	7	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	7	RAFIABAD	1	BARAMULLA
14	Jammu & Kashmir	1	8	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	8	SOPORE	1	BARAMULLA
15	Jammu & Kashmir	1	8	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	8	SOPORE	1	BARAMULLA
16	Jammu & Kashmir	1	9	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	9	GUREZ	1	BARAMULLA
17	Jammu & Kashmir	1	9	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	9	GUREZ	1	BARAMULLA
18	Jammu & Kashmir	1	10	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	10	BANDIPORA	1	BARAMULLA
19	Jammu & Kashmir	1	10	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	10	BANDIPORA	1	BARAMULLA
20	Jammu & Kashmir	1	11	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	11	SONAWARI	1	BARAMULLA
21	Jammu & Kashmir	1	11	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	11	SONAWARI	1	BARAMULLA
22	Jammu & Kashmir	1	12	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	12	SANGRAMA	1	BARAMULLA
23	Jammu & Kashmir	1	12	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	12	SANGRAMA	1	BARAMULLA
24	Jammu & Kashmir	1	13	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	13	BARAMULA	1	BARAMULLA
25	Jammu & Kashmir	1	13	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	13	BARAMULA	1	BARAMULLA
26	Jammu & Kashmir	1	14	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	14	GULMARG	1	BARAMULLA
27	Jammu & Kashmir	1	14	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	14	GULMARG	1	BARAMULLA
28	Jammu & Kashmir	1	15	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	15	PATTAN	1	BARAMULLA
29	Jammu & Kashmir	1	15	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	15	PATTAN	1	BARAMULLA
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
8328	Puducherry	34	16	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	16	Orleampeth	1	PONDICHERRY
8329	Puducherry	34	16	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	16	Orleampeth	1	PONDICHERRY
8330	Puducherry	34	17	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	17	Nellithope	1	PONDICHERRY
8331	Puducherry	34	17	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	17	Nellithope	1	PONDICHERRY
8332	Puducherry	34	18	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	18	Mudaliarpet	1	PONDICHERRY
8333	Puducherry	34	18	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	18	Mudaliarpet	1	PONDICHERRY
8334	Puducherry	34	19	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	19	Ariankuppam	1	PONDICHERRY
8335	Puducherry	34	19	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	19	Ariankuppam	1	PONDICHERRY
8336	Puducherry	34	20	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	20	Manavely	1	PONDICHERRY
8337	Puducherry	34	20	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	20	Manavely	1	PONDICHERRY
8338	Puducherry	34	21	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	21	Embalam (SC)	1	PONDICHERRY
8339	Puducherry	34	21	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	21	Embalam (SC)	1	PONDICHERRY
8340	Puducherry	34	22	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	22	Nettapakkam (SC)	1	PONDICHERRY
8341	Puducherry	34	22	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	22	Nettapakkam (SC)	1	PONDICHERRY
8342	Puducherry	34	23	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	23	Bahour	1	PONDICHERRY
8343	Puducherry	34	23	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	23	Bahour	1	PONDICHERRY
8344	Puducherry	34	24	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	24	Nedungadu (SC)	1	PONDICHERRY
8345	Puducherry	34	24	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	24	Nedungadu (SC)	1	PONDICHERRY
8346	Puducherry	34	25	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	25	Thirunallar	1	PONDICHERRY
8347	Puducherry	34	25	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	25	Thirunallar	1	PONDICHERRY
8348	Puducherry	34	26	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	26	Karaikal North	1	PONDICHERRY
8349	Puducherry	34	26	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	26	Karaikal North	1	PONDICHERRY
8350	Puducherry	34	27	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	27	Karaikal South	1	PONDICHERRY
8351	Puducherry	34	27	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	27	Karaikal South	1	PONDICHERRY
8352	Puducherry	34	28	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	28	Neravy- T.R. Pattin	1	PONDICHERRY
8353	Puducherry	34	28	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	28	Neravy- T.R. Pattin	1	PONDICHERRY
8354	Puducherry	34	29	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	3.0	MAHE	29	Mahe	1	PONDICHERRY
8355	Puducherry	34	29	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	3.0	MAHE	29	Mahe	1	PONDICHERRY
8356	Puducherry	34	30	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	1.0	YANAM	30	Yanam	1	PONDICHERRY
8357	Puducherry	34	30	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	1.0	YANAM	30	Yanam	1	PONDICHERRY

	FID_1	AC_YEAR	BLOCK_NAME	CLUSTER_NA	DISTNAME	PINCODE	SCHCD	SCHOOL_NAM	VILLAGE_NA	Longitude	Latitude	FID_2	OBJECTID	ST_CODE	ST_NAME	DT_CODE	DIST_NAME	AC_NO	AC_NAME	PC_NO	PC_NAME	PC_ID	STATUS	Shape_Leng	geometry
0	2070	2015-16	MANTRALAYAM	ZPHS, MADHAVARAM	KURNOOL	518349.0	28210300705	ZPHS MADHAVARAM	MADHAVARAM	80.094648	13.340937	441.0	1.0	33.0	TAMIL NADU	1.0	THIRUVALLUR	2.0	Ponneri (SC)	1.0	TIRUVALLUR (SC)	3301.0		1.386232	POINT (80.09464820335603 13.34093705069915)
1	1153	2015-16	NAGULUPPALAPADU	ZPHS, EDUMUDI	PRAKASAM	523189.0	28184501706	GVC H S,THIMMASAMUDRAM	THIMMASAMUDRAM	79.691107	12.866135	475.0	6.0	33.0	TAMIL NADU	3.0	KANCHEEPURAM	37.0	Kancheepuram	6.0	KANCHEEPURAM (SC)	3306.0		1.030333	POINT (79.69110656658734 12.86613488373661)
2	4321	2015-16	PEDDAPAPPUR	ZPHS, PEDDAPAPPUR	ANANTAPUR	515420.0	28221001205	MOURYA UPS C.PAPPUR	DHARMAPURAM	77.408412	8.122174	673.0	39.0	33.0	TAMIL NADU	30.0	KANNIYAKUMARI	230.0	Nagercoil	39.0	KANNIYAKUMARI	3339.0		0.517745	POINT (77.40841226660984 8.122173597444203)
3	31	2015-16	KANCHILI	ZPHS, PEDDA KOJJIRIA	SRIKAKULAM	532290.0	28113501602	MPPS BASAVAPUTTUGA	JADUPUDI	84.580530	18.975670	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.58053000000012 18.97567000000009)
4	38	2015-16	SOMPETA	ZPHS, GONAKAPADU	SRIKAKULAM	532284.0	28113400801	MPPS SARADAPURAM	SARADAPURAM	84.585440	18.946060	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.58544000000012 18.9460600000001)
5	45	2015-16	ICHAPURAM	ICHAPURAM	SRIKAKULAM	532312.0	28113790220	MPL HS GIRLS ICHAPURAM	ICHCHAPURAM	84.686190	19.113250	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.68619000000012 19.11325000000011)
6	91	2015-16	KAVITI	ZPHS, RAJAPURAM	SRIKAKULAM	532322.0	28113600605	ZPHS RAJAPURAM	RAJAPURAM	84.690250	19.011360	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.69024999999993 19.01136000000008)
7	92	2015-16	ICHAPURAM	ZPHS, LODDAPUTTI	SRIKAKULAM	532312.0	28113702401	MPPS PURNATAKAM	PURNATAKAM	84.686190	19.113250	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.68619000000012 19.11325000000011)
8	99	2015-16	ICHAPURAM	ZPHS, EDUPURAM	SRIKAKULAM	532312.0	28113702701	MPPS NEELAPU PUTTUGA	KESUPURAM	84.686190	19.113250	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.68619000000012 19.11325000000011)
9	107	2015-16	KANCHILI	ZPHS, MS PALLI	SRIKAKULAM	532291.0	28113502204	ZPHS M.SARIYAPALLI	MATHAMSARYAPALLI	84.567420	19.000690	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.56742000000003 19.00069000000008)
10	116	2015-16	KANCHILI	MPUPS J JILLUNDA	SRIKAKULAM	532291.0	28113502203	MPUPS M.SARIYAPALLI	MATHAMSARYAPALLI	84.567420	19.000690	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.56742000000003 19.00069000000008)
11	213	2015-16	SOMPETA	ZPHS, MAMIDIPALLI	SRIKAKULAM	532264.0	28113403502	MPPS CHINNA MAMIDIPALLI	PATHINIVALASA	84.553310	18.900970	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.55330999999995 18.90097000000003)
12	4328	2015-16	KANCHILI	ZPHS, PSR PURAM	SRIKAKULAM	532292.0	28113505007	S.S.V.NIKETAN.TALATAMPARA	TALATAMPARA	84.631720	18.951780	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.63172000000003 18.95177999999999)
13	4423	2015-16	ICHAPURAM	ZPHS, EDUPURAM	SRIKAKULAM	532312.0	28113702807	S GEETHANJALI PUBLIC	BURJAPADU	84.686190	19.113250	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.68619000000012 19.11325000000011)
14	4424	2015-16	KANCHILI	ZPHS, DG PURAM	SRIKAKULAM	532291.0	28113500603	ZPHS D.GOVINDAPURAM	DOLAGOVINDAPURAM	84.567420	19.000690	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.56742000000003 19.00069000000008)
15	4522	2015-16	KANCHILI	ZPHS, DG PURAM	SRIKAKULAM	532291.0	28113500602	MPPS D.GOVINDAPURAM	DOLAGOVINDAPURAM	84.567420	19.000690	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.56742000000003 19.00069000000008)
16	4564	2015-16	KAVITI	ZPHS, SAHALALAPUTTUGA	SRIKAKULAM	532290.0	28113600216	MPPS MOLLIPUTTUGA	SILAGAM	84.580530	18.975670	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.58053000000012 18.97567000000009)
17	4667	2015-16	KANCHILI	ZPHS, KANCHILI	SRIKAKULAM	532290.0	28113504101	MPUPS PADMATULA	PADMATULA	84.580530	18.975670	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.58053000000012 18.97567000000009)
18	4687	2015-16	MANDASA	ZPHS, SONDIPUDI	SRIKAKULAM	532264.0	28113300104	MPPS BALARAMPURAM	GOWDUGURANTI	84.553310	18.900970	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.55330999999995 18.90097000000003)
19	4688	2015-16	MANDASA	ZPHS, BS PURAM	SRIKAKULAM	532264.0	28113300501	MPUPS POTTANGI	B.POTHANGI	84.553310	18.900970	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.55330999999995 18.90097000000003)
20	4711	2015-16	KANCHILI	MPUPS J JILLUNDA	SRIKAKULAM	532291.0	28113500802	MPPS SAGARANNOWGAM	MUNDALA	84.567420	19.000690	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.56742000000003 19.00069000000008)
21	4748	2015-16	KANCHILI	ZPHS, PEDDA KOJJIRIA	SRIKAKULAM	532290.0	28113501702	ZPHS PEDDAKHOJIRIA	PEDDAKHOJIRIA	84.580530	18.975670	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.58053000000012 18.97567000000009)
22	4768	2015-16	KAVITI	Balliputtuga	SRIKAKULAM	532292.0	28113602003	MPUPS BALLIPUTTUGA	BALLIPUTTUGA	84.631720	18.951780	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.63172000000003 18.95177999999999)
23	4930	2015-16	ICHAPURAM	ZPHS, EDUPURAM	SRIKAKULAM	532312.0	28113702801	MPPS BURJAPADU	BURJAPADU	84.686190	19.113250	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.68619000000012 19.11325000000011)
24	636	2015-16	KURUPAM	TWAHS,G.SIVADA	VIZIANAGARAM	535534.0	28120303201	GPS D KEEDAVAI	KEEDAVAI	83.693780	18.921080	977.0	18.0	28.0	ANDHRA PRADESH	12.0	VIZIANAGARAM	130.0	Kurupam (ST)	18.0	ARAKU (ST)	2818.0		2.718990	POINT (83.69378 18.92108000000002)
25	741	2015-16	BALIJIPETA	ZPHS, PEDAPENKI	VIZIANAGARAM	535557.0	28120902201	MPPS PEDAPENKI - I	PEDAPENKI	83.529530	18.946330	977.0	18.0	28.0	ANDHRA PRADESH	12.0	VIZIANAGARAM	130.0	Kurupam (ST)	18.0	ARAKU (ST)	2818.0		2.718990	POINT (83.52953000000008 18.94633000000005)
26	813	2015-16	BALIJIPETA	ZPHS, ARASADA	VIZIANAGARAM	535557.0	28120900801	MPPS ARASADA	ARASADA	83.529530	18.946330	977.0	18.0	28.0	ANDHRA PRADESH	12.0	VIZIANAGARAM	130.0	Kurupam (ST)	18.0	ARAKU (ST)	2818.0		2.718990	POINT (83.52953000000008 18.94633000000005)
27	883	2015-16	KOMARADA	TWAHS,ULIPIRI	VIZIANAGARAM	535521.0	28120105501	GPS(TW) CHINAKHERJALA	CHINAKHERJALA	83.468890	18.885140	977.0	18.0	28.0	ANDHRA PRADESH	12.0	VIZIANAGARAM	130.0	Kurupam (ST)	18.0	ARAKU (ST)	2818.0		2.718990	POINT (83.46889000000004 18.88513999999998)
28	990	2015-16	BALIJIPETA	ZPHS, PEDAPENKI	VIZIANAGARAM	535557.0	28120902203	MPPS PEDAPENKI - III	PEDAPENKI	83.529530	18.946330	977.0	18.0	28.0	ANDHRA PRADESH	12.0	VIZIANAGARAM	130.0	Kurupam (ST)	18.0	ARAKU (ST)	2818.0		2.718990	POINT (83.52953000000008 18.94633000000005)
29	1110	2015-16	KURUPAM	TWAHS,G.SIVADA	VIZIANAGARAM	535534.0	28120303205	MPPS Y.KEEDAVAI	KEEDAVAI	83.693780	18.921080	977.0	18.0	28.0	ANDHRA PRADESH	12.0	VIZIANAGARAM	130.0	Kurupam (ST)	18.0	ARAKU (ST)	2818.0		2.718990	POINT (83.69378 18.92108000000002)
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
2787621	2698444	2010-11	KHOWAI	SARAT CHANDRA H.S SCHOOL	WEST TRIPURA	799201.0	16011502002	CHERMA COL. HIGH SCHOOL	UTTAR SINGHICHARRA	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)
2787622	2698447	2010-11	PADMABIL	RATHTILA S.B SCHOOL	WEST TRIPURA	799201.0	16011600505	KAILASH URANG JB SCHOOL	PURBA BELCHHARA	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)
2787623	2698450	2010-11	TULASHIKHAR	NALICHABARI MODEL S.B	WEST TRIPURA	799201.0	16011700907	PRASADIA PARA J.B SCHOOL	PASCHIM LAXMI CHHARA	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)
2787624	2698451	2010-11	TULASHIKHAR	KARANGICHHARA S.B SCHOOL	WEST TRIPURA	799201.0	16011700908	GUMSHING BARI J.B SCHOOL	PASCHIM LAXMI CHHARA	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)
2787625	2698452	2010-11	TULASHIKHAR	BACHAIBARI HIGH SCHOOL	WEST TRIPURA	799201.0	16011702602	NAKHACHARA URANG BASTI JB SCHOOL	BEHALABARI	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)
2787626	2699897	2016-17	KHARAR	NAYA GAON	MOHALI	160030.0	3180211337	BLOSSOM CONVENT SCHOOL	NAYAGAON	76.789640	30.714170	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (76.78964000000002 30.71417000000014)
2787627	2701934	2016-17	KHARAR	NAYA GAON	MOHALI	160030.0	3180211338	VIVEKANAND SCHOOL	NAYAGAON	76.789640	30.714170	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (76.78964000000002 30.71417000000014)
2787628	2701954	2016-17	MAJRI	BEHLOLPUR	MOHALI	160014.0	3180301205	ANGEL PUBLIC SCHOOL	BEHLOLPUR	76.768610	30.757690	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (76.76860999999997 30.75769000000014)
2787629	2703398	2016-17	KHARAR	PHASE-9 MOHALI	MOHALI	160030.0	3180222902	HARI SINGH MEMORIAL SCHOOL	INDUSTRIAL AREA PH 7	76.789640	30.714170	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (76.78964000000002 30.71417000000014)
2787630	2704612	2011-12	MAJRI	BEHLOLPUR	MOHALI	160014.0	3180301206	GYAN JYOTI PUBLIC SCHOOL	BEHLOLPUR	76.768610	30.757690	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (76.76860999999997 30.75769000000014)
2787631	2709082	2013-14	MALVAN	DEVBAG NO.1	SINDHUDURG	416606.0	27330504201	ZPPS DEVBAG NO.2	DEVBAG	73.489470	15.993231	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (73.48946952238782 15.99323070636922)
2787632	2713065	2013-14	GANGTOK	TNSSS	EAST SIKKIM	737101.0	11040300818	CANAAN SCHOOL	DEVELOPMENT AREA	89.013056	27.581667	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (89.01305555557525 27.5816666673125)
2787633	2713083	2013-14	KHAMDONG	SINGTAM SSS	EAST SIKKIM	737134.0	11040602603	VIDHYA SAGAR	SINGTAM	88.835278	27.398333	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (88.83527777776681 27.39833333352334)
2787634	2713092	2013-14	PAKYONG	DIKLING SSS	EAST SIKKIM	737106.0	11040100303	EVERSHINE ACADEMY	PACHEYKHANI	89.105000	27.398333	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (89.10499999968886 27.39833333352334)
2787635	2713660	2014-15	KATLICHERRA	SONACHERRA	HAILAKANDI	788156.0	18230212804	HARISINGH MEMORIAL VLPS	SUNACHERRA R.A	92.220400	24.514300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (92.22039999999998 24.51430000000011)
2787636	2713789	2014-15	R.K NAGAR	BHAIRAB NAGAR - I	KARIMGANJ	788156.0	18220403902	MAKHAN DAS SMRITI CHATUSPATHI	SANGATIPUR	92.220400	24.514300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (92.22039999999998 24.51430000000011)
2787637	2737685	2009-10	MANJESHWAR	GLPS KANVATHIRTHA	KASARAGOD	671323.0	32010100133	UDAYA HS MANJESHWAR	MANJESHWAR	74.892530	12.713390	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (74.89253000000008 12.71339000000012)
2787638	2751341	2010-11	SUGAULI	GMS MALI	PURBA CHAMPARAN	845456.0	10022502201	UMS GOIRGAWAN	GORGAWAN	84.790278	26.997778	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (84.79027777829492 26.99777777820054)
2787639	2752950	2010-11	SURSAND	P.S. NAWAHI	SITAMARHI	843331.0	10041305505	M.S. NAWAHI	SHRI KHANDI BHITHA	85.759167	26.635833	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (85.75916666676721 26.63583333295605)
2787640	2754312	2010-11	JAINAGAR	M.S.KAMLAWARI	MADHUBANI	847226.0	10050801702	P.S.BETONHA	BELA	86.160630	26.613340	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (86.16062999975173 26.6133400000769)
2787641	2757629	2010-11	SIKTI	M.S.PARARIA	ARARIA	854333.0	10071510002	PS PREMLAL SAH TOLA	KUCHAHA	87.630667	26.392722	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (87.63066666659103 26.39272222223468)
2787642	2758810	2010-11	DIGHAL BANK	M.S.TULSIYA	KISHANGANJ	855101.0	10082500902	PS BHAT TOLI	TULSIYA	87.896944	26.480278	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (87.89694444408332 26.48027777751372)
2787643	2758853	2010-11	DIGHAL BANK	M.S.TAPPU HAT	KISHANGANJ	855101.0	10082503701	PS KHARI DUBRI	KHARI DUBRI	88.108056	26.545556	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (88.10805555528691 26.54555555615468)
2787644	2786052	2016-17	RUPAICHARI	BAISHNABPUR HIGH SCHOOL	SOUTH TRIPURA	799145.0	16021100308	MAGROOM GIRLS' RESIDENTIAL SCHOOL	BAISHNABPUR	91.732640	23.003690	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.73264000000012 23.00369000000006)
2787645	2786069	2016-17	KHOWAI	AJAGARTILA S.B SCHOOL	KHOWAI	799201.0	16061500910	PRANAVANANDA VIDYAMANDIR	SONATALA	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)
2787646	2786533	2011-12	KHOWAI	SARAT CHANDRA H.S SCHOOL	WEST TRIPURA	799201.0	16011502401	UPENDRA KISHOR VIDYAMANDIR JB	SINGHICHARRA	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)
2787647	2786535	2011-12	KHOWAI	SARAT SMRITI J.B SCHOOL	WEST TRIPURA	799201.0	16011500316	MOTHER TERESA VIDYA BHABAN JB	GANKI	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)
2787648	2786536	2011-12	TULASHIKHAR	BIDYABIL S.B SCHOOL	WEST TRIPURA	799201.0	16011700808	SAHADAS BAISHNABBARI S.B	PURBA LAXMICHHARA	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)
2787649	2786537	2011-12	TULASHIKHAR	NALICHABARI MODEL S.B	WEST TRIPURA	799201.0	16011701210	PRASADIA PARA J.B SCHOOL	PASCHIM CHAMPA CHHARA	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)
2787650	2786539	2011-12	TULASHIKHAR	HATIMARA S.B SCHOOL	WEST TRIPURA	799201.0	16011701308	BHATI MAIDAN J.B SCHOOL	PURBA CHAMPA CHHARA	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)

	FID_1	AC_YEAR	BLOCK_NAME	CLUSTER_NA	DISTNAME	PINCODE	SCHCD	SCHOOL_NAM	VILLAGE_NA	Longitude	Latitude	FID_2	OBJECTID	ST_CODE	ST_NAME	DT_CODE	DIST_NAME	AC_NO	AC_NAME	PC_NO	PC_NAME	PC_ID	STATUS	Shape_Leng	geometry	CONTI_E	CONTI_R	ESTDYEAR	FUNDS_E	FUNDS_R	SCHMGT	SCHMNTCGRANT_E	SCHMNTCGRANT_R	TLM_GRANT_EXPND	TLM_R	dyear
0	2070	2015-16	MANTRALAYAM	ZPHS, MADHAVARAM	KURNOOL	518349.0	28210300705	ZPHS MADHAVARAM	MADHAVARAM	80.094648	13.340937	441.0	1.0	33.0	TAMIL NADU	1.0	THIRUVALLUR	2.0	Ponneri (SC)	1.0	TIRUVALLUR (SC)	3301.0		1.386232	POINT (80.09464820335603 13.34093705069915)	10000	10000	2003	10000	10000	3	7000.0	7000.0	NaN	NaN	2015
1	1153	2015-16	NAGULUPPALAPADU	ZPHS, EDUMUDI	PRAKASAM	523189.0	28184501706	GVC H S,THIMMASAMUDRAM	THIMMASAMUDRAM	79.691107	12.866135	475.0	6.0	33.0	TAMIL NADU	3.0	KANCHEEPURAM	37.0	Kancheepuram	6.0	KANCHEEPURAM (SC)	3306.0		1.030333	POINT (79.69110656658734 12.86613488373661)	0	0	1949	0	0	4	0.0	0.0	NaN	NaN	2015
2	4321	2015-16	PEDDAPAPPUR	ZPHS, PEDDAPAPPUR	ANANTAPUR	515420.0	28221001205	MOURYA UPS C.PAPPUR	DHARMAPURAM	77.408412	8.122174	673.0	39.0	33.0	TAMIL NADU	30.0	KANNIYAKUMARI	230.0	Nagercoil	39.0	KANNIYAKUMARI	3339.0		0.517745	POINT (77.40841226660984 8.122173597444203)	0	0	2010	0	0	5	0.0	0.0	NaN	NaN	2015
3	31	2015-16	KANCHILI	ZPHS, PEDDA KOJJIRIA	SRIKAKULAM	532290.0	28113501602	MPPS BASAVAPUTTUGA	JADUPUDI	84.580530	18.975670	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.58053000000012 18.97567000000009)	5000	5000	1998	5000	5000	3	5000.0	5000.0	NaN	NaN	2015
4	38	2015-16	SOMPETA	ZPHS, GONAKAPADU	SRIKAKULAM	532284.0	28113400801	MPPS SARADAPURAM	SARADAPURAM	84.585440	18.946060	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.58544000000012 18.9460600000001)	5000	50000	1928	5000	50000	3	5000.0	5000.0	NaN	NaN	2015
5	45	2015-16	ICHAPURAM	ICHAPURAM	SRIKAKULAM	532312.0	28113790220	MPL HS GIRLS ICHAPURAM	ICHCHAPURAM	84.686190	19.113250	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.68619000000012 19.11325000000011)	3000	7000	1974	3000	7000	3	5000.0	10000.0	NaN	NaN	2015
6	91	2015-16	KAVITI	ZPHS, RAJAPURAM	SRIKAKULAM	532322.0	28113600605	ZPHS RAJAPURAM	RAJAPURAM	84.690250	19.011360	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.69024999999993 19.01136000000008)	7000	7000	1962	7000	7000	3	5000.0	5000.0	NaN	NaN	2015
7	92	2015-16	ICHAPURAM	ZPHS, LODDAPUTTI	SRIKAKULAM	532312.0	28113702401	MPPS PURNATAKAM	PURNATAKAM	84.686190	19.113250	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.68619000000012 19.11325000000011)	5000	5000	1974	5000	5000	3	5000.0	5000.0	NaN	NaN	2015
8	99	2015-16	ICHAPURAM	ZPHS, EDUPURAM	SRIKAKULAM	532312.0	28113702701	MPPS NEELAPU PUTTUGA	KESUPURAM	84.686190	19.113250	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.68619000000012 19.11325000000011)	5000	5000	1961	5000	5000	3	5000.0	5000.0	NaN	NaN	2015
9	107	2015-16	KANCHILI	ZPHS, MS PALLI	SRIKAKULAM	532291.0	28113502204	ZPHS M.SARIYAPALLI	MATHAMSARYAPALLI	84.567420	19.000690	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.56742000000003 19.00069000000008)	10000	10000	1977	10000	10000	3	7000.0	7000.0	NaN	NaN	2015
10	116	2015-16	KANCHILI	MPUPS J JILLUNDA	SRIKAKULAM	532291.0	28113502203	MPUPS M.SARIYAPALLI	MATHAMSARYAPALLI	84.567420	19.000690	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.56742000000003 19.00069000000008)	5000	12000	1938	5000	12000	3	7000.0	10000.0	NaN	NaN	2015
11	213	2015-16	SOMPETA	ZPHS, MAMIDIPALLI	SRIKAKULAM	532264.0	28113403502	MPPS CHINNA MAMIDIPALLI	PATHINIVALASA	84.553310	18.900970	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.55330999999995 18.90097000000003)	5000	5000	2004	5000	5000	3	5000.0	5000.0	NaN	NaN	2015
12	4328	2015-16	KANCHILI	ZPHS, PSR PURAM	SRIKAKULAM	532292.0	28113505007	S.S.V.NIKETAN.TALATAMPARA	TALATAMPARA	84.631720	18.951780	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.63172000000003 18.95177999999999)	0	0	1995	0	0	5	0.0	0.0	NaN	NaN	2015
13	4423	2015-16	ICHAPURAM	ZPHS, EDUPURAM	SRIKAKULAM	532312.0	28113702807	S GEETHANJALI PUBLIC	BURJAPADU	84.686190	19.113250	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.68619000000012 19.11325000000011)	0	0	2004	0	0	5	0.0	0.0	NaN	NaN	2015
14	4424	2015-16	KANCHILI	ZPHS, DG PURAM	SRIKAKULAM	532291.0	28113500603	ZPHS D.GOVINDAPURAM	DOLAGOVINDAPURAM	84.567420	19.000690	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.56742000000003 19.00069000000008)	7000	7000	1991	7000	7000	3	10000.0	10000.0	NaN	NaN	2015
15	4522	2015-16	KANCHILI	ZPHS, DG PURAM	SRIKAKULAM	532291.0	28113500602	MPPS D.GOVINDAPURAM	DOLAGOVINDAPURAM	84.567420	19.000690	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.56742000000003 19.00069000000008)	5000	5000	1999	5000	5000	3	5000.0	5000.0	NaN	NaN	2015
16	4564	2015-16	KAVITI	ZPHS, SAHALALAPUTTUGA	SRIKAKULAM	532290.0	28113600216	MPPS MOLLIPUTTUGA	SILAGAM	84.580530	18.975670	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.58053000000012 18.97567000000009)	5000	5000	2006	5000	5000	3	5000.0	5000.0	NaN	NaN	2015
17	4667	2015-16	KANCHILI	ZPHS, KANCHILI	SRIKAKULAM	532290.0	28113504101	MPUPS PADMATULA	PADMATULA	84.580530	18.975670	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.58053000000012 18.97567000000009)	12000	12000	1961	12000	12000	3	10000.0	10000.0	NaN	NaN	2015
18	4687	2015-16	MANDASA	ZPHS, SONDIPUDI	SRIKAKULAM	532264.0	28113300104	MPPS BALARAMPURAM	GOWDUGURANTI	84.553310	18.900970	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.55330999999995 18.90097000000003)	5000	5000	1999	5000	5000	3	5000.0	5000.0	NaN	NaN	2015
19	4688	2015-16	MANDASA	ZPHS, BS PURAM	SRIKAKULAM	532264.0	28113300501	MPUPS POTTANGI	B.POTHANGI	84.553310	18.900970	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.55330999999995 18.90097000000003)	10000	10000	1938	10000	10000	3	12000.0	12000.0	NaN	NaN	2015
20	4711	2015-16	KANCHILI	MPUPS J JILLUNDA	SRIKAKULAM	532291.0	28113500802	MPPS SAGARANNOWGAM	MUNDALA	84.567420	19.000690	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.56742000000003 19.00069000000008)	5000	5000	1959	5000	5000	3	5000.0	5000.0	NaN	NaN	2015
21	4748	2015-16	KANCHILI	ZPHS, PEDDA KOJJIRIA	SRIKAKULAM	532290.0	28113501702	ZPHS PEDDAKHOJIRIA	PEDDAKHOJIRIA	84.580530	18.975670	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.58053000000012 18.97567000000009)	7000	7000	2001	7000	7000	3	10000.0	10000.0	NaN	NaN	2015
22	4768	2015-16	KAVITI	Balliputtuga	SRIKAKULAM	532292.0	28113602003	MPUPS BALLIPUTTUGA	BALLIPUTTUGA	84.631720	18.951780	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.63172000000003 18.95177999999999)	0	0	1941	0	0	3	0.0	0.0	NaN	NaN	2015
23	4930	2015-16	ICHAPURAM	ZPHS, EDUPURAM	SRIKAKULAM	532312.0	28113702801	MPPS BURJAPADU	BURJAPADU	84.686190	19.113250	976.0	19.0	28.0	ANDHRA PRADESH	11.0	SRIKAKULAM	120.0	Ichchapuram	19.0	SRIKAKULAM	2819.0		1.315207	POINT (84.68619000000012 19.11325000000011)	5000	5000	1961	5000	5000	3	5000.0	5000.0	NaN	NaN	2015
24	636	2015-16	KURUPAM	TWAHS,G.SIVADA	VIZIANAGARAM	535534.0	28120303201	GPS D KEEDAVAI	KEEDAVAI	83.693780	18.921080	977.0	18.0	28.0	ANDHRA PRADESH	12.0	VIZIANAGARAM	130.0	Kurupam (ST)	18.0	ARAKU (ST)	2818.0		2.718990	POINT (83.69378 18.92108000000002)	0	0	1998	0	0	1	0.0	0.0	NaN	NaN	2015
25	741	2015-16	BALIJIPETA	ZPHS, PEDAPENKI	VIZIANAGARAM	535557.0	28120902201	MPPS PEDAPENKI - I	PEDAPENKI	83.529530	18.946330	977.0	18.0	28.0	ANDHRA PRADESH	12.0	VIZIANAGARAM	130.0	Kurupam (ST)	18.0	ARAKU (ST)	2818.0		2.718990	POINT (83.52953000000008 18.94633000000005)	5000	5000	1895	5000	5000	3	5000.0	5000.0	NaN	NaN	2015
26	813	2015-16	BALIJIPETA	ZPHS, ARASADA	VIZIANAGARAM	535557.0	28120900801	MPPS ARASADA	ARASADA	83.529530	18.946330	977.0	18.0	28.0	ANDHRA PRADESH	12.0	VIZIANAGARAM	130.0	Kurupam (ST)	18.0	ARAKU (ST)	2818.0		2.718990	POINT (83.52953000000008 18.94633000000005)	5000	5000	1985	5000	5000	3	10000.0	10000.0	NaN	NaN	2015
27	883	2015-16	KOMARADA	TWAHS,ULIPIRI	VIZIANAGARAM	535521.0	28120105501	GPS(TW) CHINAKHERJALA	CHINAKHERJALA	83.468890	18.885140	977.0	18.0	28.0	ANDHRA PRADESH	12.0	VIZIANAGARAM	130.0	Kurupam (ST)	18.0	ARAKU (ST)	2818.0		2.718990	POINT (83.46889000000004 18.88513999999998)	5000	5000	1988	5000	5000	2	5000.0	5000.0	NaN	NaN	2015
28	990	2015-16	BALIJIPETA	ZPHS, PEDAPENKI	VIZIANAGARAM	535557.0	28120902203	MPPS PEDAPENKI - III	PEDAPENKI	83.529530	18.946330	977.0	18.0	28.0	ANDHRA PRADESH	12.0	VIZIANAGARAM	130.0	Kurupam (ST)	18.0	ARAKU (ST)	2818.0		2.718990	POINT (83.52953000000008 18.94633000000005)	0	0	1951	0	0	3	0.0	0.0	NaN	NaN	2015
29	1110	2015-16	KURUPAM	TWAHS,G.SIVADA	VIZIANAGARAM	535534.0	28120303205	MPPS Y.KEEDAVAI	KEEDAVAI	83.693780	18.921080	977.0	18.0	28.0	ANDHRA PRADESH	12.0	VIZIANAGARAM	130.0	Kurupam (ST)	18.0	ARAKU (ST)	2818.0		2.718990	POINT (83.69378 18.92108000000002)	0	0	2014	0	0	3	0.0	0.0	NaN	NaN	2015
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
2315376	2570598	2015-16	HAILAKANDI	SUDARSHANPUR BANDUKMARA	HAILAKANDI	788156.0	18230102714	ABDUL HASIB MEMO. PSM	BANDUKMARA R.A	92.220400	24.514300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (92.22039999999998 24.51430000000011)	0	0	1999	0	0	8	0.0	0.0	NaN	NaN	2015
2315377	2575631	2011-12	MANJESHWAR	GUPS MOODAMBAIL	KASARAGOD	671323.0	32010100139	KUNNIL ENG MED SCHL MANJESHWAR	MANJESHWAR	74.892530	12.713390	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (74.89253000000008 12.71339000000012)	0	0	2005	0	0	8	NaN	NaN	0.0	0.0	2011
2315378	2604637	2016-17	TISWADI	PANAJI	NORTH GOA	403001.0	30010504603	DEMPO HIGHER SECONDARY SCHOOL OF SCIENCE	MIRAMAR	73.808759	15.477546	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (73.80875900032845 15.47754600013877)	0	0	2012	0	0	5	0.0	0.0	NaN	NaN	2016
2315379	2616748	2009-10	KODINAR	KAJ PAY CEN	JUNAGADH	362720.0	24121406202	SOHAMPARA PRA SHALA	VELAN	70.811611	20.716003	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (70.81161111074994 20.71600277735138)	4502	5000	2000	0	0	3	NaN	NaN	1000.0	1000.0	2009
2315380	2616966	2009-10	JAFRABAD	SAGAR	AMRELI	365560.0	24130503701	SHIYALBET PRI. SCHOOL	SHIYALBET	71.514273	20.910759	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (71.51427344097266 20.91075897890317)	0	11186	1947	0	0	3	NaN	NaN	0.0	0.0	2009
2315381	2678374	2009-10	MAJRI	BEHLOLPUR	MOHALI	160014.0	3180311302	GMS TOGAN (U.G)	TOGAN	76.768610	30.757690	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (76.76860999999997 30.75769000000014)	0	0	2009	0	0	1	NaN	NaN	0.0	0.0	2009
2315382	2693706	2012-13	MANJESHWAR	GLPS KUNJATHUR	KASARAGOD	671323.0	32010100141	UDAYA ENGL MEDIUM PRIMARY SCHOOL	MANJESHWAR	74.892530	12.713390	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (74.89253000000008 12.71339000000012)	0	0	1980	0	0	5	NaN	NaN	0.0	0.0	2012
2315383	2696365	2010-11	R.K NAGAR	ANANDAPUR	KARIMGANJ	788156.0	18220400105	SWAMI VIVEKANANDA HIGH SCHOOL	ANANDAPUR	92.220400	24.514300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (92.22039999999998 24.51430000000011)	0	0	1964	0	0	1	NaN	NaN	0.0	0.0	2010
2315384	2699897	2016-17	KHARAR	NAYA GAON	MOHALI	160030.0	3180211337	BLOSSOM CONVENT SCHOOL	NAYAGAON	76.789640	30.714170	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (76.78964000000002 30.71417000000014)	0	0	2010	0	0	5	0.0	0.0	NaN	NaN	2016
2315385	2704612	2011-12	MAJRI	BEHLOLPUR	MOHALI	160014.0	3180301206	GYAN JYOTI PUBLIC SCHOOL	BEHLOLPUR	76.768610	30.757690	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (76.76860999999997 30.75769000000014)	0	0	2005	0	0	8	NaN	NaN	0.0	0.0	2011
2315386	2709082	2013-14	MALVAN	DEVBAG NO.1	SINDHUDURG	416606.0	27330504201	ZPPS DEVBAG NO.2	DEVBAG	73.489470	15.993231	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (73.48946952238782 15.99323070636922)	5000	5000	1919	5000	5000	3	0.0	0.0	NaN	NaN	2013
2315387	2713065	2013-14	GANGTOK	TNSSS	EAST SIKKIM	737101.0	11040300818	CANAAN SCHOOL	DEVELOPMENT AREA	89.013056	27.581667	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (89.01305555557525 27.5816666673125)	0	0	2006	0	0	5	0.0	0.0	NaN	NaN	2013
2315388	2713083	2013-14	KHAMDONG	SINGTAM SSS	EAST SIKKIM	737134.0	11040602603	VIDHYA SAGAR	SINGTAM	88.835278	27.398333	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (88.83527777776681 27.39833333352334)	0	0	1979	0	0	5	0.0	0.0	NaN	NaN	2013
2315389	2713092	2013-14	PAKYONG	DIKLING SSS	EAST SIKKIM	737106.0	11040100303	EVERSHINE ACADEMY	PACHEYKHANI	89.105000	27.398333	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (89.10499999968886 27.39833333352334)	0	0	2008	0	0	5	0.0	0.0	NaN	NaN	2013
2315390	2713660	2014-15	KATLICHERRA	SONACHERRA	HAILAKANDI	788156.0	18230212804	HARISINGH MEMORIAL VLPS	SUNACHERRA R.A	92.220400	24.514300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (92.22039999999998 24.51430000000011)	0	0	2005	0	0	8	0.0	0.0	NaN	NaN	2014
2315391	2713789	2014-15	R.K NAGAR	BHAIRAB NAGAR - I	KARIMGANJ	788156.0	18220403902	MAKHAN DAS SMRITI CHATUSPATHI	SANGATIPUR	92.220400	24.514300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (92.22039999999998 24.51430000000011)	0	0	2004	0	0	8	0.0	0.0	NaN	NaN	2014
2315392	2737685	2009-10	MANJESHWAR	GLPS KANVATHIRTHA	KASARAGOD	671323.0	32010100133	UDAYA HS MANJESHWAR	MANJESHWAR	74.892530	12.713390	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (74.89253000000008 12.71339000000012)	0	0	1980	0	0	5	NaN	NaN	0.0	0.0	2009
2315393	2751341	2010-11	SUGAULI	GMS MALI	PURBA CHAMPARAN	845456.0	10022502201	UMS GOIRGAWAN	GORGAWAN	84.790278	26.997778	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (84.79027777829492 26.99777777820054)	5000	5000	1975	0	0	1	NaN	NaN	2000.0	2000.0	2010
2315394	2752950	2010-11	SURSAND	P.S. NAWAHI	SITAMARHI	843331.0	10041305505	M.S. NAWAHI	SHRI KHANDI BHITHA	85.759167	26.635833	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (85.75916666676721 26.63583333295605)	0	0	1956	0	0	1	NaN	NaN	0.0	0.0	2010
2315395	2754312	2010-11	JAINAGAR	M.S.KAMLAWARI	MADHUBANI	847226.0	10050801702	P.S.BETONHA	BELA	86.160630	26.613340	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (86.16062999975173 26.6133400000769)	0	5000	1959	0	0	1	NaN	NaN	0.0	3000.0	2010
2315396	2757629	2010-11	SIKTI	M.S.PARARIA	ARARIA	854333.0	10071510002	PS PREMLAL SAH TOLA	KUCHAHA	87.630667	26.392722	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (87.63066666659103 26.39272222223468)	5000	5000	2007	0	0	1	NaN	NaN	1000.0	1000.0	2010
2315397	2758810	2010-11	DIGHAL BANK	M.S.TULSIYA	KISHANGANJ	855101.0	10082500902	PS BHAT TOLI	TULSIYA	87.896944	26.480278	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (87.89694444408332 26.48027777751372)	12000	12000	1965	0	0	1	NaN	NaN	3000.0	3000.0	2010
2315398	2758853	2010-11	DIGHAL BANK	M.S.TAPPU HAT	KISHANGANJ	855101.0	10082503701	PS KHARI DUBRI	KHARI DUBRI	88.108056	26.545556	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (88.10805555528691 26.54555555615468)	5000	5000	1973	0	0	1	NaN	NaN	3000.0	3000.0	2010
2315399	2786052	2016-17	RUPAICHARI	BAISHNABPUR HIGH SCHOOL	SOUTH TRIPURA	799145.0	16021100308	MAGROOM GIRLS' RESIDENTIAL SCHOOL	BAISHNABPUR	91.732640	23.003690	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.73264000000012 23.00369000000006)	0	0	2015	0	0	1	0.0	0.0	NaN	NaN	2016
2315400	2786069	2016-17	KHOWAI	AJAGARTILA S.B SCHOOL	KHOWAI	799201.0	16061500910	PRANAVANANDA VIDYAMANDIR	SONATALA	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)	0	0	2010	0	0	5	0.0	0.0	NaN	NaN	2016
2315401	2786533	2011-12	KHOWAI	SARAT CHANDRA H.S SCHOOL	WEST TRIPURA	799201.0	16011502401	UPENDRA KISHOR VIDYAMANDIR JB	SINGHICHARRA	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)	0	0	2011	0	0	1	NaN	NaN	0.0	0.0	2011
2315402	2786535	2011-12	KHOWAI	SARAT SMRITI J.B SCHOOL	WEST TRIPURA	799201.0	16011500316	MOTHER TERESA VIDYA BHABAN JB	GANKI	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)	20000	20000	2011	0	0	1	NaN	NaN	0.0	0.0	2011
2315403	2786536	2011-12	TULASHIKHAR	BIDYABIL S.B SCHOOL	WEST TRIPURA	799201.0	16011700808	SAHADAS BAISHNABBARI S.B	PURBA LAXMICHHARA	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)	12000	12000	1965	0	0	1	NaN	NaN	5500.0	5500.0	2011
2315404	2786537	2011-12	TULASHIKHAR	NALICHABARI MODEL S.B	WEST TRIPURA	799201.0	16011701210	PRASADIA PARA J.B SCHOOL	PASCHIM CHAMPA CHHARA	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)	5000	5000	2004	0	0	1	NaN	NaN	2500.0	2500.0	2011
2315405	2786539	2011-12	TULASHIKHAR	HATIMARA S.B SCHOOL	WEST TRIPURA	799201.0	16011701308	BHATI MAIDAN J.B SCHOOL	PURBA CHAMPA CHHARA	91.596280	24.081310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	POINT (91.59627999999998 24.08130999999992)	5000	5000	2007	0	0	1	NaN	NaN	1500.0	1500.0	2011

	state_name	state_code	constituency_no	year	month	day	dyear	datetime	OBJECTID	ST_CODE	ST_NAME	DT_CODE	DIST_NAME	AC_NO	AC_NAME	PC_NO	PC_NAME	total_school	total_school1	total_school2	total_school3	total_school4	total_school5	state_govt_school	state_govt_school1	...	private_reciepts5	private_expenditure	private_expenditure1	private_expenditure2	private_expenditure3	private_expenditure4	private_expenditure5	total_funds	total_funds1	total_funds2	total_funds3	total_funds4	total_funds5	total_reciepts	total_reciepts1	total_reciepts2	total_reciepts3	total_reciepts4	total_reciepts5	total_expenditure	total_expenditure1	total_expenditure2	total_expenditure3	total_expenditure4	total_expenditure5
0	Jammu & Kashmir	1	1	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	1	KARNAH	1	BARAMULLA	155.0	124.0	136.0	153.0	154.0	155.0	150.0	119.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	218344.0	0.0	0.0	0.0	0.0	218344.0	404318.0	0.0	0.0	0.0	11500.0	392818.0	618612.0	0.0	0.0	0.0	11500.0	607112.0
1	Jammu & Kashmir	1	1	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	1	KARNAH	1	BARAMULLA	155.0	155.0	155.0	155.0	155.0	155.0	150.0	150.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
2	Jammu & Kashmir	1	2	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	2	KUPWARA	1	BARAMULLA	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
3	Jammu & Kashmir	1	2	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	2	KUPWARA	1	BARAMULLA	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
4	Jammu & Kashmir	1	3	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	3	LOLAB	1	BARAMULLA	4.0	4.0	4.0	4.0	4.0	4.0	3.0	3.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	15000.0	0.0	0.0	0.0	0.0	15000.0	22000.0	0.0	0.0	0.0	0.0	22000.0	37000.0	0.0	0.0	0.0	0.0	37000.0
5	Jammu & Kashmir	1	3	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	3	LOLAB	1	BARAMULLA	4.0	4.0	4.0	4.0	4.0	4.0	3.0	3.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
6	Jammu & Kashmir	1	4	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	4	HANDWARA	1	BARAMULLA	312.0	264.0	285.0	303.0	311.0	311.0	276.0	236.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	327113.0	0.0	0.0	0.0	0.0	327113.0	528121.0	0.0	0.0	0.0	0.0	528121.0	856915.0	0.0	0.0	0.0	0.0	856915.0
7	Jammu & Kashmir	1	4	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	4	HANDWARA	1	BARAMULLA	312.0	312.0	312.0	312.0	312.0	312.0	276.0	276.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8	Jammu & Kashmir	1	5	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	5	LANGATE	1	BARAMULLA	443.0	361.0	392.0	435.0	436.0	441.0	364.0	296.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	275339.0	0.0	0.0	0.0	0.0	275339.0	571331.0	0.0	0.0	0.0	0.0	571331.0	829722.0	0.0	0.0	0.0	0.0	829722.0
9	Jammu & Kashmir	1	5	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	1.0	KUPWARA	5	LANGATE	1	BARAMULLA	443.0	443.0	443.0	443.0	443.0	443.0	364.0	364.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
10	Jammu & Kashmir	1	6	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	6	URI	1	BARAMULLA	332.0	297.0	305.0	322.0	328.0	331.0	306.0	275.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1370778.0	0.0	0.0	0.0	0.0	1370778.0	2526902.0	0.0	1000.0	7000.0	124000.0	2394902.0	3915856.0	0.0	1000.0	7000.0	124000.0	3783856.0
11	Jammu & Kashmir	1	6	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	6	URI	1	BARAMULLA	332.0	332.0	332.0	332.0	332.0	332.0	306.0	306.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
12	Jammu & Kashmir	1	7	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	7	RAFIABAD	1	BARAMULLA	303.0	265.0	279.0	295.0	298.0	303.0	256.0	226.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	650834.0	0.0	0.0	0.0	0.0	650834.0	1039714.0	0.0	0.0	0.0	18500.0	1021214.0	1804796.0	0.0	0.0	0.0	18500.0	1786296.0
13	Jammu & Kashmir	1	7	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	7	RAFIABAD	1	BARAMULLA	303.0	303.0	303.0	303.0	303.0	303.0	256.0	256.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
14	Jammu & Kashmir	1	8	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	8	SOPORE	1	BARAMULLA	310.0	264.0	284.0	301.0	307.0	310.0	238.0	196.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	401680.0	0.0	0.0	0.0	0.0	401680.0	919010.0	0.0	5500.0	0.0	198284.0	715226.0	1233150.0	0.0	5500.0	0.0	188694.0	1038956.0
15	Jammu & Kashmir	1	8	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	8	SOPORE	1	BARAMULLA	310.0	310.0	310.0	310.0	310.0	310.0	238.0	238.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
16	Jammu & Kashmir	1	9	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	9	GUREZ	1	BARAMULLA	150.0	120.0	130.0	141.0	142.0	150.0	147.0	117.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	131302.0	131302.0	0.0	0.0	0.0	0.0	503514.0	370500.0	0.0	0.0	8000.0	125014.0	554486.0	421480.0	0.0	0.0	8000.0	125006.0
17	Jammu & Kashmir	1	9	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	9	GUREZ	1	BARAMULLA	150.0	150.0	150.0	150.0	150.0	150.0	147.0	147.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
18	Jammu & Kashmir	1	10	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	10	BANDIPORA	1	BARAMULLA	684.0	605.0	623.0	667.0	681.0	683.0	587.0	516.0	...	0.0	877530.0	877530.0	0.0	0.0	0.0	0.0	1997163.0	1904163.0	0.0	0.0	0.0	93000.0	2596670.0	1370000.0	6000.0	0.0	6000.0	1214670.0	4115799.0	2817060.0	6000.0	0.0	6000.0	1286739.0
19	Jammu & Kashmir	1	10	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	10	BANDIPORA	1	BARAMULLA	684.0	684.0	684.0	684.0	684.0	684.0	587.0	587.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
20	Jammu & Kashmir	1	11	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	11	SONAWARI	1	BARAMULLA	1.0	0.0	0.0	1.0	1.0	1.0	1.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
21	Jammu & Kashmir	1	11	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	11	SONAWARI	1	BARAMULLA	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
22	Jammu & Kashmir	1	12	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	12	SANGRAMA	1	BARAMULLA	17.0	15.0	16.0	16.0	17.0	17.0	16.0	14.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	39274.0	0.0	0.0	0.0	0.0	39274.0	71820.0	0.0	0.0	0.0	0.0	71820.0	106500.0	0.0	0.0	0.0	0.0	106500.0
23	Jammu & Kashmir	1	12	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	12	SANGRAMA	1	BARAMULLA	17.0	17.0	17.0	17.0	17.0	17.0	16.0	16.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
24	Jammu & Kashmir	1	13	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	13	BARAMULA	1	BARAMULLA	361.0	294.0	321.0	344.0	359.0	361.0	293.0	233.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	849464.0	0.0	0.0	0.0	0.0	849464.0	1423564.0	0.0	0.0	0.0	51000.0	1372564.0	2113928.0	0.0	0.0	0.0	51000.0	2062928.0
25	Jammu & Kashmir	1	13	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	13	BARAMULA	1	BARAMULLA	361.0	361.0	361.0	361.0	361.0	361.0	293.0	293.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
26	Jammu & Kashmir	1	14	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	14	GULMARG	1	BARAMULLA	352.0	303.0	323.0	343.0	352.0	352.0	297.0	255.0	...	0.0	1227085.0	1227085.0	0.0	0.0	0.0	0.0	2380002.0	1938859.0	0.0	0.0	0.0	441143.0	1094808.0	284200.0	0.0	0.0	83000.0	727608.0	3087420.0	1937529.0	0.0	0.0	78000.0	1071891.0
27	Jammu & Kashmir	1	14	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	14	GULMARG	1	BARAMULLA	352.0	352.0	352.0	352.0	352.0	352.0	297.0	297.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
28	Jammu & Kashmir	1	15	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	15	PATTAN	1	BARAMULLA	264.0	223.0	240.0	248.0	262.0	264.0	218.0	182.0	...	0.0	251600.0	251600.0	0.0	0.0	0.0	0.0	509269.0	270441.0	0.0	0.0	0.0	238828.0	621861.0	74500.0	0.0	0.0	11000.0	536361.0	1010322.0	329255.0	0.0	0.0	11000.0	670067.0
29	Jammu & Kashmir	1	15	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2.0	BARAMULA	15	PATTAN	1	BARAMULLA	264.0	264.0	264.0	264.0	264.0	264.0	218.0	218.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
8328	Puducherry	34	16	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	16	Orleampeth	1	PONDICHERRY	8.0	8.0	8.0	8.0	8.0	8.0	4.0	4.0	...	0.0	9500.0	9500.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	46000.0	46000.0	0.0	0.0	0.0	0.0	39000.0	39000.0	0.0	0.0	0.0	0.0
8329	Puducherry	34	16	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	16	Orleampeth	1	PONDICHERRY	8.0	8.0	8.0	8.0	8.0	8.0	4.0	4.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8330	Puducherry	34	17	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	17	Nellithope	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8331	Puducherry	34	17	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	17	Nellithope	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8332	Puducherry	34	18	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	18	Mudaliarpet	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8333	Puducherry	34	18	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	18	Mudaliarpet	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8334	Puducherry	34	19	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	19	Ariankuppam	1	PONDICHERRY	54.0	53.0	53.0	53.0	54.0	54.0	27.0	27.0	...	0.0	38000.0	28000.0	0.0	10000.0	0.0	0.0	54000.0	0.0	0.0	54000.0	0.0	0.0	435460.0	331460.0	0.0	104000.0	0.0	0.0	452107.0	294107.0	0.0	158000.0	0.0	0.0
8335	Puducherry	34	19	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	19	Ariankuppam	1	PONDICHERRY	54.0	54.0	54.0	54.0	54.0	54.0	27.0	27.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8336	Puducherry	34	20	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	20	Manavely	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8337	Puducherry	34	20	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	20	Manavely	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8338	Puducherry	34	21	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	21	Embalam (SC)	1	PONDICHERRY	1.0	1.0	1.0	1.0	1.0	1.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8339	Puducherry	34	21	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	21	Embalam (SC)	1	PONDICHERRY	1.0	1.0	1.0	1.0	1.0	1.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000.0	5000.0	0.0	0.0	0.0	0.0	10000.0	10000.0	0.0	0.0	0.0	0.0	15000.0	15000.0	0.0	0.0	0.0	0.0
8340	Puducherry	34	22	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	22	Nettapakkam (SC)	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8341	Puducherry	34	22	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	22	Nettapakkam (SC)	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8342	Puducherry	34	23	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	23	Bahour	1	PONDICHERRY	52.0	50.0	50.0	50.0	51.0	52.0	33.0	33.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	51000.0	0.0	0.0	51000.0	0.0	0.0	453060.0	352060.0	0.0	101000.0	0.0	0.0	458643.0	306643.0	0.0	152000.0	0.0	0.0
8343	Puducherry	34	23	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2.0	PONDICHERRY	23	Bahour	1	PONDICHERRY	52.0	52.0	52.0	52.0	52.0	52.0	33.0	33.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8344	Puducherry	34	24	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	24	Nedungadu (SC)	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8345	Puducherry	34	24	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	24	Nedungadu (SC)	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8346	Puducherry	34	25	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	25	Thirunallar	1	PONDICHERRY	1.0	1.0	1.0	1.0	1.0	1.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8347	Puducherry	34	25	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	25	Thirunallar	1	PONDICHERRY	1.0	1.0	1.0	1.0	1.0	1.0	0.0	0.0	...	0.0	10000.0	10000.0	0.0	0.0	0.0	0.0	5000.0	5000.0	0.0	0.0	0.0	0.0	5000.0	5000.0	0.0	0.0	0.0	0.0	10000.0	10000.0	0.0	0.0	0.0	0.0
8348	Puducherry	34	26	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	26	Karaikal North	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8349	Puducherry	34	26	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	26	Karaikal North	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8350	Puducherry	34	27	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	27	Karaikal South	1	PONDICHERRY	42.0	41.0	41.0	41.0	41.0	42.0	21.0	21.0	...	0.0	90500.0	80500.0	0.0	10000.0	0.0	0.0	5000.0	0.0	0.0	5000.0	0.0	0.0	305000.0	300000.0	0.0	5000.0	0.0	0.0	316040.0	306040.0	0.0	10000.0	0.0	0.0
8351	Puducherry	34	27	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	27	Karaikal South	1	PONDICHERRY	42.0	42.0	42.0	42.0	42.0	42.0	21.0	21.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8352	Puducherry	34	28	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	28	Neravy- T.R. Pattin	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8353	Puducherry	34	28	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	4.0	KARAIKAL	28	Neravy- T.R. Pattin	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8354	Puducherry	34	29	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	3.0	MAHE	29	Mahe	1	PONDICHERRY	21.0	20.0	20.0	20.0	20.0	21.0	14.0	13.0	...	0.0	10000.0	0.0	0.0	0.0	10000.0	0.0	5000.0	0.0	0.0	0.0	5000.0	0.0	107460.0	102460.0	0.0	0.0	5000.0	0.0	100401.0	90401.0	0.0	0.0	10000.0	0.0
8355	Puducherry	34	29	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	3.0	MAHE	29	Mahe	1	PONDICHERRY	21.0	21.0	21.0	21.0	21.0	21.0	14.0	14.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8356	Puducherry	34	30	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	1.0	YANAM	30	Yanam	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8357	Puducherry	34	30	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	1.0	YANAM	30	Yanam	1	PONDICHERRY	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0