prep_state_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv('states-daily_data.csv',parse_dates=True).rename(columns={'state':'Province/State'})\\\n",
    "     .drop(columns=['negative','pending','hospitalized','death','total','hash','dateChecked',\n",
    "                    'totalTestResults','fips', 'deathIncrease','hospitalizedIncrease','negativeIncrease',\n",
    "                    'positiveIncrease','totalTestResultsIncrease'])\n",
    "cur_cols=list(df.columns).copy()\n",
    "for col in cur_cols:\n",
    "    if col not in ['date','Province/State','positive']:\n",
    "        df=df.drop(columns=[col])\n",
    "def fix_date(s):\n",
    "    s=str(s)\n",
    "    month=int(s[4:6])\n",
    "    day=s[6:]\n",
    "    year=20\n",
    "    return '{}/{}/{}'.format(month,day,year)\n",
    "df['date']=df['date'].apply(fix_date)\n",
    "counter=0\n",
    "for s in df['Province/State'].unique():\n",
    "    tmp=df[df['Province/State']==s].drop(columns=['Province/State'])\n",
    "    tmp=tmp.set_index('date')\n",
    "    tmp=tmp.T\n",
    "    tmp.index=[counter]\n",
    "    tmp['Country/Region']='US'\n",
    "    tmp['Province/State']=s\n",
    "    tmp['Lat']=np.nan\n",
    "    tmp['Long']=np.nan\n",
    "    if counter==0:\n",
    "        df2=tmp.copy()\n",
    "    else:\n",
    "        df2=pd.concat([df2,tmp],axis=0,sort=True)\n",
    "    counter+=1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['3/04/20', '3/05/20', '3/06/20', '3/07/20', '3/08/20', '3/09/20',\n",
      "       '3/10/20', '3/11/20', '3/12/20', '3/13/20', '3/14/20', '3/15/20',\n",
      "       '3/16/20', '3/17/20', '3/18/20', '3/19/20', '3/20/20', '3/21/20',\n",
      "       '3/22/20', '3/23/20', '3/24/20', '3/25/20', '3/26/20', '3/27/20',\n",
      "       '3/28/20', '3/29/20', '3/30/20', '3/31/20', '4/01/20', '4/02/20',\n",
      "       '4/03/20', '4/04/20', '4/05/20'],\n",
      "      dtype='object')\n"
     ]
    },
    {
     "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>Country/Region</th>\n",
       "      <th>Province/State</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Long</th>\n",
       "      <th>3/04/20</th>\n",
       "      <th>3/05/20</th>\n",
       "      <th>3/06/20</th>\n",
       "      <th>3/07/20</th>\n",
       "      <th>3/08/20</th>\n",
       "      <th>3/09/20</th>\n",
       "      <th>...</th>\n",
       "      <th>3/27/20</th>\n",
       "      <th>3/28/20</th>\n",
       "      <th>3/29/20</th>\n",
       "      <th>3/30/20</th>\n",
       "      <th>3/31/20</th>\n",
       "      <th>4/01/20</th>\n",
       "      <th>4/02/20</th>\n",
       "      <th>4/03/20</th>\n",
       "      <th>4/04/20</th>\n",
       "      <th>4/05/20</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>US</td>\n",
       "      <td>AK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>102.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>119.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>157.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>185.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>US</td>\n",
       "      <td>AL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>587.0</td>\n",
       "      <td>696.0</td>\n",
       "      <td>806.0</td>\n",
       "      <td>859.0</td>\n",
       "      <td>981.0</td>\n",
       "      <td>1077.0</td>\n",
       "      <td>1233.0</td>\n",
       "      <td>1432.0</td>\n",
       "      <td>1580.0</td>\n",
       "      <td>1796.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>US</td>\n",
       "      <td>AR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>381.0</td>\n",
       "      <td>404.0</td>\n",
       "      <td>426.0</td>\n",
       "      <td>473.0</td>\n",
       "      <td>523.0</td>\n",
       "      <td>584.0</td>\n",
       "      <td>643.0</td>\n",
       "      <td>704.0</td>\n",
       "      <td>743.0</td>\n",
       "      <td>830.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>US</td>\n",
       "      <td>AS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>US</td>\n",
       "      <td>AZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>736.0</td>\n",
       "      <td>873.0</td>\n",
       "      <td>919.0</td>\n",
       "      <td>1157.0</td>\n",
       "      <td>1289.0</td>\n",
       "      <td>1413.0</td>\n",
       "      <td>1598.0</td>\n",
       "      <td>1769.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2269.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Country/Region Province/State  Lat  Long  3/04/20  3/05/20  3/06/20  \\\n",
       "0             US             AK  NaN   NaN      NaN      NaN      0.0   \n",
       "1             US             AL  NaN   NaN      NaN      NaN      NaN   \n",
       "2             US             AR  NaN   NaN      NaN      NaN      0.0   \n",
       "3             US             AS  NaN   NaN      NaN      NaN      NaN   \n",
       "4             US             AZ  NaN   NaN      2.0      2.0      3.0   \n",
       "\n",
       "   3/07/20  3/08/20  3/09/20  ...  3/27/20  3/28/20  3/29/20  3/30/20  \\\n",
       "0      0.0      0.0      0.0  ...     69.0     85.0    102.0    114.0   \n",
       "1      0.0      0.0      0.0  ...    587.0    696.0    806.0    859.0   \n",
       "2      0.0      0.0      0.0  ...    381.0    404.0    426.0    473.0   \n",
       "3      NaN      NaN      NaN  ...      0.0      0.0      NaN      NaN   \n",
       "4      5.0      5.0      5.0  ...    736.0    873.0    919.0   1157.0   \n",
       "\n",
       "   3/31/20  4/01/20  4/02/20  4/03/20  4/04/20  4/05/20  \n",
       "0    119.0    133.0    143.0    157.0    171.0    185.0  \n",
       "1    981.0   1077.0   1233.0   1432.0   1580.0   1796.0  \n",
       "2    523.0    584.0    643.0    704.0    743.0    830.0  \n",
       "3      NaN      0.0      0.0      NaN      NaN      0.0  \n",
       "4   1289.0   1413.0   1598.0   1769.0   2019.0   2269.0  \n",
       "\n",
       "[5 rows x 37 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "tmp=df2.columns\n",
    "for col in ['Country/Region', 'Province/State','Lat', 'Long']:\n",
    "    tmp=np.delete(tmp, np.where(tmp == col))\n",
    "print(tmp)\n",
    "df2=df2[['Country/Region', 'Province/State','Lat', 'Long']+np.sort(tmp[::-1]).tolist()]\n",
    "display(df2.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "    \n",
    "\n",
    "df2.to_csv('state_by_state_data.csv',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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>Country/Region</th>\n",
       "      <th>Province/State</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Long</th>\n",
       "      <th>3/04/20</th>\n",
       "      <th>3/05/20</th>\n",
       "      <th>3/06/20</th>\n",
       "      <th>3/07/20</th>\n",
       "      <th>3/08/20</th>\n",
       "      <th>3/09/20</th>\n",
       "      <th>...</th>\n",
       "      <th>3/27/20</th>\n",
       "      <th>3/28/20</th>\n",
       "      <th>3/29/20</th>\n",
       "      <th>3/30/20</th>\n",
       "      <th>3/31/20</th>\n",
       "      <th>4/01/20</th>\n",
       "      <th>4/02/20</th>\n",
       "      <th>4/03/20</th>\n",
       "      <th>4/04/20</th>\n",
       "      <th>4/05/20</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>US</td>\n",
       "      <td>AK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>102.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>119.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>157.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>185.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>US</td>\n",
       "      <td>AL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>587.0</td>\n",
       "      <td>696.0</td>\n",
       "      <td>806.0</td>\n",
       "      <td>859.0</td>\n",
       "      <td>981.0</td>\n",
       "      <td>1077.0</td>\n",
       "      <td>1233.0</td>\n",
       "      <td>1432.0</td>\n",
       "      <td>1580.0</td>\n",
       "      <td>1796.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>US</td>\n",
       "      <td>AR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>381.0</td>\n",
       "      <td>404.0</td>\n",
       "      <td>426.0</td>\n",
       "      <td>473.0</td>\n",
       "      <td>523.0</td>\n",
       "      <td>584.0</td>\n",
       "      <td>643.0</td>\n",
       "      <td>704.0</td>\n",
       "      <td>743.0</td>\n",
       "      <td>830.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>US</td>\n",
       "      <td>AS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>US</td>\n",
       "      <td>AZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>736.0</td>\n",
       "      <td>873.0</td>\n",
       "      <td>919.0</td>\n",
       "      <td>1157.0</td>\n",
       "      <td>1289.0</td>\n",
       "      <td>1413.0</td>\n",
       "      <td>1598.0</td>\n",
       "      <td>1769.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2269.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>US</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3879.0</td>\n",
       "      <td>4643.0</td>\n",
       "      <td>5708.0</td>\n",
       "      <td>6447.0</td>\n",
       "      <td>7482.0</td>\n",
       "      <td>8155.0</td>\n",
       "      <td>9191.0</td>\n",
       "      <td>10701.0</td>\n",
       "      <td>12026.0</td>\n",
       "      <td>13438.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>US</td>\n",
       "      <td>CO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1430.0</td>\n",
       "      <td>1734.0</td>\n",
       "      <td>2061.0</td>\n",
       "      <td>2627.0</td>\n",
       "      <td>2627.0</td>\n",
       "      <td>2966.0</td>\n",
       "      <td>3342.0</td>\n",
       "      <td>3728.0</td>\n",
       "      <td>4173.0</td>\n",
       "      <td>4565.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>US</td>\n",
       "      <td>CT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1291.0</td>\n",
       "      <td>1291.0</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>2571.0</td>\n",
       "      <td>3128.0</td>\n",
       "      <td>3557.0</td>\n",
       "      <td>3824.0</td>\n",
       "      <td>4914.0</td>\n",
       "      <td>5276.0</td>\n",
       "      <td>5675.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>US</td>\n",
       "      <td>DC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>267.0</td>\n",
       "      <td>304.0</td>\n",
       "      <td>342.0</td>\n",
       "      <td>401.0</td>\n",
       "      <td>495.0</td>\n",
       "      <td>586.0</td>\n",
       "      <td>653.0</td>\n",
       "      <td>757.0</td>\n",
       "      <td>902.0</td>\n",
       "      <td>998.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>US</td>\n",
       "      <td>DE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>163.0</td>\n",
       "      <td>214.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>264.0</td>\n",
       "      <td>319.0</td>\n",
       "      <td>368.0</td>\n",
       "      <td>393.0</td>\n",
       "      <td>450.0</td>\n",
       "      <td>593.0</td>\n",
       "      <td>673.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>US</td>\n",
       "      <td>FL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2765.0</td>\n",
       "      <td>3763.0</td>\n",
       "      <td>4246.0</td>\n",
       "      <td>5473.0</td>\n",
       "      <td>6338.0</td>\n",
       "      <td>6955.0</td>\n",
       "      <td>8010.0</td>\n",
       "      <td>9585.0</td>\n",
       "      <td>11111.0</td>\n",
       "      <td>12151.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>US</td>\n",
       "      <td>GA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>2366.0</td>\n",
       "      <td>2651.0</td>\n",
       "      <td>2809.0</td>\n",
       "      <td>3929.0</td>\n",
       "      <td>4638.0</td>\n",
       "      <td>5348.0</td>\n",
       "      <td>5831.0</td>\n",
       "      <td>6160.0</td>\n",
       "      <td>6647.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>US</td>\n",
       "      <td>GU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>51.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>112.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>US</td>\n",
       "      <td>HI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>106.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>204.0</td>\n",
       "      <td>208.0</td>\n",
       "      <td>258.0</td>\n",
       "      <td>285.0</td>\n",
       "      <td>319.0</td>\n",
       "      <td>351.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>US</td>\n",
       "      <td>IA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>235.0</td>\n",
       "      <td>298.0</td>\n",
       "      <td>336.0</td>\n",
       "      <td>424.0</td>\n",
       "      <td>497.0</td>\n",
       "      <td>549.0</td>\n",
       "      <td>614.0</td>\n",
       "      <td>699.0</td>\n",
       "      <td>786.0</td>\n",
       "      <td>868.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>US</td>\n",
       "      <td>ID</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>189.0</td>\n",
       "      <td>230.0</td>\n",
       "      <td>261.0</td>\n",
       "      <td>310.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>525.0</td>\n",
       "      <td>669.0</td>\n",
       "      <td>891.0</td>\n",
       "      <td>1013.0</td>\n",
       "      <td>1077.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>US</td>\n",
       "      <td>IL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3026.0</td>\n",
       "      <td>3491.0</td>\n",
       "      <td>4596.0</td>\n",
       "      <td>5057.0</td>\n",
       "      <td>5994.0</td>\n",
       "      <td>6980.0</td>\n",
       "      <td>7695.0</td>\n",
       "      <td>8904.0</td>\n",
       "      <td>10357.0</td>\n",
       "      <td>11256.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>US</td>\n",
       "      <td>IN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>981.0</td>\n",
       "      <td>1232.0</td>\n",
       "      <td>1514.0</td>\n",
       "      <td>1786.0</td>\n",
       "      <td>2159.0</td>\n",
       "      <td>2565.0</td>\n",
       "      <td>3039.0</td>\n",
       "      <td>3437.0</td>\n",
       "      <td>3953.0</td>\n",
       "      <td>4411.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>US</td>\n",
       "      <td>KS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>202.0</td>\n",
       "      <td>261.0</td>\n",
       "      <td>319.0</td>\n",
       "      <td>368.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>482.0</td>\n",
       "      <td>552.0</td>\n",
       "      <td>620.0</td>\n",
       "      <td>698.0</td>\n",
       "      <td>747.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>US</td>\n",
       "      <td>KY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>248.0</td>\n",
       "      <td>302.0</td>\n",
       "      <td>394.0</td>\n",
       "      <td>439.0</td>\n",
       "      <td>480.0</td>\n",
       "      <td>591.0</td>\n",
       "      <td>680.0</td>\n",
       "      <td>770.0</td>\n",
       "      <td>831.0</td>\n",
       "      <td>917.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>US</td>\n",
       "      <td>LA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2746.0</td>\n",
       "      <td>3315.0</td>\n",
       "      <td>3540.0</td>\n",
       "      <td>4025.0</td>\n",
       "      <td>5237.0</td>\n",
       "      <td>6424.0</td>\n",
       "      <td>9150.0</td>\n",
       "      <td>10297.0</td>\n",
       "      <td>12496.0</td>\n",
       "      <td>13010.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>US</td>\n",
       "      <td>MA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3240.0</td>\n",
       "      <td>4257.0</td>\n",
       "      <td>4955.0</td>\n",
       "      <td>5752.0</td>\n",
       "      <td>6620.0</td>\n",
       "      <td>7738.0</td>\n",
       "      <td>8966.0</td>\n",
       "      <td>10402.0</td>\n",
       "      <td>11736.0</td>\n",
       "      <td>12500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>US</td>\n",
       "      <td>MD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>774.0</td>\n",
       "      <td>992.0</td>\n",
       "      <td>1239.0</td>\n",
       "      <td>1413.0</td>\n",
       "      <td>1660.0</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>2331.0</td>\n",
       "      <td>2758.0</td>\n",
       "      <td>3125.0</td>\n",
       "      <td>3609.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>US</td>\n",
       "      <td>ME</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>168.0</td>\n",
       "      <td>211.0</td>\n",
       "      <td>253.0</td>\n",
       "      <td>275.0</td>\n",
       "      <td>303.0</td>\n",
       "      <td>344.0</td>\n",
       "      <td>376.0</td>\n",
       "      <td>432.0</td>\n",
       "      <td>456.0</td>\n",
       "      <td>470.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>US</td>\n",
       "      <td>MI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3657.0</td>\n",
       "      <td>3657.0</td>\n",
       "      <td>5486.0</td>\n",
       "      <td>6498.0</td>\n",
       "      <td>7615.0</td>\n",
       "      <td>9334.0</td>\n",
       "      <td>10791.0</td>\n",
       "      <td>12744.0</td>\n",
       "      <td>14225.0</td>\n",
       "      <td>15718.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>US</td>\n",
       "      <td>MN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>398.0</td>\n",
       "      <td>441.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>576.0</td>\n",
       "      <td>629.0</td>\n",
       "      <td>689.0</td>\n",
       "      <td>742.0</td>\n",
       "      <td>789.0</td>\n",
       "      <td>865.0</td>\n",
       "      <td>935.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>US</td>\n",
       "      <td>MO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>669.0</td>\n",
       "      <td>838.0</td>\n",
       "      <td>838.0</td>\n",
       "      <td>1031.0</td>\n",
       "      <td>1327.0</td>\n",
       "      <td>1581.0</td>\n",
       "      <td>1834.0</td>\n",
       "      <td>2113.0</td>\n",
       "      <td>2291.0</td>\n",
       "      <td>2367.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>US</td>\n",
       "      <td>MP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>US</td>\n",
       "      <td>MS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>579.0</td>\n",
       "      <td>663.0</td>\n",
       "      <td>758.0</td>\n",
       "      <td>847.0</td>\n",
       "      <td>937.0</td>\n",
       "      <td>1073.0</td>\n",
       "      <td>1177.0</td>\n",
       "      <td>1358.0</td>\n",
       "      <td>1455.0</td>\n",
       "      <td>1638.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>US</td>\n",
       "      <td>MT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>108.0</td>\n",
       "      <td>129.0</td>\n",
       "      <td>154.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>184.0</td>\n",
       "      <td>208.0</td>\n",
       "      <td>227.0</td>\n",
       "      <td>243.0</td>\n",
       "      <td>265.0</td>\n",
       "      <td>286.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>US</td>\n",
       "      <td>NC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>763.0</td>\n",
       "      <td>935.0</td>\n",
       "      <td>1040.0</td>\n",
       "      <td>1307.0</td>\n",
       "      <td>1498.0</td>\n",
       "      <td>1584.0</td>\n",
       "      <td>1857.0</td>\n",
       "      <td>2093.0</td>\n",
       "      <td>2402.0</td>\n",
       "      <td>2585.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>US</td>\n",
       "      <td>ND</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>65.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>109.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>142.0</td>\n",
       "      <td>159.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>186.0</td>\n",
       "      <td>207.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>US</td>\n",
       "      <td>NE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>85.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>210.0</td>\n",
       "      <td>246.0</td>\n",
       "      <td>279.0</td>\n",
       "      <td>321.0</td>\n",
       "      <td>363.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>US</td>\n",
       "      <td>NH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>158.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>214.0</td>\n",
       "      <td>314.0</td>\n",
       "      <td>314.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>479.0</td>\n",
       "      <td>540.0</td>\n",
       "      <td>621.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>US</td>\n",
       "      <td>NJ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8825.0</td>\n",
       "      <td>11124.0</td>\n",
       "      <td>13386.0</td>\n",
       "      <td>16636.0</td>\n",
       "      <td>18696.0</td>\n",
       "      <td>22255.0</td>\n",
       "      <td>25590.0</td>\n",
       "      <td>29895.0</td>\n",
       "      <td>34124.0</td>\n",
       "      <td>37505.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>US</td>\n",
       "      <td>NM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>136.0</td>\n",
       "      <td>191.0</td>\n",
       "      <td>237.0</td>\n",
       "      <td>237.0</td>\n",
       "      <td>281.0</td>\n",
       "      <td>315.0</td>\n",
       "      <td>363.0</td>\n",
       "      <td>403.0</td>\n",
       "      <td>495.0</td>\n",
       "      <td>543.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>US</td>\n",
       "      <td>NV</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>535.0</td>\n",
       "      <td>621.0</td>\n",
       "      <td>738.0</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>1113.0</td>\n",
       "      <td>1279.0</td>\n",
       "      <td>1458.0</td>\n",
       "      <td>1514.0</td>\n",
       "      <td>1742.0</td>\n",
       "      <td>1836.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>US</td>\n",
       "      <td>NY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>142.0</td>\n",
       "      <td>...</td>\n",
       "      <td>44635.0</td>\n",
       "      <td>52318.0</td>\n",
       "      <td>59513.0</td>\n",
       "      <td>66497.0</td>\n",
       "      <td>75795.0</td>\n",
       "      <td>83712.0</td>\n",
       "      <td>92381.0</td>\n",
       "      <td>102863.0</td>\n",
       "      <td>113704.0</td>\n",
       "      <td>122031.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>US</td>\n",
       "      <td>OH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1137.0</td>\n",
       "      <td>1406.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>1933.0</td>\n",
       "      <td>2199.0</td>\n",
       "      <td>2547.0</td>\n",
       "      <td>2902.0</td>\n",
       "      <td>3312.0</td>\n",
       "      <td>3739.0</td>\n",
       "      <td>4043.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>US</td>\n",
       "      <td>OK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>322.0</td>\n",
       "      <td>377.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>565.0</td>\n",
       "      <td>719.0</td>\n",
       "      <td>879.0</td>\n",
       "      <td>988.0</td>\n",
       "      <td>1159.0</td>\n",
       "      <td>1252.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>US</td>\n",
       "      <td>OR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>...</td>\n",
       "      <td>414.0</td>\n",
       "      <td>479.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>606.0</td>\n",
       "      <td>690.0</td>\n",
       "      <td>736.0</td>\n",
       "      <td>826.0</td>\n",
       "      <td>899.0</td>\n",
       "      <td>899.0</td>\n",
       "      <td>999.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>US</td>\n",
       "      <td>PA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2218.0</td>\n",
       "      <td>2751.0</td>\n",
       "      <td>3394.0</td>\n",
       "      <td>4087.0</td>\n",
       "      <td>4843.0</td>\n",
       "      <td>5805.0</td>\n",
       "      <td>7016.0</td>\n",
       "      <td>8420.0</td>\n",
       "      <td>10017.0</td>\n",
       "      <td>11510.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>US</td>\n",
       "      <td>PR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>79.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>174.0</td>\n",
       "      <td>239.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>316.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>452.0</td>\n",
       "      <td>475.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>US</td>\n",
       "      <td>RI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>165.0</td>\n",
       "      <td>203.0</td>\n",
       "      <td>294.0</td>\n",
       "      <td>408.0</td>\n",
       "      <td>488.0</td>\n",
       "      <td>566.0</td>\n",
       "      <td>657.0</td>\n",
       "      <td>711.0</td>\n",
       "      <td>806.0</td>\n",
       "      <td>922.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>US</td>\n",
       "      <td>SC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>...</td>\n",
       "      <td>456.0</td>\n",
       "      <td>539.0</td>\n",
       "      <td>774.0</td>\n",
       "      <td>925.0</td>\n",
       "      <td>1083.0</td>\n",
       "      <td>1293.0</td>\n",
       "      <td>1554.0</td>\n",
       "      <td>1554.0</td>\n",
       "      <td>1917.0</td>\n",
       "      <td>2049.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>US</td>\n",
       "      <td>SD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>58.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>129.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>212.0</td>\n",
       "      <td>240.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>US</td>\n",
       "      <td>TN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1203.0</td>\n",
       "      <td>1373.0</td>\n",
       "      <td>1537.0</td>\n",
       "      <td>1834.0</td>\n",
       "      <td>2239.0</td>\n",
       "      <td>2683.0</td>\n",
       "      <td>2845.0</td>\n",
       "      <td>3067.0</td>\n",
       "      <td>3321.0</td>\n",
       "      <td>3633.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>US</td>\n",
       "      <td>TX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1731.0</td>\n",
       "      <td>2052.0</td>\n",
       "      <td>2552.0</td>\n",
       "      <td>2877.0</td>\n",
       "      <td>3266.0</td>\n",
       "      <td>3997.0</td>\n",
       "      <td>4669.0</td>\n",
       "      <td>5330.0</td>\n",
       "      <td>6110.0</td>\n",
       "      <td>6812.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>US</td>\n",
       "      <td>UT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>480.0</td>\n",
       "      <td>602.0</td>\n",
       "      <td>719.0</td>\n",
       "      <td>806.0</td>\n",
       "      <td>887.0</td>\n",
       "      <td>1012.0</td>\n",
       "      <td>1074.0</td>\n",
       "      <td>1246.0</td>\n",
       "      <td>1428.0</td>\n",
       "      <td>1605.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>US</td>\n",
       "      <td>VA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>604.0</td>\n",
       "      <td>739.0</td>\n",
       "      <td>890.0</td>\n",
       "      <td>1020.0</td>\n",
       "      <td>1250.0</td>\n",
       "      <td>1484.0</td>\n",
       "      <td>1706.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>2407.0</td>\n",
       "      <td>2637.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>US</td>\n",
       "      <td>VI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>19.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>US</td>\n",
       "      <td>VT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>184.0</td>\n",
       "      <td>211.0</td>\n",
       "      <td>235.0</td>\n",
       "      <td>256.0</td>\n",
       "      <td>293.0</td>\n",
       "      <td>321.0</td>\n",
       "      <td>338.0</td>\n",
       "      <td>389.0</td>\n",
       "      <td>461.0</td>\n",
       "      <td>512.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>US</td>\n",
       "      <td>WA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>102.0</td>\n",
       "      <td>102.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3207.0</td>\n",
       "      <td>3723.0</td>\n",
       "      <td>4310.0</td>\n",
       "      <td>4896.0</td>\n",
       "      <td>4896.0</td>\n",
       "      <td>5634.0</td>\n",
       "      <td>5984.0</td>\n",
       "      <td>6585.0</td>\n",
       "      <td>6966.0</td>\n",
       "      <td>7591.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>US</td>\n",
       "      <td>WI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>842.0</td>\n",
       "      <td>989.0</td>\n",
       "      <td>1112.0</td>\n",
       "      <td>1221.0</td>\n",
       "      <td>1351.0</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>1730.0</td>\n",
       "      <td>1912.0</td>\n",
       "      <td>2112.0</td>\n",
       "      <td>2267.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>US</td>\n",
       "      <td>WV</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>76.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>191.0</td>\n",
       "      <td>217.0</td>\n",
       "      <td>237.0</td>\n",
       "      <td>282.0</td>\n",
       "      <td>324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>US</td>\n",
       "      <td>WY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>109.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>197.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>56 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Country/Region Province/State  Lat  Long  3/04/20  3/05/20  3/06/20  \\\n",
       "0              US             AK  NaN   NaN      NaN      NaN      0.0   \n",
       "1              US             AL  NaN   NaN      NaN      NaN      NaN   \n",
       "2              US             AR  NaN   NaN      NaN      NaN      0.0   \n",
       "3              US             AS  NaN   NaN      NaN      NaN      NaN   \n",
       "4              US             AZ  NaN   NaN      2.0      2.0      3.0   \n",
       "5              US             CA  NaN   NaN     53.0     53.0     60.0   \n",
       "6              US             CO  NaN   NaN      NaN      0.0      2.0   \n",
       "7              US             CT  NaN   NaN      NaN      NaN      NaN   \n",
       "8              US             DC  NaN   NaN      NaN      0.0      0.0   \n",
       "9              US             DE  NaN   NaN      NaN      NaN      0.0   \n",
       "10             US             FL  NaN   NaN      2.0      9.0      9.0   \n",
       "11             US             GA  NaN   NaN      2.0      2.0      2.0   \n",
       "12             US             GU  NaN   NaN      NaN      NaN      NaN   \n",
       "13             US             HI  NaN   NaN      NaN      NaN      NaN   \n",
       "14             US             IA  NaN   NaN      NaN      NaN      0.0   \n",
       "15             US             ID  NaN   NaN      NaN      NaN      NaN   \n",
       "16             US             IL  NaN   NaN      4.0      5.0      5.0   \n",
       "17             US             IN  NaN   NaN      NaN      NaN      1.0   \n",
       "18             US             KS  NaN   NaN      NaN      NaN      0.0   \n",
       "19             US             KY  NaN   NaN      NaN      NaN      0.0   \n",
       "20             US             LA  NaN   NaN      NaN      NaN      NaN   \n",
       "21             US             MA  NaN   NaN      2.0      2.0      8.0   \n",
       "22             US             MD  NaN   NaN      NaN      0.0      3.0   \n",
       "23             US             ME  NaN   NaN      NaN      NaN      NaN   \n",
       "24             US             MI  NaN   NaN      NaN      0.0      0.0   \n",
       "25             US             MN  NaN   NaN      NaN      NaN      0.0   \n",
       "26             US             MO  NaN   NaN      NaN      NaN      NaN   \n",
       "27             US             MP  NaN   NaN      NaN      NaN      NaN   \n",
       "28             US             MS  NaN   NaN      NaN      NaN      NaN   \n",
       "29             US             MT  NaN   NaN      NaN      NaN      NaN   \n",
       "30             US             NC  NaN   NaN      1.0      1.0      2.0   \n",
       "31             US             ND  NaN   NaN      NaN      NaN      NaN   \n",
       "32             US             NE  NaN   NaN      NaN      0.0      0.0   \n",
       "33             US             NH  NaN   NaN      2.0      2.0      2.0   \n",
       "34             US             NJ  NaN   NaN      NaN      1.0      1.0   \n",
       "35             US             NM  NaN   NaN      NaN      NaN      0.0   \n",
       "36             US             NV  NaN   NaN      NaN      1.0      1.0   \n",
       "37             US             NY  NaN   NaN      6.0     22.0     33.0   \n",
       "38             US             OH  NaN   NaN      NaN      0.0      0.0   \n",
       "39             US             OK  NaN   NaN      NaN      NaN      NaN   \n",
       "40             US             OR  NaN   NaN      3.0      3.0      3.0   \n",
       "41             US             PA  NaN   NaN      NaN      NaN      2.0   \n",
       "42             US             PR  NaN   NaN      NaN      NaN      NaN   \n",
       "43             US             RI  NaN   NaN      NaN      NaN      NaN   \n",
       "44             US             SC  NaN   NaN      0.0      0.0      0.0   \n",
       "45             US             SD  NaN   NaN      NaN      NaN      NaN   \n",
       "46             US             TN  NaN   NaN      NaN      1.0      1.0   \n",
       "47             US             TX  NaN   NaN      1.0      1.0      5.0   \n",
       "48             US             UT  NaN   NaN      NaN      NaN      NaN   \n",
       "49             US             VA  NaN   NaN      NaN      0.0      0.0   \n",
       "50             US             VI  NaN   NaN      NaN      NaN      NaN   \n",
       "51             US             VT  NaN   NaN      NaN      NaN      0.0   \n",
       "52             US             WA  NaN   NaN     39.0     70.0     79.0   \n",
       "53             US             WI  NaN   NaN      1.0      1.0      1.0   \n",
       "54             US             WV  NaN   NaN      NaN      NaN      0.0   \n",
       "55             US             WY  NaN   NaN      NaN      NaN      NaN   \n",
       "\n",
       "    3/07/20  3/08/20  3/09/20  ...  3/27/20  3/28/20  3/29/20  3/30/20  \\\n",
       "0       0.0      0.0      0.0  ...     69.0     85.0    102.0    114.0   \n",
       "1       0.0      0.0      0.0  ...    587.0    696.0    806.0    859.0   \n",
       "2       0.0      0.0      0.0  ...    381.0    404.0    426.0    473.0   \n",
       "3       NaN      NaN      NaN  ...      0.0      0.0      NaN      NaN   \n",
       "4       5.0      5.0      5.0  ...    736.0    873.0    919.0   1157.0   \n",
       "5      69.0     88.0    114.0  ...   3879.0   4643.0   5708.0   6447.0   \n",
       "6       8.0      8.0      9.0  ...   1430.0   1734.0   2061.0   2627.0   \n",
       "7       0.0      1.0      1.0  ...   1291.0   1291.0   1993.0   2571.0   \n",
       "8       0.0      1.0      1.0  ...    267.0    304.0    342.0    401.0   \n",
       "9       0.0      0.0      0.0  ...    163.0    214.0    232.0    264.0   \n",
       "10     14.0     17.0     18.0  ...   2765.0   3763.0   4246.0   5473.0   \n",
       "11      6.0      7.0     12.0  ...   2001.0   2366.0   2651.0   2809.0   \n",
       "12      NaN      NaN      NaN  ...     51.0     55.0     56.0     58.0   \n",
       "13      1.0      1.0      2.0  ...    106.0    120.0    151.0    175.0   \n",
       "14      0.0      0.0      3.0  ...    235.0    298.0    336.0    424.0   \n",
       "15      0.0      0.0      0.0  ...    189.0    230.0    261.0    310.0   \n",
       "16      6.0      6.0      7.0  ...   3026.0   3491.0   4596.0   5057.0   \n",
       "17      1.0      2.0      2.0  ...    981.0   1232.0   1514.0   1786.0   \n",
       "18      0.0      1.0      1.0  ...    202.0    261.0    319.0    368.0   \n",
       "19      1.0      1.0      4.0  ...    248.0    302.0    394.0    439.0   \n",
       "20      0.0      0.0      1.0  ...   2746.0   3315.0   3540.0   4025.0   \n",
       "21     13.0     13.0     41.0  ...   3240.0   4257.0   4955.0   5752.0   \n",
       "22      3.0      3.0      5.0  ...    774.0    992.0   1239.0   1413.0   \n",
       "23      0.0      0.0      0.0  ...    168.0    211.0    253.0    275.0   \n",
       "24      0.0      0.0      0.0  ...   3657.0   3657.0   5486.0   6498.0   \n",
       "25      1.0      1.0      2.0  ...    398.0    441.0    503.0    576.0   \n",
       "26      0.0      1.0      1.0  ...    669.0    838.0    838.0   1031.0   \n",
       "27      NaN      NaN      NaN  ...      0.0      2.0      2.0      2.0   \n",
       "28      0.0      0.0      0.0  ...    579.0    663.0    758.0    847.0   \n",
       "29      0.0      0.0      0.0  ...    108.0    129.0    154.0    171.0   \n",
       "30      2.0      2.0      2.0  ...    763.0    935.0   1040.0   1307.0   \n",
       "31      0.0      0.0      0.0  ...     65.0     83.0     98.0    109.0   \n",
       "32      1.0      1.0      3.0  ...     85.0     96.0    108.0    145.0   \n",
       "33      2.0      4.0      4.0  ...    158.0    187.0    214.0    314.0   \n",
       "34      4.0      6.0     11.0  ...   8825.0  11124.0  13386.0  16636.0   \n",
       "35      0.0      0.0      0.0  ...    136.0    191.0    237.0    237.0   \n",
       "36      1.0      1.0      1.0  ...    535.0    621.0    738.0   1008.0   \n",
       "37     76.0    105.0    142.0  ...  44635.0  52318.0  59513.0  66497.0   \n",
       "38      0.0      0.0      3.0  ...   1137.0   1406.0   1653.0   1933.0   \n",
       "39      1.0      1.0      1.0  ...    322.0    377.0    429.0    481.0   \n",
       "40      7.0     14.0     14.0  ...    414.0    479.0    548.0    606.0   \n",
       "41      2.0      4.0      7.0  ...   2218.0   2751.0   3394.0   4087.0   \n",
       "42      NaN      NaN      NaN  ...     79.0    100.0    127.0    174.0   \n",
       "43      2.0      3.0      3.0  ...    165.0    203.0    294.0    408.0   \n",
       "44      2.0      2.0      7.0  ...    456.0    539.0    774.0    925.0   \n",
       "45      0.0      0.0      0.0  ...     58.0     68.0     90.0    101.0   \n",
       "46      1.0      3.0      3.0  ...   1203.0   1373.0   1537.0   1834.0   \n",
       "47      8.0      8.0     12.0  ...   1731.0   2052.0   2552.0   2877.0   \n",
       "48      1.0      1.0      1.0  ...    480.0    602.0    719.0    806.0   \n",
       "49      0.0      2.0      3.0  ...    604.0    739.0    890.0   1020.0   \n",
       "50      NaN      NaN      NaN  ...     19.0     22.0     23.0     30.0   \n",
       "51      0.0      1.0      1.0  ...    184.0    211.0    235.0    256.0   \n",
       "52    102.0    102.0    136.0  ...   3207.0   3723.0   4310.0   4896.0   \n",
       "53      1.0      1.0      1.0  ...    842.0    989.0   1112.0   1221.0   \n",
       "54      0.0      0.0      0.0  ...     76.0     96.0    113.0    126.0   \n",
       "55      0.0      0.0      0.0  ...     70.0     82.0     86.0     94.0   \n",
       "\n",
       "    3/31/20  4/01/20  4/02/20   4/03/20   4/04/20   4/05/20  \n",
       "0     119.0    133.0    143.0     157.0     171.0     185.0  \n",
       "1     981.0   1077.0   1233.0    1432.0    1580.0    1796.0  \n",
       "2     523.0    584.0    643.0     704.0     743.0     830.0  \n",
       "3       NaN      0.0      0.0       NaN       NaN       0.0  \n",
       "4    1289.0   1413.0   1598.0    1769.0    2019.0    2269.0  \n",
       "5    7482.0   8155.0   9191.0   10701.0   12026.0   13438.0  \n",
       "6    2627.0   2966.0   3342.0    3728.0    4173.0    4565.0  \n",
       "7    3128.0   3557.0   3824.0    4914.0    5276.0    5675.0  \n",
       "8     495.0    586.0    653.0     757.0     902.0     998.0  \n",
       "9     319.0    368.0    393.0     450.0     593.0     673.0  \n",
       "10   6338.0   6955.0   8010.0    9585.0   11111.0   12151.0  \n",
       "11   3929.0   4638.0   5348.0    5831.0    6160.0    6647.0  \n",
       "12     69.0     77.0     82.0      84.0      93.0     112.0  \n",
       "13    204.0    208.0    258.0     285.0     319.0     351.0  \n",
       "14    497.0    549.0    614.0     699.0     786.0     868.0  \n",
       "15    415.0    525.0    669.0     891.0    1013.0    1077.0  \n",
       "16   5994.0   6980.0   7695.0    8904.0   10357.0   11256.0  \n",
       "17   2159.0   2565.0   3039.0    3437.0    3953.0    4411.0  \n",
       "18    428.0    482.0    552.0     620.0     698.0     747.0  \n",
       "19    480.0    591.0    680.0     770.0     831.0     917.0  \n",
       "20   5237.0   6424.0   9150.0   10297.0   12496.0   13010.0  \n",
       "21   6620.0   7738.0   8966.0   10402.0   11736.0   12500.0  \n",
       "22   1660.0   1985.0   2331.0    2758.0    3125.0    3609.0  \n",
       "23    303.0    344.0    376.0     432.0     456.0     470.0  \n",
       "24   7615.0   9334.0  10791.0   12744.0   14225.0   15718.0  \n",
       "25    629.0    689.0    742.0     789.0     865.0     935.0  \n",
       "26   1327.0   1581.0   1834.0    2113.0    2291.0    2367.0  \n",
       "27      2.0      6.0      8.0       8.0       8.0       8.0  \n",
       "28    937.0   1073.0   1177.0    1358.0    1455.0    1638.0  \n",
       "29    184.0    208.0    227.0     243.0     265.0     286.0  \n",
       "30   1498.0   1584.0   1857.0    2093.0    2402.0    2585.0  \n",
       "31    126.0    142.0    159.0     173.0     186.0     207.0  \n",
       "32    172.0    210.0    246.0     279.0     321.0     363.0  \n",
       "33    314.0    415.0    415.0     479.0     540.0     621.0  \n",
       "34  18696.0  22255.0  25590.0   29895.0   34124.0   37505.0  \n",
       "35    281.0    315.0    363.0     403.0     495.0     543.0  \n",
       "36   1113.0   1279.0   1458.0    1514.0    1742.0    1836.0  \n",
       "37  75795.0  83712.0  92381.0  102863.0  113704.0  122031.0  \n",
       "38   2199.0   2547.0   2902.0    3312.0    3739.0    4043.0  \n",
       "39    565.0    719.0    879.0     988.0    1159.0    1252.0  \n",
       "40    690.0    736.0    826.0     899.0     899.0     999.0  \n",
       "41   4843.0   5805.0   7016.0    8420.0   10017.0   11510.0  \n",
       "42    239.0    286.0    316.0     378.0     452.0     475.0  \n",
       "43    488.0    566.0    657.0     711.0     806.0     922.0  \n",
       "44   1083.0   1293.0   1554.0    1554.0    1917.0    2049.0  \n",
       "45    108.0    129.0    165.0     187.0     212.0     240.0  \n",
       "46   2239.0   2683.0   2845.0    3067.0    3321.0    3633.0  \n",
       "47   3266.0   3997.0   4669.0    5330.0    6110.0    6812.0  \n",
       "48    887.0   1012.0   1074.0    1246.0    1428.0    1605.0  \n",
       "49   1250.0   1484.0   1706.0    2012.0    2407.0    2637.0  \n",
       "50     30.0     30.0     33.0      38.0      40.0      42.0  \n",
       "51    293.0    321.0    338.0     389.0     461.0     512.0  \n",
       "52   4896.0   5634.0   5984.0    6585.0    6966.0    7591.0  \n",
       "53   1351.0   1550.0   1730.0    1912.0    2112.0    2267.0  \n",
       "54    162.0    191.0    217.0     237.0     282.0     324.0  \n",
       "55    109.0    130.0    150.0     162.0     187.0     197.0  \n",
       "\n",
       "[56 rows x 37 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(df2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country/Region     object\n",
       "Province/State     object\n",
       "Lat               float64\n",
       "Long              float64\n",
       "3/04/20           float64\n",
       "3/05/20           float64\n",
       "3/06/20           float64\n",
       "3/07/20           float64\n",
       "3/08/20           float64\n",
       "3/09/20           float64\n",
       "3/10/20           float64\n",
       "3/11/20           float64\n",
       "3/12/20           float64\n",
       "3/13/20           float64\n",
       "3/14/20           float64\n",
       "3/15/20           float64\n",
       "3/16/20           float64\n",
       "3/17/20           float64\n",
       "3/18/20           float64\n",
       "3/19/20           float64\n",
       "3/20/20           float64\n",
       "3/21/20           float64\n",
       "3/22/20           float64\n",
       "3/23/20           float64\n",
       "3/24/20           float64\n",
       "3/25/20           float64\n",
       "3/26/20           float64\n",
       "3/27/20           float64\n",
       "3/28/20           float64\n",
       "3/29/20           float64\n",
       "3/30/20           float64\n",
       "3/31/20           float64\n",
       "4/01/20           float64\n",
       "4/02/20           float64\n",
       "4/03/20           float64\n",
       "4/04/20           float64\n",
       "4/05/20           float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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
}