scripts/covidbr.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 175,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import json\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 174,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Baixa o arquivo\n",
    "json_uf = requests.get('https://xx9p7hp1p7.execute-api.us-east-1.amazonaws.com/prod/PortalMapa',\n",
    "                       headers={'x-parse-application-id': 'unAFkcaNDeXajurGB7LChj8SgQYS2ptm'}).content\n",
    "\n",
    "dados_uf = json.loads(json_uf)['results']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 176,
   "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>nome</th>\n",
       "      <th>qtd_confirmado</th>\n",
       "      <th>qtd_obito</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Acre</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alagoas</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Amapá</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Amazonas</td>\n",
       "      <td>151</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bahia</td>\n",
       "      <td>176</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ceará</td>\n",
       "      <td>372</td>\n",
       "      <td>5</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Distrito Federal</td>\n",
       "      <td>312</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Espírito Santo</td>\n",
       "      <td>72</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Goiás</td>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Maranhão</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Mato Grosso</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Mato Grosso do Sul</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>261</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Paraná</td>\n",
       "      <td>155</td>\n",
       "      <td>3</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Paraíba</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Pará</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Pernambuco</td>\n",
       "      <td>78</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Piauí</td>\n",
       "      <td>16</td>\n",
       "      <td>3</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Rio Grande do Norte</td>\n",
       "      <td>77</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>241</td>\n",
       "      <td>3</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>657</td>\n",
       "      <td>18</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Rondônia</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Roraima</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>197</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Sergipe</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>São Paulo</td>\n",
       "      <td>1517</td>\n",
       "      <td>113</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Tocantins</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:52</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   nome  qtd_confirmado  qtd_obito        date   time\n",
       "0                  Acre              42          0  2020-03-30  19:42\n",
       "1               Alagoas              17          0  2020-03-30  19:43\n",
       "2                 Amapá               8          0  2020-03-30  19:44\n",
       "3              Amazonas             151          1  2020-03-30  19:43\n",
       "4                 Bahia             176          1  2020-03-30  19:44\n",
       "5                 Ceará             372          5  2020-03-30  19:46\n",
       "6      Distrito Federal             312          1  2020-03-30  19:45\n",
       "7        Espírito Santo              72          0  2020-03-30  19:45\n",
       "8                 Goiás              61          1  2020-03-30  19:46\n",
       "9              Maranhão              23          1  2020-03-30  19:45\n",
       "10          Mato Grosso              18          0  2020-03-30  19:47\n",
       "11   Mato Grosso do Sul              44          0  2020-03-30  19:50\n",
       "12         Minas Gerais             261          1  2020-03-30  19:47\n",
       "13               Paraná             155          3  2020-03-30  19:49\n",
       "14              Paraíba              15          0  2020-03-30  19:51\n",
       "15                 Pará              21          0  2020-03-30  19:47\n",
       "16           Pernambuco              78          6  2020-03-30  19:48\n",
       "17                Piauí              16          3  2020-03-30  19:49\n",
       "18  Rio Grande do Norte              77          1  2020-03-30  19:48\n",
       "19    Rio Grande do Sul             241          3  2020-03-30  19:48\n",
       "20       Rio de Janeiro             657         18  2020-03-30  19:49\n",
       "21             Rondônia               6          0  2020-03-30  19:50\n",
       "22              Roraima              16          0  2020-03-30  19:51\n",
       "23       Santa Catarina             197          1  2020-03-30  19:52\n",
       "24              Sergipe              16          0  2020-03-30  19:50\n",
       "25            São Paulo            1517        113  2020-03-30  19:51\n",
       "26            Tocantins              10          0  2020-03-30  19:52"
      ]
     },
     "execution_count": 176,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Importa dados e colunas\n",
    "df = pd.DataFrame(dados_uf)\n",
    "\n",
    "# Ajusta horário\n",
    "df['updatedAt'] = pd.to_datetime(df.updatedAt)\n",
    "df['date'] = df['updatedAt'].dt.date.astype(str)\n",
    "df['hour'] = df['updatedAt'].dt.hour.astype(str)\n",
    "df['minute'] = df['updatedAt'].dt.minute.astype(str)\n",
    "df['time'] =  df['hour'].str.cat(df['minute'], sep=':')\n",
    "\n",
    "# Remove colunas desnecessárias\n",
    "df = df.drop(['objectId', 'latitude', 'longitude','updatedAt',\n",
    "              'createdAt', 'percent','letalidade','hour','minute'], axis=1)\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 168,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Troca nome dos estados para sigla\n",
    "dicionario = {\"Acre\": \"AC\", \"Alagoas\": \"AL\", \"Amapá\": \"AP\", \"Amazonas\": \"AM\", \"Bahia\": \"BA\", \"Ceará\": \"CE\",\n",
    "             \"Distrito Federal\": \"DF\", \"Espírito Santo\": \"ES\", \"Goiás\": \"GO\", \"Maranhão\": \"MA\",\n",
    "              \"Mato Grosso\": \"MT\",\"Mato Grosso do Sul\": \"MS\",\"Minas Gerais\":\"MG\", \"Paraná\": \"PR\",\n",
    "              \"Paraíba\": \"PB\", \"Pará\": \"PA\", \"Pernambuco\": \"PE\", \"Piauí\": \"PI\", \"Rio Grande do Norte\": \"RN\", \n",
    "              \"Rio Grande do Sul\": \"RS\", \"Rio de Janeiro\": \"RJ\", \"Rondônia\": \"RO\", \"Roraima\": \"RR\",\n",
    "              \"São Paulo\": \"SP\", \"Santa Catarina\": \"SC\", \"Sergipe\": \"SE\", \"Tocantins\": \"TO\"\n",
    "             }\n",
    "\n",
    "df = df.replace({\"nome\": dicionario})\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 169,
   "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>uf</th>\n",
       "      <th>cases</th>\n",
       "      <th>deaths</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AC</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AL</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AP</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AM</td>\n",
       "      <td>151</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BA</td>\n",
       "      <td>176</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CE</td>\n",
       "      <td>372</td>\n",
       "      <td>5</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>DF</td>\n",
       "      <td>312</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>ES</td>\n",
       "      <td>72</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>GO</td>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>MA</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>MT</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>MT</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>MG</td>\n",
       "      <td>261</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>PR</td>\n",
       "      <td>155</td>\n",
       "      <td>3</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>PB</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>PA</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>PE</td>\n",
       "      <td>78</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>PI</td>\n",
       "      <td>16</td>\n",
       "      <td>3</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>RN</td>\n",
       "      <td>77</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>RS</td>\n",
       "      <td>241</td>\n",
       "      <td>3</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>RJ</td>\n",
       "      <td>657</td>\n",
       "      <td>18</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>RO</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>RR</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>SC</td>\n",
       "      <td>197</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>SE</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>SP</td>\n",
       "      <td>1517</td>\n",
       "      <td>113</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>TO</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>19:52</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    uf  cases  deaths        date   time\n",
       "0   AC     42       0  2020-03-30  19:42\n",
       "1   AL     17       0  2020-03-30  19:43\n",
       "2   AP      8       0  2020-03-30  19:44\n",
       "3   AM    151       1  2020-03-30  19:43\n",
       "4   BA    176       1  2020-03-30  19:44\n",
       "5   CE    372       5  2020-03-30  19:46\n",
       "6   DF    312       1  2020-03-30  19:45\n",
       "7   ES     72       0  2020-03-30  19:45\n",
       "8   GO     61       1  2020-03-30  19:46\n",
       "9   MA     23       1  2020-03-30  19:45\n",
       "10  MT     18       0  2020-03-30  19:47\n",
       "11  MT     44       0  2020-03-30  19:50\n",
       "12  MG    261       1  2020-03-30  19:47\n",
       "13  PR    155       3  2020-03-30  19:49\n",
       "14  PB     15       0  2020-03-30  19:51\n",
       "15  PA     21       0  2020-03-30  19:47\n",
       "16  PE     78       6  2020-03-30  19:48\n",
       "17  PI     16       3  2020-03-30  19:49\n",
       "18  RN     77       1  2020-03-30  19:48\n",
       "19  RS    241       3  2020-03-30  19:48\n",
       "20  RJ    657      18  2020-03-30  19:49\n",
       "21  RO      6       0  2020-03-30  19:50\n",
       "22  RR     16       0  2020-03-30  19:51\n",
       "23  SC    197       1  2020-03-30  19:52\n",
       "24  SE     16       0  2020-03-30  19:50\n",
       "25  SP   1517     113  2020-03-30  19:51\n",
       "26  TO     10       0  2020-03-30  19:52"
      ]
     },
     "execution_count": 169,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.rename(columns={'nome':'uf', 'qtd_obito':'deaths', 'qtd_confirmado':'cases'}, inplace=True)\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 172,
   "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>cases</th>\n",
       "      <th>deaths</th>\n",
       "      <th>uf</th>\n",
       "      <th>time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-01-30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>CE</td>\n",
       "      <td>16:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-01-30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MG</td>\n",
       "      <td>16:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-01-30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RJ</td>\n",
       "      <td>16:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-01-30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>SP</td>\n",
       "      <td>16:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-01-30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>PR</td>\n",
       "      <td>16:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>RR</td>\n",
       "      <td>19:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>197</td>\n",
       "      <td>1</td>\n",
       "      <td>SC</td>\n",
       "      <td>19:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>990</th>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>SE</td>\n",
       "      <td>19:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>1517</td>\n",
       "      <td>113</td>\n",
       "      <td>SP</td>\n",
       "      <td>19:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>TO</td>\n",
       "      <td>19:52</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>993 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           date  cases  deaths  uf   time\n",
       "0    2020-01-30      0       0  CE  16:00\n",
       "1    2020-01-30      0       0  MG  16:00\n",
       "2    2020-01-30      0       0  RJ  16:00\n",
       "3    2020-01-30      0       0  SP  16:00\n",
       "4    2020-01-30      0       0  PR  16:00\n",
       "..          ...    ...     ...  ..    ...\n",
       "988  2020-03-30     16       0  RR  19:51\n",
       "989  2020-03-30    197       1  SC  19:52\n",
       "990  2020-03-30     16       0  SE  19:50\n",
       "991  2020-03-30   1517     113  SP  19:51\n",
       "992  2020-03-30     10       0  TO  19:52\n",
       "\n",
       "[993 rows x 5 columns]"
      ]
     },
     "execution_count": 172,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Carrega a série histórica e junta com o dia atual, removendo duplicadas\n",
    "final = pd.read_csv(\"../dados/corona_brasil.csv\").append(df,ignore_index=True)\n",
    "\n",
    "final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 173,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Exporta o CSV\n",
    "\n",
    "final.to_csv(\"../dados/corona_brasil.csv\", index = False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "coronabr",
   "language": "python",
   "name": "coronabr"
  },
  "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.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}