MatchingPrecincts.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Matching precincts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas\n",
    "import geopandas\n",
    "import matplotlib.pyplot as plt\n",
    "from fuzzywuzzy import process\n",
    "\n",
    "from create_absentee_ballots_csv import create_absentee_ballots_df\n",
    "from match_precincts import find_matches"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = create_absentee_ballots_df()\n",
    "gdf = geopandas.read_file(\"./shapefiles/GA_precincts16.shp\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Bibb 1\n",
      "Chattooga 1\n",
      "Columbia 3\n",
      "Crawford 3\n",
      "DeKalb 3\n",
      "Effingham 2\n",
      "Fayette 2\n",
      "Forsyth 4\n",
      "Fulton 1\n",
      "Gwinnett 1\n",
      "Henry 1\n",
      "Lowndes 2\n",
      "Muscogee 2\n",
      "Newton 2\n",
      "Pickens 1\n"
     ]
    }
   ],
   "source": [
    "counties = df[\"COUNTY\"].unique()\n",
    "\n",
    "for county in counties:\n",
    "    difference = len(df[df[\"COUNTY\"] == county]) - len(gdf[gdf[\"CTYNAME\"] == county])\n",
    "    if difference > 0:\n",
    "        print(county, difference)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "matches = find_matches(df, gdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "county\n",
       "Bleckley          0.000000\n",
       "Chatham          89.101124\n",
       "Chattahoochee    86.000000\n",
       "Clarke           76.500000\n",
       "Crawford         54.555556\n",
       "Rockdale         82.777778\n",
       "Spalding          0.000000\n",
       "Taylor           56.000000\n",
       "Name: rating, dtype: float64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "average_by_county = matches.groupby(\"county\").rating.mean()\n",
    "average_by_county[average_by_county < 90]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "bad_counties = set(average_by_county[average_by_county < 90].index)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Spalding"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "spalding_df = df[df[\"COUNTY\"] == \"Spalding\"]\n",
    "spalding_gdf = gdf[gdf[\"CTYNAME\"] == \"Spalding\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "manual_spalding_matches = {}\n",
    "\n",
    "for i, votes in spalding_df[\"PRES16D\"].items():\n",
    "    for j, other_votes in spalding_gdf[\"PRES16D\"].items():\n",
    "        if votes == int(other_votes):\n",
    "            manual_spalding_matches[spalding_df[\"PRECINCT\"][i]] = spalding_gdf[\"PRECINCT_N\"][j]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'SECOND BAPTISH CH': '17',\n",
       " 'FAIRMONT': '10',\n",
       " 'SENIOR CENTER': '18',\n",
       " 'THIRD WARD': '20',\n",
       " 'UGA CAMPUS': '21',\n",
       " 'CITY PARK': '06',\n",
       " 'FIRST METHODIST': '12',\n",
       " 'BOY SCOUTS HDQTRS': '03',\n",
       " 'CABIN': '04',\n",
       " 'CARVER': '05',\n",
       " 'FIRST PRESBYTERIA': '13',\n",
       " 'LIBERTY': '15',\n",
       " 'COUNTY LINE': '08',\n",
       " 'SUNNYSIDE METHODI': '19',\n",
       " 'BLALOCK': '02',\n",
       " 'GARY REID': '14',\n",
       " 'AMBUCS': '01',\n",
       " 'COMMUNITY': '07',\n",
       " 'FIRST ASSEMBLY': '11',\n",
       " 'ROBERTS': '16',\n",
       " 'EAGES LANDING BAPTIST': '09'}"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "manual_spalding_matches"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 476,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert_mapping(spalding_df[\"PRECINCT\"], spalding_gdf[\"PRECINCT_N\"], manual_spalding_matches)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 477,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_spalding = merge_precincts_by_mapping(spalding_df, manual_spalding_matches, \"Spalding\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 479,
   "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>PRECINCT</th>\n",
       "      <th>PRES16D</th>\n",
       "      <th>PRES16D_AB</th>\n",
       "      <th>PRES16D_AD</th>\n",
       "      <th>PRES16D_ED</th>\n",
       "      <th>PRES16D_PR</th>\n",
       "      <th>PRES16L</th>\n",
       "      <th>PRES16L_AB</th>\n",
       "      <th>PRES16L_AD</th>\n",
       "      <th>PRES16L_ED</th>\n",
       "      <th>PRES16L_PR</th>\n",
       "      <th>PRES16R</th>\n",
       "      <th>PRES16R_AB</th>\n",
       "      <th>PRES16R_AD</th>\n",
       "      <th>PRES16R_ED</th>\n",
       "      <th>PRES16R_PR</th>\n",
       "      <th>REG_VOTE</th>\n",
       "      <th>COUNTY</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>01</td>\n",
       "      <td>347</td>\n",
       "      <td>11</td>\n",
       "      <td>200</td>\n",
       "      <td>136</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>672</td>\n",
       "      <td>22</td>\n",
       "      <td>381</td>\n",
       "      <td>268</td>\n",
       "      <td>1</td>\n",
       "      <td>1529</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>02</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>368</td>\n",
       "      <td>6</td>\n",
       "      <td>105</td>\n",
       "      <td>257</td>\n",
       "      <td>0</td>\n",
       "      <td>501</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>03</td>\n",
       "      <td>267</td>\n",
       "      <td>10</td>\n",
       "      <td>154</td>\n",
       "      <td>103</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>4</td>\n",
       "      <td>12</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>867</td>\n",
       "      <td>28</td>\n",
       "      <td>600</td>\n",
       "      <td>239</td>\n",
       "      <td>0</td>\n",
       "      <td>1432</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>04</td>\n",
       "      <td>151</td>\n",
       "      <td>3</td>\n",
       "      <td>101</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>927</td>\n",
       "      <td>30</td>\n",
       "      <td>505</td>\n",
       "      <td>391</td>\n",
       "      <td>1</td>\n",
       "      <td>1419</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>05</td>\n",
       "      <td>380</td>\n",
       "      <td>11</td>\n",
       "      <td>203</td>\n",
       "      <td>164</td>\n",
       "      <td>2</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>796</td>\n",
       "      <td>32</td>\n",
       "      <td>511</td>\n",
       "      <td>253</td>\n",
       "      <td>0</td>\n",
       "      <td>1500</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>06</td>\n",
       "      <td>839</td>\n",
       "      <td>36</td>\n",
       "      <td>447</td>\n",
       "      <td>356</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>221</td>\n",
       "      <td>18</td>\n",
       "      <td>141</td>\n",
       "      <td>62</td>\n",
       "      <td>0</td>\n",
       "      <td>1762</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>07</td>\n",
       "      <td>759</td>\n",
       "      <td>29</td>\n",
       "      <td>410</td>\n",
       "      <td>320</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>123</td>\n",
       "      <td>5</td>\n",
       "      <td>78</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>1340</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>08</td>\n",
       "      <td>171</td>\n",
       "      <td>7</td>\n",
       "      <td>88</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>1261</td>\n",
       "      <td>30</td>\n",
       "      <td>643</td>\n",
       "      <td>587</td>\n",
       "      <td>1</td>\n",
       "      <td>1875</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>09</td>\n",
       "      <td>931</td>\n",
       "      <td>64</td>\n",
       "      <td>640</td>\n",
       "      <td>227</td>\n",
       "      <td>0</td>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>1720</td>\n",
       "      <td>79</td>\n",
       "      <td>1183</td>\n",
       "      <td>457</td>\n",
       "      <td>1</td>\n",
       "      <td>3208</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>855</td>\n",
       "      <td>57</td>\n",
       "      <td>414</td>\n",
       "      <td>384</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>72</td>\n",
       "      <td>3</td>\n",
       "      <td>46</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>1588</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>405</td>\n",
       "      <td>14</td>\n",
       "      <td>235</td>\n",
       "      <td>156</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>1248</td>\n",
       "      <td>60</td>\n",
       "      <td>765</td>\n",
       "      <td>422</td>\n",
       "      <td>1</td>\n",
       "      <td>2131</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>227</td>\n",
       "      <td>12</td>\n",
       "      <td>139</td>\n",
       "      <td>76</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>883</td>\n",
       "      <td>34</td>\n",
       "      <td>588</td>\n",
       "      <td>261</td>\n",
       "      <td>0</td>\n",
       "      <td>1377</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>425</td>\n",
       "      <td>19</td>\n",
       "      <td>259</td>\n",
       "      <td>145</td>\n",
       "      <td>2</td>\n",
       "      <td>33</td>\n",
       "      <td>3</td>\n",
       "      <td>14</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>998</td>\n",
       "      <td>39</td>\n",
       "      <td>668</td>\n",
       "      <td>289</td>\n",
       "      <td>2</td>\n",
       "      <td>1852</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>837</td>\n",
       "      <td>39</td>\n",
       "      <td>471</td>\n",
       "      <td>327</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>2</td>\n",
       "      <td>14</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>611</td>\n",
       "      <td>30</td>\n",
       "      <td>359</td>\n",
       "      <td>221</td>\n",
       "      <td>1</td>\n",
       "      <td>2099</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>177</td>\n",
       "      <td>10</td>\n",
       "      <td>90</td>\n",
       "      <td>77</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>766</td>\n",
       "      <td>25</td>\n",
       "      <td>378</td>\n",
       "      <td>363</td>\n",
       "      <td>0</td>\n",
       "      <td>1222</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>219</td>\n",
       "      <td>7</td>\n",
       "      <td>121</td>\n",
       "      <td>91</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>1085</td>\n",
       "      <td>27</td>\n",
       "      <td>680</td>\n",
       "      <td>377</td>\n",
       "      <td>1</td>\n",
       "      <td>1695</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>741</td>\n",
       "      <td>27</td>\n",
       "      <td>336</td>\n",
       "      <td>376</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>101</td>\n",
       "      <td>5</td>\n",
       "      <td>59</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>1582</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>192</td>\n",
       "      <td>20</td>\n",
       "      <td>120</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>3</td>\n",
       "      <td>22</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>740</td>\n",
       "      <td>39</td>\n",
       "      <td>544</td>\n",
       "      <td>157</td>\n",
       "      <td>0</td>\n",
       "      <td>1254</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>235</td>\n",
       "      <td>7</td>\n",
       "      <td>104</td>\n",
       "      <td>124</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>722</td>\n",
       "      <td>23</td>\n",
       "      <td>342</td>\n",
       "      <td>357</td>\n",
       "      <td>0</td>\n",
       "      <td>1444</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>180</td>\n",
       "      <td>10</td>\n",
       "      <td>100</td>\n",
       "      <td>70</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>634</td>\n",
       "      <td>33</td>\n",
       "      <td>397</td>\n",
       "      <td>204</td>\n",
       "      <td>0</td>\n",
       "      <td>1083</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>975</td>\n",
       "      <td>24</td>\n",
       "      <td>528</td>\n",
       "      <td>422</td>\n",
       "      <td>1</td>\n",
       "      <td>56</td>\n",
       "      <td>2</td>\n",
       "      <td>34</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>831</td>\n",
       "      <td>46</td>\n",
       "      <td>589</td>\n",
       "      <td>196</td>\n",
       "      <td>0</td>\n",
       "      <td>2939</td>\n",
       "      <td>Spalding</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   PRECINCT  PRES16D  PRES16D_AB  PRES16D_AD  PRES16D_ED  PRES16D_PR  PRES16L  \\\n",
       "0        01      347          11         200         136           0       16   \n",
       "1        02       44           0          16          28           0       12   \n",
       "2        03      267          10         154         103           0       25   \n",
       "3        04      151           3         101          47           0       25   \n",
       "4        05      380          11         203         164           2       27   \n",
       "5        06      839          36         447         356           0       15   \n",
       "6        07      759          29         410         320           0       16   \n",
       "7        08      171           7          88          75           1       41   \n",
       "8        09      931          64         640         227           0       56   \n",
       "9        10      855          57         414         384           0       11   \n",
       "10       11      405          14         235         156           0       39   \n",
       "11       12      227          12         139          76           0       42   \n",
       "12       13      425          19         259         145           2       33   \n",
       "13       14      837          39         471         327           0       27   \n",
       "14       15      177          10          90          77           0       18   \n",
       "15       16      219           7         121          91           0       20   \n",
       "16       17      741          27         336         376           2        8   \n",
       "17       18      192          20         120          52           0       39   \n",
       "18       19      235           7         104         124           0       33   \n",
       "19       20      180          10         100          70           0       38   \n",
       "20       21      975          24         528         422           1       56   \n",
       "\n",
       "    PRES16L_AB  PRES16L_AD  PRES16L_ED  PRES16L_PR  PRES16R  PRES16R_AB  \\\n",
       "0            0           7           9           0      672          22   \n",
       "1            0           4           8           0      368           6   \n",
       "2            4          12           9           0      867          28   \n",
       "3            1          12          12           0      927          30   \n",
       "4            1          16          10           0      796          32   \n",
       "5            0          11           4           0      221          18   \n",
       "6            0           8           8           0      123           5   \n",
       "7            2          10          29           0     1261          30   \n",
       "8            1          34          21           0     1720          79   \n",
       "9            0           5           6           0       72           3   \n",
       "10           1          21          17           0     1248          60   \n",
       "11           3          10          29           0      883          34   \n",
       "12           3          14          16           0      998          39   \n",
       "13           2          14          11           0      611          30   \n",
       "14           2           2          14           0      766          25   \n",
       "15           0           6          14           0     1085          27   \n",
       "16           0           3           5           0      101           5   \n",
       "17           3          22          14           0      740          39   \n",
       "18           1          10          22           0      722          23   \n",
       "19           1          14          23           0      634          33   \n",
       "20           2          34          20           0      831          46   \n",
       "\n",
       "    PRES16R_AD  PRES16R_ED  PRES16R_PR  REG_VOTE    COUNTY  \n",
       "0          381         268           1      1529  Spalding  \n",
       "1          105         257           0       501  Spalding  \n",
       "2          600         239           0      1432  Spalding  \n",
       "3          505         391           1      1419  Spalding  \n",
       "4          511         253           0      1500  Spalding  \n",
       "5          141          62           0      1762  Spalding  \n",
       "6           78          40           0      1340  Spalding  \n",
       "7          643         587           1      1875  Spalding  \n",
       "8         1183         457           1      3208  Spalding  \n",
       "9           46          23           0      1588  Spalding  \n",
       "10         765         422           1      2131  Spalding  \n",
       "11         588         261           0      1377  Spalding  \n",
       "12         668         289           2      1852  Spalding  \n",
       "13         359         221           1      2099  Spalding  \n",
       "14         378         363           0      1222  Spalding  \n",
       "15         680         377           1      1695  Spalding  \n",
       "16          59          37           0      1582  Spalding  \n",
       "17         544         157           0      1254  Spalding  \n",
       "18         342         357           0      1444  Spalding  \n",
       "19         397         204           0      1083  Spalding  \n",
       "20         589         196           0      2939  Spalding  "
      ]
     },
     "execution_count": 479,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_spalding"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 478,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_spalding.to_csv(\"./merged/spalding.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Rockdale"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'Olde Towne', 'Flat Shoals', 'Conyers', 'Smyrna', 'Honey Creek', 'Magnet', 'Bethel', 'Rockdale', 'Sheffield', 'Barksdale', 'Milstead', 'St. Pius', 'Fieldstone', 'The Lakes', 'Stanton', 'Salem', 'Hightower', 'Lorraine'}\n",
      "{'CO', 'SA', 'FS', 'HI', 'SH', 'SP', 'BT', 'BA', 'MI', 'RO', 'OT', 'HC', 'SM', 'ST', 'FI', 'LO', 'LA', 'MA'}\n"
     ]
    }
   ],
   "source": [
    "print(set(df[df[\"COUNTY\"] == \"Rockdale\"][\"PRECINCT\"]))\n",
    "print(set(gdf[gdf[\"CTYNAME\"] == \"Rockdale\"][\"PRECINCT_N\"]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "manual_rockdale_matches = {\n",
    "    \"Olde Towne\": \"OT\",\n",
    "    \"Flat Shoals\": \"FS\",\n",
    "    \"Conyers\": \"CO\",\n",
    "    \"Smyrna\": \"SM\",\n",
    "    \"Honey Creek\": \"HC\",\n",
    "    \"Magnet\": \"MA\",\n",
    "    \"Bethel\": \"BT\",\n",
    "    \"Rockdale\": \"RO\",\n",
    "    \"Sheffield\": \"SH\",\n",
    "    \"Barksdale\": \"BA\",\n",
    "    \"Milstead\": \"MI\",\n",
    "    \"St. Pius\": \"SP\",\n",
    "    \"Fieldstone\": \"FI\",\n",
    "    \"The Lakes\": \"LA\",\n",
    "    \"Stanton\": \"ST\",\n",
    "    \"Salem\": \"SA\",\n",
    "    \"Hightower\": \"HI\",\n",
    "    \"Lorraine\": \"LO\"\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "key_set = set(manual_rockdale_matches.keys())\n",
    "value_set = set(manual_rockdale_matches.values())\n",
    "assert len(manual_rockdale_matches) == len(key_set)\n",
    "assert len(manual_rockdale_matches) == len(value_set)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert set(df[df[\"COUNTY\"] == \"Rockdale\"][\"PRECINCT\"]) == key_set\n",
    "assert set(gdf[gdf[\"CTYNAME\"] == \"Rockdale\"][\"PRECINCT_N\"]) == value_set"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 403,
   "metadata": {},
   "outputs": [],
   "source": [
    "rockdale_df, rockdale_gdf = get_county_df_and_gdf(\"Rockdale\")\n",
    "merged_rockdale = merge_precincts_by_mapping(rockdale_df, manual_rockdale_matches, \"Rockdale\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 404,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert len(merged_rockdale) == len(rockdale_gdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 406,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_rockdale.to_csv(\"./merged/rockdale.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Clarke"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 387,
   "metadata": {},
   "outputs": [],
   "source": [
    "clarke_matches = find_matches(df[df[\"COUNTY\"] == \"Clarke\"], gdf[gdf[\"CTYNAME\"] == \"Clarke\"], column=\"PRECINCT_I\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 388,
   "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>county</th>\n",
       "      <th>index</th>\n",
       "      <th>match_index</th>\n",
       "      <th>precinct</th>\n",
       "      <th>rating</th>\n",
       "      <th>match_value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>401</td>\n",
       "      <td>2545</td>\n",
       "      <td>1A W'ville Train Depot</td>\n",
       "      <td>60</td>\n",
       "      <td>1A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>402</td>\n",
       "      <td>2543</td>\n",
       "      <td>1B Gaines School</td>\n",
       "      <td>90</td>\n",
       "      <td>1B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>403</td>\n",
       "      <td>2537</td>\n",
       "      <td>1C Whit Davis School</td>\n",
       "      <td>60</td>\n",
       "      <td>1C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>404</td>\n",
       "      <td>2542</td>\n",
       "      <td>1D Whit Davis School</td>\n",
       "      <td>60</td>\n",
       "      <td>1D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>405</td>\n",
       "      <td>2561</td>\n",
       "      <td>2A Judia J. Harris Sch</td>\n",
       "      <td>60</td>\n",
       "      <td>2A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>406</td>\n",
       "      <td>2544</td>\n",
       "      <td>2B Howard Stroud School</td>\n",
       "      <td>60</td>\n",
       "      <td>2B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>407</td>\n",
       "      <td>2611</td>\n",
       "      <td>3A Clarke Central High</td>\n",
       "      <td>60</td>\n",
       "      <td>3A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>408</td>\n",
       "      <td>2560</td>\n",
       "      <td>3B Thomas N. Lay Park</td>\n",
       "      <td>60</td>\n",
       "      <td>3B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>409</td>\n",
       "      <td>2540</td>\n",
       "      <td>4A Athens Transit Ctr</td>\n",
       "      <td>60</td>\n",
       "      <td>4A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>410</td>\n",
       "      <td>2557</td>\n",
       "      <td>4B Memorial Park</td>\n",
       "      <td>90</td>\n",
       "      <td>4B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>411</td>\n",
       "      <td>2610</td>\n",
       "      <td>5A Oglethorpe School</td>\n",
       "      <td>60</td>\n",
       "      <td>5A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>412</td>\n",
       "      <td>2609</td>\n",
       "      <td>5B Whitehead Rd School</td>\n",
       "      <td>60</td>\n",
       "      <td>5B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>413</td>\n",
       "      <td>2612</td>\n",
       "      <td>5C Chase Street School</td>\n",
       "      <td>60</td>\n",
       "      <td>5C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>414</td>\n",
       "      <td>2613</td>\n",
       "      <td>5D ACC Fleet Mgt Bldg</td>\n",
       "      <td>60</td>\n",
       "      <td>5D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>415</td>\n",
       "      <td>2524</td>\n",
       "      <td>6A Cleveland Rd School</td>\n",
       "      <td>60</td>\n",
       "      <td>6A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>416</td>\n",
       "      <td>2558</td>\n",
       "      <td>6B Ga Square Mall</td>\n",
       "      <td>60</td>\n",
       "      <td>6B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>417</td>\n",
       "      <td>2530</td>\n",
       "      <td>6C Timothy Road School</td>\n",
       "      <td>60</td>\n",
       "      <td>6C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>418</td>\n",
       "      <td>2559</td>\n",
       "      <td>6D Firestation #4</td>\n",
       "      <td>60</td>\n",
       "      <td>6D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>419</td>\n",
       "      <td>2534</td>\n",
       "      <td>7A Timothy Road School</td>\n",
       "      <td>60</td>\n",
       "      <td>7A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>420</td>\n",
       "      <td>2555</td>\n",
       "      <td>7B Alps Elem. School</td>\n",
       "      <td>60</td>\n",
       "      <td>7B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>421</td>\n",
       "      <td>2556</td>\n",
       "      <td>7C Firestation #3</td>\n",
       "      <td>60</td>\n",
       "      <td>7C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>422</td>\n",
       "      <td>2541</td>\n",
       "      <td>8A Gaines School</td>\n",
       "      <td>90</td>\n",
       "      <td>8A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>423</td>\n",
       "      <td>2539</td>\n",
       "      <td>8B Cedar Shls High Sch</td>\n",
       "      <td>60</td>\n",
       "      <td>8B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Clarke</td>\n",
       "      <td>424</td>\n",
       "      <td>2538</td>\n",
       "      <td>8C Firestation #7</td>\n",
       "      <td>60</td>\n",
       "      <td>8C</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    county  index  match_index                 precinct  rating match_value\n",
       "0   Clarke    401         2545   1A W'ville Train Depot      60          1A\n",
       "1   Clarke    402         2543         1B Gaines School      90          1B\n",
       "2   Clarke    403         2537     1C Whit Davis School      60          1C\n",
       "3   Clarke    404         2542     1D Whit Davis School      60          1D\n",
       "4   Clarke    405         2561   2A Judia J. Harris Sch      60          2A\n",
       "5   Clarke    406         2544  2B Howard Stroud School      60          2B\n",
       "6   Clarke    407         2611   3A Clarke Central High      60          3A\n",
       "7   Clarke    408         2560    3B Thomas N. Lay Park      60          3B\n",
       "8   Clarke    409         2540    4A Athens Transit Ctr      60          4A\n",
       "9   Clarke    410         2557         4B Memorial Park      90          4B\n",
       "10  Clarke    411         2610     5A Oglethorpe School      60          5A\n",
       "11  Clarke    412         2609   5B Whitehead Rd School      60          5B\n",
       "12  Clarke    413         2612   5C Chase Street School      60          5C\n",
       "13  Clarke    414         2613    5D ACC Fleet Mgt Bldg      60          5D\n",
       "14  Clarke    415         2524   6A Cleveland Rd School      60          6A\n",
       "15  Clarke    416         2558        6B Ga Square Mall      60          6B\n",
       "16  Clarke    417         2530   6C Timothy Road School      60          6C\n",
       "17  Clarke    418         2559        6D Firestation #4      60          6D\n",
       "18  Clarke    419         2534   7A Timothy Road School      60          7A\n",
       "19  Clarke    420         2555     7B Alps Elem. School      60          7B\n",
       "20  Clarke    421         2556        7C Firestation #3      60          7C\n",
       "21  Clarke    422         2541         8A Gaines School      90          8A\n",
       "22  Clarke    423         2539   8B Cedar Shls High Sch      60          8B\n",
       "23  Clarke    424         2538        8C Firestation #7      60          8C"
      ]
     },
     "execution_count": 388,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clarke_matches"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "OK, those look right."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 389,
   "metadata": {},
   "outputs": [],
   "source": [
    "clarke_mapping = {\n",
    "    df[\"PRECINCT\"][i]: gdf[\"PRECINCT_N\"][j]\n",
    "    for i, j in zip(clarke_matches[\"index\"], clarke_matches[\"match_index\"])\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 393,
   "metadata": {},
   "outputs": [],
   "source": [
    "clarke_df, clarke_gdf = get_county_df_and_gdf(\"Clarke\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 394,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert_mapping(clarke_df[\"PRECINCT\"], clarke_gdf[\"PRECINCT_N\"], clarke_mapping)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 395,
   "metadata": {},
   "outputs": [],
   "source": [
    "joined_clarke = merge_precincts_by_mapping(clarke_df, clarke_mapping, \"Clarke\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 396,
   "metadata": {},
   "outputs": [],
   "source": [
    "joined_clarke.to_csv(\"./merged/clarke.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Taylor\n",
    "\n",
    "These matches actually look OK, thanks to the numbers:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>county</th>\n",
       "      <th>index</th>\n",
       "      <th>match_index</th>\n",
       "      <th>precinct</th>\n",
       "      <th>rating</th>\n",
       "      <th>match_value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1148</th>\n",
       "      <td>Taylor</td>\n",
       "      <td>2455</td>\n",
       "      <td>516</td>\n",
       "      <td>#1 BUTLER FIRE DEPT.</td>\n",
       "      <td>86</td>\n",
       "      <td>PRECINCT 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1149</th>\n",
       "      <td>Taylor</td>\n",
       "      <td>2456</td>\n",
       "      <td>515</td>\n",
       "      <td>#5 COURTHOUSE</td>\n",
       "      <td>34</td>\n",
       "      <td>PRECINCT 5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1150</th>\n",
       "      <td>Taylor</td>\n",
       "      <td>2457</td>\n",
       "      <td>517</td>\n",
       "      <td>#6 REYNOLDS</td>\n",
       "      <td>48</td>\n",
       "      <td>PRECINCT 6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      county  index  match_index              precinct  rating match_value\n",
       "1148  Taylor   2455          516  #1 BUTLER FIRE DEPT.      86  PRECINCT 1\n",
       "1149  Taylor   2456          515         #5 COURTHOUSE      34  PRECINCT 5\n",
       "1150  Taylor   2457          517           #6 REYNOLDS      48  PRECINCT 6"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches[matches[\"county\"] == \"Taylor\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Crawford"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 376,
   "metadata": {},
   "outputs": [],
   "source": [
    "crawford = df[df[\"COUNTY\"] == \"Crawford\"]\n",
    "crawford_gdf = gdf[gdf[\"CTYNAME\"] == \"Crawford\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 377,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['ID', 'POPULATION', 'DISTRICT', 'PRECINCT_I', 'PRECINCT_N', 'CTYNAME',\n",
       "       'FIPS1', 'FIPS2', 'PRES16D', 'PRES16R', 'PRES16L', 'SEN16D', 'SEN16R',\n",
       "       'SEN16L', 'TOTPOP', 'NH_WHITE', 'NH_BLACK', 'NH_AMIN', 'NH_ASIAN',\n",
       "       'NH_NHPI', 'NH_OTHER', 'NH_2MORE', 'HISP', 'H_WHITE', 'H_BLACK',\n",
       "       'H_AMIN', 'H_ASIAN', 'H_NHPI', 'H_OTHER', 'H_2MORE', 'VAP', 'HVAP',\n",
       "       'WVAP', 'BVAP', 'AMINVAP', 'ASIANVAP', 'NHPIVAP', 'OTHERVAP',\n",
       "       '2MOREVAP', 'CONDIST', 'HDIST', 'SENDIST', 'geometry'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 377,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "crawford_gdf.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 378,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['COUNTY', 'PRECINCT', 'PRES16D', 'PRES16D_AB', 'PRES16D_AD',\n",
       "       'PRES16D_ED', 'PRES16D_PR', 'PRES16L', 'PRES16L_AB', 'PRES16L_AD',\n",
       "       'PRES16L_ED', 'PRES16L_PR', 'PRES16R', 'PRES16R_AB', 'PRES16R_AD',\n",
       "       'PRES16R_ED', 'PRES16R_PR', 'REG_VOTE'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 378,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "crawford.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 379,
   "metadata": {},
   "outputs": [],
   "source": [
    "columns_to_aggregate = [\n",
    "    'PRES16D', 'PRES16D_AB', 'PRES16D_AD',\n",
    "    'PRES16D_ED', 'PRES16D_PR', 'PRES16L', 'PRES16L_AB', 'PRES16L_AD',\n",
    "    'PRES16L_ED', 'PRES16L_PR', 'PRES16R', 'PRES16R_AB', 'PRES16R_AD',\n",
    "    'PRES16R_ED', 'PRES16R_PR', 'REG_VOTE'\n",
    "]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "It looks like the shapefile has merged the \"COUNTY\" and \"CITY\" parts of each of precincts 1B, 2, and 3 into singular precincts 1B, 2, and 3."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 380,
   "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>PRES16D</th>\n",
       "      <th>PRES16D_AB</th>\n",
       "      <th>PRES16D_AD</th>\n",
       "      <th>PRES16D_ED</th>\n",
       "      <th>PRES16D_PR</th>\n",
       "      <th>PRES16L</th>\n",
       "      <th>PRES16L_AB</th>\n",
       "      <th>PRES16L_AD</th>\n",
       "      <th>PRES16L_ED</th>\n",
       "      <th>PRES16L_PR</th>\n",
       "      <th>PRES16R</th>\n",
       "      <th>PRES16R_AB</th>\n",
       "      <th>PRES16R_AD</th>\n",
       "      <th>PRES16R_ED</th>\n",
       "      <th>PRES16R_PR</th>\n",
       "      <th>REG_VOTE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PRECINCT</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1A</th>\n",
       "      <td>135</td>\n",
       "      <td>9</td>\n",
       "      <td>45</td>\n",
       "      <td>81</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>154</td>\n",
       "      <td>3</td>\n",
       "      <td>66</td>\n",
       "      <td>84</td>\n",
       "      <td>1</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1B</th>\n",
       "      <td>389</td>\n",
       "      <td>29</td>\n",
       "      <td>152</td>\n",
       "      <td>207</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>225</td>\n",
       "      <td>8</td>\n",
       "      <td>125</td>\n",
       "      <td>92</td>\n",
       "      <td>0</td>\n",
       "      <td>813</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>507</td>\n",
       "      <td>32</td>\n",
       "      <td>334</td>\n",
       "      <td>141</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>548</td>\n",
       "      <td>39</td>\n",
       "      <td>377</td>\n",
       "      <td>132</td>\n",
       "      <td>0</td>\n",
       "      <td>1385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>154</td>\n",
       "      <td>7</td>\n",
       "      <td>87</td>\n",
       "      <td>59</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>875</td>\n",
       "      <td>36</td>\n",
       "      <td>514</td>\n",
       "      <td>325</td>\n",
       "      <td>0</td>\n",
       "      <td>1331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>126</td>\n",
       "      <td>11</td>\n",
       "      <td>61</td>\n",
       "      <td>54</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>906</td>\n",
       "      <td>36</td>\n",
       "      <td>398</td>\n",
       "      <td>471</td>\n",
       "      <td>1</td>\n",
       "      <td>1318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>110</td>\n",
       "      <td>7</td>\n",
       "      <td>47</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>927</td>\n",
       "      <td>31</td>\n",
       "      <td>384</td>\n",
       "      <td>511</td>\n",
       "      <td>1</td>\n",
       "      <td>1301</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          PRES16D  PRES16D_AB  PRES16D_AD  PRES16D_ED  PRES16D_PR  PRES16L  \\\n",
       "PRECINCT                                                                     \n",
       "1A            135           9          45          81           0        3   \n",
       "1B            389          29         152         207           1       10   \n",
       "2             507          32         334         141           0       24   \n",
       "3             154           7          87          59           1       31   \n",
       "4             126          11          61          54           0       16   \n",
       "5             110           7          47          56           0       22   \n",
       "\n",
       "          PRES16L_AB  PRES16L_AD  PRES16L_ED  PRES16L_PR  PRES16R  PRES16R_AB  \\\n",
       "PRECINCT                                                                        \n",
       "1A                 0           1           2           0      154           3   \n",
       "1B                 1           4           5           0      225           8   \n",
       "2                  0          16           8           0      548          39   \n",
       "3                  3           9          19           0      875          36   \n",
       "4                  0           7           9           0      906          36   \n",
       "5                  0          11          11           0      927          31   \n",
       "\n",
       "          PRES16R_AD  PRES16R_ED  PRES16R_PR  REG_VOTE  \n",
       "PRECINCT                                                \n",
       "1A                66          84           1       377  \n",
       "1B               125          92           0       813  \n",
       "2                377         132           0      1385  \n",
       "3                514         325           0      1331  \n",
       "4                398         471           1      1318  \n",
       "5                384         511           1      1301  "
      ]
     },
     "execution_count": 380,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_crawford_precincts = crawford.groupby(crawford[\"PRECINCT\"].apply(lambda s: s.split()[0])).sum()\n",
    "merged_crawford_precincts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 381,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_crawford_precincts.reset_index(inplace=True)\n",
    "merged_crawford_precincts[\"COUNTY\"] = \"Crawford\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 382,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert set(merged_crawford_precincts.columns) == set(df.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 385,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_crawford_precincts[\"PRECINCT\"] = merged_crawford_precincts[\"PRECINCT\"].apply(lambda s: f\"DISTRICT {s}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 386,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_crawford_precincts.to_csv(\"./merged/crawford.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Bleckley"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>COUNTY</th>\n",
       "      <th>PRECINCT</th>\n",
       "      <th>PRES16D</th>\n",
       "      <th>PRES16D_AB</th>\n",
       "      <th>PRES16D_AD</th>\n",
       "      <th>PRES16D_ED</th>\n",
       "      <th>PRES16D_PR</th>\n",
       "      <th>PRES16L</th>\n",
       "      <th>PRES16L_AB</th>\n",
       "      <th>PRES16L_AD</th>\n",
       "      <th>PRES16L_ED</th>\n",
       "      <th>PRES16L_PR</th>\n",
       "      <th>PRES16R</th>\n",
       "      <th>PRES16R_AB</th>\n",
       "      <th>PRES16R_AD</th>\n",
       "      <th>PRES16R_ED</th>\n",
       "      <th>PRES16R_PR</th>\n",
       "      <th>REG_VOTE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>Bleckley</td>\n",
       "      <td>FAIRGROUND</td>\n",
       "      <td>1101</td>\n",
       "      <td>113</td>\n",
       "      <td>502</td>\n",
       "      <td>479</td>\n",
       "      <td>7</td>\n",
       "      <td>123</td>\n",
       "      <td>1</td>\n",
       "      <td>66</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>3719</td>\n",
       "      <td>136</td>\n",
       "      <td>2076</td>\n",
       "      <td>1505</td>\n",
       "      <td>2</td>\n",
       "      <td>6162</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       COUNTY    PRECINCT  PRES16D  PRES16D_AB  PRES16D_AD  PRES16D_ED  \\\n",
       "127  Bleckley  FAIRGROUND     1101         113         502         479   \n",
       "\n",
       "     PRES16D_PR  PRES16L  PRES16L_AB  PRES16L_AD  PRES16L_ED  PRES16L_PR  \\\n",
       "127           7      123           1          66          56           0   \n",
       "\n",
       "     PRES16R  PRES16R_AB  PRES16R_AD  PRES16R_ED  PRES16R_PR  REG_VOTE  \n",
       "127     3719         136        2076        1505           2      6162  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df[\"COUNTY\"] == \"Bleckley\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>ID</th>\n",
       "      <th>POPULATION</th>\n",
       "      <th>DISTRICT</th>\n",
       "      <th>PRECINCT_I</th>\n",
       "      <th>PRECINCT_N</th>\n",
       "      <th>CTYNAME</th>\n",
       "      <th>FIPS1</th>\n",
       "      <th>FIPS2</th>\n",
       "      <th>PRES16D</th>\n",
       "      <th>PRES16R</th>\n",
       "      <th>...</th>\n",
       "      <th>BVAP</th>\n",
       "      <th>AMINVAP</th>\n",
       "      <th>ASIANVAP</th>\n",
       "      <th>NHPIVAP</th>\n",
       "      <th>OTHERVAP</th>\n",
       "      <th>2MOREVAP</th>\n",
       "      <th>CONDIST</th>\n",
       "      <th>HDIST</th>\n",
       "      <th>SENDIST</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>878</th>\n",
       "      <td>1754047</td>\n",
       "      <td>13063</td>\n",
       "      <td>0231</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Bleckley</td>\n",
       "      <td>13023</td>\n",
       "      <td>023</td>\n",
       "      <td>1101</td>\n",
       "      <td>3719</td>\n",
       "      <td>...</td>\n",
       "      <td>2655</td>\n",
       "      <td>7</td>\n",
       "      <td>87</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>49</td>\n",
       "      <td>008</td>\n",
       "      <td>144</td>\n",
       "      <td>020</td>\n",
       "      <td>POLYGON ((-83.337441 32.530466, -83.337288 32....</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID  POPULATION DISTRICT PRECINCT_I PRECINCT_N   CTYNAME  FIPS1  \\\n",
       "878  1754047       13063     0231          1          1  Bleckley  13023   \n",
       "\n",
       "    FIPS2 PRES16D PRES16R  ...  BVAP AMINVAP ASIANVAP NHPIVAP  OTHERVAP  \\\n",
       "878   023    1101    3719  ...  2655       7       87       3         0   \n",
       "\n",
       "     2MOREVAP  CONDIST  HDIST  SENDIST  \\\n",
       "878        49      008    144      020   \n",
       "\n",
       "                                              geometry  \n",
       "878  POLYGON ((-83.337441 32.530466, -83.337288 32....  \n",
       "\n",
       "[1 rows x 43 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf[gdf[\"CTYNAME\"] == \"Bleckley\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This one is just a single precinct in both datasets, and the vote totals match, so I feel good about matching it."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Spalding"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 471,
   "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>COUNTY</th>\n",
       "      <th>PRECINCT</th>\n",
       "      <th>PRES16D</th>\n",
       "      <th>PRES16D_AB</th>\n",
       "      <th>PRES16D_AD</th>\n",
       "      <th>PRES16D_ED</th>\n",
       "      <th>PRES16D_PR</th>\n",
       "      <th>PRES16L</th>\n",
       "      <th>PRES16L_AB</th>\n",
       "      <th>PRES16L_AD</th>\n",
       "      <th>PRES16L_ED</th>\n",
       "      <th>PRES16L_PR</th>\n",
       "      <th>PRES16R</th>\n",
       "      <th>PRES16R_AB</th>\n",
       "      <th>PRES16R_AD</th>\n",
       "      <th>PRES16R_ED</th>\n",
       "      <th>PRES16R_PR</th>\n",
       "      <th>REG_VOTE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2401</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>SECOND BAPTISH CH</td>\n",
       "      <td>741</td>\n",
       "      <td>27</td>\n",
       "      <td>336</td>\n",
       "      <td>376</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>101</td>\n",
       "      <td>5</td>\n",
       "      <td>59</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>1582</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2402</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>FAIRMONT</td>\n",
       "      <td>855</td>\n",
       "      <td>57</td>\n",
       "      <td>414</td>\n",
       "      <td>384</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>72</td>\n",
       "      <td>3</td>\n",
       "      <td>46</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>1588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2403</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>SENIOR CENTER</td>\n",
       "      <td>192</td>\n",
       "      <td>20</td>\n",
       "      <td>120</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>3</td>\n",
       "      <td>22</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>740</td>\n",
       "      <td>39</td>\n",
       "      <td>544</td>\n",
       "      <td>157</td>\n",
       "      <td>0</td>\n",
       "      <td>1254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2404</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>THIRD WARD</td>\n",
       "      <td>180</td>\n",
       "      <td>10</td>\n",
       "      <td>100</td>\n",
       "      <td>70</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>634</td>\n",
       "      <td>33</td>\n",
       "      <td>397</td>\n",
       "      <td>204</td>\n",
       "      <td>0</td>\n",
       "      <td>1083</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2405</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>UGA CAMPUS</td>\n",
       "      <td>975</td>\n",
       "      <td>24</td>\n",
       "      <td>528</td>\n",
       "      <td>422</td>\n",
       "      <td>1</td>\n",
       "      <td>56</td>\n",
       "      <td>2</td>\n",
       "      <td>34</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>831</td>\n",
       "      <td>46</td>\n",
       "      <td>589</td>\n",
       "      <td>196</td>\n",
       "      <td>0</td>\n",
       "      <td>2939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2406</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>CITY PARK</td>\n",
       "      <td>839</td>\n",
       "      <td>36</td>\n",
       "      <td>447</td>\n",
       "      <td>356</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>221</td>\n",
       "      <td>18</td>\n",
       "      <td>141</td>\n",
       "      <td>62</td>\n",
       "      <td>0</td>\n",
       "      <td>1762</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2407</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>FIRST METHODIST</td>\n",
       "      <td>227</td>\n",
       "      <td>12</td>\n",
       "      <td>139</td>\n",
       "      <td>76</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>883</td>\n",
       "      <td>34</td>\n",
       "      <td>588</td>\n",
       "      <td>261</td>\n",
       "      <td>0</td>\n",
       "      <td>1377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2408</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>BOY SCOUTS HDQTRS</td>\n",
       "      <td>267</td>\n",
       "      <td>10</td>\n",
       "      <td>154</td>\n",
       "      <td>103</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>4</td>\n",
       "      <td>12</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>867</td>\n",
       "      <td>28</td>\n",
       "      <td>600</td>\n",
       "      <td>239</td>\n",
       "      <td>0</td>\n",
       "      <td>1432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2409</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>CABIN</td>\n",
       "      <td>151</td>\n",
       "      <td>3</td>\n",
       "      <td>101</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>927</td>\n",
       "      <td>30</td>\n",
       "      <td>505</td>\n",
       "      <td>391</td>\n",
       "      <td>1</td>\n",
       "      <td>1419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2410</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>CARVER</td>\n",
       "      <td>380</td>\n",
       "      <td>11</td>\n",
       "      <td>203</td>\n",
       "      <td>164</td>\n",
       "      <td>2</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>796</td>\n",
       "      <td>32</td>\n",
       "      <td>511</td>\n",
       "      <td>253</td>\n",
       "      <td>0</td>\n",
       "      <td>1500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2411</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>FIRST PRESBYTERIA</td>\n",
       "      <td>425</td>\n",
       "      <td>19</td>\n",
       "      <td>259</td>\n",
       "      <td>145</td>\n",
       "      <td>2</td>\n",
       "      <td>33</td>\n",
       "      <td>3</td>\n",
       "      <td>14</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>998</td>\n",
       "      <td>39</td>\n",
       "      <td>668</td>\n",
       "      <td>289</td>\n",
       "      <td>2</td>\n",
       "      <td>1852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2412</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>LIBERTY</td>\n",
       "      <td>177</td>\n",
       "      <td>10</td>\n",
       "      <td>90</td>\n",
       "      <td>77</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>766</td>\n",
       "      <td>25</td>\n",
       "      <td>378</td>\n",
       "      <td>363</td>\n",
       "      <td>0</td>\n",
       "      <td>1222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2413</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>COUNTY LINE</td>\n",
       "      <td>171</td>\n",
       "      <td>7</td>\n",
       "      <td>88</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>1261</td>\n",
       "      <td>30</td>\n",
       "      <td>643</td>\n",
       "      <td>587</td>\n",
       "      <td>1</td>\n",
       "      <td>1875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2414</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>SUNNYSIDE METHODI</td>\n",
       "      <td>235</td>\n",
       "      <td>7</td>\n",
       "      <td>104</td>\n",
       "      <td>124</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>722</td>\n",
       "      <td>23</td>\n",
       "      <td>342</td>\n",
       "      <td>357</td>\n",
       "      <td>0</td>\n",
       "      <td>1444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2415</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>BLALOCK</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>368</td>\n",
       "      <td>6</td>\n",
       "      <td>105</td>\n",
       "      <td>257</td>\n",
       "      <td>0</td>\n",
       "      <td>501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2416</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>GARY REID</td>\n",
       "      <td>837</td>\n",
       "      <td>39</td>\n",
       "      <td>471</td>\n",
       "      <td>327</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>2</td>\n",
       "      <td>14</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>611</td>\n",
       "      <td>30</td>\n",
       "      <td>359</td>\n",
       "      <td>221</td>\n",
       "      <td>1</td>\n",
       "      <td>2099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2417</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>AMBUCS</td>\n",
       "      <td>347</td>\n",
       "      <td>11</td>\n",
       "      <td>200</td>\n",
       "      <td>136</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>672</td>\n",
       "      <td>22</td>\n",
       "      <td>381</td>\n",
       "      <td>268</td>\n",
       "      <td>1</td>\n",
       "      <td>1529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2418</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>COMMUNITY</td>\n",
       "      <td>759</td>\n",
       "      <td>29</td>\n",
       "      <td>410</td>\n",
       "      <td>320</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>123</td>\n",
       "      <td>5</td>\n",
       "      <td>78</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>1340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2419</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>FIRST ASSEMBLY</td>\n",
       "      <td>405</td>\n",
       "      <td>14</td>\n",
       "      <td>235</td>\n",
       "      <td>156</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>1248</td>\n",
       "      <td>60</td>\n",
       "      <td>765</td>\n",
       "      <td>422</td>\n",
       "      <td>1</td>\n",
       "      <td>2131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2420</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>ROBERTS</td>\n",
       "      <td>219</td>\n",
       "      <td>7</td>\n",
       "      <td>121</td>\n",
       "      <td>91</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>1085</td>\n",
       "      <td>27</td>\n",
       "      <td>680</td>\n",
       "      <td>377</td>\n",
       "      <td>1</td>\n",
       "      <td>1695</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2421</th>\n",
       "      <td>Spalding</td>\n",
       "      <td>EAGES LANDING BAPTIST</td>\n",
       "      <td>931</td>\n",
       "      <td>64</td>\n",
       "      <td>640</td>\n",
       "      <td>227</td>\n",
       "      <td>0</td>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>1720</td>\n",
       "      <td>79</td>\n",
       "      <td>1183</td>\n",
       "      <td>457</td>\n",
       "      <td>1</td>\n",
       "      <td>3208</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        COUNTY               PRECINCT  PRES16D  PRES16D_AB  PRES16D_AD  \\\n",
       "2401  Spalding      SECOND BAPTISH CH      741          27         336   \n",
       "2402  Spalding               FAIRMONT      855          57         414   \n",
       "2403  Spalding          SENIOR CENTER      192          20         120   \n",
       "2404  Spalding             THIRD WARD      180          10         100   \n",
       "2405  Spalding             UGA CAMPUS      975          24         528   \n",
       "2406  Spalding              CITY PARK      839          36         447   \n",
       "2407  Spalding        FIRST METHODIST      227          12         139   \n",
       "2408  Spalding      BOY SCOUTS HDQTRS      267          10         154   \n",
       "2409  Spalding                  CABIN      151           3         101   \n",
       "2410  Spalding                 CARVER      380          11         203   \n",
       "2411  Spalding      FIRST PRESBYTERIA      425          19         259   \n",
       "2412  Spalding                LIBERTY      177          10          90   \n",
       "2413  Spalding            COUNTY LINE      171           7          88   \n",
       "2414  Spalding      SUNNYSIDE METHODI      235           7         104   \n",
       "2415  Spalding                BLALOCK       44           0          16   \n",
       "2416  Spalding              GARY REID      837          39         471   \n",
       "2417  Spalding                 AMBUCS      347          11         200   \n",
       "2418  Spalding              COMMUNITY      759          29         410   \n",
       "2419  Spalding         FIRST ASSEMBLY      405          14         235   \n",
       "2420  Spalding                ROBERTS      219           7         121   \n",
       "2421  Spalding  EAGES LANDING BAPTIST      931          64         640   \n",
       "\n",
       "      PRES16D_ED  PRES16D_PR  PRES16L  PRES16L_AB  PRES16L_AD  PRES16L_ED  \\\n",
       "2401         376           2        8           0           3           5   \n",
       "2402         384           0       11           0           5           6   \n",
       "2403          52           0       39           3          22          14   \n",
       "2404          70           0       38           1          14          23   \n",
       "2405         422           1       56           2          34          20   \n",
       "2406         356           0       15           0          11           4   \n",
       "2407          76           0       42           3          10          29   \n",
       "2408         103           0       25           4          12           9   \n",
       "2409          47           0       25           1          12          12   \n",
       "2410         164           2       27           1          16          10   \n",
       "2411         145           2       33           3          14          16   \n",
       "2412          77           0       18           2           2          14   \n",
       "2413          75           1       41           2          10          29   \n",
       "2414         124           0       33           1          10          22   \n",
       "2415          28           0       12           0           4           8   \n",
       "2416         327           0       27           2          14          11   \n",
       "2417         136           0       16           0           7           9   \n",
       "2418         320           0       16           0           8           8   \n",
       "2419         156           0       39           1          21          17   \n",
       "2420          91           0       20           0           6          14   \n",
       "2421         227           0       56           1          34          21   \n",
       "\n",
       "      PRES16L_PR  PRES16R  PRES16R_AB  PRES16R_AD  PRES16R_ED  PRES16R_PR  \\\n",
       "2401           0      101           5          59          37           0   \n",
       "2402           0       72           3          46          23           0   \n",
       "2403           0      740          39         544         157           0   \n",
       "2404           0      634          33         397         204           0   \n",
       "2405           0      831          46         589         196           0   \n",
       "2406           0      221          18         141          62           0   \n",
       "2407           0      883          34         588         261           0   \n",
       "2408           0      867          28         600         239           0   \n",
       "2409           0      927          30         505         391           1   \n",
       "2410           0      796          32         511         253           0   \n",
       "2411           0      998          39         668         289           2   \n",
       "2412           0      766          25         378         363           0   \n",
       "2413           0     1261          30         643         587           1   \n",
       "2414           0      722          23         342         357           0   \n",
       "2415           0      368           6         105         257           0   \n",
       "2416           0      611          30         359         221           1   \n",
       "2417           0      672          22         381         268           1   \n",
       "2418           0      123           5          78          40           0   \n",
       "2419           0     1248          60         765         422           1   \n",
       "2420           0     1085          27         680         377           1   \n",
       "2421           0     1720          79        1183         457           1   \n",
       "\n",
       "      REG_VOTE  \n",
       "2401      1582  \n",
       "2402      1588  \n",
       "2403      1254  \n",
       "2404      1083  \n",
       "2405      2939  \n",
       "2406      1762  \n",
       "2407      1377  \n",
       "2408      1432  \n",
       "2409      1419  \n",
       "2410      1500  \n",
       "2411      1852  \n",
       "2412      1222  \n",
       "2413      1875  \n",
       "2414      1444  \n",
       "2415       501  \n",
       "2416      2099  \n",
       "2417      1529  \n",
       "2418      1340  \n",
       "2419      2131  \n",
       "2420      1695  \n",
       "2421      3208  "
      ]
     },
     "execution_count": 471,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df[\"COUNTY\"] == \"Spalding\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 472,
   "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>ID</th>\n",
       "      <th>POPULATION</th>\n",
       "      <th>DISTRICT</th>\n",
       "      <th>PRECINCT_I</th>\n",
       "      <th>PRECINCT_N</th>\n",
       "      <th>CTYNAME</th>\n",
       "      <th>FIPS1</th>\n",
       "      <th>FIPS2</th>\n",
       "      <th>PRES16D</th>\n",
       "      <th>PRES16R</th>\n",
       "      <th>...</th>\n",
       "      <th>BVAP</th>\n",
       "      <th>AMINVAP</th>\n",
       "      <th>ASIANVAP</th>\n",
       "      <th>NHPIVAP</th>\n",
       "      <th>OTHERVAP</th>\n",
       "      <th>2MOREVAP</th>\n",
       "      <th>CONDIST</th>\n",
       "      <th>HDIST</th>\n",
       "      <th>SENDIST</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>1054638</td>\n",
       "      <td>3210</td>\n",
       "      <td>25514</td>\n",
       "      <td>14</td>\n",
       "      <td>19</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>235</td>\n",
       "      <td>722</td>\n",
       "      <td>...</td>\n",
       "      <td>316</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>003</td>\n",
       "      <td>073</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.247136 33.338347, -84.247125 33....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>595</th>\n",
       "      <td>1089620</td>\n",
       "      <td>2656</td>\n",
       "      <td>25509</td>\n",
       "      <td>09</td>\n",
       "      <td>04</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>151</td>\n",
       "      <td>927</td>\n",
       "      <td>...</td>\n",
       "      <td>132</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>003</td>\n",
       "      <td>130</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.08899099999999 33.285646, -84.08...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>598</th>\n",
       "      <td>816003</td>\n",
       "      <td>829</td>\n",
       "      <td>25515</td>\n",
       "      <td>15</td>\n",
       "      <td>02</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>44</td>\n",
       "      <td>368</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>003</td>\n",
       "      <td>073</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.50851299999999 33.239846, -84.50...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>610</th>\n",
       "      <td>989093</td>\n",
       "      <td>2143</td>\n",
       "      <td>25512</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>177</td>\n",
       "      <td>766</td>\n",
       "      <td>...</td>\n",
       "      <td>160</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>003</td>\n",
       "      <td>073</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.437512 33.208678, -84.442915 33....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>611</th>\n",
       "      <td>989165</td>\n",
       "      <td>3714</td>\n",
       "      <td>25519</td>\n",
       "      <td>19</td>\n",
       "      <td>11</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>405</td>\n",
       "      <td>1248</td>\n",
       "      <td>...</td>\n",
       "      <td>426</td>\n",
       "      <td>11</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>003</td>\n",
       "      <td>073</td>\n",
       "      <td>016</td>\n",
       "      <td>(POLYGON ((-84.419723 33.289229, -84.419655000...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>654</th>\n",
       "      <td>1015373</td>\n",
       "      <td>1822</td>\n",
       "      <td>25503</td>\n",
       "      <td>03</td>\n",
       "      <td>18</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>192</td>\n",
       "      <td>740</td>\n",
       "      <td>...</td>\n",
       "      <td>106</td>\n",
       "      <td>2</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>003</td>\n",
       "      <td>130</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.244934 33.229792, -84.2449309999...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>655</th>\n",
       "      <td>1015495</td>\n",
       "      <td>3276</td>\n",
       "      <td>25502</td>\n",
       "      <td>02</td>\n",
       "      <td>10</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>855</td>\n",
       "      <td>72</td>\n",
       "      <td>...</td>\n",
       "      <td>2000</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>003</td>\n",
       "      <td>130</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.243694 33.248529, -84.243719 33....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>656</th>\n",
       "      <td>1015584</td>\n",
       "      <td>2322</td>\n",
       "      <td>25518</td>\n",
       "      <td>18</td>\n",
       "      <td>07</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>759</td>\n",
       "      <td>123</td>\n",
       "      <td>...</td>\n",
       "      <td>1263</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>003</td>\n",
       "      <td>073</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.253989 33.303513, -84.247848 33....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>657</th>\n",
       "      <td>1015655</td>\n",
       "      <td>3019</td>\n",
       "      <td>25517</td>\n",
       "      <td>17</td>\n",
       "      <td>01</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>347</td>\n",
       "      <td>672</td>\n",
       "      <td>...</td>\n",
       "      <td>508</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>003</td>\n",
       "      <td>130</td>\n",
       "      <td>016</td>\n",
       "      <td>(POLYGON ((-84.22183200000001 33.234187, -84.2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>658</th>\n",
       "      <td>1063865</td>\n",
       "      <td>3170</td>\n",
       "      <td>25521</td>\n",
       "      <td>21</td>\n",
       "      <td>09</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>931</td>\n",
       "      <td>1720</td>\n",
       "      <td>...</td>\n",
       "      <td>399</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>003</td>\n",
       "      <td>130</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.136798 33.308318, -84.1366419999...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668</th>\n",
       "      <td>1025485</td>\n",
       "      <td>3067</td>\n",
       "      <td>25520</td>\n",
       "      <td>20</td>\n",
       "      <td>16</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>219</td>\n",
       "      <td>1085</td>\n",
       "      <td>...</td>\n",
       "      <td>243</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>003</td>\n",
       "      <td>130</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.123767 33.202824, -84.123783 33....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>669</th>\n",
       "      <td>1025551</td>\n",
       "      <td>3670</td>\n",
       "      <td>25513</td>\n",
       "      <td>13</td>\n",
       "      <td>08</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>171</td>\n",
       "      <td>1261</td>\n",
       "      <td>...</td>\n",
       "      <td>130</td>\n",
       "      <td>4</td>\n",
       "      <td>22</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>003</td>\n",
       "      <td>073</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.35941 33.35255, -84.359217 33.35...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>672</th>\n",
       "      <td>998189</td>\n",
       "      <td>4699</td>\n",
       "      <td>25506</td>\n",
       "      <td>06</td>\n",
       "      <td>06</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>839</td>\n",
       "      <td>221</td>\n",
       "      <td>...</td>\n",
       "      <td>2190</td>\n",
       "      <td>8</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>003</td>\n",
       "      <td>130</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.290627 33.247425, -84.2884229999...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>673</th>\n",
       "      <td>998306</td>\n",
       "      <td>4259</td>\n",
       "      <td>25516</td>\n",
       "      <td>16</td>\n",
       "      <td>14</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>837</td>\n",
       "      <td>611</td>\n",
       "      <td>...</td>\n",
       "      <td>1249</td>\n",
       "      <td>13</td>\n",
       "      <td>47</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>30</td>\n",
       "      <td>003</td>\n",
       "      <td>073</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.27658 33.257456, -84.276582 33.2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>676</th>\n",
       "      <td>994154</td>\n",
       "      <td>3245</td>\n",
       "      <td>25510</td>\n",
       "      <td>10</td>\n",
       "      <td>05</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>380</td>\n",
       "      <td>796</td>\n",
       "      <td>...</td>\n",
       "      <td>601</td>\n",
       "      <td>2</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>003</td>\n",
       "      <td>073</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.31667899999999 33.189326, -84.32...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>677</th>\n",
       "      <td>994266</td>\n",
       "      <td>2268</td>\n",
       "      <td>25508</td>\n",
       "      <td>08</td>\n",
       "      <td>03</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>267</td>\n",
       "      <td>867</td>\n",
       "      <td>...</td>\n",
       "      <td>248</td>\n",
       "      <td>8</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>003</td>\n",
       "      <td>073</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.293649 33.189194, -84.297887 33....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>678</th>\n",
       "      <td>994332</td>\n",
       "      <td>5735</td>\n",
       "      <td>25505</td>\n",
       "      <td>05</td>\n",
       "      <td>21</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>975</td>\n",
       "      <td>831</td>\n",
       "      <td>...</td>\n",
       "      <td>1579</td>\n",
       "      <td>10</td>\n",
       "      <td>136</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>38</td>\n",
       "      <td>003</td>\n",
       "      <td>130</td>\n",
       "      <td>016</td>\n",
       "      <td>(POLYGON ((-84.284019 33.256053, -84.284450000...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>679</th>\n",
       "      <td>1010402</td>\n",
       "      <td>2075</td>\n",
       "      <td>25507</td>\n",
       "      <td>07</td>\n",
       "      <td>12</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>227</td>\n",
       "      <td>883</td>\n",
       "      <td>...</td>\n",
       "      <td>133</td>\n",
       "      <td>3</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>003</td>\n",
       "      <td>130</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.25761199999999 33.209581, -84.25...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>680</th>\n",
       "      <td>1010473</td>\n",
       "      <td>3018</td>\n",
       "      <td>25511</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>425</td>\n",
       "      <td>998</td>\n",
       "      <td>...</td>\n",
       "      <td>449</td>\n",
       "      <td>5</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>003</td>\n",
       "      <td>130</td>\n",
       "      <td>016</td>\n",
       "      <td>(POLYGON ((-84.238744 33.188898, -84.239752 33...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>681</th>\n",
       "      <td>1010601</td>\n",
       "      <td>4198</td>\n",
       "      <td>25501</td>\n",
       "      <td>01</td>\n",
       "      <td>17</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>741</td>\n",
       "      <td>101</td>\n",
       "      <td>...</td>\n",
       "      <td>2257</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>003</td>\n",
       "      <td>130</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.28842299999999 33.247408, -84.29...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>682</th>\n",
       "      <td>1010696</td>\n",
       "      <td>1678</td>\n",
       "      <td>25504</td>\n",
       "      <td>04</td>\n",
       "      <td>20</td>\n",
       "      <td>Spalding</td>\n",
       "      <td>13255</td>\n",
       "      <td>255</td>\n",
       "      <td>180</td>\n",
       "      <td>634</td>\n",
       "      <td>...</td>\n",
       "      <td>98</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>003</td>\n",
       "      <td>130</td>\n",
       "      <td>016</td>\n",
       "      <td>POLYGON ((-84.247531 33.240555, -84.247777 33....</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID  POPULATION DISTRICT PRECINCT_I PRECINCT_N   CTYNAME  FIPS1  \\\n",
       "165  1054638        3210    25514         14         19  Spalding  13255   \n",
       "595  1089620        2656    25509         09         04  Spalding  13255   \n",
       "598   816003         829    25515         15         02  Spalding  13255   \n",
       "610   989093        2143    25512         12         15  Spalding  13255   \n",
       "611   989165        3714    25519         19         11  Spalding  13255   \n",
       "654  1015373        1822    25503         03         18  Spalding  13255   \n",
       "655  1015495        3276    25502         02         10  Spalding  13255   \n",
       "656  1015584        2322    25518         18         07  Spalding  13255   \n",
       "657  1015655        3019    25517         17         01  Spalding  13255   \n",
       "658  1063865        3170    25521         21         09  Spalding  13255   \n",
       "668  1025485        3067    25520         20         16  Spalding  13255   \n",
       "669  1025551        3670    25513         13         08  Spalding  13255   \n",
       "672   998189        4699    25506         06         06  Spalding  13255   \n",
       "673   998306        4259    25516         16         14  Spalding  13255   \n",
       "676   994154        3245    25510         10         05  Spalding  13255   \n",
       "677   994266        2268    25508         08         03  Spalding  13255   \n",
       "678   994332        5735    25505         05         21  Spalding  13255   \n",
       "679  1010402        2075    25507         07         12  Spalding  13255   \n",
       "680  1010473        3018    25511         11         13  Spalding  13255   \n",
       "681  1010601        4198    25501         01         17  Spalding  13255   \n",
       "682  1010696        1678    25504         04         20  Spalding  13255   \n",
       "\n",
       "    FIPS2 PRES16D PRES16R  ...  BVAP AMINVAP ASIANVAP NHPIVAP  OTHERVAP  \\\n",
       "165   255     235     722  ...   316       7        8       0         3   \n",
       "595   255     151     927  ...   132       5       10       0         1   \n",
       "598   255      44     368  ...     9       3        2       0         0   \n",
       "610   255     177     766  ...   160       3        7       0         0   \n",
       "611   255     405    1248  ...   426      11       26       0         1   \n",
       "654   255     192     740  ...   106       2       13       0         0   \n",
       "655   255     855      72  ...  2000       7        3       4         0   \n",
       "656   255     759     123  ...  1263       6        0       5         0   \n",
       "657   255     347     672  ...   508       6        3       3         0   \n",
       "658   255     931    1720  ...   399       6        9       1         1   \n",
       "668   255     219    1085  ...   243       3        8       0         0   \n",
       "669   255     171    1261  ...   130       4       22       3         0   \n",
       "672   255     839     221  ...  2190       8       19       0         0   \n",
       "673   255     837     611  ...  1249      13       47       1         3   \n",
       "676   255     380     796  ...   601       2       37       0         1   \n",
       "677   255     267     867  ...   248       8       21       0         0   \n",
       "678   255     975     831  ...  1579      10      136       3         5   \n",
       "679   255     227     883  ...   133       3       17       0         5   \n",
       "680   255     425     998  ...   449       5       25       0         1   \n",
       "681   255     741     101  ...  2257       5        1       2         0   \n",
       "682   255     180     634  ...    98       5        7       0         0   \n",
       "\n",
       "     2MOREVAP  CONDIST  HDIST  SENDIST  \\\n",
       "165         8      003    073      016   \n",
       "595        24      003    130      016   \n",
       "598         2      003    073      016   \n",
       "610        11      003    073      016   \n",
       "611        23      003    073      016   \n",
       "654         9      003    130      016   \n",
       "655        17      003    130      016   \n",
       "656        21      003    073      016   \n",
       "657        25      003    130      016   \n",
       "658        18      003    130      016   \n",
       "668        19      003    130      016   \n",
       "669        21      003    073      016   \n",
       "672        32      003    130      016   \n",
       "673        30      003    073      016   \n",
       "676        12      003    073      016   \n",
       "677        13      003    073      016   \n",
       "678        38      003    130      016   \n",
       "679         9      003    130      016   \n",
       "680        18      003    130      016   \n",
       "681        32      003    130      016   \n",
       "682        11      003    130      016   \n",
       "\n",
       "                                              geometry  \n",
       "165  POLYGON ((-84.247136 33.338347, -84.247125 33....  \n",
       "595  POLYGON ((-84.08899099999999 33.285646, -84.08...  \n",
       "598  POLYGON ((-84.50851299999999 33.239846, -84.50...  \n",
       "610  POLYGON ((-84.437512 33.208678, -84.442915 33....  \n",
       "611  (POLYGON ((-84.419723 33.289229, -84.419655000...  \n",
       "654  POLYGON ((-84.244934 33.229792, -84.2449309999...  \n",
       "655  POLYGON ((-84.243694 33.248529, -84.243719 33....  \n",
       "656  POLYGON ((-84.253989 33.303513, -84.247848 33....  \n",
       "657  (POLYGON ((-84.22183200000001 33.234187, -84.2...  \n",
       "658  POLYGON ((-84.136798 33.308318, -84.1366419999...  \n",
       "668  POLYGON ((-84.123767 33.202824, -84.123783 33....  \n",
       "669  POLYGON ((-84.35941 33.35255, -84.359217 33.35...  \n",
       "672  POLYGON ((-84.290627 33.247425, -84.2884229999...  \n",
       "673  POLYGON ((-84.27658 33.257456, -84.276582 33.2...  \n",
       "676  POLYGON ((-84.31667899999999 33.189326, -84.32...  \n",
       "677  POLYGON ((-84.293649 33.189194, -84.297887 33....  \n",
       "678  (POLYGON ((-84.284019 33.256053, -84.284450000...  \n",
       "679  POLYGON ((-84.25761199999999 33.209581, -84.25...  \n",
       "680  (POLYGON ((-84.238744 33.188898, -84.239752 33...  \n",
       "681  POLYGON ((-84.28842299999999 33.247408, -84.29...  \n",
       "682  POLYGON ((-84.247531 33.240555, -84.247777 33....  \n",
       "\n",
       "[21 rows x 43 columns]"
      ]
     },
     "execution_count": 472,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf[gdf[\"CTYNAME\"] == \"Spalding\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This one is wild! I suppose our next course of action is try and figure out where these landmarks (\"SENIOR CENTER\", \"CITY PARK\") are and then match that to our precinct geometries. We could also talk to the county for more information."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Bacon"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "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>COUNTY</th>\n",
       "      <th>PRECINCT</th>\n",
       "      <th>PRES16D</th>\n",
       "      <th>PRES16D_AB</th>\n",
       "      <th>PRES16D_AD</th>\n",
       "      <th>PRES16D_ED</th>\n",
       "      <th>PRES16D_PR</th>\n",
       "      <th>PRES16L</th>\n",
       "      <th>PRES16L_AB</th>\n",
       "      <th>PRES16L_AD</th>\n",
       "      <th>PRES16L_ED</th>\n",
       "      <th>PRES16L_PR</th>\n",
       "      <th>PRES16R</th>\n",
       "      <th>PRES16R_AB</th>\n",
       "      <th>PRES16R_AD</th>\n",
       "      <th>PRES16R_ED</th>\n",
       "      <th>PRES16R_PR</th>\n",
       "      <th>REG_VOTE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Bacon</td>\n",
       "      <td>Pearson County</td>\n",
       "      <td>136</td>\n",
       "      <td>10</td>\n",
       "      <td>66</td>\n",
       "      <td>59</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>850</td>\n",
       "      <td>25</td>\n",
       "      <td>550</td>\n",
       "      <td>271</td>\n",
       "      <td>4</td>\n",
       "      <td>1339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Bacon</td>\n",
       "      <td>Axson</td>\n",
       "      <td>29</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>375</td>\n",
       "      <td>10</td>\n",
       "      <td>144</td>\n",
       "      <td>221</td>\n",
       "      <td>0</td>\n",
       "      <td>561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Bacon</td>\n",
       "      <td>Willacoochee</td>\n",
       "      <td>257</td>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>179</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>489</td>\n",
       "      <td>14</td>\n",
       "      <td>191</td>\n",
       "      <td>283</td>\n",
       "      <td>1</td>\n",
       "      <td>1064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Bacon</td>\n",
       "      <td>Pearson City</td>\n",
       "      <td>275</td>\n",
       "      <td>14</td>\n",
       "      <td>147</td>\n",
       "      <td>114</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>164</td>\n",
       "      <td>9</td>\n",
       "      <td>87</td>\n",
       "      <td>68</td>\n",
       "      <td>0</td>\n",
       "      <td>731</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   COUNTY        PRECINCT  PRES16D  PRES16D_AB  PRES16D_AD  PRES16D_ED  \\\n",
       "18  Bacon  Pearson County      136          10          66          59   \n",
       "19  Bacon           Axson       29           2          12          15   \n",
       "20  Bacon    Willacoochee      257           4          74         179   \n",
       "21  Bacon    Pearson City      275          14         147         114   \n",
       "\n",
       "    PRES16D_PR  PRES16L  PRES16L_AB  PRES16L_AD  PRES16L_ED  PRES16L_PR  \\\n",
       "18           1        6           0           1           5           0   \n",
       "19           0        4           0           1           3           0   \n",
       "20           0       16           1           3          12           0   \n",
       "21           0        9           0           5           4           0   \n",
       "\n",
       "    PRES16R  PRES16R_AB  PRES16R_AD  PRES16R_ED  PRES16R_PR  REG_VOTE  \n",
       "18      850          25         550         271           4      1339  \n",
       "19      375          10         144         221           0       561  \n",
       "20      489          14         191         283           1      1064  \n",
       "21      164           9          87          68           0       731  "
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df[\"COUNTY\"] == \"Bacon\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>ID</th>\n",
       "      <th>POPULATION</th>\n",
       "      <th>DISTRICT</th>\n",
       "      <th>PRECINCT_I</th>\n",
       "      <th>PRECINCT_N</th>\n",
       "      <th>CTYNAME</th>\n",
       "      <th>FIPS1</th>\n",
       "      <th>FIPS2</th>\n",
       "      <th>PRES16D</th>\n",
       "      <th>PRES16R</th>\n",
       "      <th>...</th>\n",
       "      <th>BVAP</th>\n",
       "      <th>AMINVAP</th>\n",
       "      <th>ASIANVAP</th>\n",
       "      <th>NHPIVAP</th>\n",
       "      <th>OTHERVAP</th>\n",
       "      <th>2MOREVAP</th>\n",
       "      <th>CONDIST</th>\n",
       "      <th>HDIST</th>\n",
       "      <th>SENDIST</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>728</th>\n",
       "      <td>2300131</td>\n",
       "      <td>1978</td>\n",
       "      <td>005NEW L</td>\n",
       "      <td>NEW L</td>\n",
       "      <td>NEW LACY</td>\n",
       "      <td>Bacon</td>\n",
       "      <td>13005</td>\n",
       "      <td>005</td>\n",
       "      <td>58</td>\n",
       "      <td>696</td>\n",
       "      <td>...</td>\n",
       "      <td>109</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>001</td>\n",
       "      <td>169</td>\n",
       "      <td>007</td>\n",
       "      <td>POLYGON ((-82.31152299999999 31.590997, -82.31...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>787</th>\n",
       "      <td>1443845</td>\n",
       "      <td>848</td>\n",
       "      <td>005WARE</td>\n",
       "      <td>WARE</td>\n",
       "      <td>WARE</td>\n",
       "      <td>Bacon</td>\n",
       "      <td>13005</td>\n",
       "      <td>005</td>\n",
       "      <td>25</td>\n",
       "      <td>328</td>\n",
       "      <td>...</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>001</td>\n",
       "      <td>169</td>\n",
       "      <td>007</td>\n",
       "      <td>POLYGON ((-82.455321 31.491416, -82.453571 31....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1082</th>\n",
       "      <td>2292290</td>\n",
       "      <td>1483</td>\n",
       "      <td>005TAYLO</td>\n",
       "      <td>TAYLO</td>\n",
       "      <td>TAYLOR</td>\n",
       "      <td>Bacon</td>\n",
       "      <td>13005</td>\n",
       "      <td>005</td>\n",
       "      <td>30</td>\n",
       "      <td>521</td>\n",
       "      <td>...</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>001</td>\n",
       "      <td>169</td>\n",
       "      <td>007</td>\n",
       "      <td>POLYGON ((-82.595156 31.53239, -82.59652199999...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1083</th>\n",
       "      <td>2292423</td>\n",
       "      <td>520</td>\n",
       "      <td>005WARNO</td>\n",
       "      <td>WARNO</td>\n",
       "      <td>WARNOCK</td>\n",
       "      <td>Bacon</td>\n",
       "      <td>13005</td>\n",
       "      <td>005</td>\n",
       "      <td>18</td>\n",
       "      <td>241</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>001</td>\n",
       "      <td>169</td>\n",
       "      <td>007</td>\n",
       "      <td>POLYGON ((-82.40184000000001 31.63957, -82.401...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1091</th>\n",
       "      <td>2285630</td>\n",
       "      <td>6267</td>\n",
       "      <td>005DOUGL</td>\n",
       "      <td>DOUGL</td>\n",
       "      <td>DOUGLAS</td>\n",
       "      <td>Bacon</td>\n",
       "      <td>13005</td>\n",
       "      <td>005</td>\n",
       "      <td>477</td>\n",
       "      <td>1578</td>\n",
       "      <td>...</td>\n",
       "      <td>1022</td>\n",
       "      <td>4</td>\n",
       "      <td>20</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>001</td>\n",
       "      <td>169</td>\n",
       "      <td>007</td>\n",
       "      <td>POLYGON ((-82.433916 31.504452, -82.434225 31....</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           ID  POPULATION  DISTRICT PRECINCT_I PRECINCT_N CTYNAME  FIPS1  \\\n",
       "728   2300131        1978  005NEW L      NEW L   NEW LACY   Bacon  13005   \n",
       "787   1443845         848   005WARE       WARE       WARE   Bacon  13005   \n",
       "1082  2292290        1483  005TAYLO      TAYLO     TAYLOR   Bacon  13005   \n",
       "1083  2292423         520  005WARNO      WARNO    WARNOCK   Bacon  13005   \n",
       "1091  2285630        6267  005DOUGL      DOUGL    DOUGLAS   Bacon  13005   \n",
       "\n",
       "     FIPS2 PRES16D PRES16R  ...  BVAP AMINVAP ASIANVAP NHPIVAP  OTHERVAP  \\\n",
       "728    005      58     696  ...   109       3        1       1         0   \n",
       "787    005      25     328  ...    17       0        1       0         0   \n",
       "1082   005      30     521  ...    31       0        3       0         0   \n",
       "1083   005      18     241  ...     6       0        2       0         0   \n",
       "1091   005     477    1578  ...  1022       4       20       5         1   \n",
       "\n",
       "      2MOREVAP  CONDIST  HDIST  SENDIST  \\\n",
       "728          7      001    169      007   \n",
       "787          4      001    169      007   \n",
       "1082         7      001    169      007   \n",
       "1083         5      001    169      007   \n",
       "1091        26      001    169      007   \n",
       "\n",
       "                                               geometry  \n",
       "728   POLYGON ((-82.31152299999999 31.590997, -82.31...  \n",
       "787   POLYGON ((-82.455321 31.491416, -82.453571 31....  \n",
       "1082  POLYGON ((-82.595156 31.53239, -82.59652199999...  \n",
       "1083  POLYGON ((-82.40184000000001 31.63957, -82.401...  \n",
       "1091  POLYGON ((-82.433916 31.504452, -82.434225 31....  \n",
       "\n",
       "[5 rows x 43 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf[gdf[\"CTYNAME\"] == \"Bacon\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Bibb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 417,
   "metadata": {},
   "outputs": [],
   "source": [
    "merge_by_auto_matching(\"Bibb\", 90).to_csv('./merged/bibb.csv', index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Henry"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 426,
   "metadata": {},
   "outputs": [],
   "source": [
    "merge_by_auto_matching(\"Henry\", 80).to_csv(\"./merged/henry.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Pickens"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 420,
   "metadata": {},
   "outputs": [],
   "source": [
    "merge_by_auto_matching(\"Pickens\", 90).to_csv(\"./merged/pickens.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {},
   "outputs": [],
   "source": [
    "pickens = df[df[\"COUNTY\"] == \"Pickens\"]\n",
    "pickens_gdf = gdf[gdf[\"CTYNAME\"] == \"Pickens\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "metadata": {},
   "outputs": [],
   "source": [
    "columns_to_aggregate = [\n",
    "    'PRES16D', 'PRES16D_AB', 'PRES16D_AD',\n",
    "    'PRES16D_ED', 'PRES16D_PR', 'PRES16L', 'PRES16L_AB', 'PRES16L_AD',\n",
    "    'PRES16L_ED', 'PRES16L_PR', 'PRES16R', 'PRES16R_AB', 'PRES16R_AD',\n",
    "    'PRES16R_ED', 'PRES16R_PR', 'REG_VOTE'\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "pickens # 13"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "pickens_gdf #12"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "COUNTY        Pickens\n",
       "PRECINCT         TATE\n",
       "PRES16D           174\n",
       "PRES16D_AB          6\n",
       "PRES16D_AD        104\n",
       "PRES16D_ED         63\n",
       "PRES16D_PR          1\n",
       "PRES16L            42\n",
       "PRES16L_AB          1\n",
       "PRES16L_AD         29\n",
       "PRES16L_ED         12\n",
       "PRES16L_PR          0\n",
       "PRES16R          1358\n",
       "PRES16R_AB         12\n",
       "PRES16R_AD        822\n",
       "PRES16R_ED        523\n",
       "PRES16R_PR          1\n",
       "REG_VOTE         1992\n",
       "dtype: object"
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_pickens_precincts = pickens.loc[[2252,2253]].sum()\n",
    "merged_pickens_precincts['COUNTY']= 'Pickens'\n",
    "merged_pickens_precincts['PRECINCT']= 'TATE'\n",
    "merged_pickens_precincts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "metadata": {},
   "outputs": [],
   "source": [
    "pickens_dropped=pickens.drop([2252,2253])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "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>COUNTY</th>\n",
       "      <th>PRECINCT</th>\n",
       "      <th>PRES16D</th>\n",
       "      <th>PRES16D_AB</th>\n",
       "      <th>PRES16D_AD</th>\n",
       "      <th>PRES16D_ED</th>\n",
       "      <th>PRES16D_PR</th>\n",
       "      <th>PRES16L</th>\n",
       "      <th>PRES16L_AB</th>\n",
       "      <th>PRES16L_AD</th>\n",
       "      <th>PRES16L_ED</th>\n",
       "      <th>PRES16L_PR</th>\n",
       "      <th>PRES16R</th>\n",
       "      <th>PRES16R_AB</th>\n",
       "      <th>PRES16R_AD</th>\n",
       "      <th>PRES16R_ED</th>\n",
       "      <th>PRES16R_PR</th>\n",
       "      <th>REG_VOTE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Pickens</td>\n",
       "      <td>YELLOW CREEK</td>\n",
       "      <td>365</td>\n",
       "      <td>14</td>\n",
       "      <td>230</td>\n",
       "      <td>120</td>\n",
       "      <td>1</td>\n",
       "      <td>36</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>1725</td>\n",
       "      <td>43</td>\n",
       "      <td>1014</td>\n",
       "      <td>668</td>\n",
       "      <td>0</td>\n",
       "      <td>2562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Pickens</td>\n",
       "      <td>SHARPTOP</td>\n",
       "      <td>340</td>\n",
       "      <td>15</td>\n",
       "      <td>241</td>\n",
       "      <td>84</td>\n",
       "      <td>0</td>\n",
       "      <td>46</td>\n",
       "      <td>2</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>1434</td>\n",
       "      <td>39</td>\n",
       "      <td>926</td>\n",
       "      <td>469</td>\n",
       "      <td>0</td>\n",
       "      <td>2120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Pickens</td>\n",
       "      <td>APPALACHIAN</td>\n",
       "      <td>167</td>\n",
       "      <td>7</td>\n",
       "      <td>115</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>2</td>\n",
       "      <td>14</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>970</td>\n",
       "      <td>15</td>\n",
       "      <td>689</td>\n",
       "      <td>266</td>\n",
       "      <td>0</td>\n",
       "      <td>1463</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Pickens</td>\n",
       "      <td>REFUGE</td>\n",
       "      <td>169</td>\n",
       "      <td>3</td>\n",
       "      <td>119</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>1259</td>\n",
       "      <td>25</td>\n",
       "      <td>838</td>\n",
       "      <td>396</td>\n",
       "      <td>0</td>\n",
       "      <td>1825</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Pickens</td>\n",
       "      <td>HILL</td>\n",
       "      <td>158</td>\n",
       "      <td>5</td>\n",
       "      <td>91</td>\n",
       "      <td>62</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>913</td>\n",
       "      <td>13</td>\n",
       "      <td>576</td>\n",
       "      <td>324</td>\n",
       "      <td>0</td>\n",
       "      <td>1385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Pickens</td>\n",
       "      <td>HINTON</td>\n",
       "      <td>47</td>\n",
       "      <td>2</td>\n",
       "      <td>25</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>404</td>\n",
       "      <td>1</td>\n",
       "      <td>167</td>\n",
       "      <td>236</td>\n",
       "      <td>0</td>\n",
       "      <td>585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Pickens</td>\n",
       "      <td>JERUSALEM</td>\n",
       "      <td>67</td>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>538</td>\n",
       "      <td>6</td>\n",
       "      <td>193</td>\n",
       "      <td>339</td>\n",
       "      <td>0</td>\n",
       "      <td>776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Pickens</td>\n",
       "      <td>LUDVILLE</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>343</td>\n",
       "      <td>2</td>\n",
       "      <td>130</td>\n",
       "      <td>211</td>\n",
       "      <td>0</td>\n",
       "      <td>474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Pickens</td>\n",
       "      <td>NELSON</td>\n",
       "      <td>118</td>\n",
       "      <td>0</td>\n",
       "      <td>54</td>\n",
       "      <td>64</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>750</td>\n",
       "      <td>11</td>\n",
       "      <td>404</td>\n",
       "      <td>335</td>\n",
       "      <td>0</td>\n",
       "      <td>1098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Pickens</td>\n",
       "      <td>TALKING ROCK</td>\n",
       "      <td>104</td>\n",
       "      <td>5</td>\n",
       "      <td>58</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>933</td>\n",
       "      <td>14</td>\n",
       "      <td>553</td>\n",
       "      <td>366</td>\n",
       "      <td>0</td>\n",
       "      <td>1328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Pickens</td>\n",
       "      <td>JASPER</td>\n",
       "      <td>246</td>\n",
       "      <td>12</td>\n",
       "      <td>155</td>\n",
       "      <td>79</td>\n",
       "      <td>0</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>1024</td>\n",
       "      <td>22</td>\n",
       "      <td>710</td>\n",
       "      <td>292</td>\n",
       "      <td>0</td>\n",
       "      <td>1711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Pickens</td>\n",
       "      <td>TATE</td>\n",
       "      <td>174</td>\n",
       "      <td>6</td>\n",
       "      <td>104</td>\n",
       "      <td>63</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>1358</td>\n",
       "      <td>12</td>\n",
       "      <td>822</td>\n",
       "      <td>523</td>\n",
       "      <td>1</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     COUNTY      PRECINCT  PRES16D  PRES16D_AB  PRES16D_AD  PRES16D_ED  \\\n",
       "0   Pickens  YELLOW CREEK      365          14         230         120   \n",
       "1   Pickens      SHARPTOP      340          15         241          84   \n",
       "2   Pickens   APPALACHIAN      167           7         115          45   \n",
       "3   Pickens        REFUGE      169           3         119          47   \n",
       "4   Pickens          HILL      158           5          91          62   \n",
       "5   Pickens        HINTON       47           2          25          20   \n",
       "6   Pickens     JERUSALEM       67           1          33          33   \n",
       "7   Pickens      LUDVILLE       24           0          12          12   \n",
       "8   Pickens        NELSON      118           0          54          64   \n",
       "9   Pickens  TALKING ROCK      104           5          58          41   \n",
       "10  Pickens        JASPER      246          12         155          79   \n",
       "11  Pickens          TATE      174           6         104          63   \n",
       "\n",
       "    PRES16D_PR  PRES16L  PRES16L_AB  PRES16L_AD  PRES16L_ED  PRES16L_PR  \\\n",
       "0            1       36           2          16          18           0   \n",
       "1            0       46           2          22          22           0   \n",
       "2            0       33           2          14          17           0   \n",
       "3            0       29           0          13          16           0   \n",
       "4            0       42           1          15          26           0   \n",
       "5            0       16           0           6          10           0   \n",
       "6            0       12           2           3           7           0   \n",
       "7            0       10           0           1           9           0   \n",
       "8            0       25           0           4          21           0   \n",
       "9            0       19           0          16           3           0   \n",
       "10           0       44           0          20          24           0   \n",
       "11           1       42           1          29          12           0   \n",
       "\n",
       "    PRES16R  PRES16R_AB  PRES16R_AD  PRES16R_ED  PRES16R_PR  REG_VOTE  \n",
       "0      1725          43        1014         668           0      2562  \n",
       "1      1434          39         926         469           0      2120  \n",
       "2       970          15         689         266           0      1463  \n",
       "3      1259          25         838         396           0      1825  \n",
       "4       913          13         576         324           0      1385  \n",
       "5       404           1         167         236           0       585  \n",
       "6       538           6         193         339           0       776  \n",
       "7       343           2         130         211           0       474  \n",
       "8       750          11         404         335           0      1098  \n",
       "9       933          14         553         366           0      1328  \n",
       "10     1024          22         710         292           0      1711  \n",
       "11     1358          12         822         523           1      1992  "
      ]
     },
     "execution_count": 145,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pickens_dropped.append(merged_pickens_precincts,ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "metadata": {},
   "outputs": [],
   "source": [
    "pickens_dropped.to_csv('./merged/pickens.csv',index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Chattooga"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "chattooga = df[df[\"COUNTY\"] == \"Chattooga\"]\n",
    "chattooga_gdf = gdf[gdf[\"CTYNAME\"] == \"Chattooga\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>COUNTY</th>\n",
       "      <th>PRECINCT</th>\n",
       "      <th>PRES16D</th>\n",
       "      <th>PRES16D_AB</th>\n",
       "      <th>PRES16D_AD</th>\n",
       "      <th>PRES16D_ED</th>\n",
       "      <th>PRES16D_PR</th>\n",
       "      <th>PRES16L</th>\n",
       "      <th>PRES16L_AB</th>\n",
       "      <th>PRES16L_AD</th>\n",
       "      <th>PRES16L_ED</th>\n",
       "      <th>PRES16L_PR</th>\n",
       "      <th>PRES16R</th>\n",
       "      <th>PRES16R_AB</th>\n",
       "      <th>PRES16R_AD</th>\n",
       "      <th>PRES16R_ED</th>\n",
       "      <th>PRES16R_PR</th>\n",
       "      <th>REG_VOTE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>Chattooga</td>\n",
       "      <td>CLOUDLAND</td>\n",
       "      <td>58</td>\n",
       "      <td>3</td>\n",
       "      <td>30</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>158</td>\n",
       "      <td>9</td>\n",
       "      <td>43</td>\n",
       "      <td>106</td>\n",
       "      <td>0</td>\n",
       "      <td>275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>347</th>\n",
       "      <td>Chattooga</td>\n",
       "      <td>PENNVILLE</td>\n",
       "      <td>48</td>\n",
       "      <td>3</td>\n",
       "      <td>21</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>272</td>\n",
       "      <td>8</td>\n",
       "      <td>139</td>\n",
       "      <td>125</td>\n",
       "      <td>0</td>\n",
       "      <td>488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>348</th>\n",
       "      <td>Chattooga</td>\n",
       "      <td>COLDWATER</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>106</td>\n",
       "      <td>3</td>\n",
       "      <td>51</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>349</th>\n",
       "      <td>Chattooga</td>\n",
       "      <td>DIRTSELLER</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>106</td>\n",
       "      <td>3</td>\n",
       "      <td>42</td>\n",
       "      <td>61</td>\n",
       "      <td>0</td>\n",
       "      <td>156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>350</th>\n",
       "      <td>Chattooga</td>\n",
       "      <td>HAYWOOD</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>89</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>74</td>\n",
       "      <td>0</td>\n",
       "      <td>133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>351</th>\n",
       "      <td>Chattooga</td>\n",
       "      <td>LYERLY</td>\n",
       "      <td>94</td>\n",
       "      <td>4</td>\n",
       "      <td>34</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>445</td>\n",
       "      <td>7</td>\n",
       "      <td>186</td>\n",
       "      <td>252</td>\n",
       "      <td>0</td>\n",
       "      <td>740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352</th>\n",
       "      <td>Chattooga</td>\n",
       "      <td>TRION</td>\n",
       "      <td>306</td>\n",
       "      <td>14</td>\n",
       "      <td>176</td>\n",
       "      <td>116</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>1589</td>\n",
       "      <td>25</td>\n",
       "      <td>861</td>\n",
       "      <td>702</td>\n",
       "      <td>1</td>\n",
       "      <td>2686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>353</th>\n",
       "      <td>Chattooga</td>\n",
       "      <td>SUMMERVILLE</td>\n",
       "      <td>759</td>\n",
       "      <td>40</td>\n",
       "      <td>453</td>\n",
       "      <td>265</td>\n",
       "      <td>1</td>\n",
       "      <td>67</td>\n",
       "      <td>4</td>\n",
       "      <td>32</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>2099</td>\n",
       "      <td>59</td>\n",
       "      <td>1390</td>\n",
       "      <td>648</td>\n",
       "      <td>2</td>\n",
       "      <td>4046</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>Chattooga</td>\n",
       "      <td>TELOGA</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>14</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>320</td>\n",
       "      <td>5</td>\n",
       "      <td>128</td>\n",
       "      <td>187</td>\n",
       "      <td>0</td>\n",
       "      <td>464</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>Chattooga</td>\n",
       "      <td>DIRTTOWN</td>\n",
       "      <td>96</td>\n",
       "      <td>8</td>\n",
       "      <td>35</td>\n",
       "      <td>53</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>455</td>\n",
       "      <td>7</td>\n",
       "      <td>166</td>\n",
       "      <td>280</td>\n",
       "      <td>2</td>\n",
       "      <td>690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>Chattooga</td>\n",
       "      <td>SEMINOLE</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>77</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>Chattooga</td>\n",
       "      <td>SUBLIGNA</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>295</td>\n",
       "      <td>5</td>\n",
       "      <td>91</td>\n",
       "      <td>199</td>\n",
       "      <td>0</td>\n",
       "      <td>391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>Chattooga</td>\n",
       "      <td>ALPINE</td>\n",
       "      <td>93</td>\n",
       "      <td>4</td>\n",
       "      <td>36</td>\n",
       "      <td>53</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>451</td>\n",
       "      <td>13</td>\n",
       "      <td>146</td>\n",
       "      <td>292</td>\n",
       "      <td>0</td>\n",
       "      <td>713</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        COUNTY     PRECINCT  PRES16D  PRES16D_AB  PRES16D_AD  PRES16D_ED  \\\n",
       "346  Chattooga    CLOUDLAND       58           3          30          25   \n",
       "347  Chattooga    PENNVILLE       48           3          21          24   \n",
       "348  Chattooga    COLDWATER       53           1          10          42   \n",
       "349  Chattooga   DIRTSELLER       16           0           3          13   \n",
       "350  Chattooga      HAYWOOD       15           2           1          12   \n",
       "351  Chattooga       LYERLY       94           4          34          56   \n",
       "352  Chattooga        TRION      306          14         176         116   \n",
       "353  Chattooga  SUMMERVILLE      759          40         453         265   \n",
       "354  Chattooga       TELOGA       40           3          14          23   \n",
       "355  Chattooga     DIRTTOWN       96           8          35          53   \n",
       "356  Chattooga     SEMINOLE        5           0           2           3   \n",
       "357  Chattooga     SUBLIGNA       30           0          12          18   \n",
       "358  Chattooga       ALPINE       93           4          36          53   \n",
       "\n",
       "     PRES16D_PR  PRES16L  PRES16L_AB  PRES16L_AD  PRES16L_ED  PRES16L_PR  \\\n",
       "346           0        5           0           3           2           0   \n",
       "347           0        3           0           1           2           0   \n",
       "348           0        3           0           1           2           0   \n",
       "349           0        0           0           0           0           0   \n",
       "350           0        3           0           1           2           0   \n",
       "351           0       12           0           2          10           0   \n",
       "352           0       36           1          12          23           0   \n",
       "353           1       67           4          32          31           0   \n",
       "354           0       10           0           8           2           0   \n",
       "355           0       11           0           2           9           0   \n",
       "356           0        5           0           2           3           0   \n",
       "357           0        5           0           0           5           0   \n",
       "358           0       17           1           5          11           0   \n",
       "\n",
       "     PRES16R  PRES16R_AB  PRES16R_AD  PRES16R_ED  PRES16R_PR  REG_VOTE  \n",
       "346      158           9          43         106           0       275  \n",
       "347      272           8         139         125           0       488  \n",
       "348      106           3          51          52           0       203  \n",
       "349      106           3          42          61           0       156  \n",
       "350       89           0          15          74           0       133  \n",
       "351      445           7         186         252           0       740  \n",
       "352     1589          25         861         702           1      2686  \n",
       "353     2099          59        1390         648           2      4046  \n",
       "354      320           5         128         187           0       464  \n",
       "355      455           7         166         280           2       690  \n",
       "356       77           0          21          56           0       114  \n",
       "357      295           5          91         199           0       391  \n",
       "358      451          13         146         292           0       713  "
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(chattooga), len(chattooga_gdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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>COUNTY</th>\n",
       "      <th>PRECINCT</th>\n",
       "      <th>PRES16D</th>\n",
       "      <th>PRES16D_AB</th>\n",
       "      <th>PRES16D_AD</th>\n",
       "      <th>PRES16D_ED</th>\n",
       "      <th>PRES16D_PR</th>\n",
       "      <th>PRES16L</th>\n",
       "      <th>PRES16L_AB</th>\n",
       "      <th>PRES16L_AD</th>\n",
       "      <th>PRES16L_ED</th>\n",
       "      <th>PRES16L_PR</th>\n",
       "      <th>PRES16R</th>\n",
       "      <th>PRES16R_AB</th>\n",
       "      <th>PRES16R_AD</th>\n",
       "      <th>PRES16R_ED</th>\n",
       "      <th>PRES16R_PR</th>\n",
       "      <th>REG_VOTE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>Chattooga</td>\n",
       "      <td>CLOUDLAND</td>\n",
       "      <td>58</td>\n",
       "      <td>3</td>\n",
       "      <td>30</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>158</td>\n",
       "      <td>9</td>\n",
       "      <td>43</td>\n",
       "      <td>106</td>\n",
       "      <td>0</td>\n",
       "      <td>275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>Chattooga</td>\n",
       "      <td>TELOGA</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>14</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>320</td>\n",
       "      <td>5</td>\n",
       "      <td>128</td>\n",
       "      <td>187</td>\n",
       "      <td>0</td>\n",
       "      <td>464</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        COUNTY   PRECINCT  PRES16D  PRES16D_AB  PRES16D_AD  PRES16D_ED  \\\n",
       "346  Chattooga  CLOUDLAND       58           3          30          25   \n",
       "354  Chattooga     TELOGA       40           3          14          23   \n",
       "\n",
       "     PRES16D_PR  PRES16L  PRES16L_AB  PRES16L_AD  PRES16L_ED  PRES16L_PR  \\\n",
       "346           0        5           0           3           2           0   \n",
       "354           0       10           0           8           2           0   \n",
       "\n",
       "     PRES16R  PRES16R_AB  PRES16R_AD  PRES16R_ED  PRES16R_PR  REG_VOTE  \n",
       "346      158           9          43         106           0       275  \n",
       "354      320           5         128         187           0       464  "
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "chattooga.loc[[346, 354]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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>ID</th>\n",
       "      <th>POPULATION</th>\n",
       "      <th>DISTRICT</th>\n",
       "      <th>PRECINCT_I</th>\n",
       "      <th>PRECINCT_N</th>\n",
       "      <th>CTYNAME</th>\n",
       "      <th>FIPS1</th>\n",
       "      <th>FIPS2</th>\n",
       "      <th>PRES16D</th>\n",
       "      <th>PRES16R</th>\n",
       "      <th>...</th>\n",
       "      <th>BVAP</th>\n",
       "      <th>AMINVAP</th>\n",
       "      <th>ASIANVAP</th>\n",
       "      <th>NHPIVAP</th>\n",
       "      <th>OTHERVAP</th>\n",
       "      <th>2MOREVAP</th>\n",
       "      <th>CONDIST</th>\n",
       "      <th>HDIST</th>\n",
       "      <th>SENDIST</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1519</th>\n",
       "      <td>3588199</td>\n",
       "      <td>1385</td>\n",
       "      <td>055XC-968</td>\n",
       "      <td>XC-968</td>\n",
       "      <td>CLOULDLAND-TELOGA</td>\n",
       "      <td>Chattooga</td>\n",
       "      <td>13055</td>\n",
       "      <td>55</td>\n",
       "      <td>98</td>\n",
       "      <td>478</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>014</td>\n",
       "      <td>012</td>\n",
       "      <td>053</td>\n",
       "      <td>POLYGON ((-85.40821099999999 34.532039, -85.40...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           ID  POPULATION   DISTRICT PRECINCT_I         PRECINCT_N    CTYNAME  \\\n",
       "1519  3588199        1385  055XC-968     XC-968  CLOULDLAND-TELOGA  Chattooga   \n",
       "\n",
       "      FIPS1 FIPS2 PRES16D PRES16R  ... BVAP AMINVAP ASIANVAP NHPIVAP  \\\n",
       "1519  13055    55      98     478  ...    4       9        2       0   \n",
       "\n",
       "      OTHERVAP  2MOREVAP  CONDIST  HDIST  SENDIST  \\\n",
       "1519         4         6      014    012      053   \n",
       "\n",
       "                                               geometry  \n",
       "1519  POLYGON ((-85.40821099999999 34.532039, -85.40...  \n",
       "\n",
       "[1 rows x 43 columns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "chattooga_gdf.loc[[1519]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "name = \"CLOUDLAND-TELOGA\"\n",
    "def find_cloudland_and_teloga(precinct):\n",
    "    if precinct in name:\n",
    "        return name\n",
    "    else:\n",
    "        return precinct"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_chattooga = chattooga.groupby(chattooga[\"PRECINCT\"].apply(find_cloudland_and_teloga)).sum().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_chattooga[\"COUNTY\"] = \"Chattooga\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 349,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_chattooga.to_csv(\"./merged/chattooga.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Fixing Morgan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "morgan_df = df[df[\"COUNTY\"] == \"Morgan\"]\n",
    "morgan_gdf = gdf[gdf[\"CTYNAME\"] == \"Morgan\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "morgan_match = find_matches(morgan_df, morgan_gdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "mapping = morgan_match.set_index(\"match_index\")[\"index\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "cols = [\"PRES16D\", \"PRES16R\", \"PRES16L\"]\n",
    "patch_rows = pandas.DataFrame({col: mapping.map(morgan_df[col]) for col in cols})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf.update(patch_rows)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf.to_file(\"./shapefiles/GA_precincts16.shp\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Effingham"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 465,
   "metadata": {},
   "outputs": [],
   "source": [
    "effingham_final = merge_by_auto_matching(\"Effingham\", 90)\n",
    "effingham_final.to_csv(\"./merged/effingham.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 466,
   "metadata": {},
   "outputs": [],
   "source": [
    "effingham_df, effingham_gdf = get_county_df_and_gdf(\"Effingham\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Columbia"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_county_df_and_gdf(county, df=df, gdf=gdf):\n",
    "    return df[df[\"COUNTY\"] == county], gdf[gdf[\"CTYNAME\"] == county]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_good_matches(df, gdf, threshold=100):\n",
    "    matches = find_matches(df, gdf)\n",
    "    good_matches = matches[matches[\"rating\"] >= threshold]\n",
    "    mapping = dict(zip(good_matches[\"precinct\"], good_matches[\"match_value\"]))\n",
    "    return mapping"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 206,
   "metadata": {},
   "outputs": [],
   "source": [
    "def assert_mapping(left, right, mapping):\n",
    "    expected_keys = set(left)\n",
    "    keys = set(mapping.keys())\n",
    "    missing_keys = expected_keys - keys\n",
    "    extra_keys = keys - expected_keys\n",
    "    assert len(missing_keys) == 0, f\"Missing expected keys: {missing_keys}\"\n",
    "    assert len(extra_keys) == 0, f\"Found unexpected keys: {extra_keys}\"\n",
    "    values = set(mapping.values())\n",
    "    expected_values = set(right)\n",
    "    missing_values = expected_values - values\n",
    "    extra_values = values - expected_values\n",
    "    assert len(missing_values) == 0, f\"Missing expected values: {missing_values}\"\n",
    "    assert len(extra_values) == 0, f\"Found unexpected values: {extra_values}\"\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [],
   "source": [
    "columbia_df, columbia_gdf = get_county_df_and_gdf(\"Columbia\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [],
   "source": [
    "columbia_matches = find_matches(columbia_df, columbia_gdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "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>county</th>\n",
       "      <th>index</th>\n",
       "      <th>match_index</th>\n",
       "      <th>precinct</th>\n",
       "      <th>rating</th>\n",
       "      <th>match_value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>662</td>\n",
       "      <td>193</td>\n",
       "      <td>Kiokee Baptist Church-10</td>\n",
       "      <td>86</td>\n",
       "      <td>GENESIS CHURCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>663</td>\n",
       "      <td>193</td>\n",
       "      <td>Kiokee Baptist Church-12</td>\n",
       "      <td>86</td>\n",
       "      <td>GENESIS CHURCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>664</td>\n",
       "      <td>209</td>\n",
       "      <td>Lewis Methodist Church</td>\n",
       "      <td>95</td>\n",
       "      <td>LEWIS METHODIST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>665</td>\n",
       "      <td>229</td>\n",
       "      <td>Woodlawn Baptist Church</td>\n",
       "      <td>93</td>\n",
       "      <td>WOODLAWN BAPT CHURCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>666</td>\n",
       "      <td>228</td>\n",
       "      <td>Patriots Park</td>\n",
       "      <td>100</td>\n",
       "      <td>PATRIOTS PARK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>667</td>\n",
       "      <td>1105</td>\n",
       "      <td>Harlem Middle School-10</td>\n",
       "      <td>95</td>\n",
       "      <td>HARLEM MIDDLE SCHOOL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>668</td>\n",
       "      <td>1105</td>\n",
       "      <td>Harlem Middle School-12</td>\n",
       "      <td>95</td>\n",
       "      <td>HARLEM MIDDLE SCHOOL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>669</td>\n",
       "      <td>1104</td>\n",
       "      <td>Harlem Baptist Church-10</td>\n",
       "      <td>90</td>\n",
       "      <td>HARLEM BAPTIST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>670</td>\n",
       "      <td>1104</td>\n",
       "      <td>Harlem Baptist Church-12</td>\n",
       "      <td>90</td>\n",
       "      <td>HARLEM BAPTIST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>671</td>\n",
       "      <td>947</td>\n",
       "      <td>Bessie Thomas Center</td>\n",
       "      <td>100</td>\n",
       "      <td>BESSIE THOMAS CENTER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>672</td>\n",
       "      <td>222</td>\n",
       "      <td>Philadelphia Church</td>\n",
       "      <td>100</td>\n",
       "      <td>PHILADELPHIA CHURCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>673</td>\n",
       "      <td>225</td>\n",
       "      <td>Grovetown City Hall</td>\n",
       "      <td>100</td>\n",
       "      <td>GROVETOWN CITY HALL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>674</td>\n",
       "      <td>226</td>\n",
       "      <td>Grovetown Methodist Church</td>\n",
       "      <td>95</td>\n",
       "      <td>GROVETOWN METHODIST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>675</td>\n",
       "      <td>1164</td>\n",
       "      <td>G A Apostolic Church</td>\n",
       "      <td>100</td>\n",
       "      <td>G A APOSTOLIC CHURCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>676</td>\n",
       "      <td>224</td>\n",
       "      <td>Grovetown Middle School</td>\n",
       "      <td>93</td>\n",
       "      <td>GROVETOWN MIDDLE SCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>677</td>\n",
       "      <td>227</td>\n",
       "      <td>Warren Baptist Church - Grovetown</td>\n",
       "      <td>97</td>\n",
       "      <td>WARREN BAPTIST CHURCH-GROVETOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>678</td>\n",
       "      <td>8</td>\n",
       "      <td>Eubank/Blanchard Center</td>\n",
       "      <td>93</td>\n",
       "      <td>EUBANK/BLANCHARD CTR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>679</td>\n",
       "      <td>2490</td>\n",
       "      <td>Second Mt Carmel Bapt Church</td>\n",
       "      <td>93</td>\n",
       "      <td>SECOND MT. CARMEL BAPTIST CHURCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>680</td>\n",
       "      <td>2489</td>\n",
       "      <td>Damascus Baptist Church</td>\n",
       "      <td>93</td>\n",
       "      <td>DAMASCUS BAPT CHURCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>681</td>\n",
       "      <td>195</td>\n",
       "      <td>Col Cty Bd Of Edu</td>\n",
       "      <td>92</td>\n",
       "      <td>COL CTY BOARD OF EDU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>682</td>\n",
       "      <td>2</td>\n",
       "      <td>Greenbrier High</td>\n",
       "      <td>100</td>\n",
       "      <td>GREENBRIER HIGH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>683</td>\n",
       "      <td>210</td>\n",
       "      <td>Redeemer Church</td>\n",
       "      <td>100</td>\n",
       "      <td>REDEEMER CHURCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>684</td>\n",
       "      <td>3</td>\n",
       "      <td>Riverside Elementary</td>\n",
       "      <td>100</td>\n",
       "      <td>RIVERSIDE ELEMENTARY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>685</td>\n",
       "      <td>1</td>\n",
       "      <td>Grace Baptist Church</td>\n",
       "      <td>100</td>\n",
       "      <td>GRACE BAPTIST CHURCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>686</td>\n",
       "      <td>194</td>\n",
       "      <td>Christ Sanctified</td>\n",
       "      <td>100</td>\n",
       "      <td>CHRIST SANCTIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>687</td>\n",
       "      <td>1168</td>\n",
       "      <td>Blanchard Park</td>\n",
       "      <td>100</td>\n",
       "      <td>BLANCHARD PARK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>688</td>\n",
       "      <td>196</td>\n",
       "      <td>Mtz Col Fire Dept #4</td>\n",
       "      <td>100</td>\n",
       "      <td>MTZ COL FIRE DEPT #4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>689</td>\n",
       "      <td>1165</td>\n",
       "      <td>Belair Baptist Church</td>\n",
       "      <td>100</td>\n",
       "      <td>BELAIR BAPTIST CHURCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>690</td>\n",
       "      <td>197</td>\n",
       "      <td>Marvin Methodist Church</td>\n",
       "      <td>95</td>\n",
       "      <td>MARVIN METHODIST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>691</td>\n",
       "      <td>1137</td>\n",
       "      <td>Westside Bapt Church</td>\n",
       "      <td>100</td>\n",
       "      <td>WESTSIDE BAPT CHURCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>692</td>\n",
       "      <td>198</td>\n",
       "      <td>Trinity Bapt Church</td>\n",
       "      <td>100</td>\n",
       "      <td>TRINITY BAPT CHURCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>693</td>\n",
       "      <td>1138</td>\n",
       "      <td>Abilene Baptist</td>\n",
       "      <td>100</td>\n",
       "      <td>ABILENE BAPTIST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>694</td>\n",
       "      <td>191</td>\n",
       "      <td>Augusta Christian</td>\n",
       "      <td>100</td>\n",
       "      <td>AUGUSTA CHRISTIAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>695</td>\n",
       "      <td>192</td>\n",
       "      <td>Stevens Creek Elem</td>\n",
       "      <td>100</td>\n",
       "      <td>STEVENS CREEK ELEM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>696</td>\n",
       "      <td>6</td>\n",
       "      <td>Gospel Water Branch</td>\n",
       "      <td>100</td>\n",
       "      <td>GOSPEL WATER BRANCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>697</td>\n",
       "      <td>193</td>\n",
       "      <td>Genesis Church</td>\n",
       "      <td>100</td>\n",
       "      <td>GENESIS CHURCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>698</td>\n",
       "      <td>183</td>\n",
       "      <td>Stevens Creek Church</td>\n",
       "      <td>100</td>\n",
       "      <td>STEVENS CREEK CHURCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>699</td>\n",
       "      <td>1139</td>\n",
       "      <td>Mtz Col Fire Hdqtr</td>\n",
       "      <td>100</td>\n",
       "      <td>MTZ COL FIRE HDQTR.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>700</td>\n",
       "      <td>1142</td>\n",
       "      <td>Lakeside Middle</td>\n",
       "      <td>100</td>\n",
       "      <td>LAKESIDE MIDDLE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>701</td>\n",
       "      <td>1141</td>\n",
       "      <td>Martinez Baptist</td>\n",
       "      <td>100</td>\n",
       "      <td>MARTINEZ BAPTIST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>702</td>\n",
       "      <td>199</td>\n",
       "      <td>Gold Cross EMS</td>\n",
       "      <td>100</td>\n",
       "      <td>GOLD CROSS EMS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>703</td>\n",
       "      <td>200</td>\n",
       "      <td>Church of our Savior</td>\n",
       "      <td>100</td>\n",
       "      <td>CHURCH OF OUR SAVIOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>704</td>\n",
       "      <td>201</td>\n",
       "      <td>West Acres Baptist</td>\n",
       "      <td>100</td>\n",
       "      <td>WEST ACRES BAPTIST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>705</td>\n",
       "      <td>0</td>\n",
       "      <td>Journey Comm. Church</td>\n",
       "      <td>100</td>\n",
       "      <td>JOURNEY COMM. CHURCH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>706</td>\n",
       "      <td>4</td>\n",
       "      <td>Wesley Methodist</td>\n",
       "      <td>100</td>\n",
       "      <td>WESLEY METHODIST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>707</td>\n",
       "      <td>202</td>\n",
       "      <td>Col Cty Main Library</td>\n",
       "      <td>100</td>\n",
       "      <td>COL CTY MAIN LIBRARY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>708</td>\n",
       "      <td>5</td>\n",
       "      <td>Christ Church</td>\n",
       "      <td>90</td>\n",
       "      <td>CHRIST CHURCH, PRESBYTERIAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>709</td>\n",
       "      <td>186</td>\n",
       "      <td>Blue Ridge Elementary</td>\n",
       "      <td>98</td>\n",
       "      <td>BLUERIDGE ELEMENTARY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>710</td>\n",
       "      <td>187</td>\n",
       "      <td>Christ The King Luth Ch</td>\n",
       "      <td>95</td>\n",
       "      <td>CHRIST THE KING CH</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      county  index  match_index                           precinct  rating  \\\n",
       "0   Columbia    662          193           Kiokee Baptist Church-10      86   \n",
       "1   Columbia    663          193           Kiokee Baptist Church-12      86   \n",
       "2   Columbia    664          209             Lewis Methodist Church      95   \n",
       "3   Columbia    665          229            Woodlawn Baptist Church      93   \n",
       "4   Columbia    666          228                      Patriots Park     100   \n",
       "5   Columbia    667         1105            Harlem Middle School-10      95   \n",
       "6   Columbia    668         1105            Harlem Middle School-12      95   \n",
       "7   Columbia    669         1104           Harlem Baptist Church-10      90   \n",
       "8   Columbia    670         1104           Harlem Baptist Church-12      90   \n",
       "9   Columbia    671          947               Bessie Thomas Center     100   \n",
       "10  Columbia    672          222                Philadelphia Church     100   \n",
       "11  Columbia    673          225                Grovetown City Hall     100   \n",
       "12  Columbia    674          226         Grovetown Methodist Church      95   \n",
       "13  Columbia    675         1164               G A Apostolic Church     100   \n",
       "14  Columbia    676          224            Grovetown Middle School      93   \n",
       "15  Columbia    677          227  Warren Baptist Church - Grovetown      97   \n",
       "16  Columbia    678            8            Eubank/Blanchard Center      93   \n",
       "17  Columbia    679         2490       Second Mt Carmel Bapt Church      93   \n",
       "18  Columbia    680         2489            Damascus Baptist Church      93   \n",
       "19  Columbia    681          195                  Col Cty Bd Of Edu      92   \n",
       "20  Columbia    682            2                    Greenbrier High     100   \n",
       "21  Columbia    683          210                    Redeemer Church     100   \n",
       "22  Columbia    684            3               Riverside Elementary     100   \n",
       "23  Columbia    685            1               Grace Baptist Church     100   \n",
       "24  Columbia    686          194                  Christ Sanctified     100   \n",
       "25  Columbia    687         1168                     Blanchard Park     100   \n",
       "26  Columbia    688          196               Mtz Col Fire Dept #4     100   \n",
       "27  Columbia    689         1165              Belair Baptist Church     100   \n",
       "28  Columbia    690          197            Marvin Methodist Church      95   \n",
       "29  Columbia    691         1137               Westside Bapt Church     100   \n",
       "30  Columbia    692          198                Trinity Bapt Church     100   \n",
       "31  Columbia    693         1138                    Abilene Baptist     100   \n",
       "32  Columbia    694          191                  Augusta Christian     100   \n",
       "33  Columbia    695          192                 Stevens Creek Elem     100   \n",
       "34  Columbia    696            6                Gospel Water Branch     100   \n",
       "35  Columbia    697          193                     Genesis Church     100   \n",
       "36  Columbia    698          183               Stevens Creek Church     100   \n",
       "37  Columbia    699         1139                 Mtz Col Fire Hdqtr     100   \n",
       "38  Columbia    700         1142                    Lakeside Middle     100   \n",
       "39  Columbia    701         1141                   Martinez Baptist     100   \n",
       "40  Columbia    702          199                     Gold Cross EMS     100   \n",
       "41  Columbia    703          200               Church of our Savior     100   \n",
       "42  Columbia    704          201                 West Acres Baptist     100   \n",
       "43  Columbia    705            0               Journey Comm. Church     100   \n",
       "44  Columbia    706            4                   Wesley Methodist     100   \n",
       "45  Columbia    707          202               Col Cty Main Library     100   \n",
       "46  Columbia    708            5                      Christ Church      90   \n",
       "47  Columbia    709          186              Blue Ridge Elementary      98   \n",
       "48  Columbia    710          187            Christ The King Luth Ch      95   \n",
       "\n",
       "                         match_value  \n",
       "0                     GENESIS CHURCH  \n",
       "1                     GENESIS CHURCH  \n",
       "2                    LEWIS METHODIST  \n",
       "3               WOODLAWN BAPT CHURCH  \n",
       "4                      PATRIOTS PARK  \n",
       "5               HARLEM MIDDLE SCHOOL  \n",
       "6               HARLEM MIDDLE SCHOOL  \n",
       "7                     HARLEM BAPTIST  \n",
       "8                     HARLEM BAPTIST  \n",
       "9               BESSIE THOMAS CENTER  \n",
       "10               PHILADELPHIA CHURCH  \n",
       "11               GROVETOWN CITY HALL  \n",
       "12               GROVETOWN METHODIST  \n",
       "13              G A APOSTOLIC CHURCH  \n",
       "14              GROVETOWN MIDDLE SCH  \n",
       "15   WARREN BAPTIST CHURCH-GROVETOWN  \n",
       "16              EUBANK/BLANCHARD CTR  \n",
       "17  SECOND MT. CARMEL BAPTIST CHURCH  \n",
       "18              DAMASCUS BAPT CHURCH  \n",
       "19              COL CTY BOARD OF EDU  \n",
       "20                   GREENBRIER HIGH  \n",
       "21                   REDEEMER CHURCH  \n",
       "22              RIVERSIDE ELEMENTARY  \n",
       "23              GRACE BAPTIST CHURCH  \n",
       "24                 CHRIST SANCTIFIED  \n",
       "25                    BLANCHARD PARK  \n",
       "26              MTZ COL FIRE DEPT #4  \n",
       "27             BELAIR BAPTIST CHURCH  \n",
       "28                  MARVIN METHODIST  \n",
       "29              WESTSIDE BAPT CHURCH  \n",
       "30               TRINITY BAPT CHURCH  \n",
       "31                   ABILENE BAPTIST  \n",
       "32                 AUGUSTA CHRISTIAN  \n",
       "33                STEVENS CREEK ELEM  \n",
       "34               GOSPEL WATER BRANCH  \n",
       "35                    GENESIS CHURCH  \n",
       "36              STEVENS CREEK CHURCH  \n",
       "37               MTZ COL FIRE HDQTR.  \n",
       "38                   LAKESIDE MIDDLE  \n",
       "39                  MARTINEZ BAPTIST  \n",
       "40                    GOLD CROSS EMS  \n",
       "41              CHURCH OF OUR SAVIOR  \n",
       "42                WEST ACRES BAPTIST  \n",
       "43              JOURNEY COMM. CHURCH  \n",
       "44                  WESLEY METHODIST  \n",
       "45              COL CTY MAIN LIBRARY  \n",
       "46       CHRIST CHURCH, PRESBYTERIAN  \n",
       "47              BLUERIDGE ELEMENTARY  \n",
       "48                CHRIST THE KING CH  "
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columbia_matches"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "metadata": {},
   "outputs": [],
   "source": [
    "columbia_mapping = get_good_matches(columbia_df, columbia_gdf, 90)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "metadata": {},
   "outputs": [],
   "source": [
    "columbia_mapping[\"Kiokee Baptist Church-10\"] = \"KIOKEE BAPT CHURCH\"\n",
    "columbia_mapping[\"Kiokee Baptist Church-12\"] = \"KIOKEE BAPT CHURCH\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 207,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert_mapping(columbia_df[\"PRECINCT\"], columbia_gdf[\"PRECINCT_N\"], columbia_mapping)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_columbia = columbia_df.groupby(columbia_df[\"PRECINCT\"].apply(columbia_mapping.get)).sum()\n",
    "\n",
    "merged_columbia = merged_columbia.reset_index(drop=False)\n",
    "\n",
    "merged_columbia[\"COUNTY\"] = \"Columbia\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 350,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_columbia.to_csv(\"./merged/columbia.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### DeKalb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {},
   "outputs": [],
   "source": [
    "dekalb_df, dekalb_gdf = get_county_df_and_gdf(\"DeKalb\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "metadata": {},
   "outputs": [],
   "source": [
    "matches = find_matches(dekalb_df, dekalb_gdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "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>county</th>\n",
       "      <th>index</th>\n",
       "      <th>match_index</th>\n",
       "      <th>precinct</th>\n",
       "      <th>rating</th>\n",
       "      <th>match_value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>DeKalb</td>\n",
       "      <td>832</td>\n",
       "      <td>78</td>\n",
       "      <td>EAST LAKE ELEM</td>\n",
       "      <td>86</td>\n",
       "      <td>CANDLER-MURPHEY CANDLER ELEM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>DeKalb</td>\n",
       "      <td>847</td>\n",
       "      <td>2358</td>\n",
       "      <td>GEORGETOWN SQUARE</td>\n",
       "      <td>80</td>\n",
       "      <td>GEORGETOWN SQ (DUN)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>DeKalb</td>\n",
       "      <td>849</td>\n",
       "      <td>2274</td>\n",
       "      <td>GLENNWOOD - 04</td>\n",
       "      <td>82</td>\n",
       "      <td>GLENNWOOD (DEC)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>DeKalb</td>\n",
       "      <td>850</td>\n",
       "      <td>2274</td>\n",
       "      <td>GLENNWOOD - 05</td>\n",
       "      <td>82</td>\n",
       "      <td>GLENNWOOD (DEC)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>DeKalb</td>\n",
       "      <td>898</td>\n",
       "      <td>2404</td>\n",
       "      <td>MT. VERNON EAST</td>\n",
       "      <td>84</td>\n",
       "      <td>MOUNT VERNON EAST (DUN)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>DeKalb</td>\n",
       "      <td>899</td>\n",
       "      <td>2360</td>\n",
       "      <td>MT. VERNON WEST</td>\n",
       "      <td>84</td>\n",
       "      <td>MOUNT VERNON WEST (DUN)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>DeKalb</td>\n",
       "      <td>915</td>\n",
       "      <td>78</td>\n",
       "      <td>PLEASANTDALE ELEM</td>\n",
       "      <td>86</td>\n",
       "      <td>CANDLER-MURPHEY CANDLER ELEM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>DeKalb</td>\n",
       "      <td>941</td>\n",
       "      <td>2255</td>\n",
       "      <td>SNAPFINGER ROAD NORTH</td>\n",
       "      <td>89</td>\n",
       "      <td>SNAPFINGER ROAD S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>DeKalb</td>\n",
       "      <td>942</td>\n",
       "      <td>2255</td>\n",
       "      <td>SNAPFINGER ROAD SOUTH</td>\n",
       "      <td>89</td>\n",
       "      <td>SNAPFINGER ROAD S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>DeKalb</td>\n",
       "      <td>948</td>\n",
       "      <td>2105</td>\n",
       "      <td>STONE MOUNTAIN CHAMPION</td>\n",
       "      <td>86</td>\n",
       "      <td>STONE MILL ELEM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>DeKalb</td>\n",
       "      <td>950</td>\n",
       "      <td>2401</td>\n",
       "      <td>STONE MOUNTAIN LIBRARY</td>\n",
       "      <td>86</td>\n",
       "      <td>TUCKER LIBRARY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>DeKalb</td>\n",
       "      <td>951</td>\n",
       "      <td>2151</td>\n",
       "      <td>STONE MOUNTAIN MIDDLE</td>\n",
       "      <td>86</td>\n",
       "      <td>SALEM MIDDLE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>DeKalb</td>\n",
       "      <td>969</td>\n",
       "      <td>78</td>\n",
       "      <td>WOODWARD ELEM</td>\n",
       "      <td>86</td>\n",
       "      <td>CANDLER-MURPHEY CANDLER ELEM</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     county  index  match_index                 precinct  rating  \\\n",
       "52   DeKalb    832           78           EAST LAKE ELEM      86   \n",
       "67   DeKalb    847         2358        GEORGETOWN SQUARE      80   \n",
       "69   DeKalb    849         2274           GLENNWOOD - 04      82   \n",
       "70   DeKalb    850         2274           GLENNWOOD - 05      82   \n",
       "118  DeKalb    898         2404          MT. VERNON EAST      84   \n",
       "119  DeKalb    899         2360          MT. VERNON WEST      84   \n",
       "135  DeKalb    915           78        PLEASANTDALE ELEM      86   \n",
       "161  DeKalb    941         2255    SNAPFINGER ROAD NORTH      89   \n",
       "162  DeKalb    942         2255    SNAPFINGER ROAD SOUTH      89   \n",
       "168  DeKalb    948         2105  STONE MOUNTAIN CHAMPION      86   \n",
       "170  DeKalb    950         2401   STONE MOUNTAIN LIBRARY      86   \n",
       "171  DeKalb    951         2151    STONE MOUNTAIN MIDDLE      86   \n",
       "189  DeKalb    969           78            WOODWARD ELEM      86   \n",
       "\n",
       "                      match_value  \n",
       "52   CANDLER-MURPHEY CANDLER ELEM  \n",
       "67            GEORGETOWN SQ (DUN)  \n",
       "69                GLENNWOOD (DEC)  \n",
       "70                GLENNWOOD (DEC)  \n",
       "118       MOUNT VERNON EAST (DUN)  \n",
       "119       MOUNT VERNON WEST (DUN)  \n",
       "135  CANDLER-MURPHEY CANDLER ELEM  \n",
       "161             SNAPFINGER ROAD S  \n",
       "162             SNAPFINGER ROAD S  \n",
       "168               STONE MILL ELEM  \n",
       "170                TUCKER LIBRARY  \n",
       "171                  SALEM MIDDLE  \n",
       "189  CANDLER-MURPHEY CANDLER ELEM  "
      ]
     },
     "execution_count": 129,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches[matches[\"rating\"] < 90]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [],
   "source": [
    "dekalb_mapping = get_good_matches(dekalb_df, dekalb_gdf, 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {},
   "outputs": [],
   "source": [
    "manual_matches = {\n",
    "    'LITHONIA': 'LITHONIA (LIT)',\n",
    "    'BROCKETT': 'BROCKETT (TUC)',\n",
    "    'WOODWARD ELEM': 'WOODWARD (BHAVN)',\n",
    "    'COVINGTON HWY LIBRARY': 'COVINGTON HWY',\n",
    "    \"DUNWOODY\": 'DUNWOODY (DUN)',\n",
    "    \"EAST LAKE ELEM\": 'EAST LAKE (ATL)',\n",
    "    \"PLEASANTDALE ELEM\": \"PLEASANTDALE ROAD\",\n",
    "    \"SNAPFINGER ROAD NORTH\": \"SNAPFINGER ROAD N\",\n",
    "    \"SNAPFINGER ROAD SOUTH\": \"SNAPFINGER ROAD S\",\n",
    "    \"STONE MOUNTAIN LIBRARY\": 'STONE MTN LIBRARY  (STO)',\n",
    "    \"STONE MOUNTAIN CHAMPION\": 'STONE MTN CHAMPION (STO)',\n",
    "    \"STONE MOUNTAIN MIDDLE\": 'STN MTN MIDDLE',\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 157,
   "metadata": {},
   "outputs": [],
   "source": [
    "dekalb_mapping.update(manual_matches)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert_mapping(dekalb_df[\"PRECINCT\"], dekalb_gdf[\"PRECINCT_N\"], dekalb_mapping)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 164,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "AVONDALE HIGH - 04 954 | AVONDALE HIGH 1804\n",
      "AVONDALE HIGH - 05 850 | AVONDALE HIGH 1804\n",
      "GLENNWOOD - 04 559 | GLENNWOOD (DEC) 1278\n",
      "GLENNWOOD - 05 719 | GLENNWOOD (DEC) 1278\n",
      "MCNAIR ACADEMY 1131 | MCNAIR ACADEMY 2032\n",
      "MCNAIR HIGH 2032 | MCNAIR HIGH 1225\n",
      "MCNAIR MIDDLE 1225 | MCNAIR 1131\n",
      "MILLER GROVE HIGH 1450 | MILLER GROVE HIGH 2013\n",
      "MILLER GROVE MIDDLE 2013 | MILLER GROVE 1450\n",
      "WADSWORTH ELEM - 05 486 | WADSWORTH 1543\n",
      "WADSWORTH ELEM - 04 1057 | WADSWORTH 1543\n"
     ]
    }
   ],
   "source": [
    "left = dekalb_df.set_index(\"PRECINCT\")[\"PRES16D\"]\n",
    "right = dekalb_gdf.set_index(\"PRECINCT_N\")[\"PRES16D\"].astype(int)\n",
    "\n",
    "for key, value in dekalb_mapping.items():\n",
    "    if left[key] != right[value]:\n",
    "        print(key, left[key], \"|\", value, right[value])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Looks like the shapefile has MCNAIR ACADEMY, MCNAIR HIGH, and MCNAIR MIDDLE shuffled, as well as MILLER GROVE HIGH and MILLER GROVE MIDDLE. Hmm... I guess these will be fixed when we join the dataset, since we'll bring the vote totals from the tabular data."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 165,
   "metadata": {},
   "outputs": [],
   "source": [
    "def merge_precincts_by_mapping(county_df, mapping, county):\n",
    "    merged = county_df.groupby(county_df[\"PRECINCT\"].apply(mapping.get)).sum()\n",
    "    merged= merged.reset_index(drop=False)\n",
    "    merged[\"COUNTY\"] = county\n",
    "    return merged"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 166,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_dekalb = merge_precincts_by_mapping(dekalb_df, dekalb_mapping, \"DeKalb\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 167,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert len(merged_dekalb) == len(dekalb_gdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 358,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_dekalb.to_csv(\"./merged/dekalb.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Chatham"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 232,
   "metadata": {},
   "outputs": [],
   "source": [
    "chatham_df, chatham_gdf = get_county_df_and_gdf(\"Chatham\")\n",
    "chatham_df = chatham_df.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 233,
   "metadata": {},
   "outputs": [],
   "source": [
    "chatham_df[\"PRECINCT\"] = chatham_df[\"PRECINCT\"].apply(lambda s: s.split()[0])\n",
    "\n",
    "matches = find_matches(chatham_df, chatham_gdf, \"PRECINCT_I\")\n",
    "\n",
    "chatham_mapping = {df[\"PRECINCT\"][i]: gdf[\"PRECINCT_N\"][j] for i, j in zip(matches[\"index\"], matches[\"match_index\"])}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 234,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert_mapping(df[df[\"COUNTY\"] == \"Chatham\"][\"PRECINCT\"], chatham_gdf[\"PRECINCT_N\"], chatham_mapping)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 357,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_chatham = df[df[\"COUNTY\"] == \"Chatham\"].copy()\n",
    "\n",
    "final_chatham[\"PRECINCT\"] = final_chatham[\"PRECINCT\"].apply(chatham_mapping.get)\n",
    "\n",
    "final_chatham.to_csv(\"./merged/chatham.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 239,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert len(final_chatham) == len(chatham_gdf)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Forsyth"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 222,
   "metadata": {},
   "outputs": [],
   "source": [
    "forsyth_df, forsyth_gdf = get_county_df_and_gdf(\"Forsyth\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 226,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 226,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set(forsyth_df[\"PRECINCT\"].apply(lambda s: s.split()[0])) == set(forsyth_gdf[\"PRECINCT_I\"])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Looks like we can just use the prefixes to match, as above."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 236,
   "metadata": {},
   "outputs": [],
   "source": [
    "forsyth_df = forsyth_df.copy()\n",
    "\n",
    "forsyth_df[\"PRECINCT\"] = forsyth_df[\"PRECINCT\"].apply(lambda s: s.split()[0])\n",
    "\n",
    "matches = find_matches(forsyth_df, forsyth_gdf, \"PRECINCT_I\")\n",
    "\n",
    "forsyth_mapping = {df[\"PRECINCT\"][i]: gdf[\"PRECINCT_N\"][j] for i, j in zip(matches[\"index\"], matches[\"match_index\"])}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 237,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert_mapping(df[df[\"COUNTY\"] == \"Forsyth\"][\"PRECINCT\"], forsyth_gdf[\"PRECINCT_N\"], forsyth_mapping)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 243,
   "metadata": {},
   "outputs": [],
   "source": [
    "forsyth_df = df[df[\"COUNTY\"] == \"Forsyth\"].copy()\n",
    "final_forsyth = forsyth_df.groupby(forsyth_df[\"PRECINCT\"].apply(forsyth_mapping.get)).sum()\n",
    "final_forsyth.reset_index(drop=False, inplace=True)\n",
    "final_forsyth[\"COUNTY\"] = \"Forsyth\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 245,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert set(final_forsyth[\"PRECINCT\"]) == set(forsyth_gdf[\"PRECINCT_N\"])\n",
    "assert len(final_forsyth) == len(forsyth_gdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 356,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_forsyth.to_csv(\"./merged/forsyth.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Fayette"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 248,
   "metadata": {},
   "outputs": [],
   "source": [
    "fayette_df, fayette_gdf = get_county_df_and_gdf(\"Fayette\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 256,
   "metadata": {},
   "outputs": [],
   "source": [
    "fayette_mapping = get_good_matches(fayette_df, fayette_gdf, 95)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 260,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_fayette = fayette_df.groupby(fayette_df[\"PRECINCT\"].apply(fayette_mapping.get)).sum()\n",
    "final_fayette.reset_index(drop=False, inplace=True)\n",
    "final_fayette[\"COUNTY\"] = \"Fayette\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 261,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert set(final_fayette[\"PRECINCT\"]) == set(fayette_gdf[\"PRECINCT_N\"])\n",
    "assert len(final_fayette) == len(fayette_gdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 355,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_fayette.to_csv(\"./merged/fayette.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Fulton"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 281,
   "metadata": {},
   "outputs": [],
   "source": [
    "def merge_by_auto_matching(county, threshold=90):\n",
    "    df, gdf = get_county_df_and_gdf(county)\n",
    "    mapping = get_good_matches(df, gdf, threshold)\n",
    "    assert_mapping(df[\"PRECINCT\"], gdf[\"PRECINCT_N\"], mapping)\n",
    "    final = merge_precincts_by_mapping(df, mapping, county)\n",
    "    assert set(final[\"PRECINCT\"]) == set(gdf[\"PRECINCT_N\"])\n",
    "    assert len(final) == len(gdf)\n",
    "    return final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 282,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_fulton = merge_by_auto_matching(\"Fulton\", threshold=90)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 354,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_fulton.to_csv(\"./merged/fulton.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Gwinnett"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 291,
   "metadata": {},
   "outputs": [],
   "source": [
    "gwinnett_df, gwinnett_gdf = get_county_df_and_gdf(\"Gwinnett\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 292,
   "metadata": {},
   "outputs": [],
   "source": [
    "auto_matches = find_matches(gwinnett_df, gwinnett_gdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 295,
   "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>county</th>\n",
       "      <th>index</th>\n",
       "      <th>match_index</th>\n",
       "      <th>precinct</th>\n",
       "      <th>rating</th>\n",
       "      <th>match_value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Gwinnett</td>\n",
       "      <td>1637</td>\n",
       "      <td>2378</td>\n",
       "      <td>PINCKNEYVILLE A</td>\n",
       "      <td>97</td>\n",
       "      <td>PINCKNEYVILLE A1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Gwinnett</td>\n",
       "      <td>1653</td>\n",
       "      <td>2083</td>\n",
       "      <td>035 Cates D - 04</td>\n",
       "      <td>90</td>\n",
       "      <td>CATES D</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      county  index  match_index          precinct  rating       match_value\n",
       "19  Gwinnett   1637         2378   PINCKNEYVILLE A      97  PINCKNEYVILLE A1\n",
       "35  Gwinnett   1653         2083  035 Cates D - 04      90           CATES D"
      ]
     },
     "execution_count": 295,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "auto_matches[auto_matches.rating < 100]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 300,
   "metadata": {},
   "outputs": [],
   "source": [
    "gwinnett_matches = get_good_matches(gwinnett_df, gwinnett_gdf, 100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 305,
   "metadata": {},
   "outputs": [],
   "source": [
    "gwinnett_matches[\"PINCKNEYVILLE A\"] = \"PINKCNEYVILLE A\"\n",
    "gwinnett_matches[\"035 Cates D - 04\"] = \"CATES D\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 306,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert_mapping(gwinnett_df[\"PRECINCT\"], gwinnett_gdf[\"PRECINCT_N\"], gwinnett_matches)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 307,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_gwinnett = merge_precincts_by_mapping(gwinnett_df, gwinnett_matches, \"Gwinnett\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 352,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_gwinnett.to_csv(\"./merged/gwinnett.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Lowndes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 353,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_lowndes = merge_by_auto_matching(\"Lowndes\", 90)\n",
    "final_lowndes.to_csv(\"./merged/lowndes.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Muscogee"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 316,
   "metadata": {},
   "outputs": [],
   "source": [
    "muscogee_df, muscogee_gdf = get_county_df_and_gdf(\"Muscogee\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 323,
   "metadata": {},
   "outputs": [],
   "source": [
    "muscogee_matches = get_good_matches(muscogee_df, muscogee_gdf, 95)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 324,
   "metadata": {},
   "outputs": [],
   "source": [
    "manual_matches = {\n",
    "    \"EPWORTH-03\": \"EPWORTH UMC\",\n",
    "    \"EPWORTH-02\": \"EPWORTH UMC\",\n",
    "    'ST PAUL U.M.C.-02': \"ST PAUL/CLUBVIEW\",\n",
    "    'ST PAUL U.M.C.-03': \"ST PAUL/CLUBVIEW\",\n",
    "    'ST PETER U. M. C.': \"ST. PETER\",\n",
    "    'BRITT DAVID BAPT CH': \"BRITT DAVID\",\n",
    "    \"CORNERSTONE CHURCH\": \"CORNERSTONE\",\n",
    "    'GALLOPS/HANNAN': \"MARIANNA GALLOPS\",\n",
    "    'WYNNTON': \"WYNNTON/BRITT\",\n",
    "}\n",
    "\n",
    "muscogee_matches.update(manual_matches)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 325,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert_mapping(muscogee_df[\"PRECINCT\"], muscogee_gdf[\"PRECINCT_N\"], muscogee_matches)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 326,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_muscogee = merge_precincts_by_mapping(muscogee_df, muscogee_matches, \"Muscogee\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 327,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert len(final_muscogee) == len(muscogee_gdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 336,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "PRECINCT\n",
       "BRITT DAVID                 True\n",
       "CARVER/MACK                 True\n",
       "COLUMBUS TECH               True\n",
       "CORNERSTONE                 True\n",
       "CUSSETA RD                  True\n",
       "EDDY/KEY                    True\n",
       "EDGEWOOD BAPTIST            True\n",
       "EPWORTH UMC                 True\n",
       "FAITH TABERNACLE            True\n",
       "FIRST AFRICAN               True\n",
       "FORT/WADDELL                True\n",
       "GENTIAN/REESE @LDS          True\n",
       "MARIANNA GALLOPS            True\n",
       "MOON/MORNINGSIDE            True\n",
       "MT PILGRIM                  True\n",
       "NATIONAL INFANTRY MUSEUM    True\n",
       "PSALMOND/MATHEWS            True\n",
       "ROTHSCHILD                  True\n",
       "SALVATION ARMY              True\n",
       "ST ANDREWS/MIDLAND          True\n",
       "ST JOHN/BELVEDERE           True\n",
       "ST MARK/HEIFERHORN          True\n",
       "ST PAUL/CLUBVIEW            True\n",
       "ST. PETER                   True\n",
       "WYNNBROOK                   True\n",
       "WYNNTON/BRITT               True\n",
       "Name: PRES16D, dtype: bool"
      ]
     },
     "execution_count": 336,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_muscogee.set_index(\"PRECINCT\").sort_index()[\"PRES16D\"] == muscogee_gdf.set_index(\"PRECINCT_N\").sort_index()[\"PRES16D\"].astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 351,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_muscogee.to_csv(\"./merged/muscogee.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Newton"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 342,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_newton = merge_by_auto_matching(\"Newton\", 90)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 343,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "PRECINCT\n",
       "ALCOVY             True\n",
       "ALMON              True\n",
       "BEAVERDAM          True\n",
       "BREWERS            True\n",
       "BRICK STORE        True\n",
       "BUCK CREEK         True\n",
       "CEDAR SHOALS       True\n",
       "CITY POND          True\n",
       "COVINGTON MILLS    True\n",
       "CROWELL            True\n",
       "DOWNS              True\n",
       "FAIRVIEW           True\n",
       "GUM CREEK          True\n",
       "HUB                True\n",
       "LEGUINN            True\n",
       "LIVINGSTON         True\n",
       "MANSFIELD          True\n",
       "NEWBORN            True\n",
       "OXFORD             True\n",
       "ROCKY PLAINS       True\n",
       "STANSELLS          True\n",
       "TOWN               True\n",
       "Name: PRES16D, dtype: bool"
      ]
     },
     "execution_count": 343,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_newton.set_index(\"PRECINCT\").sort_index()[\"PRES16D\"] == gdf[gdf[\"CTYNAME\"] == \"Newton\"].set_index(\"PRECINCT_N\").sort_index()[\"PRES16D\"].astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 347,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_newton.to_csv(\"./merged/newton.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Laurens"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 434,
   "metadata": {},
   "outputs": [],
   "source": [
    "laurens_df, laurens_gdf = get_county_df_and_gdf(\"Laurens\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 436,
   "metadata": {},
   "outputs": [],
   "source": [
    "laurens_matches = get_good_matches(laurens_df, laurens_gdf, 100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 438,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Family Life Center', 'LCFS 10 (Valambrosia)'}"
      ]
     },
     "execution_count": 438,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set(laurens_df[\"PRECINCT\"]) - set(laurens_matches.keys())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 439,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'FBC - FLC', 'LCFS #10 (VALAMBROSIA)'}"
      ]
     },
     "execution_count": 439,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set(laurens_gdf[\"PRECINCT_N\"]) - set(laurens_matches.values())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 440,
   "metadata": {},
   "outputs": [],
   "source": [
    "laurens_matches[\"Family Life Center\"] = \"FBC - FLC\"\n",
    "laurens_matches[\"LCFS 10 (Valambrosia)\"] = \"LCFS #10 (VALAMBROSIA)\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 441,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert_mapping(laurens_df[\"PRECINCT\"], laurens_gdf[\"PRECINCT_N\"], laurens_matches)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 443,
   "metadata": {},
   "outputs": [],
   "source": [
    "laurens_final = merge_precincts_by_mapping(laurens_df, laurens_matches, \"Laurens\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 444,
   "metadata": {},
   "outputs": [],
   "source": [
    "laurens_final.to_csv(\"./merged/laurens.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Chattahoochee and Bleckley"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 447,
   "metadata": {},
   "outputs": [],
   "source": [
    "merge_by_auto_matching(\"Chattahoochee\", 0).to_csv(\"./merged/chattahoochee.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 448,
   "metadata": {},
   "outputs": [],
   "source": [
    "merge_by_auto_matching(\"Bleckley\", 0).to_csv(\"./merged/bleckley.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Jackson"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 449,
   "metadata": {},
   "outputs": [],
   "source": [
    "jackson_df, jackson_gdf = get_county_df_and_gdf(\"Jackson\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 454,
   "metadata": {},
   "outputs": [],
   "source": [
    "jackson_matches = get_good_matches(jackson_df, jackson_gdf, 100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 457,
   "metadata": {},
   "outputs": [],
   "source": [
    "jackson_matches[\"South Jefferson\"] = \"S JEFFERSON\"\n",
    "jackson_matches[\"North Jefferson\"] = \"N JEFFERSON\"\n",
    "jackson_matches[\"South Minish\"] = \"S MINISH\"\n",
    "jackson_matches[\"North Minish\"] = \"N MINISH\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 458,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert_mapping(jackson_df[\"PRECINCT\"], jackson_gdf[\"PRECINCT_N\"], jackson_matches)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 459,
   "metadata": {},
   "outputs": [],
   "source": [
    "merge_precincts_by_mapping(jackson_df, jackson_matches, \"Jackson\").to_csv(\"./merged/jackson.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}