scripts/himachal-tabula-py.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import re\n",
    "from glob import glob\n",
    "import pandas as pd\n",
    "import tabula"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"\\nOrder\\nHouse No.\\nVoter's name\\nRelations\\nRelative name\\nGender\\nAge\\nidentity card\\nPhoto\\n\""
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Columns\n",
    "\"\"\"\n",
    "क्रम\n",
    "मकान न.\n",
    "मतदाता का नाम\n",
    "सम्बन्ध\n",
    "सम्बन्धी का नाम\n",
    "लिंग\n",
    "आयु\n",
    "पहचान पत्र\n",
    "फोटो\n",
    "\"\"\"\n",
    "\"\"\"\n",
    "Order\n",
    "House No.\n",
    "Voter's name\n",
    "Relations\n",
    "Relative name\n",
    "Gender\n",
    "Age\n",
    "identity card\n",
    "Photo\n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "A0560059.pdf 4 , शमला (अ.जा.)\n",
      "A0560059.pdf 1 801 410 410 0 391 391 0 0 0 0 801 801 0\n",
      "A0560059.pdf 56 , नाहन (सामा(य) भाग स.या\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9.0\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9.0\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9.0\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9.0\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9.0\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9.0\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0560059.pdf 593 23 NCH0273441 फोटो उपल!ध\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9.0\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9.0\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0560059.pdf 59 , बमा-पापड़ी-1\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0560059.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0560059.pdf 56 , नाहन  (सामाCय)\n",
      "A0370091.pdf 1 940 452 452 0 488 488 0 0 0 0 940 940 0\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 91 , पटनौण\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0370091.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0330058.pdf 1 295 145 145 0 150 150 0 0 0 0 295 295 0\n",
      "A0330058.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330058.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330058.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330058.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330058.pdf 1 2 3 4 5 6 7.0 8 9.0\n",
      "A0330058.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330058.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330058.pdf 58 , भलेड\n",
      "A0330058.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330058.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0190001.pdf 1 717 383 383 0 334 334 0 0 0 0 717 717 0\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 108 23 लख राम अ य सोमा देवी पु ष 66 NVF0087585 फोटो उपल ध\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 421 26 पनी चद अ य चोधरी पु ष 68 CBN0707273 फोटो उपल ध\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 , डाढ़-1\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190001.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0130069.pdf 1 579 250 250 0 329 329 0 0 0 0 579 579 0\n",
      "A0130069.pdf 13 , जयिसहंपुर (अ.जा.) भाग सख्या\n",
      "A0130069.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130069.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130069.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130069.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130069.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130069.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130069.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130069.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130069.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130069.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130069.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130069.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130069.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130069.pdf 69 , देह -1\n",
      "A0130069.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130069.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0630071.pdf 4 , िशमला (अ.जा.)\n",
      "A0630071.pdf 1 382 176 176 0 206 206 0 0 0 0 382 382 0\n",
      "A0630071.pdf 63 , िशमला (सामा ) भाग सख्या\n",
      "A0630071.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0630071.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0630071.pdf 1 2 3 4 5 6 7.0 8 9.0\n",
      "A0630071.pdf 1 2 3 4 5 6 7.0 8 9.0\n",
      "A0630071.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0630071.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0630071.pdf 1 2 3 4 5 6 7.0 8 9.0\n",
      "A0630071.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0630071.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0630071.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0630071.pdf 71 , अ र संजौली चौक\n",
      "A0630071.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0630071.pdf 391 िस टर िनविदता गवनमट निसचेतना चतरा टा िपता िनहाल च द चतरा टा म िहला 19 YEJ0308338 फोटो उपल ध\n",
      "A0630071.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0630071.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0630071.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0390025.pdf 1 1181 596 596 0 585 585 0 0 0 0 1181 1181 0\n",
      "A0390025.pdf 25 , रा.व.मा.पा.भोटा , भोटा\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390025.pdf 25 , भोटा\n",
      "A0390025.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0390025.pdf 1 भोटा वाड न. 1\n",
      "A0390025.pdf 1182 िपता अशोक कुमार मिहला UPO0271007 फोटो उपल ध\n",
      "A0390025.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0390025.pdf 39 , बड़सर (सामा य)\n",
      "A0520033.pdf 1 588 289 289 0 299 299 0 0 0 0 588 588 0\n",
      "A0520033.pdf 52 , दनू (सामा य) भाग सख्या\n",
      "A0520033.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0520033.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0520033.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0520033.pdf 1 2 3 4 5 6 7.0 8 9.0\n",
      "A0520033.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0520033.pdf 1 2 3 4 5 6 7.0 8 9.0\n",
      "A0520033.pdf 311 36-/-8-----------------------------------त--न-- ु-व--ाि-ल---य़-ा- - िवलोिपत -------ि-प--त--ा------र--मे--श-- -व--ा-ि-ल--य़--ा -- --------म---िह--ल--ा--------2--4----U--N--Y--0-1--7-2--1--2-2---------फ---ोट--ो-उ--प--ल- ध\n",
      "A0520033.pdf 1 2 3 4 5 6 7.0 8 9.0\n",
      "A0520033.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0520033.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0520033.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0520033.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0520033.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0520033.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0520033.pdf 33 , आरला\n",
      "A0520033.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0570100.pdf 4 , िशमला (अ.जा.)\n",
      "A0570100.pdf 1 895 452 452 0 443 443 0 0 0 0 895 895 0\n",
      "A0570100.pdf 57 , ी रेणुका जी (अ.जा.) भाग स या\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 34 6क र तु अ य चमै सहं  म हला 20.0 SER0264564 फोटो उपल\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 50 12 गीता अ य माठो राम  म हला 18.0 SER0264689 फोटो उपल\n",
      "A0570100.pdf 54 13 ो मला अ य सीता राम  म हला 25.0 SER0264663 फोटो उपल\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 172 21/4क सजीत अ य बाती राम  पु ष 23.0 SER0264515 फोटो उपल\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 193 23 ख गोकुल च द  अ य जगं बहादरू  प ष 52.0 SER0195347 फोटो उपल\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 426 85/1 म लता परमार प त उदय पाल सहं परमारम  हला 59.0 SER0056663 फोटो उपल\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 100 , ददा -2\n",
      "A0570100.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0570100.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0570100.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0570100.pdf 57 , ी रेणुका जी  (अ.जा.)\n",
      "A0390104.pdf 1 954 453 453 0 501 501 0 0 0 0 954 954 0\n",
      "A0390104.pdf 04 , रा.मा.पा.बड़ा मां , बड़ा मां\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 722 12(3) अमर िसंह िपता बिी राम परुूष -13.0 MLP0485599 फोटो उपलब्ध\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0390104.pdf 104 , बड़ा मां\n",
      "A0390104.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0390104.pdf 957 अिमता कुमारी पित रजनीश कुमार 26 UPO0280438 फोटो उपल ध\n",
      "A0390104.pdf 961 163/ िश पा कुमारी िकशोरी लाल मिहला 18 UPO0280479 फोटो उपल ध\n",
      "A0390104.pdf 962 203 िप्रयंका पित िवनय कुमार मिहला UPO0280487\n",
      "A0390104.pdf 963 163 अजना देवी पित कमल देव 21 UPO0280495 फोटो उपल ध\n",
      "A0390104.pdf 965 178 रोिहणी कुलब त िसहं मिहला 18 UPO0280511 फोटो उपल ध\n",
      "A0390104.pdf 966 140/3 मनीता कुमारी पित किपल देव मिहला UPO0280529\n",
      "A0390104.pdf 967 पनम कुमारी अ वनी कुमार मिहला 29 UPO0280537 फोटो उपल ध\n",
      "A0390104.pdf 959 12 अजना कुमारी िपता मिहला UPO0280453 फोटो उपल ध\n",
      "A0390104.pdf 974 21 िपता मिहला UPO0280602 फोटो उपल ध\n",
      "A0390104.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0390104.pdf 39 , बड़सर (सामा य)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "A0220055.pdf 1 889 443 443 0 446 446 0 0 0 0 889 889 0\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 839 159/1 रीना अ य नीरज  मिहला 32.0 TKE0141291 फोटो उपल ध\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 55 , कटरांई-2\n",
      "A0220055.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0220055.pdf 289 20/ख SHIVANGI SHARMA  िपता RAJEEV SHARMA म िहला 22.0 TKE0185116 फोटो उपल ध\n",
      "A0220055.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0540076.pdf 4 , िशमला (अ.जा.)\n",
      "A0540076.pdf 1 599 315 315 0 284 284 0 0 0 0 599 599 0\n",
      "A0540076.pdf 54 , कसौली (अ.जा.) भाग सख्या\n",
      "A0540076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0540076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0540076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0540076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0540076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0540076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0540076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0540076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0540076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0540076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0540076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0540076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0540076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0540076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0540076.pdf 76 , कोटी\n",
      "A0540076.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0540076.pdf 54 , कसौली (अ.जा.)\n",
      "A0160085.pdf 1 829 418 418 0 411 411 0 0 0 0 829 829 0\n",
      "A0160085.pdf 16 , कागड़ा (सामा य) भाग सख्या\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9.0\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 85 , दौलतपुर-1\n",
      "A0160085.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0160085.pdf 450 442.0 892.0\n",
      "A0160085.pdf 2 िनरर अ तन - 2017 0\n",
      "A0620054.pdf 1 348 188 188 0 160 160 0 0 0 0 348 348 0\n",
      "A0620054.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0620054.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0620054.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0620054.pdf 135 - अशोक िनवास शशी कला चौहान पित अशोक प्रकाश चौहान म िहला 35 IPP0001016 फोटो उपल ध\n",
      "A0620054.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0620054.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0620054.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0620054.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0620054.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0620054.pdf 54 , सांगटी-4\n",
      "A0620054.pdf 62 , कस पटी (सामा य)\n",
      "A0240015.pdf 1 590 288 288 0 302 302 0 0 0 0 590 590 0\n",
      "A0240015.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0240015.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0240015.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0240015.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0240015.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0240015.pdf 1 2 3 4 5 6 7.0 8 9.0\n",
      "A0240015.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0240015.pdf 1 2 3 4 5 6 7.0 8 9.0\n",
      "A0240015.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0240015.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0240015.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0240015.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0240015.pdf 15 , नरैश\n",
      "A0240015.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0240015.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0240015.pdf 24 , ब जार (सामा य)\n",
      "A0330078.pdf 1 233 106 106 0 127 127 0 0 0 0 233 233 0\n",
      "A0330078.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330078.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330078.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330078.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330078.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330078.pdf 78 , लोअर भगवाहन-।\n",
      "A0330078.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0410028.pdf 1 449 226 226 0 223 223 0 0 0 0 449 449 0\n",
      "A0410028.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0410028.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0410028.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0410028.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0410028.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0410028.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0410028.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0410028.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0410028.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0410028.pdf 28 , वार-2\n",
      "A0410028.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0410028.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 840 433 433 0 407 407 0 0 0 0 840 840 0\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0330085.pdf 85 , मगवाईं-।।\n",
      "A0330085.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 722 398 398 0 324 324 0 0 0 0 722 722 0\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0200104.pdf 104 , लोहारडी -1\n",
      "A0310019.pdf 3 4 05 6 .+ ∃ % & ∋ (\n",
      "A0310019.pdf 02 3\n",
      "A0310019.pdf 4 05 6 .+\n",
      "A0310019.pdf 905 : 9 ≅ )\n",
      "A0310019.pdf 905 6 < , : =0>+ 905 ? , 6+ ; < + Ε Α 905\n",
      "A0310019.pdf 7 θ\n",
      "A0310019.pdf 4 Ν ;.+ +Κ + Ο ≅ 7\n",
      "A0310019.pdf 3 <:7 3 7 Θ Ρ Θ Ρ Π Θ Ρ Θ Ρ ++ Θ Ρ Θ Ρ Θ Ρ Σ+ Θ Ρ Π +\n",
      "A0310019.pdf 2 !∀ 345 ∃6\n",
      "A0310019.pdf 9 Σ\n",
      "A0310019.pdf 7 θ\n",
      "?0 5 ≅0Φ∃ Μ7. )\n",
      "−56 5. 35;5) =2#4\n",
      "A0310019.pdf 4 ! &∋()#∃\n",
      "4 ! &∋()#∃df 2\n",
      "A0310019.pdf 2 + , (. /\n",
      "A0310019.pdf 9 !∀# ∃ ) ∗+ ) ∃, −\n",
      "A0310019.pdf 32 ( 0∋ + , (.\n",
      "A0310019.pdf 9 5: 1\n",
      "A0310019.pdf 61 9 % & +, - 12 :3\n",
      "A0310019.pdf 5 !\"# + ( )* ( +, -\n",
      "A0130031.pdf 1 669 346 346 0 323 323 0 0 0 0 669 669 0\n",
      "A0130031.pdf 13 , जयिसहंपुर (अ.जा.) भाग सख्या\n",
      "A0130031.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130031.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130031.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130031.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130031.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130031.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130031.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130031.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130031.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130031.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130031.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130031.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130031.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130031.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130031.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0130031.pdf 31 , धार द्रमुका कलां\n",
      "A0130031.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 , कांगड़ा (सामा )\n",
      "A0190058.pdf 1 990 499 499 0 491 491 0 0 0 0 990 990 0\n",
      "A0190058.pdf 19 , पालमपुर (सामा ) भाग सख्या\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 58 , टा ा\n",
      "A0190058.pdf 1 2 3 4 5 6 7 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0190058.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 1 758 388 388 0 370 370 0 0 0 0 758 758 0\n",
      "A0480077.pdf 77 , राजकीय महािव ालय िबलासपुर , कोस रया\n",
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0480077.pdf 77 , कोस रया\n",
      "A0480077.pdf 403 391.0 794.0\n",
      "A0660038.pdf 1 389 197 197 0 192 192 0 0 0 0 389 389 0\n",
      "A0660038.pdf 1 2 3 4 5 6 7.0 8 9.0\n",
      "A0660038.pdf 1 2 3 4 5 6 7.0 8 9.0\n",
      "A0660038.pdf 1 2 3 4 5 6 7.0 8 9.0\n",
      "A0660038.pdf 109 23/1 शिश कला अ य पे्रम िसहं  मिहला 26.0 SZS0204479 फोटो उपल ध\n",
      "A0660038.pdf 117 28/1 प्रवीणा देवी अ य ऊषा देवी  मिहला 28.0 SZS0204503 फोटो उपल ध\n",
      "A0660038.pdf 1 2 3 4 5 6 7.0 8 9.0\n",
      "A0660038.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0660038.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0660038.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0660038.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0660038.pdf 1 2 3 4 5 6 7.0 8 9.0\n",
      "A0660038.pdf 38 , यू थल\n",
      "A0050076.pdf 1 729 385 385 0 344 344 0 0 0 0 729 729 0\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 76 , िटकरी\n",
      "A0050076.pdf 5 , भ टयात  (सामा य) भाग स या\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n",
      "A0050076.pdf 1 2 3 4 5 6 7.0 8 9\n"
     ]
    }
   ],
   "source": [
    "rows = []\n",
    "for fn in glob('../../parse_in_rolls/data/himachal/*.pdf'):\n",
    "    dfs = tabula.read_pdf(fn, pages='all', lattice = False, silent=True)\n",
    "    for i, df in enumerate(dfs):\n",
    "        for j, r in df.iterrows():\n",
    "            txt = ' '.join(r.dropna().astype(str))\n",
    "            m = re.match(r'(?:O\\s)?(\\d*)\\s([कखगॠख़AB\\s\\d\\/\\(\\)\\-\\,]*)\\s?(.*)\\s?(िपता|पित|प.त|.पता|माता)\\s(.*)\\s?(प.{1,3}ष|पु.ष|म.हला|मिहला)\\s([\\d\\.]*)\\s([\\dA-Z\\/]*)\\s?(.*)$', txt)\n",
    "            if m:\n",
    "                pass\n",
    "                #print(os.path.basename(fn), m.group(1), '|', m.group(2), '|', m.group(3), '|', m.group(4), '|', m.group(5), '|', m.group(6), '|', m.group(7), '|', m.group(8), '|', m.group(9))\n",
    "                data = {'filename': os.path.basename(fn),\n",
    "                        'number': m.group(1),\n",
    "                        'id': m.group(8),\n",
    "                        'elector_name': m.group(3),\n",
    "                        'father_or_husband_name': m.group(5),\n",
    "                        'relationship': m.group(4),\n",
    "                        'house_no': m.group(2),\n",
    "                        'age': m.group(7),\n",
    "                        'sex': m.group(6),\n",
    "                       }\n",
    "                rows.append(data)\n",
    "            else:\n",
    "                m2 = re.match(r'(?:O\\s)?(\\d*)\\s(.*)$', txt)\n",
    "                if m2:\n",
    "                    print(os.path.basename(fn), txt)\n",
    "    #break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>A0560059.pdf</td>\n",
       "      <td>1</td>\n",
       "      <td>HP/01/019/111312</td>\n",
       "      <td>राम Aयार&lt;</td>\n",
       "      <td>राम च(P</td>\n",
       "      <td>प.त</td>\n",
       "      <td>1/1</td>\n",
       "      <td>44</td>\n",
       "      <td>मSहला</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A0560059.pdf</td>\n",
       "      <td>2</td>\n",
       "      <td>NCH0159657</td>\n",
       "      <td>धनवीर सहं</td>\n",
       "      <td>राम च(P</td>\n",
       "      <td>+पता</td>\n",
       "      <td>1/1</td>\n",
       "      <td>25</td>\n",
       "      <td>पु?ष</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A0560059.pdf</td>\n",
       "      <td>3</td>\n",
       "      <td>HP/01/019/111211</td>\n",
       "      <td>जगद&lt;श च(द</td>\n",
       "      <td>तारा च(द</td>\n",
       "      <td>+पता</td>\n",
       "      <td>2</td>\n",
       "      <td>52</td>\n",
       "      <td>पु?ष</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A0560059.pdf</td>\n",
       "      <td>4</td>\n",
       "      <td>HP/01/019/111218</td>\n",
       "      <td>सYया देवी</td>\n",
       "      <td>जगद&lt;श च(द</td>\n",
       "      <td>प.त</td>\n",
       "      <td>2</td>\n",
       "      <td>48</td>\n",
       "      <td>मSहला</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A0560059.pdf</td>\n",
       "      <td>6</td>\n",
       "      <td>HP/01/019/111313</td>\n",
       "      <td>ु(दन सहं</td>\n",
       "      <td>तारा च(द</td>\n",
       "      <td>+पता</td>\n",
       "      <td>3/1 क</td>\n",
       "      <td>62</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>16522</th>\n",
       "      <td>A0050076.pdf</td>\n",
       "      <td>733</td>\n",
       "      <td>TMT0306803</td>\n",
       "      <td>लता</td>\n",
       "      <td>राजेश  कुमार</td>\n",
       "      <td>प त</td>\n",
       "      <td>48</td>\n",
       "      <td>28.0</td>\n",
       "      <td>म हला</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16523</th>\n",
       "      <td>A0050076.pdf</td>\n",
       "      <td>734</td>\n",
       "      <td>TMT0306811</td>\n",
       "      <td>इि दरा  देवी</td>\n",
       "      <td>सजीव  कुमार</td>\n",
       "      <td>प त</td>\n",
       "      <td>42/2</td>\n",
       "      <td>21.0</td>\n",
       "      <td>म हला</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16524</th>\n",
       "      <td>A0050076.pdf</td>\n",
       "      <td>735</td>\n",
       "      <td>TMT0306829</td>\n",
       "      <td>मनीला  कुमार</td>\n",
       "      <td>बलदेव  राज</td>\n",
       "      <td>प त</td>\n",
       "      <td>57/1</td>\n",
       "      <td>26.0</td>\n",
       "      <td>म हला</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16525</th>\n",
       "      <td>A0050076.pdf</td>\n",
       "      <td>736</td>\n",
       "      <td>TMT0306837</td>\n",
       "      <td>वशाल  कुमार</td>\n",
       "      <td>रणजीत  सहं</td>\n",
       "      <td>पता</td>\n",
       "      <td>94/1</td>\n",
       "      <td>18.0</td>\n",
       "      <td>प ष</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16526</th>\n",
       "      <td>A0050076.pdf</td>\n",
       "      <td>737</td>\n",
       "      <td>TMT0306852</td>\n",
       "      <td>सरेखा  देवी</td>\n",
       "      <td>वचन  सहं</td>\n",
       "      <td>पता</td>\n",
       "      <td>104/1</td>\n",
       "      <td>19.0</td>\n",
       "      <td>म हला</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>16527 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           filename number                id   elector_name  \\\n",
       "0      A0560059.pdf      1  HP/01/019/111312     राम Aयार<    \n",
       "1      A0560059.pdf      2        NCH0159657     धनवीर सहं    \n",
       "2      A0560059.pdf      3  HP/01/019/111211     जगद<श च(द    \n",
       "3      A0560059.pdf      4  HP/01/019/111218     सYया देवी    \n",
       "4      A0560059.pdf      6  HP/01/019/111313      ु(दन सहं    \n",
       "...             ...    ...               ...            ...   \n",
       "16522  A0050076.pdf    733        TMT0306803           लता    \n",
       "16523  A0050076.pdf    734        TMT0306811  इि दरा  देवी    \n",
       "16524  A0050076.pdf    735        TMT0306829  मनीला  कुमार    \n",
       "16525  A0050076.pdf    736        TMT0306837    वशाल  कुमार   \n",
       "16526  A0050076.pdf    737        TMT0306852    सरेखा  देवी   \n",
       "\n",
       "      father_or_husband_name relationship house_no   age    sex  \n",
       "0                   राम च(P           प.त     1/1     44  मSहला  \n",
       "1                   राम च(P          +पता     1/1     25   पु?ष  \n",
       "2                  तारा च(द          +पता       2     52   पु?ष  \n",
       "3                 जगद<श च(द           प.त       2     48  मSहला  \n",
       "4                  तारा च(द          +पता    3/1 क    62   पु?ष  \n",
       "...                      ...          ...      ...   ...    ...  \n",
       "16522          राजेश  कुमार           प त      48   28.0  म हला  \n",
       "16523           सजीव  कुमार           प त    42/2   21.0  म हला  \n",
       "16524            बलदेव  राज           प त    57/1   26.0  म हला  \n",
       "16525            रणजीत  सहं           पता    94/1   18.0    प ष  \n",
       "16526              वचन  सहं           पता   104/1   19.0  म हला  \n",
       "\n",
       "[16527 rows x 9 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(rows)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['प.त', '+पता', 'माता', 'प त', ' पता', 'िपता', 'पित'], dtype=object)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.relationship.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['मSहला', 'पु?ष', 'मQहला', 'प4ुष', 'पु4ष', 'पु ष', 'मिहला', 'प ष',\n",
       "       'परुूष', 'परूष', 'म हला', 'पु  ष', 'पुी ष'], dtype=object)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sex.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['44', '25', '52', '48', '62', '57', '34', '31', '30', '29', '26',\n",
       "       '24', '36', '33', '28', '23', '43', '42', '41', '35', '45', '47',\n",
       "       '50', '38', '82', '55', '51', '27', '67', '46', '58', '54', '49',\n",
       "       '77', '37', '19', '70', '32', '72', '40', '60', '56', '39', '22',\n",
       "       '61', '64', '68', '20', '65', '71', '21', '66', '59', '74', '87',\n",
       "       '18', '69', '53', '79', '91', '63', '73', '76', '80', '81', '75',\n",
       "       '85', '84', '78', '94', '86', '93', '80.0', '51.0', '49.0', '48.0',\n",
       "       '47.0', '46.0', '20.0', '21.0', '61.0', '53.0', '34.0', '25.0',\n",
       "       '70.0', '41.0', '59.0', '58.0', '24.0', '56.0', '36.0', '27.0',\n",
       "       '54.0', '26.0', '23.0', '60.0', '57.0', '39.0', '32.0', '29.0',\n",
       "       '52.0', '28.0', '50.0', '64.0', '43.0', '37.0', '38.0', '78.0',\n",
       "       '22.0', '91.0', '35.0', '33.0', '31.0', '18.0', '44.0', '68.0',\n",
       "       '83.0', '55.0', '30.0', '63.0', '42.0', '45.0', '73.0', '72.0',\n",
       "       '40.0', '81.0', '75.0', '19.0', '67.0', '88.0', '62.0', '71.0',\n",
       "       '79.0', '65.0', '92', '97.0', '66.0', '77.0', '74.0', '90.0',\n",
       "       '76.0', '82.0', '84.0', '116.0', '86.0', '87.0', '85.0', '95.0',\n",
       "       '69.0', '89.0', '17.0', '96.0', '94.0', '93.0', '98.0', '92.0',\n",
       "       '107.0', '116'], dtype=object)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.age.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('himachal.csv', index_label='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>mandal</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>ol</td>\n",
       "      <td>HP/03/050/156295</td>\n",
       "      <td>केसरो देवी</td>\n",
       "      <td>राम चन्द</td>\n",
       "      <td>Husband</td>\n",
       "      <td>2(1)</td>\n",
       "      <td>68</td>\n",
       "      <td>महिला</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>LTK0569285</td>\n",
       "      <td>लेख राज</td>\n",
       "      <td>राम चन्द</td>\n",
       "      <td>Father</td>\n",
       "      <td>2(1)</td>\n",
       "      <td>47</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>[1100352294</td>\n",
       "      <td>तिलक राज</td>\n",
       "      <td>राम चन्द</td>\n",
       "      <td>Father</td>\n",
       "      <td>2(1)</td>\n",
       "      <td>43</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>दर्शना देवी</td>\n",
       "      <td>मोती राम</td>\n",
       "      <td>Husband</td>\n",
       "      <td>2(2)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>महिला</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>LTK0569673</td>\n",
       "      <td>पूजा देवी</td>\n",
       "      <td>लेख राज</td>\n",
       "      <td>Husband</td>\n",
       "      <td>2/1</td>\n",
       "      <td>35</td>\n",
       "      <td>महिला</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</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>16701</th>\n",
       "      <td>884</td>\n",
       "      <td>665</td>\n",
       "      <td>TKE0062240</td>\n",
       "      <td>पराकल कृमार</td>\n",
       "      <td>शमशेर सिंह</td>\n",
       "      <td>Father</td>\n",
       "      <td>177</td>\n",
       "      <td>28.0</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16702</th>\n",
       "      <td>885</td>\n",
       "      <td>886</td>\n",
       "      <td>MGJ1149475</td>\n",
       "      <td>कमला देवी</td>\n",
       "      <td>मूृनि यप्पा</td>\n",
       "      <td>Husband</td>\n",
       "      <td>178</td>\n",
       "      <td>44.0</td>\n",
       "      <td>महिला</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16703</th>\n",
       "      <td>886</td>\n",
       "      <td>667</td>\n",
       "      <td>TKE0121905</td>\n",
       "      <td>रवि कुमार</td>\n",
       "      <td>मृनियप्पा</td>\n",
       "      <td>Father</td>\n",
       "      <td>178</td>\n",
       "      <td>24.0</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16704</th>\n",
       "      <td>887</td>\n",
       "      <td>888</td>\n",
       "      <td>TKE0159467</td>\n",
       "      <td>मंजला</td>\n",
       "      <td>मृनियपा</td>\n",
       "      <td>Father</td>\n",
       "      <td>178</td>\n",
       "      <td>23.0</td>\n",
       "      <td>महिला</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16705</th>\n",
       "      <td>888</td>\n",
       "      <td>569</td>\n",
       "      <td>TKEO206102</td>\n",
       "      <td>आकृति</td>\n",
       "      <td>शशिकान्त</td>\n",
       "      <td>Father</td>\n",
       "      <td>154/1</td>\n",
       "      <td>21.0</td>\n",
       "      <td>महिला</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>16706 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0 number                id  elector_name  \\\n",
       "0               0     ol  HP/03/050/156295   केसरो देवी    \n",
       "1               1      2        LTK0569285      लेख राज    \n",
       "2               2      3       [1100352294     तिलक राज    \n",
       "3               3      4               NaN  दर्शना देवी    \n",
       "4               4      5        LTK0569673    पूजा देवी    \n",
       "...           ...    ...               ...           ...   \n",
       "16701         884    665        TKE0062240  पराकल कृमार    \n",
       "16702         885    886        MGJ1149475    कमला देवी    \n",
       "16703         886    667        TKE0121905    रवि कुमार    \n",
       "16704         887    888        TKE0159467        मंजला    \n",
       "16705         888    569        TKEO206102        आकृति    \n",
       "\n",
       "      father_or_husband_name relationship house_no   age    sex  \\\n",
       "0                  राम चन्द       Husband     2(1)    68  महिला   \n",
       "1                  राम चन्द        Father     2(1)    47  पुरूष   \n",
       "2                  राम चन्द        Father     2(1)    43  पुरूष   \n",
       "3                  मोती राम       Husband     2(2)   NaN  महिला   \n",
       "4                   लेख राज       Husband      2/1    35  महिला   \n",
       "...                      ...          ...      ...   ...    ...   \n",
       "16701            शमशेर सिंह        Father      177  28.0  पुरूष   \n",
       "16702           मूृनि यप्पा       Husband      178  44.0  महिला   \n",
       "16703             मृनियप्पा        Father      178  24.0  पुरूष   \n",
       "16704               मृनियपा        Father      178  23.0  महिला   \n",
       "16705              शशिकान्त        Father    154/1  21.0  महिला   \n",
       "\n",
       "                      ac_name  ...   mandal revenue_division  district  \\\n",
       "0      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "1      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "2      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "3      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "4      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "...                       ...  ...      ...              ...       ...   \n",
       "16701    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16702    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16703    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16704    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16705    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "\n",
       "      pin_code polling_station_name       polling_station_address  \\\n",
       "0       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "1       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "2       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "3       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "4       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "...        ...                  ...                           ...   \n",
       "16701   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16702   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16703   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16704   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16705   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "\n",
       "      net_electors_male net_electors_female net_electors_third_gender  \\\n",
       "0                   385                 344                         0   \n",
       "1                   385                 344                         0   \n",
       "2                   385                 344                         0   \n",
       "3                   385                 344                         0   \n",
       "4                   385                 344                         0   \n",
       "...                 ...                 ...                       ...   \n",
       "16701               443                 446                         0   \n",
       "16702               443                 446                         0   \n",
       "16703               443                 446                         0   \n",
       "16704               443                 446                         0   \n",
       "16705               443                 446                         0   \n",
       "\n",
       "      net_electors_total  \n",
       "0                    729  \n",
       "1                    729  \n",
       "2                    729  \n",
       "3                    729  \n",
       "4                    729  \n",
       "...                  ...  \n",
       "16701                889  \n",
       "16702                889  \n",
       "16703                889  \n",
       "16704                889  \n",
       "16705                889  \n",
       "\n",
       "[16706 rows x 27 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = pd.read_csv('../../parse_in_rolls/csvs/Himachal_final.csv')\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>mandal</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>ol</td>\n",
       "      <td>HP/03/050/156295</td>\n",
       "      <td>केसरो देवी</td>\n",
       "      <td>राम चन्द</td>\n",
       "      <td>Husband</td>\n",
       "      <td>2(1)</td>\n",
       "      <td>68</td>\n",
       "      <td>महिला</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>LTK0569285</td>\n",
       "      <td>लेख राज</td>\n",
       "      <td>राम चन्द</td>\n",
       "      <td>Father</td>\n",
       "      <td>2(1)</td>\n",
       "      <td>47</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>[1100352294</td>\n",
       "      <td>तिलक राज</td>\n",
       "      <td>राम चन्द</td>\n",
       "      <td>Father</td>\n",
       "      <td>2(1)</td>\n",
       "      <td>43</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>दर्शना देवी</td>\n",
       "      <td>मोती राम</td>\n",
       "      <td>Husband</td>\n",
       "      <td>2(2)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>महिला</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>LTK0569673</td>\n",
       "      <td>पूजा देवी</td>\n",
       "      <td>लेख राज</td>\n",
       "      <td>Husband</td>\n",
       "      <td>2/1</td>\n",
       "      <td>35</td>\n",
       "      <td>महिला</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</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>16701</th>\n",
       "      <td>884</td>\n",
       "      <td>665</td>\n",
       "      <td>TKE0062240</td>\n",
       "      <td>पराकल कृमार</td>\n",
       "      <td>शमशेर सिंह</td>\n",
       "      <td>Father</td>\n",
       "      <td>177</td>\n",
       "      <td>28.0</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16702</th>\n",
       "      <td>885</td>\n",
       "      <td>886</td>\n",
       "      <td>MGJ1149475</td>\n",
       "      <td>कमला देवी</td>\n",
       "      <td>मूृनि यप्पा</td>\n",
       "      <td>Husband</td>\n",
       "      <td>178</td>\n",
       "      <td>44.0</td>\n",
       "      <td>महिला</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16703</th>\n",
       "      <td>886</td>\n",
       "      <td>667</td>\n",
       "      <td>TKE0121905</td>\n",
       "      <td>रवि कुमार</td>\n",
       "      <td>मृनियप्पा</td>\n",
       "      <td>Father</td>\n",
       "      <td>178</td>\n",
       "      <td>24.0</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16704</th>\n",
       "      <td>887</td>\n",
       "      <td>888</td>\n",
       "      <td>TKE0159467</td>\n",
       "      <td>मंजला</td>\n",
       "      <td>मृनियपा</td>\n",
       "      <td>Father</td>\n",
       "      <td>178</td>\n",
       "      <td>23.0</td>\n",
       "      <td>महिला</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16705</th>\n",
       "      <td>888</td>\n",
       "      <td>569</td>\n",
       "      <td>TKEO206102</td>\n",
       "      <td>आकृति</td>\n",
       "      <td>शशिकान्त</td>\n",
       "      <td>Father</td>\n",
       "      <td>154/1</td>\n",
       "      <td>21.0</td>\n",
       "      <td>महिला</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>16706 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0 number                id  elector_name  \\\n",
       "0               0     ol  HP/03/050/156295   केसरो देवी    \n",
       "1               1      2        LTK0569285      लेख राज    \n",
       "2               2      3       [1100352294     तिलक राज    \n",
       "3               3      4               NaN  दर्शना देवी    \n",
       "4               4      5        LTK0569673    पूजा देवी    \n",
       "...           ...    ...               ...           ...   \n",
       "16701         884    665        TKE0062240  पराकल कृमार    \n",
       "16702         885    886        MGJ1149475    कमला देवी    \n",
       "16703         886    667        TKE0121905    रवि कुमार    \n",
       "16704         887    888        TKE0159467        मंजला    \n",
       "16705         888    569        TKEO206102        आकृति    \n",
       "\n",
       "      father_or_husband_name relationship house_no   age    sex  \\\n",
       "0                  राम चन्द       Husband     2(1)    68  महिला   \n",
       "1                  राम चन्द        Father     2(1)    47  पुरूष   \n",
       "2                  राम चन्द        Father     2(1)    43  पुरूष   \n",
       "3                  मोती राम       Husband     2(2)   NaN  महिला   \n",
       "4                   लेख राज       Husband      2/1    35  महिला   \n",
       "...                      ...          ...      ...   ...    ...   \n",
       "16701            शमशेर सिंह        Father      177  28.0  पुरूष   \n",
       "16702           मूृनि यप्पा       Husband      178  44.0  महिला   \n",
       "16703             मृनियप्पा        Father      178  24.0  पुरूष   \n",
       "16704               मृनियपा        Father      178  23.0  महिला   \n",
       "16705              शशिकान्त        Father    154/1  21.0  महिला   \n",
       "\n",
       "                      ac_name  ...   mandal revenue_division  district  \\\n",
       "0      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "1      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "2      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "3      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "4      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "...                       ...  ...      ...              ...       ...   \n",
       "16701    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16702    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16703    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16704    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16705    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "\n",
       "      pin_code polling_station_name       polling_station_address  \\\n",
       "0       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "1       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "2       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "3       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "4       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "...        ...                  ...                           ...   \n",
       "16701   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16702   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16703   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16704   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16705   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "\n",
       "      net_electors_male net_electors_female net_electors_third_gender  \\\n",
       "0                   385                 344                         0   \n",
       "1                   385                 344                         0   \n",
       "2                   385                 344                         0   \n",
       "3                   385                 344                         0   \n",
       "4                   385                 344                         0   \n",
       "...                 ...                 ...                       ...   \n",
       "16701               443                 446                         0   \n",
       "16702               443                 446                         0   \n",
       "16703               443                 446                         0   \n",
       "16704               443                 446                         0   \n",
       "16705               443                 446                         0   \n",
       "\n",
       "      net_electors_total  \n",
       "0                    729  \n",
       "1                    729  \n",
       "2                    729  \n",
       "3                    729  \n",
       "4                    729  \n",
       "...                  ...  \n",
       "16701                889  \n",
       "16702                889  \n",
       "16703                889  \n",
       "16704                889  \n",
       "16705                889  \n",
       "\n",
       "[16706 rows x 27 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.id = df2.id.str.strip()\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>mandal</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>ol</td>\n",
       "      <td>HP/03/050/156295</td>\n",
       "      <td>केसरो देवी</td>\n",
       "      <td>राम चन्द</td>\n",
       "      <td>Husband</td>\n",
       "      <td>2(1)</td>\n",
       "      <td>68</td>\n",
       "      <td>महिला</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>LTK0569285</td>\n",
       "      <td>लेख राज</td>\n",
       "      <td>राम चन्द</td>\n",
       "      <td>Father</td>\n",
       "      <td>2(1)</td>\n",
       "      <td>47</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>[1100352294</td>\n",
       "      <td>तिलक राज</td>\n",
       "      <td>राम चन्द</td>\n",
       "      <td>Father</td>\n",
       "      <td>2(1)</td>\n",
       "      <td>43</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>दर्शना देवी</td>\n",
       "      <td>मोती राम</td>\n",
       "      <td>Husband</td>\n",
       "      <td>2(2)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>महिला</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>LTK0569673</td>\n",
       "      <td>पूजा देवी</td>\n",
       "      <td>लेख राज</td>\n",
       "      <td>Husband</td>\n",
       "      <td>2/1</td>\n",
       "      <td>35</td>\n",
       "      <td>महिला</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</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>16701</th>\n",
       "      <td>884</td>\n",
       "      <td>665</td>\n",
       "      <td>TKE0062240</td>\n",
       "      <td>पराकल कृमार</td>\n",
       "      <td>शमशेर सिंह</td>\n",
       "      <td>Father</td>\n",
       "      <td>177</td>\n",
       "      <td>28.0</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16702</th>\n",
       "      <td>885</td>\n",
       "      <td>886</td>\n",
       "      <td>MGJ1149475</td>\n",
       "      <td>कमला देवी</td>\n",
       "      <td>मूृनि यप्पा</td>\n",
       "      <td>Husband</td>\n",
       "      <td>178</td>\n",
       "      <td>44.0</td>\n",
       "      <td>महिला</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16703</th>\n",
       "      <td>886</td>\n",
       "      <td>667</td>\n",
       "      <td>TKE0121905</td>\n",
       "      <td>रवि कुमार</td>\n",
       "      <td>मृनियप्पा</td>\n",
       "      <td>Father</td>\n",
       "      <td>178</td>\n",
       "      <td>24.0</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16704</th>\n",
       "      <td>887</td>\n",
       "      <td>888</td>\n",
       "      <td>TKE0159467</td>\n",
       "      <td>मंजला</td>\n",
       "      <td>मृनियपा</td>\n",
       "      <td>Father</td>\n",
       "      <td>178</td>\n",
       "      <td>23.0</td>\n",
       "      <td>महिला</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16705</th>\n",
       "      <td>888</td>\n",
       "      <td>569</td>\n",
       "      <td>TKEO206102</td>\n",
       "      <td>आकृति</td>\n",
       "      <td>शशिकान्त</td>\n",
       "      <td>Father</td>\n",
       "      <td>154/1</td>\n",
       "      <td>21.0</td>\n",
       "      <td>महिला</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>16706 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0 number                id elector_name  \\\n",
       "0               0     ol  HP/03/050/156295   केसरो देवी   \n",
       "1               1      2        LTK0569285      लेख राज   \n",
       "2               2      3       [1100352294     तिलक राज   \n",
       "3               3      4               NaN  दर्शना देवी   \n",
       "4               4      5        LTK0569673    पूजा देवी   \n",
       "...           ...    ...               ...          ...   \n",
       "16701         884    665        TKE0062240  पराकल कृमार   \n",
       "16702         885    886        MGJ1149475    कमला देवी   \n",
       "16703         886    667        TKE0121905    रवि कुमार   \n",
       "16704         887    888        TKE0159467        मंजला   \n",
       "16705         888    569        TKEO206102        आकृति   \n",
       "\n",
       "      father_or_husband_name relationship house_no   age    sex  \\\n",
       "0                  राम चन्द       Husband     2(1)    68  महिला   \n",
       "1                  राम चन्द        Father     2(1)    47  पुरूष   \n",
       "2                  राम चन्द        Father     2(1)    43  पुरूष   \n",
       "3                  मोती राम       Husband     2(2)   NaN  महिला   \n",
       "4                   लेख राज       Husband      2/1    35  महिला   \n",
       "...                      ...          ...      ...   ...    ...   \n",
       "16701            शमशेर सिंह        Father      177  28.0  पुरूष   \n",
       "16702           मूृनि यप्पा       Husband      178  44.0  महिला   \n",
       "16703             मृनियप्पा        Father      178  24.0  पुरूष   \n",
       "16704               मृनियपा        Father      178  23.0  महिला   \n",
       "16705              शशिकान्त        Father    154/1  21.0  महिला   \n",
       "\n",
       "                      ac_name  ...   mandal revenue_division  district  \\\n",
       "0      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "1      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "2      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "3      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "4      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "...                       ...  ...      ...              ...       ...   \n",
       "16701    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16702    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16703    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16704    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16705    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "\n",
       "      pin_code polling_station_name       polling_station_address  \\\n",
       "0       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "1       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "2       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "3       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "4       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "...        ...                  ...                           ...   \n",
       "16701   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16702   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16703   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16704   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16705   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "\n",
       "      net_electors_male net_electors_female net_electors_third_gender  \\\n",
       "0                   385                 344                         0   \n",
       "1                   385                 344                         0   \n",
       "2                   385                 344                         0   \n",
       "3                   385                 344                         0   \n",
       "4                   385                 344                         0   \n",
       "...                 ...                 ...                       ...   \n",
       "16701               443                 446                         0   \n",
       "16702               443                 446                         0   \n",
       "16703               443                 446                         0   \n",
       "16704               443                 446                         0   \n",
       "16705               443                 446                         0   \n",
       "\n",
       "      net_electors_total  \n",
       "0                    729  \n",
       "1                    729  \n",
       "2                    729  \n",
       "3                    729  \n",
       "4                    729  \n",
       "...                  ...  \n",
       "16701                889  \n",
       "16702                889  \n",
       "16703                889  \n",
       "16704                889  \n",
       "16705                889  \n",
       "\n",
       "[16706 rows x 27 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.elector_name = df2.elector_name.str.strip()\n",
    "df2"
   ]
  },
  {
   "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>mandal</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>ol</td>\n",
       "      <td>HP/03/050/156295</td>\n",
       "      <td>केसरो देवी</td>\n",
       "      <td>राम चन्द</td>\n",
       "      <td>Husband</td>\n",
       "      <td>2(1)</td>\n",
       "      <td>68</td>\n",
       "      <td>महिला</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>LTK0569285</td>\n",
       "      <td>लेख राज</td>\n",
       "      <td>राम चन्द</td>\n",
       "      <td>Father</td>\n",
       "      <td>2(1)</td>\n",
       "      <td>47</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>LTK0569673</td>\n",
       "      <td>पूजा देवी</td>\n",
       "      <td>लेख राज</td>\n",
       "      <td>Husband</td>\n",
       "      <td>2/1</td>\n",
       "      <td>35</td>\n",
       "      <td>महिला</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>TMT0097501</td>\n",
       "      <td>गीता देवी</td>\n",
       "      <td>तिलक राज</td>\n",
       "      <td>Husband</td>\n",
       "      <td>2/1</td>\n",
       "      <td>34</td>\n",
       "      <td>महिला</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>LTK0569715</td>\n",
       "      <td>दीपीका</td>\n",
       "      <td>चमारु राम</td>\n",
       "      <td>Husband</td>\n",
       "      <td>2/2</td>\n",
       "      <td>28</td>\n",
       "      <td>महिला</td>\n",
       "      <td>... ' भटियात (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</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>16700</th>\n",
       "      <td>883</td>\n",
       "      <td>884</td>\n",
       "      <td>TKE0062265</td>\n",
       "      <td>प्रियंका शर्मा</td>\n",
       "      <td>शमशेर सिंह</td>\n",
       "      <td>Father</td>\n",
       "      <td>477</td>\n",
       "      <td>28.0</td>\n",
       "      <td>महिला</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16701</th>\n",
       "      <td>884</td>\n",
       "      <td>665</td>\n",
       "      <td>TKE0062240</td>\n",
       "      <td>पराकल कृमार</td>\n",
       "      <td>शमशेर सिंह</td>\n",
       "      <td>Father</td>\n",
       "      <td>177</td>\n",
       "      <td>28.0</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16702</th>\n",
       "      <td>885</td>\n",
       "      <td>886</td>\n",
       "      <td>MGJ1149475</td>\n",
       "      <td>कमला देवी</td>\n",
       "      <td>मूृनि यप्पा</td>\n",
       "      <td>Husband</td>\n",
       "      <td>178</td>\n",
       "      <td>44.0</td>\n",
       "      <td>महिला</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16703</th>\n",
       "      <td>886</td>\n",
       "      <td>667</td>\n",
       "      <td>TKE0121905</td>\n",
       "      <td>रवि कुमार</td>\n",
       "      <td>मृनियप्पा</td>\n",
       "      <td>Father</td>\n",
       "      <td>178</td>\n",
       "      <td>24.0</td>\n",
       "      <td>पुरूष</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16704</th>\n",
       "      <td>887</td>\n",
       "      <td>888</td>\n",
       "      <td>TKE0159467</td>\n",
       "      <td>मंजला</td>\n",
       "      <td>मृनियपा</td>\n",
       "      <td>Father</td>\n",
       "      <td>178</td>\n",
       "      <td>23.0</td>\n",
       "      <td>महिला</td>\n",
       "      <td>.“ ' मनाली (सामान्य)</td>\n",
       "      <td>...</td>\n",
       "      <td>. मनाली</td>\n",
       "      <td>कटरा</td>\n",
       "      <td>Hoe</td>\n",
       "      <td>175129</td>\n",
       "      <td>55 , कटरांई-2</td>\n",
       "      <td>रा.व.मा.पा.कटरांई (नया भवन),</td>\n",
       "      <td>443</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>889</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11270 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0 number                id    elector_name  \\\n",
       "0               0     ol  HP/03/050/156295      केसरो देवी   \n",
       "1               1      2        LTK0569285         लेख राज   \n",
       "4               4      5        LTK0569673       पूजा देवी   \n",
       "5               5      6        TMT0097501       गीता देवी   \n",
       "7               7      8        LTK0569715          दीपीका   \n",
       "...           ...    ...               ...             ...   \n",
       "16700         883    884        TKE0062265  प्रियंका शर्मा   \n",
       "16701         884    665        TKE0062240     पराकल कृमार   \n",
       "16702         885    886        MGJ1149475       कमला देवी   \n",
       "16703         886    667        TKE0121905       रवि कुमार   \n",
       "16704         887    888        TKE0159467           मंजला   \n",
       "\n",
       "      father_or_husband_name relationship house_no   age    sex  \\\n",
       "0                  राम चन्द       Husband     2(1)    68  महिला   \n",
       "1                  राम चन्द        Father     2(1)    47  पुरूष   \n",
       "4                   लेख राज       Husband      2/1    35  महिला   \n",
       "5                  तिलक राज       Husband      2/1    34  महिला   \n",
       "7                 चमारु राम       Husband      2/2    28  महिला   \n",
       "...                      ...          ...      ...   ...    ...   \n",
       "16700            शमशेर सिंह        Father      477  28.0  महिला   \n",
       "16701            शमशेर सिंह        Father      177  28.0  पुरूष   \n",
       "16702           मूृनि यप्पा       Husband      178  44.0  महिला   \n",
       "16703             मृनियप्पा        Father      178  24.0  पुरूष   \n",
       "16704               मृनियपा        Father      178  23.0  महिला   \n",
       "\n",
       "                      ac_name  ...   mandal revenue_division  district  \\\n",
       "0      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "1      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "4      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "5      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "7      ... ' भटियात (सामान्य)  ...  भरटियात            टिकरी     चम्बा   \n",
       "...                       ...  ...      ...              ...       ...   \n",
       "16700    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16701    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16702    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16703    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "16704    .“ ' मनाली (सामान्य)  ...  . मनाली             कटरा       Hoe   \n",
       "\n",
       "      pin_code polling_station_name       polling_station_address  \\\n",
       "0       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "1       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "4       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "5       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "7       176207           76 , टिकरी            रा.प्रा.पा. टिकरी,   \n",
       "...        ...                  ...                           ...   \n",
       "16700   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16701   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16702   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16703   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "16704   175129        55 , कटरांई-2  रा.व.मा.पा.कटरांई (नया भवन),   \n",
       "\n",
       "      net_electors_male net_electors_female net_electors_third_gender  \\\n",
       "0                   385                 344                         0   \n",
       "1                   385                 344                         0   \n",
       "4                   385                 344                         0   \n",
       "5                   385                 344                         0   \n",
       "7                   385                 344                         0   \n",
       "...                 ...                 ...                       ...   \n",
       "16700               443                 446                         0   \n",
       "16701               443                 446                         0   \n",
       "16702               443                 446                         0   \n",
       "16703               443                 446                         0   \n",
       "16704               443                 446                         0   \n",
       "\n",
       "      net_electors_total  \n",
       "0                    729  \n",
       "1                    729  \n",
       "4                    729  \n",
       "5                    729  \n",
       "7                    729  \n",
       "...                  ...  \n",
       "16700                889  \n",
       "16701                889  \n",
       "16702                889  \n",
       "16703                889  \n",
       "16704                889  \n",
       "\n",
       "[11270 rows x 27 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2[df2.id.isin(df.id.unique())]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>mandal</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A0560059.pdf</td>\n",
       "      <td>1</td>\n",
       "      <td>HP/01/019/111312</td>\n",
       "      <td>राम Aयार&lt;</td>\n",
       "      <td>राम च(P</td>\n",
       "      <td>प.त</td>\n",
       "      <td>1/1</td>\n",
       "      <td>44</td>\n",
       "      <td>मSहला</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>बर्मा पापडी</td>\n",
       "      <td>सिरमौर</td>\n",
       "      <td>173030</td>\n",
       "      <td>59 , बमी-पापड़ी-1</td>\n",
       "      <td>रा.व.मा.पा., बर्मा-पापड़ी,</td>\n",
       "      <td>410</td>\n",
       "      <td>391</td>\n",
       "      <td>0</td>\n",
       "      <td>801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A0560059.pdf</td>\n",
       "      <td>2</td>\n",
       "      <td>NCH0159657</td>\n",
       "      <td>धनवीर सहं</td>\n",
       "      <td>राम च(P</td>\n",
       "      <td>+पता</td>\n",
       "      <td>1/1</td>\n",
       "      <td>25</td>\n",
       "      <td>पु?ष</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>बर्मा पापडी</td>\n",
       "      <td>सिरमौर</td>\n",
       "      <td>173030</td>\n",
       "      <td>59 , बमी-पापड़ी-1</td>\n",
       "      <td>रा.व.मा.पा., बर्मा-पापड़ी,</td>\n",
       "      <td>410</td>\n",
       "      <td>391</td>\n",
       "      <td>0</td>\n",
       "      <td>801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A0560059.pdf</td>\n",
       "      <td>10</td>\n",
       "      <td>KPD0644542</td>\n",
       "      <td>सरे(P कुमार</td>\n",
       "      <td>कु(दन सहं</td>\n",
       "      <td>+पता</td>\n",
       "      <td>3/1</td>\n",
       "      <td>31</td>\n",
       "      <td>पु?ष</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>बर्मा पापडी</td>\n",
       "      <td>सिरमौर</td>\n",
       "      <td>173030</td>\n",
       "      <td>59 , बमी-पापड़ी-1</td>\n",
       "      <td>रा.व.मा.पा., बर्मा-पापड़ी,</td>\n",
       "      <td>410</td>\n",
       "      <td>391</td>\n",
       "      <td>0</td>\n",
       "      <td>801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A0560059.pdf</td>\n",
       "      <td>12</td>\n",
       "      <td>KPD0642991</td>\n",
       "      <td>अशोक कुमार</td>\n",
       "      <td>कु(दन सहं</td>\n",
       "      <td>+पता</td>\n",
       "      <td>3/1</td>\n",
       "      <td>29</td>\n",
       "      <td>पु?ष</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>बर्मा पापडी</td>\n",
       "      <td>सिरमौर</td>\n",
       "      <td>173030</td>\n",
       "      <td>59 , बमी-पापड़ी-1</td>\n",
       "      <td>रा.व.मा.पा., बर्मा-पापड़ी,</td>\n",
       "      <td>410</td>\n",
       "      <td>391</td>\n",
       "      <td>0</td>\n",
       "      <td>801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A0560059.pdf</td>\n",
       "      <td>13</td>\n",
       "      <td>NCH0137075</td>\n",
       "      <td>उषा रानी</td>\n",
       "      <td>सरे(P कुमार</td>\n",
       "      <td>प.त</td>\n",
       "      <td>3/1</td>\n",
       "      <td>26</td>\n",
       "      <td>मSहला</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>बर्मा पापडी</td>\n",
       "      <td>सिरमौर</td>\n",
       "      <td>173030</td>\n",
       "      <td>59 , बमी-पापड़ी-1</td>\n",
       "      <td>रा.व.मा.पा., बर्मा-पापड़ी,</td>\n",
       "      <td>410</td>\n",
       "      <td>391</td>\n",
       "      <td>0</td>\n",
       "      <td>801</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>11266</th>\n",
       "      <td>A0050076.pdf</td>\n",
       "      <td>722</td>\n",
       "      <td>TMT0017228</td>\n",
       "      <td>लता देवी</td>\n",
       "      <td>जगदीश चद</td>\n",
       "      <td>पित</td>\n",
       "      <td>188(1)</td>\n",
       "      <td>32.0</td>\n",
       "      <td>मिहला</td>\n",
       "      <td>721</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11267</th>\n",
       "      <td>A0050076.pdf</td>\n",
       "      <td>723</td>\n",
       "      <td>TMT0246132</td>\n",
       "      <td>नरे द्र  .</td>\n",
       "      <td>केसर िसहं  .</td>\n",
       "      <td>िपता</td>\n",
       "      <td>188(1)</td>\n",
       "      <td>23.0</td>\n",
       "      <td>पु ष</td>\n",
       "      <td>722</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11268</th>\n",
       "      <td>A0050076.pdf</td>\n",
       "      <td>725</td>\n",
       "      <td>LTK0512566</td>\n",
       "      <td>िककर िस◌ंह</td>\n",
       "      <td>केसर राम</td>\n",
       "      <td>िपता</td>\n",
       "      <td>188/1</td>\n",
       "      <td>34.0</td>\n",
       "      <td>पु ष</td>\n",
       "      <td>724</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11269</th>\n",
       "      <td>A0050076.pdf</td>\n",
       "      <td>726</td>\n",
       "      <td>TMT0190827</td>\n",
       "      <td>िवजय कुमार</td>\n",
       "      <td>चरणो राम</td>\n",
       "      <td>िपता</td>\n",
       "      <td>190 (1)</td>\n",
       "      <td>22.0</td>\n",
       "      <td>पु ष</td>\n",
       "      <td>725</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11270</th>\n",
       "      <td>A0050076.pdf</td>\n",
       "      <td>729</td>\n",
       "      <td>TMT0274159</td>\n",
       "      <td>आरती  देवी</td>\n",
       "      <td>ितलक  राज</td>\n",
       "      <td>पित</td>\n",
       "      <td>11991)</td>\n",
       "      <td>23.0</td>\n",
       "      <td>मिहला</td>\n",
       "      <td>728</td>\n",
       "      <td>...</td>\n",
       "      <td>भरटियात</td>\n",
       "      <td>टिकरी</td>\n",
       "      <td>चम्बा</td>\n",
       "      <td>176207</td>\n",
       "      <td>76 , टिकरी</td>\n",
       "      <td>रा.प्रा.पा. टिकरी,</td>\n",
       "      <td>385</td>\n",
       "      <td>344</td>\n",
       "      <td>0</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11271 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         filename_x number_x                id elector_name_x  \\\n",
       "0      A0560059.pdf        1  HP/01/019/111312     राम Aयार<    \n",
       "1      A0560059.pdf        2        NCH0159657     धनवीर सहं    \n",
       "2      A0560059.pdf       10        KPD0644542   सरे(P कुमार    \n",
       "3      A0560059.pdf       12        KPD0642991    अशोक कुमार    \n",
       "4      A0560059.pdf       13        NCH0137075      उषा रानी    \n",
       "...             ...      ...               ...            ...   \n",
       "11266  A0050076.pdf      722        TMT0017228      लता देवी    \n",
       "11267  A0050076.pdf      723        TMT0246132    नरे द्र  .    \n",
       "11268  A0050076.pdf      725        LTK0512566    िककर िस◌ंह    \n",
       "11269  A0050076.pdf      726        TMT0190827    िवजय कुमार    \n",
       "11270  A0050076.pdf      729        TMT0274159    आरती  देवी    \n",
       "\n",
       "      father_or_husband_name_x relationship_x house_no_x age_x  sex_x  \\\n",
       "0                     राम च(P             प.त       1/1     44  मSहला   \n",
       "1                     राम च(P            +पता       1/1     25   पु?ष   \n",
       "2                   कु(दन सहं            +पता       3/1     31   पु?ष   \n",
       "3                   कु(दन सहं            +पता       3/1     29   पु?ष   \n",
       "4                 सरे(P कुमार             प.त       3/1     26  मSहला   \n",
       "...                        ...            ...        ...   ...    ...   \n",
       "11266               जगदीश चद              पित    188(1)   32.0  मिहला   \n",
       "11267            केसर िसहं  .            िपता    188(1)   23.0   पु ष   \n",
       "11268               केसर राम             िपता     188/1   34.0   पु ष   \n",
       "11269               चरणो राम             िपता   190 (1)   22.0   पु ष   \n",
       "11270               ितलक  राज             पित    11991)   23.0  मिहला   \n",
       "\n",
       "       Unnamed: 0  ...   mandal revenue_division district pin_code  \\\n",
       "0               0  ...      NaN      बर्मा पापडी   सिरमौर   173030   \n",
       "1               1  ...      NaN      बर्मा पापडी   सिरमौर   173030   \n",
       "2               9  ...      NaN      बर्मा पापडी   सिरमौर   173030   \n",
       "3              11  ...      NaN      बर्मा पापडी   सिरमौर   173030   \n",
       "4              12  ...      NaN      बर्मा पापडी   सिरमौर   173030   \n",
       "...           ...  ...      ...              ...      ...      ...   \n",
       "11266         721  ...  भरटियात            टिकरी    चम्बा   176207   \n",
       "11267         722  ...  भरटियात            टिकरी    चम्बा   176207   \n",
       "11268         724  ...  भरटियात            टिकरी    चम्बा   176207   \n",
       "11269         725  ...  भरटियात            टिकरी    चम्बा   176207   \n",
       "11270         728  ...  भरटियात            टिकरी    चम्बा   176207   \n",
       "\n",
       "      polling_station_name     polling_station_address net_electors_male  \\\n",
       "0        59 , बमी-पापड़ी-1  रा.व.मा.पा., बर्मा-पापड़ी,               410   \n",
       "1        59 , बमी-पापड़ी-1  रा.व.मा.पा., बर्मा-पापड़ी,               410   \n",
       "2        59 , बमी-पापड़ी-1  रा.व.मा.पा., बर्मा-पापड़ी,               410   \n",
       "3        59 , बमी-पापड़ी-1  रा.व.मा.पा., बर्मा-पापड़ी,               410   \n",
       "4        59 , बमी-पापड़ी-1  रा.व.मा.पा., बर्मा-पापड़ी,               410   \n",
       "...                    ...                         ...               ...   \n",
       "11266           76 , टिकरी          रा.प्रा.पा. टिकरी,               385   \n",
       "11267           76 , टिकरी          रा.प्रा.पा. टिकरी,               385   \n",
       "11268           76 , टिकरी          रा.प्रा.पा. टिकरी,               385   \n",
       "11269           76 , टिकरी          रा.प्रा.पा. टिकरी,               385   \n",
       "11270           76 , टिकरी          रा.प्रा.पा. टिकरी,               385   \n",
       "\n",
       "      net_electors_female net_electors_third_gender net_electors_total  \n",
       "0                     391                         0                801  \n",
       "1                     391                         0                801  \n",
       "2                     391                         0                801  \n",
       "3                     391                         0                801  \n",
       "4                     391                         0                801  \n",
       "...                   ...                       ...                ...  \n",
       "11266                 344                         0                729  \n",
       "11267                 344                         0                729  \n",
       "11268                 344                         0                729  \n",
       "11269                 344                         0                729  \n",
       "11270                 344                         0                729  \n",
       "\n",
       "[11271 rows x 35 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3 = df.merge(df2, on='id')\n",
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>mandal</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>A0560059.pdf</td>\n",
       "      <td>367</td>\n",
       "      <td>NCH0159491</td>\n",
       "      <td>मनोज कुमार</td>\n",
       "      <td>Yान चCद</td>\n",
       "      <td>पता</td>\n",
       "      <td>89</td>\n",
       "      <td>22</td>\n",
       "      <td>प4ुष</td>\n",
       "      <td>366</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>बर्मा पापडी</td>\n",
       "      <td>सिरमौर</td>\n",
       "      <td>173030</td>\n",
       "      <td>59 , बमी-पापड़ी-1</td>\n",
       "      <td>रा.व.मा.पा., बर्मा-पापड़ी,</td>\n",
       "      <td>410</td>\n",
       "      <td>391</td>\n",
       "      <td>0</td>\n",
       "      <td>801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3789</th>\n",
       "      <td>A0570100.pdf</td>\n",
       "      <td>16</td>\n",
       "      <td>KPD0454603</td>\n",
       "      <td>दया राम</td>\n",
       "      <td>जालू राम</td>\n",
       "      <td>पता</td>\n",
       "      <td>4</td>\n",
       "      <td>54.0</td>\n",
       "      <td>पु ष</td>\n",
       "      <td>15</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ददाहू</td>\n",
       "      <td>सिरमौर</td>\n",
       "      <td>173022</td>\n",
       "      <td>100, aalg -2</td>\n",
       "      <td>रा.मा.पा.(कन्या), ददाहू,</td>\n",
       "      <td>452</td>\n",
       "      <td>443</td>\n",
       "      <td>0</td>\n",
       "      <td>895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3795</th>\n",
       "      <td>A0570100.pdf</td>\n",
       "      <td>26</td>\n",
       "      <td>KPD0502864</td>\n",
       "      <td>घाला राम</td>\n",
       "      <td>ना टा राम</td>\n",
       "      <td>पता</td>\n",
       "      <td>5</td>\n",
       "      <td>38.0</td>\n",
       "      <td>पु ष</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ददाहू</td>\n",
       "      <td>सिरमौर</td>\n",
       "      <td>173022</td>\n",
       "      <td>100, aalg -2</td>\n",
       "      <td>रा.मा.पा.(कन्या), ददाहू,</td>\n",
       "      <td>452</td>\n",
       "      <td>443</td>\n",
       "      <td>0</td>\n",
       "      <td>895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3796</th>\n",
       "      <td>A0570100.pdf</td>\n",
       "      <td>27</td>\n",
       "      <td>KPD0582841</td>\n",
       "      <td>राजेश</td>\n",
       "      <td>कोचन</td>\n",
       "      <td>पता</td>\n",
       "      <td>5/क</td>\n",
       "      <td>36.0</td>\n",
       "      <td>पु ष</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ददाहू</td>\n",
       "      <td>सिरमौर</td>\n",
       "      <td>173022</td>\n",
       "      <td>100, aalg -2</td>\n",
       "      <td>रा.मा.पा.(कन्या), ददाहू,</td>\n",
       "      <td>452</td>\n",
       "      <td>443</td>\n",
       "      <td>0</td>\n",
       "      <td>895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3799</th>\n",
       "      <td>A0570100.pdf</td>\n",
       "      <td>46</td>\n",
       "      <td>SER0032797</td>\n",
       "      <td>जीत राम</td>\n",
       "      <td>मधू राम</td>\n",
       "      <td>पता</td>\n",
       "      <td>12</td>\n",
       "      <td>52.0</td>\n",
       "      <td>पु ष</td>\n",
       "      <td>45</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ददाहू</td>\n",
       "      <td>सिरमौर</td>\n",
       "      <td>173022</td>\n",
       "      <td>100, aalg -2</td>\n",
       "      <td>रा.मा.पा.(कन्या), ददाहू,</td>\n",
       "      <td>452</td>\n",
       "      <td>443</td>\n",
       "      <td>0</td>\n",
       "      <td>895</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>10489</th>\n",
       "      <td>A0480077.pdf</td>\n",
       "      <td>647</td>\n",
       "      <td>GZP0715136</td>\n",
       "      <td>हेम राज</td>\n",
       "      <td>कु दन लाल</td>\n",
       "      <td>पता</td>\n",
       "      <td>85</td>\n",
       "      <td>68.0</td>\n",
       "      <td>प ष</td>\n",
       "      <td>646</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>बेलासपुर</td>\n",
       "      <td>174001</td>\n",
       "      <td>77 , कोसरिया</td>\n",
       "      <td>राजकीय महाविद्यालय बिलासपुर,</td>\n",
       "      <td>388</td>\n",
       "      <td>370</td>\n",
       "      <td>0</td>\n",
       "      <td>758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10566</th>\n",
       "      <td>A0480077.pdf</td>\n",
       "      <td>728</td>\n",
       "      <td>GZP0486423</td>\n",
       "      <td>राम दास</td>\n",
       "      <td>राम दतु</td>\n",
       "      <td>पता</td>\n",
       "      <td>175</td>\n",
       "      <td>62.0</td>\n",
       "      <td>प ष</td>\n",
       "      <td>727</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>बेलासपुर</td>\n",
       "      <td>174001</td>\n",
       "      <td>77 , कोसरिया</td>\n",
       "      <td>राजकीय महाविद्यालय बिलासपुर,</td>\n",
       "      <td>388</td>\n",
       "      <td>370</td>\n",
       "      <td>0</td>\n",
       "      <td>758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10567</th>\n",
       "      <td>A0480077.pdf</td>\n",
       "      <td>729</td>\n",
       "      <td>GZP0715797</td>\n",
       "      <td>बलबीर</td>\n",
       "      <td>रामोदतु</td>\n",
       "      <td>पता</td>\n",
       "      <td>175</td>\n",
       "      <td>56.0</td>\n",
       "      <td>प ष</td>\n",
       "      <td>728</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>बेलासपुर</td>\n",
       "      <td>174001</td>\n",
       "      <td>77 , कोसरिया</td>\n",
       "      <td>राजकीय महाविद्यालय बिलासपुर,</td>\n",
       "      <td>388</td>\n",
       "      <td>370</td>\n",
       "      <td>0</td>\n",
       "      <td>758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10572</th>\n",
       "      <td>A0480077.pdf</td>\n",
       "      <td>734</td>\n",
       "      <td>YDB0198234</td>\n",
       "      <td>देश राज</td>\n",
       "      <td>राम दास</td>\n",
       "      <td>पता</td>\n",
       "      <td>175</td>\n",
       "      <td>27.0</td>\n",
       "      <td>प ष</td>\n",
       "      <td>733</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>बेलासपुर</td>\n",
       "      <td>174001</td>\n",
       "      <td>77 , कोसरिया</td>\n",
       "      <td>राजकीय महाविद्यालय बिलासपुर,</td>\n",
       "      <td>388</td>\n",
       "      <td>370</td>\n",
       "      <td>0</td>\n",
       "      <td>758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10579</th>\n",
       "      <td>A0480077.pdf</td>\n",
       "      <td>741</td>\n",
       "      <td>YDB0041368</td>\n",
       "      <td>आरती</td>\n",
       "      <td>देव काश</td>\n",
       "      <td>पता</td>\n",
       "      <td>197</td>\n",
       "      <td>27.0</td>\n",
       "      <td>म हला</td>\n",
       "      <td>740</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>बेलासपुर</td>\n",
       "      <td>174001</td>\n",
       "      <td>77 , कोसरिया</td>\n",
       "      <td>राजकीय महाविद्यालय बिलासपुर,</td>\n",
       "      <td>388</td>\n",
       "      <td>370</td>\n",
       "      <td>0</td>\n",
       "      <td>758</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>118 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         filename_x number_x          id elector_name_x  \\\n",
       "449    A0560059.pdf      367  NCH0159491     मनोज कुमार   \n",
       "3789   A0570100.pdf       16  KPD0454603        दया राम   \n",
       "3795   A0570100.pdf       26  KPD0502864       घाला राम   \n",
       "3796   A0570100.pdf       27  KPD0582841          राजेश   \n",
       "3799   A0570100.pdf       46  SER0032797        जीत राम   \n",
       "...             ...      ...         ...            ...   \n",
       "10489  A0480077.pdf      647  GZP0715136        हेम राज   \n",
       "10566  A0480077.pdf      728  GZP0486423        राम दास   \n",
       "10567  A0480077.pdf      729  GZP0715797          बलबीर   \n",
       "10572  A0480077.pdf      734  YDB0198234        देश राज   \n",
       "10579  A0480077.pdf      741  YDB0041368           आरती   \n",
       "\n",
       "      father_or_husband_name_x relationship_x house_no_x age_x  sex_x  \\\n",
       "449                   Yान चCद             पता        89     22   प4ुष   \n",
       "3789                जालू राम              पता         4   54.0   पु ष   \n",
       "3795               ना टा राम              पता         5   38.0   पु ष   \n",
       "3796                    कोचन              पता       5/क   36.0   पु ष   \n",
       "3799                 मधू राम              पता        12   52.0   पु ष   \n",
       "...                        ...            ...        ...   ...    ...   \n",
       "10489               कु दन लाल             पता        85   68.0    प ष   \n",
       "10566                राम दतु              पता       175   62.0    प ष   \n",
       "10567                रामोदतु              पता       175   56.0    प ष   \n",
       "10572                राम दास              पता       175   27.0    प ष   \n",
       "10579                देव काश              पता       197   27.0  म हला   \n",
       "\n",
       "       Unnamed: 0  ... mandal revenue_division  district pin_code  \\\n",
       "449           366  ...    NaN      बर्मा पापडी    सिरमौर   173030   \n",
       "3789           15  ...    NaN            ददाहू    सिरमौर   173022   \n",
       "3795           25  ...    NaN            ददाहू    सिरमौर   173022   \n",
       "3796           26  ...    NaN            ददाहू    सिरमौर   173022   \n",
       "3799           45  ...    NaN            ददाहू    सिरमौर   173022   \n",
       "...           ...  ...    ...              ...       ...      ...   \n",
       "10489         646  ...    NaN              NaN  बेलासपुर   174001   \n",
       "10566         727  ...    NaN              NaN  बेलासपुर   174001   \n",
       "10567         728  ...    NaN              NaN  बेलासपुर   174001   \n",
       "10572         733  ...    NaN              NaN  बेलासपुर   174001   \n",
       "10579         740  ...    NaN              NaN  बेलासपुर   174001   \n",
       "\n",
       "      polling_station_name       polling_station_address net_electors_male  \\\n",
       "449      59 , बमी-पापड़ी-1    रा.व.मा.पा., बर्मा-पापड़ी,               410   \n",
       "3789          100, aalg -2      रा.मा.पा.(कन्या), ददाहू,               452   \n",
       "3795          100, aalg -2      रा.मा.पा.(कन्या), ददाहू,               452   \n",
       "3796          100, aalg -2      रा.मा.पा.(कन्या), ददाहू,               452   \n",
       "3799          100, aalg -2      रा.मा.पा.(कन्या), ददाहू,               452   \n",
       "...                    ...                           ...               ...   \n",
       "10489         77 , कोसरिया  राजकीय महाविद्यालय बिलासपुर,               388   \n",
       "10566         77 , कोसरिया  राजकीय महाविद्यालय बिलासपुर,               388   \n",
       "10567         77 , कोसरिया  राजकीय महाविद्यालय बिलासपुर,               388   \n",
       "10572         77 , कोसरिया  राजकीय महाविद्यालय बिलासपुर,               388   \n",
       "10579         77 , कोसरिया  राजकीय महाविद्यालय बिलासपुर,               388   \n",
       "\n",
       "      net_electors_female net_electors_third_gender net_electors_total  \n",
       "449                   391                         0                801  \n",
       "3789                  443                         0                895  \n",
       "3795                  443                         0                895  \n",
       "3796                  443                         0                895  \n",
       "3799                  443                         0                895  \n",
       "...                   ...                       ...                ...  \n",
       "10489                 370                         0                758  \n",
       "10566                 370                         0                758  \n",
       "10567                 370                         0                758  \n",
       "10572                 370                         0                758  \n",
       "10579                 370                         0                758  \n",
       "\n",
       "[118 rows x 35 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3[df3.elector_name_x==df3.elector_name_y]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "df3.to_csv('/tmp/himachal.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
}