# Import Libraries
import pandas as pd
import geopandas as gpd
from shapely.geometry import Point, Polygon
import os
# 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, "shapefiles", "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
| 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 | KUPWARA | 1 | KARNAH | 1 | BARAMULLA |
| 1 | Jammu & Kashmir | 1 | 1 | 2014 | 12 | 1 | 2015 | 2014-12-01 | 1 | 1 | JAMMU & KASHMIR | 1 | KUPWARA | 1 | KARNAH | 1 | BARAMULLA |
| 2 | Jammu & Kashmir | 1 | 2 | 2008 | 12 | 1 | 2009 | 2008-12-01 | 1 | 1 | JAMMU & KASHMIR | 1 | KUPWARA | 2 | KUPWARA | 1 | BARAMULLA |
| 3 | Jammu & Kashmir | 1 | 2 | 2014 | 12 | 1 | 2015 | 2014-12-01 | 1 | 1 | JAMMU & KASHMIR | 1 | KUPWARA | 2 | KUPWARA | 1 | BARAMULLA |
| 4 | Jammu & Kashmir | 1 | 3 | 2008 | 12 | 1 | 2009 | 2008-12-01 | 1 | 1 | JAMMU & KASHMIR | 1 | KUPWARA | 3 | LOLAB | 1 | BARAMULLA |
| 5 | Jammu & Kashmir | 1 | 3 | 2014 | 12 | 1 | 2015 | 2014-12-01 | 1 | 1 | JAMMU & KASHMIR | 1 | KUPWARA | 3 | LOLAB | 1 | BARAMULLA |
| 6 | Jammu & Kashmir | 1 | 4 | 2008 | 12 | 1 | 2009 | 2008-12-01 | 1 | 1 | JAMMU & KASHMIR | 1 | KUPWARA | 4 | HANDWARA | 1 | BARAMULLA |
| 7 | Jammu & Kashmir | 1 | 4 | 2014 | 12 | 1 | 2015 | 2014-12-01 | 1 | 1 | JAMMU & KASHMIR | 1 | KUPWARA | 4 | HANDWARA | 1 | BARAMULLA |
| 8 | Jammu & Kashmir | 1 | 5 | 2008 | 12 | 1 | 2009 | 2008-12-01 | 1 | 1 | JAMMU & KASHMIR | 1 | KUPWARA | 5 | LANGATE | 1 | BARAMULLA |
| 9 | Jammu & Kashmir | 1 | 5 | 2014 | 12 | 1 | 2015 | 2014-12-01 | 1 | 1 | JAMMU & KASHMIR | 1 | KUPWARA | 5 | LANGATE | 1 | BARAMULLA |
| 10 | Jammu & Kashmir | 1 | 6 | 2008 | 12 | 1 | 2009 | 2008-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 6 | URI | 1 | BARAMULLA |
| 11 | Jammu & Kashmir | 1 | 6 | 2014 | 12 | 1 | 2015 | 2014-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 6 | URI | 1 | BARAMULLA |
| 12 | Jammu & Kashmir | 1 | 7 | 2008 | 12 | 1 | 2009 | 2008-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 7 | RAFIABAD | 1 | BARAMULLA |
| 13 | Jammu & Kashmir | 1 | 7 | 2014 | 12 | 1 | 2015 | 2014-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 7 | RAFIABAD | 1 | BARAMULLA |
| 14 | Jammu & Kashmir | 1 | 8 | 2008 | 12 | 1 | 2009 | 2008-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 8 | SOPORE | 1 | BARAMULLA |
| 15 | Jammu & Kashmir | 1 | 8 | 2014 | 12 | 1 | 2015 | 2014-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 8 | SOPORE | 1 | BARAMULLA |
| 16 | Jammu & Kashmir | 1 | 9 | 2008 | 12 | 1 | 2009 | 2008-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 9 | GUREZ | 1 | BARAMULLA |
| 17 | Jammu & Kashmir | 1 | 9 | 2014 | 12 | 1 | 2015 | 2014-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 9 | GUREZ | 1 | BARAMULLA |
| 18 | Jammu & Kashmir | 1 | 10 | 2008 | 12 | 1 | 2009 | 2008-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 10 | BANDIPORA | 1 | BARAMULLA |
| 19 | Jammu & Kashmir | 1 | 10 | 2014 | 12 | 1 | 2015 | 2014-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 10 | BANDIPORA | 1 | BARAMULLA |
| 20 | Jammu & Kashmir | 1 | 11 | 2008 | 12 | 1 | 2009 | 2008-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 11 | SONAWARI | 1 | BARAMULLA |
| 21 | Jammu & Kashmir | 1 | 11 | 2014 | 12 | 1 | 2015 | 2014-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 11 | SONAWARI | 1 | BARAMULLA |
| 22 | Jammu & Kashmir | 1 | 12 | 2008 | 12 | 1 | 2009 | 2008-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 12 | SANGRAMA | 1 | BARAMULLA |
| 23 | Jammu & Kashmir | 1 | 12 | 2014 | 12 | 1 | 2015 | 2014-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 12 | SANGRAMA | 1 | BARAMULLA |
| 24 | Jammu & Kashmir | 1 | 13 | 2008 | 12 | 1 | 2009 | 2008-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 13 | BARAMULA | 1 | BARAMULLA |
| 25 | Jammu & Kashmir | 1 | 13 | 2014 | 12 | 1 | 2015 | 2014-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 13 | BARAMULA | 1 | BARAMULLA |
| 26 | Jammu & Kashmir | 1 | 14 | 2008 | 12 | 1 | 2009 | 2008-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 14 | GULMARG | 1 | BARAMULLA |
| 27 | Jammu & Kashmir | 1 | 14 | 2014 | 12 | 1 | 2015 | 2014-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 14 | GULMARG | 1 | BARAMULLA |
| 28 | Jammu & Kashmir | 1 | 15 | 2008 | 12 | 1 | 2009 | 2008-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 15 | PATTAN | 1 | BARAMULLA |
| 29 | Jammu & Kashmir | 1 | 15 | 2014 | 12 | 1 | 2015 | 2014-12-01 | 1 | 1 | JAMMU & KASHMIR | 2 | BARAMULA | 15 | PATTAN | 1 | BARAMULLA |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 8328 | Puducherry | 34 | 16 | 2011 | 5 | 1 | 2011 | 2011-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 16 | Orleampeth | 1 | PONDICHERRY |
| 8329 | Puducherry | 34 | 16 | 2016 | 5 | 1 | 2016 | 2016-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 16 | Orleampeth | 1 | PONDICHERRY |
| 8330 | Puducherry | 34 | 17 | 2011 | 5 | 1 | 2011 | 2011-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 17 | Nellithope | 1 | PONDICHERRY |
| 8331 | Puducherry | 34 | 17 | 2016 | 5 | 1 | 2016 | 2016-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 17 | Nellithope | 1 | PONDICHERRY |
| 8332 | Puducherry | 34 | 18 | 2011 | 5 | 1 | 2011 | 2011-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 18 | Mudaliarpet | 1 | PONDICHERRY |
| 8333 | Puducherry | 34 | 18 | 2016 | 5 | 1 | 2016 | 2016-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 18 | Mudaliarpet | 1 | PONDICHERRY |
| 8334 | Puducherry | 34 | 19 | 2011 | 5 | 1 | 2011 | 2011-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 19 | Ariankuppam | 1 | PONDICHERRY |
| 8335 | Puducherry | 34 | 19 | 2016 | 5 | 1 | 2016 | 2016-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 19 | Ariankuppam | 1 | PONDICHERRY |
| 8336 | Puducherry | 34 | 20 | 2011 | 5 | 1 | 2011 | 2011-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 20 | Manavely | 1 | PONDICHERRY |
| 8337 | Puducherry | 34 | 20 | 2016 | 5 | 1 | 2016 | 2016-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 20 | Manavely | 1 | PONDICHERRY |
| 8338 | Puducherry | 34 | 21 | 2011 | 5 | 1 | 2011 | 2011-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 21 | Embalam (SC) | 1 | PONDICHERRY |
| 8339 | Puducherry | 34 | 21 | 2016 | 5 | 1 | 2016 | 2016-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 21 | Embalam (SC) | 1 | PONDICHERRY |
| 8340 | Puducherry | 34 | 22 | 2011 | 5 | 1 | 2011 | 2011-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 22 | Nettapakkam (SC) | 1 | PONDICHERRY |
| 8341 | Puducherry | 34 | 22 | 2016 | 5 | 1 | 2016 | 2016-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 22 | Nettapakkam (SC) | 1 | PONDICHERRY |
| 8342 | Puducherry | 34 | 23 | 2011 | 5 | 1 | 2011 | 2011-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 23 | Bahour | 1 | PONDICHERRY |
| 8343 | Puducherry | 34 | 23 | 2016 | 5 | 1 | 2016 | 2016-05-01 | 1 | 34 | PUDUCHERRY | 2 | PONDICHERRY | 23 | Bahour | 1 | PONDICHERRY |
| 8344 | Puducherry | 34 | 24 | 2011 | 5 | 1 | 2011 | 2011-05-01 | 1 | 34 | PUDUCHERRY | 4 | KARAIKAL | 24 | Nedungadu (SC) | 1 | PONDICHERRY |
| 8345 | Puducherry | 34 | 24 | 2016 | 5 | 1 | 2016 | 2016-05-01 | 1 | 34 | PUDUCHERRY | 4 | KARAIKAL | 24 | Nedungadu (SC) | 1 | PONDICHERRY |
| 8346 | Puducherry | 34 | 25 | 2011 | 5 | 1 | 2011 | 2011-05-01 | 1 | 34 | PUDUCHERRY | 4 | KARAIKAL | 25 | Thirunallar | 1 | PONDICHERRY |
| 8347 | Puducherry | 34 | 25 | 2016 | 5 | 1 | 2016 | 2016-05-01 | 1 | 34 | PUDUCHERRY | 4 | KARAIKAL | 25 | Thirunallar | 1 | PONDICHERRY |
| 8348 | Puducherry | 34 | 26 | 2011 | 5 | 1 | 2011 | 2011-05-01 | 1 | 34 | PUDUCHERRY | 4 | KARAIKAL | 26 | Karaikal North | 1 | PONDICHERRY |
| 8349 | Puducherry | 34 | 26 | 2016 | 5 | 1 | 2016 | 2016-05-01 | 1 | 34 | PUDUCHERRY | 4 | KARAIKAL | 26 | Karaikal North | 1 | PONDICHERRY |
| 8350 | Puducherry | 34 | 27 | 2011 | 5 | 1 | 2011 | 2011-05-01 | 1 | 34 | PUDUCHERRY | 4 | KARAIKAL | 27 | Karaikal South | 1 | PONDICHERRY |
| 8351 | Puducherry | 34 | 27 | 2016 | 5 | 1 | 2016 | 2016-05-01 | 1 | 34 | PUDUCHERRY | 4 | KARAIKAL | 27 | Karaikal South | 1 | PONDICHERRY |
| 8352 | Puducherry | 34 | 28 | 2011 | 5 | 1 | 2011 | 2011-05-01 | 1 | 34 | PUDUCHERRY | 4 | KARAIKAL | 28 | Neravy- T.R. Pattin | 1 | PONDICHERRY |
| 8353 | Puducherry | 34 | 28 | 2016 | 5 | 1 | 2016 | 2016-05-01 | 1 | 34 | PUDUCHERRY | 4 | KARAIKAL | 28 | Neravy- T.R. Pattin | 1 | PONDICHERRY |
| 8354 | Puducherry | 34 | 29 | 2011 | 5 | 1 | 2011 | 2011-05-01 | 1 | 34 | PUDUCHERRY | 3 | MAHE | 29 | Mahe | 1 | PONDICHERRY |
| 8355 | Puducherry | 34 | 29 | 2016 | 5 | 1 | 2016 | 2016-05-01 | 1 | 34 | PUDUCHERRY | 3 | MAHE | 29 | Mahe | 1 | PONDICHERRY |
| 8356 | Puducherry | 34 | 30 | 2011 | 5 | 1 | 2011 | 2011-05-01 | 1 | 34 | PUDUCHERRY | 1 | YANAM | 30 | Yanam | 1 | PONDICHERRY |
| 8357 | Puducherry | 34 | 30 | 2016 | 5 | 1 | 2016 | 2016-05-01 | 1 | 34 | PUDUCHERRY | 1 | YANAM | 30 | Yanam | 1 | PONDICHERRY |
8358 rows × 17 columns
ac_gdf
| OBJECTID | ST_CODE | ST_NAME | DT_CODE | DIST_NAME | AC_NO | AC_NAME | PC_NO | PC_NAME | PC_ID | STATUS | Shape_Leng | Shape_Area | geometry | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| index_right | ||||||||||||||
| 0 | 1 | 13 | NAGALAND | 1 | MON | 41 | Tizit | 1 | NAGALAND | 1301 | Pre delimitation | 1.381854 | 0.055845 | POLYGON ((94.9457548574008 26.93518316946773, ... |
| 1 | 1 | 13 | NAGALAND | 1 | MON | 43 | Tapi | 1 | NAGALAND | 1301 | Pre delimitation | 1.056157 | 0.030387 | POLYGON ((95.22324386371338 26.75963707718944,... |
| 2 | 1 | 13 | NAGALAND | 1 | MON | 42 | Wakching | 1 | NAGALAND | 1301 | Pre delimitation | 0.980303 | 0.018828 | POLYGON ((94.86775129009004 26.82831138606167,... |
| 3 | 1 | 13 | NAGALAND | 2 | TUENSANG | 49 | Tamlu | 1 | NAGALAND | 1301 | Pre delimitation | 1.133296 | 0.021899 | POLYGON ((94.73862639329349 26.76868496204139,... |
| 4 | 1 | 13 | NAGALAND | 3 | MOKOKCHUNG | 21 | Tuli | 1 | NAGALAND | 1301 | Pre delimitation | 0.965989 | 0.022397 | POLYGON ((94.73862639329349 26.76868496204139,... |
| 5 | 1 | 13 | NAGALAND | 1 | MON | 44 | Phomching | 1 | NAGALAND | 1301 | Pre delimitation | 0.356973 | 0.007281 | POLYGON ((95.20991815389976 26.72866549251853,... |
| 6 | 1 | 13 | NAGALAND | 1 | MON | 46 | Mon Town | 1 | NAGALAND | 1301 | Pre delimitation | 0.492124 | 0.011957 | POLYGON ((94.96949610236328 26.72373432897615,... |
| 7 | 1 | 13 | NAGALAND | 1 | MON | 47 | Aboi | 1 | NAGALAND | 1301 | Pre delimitation | 0.664703 | 0.016869 | POLYGON ((94.99003335425596 26.62768812660579,... |
| 8 | 1 | 13 | NAGALAND | 3 | MOKOKCHUNG | 30 | Alungtaki | 1 | NAGALAND | 1301 | Pre delimitation | 1.111287 | 0.031180 | POLYGON ((94.52707905005815 26.69958256688199,... |
| 9 | 1 | 13 | NAGALAND | 1 | MON | 45 | Tehok | 1 | NAGALAND | 1301 | Pre delimitation | 0.580774 | 0.011101 | POLYGON ((95.12053707632509 26.62556110945769,... |
| 10 | 1 | 13 | NAGALAND | 2 | TUENSANG | 50 | Longleng | 1 | NAGALAND | 1301 | Pre delimitation | 0.725516 | 0.022976 | POLYGON ((94.73277705341832 26.59490452672259,... |
| 11 | 1 | 13 | NAGALAND | 3 | MOKOKCHUNG | 22 | Arkakong | 1 | NAGALAND | 1301 | Pre delimitation | 0.576670 | 0.016012 | POLYGON ((94.73272983001772 26.59489452536212,... |
| 12 | 1 | 13 | NAGALAND | 3 | MOKOKCHUNG | 29 | Jangpetkong | 1 | NAGALAND | 1301 | Pre delimitation | 0.790225 | 0.019501 | POLYGON ((94.59166983429549 26.54138626746231,... |
| 13 | 1 | 13 | NAGALAND | 1 | MON | 48 | Moka | 1 | NAGALAND | 1301 | Pre delimitation | 0.613600 | 0.013579 | POLYGON ((95.11353174969054 26.53153183372717,... |
| 14 | 1 | 13 | NAGALAND | 5 | WOKHA | 40 | Bhandari | 1 | NAGALAND | 1301 | Pre delimitation | 2.105271 | 0.078391 | POLYGON ((94.22785725650726 26.50144543915576,... |
| 15 | 1 | 13 | NAGALAND | 2 | TUENSANG | 51 | Noksen | 1 | NAGALAND | 1301 | Pre delimitation | 0.883926 | 0.020589 | POLYGON ((94.68651101617053 26.5247634442776, ... |
| 16 | 1 | 13 | NAGALAND | 2 | TUENSANG | 55 | Tobu | 1 | NAGALAND | 1301 | Pre delimitation | 0.675198 | 0.024041 | POLYGON ((95.02478163826203 26.4871035152151, ... |
| 17 | 1 | 13 | NAGALAND | 3 | MOKOKCHUNG | 24 | Angetyongpang | 1 | NAGALAND | 1301 | Pre delimitation | 0.680903 | 0.013847 | POLYGON ((94.69043964607289 26.4755964063491, ... |
| 18 | 1 | 13 | NAGALAND | 3 | MOKOKCHUNG | 23 | Impur | 1 | NAGALAND | 1301 | Pre delimitation | 0.449900 | 0.013073 | POLYGON ((94.60467622003159 26.4561825093154, ... |
| 19 | 1 | 13 | NAGALAND | 2 | TUENSANG | 56 | Noklak | 1 | NAGALAND | 1301 | Pre delimitation | 0.876690 | 0.032109 | POLYGON ((95.10811841912982 26.39522082138387,... |
| 20 | 1 | 13 | NAGALAND | 3 | MOKOKCHUNG | 28 | Koridang | 1 | NAGALAND | 1301 | Pre delimitation | 0.752880 | 0.016517 | POLYGON ((94.4926679209878 26.34862624470549, ... |
| 21 | 1 | 13 | NAGALAND | 2 | TUENSANG | 52 | Longkhim Chare | 1 | NAGALAND | 1301 | Pre delimitation | 0.784452 | 0.027747 | POLYGON ((94.65750690711815 26.34742268291052,... |
| 22 | 1 | 13 | NAGALAND | 2 | TUENSANG | 54 | Tuensang Sadar-II | 1 | NAGALAND | 1301 | Pre delimitation | 1.078362 | 0.043857 | POLYGON ((94.91999992425718 26.34637312911667,... |
| 23 | 1 | 13 | NAGALAND | 3 | MOKOKCHUNG | 25 | Monguya | 1 | NAGALAND | 1301 | Pre delimitation | 0.608629 | 0.008306 | POLYGON ((94.62470017936982 26.32930194712719,... |
| 24 | 1 | 13 | NAGALAND | 3 | MOKOKCHUNG | 27 | Mokokchung Town | 1 | NAGALAND | 1301 | Pre delimitation | 0.131384 | 0.001076 | POLYGON ((94.54252940101111 26.33431455507269,... |
| 25 | 1 | 13 | NAGALAND | 3 | MOKOKCHUNG | 26 | Aonglenden | 1 | NAGALAND | 1301 | Pre delimitation | 0.314304 | 0.003474 | POLYGON ((94.52133995267673 26.30919024633283,... |
| 26 | 1 | 13 | NAGALAND | 2 | TUENSANG | 53 | Tuensang Sadar-I | 1 | NAGALAND | 1301 | Pre delimitation | 0.288725 | 0.004838 | POLYGON ((94.79527878988432 26.30946500720438,... |
| 27 | 1 | 13 | NAGALAND | 5 | WOKHA | 39 | Sanis | 1 | NAGALAND | 1301 | Pre delimitation | 1.148655 | 0.030105 | POLYGON ((94.34819933373234 26.25056504923771,... |
| 28 | 1 | 13 | NAGALAND | 4 | ZUNHEBOTO | 31 | Akuluto | 1 | NAGALAND | 1301 | Pre delimitation | 0.620547 | 0.014271 | POLYGON ((94.48322360598468 26.29239831283195,... |
| 29 | 1 | 13 | NAGALAND | 4 | ZUNHEBOTO | 33 | Suruhuto | 1 | NAGALAND | 1301 | Pre delimitation | 0.568226 | 0.013466 | POLYGON ((94.5081128643173 26.21370854751149, ... |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 4152 | 78 | 9 | UTTAR PRADESH | 45 | ALLAHABAD | 258 | Handia | 78 | BHADOHI | 978 | None | 1.221541 | 0.026459 | POLYGON ((82.33191633527071 25.44923534473543,... |
| 4153 | 52 | 9 | UTTAR PRADESH | 45 | ALLAHABAD | 263 | Allahabad South | 52 | ALLAHABAD | 952 | None | 0.308595 | 0.002585 | POLYGON ((81.87433344513244 25.45406652075337,... |
| 4154 | 76 | 9 | UTTAR PRADESH | 67 | VARANASI | 386 | Shivpur | 76 | CHANDAULI | 976 | None | 1.126150 | 0.024123 | POLYGON ((83.12710597246274 25.44357179220452,... |
| 4155 | 78 | 9 | UTTAR PRADESH | 68 | SANT RAVIDAS NAGAR * | 393 | Gyanpur | 78 | BHADOHI | 978 | None | 1.422333 | 0.030785 | POLYGON ((82.38944645219209 25.44594297618744,... |
| 4156 | 52 | 9 | UTTAR PRADESH | 45 | ALLAHABAD | 260 | Karachhana | 52 | ALLAHABAD | 952 | None | 1.157874 | 0.032931 | POLYGON ((81.82137715063504 25.41293949925853,... |
| 4157 | 48 | 9 | UTTAR PRADESH | 40 | BANDA | 234 | Naraini (SC) | 48 | BANDA | 948 | None | 3.475376 | 0.107559 | POLYGON ((80.74833097129732 25.40767615672928,... |
| 4158 | 77 | 9 | UTTAR PRADESH | 67 | VARANASI | 391 | Sevapuri | 77 | VARANASI | 977 | None | 1.211015 | 0.024156 | POLYGON ((82.82223038402503 25.38401144946886,... |
| 4159 | 48 | 9 | UTTAR PRADESH | 41 | CHITRAKOOT * | 237 | Manikpur | 48 | BANDA | 948 | None | 3.417139 | 0.175099 | POLYGON ((81.49776040481891 25.26790492816997,... |
| 4160 | 77 | 9 | UTTAR PRADESH | 67 | VARANASI | 387 | Rohaniya | 77 | VARANASI | 977 | None | 0.985821 | 0.020446 | POLYGON ((82.86353564485421 25.37710985873304,... |
| 4161 | 77 | 9 | UTTAR PRADESH | 67 | VARANASI | 388 | Varanasi North | 77 | VARANASI | 977 | None | 0.340793 | 0.004158 | POLYGON ((83.03745467379423 25.33332910065752,... |
| 4162 | 78 | 9 | UTTAR PRADESH | 68 | SANT RAVIDAS NAGAR * | 394 | Aurai (SC) | 78 | BHADOHI | 978 | None | 1.053042 | 0.019486 | POLYGON ((82.47639097046698 25.35226362756441,... |
| 4163 | 52 | 9 | UTTAR PRADESH | 45 | ALLAHABAD | 264 | Bara (SC) | 52 | ALLAHABAD | 952 | None | 1.644742 | 0.084295 | POLYGON ((81.74993347485002 25.34606069764311,... |
| 4164 | 77 | 9 | UTTAR PRADESH | 67 | VARANASI | 389 | Varanasi South | 77 | VARANASI | 977 | None | 0.122368 | 0.000584 | POLYGON ((83.03745467379423 25.33332910065752,... |
| 4165 | 76 | 9 | UTTAR PRADESH | 66 | CHANDAULI * | 380 | Mughalsarai | 76 | CHANDAULI | 976 | None | 1.052822 | 0.022884 | POLYGON ((83.13732327095227 25.32277610952985,... |
| 4166 | 52 | 9 | UTTAR PRADESH | 45 | ALLAHABAD | 259 | Meja | 52 | ALLAHABAD | 952 | None | 1.208045 | 0.044396 | POLYGON ((82.22175459799638 25.27342988168374,... |
| 4167 | 77 | 9 | UTTAR PRADESH | 67 | VARANASI | 390 | Varanasi Cantt. | 77 | VARANASI | 977 | None | 0.336326 | 0.003619 | POLYGON ((83.00090658107393 25.31745955051787,... |
| 4168 | 79 | 9 | UTTAR PRADESH | 69 | MIRZAPUR | 397 | Majhawan | 79 | MIRZAPUR | 979 | None | 1.703413 | 0.061997 | POLYGON ((82.64149998793414 25.2505412587721, ... |
| 4169 | 79 | 9 | UTTAR PRADESH | 69 | MIRZAPUR | 395 | Chhanbey (SC) | 79 | MIRZAPUR | 979 | None | 3.353915 | 0.134513 | POLYGON ((82.34662684725123 25.20696243626747,... |
| 4170 | 46 | 9 | UTTAR PRADESH | 37 | LALITPUR | 226 | Lalitpur | 46 | JHANSI | 946 | None | 2.682238 | 0.192485 | POLYGON ((78.58016882513124 25.19122700562184,... |
| 4171 | 80 | 9 | UTTAR PRADESH | 66 | CHANDAULI * | 383 | Chakia (SC) | 80 | ROBERTSGANJ (SC) | 980 | None | 2.112128 | 0.119383 | POLYGON ((83.31480632035544 25.2531978102308, ... |
| 4172 | 79 | 9 | UTTAR PRADESH | 69 | MIRZAPUR | 396 | Mirzapur | 79 | MIRZAPUR | 979 | None | 1.020419 | 0.024429 | POLYGON ((82.57645444171919 25.24636920127767,... |
| 4173 | 79 | 9 | UTTAR PRADESH | 69 | MIRZAPUR | 398 | Chunar | 79 | MIRZAPUR | 979 | None | 1.443258 | 0.037048 | POLYGON ((83.03014026905822 25.24342130365028,... |
| 4174 | 52 | 9 | UTTAR PRADESH | 45 | ALLAHABAD | 265 | Koraon (SC) | 52 | ALLAHABAD | 952 | None | 1.939929 | 0.108972 | POLYGON ((81.96441033357007 25.1558874632359, ... |
| 4175 | 79 | 9 | UTTAR PRADESH | 69 | MIRZAPUR | 399 | Marihan | 79 | MIRZAPUR | 979 | None | 2.946889 | 0.145359 | POLYGON ((83.13272370903201 25.12748348347606,... |
| 4176 | 46 | 9 | UTTAR PRADESH | 37 | LALITPUR | 227 | Mehroni (SC) | 46 | JHANSI | 946 | None | 3.339006 | 0.256947 | POLYGON ((78.77402903711044 24.85108140048629,... |
| 4177 | 80 | 9 | UTTAR PRADESH | 70 | SONBHADRA | 400 | Ghorawal | 80 | ROBERTSGANJ (SC) | 980 | None | 2.354558 | 0.104874 | POLYGON ((83.09301859303372 24.79781630937521,... |
| 4178 | 80 | 9 | UTTAR PRADESH | 70 | SONBHADRA | 401 | Robertsganj | 80 | ROBERTSGANJ (SC) | 980 | None | 2.316555 | 0.161227 | POLYGON ((83.39349552090164 24.78226446543277,... |
| 4179 | 80 | 9 | UTTAR PRADESH | 70 | SONBHADRA | 402 | Obra | 80 | ROBERTSGANJ (SC) | 980 | None | 2.437449 | 0.135870 | POLYGON ((83.09499108776856 24.65526460727585,... |
| 4180 | 80 | 9 | UTTAR PRADESH | 70 | SONBHADRA | 403 | Duddhi (SC) | 80 | ROBERTSGANJ (SC) | 980 | None | 2.631747 | 0.202402 | POLYGON ((83.27368541514983 24.36496680167659,... |
| 4181 | 29 | 33 | TAMIL NADU | 20 | THIRUVARUR | 169 | Nannilam | 29 | NAGAPATTINAM (SC) | 3329 | None | 1.453697 | 0.033369 | POLYGON ((79.74810744410331 10.99637622558237,... |
4182 rows × 14 columns
# Merge all Scrapped files
files = os.listdir(os.path.join(data_folder, 'Scrapped'))
df_list = []
for file in files:
filepath = os.path.join(data_folder, 'Scrapped', file)
df = pd.read_csv(filepath)
df_list.append(df)
# Merge Files
df = pd.concat(df_list)
df
C:\Users\sandyjones\AppData\Local\conda\conda\envs\geo\lib\site-packages\ipykernel_launcher.py:9: FutureWarning: Sorting because non-concatenation axis is not aligned. A future version of pandas will change to not sort by default. To accept the future behavior, pass 'sort=False'. To retain the current behavior and silence the warning, pass 'sort=True'. if __name__ == '__main__':
| Amount disbursed to bank accounts | Amount disbursed to post office accounts | Amount sanctioned (Rs. In Lakhs) | Approved_Work_status_Amount sanctioned (Rs. In Lakhs) | Approved_Work_status_Total works | Block Name | Completed_Work_status_Amount sanctioned (Rs. In Lakhs) | Completed_Work_status_Total works | District Name | Labour exp. (disbursed + pending, Rs. In Lakhs) | ... | Total person-days worked by SCs | Total person-days worked by STs | Total person-days worked by women | Total persons allotted work | Total persons demanded work | Total persons with disability | Total persons worked | Total post office accounts | Total works | financial_year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 48381 | 1195 | 327 | 0.0 | 17.0 | Campbell Bay | 1.0 | 6.0 | NICOBARS | 1 | ... | 26 | 5 | 273 | 56 | 57 | 0 | 36 | 2 | 1039 | 2012 |
| 1 | 412497 | 0 | 12 | 0.0 | 12.0 | Campbell Bay | 0.0 | 0.0 | NICOBARS | 6 | ... | 0 | 0 | 1387 | 92 | 92 | 0 | 92 | 0 | 82 | 2012 |
| 2 | 21546 | 0 | 7 | 0.0 | 0.0 | Campbell Bay | 0.0 | 0.0 | NICOBARS | 2 | ... | 0 | 916 | 124 | 25 | 25 | 0 | 25 | 0 | 17 | 2012 |
| 3 | 288142 | 0 | 10 | 0.0 | 12.0 | Campbell Bay | 0.0 | 1.0 | NICOBARS | 6 | ... | 0 | 0 | 1508 | 123 | 123 | 1 | 122 | 0 | 61 | 2012 |
| 4 | 0 | 0 | 7 | 0.0 | 0.0 | Nancowry | 3.0 | 3.0 | NICOBARS | 3 | ... | 0 | 1659 | 176 | 61 | 61 | 0 | 61 | 0 | 27 | 2012 |
| 5 | 784143 | 0 | 20 | 0.0 | 14.0 | Nancowry | 10.0 | 5.0 | NICOBARS | 10 | ... | 0 | 5031 | 1180 | 151 | 151 | 0 | 148 | 0 | 67 | 2012 |
| 6 | 0 | 0 | 8 | 0.0 | 4.0 | Nancowry | 5.0 | 5.0 | NICOBARS | 5 | ... | 0 | 2577 | 714 | 92 | 92 | 1 | 88 | 0 | 43 | 2012 |
| 7 | 882819 | 0 | 14 | 0.0 | 3.0 | Nancowry | 12.0 | 8.0 | NICOBARS | 12 | ... | 0 | 6204 | 2127 | 190 | 190 | 1 | 184 | 0 | 59 | 2012 |
| 8 | 0 | 0 | 8 | 0.0 | 1.0 | Nancowry | 7.0 | 4.0 | NICOBARS | 6 | ... | 0 | 3816 | 520 | 108 | 108 | 0 | 105 | 0 | 25 | 2012 |
| 9 | 188940 | 0 | 202 | 0.0 | 10.0 | Nicobar | 15.0 | 9.0 | NICOBARS | 51 | ... | 0 | 23372 | 9779 | 792 | 792 | 1 | 749 | 0 | 332 | 2012 |
| 10 | 164828 | 0 | 30 | 0.0 | 0.0 | Diglipur | 23.0 | 5.0 | NORTH AND MIDDLE ANDAMAN | 15 | ... | 0 | 0 | 5590 | 280 | 280 | 0 | 254 | 0 | 38 | 2012 |
| 11 | 78142 | 0 | 42 | 0.0 | 0.0 | Diglipur | 28.0 | 3.0 | NORTH AND MIDDLE ANDAMAN | 20 | ... | 0 | 0 | 4157 | 402 | 402 | 0 | 344 | 0 | 38 | 2012 |
| 12 | 0 | 0 | 82 | 0.0 | 1.0 | Diglipur | 42.0 | 10.0 | NORTH AND MIDDLE ANDAMAN | 19 | ... | 0 | 0 | 5506 | 335 | 334 | 1 | 297 | 0 | 77 | 2012 |
| 13 | 0 | 0 | 40 | 0.0 | 0.0 | Diglipur | 17.0 | 2.0 | NORTH AND MIDDLE ANDAMAN | 17 | ... | 0 | 0 | 6169 | 348 | 346 | 1 | 296 | 0 | 36 | 2012 |
| 14 | 56426 | 182628 | 47 | 0.0 | 2.0 | Diglipur | 14.0 | 7.0 | NORTH AND MIDDLE ANDAMAN | 16 | ... | 0 | 0 | 4913 | 594 | 594 | 3 | 536 | 91 | 76 | 2012 |
| 15 | 0 | 0 | 31 | 0.0 | 2.0 | Diglipur | 24.0 | 6.0 | NORTH AND MIDDLE ANDAMAN | 21 | ... | 0 | 0 | 4185 | 351 | 349 | 10 | 309 | 0 | 58 | 2012 |
| 16 | 3916 | 0 | 46 | 0.0 | 2.0 | Diglipur | 37.0 | 5.0 | NORTH AND MIDDLE ANDAMAN | 35 | ... | 0 | 0 | 9954 | 646 | 636 | 0 | 552 | 0 | 48 | 2012 |
| 17 | 0 | 0 | 31 | 0.0 | 2.0 | Diglipur | 21.0 | 5.0 | NORTH AND MIDDLE ANDAMAN | 22 | ... | 0 | 0 | 4771 | 334 | 334 | 4 | 304 | 0 | 44 | 2012 |
| 18 | 0 | 0 | 47 | 0.0 | 0.0 | Diglipur | 23.0 | 1.0 | NORTH AND MIDDLE ANDAMAN | 17 | ... | 0 | 0 | 1808 | 260 | 255 | 0 | 242 | 0 | 10 | 2012 |
| 19 | 244394 | 0 | 92 | 0.0 | 2.0 | Diglipur | 37.0 | 9.0 | NORTH AND MIDDLE ANDAMAN | 37 | ... | 0 | 0 | 11853 | 742 | 739 | 0 | 685 | 0 | 83 | 2012 |
| 20 | 1075832 | 0 | 70 | 0.0 | 0.0 | Diglipur | 13.0 | 3.0 | NORTH AND MIDDLE ANDAMAN | 33 | ... | 0 | 0 | 11613 | 446 | 440 | 0 | 408 | 0 | 38 | 2012 |
| 21 | 0 | 0 | 41 | 0.0 | 3.0 | Diglipur | 32.0 | 5.0 | NORTH AND MIDDLE ANDAMAN | 19 | ... | 0 | 0 | 4063 | 316 | 316 | 2 | 298 | 0 | 46 | 2012 |
| 22 | 0 | 0 | 54 | 0.0 | 0.0 | Diglipur | 21.0 | 11.0 | NORTH AND MIDDLE ANDAMAN | 21 | ... | 0 | 0 | 9496 | 555 | 551 | 1 | 460 | 0 | 72 | 2012 |
| 23 | 150410 | 6230 | 45 | 0.0 | 1.0 | Diglipur | 29.0 | 4.0 | NORTH AND MIDDLE ANDAMAN | 27 | ... | 0 | 0 | 7532 | 378 | 374 | 3 | 354 | 4 | 51 | 2012 |
| 24 | 74048 | 0 | 15 | 0.0 | 1.0 | Diglipur | 10.0 | 3.0 | NORTH AND MIDDLE ANDAMAN | 7 | ... | 0 | 0 | 2003 | 226 | 222 | 0 | 173 | 0 | 25 | 2012 |
| 25 | 14240 | 0 | 4341917 | 0.0 | 7.0 | Mayabunder | 3864203.0 | 5.0 | NORTH AND MIDDLE ANDAMAN | 37 | ... | 0 | 0 | 8578 | 434 | 434 | 0 | 433 | 0 | 48 | 2012 |
| 26 | 1290144 | 0 | 7114028 | 0.0 | 3.0 | Mayabunder | 1878501.0 | 4.0 | NORTH AND MIDDLE ANDAMAN | 38 | ... | 0 | 0 | 7008 | 386 | 388 | 0 | 385 | 0 | 46 | 2012 |
| 27 | 16910 | 0 | 3679558 | 0.0 | 0.0 | Mayabunder | 1377881.0 | 6.0 | NORTH AND MIDDLE ANDAMAN | 16 | ... | 0 | 0 | 2731 | 150 | 150 | 0 | 150 | 0 | 47 | 2012 |
| 28 | 340336 | 0 | 7608985 | 0.0 | 10.0 | Mayabunder | 2869372.0 | 4.0 | NORTH AND MIDDLE ANDAMAN | 47 | ... | 0 | 0 | 11100 | 570 | 571 | 0 | 568 | 0 | 54 | 2012 |
| 29 | 532932 | 0 | 1340646 | 0.0 | 4.0 | Mayabunder | 856650.0 | 4.0 | NORTH AND MIDDLE ANDAMAN | 10 | ... | 0 | 0 | 9360 | 294 | 294 | 0 | 294 | 0 | 43 | 2012 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 106924 | 10334569 | 97888 | 848 | NaN | NaN | RAGHUNATHPUR-II | NaN | NaN | PURULIA | 103 | ... | 7923 | 21956 | 24195 | 2805 | 2805 | 25 | 1727 | 1934 | 5816 | 2017 |
| 106925 | 8168598 | 2247196 | 438 | NaN | NaN | RAGHUNATHPUR-II | NaN | NaN | PURULIA | 105 | ... | 37393 | 3441 | 23370 | 3982 | 3984 | 26 | 1982 | 2725 | 3217 | 2017 |
| 106926 | 3553754 | 0 | 360 | NaN | NaN | SANTURI | NaN | NaN | PURULIA | 36 | ... | 16922 | 4369 | 11933 | 1340 | 1339 | 14 | 722 | 1739 | 2086 | 2017 |
| 106927 | 14342705 | 5521 | 1057 | NaN | NaN | SANTURI | NaN | NaN | PURULIA | 147 | ... | 18995 | 40825 | 42956 | 3542 | 3542 | 38 | 2801 | 700 | 2500 | 2017 |
| 106928 | 8197670 | 0 | 444 | NaN | NaN | SANTURI | NaN | NaN | PURULIA | 82 | ... | 10108 | 13057 | 15003 | 1592 | 1592 | 9 | 1313 | 281 | 3310 | 2017 |
| 106929 | 6753142 | 428040 | 566 | NaN | NaN | SANTURI | NaN | NaN | PURULIA | 72 | ... | 30925 | 2127 | 27008 | 2550 | 2550 | 32 | 1945 | 1366 | 3613 | 2017 |
| 106930 | 5518460 | 0 | 457 | NaN | NaN | SANTURI | NaN | NaN | PURULIA | 56 | ... | 7104 | 25503 | 17819 | 1979 | 1979 | 56 | 1396 | 487 | 2573 | 2017 |
| 106931 | 3540582 | 180484 | 385 | NaN | NaN | SANTURI | NaN | NaN | PURULIA | 38 | ... | 9863 | 12513 | 11092 | 1528 | 1528 | 11 | 857 | 1598 | 2511 | 2017 |
| 106932 | 13625280 | 0 | 877 | NaN | NaN | Khoribari | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 137 | ... | 40347 | 13973 | 47066 | 1847 | 1847 | 19 | 1730 | 381 | 5717 | 2017 |
| 106933 | 17096940 | 0 | 1027 | NaN | NaN | Khoribari | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 170 | ... | 57306 | 25075 | 52795 | 2097 | 2097 | 0 | 1970 | 1802 | 3139 | 2017 |
| 106934 | 14412240 | 0 | 731 | NaN | NaN | Khoribari | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 144 | ... | 55862 | 8392 | 60938 | 1780 | 1780 | 25 | 1735 | 281 | 2534 | 2017 |
| 106935 | 16777256 | 0 | 884 | NaN | NaN | Khoribari | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 170 | ... | 72657 | 10651 | 54664 | 2178 | 2178 | 0 | 2081 | 1332 | 4067 | 2017 |
| 106936 | 7774024 | 0 | 468 | NaN | NaN | Matigara | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 78 | ... | 36469 | 1083 | 25972 | 1094 | 1094 | 1 | 1065 | 551 | 1412 | 2017 |
| 106937 | 11880180 | 0 | 669 | NaN | NaN | Matigara | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 121 | ... | 21585 | 22408 | 52214 | 853 | 853 | 2 | 831 | 297 | 965 | 2017 |
| 106938 | 8598620 | 0 | 571 | NaN | NaN | Matigara | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 86 | ... | 32764 | 1906 | 37590 | 770 | 770 | 0 | 668 | 359 | 935 | 2017 |
| 106939 | 12731752 | 0 | 667 | NaN | NaN | Matigara | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 127 | ... | 41995 | 126 | 57034 | 827 | 827 | 13 | 751 | 244 | 639 | 2017 |
| 106940 | 13612488 | 0 | 710 | NaN | NaN | Matigara | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 135 | ... | 32858 | 31088 | 41350 | 1423 | 1426 | 4 | 1325 | 298 | 1825 | 2017 |
| 106941 | 17647920 | 0 | 1435 | NaN | NaN | Naxalbari | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 175 | ... | 74050 | 3742 | 77052 | 1817 | 1817 | 12 | 1768 | 572 | 1687 | 2017 |
| 106942 | 20450660 | 0 | 847 | NaN | NaN | Naxalbari | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 205 | ... | 20202 | 65415 | 61640 | 2023 | 2023 | 0 | 2006 | 85 | 2492 | 2017 |
| 106943 | 9795060 | 0 | 519 | NaN | NaN | Naxalbari | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 99 | ... | 28897 | 19272 | 46761 | 675 | 675 | 1 | 666 | 22 | 1032 | 2017 |
| 106944 | 24039180 | 0 | 1708 | NaN | NaN | Naxalbari | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 244 | ... | 41961 | 28614 | 61380 | 2279 | 2280 | 14 | 2245 | 362 | 3034 | 2017 |
| 106945 | 17662140 | 0 | 1257 | NaN | NaN | Naxalbari | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 178 | ... | 43698 | 16947 | 63556 | 2277 | 2277 | 3 | 2209 | 0 | 1693 | 2017 |
| 106946 | 7904112 | 0 | 418 | NaN | NaN | Naxalbari | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 79 | ... | 3790 | 25626 | 40830 | 567 | 567 | 0 | 566 | 612 | 1049 | 2017 |
| 106947 | 12777216 | 0 | 1023 | NaN | NaN | Phansidewa | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 128 | ... | 12328 | 15593 | 20966 | 1804 | 1808 | 1 | 1517 | 947 | 2267 | 2017 |
| 106948 | 20092576 | 0 | 1654 | NaN | NaN | Phansidewa | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 198 | ... | 29500 | 49551 | 42795 | 2304 | 2304 | 11 | 2191 | 539 | 1523 | 2017 |
| 106949 | 16286338 | 8800 | 523 | NaN | NaN | Phansidewa | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 159 | ... | 6101 | 4368 | 23659 | 2363 | 2363 | 0 | 2198 | 774 | 4539 | 2017 |
| 106950 | 15877824 | 19360 | 1229 | NaN | NaN | Phansidewa | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 155 | ... | 27076 | 37795 | 33354 | 2187 | 2187 | 4 | 2019 | 612 | 1719 | 2017 |
| 106951 | 20107700 | 0 | 1048 | NaN | NaN | Phansidewa | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 201 | ... | 11479 | 69106 | 49520 | 2401 | 2402 | 6 | 2182 | 702 | 1260 | 2017 |
| 106952 | 16102484 | 0 | 1350 | NaN | NaN | Phansidewa | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 161 | ... | 48751 | 5241 | 52190 | 2336 | 2359 | 0 | 2102 | 920 | 2074 | 2017 |
| 106953 | 21957688 | 0 | 733 | NaN | NaN | Phansidewa | NaN | NaN | SILIGURI MAHAKUMA PARISAD | 216 | ... | 46217 | 7608 | 43426 | 2689 | 2689 | 19 | 2494 | 866 | 1424 | 2017 |
981716 rows × 55 columns
# Read Geocoded Panchayat Data
geocoded_panchayat = os.path.join(data_folder, 'geocoded_panchayats.csv')
geo_df = pd.read_csv(geocoded_panchayat)
# Join AC Data
df = pd.merge(df, geo_df, how='inner', on=['District Name', 'Block Name', 'Panchayat Name'])
geometry = [Point(xy) for xy in zip(df.lon, df.lat)]
crs = {'init': 'epsg:4326'}
geo_df = gpd.GeoDataFrame(df, crs=crs, geometry=geometry)
geo_df.to_csv(os.path.join(output_folder, 'geocoded_data.csv'), encoding='utf-8', index=False)
geo_df
| Amount disbursed to bank accounts | Amount disbursed to post office accounts | Amount sanctioned (Rs. In Lakhs) | Approved_Work_status_Amount sanctioned (Rs. In Lakhs) | Approved_Work_status_Total works | Block Name | Completed_Work_status_Amount sanctioned (Rs. In Lakhs) | Completed_Work_status_Total works | District Name | Labour exp. (disbursed + pending, Rs. In Lakhs) | ... | Total persons demanded work | Total persons with disability | Total persons worked | Total post office accounts | Total works | financial_year | lat | lon | id | geometry | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 48381 | 1195 | 327 | 0.0 | 17.0 | Campbell Bay | 1.0 | 6.0 | NICOBARS | 1 | ... | 57 | 0 | 36 | 2 | 1039 | 2012 | 7.009279 | 93.926589 | 1000000 | POINT (93.92658878773626 7.009278839995805) |
| 1 | 48381 | 1195 | 327 | 0.0 | 17.0 | Campbell Bay | 1.0 | 6.0 | NICOBARS | 1 | ... | 57 | 0 | 36 | 2 | 1039 | 2012 | 7.009279 | 93.926589 | 1000000 | POINT (93.92658878773626 7.009278839995805) |
| 2 | 34230 | 0 | 331 | NaN | NaN | Campbell Bay | NaN | NaN | NICOBARS | 3 | ... | 123 | 0 | 71 | 2 | 984 | 2013 | 7.009279 | 93.926589 | 1000000 | POINT (93.92658878773626 7.009278839995805) |
| 3 | 13630 | 0 | 0 | NaN | NaN | Campbell Bay | NaN | NaN | NICOBARS | 0 | ... | 39 | 0 | 20 | 2 | 0 | 2014 | 7.009279 | 93.926589 | 1000000 | POINT (93.92658878773626 7.009278839995805) |
| 4 | 412497 | 0 | 12 | 0.0 | 12.0 | Campbell Bay | 0.0 | 0.0 | NICOBARS | 6 | ... | 92 | 0 | 92 | 0 | 82 | 2012 | 6.996494 | 93.896547 | 1000001 | POINT (93.89654712947709 6.996494141325315) |
| 5 | 412497 | 0 | 12 | 0.0 | 12.0 | Campbell Bay | 0.0 | 0.0 | NICOBARS | 6 | ... | 92 | 0 | 92 | 0 | 82 | 2012 | 6.996494 | 93.896547 | 1000001 | POINT (93.89654712947709 6.996494141325315) |
| 6 | 712824 | 0 | 15 | NaN | NaN | Campbell Bay | NaN | NaN | NICOBARS | 2 | ... | 119 | 0 | 119 | 0 | 91 | 2013 | 6.996494 | 93.896547 | 1000001 | POINT (93.89654712947709 6.996494141325315) |
| 7 | 141482 | 0 | 0 | NaN | NaN | Campbell Bay | NaN | NaN | NICOBARS | 0 | ... | 94 | 0 | 66 | 0 | 0 | 2014 | 6.996494 | 93.896547 | 1000001 | POINT (93.89654712947709 6.996494141325315) |
| 8 | 21546 | 0 | 7 | 0.0 | 0.0 | Campbell Bay | 0.0 | 0.0 | NICOBARS | 2 | ... | 25 | 0 | 25 | 0 | 17 | 2012 | 7.325778 | 93.692753 | 1000002 | POINT (93.69275309999999 7.325778) |
| 9 | 21546 | 0 | 7 | 0.0 | 0.0 | Campbell Bay | 0.0 | 0.0 | NICOBARS | 2 | ... | 25 | 0 | 25 | 0 | 17 | 2012 | 7.325778 | 93.692753 | 1000002 | POINT (93.69275309999999 7.325778) |
| 10 | 147840 | 0 | 14 | NaN | NaN | Campbell Bay | NaN | NaN | NICOBARS | 4 | ... | 122 | 0 | 122 | 0 | 32 | 2013 | 7.325778 | 93.692753 | 1000002 | POINT (93.69275309999999 7.325778) |
| 11 | 91075 | 0 | 0 | NaN | NaN | Campbell Bay | NaN | NaN | NICOBARS | 0 | ... | 0 | 0 | 0 | 0 | 0 | 2014 | 7.325778 | 93.692753 | 1000002 | POINT (93.69275309999999 7.325778) |
| 12 | 288142 | 0 | 10 | 0.0 | 12.0 | Campbell Bay | 0.0 | 1.0 | NICOBARS | 6 | ... | 123 | 1 | 122 | 0 | 61 | 2012 | 6.883300 | 93.889787 | 1000003 | POINT (93.88978685151821 6.883299907186833) |
| 13 | 288142 | 0 | 10 | 0.0 | 12.0 | Campbell Bay | 0.0 | 1.0 | NICOBARS | 6 | ... | 123 | 1 | 122 | 0 | 61 | 2012 | 6.883300 | 93.889787 | 1000003 | POINT (93.88978685151821 6.883299907186833) |
| 14 | 694218 | 0 | 18 | NaN | NaN | Campbell Bay | NaN | NaN | NICOBARS | 9 | ... | 195 | 1 | 190 | 0 | 70 | 2013 | 6.883300 | 93.889787 | 1000003 | POINT (93.88978685151821 6.883299907186833) |
| 15 | 18130 | 0 | 0 | NaN | NaN | Campbell Bay | NaN | NaN | NICOBARS | 0 | ... | 30 | 0 | 29 | 0 | 0 | 2014 | 6.883300 | 93.889787 | 1000003 | POINT (93.88978685151821 6.883299907186833) |
| 16 | 0 | 0 | 7 | 0.0 | 0.0 | Nancowry | 3.0 | 3.0 | NICOBARS | 3 | ... | 61 | 0 | 61 | 0 | 27 | 2012 | 8.456021 | 93.042598 | 1000004 | POINT (93.0425977 8.4560212) |
| 17 | 0 | 0 | 7 | 0.0 | 0.0 | Nancowry | 3.0 | 3.0 | NICOBARS | 3 | ... | 61 | 0 | 61 | 0 | 27 | 2012 | 8.456021 | 93.042598 | 1000004 | POINT (93.0425977 8.4560212) |
| 18 | 0 | 0 | 4 | NaN | NaN | Nancowry | NaN | NaN | NICOBARS | 0 | ... | 0 | 0 | 0 | 0 | 12 | 2013 | 8.456021 | 93.042598 | 1000004 | POINT (93.0425977 8.4560212) |
| 19 | 0 | 0 | 0 | NaN | NaN | Nancowry | NaN | NaN | NICOBARS | 0 | ... | 65 | 1 | 31 | 0 | 0 | 2014 | 8.456021 | 93.042598 | 1000004 | POINT (93.0425977 8.4560212) |
| 20 | 784143 | 0 | 20 | 0.0 | 14.0 | Nancowry | 10.0 | 5.0 | NICOBARS | 10 | ... | 151 | 0 | 148 | 0 | 67 | 2012 | 21.065458 | 79.498997 | 1000005 | POINT (79.49899671329383 21.06545799150364) |
| 21 | 784143 | 0 | 20 | 0.0 | 14.0 | Nancowry | 10.0 | 5.0 | NICOBARS | 10 | ... | 151 | 0 | 148 | 0 | 67 | 2012 | 21.065458 | 79.498997 | 1000005 | POINT (79.49899671329383 21.06545799150364) |
| 22 | 1296120 | 0 | 37 | NaN | NaN | Nancowry | NaN | NaN | NICOBARS | 24 | ... | 330 | 1 | 326 | 0 | 85 | 2013 | 21.065458 | 79.498997 | 1000005 | POINT (79.49899671329383 21.06545799150364) |
| 23 | 655100 | 0 | 0 | NaN | NaN | Nancowry | NaN | NaN | NICOBARS | 0 | ... | 127 | 0 | 72 | 0 | 0 | 2014 | 21.065458 | 79.498997 | 1000005 | POINT (79.49899671329383 21.06545799150364) |
| 24 | 0 | 0 | 8 | 0.0 | 4.0 | Nancowry | 5.0 | 5.0 | NICOBARS | 5 | ... | 92 | 1 | 88 | 0 | 43 | 2012 | 7.967549 | 93.359045 | 1000006 | POINT (93.3590446 7.9675489) |
| 25 | 0 | 0 | 8 | 0.0 | 4.0 | Nancowry | 5.0 | 5.0 | NICOBARS | 5 | ... | 92 | 1 | 88 | 0 | 43 | 2012 | 7.967549 | 93.359045 | 1000006 | POINT (93.3590446 7.9675489) |
| 26 | 0 | 0 | 10 | NaN | NaN | Nancowry | NaN | NaN | NICOBARS | 5 | ... | 140 | 0 | 137 | 0 | 54 | 2013 | 7.967549 | 93.359045 | 1000006 | POINT (93.3590446 7.9675489) |
| 27 | 0 | 0 | 0 | NaN | NaN | Nancowry | NaN | NaN | NICOBARS | 0 | ... | 0 | 0 | 0 | 0 | 0 | 2014 | 7.967549 | 93.359045 | 1000006 | POINT (93.3590446 7.9675489) |
| 28 | 882819 | 0 | 14 | 0.0 | 3.0 | Nancowry | 12.0 | 8.0 | NICOBARS | 12 | ... | 190 | 1 | 184 | 0 | 59 | 2012 | 7.976840 | 93.550907 | 1000007 | POINT (93.5509074 7.976840399999999) |
| 29 | 882819 | 0 | 14 | 0.0 | 3.0 | Nancowry | 12.0 | 8.0 | NICOBARS | 12 | ... | 190 | 1 | 184 | 0 | 59 | 2012 | 7.976840 | 93.550907 | 1000007 | POINT (93.5509074 7.976840399999999) |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 946781 | 10016532 | 0 | 574 | NaN | NaN | JHARGRAM | NaN | NaN | JHARGRAM | 100 | ... | 2009 | 1 | 1781 | 469 | 3594 | 2017 | 22.385609 | 86.996699 | 1261011 | POINT (86.99669908106674 22.38560863039944) |
| 946782 | 8152884 | 0 | 528 | NaN | NaN | JHARGRAM | NaN | NaN | JHARGRAM | 84 | ... | 1972 | 1 | 1674 | 480 | 3135 | 2017 | 22.369905 | 87.125101 | 1261012 | POINT (87.1251014713233 22.36990517953286) |
| 946783 | 7086616 | 0 | 645 | NaN | NaN | JHARGRAM | NaN | NaN | JHARGRAM | 72 | ... | 2005 | 0 | 1583 | 104 | 3164 | 2017 | 22.380763 | 86.995109 | 1261013 | POINT (86.99510861655114 22.38076321684423) |
| 946784 | 9149328 | 0 | 556 | NaN | NaN | JHARGRAM | NaN | NaN | JHARGRAM | 90 | ... | 1954 | 0 | 1820 | 85 | 3576 | 2017 | 22.285662 | 86.980339 | 1261014 | POINT (86.98033948683016 22.28566177340342) |
| 946785 | 12003196 | 0 | 666 | NaN | NaN | JHARGRAM | NaN | NaN | JHARGRAM | 120 | ... | 2257 | 9 | 2176 | 485 | 3870 | 2017 | 22.477238 | 87.010400 | 1261015 | POINT (87.0103999135906 22.47723790821667) |
| 946786 | 7908592 | 0 | 538894 | NaN | NaN | JHARGRAM | NaN | NaN | JHARGRAM | 81 | ... | 1638 | 0 | 1492 | 1 | 3659 | 2017 | 22.377526 | 86.926356 | 1261016 | POINT (86.92635587841463 22.37752644100613) |
| 946787 | 5938380 | 0 | 410 | NaN | NaN | JHARGRAM | NaN | NaN | JHARGRAM | 60 | ... | 1263 | 0 | 1129 | 5 | 3291 | 2017 | 22.375892 | 87.153331 | 1261017 | POINT (87.15333073627596 22.375891672548) |
| 946788 | 12212726 | 0 | 644 | NaN | NaN | JHARGRAM | NaN | NaN | JHARGRAM | 122 | ... | 2513 | 5 | 2387 | 359 | 4256 | 2017 | 21.873296 | 87.084168 | 1261018 | POINT (87.08416819209673 21.87329583481727) |
| 946789 | 33141132 | 0 | 1895 | NaN | NaN | NAYAGRAM | NaN | NaN | JHARGRAM | 329 | ... | 5243 | 93 | 4575 | 403 | 4103 | 2017 | 21.900784 | 87.050799 | 1261019 | POINT (87.05079912192285 21.90078376245537) |
| 946790 | 26415250 | 0 | 1359 | NaN | NaN | NAYAGRAM | NaN | NaN | JHARGRAM | 254 | ... | 3139 | 20 | 2898 | 30 | 3539 | 2017 | 21.896406 | 87.079674 | 1261020 | POINT (87.0796740042736 21.89640588744141) |
| 946791 | 23938144 | 0 | 1300 | NaN | NaN | NAYAGRAM | NaN | NaN | JHARGRAM | 276 | ... | 3962 | 3 | 3293 | 94 | 2950 | 2017 | 22.372433 | 87.154985 | 1261021 | POINT (87.15498530996014 22.37243329445784) |
| 946792 | 23714672 | 0 | 1316 | NaN | NaN | NAYAGRAM | NaN | NaN | JHARGRAM | 228 | ... | 3309 | 0 | 3005 | 37 | 3066 | 2017 | 21.985373 | 87.111380 | 1261022 | POINT (87.11137952928858 21.98537278579145) |
| 946793 | 21791660 | 0 | 1398 | NaN | NaN | NAYAGRAM | NaN | NaN | JHARGRAM | 210 | ... | 3070 | 26 | 2616 | 131 | 2743 | 2017 | 21.979447 | 87.148221 | 1261023 | POINT (87.14822143245193 21.97944666866407) |
| 946794 | 25508156 | 0 | 1581 | NaN | NaN | NAYAGRAM | NaN | NaN | JHARGRAM | 246 | ... | 3995 | 29 | 3707 | 88 | 3146 | 2017 | 22.086912 | 87.017334 | 1261024 | POINT (87.01733447908759 22.08691224033913) |
| 946795 | 22356060 | 0 | 1147 | NaN | NaN | NAYAGRAM | NaN | NaN | JHARGRAM | 222 | ... | 2842 | 10 | 2731 | 42 | 3015 | 2017 | 21.960476 | 87.063864 | 1261025 | POINT (87.06386353579718 21.96047606854223) |
| 946796 | 24422652 | 11520 | 8341350 | NaN | NaN | NAYAGRAM | NaN | NaN | JHARGRAM | 249 | ... | 3408 | 13 | 2956 | 462 | 2124 | 2017 | 21.983613 | 87.210078 | 1261026 | POINT (87.21007838446394 21.98361256350585) |
| 946797 | 51678196 | 0 | 3462 | NaN | NaN | NAYAGRAM | NaN | NaN | JHARGRAM | 526 | ... | 6724 | 11 | 6237 | 76 | 6151 | 2017 | 22.005273 | 87.146044 | 1261027 | POINT (87.14604373204861 22.00527281995051) |
| 946798 | 26532896 | 0 | 3480473 | NaN | NaN | NAYAGRAM | NaN | NaN | JHARGRAM | 236 | ... | 4048 | 3 | 3770 | 0 | 3259 | 2017 | 22.066601 | 87.152645 | 1261028 | POINT (87.15264514384776 22.06660092689146) |
| 946799 | 25646300 | 0 | 1218 | NaN | NaN | NAYAGRAM | NaN | NaN | JHARGRAM | 267 | ... | 3426 | 3 | 2966 | 8 | 2699 | 2017 | 22.035067 | 87.170341 | 1261029 | POINT (87.1703410736976 22.03506674075359) |
| 946800 | 18197592 | 0 | 1291 | NaN | NaN | NAYAGRAM | NaN | NaN | JHARGRAM | 183 | ... | 2988 | 4 | 2750 | 69 | 2581 | 2017 | 22.162124 | 87.006604 | 1261030 | POINT (87.00660433119089 22.16212401833229) |
| 946801 | 16195292 | 0 | 550 | NaN | NaN | SANKRAIL | NaN | NaN | JHARGRAM | 160 | ... | 2728 | 8 | 2633 | 24 | 3653 | 2017 | 22.154164 | 87.092958 | 1261031 | POINT (87.09295836166208 22.15416390870998) |
| 946802 | 13695352 | 0 | 882 | NaN | NaN | SANKRAIL | NaN | NaN | JHARGRAM | 137 | ... | 1932 | 1 | 1797 | 0 | 3987 | 2017 | 22.237054 | 87.089601 | 1261032 | POINT (87.0896011921553 22.23705432233832) |
| 946803 | 9452556 | 1232 | 561 | NaN | NaN | SANKRAIL | NaN | NaN | JHARGRAM | 95 | ... | 1899 | 0 | 1714 | 182 | 5067 | 2017 | 22.147340 | 87.143844 | 1261033 | POINT (87.14384423761818 22.14734020481125) |
| 946804 | 5830406 | 0 | 230 | NaN | NaN | SANKRAIL | NaN | NaN | JHARGRAM | 58 | ... | 881 | 1 | 803 | 26 | 3134 | 2017 | 21.976395 | 87.212614 | 1261034 | POINT (87.2126137347246 21.97639516033443) |
| 946805 | 9773556 | 0 | 448 | NaN | NaN | SANKRAIL | NaN | NaN | JHARGRAM | 97 | ... | 2005 | 1 | 1839 | 72 | 3183 | 2017 | 22.175490 | 87.165471 | 1261035 | POINT (87.16547087355448 22.17549003037828) |
| 946806 | 14094220 | 0 | 693 | NaN | NaN | SANKRAIL | NaN | NaN | JHARGRAM | 142 | ... | 2370 | 1 | 2298 | 164 | 3818 | 2017 | 22.143824 | 87.123349 | 1261036 | POINT (87.12334897947655 22.14382421601348) |
| 946807 | 9392235 | 0 | 396 | NaN | NaN | SANKRAIL | NaN | NaN | JHARGRAM | 93 | ... | 1987 | 0 | 1943 | 174 | 1833 | 2017 | 22.260671 | 87.159645 | 1261037 | POINT (87.15964491355969 22.26067137837323) |
| 946808 | 13228526 | 0 | 516 | NaN | NaN | SANKRAIL | NaN | NaN | JHARGRAM | 132 | ... | 2045 | 2 | 1872 | 112 | 3202 | 2017 | 22.181524 | 87.037965 | 1261038 | POINT (87.03796474413494 22.18152361012664) |
| 946809 | 18050855 | 1056 | 983 | NaN | NaN | SANKRAIL | NaN | NaN | JHARGRAM | 184 | ... | 2755 | 4 | 2468 | 88 | 5052 | 2017 | 22.165943 | 87.084149 | 1261039 | POINT (87.08414870943486 22.16594308984293) |
| 946810 | 16448040 | 0 | 508 | NaN | NaN | SANKRAIL | NaN | NaN | JHARGRAM | 168 | ... | 2543 | 1 | 2485 | 29 | 3485 | 2017 | 22.196941 | 87.138044 | 1261040 | POINT (87.13804425959637 22.19694053549862) |
946811 rows × 59 columns
# Spatial Join
joined_df = gpd.sjoin(geo_df, ac_gdf, how='inner', op='within')
joined_df = joined_df[joined_df.columns[:-3]]
joined_df.to_csv(os.path.join(output_folder, 'geocoded_joined_data.csv'), encoding='utf-8', index=False)
joined_df
| Amount disbursed to bank accounts | Amount disbursed to post office accounts | Amount sanctioned (Rs. In Lakhs) | Approved_Work_status_Amount sanctioned (Rs. In Lakhs) | Approved_Work_status_Total works | Block Name | Completed_Work_status_Amount sanctioned (Rs. In Lakhs) | Completed_Work_status_Total works | District Name | Labour exp. (disbursed + pending, Rs. In Lakhs) | ... | OBJECTID | ST_CODE | ST_NAME | DT_CODE | DIST_NAME | AC_NO | AC_NAME | PC_NO | PC_NAME | PC_ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20 | 784143 | 0 | 20 | 0.0 | 14.0 | Nancowry | 10.0 | 5.0 | NICOBARS | 10 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 21 | 784143 | 0 | 20 | 0.0 | 14.0 | Nancowry | 10.0 | 5.0 | NICOBARS | 10 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 22 | 1296120 | 0 | 37 | NaN | NaN | Nancowry | NaN | NaN | NICOBARS | 24 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 23 | 655100 | 0 | 0 | NaN | NaN | Nancowry | NaN | NaN | NICOBARS | 0 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 319344 | 0 | 0 | 0 | NaN | NaN | MEHKAR | NaN | NaN | BULDHANA | 0 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 319345 | 0 | 0 | 0 | NaN | NaN | MEHKAR | NaN | NaN | BULDHANA | 0 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 319346 | 0 | 0 | 0 | NaN | NaN | MEHKAR | NaN | NaN | BULDHANA | 0 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340288 | 312726 | 0 | 259171 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 4 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340289 | 1008247 | 648 | 259199 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 10 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340290 | 1115005 | 0 | 237427 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 12 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340291 | 2286 | 0 | 0 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 0 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340292 | 0 | 0 | 0 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 0 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340293 | 38640 | 0 | 22 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 2 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340294 | 562913 | 28598 | 40 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 6 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340295 | 1111108 | 0 | 64 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 10 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340296 | 1833852 | 0 | 111 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 19 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340297 | 290941 | 0 | 16839 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 3 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340298 | 541461 | 0 | 78537 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 6 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340299 | 530024 | 0 | 56 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 6 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340300 | 659078 | 7547 | 360181 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 7 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340301 | 1095244 | 0 | 360236 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 11 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340302 | 1801576 | 0 | 237101 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 19 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340303 | 78857 | 2232 | 25 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 1 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340304 | 309531 | 0 | 37 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 4 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340305 | 556917 | 0 | 53 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 8 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340309 | 90726 | 0 | 722404 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 1 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340310 | 155196 | 0 | 722410 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 2 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340311 | 208194 | 0 | 22 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 2 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340312 | 49900 | 0 | 20 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 1 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| 340313 | 142415 | 0 | 43 | NaN | NaN | BHIWAPUR | NaN | NaN | NAGPUR | 1 | ... | 9 | 27 | MAHARASHTRA | 9 | NAGPUR | 51 | Umred (SC) | 9 | RAMTEK (SC) | 2709 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 945858 | 2992705 | 0 | 328 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 30 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945859 | 2319777 | 0 | 188 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 21 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945860 | 2243797 | 0 | 145 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 25 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945861 | 2565658 | 430920 | 193 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 30 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945862 | 2503656 | 8035 | 170 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 35 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945863 | 5318058 | 1920 | 397 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 68 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945864 | 1850490 | 74029 | 201 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 19 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945865 | 2868813 | 38209 | 215 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 30 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945866 | 2506914 | 1116 | 156 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 26 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945873 | 1165158 | 20804 | 286 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 12 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945874 | 2608559 | 0 | 299 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 25 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945875 | 3146196 | 0 | 409 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 39 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945876 | 2851239 | 150689 | 405 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 37 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945877 | 4459017 | 9037 | 278 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 41 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945878 | 2392091 | 0 | 268 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 17 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945879 | 2683630 | 3935 | 320 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 26 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945880 | 2290351 | 0 | 318 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 23 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945881 | 3152382 | 0 | 178 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 36 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945885 | 589015 | 3250 | 94 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 6 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945886 | 963372 | 5390 | 117 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 10 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945887 | 1265933 | 240 | 178 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 14 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945888 | 910110 | 20683 | 262 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 9 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945889 | 2021292 | 47250 | 222 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 20 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 945890 | 2429491 | 5600 | 243 | NaN | NaN | Sayra | NaN | NaN | UDAIPUR | 22 | ... | 19 | 8 | RAJASTHAN | 26 | UDAIPUR | 149 | Gogunda(ST) | 19 | UDAIPUR (ST) | 819 |
| 946497 | 41519236 | 101396 | 2505 | NaN | NaN | BHATAR | NaN | NaN | PURBA BARDHAMAN | 413 | ... | 39 | 19 | WEST BENGAL | 9 | BARDDHAMAN | 260 | BARDHAMAN DAKSHIN | 39 | BARDHAMAN-DURGAPUR | 1939 |
| 946508 | 16455908 | 12672 | 1372 | NaN | NaN | BURDWAN-I | NaN | NaN | PURBA BARDHAMAN | 164 | ... | 39 | 19 | WEST BENGAL | 9 | BARDDHAMAN | 260 | BARDHAMAN DAKSHIN | 39 | BARDHAMAN-DURGAPUR | 1939 |
| 946517 | 14717660 | 3696 | 1082 | NaN | NaN | BURDWAN-II | NaN | NaN | PURBA BARDHAMAN | 147 | ... | 39 | 19 | WEST BENGAL | 9 | BARDDHAMAN | 260 | BARDHAMAN DAKSHIN | 39 | BARDHAMAN-DURGAPUR | 1939 |
| 946645 | 23954786 | 5808 | 2630 | NaN | NaN | MONGOLKOTE | NaN | NaN | PURBA BARDHAMAN | 241 | ... | 39 | 19 | WEST BENGAL | 9 | BARDDHAMAN | 260 | BARDHAMAN DAKSHIN | 39 | BARDHAMAN-DURGAPUR | 1939 |
| 946646 | 33242106 | 418820 | 3474 | NaN | NaN | MONGOLKOTE | NaN | NaN | PURBA BARDHAMAN | 332 | ... | 39 | 19 | WEST BENGAL | 9 | BARDDHAMAN | 260 | BARDHAMAN DAKSHIN | 39 | BARDHAMAN-DURGAPUR | 1939 |
| 946656 | 33952892 | 0 | 2219 | NaN | NaN | MONGOLKOTE | NaN | NaN | PURBA BARDHAMAN | 332 | ... | 39 | 19 | WEST BENGAL | 9 | BARDDHAMAN | 260 | BARDHAMAN DAKSHIN | 39 | BARDHAMAN-DURGAPUR | 1939 |
945425 rows × 70 columns