2008_Election.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "low_memory=False\n",
    "\n",
    "# file and import as df\n",
    "election_file = \"Resources/1976-2016-president.csv\"\n",
    "election_df = pd.read_csv(election_file)\n",
    "election_data_2008 = election_df.drop(columns = ['notes','version','writein','office','state_ic','state_cen','state_fips','state_po'])\n",
    "\n",
    "# getting the data I want to work with\n",
    "election_data_2008 = election_df[(election_df['year']==2008)&((election_df['candidate']=='McCain, John')|(election_df['candidate']=='Obama, Barack H.'))]\n",
    "election_data_2008 = election_data_2008.drop(columns = ['notes','version','writein','office','state_ic','state_cen','state_fips','state_po'])\n",
    "\n",
    "# total votes in 2008\n",
    "totalvotes_2008 = list(election_data_2008['totalvotes'].unique())\n",
    "\n",
    "# list of every state\n",
    "states = list(election_data_2008['state'].unique())\n",
    "\n",
    "# all the republican and democret votes for each state in order for 2008 and 2016\n",
    "republican_votes_2008 = list(election_data_2008[(election_data_2008['party']=='republican')&(election_data_2008['candidatevotes']>=5000)]['candidatevotes'])\n",
    "democrat_votes_2008 = list(election_data_2008[(election_data_2008['party']=='democrat')&(election_data_2008['candidatevotes']>=5000)]['candidatevotes'])\n",
    "\n",
    "# dictionary for my data frame\n",
    "election_dict_2008 = {\n",
    "    \"State\":states,\n",
    "    \"Republican Votes 2008\":republican_votes_2008,\n",
    "    \"Democrat Votes 2008\":democrat_votes_2008,\n",
    "    \"Total Votes 2008\":totalvotes_2008,\n",
    "}\n",
    "\n",
    "clean_election_data_2008 = pd.DataFrame.from_dict(election_dict_2008)\n",
    "\n",
    "# getting the percentage of republican votes and democrat votes for each year\n",
    "\n",
    "# initialize all the lists for percents\n",
    "republican_percent_2008 = []\n",
    "democrat_percent_2008 = []\n",
    "\n",
    "# for loop for all the percentages\n",
    "for i in range(51):\n",
    "    republican_percent_2008.append(round((republican_votes_2008[i]/totalvotes_2008[i])*100,2))\n",
    "    democrat_percent_2008.append(round((democrat_votes_2008[i]/totalvotes_2008[i])*100,2))\n",
    "\n",
    "\n",
    "# add all my sick new data to my clean data frame\n",
    "clean_election_data_2008['Republican Vote Percentage 2008'] = republican_percent_2008\n",
    "clean_election_data_2008['Democrat Vote Percentage 2008'] = democrat_percent_2008\n",
    "\n",
    "state_politics_2008 = []\n",
    "\n",
    "for i in range(51):\n",
    "    if (republican_percent_2008[i] > democrat_percent_2008[i]):\n",
    "        if (republican_percent_2008[i] >= 60):\n",
    "            state_politics_2008.append(\"Hard Right\")\n",
    "        else:\n",
    "            state_politics_2008.append(\"Middle Right\")\n",
    "            \n",
    "    if (republican_percent_2008[i] < democrat_percent_2008[i]):\n",
    "        if (democrat_percent_2008[i] >= 60):\n",
    "            state_politics_2008.append(\"Hard Left\")\n",
    "        else:\n",
    "            state_politics_2008.append(\"Middle Left\")\n",
    "\n",
    "clean_election_data_2008.insert(loc=1, column='Voting Affiliation 2008', value=state_politics_2008)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "clean_election_data_2008.to_csv(\"Resources/ElectionData2008\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>State</th>\n",
       "      <th>Voting Affiliation 2008</th>\n",
       "      <th>Republican Votes 2008</th>\n",
       "      <th>Democrat Votes 2008</th>\n",
       "      <th>Total Votes 2008</th>\n",
       "      <th>Republican Vote Percentage 2008</th>\n",
       "      <th>Democrat Vote Percentage 2008</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Hard Right</td>\n",
       "      <td>1266546</td>\n",
       "      <td>813479</td>\n",
       "      <td>2099819</td>\n",
       "      <td>60.32</td>\n",
       "      <td>38.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>193841</td>\n",
       "      <td>123594</td>\n",
       "      <td>326197</td>\n",
       "      <td>59.42</td>\n",
       "      <td>37.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>1230111</td>\n",
       "      <td>1034707</td>\n",
       "      <td>2293475</td>\n",
       "      <td>53.64</td>\n",
       "      <td>45.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>638017</td>\n",
       "      <td>422310</td>\n",
       "      <td>1086617</td>\n",
       "      <td>58.72</td>\n",
       "      <td>38.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>California</td>\n",
       "      <td>Hard Left</td>\n",
       "      <td>5011781</td>\n",
       "      <td>8274473</td>\n",
       "      <td>13561900</td>\n",
       "      <td>36.95</td>\n",
       "      <td>61.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Colorado</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>1073589</td>\n",
       "      <td>1288576</td>\n",
       "      <td>2401361</td>\n",
       "      <td>44.71</td>\n",
       "      <td>53.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Connecticut</td>\n",
       "      <td>Hard Left</td>\n",
       "      <td>629428</td>\n",
       "      <td>997772</td>\n",
       "      <td>1646792</td>\n",
       "      <td>38.22</td>\n",
       "      <td>60.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Delaware</td>\n",
       "      <td>Hard Left</td>\n",
       "      <td>152374</td>\n",
       "      <td>255459</td>\n",
       "      <td>412412</td>\n",
       "      <td>36.95</td>\n",
       "      <td>61.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>District of Columbia</td>\n",
       "      <td>Hard Left</td>\n",
       "      <td>17367</td>\n",
       "      <td>245800</td>\n",
       "      <td>265853</td>\n",
       "      <td>6.53</td>\n",
       "      <td>92.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Florida</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>4045624</td>\n",
       "      <td>4282074</td>\n",
       "      <td>8390744</td>\n",
       "      <td>48.22</td>\n",
       "      <td>51.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>2048759</td>\n",
       "      <td>1844123</td>\n",
       "      <td>3924486</td>\n",
       "      <td>52.20</td>\n",
       "      <td>46.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Hawaii</td>\n",
       "      <td>Hard Left</td>\n",
       "      <td>120566</td>\n",
       "      <td>325871</td>\n",
       "      <td>456064</td>\n",
       "      <td>26.44</td>\n",
       "      <td>71.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Idaho</td>\n",
       "      <td>Hard Right</td>\n",
       "      <td>403012</td>\n",
       "      <td>236440</td>\n",
       "      <td>655122</td>\n",
       "      <td>61.52</td>\n",
       "      <td>36.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Illinois</td>\n",
       "      <td>Hard Left</td>\n",
       "      <td>2031179</td>\n",
       "      <td>3419348</td>\n",
       "      <td>5522371</td>\n",
       "      <td>36.78</td>\n",
       "      <td>61.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Indiana</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>1345648</td>\n",
       "      <td>1374039</td>\n",
       "      <td>2751054</td>\n",
       "      <td>48.91</td>\n",
       "      <td>49.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>682379</td>\n",
       "      <td>828940</td>\n",
       "      <td>1537123</td>\n",
       "      <td>44.39</td>\n",
       "      <td>53.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kansas</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>699655</td>\n",
       "      <td>514765</td>\n",
       "      <td>1235872</td>\n",
       "      <td>56.61</td>\n",
       "      <td>41.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Kentucky</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>1048462</td>\n",
       "      <td>751985</td>\n",
       "      <td>1826620</td>\n",
       "      <td>57.40</td>\n",
       "      <td>41.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Louisiana</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>1148275</td>\n",
       "      <td>782989</td>\n",
       "      <td>1960761</td>\n",
       "      <td>58.56</td>\n",
       "      <td>39.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Maine</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>295273</td>\n",
       "      <td>421923</td>\n",
       "      <td>731163</td>\n",
       "      <td>40.38</td>\n",
       "      <td>57.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>Hard Left</td>\n",
       "      <td>959862</td>\n",
       "      <td>1629467</td>\n",
       "      <td>2631596</td>\n",
       "      <td>36.47</td>\n",
       "      <td>61.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>Hard Left</td>\n",
       "      <td>1108854</td>\n",
       "      <td>1904097</td>\n",
       "      <td>3102995</td>\n",
       "      <td>35.73</td>\n",
       "      <td>61.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>2048639</td>\n",
       "      <td>2872579</td>\n",
       "      <td>5001596</td>\n",
       "      <td>40.96</td>\n",
       "      <td>57.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Minnesota</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>1275409</td>\n",
       "      <td>1573354</td>\n",
       "      <td>2910369</td>\n",
       "      <td>43.82</td>\n",
       "      <td>54.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Mississippi</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>724597</td>\n",
       "      <td>554662</td>\n",
       "      <td>1289865</td>\n",
       "      <td>56.18</td>\n",
       "      <td>43.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Missouri</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>1445814</td>\n",
       "      <td>1441911</td>\n",
       "      <td>2925205</td>\n",
       "      <td>49.43</td>\n",
       "      <td>49.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Montana</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>242763</td>\n",
       "      <td>231667</td>\n",
       "      <td>490109</td>\n",
       "      <td>49.53</td>\n",
       "      <td>47.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Nebraska</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>452979</td>\n",
       "      <td>333319</td>\n",
       "      <td>801281</td>\n",
       "      <td>56.53</td>\n",
       "      <td>41.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Nevada</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>412827</td>\n",
       "      <td>533736</td>\n",
       "      <td>967848</td>\n",
       "      <td>42.65</td>\n",
       "      <td>55.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>New Hampshire</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>316534</td>\n",
       "      <td>384826</td>\n",
       "      <td>710970</td>\n",
       "      <td>44.52</td>\n",
       "      <td>54.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>New Jersey</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>1613207</td>\n",
       "      <td>2215422</td>\n",
       "      <td>3868237</td>\n",
       "      <td>41.70</td>\n",
       "      <td>57.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>New Mexico</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>346832</td>\n",
       "      <td>472422</td>\n",
       "      <td>830158</td>\n",
       "      <td>41.78</td>\n",
       "      <td>56.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>New York</td>\n",
       "      <td>Hard Left</td>\n",
       "      <td>2418323</td>\n",
       "      <td>4645332</td>\n",
       "      <td>7722019</td>\n",
       "      <td>31.32</td>\n",
       "      <td>60.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>North Carolina</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>2128474</td>\n",
       "      <td>2142651</td>\n",
       "      <td>4310851</td>\n",
       "      <td>49.37</td>\n",
       "      <td>49.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>North Dakota</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>168601</td>\n",
       "      <td>141278</td>\n",
       "      <td>316621</td>\n",
       "      <td>53.25</td>\n",
       "      <td>44.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Ohio</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>2677820</td>\n",
       "      <td>2940044</td>\n",
       "      <td>5708350</td>\n",
       "      <td>46.91</td>\n",
       "      <td>51.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>Hard Right</td>\n",
       "      <td>960165</td>\n",
       "      <td>502496</td>\n",
       "      <td>1462661</td>\n",
       "      <td>65.65</td>\n",
       "      <td>34.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Oregon</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>738475</td>\n",
       "      <td>1037291</td>\n",
       "      <td>1827864</td>\n",
       "      <td>40.40</td>\n",
       "      <td>56.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>2655885</td>\n",
       "      <td>3276363</td>\n",
       "      <td>6013272</td>\n",
       "      <td>44.17</td>\n",
       "      <td>54.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>Hard Left</td>\n",
       "      <td>165391</td>\n",
       "      <td>296571</td>\n",
       "      <td>471766</td>\n",
       "      <td>35.06</td>\n",
       "      <td>62.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>South Carolina</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>1034896</td>\n",
       "      <td>862449</td>\n",
       "      <td>1920969</td>\n",
       "      <td>53.87</td>\n",
       "      <td>44.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>203054</td>\n",
       "      <td>170924</td>\n",
       "      <td>381975</td>\n",
       "      <td>53.16</td>\n",
       "      <td>44.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Tennessee</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>1479178</td>\n",
       "      <td>1087437</td>\n",
       "      <td>2599749</td>\n",
       "      <td>56.90</td>\n",
       "      <td>41.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Texas</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>4479328</td>\n",
       "      <td>3528633</td>\n",
       "      <td>8077795</td>\n",
       "      <td>55.45</td>\n",
       "      <td>43.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Utah</td>\n",
       "      <td>Hard Right</td>\n",
       "      <td>596030</td>\n",
       "      <td>327670</td>\n",
       "      <td>952370</td>\n",
       "      <td>62.58</td>\n",
       "      <td>34.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Vermont</td>\n",
       "      <td>Hard Left</td>\n",
       "      <td>98974</td>\n",
       "      <td>219262</td>\n",
       "      <td>325046</td>\n",
       "      <td>30.45</td>\n",
       "      <td>67.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>1725005</td>\n",
       "      <td>1959532</td>\n",
       "      <td>3723260</td>\n",
       "      <td>46.33</td>\n",
       "      <td>52.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Washington</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>1229216</td>\n",
       "      <td>1750848</td>\n",
       "      <td>3036878</td>\n",
       "      <td>40.48</td>\n",
       "      <td>57.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>Middle Right</td>\n",
       "      <td>397466</td>\n",
       "      <td>303857</td>\n",
       "      <td>713451</td>\n",
       "      <td>55.71</td>\n",
       "      <td>42.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Middle Left</td>\n",
       "      <td>1262393</td>\n",
       "      <td>1677211</td>\n",
       "      <td>2983417</td>\n",
       "      <td>42.31</td>\n",
       "      <td>56.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Hard Right</td>\n",
       "      <td>164958</td>\n",
       "      <td>82868</td>\n",
       "      <td>254904</td>\n",
       "      <td>64.71</td>\n",
       "      <td>32.51</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   State Voting Affiliation 2008  Republican Votes 2008  \\\n",
       "0                Alabama              Hard Right                1266546   \n",
       "1                 Alaska            Middle Right                 193841   \n",
       "2                Arizona            Middle Right                1230111   \n",
       "3               Arkansas            Middle Right                 638017   \n",
       "4             California               Hard Left                5011781   \n",
       "5               Colorado             Middle Left                1073589   \n",
       "6            Connecticut               Hard Left                 629428   \n",
       "7               Delaware               Hard Left                 152374   \n",
       "8   District of Columbia               Hard Left                  17367   \n",
       "9                Florida             Middle Left                4045624   \n",
       "10               Georgia            Middle Right                2048759   \n",
       "11                Hawaii               Hard Left                 120566   \n",
       "12                 Idaho              Hard Right                 403012   \n",
       "13              Illinois               Hard Left                2031179   \n",
       "14               Indiana             Middle Left                1345648   \n",
       "15                  Iowa             Middle Left                 682379   \n",
       "16                Kansas            Middle Right                 699655   \n",
       "17              Kentucky            Middle Right                1048462   \n",
       "18             Louisiana            Middle Right                1148275   \n",
       "19                 Maine             Middle Left                 295273   \n",
       "20              Maryland               Hard Left                 959862   \n",
       "21         Massachusetts               Hard Left                1108854   \n",
       "22              Michigan             Middle Left                2048639   \n",
       "23             Minnesota             Middle Left                1275409   \n",
       "24           Mississippi            Middle Right                 724597   \n",
       "25              Missouri            Middle Right                1445814   \n",
       "26               Montana            Middle Right                 242763   \n",
       "27              Nebraska            Middle Right                 452979   \n",
       "28                Nevada             Middle Left                 412827   \n",
       "29         New Hampshire             Middle Left                 316534   \n",
       "30            New Jersey             Middle Left                1613207   \n",
       "31            New Mexico             Middle Left                 346832   \n",
       "32              New York               Hard Left                2418323   \n",
       "33        North Carolina             Middle Left                2128474   \n",
       "34          North Dakota            Middle Right                 168601   \n",
       "35                  Ohio             Middle Left                2677820   \n",
       "36              Oklahoma              Hard Right                 960165   \n",
       "37                Oregon             Middle Left                 738475   \n",
       "38          Pennsylvania             Middle Left                2655885   \n",
       "39          Rhode Island               Hard Left                 165391   \n",
       "40        South Carolina            Middle Right                1034896   \n",
       "41          South Dakota            Middle Right                 203054   \n",
       "42             Tennessee            Middle Right                1479178   \n",
       "43                 Texas            Middle Right                4479328   \n",
       "44                  Utah              Hard Right                 596030   \n",
       "45               Vermont               Hard Left                  98974   \n",
       "46              Virginia             Middle Left                1725005   \n",
       "47            Washington             Middle Left                1229216   \n",
       "48         West Virginia            Middle Right                 397466   \n",
       "49             Wisconsin             Middle Left                1262393   \n",
       "50               Wyoming              Hard Right                 164958   \n",
       "\n",
       "    Democrat Votes 2008  Total Votes 2008  Republican Vote Percentage 2008  \\\n",
       "0                813479           2099819                            60.32   \n",
       "1                123594            326197                            59.42   \n",
       "2               1034707           2293475                            53.64   \n",
       "3                422310           1086617                            58.72   \n",
       "4               8274473          13561900                            36.95   \n",
       "5               1288576           2401361                            44.71   \n",
       "6                997772           1646792                            38.22   \n",
       "7                255459            412412                            36.95   \n",
       "8                245800            265853                             6.53   \n",
       "9               4282074           8390744                            48.22   \n",
       "10              1844123           3924486                            52.20   \n",
       "11               325871            456064                            26.44   \n",
       "12               236440            655122                            61.52   \n",
       "13              3419348           5522371                            36.78   \n",
       "14              1374039           2751054                            48.91   \n",
       "15               828940           1537123                            44.39   \n",
       "16               514765           1235872                            56.61   \n",
       "17               751985           1826620                            57.40   \n",
       "18               782989           1960761                            58.56   \n",
       "19               421923            731163                            40.38   \n",
       "20              1629467           2631596                            36.47   \n",
       "21              1904097           3102995                            35.73   \n",
       "22              2872579           5001596                            40.96   \n",
       "23              1573354           2910369                            43.82   \n",
       "24               554662           1289865                            56.18   \n",
       "25              1441911           2925205                            49.43   \n",
       "26               231667            490109                            49.53   \n",
       "27               333319            801281                            56.53   \n",
       "28               533736            967848                            42.65   \n",
       "29               384826            710970                            44.52   \n",
       "30              2215422           3868237                            41.70   \n",
       "31               472422            830158                            41.78   \n",
       "32              4645332           7722019                            31.32   \n",
       "33              2142651           4310851                            49.37   \n",
       "34               141278            316621                            53.25   \n",
       "35              2940044           5708350                            46.91   \n",
       "36               502496           1462661                            65.65   \n",
       "37              1037291           1827864                            40.40   \n",
       "38              3276363           6013272                            44.17   \n",
       "39               296571            471766                            35.06   \n",
       "40               862449           1920969                            53.87   \n",
       "41               170924            381975                            53.16   \n",
       "42              1087437           2599749                            56.90   \n",
       "43              3528633           8077795                            55.45   \n",
       "44               327670            952370                            62.58   \n",
       "45               219262            325046                            30.45   \n",
       "46              1959532           3723260                            46.33   \n",
       "47              1750848           3036878                            40.48   \n",
       "48               303857            713451                            55.71   \n",
       "49              1677211           2983417                            42.31   \n",
       "50                82868            254904                            64.71   \n",
       "\n",
       "    Democrat Vote Percentage 2008  \n",
       "0                           38.74  \n",
       "1                           37.89  \n",
       "2                           45.12  \n",
       "3                           38.86  \n",
       "4                           61.01  \n",
       "5                           53.66  \n",
       "6                           60.59  \n",
       "7                           61.94  \n",
       "8                           92.46  \n",
       "9                           51.03  \n",
       "10                          46.99  \n",
       "11                          71.45  \n",
       "12                          36.09  \n",
       "13                          61.92  \n",
       "14                          49.95  \n",
       "15                          53.93  \n",
       "16                          41.65  \n",
       "17                          41.17  \n",
       "18                          39.93  \n",
       "19                          57.71  \n",
       "20                          61.92  \n",
       "21                          61.36  \n",
       "22                          57.43  \n",
       "23                          54.06  \n",
       "24                          43.00  \n",
       "25                          49.29  \n",
       "26                          47.27  \n",
       "27                          41.60  \n",
       "28                          55.15  \n",
       "29                          54.13  \n",
       "30                          57.27  \n",
       "31                          56.91  \n",
       "32                          60.16  \n",
       "33                          49.70  \n",
       "34                          44.62  \n",
       "35                          51.50  \n",
       "36                          34.35  \n",
       "37                          56.75  \n",
       "38                          54.49  \n",
       "39                          62.86  \n",
       "40                          44.90  \n",
       "41                          44.75  \n",
       "42                          41.83  \n",
       "43                          43.68  \n",
       "44                          34.41  \n",
       "45                          67.46  \n",
       "46                          52.63  \n",
       "47                          57.65  \n",
       "48                          42.59  \n",
       "49                          56.22  \n",
       "50                          32.51  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clean_election_data_2008"
   ]
  },
  {
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}