covidtracking.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Save data to the project and do some exploration if desired"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "from datetime import datetime\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "usin = 'https://covidtracking.com/api/us/daily.csv'\n",
    "statesin = 'https://covidtracking.com/api/v1/states/current.csv'\n",
    "\n",
    "usout = '../data/raw/covidtracking/us_historical.csv'\n",
    "statesout = '../data/raw/covidtracking/states_historical.csv'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### not going to merge in the numbers from the current day, but you can do so if you like"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>positive</th>\n",
       "      <th>negative</th>\n",
       "      <th>pending</th>\n",
       "      <th>hospitalizedCurrently</th>\n",
       "      <th>hospitalizedCumulative</th>\n",
       "      <th>inIcuCurrently</th>\n",
       "      <th>inIcuCumulative</th>\n",
       "      <th>onVentilatorCurrently</th>\n",
       "      <th>onVentilatorCumulative</th>\n",
       "      <th>recovered</th>\n",
       "      <th>hash</th>\n",
       "      <th>lastModified</th>\n",
       "      <th>death</th>\n",
       "      <th>hospitalized</th>\n",
       "      <th>total</th>\n",
       "      <th>totalTestResults</th>\n",
       "      <th>posNeg</th>\n",
       "      <th>notes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>801038</td>\n",
       "      <td>3362426</td>\n",
       "      <td>11194</td>\n",
       "      <td>58542</td>\n",
       "      <td>84657</td>\n",
       "      <td>15251</td>\n",
       "      <td>2291</td>\n",
       "      <td>5544</td>\n",
       "      <td>214</td>\n",
       "      <td>59697</td>\n",
       "      <td>6f6c3725f25cfeffee7b646e4c7274565d95f332</td>\n",
       "      <td>4/22/2020</td>\n",
       "      <td>40097</td>\n",
       "      <td>84657</td>\n",
       "      <td>4174658</td>\n",
       "      <td>4163464</td>\n",
       "      <td>4163464</td>\n",
       "      <td>NOTE: \"total\", \"posNeg\", \"hospitalized\" will b...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   positive  negative  pending  hospitalizedCurrently  hospitalizedCumulative  \\\n",
       "0    801038   3362426    11194                  58542                   84657   \n",
       "\n",
       "   inIcuCurrently  inIcuCumulative  onVentilatorCurrently  \\\n",
       "0           15251             2291                   5544   \n",
       "\n",
       "   onVentilatorCumulative  recovered  \\\n",
       "0                     214      59697   \n",
       "\n",
       "                                       hash lastModified  death  hospitalized  \\\n",
       "0  6f6c3725f25cfeffee7b646e4c7274565d95f332    4/22/2020  40097         84657   \n",
       "\n",
       "     total  totalTestResults   posNeg  \\\n",
       "0  4174658           4163464  4163464   \n",
       "\n",
       "                                               notes  \n",
       "0  NOTE: \"total\", \"posNeg\", \"hospitalized\" will b...  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_csv('https://covidtracking.com/api/v1/us/current.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>state</th>\n",
       "      <th>positive</th>\n",
       "      <th>positiveScore</th>\n",
       "      <th>negativeScore</th>\n",
       "      <th>negativeRegularScore</th>\n",
       "      <th>commercialScore</th>\n",
       "      <th>grade</th>\n",
       "      <th>score</th>\n",
       "      <th>negative</th>\n",
       "      <th>pending</th>\n",
       "      <th>...</th>\n",
       "      <th>death</th>\n",
       "      <th>hospitalized</th>\n",
       "      <th>total</th>\n",
       "      <th>totalTestResults</th>\n",
       "      <th>posNeg</th>\n",
       "      <th>fips</th>\n",
       "      <th>dateModified</th>\n",
       "      <th>dateChecked</th>\n",
       "      <th>notes</th>\n",
       "      <th>hash</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AK</td>\n",
       "      <td>329</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>A</td>\n",
       "      <td>4.0</td>\n",
       "      <td>10790</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>11119</td>\n",
       "      <td>11119</td>\n",
       "      <td>11119</td>\n",
       "      <td>2</td>\n",
       "      <td>2020-04-21T19:15:00Z</td>\n",
       "      <td>2020-04-21T19:32:00Z</td>\n",
       "      <td>Please stop using the \"total\" field. Use \"tota...</td>\n",
       "      <td>21e3abbf65693963556e477f74528ac4437f9ef1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AL</td>\n",
       "      <td>5327</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>B</td>\n",
       "      <td>3.0</td>\n",
       "      <td>43295</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>186.0</td>\n",
       "      <td>697.0</td>\n",
       "      <td>48622</td>\n",
       "      <td>48622</td>\n",
       "      <td>48622</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-04-21T04:00:00Z</td>\n",
       "      <td>2020-04-22T03:00:00Z</td>\n",
       "      <td>Please stop using the \"total\" field. Use \"tota...</td>\n",
       "      <td>f0de445f1b0d603197e43096a60fa545a9ab5860</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  state  positive  positiveScore  negativeScore  negativeRegularScore  \\\n",
       "0    AK       329            1.0            1.0                   1.0   \n",
       "1    AL      5327            1.0            1.0                   0.0   \n",
       "\n",
       "   commercialScore grade  score  negative  pending  ...  death  hospitalized  \\\n",
       "0              1.0     A    4.0     10790      NaN  ...    9.0          36.0   \n",
       "1              1.0     B    3.0     43295      NaN  ...  186.0         697.0   \n",
       "\n",
       "   total  totalTestResults  posNeg  fips          dateModified  \\\n",
       "0  11119             11119   11119     2  2020-04-21T19:15:00Z   \n",
       "1  48622             48622   48622     1  2020-04-21T04:00:00Z   \n",
       "\n",
       "            dateChecked                                              notes  \\\n",
       "0  2020-04-21T19:32:00Z  Please stop using the \"total\" field. Use \"tota...   \n",
       "1  2020-04-22T03:00:00Z  Please stop using the \"total\" field. Use \"tota...   \n",
       "\n",
       "                                       hash  \n",
       "0  21e3abbf65693963556e477f74528ac4437f9ef1  \n",
       "1  f0de445f1b0d603197e43096a60fa545a9ab5860  \n",
       "\n",
       "[2 rows x 29 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_csv('https://covidtracking.com/api/v1/states/current.csv').head(2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### get historical numbers"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(usin)\n",
    "dfs = pd.read_csv(statesin)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(usout)\n",
    "dfs.to_csv(statesout)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### brief exploration"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>states</th>\n",
       "      <th>positive</th>\n",
       "      <th>negative</th>\n",
       "      <th>pending</th>\n",
       "      <th>hospitalizedCurrently</th>\n",
       "      <th>hospitalizedCumulative</th>\n",
       "      <th>inIcuCurrently</th>\n",
       "      <th>inIcuCumulative</th>\n",
       "      <th>onVentilatorCurrently</th>\n",
       "      <th>...</th>\n",
       "      <th>death</th>\n",
       "      <th>hospitalized</th>\n",
       "      <th>total</th>\n",
       "      <th>totalTestResults</th>\n",
       "      <th>posNeg</th>\n",
       "      <th>deathIncrease</th>\n",
       "      <th>hospitalizedIncrease</th>\n",
       "      <th>negativeIncrease</th>\n",
       "      <th>positiveIncrease</th>\n",
       "      <th>totalTestResultsIncrease</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20200421</td>\n",
       "      <td>56</td>\n",
       "      <td>799717</td>\n",
       "      <td>3355461.0</td>\n",
       "      <td>3956.0</td>\n",
       "      <td>58468.0</td>\n",
       "      <td>84292.0</td>\n",
       "      <td>15228.0</td>\n",
       "      <td>2315.0</td>\n",
       "      <td>5514.0</td>\n",
       "      <td>...</td>\n",
       "      <td>39995</td>\n",
       "      <td>84292.0</td>\n",
       "      <td>4159134</td>\n",
       "      <td>4155178</td>\n",
       "      <td>4155178</td>\n",
       "      <td>2674.0</td>\n",
       "      <td>1413.0</td>\n",
       "      <td>124434.0</td>\n",
       "      <td>27193.0</td>\n",
       "      <td>151627.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20200420</td>\n",
       "      <td>56</td>\n",
       "      <td>772524</td>\n",
       "      <td>3231027.0</td>\n",
       "      <td>4037.0</td>\n",
       "      <td>55509.0</td>\n",
       "      <td>82879.0</td>\n",
       "      <td>14691.0</td>\n",
       "      <td>2193.0</td>\n",
       "      <td>5567.0</td>\n",
       "      <td>...</td>\n",
       "      <td>37321</td>\n",
       "      <td>82879.0</td>\n",
       "      <td>4007588</td>\n",
       "      <td>4003551</td>\n",
       "      <td>4003551</td>\n",
       "      <td>1528.0</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>114366.0</td>\n",
       "      <td>23321.0</td>\n",
       "      <td>137687.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20200419</td>\n",
       "      <td>56</td>\n",
       "      <td>749203</td>\n",
       "      <td>3116661.0</td>\n",
       "      <td>11324.0</td>\n",
       "      <td>55565.0</td>\n",
       "      <td>80881.0</td>\n",
       "      <td>14548.0</td>\n",
       "      <td>2145.0</td>\n",
       "      <td>5603.0</td>\n",
       "      <td>...</td>\n",
       "      <td>35793</td>\n",
       "      <td>80881.0</td>\n",
       "      <td>3877188</td>\n",
       "      <td>3865864</td>\n",
       "      <td>3865864</td>\n",
       "      <td>1654.0</td>\n",
       "      <td>2042.0</td>\n",
       "      <td>140309.0</td>\n",
       "      <td>27021.0</td>\n",
       "      <td>167330.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20200418</td>\n",
       "      <td>56</td>\n",
       "      <td>722182</td>\n",
       "      <td>2976352.0</td>\n",
       "      <td>9906.0</td>\n",
       "      <td>56575.0</td>\n",
       "      <td>78839.0</td>\n",
       "      <td>14788.0</td>\n",
       "      <td>2096.0</td>\n",
       "      <td>5729.0</td>\n",
       "      <td>...</td>\n",
       "      <td>34139</td>\n",
       "      <td>78839.0</td>\n",
       "      <td>3708440</td>\n",
       "      <td>3698534</td>\n",
       "      <td>3698534</td>\n",
       "      <td>1774.0</td>\n",
       "      <td>884.0</td>\n",
       "      <td>113379.0</td>\n",
       "      <td>27662.0</td>\n",
       "      <td>141041.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>20200417</td>\n",
       "      <td>56</td>\n",
       "      <td>694520</td>\n",
       "      <td>2862973.0</td>\n",
       "      <td>10889.0</td>\n",
       "      <td>57858.0</td>\n",
       "      <td>77955.0</td>\n",
       "      <td>14910.0</td>\n",
       "      <td>2052.0</td>\n",
       "      <td>6096.0</td>\n",
       "      <td>...</td>\n",
       "      <td>32365</td>\n",
       "      <td>77955.0</td>\n",
       "      <td>3568382</td>\n",
       "      <td>3557493</td>\n",
       "      <td>3557493</td>\n",
       "      <td>2069.0</td>\n",
       "      <td>3250.0</td>\n",
       "      <td>125169.0</td>\n",
       "      <td>31260.0</td>\n",
       "      <td>156429.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       date  states  positive   negative  pending  hospitalizedCurrently  \\\n",
       "0  20200421      56    799717  3355461.0   3956.0                58468.0   \n",
       "1  20200420      56    772524  3231027.0   4037.0                55509.0   \n",
       "2  20200419      56    749203  3116661.0  11324.0                55565.0   \n",
       "3  20200418      56    722182  2976352.0   9906.0                56575.0   \n",
       "4  20200417      56    694520  2862973.0  10889.0                57858.0   \n",
       "\n",
       "   hospitalizedCumulative  inIcuCurrently  inIcuCumulative  \\\n",
       "0                 84292.0         15228.0           2315.0   \n",
       "1                 82879.0         14691.0           2193.0   \n",
       "2                 80881.0         14548.0           2145.0   \n",
       "3                 78839.0         14788.0           2096.0   \n",
       "4                 77955.0         14910.0           2052.0   \n",
       "\n",
       "   onVentilatorCurrently  ...  death  hospitalized    total totalTestResults  \\\n",
       "0                 5514.0  ...  39995       84292.0  4159134          4155178   \n",
       "1                 5567.0  ...  37321       82879.0  4007588          4003551   \n",
       "2                 5603.0  ...  35793       80881.0  3877188          3865864   \n",
       "3                 5729.0  ...  34139       78839.0  3708440          3698534   \n",
       "4                 6096.0  ...  32365       77955.0  3568382          3557493   \n",
       "\n",
       "    posNeg  deathIncrease  hospitalizedIncrease  negativeIncrease  \\\n",
       "0  4155178         2674.0                1413.0          124434.0   \n",
       "1  4003551         1528.0                1998.0          114366.0   \n",
       "2  3865864         1654.0                2042.0          140309.0   \n",
       "3  3698534         1774.0                 884.0          113379.0   \n",
       "4  3557493         2069.0                3250.0          125169.0   \n",
       "\n",
       "   positiveIncrease  totalTestResultsIncrease  \n",
       "0           27193.0                  151627.0  \n",
       "1           23321.0                  137687.0  \n",
       "2           27021.0                  167330.0  \n",
       "3           27662.0                  141041.0  \n",
       "4           31260.0                  156429.0  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>date</th>\n",
       "      <th>states</th>\n",
       "      <th>positive</th>\n",
       "      <th>negative</th>\n",
       "      <th>pending</th>\n",
       "      <th>hospitalizedCurrently</th>\n",
       "      <th>hospitalizedCumulative</th>\n",
       "      <th>inIcuCurrently</th>\n",
       "      <th>inIcuCumulative</th>\n",
       "      <th>onVentilatorCurrently</th>\n",
       "      <th>...</th>\n",
       "      <th>death</th>\n",
       "      <th>hospitalized</th>\n",
       "      <th>total</th>\n",
       "      <th>totalTestResults</th>\n",
       "      <th>posNeg</th>\n",
       "      <th>deathIncrease</th>\n",
       "      <th>hospitalizedIncrease</th>\n",
       "      <th>negativeIncrease</th>\n",
       "      <th>positiveIncrease</th>\n",
       "      <th>totalTestResultsIncrease</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>5.400000e+01</td>\n",
       "      <td>54.000000</td>\n",
       "      <td>54.000000</td>\n",
       "      <td>5.000000e+01</td>\n",
       "      <td>49.000000</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>32.000000</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>28.000000</td>\n",
       "      <td>28.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>54.000000</td>\n",
       "      <td>32.000000</td>\n",
       "      <td>5.400000e+01</td>\n",
       "      <td>5.400000e+01</td>\n",
       "      <td>5.400000e+01</td>\n",
       "      <td>53.000000</td>\n",
       "      <td>53.000000</td>\n",
       "      <td>53.000000</td>\n",
       "      <td>53.000000</td>\n",
       "      <td>53.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2.020035e+07</td>\n",
       "      <td>48.518519</td>\n",
       "      <td>221057.462963</td>\n",
       "      <td>1.014031e+06</td>\n",
       "      <td>18919.551020</td>\n",
       "      <td>33405.870968</td>\n",
       "      <td>41293.843750</td>\n",
       "      <td>9235.111111</td>\n",
       "      <td>1033.571429</td>\n",
       "      <td>3323.964286</td>\n",
       "      <td>...</td>\n",
       "      <td>8445.000000</td>\n",
       "      <td>41293.843750</td>\n",
       "      <td>1.177143e+06</td>\n",
       "      <td>1.159975e+06</td>\n",
       "      <td>1.159975e+06</td>\n",
       "      <td>754.547170</td>\n",
       "      <td>1590.415094</td>\n",
       "      <td>63310.584906</td>\n",
       "      <td>15088.830189</td>\n",
       "      <td>78399.415094</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>5.261954e+01</td>\n",
       "      <td>16.598182</td>\n",
       "      <td>264891.447008</td>\n",
       "      <td>1.100562e+06</td>\n",
       "      <td>22631.721321</td>\n",
       "      <td>21467.973438</td>\n",
       "      <td>27746.699318</td>\n",
       "      <td>5244.829544</td>\n",
       "      <td>760.512567</td>\n",
       "      <td>2614.239136</td>\n",
       "      <td>...</td>\n",
       "      <td>12172.962724</td>\n",
       "      <td>27746.699318</td>\n",
       "      <td>1.359402e+06</td>\n",
       "      <td>1.356417e+06</td>\n",
       "      <td>1.356417e+06</td>\n",
       "      <td>859.998537</td>\n",
       "      <td>1599.320991</td>\n",
       "      <td>53644.980070</td>\n",
       "      <td>13037.045747</td>\n",
       "      <td>66327.965775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2.020023e+07</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>103.000000</td>\n",
       "      <td>112.000000</td>\n",
       "      <td>1964.000000</td>\n",
       "      <td>1299.000000</td>\n",
       "      <td>74.000000</td>\n",
       "      <td>167.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>1964.000000</td>\n",
       "      <td>9.000000e+00</td>\n",
       "      <td>9.000000e+00</td>\n",
       "      <td>9.000000e+00</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>9.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2.020031e+07</td>\n",
       "      <td>51.000000</td>\n",
       "      <td>2439.500000</td>\n",
       "      <td>2.599400e+04</td>\n",
       "      <td>1691.000000</td>\n",
       "      <td>14703.500000</td>\n",
       "      <td>15634.500000</td>\n",
       "      <td>4173.500000</td>\n",
       "      <td>364.250000</td>\n",
       "      <td>547.500000</td>\n",
       "      <td>...</td>\n",
       "      <td>52.000000</td>\n",
       "      <td>15634.500000</td>\n",
       "      <td>1.266075e+04</td>\n",
       "      <td>1.187350e+04</td>\n",
       "      <td>1.187350e+04</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3489.000000</td>\n",
       "      <td>751.000000</td>\n",
       "      <td>4240.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2.020033e+07</td>\n",
       "      <td>56.000000</td>\n",
       "      <td>78159.500000</td>\n",
       "      <td>5.785140e+05</td>\n",
       "      <td>14433.000000</td>\n",
       "      <td>32996.000000</td>\n",
       "      <td>41710.500000</td>\n",
       "      <td>9932.000000</td>\n",
       "      <td>906.500000</td>\n",
       "      <td>4103.500000</td>\n",
       "      <td>...</td>\n",
       "      <td>1069.500000</td>\n",
       "      <td>41710.500000</td>\n",
       "      <td>5.366385e+05</td>\n",
       "      <td>4.808955e+05</td>\n",
       "      <td>4.808955e+05</td>\n",
       "      <td>277.000000</td>\n",
       "      <td>1413.000000</td>\n",
       "      <td>73593.000000</td>\n",
       "      <td>17303.000000</td>\n",
       "      <td>93086.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2.020041e+07</td>\n",
       "      <td>56.000000</td>\n",
       "      <td>416755.750000</td>\n",
       "      <td>1.884609e+06</td>\n",
       "      <td>17303.000000</td>\n",
       "      <td>55386.500000</td>\n",
       "      <td>63891.500000</td>\n",
       "      <td>14293.500000</td>\n",
       "      <td>1732.000000</td>\n",
       "      <td>5937.750000</td>\n",
       "      <td>...</td>\n",
       "      <td>14071.750000</td>\n",
       "      <td>63891.500000</td>\n",
       "      <td>2.194733e+06</td>\n",
       "      <td>2.177682e+06</td>\n",
       "      <td>2.177682e+06</td>\n",
       "      <td>1496.000000</td>\n",
       "      <td>2652.000000</td>\n",
       "      <td>111243.000000</td>\n",
       "      <td>27662.000000</td>\n",
       "      <td>139536.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2.020042e+07</td>\n",
       "      <td>56.000000</td>\n",
       "      <td>799717.000000</td>\n",
       "      <td>3.355461e+06</td>\n",
       "      <td>65709.000000</td>\n",
       "      <td>59420.000000</td>\n",
       "      <td>84292.000000</td>\n",
       "      <td>15228.000000</td>\n",
       "      <td>2315.000000</td>\n",
       "      <td>6168.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>39995.000000</td>\n",
       "      <td>84292.000000</td>\n",
       "      <td>4.159134e+06</td>\n",
       "      <td>4.155178e+06</td>\n",
       "      <td>4.155178e+06</td>\n",
       "      <td>2674.000000</td>\n",
       "      <td>5102.000000</td>\n",
       "      <td>195732.000000</td>\n",
       "      <td>34550.000000</td>\n",
       "      <td>229268.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               date     states       positive      negative       pending  \\\n",
       "count  5.400000e+01  54.000000      54.000000  5.000000e+01     49.000000   \n",
       "mean   2.020035e+07  48.518519  221057.462963  1.014031e+06  18919.551020   \n",
       "std    5.261954e+01  16.598182  264891.447008  1.100562e+06  22631.721321   \n",
       "min    2.020023e+07   1.000000       9.000000  6.000000e+00    103.000000   \n",
       "25%    2.020031e+07  51.000000    2439.500000  2.599400e+04   1691.000000   \n",
       "50%    2.020033e+07  56.000000   78159.500000  5.785140e+05  14433.000000   \n",
       "75%    2.020041e+07  56.000000  416755.750000  1.884609e+06  17303.000000   \n",
       "max    2.020042e+07  56.000000  799717.000000  3.355461e+06  65709.000000   \n",
       "\n",
       "       hospitalizedCurrently  hospitalizedCumulative  inIcuCurrently  \\\n",
       "count              31.000000               32.000000       27.000000   \n",
       "mean            33405.870968            41293.843750     9235.111111   \n",
       "std             21467.973438            27746.699318     5244.829544   \n",
       "min               112.000000             1964.000000     1299.000000   \n",
       "25%             14703.500000            15634.500000     4173.500000   \n",
       "50%             32996.000000            41710.500000     9932.000000   \n",
       "75%             55386.500000            63891.500000    14293.500000   \n",
       "max             59420.000000            84292.000000    15228.000000   \n",
       "\n",
       "       inIcuCumulative  onVentilatorCurrently  ...         death  \\\n",
       "count        28.000000              28.000000  ...     54.000000   \n",
       "mean       1033.571429            3323.964286  ...   8445.000000   \n",
       "std         760.512567            2614.239136  ...  12172.962724   \n",
       "min          74.000000             167.000000  ...      4.000000   \n",
       "25%         364.250000             547.500000  ...     52.000000   \n",
       "50%         906.500000            4103.500000  ...   1069.500000   \n",
       "75%        1732.000000            5937.750000  ...  14071.750000   \n",
       "max        2315.000000            6168.000000  ...  39995.000000   \n",
       "\n",
       "       hospitalized         total  totalTestResults        posNeg  \\\n",
       "count     32.000000  5.400000e+01      5.400000e+01  5.400000e+01   \n",
       "mean   41293.843750  1.177143e+06      1.159975e+06  1.159975e+06   \n",
       "std    27746.699318  1.359402e+06      1.356417e+06  1.356417e+06   \n",
       "min     1964.000000  9.000000e+00      9.000000e+00  9.000000e+00   \n",
       "25%    15634.500000  1.266075e+04      1.187350e+04  1.187350e+04   \n",
       "50%    41710.500000  5.366385e+05      4.808955e+05  4.808955e+05   \n",
       "75%    63891.500000  2.194733e+06      2.177682e+06  2.177682e+06   \n",
       "max    84292.000000  4.159134e+06      4.155178e+06  4.155178e+06   \n",
       "\n",
       "       deathIncrease  hospitalizedIncrease  negativeIncrease  \\\n",
       "count      53.000000             53.000000         53.000000   \n",
       "mean      754.547170           1590.415094      63310.584906   \n",
       "std       859.998537           1599.320991      53644.980070   \n",
       "min         1.000000              0.000000          0.000000   \n",
       "25%         8.000000              0.000000       3489.000000   \n",
       "50%       277.000000           1413.000000      73593.000000   \n",
       "75%      1496.000000           2652.000000     111243.000000   \n",
       "max      2674.000000           5102.000000     195732.000000   \n",
       "\n",
       "       positiveIncrease  totalTestResultsIncrease  \n",
       "count         53.000000                 53.000000  \n",
       "mean       15088.830189              78399.415094  \n",
       "std        13037.045747              66327.965775  \n",
       "min            9.000000                  9.000000  \n",
       "25%          751.000000               4240.000000  \n",
       "50%        17303.000000              93086.000000  \n",
       "75%        27662.000000             139536.000000  \n",
       "max        34550.000000             229268.000000  \n",
       "\n",
       "[8 rows x 22 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "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.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}