scripts/chandigarh.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import fitz\n",
    "import re\n",
    "from glob import glob\n",
    "import pandas as pd\n",
    "import tarfile"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "### From parse_in_rolls\n",
    "\n",
    "COLUMNS = [\"number\",\"id\", \"elector_name\", \"father_or_husband_name\", \"relationship\", \"house_no\", \"age\", \"sex\", \"ac_name\", \"parl_constituency\", \"part_no\", \"year\", \"state\", \"filename\", \"main_town\", \"police_station\", \"mandal\", \"revenue_division\", \"district\", \"pin_code\", \"polling_station_name\", \"polling_station_address\", \"net_electors_male\", \"net_electors_female\", \"net_electors_third_gender\", \"net_electors_total\",\"original_or_amendment\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "INPUT_FILE = '/opt/data/in-electoral-rolls/chandigarh_pdfs.tar.gz'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Total PDF files: 527\n",
      "1 chandigarh_pdfs/w0010117.pdf 1243\n",
      "2 chandigarh_pdfs/w0010379.pdf 2313\n",
      "3 chandigarh_pdfs/w0010100.pdf 2860\n",
      "4 chandigarh_pdfs/w0010114.pdf 3915\n",
      "5 chandigarh_pdfs/w0010051.pdf 4819\n",
      "6 chandigarh_pdfs/w0010196.pdf 5949\n",
      "7 chandigarh_pdfs/w0010483.pdf 7156\n",
      "8 chandigarh_pdfs/w0010255.pdf 8237\n",
      "9 chandigarh_pdfs/w0010024.pdf 9309\n",
      "10 chandigarh_pdfs/w0010249.pdf 10347\n",
      "11 chandigarh_pdfs/w0010173.pdf 11265\n",
      "12 chandigarh_pdfs/w0010131.pdf 12426\n",
      "13 chandigarh_pdfs/w0010362.pdf 13403\n",
      "14 chandigarh_pdfs/w0010381.pdf 14589\n",
      "15 chandigarh_pdfs/w0010516.pdf 15794\n",
      "16 chandigarh_pdfs/w0010190.pdf 16489\n",
      "17 chandigarh_pdfs/w0010313.pdf 17657\n",
      "18 chandigarh_pdfs/w0010140.pdf 18872\n",
      "19 chandigarh_pdfs/w0010432.pdf 19864\n",
      "20 chandigarh_pdfs/w0010060.pdf 21255\n",
      "21 chandigarh_pdfs/w0010412.pdf 22328\n",
      "22 chandigarh_pdfs/w0010285.pdf 23456\n",
      "23 chandigarh_pdfs/w0010076.pdf 24181\n",
      "24 chandigarh_pdfs/w0010324.pdf 25403\n",
      "25 chandigarh_pdfs/w0010164.pdf 26597\n",
      "26 chandigarh_pdfs/w0010052.pdf 27581\n",
      "27 chandigarh_pdfs/w0010455.pdf 28499\n",
      "28 chandigarh_pdfs/w0010106.pdf 29359\n",
      "29 chandigarh_pdfs/w0010026.pdf 30339\n",
      "30 chandigarh_pdfs/w0010289.pdf 31591\n",
      "31 chandigarh_pdfs/w0010211.pdf 32820\n",
      "32 chandigarh_pdfs/w0010266.pdf 33921\n",
      "33 chandigarh_pdfs/w0010215.pdf 35098\n",
      "34 chandigarh_pdfs/w0010308.pdf 36086\n",
      "35 chandigarh_pdfs/w0010107.pdf 37023\n",
      "36 chandigarh_pdfs/w0010008.pdf 38181\n",
      "37 chandigarh_pdfs/w0010269.pdf 39330\n",
      "38 chandigarh_pdfs/w0010235.pdf 40440\n",
      "39 chandigarh_pdfs/w0010361.pdf 41608\n",
      "40 chandigarh_pdfs/w0010059.pdf 42909\n",
      "41 chandigarh_pdfs/w0010435.pdf 43889\n",
      "42 chandigarh_pdfs/w0010135.pdf 45043\n",
      "43 chandigarh_pdfs/w0010058.pdf 45852\n",
      "44 chandigarh_pdfs/w0010142.pdf 46780\n",
      "45 chandigarh_pdfs/w0010081.pdf 47608\n",
      "46 chandigarh_pdfs/w0010203.pdf 48523\n",
      "47 chandigarh_pdfs/w0010397.pdf 49720\n",
      "48 chandigarh_pdfs/w0010193.pdf 50662\n",
      "49 chandigarh_pdfs/w0010136.pdf 51883\n",
      "50 chandigarh_pdfs/w0010099.pdf 52615\n",
      "51 chandigarh_pdfs/w0010287.pdf 53812\n",
      "52 chandigarh_pdfs/w0010522.pdf 54953\n",
      "53 chandigarh_pdfs/w0010145.pdf 55875\n",
      "54 chandigarh_pdfs/w0010264.pdf 57027\n",
      "55 chandigarh_pdfs/w0010352.pdf 58173\n",
      "56 chandigarh_pdfs/w0010141.pdf 59100\n",
      "57 chandigarh_pdfs/w0010477.pdf 60073\n",
      "58 chandigarh_pdfs/w0010138.pdf 61263\n",
      "59 chandigarh_pdfs/w0010240.pdf 62492\n",
      "60 chandigarh_pdfs/w0010251.pdf 63635\n",
      "61 chandigarh_pdfs/w0010387.pdf 64767\n",
      "62 chandigarh_pdfs/w0010501.pdf 65868\n",
      "63 chandigarh_pdfs/w0010110.pdf 67100\n",
      "64 chandigarh_pdfs/w0010364.pdf 67970\n",
      "65 chandigarh_pdfs/w0010415.pdf 69120\n",
      "66 chandigarh_pdfs/w0010316.pdf 70210\n",
      "67 chandigarh_pdfs/w0010407.pdf 71306\n",
      "68 chandigarh_pdfs/w0010168.pdf 72303\n",
      "69 chandigarh_pdfs/w0010494.pdf 73450\n",
      "70 chandigarh_pdfs/w0010304.pdf 74630\n",
      "71 chandigarh_pdfs/w0010092.pdf 75549\n",
      "72 chandigarh_pdfs/w0010279.pdf 76663\n",
      "73 chandigarh_pdfs/w0010331.pdf 77849\n",
      "74 chandigarh_pdfs/w0010063.pdf 79231\n",
      "75 chandigarh_pdfs/w0010288.pdf 80582\n",
      "76 chandigarh_pdfs/w0010280.pdf 81700\n",
      "77 chandigarh_pdfs/w0010039.pdf 82728\n",
      "78 chandigarh_pdfs/w0010064.pdf 84203\n",
      "79 chandigarh_pdfs/w0010485.pdf 85414\n",
      "80 chandigarh_pdfs/w0010366.pdf 86678\n",
      "81 chandigarh_pdfs/w0010185.pdf 87644\n",
      "82 chandigarh_pdfs/w0010009.pdf 88800\n",
      "83 chandigarh_pdfs/w0010406.pdf 89879\n",
      "84 chandigarh_pdfs/w0010158.pdf 91141\n",
      "85 chandigarh_pdfs/w0010157.pdf 92153\n",
      "86 chandigarh_pdfs/w0010328.pdf 93145\n",
      "87 chandigarh_pdfs/w0010182.pdf 94117\n",
      "88 chandigarh_pdfs/w0010210.pdf 95424\n",
      "89 chandigarh_pdfs/w0010246.pdf 96499\n",
      "90 chandigarh_pdfs/w0010420.pdf 97475\n",
      "91 chandigarh_pdfs/w0010199.pdf 98463\n",
      "92 chandigarh_pdfs/w0010046.pdf 99814\n",
      "93 chandigarh_pdfs/w0010348.pdf 101002\n",
      "94 chandigarh_pdfs/w0010253.pdf 102162\n",
      "95 chandigarh_pdfs/w0010103.pdf 103375\n",
      "96 chandigarh_pdfs/w0010422.pdf 104698\n",
      "97 chandigarh_pdfs/w0010421.pdf 105941\n",
      "98 chandigarh_pdfs/w0010090.pdf 106960\n",
      "99 chandigarh_pdfs/w0010175.pdf 107679\n",
      "100 chandigarh_pdfs/w0010116.pdf 108943\n",
      "101 chandigarh_pdfs/w0010019.pdf 109929\n",
      "102 chandigarh_pdfs/w0010124.pdf 111204\n",
      "103 chandigarh_pdfs/w0010440.pdf 112318\n",
      "104 chandigarh_pdfs/w0010486.pdf 113654\n",
      "105 chandigarh_pdfs/w0010056.pdf 114992\n",
      "106 chandigarh_pdfs/w0010319.pdf 115954\n",
      "107 chandigarh_pdfs/w0010001.pdf 117143\n",
      "108 chandigarh_pdfs/w0010429.pdf 118183\n",
      "109 chandigarh_pdfs/w0010014.pdf 119393\n",
      "110 chandigarh_pdfs/w0010359.pdf 120302\n",
      "111 chandigarh_pdfs/w0010505.pdf 121545\n",
      "112 chandigarh_pdfs/w0010044.pdf 122755\n",
      "113 chandigarh_pdfs/w0010216.pdf 123761\n",
      "114 chandigarh_pdfs/w0010427.pdf 124912\n",
      "115 chandigarh_pdfs/w0010281.pdf 126067\n",
      "116 chandigarh_pdfs/w0010125.pdf 127200\n",
      "117 chandigarh_pdfs/w0010220.pdf 128255\n",
      "118 chandigarh_pdfs/w0010031.pdf 129171\n",
      "119 chandigarh_pdfs/w0010400.pdf 130355\n",
      "120 chandigarh_pdfs/w0010286.pdf 131390\n",
      "121 chandigarh_pdfs/w0010029.pdf 132660\n",
      "122 chandigarh_pdfs/w0010195.pdf 133690\n",
      "123 chandigarh_pdfs/w0010339.pdf 134850\n",
      "124 chandigarh_pdfs/w0010250.pdf 135951\n",
      "125 chandigarh_pdfs/w0010225.pdf 137202\n",
      "126 chandigarh_pdfs/w0010490.pdf 138200\n",
      "127 chandigarh_pdfs/w0010053.pdf 139552\n",
      "128 chandigarh_pdfs/w0010091.pdf 140552\n",
      "129 chandigarh_pdfs/w0010207.pdf 141565\n",
      "130 chandigarh_pdfs/w0010170.pdf 142448\n",
      "131 chandigarh_pdfs/w0010030.pdf 143320\n",
      "132 chandigarh_pdfs/w0010222.pdf 144709\n",
      "133 chandigarh_pdfs/w0010322.pdf 145948\n",
      "134 chandigarh_pdfs/w0010480.pdf 147130\n",
      "135 chandigarh_pdfs/w0010178.pdf 148402\n",
      "136 chandigarh_pdfs/w0010094.pdf 149502\n",
      "137 chandigarh_pdfs/w0010525.pdf 150579\n",
      "138 chandigarh_pdfs/w0010291.pdf 151591\n",
      "139 chandigarh_pdfs/w0010105.pdf 152537\n",
      "140 chandigarh_pdfs/w0010353.pdf 153676\n",
      "141 chandigarh_pdfs/w0010320.pdf 154994\n",
      "142 chandigarh_pdfs/w0010390.pdf 156209\n",
      "143 chandigarh_pdfs/w0010049.pdf 157304\n",
      "144 chandigarh_pdfs/w0010176.pdf 158251\n",
      "145 chandigarh_pdfs/w0010393.pdf 159281\n",
      "146 chandigarh_pdfs/w0010002.pdf 160438\n",
      "147 chandigarh_pdfs/w0010268.pdf 161519\n",
      "148 chandigarh_pdfs/w0010409.pdf 162569\n",
      "149 chandigarh_pdfs/w0010394.pdf 163553\n",
      "150 chandigarh_pdfs/w0010032.pdf 164605\n",
      "151 chandigarh_pdfs/w0010405.pdf 165736\n",
      "152 chandigarh_pdfs/w0010129.pdf 166921\n",
      "153 chandigarh_pdfs/w0010441.pdf 167815\n",
      "154 chandigarh_pdfs/w0010510.pdf 169085\n",
      "155 chandigarh_pdfs/w0010449.pdf 170236\n",
      "156 chandigarh_pdfs/w0010504.pdf 171539\n",
      "157 chandigarh_pdfs/w0010290.pdf 172808\n",
      "158 chandigarh_pdfs/w0010360.pdf 173930\n",
      "159 chandigarh_pdfs/w0010342.pdf 174759\n",
      "160 chandigarh_pdfs/w0010306.pdf 175827\n",
      "161 chandigarh_pdfs/w0010411.pdf 176928\n",
      "162 chandigarh_pdfs/w0010341.pdf 178009\n",
      "163 chandigarh_pdfs/w0010041.pdf 179207\n",
      "164 chandigarh_pdfs/w0010257.pdf 180412\n",
      "165 chandigarh_pdfs/w0010003.pdf 181670\n",
      "166 chandigarh_pdfs/w0010500.pdf 182885\n",
      "167 chandigarh_pdfs/w0010137.pdf 184102\n",
      "168 chandigarh_pdfs/w0010507.pdf 185416\n",
      "169 chandigarh_pdfs/w0010261.pdf 186597\n",
      "170 chandigarh_pdfs/w0010244.pdf 187501\n",
      "171 chandigarh_pdfs/w0010371.pdf 188544\n",
      "172 chandigarh_pdfs/w0010417.pdf 189703\n",
      "173 chandigarh_pdfs/w0010425.pdf 190987\n",
      "174 chandigarh_pdfs/w0010022.pdf 192073\n",
      "175 chandigarh_pdfs/w0010508.pdf 193464\n",
      "176 chandigarh_pdfs/w0010311.pdf 194547\n",
      "177 chandigarh_pdfs/w0010037.pdf 195888\n",
      "178 chandigarh_pdfs/w0010467.pdf 196980\n",
      "179 chandigarh_pdfs/w0010413.pdf 198070\n",
      "180 chandigarh_pdfs/w0010245.pdf 199318\n",
      "181 chandigarh_pdfs/w0010325.pdf 200416\n",
      "182 chandigarh_pdfs/w0010284.pdf 201377\n",
      "183 chandigarh_pdfs/w0010442.pdf 202225\n",
      "184 chandigarh_pdfs/w0010159.pdf 203480\n",
      "185 chandigarh_pdfs/w0010511.pdf 204643\n",
      "186 chandigarh_pdfs/w0010018.pdf 205706\n",
      "187 chandigarh_pdfs/w0010514.pdf 207035\n",
      "188 chandigarh_pdfs/w0010045.pdf 207900\n",
      "189 chandigarh_pdfs/w0010518.pdf 208927\n",
      "190 chandigarh_pdfs/w0010229.pdf 210032\n",
      "191 chandigarh_pdfs/w0010374.pdf 210983\n",
      "192 chandigarh_pdfs/w0010258.pdf 212222\n",
      "193 chandigarh_pdfs/w0010065.pdf 213623\n",
      "194 chandigarh_pdfs/w0010414.pdf 214743\n",
      "195 chandigarh_pdfs/w0010096.pdf 215928\n",
      "196 chandigarh_pdfs/w0010183.pdf 216823\n",
      "197 chandigarh_pdfs/w0010278.pdf 217841\n",
      "198 chandigarh_pdfs/w0010468.pdf 218964\n",
      "199 chandigarh_pdfs/w0010383.pdf 220137\n",
      "200 chandigarh_pdfs/w0010333.pdf 221331\n",
      "201 chandigarh_pdfs/w0010297.pdf 222530\n",
      "202 chandigarh_pdfs/w0010521.pdf 223561\n",
      "203 chandigarh_pdfs/w0010174.pdf 224220\n",
      "204 chandigarh_pdfs/w0010166.pdf 225215\n",
      "205 chandigarh_pdfs/w0010391.pdf 226434\n",
      "206 chandigarh_pdfs/w0010202.pdf 227693\n",
      "207 chandigarh_pdfs/w0010423.pdf 229133\n",
      "208 chandigarh_pdfs/w0010354.pdf 230314\n",
      "209 chandigarh_pdfs/w0010027.pdf 231082\n",
      "210 chandigarh_pdfs/w0010163.pdf 232328\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "211 chandigarh_pdfs/w0010502.pdf 233519\n",
      "212 chandigarh_pdfs/w0010519.pdf 234573\n",
      "213 chandigarh_pdfs/w0010445.pdf 235679\n",
      "214 chandigarh_pdfs/w0010410.pdf 236757\n",
      "215 chandigarh_pdfs/w0010433.pdf 237824\n",
      "216 chandigarh_pdfs/w0010299.pdf 239038\n",
      "217 chandigarh_pdfs/w0010317.pdf 240223\n",
      "218 chandigarh_pdfs/w0010272.pdf 241507\n",
      "219 chandigarh_pdfs/w0010034.pdf 242465\n",
      "220 chandigarh_pdfs/w0010212.pdf 243748\n",
      "221 chandigarh_pdfs/w0010437.pdf 244881\n",
      "222 chandigarh_pdfs/w0010438.pdf 245993\n",
      "223 chandigarh_pdfs/w0010265.pdf 247100\n",
      "224 chandigarh_pdfs/w0010201.pdf 248111\n",
      "225 chandigarh_pdfs/w0010040.pdf 249321\n",
      "226 chandigarh_pdfs/w0010101.pdf 250555\n",
      "227 chandigarh_pdfs/w0010386.pdf 251633\n",
      "228 chandigarh_pdfs/w0010378.pdf 252733\n",
      "229 chandigarh_pdfs/w0010241.pdf 253940\n",
      "230 chandigarh_pdfs/w0010042.pdf 255193\n",
      "231 chandigarh_pdfs/w0010248.pdf 256386\n",
      "232 chandigarh_pdfs/w0010363.pdf 257337\n",
      "233 chandigarh_pdfs/w0010498.pdf 258517\n",
      "234 chandigarh_pdfs/w0010023.pdf 259804\n",
      "235 chandigarh_pdfs/w0010093.pdf 260878\n",
      "236 chandigarh_pdfs/w0010113.pdf 261864\n",
      "237 chandigarh_pdfs/w0010087.pdf 262738\n",
      "238 chandigarh_pdfs/w0010184.pdf 263818\n",
      "239 chandigarh_pdfs/w0010194.pdf 264913\n",
      "240 chandigarh_pdfs/w0010479.pdf 265994\n",
      "241 chandigarh_pdfs/w0010126.pdf 267200\n",
      "242 chandigarh_pdfs/w0010181.pdf 268434\n",
      "243 chandigarh_pdfs/w0010385.pdf 269571\n",
      "244 chandigarh_pdfs/w0010496.pdf 270751\n",
      "245 chandigarh_pdfs/w0010082.pdf 271548\n",
      "246 chandigarh_pdfs/w0010015.pdf 272897\n",
      "247 chandigarh_pdfs/w0010007.pdf 274093\n",
      "248 chandigarh_pdfs/w0010112.pdf 275197\n",
      "249 chandigarh_pdfs/w0010144.pdf 276380\n",
      "250 chandigarh_pdfs/w0010069.pdf 277795\n",
      "251 chandigarh_pdfs/w0010375.pdf 278770\n",
      "252 chandigarh_pdfs/w0010334.pdf 280095\n",
      "253 chandigarh_pdfs/w0010171.pdf 281301\n",
      "254 chandigarh_pdfs/w0010085.pdf 282329\n",
      "255 chandigarh_pdfs/w0010367.pdf 283362\n",
      "256 chandigarh_pdfs/w0010020.pdf 284336\n",
      "257 chandigarh_pdfs/w0010200.pdf 285431\n",
      "258 chandigarh_pdfs/w0010062.pdf 286818\n",
      "259 chandigarh_pdfs/w0010295.pdf 288252\n",
      "260 chandigarh_pdfs/w0010377.pdf 289556\n",
      "261 chandigarh_pdfs/w0010077.pdf 290731\n",
      "262 chandigarh_pdfs/w0010043.pdf 291944\n",
      "263 chandigarh_pdfs/w0010160.pdf 293141\n",
      "264 chandigarh_pdfs/w0010471.pdf 294159\n",
      "265 chandigarh_pdfs/w0010523.pdf 295264\n",
      "266 chandigarh_pdfs/w0010365.pdf 296306\n",
      "267 chandigarh_pdfs/w0010416.pdf 297436\n",
      "268 chandigarh_pdfs/w0010337.pdf 298635\n",
      "269 chandigarh_pdfs/w0010259.pdf 299759\n",
      "270 chandigarh_pdfs/w0010473.pdf 300583\n",
      "271 chandigarh_pdfs/w0010237.pdf 301420\n",
      "272 chandigarh_pdfs/w0010526.pdf 302328\n",
      "273 chandigarh_pdfs/w0010358.pdf 303315\n",
      "274 chandigarh_pdfs/w0010167.pdf 304382\n",
      "275 chandigarh_pdfs/w0010028.pdf 305343\n",
      "276 chandigarh_pdfs/w0010344.pdf 306597\n",
      "277 chandigarh_pdfs/w0010419.pdf 307865\n",
      "278 chandigarh_pdfs/w0010434.pdf 308850\n",
      "279 chandigarh_pdfs/w0010462.pdf 309811\n",
      "280 chandigarh_pdfs/w0010506.pdf 311205\n",
      "281 chandigarh_pdfs/w0010198.pdf 312447\n",
      "282 chandigarh_pdfs/w0010098.pdf 313190\n",
      "283 chandigarh_pdfs/w0010327.pdf 314266\n",
      "284 chandigarh_pdfs/w0010267.pdf 315223\n",
      "285 chandigarh_pdfs/w0010277.pdf 316342\n",
      "286 chandigarh_pdfs/w0010466.pdf 317444\n",
      "287 chandigarh_pdfs/w0010226.pdf 318777\n",
      "288 chandigarh_pdfs/w0010447.pdf 319931\n",
      "289 chandigarh_pdfs/w0010517.pdf 320917\n",
      "290 chandigarh_pdfs/w0010399.pdf 322091\n",
      "291 chandigarh_pdfs/w0010418.pdf 323334\n",
      "292 chandigarh_pdfs/w0010238.pdf 324403\n",
      "293 chandigarh_pdfs/w0010118.pdf 325667\n",
      "294 chandigarh_pdfs/w0010252.pdf 326909\n",
      "295 chandigarh_pdfs/w0010010.pdf 328039\n",
      "296 chandigarh_pdfs/w0010111.pdf 329129\n",
      "297 chandigarh_pdfs/w0010132.pdf 330177\n",
      "298 chandigarh_pdfs/w0010402.pdf 331327\n",
      "299 chandigarh_pdfs/w0010302.pdf 332565\n",
      "300 chandigarh_pdfs/w0010133.pdf 333638\n",
      "301 chandigarh_pdfs/w0010489.pdf 334514\n",
      "302 chandigarh_pdfs/w0010424.pdf 335773\n",
      "303 chandigarh_pdfs/w0010453.pdf 336917\n",
      "304 chandigarh_pdfs/w0010458.pdf 337861\n",
      "305 chandigarh_pdfs/w0010503.pdf 339210\n",
      "306 chandigarh_pdfs/w0010224.pdf 339895\n",
      "307 chandigarh_pdfs/w0010476.pdf 340946\n",
      "308 chandigarh_pdfs/w0010330.pdf 341961\n",
      "309 chandigarh_pdfs/w0010088.pdf 343048\n",
      "310 chandigarh_pdfs/w0010270.pdf 344191\n",
      "311 chandigarh_pdfs/w0010243.pdf 345088\n",
      "312 chandigarh_pdfs/w0010347.pdf 346264\n",
      "313 chandigarh_pdfs/w0010086.pdf 347432\n",
      "314 chandigarh_pdfs/w0010263.pdf 348537\n",
      "315 chandigarh_pdfs/w0010451.pdf 349659\n",
      "316 chandigarh_pdfs/w0010318.pdf 350701\n",
      "317 chandigarh_pdfs/w0010205.pdf 351736\n",
      "318 chandigarh_pdfs/w0010456.pdf 352489\n",
      "319 chandigarh_pdfs/w0010260.pdf 353588\n",
      "320 chandigarh_pdfs/w0010177.pdf 354506\n",
      "321 chandigarh_pdfs/w0010349.pdf 355683\n",
      "322 chandigarh_pdfs/w0010482.pdf 356859\n",
      "323 chandigarh_pdfs/w0010232.pdf 358076\n",
      "324 chandigarh_pdfs/w0010335.pdf 359361\n",
      "325 chandigarh_pdfs/w0010262.pdf 360468\n",
      "326 chandigarh_pdfs/w0010355.pdf 361439\n",
      "327 chandigarh_pdfs/w0010152.pdf 362441\n",
      "328 chandigarh_pdfs/w0010154.pdf 363518\n",
      "329 chandigarh_pdfs/w0010392.pdf 364820\n",
      "330 chandigarh_pdfs/w0010104.pdf 365707\n",
      "331 chandigarh_pdfs/w0010242.pdf 366631\n",
      "332 chandigarh_pdfs/w0010192.pdf 367358\n",
      "333 chandigarh_pdfs/w0010191.pdf 368302\n",
      "334 chandigarh_pdfs/w0010296.pdf 369660\n",
      "335 chandigarh_pdfs/w0010307.pdf 370773\n",
      "336 chandigarh_pdfs/w0010128.pdf 372013\n",
      "337 chandigarh_pdfs/w0010469.pdf 373105\n",
      "338 chandigarh_pdfs/w0010395.pdf 374055\n",
      "339 chandigarh_pdfs/w0010072.pdf 375469\n",
      "340 chandigarh_pdfs/w0010038.pdf 376555\n",
      "341 chandigarh_pdfs/w0010460.pdf 377450\n",
      "342 chandigarh_pdfs/w0010408.pdf 378516\n",
      "343 chandigarh_pdfs/w0010078.pdf 379637\n",
      "344 chandigarh_pdfs/w0010247.pdf 380919\n",
      "345 chandigarh_pdfs/w0010380.pdf 382049\n",
      "346 chandigarh_pdfs/w0010239.pdf 383081\n",
      "347 chandigarh_pdfs/w0010484.pdf 384174\n",
      "348 chandigarh_pdfs/w0010033.pdf 385041\n",
      "349 chandigarh_pdfs/w0010351.pdf 386215\n",
      "350 chandigarh_pdfs/w0010083.pdf 386954\n",
      "351 chandigarh_pdfs/w0010169.pdf 387818\n",
      "352 chandigarh_pdfs/w0010273.pdf 389043\n",
      "353 chandigarh_pdfs/w0010389.pdf 390229\n",
      "354 chandigarh_pdfs/w0010070.pdf 391660\n",
      "355 chandigarh_pdfs/w0010221.pdf 392863\n",
      "356 chandigarh_pdfs/w0010497.pdf 394033\n",
      "357 chandigarh_pdfs/w0010443.pdf 395150\n",
      "358 chandigarh_pdfs/w0010223.pdf 396182\n",
      "359 chandigarh_pdfs/w0010162.pdf 397037\n",
      "360 chandigarh_pdfs/w0010493.pdf 398248\n",
      "361 chandigarh_pdfs/w0010357.pdf 399342\n",
      "362 chandigarh_pdfs/w0010474.pdf 400649\n",
      "363 chandigarh_pdfs/w0010047.pdf 401908\n",
      "364 chandigarh_pdfs/w0010350.pdf 403012\n",
      "365 chandigarh_pdfs/w0010155.pdf 404074\n",
      "366 chandigarh_pdfs/w0010208.pdf 405167\n",
      "367 chandigarh_pdfs/w0010188.pdf 405921\n",
      "368 chandigarh_pdfs/w0010478.pdf 406984\n",
      "369 chandigarh_pdfs/w0010461.pdf 407963\n",
      "370 chandigarh_pdfs/w0010499.pdf 409165\n",
      "371 chandigarh_pdfs/w0010340.pdf 410219\n",
      "372 chandigarh_pdfs/w0010187.pdf 411112\n",
      "373 chandigarh_pdfs/w0010431.pdf 412103\n",
      "374 chandigarh_pdfs/w0010218.pdf 413532\n",
      "375 chandigarh_pdfs/w0010305.pdf 414574\n",
      "376 chandigarh_pdfs/w0010454.pdf 415680\n",
      "377 chandigarh_pdfs/w0010326.pdf 416768\n",
      "378 chandigarh_pdfs/w0010151.pdf 418010\n",
      "379 chandigarh_pdfs/w0010006.pdf 419198\n",
      "380 chandigarh_pdfs/w0010426.pdf 420571\n",
      "381 chandigarh_pdfs/w0010314.pdf 421660\n",
      "382 chandigarh_pdfs/w0010080.pdf 422568\n",
      "383 chandigarh_pdfs/w0010228.pdf 423135\n",
      "384 chandigarh_pdfs/w0010470.pdf 424253\n",
      "385 chandigarh_pdfs/w0010011.pdf 425464\n",
      "386 chandigarh_pdfs/w0010472.pdf 426196\n",
      "387 chandigarh_pdfs/w0010189.pdf 426972\n",
      "388 chandigarh_pdfs/w0010061.pdf 428334\n",
      "389 chandigarh_pdfs/w0010512.pdf 429383\n",
      "390 chandigarh_pdfs/w0010074.pdf 430657\n",
      "391 chandigarh_pdfs/w0010376.pdf 431808\n",
      "392 chandigarh_pdfs/w0010121.pdf 433085\n",
      "393 chandigarh_pdfs/w0010214.pdf 434330\n",
      "394 chandigarh_pdfs/w0010436.pdf 435483\n",
      "395 chandigarh_pdfs/w0010073.pdf 436855\n",
      "396 chandigarh_pdfs/w0010021.pdf 437905\n",
      "397 chandigarh_pdfs/w0010179.pdf 439139\n",
      "398 chandigarh_pdfs/w0010430.pdf 440180\n",
      "399 chandigarh_pdfs/w0010217.pdf 441135\n",
      "400 chandigarh_pdfs/w0010356.pdf 442045\n",
      "401 chandigarh_pdfs/w0010404.pdf 443250\n",
      "402 chandigarh_pdfs/w0010293.pdf 444498\n",
      "403 chandigarh_pdfs/w0010236.pdf 445363\n",
      "404 chandigarh_pdfs/w0010219.pdf 446761\n",
      "405 chandigarh_pdfs/w0010370.pdf 447753\n",
      "406 chandigarh_pdfs/w0010036.pdf 448939\n",
      "407 chandigarh_pdfs/w0010274.pdf 450102\n",
      "408 chandigarh_pdfs/w0010161.pdf 451446\n",
      "409 chandigarh_pdfs/w0010180.pdf 452605\n",
      "410 chandigarh_pdfs/w0010401.pdf 453762\n",
      "411 chandigarh_pdfs/w0010122.pdf 454934\n",
      "412 chandigarh_pdfs/w0010403.pdf 456136\n",
      "413 chandigarh_pdfs/w0010428.pdf 456947\n",
      "414 chandigarh_pdfs/w0010301.pdf 458325\n",
      "415 chandigarh_pdfs/w0010197.pdf 459431\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "416 chandigarh_pdfs/w0010396.pdf 460426\n",
      "417 chandigarh_pdfs/w0010303.pdf 461546\n",
      "418 chandigarh_pdfs/w0010055.pdf 462684\n",
      "419 chandigarh_pdfs/w0010450.pdf 463826\n",
      "420 chandigarh_pdfs/w0010509.pdf 464944\n",
      "421 chandigarh_pdfs/w0010050.pdf 466284\n",
      "422 chandigarh_pdfs/w0010089.pdf 466987\n",
      "423 chandigarh_pdfs/w0010345.pdf 468096\n",
      "424 chandigarh_pdfs/w0010481.pdf 469220\n",
      "425 chandigarh_pdfs/w0010108.pdf 470056\n",
      "426 chandigarh_pdfs/w0010446.pdf 471222\n",
      "427 chandigarh_pdfs/w0010120.pdf 472494\n",
      "428 chandigarh_pdfs/w0010054.pdf 473416\n",
      "429 chandigarh_pdfs/w0010524.pdf 474675\n",
      "430 chandigarh_pdfs/w0010146.pdf 475477\n",
      "431 chandigarh_pdfs/w0010315.pdf 476530\n",
      "432 chandigarh_pdfs/w0010312.pdf 477667\n",
      "433 chandigarh_pdfs/w0010300.pdf 479069\n",
      "434 chandigarh_pdfs/w0010172.pdf 480193\n",
      "435 chandigarh_pdfs/w0010336.pdf 481394\n",
      "436 chandigarh_pdfs/w0010515.pdf 482721\n",
      "437 chandigarh_pdfs/w0010448.pdf 483815\n",
      "438 chandigarh_pdfs/w0010013.pdf 485042\n",
      "439 chandigarh_pdfs/w0010123.pdf 486270\n",
      "440 chandigarh_pdfs/w0010067.pdf 487658\n",
      "441 chandigarh_pdfs/w0010398.pdf 488926\n",
      "442 chandigarh_pdfs/w0010095.pdf 489911\n",
      "443 chandigarh_pdfs/w0010165.pdf 491258\n",
      "444 chandigarh_pdfs/w0010372.pdf 492366\n",
      "445 chandigarh_pdfs/w0010035.pdf 493267\n",
      "446 chandigarh_pdfs/w0010143.pdf 494424\n",
      "447 chandigarh_pdfs/w0010488.pdf 495481\n",
      "448 chandigarh_pdfs/w0010057.pdf 496527\n",
      "449 chandigarh_pdfs/w0010444.pdf 497710\n",
      "450 chandigarh_pdfs/w0010321.pdf 498956\n",
      "451 chandigarh_pdfs/w0010271.pdf 500226\n",
      "452 chandigarh_pdfs/w0010276.pdf 501420\n",
      "453 chandigarh_pdfs/w0010150.pdf 502518\n",
      "454 chandigarh_pdfs/w0010012.pdf 503781\n",
      "455 chandigarh_pdfs/w0010388.pdf 504997\n",
      "456 chandigarh_pdfs/w0010282.pdf 506087\n",
      "457 chandigarh_pdfs/w0010231.pdf 507309\n",
      "458 chandigarh_pdfs/w0010487.pdf 508439\n",
      "459 chandigarh_pdfs/w0010463.pdf 509502\n",
      "460 chandigarh_pdfs/w0010071.pdf 510873\n",
      "461 chandigarh_pdfs/w0010254.pdf 511921\n",
      "462 chandigarh_pdfs/w0010153.pdf 513186\n",
      "463 chandigarh_pdfs/w0010227.pdf 514263\n",
      "464 chandigarh_pdfs/w0010079.pdf 515122\n",
      "465 chandigarh_pdfs/w0010520.pdf 516036\n",
      "466 chandigarh_pdfs/w0010025.pdf 516945\n",
      "467 chandigarh_pdfs/w0010294.pdf 518296\n",
      "468 chandigarh_pdfs/w0010156.pdf 519272\n",
      "469 chandigarh_pdfs/w0010495.pdf 520242\n",
      "470 chandigarh_pdfs/w0010127.pdf 521414\n",
      "471 chandigarh_pdfs/w0010527.pdf 522073\n",
      "472 chandigarh_pdfs/w0010234.pdf 523106\n",
      "473 chandigarh_pdfs/w0010206.pdf 524269\n",
      "474 chandigarh_pdfs/w0010213.pdf 525550\n",
      "475 chandigarh_pdfs/w0010384.pdf 526679\n",
      "476 chandigarh_pdfs/w0010186.pdf 527783\n",
      "477 chandigarh_pdfs/w0010323.pdf 528992\n",
      "478 chandigarh_pdfs/w0010329.pdf 530064\n",
      "479 chandigarh_pdfs/w0010115.pdf 531455\n",
      "480 chandigarh_pdfs/w0010283.pdf 532499\n",
      "481 chandigarh_pdfs/w0010309.pdf 533616\n",
      "482 chandigarh_pdfs/w0010513.pdf 534578\n",
      "483 chandigarh_pdfs/w0010066.pdf 536012\n",
      "484 chandigarh_pdfs/w0010373.pdf 537304\n",
      "485 chandigarh_pdfs/w0010292.pdf 538263\n",
      "486 chandigarh_pdfs/w0010368.pdf 539431\n",
      "487 chandigarh_pdfs/w0010256.pdf 540655\n",
      "488 chandigarh_pdfs/w0010084.pdf 541791\n",
      "489 chandigarh_pdfs/w0010017.pdf 542848\n",
      "490 chandigarh_pdfs/w0010147.pdf 544030\n",
      "491 chandigarh_pdfs/w0010369.pdf 545358\n",
      "492 chandigarh_pdfs/w0010492.pdf 546432\n",
      "493 chandigarh_pdfs/w0010204.pdf 547509\n",
      "494 chandigarh_pdfs/w0010298.pdf 548734\n",
      "495 chandigarh_pdfs/w0010109.pdf 549975\n",
      "496 chandigarh_pdfs/w0010230.pdf 551471\n",
      "497 chandigarh_pdfs/w0010130.pdf 552531\n",
      "498 chandigarh_pdfs/w0010016.pdf 553804\n",
      "499 chandigarh_pdfs/w0010004.pdf 555151\n",
      "500 chandigarh_pdfs/w0010048.pdf 556370\n",
      "501 chandigarh_pdfs/w0010343.pdf 557266\n",
      "502 chandigarh_pdfs/w0010275.pdf 558407\n",
      "503 chandigarh_pdfs/w0010464.pdf 559554\n",
      "504 chandigarh_pdfs/w0010382.pdf 560693\n",
      "505 chandigarh_pdfs/w0010475.pdf 561772\n",
      "506 chandigarh_pdfs/w0010233.pdf 562852\n",
      "507 chandigarh_pdfs/w0010148.pdf 564058\n",
      "508 chandigarh_pdfs/w0010097.pdf 565014\n",
      "509 chandigarh_pdfs/w0010465.pdf 566031\n",
      "510 chandigarh_pdfs/w0010075.pdf 566862\n",
      "511 chandigarh_pdfs/w0010346.pdf 568021\n",
      "512 chandigarh_pdfs/w0010068.pdf 569510\n",
      "513 chandigarh_pdfs/w0010310.pdf 570649\n",
      "514 chandigarh_pdfs/w0010491.pdf 571477\n",
      "515 chandigarh_pdfs/w0010209.pdf 572578\n",
      "516 chandigarh_pdfs/w0010338.pdf 573662\n",
      "517 chandigarh_pdfs/w0010102.pdf 574727\n",
      "518 chandigarh_pdfs/w0010332.pdf 575904\n",
      "519 chandigarh_pdfs/w0010452.pdf 577076\n",
      "520 chandigarh_pdfs/w0010457.pdf 577881\n",
      "521 chandigarh_pdfs/w0010134.pdf 578965\n",
      "522 chandigarh_pdfs/w0010459.pdf 579933\n",
      "523 chandigarh_pdfs/w0010439.pdf 581071\n",
      "524 chandigarh_pdfs/w0010005.pdf 582353\n",
      "525 chandigarh_pdfs/w0010119.pdf 583632\n",
      "526 chandigarh_pdfs/w0010149.pdf 584578\n",
      "527 chandigarh_pdfs/w0010139.pdf 585728\n"
     ]
    }
   ],
   "source": [
    "rows = []\n",
    "with tarfile.open(INPUT_FILE, \"r:gz\") as tar:\n",
    "    members = tar.getmembers()[1:]\n",
    "    print('Total PDF files: %d' % len(members))\n",
    "    for i, t in enumerate(members):\n",
    "        fn = t.name\n",
    "        with tar.extractfile(t) as f:\n",
    "            pdf_data = f.read()\n",
    "        doc = fitz.open('pdf', pdf_data)\n",
    "        for p in doc:\n",
    "            text = p.getText()\n",
    "            #print(text)\n",
    "            for m in re.finditer(r'(?<=\\n)(.*?\\n\\d+\\n.*?\\nनाम :(.*?\\nहै।))', '\\n' + text, flags=re.DOTALL):\n",
    "                box = m.group(1)\n",
    "                #print(box)\n",
    "                #print('-'*50)\n",
    "                if True:\n",
    "                    elector_name = re.findall(r'(.*?)\\d+', box, flags=re.S)[0].strip().replace('\\n', ' ')\n",
    "                    number = re.findall(r'.*?(\\d+)', box, flags=re.S)[0].strip()\n",
    "                    _id = re.findall(r'.*?\\d+\\n(.*?)\\n', box, flags=re.S)[0].strip()\n",
    "                    a = re.findall(r'नाम :\\n(.*?)\\nमकान  नं. :', box, flags=re.S)[0].strip().split(':')\n",
    "                    relationship = a[0].strip()\n",
    "                    father_or_husband_name = a[1].strip()\n",
    "                    house_no = re.findall(r'मकान  नं. :(.*?)आयु', box, flags=re.S)[0].strip()\n",
    "                    age = re.findall(r'आयु :(.*?)िलग', box, flags=re.S)[0].strip()\n",
    "                    sex = re.findall(r'लग : (.*?)फोटो', box, flags=re.S)[0].strip()\n",
    "                    data = {'filename': os.path.basename(fn),\n",
    "                            'number': number,\n",
    "                            'id': _id,\n",
    "                            'elector_name': elector_name,\n",
    "                            'father_or_husband_name': father_or_husband_name,\n",
    "                            'relationship': relationship,\n",
    "                            'house_no': house_no,\n",
    "                            'age': age,\n",
    "                            'sex': sex,\n",
    "                           }\n",
    "                    rows.append(data)\n",
    "        print(i + 1, fn, len(rows))\n",
    "        #break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>filename</th>\n",
       "      <th>number</th>\n",
       "      <th>id</th>\n",
       "      <th>elector_name</th>\n",
       "      <th>father_or_husband_name</th>\n",
       "      <th>relationship</th>\n",
       "      <th>house_no</th>\n",
       "      <th>age</th>\n",
       "      <th>sex</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>w0010117.pdf</td>\n",
       "      <td>1</td>\n",
       "      <td>PBA9469131</td>\n",
       "      <td>प्रदीप भनोट</td>\n",
       "      <td>एस एन भनोट</td>\n",
       "      <td>िपता</td>\n",
       "      <td>2</td>\n",
       "      <td>60</td>\n",
       "      <td>पुरुष</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>w0010117.pdf</td>\n",
       "      <td>2</td>\n",
       "      <td>PBA5154240</td>\n",
       "      <td>नीरज शमार्</td>\n",
       "      <td>िरखी राम</td>\n",
       "      <td>िपता</td>\n",
       "      <td>2</td>\n",
       "      <td>45</td>\n",
       "      <td>मिहला</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>w0010117.pdf</td>\n",
       "      <td>3</td>\n",
       "      <td>AXN2315307</td>\n",
       "      <td>हरीश कु मार</td>\n",
       "      <td>िबहारी लाल</td>\n",
       "      <td>िपता</td>\n",
       "      <td>2</td>\n",
       "      <td>37</td>\n",
       "      <td>पुरुष</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>w0010117.pdf</td>\n",
       "      <td>4</td>\n",
       "      <td>PBA7503139</td>\n",
       "      <td>देव कु मार सोइ</td>\n",
       "      <td>पृथ्वी राज सोइ</td>\n",
       "      <td>िपता</td>\n",
       "      <td>4</td>\n",
       "      <td>80</td>\n",
       "      <td>पुरुष</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>w0010117.pdf</td>\n",
       "      <td>5</td>\n",
       "      <td>PBA8749475</td>\n",
       "      <td>िवक्रम िसंह</td>\n",
       "      <td>बलबीर िसह</td>\n",
       "      <td>िपता</td>\n",
       "      <td>4</td>\n",
       "      <td>53</td>\n",
       "      <td>पुरुष</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>585723</th>\n",
       "      <td>w0010139.pdf</td>\n",
       "      <td>1146</td>\n",
       "      <td>AXN0302364</td>\n",
       "      <td>अशोक कु मार कु करेजा</td>\n",
       "      <td>ज्ञान चन्द कुकरेजा</td>\n",
       "      <td>िपता</td>\n",
       "      <td>3100</td>\n",
       "      <td>59</td>\n",
       "      <td>पुरुष</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>585724</th>\n",
       "      <td>w0010139.pdf</td>\n",
       "      <td>1147</td>\n",
       "      <td>AXN0302349</td>\n",
       "      <td>प्रितभा कु करेजा</td>\n",
       "      <td>अशोक कुमार कुकरेजा</td>\n",
       "      <td>पित</td>\n",
       "      <td>3100</td>\n",
       "      <td>57</td>\n",
       "      <td>मिहला</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>585725</th>\n",
       "      <td>w0010139.pdf</td>\n",
       "      <td>1148</td>\n",
       "      <td>AXN0302331</td>\n",
       "      <td>जतीन कु करेजा</td>\n",
       "      <td>अशोक कुमार कुकरेजा</td>\n",
       "      <td>िपता</td>\n",
       "      <td>3100</td>\n",
       "      <td>33</td>\n",
       "      <td>पुरुष</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>585726</th>\n",
       "      <td>w0010139.pdf</td>\n",
       "      <td>1149</td>\n",
       "      <td>AXN0302356</td>\n",
       "      <td>अपारीता कु करेजा</td>\n",
       "      <td>अशोक कुमार कुकरेजा</td>\n",
       "      <td>िपता</td>\n",
       "      <td>3100</td>\n",
       "      <td>31</td>\n",
       "      <td>मिहला</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>585727</th>\n",
       "      <td>w0010139.pdf</td>\n",
       "      <td>1150</td>\n",
       "      <td>AXN2493674</td>\n",
       "      <td>नुपुर कु करेजा</td>\n",
       "      <td>जितन कुकरेजा</td>\n",
       "      <td>पित</td>\n",
       "      <td>3100</td>\n",
       "      <td>29</td>\n",
       "      <td>मिहला</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>585728 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            filename number          id          elector_name  \\\n",
       "0       w0010117.pdf      1  PBA9469131           प्रदीप भनोट   \n",
       "1       w0010117.pdf      2  PBA5154240            नीरज शमार्   \n",
       "2       w0010117.pdf      3  AXN2315307           हरीश कु मार   \n",
       "3       w0010117.pdf      4  PBA7503139        देव कु मार सोइ   \n",
       "4       w0010117.pdf      5  PBA8749475           िवक्रम िसंह   \n",
       "...              ...    ...         ...                   ...   \n",
       "585723  w0010139.pdf   1146  AXN0302364  अशोक कु मार कु करेजा   \n",
       "585724  w0010139.pdf   1147  AXN0302349      प्रितभा कु करेजा   \n",
       "585725  w0010139.pdf   1148  AXN0302331         जतीन कु करेजा   \n",
       "585726  w0010139.pdf   1149  AXN0302356      अपारीता कु करेजा   \n",
       "585727  w0010139.pdf   1150  AXN2493674        नुपुर कु करेजा   \n",
       "\n",
       "       father_or_husband_name relationship house_no age    sex  \n",
       "0                  एस एन भनोट         िपता        2  60  पुरुष  \n",
       "1                    िरखी राम         िपता        2  45  मिहला  \n",
       "2                  िबहारी लाल         िपता        2  37  पुरुष  \n",
       "3              पृथ्वी राज सोइ         िपता        4  80  पुरुष  \n",
       "4                   बलबीर िसह         िपता        4  53  पुरुष  \n",
       "...                       ...          ...      ...  ..    ...  \n",
       "585723     ज्ञान चन्द कुकरेजा         िपता     3100  59  पुरुष  \n",
       "585724     अशोक कुमार कुकरेजा          पित     3100  57  मिहला  \n",
       "585725     अशोक कुमार कुकरेजा         िपता     3100  33  पुरुष  \n",
       "585726     अशोक कुमार कुकरेजा         िपता     3100  31  मिहला  \n",
       "585727           जितन कुकरेजा          पित     3100  29  मिहला  \n",
       "\n",
       "[585728 rows x 9 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(rows)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['िपता', 'पित', '......', 'माता'], dtype=object)"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.relationship.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['पुरुष', 'मिहला', 'तृतीय'], dtype=object)"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sex.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['60', '45', '37', '80', '53', '69', '63', '55', '52', '30', '26',\n",
       "       '74', '46', '38', '73', '50', '48', '19', '76', '54', '32', '31',\n",
       "       '57', '33', '25', '72', '66', '58', '36', '68', '51', '23', '27',\n",
       "       '24', '61', '47', '40', '91', '64', '67', '65', '42', '41', '22',\n",
       "       '35', '20', '39', '43', '79', '85', '77', '21', '81', '28', '56',\n",
       "       '44', '70', '29', '49', '59', '34', '82', '78', '75', '88', '62',\n",
       "       '86', '92', '83', '71', '89', '87', '90', '84', '96', '93', '94',\n",
       "       '97', '95', '100', '103', '102', '99', '105', '101', '98', '111',\n",
       "       '104', '112', '106'], dtype=object)"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.age.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('/opt/data/searchable_rolls/chandigarh.csv.gz', index_label='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>number</th>\n",
       "      <th>id</th>\n",
       "      <th>elector_name</th>\n",
       "      <th>father_or_husband_name</th>\n",
       "      <th>relationship</th>\n",
       "      <th>house_no</th>\n",
       "      <th>age</th>\n",
       "      <th>sex</th>\n",
       "      <th>ac_name</th>\n",
       "      <th>...</th>\n",
       "      <th>revenue_division</th>\n",
       "      <th>district</th>\n",
       "      <th>pin_code</th>\n",
       "      <th>polling_station_name</th>\n",
       "      <th>polling_station_address</th>\n",
       "      <th>net_electors_male</th>\n",
       "      <th>net_electors_female</th>\n",
       "      <th>net_electors_third_gender</th>\n",
       "      <th>net_electors_total</th>\n",
       "      <th>original_or_amendment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>AXN1387026</td>\n",
       "      <td>माया देवी पु</td>\n",
       "      <td>राम नाथ पुनिया ——</td>\n",
       "      <td>husband</td>\n",
       "      <td>511</td>\n",
       "      <td>60</td>\n",
       "      <td>महिला</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160022</td>\n",
       "      <td>246-सैक्टर-35</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...</td>\n",
       "      <td>537</td>\n",
       "      <td>538</td>\n",
       "      <td>0</td>\n",
       "      <td>1075</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>AXN1387034</td>\n",
       "      <td>मिनाक्षी पुनिया कप</td>\n",
       "      <td>राम नाथ पुनिया उपलब्ध</td>\n",
       "      <td>father</td>\n",
       "      <td>511</td>\n",
       "      <td>30</td>\n",
       "      <td>महिला</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160022</td>\n",
       "      <td>246-सैक्टर-35</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...</td>\n",
       "      <td>537</td>\n",
       "      <td>538</td>\n",
       "      <td>0</td>\n",
       "      <td>1075</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3 AXN1386432</td>\n",
       "      <td>कषण चंदर न</td>\n",
       "      <td>श्री चंद a</td>\n",
       "      <td>father</td>\n",
       "      <td>511</td>\n",
       "      <td>54</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160022</td>\n",
       "      <td>246-सैक्टर-35</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...</td>\n",
       "      <td>537</td>\n",
       "      <td>538</td>\n",
       "      <td>0</td>\n",
       "      <td>1075</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AXN1386457</td>\n",
       "      <td>कलदीपक यु</td>\n",
       "      <td>कृषण चंदर शर्मा —</td>\n",
       "      <td>father</td>\n",
       "      <td>511</td>\n",
       "      <td>30</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160022</td>\n",
       "      <td>246-सैक्टर-35</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...</td>\n",
       "      <td>537</td>\n",
       "      <td>538</td>\n",
       "      <td>0</td>\n",
       "      <td>1075</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&gt; AXN1386465</td>\n",
       "      <td>NaN</td>\n",
       "      <td>कृषण चंदर कौशिक उपलब्ध</td>\n",
       "      <td>father</td>\n",
       "      <td>511</td>\n",
       "      <td>25</td>\n",
       "      <td>महिला</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160022</td>\n",
       "      <td>246-सैक्टर-35</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...</td>\n",
       "      <td>537</td>\n",
       "      <td>538</td>\n",
       "      <td>0</td>\n",
       "      <td>1075</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27429</th>\n",
       "      <td>1211</td>\n",
       "      <td>1215.0</td>\n",
       "      <td>PBA8090821</td>\n",
       "      <td>स॒रताज ये</td>\n",
       "      <td>सरदार a</td>\n",
       "      <td>father</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>198</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160036</td>\n",
       "      <td>048-ग्राम धनास</td>\n",
       "      <td>राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)</td>\n",
       "      <td>657</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>1219</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27430</th>\n",
       "      <td>1212</td>\n",
       "      <td>1216.0</td>\n",
       "      <td>PBA8090813</td>\n",
       "      <td>सलीम कप</td>\n",
       "      <td>जाकिर अली a</td>\n",
       "      <td>father</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>198</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160036</td>\n",
       "      <td>048-ग्राम धनास</td>\n",
       "      <td>राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)</td>\n",
       "      <td>657</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>1219</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27431</th>\n",
       "      <td>1213</td>\n",
       "      <td>1217.0</td>\n",
       "      <td>AXN0461574</td>\n",
       "      <td>रुबी re</td>\n",
       "      <td>सरताज हि 7</td>\n",
       "      <td>husband</td>\n",
       "      <td>0.0</td>\n",
       "      <td>41</td>\n",
       "      <td>महिला</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>198</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160036</td>\n",
       "      <td>048-ग्राम धनास</td>\n",
       "      <td>राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)</td>\n",
       "      <td>657</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>1219</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27432</th>\n",
       "      <td>1214</td>\n",
       "      <td>1218.0</td>\n",
       "      <td>AXN2111524</td>\n",
       "      <td>जगदीश सिंह re</td>\n",
       "      <td>मेहरबान सिंह a</td>\n",
       "      <td>father</td>\n",
       "      <td>83.0</td>\n",
       "      <td>50</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>198</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160036</td>\n",
       "      <td>048-ग्राम धनास</td>\n",
       "      <td>राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)</td>\n",
       "      <td>657</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>1219</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27433</th>\n",
       "      <td>1215</td>\n",
       "      <td>1219.0</td>\n",
       "      <td>AXN1400803</td>\n",
       "      <td>प्रदीप कमार re</td>\n",
       "      <td>दिनेश कुमार यादव —</td>\n",
       "      <td>father</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>198</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160036</td>\n",
       "      <td>048-ग्राम धनास</td>\n",
       "      <td>राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)</td>\n",
       "      <td>657</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>1219</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>27434 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0  number            id        elector_name  \\\n",
       "0               0     1.0    AXN1387026        माया देवी पु   \n",
       "1               1     2.0    AXN1387034  मिनाक्षी पुनिया कप   \n",
       "2               2     NaN  3 AXN1386432          कषण चंदर न   \n",
       "3               3     4.0    AXN1386457           कलदीपक यु   \n",
       "4               4     NaN  > AXN1386465                 NaN   \n",
       "...           ...     ...           ...                 ...   \n",
       "27429        1211  1215.0    PBA8090821           स॒रताज ये   \n",
       "27430        1212  1216.0    PBA8090813             सलीम कप   \n",
       "27431        1213  1217.0    AXN0461574             रुबी re   \n",
       "27432        1214  1218.0    AXN2111524       जगदीश सिंह re   \n",
       "27433        1215  1219.0    AXN1400803      प्रदीप कमार re   \n",
       "\n",
       "       father_or_husband_name relationship house_no  age    sex  \\\n",
       "0           राम नाथ पुनिया ——      husband      511   60  महिला   \n",
       "1       राम नाथ पुनिया उपलब्ध       father      511   30  महिला   \n",
       "2                  श्री चंद a       father      511   54  पुरूष   \n",
       "3           कृषण चंदर शर्मा —       father      511   30  पुरूष   \n",
       "4      कृषण चंदर कौशिक उपलब्ध       father      511   25  महिला   \n",
       "...                       ...          ...      ...  ...    ...   \n",
       "27429                 सरदार a       father      NaN   51  पुरूष   \n",
       "27430             जाकिर अली a       father      NaN   43  पुरूष   \n",
       "27431              सरताज हि 7      husband      0.0   41  महिला   \n",
       "27432          मेहरबान सिंह a       father     83.0   50  पुरूष   \n",
       "27433      दिनेश कुमार यादव —       father      1.0   26  पुरूष   \n",
       "\n",
       "               ac_name  ...  revenue_division  district  pin_code  \\\n",
       "0       001 - चण्डीगढ़  ...                 0  चण्डीगढ़    160022   \n",
       "1       001 - चण्डीगढ़  ...                 0  चण्डीगढ़    160022   \n",
       "2       001 - चण्डीगढ़  ...                 0  चण्डीगढ़    160022   \n",
       "3       001 - चण्डीगढ़  ...                 0  चण्डीगढ़    160022   \n",
       "4       001 - चण्डीगढ़  ...                 0  चण्डीगढ़    160022   \n",
       "...                ...  ...               ...       ...       ...   \n",
       "27429   001 - चण्डीगढ़  ...               198  चण्डीगढ़    160036   \n",
       "27430   001 - चण्डीगढ़  ...               198  चण्डीगढ़    160036   \n",
       "27431   001 - चण्डीगढ़  ...               198  चण्डीगढ़    160036   \n",
       "27432   001 - चण्डीगढ़  ...               198  चण्डीगढ़    160036   \n",
       "27433   001 - चण्डीगढ़  ...               198  चण्डीगढ़    160036   \n",
       "\n",
       "      polling_station_name                            polling_station_address  \\\n",
       "0            246-सैक्टर-35   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...   \n",
       "1            246-सैक्टर-35   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...   \n",
       "2            246-सैक्टर-35   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...   \n",
       "3            246-सैक्टर-35   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...   \n",
       "4            246-सैक्टर-35   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...   \n",
       "...                    ...                                                ...   \n",
       "27429       048-ग्राम धनास     राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)   \n",
       "27430       048-ग्राम धनास     राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)   \n",
       "27431       048-ग्राम धनास     राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)   \n",
       "27432       048-ग्राम धनास     राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)   \n",
       "27433       048-ग्राम धनास     राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)   \n",
       "\n",
       "      net_electors_male net_electors_female net_electors_third_gender  \\\n",
       "0                   537                 538                         0   \n",
       "1                   537                 538                         0   \n",
       "2                   537                 538                         0   \n",
       "3                   537                 538                         0   \n",
       "4                   537                 538                         0   \n",
       "...                 ...                 ...                       ...   \n",
       "27429               657                 562                         0   \n",
       "27430               657                 562                         0   \n",
       "27431               657                 562                         0   \n",
       "27432               657                 562                         0   \n",
       "27433               657                 562                         0   \n",
       "\n",
       "       net_electors_total original_or_amendment  \n",
       "0                    1075              original  \n",
       "1                    1075              original  \n",
       "2                    1075              original  \n",
       "3                    1075              original  \n",
       "4                    1075              original  \n",
       "...                   ...                   ...  \n",
       "27429                1219              original  \n",
       "27430                1219              original  \n",
       "27431                1219              original  \n",
       "27432                1219              original  \n",
       "27433                1219              original  \n",
       "\n",
       "[27434 rows x 28 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = pd.read_csv('../../parse_in_rolls/csvs/Chandigar_final.csv')\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>number</th>\n",
       "      <th>id</th>\n",
       "      <th>elector_name</th>\n",
       "      <th>father_or_husband_name</th>\n",
       "      <th>relationship</th>\n",
       "      <th>house_no</th>\n",
       "      <th>age</th>\n",
       "      <th>sex</th>\n",
       "      <th>ac_name</th>\n",
       "      <th>...</th>\n",
       "      <th>revenue_division</th>\n",
       "      <th>district</th>\n",
       "      <th>pin_code</th>\n",
       "      <th>polling_station_name</th>\n",
       "      <th>polling_station_address</th>\n",
       "      <th>net_electors_male</th>\n",
       "      <th>net_electors_female</th>\n",
       "      <th>net_electors_third_gender</th>\n",
       "      <th>net_electors_total</th>\n",
       "      <th>original_or_amendment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>AXN1387026</td>\n",
       "      <td>माया देवी पु</td>\n",
       "      <td>राम नाथ पुनिया ——</td>\n",
       "      <td>husband</td>\n",
       "      <td>511</td>\n",
       "      <td>60</td>\n",
       "      <td>महिला</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160022</td>\n",
       "      <td>246-सैक्टर-35</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...</td>\n",
       "      <td>537</td>\n",
       "      <td>538</td>\n",
       "      <td>0</td>\n",
       "      <td>1075</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>AXN1387034</td>\n",
       "      <td>मिनाक्षी पुनिया कप</td>\n",
       "      <td>राम नाथ पुनिया उपलब्ध</td>\n",
       "      <td>father</td>\n",
       "      <td>511</td>\n",
       "      <td>30</td>\n",
       "      <td>महिला</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160022</td>\n",
       "      <td>246-सैक्टर-35</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...</td>\n",
       "      <td>537</td>\n",
       "      <td>538</td>\n",
       "      <td>0</td>\n",
       "      <td>1075</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3 AXN1386432</td>\n",
       "      <td>कषण चंदर न</td>\n",
       "      <td>श्री चंद a</td>\n",
       "      <td>father</td>\n",
       "      <td>511</td>\n",
       "      <td>54</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160022</td>\n",
       "      <td>246-सैक्टर-35</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...</td>\n",
       "      <td>537</td>\n",
       "      <td>538</td>\n",
       "      <td>0</td>\n",
       "      <td>1075</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AXN1386457</td>\n",
       "      <td>कलदीपक यु</td>\n",
       "      <td>कृषण चंदर शर्मा —</td>\n",
       "      <td>father</td>\n",
       "      <td>511</td>\n",
       "      <td>30</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160022</td>\n",
       "      <td>246-सैक्टर-35</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...</td>\n",
       "      <td>537</td>\n",
       "      <td>538</td>\n",
       "      <td>0</td>\n",
       "      <td>1075</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&gt; AXN1386465</td>\n",
       "      <td>NaN</td>\n",
       "      <td>कृषण चंदर कौशिक उपलब्ध</td>\n",
       "      <td>father</td>\n",
       "      <td>511</td>\n",
       "      <td>25</td>\n",
       "      <td>महिला</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160022</td>\n",
       "      <td>246-सैक्टर-35</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...</td>\n",
       "      <td>537</td>\n",
       "      <td>538</td>\n",
       "      <td>0</td>\n",
       "      <td>1075</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27429</th>\n",
       "      <td>1211</td>\n",
       "      <td>1215.0</td>\n",
       "      <td>PBA8090821</td>\n",
       "      <td>स॒रताज ये</td>\n",
       "      <td>सरदार a</td>\n",
       "      <td>father</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>198</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160036</td>\n",
       "      <td>048-ग्राम धनास</td>\n",
       "      <td>राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)</td>\n",
       "      <td>657</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>1219</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27430</th>\n",
       "      <td>1212</td>\n",
       "      <td>1216.0</td>\n",
       "      <td>PBA8090813</td>\n",
       "      <td>सलीम कप</td>\n",
       "      <td>जाकिर अली a</td>\n",
       "      <td>father</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>198</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160036</td>\n",
       "      <td>048-ग्राम धनास</td>\n",
       "      <td>राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)</td>\n",
       "      <td>657</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>1219</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27431</th>\n",
       "      <td>1213</td>\n",
       "      <td>1217.0</td>\n",
       "      <td>AXN0461574</td>\n",
       "      <td>रुबी re</td>\n",
       "      <td>सरताज हि 7</td>\n",
       "      <td>husband</td>\n",
       "      <td>0.0</td>\n",
       "      <td>41</td>\n",
       "      <td>महिला</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>198</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160036</td>\n",
       "      <td>048-ग्राम धनास</td>\n",
       "      <td>राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)</td>\n",
       "      <td>657</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>1219</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27432</th>\n",
       "      <td>1214</td>\n",
       "      <td>1218.0</td>\n",
       "      <td>AXN2111524</td>\n",
       "      <td>जगदीश सिंह re</td>\n",
       "      <td>मेहरबान सिंह a</td>\n",
       "      <td>father</td>\n",
       "      <td>83.0</td>\n",
       "      <td>50</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>198</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160036</td>\n",
       "      <td>048-ग्राम धनास</td>\n",
       "      <td>राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)</td>\n",
       "      <td>657</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>1219</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27433</th>\n",
       "      <td>1215</td>\n",
       "      <td>1219.0</td>\n",
       "      <td>AXN1400803</td>\n",
       "      <td>प्रदीप कमार re</td>\n",
       "      <td>दिनेश कुमार यादव —</td>\n",
       "      <td>father</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>198</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160036</td>\n",
       "      <td>048-ग्राम धनास</td>\n",
       "      <td>राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)</td>\n",
       "      <td>657</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>1219</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>27434 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0  number            id        elector_name  \\\n",
       "0               0     1.0    AXN1387026        माया देवी पु   \n",
       "1               1     2.0    AXN1387034  मिनाक्षी पुनिया कप   \n",
       "2               2     NaN  3 AXN1386432          कषण चंदर न   \n",
       "3               3     4.0    AXN1386457           कलदीपक यु   \n",
       "4               4     NaN  > AXN1386465                 NaN   \n",
       "...           ...     ...           ...                 ...   \n",
       "27429        1211  1215.0    PBA8090821           स॒रताज ये   \n",
       "27430        1212  1216.0    PBA8090813             सलीम कप   \n",
       "27431        1213  1217.0    AXN0461574             रुबी re   \n",
       "27432        1214  1218.0    AXN2111524       जगदीश सिंह re   \n",
       "27433        1215  1219.0    AXN1400803      प्रदीप कमार re   \n",
       "\n",
       "       father_or_husband_name relationship house_no  age    sex  \\\n",
       "0           राम नाथ पुनिया ——      husband      511   60  महिला   \n",
       "1       राम नाथ पुनिया उपलब्ध       father      511   30  महिला   \n",
       "2                  श्री चंद a       father      511   54  पुरूष   \n",
       "3           कृषण चंदर शर्मा —       father      511   30  पुरूष   \n",
       "4      कृषण चंदर कौशिक उपलब्ध       father      511   25  महिला   \n",
       "...                       ...          ...      ...  ...    ...   \n",
       "27429                 सरदार a       father      NaN   51  पुरूष   \n",
       "27430             जाकिर अली a       father      NaN   43  पुरूष   \n",
       "27431              सरताज हि 7      husband      0.0   41  महिला   \n",
       "27432          मेहरबान सिंह a       father     83.0   50  पुरूष   \n",
       "27433      दिनेश कुमार यादव —       father      1.0   26  पुरूष   \n",
       "\n",
       "               ac_name  ...  revenue_division  district  pin_code  \\\n",
       "0       001 - चण्डीगढ़  ...                 0  चण्डीगढ़    160022   \n",
       "1       001 - चण्डीगढ़  ...                 0  चण्डीगढ़    160022   \n",
       "2       001 - चण्डीगढ़  ...                 0  चण्डीगढ़    160022   \n",
       "3       001 - चण्डीगढ़  ...                 0  चण्डीगढ़    160022   \n",
       "4       001 - चण्डीगढ़  ...                 0  चण्डीगढ़    160022   \n",
       "...                ...  ...               ...       ...       ...   \n",
       "27429   001 - चण्डीगढ़  ...               198  चण्डीगढ़    160036   \n",
       "27430   001 - चण्डीगढ़  ...               198  चण्डीगढ़    160036   \n",
       "27431   001 - चण्डीगढ़  ...               198  चण्डीगढ़    160036   \n",
       "27432   001 - चण्डीगढ़  ...               198  चण्डीगढ़    160036   \n",
       "27433   001 - चण्डीगढ़  ...               198  चण्डीगढ़    160036   \n",
       "\n",
       "      polling_station_name                            polling_station_address  \\\n",
       "0            246-सैक्टर-35   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...   \n",
       "1            246-सैक्टर-35   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...   \n",
       "2            246-सैक्टर-35   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...   \n",
       "3            246-सैक्टर-35   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...   \n",
       "4            246-सैक्टर-35   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...   \n",
       "...                    ...                                                ...   \n",
       "27429       048-ग्राम धनास     राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)   \n",
       "27430       048-ग्राम धनास     राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)   \n",
       "27431       048-ग्राम धनास     राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)   \n",
       "27432       048-ग्राम धनास     राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)   \n",
       "27433       048-ग्राम धनास     राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)   \n",
       "\n",
       "      net_electors_male net_electors_female net_electors_third_gender  \\\n",
       "0                   537                 538                         0   \n",
       "1                   537                 538                         0   \n",
       "2                   537                 538                         0   \n",
       "3                   537                 538                         0   \n",
       "4                   537                 538                         0   \n",
       "...                 ...                 ...                       ...   \n",
       "27429               657                 562                         0   \n",
       "27430               657                 562                         0   \n",
       "27431               657                 562                         0   \n",
       "27432               657                 562                         0   \n",
       "27433               657                 562                         0   \n",
       "\n",
       "       net_electors_total original_or_amendment  \n",
       "0                    1075              original  \n",
       "1                    1075              original  \n",
       "2                    1075              original  \n",
       "3                    1075              original  \n",
       "4                    1075              original  \n",
       "...                   ...                   ...  \n",
       "27429                1219              original  \n",
       "27430                1219              original  \n",
       "27431                1219              original  \n",
       "27432                1219              original  \n",
       "27433                1219              original  \n",
       "\n",
       "[27434 rows x 28 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.id = df2.id.str.strip()\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>number</th>\n",
       "      <th>id</th>\n",
       "      <th>elector_name</th>\n",
       "      <th>father_or_husband_name</th>\n",
       "      <th>relationship</th>\n",
       "      <th>house_no</th>\n",
       "      <th>age</th>\n",
       "      <th>sex</th>\n",
       "      <th>ac_name</th>\n",
       "      <th>...</th>\n",
       "      <th>revenue_division</th>\n",
       "      <th>district</th>\n",
       "      <th>pin_code</th>\n",
       "      <th>polling_station_name</th>\n",
       "      <th>polling_station_address</th>\n",
       "      <th>net_electors_male</th>\n",
       "      <th>net_electors_female</th>\n",
       "      <th>net_electors_third_gender</th>\n",
       "      <th>net_electors_total</th>\n",
       "      <th>original_or_amendment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>AXN1387026</td>\n",
       "      <td>माया देवी पु</td>\n",
       "      <td>राम नाथ पुनिया ——</td>\n",
       "      <td>husband</td>\n",
       "      <td>511</td>\n",
       "      <td>60</td>\n",
       "      <td>महिला</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160022</td>\n",
       "      <td>246-सैक्टर-35</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...</td>\n",
       "      <td>537</td>\n",
       "      <td>538</td>\n",
       "      <td>0</td>\n",
       "      <td>1075</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>AXN1387034</td>\n",
       "      <td>मिनाक्षी पुनिया कप</td>\n",
       "      <td>राम नाथ पुनिया उपलब्ध</td>\n",
       "      <td>father</td>\n",
       "      <td>511</td>\n",
       "      <td>30</td>\n",
       "      <td>महिला</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160022</td>\n",
       "      <td>246-सैक्टर-35</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...</td>\n",
       "      <td>537</td>\n",
       "      <td>538</td>\n",
       "      <td>0</td>\n",
       "      <td>1075</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3 AXN1386432</td>\n",
       "      <td>कषण चंदर न</td>\n",
       "      <td>श्री चंद a</td>\n",
       "      <td>father</td>\n",
       "      <td>511</td>\n",
       "      <td>54</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160022</td>\n",
       "      <td>246-सैक्टर-35</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...</td>\n",
       "      <td>537</td>\n",
       "      <td>538</td>\n",
       "      <td>0</td>\n",
       "      <td>1075</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AXN1386457</td>\n",
       "      <td>कलदीपक यु</td>\n",
       "      <td>कृषण चंदर शर्मा —</td>\n",
       "      <td>father</td>\n",
       "      <td>511</td>\n",
       "      <td>30</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160022</td>\n",
       "      <td>246-सैक्टर-35</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...</td>\n",
       "      <td>537</td>\n",
       "      <td>538</td>\n",
       "      <td>0</td>\n",
       "      <td>1075</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&gt; AXN1386465</td>\n",
       "      <td>NaN</td>\n",
       "      <td>कृषण चंदर कौशिक उपलब्ध</td>\n",
       "      <td>father</td>\n",
       "      <td>511</td>\n",
       "      <td>25</td>\n",
       "      <td>महिला</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160022</td>\n",
       "      <td>246-सैक्टर-35</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...</td>\n",
       "      <td>537</td>\n",
       "      <td>538</td>\n",
       "      <td>0</td>\n",
       "      <td>1075</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27429</th>\n",
       "      <td>1211</td>\n",
       "      <td>1215.0</td>\n",
       "      <td>PBA8090821</td>\n",
       "      <td>स॒रताज ये</td>\n",
       "      <td>सरदार a</td>\n",
       "      <td>father</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>198</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160036</td>\n",
       "      <td>048-ग्राम धनास</td>\n",
       "      <td>राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)</td>\n",
       "      <td>657</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>1219</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27430</th>\n",
       "      <td>1212</td>\n",
       "      <td>1216.0</td>\n",
       "      <td>PBA8090813</td>\n",
       "      <td>सलीम कप</td>\n",
       "      <td>जाकिर अली a</td>\n",
       "      <td>father</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>198</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160036</td>\n",
       "      <td>048-ग्राम धनास</td>\n",
       "      <td>राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)</td>\n",
       "      <td>657</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>1219</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27431</th>\n",
       "      <td>1213</td>\n",
       "      <td>1217.0</td>\n",
       "      <td>AXN0461574</td>\n",
       "      <td>रुबी re</td>\n",
       "      <td>सरताज हि 7</td>\n",
       "      <td>husband</td>\n",
       "      <td>0.0</td>\n",
       "      <td>41</td>\n",
       "      <td>महिला</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>198</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160036</td>\n",
       "      <td>048-ग्राम धनास</td>\n",
       "      <td>राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)</td>\n",
       "      <td>657</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>1219</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27432</th>\n",
       "      <td>1214</td>\n",
       "      <td>1218.0</td>\n",
       "      <td>AXN2111524</td>\n",
       "      <td>जगदीश सिंह re</td>\n",
       "      <td>मेहरबान सिंह a</td>\n",
       "      <td>father</td>\n",
       "      <td>83.0</td>\n",
       "      <td>50</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>198</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160036</td>\n",
       "      <td>048-ग्राम धनास</td>\n",
       "      <td>राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)</td>\n",
       "      <td>657</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>1219</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27433</th>\n",
       "      <td>1215</td>\n",
       "      <td>1219.0</td>\n",
       "      <td>AXN1400803</td>\n",
       "      <td>प्रदीप कमार re</td>\n",
       "      <td>दिनेश कुमार यादव —</td>\n",
       "      <td>father</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>001 - चण्डीगढ़</td>\n",
       "      <td>...</td>\n",
       "      <td>198</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160036</td>\n",
       "      <td>048-ग्राम धनास</td>\n",
       "      <td>राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)</td>\n",
       "      <td>657</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>1219</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>27434 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0  number            id        elector_name  \\\n",
       "0               0     1.0    AXN1387026        माया देवी पु   \n",
       "1               1     2.0    AXN1387034  मिनाक्षी पुनिया कप   \n",
       "2               2     NaN  3 AXN1386432          कषण चंदर न   \n",
       "3               3     4.0    AXN1386457           कलदीपक यु   \n",
       "4               4     NaN  > AXN1386465                 NaN   \n",
       "...           ...     ...           ...                 ...   \n",
       "27429        1211  1215.0    PBA8090821           स॒रताज ये   \n",
       "27430        1212  1216.0    PBA8090813             सलीम कप   \n",
       "27431        1213  1217.0    AXN0461574             रुबी re   \n",
       "27432        1214  1218.0    AXN2111524       जगदीश सिंह re   \n",
       "27433        1215  1219.0    AXN1400803      प्रदीप कमार re   \n",
       "\n",
       "       father_or_husband_name relationship house_no  age    sex  \\\n",
       "0           राम नाथ पुनिया ——      husband      511   60  महिला   \n",
       "1       राम नाथ पुनिया उपलब्ध       father      511   30  महिला   \n",
       "2                  श्री चंद a       father      511   54  पुरूष   \n",
       "3           कृषण चंदर शर्मा —       father      511   30  पुरूष   \n",
       "4      कृषण चंदर कौशिक उपलब्ध       father      511   25  महिला   \n",
       "...                       ...          ...      ...  ...    ...   \n",
       "27429                 सरदार a       father      NaN   51  पुरूष   \n",
       "27430             जाकिर अली a       father      NaN   43  पुरूष   \n",
       "27431              सरताज हि 7      husband      0.0   41  महिला   \n",
       "27432          मेहरबान सिंह a       father     83.0   50  पुरूष   \n",
       "27433      दिनेश कुमार यादव —       father      1.0   26  पुरूष   \n",
       "\n",
       "               ac_name  ...  revenue_division  district  pin_code  \\\n",
       "0       001 - चण्डीगढ़  ...                 0  चण्डीगढ़    160022   \n",
       "1       001 - चण्डीगढ़  ...                 0  चण्डीगढ़    160022   \n",
       "2       001 - चण्डीगढ़  ...                 0  चण्डीगढ़    160022   \n",
       "3       001 - चण्डीगढ़  ...                 0  चण्डीगढ़    160022   \n",
       "4       001 - चण्डीगढ़  ...                 0  चण्डीगढ़    160022   \n",
       "...                ...  ...               ...       ...       ...   \n",
       "27429   001 - चण्डीगढ़  ...               198  चण्डीगढ़    160036   \n",
       "27430   001 - चण्डीगढ़  ...               198  चण्डीगढ़    160036   \n",
       "27431   001 - चण्डीगढ़  ...               198  चण्डीगढ़    160036   \n",
       "27432   001 - चण्डीगढ़  ...               198  चण्डीगढ़    160036   \n",
       "27433   001 - चण्डीगढ़  ...               198  चण्डीगढ़    160036   \n",
       "\n",
       "      polling_station_name                            polling_station_address  \\\n",
       "0            246-सैक्टर-35   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...   \n",
       "1            246-सैक्टर-35   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...   \n",
       "2            246-सैक्टर-35   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...   \n",
       "3            246-सैक्टर-35   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...   \n",
       "4            246-सैक्टर-35   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 35डी...   \n",
       "...                    ...                                                ...   \n",
       "27429       048-ग्राम धनास     राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)   \n",
       "27430       048-ग्राम धनास     राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)   \n",
       "27431       048-ग्राम धनास     राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)   \n",
       "27432       048-ग्राम धनास     राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)   \n",
       "27433       048-ग्राम धनास     राजकीय सीनियर सकैंडरी स्कूल, धनास (कमरा.न. 87)   \n",
       "\n",
       "      net_electors_male net_electors_female net_electors_third_gender  \\\n",
       "0                   537                 538                         0   \n",
       "1                   537                 538                         0   \n",
       "2                   537                 538                         0   \n",
       "3                   537                 538                         0   \n",
       "4                   537                 538                         0   \n",
       "...                 ...                 ...                       ...   \n",
       "27429               657                 562                         0   \n",
       "27430               657                 562                         0   \n",
       "27431               657                 562                         0   \n",
       "27432               657                 562                         0   \n",
       "27433               657                 562                         0   \n",
       "\n",
       "       net_electors_total original_or_amendment  \n",
       "0                    1075              original  \n",
       "1                    1075              original  \n",
       "2                    1075              original  \n",
       "3                    1075              original  \n",
       "4                    1075              original  \n",
       "...                   ...                   ...  \n",
       "27429                1219              original  \n",
       "27430                1219              original  \n",
       "27431                1219              original  \n",
       "27432                1219              original  \n",
       "27433                1219              original  \n",
       "\n",
       "[27434 rows x 28 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.elector_name = df2.elector_name.str.strip()\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>filename_x</th>\n",
       "      <th>number_x</th>\n",
       "      <th>id</th>\n",
       "      <th>elector_name_x</th>\n",
       "      <th>father_or_husband_name_x</th>\n",
       "      <th>relationship_x</th>\n",
       "      <th>house_no_x</th>\n",
       "      <th>age_x</th>\n",
       "      <th>sex_x</th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>...</th>\n",
       "      <th>revenue_division</th>\n",
       "      <th>district</th>\n",
       "      <th>pin_code</th>\n",
       "      <th>polling_station_name</th>\n",
       "      <th>polling_station_address</th>\n",
       "      <th>net_electors_male</th>\n",
       "      <th>net_electors_female</th>\n",
       "      <th>net_electors_third_gender</th>\n",
       "      <th>net_electors_total</th>\n",
       "      <th>original_or_amendment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>w0010309.pdf</td>\n",
       "      <td>1</td>\n",
       "      <td>CH/01/000/1119913</td>\n",
       "      <td>सुिर�द्र िसंह</td>\n",
       "      <td>हरबन्स िसह</td>\n",
       "      <td>िपता</td>\n",
       "      <td>1</td>\n",
       "      <td>77</td>\n",
       "      <td>पुरुष</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160047</td>\n",
       "      <td>309-सैक्टर 44</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 44बी...</td>\n",
       "      <td>569</td>\n",
       "      <td>548</td>\n",
       "      <td>0</td>\n",
       "      <td>1117</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>w0010309.pdf</td>\n",
       "      <td>2</td>\n",
       "      <td>CH/01/000/1119914</td>\n",
       "      <td>गुिर�द्रजीत कौर</td>\n",
       "      <td>सुिरन्दर् िसह</td>\n",
       "      <td>पित</td>\n",
       "      <td>1</td>\n",
       "      <td>71</td>\n",
       "      <td>मिहला</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160047</td>\n",
       "      <td>309-सैक्टर 44</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 44बी...</td>\n",
       "      <td>569</td>\n",
       "      <td>548</td>\n",
       "      <td>0</td>\n",
       "      <td>1117</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>w0010309.pdf</td>\n",
       "      <td>4</td>\n",
       "      <td>AXN3297181</td>\n",
       "      <td>हरिसमरन कोहली</td>\n",
       "      <td>गुरपर्ीत िसह</td>\n",
       "      <td>पित</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>मिहला</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160047</td>\n",
       "      <td>309-सैक्टर 44</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 44बी...</td>\n",
       "      <td>569</td>\n",
       "      <td>548</td>\n",
       "      <td>0</td>\n",
       "      <td>1117</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>w0010309.pdf</td>\n",
       "      <td>5</td>\n",
       "      <td>AXN2593937</td>\n",
       "      <td>तरसेम िसंह िसधु</td>\n",
       "      <td>संत राम</td>\n",
       "      <td>िपता</td>\n",
       "      <td>1/बी 2 फ्लोर</td>\n",
       "      <td>54</td>\n",
       "      <td>पुरुष</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160047</td>\n",
       "      <td>309-सैक्टर 44</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 44बी...</td>\n",
       "      <td>569</td>\n",
       "      <td>548</td>\n",
       "      <td>0</td>\n",
       "      <td>1117</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>w0010309.pdf</td>\n",
       "      <td>7</td>\n",
       "      <td>AXN2593945</td>\n",
       "      <td>नवनीत िसधु</td>\n",
       "      <td>तरसेम िसह िसधु</td>\n",
       "      <td>िपता</td>\n",
       "      <td>1/बी, 2 फ्लोर</td>\n",
       "      <td>24</td>\n",
       "      <td>मिहला</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160047</td>\n",
       "      <td>309-सैक्टर 44</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 44बी...</td>\n",
       "      <td>569</td>\n",
       "      <td>548</td>\n",
       "      <td>0</td>\n",
       "      <td>1117</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25560</th>\n",
       "      <td>w0010181.pdf</td>\n",
       "      <td>1230</td>\n",
       "      <td>PBA9252313</td>\n",
       "      <td>�याम नारायण गु�ता</td>\n",
       "      <td>कीतर् राय गु�ा</td>\n",
       "      <td>िपता</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>पुरुष</td>\n",
       "      <td>1227</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160026</td>\n",
       "      <td>181-सैक्टर 26</td>\n",
       "      <td>कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...</td>\n",
       "      <td>706</td>\n",
       "      <td>528</td>\n",
       "      <td>0</td>\n",
       "      <td>1234</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25561</th>\n",
       "      <td>w0010181.pdf</td>\n",
       "      <td>1231</td>\n",
       "      <td>PBA9252156</td>\n",
       "      <td>परस बैथा</td>\n",
       "      <td>भगराझान बैथा</td>\n",
       "      <td>िपता</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>पुरुष</td>\n",
       "      <td>1228</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160026</td>\n",
       "      <td>181-सैक्टर 26</td>\n",
       "      <td>कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...</td>\n",
       "      <td>706</td>\n",
       "      <td>528</td>\n",
       "      <td>0</td>\n",
       "      <td>1234</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25562</th>\n",
       "      <td>w0010181.pdf</td>\n",
       "      <td>1232</td>\n",
       "      <td>PBA9252305</td>\n",
       "      <td>दरोगा शाह</td>\n",
       "      <td>रमेश वर शाह</td>\n",
       "      <td>िपता</td>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>पुरुष</td>\n",
       "      <td>1229</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160026</td>\n",
       "      <td>181-सैक्टर 26</td>\n",
       "      <td>कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...</td>\n",
       "      <td>706</td>\n",
       "      <td>528</td>\n",
       "      <td>0</td>\n",
       "      <td>1234</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25563</th>\n",
       "      <td>w0010181.pdf</td>\n",
       "      <td>1233</td>\n",
       "      <td>PBA9252198</td>\n",
       "      <td>लाल बदन ठाकु र</td>\n",
       "      <td>राम जनक ठाकुर</td>\n",
       "      <td>िपता</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>पुरुष</td>\n",
       "      <td>1230</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160026</td>\n",
       "      <td>181-सैक्टर 26</td>\n",
       "      <td>कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...</td>\n",
       "      <td>706</td>\n",
       "      <td>528</td>\n",
       "      <td>0</td>\n",
       "      <td>1234</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25564</th>\n",
       "      <td>w0010181.pdf</td>\n",
       "      <td>1234</td>\n",
       "      <td>PBA9252248</td>\n",
       "      <td>अशोक बैथा</td>\n",
       "      <td>कंचन बैथा</td>\n",
       "      <td>िपता</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>पुरुष</td>\n",
       "      <td>1231</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160026</td>\n",
       "      <td>181-सैक्टर 26</td>\n",
       "      <td>कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...</td>\n",
       "      <td>706</td>\n",
       "      <td>528</td>\n",
       "      <td>0</td>\n",
       "      <td>1234</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25565 rows × 36 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         filename_x number_x                 id     elector_name_x  \\\n",
       "0      w0010309.pdf        1  CH/01/000/1119913      सुिर�द्र िसंह   \n",
       "1      w0010309.pdf        2  CH/01/000/1119914    गुिर�द्रजीत कौर   \n",
       "2      w0010309.pdf        4         AXN3297181      हरिसमरन कोहली   \n",
       "3      w0010309.pdf        5         AXN2593937    तरसेम िसंह िसधु   \n",
       "4      w0010309.pdf        7         AXN2593945         नवनीत िसधु   \n",
       "...             ...      ...                ...                ...   \n",
       "25560  w0010181.pdf     1230         PBA9252313  �याम नारायण गु�ता   \n",
       "25561  w0010181.pdf     1231         PBA9252156           परस बैथा   \n",
       "25562  w0010181.pdf     1232         PBA9252305          दरोगा शाह   \n",
       "25563  w0010181.pdf     1233         PBA9252198     लाल बदन ठाकु र   \n",
       "25564  w0010181.pdf     1234         PBA9252248          अशोक बैथा   \n",
       "\n",
       "      father_or_husband_name_x relationship_x     house_no_x age_x  sex_x  \\\n",
       "0                   हरबन्स िसह           िपता              1    77  पुरुष   \n",
       "1                सुिरन्दर् िसह            पित              1    71  मिहला   \n",
       "2                 गुरपर्ीत िसह            पित              1    32  मिहला   \n",
       "3                      संत राम           िपता   1/बी 2 फ्लोर    54  पुरुष   \n",
       "4               तरसेम िसह िसधु           िपता  1/बी, 2 फ्लोर    24  मिहला   \n",
       "...                        ...            ...            ...   ...    ...   \n",
       "25560           कीतर् राय गु�ा           िपता              1    52  पुरुष   \n",
       "25561             भगराझान बैथा           िपता              1    41  पुरुष   \n",
       "25562              रमेश वर शाह           िपता              1    33  पुरुष   \n",
       "25563            राम जनक ठाकुर           िपता              1    30  पुरुष   \n",
       "25564                कंचन बैथा           िपता              1    28  पुरुष   \n",
       "\n",
       "       Unnamed: 0  ...  revenue_division  district pin_code  \\\n",
       "0               0  ...                 0  चण्डीगढ़   160047   \n",
       "1               1  ...                 0  चण्डीगढ़   160047   \n",
       "2               3  ...                 0  चण्डीगढ़   160047   \n",
       "3               4  ...                 0  चण्डीगढ़   160047   \n",
       "4               6  ...                 0  चण्डीगढ़   160047   \n",
       "...           ...  ...               ...       ...      ...   \n",
       "25560        1227  ...                 0  चण्डीगढ़   160026   \n",
       "25561        1228  ...                 0  चण्डीगढ़   160026   \n",
       "25562        1229  ...                 0  चण्डीगढ़   160026   \n",
       "25563        1230  ...                 0  चण्डीगढ़   160026   \n",
       "25564        1231  ...                 0  चण्डीगढ़   160026   \n",
       "\n",
       "      polling_station_name                            polling_station_address  \\\n",
       "0            309-सैक्टर 44   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 44बी...   \n",
       "1            309-सैक्टर 44   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 44बी...   \n",
       "2            309-सैक्टर 44   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 44बी...   \n",
       "3            309-सैक्टर 44   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 44बी...   \n",
       "4            309-सैक्टर 44   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 44बी...   \n",
       "...                    ...                                                ...   \n",
       "25560        181-सैक्टर 26   कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...   \n",
       "25561        181-सैक्टर 26   कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...   \n",
       "25562        181-सैक्टर 26   कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...   \n",
       "25563        181-सैक्टर 26   कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...   \n",
       "25564        181-सैक्टर 26   कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...   \n",
       "\n",
       "       net_electors_male net_electors_female net_electors_third_gender  \\\n",
       "0                    569                 548                         0   \n",
       "1                    569                 548                         0   \n",
       "2                    569                 548                         0   \n",
       "3                    569                 548                         0   \n",
       "4                    569                 548                         0   \n",
       "...                  ...                 ...                       ...   \n",
       "25560                706                 528                         0   \n",
       "25561                706                 528                         0   \n",
       "25562                706                 528                         0   \n",
       "25563                706                 528                         0   \n",
       "25564                706                 528                         0   \n",
       "\n",
       "       net_electors_total  original_or_amendment  \n",
       "0                    1117               original  \n",
       "1                    1117               original  \n",
       "2                    1117               original  \n",
       "3                    1117               original  \n",
       "4                    1117               original  \n",
       "...                   ...                    ...  \n",
       "25560                1234               original  \n",
       "25561                1234               original  \n",
       "25562                1234               original  \n",
       "25563                1234               original  \n",
       "25564                1234               original  \n",
       "\n",
       "[25565 rows x 36 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3 = df.merge(df2, on='id')\n",
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>filename_x</th>\n",
       "      <th>number_x</th>\n",
       "      <th>id</th>\n",
       "      <th>elector_name_x</th>\n",
       "      <th>father_or_husband_name_x</th>\n",
       "      <th>relationship_x</th>\n",
       "      <th>house_no_x</th>\n",
       "      <th>age_x</th>\n",
       "      <th>sex_x</th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>...</th>\n",
       "      <th>revenue_division</th>\n",
       "      <th>district</th>\n",
       "      <th>pin_code</th>\n",
       "      <th>polling_station_name</th>\n",
       "      <th>polling_station_address</th>\n",
       "      <th>net_electors_male</th>\n",
       "      <th>net_electors_female</th>\n",
       "      <th>net_electors_third_gender</th>\n",
       "      <th>net_electors_total</th>\n",
       "      <th>original_or_amendment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>646</th>\n",
       "      <td>w0010309.pdf</td>\n",
       "      <td>685</td>\n",
       "      <td>AXN1252063</td>\n",
       "      <td>गगनदीप कौर</td>\n",
       "      <td>तरसेम िसह</td>\n",
       "      <td>िपता</td>\n",
       "      <td>175</td>\n",
       "      <td>25</td>\n",
       "      <td>मिहला</td>\n",
       "      <td>683</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160047</td>\n",
       "      <td>309-सैक्टर 44</td>\n",
       "      <td>राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 44बी...</td>\n",
       "      <td>569</td>\n",
       "      <td>548</td>\n",
       "      <td>0</td>\n",
       "      <td>1117</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1167</th>\n",
       "      <td>w0010172.pdf</td>\n",
       "      <td>133</td>\n",
       "      <td>PBA6082507</td>\n",
       "      <td>सगा राम</td>\n",
       "      <td>कालु राम</td>\n",
       "      <td>िपता</td>\n",
       "      <td>3545</td>\n",
       "      <td>71</td>\n",
       "      <td>पुरुष</td>\n",
       "      <td>132</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160014</td>\n",
       "      <td>172-सैक्टर 25</td>\n",
       "      <td>यु.आई.ई.टी. एडमिन. ब्लाक-2 ,सैक्टर 25 (कमरा.न.1)</td>\n",
       "      <td>608</td>\n",
       "      <td>516</td>\n",
       "      <td>0</td>\n",
       "      <td>1124</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1201</th>\n",
       "      <td>w0010172.pdf</td>\n",
       "      <td>167</td>\n",
       "      <td>PBA4513297</td>\n",
       "      <td>सूरज</td>\n",
       "      <td>रणधीर िसह</td>\n",
       "      <td>िपता</td>\n",
       "      <td>3599</td>\n",
       "      <td>39</td>\n",
       "      <td>पुरुष</td>\n",
       "      <td>166</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160014</td>\n",
       "      <td>172-सैक्टर 25</td>\n",
       "      <td>यु.आई.ई.टी. एडमिन. ब्लाक-2 ,सैक्टर 25 (कमरा.न.1)</td>\n",
       "      <td>608</td>\n",
       "      <td>516</td>\n",
       "      <td>0</td>\n",
       "      <td>1124</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1534</th>\n",
       "      <td>w0010172.pdf</td>\n",
       "      <td>512</td>\n",
       "      <td>PBA4786976</td>\n",
       "      <td>राजू</td>\n",
       "      <td>जगदीश</td>\n",
       "      <td>िपता</td>\n",
       "      <td>3509</td>\n",
       "      <td>30</td>\n",
       "      <td>पुरुष</td>\n",
       "      <td>511</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160014</td>\n",
       "      <td>172-सैक्टर 25</td>\n",
       "      <td>यु.आई.ई.टी. एडमिन. ब्लाक-2 ,सैक्टर 25 (कमरा.न.1)</td>\n",
       "      <td>608</td>\n",
       "      <td>516</td>\n",
       "      <td>0</td>\n",
       "      <td>1124</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1563</th>\n",
       "      <td>w0010172.pdf</td>\n",
       "      <td>541</td>\n",
       "      <td>PBA7557408</td>\n",
       "      <td>सूरज प्रकाश</td>\n",
       "      <td>िशव चरण</td>\n",
       "      <td>िपता</td>\n",
       "      <td>3524</td>\n",
       "      <td>53</td>\n",
       "      <td>पुरुष</td>\n",
       "      <td>540</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160014</td>\n",
       "      <td>172-सैक्टर 25</td>\n",
       "      <td>यु.आई.ई.टी. एडमिन. ब्लाक-2 ,सैक्टर 25 (कमरा.न.1)</td>\n",
       "      <td>608</td>\n",
       "      <td>516</td>\n",
       "      <td>0</td>\n",
       "      <td>1124</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24471</th>\n",
       "      <td>w0010181.pdf</td>\n",
       "      <td>92</td>\n",
       "      <td>PBA8166308</td>\n",
       "      <td>खुषनुमा रानी</td>\n",
       "      <td>मोहम्मद. मोबीन</td>\n",
       "      <td>पित</td>\n",
       "      <td>18</td>\n",
       "      <td>33</td>\n",
       "      <td>मिहला</td>\n",
       "      <td>91</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160026</td>\n",
       "      <td>181-सैक्टर 26</td>\n",
       "      <td>कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...</td>\n",
       "      <td>706</td>\n",
       "      <td>528</td>\n",
       "      <td>0</td>\n",
       "      <td>1234</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24605</th>\n",
       "      <td>w0010181.pdf</td>\n",
       "      <td>232</td>\n",
       "      <td>AXN2935229</td>\n",
       "      <td>राजू</td>\n",
       "      <td>रािजदर</td>\n",
       "      <td>िपता</td>\n",
       "      <td>38</td>\n",
       "      <td>21</td>\n",
       "      <td>पुरुष</td>\n",
       "      <td>231</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160026</td>\n",
       "      <td>181-सैक्टर 26</td>\n",
       "      <td>कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...</td>\n",
       "      <td>706</td>\n",
       "      <td>528</td>\n",
       "      <td>0</td>\n",
       "      <td>1234</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24696</th>\n",
       "      <td>w0010181.pdf</td>\n",
       "      <td>325</td>\n",
       "      <td>PBA2713287</td>\n",
       "      <td>सुनीता</td>\n",
       "      <td>मु�ा िसह</td>\n",
       "      <td>पित</td>\n",
       "      <td>51बी</td>\n",
       "      <td>36</td>\n",
       "      <td>मिहला</td>\n",
       "      <td>324</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160026</td>\n",
       "      <td>181-सैक्टर 26</td>\n",
       "      <td>कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...</td>\n",
       "      <td>706</td>\n",
       "      <td>528</td>\n",
       "      <td>0</td>\n",
       "      <td>1234</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24985</th>\n",
       "      <td>w0010181.pdf</td>\n",
       "      <td>625</td>\n",
       "      <td>AXN2383297</td>\n",
       "      <td>सुनीता</td>\n",
       "      <td>भूप िसह</td>\n",
       "      <td>पित</td>\n",
       "      <td>98</td>\n",
       "      <td>29</td>\n",
       "      <td>मिहला</td>\n",
       "      <td>623</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160026</td>\n",
       "      <td>181-सैक्टर 26</td>\n",
       "      <td>कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...</td>\n",
       "      <td>706</td>\n",
       "      <td>528</td>\n",
       "      <td>0</td>\n",
       "      <td>1234</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25356</th>\n",
       "      <td>w0010181.pdf</td>\n",
       "      <td>1017</td>\n",
       "      <td>PBA2715928</td>\n",
       "      <td>हीरा</td>\n",
       "      <td>नािगया</td>\n",
       "      <td>पित</td>\n",
       "      <td>161</td>\n",
       "      <td>33</td>\n",
       "      <td>मिहला</td>\n",
       "      <td>1015</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>चण्डीगढ़</td>\n",
       "      <td>160026</td>\n",
       "      <td>181-सैक्टर 26</td>\n",
       "      <td>कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...</td>\n",
       "      <td>706</td>\n",
       "      <td>528</td>\n",
       "      <td>0</td>\n",
       "      <td>1234</td>\n",
       "      <td>original</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>75 rows × 36 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         filename_x number_x          id elector_name_x  \\\n",
       "646    w0010309.pdf      685  AXN1252063     गगनदीप कौर   \n",
       "1167   w0010172.pdf      133  PBA6082507        सगा राम   \n",
       "1201   w0010172.pdf      167  PBA4513297           सूरज   \n",
       "1534   w0010172.pdf      512  PBA4786976           राजू   \n",
       "1563   w0010172.pdf      541  PBA7557408    सूरज प्रकाश   \n",
       "...             ...      ...         ...            ...   \n",
       "24471  w0010181.pdf       92  PBA8166308   खुषनुमा रानी   \n",
       "24605  w0010181.pdf      232  AXN2935229           राजू   \n",
       "24696  w0010181.pdf      325  PBA2713287         सुनीता   \n",
       "24985  w0010181.pdf      625  AXN2383297         सुनीता   \n",
       "25356  w0010181.pdf     1017  PBA2715928           हीरा   \n",
       "\n",
       "      father_or_husband_name_x relationship_x house_no_x age_x  sex_x  \\\n",
       "646                  तरसेम िसह           िपता        175    25  मिहला   \n",
       "1167                  कालु राम           िपता       3545    71  पुरुष   \n",
       "1201                 रणधीर िसह           िपता       3599    39  पुरुष   \n",
       "1534                     जगदीश           िपता       3509    30  पुरुष   \n",
       "1563                   िशव चरण           िपता       3524    53  पुरुष   \n",
       "...                        ...            ...        ...   ...    ...   \n",
       "24471           मोहम्मद. मोबीन            पित         18    33  मिहला   \n",
       "24605                   रािजदर           िपता         38    21  पुरुष   \n",
       "24696                 मु�ा िसह            पित       51बी    36  मिहला   \n",
       "24985                  भूप िसह            पित         98    29  मिहला   \n",
       "25356                   नािगया            पित        161    33  मिहला   \n",
       "\n",
       "       Unnamed: 0  ...  revenue_division  district pin_code  \\\n",
       "646           683  ...                 0  चण्डीगढ़   160047   \n",
       "1167          132  ...                 0  चण्डीगढ़   160014   \n",
       "1201          166  ...                 0  चण्डीगढ़   160014   \n",
       "1534          511  ...                 0  चण्डीगढ़   160014   \n",
       "1563          540  ...                 0  चण्डीगढ़   160014   \n",
       "...           ...  ...               ...       ...      ...   \n",
       "24471          91  ...                 0  चण्डीगढ़   160026   \n",
       "24605         231  ...                 0  चण्डीगढ़   160026   \n",
       "24696         324  ...                 0  चण्डीगढ़   160026   \n",
       "24985         623  ...                 0  चण्डीगढ़   160026   \n",
       "25356        1015  ...                 0  चण्डीगढ़   160026   \n",
       "\n",
       "      polling_station_name                            polling_station_address  \\\n",
       "646          309-सैक्टर 44   राजकीय माडल सीनियर सकैंडरी स्कूल, सैक्टर 44बी...   \n",
       "1167         172-सैक्टर 25   यु.आई.ई.टी. एडमिन. ब्लाक-2 ,सैक्टर 25 (कमरा.न.1)   \n",
       "1201         172-सैक्टर 25   यु.आई.ई.टी. एडमिन. ब्लाक-2 ,सैक्टर 25 (कमरा.न.1)   \n",
       "1534         172-सैक्टर 25   यु.आई.ई.टी. एडमिन. ब्लाक-2 ,सैक्टर 25 (कमरा.न.1)   \n",
       "1563         172-सैक्टर 25   यु.आई.ई.टी. एडमिन. ब्लाक-2 ,सैक्टर 25 (कमरा.न.1)   \n",
       "...                    ...                                                ...   \n",
       "24471        181-सैक्टर 26   कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...   \n",
       "24605        181-सैक्टर 26   कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...   \n",
       "24696        181-सैक्टर 26   कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...   \n",
       "24985        181-सैक्टर 26   कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...   \n",
       "25356        181-सैक्टर 26   कम्पोजिट आंगनवाड़ी सैंटर, बापू धाम कालोनी, सै...   \n",
       "\n",
       "       net_electors_male net_electors_female net_electors_third_gender  \\\n",
       "646                  569                 548                         0   \n",
       "1167                 608                 516                         0   \n",
       "1201                 608                 516                         0   \n",
       "1534                 608                 516                         0   \n",
       "1563                 608                 516                         0   \n",
       "...                  ...                 ...                       ...   \n",
       "24471                706                 528                         0   \n",
       "24605                706                 528                         0   \n",
       "24696                706                 528                         0   \n",
       "24985                706                 528                         0   \n",
       "25356                706                 528                         0   \n",
       "\n",
       "       net_electors_total  original_or_amendment  \n",
       "646                  1117               original  \n",
       "1167                 1124               original  \n",
       "1201                 1124               original  \n",
       "1534                 1124               original  \n",
       "1563                 1124               original  \n",
       "...                   ...                    ...  \n",
       "24471                1234               original  \n",
       "24605                1234               original  \n",
       "24696                1234               original  \n",
       "24985                1234               original  \n",
       "25356                1234               original  \n",
       "\n",
       "[75 rows x 36 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3[df3.elector_name_x==df3.elector_name_y]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "df3.to_csv('/tmp/chandigarh_merged.csv', index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}