Skip to content

Instantly share code, notes, and snippets.

@whynotavailable

whynotavailable/covid.ipynb

Last active April 1, 2020 13:25
Show Gist options
  • Save whynotavailable/13c9cda372163c3ecb19a8cffdc1689c to your computer and use it in GitHub Desktop.
Save whynotavailable/13c9cda372163c3ecb19a8cffdc1689c to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
covid.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Some covid stats"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"import pandas\n",
"import numpy as np"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"df = pandas.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_daily_reports/03-31-2020.csv')\n",
"df['Confirmed'] = df['Confirmed'].astype(int)\n",
"df['Deaths'] = df['Deaths'].astype(int)\n",
"df['Recovered'] = df['Recovered'].astype(int)\n",
"df = df[df['Country_Region'] == 'US']"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"def render_grouping(col):\n",
" df2 = df.groupby(col).sum().sort_values(by=['Confirmed'], ascending=False)\n",
" df2[\"Row #\"] = np.arange(len(df2)) + 1\n",
" return df2.filter(items=['Row #', 'Confirmed', 'Deaths', 'Recovered'])"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Here we have grouped by US state"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Row #</th>\n",
" <th>Confirmed</th>\n",
" <th>Deaths</th>\n",
" <th>Recovered</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Province_State</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>New York</th>\n",
" <td>1</td>\n",
" <td>75833</td>\n",
" <td>1550</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>New Jersey</th>\n",
" <td>2</td>\n",
" <td>18696</td>\n",
" <td>267</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>California</th>\n",
" <td>3</td>\n",
" <td>8210</td>\n",
" <td>173</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Michigan</th>\n",
" <td>4</td>\n",
" <td>7615</td>\n",
" <td>259</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Florida</th>\n",
" <td>5</td>\n",
" <td>6741</td>\n",
" <td>85</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Massachusetts</th>\n",
" <td>6</td>\n",
" <td>6620</td>\n",
" <td>89</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Illinois</th>\n",
" <td>7</td>\n",
" <td>5994</td>\n",
" <td>99</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington</th>\n",
" <td>8</td>\n",
" <td>5432</td>\n",
" <td>225</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Louisiana</th>\n",
" <td>9</td>\n",
" <td>5237</td>\n",
" <td>239</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Pennsylvania</th>\n",
" <td>10</td>\n",
" <td>4963</td>\n",
" <td>63</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Georgia</th>\n",
" <td>11</td>\n",
" <td>3929</td>\n",
" <td>111</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Texas</th>\n",
" <td>12</td>\n",
" <td>3809</td>\n",
" <td>54</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Connecticut</th>\n",
" <td>13</td>\n",
" <td>3128</td>\n",
" <td>69</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Colorado</th>\n",
" <td>14</td>\n",
" <td>2966</td>\n",
" <td>69</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Tennessee</th>\n",
" <td>15</td>\n",
" <td>2391</td>\n",
" <td>23</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Ohio</th>\n",
" <td>16</td>\n",
" <td>2199</td>\n",
" <td>55</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Indiana</th>\n",
" <td>17</td>\n",
" <td>2158</td>\n",
" <td>49</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Maryland</th>\n",
" <td>18</td>\n",
" <td>1660</td>\n",
" <td>18</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>North Carolina</th>\n",
" <td>19</td>\n",
" <td>1535</td>\n",
" <td>12</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Wisconsin</th>\n",
" <td>20</td>\n",
" <td>1412</td>\n",
" <td>25</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Missouri</th>\n",
" <td>21</td>\n",
" <td>1357</td>\n",
" <td>15</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Arizona</th>\n",
" <td>22</td>\n",
" <td>1289</td>\n",
" <td>24</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Virginia</th>\n",
" <td>23</td>\n",
" <td>1249</td>\n",
" <td>27</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Nevada</th>\n",
" <td>24</td>\n",
" <td>1114</td>\n",
" <td>26</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>South Carolina</th>\n",
" <td>25</td>\n",
" <td>1083</td>\n",
" <td>22</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Alabama</th>\n",
" <td>26</td>\n",
" <td>987</td>\n",
" <td>23</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Mississippi</th>\n",
" <td>27</td>\n",
" <td>937</td>\n",
" <td>20</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Utah</th>\n",
" <td>28</td>\n",
" <td>888</td>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Oregon</th>\n",
" <td>29</td>\n",
" <td>690</td>\n",
" <td>18</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Minnesota</th>\n",
" <td>30</td>\n",
" <td>629</td>\n",
" <td>12</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Kentucky</th>\n",
" <td>31</td>\n",
" <td>628</td>\n",
" <td>11</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Oklahoma</th>\n",
" <td>32</td>\n",
" <td>568</td>\n",
" <td>23</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Arkansas</th>\n",
" <td>33</td>\n",
" <td>523</td>\n",
" <td>8</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Idaho</th>\n",
" <td>34</td>\n",
" <td>515</td>\n",
" <td>8</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Iowa</th>\n",
" <td>35</td>\n",
" <td>497</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>District of Columbia</th>\n",
" <td>36</td>\n",
" <td>495</td>\n",
" <td>9</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Rhode Island</th>\n",
" <td>37</td>\n",
" <td>488</td>\n",
" <td>8</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Kansas</th>\n",
" <td>38</td>\n",
" <td>434</td>\n",
" <td>9</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>New Hampshire</th>\n",
" <td>39</td>\n",
" <td>357</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Delaware</th>\n",
" <td>40</td>\n",
" <td>319</td>\n",
" <td>10</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>New Mexico</th>\n",
" <td>41</td>\n",
" <td>315</td>\n",
" <td>4</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Maine</th>\n",
" <td>42</td>\n",
" <td>303</td>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Vermont</th>\n",
" <td>43</td>\n",
" <td>293</td>\n",
" <td>13</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Puerto Rico</th>\n",
" <td>44</td>\n",
" <td>239</td>\n",
" <td>8</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Hawaii</th>\n",
" <td>45</td>\n",
" <td>204</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Montana</th>\n",
" <td>46</td>\n",
" <td>198</td>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Nebraska</th>\n",
" <td>47</td>\n",
" <td>172</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>West Virginia</th>\n",
" <td>48</td>\n",
" <td>162</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>North Dakota</th>\n",
" <td>49</td>\n",
" <td>122</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Alaska</th>\n",
" <td>50</td>\n",
" <td>119</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Wyoming</th>\n",
" <td>51</td>\n",
" <td>109</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>South Dakota</th>\n",
" <td>52</td>\n",
" <td>108</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Grand Princess</th>\n",
" <td>53</td>\n",
" <td>103</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Guam</th>\n",
" <td>54</td>\n",
" <td>69</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Diamond Princess</th>\n",
" <td>55</td>\n",
" <td>49</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Virgin Islands</th>\n",
" <td>56</td>\n",
" <td>30</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Northern Mariana Islands</th>\n",
" <td>57</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Recovered</th>\n",
" <td>58</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>7024</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Row # Confirmed Deaths Recovered\n",
"Province_State \n",
"New York 1 75833 1550 0\n",
"New Jersey 2 18696 267 0\n",
"California 3 8210 173 0\n",
"Michigan 4 7615 259 0\n",
"Florida 5 6741 85 0\n",
"Massachusetts 6 6620 89 0\n",
"Illinois 7 5994 99 0\n",
"Washington 8 5432 225 0\n",
"Louisiana 9 5237 239 0\n",
"Pennsylvania 10 4963 63 0\n",
"Georgia 11 3929 111 0\n",
"Texas 12 3809 54 0\n",
"Connecticut 13 3128 69 0\n",
"Colorado 14 2966 69 0\n",
"Tennessee 15 2391 23 0\n",
"Ohio 16 2199 55 0\n",
"Indiana 17 2158 49 0\n",
"Maryland 18 1660 18 0\n",
"North Carolina 19 1535 12 0\n",
"Wisconsin 20 1412 25 0\n",
"Missouri 21 1357 15 0\n",
"Arizona 22 1289 24 0\n",
"Virginia 23 1249 27 0\n",
"Nevada 24 1114 26 0\n",
"South Carolina 25 1083 22 0\n",
"Alabama 26 987 23 0\n",
"Mississippi 27 937 20 0\n",
"Utah 28 888 5 0\n",
"Oregon 29 690 18 0\n",
"Minnesota 30 629 12 0\n",
"Kentucky 31 628 11 0\n",
"Oklahoma 32 568 23 0\n",
"Arkansas 33 523 8 0\n",
"Idaho 34 515 8 0\n",
"Iowa 35 497 7 0\n",
"District of Columbia 36 495 9 0\n",
"Rhode Island 37 488 8 0\n",
"Kansas 38 434 9 0\n",
"New Hampshire 39 357 3 0\n",
"Delaware 40 319 10 0\n",
"New Mexico 41 315 4 0\n",
"Maine 42 303 5 0\n",
"Vermont 43 293 13 0\n",
"Puerto Rico 44 239 8 0\n",
"Hawaii 45 204 0 0\n",
"Montana 46 198 5 0\n",
"Nebraska 47 172 3 0\n",
"West Virginia 48 162 1 0\n",
"North Dakota 49 122 3 0\n",
"Alaska 50 119 3 0\n",
"Wyoming 51 109 0 0\n",
"South Dakota 52 108 1 0\n",
"Grand Princess 53 103 3 0\n",
"Guam 54 69 2 0\n",
"Diamond Princess 55 49 0 0\n",
"Virgin Islands 56 30 0 0\n",
"Northern Mariana Islands 57 2 0 0\n",
"Recovered 58 0 0 7024"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"render_grouping('Province_State')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Grouping by us cities"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Row #</th>\n",
" <th>Confirmed</th>\n",
" <th>Deaths</th>\n",
" <th>Recovered</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Combined_Key</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>New York City, New York, US</th>\n",
" <td>1</td>\n",
" <td>43119</td>\n",
" <td>932</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Westchester, New York, US</th>\n",
" <td>2</td>\n",
" <td>9967</td>\n",
" <td>10</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Nassau, New York, US</th>\n",
" <td>3</td>\n",
" <td>8544</td>\n",
" <td>48</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Suffolk, New York, US</th>\n",
" <td>4</td>\n",
" <td>6713</td>\n",
" <td>44</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Cook, Illinois, US</th>\n",
" <td>5</td>\n",
" <td>4496</td>\n",
" <td>61</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Wayne,Michigan,US</th>\n",
" <td>6</td>\n",
" <td>3735</td>\n",
" <td>120</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Unassigned, New Jersey, US</th>\n",
" <td>7</td>\n",
" <td>3686</td>\n",
" <td>247</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Los Angeles, California, US</th>\n",
" <td>8</td>\n",
" <td>3019</td>\n",
" <td>54</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Bergen, New Jersey, US</th>\n",
" <td>9</td>\n",
" <td>2909</td>\n",
" <td>4</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Rockland, New York, US</th>\n",
" <td>10</td>\n",
" <td>2863</td>\n",
" <td>8</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>King, Washington, US</th>\n",
" <td>11</td>\n",
" <td>2330</td>\n",
" <td>150</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Miami-Dade, Florida, US</th>\n",
" <td>12</td>\n",
" <td>2123</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Essex, New Jersey, US</th>\n",
" <td>13</td>\n",
" <td>1900</td>\n",
" <td>4</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Fairfield, Connecticut, US</th>\n",
" <td>14</td>\n",
" <td>1870</td>\n",
" <td>38</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Orleans, Louisiana, US</th>\n",
" <td>15</td>\n",
" <td>1834</td>\n",
" <td>101</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Hudson, New Jersey, US</th>\n",
" <td>16</td>\n",
" <td>1606</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Oakland, Michigan, US</th>\n",
" <td>17</td>\n",
" <td>1591</td>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Orange, New York, US</th>\n",
" <td>18</td>\n",
" <td>1556</td>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Union, New Jersey, US</th>\n",
" <td>19</td>\n",
" <td>1418</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Suffolk, Massachusetts, US</th>\n",
" <td>20</td>\n",
" <td>1373</td>\n",
" <td>6</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Middlesex, Massachusetts, US</th>\n",
" <td>21</td>\n",
" <td>1340</td>\n",
" <td>17</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Philadelphia, Pennsylvania, US</th>\n",
" <td>22</td>\n",
" <td>1315</td>\n",
" <td>10</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Passaic, New Jersey, US</th>\n",
" <td>23</td>\n",
" <td>1294</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Middlesex, New Jersey, US</th>\n",
" <td>24</td>\n",
" <td>1277</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Snohomish, Washington, US</th>\n",
" <td>25</td>\n",
" <td>1229</td>\n",
" <td>33</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Broward, Florida, US</th>\n",
" <td>26</td>\n",
" <td>1219</td>\n",
" <td>12</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Jefferson, Louisiana, US</th>\n",
" <td>27</td>\n",
" <td>1193</td>\n",
" <td>57</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Monmouth, New Jersey, US</th>\n",
" <td>28</td>\n",
" <td>1140</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Ocean, New Jersey, US</th>\n",
" <td>29</td>\n",
" <td>1022</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Marion, Indiana, US</th>\n",
" <td>30</td>\n",
" <td>964</td>\n",
" <td>17</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Santa Clara, California, US</th>\n",
" <td>31</td>\n",
" <td>890</td>\n",
" <td>30</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Clark, Nevada, US</th>\n",
" <td>32</td>\n",
" <td>869</td>\n",
" <td>23</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Macomb, Michigan, US</th>\n",
" <td>33</td>\n",
" <td>853</td>\n",
" <td>38</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Morris, New Jersey, US</th>\n",
" <td>34</td>\n",
" <td>841</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Maricopa, Arizona, US</th>\n",
" <td>35</td>\n",
" <td>788</td>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Essex, Massachusetts, US</th>\n",
" <td>36</td>\n",
" <td>784</td>\n",
" <td>12</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Norfolk, Massachusetts, US</th>\n",
" <td>37</td>\n",
" <td>738</td>\n",
" <td>12</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Milwaukee, Wisconsin, US</th>\n",
" <td>38</td>\n",
" <td>710</td>\n",
" <td>11</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Harris,Texas,US</th>\n",
" <td>39</td>\n",
" <td>680</td>\n",
" <td>6</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Dallas, Texas, US</th>\n",
" <td>40</td>\n",
" <td>631</td>\n",
" <td>13</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>San Diego, California, US</th>\n",
" <td>41</td>\n",
" <td>603</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Montgomery, Pennsylvania, US</th>\n",
" <td>42</td>\n",
" <td>570</td>\n",
" <td>6</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Fulton, Georgia, US</th>\n",
" <td>43</td>\n",
" <td>570</td>\n",
" <td>17</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Palm Beach, Florida, US</th>\n",
" <td>44</td>\n",
" <td>551</td>\n",
" <td>14</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Davidson, Tennessee, US</th>\n",
" <td>45</td>\n",
" <td>541</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Denver, Colorado, US</th>\n",
" <td>46</td>\n",
" <td>539</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Cuyahoga, Ohio, US</th>\n",
" <td>47</td>\n",
" <td>527</td>\n",
" <td>6</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>New Haven, Connecticut, US</th>\n",
" <td>48</td>\n",
" <td>517</td>\n",
" <td>12</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Orange, California, US</th>\n",
" <td>49</td>\n",
" <td>502</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Erie, New York, US</th>\n",
" <td>50</td>\n",
" <td>499</td>\n",
" <td>8</td>\n",
" <td>0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Row # Confirmed Deaths Recovered\n",
"Combined_Key \n",
"New York City, New York, US 1 43119 932 0\n",
"Westchester, New York, US 2 9967 10 0\n",
"Nassau, New York, US 3 8544 48 0\n",
"Suffolk, New York, US 4 6713 44 0\n",
"Cook, Illinois, US 5 4496 61 0\n",
"Wayne,Michigan,US 6 3735 120 0\n",
"Unassigned, New Jersey, US 7 3686 247 0\n",
"Los Angeles, California, US 8 3019 54 0\n",
"Bergen, New Jersey, US 9 2909 4 0\n",
"Rockland, New York, US 10 2863 8 0\n",
"King, Washington, US 11 2330 150 0\n",
"Miami-Dade, Florida, US 12 2123 7 0\n",
"Essex, New Jersey, US 13 1900 4 0\n",
"Fairfield, Connecticut, US 14 1870 38 0\n",
"Orleans, Louisiana, US 15 1834 101 0\n",
"Hudson, New Jersey, US 16 1606 2 0\n",
"Oakland, Michigan, US 17 1591 70 0\n",
"Orange, New York, US 18 1556 5 0\n",
"Union, New Jersey, US 19 1418 0 0\n",
"Suffolk, Massachusetts, US 20 1373 6 0\n",
"Middlesex, Massachusetts, US 21 1340 17 0\n",
"Philadelphia, Pennsylvania, US 22 1315 10 0\n",
"Passaic, New Jersey, US 23 1294 1 0\n",
"Middlesex, New Jersey, US 24 1277 0 0\n",
"Snohomish, Washington, US 25 1229 33 0\n",
"Broward, Florida, US 26 1219 12 0\n",
"Jefferson, Louisiana, US 27 1193 57 0\n",
"Monmouth, New Jersey, US 28 1140 2 0\n",
"Ocean, New Jersey, US 29 1022 1 0\n",
"Marion, Indiana, US 30 964 17 0\n",
"Santa Clara, California, US 31 890 30 0\n",
"Clark, Nevada, US 32 869 23 0\n",
"Macomb, Michigan, US 33 853 38 0\n",
"Morris, New Jersey, US 34 841 1 0\n",
"Maricopa, Arizona, US 35 788 5 0\n",
"Essex, Massachusetts, US 36 784 12 0\n",
"Norfolk, Massachusetts, US 37 738 12 0\n",
"Milwaukee, Wisconsin, US 38 710 11 0\n",
"Harris,Texas,US 39 680 6 0\n",
"Dallas, Texas, US 40 631 13 0\n",
"San Diego, California, US 41 603 7 0\n",
"Montgomery, Pennsylvania, US 42 570 6 0\n",
"Fulton, Georgia, US 43 570 17 0\n",
"Palm Beach, Florida, US 44 551 14 0\n",
"Davidson, Tennessee, US 45 541 3 0\n",
"Denver, Colorado, US 46 539 7 0\n",
"Cuyahoga, Ohio, US 47 527 6 0\n",
"New Haven, Connecticut, US 48 517 12 0\n",
"Orange, California, US 49 502 7 0\n",
"Erie, New York, US 50 499 8 0"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"render_grouping('Combined_Key').head(50)"
]
},
{
"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.8.1"
}
},
"nbformat": 4,
"nbformat_minor": 4
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment