FinalVax.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "cc622743",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "14ca6eac",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv (\"./FinalVax.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a07bbbcf",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df.columns)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "e604f2b8",
   "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>Total Doses Delivered</th>\n",
       "      <th>Total Doses Administered by State where Administered</th>\n",
       "      <th>People with at least One Dose by State of Residence</th>\n",
       "      <th>Percent of Total Pop with at least One Dose by State of Residence</th>\n",
       "      <th>People Fully Vaccinated by State of Residence</th>\n",
       "      <th>Percent of Total Pop Fully Vaccinated by State of Residence</th>\n",
       "      <th>Percent of Total Pop with over 1 Dose by State of Residence</th>\n",
       "      <th>People who have received a booster dose</th>\n",
       "      <th>Percent of fully vaccinated people with booster doses</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>9344040</td>\n",
       "      <td>6136613</td>\n",
       "      <td>3045967</td>\n",
       "      <td>62</td>\n",
       "      <td>2476199</td>\n",
       "      <td>51</td>\n",
       "      <td>62</td>\n",
       "      <td>858145</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>1464865</td>\n",
       "      <td>1108025</td>\n",
       "      <td>504539</td>\n",
       "      <td>69</td>\n",
       "      <td>449359</td>\n",
       "      <td>61</td>\n",
       "      <td>69</td>\n",
       "      <td>188122</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>14211920</td>\n",
       "      <td>11656237</td>\n",
       "      <td>5232140</td>\n",
       "      <td>72</td>\n",
       "      <td>4404914</td>\n",
       "      <td>61</td>\n",
       "      <td>72</td>\n",
       "      <td>1769853</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>5921480</td>\n",
       "      <td>4115448</td>\n",
       "      <td>1991116</td>\n",
       "      <td>66</td>\n",
       "      <td>1622985</td>\n",
       "      <td>54</td>\n",
       "      <td>66</td>\n",
       "      <td>621175</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>California</td>\n",
       "      <td>86699025</td>\n",
       "      <td>72203934</td>\n",
       "      <td>32494180</td>\n",
       "      <td>82</td>\n",
       "      <td>28000511</td>\n",
       "      <td>71</td>\n",
       "      <td>82</td>\n",
       "      <td>13728499</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Colorado</td>\n",
       "      <td>11965375</td>\n",
       "      <td>10392018</td>\n",
       "      <td>4529548</td>\n",
       "      <td>79</td>\n",
       "      <td>4004711</td>\n",
       "      <td>70</td>\n",
       "      <td>79</td>\n",
       "      <td>2021778</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Connecticut</td>\n",
       "      <td>8381735</td>\n",
       "      <td>7349027</td>\n",
       "      <td>3363017</td>\n",
       "      <td>94</td>\n",
       "      <td>2786396</td>\n",
       "      <td>78</td>\n",
       "      <td>94</td>\n",
       "      <td>1402029</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Delaware</td>\n",
       "      <td>2243655</td>\n",
       "      <td>1746240</td>\n",
       "      <td>799668</td>\n",
       "      <td>82</td>\n",
       "      <td>662698</td>\n",
       "      <td>68</td>\n",
       "      <td>82</td>\n",
       "      <td>292626</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>District of Columbia</td>\n",
       "      <td>1796405</td>\n",
       "      <td>1434113</td>\n",
       "      <td>677127</td>\n",
       "      <td>95</td>\n",
       "      <td>508530</td>\n",
       "      <td>72</td>\n",
       "      <td>95</td>\n",
       "      <td>180651</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Florida</td>\n",
       "      <td>46078085</td>\n",
       "      <td>36344605</td>\n",
       "      <td>16829431</td>\n",
       "      <td>78</td>\n",
       "      <td>14223127</td>\n",
       "      <td>66</td>\n",
       "      <td>78</td>\n",
       "      <td>5522219</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>20870895</td>\n",
       "      <td>14485449</td>\n",
       "      <td>6867234</td>\n",
       "      <td>65</td>\n",
       "      <td>5733124</td>\n",
       "      <td>54</td>\n",
       "      <td>65</td>\n",
       "      <td>2043030</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Hawaii</td>\n",
       "      <td>3337580</td>\n",
       "      <td>2826157</td>\n",
       "      <td>1228270</td>\n",
       "      <td>87</td>\n",
       "      <td>1098640</td>\n",
       "      <td>78</td>\n",
       "      <td>87</td>\n",
       "      <td>549481</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Idaho</td>\n",
       "      <td>3247090</td>\n",
       "      <td>2382727</td>\n",
       "      <td>1082047</td>\n",
       "      <td>61</td>\n",
       "      <td>954547</td>\n",
       "      <td>53</td>\n",
       "      <td>61</td>\n",
       "      <td>392782</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Illinois</td>\n",
       "      <td>26377145</td>\n",
       "      <td>21946996</td>\n",
       "      <td>9668434</td>\n",
       "      <td>76</td>\n",
       "      <td>8609660</td>\n",
       "      <td>68</td>\n",
       "      <td>76</td>\n",
       "      <td>4275249</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Indiana</td>\n",
       "      <td>12771980</td>\n",
       "      <td>9265595</td>\n",
       "      <td>4100631</td>\n",
       "      <td>61</td>\n",
       "      <td>3656889</td>\n",
       "      <td>54</td>\n",
       "      <td>61</td>\n",
       "      <td>1629049</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>6318955</td>\n",
       "      <td>4952757</td>\n",
       "      <td>2128809</td>\n",
       "      <td>68</td>\n",
       "      <td>1936322</td>\n",
       "      <td>61</td>\n",
       "      <td>68</td>\n",
       "      <td>1007372</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kansas</td>\n",
       "      <td>5790715</td>\n",
       "      <td>4478344</td>\n",
       "      <td>2150241</td>\n",
       "      <td>74</td>\n",
       "      <td>1765693</td>\n",
       "      <td>61</td>\n",
       "      <td>74</td>\n",
       "      <td>736536</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Kentucky</td>\n",
       "      <td>8498075</td>\n",
       "      <td>6364830</td>\n",
       "      <td>2929634</td>\n",
       "      <td>66</td>\n",
       "      <td>2536474</td>\n",
       "      <td>57</td>\n",
       "      <td>66</td>\n",
       "      <td>1097242</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Louisiana</td>\n",
       "      <td>7962650</td>\n",
       "      <td>6110191</td>\n",
       "      <td>2812222</td>\n",
       "      <td>61</td>\n",
       "      <td>2461340</td>\n",
       "      <td>53</td>\n",
       "      <td>61</td>\n",
       "      <td>945301</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Maine</td>\n",
       "      <td>3216350</td>\n",
       "      <td>2719394</td>\n",
       "      <td>1200174</td>\n",
       "      <td>89</td>\n",
       "      <td>1056524</td>\n",
       "      <td>79</td>\n",
       "      <td>89</td>\n",
       "      <td>573366</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>15162870</td>\n",
       "      <td>11606157</td>\n",
       "      <td>5156516</td>\n",
       "      <td>85</td>\n",
       "      <td>4499863</td>\n",
       "      <td>74</td>\n",
       "      <td>85</td>\n",
       "      <td>2221431</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>16318310</td>\n",
       "      <td>14371860</td>\n",
       "      <td>6679344</td>\n",
       "      <td>95</td>\n",
       "      <td>5374123</td>\n",
       "      <td>78</td>\n",
       "      <td>95</td>\n",
       "      <td>2687779</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>20226510</td>\n",
       "      <td>15389332</td>\n",
       "      <td>6636918</td>\n",
       "      <td>67</td>\n",
       "      <td>5950255</td>\n",
       "      <td>60</td>\n",
       "      <td>67</td>\n",
       "      <td>3161199</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Minnesota</td>\n",
       "      <td>12064730</td>\n",
       "      <td>9968531</td>\n",
       "      <td>4204685</td>\n",
       "      <td>75</td>\n",
       "      <td>3866020</td>\n",
       "      <td>69</td>\n",
       "      <td>75</td>\n",
       "      <td>2176562</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Mississippi</td>\n",
       "      <td>5345915</td>\n",
       "      <td>3787172</td>\n",
       "      <td>1757143</td>\n",
       "      <td>59</td>\n",
       "      <td>1525309</td>\n",
       "      <td>51</td>\n",
       "      <td>59</td>\n",
       "      <td>552378</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Missouri</td>\n",
       "      <td>11164905</td>\n",
       "      <td>8711919</td>\n",
       "      <td>4026372</td>\n",
       "      <td>66</td>\n",
       "      <td>3400392</td>\n",
       "      <td>55</td>\n",
       "      <td>66</td>\n",
       "      <td>1406296</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Montana</td>\n",
       "      <td>1896595</td>\n",
       "      <td>1543262</td>\n",
       "      <td>691222</td>\n",
       "      <td>65</td>\n",
       "      <td>600400</td>\n",
       "      <td>56</td>\n",
       "      <td>65</td>\n",
       "      <td>279829</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Nebraska</td>\n",
       "      <td>3800810</td>\n",
       "      <td>3101078</td>\n",
       "      <td>1346242</td>\n",
       "      <td>70</td>\n",
       "      <td>1214628</td>\n",
       "      <td>63</td>\n",
       "      <td>70</td>\n",
       "      <td>591116</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Nevada</td>\n",
       "      <td>5722810</td>\n",
       "      <td>4765079</td>\n",
       "      <td>2291011</td>\n",
       "      <td>74</td>\n",
       "      <td>1849339</td>\n",
       "      <td>60</td>\n",
       "      <td>74</td>\n",
       "      <td>694192</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>New Hampshire</td>\n",
       "      <td>3317930</td>\n",
       "      <td>2542697</td>\n",
       "      <td>1321982</td>\n",
       "      <td>95</td>\n",
       "      <td>944421</td>\n",
       "      <td>70</td>\n",
       "      <td>95</td>\n",
       "      <td>283995</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>New Jersey</td>\n",
       "      <td>21176855</td>\n",
       "      <td>16700701</td>\n",
       "      <td>7944016</td>\n",
       "      <td>89</td>\n",
       "      <td>6632578</td>\n",
       "      <td>75</td>\n",
       "      <td>89</td>\n",
       "      <td>3043351</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>New Mexico</td>\n",
       "      <td>4284245</td>\n",
       "      <td>3799157</td>\n",
       "      <td>1811658</td>\n",
       "      <td>86</td>\n",
       "      <td>1468726</td>\n",
       "      <td>70</td>\n",
       "      <td>86</td>\n",
       "      <td>711781</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>New York</td>\n",
       "      <td>44392845</td>\n",
       "      <td>38129707</td>\n",
       "      <td>17376730</td>\n",
       "      <td>89</td>\n",
       "      <td>14766854</td>\n",
       "      <td>76</td>\n",
       "      <td>89</td>\n",
       "      <td>6566936</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>North Carolina</td>\n",
       "      <td>21096800</td>\n",
       "      <td>16246060</td>\n",
       "      <td>8681622</td>\n",
       "      <td>83</td>\n",
       "      <td>6258995</td>\n",
       "      <td>60</td>\n",
       "      <td>83</td>\n",
       "      <td>1608180</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>North Dakota</td>\n",
       "      <td>1318100</td>\n",
       "      <td>1065896</td>\n",
       "      <td>491967</td>\n",
       "      <td>65</td>\n",
       "      <td>415744</td>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "      <td>167398</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Ohio</td>\n",
       "      <td>22154955</td>\n",
       "      <td>17330784</td>\n",
       "      <td>7373720</td>\n",
       "      <td>63</td>\n",
       "      <td>6763928</td>\n",
       "      <td>58</td>\n",
       "      <td>63</td>\n",
       "      <td>3439399</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>7034930</td>\n",
       "      <td>5755924</td>\n",
       "      <td>2780004</td>\n",
       "      <td>70</td>\n",
       "      <td>2228871</td>\n",
       "      <td>56</td>\n",
       "      <td>70</td>\n",
       "      <td>815159</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Oregon</td>\n",
       "      <td>9613085</td>\n",
       "      <td>7499331</td>\n",
       "      <td>3257811</td>\n",
       "      <td>77</td>\n",
       "      <td>2909059</td>\n",
       "      <td>69</td>\n",
       "      <td>77</td>\n",
       "      <td>1512421</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>29098425</td>\n",
       "      <td>22243436</td>\n",
       "      <td>10717480</td>\n",
       "      <td>84</td>\n",
       "      <td>8621690</td>\n",
       "      <td>67</td>\n",
       "      <td>84</td>\n",
       "      <td>3579552</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>2506925</td>\n",
       "      <td>2146406</td>\n",
       "      <td>1027413</td>\n",
       "      <td>95</td>\n",
       "      <td>860233</td>\n",
       "      <td>81</td>\n",
       "      <td>95</td>\n",
       "      <td>447622</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>South Carolina</td>\n",
       "      <td>10094075</td>\n",
       "      <td>7341961</td>\n",
       "      <td>3447431</td>\n",
       "      <td>67</td>\n",
       "      <td>2901702</td>\n",
       "      <td>56</td>\n",
       "      <td>67</td>\n",
       "      <td>1125068</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>1781165</td>\n",
       "      <td>1365121</td>\n",
       "      <td>666057</td>\n",
       "      <td>75</td>\n",
       "      <td>533114</td>\n",
       "      <td>60</td>\n",
       "      <td>75</td>\n",
       "      <td>215305</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Tennessee</td>\n",
       "      <td>12372730</td>\n",
       "      <td>9665002</td>\n",
       "      <td>4204484</td>\n",
       "      <td>62</td>\n",
       "      <td>3677363</td>\n",
       "      <td>54</td>\n",
       "      <td>62</td>\n",
       "      <td>1572539</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Texas</td>\n",
       "      <td>59477235</td>\n",
       "      <td>44868529</td>\n",
       "      <td>20783338</td>\n",
       "      <td>72</td>\n",
       "      <td>17538002</td>\n",
       "      <td>61</td>\n",
       "      <td>72</td>\n",
       "      <td>6356771</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Utah</td>\n",
       "      <td>6049150</td>\n",
       "      <td>5100934</td>\n",
       "      <td>2291082</td>\n",
       "      <td>72</td>\n",
       "      <td>2038829</td>\n",
       "      <td>64</td>\n",
       "      <td>72</td>\n",
       "      <td>883340</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Vermont</td>\n",
       "      <td>1711950</td>\n",
       "      <td>1354989</td>\n",
       "      <td>578479</td>\n",
       "      <td>93</td>\n",
       "      <td>501868</td>\n",
       "      <td>80</td>\n",
       "      <td>93</td>\n",
       "      <td>296252</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>18921725</td>\n",
       "      <td>15986497</td>\n",
       "      <td>7237259</td>\n",
       "      <td>85</td>\n",
       "      <td>6173036</td>\n",
       "      <td>72</td>\n",
       "      <td>85</td>\n",
       "      <td>2849860</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Washington</td>\n",
       "      <td>17012895</td>\n",
       "      <td>13963937</td>\n",
       "      <td>6097229</td>\n",
       "      <td>80</td>\n",
       "      <td>5468432</td>\n",
       "      <td>72</td>\n",
       "      <td>80</td>\n",
       "      <td>2775875</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>3892945</td>\n",
       "      <td>2649826</td>\n",
       "      <td>1154492</td>\n",
       "      <td>64</td>\n",
       "      <td>1021806</td>\n",
       "      <td>57</td>\n",
       "      <td>64</td>\n",
       "      <td>455962</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>11169245</td>\n",
       "      <td>9933799</td>\n",
       "      <td>4150489</td>\n",
       "      <td>71</td>\n",
       "      <td>3778622</td>\n",
       "      <td>65</td>\n",
       "      <td>71</td>\n",
       "      <td>2078078</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Wyoming</td>\n",
       "      <td>942285</td>\n",
       "      <td>735005</td>\n",
       "      <td>336848</td>\n",
       "      <td>58</td>\n",
       "      <td>294355</td>\n",
       "      <td>51</td>\n",
       "      <td>58</td>\n",
       "      <td>123659</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   State  Total Doses Delivered  \\\n",
       "0                Alabama                9344040   \n",
       "1                 Alaska                1464865   \n",
       "2                Arizona               14211920   \n",
       "3               Arkansas                5921480   \n",
       "4             California               86699025   \n",
       "5               Colorado               11965375   \n",
       "6            Connecticut                8381735   \n",
       "7               Delaware                2243655   \n",
       "8   District of Columbia                1796405   \n",
       "9                Florida               46078085   \n",
       "10               Georgia               20870895   \n",
       "11                Hawaii                3337580   \n",
       "12                 Idaho                3247090   \n",
       "13              Illinois               26377145   \n",
       "14               Indiana               12771980   \n",
       "15                  Iowa                6318955   \n",
       "16                Kansas                5790715   \n",
       "17              Kentucky                8498075   \n",
       "18             Louisiana                7962650   \n",
       "19                 Maine                3216350   \n",
       "20              Maryland               15162870   \n",
       "21         Massachusetts               16318310   \n",
       "22              Michigan               20226510   \n",
       "23             Minnesota               12064730   \n",
       "24           Mississippi                5345915   \n",
       "25              Missouri               11164905   \n",
       "26               Montana                1896595   \n",
       "27              Nebraska                3800810   \n",
       "28                Nevada                5722810   \n",
       "29         New Hampshire                3317930   \n",
       "30            New Jersey               21176855   \n",
       "31            New Mexico                4284245   \n",
       "32              New York               44392845   \n",
       "33        North Carolina               21096800   \n",
       "34          North Dakota                1318100   \n",
       "35                  Ohio               22154955   \n",
       "36              Oklahoma                7034930   \n",
       "37                Oregon                9613085   \n",
       "38          Pennsylvania               29098425   \n",
       "39          Rhode Island                2506925   \n",
       "40        South Carolina               10094075   \n",
       "41          South Dakota                1781165   \n",
       "42             Tennessee               12372730   \n",
       "43                 Texas               59477235   \n",
       "44                  Utah                6049150   \n",
       "45               Vermont                1711950   \n",
       "46              Virginia               18921725   \n",
       "47            Washington               17012895   \n",
       "48         West Virginia                3892945   \n",
       "49             Wisconsin               11169245   \n",
       "50               Wyoming                 942285   \n",
       "\n",
       "    Total Doses Administered by State where Administered  \\\n",
       "0                                             6136613      \n",
       "1                                             1108025      \n",
       "2                                            11656237      \n",
       "3                                             4115448      \n",
       "4                                            72203934      \n",
       "5                                            10392018      \n",
       "6                                             7349027      \n",
       "7                                             1746240      \n",
       "8                                             1434113      \n",
       "9                                            36344605      \n",
       "10                                           14485449      \n",
       "11                                            2826157      \n",
       "12                                            2382727      \n",
       "13                                           21946996      \n",
       "14                                            9265595      \n",
       "15                                            4952757      \n",
       "16                                            4478344      \n",
       "17                                            6364830      \n",
       "18                                            6110191      \n",
       "19                                            2719394      \n",
       "20                                           11606157      \n",
       "21                                           14371860      \n",
       "22                                           15389332      \n",
       "23                                            9968531      \n",
       "24                                            3787172      \n",
       "25                                            8711919      \n",
       "26                                            1543262      \n",
       "27                                            3101078      \n",
       "28                                            4765079      \n",
       "29                                            2542697      \n",
       "30                                           16700701      \n",
       "31                                            3799157      \n",
       "32                                           38129707      \n",
       "33                                           16246060      \n",
       "34                                            1065896      \n",
       "35                                           17330784      \n",
       "36                                            5755924      \n",
       "37                                            7499331      \n",
       "38                                           22243436      \n",
       "39                                            2146406      \n",
       "40                                            7341961      \n",
       "41                                            1365121      \n",
       "42                                            9665002      \n",
       "43                                           44868529      \n",
       "44                                            5100934      \n",
       "45                                            1354989      \n",
       "46                                           15986497      \n",
       "47                                           13963937      \n",
       "48                                            2649826      \n",
       "49                                            9933799      \n",
       "50                                             735005      \n",
       "\n",
       "    People with at least One Dose by State of Residence  \\\n",
       "0                                             3045967     \n",
       "1                                              504539     \n",
       "2                                             5232140     \n",
       "3                                             1991116     \n",
       "4                                            32494180     \n",
       "5                                             4529548     \n",
       "6                                             3363017     \n",
       "7                                              799668     \n",
       "8                                              677127     \n",
       "9                                            16829431     \n",
       "10                                            6867234     \n",
       "11                                            1228270     \n",
       "12                                            1082047     \n",
       "13                                            9668434     \n",
       "14                                            4100631     \n",
       "15                                            2128809     \n",
       "16                                            2150241     \n",
       "17                                            2929634     \n",
       "18                                            2812222     \n",
       "19                                            1200174     \n",
       "20                                            5156516     \n",
       "21                                            6679344     \n",
       "22                                            6636918     \n",
       "23                                            4204685     \n",
       "24                                            1757143     \n",
       "25                                            4026372     \n",
       "26                                             691222     \n",
       "27                                            1346242     \n",
       "28                                            2291011     \n",
       "29                                            1321982     \n",
       "30                                            7944016     \n",
       "31                                            1811658     \n",
       "32                                           17376730     \n",
       "33                                            8681622     \n",
       "34                                             491967     \n",
       "35                                            7373720     \n",
       "36                                            2780004     \n",
       "37                                            3257811     \n",
       "38                                           10717480     \n",
       "39                                            1027413     \n",
       "40                                            3447431     \n",
       "41                                             666057     \n",
       "42                                            4204484     \n",
       "43                                           20783338     \n",
       "44                                            2291082     \n",
       "45                                             578479     \n",
       "46                                            7237259     \n",
       "47                                            6097229     \n",
       "48                                            1154492     \n",
       "49                                            4150489     \n",
       "50                                             336848     \n",
       "\n",
       "    Percent of Total Pop with at least One Dose by State of Residence  \\\n",
       "0                                                  62                   \n",
       "1                                                  69                   \n",
       "2                                                  72                   \n",
       "3                                                  66                   \n",
       "4                                                  82                   \n",
       "5                                                  79                   \n",
       "6                                                  94                   \n",
       "7                                                  82                   \n",
       "8                                                  95                   \n",
       "9                                                  78                   \n",
       "10                                                 65                   \n",
       "11                                                 87                   \n",
       "12                                                 61                   \n",
       "13                                                 76                   \n",
       "14                                                 61                   \n",
       "15                                                 68                   \n",
       "16                                                 74                   \n",
       "17                                                 66                   \n",
       "18                                                 61                   \n",
       "19                                                 89                   \n",
       "20                                                 85                   \n",
       "21                                                 95                   \n",
       "22                                                 67                   \n",
       "23                                                 75                   \n",
       "24                                                 59                   \n",
       "25                                                 66                   \n",
       "26                                                 65                   \n",
       "27                                                 70                   \n",
       "28                                                 74                   \n",
       "29                                                 95                   \n",
       "30                                                 89                   \n",
       "31                                                 86                   \n",
       "32                                                 89                   \n",
       "33                                                 83                   \n",
       "34                                                 65                   \n",
       "35                                                 63                   \n",
       "36                                                 70                   \n",
       "37                                                 77                   \n",
       "38                                                 84                   \n",
       "39                                                 95                   \n",
       "40                                                 67                   \n",
       "41                                                 75                   \n",
       "42                                                 62                   \n",
       "43                                                 72                   \n",
       "44                                                 72                   \n",
       "45                                                 93                   \n",
       "46                                                 85                   \n",
       "47                                                 80                   \n",
       "48                                                 64                   \n",
       "49                                                 71                   \n",
       "50                                                 58                   \n",
       "\n",
       "    People Fully Vaccinated by State of Residence  \\\n",
       "0                                         2476199   \n",
       "1                                          449359   \n",
       "2                                         4404914   \n",
       "3                                         1622985   \n",
       "4                                        28000511   \n",
       "5                                         4004711   \n",
       "6                                         2786396   \n",
       "7                                          662698   \n",
       "8                                          508530   \n",
       "9                                        14223127   \n",
       "10                                        5733124   \n",
       "11                                        1098640   \n",
       "12                                         954547   \n",
       "13                                        8609660   \n",
       "14                                        3656889   \n",
       "15                                        1936322   \n",
       "16                                        1765693   \n",
       "17                                        2536474   \n",
       "18                                        2461340   \n",
       "19                                        1056524   \n",
       "20                                        4499863   \n",
       "21                                        5374123   \n",
       "22                                        5950255   \n",
       "23                                        3866020   \n",
       "24                                        1525309   \n",
       "25                                        3400392   \n",
       "26                                         600400   \n",
       "27                                        1214628   \n",
       "28                                        1849339   \n",
       "29                                         944421   \n",
       "30                                        6632578   \n",
       "31                                        1468726   \n",
       "32                                       14766854   \n",
       "33                                        6258995   \n",
       "34                                         415744   \n",
       "35                                        6763928   \n",
       "36                                        2228871   \n",
       "37                                        2909059   \n",
       "38                                        8621690   \n",
       "39                                         860233   \n",
       "40                                        2901702   \n",
       "41                                         533114   \n",
       "42                                        3677363   \n",
       "43                                       17538002   \n",
       "44                                        2038829   \n",
       "45                                         501868   \n",
       "46                                        6173036   \n",
       "47                                        5468432   \n",
       "48                                        1021806   \n",
       "49                                        3778622   \n",
       "50                                         294355   \n",
       "\n",
       "    Percent of Total Pop Fully Vaccinated by State of Residence  \\\n",
       "0                                                  51             \n",
       "1                                                  61             \n",
       "2                                                  61             \n",
       "3                                                  54             \n",
       "4                                                  71             \n",
       "5                                                  70             \n",
       "6                                                  78             \n",
       "7                                                  68             \n",
       "8                                                  72             \n",
       "9                                                  66             \n",
       "10                                                 54             \n",
       "11                                                 78             \n",
       "12                                                 53             \n",
       "13                                                 68             \n",
       "14                                                 54             \n",
       "15                                                 61             \n",
       "16                                                 61             \n",
       "17                                                 57             \n",
       "18                                                 53             \n",
       "19                                                 79             \n",
       "20                                                 74             \n",
       "21                                                 78             \n",
       "22                                                 60             \n",
       "23                                                 69             \n",
       "24                                                 51             \n",
       "25                                                 55             \n",
       "26                                                 56             \n",
       "27                                                 63             \n",
       "28                                                 60             \n",
       "29                                                 70             \n",
       "30                                                 75             \n",
       "31                                                 70             \n",
       "32                                                 76             \n",
       "33                                                 60             \n",
       "34                                                 55             \n",
       "35                                                 58             \n",
       "36                                                 56             \n",
       "37                                                 69             \n",
       "38                                                 67             \n",
       "39                                                 81             \n",
       "40                                                 56             \n",
       "41                                                 60             \n",
       "42                                                 54             \n",
       "43                                                 61             \n",
       "44                                                 64             \n",
       "45                                                 80             \n",
       "46                                                 72             \n",
       "47                                                 72             \n",
       "48                                                 57             \n",
       "49                                                 65             \n",
       "50                                                 51             \n",
       "\n",
       "    Percent of Total Pop with over 1 Dose by State of Residence  \\\n",
       "0                                                  62             \n",
       "1                                                  69             \n",
       "2                                                  72             \n",
       "3                                                  66             \n",
       "4                                                  82             \n",
       "5                                                  79             \n",
       "6                                                  94             \n",
       "7                                                  82             \n",
       "8                                                  95             \n",
       "9                                                  78             \n",
       "10                                                 65             \n",
       "11                                                 87             \n",
       "12                                                 61             \n",
       "13                                                 76             \n",
       "14                                                 61             \n",
       "15                                                 68             \n",
       "16                                                 74             \n",
       "17                                                 66             \n",
       "18                                                 61             \n",
       "19                                                 89             \n",
       "20                                                 85             \n",
       "21                                                 95             \n",
       "22                                                 67             \n",
       "23                                                 75             \n",
       "24                                                 59             \n",
       "25                                                 66             \n",
       "26                                                 65             \n",
       "27                                                 70             \n",
       "28                                                 74             \n",
       "29                                                 95             \n",
       "30                                                 89             \n",
       "31                                                 86             \n",
       "32                                                 89             \n",
       "33                                                 83             \n",
       "34                                                 65             \n",
       "35                                                 63             \n",
       "36                                                 70             \n",
       "37                                                 77             \n",
       "38                                                 84             \n",
       "39                                                 95             \n",
       "40                                                 67             \n",
       "41                                                 75             \n",
       "42                                                 62             \n",
       "43                                                 72             \n",
       "44                                                 72             \n",
       "45                                                 93             \n",
       "46                                                 85             \n",
       "47                                                 80             \n",
       "48                                                 64             \n",
       "49                                                 71             \n",
       "50                                                 58             \n",
       "\n",
       "    People who have received a booster dose  \\\n",
       "0                                    858145   \n",
       "1                                    188122   \n",
       "2                                   1769853   \n",
       "3                                    621175   \n",
       "4                                  13728499   \n",
       "5                                   2021778   \n",
       "6                                   1402029   \n",
       "7                                    292626   \n",
       "8                                    180651   \n",
       "9                                   5522219   \n",
       "10                                  2043030   \n",
       "11                                   549481   \n",
       "12                                   392782   \n",
       "13                                  4275249   \n",
       "14                                  1629049   \n",
       "15                                  1007372   \n",
       "16                                   736536   \n",
       "17                                  1097242   \n",
       "18                                   945301   \n",
       "19                                   573366   \n",
       "20                                  2221431   \n",
       "21                                  2687779   \n",
       "22                                  3161199   \n",
       "23                                  2176562   \n",
       "24                                   552378   \n",
       "25                                  1406296   \n",
       "26                                   279829   \n",
       "27                                   591116   \n",
       "28                                   694192   \n",
       "29                                   283995   \n",
       "30                                  3043351   \n",
       "31                                   711781   \n",
       "32                                  6566936   \n",
       "33                                  1608180   \n",
       "34                                   167398   \n",
       "35                                  3439399   \n",
       "36                                   815159   \n",
       "37                                  1512421   \n",
       "38                                  3579552   \n",
       "39                                   447622   \n",
       "40                                  1125068   \n",
       "41                                   215305   \n",
       "42                                  1572539   \n",
       "43                                  6356771   \n",
       "44                                   883340   \n",
       "45                                   296252   \n",
       "46                                  2849860   \n",
       "47                                  2775875   \n",
       "48                                   455962   \n",
       "49                                  2078078   \n",
       "50                                   123659   \n",
       "\n",
       "    Percent of fully vaccinated people with booster doses  \n",
       "0                                                  35      \n",
       "1                                                  42      \n",
       "2                                                  40      \n",
       "3                                                  38      \n",
       "4                                                  49      \n",
       "5                                                  51      \n",
       "6                                                  50      \n",
       "7                                                  44      \n",
       "8                                                  36      \n",
       "9                                                  39      \n",
       "10                                                 36      \n",
       "11                                                 50      \n",
       "12                                                 41      \n",
       "13                                                 50      \n",
       "14                                                 45      \n",
       "15                                                 52      \n",
       "16                                                 42      \n",
       "17                                                 43      \n",
       "18                                                 38      \n",
       "19                                                 54      \n",
       "20                                                 49      \n",
       "21                                                 50      \n",
       "22                                                 53      \n",
       "23                                                 56      \n",
       "24                                                 36      \n",
       "25                                                 41      \n",
       "26                                                 47      \n",
       "27                                                 49      \n",
       "28                                                 38      \n",
       "29                                                 30      \n",
       "30                                                 46      \n",
       "31                                                 49      \n",
       "32                                                 45      \n",
       "33                                                 26      \n",
       "34                                                 40      \n",
       "35                                                 51      \n",
       "36                                                 37      \n",
       "37                                                 52      \n",
       "38                                                 42      \n",
       "39                                                 52      \n",
       "40                                                 39      \n",
       "41                                                 40      \n",
       "42                                                 43      \n",
       "43                                                 36      \n",
       "44                                                 43      \n",
       "45                                                 59      \n",
       "46                                                 46      \n",
       "47                                                 51      \n",
       "48                                                 45      \n",
       "49                                                 55      \n",
       "50                                                 42      "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "d778fa7d",
   "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>Total Doses Delivered</th>\n",
       "      <th>Total Doses Administered by State where Administered</th>\n",
       "      <th>People with at least One Dose by State of Residence</th>\n",
       "      <th>Percent of Total Pop with at least One Dose by State of Residence</th>\n",
       "      <th>People Fully Vaccinated by State of Residence</th>\n",
       "      <th>Percent of Total Pop Fully Vaccinated by State of Residence</th>\n",
       "      <th>Percent of Total Pop with over 1 Dose by State of Residence</th>\n",
       "      <th>People who have received a booster dose</th>\n",
       "      <th>Percent of fully vaccinated people with booster doses</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>1464865</td>\n",
       "      <td>1108025</td>\n",
       "      <td>504539</td>\n",
       "      <td>69</td>\n",
       "      <td>449359</td>\n",
       "      <td>61</td>\n",
       "      <td>69</td>\n",
       "      <td>188122</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    State Total Doses Delivered  \\\n",
       "1  Alaska               1464865   \n",
       "\n",
       "  Total Doses Administered by State where Administered  \\\n",
       "1                                            1108025     \n",
       "\n",
       "  People with at least One Dose by State of Residence  \\\n",
       "1                                             504539    \n",
       "\n",
       "  Percent of Total Pop with at least One Dose by State of Residence  \\\n",
       "1                                                 69                  \n",
       "\n",
       "  People Fully Vaccinated by State of Residence  \\\n",
       "1                                        449359   \n",
       "\n",
       "  Percent of Total Pop Fully Vaccinated by State of Residence  \\\n",
       "1                                                 61            \n",
       "\n",
       "  Percent of Total Pop with over 1 Dose by State of Residence  \\\n",
       "1                                                 69            \n",
       "\n",
       "  People who have received a booster dose  \\\n",
       "1                                  188122   \n",
       "\n",
       "  Percent of fully vaccinated people with booster doses  \n",
       "1                                                 42     "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[1].to_frame().T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "6eedbc92",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.iloc[1].to_frame().T.to_csv ('test.csv',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "3406c905",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.iloc[2].to_frame().T.to_csv ('test2.csv',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "78425c28",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "PythonData",
   "language": "python",
   "name": "pythondata"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}