Group_Assign2/assignment_2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>year</th>\n",
       "      <th>fips</th>\n",
       "      <th>pop2010</th>\n",
       "      <th>pop2023</th>\n",
       "      <th>state</th>\n",
       "      <th>stateCode</th>\n",
       "      <th>growthSince2010</th>\n",
       "      <th>name</th>\n",
       "      <th>ctyname</th>\n",
       "      <th>slug</th>\n",
       "      <th>landArea</th>\n",
       "      <th>density</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2023</td>\n",
       "      <td>53033</td>\n",
       "      <td>1931249</td>\n",
       "      <td>2371204</td>\n",
       "      <td>Washington</td>\n",
       "      <td>WA</td>\n",
       "      <td>0.227809</td>\n",
       "      <td>King County</td>\n",
       "      <td>King County</td>\n",
       "      <td>king-county-wa</td>\n",
       "      <td>2116</td>\n",
       "      <td>1120.606805</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2023</td>\n",
       "      <td>53053</td>\n",
       "      <td>795225</td>\n",
       "      <td>958900</td>\n",
       "      <td>Washington</td>\n",
       "      <td>WA</td>\n",
       "      <td>0.205822</td>\n",
       "      <td>Pierce County</td>\n",
       "      <td>Pierce County</td>\n",
       "      <td>pierce-county-wa</td>\n",
       "      <td>1669</td>\n",
       "      <td>574.535650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2023</td>\n",
       "      <td>53061</td>\n",
       "      <td>713335</td>\n",
       "      <td>862343</td>\n",
       "      <td>Washington</td>\n",
       "      <td>WA</td>\n",
       "      <td>0.208889</td>\n",
       "      <td>Snohomish County</td>\n",
       "      <td>Snohomish County</td>\n",
       "      <td>snohomish-county-wa</td>\n",
       "      <td>2087</td>\n",
       "      <td>413.197413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2023</td>\n",
       "      <td>53063</td>\n",
       "      <td>471221</td>\n",
       "      <td>559775</td>\n",
       "      <td>Washington</td>\n",
       "      <td>WA</td>\n",
       "      <td>0.187925</td>\n",
       "      <td>Spokane County</td>\n",
       "      <td>Spokane County</td>\n",
       "      <td>spokane-county-wa</td>\n",
       "      <td>1764</td>\n",
       "      <td>317.332766</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2023</td>\n",
       "      <td>53011</td>\n",
       "      <td>425363</td>\n",
       "      <td>526696</td>\n",
       "      <td>Washington</td>\n",
       "      <td>WA</td>\n",
       "      <td>0.238227</td>\n",
       "      <td>Clark County</td>\n",
       "      <td>Clark County</td>\n",
       "      <td>clark-county-wa</td>\n",
       "      <td>629</td>\n",
       "      <td>837.354531</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2023</td>\n",
       "      <td>53067</td>\n",
       "      <td>252264</td>\n",
       "      <td>307552</td>\n",
       "      <td>Washington</td>\n",
       "      <td>WA</td>\n",
       "      <td>0.219167</td>\n",
       "      <td>Thurston County</td>\n",
       "      <td>Thurston County</td>\n",
       "      <td>thurston-county-wa</td>\n",
       "      <td>722</td>\n",
       "      <td>425.972299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2023</td>\n",
       "      <td>53035</td>\n",
       "      <td>251133</td>\n",
       "      <td>282955</td>\n",
       "      <td>Washington</td>\n",
       "      <td>WA</td>\n",
       "      <td>0.126714</td>\n",
       "      <td>Kitsap County</td>\n",
       "      <td>Kitsap County</td>\n",
       "      <td>kitsap-county-wa</td>\n",
       "      <td>395</td>\n",
       "      <td>716.341772</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2023</td>\n",
       "      <td>53077</td>\n",
       "      <td>243231</td>\n",
       "      <td>260778</td>\n",
       "      <td>Washington</td>\n",
       "      <td>WA</td>\n",
       "      <td>0.072141</td>\n",
       "      <td>Yakima County</td>\n",
       "      <td>Yakima County</td>\n",
       "      <td>yakima-county-wa</td>\n",
       "      <td>4296</td>\n",
       "      <td>60.702514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2023</td>\n",
       "      <td>53073</td>\n",
       "      <td>201140</td>\n",
       "      <td>234560</td>\n",
       "      <td>Washington</td>\n",
       "      <td>WA</td>\n",
       "      <td>0.166153</td>\n",
       "      <td>Whatcom County</td>\n",
       "      <td>Whatcom County</td>\n",
       "      <td>whatcom-county-wa</td>\n",
       "      <td>2107</td>\n",
       "      <td>111.324158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2023</td>\n",
       "      <td>53005</td>\n",
       "      <td>175177</td>\n",
       "      <td>216383</td>\n",
       "      <td>Washington</td>\n",
       "      <td>WA</td>\n",
       "      <td>0.235225</td>\n",
       "      <td>Benton County</td>\n",
       "      <td>Benton County</td>\n",
       "      <td>benton-county-wa</td>\n",
       "      <td>1700</td>\n",
       "      <td>127.284118</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   year   fips  pop2010  pop2023       state stateCode  growthSince2010  \\\n",
       "0  2023  53033  1931249  2371204  Washington        WA         0.227809   \n",
       "1  2023  53053   795225   958900  Washington        WA         0.205822   \n",
       "2  2023  53061   713335   862343  Washington        WA         0.208889   \n",
       "3  2023  53063   471221   559775  Washington        WA         0.187925   \n",
       "4  2023  53011   425363   526696  Washington        WA         0.238227   \n",
       "5  2023  53067   252264   307552  Washington        WA         0.219167   \n",
       "6  2023  53035   251133   282955  Washington        WA         0.126714   \n",
       "7  2023  53077   243231   260778  Washington        WA         0.072141   \n",
       "8  2023  53073   201140   234560  Washington        WA         0.166153   \n",
       "9  2023  53005   175177   216383  Washington        WA         0.235225   \n",
       "\n",
       "               name           ctyname                 slug  landArea  \\\n",
       "0       King County       King County       king-county-wa      2116   \n",
       "1     Pierce County     Pierce County     pierce-county-wa      1669   \n",
       "2  Snohomish County  Snohomish County  snohomish-county-wa      2087   \n",
       "3    Spokane County    Spokane County    spokane-county-wa      1764   \n",
       "4      Clark County      Clark County      clark-county-wa       629   \n",
       "5   Thurston County   Thurston County   thurston-county-wa       722   \n",
       "6     Kitsap County     Kitsap County     kitsap-county-wa       395   \n",
       "7     Yakima County     Yakima County     yakima-county-wa      4296   \n",
       "8    Whatcom County    Whatcom County    whatcom-county-wa      2107   \n",
       "9     Benton County     Benton County     benton-county-wa      1700   \n",
       "\n",
       "       density  \n",
       "0  1120.606805  \n",
       "1   574.535650  \n",
       "2   413.197413  \n",
       "3   317.332766  \n",
       "4   837.354531  \n",
       "5   425.972299  \n",
       "6   716.341772  \n",
       "7    60.702514  \n",
       "8   111.324158  \n",
       "9   127.284118  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "counties = pd.read_csv(\"data/counties_table.csv\")\n",
    "counties = counties[counties[\"state\"] == \"Washington\"].reset_index(drop=True)\n",
    "counties"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>Legislative District</th>\n",
       "      <th>Turnout_Registered Voters</th>\n",
       "      <th>Turnout_Ballots Cast</th>\n",
       "      <th>Turnout_%</th>\n",
       "      <th>President/Vice President_Joseph R. Biden / Kamala D. Harris</th>\n",
       "      <th>President/Vice President_Donald J. Trump / Michael R. Pence</th>\n",
       "      <th>President/Vice President_Jo Jorgensen / Jeremy \"Spike\" Cohen</th>\n",
       "      <th>President/Vice President_Howie Hawkins / Angela Walker</th>\n",
       "      <th>President/Vice President_Gloria La Riva / Sunil Freeman</th>\n",
       "      <th>President/Vice President_Alyson Kennedy / Malcolm M. Jarrett</th>\n",
       "      <th>President/Vice President_Write-in</th>\n",
       "      <th>Governor_Jay Inslee</th>\n",
       "      <th>Governor_Loren Culp</th>\n",
       "      <th>Governor_Write-in</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>106,217</td>\n",
       "      <td>93,372</td>\n",
       "      <td>87.90%</td>\n",
       "      <td>62,011</td>\n",
       "      <td>27,575</td>\n",
       "      <td>1,843</td>\n",
       "      <td>397</td>\n",
       "      <td>83</td>\n",
       "      <td>37</td>\n",
       "      <td>703</td>\n",
       "      <td>59,793</td>\n",
       "      <td>31,768</td>\n",
       "      <td>367</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>106,280</td>\n",
       "      <td>86,171</td>\n",
       "      <td>81.10%</td>\n",
       "      <td>35,289</td>\n",
       "      <td>47,157</td>\n",
       "      <td>2,229</td>\n",
       "      <td>353</td>\n",
       "      <td>67</td>\n",
       "      <td>50</td>\n",
       "      <td>572</td>\n",
       "      <td>33,043</td>\n",
       "      <td>51,807</td>\n",
       "      <td>281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>91,050</td>\n",
       "      <td>70,214</td>\n",
       "      <td>77.10%</td>\n",
       "      <td>39,922</td>\n",
       "      <td>26,940</td>\n",
       "      <td>1,818</td>\n",
       "      <td>461</td>\n",
       "      <td>121</td>\n",
       "      <td>96</td>\n",
       "      <td>506</td>\n",
       "      <td>39,184</td>\n",
       "      <td>29,945</td>\n",
       "      <td>269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>113,683</td>\n",
       "      <td>93,601</td>\n",
       "      <td>82.30%</td>\n",
       "      <td>36,525</td>\n",
       "      <td>53,123</td>\n",
       "      <td>2,324</td>\n",
       "      <td>352</td>\n",
       "      <td>77</td>\n",
       "      <td>41</td>\n",
       "      <td>628</td>\n",
       "      <td>35,132</td>\n",
       "      <td>57,264</td>\n",
       "      <td>309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>110,814</td>\n",
       "      <td>97,471</td>\n",
       "      <td>88.00%</td>\n",
       "      <td>57,868</td>\n",
       "      <td>35,379</td>\n",
       "      <td>2,209</td>\n",
       "      <td>333</td>\n",
       "      <td>50</td>\n",
       "      <td>44</td>\n",
       "      <td>777</td>\n",
       "      <td>54,640</td>\n",
       "      <td>40,964</td>\n",
       "      <td>337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>107,630</td>\n",
       "      <td>90,057</td>\n",
       "      <td>83.70%</td>\n",
       "      <td>44,883</td>\n",
       "      <td>41,319</td>\n",
       "      <td>2,096</td>\n",
       "      <td>348</td>\n",
       "      <td>91</td>\n",
       "      <td>46</td>\n",
       "      <td>726</td>\n",
       "      <td>43,678</td>\n",
       "      <td>44,981</td>\n",
       "      <td>337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>106,783</td>\n",
       "      <td>89,895</td>\n",
       "      <td>84.20%</td>\n",
       "      <td>28,309</td>\n",
       "      <td>58,375</td>\n",
       "      <td>1,703</td>\n",
       "      <td>268</td>\n",
       "      <td>63</td>\n",
       "      <td>43</td>\n",
       "      <td>504</td>\n",
       "      <td>26,705</td>\n",
       "      <td>61,991</td>\n",
       "      <td>264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>100,696</td>\n",
       "      <td>82,892</td>\n",
       "      <td>82.30%</td>\n",
       "      <td>32,595</td>\n",
       "      <td>46,342</td>\n",
       "      <td>2,280</td>\n",
       "      <td>317</td>\n",
       "      <td>95</td>\n",
       "      <td>46</td>\n",
       "      <td>637</td>\n",
       "      <td>31,306</td>\n",
       "      <td>50,202</td>\n",
       "      <td>339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>85,769</td>\n",
       "      <td>71,484</td>\n",
       "      <td>83.30%</td>\n",
       "      <td>27,886</td>\n",
       "      <td>40,531</td>\n",
       "      <td>1,605</td>\n",
       "      <td>283</td>\n",
       "      <td>60</td>\n",
       "      <td>45</td>\n",
       "      <td>453</td>\n",
       "      <td>26,734</td>\n",
       "      <td>43,572</td>\n",
       "      <td>235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>111,652</td>\n",
       "      <td>96,776</td>\n",
       "      <td>86.70%</td>\n",
       "      <td>49,457</td>\n",
       "      <td>43,329</td>\n",
       "      <td>2,150</td>\n",
       "      <td>351</td>\n",
       "      <td>83</td>\n",
       "      <td>44</td>\n",
       "      <td>657</td>\n",
       "      <td>47,186</td>\n",
       "      <td>48,106</td>\n",
       "      <td>287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>89,463</td>\n",
       "      <td>72,288</td>\n",
       "      <td>80.80%</td>\n",
       "      <td>50,475</td>\n",
       "      <td>19,212</td>\n",
       "      <td>1,113</td>\n",
       "      <td>319</td>\n",
       "      <td>91</td>\n",
       "      <td>46</td>\n",
       "      <td>466</td>\n",
       "      <td>49,641</td>\n",
       "      <td>20,958</td>\n",
       "      <td>218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>93,009</td>\n",
       "      <td>79,217</td>\n",
       "      <td>85.20%</td>\n",
       "      <td>33,648</td>\n",
       "      <td>42,869</td>\n",
       "      <td>1,237</td>\n",
       "      <td>275</td>\n",
       "      <td>71</td>\n",
       "      <td>44</td>\n",
       "      <td>491</td>\n",
       "      <td>31,240</td>\n",
       "      <td>46,678</td>\n",
       "      <td>318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>84,351</td>\n",
       "      <td>70,022</td>\n",
       "      <td>83.00%</td>\n",
       "      <td>24,302</td>\n",
       "      <td>43,145</td>\n",
       "      <td>1,333</td>\n",
       "      <td>224</td>\n",
       "      <td>71</td>\n",
       "      <td>35</td>\n",
       "      <td>399</td>\n",
       "      <td>22,223</td>\n",
       "      <td>46,705</td>\n",
       "      <td>223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>86,902</td>\n",
       "      <td>69,841</td>\n",
       "      <td>80.40%</td>\n",
       "      <td>30,673</td>\n",
       "      <td>36,693</td>\n",
       "      <td>1,103</td>\n",
       "      <td>233</td>\n",
       "      <td>80</td>\n",
       "      <td>49</td>\n",
       "      <td>419</td>\n",
       "      <td>29,262</td>\n",
       "      <td>39,302</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>66,014</td>\n",
       "      <td>48,489</td>\n",
       "      <td>73.50%</td>\n",
       "      <td>22,124</td>\n",
       "      <td>24,801</td>\n",
       "      <td>704</td>\n",
       "      <td>166</td>\n",
       "      <td>89</td>\n",
       "      <td>46</td>\n",
       "      <td>195</td>\n",
       "      <td>21,202</td>\n",
       "      <td>26,468</td>\n",
       "      <td>121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>77,960</td>\n",
       "      <td>63,144</td>\n",
       "      <td>81.00%</td>\n",
       "      <td>25,180</td>\n",
       "      <td>35,353</td>\n",
       "      <td>1,369</td>\n",
       "      <td>201</td>\n",
       "      <td>91</td>\n",
       "      <td>34</td>\n",
       "      <td>338</td>\n",
       "      <td>24,209</td>\n",
       "      <td>37,815</td>\n",
       "      <td>186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>104,127</td>\n",
       "      <td>87,351</td>\n",
       "      <td>83.90%</td>\n",
       "      <td>43,637</td>\n",
       "      <td>40,468</td>\n",
       "      <td>1,727</td>\n",
       "      <td>340</td>\n",
       "      <td>73</td>\n",
       "      <td>42</td>\n",
       "      <td>602</td>\n",
       "      <td>43,066</td>\n",
       "      <td>42,372</td>\n",
       "      <td>234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>115,185</td>\n",
       "      <td>101,214</td>\n",
       "      <td>87.90%</td>\n",
       "      <td>47,030</td>\n",
       "      <td>50,547</td>\n",
       "      <td>1,835</td>\n",
       "      <td>308</td>\n",
       "      <td>68</td>\n",
       "      <td>42</td>\n",
       "      <td>729</td>\n",
       "      <td>45,785</td>\n",
       "      <td>53,508</td>\n",
       "      <td>221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>92,751</td>\n",
       "      <td>76,034</td>\n",
       "      <td>82.00%</td>\n",
       "      <td>33,132</td>\n",
       "      <td>40,057</td>\n",
       "      <td>1,493</td>\n",
       "      <td>322</td>\n",
       "      <td>64</td>\n",
       "      <td>62</td>\n",
       "      <td>361</td>\n",
       "      <td>31,183</td>\n",
       "      <td>43,678</td>\n",
       "      <td>238</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>103,227</td>\n",
       "      <td>87,255</td>\n",
       "      <td>84.50%</td>\n",
       "      <td>28,956</td>\n",
       "      <td>54,990</td>\n",
       "      <td>1,790</td>\n",
       "      <td>340</td>\n",
       "      <td>79</td>\n",
       "      <td>41</td>\n",
       "      <td>463</td>\n",
       "      <td>27,255</td>\n",
       "      <td>58,868</td>\n",
       "      <td>234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>98,061</td>\n",
       "      <td>83,575</td>\n",
       "      <td>85.20%</td>\n",
       "      <td>55,372</td>\n",
       "      <td>24,976</td>\n",
       "      <td>1,525</td>\n",
       "      <td>368</td>\n",
       "      <td>94</td>\n",
       "      <td>46</td>\n",
       "      <td>581</td>\n",
       "      <td>53,754</td>\n",
       "      <td>28,237</td>\n",
       "      <td>291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>112,393</td>\n",
       "      <td>95,281</td>\n",
       "      <td>84.80%</td>\n",
       "      <td>62,311</td>\n",
       "      <td>28,830</td>\n",
       "      <td>1,963</td>\n",
       "      <td>630</td>\n",
       "      <td>206</td>\n",
       "      <td>69</td>\n",
       "      <td>662</td>\n",
       "      <td>61,009</td>\n",
       "      <td>32,436</td>\n",
       "      <td>338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>106,338</td>\n",
       "      <td>90,342</td>\n",
       "      <td>85.00%</td>\n",
       "      <td>56,406</td>\n",
       "      <td>29,815</td>\n",
       "      <td>2,448</td>\n",
       "      <td>380</td>\n",
       "      <td>74</td>\n",
       "      <td>50</td>\n",
       "      <td>581</td>\n",
       "      <td>55,186</td>\n",
       "      <td>33,696</td>\n",
       "      <td>257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>112,030</td>\n",
       "      <td>95,945</td>\n",
       "      <td>85.60%</td>\n",
       "      <td>51,330</td>\n",
       "      <td>41,150</td>\n",
       "      <td>1,614</td>\n",
       "      <td>500</td>\n",
       "      <td>114</td>\n",
       "      <td>73</td>\n",
       "      <td>471</td>\n",
       "      <td>50,358</td>\n",
       "      <td>44,342</td>\n",
       "      <td>202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>98,284</td>\n",
       "      <td>81,075</td>\n",
       "      <td>82.50%</td>\n",
       "      <td>40,299</td>\n",
       "      <td>37,260</td>\n",
       "      <td>1,897</td>\n",
       "      <td>343</td>\n",
       "      <td>89</td>\n",
       "      <td>60</td>\n",
       "      <td>563</td>\n",
       "      <td>38,158</td>\n",
       "      <td>41,547</td>\n",
       "      <td>301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>108,759</td>\n",
       "      <td>93,338</td>\n",
       "      <td>85.80%</td>\n",
       "      <td>47,219</td>\n",
       "      <td>41,729</td>\n",
       "      <td>2,513</td>\n",
       "      <td>389</td>\n",
       "      <td>74</td>\n",
       "      <td>59</td>\n",
       "      <td>698</td>\n",
       "      <td>45,117</td>\n",
       "      <td>46,729</td>\n",
       "      <td>315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>95,771</td>\n",
       "      <td>79,389</td>\n",
       "      <td>82.90%</td>\n",
       "      <td>55,161</td>\n",
       "      <td>20,913</td>\n",
       "      <td>1,559</td>\n",
       "      <td>468</td>\n",
       "      <td>143</td>\n",
       "      <td>51</td>\n",
       "      <td>597</td>\n",
       "      <td>53,706</td>\n",
       "      <td>24,154</td>\n",
       "      <td>337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>90,643</td>\n",
       "      <td>73,440</td>\n",
       "      <td>81.00%</td>\n",
       "      <td>42,010</td>\n",
       "      <td>28,026</td>\n",
       "      <td>1,784</td>\n",
       "      <td>316</td>\n",
       "      <td>87</td>\n",
       "      <td>50</td>\n",
       "      <td>609</td>\n",
       "      <td>40,730</td>\n",
       "      <td>31,181</td>\n",
       "      <td>307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>82,472</td>\n",
       "      <td>61,200</td>\n",
       "      <td>74.20%</td>\n",
       "      <td>35,822</td>\n",
       "      <td>22,629</td>\n",
       "      <td>1,476</td>\n",
       "      <td>392</td>\n",
       "      <td>117</td>\n",
       "      <td>77</td>\n",
       "      <td>385</td>\n",
       "      <td>34,793</td>\n",
       "      <td>25,214</td>\n",
       "      <td>243</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>84,706</td>\n",
       "      <td>66,744</td>\n",
       "      <td>78.80%</td>\n",
       "      <td>39,520</td>\n",
       "      <td>24,741</td>\n",
       "      <td>1,181</td>\n",
       "      <td>292</td>\n",
       "      <td>79</td>\n",
       "      <td>42</td>\n",
       "      <td>371</td>\n",
       "      <td>38,524</td>\n",
       "      <td>26,873</td>\n",
       "      <td>210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>31</td>\n",
       "      <td>107,641</td>\n",
       "      <td>91,305</td>\n",
       "      <td>84.80%</td>\n",
       "      <td>41,303</td>\n",
       "      <td>46,447</td>\n",
       "      <td>1,902</td>\n",
       "      <td>336</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>585</td>\n",
       "      <td>38,109</td>\n",
       "      <td>51,889</td>\n",
       "      <td>285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>32</td>\n",
       "      <td>98,892</td>\n",
       "      <td>85,336</td>\n",
       "      <td>86.30%</td>\n",
       "      <td>63,882</td>\n",
       "      <td>18,385</td>\n",
       "      <td>1,217</td>\n",
       "      <td>451</td>\n",
       "      <td>113</td>\n",
       "      <td>49</td>\n",
       "      <td>623</td>\n",
       "      <td>62,664</td>\n",
       "      <td>21,059</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>33</td>\n",
       "      <td>83,210</td>\n",
       "      <td>65,502</td>\n",
       "      <td>78.70%</td>\n",
       "      <td>44,662</td>\n",
       "      <td>18,465</td>\n",
       "      <td>1,037</td>\n",
       "      <td>310</td>\n",
       "      <td>90</td>\n",
       "      <td>51</td>\n",
       "      <td>341</td>\n",
       "      <td>43,754</td>\n",
       "      <td>20,267</td>\n",
       "      <td>198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>34</td>\n",
       "      <td>109,110</td>\n",
       "      <td>94,975</td>\n",
       "      <td>87.00%</td>\n",
       "      <td>77,869</td>\n",
       "      <td>14,243</td>\n",
       "      <td>1,120</td>\n",
       "      <td>413</td>\n",
       "      <td>136</td>\n",
       "      <td>63</td>\n",
       "      <td>519</td>\n",
       "      <td>76,155</td>\n",
       "      <td>16,922</td>\n",
       "      <td>253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>35</td>\n",
       "      <td>104,742</td>\n",
       "      <td>88,908</td>\n",
       "      <td>84.90%</td>\n",
       "      <td>42,694</td>\n",
       "      <td>42,326</td>\n",
       "      <td>2,204</td>\n",
       "      <td>430</td>\n",
       "      <td>86</td>\n",
       "      <td>54</td>\n",
       "      <td>556</td>\n",
       "      <td>40,823</td>\n",
       "      <td>46,839</td>\n",
       "      <td>289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>36</td>\n",
       "      <td>122,274</td>\n",
       "      <td>109,793</td>\n",
       "      <td>89.80%</td>\n",
       "      <td>96,778</td>\n",
       "      <td>9,714</td>\n",
       "      <td>1,300</td>\n",
       "      <td>559</td>\n",
       "      <td>156</td>\n",
       "      <td>62</td>\n",
       "      <td>617</td>\n",
       "      <td>94,908</td>\n",
       "      <td>12,862</td>\n",
       "      <td>281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>37</td>\n",
       "      <td>104,883</td>\n",
       "      <td>86,286</td>\n",
       "      <td>82.30%</td>\n",
       "      <td>74,478</td>\n",
       "      <td>9,303</td>\n",
       "      <td>650</td>\n",
       "      <td>502</td>\n",
       "      <td>193</td>\n",
       "      <td>79</td>\n",
       "      <td>463</td>\n",
       "      <td>74,445</td>\n",
       "      <td>9,947</td>\n",
       "      <td>210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>38</td>\n",
       "      <td>87,957</td>\n",
       "      <td>71,255</td>\n",
       "      <td>81.00%</td>\n",
       "      <td>41,500</td>\n",
       "      <td>26,583</td>\n",
       "      <td>1,647</td>\n",
       "      <td>397</td>\n",
       "      <td>128</td>\n",
       "      <td>56</td>\n",
       "      <td>505</td>\n",
       "      <td>39,616</td>\n",
       "      <td>30,492</td>\n",
       "      <td>280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>39</td>\n",
       "      <td>102,166</td>\n",
       "      <td>86,029</td>\n",
       "      <td>84.20%</td>\n",
       "      <td>37,249</td>\n",
       "      <td>44,753</td>\n",
       "      <td>2,277</td>\n",
       "      <td>388</td>\n",
       "      <td>111</td>\n",
       "      <td>63</td>\n",
       "      <td>596</td>\n",
       "      <td>34,385</td>\n",
       "      <td>50,439</td>\n",
       "      <td>312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>40</td>\n",
       "      <td>104,336</td>\n",
       "      <td>92,471</td>\n",
       "      <td>88.60%</td>\n",
       "      <td>62,390</td>\n",
       "      <td>26,438</td>\n",
       "      <td>1,657</td>\n",
       "      <td>484</td>\n",
       "      <td>153</td>\n",
       "      <td>61</td>\n",
       "      <td>629</td>\n",
       "      <td>61,162</td>\n",
       "      <td>29,846</td>\n",
       "      <td>230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>41</td>\n",
       "      <td>103,844</td>\n",
       "      <td>90,205</td>\n",
       "      <td>86.90%</td>\n",
       "      <td>63,836</td>\n",
       "      <td>22,942</td>\n",
       "      <td>1,368</td>\n",
       "      <td>314</td>\n",
       "      <td>55</td>\n",
       "      <td>24</td>\n",
       "      <td>705</td>\n",
       "      <td>62,206</td>\n",
       "      <td>25,766</td>\n",
       "      <td>291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>42</td>\n",
       "      <td>109,764</td>\n",
       "      <td>95,621</td>\n",
       "      <td>87.10%</td>\n",
       "      <td>50,694</td>\n",
       "      <td>41,146</td>\n",
       "      <td>1,779</td>\n",
       "      <td>443</td>\n",
       "      <td>104</td>\n",
       "      <td>60</td>\n",
       "      <td>668</td>\n",
       "      <td>49,336</td>\n",
       "      <td>44,850</td>\n",
       "      <td>302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>43</td>\n",
       "      <td>115,478</td>\n",
       "      <td>101,215</td>\n",
       "      <td>87.60%</td>\n",
       "      <td>91,614</td>\n",
       "      <td>6,417</td>\n",
       "      <td>1,029</td>\n",
       "      <td>651</td>\n",
       "      <td>291</td>\n",
       "      <td>70</td>\n",
       "      <td>544</td>\n",
       "      <td>90,781</td>\n",
       "      <td>8,544</td>\n",
       "      <td>251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>44</td>\n",
       "      <td>107,181</td>\n",
       "      <td>92,814</td>\n",
       "      <td>86.60%</td>\n",
       "      <td>51,636</td>\n",
       "      <td>37,069</td>\n",
       "      <td>2,176</td>\n",
       "      <td>399</td>\n",
       "      <td>76</td>\n",
       "      <td>46</td>\n",
       "      <td>735</td>\n",
       "      <td>48,565</td>\n",
       "      <td>42,788</td>\n",
       "      <td>354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>45</td>\n",
       "      <td>102,098</td>\n",
       "      <td>90,413</td>\n",
       "      <td>88.60%</td>\n",
       "      <td>62,921</td>\n",
       "      <td>23,729</td>\n",
       "      <td>1,722</td>\n",
       "      <td>315</td>\n",
       "      <td>65</td>\n",
       "      <td>23</td>\n",
       "      <td>743</td>\n",
       "      <td>60,698</td>\n",
       "      <td>27,655</td>\n",
       "      <td>344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>46</td>\n",
       "      <td>109,303</td>\n",
       "      <td>97,385</td>\n",
       "      <td>89.10%</td>\n",
       "      <td>82,192</td>\n",
       "      <td>11,908</td>\n",
       "      <td>1,219</td>\n",
       "      <td>537</td>\n",
       "      <td>160</td>\n",
       "      <td>47</td>\n",
       "      <td>621</td>\n",
       "      <td>80,722</td>\n",
       "      <td>14,728</td>\n",
       "      <td>309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>47</td>\n",
       "      <td>94,452</td>\n",
       "      <td>76,614</td>\n",
       "      <td>81.10%</td>\n",
       "      <td>44,286</td>\n",
       "      <td>29,414</td>\n",
       "      <td>1,388</td>\n",
       "      <td>300</td>\n",
       "      <td>70</td>\n",
       "      <td>54</td>\n",
       "      <td>455</td>\n",
       "      <td>43,014</td>\n",
       "      <td>32,094</td>\n",
       "      <td>204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>48</td>\n",
       "      <td>87,654</td>\n",
       "      <td>75,029</td>\n",
       "      <td>85.60%</td>\n",
       "      <td>53,699</td>\n",
       "      <td>18,252</td>\n",
       "      <td>1,292</td>\n",
       "      <td>338</td>\n",
       "      <td>73</td>\n",
       "      <td>19</td>\n",
       "      <td>629</td>\n",
       "      <td>52,722</td>\n",
       "      <td>20,345</td>\n",
       "      <td>255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>49</td>\n",
       "      <td>94,866</td>\n",
       "      <td>78,621</td>\n",
       "      <td>82.90%</td>\n",
       "      <td>46,577</td>\n",
       "      <td>28,843</td>\n",
       "      <td>1,595</td>\n",
       "      <td>453</td>\n",
       "      <td>91</td>\n",
       "      <td>51</td>\n",
       "      <td>574</td>\n",
       "      <td>46,376</td>\n",
       "      <td>30,373</td>\n",
       "      <td>245</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Legislative District Turnout_Registered Voters Turnout_Ballots Cast  \\\n",
       "0                      1                   106,217               93,372   \n",
       "1                      2                   106,280               86,171   \n",
       "2                      3                    91,050               70,214   \n",
       "3                      4                   113,683               93,601   \n",
       "4                      5                   110,814               97,471   \n",
       "5                      6                   107,630               90,057   \n",
       "6                      7                   106,783               89,895   \n",
       "7                      8                   100,696               82,892   \n",
       "8                      9                    85,769               71,484   \n",
       "9                     10                   111,652               96,776   \n",
       "10                    11                    89,463               72,288   \n",
       "11                    12                    93,009               79,217   \n",
       "12                    13                    84,351               70,022   \n",
       "13                    14                    86,902               69,841   \n",
       "14                    15                    66,014               48,489   \n",
       "15                    16                    77,960               63,144   \n",
       "16                    17                   104,127               87,351   \n",
       "17                    18                   115,185              101,214   \n",
       "18                    19                    92,751               76,034   \n",
       "19                    20                   103,227               87,255   \n",
       "20                    21                    98,061               83,575   \n",
       "21                    22                   112,393               95,281   \n",
       "22                    23                   106,338               90,342   \n",
       "23                    24                   112,030               95,945   \n",
       "24                    25                    98,284               81,075   \n",
       "25                    26                   108,759               93,338   \n",
       "26                    27                    95,771               79,389   \n",
       "27                    28                    90,643               73,440   \n",
       "28                    29                    82,472               61,200   \n",
       "29                    30                    84,706               66,744   \n",
       "30                    31                   107,641               91,305   \n",
       "31                    32                    98,892               85,336   \n",
       "32                    33                    83,210               65,502   \n",
       "33                    34                   109,110               94,975   \n",
       "34                    35                   104,742               88,908   \n",
       "35                    36                   122,274              109,793   \n",
       "36                    37                   104,883               86,286   \n",
       "37                    38                    87,957               71,255   \n",
       "38                    39                   102,166               86,029   \n",
       "39                    40                   104,336               92,471   \n",
       "40                    41                   103,844               90,205   \n",
       "41                    42                   109,764               95,621   \n",
       "42                    43                   115,478              101,215   \n",
       "43                    44                   107,181               92,814   \n",
       "44                    45                   102,098               90,413   \n",
       "45                    46                   109,303               97,385   \n",
       "46                    47                    94,452               76,614   \n",
       "47                    48                    87,654               75,029   \n",
       "48                    49                    94,866               78,621   \n",
       "\n",
       "   Turnout_% President/Vice President_Joseph R. Biden / Kamala D. Harris  \\\n",
       "0     87.90%                                             62,011            \n",
       "1     81.10%                                             35,289            \n",
       "2     77.10%                                             39,922            \n",
       "3     82.30%                                             36,525            \n",
       "4     88.00%                                             57,868            \n",
       "5     83.70%                                             44,883            \n",
       "6     84.20%                                             28,309            \n",
       "7     82.30%                                             32,595            \n",
       "8     83.30%                                             27,886            \n",
       "9     86.70%                                             49,457            \n",
       "10    80.80%                                             50,475            \n",
       "11    85.20%                                             33,648            \n",
       "12    83.00%                                             24,302            \n",
       "13    80.40%                                             30,673            \n",
       "14    73.50%                                             22,124            \n",
       "15    81.00%                                             25,180            \n",
       "16    83.90%                                             43,637            \n",
       "17    87.90%                                             47,030            \n",
       "18    82.00%                                             33,132            \n",
       "19    84.50%                                             28,956            \n",
       "20    85.20%                                             55,372            \n",
       "21    84.80%                                             62,311            \n",
       "22    85.00%                                             56,406            \n",
       "23    85.60%                                             51,330            \n",
       "24    82.50%                                             40,299            \n",
       "25    85.80%                                             47,219            \n",
       "26    82.90%                                             55,161            \n",
       "27    81.00%                                             42,010            \n",
       "28    74.20%                                             35,822            \n",
       "29    78.80%                                             39,520            \n",
       "30    84.80%                                             41,303            \n",
       "31    86.30%                                             63,882            \n",
       "32    78.70%                                             44,662            \n",
       "33    87.00%                                             77,869            \n",
       "34    84.90%                                             42,694            \n",
       "35    89.80%                                             96,778            \n",
       "36    82.30%                                             74,478            \n",
       "37    81.00%                                             41,500            \n",
       "38    84.20%                                             37,249            \n",
       "39    88.60%                                             62,390            \n",
       "40    86.90%                                             63,836            \n",
       "41    87.10%                                             50,694            \n",
       "42    87.60%                                             91,614            \n",
       "43    86.60%                                             51,636            \n",
       "44    88.60%                                             62,921            \n",
       "45    89.10%                                             82,192            \n",
       "46    81.10%                                             44,286            \n",
       "47    85.60%                                             53,699            \n",
       "48    82.90%                                             46,577            \n",
       "\n",
       "   President/Vice President_Donald J. Trump / Michael R. Pence  \\\n",
       "0                                              27,575            \n",
       "1                                              47,157            \n",
       "2                                              26,940            \n",
       "3                                              53,123            \n",
       "4                                              35,379            \n",
       "5                                              41,319            \n",
       "6                                              58,375            \n",
       "7                                              46,342            \n",
       "8                                              40,531            \n",
       "9                                              43,329            \n",
       "10                                             19,212            \n",
       "11                                             42,869            \n",
       "12                                             43,145            \n",
       "13                                             36,693            \n",
       "14                                             24,801            \n",
       "15                                             35,353            \n",
       "16                                             40,468            \n",
       "17                                             50,547            \n",
       "18                                             40,057            \n",
       "19                                             54,990            \n",
       "20                                             24,976            \n",
       "21                                             28,830            \n",
       "22                                             29,815            \n",
       "23                                             41,150            \n",
       "24                                             37,260            \n",
       "25                                             41,729            \n",
       "26                                             20,913            \n",
       "27                                             28,026            \n",
       "28                                             22,629            \n",
       "29                                             24,741            \n",
       "30                                             46,447            \n",
       "31                                             18,385            \n",
       "32                                             18,465            \n",
       "33                                             14,243            \n",
       "34                                             42,326            \n",
       "35                                              9,714            \n",
       "36                                              9,303            \n",
       "37                                             26,583            \n",
       "38                                             44,753            \n",
       "39                                             26,438            \n",
       "40                                             22,942            \n",
       "41                                             41,146            \n",
       "42                                              6,417            \n",
       "43                                             37,069            \n",
       "44                                             23,729            \n",
       "45                                             11,908            \n",
       "46                                             29,414            \n",
       "47                                             18,252            \n",
       "48                                             28,843            \n",
       "\n",
       "   President/Vice President_Jo Jorgensen / Jeremy \"Spike\" Cohen  \\\n",
       "0                                               1,843             \n",
       "1                                               2,229             \n",
       "2                                               1,818             \n",
       "3                                               2,324             \n",
       "4                                               2,209             \n",
       "5                                               2,096             \n",
       "6                                               1,703             \n",
       "7                                               2,280             \n",
       "8                                               1,605             \n",
       "9                                               2,150             \n",
       "10                                              1,113             \n",
       "11                                              1,237             \n",
       "12                                              1,333             \n",
       "13                                              1,103             \n",
       "14                                                704             \n",
       "15                                              1,369             \n",
       "16                                              1,727             \n",
       "17                                              1,835             \n",
       "18                                              1,493             \n",
       "19                                              1,790             \n",
       "20                                              1,525             \n",
       "21                                              1,963             \n",
       "22                                              2,448             \n",
       "23                                              1,614             \n",
       "24                                              1,897             \n",
       "25                                              2,513             \n",
       "26                                              1,559             \n",
       "27                                              1,784             \n",
       "28                                              1,476             \n",
       "29                                              1,181             \n",
       "30                                              1,902             \n",
       "31                                              1,217             \n",
       "32                                              1,037             \n",
       "33                                              1,120             \n",
       "34                                              2,204             \n",
       "35                                              1,300             \n",
       "36                                                650             \n",
       "37                                              1,647             \n",
       "38                                              2,277             \n",
       "39                                              1,657             \n",
       "40                                              1,368             \n",
       "41                                              1,779             \n",
       "42                                              1,029             \n",
       "43                                              2,176             \n",
       "44                                              1,722             \n",
       "45                                              1,219             \n",
       "46                                              1,388             \n",
       "47                                              1,292             \n",
       "48                                              1,595             \n",
       "\n",
       "    President/Vice President_Howie Hawkins / Angela Walker  \\\n",
       "0                                                 397        \n",
       "1                                                 353        \n",
       "2                                                 461        \n",
       "3                                                 352        \n",
       "4                                                 333        \n",
       "5                                                 348        \n",
       "6                                                 268        \n",
       "7                                                 317        \n",
       "8                                                 283        \n",
       "9                                                 351        \n",
       "10                                                319        \n",
       "11                                                275        \n",
       "12                                                224        \n",
       "13                                                233        \n",
       "14                                                166        \n",
       "15                                                201        \n",
       "16                                                340        \n",
       "17                                                308        \n",
       "18                                                322        \n",
       "19                                                340        \n",
       "20                                                368        \n",
       "21                                                630        \n",
       "22                                                380        \n",
       "23                                                500        \n",
       "24                                                343        \n",
       "25                                                389        \n",
       "26                                                468        \n",
       "27                                                316        \n",
       "28                                                392        \n",
       "29                                                292        \n",
       "30                                                336        \n",
       "31                                                451        \n",
       "32                                                310        \n",
       "33                                                413        \n",
       "34                                                430        \n",
       "35                                                559        \n",
       "36                                                502        \n",
       "37                                                397        \n",
       "38                                                388        \n",
       "39                                                484        \n",
       "40                                                314        \n",
       "41                                                443        \n",
       "42                                                651        \n",
       "43                                                399        \n",
       "44                                                315        \n",
       "45                                                537        \n",
       "46                                                300        \n",
       "47                                                338        \n",
       "48                                                453        \n",
       "\n",
       "    President/Vice President_Gloria La Riva / Sunil Freeman  \\\n",
       "0                                                  83         \n",
       "1                                                  67         \n",
       "2                                                 121         \n",
       "3                                                  77         \n",
       "4                                                  50         \n",
       "5                                                  91         \n",
       "6                                                  63         \n",
       "7                                                  95         \n",
       "8                                                  60         \n",
       "9                                                  83         \n",
       "10                                                 91         \n",
       "11                                                 71         \n",
       "12                                                 71         \n",
       "13                                                 80         \n",
       "14                                                 89         \n",
       "15                                                 91         \n",
       "16                                                 73         \n",
       "17                                                 68         \n",
       "18                                                 64         \n",
       "19                                                 79         \n",
       "20                                                 94         \n",
       "21                                                206         \n",
       "22                                                 74         \n",
       "23                                                114         \n",
       "24                                                 89         \n",
       "25                                                 74         \n",
       "26                                                143         \n",
       "27                                                 87         \n",
       "28                                                117         \n",
       "29                                                 79         \n",
       "30                                                 45         \n",
       "31                                                113         \n",
       "32                                                 90         \n",
       "33                                                136         \n",
       "34                                                 86         \n",
       "35                                                156         \n",
       "36                                                193         \n",
       "37                                                128         \n",
       "38                                                111         \n",
       "39                                                153         \n",
       "40                                                 55         \n",
       "41                                                104         \n",
       "42                                                291         \n",
       "43                                                 76         \n",
       "44                                                 65         \n",
       "45                                                160         \n",
       "46                                                 70         \n",
       "47                                                 73         \n",
       "48                                                 91         \n",
       "\n",
       "    President/Vice President_Alyson Kennedy / Malcolm M. Jarrett  \\\n",
       "0                                                  37              \n",
       "1                                                  50              \n",
       "2                                                  96              \n",
       "3                                                  41              \n",
       "4                                                  44              \n",
       "5                                                  46              \n",
       "6                                                  43              \n",
       "7                                                  46              \n",
       "8                                                  45              \n",
       "9                                                  44              \n",
       "10                                                 46              \n",
       "11                                                 44              \n",
       "12                                                 35              \n",
       "13                                                 49              \n",
       "14                                                 46              \n",
       "15                                                 34              \n",
       "16                                                 42              \n",
       "17                                                 42              \n",
       "18                                                 62              \n",
       "19                                                 41              \n",
       "20                                                 46              \n",
       "21                                                 69              \n",
       "22                                                 50              \n",
       "23                                                 73              \n",
       "24                                                 60              \n",
       "25                                                 59              \n",
       "26                                                 51              \n",
       "27                                                 50              \n",
       "28                                                 77              \n",
       "29                                                 42              \n",
       "30                                                 45              \n",
       "31                                                 49              \n",
       "32                                                 51              \n",
       "33                                                 63              \n",
       "34                                                 54              \n",
       "35                                                 62              \n",
       "36                                                 79              \n",
       "37                                                 56              \n",
       "38                                                 63              \n",
       "39                                                 61              \n",
       "40                                                 24              \n",
       "41                                                 60              \n",
       "42                                                 70              \n",
       "43                                                 46              \n",
       "44                                                 23              \n",
       "45                                                 47              \n",
       "46                                                 54              \n",
       "47                                                 19              \n",
       "48                                                 51              \n",
       "\n",
       "    President/Vice President_Write-in Governor_Jay Inslee Governor_Loren Culp  \\\n",
       "0                                 703              59,793              31,768   \n",
       "1                                 572              33,043              51,807   \n",
       "2                                 506              39,184              29,945   \n",
       "3                                 628              35,132              57,264   \n",
       "4                                 777              54,640              40,964   \n",
       "5                                 726              43,678              44,981   \n",
       "6                                 504              26,705              61,991   \n",
       "7                                 637              31,306              50,202   \n",
       "8                                 453              26,734              43,572   \n",
       "9                                 657              47,186              48,106   \n",
       "10                                466              49,641              20,958   \n",
       "11                                491              31,240              46,678   \n",
       "12                                399              22,223              46,705   \n",
       "13                                419              29,262              39,302   \n",
       "14                                195              21,202              26,468   \n",
       "15                                338              24,209              37,815   \n",
       "16                                602              43,066              42,372   \n",
       "17                                729              45,785              53,508   \n",
       "18                                361              31,183              43,678   \n",
       "19                                463              27,255              58,868   \n",
       "20                                581              53,754              28,237   \n",
       "21                                662              61,009              32,436   \n",
       "22                                581              55,186              33,696   \n",
       "23                                471              50,358              44,342   \n",
       "24                                563              38,158              41,547   \n",
       "25                                698              45,117              46,729   \n",
       "26                                597              53,706              24,154   \n",
       "27                                609              40,730              31,181   \n",
       "28                                385              34,793              25,214   \n",
       "29                                371              38,524              26,873   \n",
       "30                                585              38,109              51,889   \n",
       "31                                623              62,664              21,059   \n",
       "32                                341              43,754              20,267   \n",
       "33                                519              76,155              16,922   \n",
       "34                                556              40,823              46,839   \n",
       "35                                617              94,908              12,862   \n",
       "36                                463              74,445               9,947   \n",
       "37                                505              39,616              30,492   \n",
       "38                                596              34,385              50,439   \n",
       "39                                629              61,162              29,846   \n",
       "40                                705              62,206              25,766   \n",
       "41                                668              49,336              44,850   \n",
       "42                                544              90,781               8,544   \n",
       "43                                735              48,565              42,788   \n",
       "44                                743              60,698              27,655   \n",
       "45                                621              80,722              14,728   \n",
       "46                                455              43,014              32,094   \n",
       "47                                629              52,722              20,345   \n",
       "48                                574              46,376              30,373   \n",
       "\n",
       "    Governor_Write-in  \n",
       "0                 367  \n",
       "1                 281  \n",
       "2                 269  \n",
       "3                 309  \n",
       "4                 337  \n",
       "5                 337  \n",
       "6                 264  \n",
       "7                 339  \n",
       "8                 235  \n",
       "9                 287  \n",
       "10                218  \n",
       "11                318  \n",
       "12                223  \n",
       "13                213  \n",
       "14                121  \n",
       "15                186  \n",
       "16                234  \n",
       "17                221  \n",
       "18                238  \n",
       "19                234  \n",
       "20                291  \n",
       "21                338  \n",
       "22                257  \n",
       "23                202  \n",
       "24                301  \n",
       "25                315  \n",
       "26                337  \n",
       "27                307  \n",
       "28                243  \n",
       "29                210  \n",
       "30                285  \n",
       "31                220  \n",
       "32                198  \n",
       "33                253  \n",
       "34                289  \n",
       "35                281  \n",
       "36                210  \n",
       "37                280  \n",
       "38                312  \n",
       "39                230  \n",
       "40                291  \n",
       "41                302  \n",
       "42                251  \n",
       "43                354  \n",
       "44                344  \n",
       "45                309  \n",
       "46                204  \n",
       "47                255  \n",
       "48                245  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pres_results = pd.read_csv(\"data/2020_election_results.csv\")\n",
    "pres_results"
   ]
  },
  {
   "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>SUMLEV</th>\n",
       "      <th>STATE</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>STNAME</th>\n",
       "      <th>CTYNAME</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>AGEGRP</th>\n",
       "      <th>TOT_POP</th>\n",
       "      <th>TOT_MALE</th>\n",
       "      <th>TOT_FEMALE</th>\n",
       "      <th>...</th>\n",
       "      <th>HWAC_MALE</th>\n",
       "      <th>HWAC_FEMALE</th>\n",
       "      <th>HBAC_MALE</th>\n",
       "      <th>HBAC_FEMALE</th>\n",
       "      <th>HIAC_MALE</th>\n",
       "      <th>HIAC_FEMALE</th>\n",
       "      <th>HAAC_MALE</th>\n",
       "      <th>HAAC_FEMALE</th>\n",
       "      <th>HNAC_MALE</th>\n",
       "      <th>HNAC_FEMALE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>50</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Adams County</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>20612</td>\n",
       "      <td>10468</td>\n",
       "      <td>10144</td>\n",
       "      <td>...</td>\n",
       "      <td>6014</td>\n",
       "      <td>5614</td>\n",
       "      <td>232</td>\n",
       "      <td>177</td>\n",
       "      <td>668</td>\n",
       "      <td>620</td>\n",
       "      <td>83</td>\n",
       "      <td>85</td>\n",
       "      <td>39</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>50</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Adams County</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1887</td>\n",
       "      <td>958</td>\n",
       "      <td>929</td>\n",
       "      <td>...</td>\n",
       "      <td>582</td>\n",
       "      <td>525</td>\n",
       "      <td>64</td>\n",
       "      <td>33</td>\n",
       "      <td>128</td>\n",
       "      <td>162</td>\n",
       "      <td>12</td>\n",
       "      <td>16</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>50</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Adams County</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2082</td>\n",
       "      <td>1057</td>\n",
       "      <td>1025</td>\n",
       "      <td>...</td>\n",
       "      <td>635</td>\n",
       "      <td>618</td>\n",
       "      <td>31</td>\n",
       "      <td>33</td>\n",
       "      <td>121</td>\n",
       "      <td>133</td>\n",
       "      <td>11</td>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>50</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Adams County</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2199</td>\n",
       "      <td>1153</td>\n",
       "      <td>1046</td>\n",
       "      <td>...</td>\n",
       "      <td>804</td>\n",
       "      <td>734</td>\n",
       "      <td>22</td>\n",
       "      <td>10</td>\n",
       "      <td>71</td>\n",
       "      <td>70</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>50</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Adams County</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1821</td>\n",
       "      <td>972</td>\n",
       "      <td>849</td>\n",
       "      <td>...</td>\n",
       "      <td>702</td>\n",
       "      <td>601</td>\n",
       "      <td>16</td>\n",
       "      <td>11</td>\n",
       "      <td>49</td>\n",
       "      <td>53</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>736</th>\n",
       "      <td>50</td>\n",
       "      <td>53</td>\n",
       "      <td>77</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Yakima County</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>11565</td>\n",
       "      <td>5546</td>\n",
       "      <td>6019</td>\n",
       "      <td>...</td>\n",
       "      <td>1297</td>\n",
       "      <td>1234</td>\n",
       "      <td>22</td>\n",
       "      <td>9</td>\n",
       "      <td>70</td>\n",
       "      <td>54</td>\n",
       "      <td>17</td>\n",
       "      <td>23</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>737</th>\n",
       "      <td>50</td>\n",
       "      <td>53</td>\n",
       "      <td>77</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Yakima County</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>9469</td>\n",
       "      <td>4606</td>\n",
       "      <td>4863</td>\n",
       "      <td>...</td>\n",
       "      <td>956</td>\n",
       "      <td>835</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>36</td>\n",
       "      <td>31</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>738</th>\n",
       "      <td>50</td>\n",
       "      <td>53</td>\n",
       "      <td>77</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Yakima County</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>6432</td>\n",
       "      <td>3051</td>\n",
       "      <td>3381</td>\n",
       "      <td>...</td>\n",
       "      <td>536</td>\n",
       "      <td>494</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>739</th>\n",
       "      <td>50</td>\n",
       "      <td>53</td>\n",
       "      <td>77</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Yakima County</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>4096</td>\n",
       "      <td>1799</td>\n",
       "      <td>2297</td>\n",
       "      <td>...</td>\n",
       "      <td>322</td>\n",
       "      <td>397</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>740</th>\n",
       "      <td>50</td>\n",
       "      <td>53</td>\n",
       "      <td>77</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Yakima County</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>4251</td>\n",
       "      <td>1552</td>\n",
       "      <td>2699</td>\n",
       "      <td>...</td>\n",
       "      <td>252</td>\n",
       "      <td>339</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>741 rows × 80 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     SUMLEV  STATE  COUNTY      STNAME        CTYNAME  YEAR  AGEGRP  TOT_POP  \\\n",
       "0        50     53       1  Washington   Adams County     1       0    20612   \n",
       "1        50     53       1  Washington   Adams County     1       1     1887   \n",
       "2        50     53       1  Washington   Adams County     1       2     2082   \n",
       "3        50     53       1  Washington   Adams County     1       3     2199   \n",
       "4        50     53       1  Washington   Adams County     1       4     1821   \n",
       "..      ...    ...     ...         ...            ...   ...     ...      ...   \n",
       "736      50     53      77  Washington  Yakima County     1      14    11565   \n",
       "737      50     53      77  Washington  Yakima County     1      15     9469   \n",
       "738      50     53      77  Washington  Yakima County     1      16     6432   \n",
       "739      50     53      77  Washington  Yakima County     1      17     4096   \n",
       "740      50     53      77  Washington  Yakima County     1      18     4251   \n",
       "\n",
       "     TOT_MALE  TOT_FEMALE  ...  HWAC_MALE  HWAC_FEMALE  HBAC_MALE  \\\n",
       "0       10468       10144  ...       6014         5614        232   \n",
       "1         958         929  ...        582          525         64   \n",
       "2        1057        1025  ...        635          618         31   \n",
       "3        1153        1046  ...        804          734         22   \n",
       "4         972         849  ...        702          601         16   \n",
       "..        ...         ...  ...        ...          ...        ...   \n",
       "736      5546        6019  ...       1297         1234         22   \n",
       "737      4606        4863  ...        956          835          8   \n",
       "738      3051        3381  ...        536          494         10   \n",
       "739      1799        2297  ...        322          397          3   \n",
       "740      1552        2699  ...        252          339          1   \n",
       "\n",
       "     HBAC_FEMALE  HIAC_MALE  HIAC_FEMALE  HAAC_MALE  HAAC_FEMALE  HNAC_MALE  \\\n",
       "0            177        668          620         83           85         39   \n",
       "1             33        128          162         12           16          6   \n",
       "2             33        121          133         11           16          9   \n",
       "3             10         71           70          8            7          3   \n",
       "4             11         49           53          7            9          3   \n",
       "..           ...        ...          ...        ...          ...        ...   \n",
       "736            9         70           54         17           23          4   \n",
       "737           12         36           31         11           12          3   \n",
       "738            6         21           21          7            7          1   \n",
       "739            4         14            5          1            6          1   \n",
       "740            4          6            7          3            7          3   \n",
       "\n",
       "     HNAC_FEMALE  \n",
       "0             26  \n",
       "1              5  \n",
       "2              7  \n",
       "3              5  \n",
       "4              2  \n",
       "..           ...  \n",
       "736            5  \n",
       "737            3  \n",
       "738            2  \n",
       "739            5  \n",
       "740            0  \n",
       "\n",
       "[741 rows x 80 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "demographics = pd.read_csv(\"data/census_demographics.csv\")\n",
    "### Year 1 = 2020 census, other years are projections and therefore not relevant.\n",
    "demographics = demographics[demographics['YEAR']==1].reset_index(drop=True)\n",
    "\n",
    "### THE NEXT LEVEL OF DATA IS GRANULAR AT THE LEVEL OF AGES. THE PARAMETERS OF THE ASSIGNMENT DO NOT SPECIFY TAKING AGE INTO ACCOUNT SO I WILL AGGREGATE. \n",
    "\n",
    "identifier_fields=[\n",
    "    'SUMLEV',\n",
    "    'STATE',\n",
    "    'COUNTY',\n",
    "    'STNAME',\n",
    "    'CTYNAM', \n",
    "    'YEAR']\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "demographics = demographics.groupby\n",
    "\n"
   ]
  }
 ],
 "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.10.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}