legislatures_data_cleanup.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "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>State</th>\n",
       "      <th>population</th>\n",
       "      <th>senate_seats</th>\n",
       "      <th>rep_seats</th>\n",
       "      <th>pop_per_senator</th>\n",
       "      <th>pop_per_rep</th>\n",
       "      <th>total_seats</th>\n",
       "      <th>pop_per_legislator</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>California</td>\n",
       "      <td>37253956.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>931349.0</td>\n",
       "      <td>465674.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>310450.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Texas</td>\n",
       "      <td>25145561.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>811147.0</td>\n",
       "      <td>167637.0</td>\n",
       "      <td>181.0</td>\n",
       "      <td>138926.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>New York</td>\n",
       "      <td>19378102.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>307589.0</td>\n",
       "      <td>129187.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>90977.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Florida</td>\n",
       "      <td>18801310.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>470033.0</td>\n",
       "      <td>156678.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>117508.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Illinois</td>\n",
       "      <td>12830632.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>217468.0</td>\n",
       "      <td>108734.0</td>\n",
       "      <td>177.0</td>\n",
       "      <td>72489.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>12702379.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>203.0</td>\n",
       "      <td>254048.0</td>\n",
       "      <td>62573.0</td>\n",
       "      <td>253.0</td>\n",
       "      <td>50207.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ohio</td>\n",
       "      <td>11536504.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>349591.0</td>\n",
       "      <td>116530.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>87398.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>9883640.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>260096.0</td>\n",
       "      <td>89851.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>66781.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>9687653.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>172994.0</td>\n",
       "      <td>53820.0</td>\n",
       "      <td>236.0</td>\n",
       "      <td>41049.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>North Carolina</td>\n",
       "      <td>9535483.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>190710.0</td>\n",
       "      <td>79462.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>56091.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>New Jersey</td>\n",
       "      <td>8791894.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>219797.0</td>\n",
       "      <td>109899.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>73266.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>8001024.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>200026.0</td>\n",
       "      <td>80010.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>57150.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Washington</td>\n",
       "      <td>6724540.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>137236.0</td>\n",
       "      <td>68618.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>45745.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>6547629.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>163691.0</td>\n",
       "      <td>40923.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>32738.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Indiana</td>\n",
       "      <td>6483802.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>129676.0</td>\n",
       "      <td>64838.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>43225.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>6392017.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>213067.0</td>\n",
       "      <td>106534.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>71022.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Tennessee</td>\n",
       "      <td>6346105.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>192306.0</td>\n",
       "      <td>64102.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>48077.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Missouri</td>\n",
       "      <td>5988927.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>176145.0</td>\n",
       "      <td>36742.0</td>\n",
       "      <td>197.0</td>\n",
       "      <td>30401.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>5773552.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>122842.0</td>\n",
       "      <td>40947.0</td>\n",
       "      <td>188.0</td>\n",
       "      <td>30710.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>5686986.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>172333.0</td>\n",
       "      <td>57444.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>43083.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Minnesota</td>\n",
       "      <td>5303925.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>79163.0</td>\n",
       "      <td>39582.0</td>\n",
       "      <td>201.0</td>\n",
       "      <td>26388.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Colorado</td>\n",
       "      <td>5029196.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>143691.0</td>\n",
       "      <td>77372.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50292.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>4779736.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>136564.0</td>\n",
       "      <td>45521.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>34141.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>South Carolina</td>\n",
       "      <td>4625364.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>100551.0</td>\n",
       "      <td>37301.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>27208.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Louisiana</td>\n",
       "      <td>4533372.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>116240.0</td>\n",
       "      <td>43175.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>31482.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Kentucky</td>\n",
       "      <td>4339367.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>114194.0</td>\n",
       "      <td>43394.0</td>\n",
       "      <td>138.0</td>\n",
       "      <td>31445.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Oregon</td>\n",
       "      <td>3831074.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>127702.0</td>\n",
       "      <td>63851.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>42567.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>3751351.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>78153.0</td>\n",
       "      <td>37142.0</td>\n",
       "      <td>149.0</td>\n",
       "      <td>25177.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Connecticut</td>\n",
       "      <td>3574097.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>99280.0</td>\n",
       "      <td>23670.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>19113.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>3046355.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60927.0</td>\n",
       "      <td>30464.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>20309.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Mississippi</td>\n",
       "      <td>2967297.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>57063.0</td>\n",
       "      <td>24322.0</td>\n",
       "      <td>174.0</td>\n",
       "      <td>17053.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>2915918.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>83312.0</td>\n",
       "      <td>29159.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>21599.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Kansas</td>\n",
       "      <td>2853118.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>71328.0</td>\n",
       "      <td>22825.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>17292.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Utah</td>\n",
       "      <td>2763885.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>95306.0</td>\n",
       "      <td>36852.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>26576.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Nevada</td>\n",
       "      <td>2700551.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>128598.0</td>\n",
       "      <td>64299.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>42866.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>New Mexico</td>\n",
       "      <td>2059179.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>49028.0</td>\n",
       "      <td>29417.0</td>\n",
       "      <td>112.0</td>\n",
       "      <td>18386.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>1852994.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>54500.0</td>\n",
       "      <td>18530.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>13828.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Nebraska</td>\n",
       "      <td>1826341.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37272.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>49.0</td>\n",
       "      <td>37272.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Idaho</td>\n",
       "      <td>1567582.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>44788.0</td>\n",
       "      <td>22394.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>14929.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Hawaii</td>\n",
       "      <td>1360301.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>54412.0</td>\n",
       "      <td>26673.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>17899.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Maine</td>\n",
       "      <td>1328361.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>37953.0</td>\n",
       "      <td>8797.0</td>\n",
       "      <td>186.0</td>\n",
       "      <td>7142.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>New Hampshire</td>\n",
       "      <td>1316470.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>54853.0</td>\n",
       "      <td>3291.0</td>\n",
       "      <td>424.0</td>\n",
       "      <td>3105.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>1052567.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>27699.0</td>\n",
       "      <td>14034.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>9315.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Montana</td>\n",
       "      <td>989415.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>19788.0</td>\n",
       "      <td>9894.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>6596.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Delaware</td>\n",
       "      <td>897934.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>42759.0</td>\n",
       "      <td>21901.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>14483.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>814180.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>23262.0</td>\n",
       "      <td>11631.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>7754.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>710231.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>35512.0</td>\n",
       "      <td>17756.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>11837.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>North Dakota</td>\n",
       "      <td>672591.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>14310.0</td>\n",
       "      <td>7155.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>4770.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Vermont</td>\n",
       "      <td>625741.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>20858.0</td>\n",
       "      <td>4172.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>3476.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Wyoming</td>\n",
       "      <td>563626.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>18788.0</td>\n",
       "      <td>9394.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>6263.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             State  population  senate_seats  rep_seats  pop_per_senator  \\\n",
       "1       California  37253956.0          40.0       80.0         931349.0   \n",
       "2            Texas  25145561.0          31.0      150.0         811147.0   \n",
       "3         New York  19378102.0          63.0      150.0         307589.0   \n",
       "4          Florida  18801310.0          40.0      120.0         470033.0   \n",
       "5         Illinois  12830632.0          59.0      118.0         217468.0   \n",
       "6     Pennsylvania  12702379.0          50.0      203.0         254048.0   \n",
       "7             Ohio  11536504.0          33.0       99.0         349591.0   \n",
       "8         Michigan   9883640.0          38.0      110.0         260096.0   \n",
       "9          Georgia   9687653.0          56.0      180.0         172994.0   \n",
       "10  North Carolina   9535483.0          50.0      120.0         190710.0   \n",
       "11      New Jersey   8791894.0          40.0       80.0         219797.0   \n",
       "12        Virginia   8001024.0          40.0      100.0         200026.0   \n",
       "13      Washington   6724540.0          49.0       98.0         137236.0   \n",
       "14   Massachusetts   6547629.0          40.0      160.0         163691.0   \n",
       "15         Indiana   6483802.0          50.0      100.0         129676.0   \n",
       "16         Arizona   6392017.0          30.0       60.0         213067.0   \n",
       "17       Tennessee   6346105.0          33.0       99.0         192306.0   \n",
       "18        Missouri   5988927.0          34.0      163.0         176145.0   \n",
       "19        Maryland   5773552.0          47.0      141.0         122842.0   \n",
       "20       Wisconsin   5686986.0          33.0       99.0         172333.0   \n",
       "21       Minnesota   5303925.0          67.0      134.0          79163.0   \n",
       "22        Colorado   5029196.0          35.0       65.0         143691.0   \n",
       "23         Alabama   4779736.0          35.0      105.0         136564.0   \n",
       "24  South Carolina   4625364.0          46.0      124.0         100551.0   \n",
       "25       Louisiana   4533372.0          39.0      105.0         116240.0   \n",
       "26        Kentucky   4339367.0          38.0      100.0         114194.0   \n",
       "27          Oregon   3831074.0          30.0       60.0         127702.0   \n",
       "28        Oklahoma   3751351.0          48.0      101.0          78153.0   \n",
       "29     Connecticut   3574097.0          36.0      151.0          99280.0   \n",
       "30            Iowa   3046355.0          50.0      100.0          60927.0   \n",
       "31     Mississippi   2967297.0          52.0      122.0          57063.0   \n",
       "32        Arkansas   2915918.0          35.0      100.0          83312.0   \n",
       "33          Kansas   2853118.0          40.0      125.0          71328.0   \n",
       "34            Utah   2763885.0          29.0       75.0          95306.0   \n",
       "35          Nevada   2700551.0          21.0       42.0         128598.0   \n",
       "36      New Mexico   2059179.0          42.0       70.0          49028.0   \n",
       "37   West Virginia   1852994.0          34.0      100.0          54500.0   \n",
       "38        Nebraska   1826341.0          49.0        0.0          37272.0   \n",
       "39           Idaho   1567582.0          35.0       70.0          44788.0   \n",
       "40          Hawaii   1360301.0          25.0       51.0          54412.0   \n",
       "41           Maine   1328361.0          35.0      151.0          37953.0   \n",
       "42   New Hampshire   1316470.0          24.0      400.0          54853.0   \n",
       "43    Rhode Island   1052567.0          38.0       75.0          27699.0   \n",
       "44         Montana    989415.0          50.0      100.0          19788.0   \n",
       "45        Delaware    897934.0          21.0       41.0          42759.0   \n",
       "46    South Dakota    814180.0          35.0       70.0          23262.0   \n",
       "47          Alaska    710231.0          20.0       40.0          35512.0   \n",
       "48    North Dakota    672591.0          47.0       94.0          14310.0   \n",
       "49         Vermont    625741.0          30.0      150.0          20858.0   \n",
       "50         Wyoming    563626.0          30.0       60.0          18788.0   \n",
       "\n",
       "    pop_per_rep  total_seats  pop_per_legislator  \n",
       "1      465674.0        120.0            310450.0  \n",
       "2      167637.0        181.0            138926.0  \n",
       "3      129187.0        213.0             90977.0  \n",
       "4      156678.0        160.0            117508.0  \n",
       "5      108734.0        177.0             72489.0  \n",
       "6       62573.0        253.0             50207.0  \n",
       "7      116530.0        132.0             87398.0  \n",
       "8       89851.0        148.0             66781.0  \n",
       "9       53820.0        236.0             41049.0  \n",
       "10      79462.0        170.0             56091.0  \n",
       "11     109899.0        120.0             73266.0  \n",
       "12      80010.0        140.0             57150.0  \n",
       "13      68618.0        147.0             45745.0  \n",
       "14      40923.0        200.0             32738.0  \n",
       "15      64838.0        150.0             43225.0  \n",
       "16     106534.0         90.0             71022.0  \n",
       "17      64102.0        132.0             48077.0  \n",
       "18      36742.0        197.0             30401.0  \n",
       "19      40947.0        188.0             30710.0  \n",
       "20      57444.0        132.0             43083.0  \n",
       "21      39582.0        201.0             26388.0  \n",
       "22      77372.0        100.0             50292.0  \n",
       "23      45521.0        140.0             34141.0  \n",
       "24      37301.0        170.0             27208.0  \n",
       "25      43175.0        144.0             31482.0  \n",
       "26      43394.0        138.0             31445.0  \n",
       "27      63851.0         90.0             42567.0  \n",
       "28      37142.0        149.0             25177.0  \n",
       "29      23670.0        187.0             19113.0  \n",
       "30      30464.0        150.0             20309.0  \n",
       "31      24322.0        174.0             17053.0  \n",
       "32      29159.0        135.0             21599.0  \n",
       "33      22825.0        165.0             17292.0  \n",
       "34      36852.0        104.0             26576.0  \n",
       "35      64299.0         63.0             42866.0  \n",
       "36      29417.0        112.0             18386.0  \n",
       "37      18530.0        134.0             13828.0  \n",
       "38          NaN         49.0             37272.0  \n",
       "39      22394.0        105.0             14929.0  \n",
       "40      26673.0         76.0             17899.0  \n",
       "41       8797.0        186.0              7142.0  \n",
       "42       3291.0        424.0              3105.0  \n",
       "43      14034.0        113.0              9315.0  \n",
       "44       9894.0        150.0              6596.0  \n",
       "45      21901.0         62.0             14483.0  \n",
       "46      11631.0        105.0              7754.0  \n",
       "47      17756.0         60.0             11837.0  \n",
       "48       7155.0        141.0              4770.0  \n",
       "49       4172.0        180.0              3476.0  \n",
       "50       9394.0         90.0              6263.0  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_leg = pd.read_csv('data\\state_legislatures_size.csv')\n",
    "df_leg = df_leg.drop(['population_per_representative_2000','population_per_senator_2000','population_of_state_2000'],axis=1)\n",
    "df_leg = df_leg.drop(0,axis=0)\n",
    "df_leg['States'] = df_leg['States'].map(lambda x: x.rstrip(' (SAH,*)'))\n",
    "df_leg = df_leg.rename(columns={'States':'State'})\n",
    "\n",
    "population = []\n",
    "for index, row in df_leg.iterrows():\n",
    "    p = float(row['population_of_state_2010'].replace(',',''))\n",
    "    population.append(p)\n",
    "df_leg['population'] = population\n",
    "df_leg = df_leg.drop(['population_of_state_2010'],axis=1)\n",
    "\n",
    "senate_seats = []\n",
    "for index, row in df_leg.iterrows():\n",
    "    p = float(row['number_of_seats_senators'].replace(',',''))\n",
    "    senate_seats.append(p)\n",
    "df_leg['senate_seats'] = senate_seats\n",
    "df_leg = df_leg.drop(['number_of_seats_senators'],axis=1)\n",
    "\n",
    "rep_seats = []\n",
    "for index, row in df_leg.iterrows():\n",
    "    p = float(row['number_of_seats_representatives'].replace(',',''))\n",
    "    rep_seats.append(p)\n",
    "df_leg['rep_seats'] = rep_seats\n",
    "df_leg = df_leg.drop(['number_of_seats_representatives'],axis=1)\n",
    "\n",
    "pop_per_senator = []\n",
    "for index, row in df_leg.iterrows():\n",
    "    p = float(row['population_per_senator_2010'].replace(',',''))\n",
    "    pop_per_senator.append(p)\n",
    "df_leg['pop_per_senator'] = pop_per_senator\n",
    "df_leg = df_leg.drop(['population_per_senator_2010'],axis=1)\n",
    "\n",
    "pop_per_rep = []\n",
    "for index, row in df_leg.iterrows():\n",
    "    p = float(str(row['population_per_representative_2010']).replace(',',''))\n",
    "    pop_per_rep.append(p)\n",
    "df_leg['pop_per_rep'] = pop_per_rep\n",
    "df_leg = df_leg.drop(['population_per_representative_2010'],axis=1)\n",
    "\n",
    "df_leg['total_seats'] = df_leg['rep_seats'] + df_leg['senate_seats']\n",
    "df_leg['pop_per_legislator'] = round(df_leg['population']/df_leg['total_seats'],0)\n",
    "df_leg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>State</th>\n",
       "      <th>leg_dem</th>\n",
       "      <th>leg_rep</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>0.257143</td>\n",
       "      <td>0.735714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>0.366667</td>\n",
       "      <td>0.583333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>0.466667</td>\n",
       "      <td>0.533333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>0.244444</td>\n",
       "      <td>0.748148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>California</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Colorado</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>0.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Connecticut</td>\n",
       "      <td>0.604278</td>\n",
       "      <td>0.395722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Delaware</td>\n",
       "      <td>0.612903</td>\n",
       "      <td>0.387097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Florida</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>0.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>0.406780</td>\n",
       "      <td>0.593220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Hawaii</td>\n",
       "      <td>0.921053</td>\n",
       "      <td>0.078947</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Idaho</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Illinois</td>\n",
       "      <td>0.644068</td>\n",
       "      <td>0.355932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Indiana</td>\n",
       "      <td>0.286667</td>\n",
       "      <td>0.706667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>0.426667</td>\n",
       "      <td>0.566667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Kansas</td>\n",
       "      <td>0.315152</td>\n",
       "      <td>0.672727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kentucky</td>\n",
       "      <td>0.347826</td>\n",
       "      <td>0.652174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Louisiana</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.652778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Maine</td>\n",
       "      <td>0.591398</td>\n",
       "      <td>0.376344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>0.696809</td>\n",
       "      <td>0.303191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>0.805000</td>\n",
       "      <td>0.190000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>0.459459</td>\n",
       "      <td>0.540541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Minnesota</td>\n",
       "      <td>0.532338</td>\n",
       "      <td>0.467662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Mississippi</td>\n",
       "      <td>0.356322</td>\n",
       "      <td>0.637931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Missouri</td>\n",
       "      <td>0.294416</td>\n",
       "      <td>0.700508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Montana</td>\n",
       "      <td>0.413333</td>\n",
       "      <td>0.586667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Nebraska</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Nevada</td>\n",
       "      <td>0.650794</td>\n",
       "      <td>0.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>New Hampshire</td>\n",
       "      <td>0.582547</td>\n",
       "      <td>0.412736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>New Jersey</td>\n",
       "      <td>0.625000</td>\n",
       "      <td>0.375000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>New Mexico</td>\n",
       "      <td>0.642857</td>\n",
       "      <td>0.357143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>New York</td>\n",
       "      <td>0.685446</td>\n",
       "      <td>0.309859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>North Carolina</td>\n",
       "      <td>0.447059</td>\n",
       "      <td>0.547059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>North Dakota</td>\n",
       "      <td>0.177305</td>\n",
       "      <td>0.822695</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Ohio</td>\n",
       "      <td>0.356061</td>\n",
       "      <td>0.636364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>0.221477</td>\n",
       "      <td>0.778523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Oregon</td>\n",
       "      <td>0.622222</td>\n",
       "      <td>0.366667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>0.450593</td>\n",
       "      <td>0.545455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>0.876106</td>\n",
       "      <td>0.123894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>South Carolina</td>\n",
       "      <td>0.370588</td>\n",
       "      <td>0.629412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>0.152381</td>\n",
       "      <td>0.847619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Tennessee</td>\n",
       "      <td>0.234848</td>\n",
       "      <td>0.757576</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Texas</td>\n",
       "      <td>0.441989</td>\n",
       "      <td>0.558011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Utah</td>\n",
       "      <td>0.211538</td>\n",
       "      <td>0.788462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Vermont</td>\n",
       "      <td>0.650000</td>\n",
       "      <td>0.272222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>0.542857</td>\n",
       "      <td>0.457143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Washington</td>\n",
       "      <td>0.585034</td>\n",
       "      <td>0.414966</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>0.410448</td>\n",
       "      <td>0.589552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>0.378788</td>\n",
       "      <td>0.621212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Wyoming</td>\n",
       "      <td>0.133333</td>\n",
       "      <td>0.855556</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             State   leg_dem   leg_rep\n",
       "0          Alabama  0.257143  0.735714\n",
       "1           Alaska  0.366667  0.583333\n",
       "2          Arizona  0.466667  0.533333\n",
       "3         Arkansas  0.244444  0.748148\n",
       "4       California  0.750000  0.250000\n",
       "5         Colorado  0.600000  0.400000\n",
       "6      Connecticut  0.604278  0.395722\n",
       "7         Delaware  0.612903  0.387097\n",
       "8          Florida  0.400000  0.600000\n",
       "9          Georgia  0.406780  0.593220\n",
       "10          Hawaii  0.921053  0.078947\n",
       "11           Idaho  0.200000  0.800000\n",
       "12        Illinois  0.644068  0.355932\n",
       "13         Indiana  0.286667  0.706667\n",
       "14            Iowa  0.426667  0.566667\n",
       "15          Kansas  0.315152  0.672727\n",
       "16        Kentucky  0.347826  0.652174\n",
       "17       Louisiana  0.333333  0.652778\n",
       "18           Maine  0.591398  0.376344\n",
       "19        Maryland  0.696809  0.303191\n",
       "20   Massachusetts  0.805000  0.190000\n",
       "21        Michigan  0.459459  0.540541\n",
       "22       Minnesota  0.532338  0.467662\n",
       "23     Mississippi  0.356322  0.637931\n",
       "24        Missouri  0.294416  0.700508\n",
       "25         Montana  0.413333  0.586667\n",
       "26        Nebraska  0.000000  0.000000\n",
       "27          Nevada  0.650794  0.333333\n",
       "28   New Hampshire  0.582547  0.412736\n",
       "29      New Jersey  0.625000  0.375000\n",
       "30      New Mexico  0.642857  0.357143\n",
       "31        New York  0.685446  0.309859\n",
       "32  North Carolina  0.447059  0.547059\n",
       "33    North Dakota  0.177305  0.822695\n",
       "34            Ohio  0.356061  0.636364\n",
       "35        Oklahoma  0.221477  0.778523\n",
       "36          Oregon  0.622222  0.366667\n",
       "37    Pennsylvania  0.450593  0.545455\n",
       "38    Rhode Island  0.876106  0.123894\n",
       "39  South Carolina  0.370588  0.629412\n",
       "40    South Dakota  0.152381  0.847619\n",
       "41       Tennessee  0.234848  0.757576\n",
       "42           Texas  0.441989  0.558011\n",
       "43            Utah  0.211538  0.788462\n",
       "44         Vermont  0.650000  0.272222\n",
       "45        Virginia  0.542857  0.457143\n",
       "46      Washington  0.585034  0.414966\n",
       "47   West Virginia  0.410448  0.589552\n",
       "48       Wisconsin  0.378788  0.621212\n",
       "49         Wyoming  0.133333  0.855556"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_legparty = pd.read_csv('data\\state_legislature_breakdown_2019.csv')\n",
    "dff_legparty = df_legparty[['STATE','dem_percent','rep_percent']]\n",
    "dff_legparty = dff_legparty.rename(columns={'STATE':'State','dem_percent':'leg_dem','rep_percent':'leg_rep'})\n",
    "dff_legparty"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>State</th>\n",
       "      <th>pres_dem</th>\n",
       "      <th>pres_rep</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>34.36</td>\n",
       "      <td>62.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>36.55</td>\n",
       "      <td>51.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>45.13</td>\n",
       "      <td>48.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>33.65</td>\n",
       "      <td>60.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>California</td>\n",
       "      <td>61.73</td>\n",
       "      <td>31.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Colorado</td>\n",
       "      <td>48.16</td>\n",
       "      <td>43.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Connecticut</td>\n",
       "      <td>54.57</td>\n",
       "      <td>40.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Delaware</td>\n",
       "      <td>53.09</td>\n",
       "      <td>41.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Washington DC</td>\n",
       "      <td>90.48</td>\n",
       "      <td>4.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Florida</td>\n",
       "      <td>47.82</td>\n",
       "      <td>49.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>45.64</td>\n",
       "      <td>50.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Hawaii</td>\n",
       "      <td>62.22</td>\n",
       "      <td>30.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Idaho</td>\n",
       "      <td>27.49</td>\n",
       "      <td>59.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Illinois</td>\n",
       "      <td>55.83</td>\n",
       "      <td>38.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Indiana</td>\n",
       "      <td>37.91</td>\n",
       "      <td>56.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>41.74</td>\n",
       "      <td>51.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kansas</td>\n",
       "      <td>36.05</td>\n",
       "      <td>56.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Kentucky</td>\n",
       "      <td>32.68</td>\n",
       "      <td>62.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Louisiana</td>\n",
       "      <td>38.45</td>\n",
       "      <td>58.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Maine</td>\n",
       "      <td>47.83</td>\n",
       "      <td>44.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>60.33</td>\n",
       "      <td>33.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>60.01</td>\n",
       "      <td>32.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>47.27</td>\n",
       "      <td>47.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Minnesota</td>\n",
       "      <td>46.44</td>\n",
       "      <td>44.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Mississippi</td>\n",
       "      <td>40.11</td>\n",
       "      <td>57.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Missouri</td>\n",
       "      <td>38.14</td>\n",
       "      <td>56.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Montana</td>\n",
       "      <td>35.75</td>\n",
       "      <td>56.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Nebraska</td>\n",
       "      <td>33.70</td>\n",
       "      <td>58.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Nevada</td>\n",
       "      <td>47.92</td>\n",
       "      <td>45.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>New Hampshire</td>\n",
       "      <td>46.98</td>\n",
       "      <td>46.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>New Jersey</td>\n",
       "      <td>54.99</td>\n",
       "      <td>41.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>New Mexico</td>\n",
       "      <td>48.26</td>\n",
       "      <td>40.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>New York</td>\n",
       "      <td>59.01</td>\n",
       "      <td>36.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>North Carolina</td>\n",
       "      <td>46.17</td>\n",
       "      <td>49.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>North Dakota</td>\n",
       "      <td>27.23</td>\n",
       "      <td>62.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Ohio</td>\n",
       "      <td>43.56</td>\n",
       "      <td>51.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>28.93</td>\n",
       "      <td>65.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Oregon</td>\n",
       "      <td>50.07</td>\n",
       "      <td>39.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>47.46</td>\n",
       "      <td>48.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>54.41</td>\n",
       "      <td>38.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>South Carolina</td>\n",
       "      <td>40.67</td>\n",
       "      <td>54.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>31.74</td>\n",
       "      <td>61.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Tennessee</td>\n",
       "      <td>34.72</td>\n",
       "      <td>60.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Texas</td>\n",
       "      <td>43.24</td>\n",
       "      <td>52.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Utah</td>\n",
       "      <td>27.46</td>\n",
       "      <td>45.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Vermont</td>\n",
       "      <td>56.68</td>\n",
       "      <td>30.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>49.73</td>\n",
       "      <td>44.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Washington</td>\n",
       "      <td>52.54</td>\n",
       "      <td>36.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>26.43</td>\n",
       "      <td>68.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>46.45</td>\n",
       "      <td>47.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Wyoming</td>\n",
       "      <td>21.63</td>\n",
       "      <td>67.40</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             State  pres_dem  pres_rep\n",
       "0          Alabama     34.36     62.08\n",
       "1           Alaska     36.55     51.28\n",
       "2          Arizona     45.13     48.67\n",
       "3         Arkansas     33.65     60.57\n",
       "4       California     61.73     31.62\n",
       "5         Colorado     48.16     43.25\n",
       "6      Connecticut     54.57     40.93\n",
       "7         Delaware     53.09     41.72\n",
       "8    Washington DC     90.48      4.07\n",
       "9          Florida     47.82     49.02\n",
       "10         Georgia     45.64     50.77\n",
       "11          Hawaii     62.22     30.03\n",
       "12           Idaho     27.49     59.26\n",
       "13        Illinois     55.83     38.76\n",
       "14         Indiana     37.91     56.82\n",
       "15            Iowa     41.74     51.15\n",
       "16          Kansas     36.05     56.65\n",
       "17        Kentucky     32.68     62.52\n",
       "18       Louisiana     38.45     58.09\n",
       "19           Maine     47.83     44.87\n",
       "20        Maryland     60.33     33.91\n",
       "21   Massachusetts     60.01     32.81\n",
       "22        Michigan     47.27     47.50\n",
       "23       Minnesota     46.44     44.92\n",
       "24     Mississippi     40.11     57.94\n",
       "25        Missouri     38.14     56.77\n",
       "26         Montana     35.75     56.17\n",
       "27        Nebraska     33.70     58.75\n",
       "28          Nevada     47.92     45.50\n",
       "29   New Hampshire     46.98     46.61\n",
       "30      New Jersey     54.99     41.00\n",
       "31      New Mexico     48.26     40.04\n",
       "32        New York     59.01     36.52\n",
       "33  North Carolina     46.17     49.83\n",
       "34    North Dakota     27.23     62.96\n",
       "35            Ohio     43.56     51.69\n",
       "36        Oklahoma     28.93     65.32\n",
       "37          Oregon     50.07     39.09\n",
       "38    Pennsylvania     47.46     48.18\n",
       "39    Rhode Island     54.41     38.90\n",
       "40  South Carolina     40.67     54.94\n",
       "41    South Dakota     31.74     61.53\n",
       "42       Tennessee     34.72     60.72\n",
       "43           Texas     43.24     52.23\n",
       "44            Utah     27.46     45.54\n",
       "45         Vermont     56.68     30.27\n",
       "46        Virginia     49.73     44.41\n",
       "47      Washington     52.54     36.83\n",
       "48   West Virginia     26.43     68.50\n",
       "49       Wisconsin     46.45     47.22\n",
       "50         Wyoming     21.63     67.40"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_pres = pd.read_csv('data\\state_by_state_2016_presidential.csv')\n",
    "dff_pres = df_pres[['State','votePctDem','votePctRep']]\n",
    "dff_pres = dff_pres.rename(columns={'votePctDem':'pres_dem','votePctRep':'pres_rep'})\n",
    "dff_pres"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>State</th>\n",
       "      <th>pres_dem</th>\n",
       "      <th>pres_rep</th>\n",
       "      <th>leg_dem</th>\n",
       "      <th>leg_rep</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>34.36</td>\n",
       "      <td>62.08</td>\n",
       "      <td>0.257143</td>\n",
       "      <td>0.735714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>36.55</td>\n",
       "      <td>51.28</td>\n",
       "      <td>0.366667</td>\n",
       "      <td>0.583333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>45.13</td>\n",
       "      <td>48.67</td>\n",
       "      <td>0.466667</td>\n",
       "      <td>0.533333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>33.65</td>\n",
       "      <td>60.57</td>\n",
       "      <td>0.244444</td>\n",
       "      <td>0.748148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>California</td>\n",
       "      <td>61.73</td>\n",
       "      <td>31.62</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Colorado</td>\n",
       "      <td>48.16</td>\n",
       "      <td>43.25</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>0.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Connecticut</td>\n",
       "      <td>54.57</td>\n",
       "      <td>40.93</td>\n",
       "      <td>0.604278</td>\n",
       "      <td>0.395722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Delaware</td>\n",
       "      <td>53.09</td>\n",
       "      <td>41.72</td>\n",
       "      <td>0.612903</td>\n",
       "      <td>0.387097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Florida</td>\n",
       "      <td>47.82</td>\n",
       "      <td>49.02</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>0.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>45.64</td>\n",
       "      <td>50.77</td>\n",
       "      <td>0.406780</td>\n",
       "      <td>0.593220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Hawaii</td>\n",
       "      <td>62.22</td>\n",
       "      <td>30.03</td>\n",
       "      <td>0.921053</td>\n",
       "      <td>0.078947</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Idaho</td>\n",
       "      <td>27.49</td>\n",
       "      <td>59.26</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Illinois</td>\n",
       "      <td>55.83</td>\n",
       "      <td>38.76</td>\n",
       "      <td>0.644068</td>\n",
       "      <td>0.355932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Indiana</td>\n",
       "      <td>37.91</td>\n",
       "      <td>56.82</td>\n",
       "      <td>0.286667</td>\n",
       "      <td>0.706667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>41.74</td>\n",
       "      <td>51.15</td>\n",
       "      <td>0.426667</td>\n",
       "      <td>0.566667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Kansas</td>\n",
       "      <td>36.05</td>\n",
       "      <td>56.65</td>\n",
       "      <td>0.315152</td>\n",
       "      <td>0.672727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kentucky</td>\n",
       "      <td>32.68</td>\n",
       "      <td>62.52</td>\n",
       "      <td>0.347826</td>\n",
       "      <td>0.652174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Louisiana</td>\n",
       "      <td>38.45</td>\n",
       "      <td>58.09</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.652778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Maine</td>\n",
       "      <td>47.83</td>\n",
       "      <td>44.87</td>\n",
       "      <td>0.591398</td>\n",
       "      <td>0.376344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>60.33</td>\n",
       "      <td>33.91</td>\n",
       "      <td>0.696809</td>\n",
       "      <td>0.303191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>60.01</td>\n",
       "      <td>32.81</td>\n",
       "      <td>0.805000</td>\n",
       "      <td>0.190000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>47.27</td>\n",
       "      <td>47.50</td>\n",
       "      <td>0.459459</td>\n",
       "      <td>0.540541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Minnesota</td>\n",
       "      <td>46.44</td>\n",
       "      <td>44.92</td>\n",
       "      <td>0.532338</td>\n",
       "      <td>0.467662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Mississippi</td>\n",
       "      <td>40.11</td>\n",
       "      <td>57.94</td>\n",
       "      <td>0.356322</td>\n",
       "      <td>0.637931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Missouri</td>\n",
       "      <td>38.14</td>\n",
       "      <td>56.77</td>\n",
       "      <td>0.294416</td>\n",
       "      <td>0.700508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Montana</td>\n",
       "      <td>35.75</td>\n",
       "      <td>56.17</td>\n",
       "      <td>0.413333</td>\n",
       "      <td>0.586667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Nebraska</td>\n",
       "      <td>33.70</td>\n",
       "      <td>58.75</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Nevada</td>\n",
       "      <td>47.92</td>\n",
       "      <td>45.50</td>\n",
       "      <td>0.650794</td>\n",
       "      <td>0.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>New Hampshire</td>\n",
       "      <td>46.98</td>\n",
       "      <td>46.61</td>\n",
       "      <td>0.582547</td>\n",
       "      <td>0.412736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>New Jersey</td>\n",
       "      <td>54.99</td>\n",
       "      <td>41.00</td>\n",
       "      <td>0.625000</td>\n",
       "      <td>0.375000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>New Mexico</td>\n",
       "      <td>48.26</td>\n",
       "      <td>40.04</td>\n",
       "      <td>0.642857</td>\n",
       "      <td>0.357143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>New York</td>\n",
       "      <td>59.01</td>\n",
       "      <td>36.52</td>\n",
       "      <td>0.685446</td>\n",
       "      <td>0.309859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>North Carolina</td>\n",
       "      <td>46.17</td>\n",
       "      <td>49.83</td>\n",
       "      <td>0.447059</td>\n",
       "      <td>0.547059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>North Dakota</td>\n",
       "      <td>27.23</td>\n",
       "      <td>62.96</td>\n",
       "      <td>0.177305</td>\n",
       "      <td>0.822695</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Ohio</td>\n",
       "      <td>43.56</td>\n",
       "      <td>51.69</td>\n",
       "      <td>0.356061</td>\n",
       "      <td>0.636364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>28.93</td>\n",
       "      <td>65.32</td>\n",
       "      <td>0.221477</td>\n",
       "      <td>0.778523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Oregon</td>\n",
       "      <td>50.07</td>\n",
       "      <td>39.09</td>\n",
       "      <td>0.622222</td>\n",
       "      <td>0.366667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>47.46</td>\n",
       "      <td>48.18</td>\n",
       "      <td>0.450593</td>\n",
       "      <td>0.545455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>54.41</td>\n",
       "      <td>38.90</td>\n",
       "      <td>0.876106</td>\n",
       "      <td>0.123894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>South Carolina</td>\n",
       "      <td>40.67</td>\n",
       "      <td>54.94</td>\n",
       "      <td>0.370588</td>\n",
       "      <td>0.629412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>31.74</td>\n",
       "      <td>61.53</td>\n",
       "      <td>0.152381</td>\n",
       "      <td>0.847619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Tennessee</td>\n",
       "      <td>34.72</td>\n",
       "      <td>60.72</td>\n",
       "      <td>0.234848</td>\n",
       "      <td>0.757576</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Texas</td>\n",
       "      <td>43.24</td>\n",
       "      <td>52.23</td>\n",
       "      <td>0.441989</td>\n",
       "      <td>0.558011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Utah</td>\n",
       "      <td>27.46</td>\n",
       "      <td>45.54</td>\n",
       "      <td>0.211538</td>\n",
       "      <td>0.788462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Vermont</td>\n",
       "      <td>56.68</td>\n",
       "      <td>30.27</td>\n",
       "      <td>0.650000</td>\n",
       "      <td>0.272222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>49.73</td>\n",
       "      <td>44.41</td>\n",
       "      <td>0.542857</td>\n",
       "      <td>0.457143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Washington</td>\n",
       "      <td>52.54</td>\n",
       "      <td>36.83</td>\n",
       "      <td>0.585034</td>\n",
       "      <td>0.414966</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>26.43</td>\n",
       "      <td>68.50</td>\n",
       "      <td>0.410448</td>\n",
       "      <td>0.589552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>46.45</td>\n",
       "      <td>47.22</td>\n",
       "      <td>0.378788</td>\n",
       "      <td>0.621212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Wyoming</td>\n",
       "      <td>21.63</td>\n",
       "      <td>67.40</td>\n",
       "      <td>0.133333</td>\n",
       "      <td>0.855556</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             State  pres_dem  pres_rep   leg_dem   leg_rep\n",
       "0          Alabama     34.36     62.08  0.257143  0.735714\n",
       "1           Alaska     36.55     51.28  0.366667  0.583333\n",
       "2          Arizona     45.13     48.67  0.466667  0.533333\n",
       "3         Arkansas     33.65     60.57  0.244444  0.748148\n",
       "4       California     61.73     31.62  0.750000  0.250000\n",
       "5         Colorado     48.16     43.25  0.600000  0.400000\n",
       "6      Connecticut     54.57     40.93  0.604278  0.395722\n",
       "7         Delaware     53.09     41.72  0.612903  0.387097\n",
       "8          Florida     47.82     49.02  0.400000  0.600000\n",
       "9          Georgia     45.64     50.77  0.406780  0.593220\n",
       "10          Hawaii     62.22     30.03  0.921053  0.078947\n",
       "11           Idaho     27.49     59.26  0.200000  0.800000\n",
       "12        Illinois     55.83     38.76  0.644068  0.355932\n",
       "13         Indiana     37.91     56.82  0.286667  0.706667\n",
       "14            Iowa     41.74     51.15  0.426667  0.566667\n",
       "15          Kansas     36.05     56.65  0.315152  0.672727\n",
       "16        Kentucky     32.68     62.52  0.347826  0.652174\n",
       "17       Louisiana     38.45     58.09  0.333333  0.652778\n",
       "18           Maine     47.83     44.87  0.591398  0.376344\n",
       "19        Maryland     60.33     33.91  0.696809  0.303191\n",
       "20   Massachusetts     60.01     32.81  0.805000  0.190000\n",
       "21        Michigan     47.27     47.50  0.459459  0.540541\n",
       "22       Minnesota     46.44     44.92  0.532338  0.467662\n",
       "23     Mississippi     40.11     57.94  0.356322  0.637931\n",
       "24        Missouri     38.14     56.77  0.294416  0.700508\n",
       "25         Montana     35.75     56.17  0.413333  0.586667\n",
       "26        Nebraska     33.70     58.75  0.000000  0.000000\n",
       "27          Nevada     47.92     45.50  0.650794  0.333333\n",
       "28   New Hampshire     46.98     46.61  0.582547  0.412736\n",
       "29      New Jersey     54.99     41.00  0.625000  0.375000\n",
       "30      New Mexico     48.26     40.04  0.642857  0.357143\n",
       "31        New York     59.01     36.52  0.685446  0.309859\n",
       "32  North Carolina     46.17     49.83  0.447059  0.547059\n",
       "33    North Dakota     27.23     62.96  0.177305  0.822695\n",
       "34            Ohio     43.56     51.69  0.356061  0.636364\n",
       "35        Oklahoma     28.93     65.32  0.221477  0.778523\n",
       "36          Oregon     50.07     39.09  0.622222  0.366667\n",
       "37    Pennsylvania     47.46     48.18  0.450593  0.545455\n",
       "38    Rhode Island     54.41     38.90  0.876106  0.123894\n",
       "39  South Carolina     40.67     54.94  0.370588  0.629412\n",
       "40    South Dakota     31.74     61.53  0.152381  0.847619\n",
       "41       Tennessee     34.72     60.72  0.234848  0.757576\n",
       "42           Texas     43.24     52.23  0.441989  0.558011\n",
       "43            Utah     27.46     45.54  0.211538  0.788462\n",
       "44         Vermont     56.68     30.27  0.650000  0.272222\n",
       "45        Virginia     49.73     44.41  0.542857  0.457143\n",
       "46      Washington     52.54     36.83  0.585034  0.414966\n",
       "47   West Virginia     26.43     68.50  0.410448  0.589552\n",
       "48       Wisconsin     46.45     47.22  0.378788  0.621212\n",
       "49         Wyoming     21.63     67.40  0.133333  0.855556"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_comp = dff_pres.merge(dff_legparty,on='State')\n",
    "df_comp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>State</th>\n",
       "      <th>population</th>\n",
       "      <th>senate_seats</th>\n",
       "      <th>rep_seats</th>\n",
       "      <th>pop_per_senator</th>\n",
       "      <th>pop_per_rep</th>\n",
       "      <th>total_seats</th>\n",
       "      <th>pop_per_legislator</th>\n",
       "      <th>pres_dem</th>\n",
       "      <th>pres_rep</th>\n",
       "      <th>leg_dem</th>\n",
       "      <th>leg_rep</th>\n",
       "      <th>total_diff</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>California</td>\n",
       "      <td>37253956.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>931349.0</td>\n",
       "      <td>465674.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>310450.0</td>\n",
       "      <td>61.73</td>\n",
       "      <td>31.62</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>0.165800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Texas</td>\n",
       "      <td>25145561.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>811147.0</td>\n",
       "      <td>167637.0</td>\n",
       "      <td>181.0</td>\n",
       "      <td>138926.0</td>\n",
       "      <td>43.24</td>\n",
       "      <td>52.23</td>\n",
       "      <td>0.441989</td>\n",
       "      <td>0.558011</td>\n",
       "      <td>0.027444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>New York</td>\n",
       "      <td>19378102.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>307589.0</td>\n",
       "      <td>129187.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>90977.0</td>\n",
       "      <td>59.01</td>\n",
       "      <td>36.52</td>\n",
       "      <td>0.685446</td>\n",
       "      <td>0.309859</td>\n",
       "      <td>0.123016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Florida</td>\n",
       "      <td>18801310.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>470033.0</td>\n",
       "      <td>156678.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>117508.0</td>\n",
       "      <td>47.82</td>\n",
       "      <td>49.02</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>0.133100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Illinois</td>\n",
       "      <td>12830632.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>217468.0</td>\n",
       "      <td>108734.0</td>\n",
       "      <td>177.0</td>\n",
       "      <td>72489.0</td>\n",
       "      <td>55.83</td>\n",
       "      <td>38.76</td>\n",
       "      <td>0.644068</td>\n",
       "      <td>0.355932</td>\n",
       "      <td>0.101602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>12702379.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>203.0</td>\n",
       "      <td>254048.0</td>\n",
       "      <td>62573.0</td>\n",
       "      <td>253.0</td>\n",
       "      <td>50207.0</td>\n",
       "      <td>47.46</td>\n",
       "      <td>48.18</td>\n",
       "      <td>0.450593</td>\n",
       "      <td>0.545455</td>\n",
       "      <td>0.055834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ohio</td>\n",
       "      <td>11536504.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>349591.0</td>\n",
       "      <td>116530.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>87398.0</td>\n",
       "      <td>43.56</td>\n",
       "      <td>51.69</td>\n",
       "      <td>0.356061</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>0.139271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>9883640.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>260096.0</td>\n",
       "      <td>89851.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>66781.0</td>\n",
       "      <td>47.27</td>\n",
       "      <td>47.50</td>\n",
       "      <td>0.459459</td>\n",
       "      <td>0.540541</td>\n",
       "      <td>0.046011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>9687653.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>172994.0</td>\n",
       "      <td>53820.0</td>\n",
       "      <td>236.0</td>\n",
       "      <td>41049.0</td>\n",
       "      <td>45.64</td>\n",
       "      <td>50.77</td>\n",
       "      <td>0.406780</td>\n",
       "      <td>0.593220</td>\n",
       "      <td>0.092381</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>North Carolina</td>\n",
       "      <td>9535483.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>190710.0</td>\n",
       "      <td>79462.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>56091.0</td>\n",
       "      <td>46.17</td>\n",
       "      <td>49.83</td>\n",
       "      <td>0.447059</td>\n",
       "      <td>0.547059</td>\n",
       "      <td>0.039021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>New Jersey</td>\n",
       "      <td>8791894.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>219797.0</td>\n",
       "      <td>109899.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>73266.0</td>\n",
       "      <td>54.99</td>\n",
       "      <td>41.00</td>\n",
       "      <td>0.625000</td>\n",
       "      <td>0.375000</td>\n",
       "      <td>0.092600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>8001024.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>200026.0</td>\n",
       "      <td>80010.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>57150.0</td>\n",
       "      <td>49.73</td>\n",
       "      <td>44.41</td>\n",
       "      <td>0.542857</td>\n",
       "      <td>0.457143</td>\n",
       "      <td>0.052079</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Washington</td>\n",
       "      <td>6724540.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>137236.0</td>\n",
       "      <td>68618.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>45745.0</td>\n",
       "      <td>52.54</td>\n",
       "      <td>36.83</td>\n",
       "      <td>0.585034</td>\n",
       "      <td>0.414966</td>\n",
       "      <td>0.082967</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>6547629.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>163691.0</td>\n",
       "      <td>40923.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>32738.0</td>\n",
       "      <td>60.01</td>\n",
       "      <td>32.81</td>\n",
       "      <td>0.805000</td>\n",
       "      <td>0.190000</td>\n",
       "      <td>0.273950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Indiana</td>\n",
       "      <td>6483802.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>129676.0</td>\n",
       "      <td>64838.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>43225.0</td>\n",
       "      <td>37.91</td>\n",
       "      <td>56.82</td>\n",
       "      <td>0.286667</td>\n",
       "      <td>0.706667</td>\n",
       "      <td>0.161667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>6392017.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>213067.0</td>\n",
       "      <td>106534.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>71022.0</td>\n",
       "      <td>45.13</td>\n",
       "      <td>48.67</td>\n",
       "      <td>0.466667</td>\n",
       "      <td>0.533333</td>\n",
       "      <td>0.038683</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Tennessee</td>\n",
       "      <td>6346105.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>192306.0</td>\n",
       "      <td>64102.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>48077.0</td>\n",
       "      <td>34.72</td>\n",
       "      <td>60.72</td>\n",
       "      <td>0.234848</td>\n",
       "      <td>0.757576</td>\n",
       "      <td>0.187539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Missouri</td>\n",
       "      <td>5988927.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>176145.0</td>\n",
       "      <td>36742.0</td>\n",
       "      <td>197.0</td>\n",
       "      <td>30401.0</td>\n",
       "      <td>38.14</td>\n",
       "      <td>56.77</td>\n",
       "      <td>0.294416</td>\n",
       "      <td>0.700508</td>\n",
       "      <td>0.153388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>5773552.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>122842.0</td>\n",
       "      <td>40947.0</td>\n",
       "      <td>188.0</td>\n",
       "      <td>30710.0</td>\n",
       "      <td>60.33</td>\n",
       "      <td>33.91</td>\n",
       "      <td>0.696809</td>\n",
       "      <td>0.303191</td>\n",
       "      <td>0.111463</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>5686986.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>172333.0</td>\n",
       "      <td>57444.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>43083.0</td>\n",
       "      <td>46.45</td>\n",
       "      <td>47.22</td>\n",
       "      <td>0.378788</td>\n",
       "      <td>0.621212</td>\n",
       "      <td>0.160218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Minnesota</td>\n",
       "      <td>5303925.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>79163.0</td>\n",
       "      <td>39582.0</td>\n",
       "      <td>201.0</td>\n",
       "      <td>26388.0</td>\n",
       "      <td>46.44</td>\n",
       "      <td>44.92</td>\n",
       "      <td>0.532338</td>\n",
       "      <td>0.467662</td>\n",
       "      <td>0.077169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Colorado</td>\n",
       "      <td>5029196.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>143691.0</td>\n",
       "      <td>77372.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50292.0</td>\n",
       "      <td>48.16</td>\n",
       "      <td>43.25</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>0.134650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>4779736.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>136564.0</td>\n",
       "      <td>45521.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>34141.0</td>\n",
       "      <td>34.36</td>\n",
       "      <td>62.08</td>\n",
       "      <td>0.257143</td>\n",
       "      <td>0.735714</td>\n",
       "      <td>0.143914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>South Carolina</td>\n",
       "      <td>4625364.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>100551.0</td>\n",
       "      <td>37301.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>27208.0</td>\n",
       "      <td>40.67</td>\n",
       "      <td>54.94</td>\n",
       "      <td>0.370588</td>\n",
       "      <td>0.629412</td>\n",
       "      <td>0.076118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Louisiana</td>\n",
       "      <td>4533372.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>116240.0</td>\n",
       "      <td>43175.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>31482.0</td>\n",
       "      <td>38.45</td>\n",
       "      <td>58.09</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.652778</td>\n",
       "      <td>0.087106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Kentucky</td>\n",
       "      <td>4339367.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>114194.0</td>\n",
       "      <td>43394.0</td>\n",
       "      <td>138.0</td>\n",
       "      <td>31445.0</td>\n",
       "      <td>32.68</td>\n",
       "      <td>62.52</td>\n",
       "      <td>0.347826</td>\n",
       "      <td>0.652174</td>\n",
       "      <td>0.034513</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Oregon</td>\n",
       "      <td>3831074.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>127702.0</td>\n",
       "      <td>63851.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>42567.0</td>\n",
       "      <td>50.07</td>\n",
       "      <td>39.09</td>\n",
       "      <td>0.622222</td>\n",
       "      <td>0.366667</td>\n",
       "      <td>0.133639</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>3751351.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>78153.0</td>\n",
       "      <td>37142.0</td>\n",
       "      <td>149.0</td>\n",
       "      <td>25177.0</td>\n",
       "      <td>28.93</td>\n",
       "      <td>65.32</td>\n",
       "      <td>0.221477</td>\n",
       "      <td>0.778523</td>\n",
       "      <td>0.130485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Connecticut</td>\n",
       "      <td>3574097.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>99280.0</td>\n",
       "      <td>23670.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>19113.0</td>\n",
       "      <td>54.57</td>\n",
       "      <td>40.93</td>\n",
       "      <td>0.604278</td>\n",
       "      <td>0.395722</td>\n",
       "      <td>0.065367</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>3046355.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60927.0</td>\n",
       "      <td>30464.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>20309.0</td>\n",
       "      <td>41.74</td>\n",
       "      <td>51.15</td>\n",
       "      <td>0.426667</td>\n",
       "      <td>0.566667</td>\n",
       "      <td>0.036850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Mississippi</td>\n",
       "      <td>2967297.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>57063.0</td>\n",
       "      <td>24322.0</td>\n",
       "      <td>174.0</td>\n",
       "      <td>17053.0</td>\n",
       "      <td>40.11</td>\n",
       "      <td>57.94</td>\n",
       "      <td>0.356322</td>\n",
       "      <td>0.637931</td>\n",
       "      <td>0.074044</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>2915918.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>83312.0</td>\n",
       "      <td>29159.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>21599.0</td>\n",
       "      <td>33.65</td>\n",
       "      <td>60.57</td>\n",
       "      <td>0.244444</td>\n",
       "      <td>0.748148</td>\n",
       "      <td>0.163280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Kansas</td>\n",
       "      <td>2853118.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>71328.0</td>\n",
       "      <td>22825.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>17292.0</td>\n",
       "      <td>36.05</td>\n",
       "      <td>56.65</td>\n",
       "      <td>0.315152</td>\n",
       "      <td>0.672727</td>\n",
       "      <td>0.098462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Utah</td>\n",
       "      <td>2763885.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>95306.0</td>\n",
       "      <td>36852.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>26576.0</td>\n",
       "      <td>27.46</td>\n",
       "      <td>45.54</td>\n",
       "      <td>0.211538</td>\n",
       "      <td>0.788462</td>\n",
       "      <td>0.229592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Nevada</td>\n",
       "      <td>2700551.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>128598.0</td>\n",
       "      <td>64299.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>42866.0</td>\n",
       "      <td>47.92</td>\n",
       "      <td>45.50</td>\n",
       "      <td>0.650794</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.232427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>New Mexico</td>\n",
       "      <td>2059179.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>49028.0</td>\n",
       "      <td>29417.0</td>\n",
       "      <td>112.0</td>\n",
       "      <td>18386.0</td>\n",
       "      <td>48.26</td>\n",
       "      <td>40.04</td>\n",
       "      <td>0.642857</td>\n",
       "      <td>0.357143</td>\n",
       "      <td>0.181886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>1852994.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>54500.0</td>\n",
       "      <td>18530.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>13828.0</td>\n",
       "      <td>26.43</td>\n",
       "      <td>68.50</td>\n",
       "      <td>0.410448</td>\n",
       "      <td>0.589552</td>\n",
       "      <td>0.193872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Nebraska</td>\n",
       "      <td>1826341.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37272.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>49.0</td>\n",
       "      <td>37272.0</td>\n",
       "      <td>33.70</td>\n",
       "      <td>58.75</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.630750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Idaho</td>\n",
       "      <td>1567582.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>44788.0</td>\n",
       "      <td>22394.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>14929.0</td>\n",
       "      <td>27.49</td>\n",
       "      <td>59.26</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.178600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Hawaii</td>\n",
       "      <td>1360301.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>54412.0</td>\n",
       "      <td>26673.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>17899.0</td>\n",
       "      <td>62.22</td>\n",
       "      <td>30.03</td>\n",
       "      <td>0.921053</td>\n",
       "      <td>0.078947</td>\n",
       "      <td>0.409529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Maine</td>\n",
       "      <td>1328361.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>37953.0</td>\n",
       "      <td>8797.0</td>\n",
       "      <td>186.0</td>\n",
       "      <td>7142.0</td>\n",
       "      <td>47.83</td>\n",
       "      <td>44.87</td>\n",
       "      <td>0.591398</td>\n",
       "      <td>0.376344</td>\n",
       "      <td>0.149276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>New Hampshire</td>\n",
       "      <td>1316470.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>54853.0</td>\n",
       "      <td>3291.0</td>\n",
       "      <td>424.0</td>\n",
       "      <td>3105.0</td>\n",
       "      <td>46.98</td>\n",
       "      <td>46.61</td>\n",
       "      <td>0.582547</td>\n",
       "      <td>0.412736</td>\n",
       "      <td>0.139429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>1052567.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>27699.0</td>\n",
       "      <td>14034.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>9315.0</td>\n",
       "      <td>54.41</td>\n",
       "      <td>38.90</td>\n",
       "      <td>0.876106</td>\n",
       "      <td>0.123894</td>\n",
       "      <td>0.464559</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Montana</td>\n",
       "      <td>989415.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>19788.0</td>\n",
       "      <td>9894.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>6596.0</td>\n",
       "      <td>35.75</td>\n",
       "      <td>56.17</td>\n",
       "      <td>0.413333</td>\n",
       "      <td>0.586667</td>\n",
       "      <td>0.068317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Delaware</td>\n",
       "      <td>897934.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>42759.0</td>\n",
       "      <td>21901.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>14483.0</td>\n",
       "      <td>53.09</td>\n",
       "      <td>41.72</td>\n",
       "      <td>0.612903</td>\n",
       "      <td>0.387097</td>\n",
       "      <td>0.097055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>814180.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>23262.0</td>\n",
       "      <td>11631.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>7754.0</td>\n",
       "      <td>31.74</td>\n",
       "      <td>61.53</td>\n",
       "      <td>0.152381</td>\n",
       "      <td>0.847619</td>\n",
       "      <td>0.281179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>710231.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>35512.0</td>\n",
       "      <td>17756.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>11837.0</td>\n",
       "      <td>36.55</td>\n",
       "      <td>51.28</td>\n",
       "      <td>0.366667</td>\n",
       "      <td>0.583333</td>\n",
       "      <td>0.036433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>North Dakota</td>\n",
       "      <td>672591.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>14310.0</td>\n",
       "      <td>7155.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>4770.0</td>\n",
       "      <td>27.23</td>\n",
       "      <td>62.96</td>\n",
       "      <td>0.177305</td>\n",
       "      <td>0.822695</td>\n",
       "      <td>0.191543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Vermont</td>\n",
       "      <td>625741.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>20858.0</td>\n",
       "      <td>4172.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>3476.0</td>\n",
       "      <td>56.68</td>\n",
       "      <td>30.27</td>\n",
       "      <td>0.650000</td>\n",
       "      <td>0.272222</td>\n",
       "      <td>0.098439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Wyoming</td>\n",
       "      <td>563626.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>18788.0</td>\n",
       "      <td>9394.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>6263.0</td>\n",
       "      <td>21.63</td>\n",
       "      <td>67.40</td>\n",
       "      <td>0.133333</td>\n",
       "      <td>0.855556</td>\n",
       "      <td>0.173744</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             State  population  senate_seats  rep_seats  pop_per_senator  \\\n",
       "0       California  37253956.0          40.0       80.0         931349.0   \n",
       "1            Texas  25145561.0          31.0      150.0         811147.0   \n",
       "2         New York  19378102.0          63.0      150.0         307589.0   \n",
       "3          Florida  18801310.0          40.0      120.0         470033.0   \n",
       "4         Illinois  12830632.0          59.0      118.0         217468.0   \n",
       "5     Pennsylvania  12702379.0          50.0      203.0         254048.0   \n",
       "6             Ohio  11536504.0          33.0       99.0         349591.0   \n",
       "7         Michigan   9883640.0          38.0      110.0         260096.0   \n",
       "8          Georgia   9687653.0          56.0      180.0         172994.0   \n",
       "9   North Carolina   9535483.0          50.0      120.0         190710.0   \n",
       "10      New Jersey   8791894.0          40.0       80.0         219797.0   \n",
       "11        Virginia   8001024.0          40.0      100.0         200026.0   \n",
       "12      Washington   6724540.0          49.0       98.0         137236.0   \n",
       "13   Massachusetts   6547629.0          40.0      160.0         163691.0   \n",
       "14         Indiana   6483802.0          50.0      100.0         129676.0   \n",
       "15         Arizona   6392017.0          30.0       60.0         213067.0   \n",
       "16       Tennessee   6346105.0          33.0       99.0         192306.0   \n",
       "17        Missouri   5988927.0          34.0      163.0         176145.0   \n",
       "18        Maryland   5773552.0          47.0      141.0         122842.0   \n",
       "19       Wisconsin   5686986.0          33.0       99.0         172333.0   \n",
       "20       Minnesota   5303925.0          67.0      134.0          79163.0   \n",
       "21        Colorado   5029196.0          35.0       65.0         143691.0   \n",
       "22         Alabama   4779736.0          35.0      105.0         136564.0   \n",
       "23  South Carolina   4625364.0          46.0      124.0         100551.0   \n",
       "24       Louisiana   4533372.0          39.0      105.0         116240.0   \n",
       "25        Kentucky   4339367.0          38.0      100.0         114194.0   \n",
       "26          Oregon   3831074.0          30.0       60.0         127702.0   \n",
       "27        Oklahoma   3751351.0          48.0      101.0          78153.0   \n",
       "28     Connecticut   3574097.0          36.0      151.0          99280.0   \n",
       "29            Iowa   3046355.0          50.0      100.0          60927.0   \n",
       "30     Mississippi   2967297.0          52.0      122.0          57063.0   \n",
       "31        Arkansas   2915918.0          35.0      100.0          83312.0   \n",
       "32          Kansas   2853118.0          40.0      125.0          71328.0   \n",
       "33            Utah   2763885.0          29.0       75.0          95306.0   \n",
       "34          Nevada   2700551.0          21.0       42.0         128598.0   \n",
       "35      New Mexico   2059179.0          42.0       70.0          49028.0   \n",
       "36   West Virginia   1852994.0          34.0      100.0          54500.0   \n",
       "37        Nebraska   1826341.0          49.0        0.0          37272.0   \n",
       "38           Idaho   1567582.0          35.0       70.0          44788.0   \n",
       "39          Hawaii   1360301.0          25.0       51.0          54412.0   \n",
       "40           Maine   1328361.0          35.0      151.0          37953.0   \n",
       "41   New Hampshire   1316470.0          24.0      400.0          54853.0   \n",
       "42    Rhode Island   1052567.0          38.0       75.0          27699.0   \n",
       "43         Montana    989415.0          50.0      100.0          19788.0   \n",
       "44        Delaware    897934.0          21.0       41.0          42759.0   \n",
       "45    South Dakota    814180.0          35.0       70.0          23262.0   \n",
       "46          Alaska    710231.0          20.0       40.0          35512.0   \n",
       "47    North Dakota    672591.0          47.0       94.0          14310.0   \n",
       "48         Vermont    625741.0          30.0      150.0          20858.0   \n",
       "49         Wyoming    563626.0          30.0       60.0          18788.0   \n",
       "\n",
       "    pop_per_rep  total_seats  pop_per_legislator  pres_dem  pres_rep  \\\n",
       "0      465674.0        120.0            310450.0     61.73     31.62   \n",
       "1      167637.0        181.0            138926.0     43.24     52.23   \n",
       "2      129187.0        213.0             90977.0     59.01     36.52   \n",
       "3      156678.0        160.0            117508.0     47.82     49.02   \n",
       "4      108734.0        177.0             72489.0     55.83     38.76   \n",
       "5       62573.0        253.0             50207.0     47.46     48.18   \n",
       "6      116530.0        132.0             87398.0     43.56     51.69   \n",
       "7       89851.0        148.0             66781.0     47.27     47.50   \n",
       "8       53820.0        236.0             41049.0     45.64     50.77   \n",
       "9       79462.0        170.0             56091.0     46.17     49.83   \n",
       "10     109899.0        120.0             73266.0     54.99     41.00   \n",
       "11      80010.0        140.0             57150.0     49.73     44.41   \n",
       "12      68618.0        147.0             45745.0     52.54     36.83   \n",
       "13      40923.0        200.0             32738.0     60.01     32.81   \n",
       "14      64838.0        150.0             43225.0     37.91     56.82   \n",
       "15     106534.0         90.0             71022.0     45.13     48.67   \n",
       "16      64102.0        132.0             48077.0     34.72     60.72   \n",
       "17      36742.0        197.0             30401.0     38.14     56.77   \n",
       "18      40947.0        188.0             30710.0     60.33     33.91   \n",
       "19      57444.0        132.0             43083.0     46.45     47.22   \n",
       "20      39582.0        201.0             26388.0     46.44     44.92   \n",
       "21      77372.0        100.0             50292.0     48.16     43.25   \n",
       "22      45521.0        140.0             34141.0     34.36     62.08   \n",
       "23      37301.0        170.0             27208.0     40.67     54.94   \n",
       "24      43175.0        144.0             31482.0     38.45     58.09   \n",
       "25      43394.0        138.0             31445.0     32.68     62.52   \n",
       "26      63851.0         90.0             42567.0     50.07     39.09   \n",
       "27      37142.0        149.0             25177.0     28.93     65.32   \n",
       "28      23670.0        187.0             19113.0     54.57     40.93   \n",
       "29      30464.0        150.0             20309.0     41.74     51.15   \n",
       "30      24322.0        174.0             17053.0     40.11     57.94   \n",
       "31      29159.0        135.0             21599.0     33.65     60.57   \n",
       "32      22825.0        165.0             17292.0     36.05     56.65   \n",
       "33      36852.0        104.0             26576.0     27.46     45.54   \n",
       "34      64299.0         63.0             42866.0     47.92     45.50   \n",
       "35      29417.0        112.0             18386.0     48.26     40.04   \n",
       "36      18530.0        134.0             13828.0     26.43     68.50   \n",
       "37          NaN         49.0             37272.0     33.70     58.75   \n",
       "38      22394.0        105.0             14929.0     27.49     59.26   \n",
       "39      26673.0         76.0             17899.0     62.22     30.03   \n",
       "40       8797.0        186.0              7142.0     47.83     44.87   \n",
       "41       3291.0        424.0              3105.0     46.98     46.61   \n",
       "42      14034.0        113.0              9315.0     54.41     38.90   \n",
       "43       9894.0        150.0              6596.0     35.75     56.17   \n",
       "44      21901.0         62.0             14483.0     53.09     41.72   \n",
       "45      11631.0        105.0              7754.0     31.74     61.53   \n",
       "46      17756.0         60.0             11837.0     36.55     51.28   \n",
       "47       7155.0        141.0              4770.0     27.23     62.96   \n",
       "48       4172.0        180.0              3476.0     56.68     30.27   \n",
       "49       9394.0         90.0              6263.0     21.63     67.40   \n",
       "\n",
       "     leg_dem   leg_rep  total_diff  \n",
       "0   0.750000  0.250000    0.165800  \n",
       "1   0.441989  0.558011    0.027444  \n",
       "2   0.685446  0.309859    0.123016  \n",
       "3   0.400000  0.600000    0.133100  \n",
       "4   0.644068  0.355932    0.101602  \n",
       "5   0.450593  0.545455    0.055834  \n",
       "6   0.356061  0.636364    0.139271  \n",
       "7   0.459459  0.540541    0.046011  \n",
       "8   0.406780  0.593220    0.092381  \n",
       "9   0.447059  0.547059    0.039021  \n",
       "10  0.625000  0.375000    0.092600  \n",
       "11  0.542857  0.457143    0.052079  \n",
       "12  0.585034  0.414966    0.082967  \n",
       "13  0.805000  0.190000    0.273950  \n",
       "14  0.286667  0.706667    0.161667  \n",
       "15  0.466667  0.533333    0.038683  \n",
       "16  0.234848  0.757576    0.187539  \n",
       "17  0.294416  0.700508    0.153388  \n",
       "18  0.696809  0.303191    0.111463  \n",
       "19  0.378788  0.621212    0.160218  \n",
       "20  0.532338  0.467662    0.077169  \n",
       "21  0.600000  0.400000    0.134650  \n",
       "22  0.257143  0.735714    0.143914  \n",
       "23  0.370588  0.629412    0.076118  \n",
       "24  0.333333  0.652778    0.087106  \n",
       "25  0.347826  0.652174    0.034513  \n",
       "26  0.622222  0.366667    0.133639  \n",
       "27  0.221477  0.778523    0.130485  \n",
       "28  0.604278  0.395722    0.065367  \n",
       "29  0.426667  0.566667    0.036850  \n",
       "30  0.356322  0.637931    0.074044  \n",
       "31  0.244444  0.748148    0.163280  \n",
       "32  0.315152  0.672727    0.098462  \n",
       "33  0.211538  0.788462    0.229592  \n",
       "34  0.650794  0.333333    0.232427  \n",
       "35  0.642857  0.357143    0.181886  \n",
       "36  0.410448  0.589552    0.193872  \n",
       "37  0.000000  0.000000    0.630750  \n",
       "38  0.200000  0.800000    0.178600  \n",
       "39  0.921053  0.078947    0.409529  \n",
       "40  0.591398  0.376344    0.149276  \n",
       "41  0.582547  0.412736    0.139429  \n",
       "42  0.876106  0.123894    0.464559  \n",
       "43  0.413333  0.586667    0.068317  \n",
       "44  0.612903  0.387097    0.097055  \n",
       "45  0.152381  0.847619    0.281179  \n",
       "46  0.366667  0.583333    0.036433  \n",
       "47  0.177305  0.822695    0.191543  \n",
       "48  0.650000  0.272222    0.098439  \n",
       "49  0.133333  0.855556    0.173744  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df_leg.merge(df_comp,on='State')\n",
    "df['total_diff'] = (abs((df['pres_dem']/100)-df['leg_dem']) + abs((df['pres_rep']/100)-df['leg_rep'])/2)\n",
    "df"
   ]
  },
  {
   "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>State</th>\n",
       "      <th>population</th>\n",
       "      <th>senate_seats</th>\n",
       "      <th>rep_seats</th>\n",
       "      <th>pop_per_senator</th>\n",
       "      <th>pop_per_rep</th>\n",
       "      <th>total_seats</th>\n",
       "      <th>pop_per_legislator</th>\n",
       "      <th>pres_dem</th>\n",
       "      <th>pres_rep</th>\n",
       "      <th>leg_dem</th>\n",
       "      <th>leg_rep</th>\n",
       "      <th>total_diff</th>\n",
       "      <th>Abbreviation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>California</td>\n",
       "      <td>37253956.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>931349.0</td>\n",
       "      <td>465674.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>310450.0</td>\n",
       "      <td>61.73</td>\n",
       "      <td>31.62</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>0.165800</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Texas</td>\n",
       "      <td>25145561.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>811147.0</td>\n",
       "      <td>167637.0</td>\n",
       "      <td>181.0</td>\n",
       "      <td>138926.0</td>\n",
       "      <td>43.24</td>\n",
       "      <td>52.23</td>\n",
       "      <td>0.441989</td>\n",
       "      <td>0.558011</td>\n",
       "      <td>0.027444</td>\n",
       "      <td>TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>New York</td>\n",
       "      <td>19378102.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>307589.0</td>\n",
       "      <td>129187.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>90977.0</td>\n",
       "      <td>59.01</td>\n",
       "      <td>36.52</td>\n",
       "      <td>0.685446</td>\n",
       "      <td>0.309859</td>\n",
       "      <td>0.123016</td>\n",
       "      <td>NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Florida</td>\n",
       "      <td>18801310.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>470033.0</td>\n",
       "      <td>156678.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>117508.0</td>\n",
       "      <td>47.82</td>\n",
       "      <td>49.02</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>0.133100</td>\n",
       "      <td>FL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Illinois</td>\n",
       "      <td>12830632.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>217468.0</td>\n",
       "      <td>108734.0</td>\n",
       "      <td>177.0</td>\n",
       "      <td>72489.0</td>\n",
       "      <td>55.83</td>\n",
       "      <td>38.76</td>\n",
       "      <td>0.644068</td>\n",
       "      <td>0.355932</td>\n",
       "      <td>0.101602</td>\n",
       "      <td>IL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>12702379.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>203.0</td>\n",
       "      <td>254048.0</td>\n",
       "      <td>62573.0</td>\n",
       "      <td>253.0</td>\n",
       "      <td>50207.0</td>\n",
       "      <td>47.46</td>\n",
       "      <td>48.18</td>\n",
       "      <td>0.450593</td>\n",
       "      <td>0.545455</td>\n",
       "      <td>0.055834</td>\n",
       "      <td>PA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ohio</td>\n",
       "      <td>11536504.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>349591.0</td>\n",
       "      <td>116530.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>87398.0</td>\n",
       "      <td>43.56</td>\n",
       "      <td>51.69</td>\n",
       "      <td>0.356061</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>0.139271</td>\n",
       "      <td>OH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>9883640.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>260096.0</td>\n",
       "      <td>89851.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>66781.0</td>\n",
       "      <td>47.27</td>\n",
       "      <td>47.50</td>\n",
       "      <td>0.459459</td>\n",
       "      <td>0.540541</td>\n",
       "      <td>0.046011</td>\n",
       "      <td>MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>9687653.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>172994.0</td>\n",
       "      <td>53820.0</td>\n",
       "      <td>236.0</td>\n",
       "      <td>41049.0</td>\n",
       "      <td>45.64</td>\n",
       "      <td>50.77</td>\n",
       "      <td>0.406780</td>\n",
       "      <td>0.593220</td>\n",
       "      <td>0.092381</td>\n",
       "      <td>GA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>North Carolina</td>\n",
       "      <td>9535483.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>190710.0</td>\n",
       "      <td>79462.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>56091.0</td>\n",
       "      <td>46.17</td>\n",
       "      <td>49.83</td>\n",
       "      <td>0.447059</td>\n",
       "      <td>0.547059</td>\n",
       "      <td>0.039021</td>\n",
       "      <td>NC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>New Jersey</td>\n",
       "      <td>8791894.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>219797.0</td>\n",
       "      <td>109899.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>73266.0</td>\n",
       "      <td>54.99</td>\n",
       "      <td>41.00</td>\n",
       "      <td>0.625000</td>\n",
       "      <td>0.375000</td>\n",
       "      <td>0.092600</td>\n",
       "      <td>NJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>8001024.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>200026.0</td>\n",
       "      <td>80010.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>57150.0</td>\n",
       "      <td>49.73</td>\n",
       "      <td>44.41</td>\n",
       "      <td>0.542857</td>\n",
       "      <td>0.457143</td>\n",
       "      <td>0.052079</td>\n",
       "      <td>VA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Washington</td>\n",
       "      <td>6724540.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>137236.0</td>\n",
       "      <td>68618.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>45745.0</td>\n",
       "      <td>52.54</td>\n",
       "      <td>36.83</td>\n",
       "      <td>0.585034</td>\n",
       "      <td>0.414966</td>\n",
       "      <td>0.082967</td>\n",
       "      <td>WA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>6547629.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>163691.0</td>\n",
       "      <td>40923.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>32738.0</td>\n",
       "      <td>60.01</td>\n",
       "      <td>32.81</td>\n",
       "      <td>0.805000</td>\n",
       "      <td>0.190000</td>\n",
       "      <td>0.273950</td>\n",
       "      <td>MA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Indiana</td>\n",
       "      <td>6483802.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>129676.0</td>\n",
       "      <td>64838.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>43225.0</td>\n",
       "      <td>37.91</td>\n",
       "      <td>56.82</td>\n",
       "      <td>0.286667</td>\n",
       "      <td>0.706667</td>\n",
       "      <td>0.161667</td>\n",
       "      <td>IN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>6392017.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>213067.0</td>\n",
       "      <td>106534.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>71022.0</td>\n",
       "      <td>45.13</td>\n",
       "      <td>48.67</td>\n",
       "      <td>0.466667</td>\n",
       "      <td>0.533333</td>\n",
       "      <td>0.038683</td>\n",
       "      <td>AZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Tennessee</td>\n",
       "      <td>6346105.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>192306.0</td>\n",
       "      <td>64102.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>48077.0</td>\n",
       "      <td>34.72</td>\n",
       "      <td>60.72</td>\n",
       "      <td>0.234848</td>\n",
       "      <td>0.757576</td>\n",
       "      <td>0.187539</td>\n",
       "      <td>TN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Missouri</td>\n",
       "      <td>5988927.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>176145.0</td>\n",
       "      <td>36742.0</td>\n",
       "      <td>197.0</td>\n",
       "      <td>30401.0</td>\n",
       "      <td>38.14</td>\n",
       "      <td>56.77</td>\n",
       "      <td>0.294416</td>\n",
       "      <td>0.700508</td>\n",
       "      <td>0.153388</td>\n",
       "      <td>MO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>5773552.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>122842.0</td>\n",
       "      <td>40947.0</td>\n",
       "      <td>188.0</td>\n",
       "      <td>30710.0</td>\n",
       "      <td>60.33</td>\n",
       "      <td>33.91</td>\n",
       "      <td>0.696809</td>\n",
       "      <td>0.303191</td>\n",
       "      <td>0.111463</td>\n",
       "      <td>MD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>5686986.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>172333.0</td>\n",
       "      <td>57444.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>43083.0</td>\n",
       "      <td>46.45</td>\n",
       "      <td>47.22</td>\n",
       "      <td>0.378788</td>\n",
       "      <td>0.621212</td>\n",
       "      <td>0.160218</td>\n",
       "      <td>WI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Minnesota</td>\n",
       "      <td>5303925.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>79163.0</td>\n",
       "      <td>39582.0</td>\n",
       "      <td>201.0</td>\n",
       "      <td>26388.0</td>\n",
       "      <td>46.44</td>\n",
       "      <td>44.92</td>\n",
       "      <td>0.532338</td>\n",
       "      <td>0.467662</td>\n",
       "      <td>0.077169</td>\n",
       "      <td>MN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Colorado</td>\n",
       "      <td>5029196.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>143691.0</td>\n",
       "      <td>77372.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50292.0</td>\n",
       "      <td>48.16</td>\n",
       "      <td>43.25</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>0.134650</td>\n",
       "      <td>CO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>4779736.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>136564.0</td>\n",
       "      <td>45521.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>34141.0</td>\n",
       "      <td>34.36</td>\n",
       "      <td>62.08</td>\n",
       "      <td>0.257143</td>\n",
       "      <td>0.735714</td>\n",
       "      <td>0.143914</td>\n",
       "      <td>AL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>South Carolina</td>\n",
       "      <td>4625364.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>100551.0</td>\n",
       "      <td>37301.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>27208.0</td>\n",
       "      <td>40.67</td>\n",
       "      <td>54.94</td>\n",
       "      <td>0.370588</td>\n",
       "      <td>0.629412</td>\n",
       "      <td>0.076118</td>\n",
       "      <td>SC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Louisiana</td>\n",
       "      <td>4533372.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>116240.0</td>\n",
       "      <td>43175.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>31482.0</td>\n",
       "      <td>38.45</td>\n",
       "      <td>58.09</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.652778</td>\n",
       "      <td>0.087106</td>\n",
       "      <td>LA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Kentucky</td>\n",
       "      <td>4339367.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>114194.0</td>\n",
       "      <td>43394.0</td>\n",
       "      <td>138.0</td>\n",
       "      <td>31445.0</td>\n",
       "      <td>32.68</td>\n",
       "      <td>62.52</td>\n",
       "      <td>0.347826</td>\n",
       "      <td>0.652174</td>\n",
       "      <td>0.034513</td>\n",
       "      <td>KY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Oregon</td>\n",
       "      <td>3831074.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>127702.0</td>\n",
       "      <td>63851.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>42567.0</td>\n",
       "      <td>50.07</td>\n",
       "      <td>39.09</td>\n",
       "      <td>0.622222</td>\n",
       "      <td>0.366667</td>\n",
       "      <td>0.133639</td>\n",
       "      <td>OR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>3751351.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>78153.0</td>\n",
       "      <td>37142.0</td>\n",
       "      <td>149.0</td>\n",
       "      <td>25177.0</td>\n",
       "      <td>28.93</td>\n",
       "      <td>65.32</td>\n",
       "      <td>0.221477</td>\n",
       "      <td>0.778523</td>\n",
       "      <td>0.130485</td>\n",
       "      <td>OK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Connecticut</td>\n",
       "      <td>3574097.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>99280.0</td>\n",
       "      <td>23670.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>19113.0</td>\n",
       "      <td>54.57</td>\n",
       "      <td>40.93</td>\n",
       "      <td>0.604278</td>\n",
       "      <td>0.395722</td>\n",
       "      <td>0.065367</td>\n",
       "      <td>CT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>3046355.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60927.0</td>\n",
       "      <td>30464.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>20309.0</td>\n",
       "      <td>41.74</td>\n",
       "      <td>51.15</td>\n",
       "      <td>0.426667</td>\n",
       "      <td>0.566667</td>\n",
       "      <td>0.036850</td>\n",
       "      <td>IA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Mississippi</td>\n",
       "      <td>2967297.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>57063.0</td>\n",
       "      <td>24322.0</td>\n",
       "      <td>174.0</td>\n",
       "      <td>17053.0</td>\n",
       "      <td>40.11</td>\n",
       "      <td>57.94</td>\n",
       "      <td>0.356322</td>\n",
       "      <td>0.637931</td>\n",
       "      <td>0.074044</td>\n",
       "      <td>MS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>2915918.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>83312.0</td>\n",
       "      <td>29159.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>21599.0</td>\n",
       "      <td>33.65</td>\n",
       "      <td>60.57</td>\n",
       "      <td>0.244444</td>\n",
       "      <td>0.748148</td>\n",
       "      <td>0.163280</td>\n",
       "      <td>AR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Kansas</td>\n",
       "      <td>2853118.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>71328.0</td>\n",
       "      <td>22825.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>17292.0</td>\n",
       "      <td>36.05</td>\n",
       "      <td>56.65</td>\n",
       "      <td>0.315152</td>\n",
       "      <td>0.672727</td>\n",
       "      <td>0.098462</td>\n",
       "      <td>KS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Utah</td>\n",
       "      <td>2763885.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>95306.0</td>\n",
       "      <td>36852.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>26576.0</td>\n",
       "      <td>27.46</td>\n",
       "      <td>45.54</td>\n",
       "      <td>0.211538</td>\n",
       "      <td>0.788462</td>\n",
       "      <td>0.229592</td>\n",
       "      <td>UT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Nevada</td>\n",
       "      <td>2700551.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>128598.0</td>\n",
       "      <td>64299.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>42866.0</td>\n",
       "      <td>47.92</td>\n",
       "      <td>45.50</td>\n",
       "      <td>0.650794</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.232427</td>\n",
       "      <td>NV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>New Mexico</td>\n",
       "      <td>2059179.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>49028.0</td>\n",
       "      <td>29417.0</td>\n",
       "      <td>112.0</td>\n",
       "      <td>18386.0</td>\n",
       "      <td>48.26</td>\n",
       "      <td>40.04</td>\n",
       "      <td>0.642857</td>\n",
       "      <td>0.357143</td>\n",
       "      <td>0.181886</td>\n",
       "      <td>NM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>1852994.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>54500.0</td>\n",
       "      <td>18530.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>13828.0</td>\n",
       "      <td>26.43</td>\n",
       "      <td>68.50</td>\n",
       "      <td>0.410448</td>\n",
       "      <td>0.589552</td>\n",
       "      <td>0.193872</td>\n",
       "      <td>WV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Nebraska</td>\n",
       "      <td>1826341.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37272.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>49.0</td>\n",
       "      <td>37272.0</td>\n",
       "      <td>33.70</td>\n",
       "      <td>58.75</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.630750</td>\n",
       "      <td>NE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Idaho</td>\n",
       "      <td>1567582.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>44788.0</td>\n",
       "      <td>22394.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>14929.0</td>\n",
       "      <td>27.49</td>\n",
       "      <td>59.26</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.178600</td>\n",
       "      <td>ID</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Hawaii</td>\n",
       "      <td>1360301.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>54412.0</td>\n",
       "      <td>26673.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>17899.0</td>\n",
       "      <td>62.22</td>\n",
       "      <td>30.03</td>\n",
       "      <td>0.921053</td>\n",
       "      <td>0.078947</td>\n",
       "      <td>0.409529</td>\n",
       "      <td>HI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Maine</td>\n",
       "      <td>1328361.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>37953.0</td>\n",
       "      <td>8797.0</td>\n",
       "      <td>186.0</td>\n",
       "      <td>7142.0</td>\n",
       "      <td>47.83</td>\n",
       "      <td>44.87</td>\n",
       "      <td>0.591398</td>\n",
       "      <td>0.376344</td>\n",
       "      <td>0.149276</td>\n",
       "      <td>ME</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>New Hampshire</td>\n",
       "      <td>1316470.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>54853.0</td>\n",
       "      <td>3291.0</td>\n",
       "      <td>424.0</td>\n",
       "      <td>3105.0</td>\n",
       "      <td>46.98</td>\n",
       "      <td>46.61</td>\n",
       "      <td>0.582547</td>\n",
       "      <td>0.412736</td>\n",
       "      <td>0.139429</td>\n",
       "      <td>NH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>1052567.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>27699.0</td>\n",
       "      <td>14034.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>9315.0</td>\n",
       "      <td>54.41</td>\n",
       "      <td>38.90</td>\n",
       "      <td>0.876106</td>\n",
       "      <td>0.123894</td>\n",
       "      <td>0.464559</td>\n",
       "      <td>RI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Montana</td>\n",
       "      <td>989415.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>19788.0</td>\n",
       "      <td>9894.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>6596.0</td>\n",
       "      <td>35.75</td>\n",
       "      <td>56.17</td>\n",
       "      <td>0.413333</td>\n",
       "      <td>0.586667</td>\n",
       "      <td>0.068317</td>\n",
       "      <td>MT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Delaware</td>\n",
       "      <td>897934.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>42759.0</td>\n",
       "      <td>21901.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>14483.0</td>\n",
       "      <td>53.09</td>\n",
       "      <td>41.72</td>\n",
       "      <td>0.612903</td>\n",
       "      <td>0.387097</td>\n",
       "      <td>0.097055</td>\n",
       "      <td>DE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>814180.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>23262.0</td>\n",
       "      <td>11631.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>7754.0</td>\n",
       "      <td>31.74</td>\n",
       "      <td>61.53</td>\n",
       "      <td>0.152381</td>\n",
       "      <td>0.847619</td>\n",
       "      <td>0.281179</td>\n",
       "      <td>SD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>710231.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>35512.0</td>\n",
       "      <td>17756.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>11837.0</td>\n",
       "      <td>36.55</td>\n",
       "      <td>51.28</td>\n",
       "      <td>0.366667</td>\n",
       "      <td>0.583333</td>\n",
       "      <td>0.036433</td>\n",
       "      <td>AK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>North Dakota</td>\n",
       "      <td>672591.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>14310.0</td>\n",
       "      <td>7155.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>4770.0</td>\n",
       "      <td>27.23</td>\n",
       "      <td>62.96</td>\n",
       "      <td>0.177305</td>\n",
       "      <td>0.822695</td>\n",
       "      <td>0.191543</td>\n",
       "      <td>ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Vermont</td>\n",
       "      <td>625741.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>20858.0</td>\n",
       "      <td>4172.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>3476.0</td>\n",
       "      <td>56.68</td>\n",
       "      <td>30.27</td>\n",
       "      <td>0.650000</td>\n",
       "      <td>0.272222</td>\n",
       "      <td>0.098439</td>\n",
       "      <td>VT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Wyoming</td>\n",
       "      <td>563626.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>18788.0</td>\n",
       "      <td>9394.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>6263.0</td>\n",
       "      <td>21.63</td>\n",
       "      <td>67.40</td>\n",
       "      <td>0.133333</td>\n",
       "      <td>0.855556</td>\n",
       "      <td>0.173744</td>\n",
       "      <td>WY</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             State  population  senate_seats  rep_seats  pop_per_senator  \\\n",
       "0       California  37253956.0          40.0       80.0         931349.0   \n",
       "1            Texas  25145561.0          31.0      150.0         811147.0   \n",
       "2         New York  19378102.0          63.0      150.0         307589.0   \n",
       "3          Florida  18801310.0          40.0      120.0         470033.0   \n",
       "4         Illinois  12830632.0          59.0      118.0         217468.0   \n",
       "5     Pennsylvania  12702379.0          50.0      203.0         254048.0   \n",
       "6             Ohio  11536504.0          33.0       99.0         349591.0   \n",
       "7         Michigan   9883640.0          38.0      110.0         260096.0   \n",
       "8          Georgia   9687653.0          56.0      180.0         172994.0   \n",
       "9   North Carolina   9535483.0          50.0      120.0         190710.0   \n",
       "10      New Jersey   8791894.0          40.0       80.0         219797.0   \n",
       "11        Virginia   8001024.0          40.0      100.0         200026.0   \n",
       "12      Washington   6724540.0          49.0       98.0         137236.0   \n",
       "13   Massachusetts   6547629.0          40.0      160.0         163691.0   \n",
       "14         Indiana   6483802.0          50.0      100.0         129676.0   \n",
       "15         Arizona   6392017.0          30.0       60.0         213067.0   \n",
       "16       Tennessee   6346105.0          33.0       99.0         192306.0   \n",
       "17        Missouri   5988927.0          34.0      163.0         176145.0   \n",
       "18        Maryland   5773552.0          47.0      141.0         122842.0   \n",
       "19       Wisconsin   5686986.0          33.0       99.0         172333.0   \n",
       "20       Minnesota   5303925.0          67.0      134.0          79163.0   \n",
       "21        Colorado   5029196.0          35.0       65.0         143691.0   \n",
       "22         Alabama   4779736.0          35.0      105.0         136564.0   \n",
       "23  South Carolina   4625364.0          46.0      124.0         100551.0   \n",
       "24       Louisiana   4533372.0          39.0      105.0         116240.0   \n",
       "25        Kentucky   4339367.0          38.0      100.0         114194.0   \n",
       "26          Oregon   3831074.0          30.0       60.0         127702.0   \n",
       "27        Oklahoma   3751351.0          48.0      101.0          78153.0   \n",
       "28     Connecticut   3574097.0          36.0      151.0          99280.0   \n",
       "29            Iowa   3046355.0          50.0      100.0          60927.0   \n",
       "30     Mississippi   2967297.0          52.0      122.0          57063.0   \n",
       "31        Arkansas   2915918.0          35.0      100.0          83312.0   \n",
       "32          Kansas   2853118.0          40.0      125.0          71328.0   \n",
       "33            Utah   2763885.0          29.0       75.0          95306.0   \n",
       "34          Nevada   2700551.0          21.0       42.0         128598.0   \n",
       "35      New Mexico   2059179.0          42.0       70.0          49028.0   \n",
       "36   West Virginia   1852994.0          34.0      100.0          54500.0   \n",
       "37        Nebraska   1826341.0          49.0        0.0          37272.0   \n",
       "38           Idaho   1567582.0          35.0       70.0          44788.0   \n",
       "39          Hawaii   1360301.0          25.0       51.0          54412.0   \n",
       "40           Maine   1328361.0          35.0      151.0          37953.0   \n",
       "41   New Hampshire   1316470.0          24.0      400.0          54853.0   \n",
       "42    Rhode Island   1052567.0          38.0       75.0          27699.0   \n",
       "43         Montana    989415.0          50.0      100.0          19788.0   \n",
       "44        Delaware    897934.0          21.0       41.0          42759.0   \n",
       "45    South Dakota    814180.0          35.0       70.0          23262.0   \n",
       "46          Alaska    710231.0          20.0       40.0          35512.0   \n",
       "47    North Dakota    672591.0          47.0       94.0          14310.0   \n",
       "48         Vermont    625741.0          30.0      150.0          20858.0   \n",
       "49         Wyoming    563626.0          30.0       60.0          18788.0   \n",
       "\n",
       "    pop_per_rep  total_seats  pop_per_legislator  pres_dem  pres_rep  \\\n",
       "0      465674.0        120.0            310450.0     61.73     31.62   \n",
       "1      167637.0        181.0            138926.0     43.24     52.23   \n",
       "2      129187.0        213.0             90977.0     59.01     36.52   \n",
       "3      156678.0        160.0            117508.0     47.82     49.02   \n",
       "4      108734.0        177.0             72489.0     55.83     38.76   \n",
       "5       62573.0        253.0             50207.0     47.46     48.18   \n",
       "6      116530.0        132.0             87398.0     43.56     51.69   \n",
       "7       89851.0        148.0             66781.0     47.27     47.50   \n",
       "8       53820.0        236.0             41049.0     45.64     50.77   \n",
       "9       79462.0        170.0             56091.0     46.17     49.83   \n",
       "10     109899.0        120.0             73266.0     54.99     41.00   \n",
       "11      80010.0        140.0             57150.0     49.73     44.41   \n",
       "12      68618.0        147.0             45745.0     52.54     36.83   \n",
       "13      40923.0        200.0             32738.0     60.01     32.81   \n",
       "14      64838.0        150.0             43225.0     37.91     56.82   \n",
       "15     106534.0         90.0             71022.0     45.13     48.67   \n",
       "16      64102.0        132.0             48077.0     34.72     60.72   \n",
       "17      36742.0        197.0             30401.0     38.14     56.77   \n",
       "18      40947.0        188.0             30710.0     60.33     33.91   \n",
       "19      57444.0        132.0             43083.0     46.45     47.22   \n",
       "20      39582.0        201.0             26388.0     46.44     44.92   \n",
       "21      77372.0        100.0             50292.0     48.16     43.25   \n",
       "22      45521.0        140.0             34141.0     34.36     62.08   \n",
       "23      37301.0        170.0             27208.0     40.67     54.94   \n",
       "24      43175.0        144.0             31482.0     38.45     58.09   \n",
       "25      43394.0        138.0             31445.0     32.68     62.52   \n",
       "26      63851.0         90.0             42567.0     50.07     39.09   \n",
       "27      37142.0        149.0             25177.0     28.93     65.32   \n",
       "28      23670.0        187.0             19113.0     54.57     40.93   \n",
       "29      30464.0        150.0             20309.0     41.74     51.15   \n",
       "30      24322.0        174.0             17053.0     40.11     57.94   \n",
       "31      29159.0        135.0             21599.0     33.65     60.57   \n",
       "32      22825.0        165.0             17292.0     36.05     56.65   \n",
       "33      36852.0        104.0             26576.0     27.46     45.54   \n",
       "34      64299.0         63.0             42866.0     47.92     45.50   \n",
       "35      29417.0        112.0             18386.0     48.26     40.04   \n",
       "36      18530.0        134.0             13828.0     26.43     68.50   \n",
       "37          NaN         49.0             37272.0     33.70     58.75   \n",
       "38      22394.0        105.0             14929.0     27.49     59.26   \n",
       "39      26673.0         76.0             17899.0     62.22     30.03   \n",
       "40       8797.0        186.0              7142.0     47.83     44.87   \n",
       "41       3291.0        424.0              3105.0     46.98     46.61   \n",
       "42      14034.0        113.0              9315.0     54.41     38.90   \n",
       "43       9894.0        150.0              6596.0     35.75     56.17   \n",
       "44      21901.0         62.0             14483.0     53.09     41.72   \n",
       "45      11631.0        105.0              7754.0     31.74     61.53   \n",
       "46      17756.0         60.0             11837.0     36.55     51.28   \n",
       "47       7155.0        141.0              4770.0     27.23     62.96   \n",
       "48       4172.0        180.0              3476.0     56.68     30.27   \n",
       "49       9394.0         90.0              6263.0     21.63     67.40   \n",
       "\n",
       "     leg_dem   leg_rep  total_diff Abbreviation  \n",
       "0   0.750000  0.250000    0.165800           CA  \n",
       "1   0.441989  0.558011    0.027444           TX  \n",
       "2   0.685446  0.309859    0.123016           NY  \n",
       "3   0.400000  0.600000    0.133100           FL  \n",
       "4   0.644068  0.355932    0.101602           IL  \n",
       "5   0.450593  0.545455    0.055834           PA  \n",
       "6   0.356061  0.636364    0.139271           OH  \n",
       "7   0.459459  0.540541    0.046011           MI  \n",
       "8   0.406780  0.593220    0.092381           GA  \n",
       "9   0.447059  0.547059    0.039021           NC  \n",
       "10  0.625000  0.375000    0.092600           NJ  \n",
       "11  0.542857  0.457143    0.052079           VA  \n",
       "12  0.585034  0.414966    0.082967           WA  \n",
       "13  0.805000  0.190000    0.273950           MA  \n",
       "14  0.286667  0.706667    0.161667           IN  \n",
       "15  0.466667  0.533333    0.038683           AZ  \n",
       "16  0.234848  0.757576    0.187539           TN  \n",
       "17  0.294416  0.700508    0.153388           MO  \n",
       "18  0.696809  0.303191    0.111463           MD  \n",
       "19  0.378788  0.621212    0.160218           WI  \n",
       "20  0.532338  0.467662    0.077169           MN  \n",
       "21  0.600000  0.400000    0.134650           CO  \n",
       "22  0.257143  0.735714    0.143914           AL  \n",
       "23  0.370588  0.629412    0.076118           SC  \n",
       "24  0.333333  0.652778    0.087106           LA  \n",
       "25  0.347826  0.652174    0.034513           KY  \n",
       "26  0.622222  0.366667    0.133639           OR  \n",
       "27  0.221477  0.778523    0.130485           OK  \n",
       "28  0.604278  0.395722    0.065367           CT  \n",
       "29  0.426667  0.566667    0.036850           IA  \n",
       "30  0.356322  0.637931    0.074044           MS  \n",
       "31  0.244444  0.748148    0.163280           AR  \n",
       "32  0.315152  0.672727    0.098462           KS  \n",
       "33  0.211538  0.788462    0.229592           UT  \n",
       "34  0.650794  0.333333    0.232427           NV  \n",
       "35  0.642857  0.357143    0.181886           NM  \n",
       "36  0.410448  0.589552    0.193872           WV  \n",
       "37  0.000000  0.000000    0.630750           NE  \n",
       "38  0.200000  0.800000    0.178600           ID  \n",
       "39  0.921053  0.078947    0.409529           HI  \n",
       "40  0.591398  0.376344    0.149276           ME  \n",
       "41  0.582547  0.412736    0.139429           NH  \n",
       "42  0.876106  0.123894    0.464559           RI  \n",
       "43  0.413333  0.586667    0.068317           MT  \n",
       "44  0.612903  0.387097    0.097055           DE  \n",
       "45  0.152381  0.847619    0.281179           SD  \n",
       "46  0.366667  0.583333    0.036433           AK  \n",
       "47  0.177305  0.822695    0.191543           ND  \n",
       "48  0.650000  0.272222    0.098439           VT  \n",
       "49  0.133333  0.855556    0.173744           WY  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ab = pd.read_csv('data\\states_abbreviations.csv')\n",
    "df = df.merge(df_ab,on='State')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>State</th>\n",
       "      <th>population</th>\n",
       "      <th>senate_seats</th>\n",
       "      <th>rep_seats</th>\n",
       "      <th>pop_per_senator</th>\n",
       "      <th>pop_per_rep</th>\n",
       "      <th>total_seats</th>\n",
       "      <th>pop_per_legislator</th>\n",
       "      <th>pres_dem</th>\n",
       "      <th>pres_rep</th>\n",
       "      <th>leg_dem</th>\n",
       "      <th>leg_rep</th>\n",
       "      <th>total_diff</th>\n",
       "      <th>Abbreviation</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>California</td>\n",
       "      <td>37253956.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>931349.0</td>\n",
       "      <td>465674.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>310450.0</td>\n",
       "      <td>61.73</td>\n",
       "      <td>31.62</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>0.165800</td>\n",
       "      <td>CA</td>\n",
       "      <td>36.116203</td>\n",
       "      <td>-119.681564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Texas</td>\n",
       "      <td>25145561.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>811147.0</td>\n",
       "      <td>167637.0</td>\n",
       "      <td>181.0</td>\n",
       "      <td>138926.0</td>\n",
       "      <td>43.24</td>\n",
       "      <td>52.23</td>\n",
       "      <td>0.441989</td>\n",
       "      <td>0.558011</td>\n",
       "      <td>0.027444</td>\n",
       "      <td>TX</td>\n",
       "      <td>31.054487</td>\n",
       "      <td>-97.563461</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>New York</td>\n",
       "      <td>19378102.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>307589.0</td>\n",
       "      <td>129187.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>90977.0</td>\n",
       "      <td>59.01</td>\n",
       "      <td>36.52</td>\n",
       "      <td>0.685446</td>\n",
       "      <td>0.309859</td>\n",
       "      <td>0.123016</td>\n",
       "      <td>NY</td>\n",
       "      <td>42.165726</td>\n",
       "      <td>-74.948051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Florida</td>\n",
       "      <td>18801310.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>470033.0</td>\n",
       "      <td>156678.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>117508.0</td>\n",
       "      <td>47.82</td>\n",
       "      <td>49.02</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>0.133100</td>\n",
       "      <td>FL</td>\n",
       "      <td>27.766279</td>\n",
       "      <td>-81.686783</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Illinois</td>\n",
       "      <td>12830632.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>217468.0</td>\n",
       "      <td>108734.0</td>\n",
       "      <td>177.0</td>\n",
       "      <td>72489.0</td>\n",
       "      <td>55.83</td>\n",
       "      <td>38.76</td>\n",
       "      <td>0.644068</td>\n",
       "      <td>0.355932</td>\n",
       "      <td>0.101602</td>\n",
       "      <td>IL</td>\n",
       "      <td>40.349457</td>\n",
       "      <td>-88.986137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>12702379.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>203.0</td>\n",
       "      <td>254048.0</td>\n",
       "      <td>62573.0</td>\n",
       "      <td>253.0</td>\n",
       "      <td>50207.0</td>\n",
       "      <td>47.46</td>\n",
       "      <td>48.18</td>\n",
       "      <td>0.450593</td>\n",
       "      <td>0.545455</td>\n",
       "      <td>0.055834</td>\n",
       "      <td>PA</td>\n",
       "      <td>40.590752</td>\n",
       "      <td>-77.209755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ohio</td>\n",
       "      <td>11536504.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>349591.0</td>\n",
       "      <td>116530.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>87398.0</td>\n",
       "      <td>43.56</td>\n",
       "      <td>51.69</td>\n",
       "      <td>0.356061</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>0.139271</td>\n",
       "      <td>OH</td>\n",
       "      <td>40.388783</td>\n",
       "      <td>-82.764915</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>9883640.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>260096.0</td>\n",
       "      <td>89851.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>66781.0</td>\n",
       "      <td>47.27</td>\n",
       "      <td>47.50</td>\n",
       "      <td>0.459459</td>\n",
       "      <td>0.540541</td>\n",
       "      <td>0.046011</td>\n",
       "      <td>MI</td>\n",
       "      <td>43.326618</td>\n",
       "      <td>-84.536095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>9687653.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>172994.0</td>\n",
       "      <td>53820.0</td>\n",
       "      <td>236.0</td>\n",
       "      <td>41049.0</td>\n",
       "      <td>45.64</td>\n",
       "      <td>50.77</td>\n",
       "      <td>0.406780</td>\n",
       "      <td>0.593220</td>\n",
       "      <td>0.092381</td>\n",
       "      <td>GA</td>\n",
       "      <td>33.040619</td>\n",
       "      <td>-83.643074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>North Carolina</td>\n",
       "      <td>9535483.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>190710.0</td>\n",
       "      <td>79462.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>56091.0</td>\n",
       "      <td>46.17</td>\n",
       "      <td>49.83</td>\n",
       "      <td>0.447059</td>\n",
       "      <td>0.547059</td>\n",
       "      <td>0.039021</td>\n",
       "      <td>NC</td>\n",
       "      <td>35.630066</td>\n",
       "      <td>-79.806419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>New Jersey</td>\n",
       "      <td>8791894.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>219797.0</td>\n",
       "      <td>109899.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>73266.0</td>\n",
       "      <td>54.99</td>\n",
       "      <td>41.00</td>\n",
       "      <td>0.625000</td>\n",
       "      <td>0.375000</td>\n",
       "      <td>0.092600</td>\n",
       "      <td>NJ</td>\n",
       "      <td>40.298904</td>\n",
       "      <td>-74.521011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>8001024.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>200026.0</td>\n",
       "      <td>80010.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>57150.0</td>\n",
       "      <td>49.73</td>\n",
       "      <td>44.41</td>\n",
       "      <td>0.542857</td>\n",
       "      <td>0.457143</td>\n",
       "      <td>0.052079</td>\n",
       "      <td>VA</td>\n",
       "      <td>37.769337</td>\n",
       "      <td>-78.169968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Washington</td>\n",
       "      <td>6724540.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>137236.0</td>\n",
       "      <td>68618.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>45745.0</td>\n",
       "      <td>52.54</td>\n",
       "      <td>36.83</td>\n",
       "      <td>0.585034</td>\n",
       "      <td>0.414966</td>\n",
       "      <td>0.082967</td>\n",
       "      <td>WA</td>\n",
       "      <td>47.400902</td>\n",
       "      <td>-121.490494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>6547629.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>163691.0</td>\n",
       "      <td>40923.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>32738.0</td>\n",
       "      <td>60.01</td>\n",
       "      <td>32.81</td>\n",
       "      <td>0.805000</td>\n",
       "      <td>0.190000</td>\n",
       "      <td>0.273950</td>\n",
       "      <td>MA</td>\n",
       "      <td>42.230171</td>\n",
       "      <td>-71.530106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Indiana</td>\n",
       "      <td>6483802.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>129676.0</td>\n",
       "      <td>64838.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>43225.0</td>\n",
       "      <td>37.91</td>\n",
       "      <td>56.82</td>\n",
       "      <td>0.286667</td>\n",
       "      <td>0.706667</td>\n",
       "      <td>0.161667</td>\n",
       "      <td>IN</td>\n",
       "      <td>39.849426</td>\n",
       "      <td>-86.258278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>6392017.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>213067.0</td>\n",
       "      <td>106534.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>71022.0</td>\n",
       "      <td>45.13</td>\n",
       "      <td>48.67</td>\n",
       "      <td>0.466667</td>\n",
       "      <td>0.533333</td>\n",
       "      <td>0.038683</td>\n",
       "      <td>AZ</td>\n",
       "      <td>33.729759</td>\n",
       "      <td>-111.431221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Tennessee</td>\n",
       "      <td>6346105.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>192306.0</td>\n",
       "      <td>64102.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>48077.0</td>\n",
       "      <td>34.72</td>\n",
       "      <td>60.72</td>\n",
       "      <td>0.234848</td>\n",
       "      <td>0.757576</td>\n",
       "      <td>0.187539</td>\n",
       "      <td>TN</td>\n",
       "      <td>35.747845</td>\n",
       "      <td>-86.692345</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Missouri</td>\n",
       "      <td>5988927.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>176145.0</td>\n",
       "      <td>36742.0</td>\n",
       "      <td>197.0</td>\n",
       "      <td>30401.0</td>\n",
       "      <td>38.14</td>\n",
       "      <td>56.77</td>\n",
       "      <td>0.294416</td>\n",
       "      <td>0.700508</td>\n",
       "      <td>0.153388</td>\n",
       "      <td>MO</td>\n",
       "      <td>38.456085</td>\n",
       "      <td>-92.288368</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>5773552.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>122842.0</td>\n",
       "      <td>40947.0</td>\n",
       "      <td>188.0</td>\n",
       "      <td>30710.0</td>\n",
       "      <td>60.33</td>\n",
       "      <td>33.91</td>\n",
       "      <td>0.696809</td>\n",
       "      <td>0.303191</td>\n",
       "      <td>0.111463</td>\n",
       "      <td>MD</td>\n",
       "      <td>39.063946</td>\n",
       "      <td>-76.802101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>5686986.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>172333.0</td>\n",
       "      <td>57444.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>43083.0</td>\n",
       "      <td>46.45</td>\n",
       "      <td>47.22</td>\n",
       "      <td>0.378788</td>\n",
       "      <td>0.621212</td>\n",
       "      <td>0.160218</td>\n",
       "      <td>WI</td>\n",
       "      <td>44.268543</td>\n",
       "      <td>-89.616508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Minnesota</td>\n",
       "      <td>5303925.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>79163.0</td>\n",
       "      <td>39582.0</td>\n",
       "      <td>201.0</td>\n",
       "      <td>26388.0</td>\n",
       "      <td>46.44</td>\n",
       "      <td>44.92</td>\n",
       "      <td>0.532338</td>\n",
       "      <td>0.467662</td>\n",
       "      <td>0.077169</td>\n",
       "      <td>MN</td>\n",
       "      <td>45.694454</td>\n",
       "      <td>-93.900192</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Colorado</td>\n",
       "      <td>5029196.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>143691.0</td>\n",
       "      <td>77372.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>50292.0</td>\n",
       "      <td>48.16</td>\n",
       "      <td>43.25</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>0.134650</td>\n",
       "      <td>CO</td>\n",
       "      <td>39.059811</td>\n",
       "      <td>-105.311104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>4779736.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>136564.0</td>\n",
       "      <td>45521.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>34141.0</td>\n",
       "      <td>34.36</td>\n",
       "      <td>62.08</td>\n",
       "      <td>0.257143</td>\n",
       "      <td>0.735714</td>\n",
       "      <td>0.143914</td>\n",
       "      <td>AL</td>\n",
       "      <td>32.806671</td>\n",
       "      <td>-86.791130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>South Carolina</td>\n",
       "      <td>4625364.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>100551.0</td>\n",
       "      <td>37301.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>27208.0</td>\n",
       "      <td>40.67</td>\n",
       "      <td>54.94</td>\n",
       "      <td>0.370588</td>\n",
       "      <td>0.629412</td>\n",
       "      <td>0.076118</td>\n",
       "      <td>SC</td>\n",
       "      <td>33.856892</td>\n",
       "      <td>-80.945007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Louisiana</td>\n",
       "      <td>4533372.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>116240.0</td>\n",
       "      <td>43175.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>31482.0</td>\n",
       "      <td>38.45</td>\n",
       "      <td>58.09</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.652778</td>\n",
       "      <td>0.087106</td>\n",
       "      <td>LA</td>\n",
       "      <td>31.169546</td>\n",
       "      <td>-91.867805</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Kentucky</td>\n",
       "      <td>4339367.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>114194.0</td>\n",
       "      <td>43394.0</td>\n",
       "      <td>138.0</td>\n",
       "      <td>31445.0</td>\n",
       "      <td>32.68</td>\n",
       "      <td>62.52</td>\n",
       "      <td>0.347826</td>\n",
       "      <td>0.652174</td>\n",
       "      <td>0.034513</td>\n",
       "      <td>KY</td>\n",
       "      <td>37.668140</td>\n",
       "      <td>-84.670067</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Oregon</td>\n",
       "      <td>3831074.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>127702.0</td>\n",
       "      <td>63851.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>42567.0</td>\n",
       "      <td>50.07</td>\n",
       "      <td>39.09</td>\n",
       "      <td>0.622222</td>\n",
       "      <td>0.366667</td>\n",
       "      <td>0.133639</td>\n",
       "      <td>OR</td>\n",
       "      <td>44.572021</td>\n",
       "      <td>-122.070938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>3751351.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>78153.0</td>\n",
       "      <td>37142.0</td>\n",
       "      <td>149.0</td>\n",
       "      <td>25177.0</td>\n",
       "      <td>28.93</td>\n",
       "      <td>65.32</td>\n",
       "      <td>0.221477</td>\n",
       "      <td>0.778523</td>\n",
       "      <td>0.130485</td>\n",
       "      <td>OK</td>\n",
       "      <td>35.565342</td>\n",
       "      <td>-96.928917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Connecticut</td>\n",
       "      <td>3574097.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>99280.0</td>\n",
       "      <td>23670.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>19113.0</td>\n",
       "      <td>54.57</td>\n",
       "      <td>40.93</td>\n",
       "      <td>0.604278</td>\n",
       "      <td>0.395722</td>\n",
       "      <td>0.065367</td>\n",
       "      <td>CT</td>\n",
       "      <td>41.597782</td>\n",
       "      <td>-72.755371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>3046355.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>60927.0</td>\n",
       "      <td>30464.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>20309.0</td>\n",
       "      <td>41.74</td>\n",
       "      <td>51.15</td>\n",
       "      <td>0.426667</td>\n",
       "      <td>0.566667</td>\n",
       "      <td>0.036850</td>\n",
       "      <td>IA</td>\n",
       "      <td>42.011539</td>\n",
       "      <td>-93.210526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Mississippi</td>\n",
       "      <td>2967297.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>57063.0</td>\n",
       "      <td>24322.0</td>\n",
       "      <td>174.0</td>\n",
       "      <td>17053.0</td>\n",
       "      <td>40.11</td>\n",
       "      <td>57.94</td>\n",
       "      <td>0.356322</td>\n",
       "      <td>0.637931</td>\n",
       "      <td>0.074044</td>\n",
       "      <td>MS</td>\n",
       "      <td>32.741646</td>\n",
       "      <td>-89.678696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>2915918.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>83312.0</td>\n",
       "      <td>29159.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>21599.0</td>\n",
       "      <td>33.65</td>\n",
       "      <td>60.57</td>\n",
       "      <td>0.244444</td>\n",
       "      <td>0.748148</td>\n",
       "      <td>0.163280</td>\n",
       "      <td>AR</td>\n",
       "      <td>34.969704</td>\n",
       "      <td>-92.373123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Kansas</td>\n",
       "      <td>2853118.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>71328.0</td>\n",
       "      <td>22825.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>17292.0</td>\n",
       "      <td>36.05</td>\n",
       "      <td>56.65</td>\n",
       "      <td>0.315152</td>\n",
       "      <td>0.672727</td>\n",
       "      <td>0.098462</td>\n",
       "      <td>KS</td>\n",
       "      <td>38.526600</td>\n",
       "      <td>-96.726486</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Utah</td>\n",
       "      <td>2763885.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>95306.0</td>\n",
       "      <td>36852.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>26576.0</td>\n",
       "      <td>27.46</td>\n",
       "      <td>45.54</td>\n",
       "      <td>0.211538</td>\n",
       "      <td>0.788462</td>\n",
       "      <td>0.229592</td>\n",
       "      <td>UT</td>\n",
       "      <td>40.150032</td>\n",
       "      <td>-111.862434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Nevada</td>\n",
       "      <td>2700551.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>128598.0</td>\n",
       "      <td>64299.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>42866.0</td>\n",
       "      <td>47.92</td>\n",
       "      <td>45.50</td>\n",
       "      <td>0.650794</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.232427</td>\n",
       "      <td>NV</td>\n",
       "      <td>38.313515</td>\n",
       "      <td>-117.055374</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>New Mexico</td>\n",
       "      <td>2059179.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>49028.0</td>\n",
       "      <td>29417.0</td>\n",
       "      <td>112.0</td>\n",
       "      <td>18386.0</td>\n",
       "      <td>48.26</td>\n",
       "      <td>40.04</td>\n",
       "      <td>0.642857</td>\n",
       "      <td>0.357143</td>\n",
       "      <td>0.181886</td>\n",
       "      <td>NM</td>\n",
       "      <td>34.840515</td>\n",
       "      <td>-106.248482</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>1852994.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>54500.0</td>\n",
       "      <td>18530.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>13828.0</td>\n",
       "      <td>26.43</td>\n",
       "      <td>68.50</td>\n",
       "      <td>0.410448</td>\n",
       "      <td>0.589552</td>\n",
       "      <td>0.193872</td>\n",
       "      <td>WV</td>\n",
       "      <td>38.491226</td>\n",
       "      <td>-80.954453</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Nebraska</td>\n",
       "      <td>1826341.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37272.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>49.0</td>\n",
       "      <td>37272.0</td>\n",
       "      <td>33.70</td>\n",
       "      <td>58.75</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.630750</td>\n",
       "      <td>NE</td>\n",
       "      <td>41.125370</td>\n",
       "      <td>-98.268082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Idaho</td>\n",
       "      <td>1567582.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>44788.0</td>\n",
       "      <td>22394.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>14929.0</td>\n",
       "      <td>27.49</td>\n",
       "      <td>59.26</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.178600</td>\n",
       "      <td>ID</td>\n",
       "      <td>44.240459</td>\n",
       "      <td>-114.478828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Hawaii</td>\n",
       "      <td>1360301.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>54412.0</td>\n",
       "      <td>26673.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>17899.0</td>\n",
       "      <td>62.22</td>\n",
       "      <td>30.03</td>\n",
       "      <td>0.921053</td>\n",
       "      <td>0.078947</td>\n",
       "      <td>0.409529</td>\n",
       "      <td>HI</td>\n",
       "      <td>21.094318</td>\n",
       "      <td>-157.498337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Maine</td>\n",
       "      <td>1328361.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>37953.0</td>\n",
       "      <td>8797.0</td>\n",
       "      <td>186.0</td>\n",
       "      <td>7142.0</td>\n",
       "      <td>47.83</td>\n",
       "      <td>44.87</td>\n",
       "      <td>0.591398</td>\n",
       "      <td>0.376344</td>\n",
       "      <td>0.149276</td>\n",
       "      <td>ME</td>\n",
       "      <td>44.693947</td>\n",
       "      <td>-69.381927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>New Hampshire</td>\n",
       "      <td>1316470.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>54853.0</td>\n",
       "      <td>3291.0</td>\n",
       "      <td>424.0</td>\n",
       "      <td>3105.0</td>\n",
       "      <td>46.98</td>\n",
       "      <td>46.61</td>\n",
       "      <td>0.582547</td>\n",
       "      <td>0.412736</td>\n",
       "      <td>0.139429</td>\n",
       "      <td>NH</td>\n",
       "      <td>43.452492</td>\n",
       "      <td>-71.563896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>1052567.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>27699.0</td>\n",
       "      <td>14034.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>9315.0</td>\n",
       "      <td>54.41</td>\n",
       "      <td>38.90</td>\n",
       "      <td>0.876106</td>\n",
       "      <td>0.123894</td>\n",
       "      <td>0.464559</td>\n",
       "      <td>RI</td>\n",
       "      <td>41.680893</td>\n",
       "      <td>-71.511780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Montana</td>\n",
       "      <td>989415.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>19788.0</td>\n",
       "      <td>9894.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>6596.0</td>\n",
       "      <td>35.75</td>\n",
       "      <td>56.17</td>\n",
       "      <td>0.413333</td>\n",
       "      <td>0.586667</td>\n",
       "      <td>0.068317</td>\n",
       "      <td>MT</td>\n",
       "      <td>46.921925</td>\n",
       "      <td>-110.454353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Delaware</td>\n",
       "      <td>897934.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>42759.0</td>\n",
       "      <td>21901.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>14483.0</td>\n",
       "      <td>53.09</td>\n",
       "      <td>41.72</td>\n",
       "      <td>0.612903</td>\n",
       "      <td>0.387097</td>\n",
       "      <td>0.097055</td>\n",
       "      <td>DE</td>\n",
       "      <td>39.318523</td>\n",
       "      <td>-75.507141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>814180.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>23262.0</td>\n",
       "      <td>11631.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>7754.0</td>\n",
       "      <td>31.74</td>\n",
       "      <td>61.53</td>\n",
       "      <td>0.152381</td>\n",
       "      <td>0.847619</td>\n",
       "      <td>0.281179</td>\n",
       "      <td>SD</td>\n",
       "      <td>44.299782</td>\n",
       "      <td>-99.438828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>710231.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>35512.0</td>\n",
       "      <td>17756.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>11837.0</td>\n",
       "      <td>36.55</td>\n",
       "      <td>51.28</td>\n",
       "      <td>0.366667</td>\n",
       "      <td>0.583333</td>\n",
       "      <td>0.036433</td>\n",
       "      <td>AK</td>\n",
       "      <td>61.370716</td>\n",
       "      <td>-152.404419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>North Dakota</td>\n",
       "      <td>672591.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>14310.0</td>\n",
       "      <td>7155.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>4770.0</td>\n",
       "      <td>27.23</td>\n",
       "      <td>62.96</td>\n",
       "      <td>0.177305</td>\n",
       "      <td>0.822695</td>\n",
       "      <td>0.191543</td>\n",
       "      <td>ND</td>\n",
       "      <td>47.528912</td>\n",
       "      <td>-99.784012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Vermont</td>\n",
       "      <td>625741.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>20858.0</td>\n",
       "      <td>4172.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>3476.0</td>\n",
       "      <td>56.68</td>\n",
       "      <td>30.27</td>\n",
       "      <td>0.650000</td>\n",
       "      <td>0.272222</td>\n",
       "      <td>0.098439</td>\n",
       "      <td>VT</td>\n",
       "      <td>44.045876</td>\n",
       "      <td>-72.710686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Wyoming</td>\n",
       "      <td>563626.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>18788.0</td>\n",
       "      <td>9394.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>6263.0</td>\n",
       "      <td>21.63</td>\n",
       "      <td>67.40</td>\n",
       "      <td>0.133333</td>\n",
       "      <td>0.855556</td>\n",
       "      <td>0.173744</td>\n",
       "      <td>WY</td>\n",
       "      <td>42.755966</td>\n",
       "      <td>-107.302490</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             State  population  senate_seats  rep_seats  pop_per_senator  \\\n",
       "0       California  37253956.0          40.0       80.0         931349.0   \n",
       "1            Texas  25145561.0          31.0      150.0         811147.0   \n",
       "2         New York  19378102.0          63.0      150.0         307589.0   \n",
       "3          Florida  18801310.0          40.0      120.0         470033.0   \n",
       "4         Illinois  12830632.0          59.0      118.0         217468.0   \n",
       "5     Pennsylvania  12702379.0          50.0      203.0         254048.0   \n",
       "6             Ohio  11536504.0          33.0       99.0         349591.0   \n",
       "7         Michigan   9883640.0          38.0      110.0         260096.0   \n",
       "8          Georgia   9687653.0          56.0      180.0         172994.0   \n",
       "9   North Carolina   9535483.0          50.0      120.0         190710.0   \n",
       "10      New Jersey   8791894.0          40.0       80.0         219797.0   \n",
       "11        Virginia   8001024.0          40.0      100.0         200026.0   \n",
       "12      Washington   6724540.0          49.0       98.0         137236.0   \n",
       "13   Massachusetts   6547629.0          40.0      160.0         163691.0   \n",
       "14         Indiana   6483802.0          50.0      100.0         129676.0   \n",
       "15         Arizona   6392017.0          30.0       60.0         213067.0   \n",
       "16       Tennessee   6346105.0          33.0       99.0         192306.0   \n",
       "17        Missouri   5988927.0          34.0      163.0         176145.0   \n",
       "18        Maryland   5773552.0          47.0      141.0         122842.0   \n",
       "19       Wisconsin   5686986.0          33.0       99.0         172333.0   \n",
       "20       Minnesota   5303925.0          67.0      134.0          79163.0   \n",
       "21        Colorado   5029196.0          35.0       65.0         143691.0   \n",
       "22         Alabama   4779736.0          35.0      105.0         136564.0   \n",
       "23  South Carolina   4625364.0          46.0      124.0         100551.0   \n",
       "24       Louisiana   4533372.0          39.0      105.0         116240.0   \n",
       "25        Kentucky   4339367.0          38.0      100.0         114194.0   \n",
       "26          Oregon   3831074.0          30.0       60.0         127702.0   \n",
       "27        Oklahoma   3751351.0          48.0      101.0          78153.0   \n",
       "28     Connecticut   3574097.0          36.0      151.0          99280.0   \n",
       "29            Iowa   3046355.0          50.0      100.0          60927.0   \n",
       "30     Mississippi   2967297.0          52.0      122.0          57063.0   \n",
       "31        Arkansas   2915918.0          35.0      100.0          83312.0   \n",
       "32          Kansas   2853118.0          40.0      125.0          71328.0   \n",
       "33            Utah   2763885.0          29.0       75.0          95306.0   \n",
       "34          Nevada   2700551.0          21.0       42.0         128598.0   \n",
       "35      New Mexico   2059179.0          42.0       70.0          49028.0   \n",
       "36   West Virginia   1852994.0          34.0      100.0          54500.0   \n",
       "37        Nebraska   1826341.0          49.0        0.0          37272.0   \n",
       "38           Idaho   1567582.0          35.0       70.0          44788.0   \n",
       "39          Hawaii   1360301.0          25.0       51.0          54412.0   \n",
       "40           Maine   1328361.0          35.0      151.0          37953.0   \n",
       "41   New Hampshire   1316470.0          24.0      400.0          54853.0   \n",
       "42    Rhode Island   1052567.0          38.0       75.0          27699.0   \n",
       "43         Montana    989415.0          50.0      100.0          19788.0   \n",
       "44        Delaware    897934.0          21.0       41.0          42759.0   \n",
       "45    South Dakota    814180.0          35.0       70.0          23262.0   \n",
       "46          Alaska    710231.0          20.0       40.0          35512.0   \n",
       "47    North Dakota    672591.0          47.0       94.0          14310.0   \n",
       "48         Vermont    625741.0          30.0      150.0          20858.0   \n",
       "49         Wyoming    563626.0          30.0       60.0          18788.0   \n",
       "\n",
       "    pop_per_rep  total_seats  pop_per_legislator  pres_dem  pres_rep  \\\n",
       "0      465674.0        120.0            310450.0     61.73     31.62   \n",
       "1      167637.0        181.0            138926.0     43.24     52.23   \n",
       "2      129187.0        213.0             90977.0     59.01     36.52   \n",
       "3      156678.0        160.0            117508.0     47.82     49.02   \n",
       "4      108734.0        177.0             72489.0     55.83     38.76   \n",
       "5       62573.0        253.0             50207.0     47.46     48.18   \n",
       "6      116530.0        132.0             87398.0     43.56     51.69   \n",
       "7       89851.0        148.0             66781.0     47.27     47.50   \n",
       "8       53820.0        236.0             41049.0     45.64     50.77   \n",
       "9       79462.0        170.0             56091.0     46.17     49.83   \n",
       "10     109899.0        120.0             73266.0     54.99     41.00   \n",
       "11      80010.0        140.0             57150.0     49.73     44.41   \n",
       "12      68618.0        147.0             45745.0     52.54     36.83   \n",
       "13      40923.0        200.0             32738.0     60.01     32.81   \n",
       "14      64838.0        150.0             43225.0     37.91     56.82   \n",
       "15     106534.0         90.0             71022.0     45.13     48.67   \n",
       "16      64102.0        132.0             48077.0     34.72     60.72   \n",
       "17      36742.0        197.0             30401.0     38.14     56.77   \n",
       "18      40947.0        188.0             30710.0     60.33     33.91   \n",
       "19      57444.0        132.0             43083.0     46.45     47.22   \n",
       "20      39582.0        201.0             26388.0     46.44     44.92   \n",
       "21      77372.0        100.0             50292.0     48.16     43.25   \n",
       "22      45521.0        140.0             34141.0     34.36     62.08   \n",
       "23      37301.0        170.0             27208.0     40.67     54.94   \n",
       "24      43175.0        144.0             31482.0     38.45     58.09   \n",
       "25      43394.0        138.0             31445.0     32.68     62.52   \n",
       "26      63851.0         90.0             42567.0     50.07     39.09   \n",
       "27      37142.0        149.0             25177.0     28.93     65.32   \n",
       "28      23670.0        187.0             19113.0     54.57     40.93   \n",
       "29      30464.0        150.0             20309.0     41.74     51.15   \n",
       "30      24322.0        174.0             17053.0     40.11     57.94   \n",
       "31      29159.0        135.0             21599.0     33.65     60.57   \n",
       "32      22825.0        165.0             17292.0     36.05     56.65   \n",
       "33      36852.0        104.0             26576.0     27.46     45.54   \n",
       "34      64299.0         63.0             42866.0     47.92     45.50   \n",
       "35      29417.0        112.0             18386.0     48.26     40.04   \n",
       "36      18530.0        134.0             13828.0     26.43     68.50   \n",
       "37          NaN         49.0             37272.0     33.70     58.75   \n",
       "38      22394.0        105.0             14929.0     27.49     59.26   \n",
       "39      26673.0         76.0             17899.0     62.22     30.03   \n",
       "40       8797.0        186.0              7142.0     47.83     44.87   \n",
       "41       3291.0        424.0              3105.0     46.98     46.61   \n",
       "42      14034.0        113.0              9315.0     54.41     38.90   \n",
       "43       9894.0        150.0              6596.0     35.75     56.17   \n",
       "44      21901.0         62.0             14483.0     53.09     41.72   \n",
       "45      11631.0        105.0              7754.0     31.74     61.53   \n",
       "46      17756.0         60.0             11837.0     36.55     51.28   \n",
       "47       7155.0        141.0              4770.0     27.23     62.96   \n",
       "48       4172.0        180.0              3476.0     56.68     30.27   \n",
       "49       9394.0         90.0              6263.0     21.63     67.40   \n",
       "\n",
       "     leg_dem   leg_rep  total_diff Abbreviation   Latitude   Longitude  \n",
       "0   0.750000  0.250000    0.165800           CA  36.116203 -119.681564  \n",
       "1   0.441989  0.558011    0.027444           TX  31.054487  -97.563461  \n",
       "2   0.685446  0.309859    0.123016           NY  42.165726  -74.948051  \n",
       "3   0.400000  0.600000    0.133100           FL  27.766279  -81.686783  \n",
       "4   0.644068  0.355932    0.101602           IL  40.349457  -88.986137  \n",
       "5   0.450593  0.545455    0.055834           PA  40.590752  -77.209755  \n",
       "6   0.356061  0.636364    0.139271           OH  40.388783  -82.764915  \n",
       "7   0.459459  0.540541    0.046011           MI  43.326618  -84.536095  \n",
       "8   0.406780  0.593220    0.092381           GA  33.040619  -83.643074  \n",
       "9   0.447059  0.547059    0.039021           NC  35.630066  -79.806419  \n",
       "10  0.625000  0.375000    0.092600           NJ  40.298904  -74.521011  \n",
       "11  0.542857  0.457143    0.052079           VA  37.769337  -78.169968  \n",
       "12  0.585034  0.414966    0.082967           WA  47.400902 -121.490494  \n",
       "13  0.805000  0.190000    0.273950           MA  42.230171  -71.530106  \n",
       "14  0.286667  0.706667    0.161667           IN  39.849426  -86.258278  \n",
       "15  0.466667  0.533333    0.038683           AZ  33.729759 -111.431221  \n",
       "16  0.234848  0.757576    0.187539           TN  35.747845  -86.692345  \n",
       "17  0.294416  0.700508    0.153388           MO  38.456085  -92.288368  \n",
       "18  0.696809  0.303191    0.111463           MD  39.063946  -76.802101  \n",
       "19  0.378788  0.621212    0.160218           WI  44.268543  -89.616508  \n",
       "20  0.532338  0.467662    0.077169           MN  45.694454  -93.900192  \n",
       "21  0.600000  0.400000    0.134650           CO  39.059811 -105.311104  \n",
       "22  0.257143  0.735714    0.143914           AL  32.806671  -86.791130  \n",
       "23  0.370588  0.629412    0.076118           SC  33.856892  -80.945007  \n",
       "24  0.333333  0.652778    0.087106           LA  31.169546  -91.867805  \n",
       "25  0.347826  0.652174    0.034513           KY  37.668140  -84.670067  \n",
       "26  0.622222  0.366667    0.133639           OR  44.572021 -122.070938  \n",
       "27  0.221477  0.778523    0.130485           OK  35.565342  -96.928917  \n",
       "28  0.604278  0.395722    0.065367           CT  41.597782  -72.755371  \n",
       "29  0.426667  0.566667    0.036850           IA  42.011539  -93.210526  \n",
       "30  0.356322  0.637931    0.074044           MS  32.741646  -89.678696  \n",
       "31  0.244444  0.748148    0.163280           AR  34.969704  -92.373123  \n",
       "32  0.315152  0.672727    0.098462           KS  38.526600  -96.726486  \n",
       "33  0.211538  0.788462    0.229592           UT  40.150032 -111.862434  \n",
       "34  0.650794  0.333333    0.232427           NV  38.313515 -117.055374  \n",
       "35  0.642857  0.357143    0.181886           NM  34.840515 -106.248482  \n",
       "36  0.410448  0.589552    0.193872           WV  38.491226  -80.954453  \n",
       "37  0.000000  0.000000    0.630750           NE  41.125370  -98.268082  \n",
       "38  0.200000  0.800000    0.178600           ID  44.240459 -114.478828  \n",
       "39  0.921053  0.078947    0.409529           HI  21.094318 -157.498337  \n",
       "40  0.591398  0.376344    0.149276           ME  44.693947  -69.381927  \n",
       "41  0.582547  0.412736    0.139429           NH  43.452492  -71.563896  \n",
       "42  0.876106  0.123894    0.464559           RI  41.680893  -71.511780  \n",
       "43  0.413333  0.586667    0.068317           MT  46.921925 -110.454353  \n",
       "44  0.612903  0.387097    0.097055           DE  39.318523  -75.507141  \n",
       "45  0.152381  0.847619    0.281179           SD  44.299782  -99.438828  \n",
       "46  0.366667  0.583333    0.036433           AK  61.370716 -152.404419  \n",
       "47  0.177305  0.822695    0.191543           ND  47.528912  -99.784012  \n",
       "48  0.650000  0.272222    0.098439           VT  44.045876  -72.710686  \n",
       "49  0.133333  0.855556    0.173744           WY  42.755966 -107.302490  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_geo = pd.read_csv('data\\geographic_centers_states.csv')\n",
    "df = df.merge(df_geo,on='State')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('data\\legislatures_clean.csv')"
   ]
  },
  {
   "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.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}