mt_scratch.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import geopandas as gpd\n",
    "import pandas as pd\n",
    "from gerrychain import Graph"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "blocks_10 = gpd.read_file('data/election/cblock2010')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Unnamed: 0', 'NHPIVAP20', 'STUSAB', 'BVAP20', 'OTHERPOP20', 'GEOCODE',\n",
       "       'WVAP20', 'APAMIVAP20', 'APAPOP20', 'MTFCC20', 'NAMELSAD20', 'VTDI20',\n",
       "       'AWATER20', 'APBVAP20', 'INTPTLON20', 'APAMIPOP20', 'VTDST20', 'BPOP20',\n",
       "       '2MOREVAP20', 'DOJBVAP20', 'OTHERVAP20', 'HISP20', 'APBPOP20', 'FILEID',\n",
       "       'ASIANPOP20', 'COVAP20', 'NAME20', 'CIFSN', 'NWBHVAP20', 'ASIANVAP20',\n",
       "       'TOTPOP20', 'NBAPAVAP20', 'WPOP20', 'APAVAP20', 'SUMLEV', 'AMINVAP20',\n",
       "       'LSAD20', 'FUNCSTAT20', 'AMINPOP20', 'GEOID20', 'NHPIPOP20',\n",
       "       '2MOREPOP20', 'STATEFP20', 'ALAND20', 'HVAP20', 'COPOP20', 'COUNTYFP20',\n",
       "       'CHARITER', 'INTPTLAT20', 'NWBHPOP20', 'VAP20', 'NBAPAPOP20',\n",
       "       'LOGRECNO', 'geometry', 'G20PRERTRU', 'G20PREDBID', 'G20USSRDAI',\n",
       "       'G20USSDBUL', 'G20GOVRGIA', 'G20GOVDCOO', 'G18USSRROS', 'G18USSDTES'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test = pd.read_csv('data/election/mt_vtd_elex.csv')\n",
    "test.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "mt_data = pd.read_csv('data/election/mt_vtd_elex.csv')\n",
    "mt_graph = Graph.from_json('data/election/mt_vtd_connected.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Unnamed: 0', 'NHPIVAP20', 'STUSAB', 'BVAP20', 'OTHERPOP20', 'GEOCODE',\n",
       "       'WVAP20', 'APAMIVAP20', 'APAPOP20', 'MTFCC20', 'NAMELSAD20', 'VTDI20',\n",
       "       'AWATER20', 'APBVAP20', 'INTPTLON20', 'APAMIPOP20', 'VTDST20', 'BPOP20',\n",
       "       '2MOREVAP20', 'DOJBVAP20', 'OTHERVAP20', 'HISP20', 'APBPOP20', 'FILEID',\n",
       "       'ASIANPOP20', 'COVAP20', 'NAME20', 'CIFSN', 'NWBHVAP20', 'ASIANVAP20',\n",
       "       'TOTPOP20', 'NBAPAVAP20', 'WPOP20', 'APAVAP20', 'SUMLEV', 'AMINVAP20',\n",
       "       'LSAD20', 'FUNCSTAT20', 'AMINPOP20', 'GEOID20', 'NHPIPOP20',\n",
       "       '2MOREPOP20', 'STATEFP20', 'ALAND20', 'HVAP20', 'COPOP20', 'COUNTYFP20',\n",
       "       'CHARITER', 'INTPTLAT20', 'NWBHPOP20', 'VAP20', 'NBAPAPOP20',\n",
       "       'LOGRECNO', 'geometry', 'G20PRERTRU', 'G20PREDBID', 'G20USSRDAI',\n",
       "       'G20USSDBUL', 'G20GOVRGIA', 'G20GOVDCOO', 'G18USSRROS', 'G18USSDTES'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mt_data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "test = gpd.read_file('data/election/MontanaVotingPrecincts_shp')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "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>NUMBER</th>\n",
       "      <th>NAME</th>\n",
       "      <th>HOUSE</th>\n",
       "      <th>SENATE</th>\n",
       "      <th>POLLCODE</th>\n",
       "      <th>POLLINGPLA</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>COUNTYCODE</th>\n",
       "      <th>SOSPRECINC</th>\n",
       "      <th>SOURCE</th>\n",
       "      <th>...</th>\n",
       "      <th>FUNCSTAT20</th>\n",
       "      <th>ALAND20</th>\n",
       "      <th>AWATER20</th>\n",
       "      <th>INTPTLAT20</th>\n",
       "      <th>INTPTLON20</th>\n",
       "      <th>PrecinctNa</th>\n",
       "      <th>Acres</th>\n",
       "      <th>SHAPE_Leng</th>\n",
       "      <th>SHAPE_Area</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>000034</td>\n",
       "      <td>34 LUS OPH NAS GNE</td>\n",
       "      <td>34</td>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GLASGOW CIVIC CENTER 34</td>\n",
       "      <td>Valley</td>\n",
       "      <td>20</td>\n",
       "      <td>34 LUS OPH NAS GNE</td>\n",
       "      <td>DIGITIZED FROM COUNTY MAP</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>3.989546e+09</td>\n",
       "      <td>1832841.0</td>\n",
       "      <td>+48.5208519</td>\n",
       "      <td>-106.2278151</td>\n",
       "      <td>34 LUS OPH NAS GNE</td>\n",
       "      <td>986338.513254</td>\n",
       "      <td>373183.147215</td>\n",
       "      <td>3.989534e+09</td>\n",
       "      <td>POLYGON ((845351.470 522772.354, 845368.623 52...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     NUMBER                NAME HOUSE SENATE  POLLCODE  \\\n",
       "383  000034  34 LUS OPH NAS GNE    34     17       NaN   \n",
       "\n",
       "                  POLLINGPLA  COUNTY COUNTYCODE          SOSPRECINC  \\\n",
       "383  GLASGOW CIVIC CENTER 34  Valley         20  34 LUS OPH NAS GNE   \n",
       "\n",
       "                        SOURCE  ... FUNCSTAT20       ALAND20   AWATER20  \\\n",
       "383  DIGITIZED FROM COUNTY MAP  ...          N  3.989546e+09  1832841.0   \n",
       "\n",
       "      INTPTLAT20    INTPTLON20          PrecinctNa          Acres  \\\n",
       "383  +48.5208519  -106.2278151  34 LUS OPH NAS GNE  986338.513254   \n",
       "\n",
       "        SHAPE_Leng    SHAPE_Area  \\\n",
       "383  373183.147215  3.989534e+09   \n",
       "\n",
       "                                              geometry  \n",
       "383  POLYGON ((845351.470 522772.354, 845368.623 52...  \n",
       "\n",
       "[1 rows x 34 columns]"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test[test[\"GEOID20\"] == '30105000034']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "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>NUMBER</th>\n",
       "      <th>NAME</th>\n",
       "      <th>HOUSE</th>\n",
       "      <th>SENATE</th>\n",
       "      <th>POLLCODE</th>\n",
       "      <th>POLLINGPLA</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>COUNTYCODE</th>\n",
       "      <th>SOSPRECINC</th>\n",
       "      <th>SOURCE</th>\n",
       "      <th>...</th>\n",
       "      <th>FUNCSTAT20</th>\n",
       "      <th>ALAND20</th>\n",
       "      <th>AWATER20</th>\n",
       "      <th>INTPTLAT20</th>\n",
       "      <th>INTPTLON20</th>\n",
       "      <th>PrecinctNa</th>\n",
       "      <th>Acres</th>\n",
       "      <th>SHAPE_Leng</th>\n",
       "      <th>SHAPE_Area</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>000001</td>\n",
       "      <td>#1 Precinct - West</td>\n",
       "      <td>27</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CJI ELE GYM</td>\n",
       "      <td>Liberty</td>\n",
       "      <td>48</td>\n",
       "      <td>#1 Precinct - West</td>\n",
       "      <td>2010 CENSUS GIS DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>1.740307e+09</td>\n",
       "      <td>40732356.0</td>\n",
       "      <td>+48.5306227</td>\n",
       "      <td>-111.1562453</td>\n",
       "      <td>#1 Precinct - West</td>\n",
       "      <td>440107.371086</td>\n",
       "      <td>277799.685711</td>\n",
       "      <td>1.780194e+09</td>\n",
       "      <td>POLYGON ((489630.928 519814.997, 489630.422 51...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>000001</td>\n",
       "      <td>1-HERON-HD13</td>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HERON COMMUNITY CENTER</td>\n",
       "      <td>Sanders</td>\n",
       "      <td>35</td>\n",
       "      <td>1-HERON-HD13</td>\n",
       "      <td>COUNTY GIS DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>S</td>\n",
       "      <td>2.758566e+08</td>\n",
       "      <td>5115721.0</td>\n",
       "      <td>+48.0717721</td>\n",
       "      <td>-115.9641869</td>\n",
       "      <td>1-HERON-HD13</td>\n",
       "      <td>69455.096056</td>\n",
       "      <td>89100.974828</td>\n",
       "      <td>2.808300e+08</td>\n",
       "      <td>POLYGON ((115169.674 460413.777, 115204.854 46...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>000001</td>\n",
       "      <td>1 WESTBY</td>\n",
       "      <td>34</td>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WESTBY COMMUNITY HALL</td>\n",
       "      <td>Sheridan</td>\n",
       "      <td>34</td>\n",
       "      <td>1 WESTBY</td>\n",
       "      <td>DIGITIZED FROM COUNTY MAP</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>7.192383e+08</td>\n",
       "      <td>24529367.0</td>\n",
       "      <td>+48.8563682</td>\n",
       "      <td>-104.1708300</td>\n",
       "      <td>1 WESTBY</td>\n",
       "      <td>183654.506975</td>\n",
       "      <td>152032.440373</td>\n",
       "      <td>7.430920e+08</td>\n",
       "      <td>POLYGON ((999335.715 530475.725, 999345.275 53...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>000001</td>\n",
       "      <td>COLUMBUS PRECINCT 1</td>\n",
       "      <td>57</td>\n",
       "      <td>29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>STILLWATER PAVILLION</td>\n",
       "      <td>Stillwater</td>\n",
       "      <td>32</td>\n",
       "      <td>COLUMBUS PRECINCT 1</td>\n",
       "      <td>COUNTY GIS DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>8.983969e+08</td>\n",
       "      <td>8611530.0</td>\n",
       "      <td>+45.6436291</td>\n",
       "      <td>-109.2706396</td>\n",
       "      <td>COLUMBUS PRECINCT 1</td>\n",
       "      <td>224302.648086</td>\n",
       "      <td>211020.905061</td>\n",
       "      <td>9.071316e+08</td>\n",
       "      <td>POLYGON ((618565.054 173709.864, 618971.105 17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>000001</td>\n",
       "      <td>FORTINE</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TREGO-FORTINE-STRYKER VOLUNTEER FIRE DEPARTMENT</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>56</td>\n",
       "      <td>FORTINE</td>\n",
       "      <td>COUNTY GIS DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>2.236212e+08</td>\n",
       "      <td>1841272.0</td>\n",
       "      <td>+48.7788643</td>\n",
       "      <td>-114.8481719</td>\n",
       "      <td>FORTINE</td>\n",
       "      <td>55690.792537</td>\n",
       "      <td>77785.282402</td>\n",
       "      <td>2.253137e+08</td>\n",
       "      <td>POLYGON ((195242.148 521890.043, 195385.515 52...</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>665</th>\n",
       "      <td>000009</td>\n",
       "      <td>BIG SANDY 9</td>\n",
       "      <td>27</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BIG SANDY TOWN HALL</td>\n",
       "      <td>Chouteau</td>\n",
       "      <td>19</td>\n",
       "      <td>BIG SANDY 9</td>\n",
       "      <td>ALIGNED WITH HOUSE DISTRICTS</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>2.171519e+09</td>\n",
       "      <td>11985218.0</td>\n",
       "      <td>+48.0381231</td>\n",
       "      <td>-109.9317765</td>\n",
       "      <td>BIG SANDY 9</td>\n",
       "      <td>540833.409987</td>\n",
       "      <td>249831.476944</td>\n",
       "      <td>2.186658e+09</td>\n",
       "      <td>POLYGON ((567465.832 443144.367, 567463.389 44...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>666</th>\n",
       "      <td>000001</td>\n",
       "      <td>FORT BENTON 1</td>\n",
       "      <td>27</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FORT BENTON ELEMENTARY</td>\n",
       "      <td>Chouteau</td>\n",
       "      <td>19</td>\n",
       "      <td>FORT BENTON 1</td>\n",
       "      <td>DIGITIZED FROM COUNTY MAP</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>4.485305e+08</td>\n",
       "      <td>4042520.0</td>\n",
       "      <td>+47.7719158</td>\n",
       "      <td>-110.5648354</td>\n",
       "      <td>FORT BENTON 1</td>\n",
       "      <td>112493.886441</td>\n",
       "      <td>114653.518682</td>\n",
       "      <td>4.547761e+08</td>\n",
       "      <td>POLYGON ((519180.536 403061.958, 519271.178 40...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667</th>\n",
       "      <td>000003</td>\n",
       "      <td>GERALDINE 3</td>\n",
       "      <td>27</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GERALDINE SENIOR CITIZEN</td>\n",
       "      <td>Chouteau</td>\n",
       "      <td>19</td>\n",
       "      <td>GERALDINE 3</td>\n",
       "      <td>DIGITIZED FROM COUNTY MAP</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>2.128091e+09</td>\n",
       "      <td>19561284.0</td>\n",
       "      <td>+47.6625301</td>\n",
       "      <td>-110.1780981</td>\n",
       "      <td>GERALDINE 3</td>\n",
       "      <td>531182.844968</td>\n",
       "      <td>262935.020498</td>\n",
       "      <td>2.147285e+09</td>\n",
       "      <td>POLYGON ((555986.800 412261.985, 555993.230 41...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668</th>\n",
       "      <td>000005</td>\n",
       "      <td>ROCKY BOY 5</td>\n",
       "      <td>32</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEW STONE CHILD COLLEGE</td>\n",
       "      <td>Chouteau</td>\n",
       "      <td>19</td>\n",
       "      <td>ROCKY BOY 5</td>\n",
       "      <td>ALIGNED WITH HOUSE DISTRICTS</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>1.795011e+08</td>\n",
       "      <td>430802.0</td>\n",
       "      <td>+48.2487780</td>\n",
       "      <td>-109.9045952</td>\n",
       "      <td>ROCKY BOY 5</td>\n",
       "      <td>43174.081662</td>\n",
       "      <td>85332.794407</td>\n",
       "      <td>1.745870e+08</td>\n",
       "      <td>POLYGON ((574316.737 442986.823, 574315.268 44...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>669</th>\n",
       "      <td>000028</td>\n",
       "      <td>PREC_28</td>\n",
       "      <td>72</td>\n",
       "      <td>36</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DIVIDE GRANGE HALL</td>\n",
       "      <td>Silver Bow</td>\n",
       "      <td>1</td>\n",
       "      <td>PREC_28</td>\n",
       "      <td>COUNTY GIS DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>5.847507e+08</td>\n",
       "      <td>677794.0</td>\n",
       "      <td>+45.8320114</td>\n",
       "      <td>-112.7908678</td>\n",
       "      <td>PREC_28</td>\n",
       "      <td>144518.697896</td>\n",
       "      <td>140460.789121</td>\n",
       "      <td>5.836593e+08</td>\n",
       "      <td>POLYGON ((361838.634 188651.566, 361838.626 18...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>670 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     NUMBER                 NAME HOUSE SENATE  POLLCODE  \\\n",
       "0    000001   #1 Precinct - West    27     14       NaN   \n",
       "1    000001         1-HERON-HD13    13      7       NaN   \n",
       "2    000001             1 WESTBY    34     17       NaN   \n",
       "3    000001  COLUMBUS PRECINCT 1    57     29       NaN   \n",
       "4    000001              FORTINE     2      1       NaN   \n",
       "..      ...                  ...   ...    ...       ...   \n",
       "665  000009          BIG SANDY 9    27     14       NaN   \n",
       "666  000001        FORT BENTON 1    27     14       NaN   \n",
       "667  000003          GERALDINE 3    27     14       NaN   \n",
       "668  000005          ROCKY BOY 5    32     16       NaN   \n",
       "669  000028              PREC_28    72     36       NaN   \n",
       "\n",
       "                                          POLLINGPLA      COUNTY COUNTYCODE  \\\n",
       "0                                        CJI ELE GYM     Liberty         48   \n",
       "1                             HERON COMMUNITY CENTER     Sanders         35   \n",
       "2                              WESTBY COMMUNITY HALL    Sheridan         34   \n",
       "3                               STILLWATER PAVILLION  Stillwater         32   \n",
       "4    TREGO-FORTINE-STRYKER VOLUNTEER FIRE DEPARTMENT     Lincoln         56   \n",
       "..                                               ...         ...        ...   \n",
       "665                              BIG SANDY TOWN HALL    Chouteau         19   \n",
       "666                           FORT BENTON ELEMENTARY    Chouteau         19   \n",
       "667                         GERALDINE SENIOR CITIZEN    Chouteau         19   \n",
       "668                          NEW STONE CHILD COLLEGE    Chouteau         19   \n",
       "669                               DIVIDE GRANGE HALL  Silver Bow          1   \n",
       "\n",
       "              SOSPRECINC                        SOURCE  ... FUNCSTAT20  \\\n",
       "0     #1 Precinct - West          2010 CENSUS GIS DATA  ...          N   \n",
       "1           1-HERON-HD13               COUNTY GIS DATA  ...          S   \n",
       "2               1 WESTBY     DIGITIZED FROM COUNTY MAP  ...          N   \n",
       "3    COLUMBUS PRECINCT 1               COUNTY GIS DATA  ...          N   \n",
       "4                FORTINE               COUNTY GIS DATA  ...          N   \n",
       "..                   ...                           ...  ...        ...   \n",
       "665          BIG SANDY 9  ALIGNED WITH HOUSE DISTRICTS  ...          N   \n",
       "666        FORT BENTON 1     DIGITIZED FROM COUNTY MAP  ...          N   \n",
       "667          GERALDINE 3     DIGITIZED FROM COUNTY MAP  ...          N   \n",
       "668          ROCKY BOY 5  ALIGNED WITH HOUSE DISTRICTS  ...          N   \n",
       "669              PREC_28               COUNTY GIS DATA  ...          N   \n",
       "\n",
       "          ALAND20    AWATER20   INTPTLAT20    INTPTLON20           PrecinctNa  \\\n",
       "0    1.740307e+09  40732356.0  +48.5306227  -111.1562453   #1 Precinct - West   \n",
       "1    2.758566e+08   5115721.0  +48.0717721  -115.9641869         1-HERON-HD13   \n",
       "2    7.192383e+08  24529367.0  +48.8563682  -104.1708300             1 WESTBY   \n",
       "3    8.983969e+08   8611530.0  +45.6436291  -109.2706396  COLUMBUS PRECINCT 1   \n",
       "4    2.236212e+08   1841272.0  +48.7788643  -114.8481719              FORTINE   \n",
       "..            ...         ...          ...           ...                  ...   \n",
       "665  2.171519e+09  11985218.0  +48.0381231  -109.9317765          BIG SANDY 9   \n",
       "666  4.485305e+08   4042520.0  +47.7719158  -110.5648354        FORT BENTON 1   \n",
       "667  2.128091e+09  19561284.0  +47.6625301  -110.1780981          GERALDINE 3   \n",
       "668  1.795011e+08    430802.0  +48.2487780  -109.9045952          ROCKY BOY 5   \n",
       "669  5.847507e+08    677794.0  +45.8320114  -112.7908678              PREC_28   \n",
       "\n",
       "             Acres     SHAPE_Leng    SHAPE_Area  \\\n",
       "0    440107.371086  277799.685711  1.780194e+09   \n",
       "1     69455.096056   89100.974828  2.808300e+08   \n",
       "2    183654.506975  152032.440373  7.430920e+08   \n",
       "3    224302.648086  211020.905061  9.071316e+08   \n",
       "4     55690.792537   77785.282402  2.253137e+08   \n",
       "..             ...            ...           ...   \n",
       "665  540833.409987  249831.476944  2.186658e+09   \n",
       "666  112493.886441  114653.518682  4.547761e+08   \n",
       "667  531182.844968  262935.020498  2.147285e+09   \n",
       "668   43174.081662   85332.794407  1.745870e+08   \n",
       "669  144518.697896  140460.789121  5.836593e+08   \n",
       "\n",
       "                                              geometry  \n",
       "0    POLYGON ((489630.928 519814.997, 489630.422 51...  \n",
       "1    POLYGON ((115169.674 460413.777, 115204.854 46...  \n",
       "2    POLYGON ((999335.715 530475.725, 999345.275 53...  \n",
       "3    POLYGON ((618565.054 173709.864, 618971.105 17...  \n",
       "4    POLYGON ((195242.148 521890.043, 195385.515 52...  \n",
       "..                                                 ...  \n",
       "665  POLYGON ((567465.832 443144.367, 567463.389 44...  \n",
       "666  POLYGON ((519180.536 403061.958, 519271.178 40...  \n",
       "667  POLYGON ((555986.800 412261.985, 555993.230 41...  \n",
       "668  POLYGON ((574316.737 442986.823, 574315.268 44...  \n",
       "669  POLYGON ((361838.634 188651.566, 361838.626 18...  \n",
       "\n",
       "[670 rows x 34 columns]"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "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>NUMBER</th>\n",
       "      <th>NAME</th>\n",
       "      <th>HOUSE</th>\n",
       "      <th>SENATE</th>\n",
       "      <th>POLLCODE</th>\n",
       "      <th>POLLINGPLA</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>COUNTYCODE</th>\n",
       "      <th>SOSPRECINC</th>\n",
       "      <th>SOURCE</th>\n",
       "      <th>...</th>\n",
       "      <th>FUNCSTAT20</th>\n",
       "      <th>ALAND20</th>\n",
       "      <th>AWATER20</th>\n",
       "      <th>INTPTLAT20</th>\n",
       "      <th>INTPTLON20</th>\n",
       "      <th>PrecinctNa</th>\n",
       "      <th>Acres</th>\n",
       "      <th>SHAPE_Leng</th>\n",
       "      <th>SHAPE_Area</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>000003</td>\n",
       "      <td>PRECINCT 3</td>\n",
       "      <td>39</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HAUGO CENTER</td>\n",
       "      <td>Rosebud</td>\n",
       "      <td>29</td>\n",
       "      <td>PRECINCT 3</td>\n",
       "      <td>CREATED FROM WEB APP DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>1.734217e+06</td>\n",
       "      <td>41934.0</td>\n",
       "      <td>+46.2706407</td>\n",
       "      <td>-106.6668347</td>\n",
       "      <td>PRECINCT 3</td>\n",
       "      <td>439.761756</td>\n",
       "      <td>11837.060515</td>\n",
       "      <td>1.777784e+06</td>\n",
       "      <td>POLYGON ((819162.678 228808.877, 818734.355 22...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>000006</td>\n",
       "      <td>PRECINCT 6</td>\n",
       "      <td>39</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HAUGO CENTER</td>\n",
       "      <td>Rosebud</td>\n",
       "      <td>29</td>\n",
       "      <td>PRECINCT 6</td>\n",
       "      <td>CREATED FROM WEB APP DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>1.248508e+06</td>\n",
       "      <td>4320.0</td>\n",
       "      <td>+46.2630936</td>\n",
       "      <td>-106.6868077</td>\n",
       "      <td>PRECINCT 6</td>\n",
       "      <td>309.551959</td>\n",
       "      <td>5430.105349</td>\n",
       "      <td>1.251405e+06</td>\n",
       "      <td>POLYGON ((816967.593 228396.197, 816997.402 22...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>000007</td>\n",
       "      <td>PRECINCT 7</td>\n",
       "      <td>41</td>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ASHLAND PUBLIC SCHOOL</td>\n",
       "      <td>Rosebud</td>\n",
       "      <td>29</td>\n",
       "      <td>PRECINCT 7</td>\n",
       "      <td>CREATED FROM WEB APP DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>1.069300e+09</td>\n",
       "      <td>163786.0</td>\n",
       "      <td>+45.3416093</td>\n",
       "      <td>-106.4482609</td>\n",
       "      <td>PRECINCT 7</td>\n",
       "      <td>264377.074458</td>\n",
       "      <td>164615.022988</td>\n",
       "      <td>1.069535e+09</td>\n",
       "      <td>POLYGON ((850776.573 142222.085, 851035.863 14...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>000010</td>\n",
       "      <td>PRECINCT 10</td>\n",
       "      <td>39</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ROSEBUD SCHOOL</td>\n",
       "      <td>Rosebud</td>\n",
       "      <td>29</td>\n",
       "      <td>PRECINCT 10</td>\n",
       "      <td>CREATED FROM WEB APP DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>2.897899e+09</td>\n",
       "      <td>16293922.0</td>\n",
       "      <td>+46.5855326</td>\n",
       "      <td>-106.4986561</td>\n",
       "      <td>PRECINCT 10</td>\n",
       "      <td>719984.770457</td>\n",
       "      <td>237810.755688</td>\n",
       "      <td>2.910255e+09</td>\n",
       "      <td>POLYGON ((860145.753 293724.016, 860165.876 29...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>000011</td>\n",
       "      <td>PRECINCT 11</td>\n",
       "      <td>39</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ROSEBUD SCHOOL</td>\n",
       "      <td>Rosebud</td>\n",
       "      <td>29</td>\n",
       "      <td>PRECINCT 11</td>\n",
       "      <td>CREATED FROM WEB APP DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>1.057975e+09</td>\n",
       "      <td>2567057.0</td>\n",
       "      <td>+46.0838263</td>\n",
       "      <td>-106.3402506</td>\n",
       "      <td>PRECINCT 11</td>\n",
       "      <td>261795.876571</td>\n",
       "      <td>148630.107190</td>\n",
       "      <td>1.058438e+09</td>\n",
       "      <td>POLYGON ((857705.668 228885.315, 857722.503 22...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>000015</td>\n",
       "      <td>PRECINCT 15</td>\n",
       "      <td>41</td>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORTHERN CHEYENNE TRIBAL BUILDING</td>\n",
       "      <td>Rosebud</td>\n",
       "      <td>29</td>\n",
       "      <td>PRECINCT 15</td>\n",
       "      <td>CREATED FROM WEB APP DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>5.885473e+08</td>\n",
       "      <td>46433.0</td>\n",
       "      <td>+45.5340700</td>\n",
       "      <td>-106.6099908</td>\n",
       "      <td>PRECINCT 15</td>\n",
       "      <td>145896.001176</td>\n",
       "      <td>149134.815204</td>\n",
       "      <td>5.900398e+08</td>\n",
       "      <td>POLYGON ((836201.472 164519.121, 836603.181 16...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>000017</td>\n",
       "      <td>PRECINCT 17</td>\n",
       "      <td>41</td>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ASHLAND PUBLIC SCHOOL</td>\n",
       "      <td>Rosebud</td>\n",
       "      <td>29</td>\n",
       "      <td>PRECINCT 17</td>\n",
       "      <td>CREATED FROM WEB APP DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>7.158169e+08</td>\n",
       "      <td>12586.0</td>\n",
       "      <td>+45.6373375</td>\n",
       "      <td>-106.3465808</td>\n",
       "      <td>PRECINCT 17</td>\n",
       "      <td>176888.567016</td>\n",
       "      <td>143807.770774</td>\n",
       "      <td>7.154368e+08</td>\n",
       "      <td>POLYGON ((844777.684 141769.246, 844775.617 14...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>000020</td>\n",
       "      <td>PRECINCT 20</td>\n",
       "      <td>39</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HAUGO CENTER</td>\n",
       "      <td>Rosebud</td>\n",
       "      <td>29</td>\n",
       "      <td>PRECINCT 20</td>\n",
       "      <td>CREATED FROM WEB APP DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>1.871975e+09</td>\n",
       "      <td>21190732.0</td>\n",
       "      <td>+46.4862156</td>\n",
       "      <td>-106.8780844</td>\n",
       "      <td>PRECINCT 20</td>\n",
       "      <td>467884.301486</td>\n",
       "      <td>265210.610902</td>\n",
       "      <td>1.891379e+09</td>\n",
       "      <td>POLYGON ((810043.883 280813.649, 811082.020 25...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>000021</td>\n",
       "      <td>PRECINCT 21</td>\n",
       "      <td>39</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HAUGO CENTER</td>\n",
       "      <td>Rosebud</td>\n",
       "      <td>29</td>\n",
       "      <td>PRECINCT 21</td>\n",
       "      <td>CREATED FROM WEB APP DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>8.838560e+08</td>\n",
       "      <td>203106.0</td>\n",
       "      <td>+46.1732061</td>\n",
       "      <td>-106.6667917</td>\n",
       "      <td>PRECINCT 21</td>\n",
       "      <td>218437.745266</td>\n",
       "      <td>137029.501737</td>\n",
       "      <td>8.830391e+08</td>\n",
       "      <td>POLYGON ((828864.901 228387.623, 829059.694 22...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>000026</td>\n",
       "      <td>PRECINCT 26</td>\n",
       "      <td>39</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>INGOMAR SCHOOL</td>\n",
       "      <td>Rosebud</td>\n",
       "      <td>29</td>\n",
       "      <td>PRECINCT 26</td>\n",
       "      <td>CREATED FROM WEB APP DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>2.263622e+09</td>\n",
       "      <td>2846101.0</td>\n",
       "      <td>+46.6862159</td>\n",
       "      <td>-107.4477709</td>\n",
       "      <td>PRECINCT 26</td>\n",
       "      <td>560135.188743</td>\n",
       "      <td>246948.137002</td>\n",
       "      <td>2.264120e+09</td>\n",
       "      <td>POLYGON ((784473.150 291184.510, 784516.603 28...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <td>000030</td>\n",
       "      <td>PRECINCT 30</td>\n",
       "      <td>41</td>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>COLSTRIP CITY HALL</td>\n",
       "      <td>Rosebud</td>\n",
       "      <td>29</td>\n",
       "      <td>PRECINCT 30</td>\n",
       "      <td>CREATED FROM WEB APP DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>1.034175e+09</td>\n",
       "      <td>0.0</td>\n",
       "      <td>+45.7889325</td>\n",
       "      <td>-106.6195018</td>\n",
       "      <td>PRECINCT 30</td>\n",
       "      <td>255311.225602</td>\n",
       "      <td>164356.748708</td>\n",
       "      <td>1.032420e+09</td>\n",
       "      <td>POLYGON ((844620.765 187216.653, 844655.238 18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>000032</td>\n",
       "      <td>PRECINCT 32</td>\n",
       "      <td>39</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>COLSTRIP CITY HALL</td>\n",
       "      <td>Rosebud</td>\n",
       "      <td>29</td>\n",
       "      <td>PRECINCT 32</td>\n",
       "      <td>CREATED FROM WEB APP DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>5.848608e+08</td>\n",
       "      <td>864250.0</td>\n",
       "      <td>+45.9537239</td>\n",
       "      <td>-106.7025675</td>\n",
       "      <td>PRECINCT 32</td>\n",
       "      <td>144664.331058</td>\n",
       "      <td>130881.779431</td>\n",
       "      <td>5.849966e+08</td>\n",
       "      <td>POLYGON ((832091.425 194792.715, 832285.085 18...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     NUMBER         NAME HOUSE SENATE  POLLCODE  \\\n",
       "76   000003   PRECINCT 3    39     20       NaN   \n",
       "140  000006   PRECINCT 6    39     20       NaN   \n",
       "161  000007   PRECINCT 7    41     21       NaN   \n",
       "208  000010  PRECINCT 10    39     20       NaN   \n",
       "222  000011  PRECINCT 11    39     20       NaN   \n",
       "272  000015  PRECINCT 15    41     21       NaN   \n",
       "290  000017  PRECINCT 17    41     21       NaN   \n",
       "314  000020  PRECINCT 20    39     20       NaN   \n",
       "323  000021  PRECINCT 21    39     20       NaN   \n",
       "354  000026  PRECINCT 26    39     20       NaN   \n",
       "372  000030  PRECINCT 30    41     21       NaN   \n",
       "378  000032  PRECINCT 32    39     20       NaN   \n",
       "\n",
       "                            POLLINGPLA   COUNTY COUNTYCODE   SOSPRECINC  \\\n",
       "76                        HAUGO CENTER  Rosebud         29   PRECINCT 3   \n",
       "140                       HAUGO CENTER  Rosebud         29   PRECINCT 6   \n",
       "161              ASHLAND PUBLIC SCHOOL  Rosebud         29   PRECINCT 7   \n",
       "208                     ROSEBUD SCHOOL  Rosebud         29  PRECINCT 10   \n",
       "222                     ROSEBUD SCHOOL  Rosebud         29  PRECINCT 11   \n",
       "272  NORTHERN CHEYENNE TRIBAL BUILDING  Rosebud         29  PRECINCT 15   \n",
       "290              ASHLAND PUBLIC SCHOOL  Rosebud         29  PRECINCT 17   \n",
       "314                       HAUGO CENTER  Rosebud         29  PRECINCT 20   \n",
       "323                       HAUGO CENTER  Rosebud         29  PRECINCT 21   \n",
       "354                     INGOMAR SCHOOL  Rosebud         29  PRECINCT 26   \n",
       "372                 COLSTRIP CITY HALL  Rosebud         29  PRECINCT 30   \n",
       "378                 COLSTRIP CITY HALL  Rosebud         29  PRECINCT 32   \n",
       "\n",
       "                        SOURCE  ... FUNCSTAT20       ALAND20    AWATER20  \\\n",
       "76   CREATED FROM WEB APP DATA  ...          N  1.734217e+06     41934.0   \n",
       "140  CREATED FROM WEB APP DATA  ...          N  1.248508e+06      4320.0   \n",
       "161  CREATED FROM WEB APP DATA  ...          N  1.069300e+09    163786.0   \n",
       "208  CREATED FROM WEB APP DATA  ...          N  2.897899e+09  16293922.0   \n",
       "222  CREATED FROM WEB APP DATA  ...          N  1.057975e+09   2567057.0   \n",
       "272  CREATED FROM WEB APP DATA  ...          N  5.885473e+08     46433.0   \n",
       "290  CREATED FROM WEB APP DATA  ...          N  7.158169e+08     12586.0   \n",
       "314  CREATED FROM WEB APP DATA  ...          N  1.871975e+09  21190732.0   \n",
       "323  CREATED FROM WEB APP DATA  ...          N  8.838560e+08    203106.0   \n",
       "354  CREATED FROM WEB APP DATA  ...          N  2.263622e+09   2846101.0   \n",
       "372  CREATED FROM WEB APP DATA  ...          N  1.034175e+09         0.0   \n",
       "378  CREATED FROM WEB APP DATA  ...          N  5.848608e+08    864250.0   \n",
       "\n",
       "      INTPTLAT20    INTPTLON20   PrecinctNa          Acres     SHAPE_Leng  \\\n",
       "76   +46.2706407  -106.6668347   PRECINCT 3     439.761756   11837.060515   \n",
       "140  +46.2630936  -106.6868077   PRECINCT 6     309.551959    5430.105349   \n",
       "161  +45.3416093  -106.4482609   PRECINCT 7  264377.074458  164615.022988   \n",
       "208  +46.5855326  -106.4986561  PRECINCT 10  719984.770457  237810.755688   \n",
       "222  +46.0838263  -106.3402506  PRECINCT 11  261795.876571  148630.107190   \n",
       "272  +45.5340700  -106.6099908  PRECINCT 15  145896.001176  149134.815204   \n",
       "290  +45.6373375  -106.3465808  PRECINCT 17  176888.567016  143807.770774   \n",
       "314  +46.4862156  -106.8780844  PRECINCT 20  467884.301486  265210.610902   \n",
       "323  +46.1732061  -106.6667917  PRECINCT 21  218437.745266  137029.501737   \n",
       "354  +46.6862159  -107.4477709  PRECINCT 26  560135.188743  246948.137002   \n",
       "372  +45.7889325  -106.6195018  PRECINCT 30  255311.225602  164356.748708   \n",
       "378  +45.9537239  -106.7025675  PRECINCT 32  144664.331058  130881.779431   \n",
       "\n",
       "       SHAPE_Area                                           geometry  \n",
       "76   1.777784e+06  POLYGON ((819162.678 228808.877, 818734.355 22...  \n",
       "140  1.251405e+06  POLYGON ((816967.593 228396.197, 816997.402 22...  \n",
       "161  1.069535e+09  POLYGON ((850776.573 142222.085, 851035.863 14...  \n",
       "208  2.910255e+09  POLYGON ((860145.753 293724.016, 860165.876 29...  \n",
       "222  1.058438e+09  POLYGON ((857705.668 228885.315, 857722.503 22...  \n",
       "272  5.900398e+08  POLYGON ((836201.472 164519.121, 836603.181 16...  \n",
       "290  7.154368e+08  POLYGON ((844777.684 141769.246, 844775.617 14...  \n",
       "314  1.891379e+09  POLYGON ((810043.883 280813.649, 811082.020 25...  \n",
       "323  8.830391e+08  POLYGON ((828864.901 228387.623, 829059.694 22...  \n",
       "354  2.264120e+09  POLYGON ((784473.150 291184.510, 784516.603 28...  \n",
       "372  1.032420e+09  POLYGON ((844620.765 187216.653, 844655.238 18...  \n",
       "378  5.849966e+08  POLYGON ((832091.425 194792.715, 832285.085 18...  \n",
       "\n",
       "[12 rows x 34 columns]"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# code to do read in current legislative districts \n",
    "mt_data = pd.read_csv('data/election/mt_vtd_elex.csv')\n",
    "mt_assign = gpd.read_file('data/election/MontanaVotingPrecincts_shp')\n",
    "mt_graph = Graph.from_json('data/election/mt_vtd_connected.json')\n",
    "\n",
    "\n",
    "elections = ['G20PRERTRU', 'G20PREDBID', 'G20USSRDAI', 'G20USSDBUL', 'G20GOVRGIA', 'G20GOVDCOO', 'G18USSRROS', 'G18USSDTES']\n",
    "\n",
    "for node in mt_graph.nodes:\n",
    "    geo_id = str(mt_graph.nodes[node]['GEOCODE'])\n",
    "    for election in elections:\n",
    "        mt_graph.nodes[node][election] = mt_data[mt_data['GEOCODE'] == geo_id][election].iloc[0]\n",
    "    \n",
    "    if mt_assign[mt_assign['GEOID20'] == geo_id].empty:\n",
    "        print(node, geo_id)\n",
    "    else:\n",
    "        mt_graph.nodes[node]['HOUSE'] = mt_assign[mt_assign['GEOID20'] == geo_id]['HOUSE'].iloc[0]\n",
    "        mt_graph.nodes[node]['SENATE'] = mt_assign[mt_assign['GEOID20'] == geo_id]['SENATE'].iloc[0]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'boundary_node': False,\n",
       " 'area': 0.42112792871900284,\n",
       " 'ALAND20': 3432859260,\n",
       " 'ASIANPOP20': 0,\n",
       " 'WPOP20': 2,\n",
       " 'NWBHPOP20': 0,\n",
       " 'NHPIVAP20': 0,\n",
       " 'ASIANVAP20': 0,\n",
       " 'APBPOP20': 0,\n",
       " 'FILEID': 'PLST',\n",
       " 'GEOID20': '30029NAHD15',\n",
       " 'NAMELSAD20': 'NA-HD15',\n",
       " 'APAMIPOP20': 0,\n",
       " 'GEOCODE': '30029NAHD15',\n",
       " 'APAMIVAP20': 0,\n",
       " 'OTHERVAP20': 0,\n",
       " '2MOREPOP20': 0,\n",
       " 'AWATER20': 64637954,\n",
       " 'VTDI20': 'A',\n",
       " 'OTHERPOP20': 0,\n",
       " 'NHPIPOP20': 0,\n",
       " 'FUNCSTAT20': 'N',\n",
       " 'TOTPOP20': 2,\n",
       " 'COUNTYFP20': '029',\n",
       " 'BVAP20': 0,\n",
       " 'CHARITER': 0,\n",
       " 'WVAP20': 2,\n",
       " 'NAME20': 'NA-HD15',\n",
       " 'AMINVAP20': 0,\n",
       " 'VTDST20': 'NAHD15',\n",
       " 'LSAD20': '00',\n",
       " '2MOREVAP20': 0,\n",
       " 'VAP20': 2,\n",
       " 'CIFSN': 1,\n",
       " 'STUSAB': 'MT',\n",
       " 'NWBHVAP20': 0,\n",
       " 'STATEFP20': '30',\n",
       " 'LOGRECNO': 13151,\n",
       " 'MTFCC20': 'G5240',\n",
       " 'INTPTLON20': '-113.3985315',\n",
       " 'BPOP20': 0,\n",
       " 'APAVAP20': 0,\n",
       " 'AMINPOP20': 0,\n",
       " 'HVAP20': 0,\n",
       " 'APBVAP20': 0,\n",
       " 'SUMLEV': 700,\n",
       " 'DOJBVAP20': 0,\n",
       " 'APAPOP20': 0,\n",
       " 'HISP20': 0,\n",
       " 'INTPTLAT20': '+47.9482835'}"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mt_graph.nodes[550]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['STATEFP10', 'COUNTYFP10', 'COUNTY', 'NAME', 'SOSPRECINC', 'G18USSRROS',\n",
       "       'G18USSDTES', 'G18USSLBRE', 'G18HALRGIA', 'G18HALDWIL', 'G18HALLSWA',\n",
       "       'G18CSCRGRE', 'G18CSCDREN', 'G18CSCLROO', 'geometry'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "elex_2018 =gpd.read_file('data/election/mt_vest_18')\n",
    "elex_2018.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "mt_vtd = gpd.read_file(\"data/election/mt_vtd\")\n",
    "election_2020 = gpd.read_file(\"data/election/mt_vest_20\")\n",
    "election_2020['NAMELSAD20'] = election_2020['SOSPRECINC']\n",
    "election_2020['COUNTYFP20'] = election_2020['COUNTYFP10']\n",
    "cols = ['G20PRERTRU', 'G20PREDBID', 'G20USSRDAI', 'G20USSDBUL', 'G20GOVRGIA', 'G20GOVDCOO', 'NAMELSAD20', 'COUNTYFP20'] \n",
    "election_2020 = election_2020[cols]\n",
    "election_2020\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['STATEFP10', 'COUNTYFP10', 'COUNTY', 'NAME', 'SOSPRECINC', 'G20PRERTRU',\n",
       "       'G20PREDBID', 'G20PRELJOR', 'G20USSRDAI', 'G20USSDBUL', 'G20HALRROS',\n",
       "       'G20HALDWIL', 'G20GOVRGIA', 'G20GOVDCOO', 'G20GOVLBIS', 'G20ATGRKNU',\n",
       "       'G20ATGDGRA', 'G20SOSRJAC', 'G20SOSDBEN', 'G20AUDRDOW', 'G20AUDDMOR',\n",
       "       'G20AUDLROO', 'G20SPIRARN', 'G20SPIDROM', 'G20SPILLEA', 'geometry'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "election_2020.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>NHPIVAP20</th>\n",
       "      <th>STUSAB</th>\n",
       "      <th>BVAP20</th>\n",
       "      <th>OTHERPOP20</th>\n",
       "      <th>GEOCODE</th>\n",
       "      <th>WVAP20</th>\n",
       "      <th>APAMIVAP20</th>\n",
       "      <th>APAPOP20</th>\n",
       "      <th>MTFCC20</th>\n",
       "      <th>NAMELSAD20</th>\n",
       "      <th>...</th>\n",
       "      <th>HVAP20</th>\n",
       "      <th>COPOP20</th>\n",
       "      <th>COUNTYFP20</th>\n",
       "      <th>CHARITER</th>\n",
       "      <th>INTPTLAT20</th>\n",
       "      <th>NWBHPOP20</th>\n",
       "      <th>VAP20</th>\n",
       "      <th>NBAPAPOP20</th>\n",
       "      <th>LOGRECNO</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>8</td>\n",
       "      <td>25</td>\n",
       "      <td>30049000027</td>\n",
       "      <td>2304</td>\n",
       "      <td>114</td>\n",
       "      <td>75</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 27</td>\n",
       "      <td>...</td>\n",
       "      <td>86</td>\n",
       "      <td>183</td>\n",
       "      <td>049</td>\n",
       "      <td>0</td>\n",
       "      <td>+46.7492670</td>\n",
       "      <td>119</td>\n",
       "      <td>2610</td>\n",
       "      <td>74</td>\n",
       "      <td>13290</td>\n",
       "      <td>POLYGON ((-112.08980 46.78522, -112.05939 46.7...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>MT</td>\n",
       "      <td>3</td>\n",
       "      <td>14</td>\n",
       "      <td>30049000002</td>\n",
       "      <td>1611</td>\n",
       "      <td>78</td>\n",
       "      <td>29</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 02</td>\n",
       "      <td>...</td>\n",
       "      <td>58</td>\n",
       "      <td>84</td>\n",
       "      <td>049</td>\n",
       "      <td>0</td>\n",
       "      <td>+46.6818204</td>\n",
       "      <td>65</td>\n",
       "      <td>1804</td>\n",
       "      <td>29</td>\n",
       "      <td>13265</td>\n",
       "      <td>POLYGON ((-111.91499 46.66099, -111.91496 46.6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>30049000004</td>\n",
       "      <td>1953</td>\n",
       "      <td>87</td>\n",
       "      <td>41</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 04</td>\n",
       "      <td>...</td>\n",
       "      <td>55</td>\n",
       "      <td>120</td>\n",
       "      <td>049</td>\n",
       "      <td>0</td>\n",
       "      <td>+46.6526595</td>\n",
       "      <td>65</td>\n",
       "      <td>2166</td>\n",
       "      <td>39</td>\n",
       "      <td>13267</td>\n",
       "      <td>POLYGON ((-112.05145 46.67509, -112.05082 46.6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>MT</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>30049000024</td>\n",
       "      <td>1708</td>\n",
       "      <td>52</td>\n",
       "      <td>41</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 24</td>\n",
       "      <td>...</td>\n",
       "      <td>42</td>\n",
       "      <td>96</td>\n",
       "      <td>049</td>\n",
       "      <td>0</td>\n",
       "      <td>+46.6068815</td>\n",
       "      <td>67</td>\n",
       "      <td>1861</td>\n",
       "      <td>40</td>\n",
       "      <td>13287</td>\n",
       "      <td>POLYGON ((-112.05321 46.61101, -112.05218 46.6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>MT</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>30049000003</td>\n",
       "      <td>1472</td>\n",
       "      <td>64</td>\n",
       "      <td>10</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 03</td>\n",
       "      <td>...</td>\n",
       "      <td>30</td>\n",
       "      <td>63</td>\n",
       "      <td>049</td>\n",
       "      <td>0</td>\n",
       "      <td>+46.6450345</td>\n",
       "      <td>50</td>\n",
       "      <td>1593</td>\n",
       "      <td>10</td>\n",
       "      <td>13266</td>\n",
       "      <td>POLYGON ((-112.03212 46.65314, -112.03167 46.6...</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>661</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>30035000013</td>\n",
       "      <td>19</td>\n",
       "      <td>323</td>\n",
       "      <td>1</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 13</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>15</td>\n",
       "      <td>035</td>\n",
       "      <td>0</td>\n",
       "      <td>+48.5561567</td>\n",
       "      <td>443</td>\n",
       "      <td>346</td>\n",
       "      <td>0</td>\n",
       "      <td>13200</td>\n",
       "      <td>POLYGON ((-113.02062 48.55236, -113.02062 48.5...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>662</th>\n",
       "      <td>3</td>\n",
       "      <td>MT</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>30035000001</td>\n",
       "      <td>436</td>\n",
       "      <td>179</td>\n",
       "      <td>17</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 01</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>32</td>\n",
       "      <td>035</td>\n",
       "      <td>0</td>\n",
       "      <td>+48.6282185</td>\n",
       "      <td>237</td>\n",
       "      <td>648</td>\n",
       "      <td>17</td>\n",
       "      <td>13188</td>\n",
       "      <td>POLYGON ((-112.33431 48.62732, -112.33327 48.6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>663</th>\n",
       "      <td>1</td>\n",
       "      <td>MT</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>30035000003</td>\n",
       "      <td>362</td>\n",
       "      <td>213</td>\n",
       "      <td>18</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 03</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>26</td>\n",
       "      <td>035</td>\n",
       "      <td>0</td>\n",
       "      <td>+48.6352851</td>\n",
       "      <td>259</td>\n",
       "      <td>606</td>\n",
       "      <td>18</td>\n",
       "      <td>13190</td>\n",
       "      <td>POLYGON ((-112.34681 48.63364, -112.34658 48.6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>664</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>30019000002</td>\n",
       "      <td>141</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PRECINCT #2</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>019</td>\n",
       "      <td>0</td>\n",
       "      <td>+48.7675768</td>\n",
       "      <td>4</td>\n",
       "      <td>155</td>\n",
       "      <td>6</td>\n",
       "      <td>13066</td>\n",
       "      <td>POLYGON ((-105.32304 48.89555, -105.32294 48.8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>665</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>30019000003</td>\n",
       "      <td>352</td>\n",
       "      <td>22</td>\n",
       "      <td>21</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PRECINCT #3</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>13</td>\n",
       "      <td>019</td>\n",
       "      <td>0</td>\n",
       "      <td>+48.7851808</td>\n",
       "      <td>15</td>\n",
       "      <td>386</td>\n",
       "      <td>20</td>\n",
       "      <td>13067</td>\n",
       "      <td>POLYGON ((-106.15206 48.86723, -106.15192 48.8...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>666 rows × 53 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     NHPIVAP20 STUSAB  BVAP20  OTHERPOP20      GEOCODE  WVAP20  APAMIVAP20  \\\n",
       "0            0     MT       8          25  30049000027    2304         114   \n",
       "1            1     MT       3          14  30049000002    1611          78   \n",
       "2            0     MT       5          10  30049000004    1953          87   \n",
       "3            2     MT       9           6  30049000024    1708          52   \n",
       "4            1     MT       1           6  30049000003    1472          64   \n",
       "..         ...    ...     ...         ...          ...     ...         ...   \n",
       "661          0     MT       0           0  30035000013      19         323   \n",
       "662          3     MT       3           0  30035000001     436         179   \n",
       "663          1     MT       1           4  30035000003     362         213   \n",
       "664          0     MT       0           0  30019000002     141           3   \n",
       "665          0     MT       0           0  30019000003     352          22   \n",
       "\n",
       "     APAPOP20 MTFCC20   NAMELSAD20  ... HVAP20  COPOP20  COUNTYFP20 CHARITER  \\\n",
       "0          75   G5240       PCT 27  ...     86      183         049        0   \n",
       "1          29   G5240       PCT 02  ...     58       84         049        0   \n",
       "2          41   G5240       PCT 04  ...     55      120         049        0   \n",
       "3          41   G5240       PCT 24  ...     42       96         049        0   \n",
       "4          10   G5240       PCT 03  ...     30       63         049        0   \n",
       "..        ...     ...          ...  ...    ...      ...         ...      ...   \n",
       "661         1   G5240       PCT 13  ...      4       15         035        0   \n",
       "662        17   G5240       PCT 01  ...     15       32         035        0   \n",
       "663        18   G5240       PCT 03  ...     10       26         035        0   \n",
       "664         6   G5240  PRECINCT #2  ...      3       10         019        0   \n",
       "665        21   G5240  PRECINCT #3  ...      6       13         019        0   \n",
       "\n",
       "      INTPTLAT20 NWBHPOP20  VAP20  NBAPAPOP20  LOGRECNO  \\\n",
       "0    +46.7492670       119   2610          74     13290   \n",
       "1    +46.6818204        65   1804          29     13265   \n",
       "2    +46.6526595        65   2166          39     13267   \n",
       "3    +46.6068815        67   1861          40     13287   \n",
       "4    +46.6450345        50   1593          10     13266   \n",
       "..           ...       ...    ...         ...       ...   \n",
       "661  +48.5561567       443    346           0     13200   \n",
       "662  +48.6282185       237    648          17     13188   \n",
       "663  +48.6352851       259    606          18     13190   \n",
       "664  +48.7675768         4    155           6     13066   \n",
       "665  +48.7851808        15    386          20     13067   \n",
       "\n",
       "                                              geometry  \n",
       "0    POLYGON ((-112.08980 46.78522, -112.05939 46.7...  \n",
       "1    POLYGON ((-111.91499 46.66099, -111.91496 46.6...  \n",
       "2    POLYGON ((-112.05145 46.67509, -112.05082 46.6...  \n",
       "3    POLYGON ((-112.05321 46.61101, -112.05218 46.6...  \n",
       "4    POLYGON ((-112.03212 46.65314, -112.03167 46.6...  \n",
       "..                                                 ...  \n",
       "661  POLYGON ((-113.02062 48.55236, -113.02062 48.5...  \n",
       "662  POLYGON ((-112.33431 48.62732, -112.33327 48.6...  \n",
       "663  POLYGON ((-112.34681 48.63364, -112.34658 48.6...  \n",
       "664  POLYGON ((-105.32304 48.89555, -105.32294 48.8...  \n",
       "665  POLYGON ((-106.15206 48.86723, -106.15192 48.8...  \n",
       "\n",
       "[666 rows x 53 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mt_vtd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['STATEFP10', 'COUNTYFP10', 'COUNTY', 'NAME', 'SOSPRECINC', 'G20PRERTRU',\n",
       "       'G20PREDBID', 'G20PRELJOR', 'G20USSRDAI', 'G20USSDBUL', 'G20HALRROS',\n",
       "       'G20HALDWIL', 'G20GOVRGIA', 'G20GOVDCOO', 'G20GOVLBIS', 'G20ATGRKNU',\n",
       "       'G20ATGDGRA', 'G20SOSRJAC', 'G20SOSDBEN', 'G20AUDRDOW', 'G20AUDDMOR',\n",
       "       'G20AUDLROO', 'G20SPIRARN', 'G20SPIDROM', 'G20SPILLEA', 'geometry'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "election_2020.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>NHPIVAP20</th>\n",
       "      <th>STUSAB</th>\n",
       "      <th>BVAP20</th>\n",
       "      <th>OTHERPOP20</th>\n",
       "      <th>GEOCODE</th>\n",
       "      <th>WVAP20</th>\n",
       "      <th>APAMIVAP20</th>\n",
       "      <th>APAPOP20</th>\n",
       "      <th>MTFCC20</th>\n",
       "      <th>...</th>\n",
       "      <th>VAP20</th>\n",
       "      <th>NBAPAPOP20</th>\n",
       "      <th>LOGRECNO</th>\n",
       "      <th>geometry</th>\n",
       "      <th>G20PRERTRU</th>\n",
       "      <th>G20PREDBID</th>\n",
       "      <th>G20USSRDAI</th>\n",
       "      <th>G20USSDBUL</th>\n",
       "      <th>G20GOVRGIA</th>\n",
       "      <th>G20GOVDCOO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>8</td>\n",
       "      <td>25</td>\n",
       "      <td>30049000027</td>\n",
       "      <td>2304</td>\n",
       "      <td>114</td>\n",
       "      <td>75</td>\n",
       "      <td>G5240</td>\n",
       "      <td>...</td>\n",
       "      <td>2610</td>\n",
       "      <td>74</td>\n",
       "      <td>13290</td>\n",
       "      <td>POLYGON ((-112.089801 46.785221, -112.059386 4...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>MT</td>\n",
       "      <td>3</td>\n",
       "      <td>14</td>\n",
       "      <td>30049000002</td>\n",
       "      <td>1611</td>\n",
       "      <td>78</td>\n",
       "      <td>29</td>\n",
       "      <td>G5240</td>\n",
       "      <td>...</td>\n",
       "      <td>1804</td>\n",
       "      <td>29</td>\n",
       "      <td>13265</td>\n",
       "      <td>POLYGON ((-111.914985 46.660990999999996, -111...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>30049000004</td>\n",
       "      <td>1953</td>\n",
       "      <td>87</td>\n",
       "      <td>41</td>\n",
       "      <td>G5240</td>\n",
       "      <td>...</td>\n",
       "      <td>2166</td>\n",
       "      <td>39</td>\n",
       "      <td>13267</td>\n",
       "      <td>POLYGON ((-112.051452 46.675087, -112.050822 4...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>MT</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>30049000024</td>\n",
       "      <td>1708</td>\n",
       "      <td>52</td>\n",
       "      <td>41</td>\n",
       "      <td>G5240</td>\n",
       "      <td>...</td>\n",
       "      <td>1861</td>\n",
       "      <td>40</td>\n",
       "      <td>13287</td>\n",
       "      <td>POLYGON ((-112.053208 46.611007, -112.052183 4...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>MT</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>30049000003</td>\n",
       "      <td>1472</td>\n",
       "      <td>64</td>\n",
       "      <td>10</td>\n",
       "      <td>G5240</td>\n",
       "      <td>...</td>\n",
       "      <td>1593</td>\n",
       "      <td>10</td>\n",
       "      <td>13266</td>\n",
       "      <td>POLYGON ((-112.032117 46.653144999999995, -112...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</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>661</th>\n",
       "      <td>661</td>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>30035000013</td>\n",
       "      <td>19</td>\n",
       "      <td>323</td>\n",
       "      <td>1</td>\n",
       "      <td>G5240</td>\n",
       "      <td>...</td>\n",
       "      <td>346</td>\n",
       "      <td>0</td>\n",
       "      <td>13200</td>\n",
       "      <td>POLYGON ((-113.020621 48.552363, -113.02062 48...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>662</th>\n",
       "      <td>662</td>\n",
       "      <td>3</td>\n",
       "      <td>MT</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>30035000001</td>\n",
       "      <td>436</td>\n",
       "      <td>179</td>\n",
       "      <td>17</td>\n",
       "      <td>G5240</td>\n",
       "      <td>...</td>\n",
       "      <td>648</td>\n",
       "      <td>17</td>\n",
       "      <td>13188</td>\n",
       "      <td>POLYGON ((-112.33431 48.627317999999995, -112....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>663</th>\n",
       "      <td>663</td>\n",
       "      <td>1</td>\n",
       "      <td>MT</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>30035000003</td>\n",
       "      <td>362</td>\n",
       "      <td>213</td>\n",
       "      <td>18</td>\n",
       "      <td>G5240</td>\n",
       "      <td>...</td>\n",
       "      <td>606</td>\n",
       "      <td>18</td>\n",
       "      <td>13190</td>\n",
       "      <td>POLYGON ((-112.346814 48.633644, -112.346582 4...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>664</th>\n",
       "      <td>664</td>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>30019000002</td>\n",
       "      <td>141</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>G5240</td>\n",
       "      <td>...</td>\n",
       "      <td>155</td>\n",
       "      <td>6</td>\n",
       "      <td>13066</td>\n",
       "      <td>POLYGON ((-105.323036 48.895551, -105.322942 4...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>665</th>\n",
       "      <td>665</td>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>30019000003</td>\n",
       "      <td>352</td>\n",
       "      <td>22</td>\n",
       "      <td>21</td>\n",
       "      <td>G5240</td>\n",
       "      <td>...</td>\n",
       "      <td>386</td>\n",
       "      <td>20</td>\n",
       "      <td>13067</td>\n",
       "      <td>POLYGON ((-106.152064 48.867233999999996, -106...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>666 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0  NHPIVAP20 STUSAB  BVAP20  OTHERPOP20      GEOCODE  WVAP20  \\\n",
       "0             0          0     MT       8          25  30049000027    2304   \n",
       "1             1          1     MT       3          14  30049000002    1611   \n",
       "2             2          0     MT       5          10  30049000004    1953   \n",
       "3             3          2     MT       9           6  30049000024    1708   \n",
       "4             4          1     MT       1           6  30049000003    1472   \n",
       "..          ...        ...    ...     ...         ...          ...     ...   \n",
       "661         661          0     MT       0           0  30035000013      19   \n",
       "662         662          3     MT       3           0  30035000001     436   \n",
       "663         663          1     MT       1           4  30035000003     362   \n",
       "664         664          0     MT       0           0  30019000002     141   \n",
       "665         665          0     MT       0           0  30019000003     352   \n",
       "\n",
       "     APAMIVAP20  APAPOP20 MTFCC20  ... VAP20 NBAPAPOP20  LOGRECNO  \\\n",
       "0           114        75   G5240  ...  2610         74     13290   \n",
       "1            78        29   G5240  ...  1804         29     13265   \n",
       "2            87        41   G5240  ...  2166         39     13267   \n",
       "3            52        41   G5240  ...  1861         40     13287   \n",
       "4            64        10   G5240  ...  1593         10     13266   \n",
       "..          ...       ...     ...  ...   ...        ...       ...   \n",
       "661         323         1   G5240  ...   346          0     13200   \n",
       "662         179        17   G5240  ...   648         17     13188   \n",
       "663         213        18   G5240  ...   606         18     13190   \n",
       "664           3         6   G5240  ...   155          6     13066   \n",
       "665          22        21   G5240  ...   386         20     13067   \n",
       "\n",
       "                                              geometry  G20PRERTRU  \\\n",
       "0    POLYGON ((-112.089801 46.785221, -112.059386 4...         0.0   \n",
       "1    POLYGON ((-111.914985 46.660990999999996, -111...         0.0   \n",
       "2    POLYGON ((-112.051452 46.675087, -112.050822 4...         0.0   \n",
       "3    POLYGON ((-112.053208 46.611007, -112.052183 4...         0.0   \n",
       "4    POLYGON ((-112.032117 46.653144999999995, -112...         0.0   \n",
       "..                                                 ...         ...   \n",
       "661  POLYGON ((-113.020621 48.552363, -113.02062 48...         0.0   \n",
       "662  POLYGON ((-112.33431 48.627317999999995, -112....         0.0   \n",
       "663  POLYGON ((-112.346814 48.633644, -112.346582 4...         0.0   \n",
       "664  POLYGON ((-105.323036 48.895551, -105.322942 4...         0.0   \n",
       "665  POLYGON ((-106.152064 48.867233999999996, -106...         0.0   \n",
       "\n",
       "     G20PREDBID G20USSRDAI  G20USSDBUL  G20GOVRGIA  G20GOVDCOO  \n",
       "0           0.0        0.0         0.0         0.0         0.0  \n",
       "1           0.0        0.0         0.0         0.0         0.0  \n",
       "2           0.0        0.0         0.0         0.0         0.0  \n",
       "3           0.0        0.0         0.0         0.0         0.0  \n",
       "4           0.0        0.0         0.0         0.0         0.0  \n",
       "..          ...        ...         ...         ...         ...  \n",
       "661         0.0        0.0         0.0         0.0         0.0  \n",
       "662         0.0        0.0         0.0         0.0         0.0  \n",
       "663         0.0        0.0         0.0         0.0         0.0  \n",
       "664         0.0        0.0         0.0         0.0         0.0  \n",
       "665         0.0        0.0         0.0         0.0         0.0  \n",
       "\n",
       "[666 rows x 60 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "test = pd.read_csv('data/election/maup_test.csv')\n",
    "test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['SUMLEV', 'AWATER20', '2MOREPOP20', 'COPOP20', 'DOJBVAP20',\n",
       "       'FUNCSTAT20', 'AMINPOP20', 'MTFCC20', 'INTPTLAT20', 'CIFSN',\n",
       "       'AMINVAP20', 'APBVAP20', 'UACE20', 'TRACTCE20', 'TOTPOP20', 'STUSAB',\n",
       "       'BVAP20', 'NHPIVAP20', 'NWBHPOP20', 'UATYPE20', 'CHARITER',\n",
       "       'INTPTLON20', 'COUNTYFP20', 'NHPIPOP20', '2MOREVAP20', 'LOGRECNO',\n",
       "       'OTHERPOP20', 'ALAND20', 'HISP20', 'ASIANVAP20', 'APAVAP20',\n",
       "       'NBAPAPOP20', 'NBAPAVAP20', 'GEOID20', 'NAME20', 'STATEFP20', 'HVAP20',\n",
       "       'WPOP20', 'APAMIPOP20', 'UR20', 'VAP20', 'APAMIVAP20', 'BPOP20',\n",
       "       'WVAP20', 'NWBHVAP20', 'ASIANPOP20', 'APBPOP20', 'OTHERVAP20', 'FILEID',\n",
       "       'GEOCODE', 'BLOCKCE20', 'APAPOP20', 'COVAP20', 'geometry'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "blocks = gpd.read_file('data/election/mt_block')\n",
    "blocks.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "TOTPOP20\n",
       "0       44700\n",
       "3        2236\n",
       "1        2187\n",
       "4        2170\n",
       "5        2159\n",
       "        ...  \n",
       "270         1\n",
       "365         1\n",
       "1051        1\n",
       "453         1\n",
       "279         1\n",
       "Name: count, Length: 415, dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "blocks['TOTPOP20'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "test_blocks = gpd.read_file('data/election/blocks')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.8078078078078078"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "er_2020['PRES20R'] = er_2020['G20PRERTRU']/ (er_2020['G20PRERTRU'] + er_2020['G20PREDBID'])\n",
    "len(er_2020[er_2020['PRES20R'] < 0.8]) / len(er_2020)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "127    025\n",
       "163    029\n",
       "305    107\n",
       "320    069\n",
       "557    097\n",
       "612    045\n",
       "Name: COUNTYFP20, dtype: object"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mt_vtd[mt_vtd['NAMELSAD20']=='PRECINCT 1']['COUNTYFP20']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "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>NHPIVAP20</th>\n",
       "      <th>STUSAB</th>\n",
       "      <th>BVAP20</th>\n",
       "      <th>OTHERPOP20</th>\n",
       "      <th>GEOCODE</th>\n",
       "      <th>WVAP20</th>\n",
       "      <th>APAMIVAP20</th>\n",
       "      <th>APAPOP20</th>\n",
       "      <th>MTFCC20</th>\n",
       "      <th>NAMELSAD20</th>\n",
       "      <th>...</th>\n",
       "      <th>HVAP20</th>\n",
       "      <th>COPOP20</th>\n",
       "      <th>COUNTYFP20</th>\n",
       "      <th>CHARITER</th>\n",
       "      <th>INTPTLAT20</th>\n",
       "      <th>NWBHPOP20</th>\n",
       "      <th>VAP20</th>\n",
       "      <th>NBAPAPOP20</th>\n",
       "      <th>LOGRECNO</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>8</td>\n",
       "      <td>25</td>\n",
       "      <td>30049000027</td>\n",
       "      <td>2304</td>\n",
       "      <td>114</td>\n",
       "      <td>75</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 27</td>\n",
       "      <td>...</td>\n",
       "      <td>86</td>\n",
       "      <td>183</td>\n",
       "      <td>049</td>\n",
       "      <td>0</td>\n",
       "      <td>+46.7492670</td>\n",
       "      <td>119</td>\n",
       "      <td>2610</td>\n",
       "      <td>74</td>\n",
       "      <td>13290</td>\n",
       "      <td>POLYGON ((-112.08980 46.78522, -112.05939 46.7...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>MT</td>\n",
       "      <td>3</td>\n",
       "      <td>14</td>\n",
       "      <td>30049000002</td>\n",
       "      <td>1611</td>\n",
       "      <td>78</td>\n",
       "      <td>29</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 02</td>\n",
       "      <td>...</td>\n",
       "      <td>58</td>\n",
       "      <td>84</td>\n",
       "      <td>049</td>\n",
       "      <td>0</td>\n",
       "      <td>+46.6818204</td>\n",
       "      <td>65</td>\n",
       "      <td>1804</td>\n",
       "      <td>29</td>\n",
       "      <td>13265</td>\n",
       "      <td>POLYGON ((-111.91499 46.66099, -111.91496 46.6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>30049000004</td>\n",
       "      <td>1953</td>\n",
       "      <td>87</td>\n",
       "      <td>41</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 04</td>\n",
       "      <td>...</td>\n",
       "      <td>55</td>\n",
       "      <td>120</td>\n",
       "      <td>049</td>\n",
       "      <td>0</td>\n",
       "      <td>+46.6526595</td>\n",
       "      <td>65</td>\n",
       "      <td>2166</td>\n",
       "      <td>39</td>\n",
       "      <td>13267</td>\n",
       "      <td>POLYGON ((-112.05145 46.67509, -112.05082 46.6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>MT</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>30049000024</td>\n",
       "      <td>1708</td>\n",
       "      <td>52</td>\n",
       "      <td>41</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 24</td>\n",
       "      <td>...</td>\n",
       "      <td>42</td>\n",
       "      <td>96</td>\n",
       "      <td>049</td>\n",
       "      <td>0</td>\n",
       "      <td>+46.6068815</td>\n",
       "      <td>67</td>\n",
       "      <td>1861</td>\n",
       "      <td>40</td>\n",
       "      <td>13287</td>\n",
       "      <td>POLYGON ((-112.05321 46.61101, -112.05218 46.6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>MT</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>30049000003</td>\n",
       "      <td>1472</td>\n",
       "      <td>64</td>\n",
       "      <td>10</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 03</td>\n",
       "      <td>...</td>\n",
       "      <td>30</td>\n",
       "      <td>63</td>\n",
       "      <td>049</td>\n",
       "      <td>0</td>\n",
       "      <td>+46.6450345</td>\n",
       "      <td>50</td>\n",
       "      <td>1593</td>\n",
       "      <td>10</td>\n",
       "      <td>13266</td>\n",
       "      <td>POLYGON ((-112.03212 46.65314, -112.03167 46.6...</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>661</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>30035000013</td>\n",
       "      <td>19</td>\n",
       "      <td>323</td>\n",
       "      <td>1</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 13</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>15</td>\n",
       "      <td>035</td>\n",
       "      <td>0</td>\n",
       "      <td>+48.5561567</td>\n",
       "      <td>443</td>\n",
       "      <td>346</td>\n",
       "      <td>0</td>\n",
       "      <td>13200</td>\n",
       "      <td>POLYGON ((-113.02062 48.55236, -113.02062 48.5...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>662</th>\n",
       "      <td>3</td>\n",
       "      <td>MT</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>30035000001</td>\n",
       "      <td>436</td>\n",
       "      <td>179</td>\n",
       "      <td>17</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 01</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>32</td>\n",
       "      <td>035</td>\n",
       "      <td>0</td>\n",
       "      <td>+48.6282185</td>\n",
       "      <td>237</td>\n",
       "      <td>648</td>\n",
       "      <td>17</td>\n",
       "      <td>13188</td>\n",
       "      <td>POLYGON ((-112.33431 48.62732, -112.33327 48.6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>663</th>\n",
       "      <td>1</td>\n",
       "      <td>MT</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>30035000003</td>\n",
       "      <td>362</td>\n",
       "      <td>213</td>\n",
       "      <td>18</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 03</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>26</td>\n",
       "      <td>035</td>\n",
       "      <td>0</td>\n",
       "      <td>+48.6352851</td>\n",
       "      <td>259</td>\n",
       "      <td>606</td>\n",
       "      <td>18</td>\n",
       "      <td>13190</td>\n",
       "      <td>POLYGON ((-112.34681 48.63364, -112.34658 48.6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>664</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>30019000002</td>\n",
       "      <td>141</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PRECINCT #2</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>019</td>\n",
       "      <td>0</td>\n",
       "      <td>+48.7675768</td>\n",
       "      <td>4</td>\n",
       "      <td>155</td>\n",
       "      <td>6</td>\n",
       "      <td>13066</td>\n",
       "      <td>POLYGON ((-105.32304 48.89555, -105.32294 48.8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>665</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>30019000003</td>\n",
       "      <td>352</td>\n",
       "      <td>22</td>\n",
       "      <td>21</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PRECINCT #3</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>13</td>\n",
       "      <td>019</td>\n",
       "      <td>0</td>\n",
       "      <td>+48.7851808</td>\n",
       "      <td>15</td>\n",
       "      <td>386</td>\n",
       "      <td>20</td>\n",
       "      <td>13067</td>\n",
       "      <td>POLYGON ((-106.15206 48.86723, -106.15192 48.8...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>666 rows × 53 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     NHPIVAP20 STUSAB  BVAP20  OTHERPOP20      GEOCODE  WVAP20  APAMIVAP20  \\\n",
       "0            0     MT       8          25  30049000027    2304         114   \n",
       "1            1     MT       3          14  30049000002    1611          78   \n",
       "2            0     MT       5          10  30049000004    1953          87   \n",
       "3            2     MT       9           6  30049000024    1708          52   \n",
       "4            1     MT       1           6  30049000003    1472          64   \n",
       "..         ...    ...     ...         ...          ...     ...         ...   \n",
       "661          0     MT       0           0  30035000013      19         323   \n",
       "662          3     MT       3           0  30035000001     436         179   \n",
       "663          1     MT       1           4  30035000003     362         213   \n",
       "664          0     MT       0           0  30019000002     141           3   \n",
       "665          0     MT       0           0  30019000003     352          22   \n",
       "\n",
       "     APAPOP20 MTFCC20   NAMELSAD20  ... HVAP20  COPOP20  COUNTYFP20 CHARITER  \\\n",
       "0          75   G5240       PCT 27  ...     86      183         049        0   \n",
       "1          29   G5240       PCT 02  ...     58       84         049        0   \n",
       "2          41   G5240       PCT 04  ...     55      120         049        0   \n",
       "3          41   G5240       PCT 24  ...     42       96         049        0   \n",
       "4          10   G5240       PCT 03  ...     30       63         049        0   \n",
       "..        ...     ...          ...  ...    ...      ...         ...      ...   \n",
       "661         1   G5240       PCT 13  ...      4       15         035        0   \n",
       "662        17   G5240       PCT 01  ...     15       32         035        0   \n",
       "663        18   G5240       PCT 03  ...     10       26         035        0   \n",
       "664         6   G5240  PRECINCT #2  ...      3       10         019        0   \n",
       "665        21   G5240  PRECINCT #3  ...      6       13         019        0   \n",
       "\n",
       "      INTPTLAT20 NWBHPOP20  VAP20  NBAPAPOP20  LOGRECNO  \\\n",
       "0    +46.7492670       119   2610          74     13290   \n",
       "1    +46.6818204        65   1804          29     13265   \n",
       "2    +46.6526595        65   2166          39     13267   \n",
       "3    +46.6068815        67   1861          40     13287   \n",
       "4    +46.6450345        50   1593          10     13266   \n",
       "..           ...       ...    ...         ...       ...   \n",
       "661  +48.5561567       443    346           0     13200   \n",
       "662  +48.6282185       237    648          17     13188   \n",
       "663  +48.6352851       259    606          18     13190   \n",
       "664  +48.7675768         4    155           6     13066   \n",
       "665  +48.7851808        15    386          20     13067   \n",
       "\n",
       "                                              geometry  \n",
       "0    POLYGON ((-112.08980 46.78522, -112.05939 46.7...  \n",
       "1    POLYGON ((-111.91499 46.66099, -111.91496 46.6...  \n",
       "2    POLYGON ((-112.05145 46.67509, -112.05082 46.6...  \n",
       "3    POLYGON ((-112.05321 46.61101, -112.05218 46.6...  \n",
       "4    POLYGON ((-112.03212 46.65314, -112.03167 46.6...  \n",
       "..                                                 ...  \n",
       "661  POLYGON ((-113.02062 48.55236, -113.02062 48.5...  \n",
       "662  POLYGON ((-112.33431 48.62732, -112.33327 48.6...  \n",
       "663  POLYGON ((-112.34681 48.63364, -112.34658 48.6...  \n",
       "664  POLYGON ((-105.32304 48.89555, -105.32294 48.8...  \n",
       "665  POLYGON ((-106.15206 48.86723, -106.15192 48.8...  \n",
       "\n",
       "[666 rows x 53 columns]"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mt_vtd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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>NHPIVAP20</th>\n",
       "      <th>STUSAB</th>\n",
       "      <th>BVAP20</th>\n",
       "      <th>OTHERPOP20</th>\n",
       "      <th>GEOCODE</th>\n",
       "      <th>WVAP20</th>\n",
       "      <th>APAMIVAP20</th>\n",
       "      <th>APAPOP20</th>\n",
       "      <th>MTFCC20</th>\n",
       "      <th>NAMELSAD20</th>\n",
       "      <th>...</th>\n",
       "      <th>G16ATGRFOX</th>\n",
       "      <th>G16ATGDJEN</th>\n",
       "      <th>G16SOSRSTA</th>\n",
       "      <th>G16SOSDLIN</th>\n",
       "      <th>G16SOSLROO</th>\n",
       "      <th>G16AUDRROS</th>\n",
       "      <th>G16AUDDLAS</th>\n",
       "      <th>G16SPIRARN</th>\n",
       "      <th>G16SPIDROM</th>\n",
       "      <th>geometry_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>8</td>\n",
       "      <td>25</td>\n",
       "      <td>30049000027</td>\n",
       "      <td>2304</td>\n",
       "      <td>114</td>\n",
       "      <td>75</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 27</td>\n",
       "      <td>...</td>\n",
       "      <td>1166</td>\n",
       "      <td>331</td>\n",
       "      <td>898</td>\n",
       "      <td>550</td>\n",
       "      <td>54</td>\n",
       "      <td>854</td>\n",
       "      <td>622</td>\n",
       "      <td>823</td>\n",
       "      <td>672</td>\n",
       "      <td>POLYGON ((-112.03488 46.78380, -112.03500 46.7...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>MT</td>\n",
       "      <td>3</td>\n",
       "      <td>14</td>\n",
       "      <td>30049000002</td>\n",
       "      <td>1611</td>\n",
       "      <td>78</td>\n",
       "      <td>29</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 02</td>\n",
       "      <td>...</td>\n",
       "      <td>808</td>\n",
       "      <td>193</td>\n",
       "      <td>737</td>\n",
       "      <td>232</td>\n",
       "      <td>42</td>\n",
       "      <td>685</td>\n",
       "      <td>299</td>\n",
       "      <td>704</td>\n",
       "      <td>276</td>\n",
       "      <td>POLYGON ((-114.24908 46.18551, -114.23853 46.1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>MT</td>\n",
       "      <td>3</td>\n",
       "      <td>14</td>\n",
       "      <td>30049000002</td>\n",
       "      <td>1611</td>\n",
       "      <td>78</td>\n",
       "      <td>29</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 02</td>\n",
       "      <td>...</td>\n",
       "      <td>891</td>\n",
       "      <td>252</td>\n",
       "      <td>680</td>\n",
       "      <td>435</td>\n",
       "      <td>38</td>\n",
       "      <td>648</td>\n",
       "      <td>480</td>\n",
       "      <td>609</td>\n",
       "      <td>518</td>\n",
       "      <td>POLYGON ((-111.84308 46.71988, -111.83669 46.7...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>MT</td>\n",
       "      <td>3</td>\n",
       "      <td>14</td>\n",
       "      <td>30049000002</td>\n",
       "      <td>1611</td>\n",
       "      <td>78</td>\n",
       "      <td>29</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 02</td>\n",
       "      <td>...</td>\n",
       "      <td>246</td>\n",
       "      <td>81</td>\n",
       "      <td>205</td>\n",
       "      <td>116</td>\n",
       "      <td>15</td>\n",
       "      <td>191</td>\n",
       "      <td>135</td>\n",
       "      <td>163</td>\n",
       "      <td>166</td>\n",
       "      <td>POLYGON ((-112.32168 48.63332, -112.32137 48.6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>MT</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>30081000002</td>\n",
       "      <td>1310</td>\n",
       "      <td>29</td>\n",
       "      <td>17</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 02</td>\n",
       "      <td>...</td>\n",
       "      <td>808</td>\n",
       "      <td>193</td>\n",
       "      <td>737</td>\n",
       "      <td>232</td>\n",
       "      <td>42</td>\n",
       "      <td>685</td>\n",
       "      <td>299</td>\n",
       "      <td>704</td>\n",
       "      <td>276</td>\n",
       "      <td>POLYGON ((-114.24908 46.18551, -114.23853 46.1...</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>962</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>30011000001</td>\n",
       "      <td>149</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PRECINCT #1 ALZADA</td>\n",
       "      <td>...</td>\n",
       "      <td>107</td>\n",
       "      <td>4</td>\n",
       "      <td>100</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>101</td>\n",
       "      <td>7</td>\n",
       "      <td>102</td>\n",
       "      <td>8</td>\n",
       "      <td>POLYGON ((-104.04107 45.48014, -104.04106 45.4...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>963</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>30011000003</td>\n",
       "      <td>85</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PRECINCT #3 HAMMOND</td>\n",
       "      <td>...</td>\n",
       "      <td>67</td>\n",
       "      <td>3</td>\n",
       "      <td>63</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>67</td>\n",
       "      <td>3</td>\n",
       "      <td>61</td>\n",
       "      <td>8</td>\n",
       "      <td>POLYGON ((-104.86430 45.40319, -104.86442 45.3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>964</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>30011000014</td>\n",
       "      <td>491</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PRECINCT #14 RURAL EKALAKA</td>\n",
       "      <td>...</td>\n",
       "      <td>342</td>\n",
       "      <td>31</td>\n",
       "      <td>325</td>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>327</td>\n",
       "      <td>30</td>\n",
       "      <td>310</td>\n",
       "      <td>52</td>\n",
       "      <td>POLYGON ((-104.51608 46.05484, -104.51608 46.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>965</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>30011000013</td>\n",
       "      <td>309</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PRECINCT #13 EKALAKA</td>\n",
       "      <td>...</td>\n",
       "      <td>185</td>\n",
       "      <td>31</td>\n",
       "      <td>158</td>\n",
       "      <td>47</td>\n",
       "      <td>8</td>\n",
       "      <td>167</td>\n",
       "      <td>44</td>\n",
       "      <td>158</td>\n",
       "      <td>50</td>\n",
       "      <td>POLYGON ((-104.56107 45.88504, -104.56116 45.8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>966</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3003500021C</td>\n",
       "      <td>13</td>\n",
       "      <td>645</td>\n",
       "      <td>1</td>\n",
       "      <td>G5240</td>\n",
       "      <td>PCT 21C</td>\n",
       "      <td>...</td>\n",
       "      <td>45</td>\n",
       "      <td>234</td>\n",
       "      <td>15</td>\n",
       "      <td>260</td>\n",
       "      <td>8</td>\n",
       "      <td>37</td>\n",
       "      <td>242</td>\n",
       "      <td>29</td>\n",
       "      <td>251</td>\n",
       "      <td>POLYGON ((-113.01767 48.55233, -113.01588 48.5...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>967 rows × 79 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     NHPIVAP20 STUSAB  BVAP20  OTHERPOP20      GEOCODE  WVAP20  APAMIVAP20  \\\n",
       "0            0     MT       8          25  30049000027    2304         114   \n",
       "1            1     MT       3          14  30049000002    1611          78   \n",
       "2            1     MT       3          14  30049000002    1611          78   \n",
       "3            1     MT       3          14  30049000002    1611          78   \n",
       "4            1     MT       1          23  30081000002    1310          29   \n",
       "..         ...    ...     ...         ...          ...     ...         ...   \n",
       "962          0     MT       0           1  30011000001     149           4   \n",
       "963          0     MT       0           0  30011000003      85           0   \n",
       "964          0     MT       0           2  30011000014     491           8   \n",
       "965          0     MT       0           1  30011000013     309          10   \n",
       "966          0     MT       0           0  3003500021C      13         645   \n",
       "\n",
       "     APAPOP20 MTFCC20                  NAMELSAD20  ... G16ATGRFOX  G16ATGDJEN  \\\n",
       "0          75   G5240                      PCT 27  ...       1166         331   \n",
       "1          29   G5240                      PCT 02  ...        808         193   \n",
       "2          29   G5240                      PCT 02  ...        891         252   \n",
       "3          29   G5240                      PCT 02  ...        246          81   \n",
       "4          17   G5240                      PCT 02  ...        808         193   \n",
       "..        ...     ...                         ...  ...        ...         ...   \n",
       "962         4   G5240          PRECINCT #1 ALZADA  ...        107           4   \n",
       "963         1   G5240         PRECINCT #3 HAMMOND  ...         67           3   \n",
       "964         9   G5240  PRECINCT #14 RURAL EKALAKA  ...        342          31   \n",
       "965         2   G5240        PRECINCT #13 EKALAKA  ...        185          31   \n",
       "966         1   G5240                     PCT 21C  ...         45         234   \n",
       "\n",
       "     G16SOSRSTA G16SOSDLIN  G16SOSLROO G16AUDRROS  G16AUDDLAS  G16SPIRARN  \\\n",
       "0           898        550          54        854         622         823   \n",
       "1           737        232          42        685         299         704   \n",
       "2           680        435          38        648         480         609   \n",
       "3           205        116          15        191         135         163   \n",
       "4           737        232          42        685         299         704   \n",
       "..          ...        ...         ...        ...         ...         ...   \n",
       "962         100          7           3        101           7         102   \n",
       "963          63          8           0         67           3          61   \n",
       "964         325         50           4        327          30         310   \n",
       "965         158         47           8        167          44         158   \n",
       "966          15        260           8         37         242          29   \n",
       "\n",
       "     G16SPIDROM                                         geometry_y  \n",
       "0           672  POLYGON ((-112.03488 46.78380, -112.03500 46.7...  \n",
       "1           276  POLYGON ((-114.24908 46.18551, -114.23853 46.1...  \n",
       "2           518  POLYGON ((-111.84308 46.71988, -111.83669 46.7...  \n",
       "3           166  POLYGON ((-112.32168 48.63332, -112.32137 48.6...  \n",
       "4           276  POLYGON ((-114.24908 46.18551, -114.23853 46.1...  \n",
       "..          ...                                                ...  \n",
       "962           8  POLYGON ((-104.04107 45.48014, -104.04106 45.4...  \n",
       "963           8  POLYGON ((-104.86430 45.40319, -104.86442 45.3...  \n",
       "964          52  POLYGON ((-104.51608 46.05484, -104.51608 46.0...  \n",
       "965          50  POLYGON ((-104.56107 45.88504, -104.56116 45.8...  \n",
       "966         251  POLYGON ((-113.01767 48.55233, -113.01588 48.5...  \n",
       "\n",
       "[967 rows x 79 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combinded = pd.merge(mt_vtd, er_2020, left_on='NAMELSAD20', right_on='SOSPRECINC')\n",
    "combinded"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>NHPIVAP20</th>\n",
       "      <th>STUSAB</th>\n",
       "      <th>BVAP20</th>\n",
       "      <th>OTHERPOP20</th>\n",
       "      <th>GEOCODE</th>\n",
       "      <th>WVAP20</th>\n",
       "      <th>APAMIVAP20</th>\n",
       "      <th>APAPOP20</th>\n",
       "      <th>MTFCC20</th>\n",
       "      <th>NAMELSAD20</th>\n",
       "      <th>...</th>\n",
       "      <th>HVAP20</th>\n",
       "      <th>COPOP20</th>\n",
       "      <th>COUNTYFP20</th>\n",
       "      <th>CHARITER</th>\n",
       "      <th>INTPTLAT20</th>\n",
       "      <th>NWBHPOP20</th>\n",
       "      <th>VAP20</th>\n",
       "      <th>NBAPAPOP20</th>\n",
       "      <th>LOGRECNO</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>0</td>\n",
       "      <td>MT</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3006300089B</td>\n",
       "      <td>197</td>\n",
       "      <td>13</td>\n",
       "      <td>3</td>\n",
       "      <td>G5240</td>\n",
       "      <td>BONNER 89</td>\n",
       "      <td>...</td>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>063</td>\n",
       "      <td>0</td>\n",
       "      <td>+46.8585644</td>\n",
       "      <td>6</td>\n",
       "      <td>221</td>\n",
       "      <td>3</td>\n",
       "      <td>13335</td>\n",
       "      <td>POLYGON ((-113.93929 46.86700, -113.93812 46.8...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 53 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    NHPIVAP20 STUSAB  BVAP20  OTHERPOP20      GEOCODE  WVAP20  APAMIVAP20  \\\n",
       "97          0     MT       0           1  3006300089B     197          13   \n",
       "\n",
       "    APAPOP20 MTFCC20 NAMELSAD20  ... HVAP20  COPOP20  COUNTYFP20 CHARITER  \\\n",
       "97         3   G5240  BONNER 89  ...     13       19         063        0   \n",
       "\n",
       "     INTPTLAT20 NWBHPOP20  VAP20  NBAPAPOP20  LOGRECNO  \\\n",
       "97  +46.8585644         6    221           3     13335   \n",
       "\n",
       "                                             geometry  \n",
       "97  POLYGON ((-113.93929 46.86700, -113.93812 46.8...  \n",
       "\n",
       "[1 rows x 53 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mg_vtd = gpd.read_file('data/mt_vtd')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "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>NUMBER</th>\n",
       "      <th>NAME</th>\n",
       "      <th>HOUSE</th>\n",
       "      <th>SENATE</th>\n",
       "      <th>POLLCODE</th>\n",
       "      <th>POLLINGPLA</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>COUNTYCODE</th>\n",
       "      <th>SOSPRECINC</th>\n",
       "      <th>SOURCE</th>\n",
       "      <th>...</th>\n",
       "      <th>FUNCSTAT20</th>\n",
       "      <th>ALAND20</th>\n",
       "      <th>AWATER20</th>\n",
       "      <th>INTPTLAT20</th>\n",
       "      <th>INTPTLON20</th>\n",
       "      <th>PrecinctNa</th>\n",
       "      <th>Acres</th>\n",
       "      <th>SHAPE_Leng</th>\n",
       "      <th>SHAPE_Area</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>000001</td>\n",
       "      <td>#1 Precinct - West</td>\n",
       "      <td>27</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CJI ELE GYM</td>\n",
       "      <td>Liberty</td>\n",
       "      <td>48</td>\n",
       "      <td>#1 Precinct - West</td>\n",
       "      <td>2010 CENSUS GIS DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>1.740307e+09</td>\n",
       "      <td>40732356.0</td>\n",
       "      <td>+48.5306227</td>\n",
       "      <td>-111.1562453</td>\n",
       "      <td>#1 Precinct - West</td>\n",
       "      <td>440107.371086</td>\n",
       "      <td>277799.685711</td>\n",
       "      <td>1.780194e+09</td>\n",
       "      <td>POLYGON ((489630.928 519814.997, 489630.422 51...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>000001</td>\n",
       "      <td>1-HERON-HD13</td>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HERON COMMUNITY CENTER</td>\n",
       "      <td>Sanders</td>\n",
       "      <td>35</td>\n",
       "      <td>1-HERON-HD13</td>\n",
       "      <td>COUNTY GIS DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>S</td>\n",
       "      <td>2.758566e+08</td>\n",
       "      <td>5115721.0</td>\n",
       "      <td>+48.0717721</td>\n",
       "      <td>-115.9641869</td>\n",
       "      <td>1-HERON-HD13</td>\n",
       "      <td>69455.096056</td>\n",
       "      <td>89100.974828</td>\n",
       "      <td>2.808300e+08</td>\n",
       "      <td>POLYGON ((115169.674 460413.777, 115204.854 46...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>000001</td>\n",
       "      <td>1 WESTBY</td>\n",
       "      <td>34</td>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WESTBY COMMUNITY HALL</td>\n",
       "      <td>Sheridan</td>\n",
       "      <td>34</td>\n",
       "      <td>1 WESTBY</td>\n",
       "      <td>DIGITIZED FROM COUNTY MAP</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>7.192383e+08</td>\n",
       "      <td>24529367.0</td>\n",
       "      <td>+48.8563682</td>\n",
       "      <td>-104.1708300</td>\n",
       "      <td>1 WESTBY</td>\n",
       "      <td>183654.506975</td>\n",
       "      <td>152032.440373</td>\n",
       "      <td>7.430920e+08</td>\n",
       "      <td>POLYGON ((999335.715 530475.725, 999345.275 53...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>000001</td>\n",
       "      <td>COLUMBUS PRECINCT 1</td>\n",
       "      <td>57</td>\n",
       "      <td>29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>STILLWATER PAVILLION</td>\n",
       "      <td>Stillwater</td>\n",
       "      <td>32</td>\n",
       "      <td>COLUMBUS PRECINCT 1</td>\n",
       "      <td>COUNTY GIS DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>8.983969e+08</td>\n",
       "      <td>8611530.0</td>\n",
       "      <td>+45.6436291</td>\n",
       "      <td>-109.2706396</td>\n",
       "      <td>COLUMBUS PRECINCT 1</td>\n",
       "      <td>224302.648086</td>\n",
       "      <td>211020.905061</td>\n",
       "      <td>9.071316e+08</td>\n",
       "      <td>POLYGON ((618565.054 173709.864, 618971.105 17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>000001</td>\n",
       "      <td>FORTINE</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TREGO-FORTINE-STRYKER VOLUNTEER FIRE DEPARTMENT</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>56</td>\n",
       "      <td>FORTINE</td>\n",
       "      <td>COUNTY GIS DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>2.236212e+08</td>\n",
       "      <td>1841272.0</td>\n",
       "      <td>+48.7788643</td>\n",
       "      <td>-114.8481719</td>\n",
       "      <td>FORTINE</td>\n",
       "      <td>55690.792537</td>\n",
       "      <td>77785.282402</td>\n",
       "      <td>2.253137e+08</td>\n",
       "      <td>POLYGON ((195242.148 521890.043, 195385.515 52...</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>665</th>\n",
       "      <td>000009</td>\n",
       "      <td>BIG SANDY 9</td>\n",
       "      <td>27</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BIG SANDY TOWN HALL</td>\n",
       "      <td>Chouteau</td>\n",
       "      <td>19</td>\n",
       "      <td>BIG SANDY 9</td>\n",
       "      <td>ALIGNED WITH HOUSE DISTRICTS</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>2.171519e+09</td>\n",
       "      <td>11985218.0</td>\n",
       "      <td>+48.0381231</td>\n",
       "      <td>-109.9317765</td>\n",
       "      <td>BIG SANDY 9</td>\n",
       "      <td>540833.409987</td>\n",
       "      <td>249831.476944</td>\n",
       "      <td>2.186658e+09</td>\n",
       "      <td>POLYGON ((567465.832 443144.367, 567463.389 44...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>666</th>\n",
       "      <td>000001</td>\n",
       "      <td>FORT BENTON 1</td>\n",
       "      <td>27</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FORT BENTON ELEMENTARY</td>\n",
       "      <td>Chouteau</td>\n",
       "      <td>19</td>\n",
       "      <td>FORT BENTON 1</td>\n",
       "      <td>DIGITIZED FROM COUNTY MAP</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>4.485305e+08</td>\n",
       "      <td>4042520.0</td>\n",
       "      <td>+47.7719158</td>\n",
       "      <td>-110.5648354</td>\n",
       "      <td>FORT BENTON 1</td>\n",
       "      <td>112493.886441</td>\n",
       "      <td>114653.518682</td>\n",
       "      <td>4.547761e+08</td>\n",
       "      <td>POLYGON ((519180.536 403061.958, 519271.178 40...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667</th>\n",
       "      <td>000003</td>\n",
       "      <td>GERALDINE 3</td>\n",
       "      <td>27</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GERALDINE SENIOR CITIZEN</td>\n",
       "      <td>Chouteau</td>\n",
       "      <td>19</td>\n",
       "      <td>GERALDINE 3</td>\n",
       "      <td>DIGITIZED FROM COUNTY MAP</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>2.128091e+09</td>\n",
       "      <td>19561284.0</td>\n",
       "      <td>+47.6625301</td>\n",
       "      <td>-110.1780981</td>\n",
       "      <td>GERALDINE 3</td>\n",
       "      <td>531182.844968</td>\n",
       "      <td>262935.020498</td>\n",
       "      <td>2.147285e+09</td>\n",
       "      <td>POLYGON ((555986.800 412261.985, 555993.230 41...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668</th>\n",
       "      <td>000005</td>\n",
       "      <td>ROCKY BOY 5</td>\n",
       "      <td>32</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEW STONE CHILD COLLEGE</td>\n",
       "      <td>Chouteau</td>\n",
       "      <td>19</td>\n",
       "      <td>ROCKY BOY 5</td>\n",
       "      <td>ALIGNED WITH HOUSE DISTRICTS</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>1.795011e+08</td>\n",
       "      <td>430802.0</td>\n",
       "      <td>+48.2487780</td>\n",
       "      <td>-109.9045952</td>\n",
       "      <td>ROCKY BOY 5</td>\n",
       "      <td>43174.081662</td>\n",
       "      <td>85332.794407</td>\n",
       "      <td>1.745870e+08</td>\n",
       "      <td>POLYGON ((574316.737 442986.823, 574315.268 44...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>669</th>\n",
       "      <td>000028</td>\n",
       "      <td>PREC_28</td>\n",
       "      <td>72</td>\n",
       "      <td>36</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DIVIDE GRANGE HALL</td>\n",
       "      <td>Silver Bow</td>\n",
       "      <td>1</td>\n",
       "      <td>PREC_28</td>\n",
       "      <td>COUNTY GIS DATA</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>5.847507e+08</td>\n",
       "      <td>677794.0</td>\n",
       "      <td>+45.8320114</td>\n",
       "      <td>-112.7908678</td>\n",
       "      <td>PREC_28</td>\n",
       "      <td>144518.697896</td>\n",
       "      <td>140460.789121</td>\n",
       "      <td>5.836593e+08</td>\n",
       "      <td>POLYGON ((361838.634 188651.566, 361838.626 18...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>670 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     NUMBER                 NAME HOUSE SENATE  POLLCODE  \\\n",
       "0    000001   #1 Precinct - West    27     14       NaN   \n",
       "1    000001         1-HERON-HD13    13      7       NaN   \n",
       "2    000001             1 WESTBY    34     17       NaN   \n",
       "3    000001  COLUMBUS PRECINCT 1    57     29       NaN   \n",
       "4    000001              FORTINE     2      1       NaN   \n",
       "..      ...                  ...   ...    ...       ...   \n",
       "665  000009          BIG SANDY 9    27     14       NaN   \n",
       "666  000001        FORT BENTON 1    27     14       NaN   \n",
       "667  000003          GERALDINE 3    27     14       NaN   \n",
       "668  000005          ROCKY BOY 5    32     16       NaN   \n",
       "669  000028              PREC_28    72     36       NaN   \n",
       "\n",
       "                                          POLLINGPLA      COUNTY COUNTYCODE  \\\n",
       "0                                        CJI ELE GYM     Liberty         48   \n",
       "1                             HERON COMMUNITY CENTER     Sanders         35   \n",
       "2                              WESTBY COMMUNITY HALL    Sheridan         34   \n",
       "3                               STILLWATER PAVILLION  Stillwater         32   \n",
       "4    TREGO-FORTINE-STRYKER VOLUNTEER FIRE DEPARTMENT     Lincoln         56   \n",
       "..                                               ...         ...        ...   \n",
       "665                              BIG SANDY TOWN HALL    Chouteau         19   \n",
       "666                           FORT BENTON ELEMENTARY    Chouteau         19   \n",
       "667                         GERALDINE SENIOR CITIZEN    Chouteau         19   \n",
       "668                          NEW STONE CHILD COLLEGE    Chouteau         19   \n",
       "669                               DIVIDE GRANGE HALL  Silver Bow          1   \n",
       "\n",
       "              SOSPRECINC                        SOURCE  ... FUNCSTAT20  \\\n",
       "0     #1 Precinct - West          2010 CENSUS GIS DATA  ...          N   \n",
       "1           1-HERON-HD13               COUNTY GIS DATA  ...          S   \n",
       "2               1 WESTBY     DIGITIZED FROM COUNTY MAP  ...          N   \n",
       "3    COLUMBUS PRECINCT 1               COUNTY GIS DATA  ...          N   \n",
       "4                FORTINE               COUNTY GIS DATA  ...          N   \n",
       "..                   ...                           ...  ...        ...   \n",
       "665          BIG SANDY 9  ALIGNED WITH HOUSE DISTRICTS  ...          N   \n",
       "666        FORT BENTON 1     DIGITIZED FROM COUNTY MAP  ...          N   \n",
       "667          GERALDINE 3     DIGITIZED FROM COUNTY MAP  ...          N   \n",
       "668          ROCKY BOY 5  ALIGNED WITH HOUSE DISTRICTS  ...          N   \n",
       "669              PREC_28               COUNTY GIS DATA  ...          N   \n",
       "\n",
       "          ALAND20    AWATER20   INTPTLAT20    INTPTLON20           PrecinctNa  \\\n",
       "0    1.740307e+09  40732356.0  +48.5306227  -111.1562453   #1 Precinct - West   \n",
       "1    2.758566e+08   5115721.0  +48.0717721  -115.9641869         1-HERON-HD13   \n",
       "2    7.192383e+08  24529367.0  +48.8563682  -104.1708300             1 WESTBY   \n",
       "3    8.983969e+08   8611530.0  +45.6436291  -109.2706396  COLUMBUS PRECINCT 1   \n",
       "4    2.236212e+08   1841272.0  +48.7788643  -114.8481719              FORTINE   \n",
       "..            ...         ...          ...           ...                  ...   \n",
       "665  2.171519e+09  11985218.0  +48.0381231  -109.9317765          BIG SANDY 9   \n",
       "666  4.485305e+08   4042520.0  +47.7719158  -110.5648354        FORT BENTON 1   \n",
       "667  2.128091e+09  19561284.0  +47.6625301  -110.1780981          GERALDINE 3   \n",
       "668  1.795011e+08    430802.0  +48.2487780  -109.9045952          ROCKY BOY 5   \n",
       "669  5.847507e+08    677794.0  +45.8320114  -112.7908678              PREC_28   \n",
       "\n",
       "             Acres     SHAPE_Leng    SHAPE_Area  \\\n",
       "0    440107.371086  277799.685711  1.780194e+09   \n",
       "1     69455.096056   89100.974828  2.808300e+08   \n",
       "2    183654.506975  152032.440373  7.430920e+08   \n",
       "3    224302.648086  211020.905061  9.071316e+08   \n",
       "4     55690.792537   77785.282402  2.253137e+08   \n",
       "..             ...            ...           ...   \n",
       "665  540833.409987  249831.476944  2.186658e+09   \n",
       "666  112493.886441  114653.518682  4.547761e+08   \n",
       "667  531182.844968  262935.020498  2.147285e+09   \n",
       "668   43174.081662   85332.794407  1.745870e+08   \n",
       "669  144518.697896  140460.789121  5.836593e+08   \n",
       "\n",
       "                                              geometry  \n",
       "0    POLYGON ((489630.928 519814.997, 489630.422 51...  \n",
       "1    POLYGON ((115169.674 460413.777, 115204.854 46...  \n",
       "2    POLYGON ((999335.715 530475.725, 999345.275 53...  \n",
       "3    POLYGON ((618565.054 173709.864, 618971.105 17...  \n",
       "4    POLYGON ((195242.148 521890.043, 195385.515 52...  \n",
       "..                                                 ...  \n",
       "665  POLYGON ((567465.832 443144.367, 567463.389 44...  \n",
       "666  POLYGON ((519180.536 403061.958, 519271.178 40...  \n",
       "667  POLYGON ((555986.800 412261.985, 555993.230 41...  \n",
       "668  POLYGON ((574316.737 442986.823, 574315.268 44...  \n",
       "669  POLYGON ((361838.634 188651.566, 361838.626 18...  \n",
       "\n",
       "[670 rows x 34 columns]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vtd = gpd.read_file('data/MontanaVotingPrecincts_shp')\n",
    "vtd\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3004700POL1    3\n",
       "30053000009    3\n",
       "30051000001    1\n",
       "3009300027S    1\n",
       "3003100059A    1\n",
       "              ..\n",
       "30029000011    1\n",
       "30007000011    1\n",
       "30075000011    1\n",
       "30017000011    1\n",
       "30093000028    1\n",
       "Name: GEOID20, Length: 664, dtype: int64"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vtd.columns\n",
    "vtd['GEOID20'].value_counts()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "\n",
    "with open('data/plans/ensemble-25-zones.json', 'r') as f:\n",
    "    test = json.load(f)\n",
    "\n",
    "test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "                         Ballots  Weight\n",
       "(R1, R3, R0, D1, R2, R4, R5, D0)      11\n",
       "(R1, R3, R0, D1, R2, R5, R4, D0)      10\n",
       "(R1, R3, R0, R2, D1, R4, R5, D0)       8\n",
       "(R3, R1, D1, R0, R5, R2, R4, D0)       8\n",
       "(R3, R1, R0, D1, R2, R4, R5, D0)       7\n",
       "(D0, D1, R3, R1, R2, R5, R4, R0)       7\n",
       "(R3, R1, D1, R0, R2, R4, R5, D0)       7\n",
       "(R1, R3, R0, R2, D1, R5, R4, D0)       7\n",
       "(R1, R3, D1, R0, R5, R2, R4, D0)       7\n",
       "(R1, R3, D1, R2, R0, R4, R5, D0)       7\n",
       "(R1, R3, D1, R0, R2, R4, R5, D0)       7\n",
       "(R3, R1, R2, R0, D1, R5, R4, D0)       6\n",
       "(R3, R1, D1, R0, R2, R5, R4, D0)       6\n",
       "(R1, R3, R0, R2, R5, D1, R4, D0)       6\n",
       "(R3, R1, R0, D1, R5, R2, R4, D0)       6"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from simulate.utils import BradleyTerry\n",
    "\n",
    "test_bt = BradleyTerry.from_params(slate_to_candidates={'W': ['R1', 'R2', 'R3', 'R4', 'R5', 'R6'], 'C': ['D1', 'D2']},\n",
    "                            bloc_voter_prop={'W': 0.9, 'C': 0.1},\n",
    "                            cohesion={'W': 0.85, 'C': 0.85},\n",
    "                            alphas={\"W\": {\"C\": 1, \"W\": 1}, \"C\": {\"W\": 1, \"C\": 1}},\n",
    ")\n",
    "test_bt.generate_profile(1000)\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.9.13 ('base')",
   "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.9.13"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "9e24dd9cc808ab50800f409e27684ef1d7d2c09bc61702024ae72f277d93666d"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}