nb_subnotificacao_covid.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "dc_trab_03.ipynb",
      "provenance": [],
      "collapsed_sections": [
        "r9rnWtyei6S8"
      ],
      "toc_visible": true
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "QTzzS64YTOwH"
      },
      "source": [
        "## **Fundamentos e Técnicas em Ciências de Dados**\n",
        "\n",
        "#### Motivação: \n",
        " OBS.: Estudo realizado para fins didáticos, projeto de conclusão da disciplina \"Fundamentos e  Técnicas em Ciências de Dados - UFRN/EAJ\"\n",
        " \n",
        "Os sistemas de notificação de óbitos também passaram a ser sobrecarregados, principalmente para registrar os óbitos por Síndrome Respiratória Aguda Grave (SRAG), que é reconhecida como a principal síndrome clínica relacionada à covid-19.\n",
        "\n",
        "A partir de meados de março de 2020, passaram a ser divulgados também os óbitos oriundos da covid-19, os quais, devido à sobreposição de critérios e ao fato de nem sempre os infectados apresentarem toda a sintomatologia para definição de casos suspeitos, eram enquadrados como SG (Síndrome Gripal) ou SRAG. Ou seja: enquanto nos anos anteriores apenas havia a notificação por SRAG, em 2020 eram apresentados para cada data de ocorrência os óbitos totais por SRAG e os que, entre eles, tinham como causa principal a covid-19.\n",
        "\n",
        "Para afirmar que esse óbito foi por covid-19, era preciso que houvesse sido realizado o teste de identificação e este ter dado positivo.\n",
        "\n",
        "\n",
        "A notificação de óbitos por SRAG é feita pelas vigilâncias epidemiológicas de cada município no Sivep-Gripe (Sistema de Vigilância Epidemiológica da Gripe), disponível na plataforma [OpenDataSUS](https://opendatasus.saude.gov.br/dataset) do Ministério da Saúde.\n",
        "\n",
        "Este estudo tem como objetivo identificar a sub-notificação da covid-19.",
        "\n",
        "\n",
        " **Professor**: Josenalde Barbosa UFRN/EAJ\n",
        "\n",
        " - Francisco Gomes Cordeiro Neto\n",
        "\n",
        "\n",
        "\n",
        " \n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "uQwZFmBcagcZ"
      },
      "source": [
        "### **Bibliotecas Básicas**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "E0LPIXgAYr9E"
      },
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "import matplotlib.pyplot as plt\n",
        "import seaborn as sb\n",
        "%matplotlib inline\n",
        "plt.style.use('seaborn-whitegrid')\n",
        "from pandas.plotting import andrews_curves"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "DRoD6i3CaoYI"
      },
      "source": [
        "### **Pré - Processamento**"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "MQ6osCvPuOIM"
      },
      "source": [
        "Carremento do google drive"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "yIx1u6LGY9q9",
        "outputId": "be7c4117-4880-4741-9ed0-48ec9818550d"
      },
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Mounted at /content/drive\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "_MQiR51IjrhO"
      },
      "source": [
        "### OpenDataSUS\n",
        "SRAG 2019 - Banco de Dados de Síndrome Respiratória Aguda Grave\n",
        "Vigilância de Síndrome Respiratória Aguda Grave (SRAG)"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rsZDu0ktk3Js"
      },
      "source": [
        "pd_n_sarg_2019 = pd.read_csv('/content/drive/MyDrive/TADS - UFRN/2020.2/data_science/trab03/dataset/sarg_2019.csv',low_memory=False, encoding='ISO-8859-1', delimiter=';', error_bad_lines=False)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 412
        },
        "id": "9gpRB2SIloob",
        "outputId": "d90647f2-4994-48dc-e5d5-d7915139695c"
      },
      "source": [
        "pd_n_sarg_2019.sample(3)\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>DT_NOTIFIC</th>\n",
              "      <th>SEM_NOT</th>\n",
              "      <th>DT_SIN_PRI</th>\n",
              "      <th>SEM_PRI</th>\n",
              "      <th>SG_UF_NOT</th>\n",
              "      <th>ID_REGIONA</th>\n",
              "      <th>CO_REGIONA</th>\n",
              "      <th>ID_MUNICIP</th>\n",
              "      <th>CO_MUN_NOT</th>\n",
              "      <th>ID_UNIDADE</th>\n",
              "      <th>CO_UNI_NOT</th>\n",
              "      <th>CS_SEXO</th>\n",
              "      <th>DT_NASC</th>\n",
              "      <th>NU_IDADE_N</th>\n",
              "      <th>TP_IDADE</th>\n",
              "      <th>COD_IDADE</th>\n",
              "      <th>CS_GESTANT</th>\n",
              "      <th>CS_RACA</th>\n",
              "      <th>CS_ETINIA</th>\n",
              "      <th>CS_ESCOL_N</th>\n",
              "      <th>ID_PAIS</th>\n",
              "      <th>CO_PAIS</th>\n",
              "      <th>SG_UF</th>\n",
              "      <th>CO_RG_RESI</th>\n",
              "      <th>ID_MN_RESI</th>\n",
              "      <th>CO_MUN_RES</th>\n",
              "      <th>CS_ZONA</th>\n",
              "      <th>SURTO_SG</th>\n",
              "      <th>NOSOCOMIAL</th>\n",
              "      <th>AVE_SUINO</th>\n",
              "      <th>FEBRE</th>\n",
              "      <th>TOSSE</th>\n",
              "      <th>GARGANTA</th>\n",
              "      <th>DISPNEIA</th>\n",
              "      <th>DESC_RESP</th>\n",
              "      <th>SATURACAO</th>\n",
              "      <th>DIARREIA</th>\n",
              "      <th>VOMITO</th>\n",
              "      <th>OUTRO_SIN</th>\n",
              "      <th>OUTRO_DES</th>\n",
              "      <th>...</th>\n",
              "      <th>CO_LAB_IF</th>\n",
              "      <th>PCR_RESUL</th>\n",
              "      <th>DT_PCR</th>\n",
              "      <th>POS_PCRFLU</th>\n",
              "      <th>TP_FLU_PCR</th>\n",
              "      <th>PCR_FLUASU</th>\n",
              "      <th>FLUASU_OUT</th>\n",
              "      <th>PCR_FLUBLI</th>\n",
              "      <th>FLUBLI_OUT</th>\n",
              "      <th>POS_PCROUT</th>\n",
              "      <th>PCR_VSR</th>\n",
              "      <th>PCR_PARA1</th>\n",
              "      <th>PCR_PARA2</th>\n",
              "      <th>PCR_PARA3</th>\n",
              "      <th>PCR_PARA4</th>\n",
              "      <th>PCR_ADENO</th>\n",
              "      <th>PCR_METAP</th>\n",
              "      <th>PCR_BOCA</th>\n",
              "      <th>PCR_RINO</th>\n",
              "      <th>PCR_OUTRO</th>\n",
              "      <th>DS_PCR_OUT</th>\n",
              "      <th>LAB_PCR</th>\n",
              "      <th>CO_LAB_PCR</th>\n",
              "      <th>CLASSI_FIN</th>\n",
              "      <th>CLASSI_OUT</th>\n",
              "      <th>CRITERIO</th>\n",
              "      <th>EVOLUCAO</th>\n",
              "      <th>DT_EVOLUCA</th>\n",
              "      <th>DT_ENCERRA</th>\n",
              "      <th>OBSERVA</th>\n",
              "      <th>DT_DIGITA</th>\n",
              "      <th>HISTO_VGM</th>\n",
              "      <th>PAIS_VGM</th>\n",
              "      <th>CO_PS_VGM</th>\n",
              "      <th>LO_PS_VGM</th>\n",
              "      <th>DT_VGM</th>\n",
              "      <th>DT_RT_VGM</th>\n",
              "      <th>PCR_SARS2</th>\n",
              "      <th>PAC_COCBO</th>\n",
              "      <th>PAC_DSCBO</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>36670</th>\n",
              "      <td>02/08/2019</td>\n",
              "      <td>31</td>\n",
              "      <td>29/07/2019</td>\n",
              "      <td>31</td>\n",
              "      <td>SP</td>\n",
              "      <td>GVE I CAPITAL</td>\n",
              "      <td>1331.0</td>\n",
              "      <td>SAO PAULO</td>\n",
              "      <td>355030</td>\n",
              "      <td>HOSPITAL SAMARITANO</td>\n",
              "      <td>2080818</td>\n",
              "      <td>M</td>\n",
              "      <td>02/07/1954</td>\n",
              "      <td>65</td>\n",
              "      <td>3</td>\n",
              "      <td>3065</td>\n",
              "      <td>6</td>\n",
              "      <td>9.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9.0</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1.0</td>\n",
              "      <td>SP</td>\n",
              "      <td>1331.0</td>\n",
              "      <td>SAO PAULO</td>\n",
              "      <td>355030.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>CEFALEIA EM PESO FRONTAL</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.0</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>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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>28/08/2019</td>\n",
              "      <td>0</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10040</th>\n",
              "      <td>23/04/2019</td>\n",
              "      <td>17</td>\n",
              "      <td>21/04/2019</td>\n",
              "      <td>17</td>\n",
              "      <td>PE</td>\n",
              "      <td>1</td>\n",
              "      <td>1497.0</td>\n",
              "      <td>RECIFE</td>\n",
              "      <td>261160</td>\n",
              "      <td>IMIP</td>\n",
              "      <td>434</td>\n",
              "      <td>M</td>\n",
              "      <td>24/01/2019</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>2002</td>\n",
              "      <td>6</td>\n",
              "      <td>4.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1.0</td>\n",
              "      <td>PE</td>\n",
              "      <td>1497.0</td>\n",
              "      <td>RECIFE</td>\n",
              "      <td>261160.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</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>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>2712075.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>24/04/2019</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>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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>LAB CENTRAL DE SAUDE PUB DR MILTON BEZERRA SOBRAL</td>\n",
              "      <td>2712075.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>30/04/2019</td>\n",
              "      <td>06/05/2019</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39607</th>\n",
              "      <td>20/09/2019</td>\n",
              "      <td>38</td>\n",
              "      <td>18/09/2019</td>\n",
              "      <td>38</td>\n",
              "      <td>SP</td>\n",
              "      <td>GVE I CAPITAL</td>\n",
              "      <td>1331.0</td>\n",
              "      <td>SAO PAULO</td>\n",
              "      <td>355030</td>\n",
              "      <td>HOSPITAL SAO PAULO HOSPITAL DE ENSINO DA UNIFE...</td>\n",
              "      <td>2077485</td>\n",
              "      <td>M</td>\n",
              "      <td>07/01/1969</td>\n",
              "      <td>50</td>\n",
              "      <td>3</td>\n",
              "      <td>3050</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1.0</td>\n",
              "      <td>SP</td>\n",
              "      <td>1331.0</td>\n",
              "      <td>SAO PAULO</td>\n",
              "      <td>355030.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>19/09/2019</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>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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>15/10/2019</td>\n",
              "      <td>NaN</td>\n",
              "      <td>20/09/2019</td>\n",
              "      <td>0</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",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>3 rows × 139 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       DT_NOTIFIC  SEM_NOT  DT_SIN_PRI  ...  PCR_SARS2 PAC_COCBO PAC_DSCBO\n",
              "36670  02/08/2019       31  29/07/2019  ...        NaN       NaN       NaN\n",
              "10040  23/04/2019       17  21/04/2019  ...        NaN       NaN       NaN\n",
              "39607  20/09/2019       38  18/09/2019  ...        NaN       NaN       NaN\n",
              "\n",
              "[3 rows x 139 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 28
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7MDDxWxNdDSd"
      },
      "source": [
        "evolucao_caso = {1:'Cura', 2:'Óbito', \n",
        "                 3:'Óbito por outras causas', 9:'Ignorado'}\n",
        "classificacao_final = {1:'SRAG por influenza', 2:'SRAG por outro vírus respiratório',\n",
        "                       3:'SRAG por outro agente etiológico',\n",
        "                       4:'SRAG não especificado', 5:'SRAG por COVID-19'}"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "-e9g44dStBo6"
      },
      "source": [
        "Evolução dos Casos com NaN na feature EVOLUCAO **não** tratados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Z3PsjWSer4Y2",
        "outputId": "dfa0dcdc-5888-42f4-ea38-302b0d52beaf"
      },
      "source": [
        "pd_n_sarg_2019.groupby('EVOLUCAO').size().sort_values()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "EVOLUCAO\n",
              "9.0     1384\n",
              "2.0     5370\n",
              "1.0    38646\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 106
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "sj5LJMrbmHBt",
        "outputId": "8cfef23f-4077-48af-dff2-ffe76f654113"
      },
      "source": [
        "# Verifica se tem NaN na target \"EVOLUCAO\"\n",
        "hasNan = pd_n_sarg_2019['EVOLUCAO'].isnull().values.any()\n",
        "print(hasNan)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "True\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "SC1vOQsNmcaK",
        "outputId": "cd641a80-b11c-4a42-c776-b5000e99085f"
      },
      "source": [
        "# Verifica se tem NaN na target \"CLASSI_FIN\"\n",
        "hasNan = pd_n_sarg_2019['CLASSI_FIN'].isnull().values.any()\n",
        "print(hasNan)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "True\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "dnYg16mflfu7"
      },
      "source": [
        "pd_n_sarg_2019.loc[(pd_n_sarg_2019.EVOLUCAO.isnull()), 'EVOLUCAO'] = 9\n",
        "pd_n_sarg_2019.loc[(pd_n_sarg_2019.CLASSI_FIN.isnull()), 'CLASSI_FIN'] = 1\n",
        "pd_n_sarg_2019['EVOLUCAO'] = pd_n_sarg_2019['EVOLUCAO'].apply(lambda x: evolucao_caso[x])\n",
        "pd_n_sarg_2019['CLASSI_FIN'] = pd_n_sarg_2019['CLASSI_FIN'].apply(lambda x: classificacao_final[x])"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "6CjyIyxRmbtU",
        "outputId": "ce9c2474-7ab1-441a-8945-bf38447a58d9"
      },
      "source": [
        "# Verifica se tem NaN na target \"EVOLUCAO\"\n",
        "hasNan = pd_n_sarg_2019['EVOLUCAO'].isnull().values.any()\n",
        "print(hasNan)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "False\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Vbk0Q-zbmbtc",
        "outputId": "65253e55-6e08-4621-e698-272c9a7e92dd"
      },
      "source": [
        "# Verifica se tem NaN na target \"CLASSI_FIN\"\n",
        "hasNan = pd_n_sarg_2019['CLASSI_FIN'].isnull().values.any()\n",
        "print(hasNan)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "False\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 279
        },
        "id": "OORFC-0emMQQ",
        "outputId": "f932e6c7-ab2d-4a32-fb61-070b2eb03f22"
      },
      "source": [
        "pd_n_sarg_2019.groupby('CLASSI_FIN').size().sort_values().plot(kind='barh')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7fbb2bdaa810>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 112
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAgMAAAD1CAYAAADNj/Z6AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3de7xd07338c8WSaQSVLUaRVwe59u4PMJWJURCadwarahLPBzlafsoFcVRtCVaxaESHunNUydopXEQl+JEEdIUh9huh26/UnVPjrq0dck9+/ljjFUr29o7K8lee+215/f9euVlrTnHHHP85pKM3xxjzLWa2traMDMzs+Jao94NMDMzs/pyMmBmZlZwTgbMzMwKzsmAmZlZwTkZMDMzKzgnA2ZmZgW3Zr0bYLYqWlpa/EysmdkqaG5ubmq/zcmANazm5uZ6N6FLtLa2MnTo0Ho3o8s4np6tN8XTm2KB7omnpaWl4nZPE5iZmRWckwEzM7OCczJgZmZWcE4GzMzMCs7JgJmZWcE5GTAzMys4JwNmZmYF52TAzMys4JwMmJmZFZy/gdAa1mZn3F7vJnSh5+vdgC7meHq23hRPb4oFVhTPCxceUJOzemTAzMys4JwMmJmZFZyTATMzs4JzMmBmZlZwTgbMzMwKzsmAmZlZwfnRQkDSCcBRwEJgAHBWRNwtaQJwJPAq0JT3XRARN5UdeyZwCjA4IpaUbT8FGAfMB9YCLo2Ia6tsz3DgPKAPMA84PCLaVjfOriJpX2DziPippMnAcOBk4HMRcc4q1rktMDkiRnVdS83MrBqFTwYkbQZ8FfhMRCyWtBXwC+DuXOSyiJicy64PPC5pRkTMz/uPAN4E9gZm5HLjgBHA8IhYJOmTwGxJj0ZE64raFBEPAHt1WZBdLCJmlL3dH9gxIv4K/K5OTTIzs9VQ+GQAWJd0594PWBwRzwIjKxWMiLckzQUGA89L2o50934JKSkodZInAUdFxKJ83DxJW0fE4vL6JB0D7A58HBBwcURcKelI4JvAUuDpiPiapL7AFcAWQH/g7Ij4bbv6TiCNRiwDbo6ISyTtAPyENOqxEDiMdBe/MbBpjuVfImKGpIOBU4ElwCMRcWo+79XAEGABcDSwD7At8N/ARsBvJP0ox3yIpKPyNVgGTIyI6ySdChxCmpq6IyLOlbQxcH1u1xNlcRxKGm1ZArRExPhKn4eZmXWNwq8ZiIgngIeBP0u6StKhkiomSZIEbAi8kjeNA6YBNwL7S1orbx+Sk4ry8yyXCJTZDjgY+CIpAQBYG9g3InYDPp2TjiOABRExMpef3K5tm5M6292BPYCxkjYFvgL8JA+//yvwyXzIpyLi8zmGCyQNBL4L7JXPsYmk3YB/Bubltvw/YExZTBeTpjH2A/6W2zEIODu3YXSuv2R3YBfgGEnrkBKGabltr+XjBwLnA3tHxO7AFpL27ODamZlZF/DIABARR0saSuq8TgeOl1Qaph8v6RBgHdId+bg89N8EHA7sk0cMHiQNmU8HkNQUEW2SvgSMBwYC0yPi/HanfzAilkp6hTRKAfAWcEvKPRgKfAzYCbgvt/c1SQslrR8Rb+Vjdga2Au7N7wcBmwG3AD+V9E/AdRHxTK73nlzXf0n6FLANaaTgzrx/XdJowI5lZafl2I7p5HIOBZ7J0yjzgYPy9veBWaS7/Q2A9YGtSSMD5Nj2A/4JeDYi3i3bvkNZXGZmhdXausKZ5lVS+GQgd+r981x+q6TLgWdIHSPkNQOSBgMzgSfz9uGkUYIbcue5Hik5mA48BwwDHsuLDW/KHei2FZqwpOx1k6R+wI+B7fP0wm15XxtpEWNJP9IwfMki4PaI+HqFGD8DHAhcLem0vLn9qNAi0pD86HbH7lqhbGeWti8vaQhp2H+HiHhX0lN5V1NZDKVjKsU5HzMzY+jQoat1fEtLS8XthZ8mAI4DrshJAaQ74jWA18sLRcRc4BqgtFp+HPDtiBgWEcNId9Yj8zD3JGCipLUBcge/B2nOfUUGAUtyIrAJaUSgHzAH2DPXtwmwLC/aK2kB9pT0EUlNki6TNEDSicD6+UmGSaS7bEhD9kj6n8CLQABDJX0ibz83jxjMIS9mlHSgpLNW0P5nUlENlLSWpLtIIwGv50RgR9KIQ798zp3ycaWpgD8CW+XpBkjrNx6p4rqZmdkqcjIAU0gd/0OSZpKG1U8qe1qg3ERgjKTtSXPnU0s7IuI94DbgoIiYDlxJeoJgNvAAMJf0uGCnIuJN4C5Jc0iJx0WkTvw6oI+ke0nrFL7e7riXgEtJK/r/kzTPP580SnG9pHtICUzp8ca/S7o1vz8jIt4nLSy8Q9L9pKmJ1/K51pY0K++/egXtf4+0ZuBu0hD/L4DHgXdzvYcBPyctarwMOFbSncBHy47/F2BGvnaPRcTvV3TdzMxs1TW1tfWYx9etm+TvT3ij9MhkI2ppaWkbe/28ejfDzKxbre5PGLe0tNDc3NzUfrtHBszMzAqu8AsIiygiJtS7DWZm1nN4ZMDMzKzgnAyYmZkVnJMBMzOzgvOaAWtYq7uqtqdobW1d7S8S6UkcT8/Wm+LpTbFAfePxyICZmVnBORkwMzMrOCcDZmZmBedkwMzMrOCcDJiZmRWckwEzM7OCczJgZmZWcE4GzMzMCs7JgJmZWcE5GTAzMys4JwNmZmYF52TAzMys4JwMmJmZFZyTATMzs4JzMmBmZlZwTgbMzMwKzsmAmZlZwTkZMDMzKzgnA2ZmZgXnZMDMzKzgnAyYmZkV3Jr1boDZqtrsjNvr3YQu9Hy9G7BSXrjwgHo3wcy6kEcGzMzMCs7JgJmZWcE5GTAzMys4JwNmZmYF52TAzMys4JwMmJmZFVzNHy2UdAJwFLAQGACcFRF3S5oAHAm8CjTlfRdExE1lx54JnAIMjoglZdtPAcYB84G1gEsj4tpax7IiksZGxI1dVNcI4CTgmIh4ryvq7AqShgFfiohzqix/SETcUPZ+T+AbwFERsaBd2TOAWRHxYFe22czMOlfTkQFJmwFfBUZExEhS5/+9siKXRcSovG9f4DJJA8r2HwG8CexdVuc4YAQwPCJGAF8AJkgaWstYViTHekQXVjkAOLQnJQIAEfH4SiQC/UjJXLl1SXEtaF8+Ii50ImBm1v1qPTKwLunOvR+wOCKeBUZWKhgRb0maCwwGnpe0HdAHuITUyc7IRU8i3VUuysfNk7R1RCwur0/SMaQEYx1gY2BSREyRNAo4H1gMvAIcm+vfD9gIODwiXs119AWuALYA+gNnR8RvJb0AbBsR70r6EfAU8GVgZ0lnk5KsLYDNgVHABcBupOs9OSJ+WdbO8cC6EfH9/P5eYDxp5KOfpKeAXwHvApPzn/bnnpnLLM3n+F8R8WLZOa4CFgEfAw4ti6lvjmmmpKOBE3O5JyLiBEn3AXOAnUjJyWE5phMj4hBJzwKPAr8FXgR+kI9/O59nErCdpJ/kmErnPUNS6Vo+C9wBvA5sBdwA3FnpumNmZjVR05GBiHgCeBj4s6SrJB0qqWICIknAhqQOGlJnOA24Edhf0lp5+5CcVJSfZ7lEoMw2wBhgL+A8SWsAPwMOy6MRb+fzAGwK7FFKBLIjgAW57MGkjrgjF5OGuL+f3/fLIxe7kTrv3XI7JkgaVHbcdODAfA3WBzaMiCfb1b0DcGRE3NbBuQ8B7oqIPUmd7uAKZd6KiLE53rm57BeBS/P+04CxEbE78EjZCM2buey1wMnt6twC+H5EXAl8FBiXr9XfgdH5mkREfIOOr2Vf4D8i4odl9a7MdTczs9VU8zUDEXF0HsIfDZwOHC9pr7x7vKRDSHfv/UmdySJJTcDhwD55xOBBYH9Sx4mkpohok/QlUuc3EJgeEee3O/2svNbgDUlvAxsAbRHxct5/L2mk4lFgTkS0tTt+J+C+HMdrkhbmDrsaD5fVMSvX8Z6kP5DugB/N216W1CZpMGk65OYKdf0pIt7s5Fy/BW6StB5wQwdD7aX2DAdGSNo9vx+Qh/N/nev4FfDriJif8jPuzuUeJI2elHsvIp7Or/8C/CIne1uQRivKdXYtH66mbES81ck1sG7U2tra4b4FCxZ0ur/ROJ6eqzfFAvWNp6bJQO7U+0dEK9Aq6XLgGdJdOKQ1A5NzRzgTKN0RDyeNEtyQO6T1SMnBdOA5YBjwWF5seFOeEti2QhPKRz6agLb835J+wLL8elGF4zsqX5409K0Y/Af1dXbOkptJowOjSVMYHdVVqm+5c0fEU5K2Bz4PXCDp3yLimg7qWAT8MCJ+3W7/BZKuJY0yzJS0R95euoal69dRu/4NOCAiWiVVupNfmWtfzTWzOho6tOMlOq2trZ3ubzSOp+fqTbFA98TT0tJScXutHy08DrgiJwWQ1hCsQZof/oeImAtcA5QWpo0Dvh0RwyJiGGm4f6SkgaR56ImS1oZ/LFLbA/jQgjRgV0l9JG0ADCItRmyTVEpGRgKPdNL+OcCe+TybAMsi4q+kYfDBkvoAu+Syy6icXM0hrRsgt39L4Nl2ZaaTRj7+R0Q82kl7qHRuSYeTpiJuBr5LurPuyEPAQfm4T0g6X9Iakn5Imj6YSBoFGJLLj8j/3RX4Qyf1rgu8lEcn9uSDDrx0TTq6lpWsTFkzM1tNtU4GppA6/ockzQRuAU6KiPkVyk4ExuQ73DHA1NKOvKL+NuCgiJgOXAnMljQbeACYC5xXoc4XgOtJow7fiYhlpKcbpubFcX1J6xI6Mg3okxf1TQO+nrdPBn5D6sRLw+StwI6SJpVXEBG/B1ok/Q64Czij/RMCERGkofVqFslVOvcfgcn5Gp8D/LST4/8deFfSA7me2fm6vAM8KOke0p3547n8ppJmkBK0SytVmP0YuJ+08O8i4MxcTz9J19PxtaxkZcqamdlqampraz/y2zuUpg4i4rR6t6VR5YTpxIh4qt5taa+lpaVt7PXz6t2MwursJ4w9dNuz9aZ4elMs0H3TBM3NzU3tt/sbCM3MzAqu5k8T1EtEXFXvNjS6iBhV7zaYmVnteWTAzMys4JwMmJmZFZyTATMzs4JzMmBmZlZwvXYBofV+nT3e1kh62+NRZtZ4PDJgZmZWcE4GzMzMCs7JgJmZWcE5GTAzMys4JwNmZmYF52TAzMys4Fb4aKGkozvbHxHXdF1zzMzMrLtV8z0DH/qpw3zc/wE2BpwMmJmZNbAVJgMRcXX5e0mHAWcANwM/qlG7zMzMrJtU/Q2EkvYEfgi0AKMj4vWatcrMzMy6TTVrBrYFLgTeBY6KiD/VvFVmZmbWbaoZGXgc+ANpROA7kkrbm4C2iDi2Rm0zMzOzblBNMrBlzVthZmZmdVNNMvCXmrfCzMzM6qaaZOBpoI3lHzEsvW8DtqhBu8zMzKybVPNo4ebd0RAzMzOrjxV+HbGkqe3eX1a75piZmVl3q+a3CQa3e79dLRpiZmZm9bEqP1RU6euJzczMrEFVkwy0reC9mZmZNbBqniYYIan01cNNwLr5felLhz5Rs9aZmZlZzVXzNEHfFZWRNCQiXuyaJplVZ7Mzbq93E7rQ8/VuAC9ceEC9m2BmdbIqawYqmdJF9ZiZmVk366pkwIsKzczMGlRXJQNeVGhmZtaguioZMDMzswblaQIzM7OC66pkYGYX1WNmZmbdbIWPFkq6mE7WBETE6RHxgy5tVYOSdAJwFLAQGACcFRF3S5oAHAm8ShpFGQBcEBE3lR17JnAKMDgilpRtPwUYB8wH1gIujYhra9D2fYHNI+KnHez/NHArcDkwFjgxIp7q6naYmVn3q+ZLh/wPfhUkbQZ8FfhMRCyWtBXwC+DuXOSyiJicy64PPC5pRkTMz/uPAN4E9gZm5HLjgBHA8IhYJOmTwGxJj0ZEa1e2PyJmrKDIzsAdEXG5pLFdeW4zM6uvar506GpJfSNiMYCk/qSO4cWIeKnWDWwg65Lu3PsBiyPiWWBkpYIR8ZakuaQfgXpe0nZAH+ASUlJQ6phPAo6KiEX5uHmSti59FiWSjgH2BdYBNgYmRcQUSaOA84HFwCvAsbn+/YCNgMMj4tWyOrYFJgNXA38CtgceA84EzgLWlvTnsvNOAN6IiMmStgUmR8QoSQcDpwJLgEci4tRc/+7AxwEBFwNTgf/I1fUFdoqI/pKOBL4JLAWejoivdX7pzcxsdVTzE8aHA/fn12sBjwLnAjdLOqq2zWscEfEE8DDwZ0lXSTpUUsVkS5KADUkdNKRpgGnAjcD++ToDDMlJRfl5lksEymwDjAH2As6TtAbwM+CwiBgJvJ3PA7ApsEcpEaigmdT5fwbYn5RMXAhcFxGd/oS1pIHAd4G98nk3kbRb3r0dcDDwReCbETE/IkZFxCjgAVLSAbA2sG9E7AZ8OidLZmZWI9VME5xKuusEOAyYFxGfyx3W3cAva9W4RhMRR0saCowGTgeOl7RX3j1e0iGku/f+wLg89N8EHA7sk0cMHiR1wNMBJDVFRJukLwHjgYHA9Ig4v93pZ+W1Bm9IehvYgPTbES/n/feSRioeBeZERGffDfFcRMzL53+NNOpRrW1IycadKedhXWBI3vdgRCyV9Ep5nZL2Jo1KnJ43vQXcko8fCnxsJc5vq6i1tWtmnhYsWNBldfUEjqfn6k2xQH3jqSYZeDci3syvRwPXAUTEAkkLa9ayBpM79f55Lr9V0uXAM6SOEfKaAUmDSU9fPJm3DyeNEtyQO7/1SMnBdOA5YBjwWF5seFPZcH575aM8TaRFn+WPfPYDluXXi1YQzpJ27zt6dLQ8oSj9hsUioCUiRpcXzO0ur7cpb98A+BFpJKBNUj/gx8D2eVrkthW01brI0KFDu6Se1tbWLqurJ3A8PVdvigW6J56WlpaK26t5tLC/pI/kf7T344PFbWuS7lItOQ64IicFkO581wBeLy8UEXOBa4Bz8qZxwLcjYlhEDCPdWY/Mw+2TgImS1gbIHeUewIIK599VUp/8OQ0iLUZsk1RKRkYCj3RNqP/wd9K6B0jrAQACGCrpE7nN50r6VCd1XEl66mJefj8IWJITgU2AnUiJjJmZ1Ug1ycAk4A/5z48j4qU8RXAncH0tG9dgppA6/ockzQRuAU4qe1qg3ERgjKTtSfP8U0s7IuI94DbgoIiYTuosZ0uaTZpXnwucV6HOF0ifx0zgOxGxjPR0w1RJ95Hu3Kd1QZzlpgMHSbqLNKJBRLwPnAzcIel+0hD/a5UOlrQr6emJ0yXdl9v5UeAuSXNICdNFwCRJK/z1TDMzWzVNbW0r/lmBfEc6ICL+VrbtcxFxTy0bZ9UpTR1ExGn1bkt3aWlpaRt7/bwVF7SqddVPGHvotmfrTfH0plig+6YJmpubPzT1W83TBGsCny8lApL2lnQlsIukAV3fVDMzM+tO1Swg/BlpUdhtkrYkLSD8Ful59h+Tnl23OoqIq+rdBjMza1zVJAPbRsQu+fU44N8j4hoASffWrGVmZmbWLapZQFi+AG4f4I4atcXMzMzqoJqRgffzd9GvB/wTcBf844dr/NPFZmZmDa6aZOBrwA9IycBB+cuG1gJ+Q/qee7O66KrV7/XW21ZEm1njqeaHil6l3SLBnBDsCBxI13+RjZmZmXWjakYG/iF/38D+pK/LHUn6cpxf16BdZmZm1k1WmAzkX7/bm/QkwX7Af5J+fW7L/G1zZmZm1sCqeZpgHnApMBv4dEQcBPzNiYCZmVnvUO1vEywmfd/88ZK2YPlfqzMzM7MGtsJkICIuiIjtSU8ODATuBiTpBEkfrXUDzczMrLaqGRkAICKeioizImIL0pcPDQUer1nLzMzMrFus1NMEJRHxAPCApCe6uD1mZmbWzaoeGeiAv3TIzMyswa1uMuCvIzYzM2tw1XzPwEc62NXE6icTZmZmVmfVrBl4mg8eJSyNBPjRQjMzs16imjt7AVNJXzi0eURsDowBfpWfLDAzM7MGVk0ycDEwiOXXB/wRGCTp7Jq0yszMzLpNNcnA8IgYHxELSxsiYhFwKvD5mrXMzMzMukU1ycDSShsjYhnQr2ubY2ZmZt2tmmTgDUm7t98o6QDSjxiZmZlZA6vmaYKTgRsltZK+frgP8FlgU2B0DdtmZmZm3aCaHyp6DtgBmALMB94BJgM7RMR/17Z5ZmZmVmtV/TZBXh9wZ/5jZmZmvYi/QdDMzKzgnAxYw9rsjNvr3QQzs17ByYCZmVnBORkwMzMrOCcDZmZmBedkwMzMrOCcDJiZmRWckwEzM7OCq+pLh1aFpBOAo4CFwADgrIi4W9IE4EjgVdLPIg8ALoiIm8qOPRM4BRgcEUvKtp8CjCN9E+JawKURcW2tYqiWpLERcWO921EiaQ/gmYh4fTXqGAPMANYHzo2Ir3dQ7hhg24g4Lb/fEJgKHBcRL3RwzCc7q9PMzLpXTUYGJG0GfBUYEREjSZ3/98qKXBYRo/K+fYHLJA0o238E8Cawd1md44ARpJ9UHgF8AZggaWgtYqhWjvWIerahgmOBT6xmHacA/SJi3kp22tsAB3eUCACsQp1mZlZDtRoZWJd0594PWBwRzwIjKxWMiLckzQUGA89L2o70Y0iXkDrZGbnoScBREbEoHzdP0tYRsbi8vnynui+wDrAxMCkipkgaBZwPLAZeIXWYRwD7ARsBh0fEq7mOvsAVwBZAf+DsiPitpBdId8HvSvoR8BTwZWBnSWeTkqstgM2BUcAFwG6k6zw5In7Zrq2nAofk4+6IiHMlbQxcDywCfkdKqEZJOhg4FVgCPBIRp+ZYdwc+Dgi4GHgJ+CKwjaSxwE7tj2vXho2AK/NntRT43/mz2gX4D0nHAVMjYqcOrmF5XeOBw/PrmyPiXyX9T+Bq4K/AI7mtE4Abcp375DqXAtMi4tJK54mIhZiZWU3UZGQgIp4AHgb+LOkqSYdKqph4SBKwIekffUjTANOAG4H9Ja2Vtw/JSUX5eZZLBMpsA4wB9gLOk7QG8DPgsDwa8XY+D6RfX9yjlAhkRwALctmDST/M1JGLgVkR8f38vl8eudiNlDjsltsxQdKgCsfvTup4j5G0DvAt4N/zufsDSBoIfBfYK2/fRNJu+fjtchu/CHwzIu4i/brkV4C3Ojmu5AfAJRHxOeBS4Hs5aZlHSpQWlZXt6BoiaXPgGNLozQjgMElbAucA34+IPYEh5SeW1AT8BNg/X6+98whRh+cxM7OuV7M1AxFxdB7CHw2cDhwvaa+8e7ykQ0h37/2BcRGxKHcOhwP75BGDB0kdxXRInUdEtEn6EjAeGAhMj4jz251+Vl5r8Iakt4ENgLaIeDnvv5d09/soMCci2todvxNwX47jNUkLJa1fZegPl9UxK9fxnqQ/AFvlc5a8n8ssyW1cHxgKXJf33wrsTEpuNgXuTLkT6/JBx/pgRCyV9EreXq6j4+4vKzOclJN9lzQi85dKQeX4O7qGkH7Z8j9Lazwk3Q9sn+Mpne9WyqZ+SKMECyKidM4DOznPlErtam1trbS5oSxYsKBXxFHieHq23hRPb4oF6htPTZKB3Kn3j4hWoFXS5cAzpI4J0pqByZIGAzOBJ/P24aRRghty57UeKTmYDjwHDAMey4sNbyotXqvQhPIRjyagLf+3pB+wLL8uv/Mt6ah8edLQt2LwH9TX2TmRNIQ0L79DnnZ4qqy9y8rqKNXZEhGjy0+U419Stqn8fB0eV6HMlyNibidlVhhPJ/srxVOylA+PTq3oPMsZOrSuS0a6RGtra6+Io8Tx9Gy9KZ7eFAt0TzwtLS0Vt9fq0cLjgCtyUgDpjnQNYLnV7bkDuoY0lAxpOPjbETEsIoaR7mxH5mHyScBESWsDSOoH7AEsqHD+XSX1kbQBMIi0GLFNUikZGUmav+7IHGDPfJ5NgGUR8Vfg78BgSX1IQ/uQOqpKSdUc0rqB0jD/lkD5NMcGwOs5EdiRdMfeD/gTaVQB0jA9QABDJX0i13eupE910v5Sm6o57iHSFAOS9soLNT8UV0S8TefX8DHSdV8zTwl9Nm+rFE+pzjeBPpI+JalJ0m2kZGBlPiszM1tNtUoGppA6/ockzQRuAU6KiPkVyk4ExkjanjTPP7W0IyLeA24DDoqI6aSFbrMlzQYeAOYC51Wo8wXSIryZwHciYhnp6Yapku4j3dVP66T900id1L35dWnl+2TgN6SRiqfztlZgR0mTyiuIiN8DLZJ+B9wFnJHjKXkceDcPpx8G/Jw0f34Z8HVJd5PukJdGxPvAycAdufzHgNc6af8s4AbSQsYVHTcB+GJu5znAg3n7fcDvSUlLSYfXMD89cEU+92zgFxHxIunz+ZGkO0n/Tyxtd/5v5LY+ANyTk66V+azMzGw1NbW1tR+5bWztn3tvNJK2AdaLiPslHQHsGRFfq3e7VpWkXYD3I+LJ/P0RTRXWeKy0lpaWtrHXz+OFCw9Y/UbWmYc6ezbH03P1plig+6YJmpub208p124Boa2yd4CfS2ojDdV/pc7tWV0LgSslzSctmPSTAWZmPUyvSwYi4qp6t2F1RMRLpMcNe4WIeAz4TL3bYWZmHfNvE5iZmRWckwEzM7OCczJgZmZWcE4GzMzMCs7JgDWs3vBYoZlZT+BkwMzMrOCcDJiZmRWckwEzM7OCczJgZmZWcE4GzMzMCs7JgJmZWcE5GTAzMys4JwNmZmYF52TAzMys4JwMmJmZFZyTATMzs4JzMmBmZlZwTgbMzMwKzsmAmZlZwTkZMDMzKzgnA2ZmZgXnZMDMzKzgnAyYmZkVnJMBMzOzgnMyYGZmVnBOBszMzArOyYCZmVnBORkwMzMrOCcDZmZmBedkwMzMrOCcDJiZmRWckwEzM7OCczJgZmZWcGvWuwGNSNIJwFHAQmAAcFZE3C1pAnAk8CrQlPddEBE3lR17JnAKMDgilpRtPwUYB8wH1gIujYhra9T+rYBLgY8DfYAHgNMiYqGkjwATgc8Ci4H/Br4RES9LehA4MSJayuq6AHgDGAS8ERGTJd0HrA28B/QF7gJ+EBFLK7RlW+AWYFJETM7bPg1cAbQBfwSOL79WZmbWtTwysJIkbQZ8FRgRESNJnf/3yopcFhGj8r59gcskDSjbfwTwJrB3WZ3jgBHA8IgYAXwBmCBpaA3a3we4EbgoInYGdsq7zs7/nQi8FhE75Fo8GNsAAAi/SURBVP0XAjMk9QWmAoe2q3IsMK3Cqb4SEaOAPYGNgB9WaMvawOXAPe12/SspiRoJvFThnGZm1oU8MrDy1iXdufcDFkfEs8DISgUj4i1Jc4HBwPOStiPdiV9CSgpm5KInAUdFxKJ83DxJW0fE4vL6JB1DSjDWATYm3U1PkTQKOJ90J/8KcGyufz9SR3x4RLyaq9kHeCYiZuVztUk6HVgmaVA+ZsuyGO6X9BBwEHAdcD/w7dyeZuDViHhVUsWLFRGLJH0LCEnfaxfTQmD/Un1ltgIezq/vBL5BSkTMzKwGPDKwkiLiCVJH9WdJV0k6VFLFpEqph9yQ1EFDmgaYRroz31/SWnn7kJxUlJ9nuUSgzDbAGGAv4DxJawA/Aw7Ld9Jv5/MAbArsUZYIAHwaeLzdueZHxEJSEvBMhSH5xwFFxOukpGbnvP1QquikI+I94OXcnvLtSyJifoVD/gs4IL8eTbqGZmZWIx4ZWAURcXQewh8NnA4cL2mvvHu8pENId+/9gXH57rgJOBzYJ48YPEi6K54OIKkp36V/CRgPDASmR8T57U4/K3fWb0h6G9gAaIuIl/P+e0kjFY8CcyKird3xbaTRiUo62tcElOb7pwKHkRKiMcDwDupqb1BZHStyGvDTPBIyK5//Q1pbW6usrmdbsGBBr4kFHE9P15vi6U2xQH3jcTKwknKn3j8iWoFWSZcDz/DBXe9leRHdYGAm8GTePpx0h3tDHlJfj5QcTAeeA4YBj+XFhjfljnDbCk0oH81pInXg5Z1lP2BZfr2owvHPACe2i6k/aWj++fRW/UpTFtkwoLQIcjpwlqRfA3+MiLcrnGM5kj5KivclSbeQplp+GRFXViqfE5sD87GjSdMsHzJ0aJcvqaiL1tbWXhMLOJ6erjfF05tige6Jp6WlpeJ2TxOsvOOAK3JSAKljWwN4vbxQRMwFrgHOyZvGAd+OiGERMYw03D9S0kBgEjAxL6hDUj9gD2BBhfPvKqmPpA1Id9tvAm2SSsnISOCRTtp/FzBE0hfyudYgLdg7LCLeAX4DTCgVljQc2AG4Pcf1DinBOYsqpgjyFMqlpCRpWUQclBdYVkwE8jHnSipNE3wlt8nMzGrEycDKm0Lq+B+SNJP0WNxJHcx9TwTGSNqeNKT+j84zz6PfBhwUEdOBK4HZkmaTHvWbC5xXoc4XgOtJow7fiYhlpKcbpuZH+vpSeXV/6bzLSNMbX5P0CPB74G98kLScDKwl6QlJDwPfAb7c7rHAqaSFiLd2dB5giqRZwGPAa/laLEdSc27zMaTplfskrZ/rP0fSHNKTDbd3ch4zM1tNTW1t7aeUracqTR1ExGn1bku9tbS0tDU3N9e7GV3CQ509m+PpuXpTLNB90wTNzc0fWoflkQEzM7OC8wLCBhIRV9W7DWZm1vt4ZMDMzKzgnAyYmZkVnJMBMzOzgnMyYGZmVnBOBszMzArOyYCZmVnBORkwMzMrOCcDZmZmBedkwMzMrOCcDJiZmRWckwEzM7OCczJgZmZWcE4GzMzMCs7JgJmZWcE1tbW11bsNZiutpaXF/+Oama2C5ubmpvbbnAyYmZkVnKcJzMzMCs7JgJmZWcGtWe8GmK0MSZOAXYA2YHxEzKlzkzokaRRwPfB03vRfwEXAL4E+wFzgqIhYKOlI4GRgGXBFRFwpqS9wFTAEWAp8JSKe79YgAEnbArcAkyJisqRNVjcGSdsDPyV9jk9GxPF1jOcqoBl4Mxe5OCJub4R4JF0EjCD9W34BMIfG/mzaxzOGxv1sPpLbsyGwFvAD4Al66OfjkQFrGJJGAltFxK7AccD/rXOTqjErIkblP98Evg/8OCJGAM8Bx0paGzgb2BsYBXxL0vrAOOCvEbE78EPSP47dKrftcuCess1dEcOlpGRuN2BdSfvVMR6AM8s+p9sbIR5JewLb5r8P++Y2NPJnUykeaMDPJvsC8EhEjAQOBSbSgz8fJwPWSD4H3AwQEa3ARyWtU98mrbRRwK359W9I/wB8FpgTEX+LiPnA/cBupHhvymXvztu620Jgf+C1sm2jWI0YJPUDNi8b1SnV0R0qxVNJI8TzO+DL+fVfgbVp7M+mUjx9KpRriHgi4rqIuCi/3QR4hR78+TgZsEbySeAvZe//krf1ZFtLulXS7yXtA6wdEQvzvteBwXw4rg9tj4hlQFv+x6DbRMSS/A9UudWKIW97u0LZmusgHoATJc2UNE3SBjRAPBGxNCLey2+PA+6gsT+bSvEspQE/m3KSHgCmkqYBeuzn42TAGtmHnpXtYZ4FzgUOAv4ZuJLl1+l01P6V3V5PXRFDveP6JXBGROwFPA5MqFCmx8Yj6SBS53lile3osbHAh+Jp6M8GICKGk9Y+/Krd+XvU5+NkwBrJayw/ErARaRFOjxQRr+ahwraI+BMwjzS1MSAX+RQppvZxfWh7XkzUFBGLui2Ajr27OjGQPrOPVShbFxFxT0Q8nt/eCmxHg8QjaTTwHWC/iPgbDf7ZtI+nwT+b5rzYlhzDmsA7PfXzcTJgjeS3wCEAknYEXouId+rbpI5JOlLSafn1J0mriqcAY3ORscAM4CHgM5LWkzSQNF84mxRvaQ71C8C93dj8ztzNasQQEYuBZyTtnrcfnOuoC0k3Stoivx0FPEUDxCNpXeBi4MCIeCtvbtjPplI8jfrZZHsApwJI2hAYSA/+fPwNhNZQJF1I+ku2DDghIp6oc5M6JGkQaa5wPaAfacrgMeAa0qNGL5IeF1os6RDgX0jzgpdHxLWS+gC/ALYiLXw7JiJe7uYYmoFLgM2AxcCrwJGkR55WOQZJWwM/J92QPBQRp9QxnsuBM4D3gXdzPK/39HgkfY00bP7Hss3/nNvXiJ9NpXimkKYLGuqzyfEMIE0NbgIMIP39f4TV/Ptfq3icDJiZmRWcpwnMzMwKzsmAmZlZwTkZMDMzKzgnA2ZmZgXnZMDMzKzgnAyYmZkVnJMBMzOzgnMyYGZmVnD/HzZ54vrMCZMvAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "q3tx1GqsmJQI",
        "outputId": "ed4603d9-5957-45f9-d313-47ba1e48b716"
      },
      "source": [
        "pd_n_sarg_2019.groupby('EVOLUCAO').size().sort_values()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "EVOLUCAO\n",
              "Ignorado     4512\n",
              "Óbito        5370\n",
              "Cura        38646\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 37
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "SkbcCnsFacxM"
      },
      "source": [
        "### OpenDataSUS\n",
        "SRAG 2020 - Banco de Dados de Síndrome Respiratória Aguda Grave - incluindo dados da COVID-19\n",
        "Vigilância de Síndrome Respiratória Aguda Grave (SRAG)"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "4B9VQ07wawP1",
        "outputId": "71d08c46-bf22-4166-ad43-9cd3562955a6"
      },
      "source": [
        "pd_n_sarg_2020 = pd.read_csv('/content/drive/MyDrive/TADS - UFRN/2020.2/data_science/trab03/dataset/sarg_2020.csv', encoding='ISO-8859-1', delimiter=';', error_bad_lines=False)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/IPython/core/interactiveshell.py:2718: DtypeWarning: Columns (15,60,62,63,64,92,94,106,108,115,117,118,119,123) have mixed types.Specify dtype option on import or set low_memory=False.\n",
            "  interactivity=interactivity, compiler=compiler, result=result)\n"
          ],
          "name": "stderr"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "FeJXMzULnFXi",
        "outputId": "3b06657d-01d0-4809-c459-620ab335b78c"
      },
      "source": [
        "# Verifica se tem NaN na target \"EVOLUCAO\"\n",
        "hasNan = pd_n_sarg_2020['EVOLUCAO'].isnull().values.any()\n",
        "print(hasNan)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "False\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Ee0ZSsEtnFXp",
        "outputId": "5c020404-374d-48be-f282-d29a32c19515"
      },
      "source": [
        "# Verifica se tem NaN na target \"CLASSI_FIN\"\n",
        "hasNan = pd_n_sarg_2020['CLASSI_FIN'].isnull().values.any()\n",
        "print(hasNan)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "True\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pBli_aGiwX2X"
      },
      "source": [
        "evolucao_caso = {1:'Cura', 2:'Óbito', \n",
        "                 3:'Óbito por outras causas', 9:'Ignorado'}\n",
        "classificacao_final = {1:'SRAG por influenza', 2:'SRAG por outro vírus respiratório',\n",
        "                       3:'SRAG por outro agente etiológico',\n",
        "                       4:'SRAG não especificado', 5:'SRAG por COVID-19'}"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "-tpzIFVUoLc7",
        "outputId": "c7034f9c-abe2-476c-f132-91921be7687a"
      },
      "source": [
        "pd_n_sarg_2020.groupby('EVOLUCAO').size().sort_values()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "EVOLUCAO\n",
              "3.0     14096\n",
              "9.0     30566\n",
              "2.0    301804\n",
              "1.0    701374\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 54
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "l31ETqxneq3L"
      },
      "source": [
        "pd_n_sarg_2020.loc[(pd_n_sarg_2020.EVOLUCAO.isnull()), 'EVOLUCAO'] = 9\n",
        "pd_n_sarg_2020.loc[(pd_n_sarg_2020.CLASSI_FIN.isnull()), 'CLASSI_FIN'] = 1\n",
        "pd_n_sarg_2020['EVOLUCAO'] = pd_n_sarg_2020['EVOLUCAO'].apply(lambda x: evolucao_caso[x])\n",
        "pd_n_sarg_2020['CLASSI_FIN'] = pd_n_sarg_2020['CLASSI_FIN'].apply(lambda x: classificacao_final[x])"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 440
        },
        "id": "no3BMBJYbLkH",
        "outputId": "90109218-c290-4124-fa1b-6090e9bb03f7"
      },
      "source": [
        "pd_n_sarg_2020.sample(5)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>DT_NOTIFIC</th>\n",
              "      <th>SEM_NOT</th>\n",
              "      <th>DT_SIN_PRI</th>\n",
              "      <th>SEM_PRI</th>\n",
              "      <th>SG_UF_NOT</th>\n",
              "      <th>ID_REGIONA</th>\n",
              "      <th>CO_REGIONA</th>\n",
              "      <th>ID_MUNICIP</th>\n",
              "      <th>CO_MUN_NOT</th>\n",
              "      <th>ID_UNIDADE</th>\n",
              "      <th>CO_UNI_NOT</th>\n",
              "      <th>CS_SEXO</th>\n",
              "      <th>DT_NASC</th>\n",
              "      <th>NU_IDADE_N</th>\n",
              "      <th>TP_IDADE</th>\n",
              "      <th>COD_IDADE</th>\n",
              "      <th>CS_GESTANT</th>\n",
              "      <th>CS_RACA</th>\n",
              "      <th>CS_ETINIA</th>\n",
              "      <th>CS_ESCOL_N</th>\n",
              "      <th>ID_PAIS</th>\n",
              "      <th>CO_PAIS</th>\n",
              "      <th>SG_UF</th>\n",
              "      <th>ID_RG_RESI</th>\n",
              "      <th>CO_RG_RESI</th>\n",
              "      <th>ID_MN_RESI</th>\n",
              "      <th>CO_MUN_RES</th>\n",
              "      <th>CS_ZONA</th>\n",
              "      <th>SURTO_SG</th>\n",
              "      <th>NOSOCOMIAL</th>\n",
              "      <th>AVE_SUINO</th>\n",
              "      <th>FEBRE</th>\n",
              "      <th>TOSSE</th>\n",
              "      <th>GARGANTA</th>\n",
              "      <th>DISPNEIA</th>\n",
              "      <th>DESC_RESP</th>\n",
              "      <th>SATURACAO</th>\n",
              "      <th>DIARREIA</th>\n",
              "      <th>VOMITO</th>\n",
              "      <th>OUTRO_SIN</th>\n",
              "      <th>...</th>\n",
              "      <th>HISTO_VGM</th>\n",
              "      <th>PAIS_VGM</th>\n",
              "      <th>CO_PS_VGM</th>\n",
              "      <th>LO_PS_VGM</th>\n",
              "      <th>DT_VGM</th>\n",
              "      <th>DT_RT_VGM</th>\n",
              "      <th>PCR_SARS2</th>\n",
              "      <th>PAC_COCBO</th>\n",
              "      <th>PAC_DSCBO</th>\n",
              "      <th>OUT_ANIM</th>\n",
              "      <th>DOR_ABD</th>\n",
              "      <th>FADIGA</th>\n",
              "      <th>PERD_OLFT</th>\n",
              "      <th>PERD_PALA</th>\n",
              "      <th>TOMO_RES</th>\n",
              "      <th>TOMO_OUT</th>\n",
              "      <th>DT_TOMO</th>\n",
              "      <th>TP_TES_AN</th>\n",
              "      <th>DT_RES_AN</th>\n",
              "      <th>RES_AN</th>\n",
              "      <th>POS_AN_FLU</th>\n",
              "      <th>TP_FLU_AN</th>\n",
              "      <th>POS_AN_OUT</th>\n",
              "      <th>AN_SARS2</th>\n",
              "      <th>AN_VSR</th>\n",
              "      <th>AN_PARA1</th>\n",
              "      <th>AN_PARA2</th>\n",
              "      <th>AN_PARA3</th>\n",
              "      <th>AN_ADENO</th>\n",
              "      <th>AN_OUTRO</th>\n",
              "      <th>DS_AN_OUT</th>\n",
              "      <th>TP_AM_SOR</th>\n",
              "      <th>SOR_OUT</th>\n",
              "      <th>DT_CO_SOR</th>\n",
              "      <th>TP_SOR</th>\n",
              "      <th>OUT_SOR</th>\n",
              "      <th>DT_RES</th>\n",
              "      <th>RES_IGG</th>\n",
              "      <th>RES_IGM</th>\n",
              "      <th>RES_IGA</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>136921</th>\n",
              "      <td>04/10/2020</td>\n",
              "      <td>41</td>\n",
              "      <td>25/09/2020</td>\n",
              "      <td>39</td>\n",
              "      <td>RJ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ANGRA DOS REIS</td>\n",
              "      <td>330010</td>\n",
              "      <td>HOSPITAL E MATERNIDADE CODRATO DE VILHENA</td>\n",
              "      <td>2280868</td>\n",
              "      <td>F</td>\n",
              "      <td>13/12/1943</td>\n",
              "      <td>76</td>\n",
              "      <td>3</td>\n",
              "      <td>3076</td>\n",
              "      <td>5</td>\n",
              "      <td>4.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1</td>\n",
              "      <td>RJ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ANGRA DOS REIS</td>\n",
              "      <td>330010.0</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</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>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>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>04/10/2020</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</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>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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>348342</th>\n",
              "      <td>07/09/2020</td>\n",
              "      <td>37</td>\n",
              "      <td>31/08/2020</td>\n",
              "      <td>36</td>\n",
              "      <td>SP</td>\n",
              "      <td>GVE I CAPITAL</td>\n",
              "      <td>1331.0</td>\n",
              "      <td>SAO PAULO</td>\n",
              "      <td>355030</td>\n",
              "      <td>HOSP DO SERV PUB MUNICIPAL HSPM</td>\n",
              "      <td>2752077</td>\n",
              "      <td>F</td>\n",
              "      <td>17/11/1946</td>\n",
              "      <td>73</td>\n",
              "      <td>3</td>\n",
              "      <td>3073</td>\n",
              "      <td>6</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9.0</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1</td>\n",
              "      <td>SP</td>\n",
              "      <td>GVE I CAPITAL</td>\n",
              "      <td>1331.0</td>\n",
              "      <td>SAO PAULO</td>\n",
              "      <td>355030.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>2</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>07/09/2020</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.0</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>15/09/2020</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>15/09/2020</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>4.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>63547</th>\n",
              "      <td>20/12/2020</td>\n",
              "      <td>52</td>\n",
              "      <td>19/12/2020</td>\n",
              "      <td>51</td>\n",
              "      <td>MG</td>\n",
              "      <td>DIAMANTINA</td>\n",
              "      <td>1450.0</td>\n",
              "      <td>DIAMANTINA</td>\n",
              "      <td>312160</td>\n",
              "      <td>SANTA CASA DE CARIDADE</td>\n",
              "      <td>2135132</td>\n",
              "      <td>M</td>\n",
              "      <td>27/01/1968</td>\n",
              "      <td>52</td>\n",
              "      <td>3</td>\n",
              "      <td>3052</td>\n",
              "      <td>6</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9.0</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1</td>\n",
              "      <td>MG</td>\n",
              "      <td>DIAMANTINA</td>\n",
              "      <td>1450.0</td>\n",
              "      <td>SENADOR MODESTINO GONCALVES</td>\n",
              "      <td>316590.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>...</td>\n",
              "      <td>2</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>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>20/12/2020</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</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>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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>147400</th>\n",
              "      <td>23/11/2020</td>\n",
              "      <td>48</td>\n",
              "      <td>11/11/2020</td>\n",
              "      <td>46</td>\n",
              "      <td>CE</td>\n",
              "      <td>1 CRES FORTALEZA</td>\n",
              "      <td>1519.0</td>\n",
              "      <td>FORTALEZA</td>\n",
              "      <td>230440</td>\n",
              "      <td>HOSPITAL OTOCLINICA</td>\n",
              "      <td>3001113</td>\n",
              "      <td>F</td>\n",
              "      <td>29/11/1957</td>\n",
              "      <td>62</td>\n",
              "      <td>3</td>\n",
              "      <td>3062</td>\n",
              "      <td>5</td>\n",
              "      <td>9.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9.0</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1</td>\n",
              "      <td>CE</td>\n",
              "      <td>1 CRES FORTALEZA</td>\n",
              "      <td>1519.0</td>\n",
              "      <td>FORTALEZA</td>\n",
              "      <td>230440.0</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>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>...</td>\n",
              "      <td>2</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>NaN</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>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>05/11/2020</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</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>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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>556474</th>\n",
              "      <td>27/09/2020</td>\n",
              "      <td>40</td>\n",
              "      <td>23/09/2020</td>\n",
              "      <td>39</td>\n",
              "      <td>RS</td>\n",
              "      <td>017 CRS</td>\n",
              "      <td>1604.0</td>\n",
              "      <td>IJUI</td>\n",
              "      <td>431020</td>\n",
              "      <td>HOSPITAL DE CARIDADE DE IJUI</td>\n",
              "      <td>2261057</td>\n",
              "      <td>F</td>\n",
              "      <td>21/09/1976</td>\n",
              "      <td>44</td>\n",
              "      <td>3</td>\n",
              "      <td>3044</td>\n",
              "      <td>5</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1</td>\n",
              "      <td>RS</td>\n",
              "      <td>017 CRS</td>\n",
              "      <td>1604.0</td>\n",
              "      <td>IJUI</td>\n",
              "      <td>431020.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>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>...</td>\n",
              "      <td>2</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>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.0</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>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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 154 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        DT_NOTIFIC  SEM_NOT  DT_SIN_PRI  ...  RES_IGG RES_IGM RES_IGA\n",
              "136921  04/10/2020       41  25/09/2020  ...      NaN     NaN     NaN\n",
              "348342  07/09/2020       37  31/08/2020  ...      1.0     1.0     4.0\n",
              "63547   20/12/2020       52  19/12/2020  ...      NaN     NaN     NaN\n",
              "147400  23/11/2020       48  11/11/2020  ...      NaN     NaN     NaN\n",
              "556474  27/09/2020       40  23/09/2020  ...      NaN     NaN     NaN\n",
              "\n",
              "[5 rows x 154 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "WX4fd8abmsLR",
        "outputId": "4103541e-0bd9-4b10-b4a5-b78cdd17c67e"
      },
      "source": [
        "# Verifica se tem NaN na target \"EVOLUCAO\"\n",
        "hasNan = pd_n_sarg_2020['EVOLUCAO'].isnull().values.any()\n",
        "print(hasNan)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "False\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "3X1tE60Rmw8m",
        "outputId": "0d6bfe9d-5db4-40d3-8c37-cfeb5844ab5b"
      },
      "source": [
        "# Verifica se tem NaN na target \"CLASSI_FIN\"\n",
        "hasNan = pd_n_sarg_2020['CLASSI_FIN'].isnull().values.any()\n",
        "print(hasNan)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "False\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "fNvPrRkOZdsP",
        "outputId": "45f94202-57dd-4eb2-93d0-ca4ec5a674c3"
      },
      "source": [
        "pd_n_sarg_2020.groupby('EVOLUCAO').size().sort_values()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "EVOLUCAO\n",
              "Óbito por outras causas     14096\n",
              "Ignorado                   174530\n",
              "Óbito                      301804\n",
              "Cura                       701374\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 116
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 279
        },
        "id": "WmVsyfQ4g2d3",
        "outputId": "36de2de6-4473-459b-cac3-c6e1fc46c7a9"
      },
      "source": [
        "pd_n_sarg_2020.groupby('EVOLUCAO').size().sort_values().plot(kind='barh')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7fbaca1c5590>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 65
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAdgAAAD1CAYAAADznOTFAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAYXUlEQVR4nO3deZhcdZ3v8XcTCPtyRUZ0LhLGB76ERYSEOyhrFGUJiAooF1AIOjB6QSKb4MLqMBG5iAJX8YHrxjDMHRCGTWQRGBAHQg+Mgs2XReMgiOAgStCEJX3/OKehrHR3pZP+dddJv1/Pw5OqX53lU01Snz7n/Kqqp7+/H0mSNLpWGO8AkiQtjyxYSZIKsGAlSSrAgpUkqQALVpKkAixYSZIKWHG8A6g79Pb2+n4tSVoK06ZN6xls3ILVq6ZNmzbeEUasr6+PqVOnjneMEWliZmhm7iZmhmbmnqiZe3t7h3zMU8SSJBVgwUqSVIAFK0lSARasJEkFWLCSJBVgwUqSVIAFK0lSARasJEkFWLCSJBVgwUqSVIAFK0lSAX4WsV415cTrxjvCUvr5eAdYCk3MDM3M3cTM0Mzczcs8b065z0/2CFaSpAIsWEmSCrBgJUkqwIKVJKkAC1aSpAIsWEmSCrBgJUkqwIKVJKkAC1aSpAL8JKcGiYiNgXOB9YBJwF3AcZm5cFyDSZIW4xFsQ0TEJOAK4KzM/B/A9Pqhk8cvlSRpKB7BNse7gYcy83aAzOyPiBOAN0fEvZk5HSAi7gX2A04FXgTWBWYBlwKrA6sBR2XmPWP/FCRp4vAItjk2Be5vHcjMPwHDnR5+NjP3BdYHLsrMGcBJwKeLpZQkAR7BNkk/1XXXkRg4Sv0N8PmIOA5YGXhhNINJUlP19fUV27YF2xwPAUe2DkTEysCGbcut1HL7xfrP2cATmfnhiJgOnF0spSQ1yNSpy/Z1db29vUM+5ini5rgJ2DAi9gaIiBWAL1Jdb31DRPRExPrAWwZZ9/XAY/Xt9wOTxyCvJE1oFmxDZOYiYDfg8Hoi053A74GjgZuBucDfAfcNsvp3gGMi4kbgbmD9iJg1JsElaYLyFHGDZOavgb0HeWiwsjy0Zb25QOt5kKtHN5kkqZ1HsJIkFWDBSpJUgAUrSVIBFqwkSQVYsJIkFWDBSpJUgAUrSVIBFqwkSQVYsJIkFeAnOelV8+bMHO8II9bX17fMH9Y91pqYGZqZu4mZoZm5m5q5JI9gJUkqwIKVJKkAC1aSpAIsWEmSCrBgJUkqwIKVJKkAC1aSpAIsWEmSCrBgJUkqwIKVJKkAC1aSpAIsWEmSCrBgJUkqwIKVJKkAC1aSpAIsWEmSCrBgJUkqwIKVJKkAC1aSpAIsWEmSCrBgJUkqwIKVJKkAC1aSpAIsWEmSCrBgJUkqwIKVJKmAFcc7gLrHlBOvG+8IS+nn4x1gKTQv8/cP+avxjiA1ikewkiQVYMFKklSABStJUgEWrCRJBViwkiQVYMFKklSABStJUgG+D7YhImJ34BPA/pm5cLzzSJKGZ8E2x7rA+zPzlfEOIknqzILtchHxFuBcYH3g2Ij4EXAC8DXg8sy8tmXZ9YHTMvOIiNgJeCgznx6P3JI00XkNtotFxArAFcC5mbltZm4DzAO+MdjymflUZh5R3z0M+IsxCSpJWoxHsN3tPcDDmXlLy9g5QAKPAntHxGxgPWAW8CxwOXAS8D5g84jYF9gOOAZ4GejNzKPH7ilI0sRkwXa3TYH7Wgcysz8iHgDWBPozc9eI2Av4LHBsvcxNEXE/cCRV6Z4JvC0z50fENRExIzNvHdNnosZbsGABfX194x1jRJqYGZqZ28yLs2C7Wz8waZDxHuAVYKAk7wHmDLGNTYBHMnN+ff82YOuWdaUlssoqqzB16tTxjjEifX19jcsMzcw9UTP39vYO+dgSX4ONiDdGhNf0xtZDwPTWgYjoATYHXqQq4AGtt2kb72m5PxlYNIoZJUmDGLZgI6InIk6PiF8B1wA3RMQvIuKz9QQclXUTsFFE7Nky9ingDqpTvzvWY9sB7ec5FlGdoXgY2Dgi1qzHdwbuLZZYkgR0PoL9HLAWsElmTq9nsW5JNanmC6XDTXSZuQjYDTg8Iu6NiH+nui77yYFlIuIa4HTgjLbVb6ea8DQFOJ7ql6M7gPsy884xiC9JE1qna7Dvy8xprQP1tbzZEdELfKZYMgHVW2+oZgS3O3SIVabX650GnFaPPQh8b9TDSZKG1OkI9sVhHntpNINIkrQ86VSwf4yILdoHI2IbYP4gy0uSJDqfIj4BuCIirqR6P+YkYFtgJrDncCtKkjSRDXsEm5m9wDTgF1QzVadTzVbdOjMfLR9PkqRm6vhBE/WkpgsH7kfEWsAHI+KAzNytZDhJkppqiT7JKSJWBd4LHAi8E/gnFn9biCRJqg1bsBHxXuAAYFeqj9j7FrBRZn6seDJJkhqs0yzi7wFvAw7IzA9m5pVU38giSZKG0ekU8ZupjmDPqq+9XgasUjyVxsW8OTPHO8KITdQPGB8PTfumFGm8dZpF/GRmnpOZ04G9qD7fdlJEzI2IT4xJQkmSGmiJv64uMx8GTgVOjYjpVBOeJEnSIDp9m87kiDgjIlZqGdsc2DszjymeTpKkhuo0yelLVN+m07rcI8BaEXFysVSSJDVcp4J9R2YenZkLBwYy80XgWOA9RZNJktRgnQr2lcEG6+8pnTz6cSRJWj50KtjfRsQO7YMRMRN4qkwkSZKar9Ms4tlU36bTB9xP9W06f031/lg/h1iSpCF0eh/so8DWwDeBPwHPA+dTfZvOb8rHkySpmTp9FvFm9c3H6//6gV9nZn/pYJIkNVmnU8QXDDK2XkQ8BxycmfNGP5IkSc03bMFm5ozBxuuJT18B9ikRSpKkpus0i3hQmXknsOYoZ5EkabmxVAVbfwH7yqOcRZKk5UanSU6DfWPOOsD7gHOKJJIkaTnQaZLTeoOMPQPMyswHC+SRJGm50GmS02lDPRYRe2XmtaMfSZKk5luqa7A1v65OkqQhLEvB9oxaCkmSljPLUrB+mpMkSUPoNIv4GaoibT1aHbi/VsFckiQ1WqdJToPNIpYkSR10epsOEbEOcBgQVF/A/jPgW5k5v3A2SZIaa9hrsBGxOXA3sBpwLXAD8Drg7oiYVj6eJEnN1OkI9qvAPpn5UMvY1RHx/6i+aeddxZJJktRgnWYRr9pWrgDUY6uViSRJUvN1OoJdZbDBiFgBC3a5M+XE68Y7wlL6+XgHYN6cmeMdQVKX6XQE+/2I+EZEvPrVdBGxLvBN4B+LJpMkqcE6HcF+HjgB+GlE/AmYBKwEXJCZZ5cOJ0lSU3Uq2K0ycw4wJyLWAsjMP5SPJUlSs3Uq2AsiYm3gMuDSzHxsDDJJktR4w16Dzcx3ALsDLwCXRMS/RcTREfGGMUknSVJDdfyw/8x8PDPPycy3Ax+kug77jxFxY/F0kiQ11BJ/m05ErAhsCWwFvJ7qIxMlSdIgOn2bziRgV+AAYGfgVuC7wKzMXFQ+niRJzdRpktMfgOup3vP6t5m5cOCBiJiemfeWDCdJUlN1OkWcmbl/Zn4vMxdGxNdaHjurZLDlSURMiYgx/2UkItaIiHljvV9JUueCfa7t/qYtt3uQJEmD6vh9sMPoH7UUE0REvBX4NtUvLvcC6wGn1mOPUU0guy8zPxYR/x34v8BkYBHwUaqf+SXAfOB8YG3gKKrv6X0wMw+vPxDkCqrPkb6zZd+7AGcCLwG/Ag5rPeUvSRpdSzyLuGapLptTgNMzcwawYcv4NOAzwLbAnvWX3J8OXJyZuwD/h6qIAbYGDsrMa4HVgd0zc3tg04jYEjgYeCAzdwTub9nH14EPZebOwO+AA8s8RUkSdD6CnR4R99S3e4Co7/cAmxRNtnyaCvyovn011QxtgEcz8ymAiHiS6sh0OnBS/fitwMn17ccy87/q288C/xIRA9teF9gMuL1+/LZ6m68D+jPz8Zbt7Uz1pQ0aBX19fUu87IIFC0a0fLdoYu4mZoZm5jbz4joV7JbF9jwx9VCd7oU/Pxvw8iDL9fPade6B08QALwJExGSqL73fKjOfiohrB9nHwBmK1m21b0+jYOrUqUu8bF9f34iW7xZNzN3EzNDM3BM1c29v75CPDVuwmfnLZdqz2j1GdWR6A7AHixdrq7nADKq3SO1Mdc221ZrAy3W5blBvdzKQ9e0r6vXJzN9FRH9EvDkz/7Pe3p1IkooZ6TVYLZsvAGdHxA+Ap6kmJw3lZOAjEfFD4FCq67evqk8T3xQRc+vHzgK+TFXI20XELUDw2pHy3wCXRsRtVF85eNkoPSdJ0iCWZRaxllBmzqO6nr0dcGBm/iQiTgJ+O/BYy7LTW1bdY5DNtS57aNtj59R/zmgZO6Ve9k5gh6V8CpKkEbJgx9ZC4OL6y+v/iDN5JWm5ZcGOocy8j+qtOJKk5ZzXYCVJKsCClSSpAAtWkqQCLFhJkgqwYCVJKsCClSSpAN+mo1fNmzNzvCOMWBM//1TSxOARrCRJBViwkiQVYMFKklSABStJUgEWrCRJBViwkiQVYMFKklSABStJUgEWrCRJBViwkiQVYMFKklSABStJUgEWrCRJBViwkiQVYMFKklSABStJUgEWrCRJBViwkiQVYMFKklSABStJUgEWrCRJBViwkiQVYMFKklSABStJUgEWrCRJBViwkiQVYMFKklTAiuMdQN1jyonXDTo+b87MMU4iSc3nEawkSQVYsJIkFWDBSpJUgAUrSVIBFqwkSQVYsJIkFWDBSpJUQPH3wUbE7sAngP0zc2Hp/UmS1A3G4oMm1gXen5mvjMG+JEnqCsVOEUfEWyLiGmA2MDcizouIVevHvhURe7Utv35EXFjf3iki/qJUtmUREW+NiE3GO4ckqbsVKdiIWAG4Ajg3M7fNzG2AecA3hlonM5/KzCPqu4cBXVmwwAcAC1aSNKxSp4jfAzycmbe0jJ0DZMuR6d4RMRtYD5gFPAtcDpwEvA/YPCL2BbYDjgFeBnoz8+jWHUXEbcBcYDqwKvChzPxlRJwFbE/1HM/PzO/Wyz4AkJlHtmxjS+ACYBHwPHAI8FbgyMzcr17mt8AM4G+BZyLiaeAfgOuBp4Fr6228VG9n/3pblwBvBFYGTsnMG1r2uxLwbWBDYAHwkXqdS4HVgdWAozLznoiYB2yRmfMj4uz6efyw3v4r9fM8GPjdEOt/muqXg0XANZl55iD/3yRJo6RUwW4K3Nc6kJn9EfEAsHE91J+Zu9anij8LHFsvd1NE3A8cSVW6ZwJvq4vlmoiYkZm3tu3vvzJzRkQcBcyOiCupymj7iFgd+ElEXFUv+0Bmfr1t/a8Ax2fm3RFxHHA00L4PMvOnEXEDcHldWisB38/MGyLi3VRldl9EnA4cBPwIeH1m7hQR6wB7tm3yEOCpzDwwIg4A3gvcAlyUmVdFxDuBTwP7DvFz3g+4KTPPiIhteK3IB1v/uPrxV6h+SVhifX19I1l8TC1YsKCr8w2miZmhmbmbmBmamdvMiytVsP3ApEHGe6he4OG1ArsHmDPEdjYBHsnM+fX924CtWbz8bq7//DGwB9XR7O0AmflCRPyM14r9nkH2s1lm3t2S65RB9jGUge39BvhiRKwGvInq6PYhYM2I+C5wJXBZ27rbUBUqmXkZQESsDXy+LvqVgReG2feNwJV1eV+emT8eZv3LqX5Ol9bZltjUqVNHsviY6uvr6+p8g2liZmhm7iZmhmbmnqiZe3t7h3ys1CSnh6hK7lUR0QNsDjxcD/W3PNx6m7bxnpb7k6lOcbYbeB499TrDrfdih+wDy7ZnWmmI5Qe29xXgK5m5M3AhQGb+keoU94VUR68Xta37Cov/P5gNPJGZOwAfbxlvzbNSvf0HgK2AO4C/j4iPDLV+Zn6c6sh1feC2iPCrCiWpoFIFexOwUUS0nhL9FHBHZj5b39+x/nM7oP0YfRHV0fXDwMYRsWY9vjNw7yD7G9jW24GfUV2T3QUgItYA3gI8MkzeByLi7W37+APVKVUi4q3AQIaBbO1eDzwWEStTlenk+rTtgZl5J1XZbda2zlzgnfU+9oqIzwxsp378/VSFz0CeiJhE9TOjPq28RWZeBXyO6peaxdaPiLUj4uTMfCgzT6c69b7WMD8PSdIyKnIUk5mLImI34Ov19cgVqErrk63L1W/j2QD4cNsmbqc6pbkPcDxwQ0QsAu6sy6rdm+tro+sA+2bmExHRGxH/SnW0d2J9qnioyJ8ELoiIfqpJQrOA+cALEXEX1bXUefWydwBfjYjn27ZxHnAVVbmdB5wP/AA4OCKOoDpa/VLbOpcBu0bE7VSTow6hOr38nYjYv97G/4yIWfXta4AEHqzXf5jqZzy/3v4ngTXa16ea3LReRNxTP6+7Wn7RkSQV0NPfP9TZ2WaoZwYfWZ8u1VLq7e3t3/efnxr0sXlzZo5xmiU3Ua/7jIcm5m5iZmhm7omaube3l2nTpvUM9pifRSxJUgGNn+iSmbuMdwZJktp5BCtJUgEWrCRJBViwkiQVYMFKklSABStJUgEWrCRJBTT+bToaPd38gRKS1DQewUqSVIAFK0lSARasJEkFWLCSJBVgwUqSVIAFK0lSARasJEkFWLCSJBVgwUqSVIAFK0lSARasJEkFWLCSJBXQ09/fP94Z1AV6e3v9iyBJS2HatGk9g41bsJIkFeApYkmSCrBgJUkqwC9cFxHxZWA7oB84OjPnjvH+twD+BfhyZp4fERsA3wUmAb8GPpyZCyPiIGA2sAj4RmZeHBErAd8CNgReAWZl5s8jYivga/Vz+klmfrze1/HA/vX4aZl5/VJmPgvYkerf0N8Dc7s5c0SsVu/zDcAqwBnAf3Rz5pbsqwIP1Jlv6fbMEbEL8M/Ag/XQT4Gzuj13va2DgBOAl4GTgZ90c+6I+Cjw4Zah6cD2S7q/iFgbuBRYG5gPHJiZz0bErsCZ9fO4PjPPqLcxotdKj2AnuIjYGdg4M98OfBT46hjvf3XgPKoXzgGnAxdk5o7Ao8Bh9XInA7sCuwCfiojXAQcCz2XmDsDfUZUdwLlU/wC2B9aOiD0iYiPgAGAHYC/gnIiYtBSZZwBb1D+z3et9dXVmYG/g3szcGfggcE4DMg/4HPBsfbspmW/PzF3q/45qQu6IWBc4pWVb+3R77sy8eODnXGf/9gj3Nxu4rc78PeDT9aa/CuxLVdbviYjNlua10oLVu4CrADKzD/hvEbHWGO5/IbAn8GTL2C7A1fXta6j+If81MDczf5+ZfwJ+RPWX/13AlfWyNwPbR8RkYKOW3y4HtjED+H5mvpiZzwC/BDZbisz/SvWbMMBzwOrdnjkz/ykzz6rvbgD8qtszA0TEpvW619VDXZ95CE3IvStwc2Y+n5m/zszDG5J7wMnAF0e4v9bM1wC7RsRfAc9m5uOZuQi4vl5uxK+VFqzWB55puf9MPTYmMvPl+h9pq9Uzc2F9+2ngjSyec7Hx+h9Dfz32u+GWbRsfaeZXMvOF+u5Hqf4BdnXmARFxF9UpsdkNyfy/gWNa7jchM8BmEXF1RNwZEe9uSO4pwGp17jsi4l0NyU1EbAs8TnVqeyT7ax0fybKwBK+VFqzaDfp+rnE0VJ6RjI90G0skIvahKtgjl3F/Y5Y5M98BvBe4pG1bXZc5Ij4C/DgzfzHC7Y73z/kR4DSqU6yHABfz5/NdujV3D7Au8AHgUOCbdPnfkRYfo7r+uyz7G43n92csWD3Jn/8W9iaqyQzjaX49sQXgL6kytudcbLyeZNFDlX/d4ZZtGx+xiNgN+CywR2b+vtszR8S0evIYmXk/1Qv+892cGZgJ7BMR/0b1Avp5uvznDJCZT9Sn5Psz8zHgKarTiV2dG/gNcFd9Vukx4Hm6/+/IgF2Au6iOKkeyv9bxkSwLS/BaacHqRmA/gIjYBngyM58f30jcTDXBgPrPG4C7gW0jYp2IWIPqms8dVPkHrofuDdyamS8BD0XEDvX4B+pt/BCYGRGTI+JNVP9wfjbScPXMwy8Be2XmwOSbrs4M7AQcW+d/A7BGt2fOzA9l5raZuR1wEdUs4q7ODNVM3Ig4rr69PtXM7W92e+56v++MiBXqCU9d/3cEoF5/fn19daT7a828L3BDZs4D1oqIKRGxItWkqBtZitdKP8lJRMQcqhfgRcD/ysz/GMN9T6O6zjYFeAl4AjiI6nTPKlSTEWZl5ksRsR9wPNW1nfMy8x/qmYAXARtTTZg6NDMfj4jNgAupfom8OzOPqfd3VL39fuBzmdk6e3lJMx8OnAo83DJ8SJ2jWzOvSnWqcgNgVapTmPcC3+nWzG35TwXmAT/o9swRsSbVde51gMlUP+v7uj13va0jqC57AHyB6u1nXZ27fg35QmbuUd9f4v3VvyBcQnXU+xxwcGb+PiJ2opowBXBFZp5db2NEr5UWrCRJBXiKWJKkAixYSZIKsGAlSSrAgpUkqQALVpKkAixYSZIKsGAlSSrAgpUkqYD/D9zhhZ2jk1/fAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "lUCfa7Mb5wIm"
      },
      "source": [
        "Identificação de todos o casos identificado de SARG em 2020 - Incluindo os Recuperados e os Óbitos"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 279
        },
        "id": "4nCBhI2NiRGl",
        "outputId": "cb09cd36-d75a-4f62-d8da-0c2d49dfff69"
      },
      "source": [
        "pd_n_sarg_2020.groupby('CLASSI_FIN').size().sort_values().plot(kind='barh')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7fbac7d4f5d0>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 62
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAggAAAD1CAYAAAA1bw2NAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3deZhdVZ3u8W8xBCKjSItRkcFLv4bhAgZtBUICggwqKCBDuNAoV72Kgg00IioERaBFGZrY2ly5ICpiA0EUaRBkEIFmKAYbLV5RRBmSRgZtwIyk7h9rHT3UOZWcCqnhhPfzPHlyzt5rr/Xbu5Lav73W2nv39Pf3ExEREdFshdEOICIiIsaeJAgRERHRIglCREREtEiCEBERES2SIERERESLJAgRERHRYqXRDiBiafT29ub+3IiIpTBp0qSeTsolQYiuNWnSpNEOYcj6+vqYOHHiaIcxZIl7ZCXukdetsQ817t7e3o7LZoghIiIiWiRBiIiIiBZJECIiIqJFEoSIiIhokQQhIiIiWiRBiIiIiBZJECIiIqJFEoSIiIhokQQhIiIiWuRJitG1NjzuR6MdwlJ6aLQDWEqJe2Ql7pE39mN/+LR3jVhb6UGIiIiIFkkQIiIiokUShIiIiGiRBCEiIiJaJEGIiIiIFkkQIiIiokVuc1wKkg4HDgbmAeOB421fJ2k6cBDwGNBT151q+/KmbT8NHAVMsL2waflRwDRgDrAqcJbt7wxT/JsAZwF/A6wI3AocY3uepFcAZwB/BywA/gv4mO1HJN0GfNx2b1NdpwJPAmsAT9qeIelGYDXgeWBl4FrgC7ZfaBPL5sAVwJm2Z9RlbwLOBfqBXwEfbT5WEREx/NKDMESSNgQ+BEy2PYWSEHyuqcjZtqfWdbsBZ0sa37T+QOApYOemOqcBk4FtbU8G3gNMlzRxGOJfEbgM+JLttwLb1FUn1L/PAB63vXVdfxpwtaSVgYuA/QZUuQ9wcZumPmB7KrAj8Frgi21iWQ04B/jJgFX/REmspgC/b9NmREQMs/QgDN1alCv8ccAC2w8CU9oVtP20pFnABOAhSVtQrti/QkkUrq5FjwAOtj2/bjdb0qa2FzTXJ+lQStKxJvB6ylX3+ZKmAqdQrvgfBT5Y69+dcnI+wPZjtZpdgAds31Tb6pd0LLBI0hp1mzc27cMtkm4H9gK+B9wCfKrGMwl4zPZjktoeLNvzJf0DYEmfG7BP84A9GvU12QS4o36+BvgYJTmJiIgRkh6EIbJ9H+Xk9VtJF0jaT1LbREvlrLke5aQNZQjhYsoV/B6SVq3LN6iJRnM7L0oOmmwG7AnsBJwsaQXg68D+9Yr7mdoOwBuAHZqSA4A3AfcOaGuO7XmUxOCBNt359wKy/QQl0XlrXb4fHZy4bT8PPFLjaV6+0PacNpv8J9B4XNiulGMYEREjKD0IS8H2IbX7f1fgWOCjknaqq4+UtC/lKn8VYFq9iu4BDgB2qT0Lt1GunmcCSOqpV/PvA44EVgdm2j5lQPM31RP4k5KeAdYF+m0/UtffQOnRuBu403b/gO37Kb0Y7Qy2rgdozB+4CNifkiTtCWw7SF0DrdFUx5IcA3yt9pjcVNuPiHjZ6+vre9H3uXPntixbVpIgDFE90a9iuw/ok3QO8AB/vTo+u07UmwBcD/y8Lt+WciV8ae2OX5uSMMwEfg1sBdxTJzReXk+Om7cJobnXp4dyUm8+gY4DFtXP89ts/wDw8QH7tAqlW/+h8lXjGsMd1VZAY6LlTOB4Sd8FfmX7mTZtvIikV1L29/eSrqAM03zL9nntytdk5911210pQzQRES97Eye+eGpaX19fy7LF6e3tXXKhKkMMQ3cYcG5NFKCc7FYAnmguZHsWcCFwYl00DfiU7a1sb0UZKpgiaXXgTOCMOmkPSeOAHYC5bdp/u6QVJa1LuSp/CuiX1EhQpgB3LSb+a4ENJL2ntrUCZVLg/rafBX4ITG8UlrQtsDXwo7pfz1KSnuPpYHihDr+cRUmcFtneq07ibJsc1G1OktQYYvhAjSkiIkZQEoShO5+SDNwu6XrKLXpHDDKWfgawp6QtKd3xfzmh1nH5K4G9bM8EzgNulnQz5bbDWcDJbep8GLiE0jvxGduLKHdVXFRvL1yZ9ncVNNpdRBka+bCku4CfAX/ir4nMJ4FVJd0n6Q7gM8D7B9yieBFlsuMPBmsHOF/STcA9wOP1WLyIpEk15kMpQzM3Slqn1n+ipDspd1R062sbIyK6Vk9//8Ah6hirGsMOto8Z7VhGW29vb/8+l8we7TAiIkbUwNc9L80Qw6RJkzqa15UehIiIiGiRSYpdxPYFox1DRES8PKQHISIiIlokQYiIiIgWSRAiIiKiReYgRNcaOJu3Gwx1xvFYkbhHVuIeed0c+3BJD0JERES0SIIQERERLZIgRERERIskCBEREdEiCUJERES0SIIQERERLZIgRERERIskCBEREdEiCUJERES0SIIQERERLZIgRERERIskCBEREdEiCUJERES0SIIQERERLZIgRERERIskCBEREdEiCUJERES0SIIQERERLZIgRERERIskCBEREdEiCUJERES0WGm0A4hYWhse96PRDmEpPTTaASylxD2yBo/74dPeNYJxxMtVehAiIiKiRRKEiIiIaJEEISIiIlokQYiIiIgWSRAiIiKiRRKEiIiIaJHbHAFJhwMHA/OA8cDxtq+TNB04CHgM6KnrTrV9edO2nwaOAibYXti0/ChgGjAHWBU4y/Z3OoxnW+BkYEVgNnCA7f6Xup/LiqTdgI1sf03SDGBb4JPAO2yfuJR1bg7MsD112UUaERFL62WfIEjaEPgQ8BbbCyRtAnwDuK4WOdv2jFp2HeBeSVfbnlPXHwg8BewMXF3LTQMmA9vani/pNcDNku623bekmGzfCuy0zHZyGbN9ddPXPYA32/4j8NNRCikiIpaxl32CAKxFucIfByyw/SAwpV1B209LmgVMAB6StAXlKv8rlEShceI8AjjY9vy63WxJm9pe0FyfpEOB7YG/AQScbvs8SQcBnwBeAH5h+8OSVgbOBTYGVgFOsP3jAfUdTum1WAR83/ZXJG0N/Auld2QesD/lav/1wBvqvvyj7asl7Q0cDSwE7rJ9dG33m8AGwFzgEGAXYHPgv4DXAj+U9OW6z/tKOrgeg0XAGba/J+loYF/KsNZVtk+S9HrgkhrXfU37sR+lV2Yh0Gv7yHY/j4iIGD4v+zkItu8D7gB+K+kCSftJaps4SRKwHvBoXTQNuBi4DNhD0qp1+QY10Whu50XJQZMtgL2B91KSAoDVgN1sbwe8qSYiBwJzbU+p5WcMiG0jygl4e2AHYB9JbwA+APxL7br/J+A1dZPX2X5n3YdTJa0OfBbYqbaxvqTtgL8HZtdY/i+wZ9M+nU4ZAtkd+FONYw3ghBrDrrX+hu2BtwGHSlqTkkRcXGN7vG6/OnAKsLPt7YGNJe04yLGLiIhhkh4EwPYhkiZSTmjHAh+V1OjiP1LSvsCalCv3aXXYoAc4ANil9izcRulunwkgqcd2v6T3AUcCqwMzbZ8yoPnbbL8g6VFKbwbA08AVJR9hIvAqYBvgxhrv45LmSVrH9tN1m7cCmwA31O9rABsCVwBfk/S3wPdsP1Dr/Umt6z8lvQ7YjNKjcE1dvxal1+DNTWUvrvt26GIO50TggToEMwfYqy7/M3ATpVdgXWAdYFNKDwJ133YH/hZ40PZzTcu3btqviJe9vr4ljlSOirlz547Z2JakW2Mfzrhf9glCPdGvUucG9Ek6B3iAcrKEOgdB0gTgeuDndfm2lN6ES+sJdW1KwjAT+DWwFXBPndB4eT2pbt4mhIVNn3skjQO+CmxZhyaurOv6KRMlG8ZRuvAb5gM/sv2RNvv4FuDdwDclHVMXD+w9mk/pzt91wLZvb1N2cV4YWF7SBpQhg61tPyfp/rqqp2kfGtu02885RMRfTJw4cbRDaKuvr2/MxrYk3Rr7UOPu7e3tuOzLfogBOAw4tyYKUK6cVwCeaC5kexZwIdCYpT8N+JTtrWxvRbkCn1K7yM8EzpC0GkA96e9AGcNfkjWAhTU5WJ/SczAOuBPYsda3PrCoTgxs6AV2lPQKST2SzpY0XtLHgXXqHRRnUq7GoXT3I+l/Ar8DDEyU9Oq6/KTas3AndcKkpHdLOn4J8T9Qimp1SatKupbSY/BETQ7eTOmZGFfb3KZu1xhG+BWwSR2qgDIf5K4OjltERCxDSRDgfEoycLuk6yld8kc03aXQ7AxgT0lbUsbiL2qssP08cCWwl+2ZwHmUOxduBm4FZlFuXVws208B10q6k5KMfIlyYv8esKKkGyjzHj4yYLvfA2dR7iT4D8q8gTmU3oxLJP2EktQ0brX8b0k/qN+Ps/1nyuTFqyTdQhnWeLy2tZqkm+r6by4h/ucpcxCuowwPfAO4F3iu1rs/8K+UiZNnAx+UdA3wyqbt/xG4uh67e2z/bEnHLSIilq2e/v4xc3t9jJD6fIcnG7dvdqPe3t7+fS6ZPdphRIyKsfq6527tpofujX1phhgmTZrUs+SS6UGIiIiINl72kxRfjmxPH+0YIiJibEsPQkRERLRIghAREREtkiBEREREiyQIERER0SKTFKNrjdVbvRbn5XIr1ViRuCOWXnoQIiIiokUShIiIiGiRBCEiIiJaJEGIiIiIFkkQIiIiokUShIiIiGixxNscJR2yuPW2L1x24URERMRY0MlzENq9FnIl4P8ArweSIERERCxnlpgg2P5m83dJ+wPHAd8HvjxMcUVERMQo6vhJipJ2BL4I9AK72n5i2KKKiIiIUdXJHITNgdOA54CDbf9m2KOKiIiIUdVJD8K9wC8pPQefkdRY3gP02/7gMMUWERERo6STBOGNwx5FREREjCmdJAh/GPYoIiIiYkzpJEH4BdDPi293bHzvBzYehrgiIiJiFHVym+NGIxFIREREjB1LfNSypIsGfD97+MKJiIiIsaCTdzFMGPB9i+EIJCIiIsaOpXlZU7tHL0dERMRypJMEoX8J3yMiImI508ldDJMlNR6r3AOsVb83HpT06mGLLiIiIkZFJ3cxrLykMpI2sP27ZRNSRGc2PO5Hox0CAA+f9q7RDiEiYplbmjkI7Zy/jOqJiIiIMWBZJQiZuBgREbEcWVYJQiYuRkRELEeWVYIQERERy5EMMURERESLZZUgXL+M6omIiIgxYIm3OUo6ncXMMbB9rO0vLNOoupSkw4GDgXnAeOB429dJmg4cBDxG6W0ZD5xq+/KmbT8NHAVMsL2waflRwDRgDrAqcJbt7wxD7LsBG9n+2iDr3wT8ADgH2Af4uO37l3UcERExNnTyoKScBDogaUPgQ8BbbC+QtAnwDeC6WuRs2zNq2XWAeyVdbXtOXX8g8BSwM3B1LTcNmAxsa3u+pNcAN0u623bfsozf9tVLKPJW4Crb50jaZ1m2HRERY08nD0r6pqSVbS8AkLQK5WTxO9u/H+4Au8halCv8ccAC2w8CU9oVtP20pFmUF2E9JGkLYEXgK5REoXGyPgI42Pb8ut1sSZs2fhYNkg4FdgPWBF4PnGn7fElTgVOABcCjwAdr/bsDrwUOsP1YUx2bAzOAbwK/AbYE7gE+DRwPrCbpt03tTgeetD1D0ubADNtTJe0NHA0sBO6yfXStf3vgbwABpwMXAf9eq1sZ2Mb2KpIOAj4BvAD8wvaHF3/oIyJiWevkdc8HALfUz6sCdwMnAd+XdPDwhtc9bN8H3AH8VtIFkvaT1DYBkyRgPcpJG8oQwsXAZcAe9TgDbFATjeZ2XpQcNNkM2BPYCThZ0grA14H9bU8BnqntALwB2KGRHLQxiZIQvAXYg5JgnAZ8z/ZiX/ctaXXgs8BOtd31JW1XV28B7A28F/iE7Tm2p9qeCtxKSUQAVgN2s70d8KaaQEVExAjqZIjhaMrVKcD+wGzb76gnseuAbw1XcN3G9iGSJgK7AscCH5W0U119pKR9KVf5qwDT6rBBD3AAsEvtWbiNclKeCSCpx3a/pPcBRwKrAzNtnzKg+Zvq3IUnJT0DrEt5V8Yjdf0NlB6Nu4E7bS/u2RW/tj27tv84pXekU5tREpBrSh7EWsAGdd1ttl+Q9GhznZJ2pvReHFsXPQ1cUbefCLxqCO2PuL6+zkd75s6dO6TyY0XiHlmJe+R1a+zDGXcnCcJztp+qn3cFvgdge66kecMSVReqJ/pV6tyAPknnAA9QTpZQ5yBImkC56+Pndfm2lN6ES+sJcW1KwjAT+DWwFXBPndB4edNQwEDNvUE9lImlzbefjgMW1c/zl7A7Cwd8H+w21uYko/HOjvlAr+1dmwvWuJvr7anL1wW+TOkx6Jc0DvgqsGUdUrlyCbGOuokTJ3Zctq+vb0jlx4rEPbIS98jr1tiHGndvb2/HZTu5zXEVSa+ov8h3568T6FaiXM1GcRhwbk0UoFwhrwA80VzI9izgQuDEumga8CnbW9neinIFPqV21Z8JnCFpNYB68twBmNum/bdLWrH+nNagTHjsl9RIUKYAdy2bXf2L/6bMo4AyvwDAwERJr64xnyTpdYup4zzK3R6z6/c1gIU1OVgf2IaS3ERExAjqJEE4E/hl/fNV27+vwwvXAJcMZ3Bd5nxKMnC7pOuBK4Ajmu5SaHYGsKekLSnzBi5qrLD9PHAlsJftmZQT6M2SbqaM088CTm5T58OUn8f1wGdsL6LcVXGRpBspV/gXL4P9bDYT2EvStZSeD2z/GfgkcJWkWyjDA4+321jS2yl3bRwr6cYa5yuBayXdSUmivgScKWmJbxWNiIhlp6e/f8mvUahXruNt/6lp2Tts/2Q4g4vONIYdbB8z2rGMlN7e3v59Lpm95IIjYCive365dGOOFYl7ZHVr3NC9sS/NEMOkSZM6evpxJ3cxrAS8s5EcSNpZ0nnA2ySN7ziqiIiI6BqdTFL8OmXi2ZWS3kiZpPgPlPvtv0q5tz5Gke0LRjuGiIhYvnSSIGxu+2318zTg32xfCCDphmGLLCIiIkZNJ5MUmyfZ7QJcNUyxRERExBjRSQ/Cn+uz99cG/ha4Fv7y8p685jkiImI51EmC8GHgC5QEYa/6gKRVgR9SnusfMSqGcvdAREQMTScva3qMARMRa5LwZuDdLPuH70RERMQo66QH4S/q8xD2oDwKeArlgT7fHYa4IiIiYhQtMUGobwXcmXIHw+7Af1DeyvfG+tS8iIiIWM50chfDbOAs4GbgTbb3Av6U5CAiImL51em7GBZQnq//UUkb8+K3+EVERMRyZokJgu1TbW9JuWNhdeA6QJIOl/TK4Q4wIiIiRl4nPQgA2L7f9vG2N6Y8MGkicO+wRRYRERGjZkh3MTTYvhW4VdJ9yzieiIiIGAM67kEYRB6UFBERsRx6qQlCHrUcERGxHOrkOQivGGRVDy89wYiIiIgxqJM5CL/gr7c1NnoMcptjRETEcqyTHgABF1EekrSR7Y2APYFv1zsaIiIiYjnTSYJwOrAGL55v8CtgDUknDEtUERERMao6SRC2tX2k7XmNBbbnA0cD7xy2yCIiImLUdJIgvNBuoe1FwLhlG05ERESMBZ0kCE9K2n7gQknvorzIKSIiIpYzndzF8EngMkl9lEcrrwj8HfAGYNdhjC0iIiJGSScva/o1sDVwPjAHeBaYAWxt+7+GN7yIiIgYDR29i6HON7im/omIiIjlXJ6EGBERES2SIETX2vC4H412CBERy60kCBEREdEiCUJERES0SIIQERERLZIgRERERIskCBEREdEiCUJERES06OhBSS+FpMOBg4F5wHjgeNvXSZoOHAQ8RnmV9HjgVNuXN237aeAoYILthU3LjwKmUZ7suCpwlu3vDPe+LImkfWxftozqmgwcARxq+/llUeeyIGkr4H22T+yw/L62L236viPwMeBg23MHlD0OuMn2bcsy5oiIGLph7UGQtCHwIWCy7SmUhOBzTUXOtj21rtsNOFvS+Kb1BwJPATs31TkNmEx5DfVk4D3AdEkTh3NflqTu64HLsMrxwH5jKTkAsH3vEJKDcZQEr9lalP2aO7C87dOSHEREjA3D3YOwFuUKfxywwPaDwJR2BW0/LWkWMAF4SNIWlBdDfYVy4r26Fj2CcvU5v243W9Kmthc01yfpUErSsSbweuBM2+dLmgqcAiwAHgU+WOvfHXgtcIDtx2odKwPnAhsDqwAn2P6xpIeBzW0/J+nLwP3A+4G3SjqBknhtDGwETAVOBbajHO8Ztr/VFOeRwFq2P1+/3wAcSekhGSfpfuDbwHOUd2DMaNP29bXMC7WN/2X7d01tXADMB14F7Ne0TyvXfbpe0iHAx2u5+2wfLulG4E5gG0rCsn/dp4/b3lfSg8DdwI+B3wFfqNs/U9s5E9hC0r/UfWq0e5ykxrF8ELgKeALYBLiU8kjvluNORESMmGHtQbB9H3AH8FtJF0jaT1LbpESSgPUoJ20oJ8iLgcuAPSStWpdvUBON5nZelBw02QzYE9gJOFnSCsDXgf1rr8UztR0ob6fcoZEcVAcCc2vZvSkn58GcTuke/3z9Pq72cGxHOaFvV+OYLmmNpu1mAu+ux2AdYD3bPx9Q99bAQbavHKTtfYFrbe9IORFPaFPmadv71P2dVcu+Fzirrj8G2Mf29sBdTT05T9Wy36G82bPZxsDnbZ8HvBKYVo/Vf1Pe9Hk6YNsfY/BjuTLw77a/2FTvUI57REQMg2Gfg2D7kNr9vytwLPBRSTvV1UdK2pdylb8K5QQzX1IPcACwS+1ZuA3Yg3IyRVKP7X5J76OcEFcHZto+ZUDzN9W5C09KegZYF+i3/UhdfwOlR+Nu4E7b/QO23wa4se7H45Lm1ZN4J+5oquOmWsfzkn5JuVK+uy57RFK/pAmUoZTvt6nrN7afWkxbPwYul7Q2cOkg3fSNeLYFJkvavn4fX4cCvlvr+DbwXdtzSs7GdbXcbZRelmbP2/5F/fwH4Bs1AdyY0qvRbHHH8o5Oytp+euBO9fX1tdnVsWvu3LldFzMk7pGWuEdet8Y+nHEPa4JQT/Sr2O4D+iSdAzxAuVqHMgdhRj05Xg80rpy3pfQmXFpPUmtTEoaZwK+BrYB76oTGy+twwuZtQmjuIekB+uvfDeOARfXz/DbbD1a+OZFYue3O/7W+xbXZ8H1KL8KulOGPwepq1Peitm3fL2lL4J3AqZL+n+0LB6ljPvBF298dsP5USd+h9EZcL2mHurxxDBvHb7C4/h/wLtt9ktpd8Q/l2HdyzACYOHFUp54MWV9fX9fFDIl7pCXukdetsQ817t7e3o7LDvdtjocB59ZEAcqchBUo481/YXsWcCHQmPw2DfiU7a1sb0UZKpgiaXXKuPYZklaDv0yE2wFomfQGvF3SipLWBdagTHjsl9RIUKYAdy0m/juBHWs76wOLbP+R0oU+QdKKwNtq2UW0T7jupMxDoMb/RuDBAWVmUnpI/oftuxcTD+3alnQAZRjj+8BnKVfgg7kd2Ktu92pJp0haQdIXKUMPZ1B6Czao5SfXv98O/HIx9a4F/L72YuzIX0/qjWMy2LFsZyhlIyJiGAx3gnA+JRm4XdL1wBXAEbbntCl7BrBnvRLeE7iosaLO5L8S2Mv2TOA84GZJNwO3ArOAk9vU+TBwCaV34jO2F1HuqrioTsBbmTLPYTAXAyvWiYMXAx+py2cAP6Sc2Btd7H3AmyWd2VyB7Z8BvZJ+ClwLHDfwzgTbpnTLdzIRr13bvwJm1GN8IvC1xWz/b8Bzkm6t9dxcj8uzwG2SfkK5gr+3ln+DpKspSdtZ7SqsvgrcQplc+CXg07WecZIuYfBj2c5QykZExDDo6e8f2Gu8fGgMO9g+ZrRj6VY1ifq47ftHO5aBent7+/e5ZDYPn/au0Q5lSF4u3ZhjReIeWd0aN3Rv7EszxDBp0qSeJZfMkxQjIiKijWG/i2G02L5gtGPodranjnYMERExOtKDEBERES2SIERERESLJAgRERHRIglCREREtEiCEF2r225xjIjoJkkQIiIiokUShIiIiGiRBCEiIiJaJEGIiIiIFkkQIiIiokUShIiIiGiRBCEiIiJaJEGIiIiIFkkQIiIiokUShIiIiGiRBCEiIiJaJEGIiIiIFkkQIiIiokUShIiIiGiRBCEiIiJaJEGIiIiIFkkQIiIiokUShIiIiGiRBCEiIiJaJEGIiIiIFkkQIiIiokUShIiIiGiRBCEiIiJaJEGIiIiIFkkQIiIiokUShIiIiGiRBCEiIiJaJEGIiIiIFisNV8WSDgcOBuYB44HjbV8naTpwEPAY0FPXnWr78qZtPw0cBUywvbBp+VHANGAOsCpwlu3vDNc+dErSPrYvG+04GiTtADxg+4mXUMeewNXAOsBJtj8ySLlDgc1tH1O/rwdcBBxm++FBtnnN4uqMiIjRNyw9CJI2BD4ETLY9hZIQfK6pyNm2p9Z1uwFnSxrftP5A4Clg56Y6pwGTgW1tTwbeA0yXNHE49qFTdV8PHM0Y2vgg8OqXWMdRwDjbs4d4It8M2Huw5ABgKeqMiIgRNlw9CGtRrvDHAQtsPwhMaVfQ9tOSZgETgIckbQGsCHyFcuK9uhY9AjjY9vy63WxJm9pe0FxfvaLdDVgTeD1wpu3zJU0FTgEWAI9STqIHArsDrwUOsP1YrWNl4FxgY2AV4ATbP5b0MOVq+TlJXwbuB94PvFXSCZSEa2NgI2AqcCqwHeU4z7D9rQGxHg3sW7e7yvZJkl4PXALMB35KSbKmStobOBpYCNxl++i6r9sDfwMIOB34PfBeYDNJ+wDbDNxuQAyvBc6rP6sXgP9df1ZvA/5d0mHARba3GeQYNtd1JHBA/fx92/8k6X8C3wT+CNxVY50OXFrr3KXW+QJwse2z2rVjex4RETFihqUHwfZ9wB3AbyVdIGk/SW2TEUkC1qOcCKAMIVwMXAbsIWnVunyDmmg0t/Oi5KDJZsCewE7AyZJWAL4O7F97LZ6p7QC8AdihkRxUBwJza9m9gRmL2d3TgZtsf75+H1d7OLajJBPb1TimS1qjzfbbU07Gh0paE/gH4N9q26sASFod+CywU12+vqTt6vZb1BjfC3zC9rXAvcAHgKcXs13DF4Cv2KcW/4UAAAngSURBVH4HcBbwuZrIzKYkT/Obyg52DJG0EXAopZdnMrC/pDcCJwKft70jsEFzw5J6gH8B9qjHa+fakzRoOxERMTKGbQ6C7UNq9/+uwLHARyXtVFcfKWlfylX+KsA02/PrCeMAYJfas3Ab5eQxE8oJxXa/pPcBRwKrAzNtnzKg+Zvq3IUnJT0DrAv0236krr+BcpV8N3Cn7f4B228D3Fj343FJ8ySt0+Gu39FUx021jucl/RLYpLbZ8OdaZmGNcR1gIvC9uv4HwFspCc8bgGtKPsVa/PVke5vtFyQ9Wpc3G2y7W5rKbEvJ0z5L6bn5Q7udqvs/2DEE2Br4j8acEUm3AFvW/Wm09wOaho0ovQlzbTfafPdi2jl/YEx9fX3tQh3T5s6dm7hHUOIeWd0aN3Rv7MMZ97AkCPVEv4rtPqBP0jnAA5STFZQ5CDMkTQCuB35el29L6U24tJ7Q1qYkDDOBXwNbAffUCY2XNybItQmhuWekB+ivfzeMAxbVz81XyA2DlW9OJFZuu/N/rW9xbSJpA8o4/9Z1yOL+pngXNdXRqLPX9q7NDdX9X9i0qLm9QbdrU+b9tmctpswS92cx69vtT8MLtPZiLamdv5g4cVSnnyyVvr6+xD2CEvfI6ta4oXtjH2rcvb29HZcdrtscDwPOrYkClCvXFYAXzaqvJ6ULKd3QULqSP2V7K9tbUa6Ap9Qu9jOBMyStBiBpHLADMLdN+2+XtKKkdYE1KBMe+yU1EpQplPHwwdwJ7FjbWR9YZPuPwH8DEyStSBkWgHLyapdo3UmZh9AYIngj0DxEsi7wRE0O3ky5sh8H/IbS+wClix/AwERJr671nSTpdYuJvxFTJ9vdThmeQNJOdTJoy37ZfobFH8N7KMd9pTqc9Hd1Wbv9adT5FLCipNdJ6pF0JSVBGMrPKiIihsFwJQjnU5KB2yVdD1wBHGF7TpuyZwB7StqSMm/gosYK288DVwJ72Z5JmUx3s6SbgVuBWcDJbep8mDLR73rgM7YXUe6quEjSjZSr/4sXE//FlBPXDfVzY8b9DOCHlB6NX9RlfcCbJZ3ZXIHtnwG9kn4KXAscV/en4V7gudoVvz/wr5Tx+LOBj0i6jnIl/YLtPwOfBK6q5V8FPL6Y+G8CLqVMllzSdtOB99Y4TwRuq8tvBH5GSWQaBj2G9a6Fc2vbNwPfsP07ys/ny5KuofybeGFA+x+rsd4K/KQmYkP5WUVExDDo6e8f2Ovb3Qbel99tJG0GrG37FkkHAjva/vBox7W0JL0N+LPtn9fnW/S0mTMyZL29vf2TJk166QGOsJdLN+ZYkbhHVrfGDd0b+9IMMUyaNGngcHRbwzZJMZbas8C/SuqndPN/YJTjeanmAedJmkOZlJk7EiIiusBylyDYvmC0Y3gpbP+ecuvjcsH2PcBbRjuOiIgYmryLISIiIlokQYiIiIgWSRAiIiKiRRKEiIiIaJEEISIiIlokQYiIiIgWSRAiIiKiRRKEiIiIaJEEISIiIlokQYiIiIgWSRAiIiKiRRKEiIiIaJEEISIiIlokQYiIiIgWPf39/aMdQ8SQ9fb25h9uRMRSmDRpUk8n5ZIgRERERIsMMURERESLJAgRERHRYqXRDiBiKCSdCbwN6AeOtH3nKMSwOXAFcKbtGZLWB74FrAjMAg62PU/SQcAngUXAubbPk7QycAGwAfAC8AHbD0naEvha3a+f2/5obesfgffX5SfZvuolxP0lYDLl//2pwJ1jPW5Jr6jtrgesCnwBuG+sx90U/3jg/hr3T8Z63JKmApcAv6iL/hP40liPu9Z1EHAssBA4Afj5WI9b0mHAwU2LtgG267RNSWsBFwFrAc8B02w/LWln4JS6L1fZ/kKtY0i/P9ODEF1D0hRgE9tvBw4D/nkUYlgNOIfyy77h88BXbU8Gfg18sJY7AdgZmAr8g6R1gGnAH21vD3yRcqIGOIvyH3Y7YC1Ju0vaCDgA2B54N3CGpBWXMu4dgc3rsduttjfm4wbeA9xlewqwH3BGl8Td8Fng6fq5W+K+yfbU+ucT3RC3pFcBJzbVtVc3xG37vMaxrvF/c4htfhK4scY9E/hUrfqfgX0oycY7JW26NL8/kyBEN3kH8H0A233AKyWtOcIxzAP2AB5vWjYV+EH9/EPKL5+/A+60/Sfbc4BbKP9Z3wFcXsteB2wnaRywUVM236hjR+Dfbc+3/Qfgd8CmSxn3TylXHwB/BFbrhrhtf8/2l+rX9YFHuyFuAElvqtv/qC7qirjb6Ia4dwaus/2s7Vm2P9wlcTc7AfinIbbZHPcPgZ0lbQw8bfsR24uAq2q5If/+TIIQ3eQ1wB+avv+hLhsxthfWXyzNVrM9r35+AphAa6wty+t/3v667JnFlR2wfGnifsH28/XrYZRfGmM+7gZJt1K6Uj/ZRXF/BTiq6Xu3xL2ppB9I+pmkXbok7g2BV9S4b5b0ji6JGwBJbwEeoQyPDKXN5uVDKQsd/P5MghDdrKN7eUfYYDENZflQ6+iYpL0oCcLHX2KbIxq37W2BPYFvD6hvTMYt6RDgNtu/HWLdo328HwROonTR/z1wHi+eqzZW4+4BXgXsDRwKnE8X/Dtp8r8pcyBeSpvLYh9fJAlCdJPHeXHG+1rK5KPR9lydjAbwOkqcA2NtWV4nRvVQ9uFViys7YPlSkbQr8Blgd9t/6oa4JU2qk0CxfS/lZPXsWI8beBewl6T/oPzy/xxdcLxtP1aHdfpt/waYTemKHtNxA/8F3Fp7+H4DPEt3/DtpmArcSrmqH0qbzcuHUhY6+P2ZBCG6yY+BfQEkvRl43PazoxsSUMYs96mf9wGuBm4H3iJpbUmrU8Y5b6bsQ2MuwHuAG2wvAB6QtH1dvnet43rgXZLGSXot5T/6L5cmwDrb+XTg3bYbk+bGfNzADsDRdR/WA1bvhrht72/7LbbfBnyDchfDmI9b0kGSjqmfX0O5e+T8sR53bXcnSSvUCYtd8e8EoNbxXJ1fMNQ2m+PeB7ja9sPAmpI2lLQSZVLjj1mK3595kmJ0FUmnUU4ai4DDbd83wu1PoowtbwgsAB4DDqJ0D65KmTz0AdsLJO0L/CNlPPMc29+pM4+/AWxCmfB4qO1HJG0K/Cslab/d9lG1vU/U+vuBz9puvntiKHF/GJgO/Kpp8d/XWMZy3OMp3dzrA+Mp3d93AReO5bgH7MN04GHgmrEet6Q1KHM91gbGUY73PWM97lrXRyjDZwAnU27j7Ya4JwEn2969fu+4zZrkfJvS6/BH4H/Z/pOkHSgTHgEus/3lWseQfn8mQYiIiIgWGWKIiIiIFkkQIiIiokUShIiIiGiRBCEiIiJaJEGIiIiIFkkQIiIiokUShIiIiGiRBCEiIiJa/H+L2IDKftpfVgAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "PL5OCU6iqsIo"
      },
      "source": [
        "Todos os Óbitos por SARG em 2020"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "AdLNZUmEdDcG",
        "outputId": "415264b5-a5fe-4155-8da7-747985385b59"
      },
      "source": [
        "pd_n_obito_sarg_2020 = pd_n_sarg_2020.query('EVOLUCAO == \"Óbito\"')\n",
        "n_obito_sarg_2020 = pd_n_obito_sarg_2020.query('EVOLUCAO == \"Óbito\"')['EVOLUCAO'].value_counts()\n",
        "print(n_obito_sarg_2020)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Óbito    301804\n",
            "Name: EVOLUCAO, dtype: int64\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "80bq6VCoL9Zd"
      },
      "source": [
        "Diferença do número de óbitos por SARG em 2020 (incluindo COVID) em compração a 2019"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "cVpOKs8wLw46",
        "outputId": "812830d6-08ca-4480-c19a-4ae51888e75f"
      },
      "source": [
        "diff_sarg_2020_2019 = pd_n_sarg_2020.query('EVOLUCAO == \"Óbito\"')['EVOLUCAO'].count() - pd_n_sarg_2019.query('EVOLUCAO == \"Óbito\"')['EVOLUCAO'].count()\n",
        "print(\"Diferença do óbitos por SARG entre os anos de 2020-2019 \\nÓbitos:\",diff_sarg_2020_2019)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Diferença do óbitos por SARG entre os anos de 2020-2019 \n",
            "Óbitos: 296434\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "E-5koVZ_3pVR",
        "outputId": "2b52b244-1f35-4137-d3e8-957b327074ce"
      },
      "source": [
        "dict_result['Diferença de Óbitos 2020-2019'] = diff_sarg_2020_2019\n",
        "print(dict_result)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "{'Diferença de Óbitos 2020-2019': 296434}\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Fr7z8b74V-8W"
      },
      "source": [
        "Óbitos por COVID-19 em 2020"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "qOLBZwxwVXDP",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "9a36e650-822c-4ab0-ef8f-b58600637f9f"
      },
      "source": [
        "n_obito_covid_2020 = pd_n_obito_sarg_2020.query('CLASSI_FIN == \"SRAG por COVID-19\"')['CLASSI_FIN'].count()\n",
        "print(n_obito_covid_2020)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "219843\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "AvAOglkbxHSH"
      },
      "source": [
        "Óbitos por SRAG, sem confirmação de covid-19 em 2020:"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "xWQXl4fFw48F",
        "outputId": "9f58a0de-3a6d-4b06-d465-463dba12f775"
      },
      "source": [
        "n_obito_sarg_sem_covid_2020 = n_obito_sarg_2020 - n_obito_covid_2020\n",
        "print(\"Óbitos por SRAG, sem confirmação de covid-19 em 2020:\", n_obito_sarg_sem_covid_2020)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Óbitos por SRAG, sem confirmação de covid-19 em 2020: Óbito    81961\n",
            "Name: EVOLUCAO, dtype: int64\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "iWgrwE7IWOcf"
      },
      "source": [
        "Estimativa de Sub-notificação de COVID-19 em 2020.\n",
        "Diferença dos óbitos totais por SARG que **NÃO** foram identificados por **COVID-19**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "xgBby8lIZTTv",
        "outputId": "084b0798-fd39-4fa2-da73-6a36c33e5c61"
      },
      "source": [
        "print(diff_sarg_2020_2019 - n_obito_covid_2020)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "76591\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "aQ0LhSzbnXsB",
        "outputId": "990c5950-d4f7-4830-834f-6155a9214662"
      },
      "source": [
        "subnotificacao = ((diff_sarg_2020_2019 - n_obito_covid_2020) / (n_obito_covid_2020))*100\n",
        "print(\"Sub-notificação\", subnotificacao,\"%\")"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Sub-notificação 34.83895325300328 %\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Y_apbIGIfnAE"
      },
      "source": [
        "Função para calcular a Sub-Notificação"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_GhyurmZfNbA"
      },
      "source": [
        "def calculaSubnotificacao(covid):\n",
        "  return print(\"Sub notificação\", covid+(covid*(subnotificacao)/100))"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "3yRFDW7UcUTL",
        "outputId": "b584e1bb-4f8c-4cd6-82a5-bb7218c88b88"
      },
      "source": [
        "calculaSubnotificacao(n_obito_covid_2020)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Sub notificação 296434.0\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "r9rnWtyei6S8"
      },
      "source": [
        "### OpenDataSUS\n",
        "SRAG 2021 - Banco de Dados de Síndrome Respiratória Aguda Grave - incluindo dados da COVID-19\n",
        "Vigilância de Síndrome Respiratória Aguda Grave (SRAG)"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "-fZuxIJyjM5L",
        "outputId": "beb964ea-2651-46e8-a3f2-bcb511e79ab0"
      },
      "source": [
        "df_n_sarg_2021 = pd.read_csv('/content/drive/MyDrive/TADS - UFRN/2020.2/data_science/trab03/dataset/sarg_2021.csv', encoding='ISO-8859-1', delimiter=';', error_bad_lines=False)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/IPython/core/interactiveshell.py:2718: DtypeWarning: Columns (15,18,60,62,63,64,92,94,106,108,115,117,118,119,123,144) have mixed types.Specify dtype option on import or set low_memory=False.\n",
            "  interactivity=interactivity, compiler=compiler, result=result)\n"
          ],
          "name": "stderr"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "i9KcGh-L3uvv",
        "outputId": "520d9d45-ac06-4949-f22a-e0fac6efae67"
      },
      "source": [
        "df_n_sarg_2021.groupby('EVOLUCAO').size().sort_values()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "EVOLUCAO\n",
              "3.0      4906\n",
              "9.0     17116\n",
              "2.0    150248\n",
              "1.0    230198\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 90
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xpmWGux2sRmr"
      },
      "source": [
        "evolucao_caso = {1:'Cura', 2:'Óbito', \n",
        "                 3:'Óbito por outras causas', 9:'Ignorado'}\n",
        "classificacao_final = {1:'SRAG por influenza', 2:'SRAG por outro vírus respiratório',\n",
        "                       3:'SRAG por outro agente etiológico',\n",
        "                       4:'SRAG não especificado', 5:'SRAG por COVID-19'}"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "0_X7aZDSmoiD"
      },
      "source": [
        "df_n_sarg_2021.loc[(df_n_sarg_2021.EVOLUCAO.isnull()), 'EVOLUCAO'] = 9\n",
        "df_n_sarg_2021.loc[(df_n_sarg_2021.CLASSI_FIN.isnull()), 'CLASSI_FIN'] = 3\n",
        "df_n_sarg_2021['EVOLUCAO'] = df_n_sarg_2021['EVOLUCAO'].apply(lambda x: evolucao_caso[x])\n",
        "df_n_sarg_2021['CLASSI_FIN'] = df_n_sarg_2021['CLASSI_FIN'].apply(lambda x: classificacao_final[x])"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 830
        },
        "id": "P-2FPxQsmoiF",
        "outputId": "eb805caa-080f-4daf-de8a-5f03b5d5cc29"
      },
      "source": [
        "df_n_sarg_2021[:-1]"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>DT_NOTIFIC</th>\n",
              "      <th>SEM_NOT</th>\n",
              "      <th>DT_SIN_PRI</th>\n",
              "      <th>SEM_PRI</th>\n",
              "      <th>SG_UF_NOT</th>\n",
              "      <th>ID_REGIONA</th>\n",
              "      <th>CO_REGIONA</th>\n",
              "      <th>ID_MUNICIP</th>\n",
              "      <th>CO_MUN_NOT</th>\n",
              "      <th>ID_UNIDADE</th>\n",
              "      <th>CO_UNI_NOT</th>\n",
              "      <th>CS_SEXO</th>\n",
              "      <th>DT_NASC</th>\n",
              "      <th>NU_IDADE_N</th>\n",
              "      <th>TP_IDADE</th>\n",
              "      <th>COD_IDADE</th>\n",
              "      <th>CS_GESTANT</th>\n",
              "      <th>CS_RACA</th>\n",
              "      <th>CS_ETINIA</th>\n",
              "      <th>CS_ESCOL_N</th>\n",
              "      <th>ID_PAIS</th>\n",
              "      <th>CO_PAIS</th>\n",
              "      <th>SG_UF</th>\n",
              "      <th>ID_RG_RESI</th>\n",
              "      <th>CO_RG_RESI</th>\n",
              "      <th>ID_MN_RESI</th>\n",
              "      <th>CO_MUN_RES</th>\n",
              "      <th>CS_ZONA</th>\n",
              "      <th>SURTO_SG</th>\n",
              "      <th>NOSOCOMIAL</th>\n",
              "      <th>AVE_SUINO</th>\n",
              "      <th>FEBRE</th>\n",
              "      <th>TOSSE</th>\n",
              "      <th>GARGANTA</th>\n",
              "      <th>DISPNEIA</th>\n",
              "      <th>DESC_RESP</th>\n",
              "      <th>SATURACAO</th>\n",
              "      <th>DIARREIA</th>\n",
              "      <th>VOMITO</th>\n",
              "      <th>OUTRO_SIN</th>\n",
              "      <th>...</th>\n",
              "      <th>HISTO_VGM</th>\n",
              "      <th>PAIS_VGM</th>\n",
              "      <th>CO_PS_VGM</th>\n",
              "      <th>LO_PS_VGM</th>\n",
              "      <th>DT_VGM</th>\n",
              "      <th>DT_RT_VGM</th>\n",
              "      <th>PCR_SARS2</th>\n",
              "      <th>PAC_COCBO</th>\n",
              "      <th>PAC_DSCBO</th>\n",
              "      <th>OUT_ANIM</th>\n",
              "      <th>DOR_ABD</th>\n",
              "      <th>FADIGA</th>\n",
              "      <th>PERD_OLFT</th>\n",
              "      <th>PERD_PALA</th>\n",
              "      <th>TOMO_RES</th>\n",
              "      <th>TOMO_OUT</th>\n",
              "      <th>DT_TOMO</th>\n",
              "      <th>TP_TES_AN</th>\n",
              "      <th>DT_RES_AN</th>\n",
              "      <th>RES_AN</th>\n",
              "      <th>POS_AN_FLU</th>\n",
              "      <th>TP_FLU_AN</th>\n",
              "      <th>POS_AN_OUT</th>\n",
              "      <th>AN_SARS2</th>\n",
              "      <th>AN_VSR</th>\n",
              "      <th>AN_PARA1</th>\n",
              "      <th>AN_PARA2</th>\n",
              "      <th>AN_PARA3</th>\n",
              "      <th>AN_ADENO</th>\n",
              "      <th>AN_OUTRO</th>\n",
              "      <th>DS_AN_OUT</th>\n",
              "      <th>TP_AM_SOR</th>\n",
              "      <th>SOR_OUT</th>\n",
              "      <th>DT_CO_SOR</th>\n",
              "      <th>TP_SOR</th>\n",
              "      <th>OUT_SOR</th>\n",
              "      <th>DT_RES</th>\n",
              "      <th>RES_IGG</th>\n",
              "      <th>RES_IGM</th>\n",
              "      <th>RES_IGA</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>05/01/2021</td>\n",
              "      <td>1</td>\n",
              "      <td>04/01/2021</td>\n",
              "      <td>1</td>\n",
              "      <td>CE</td>\n",
              "      <td>11 CRES SOBRAL</td>\n",
              "      <td>1521.0</td>\n",
              "      <td>SOBRAL</td>\n",
              "      <td>231290</td>\n",
              "      <td>HOSPITAL REGIONAL NORTE</td>\n",
              "      <td>6848710</td>\n",
              "      <td>M</td>\n",
              "      <td>30/06/1956</td>\n",
              "      <td>64</td>\n",
              "      <td>3</td>\n",
              "      <td>3064</td>\n",
              "      <td>6</td>\n",
              "      <td>9</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1</td>\n",
              "      <td>CE</td>\n",
              "      <td>11 CRES SOBRAL</td>\n",
              "      <td>1521.0</td>\n",
              "      <td>SOBRAL</td>\n",
              "      <td>231290.0</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>0</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>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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</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>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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>14/04/2021</td>\n",
              "      <td>15</td>\n",
              "      <td>12/04/2021</td>\n",
              "      <td>15</td>\n",
              "      <td>BA</td>\n",
              "      <td>NUCLEO REGIONAL DE SAUDE LESTE</td>\n",
              "      <td>1380.0</td>\n",
              "      <td>SALVADOR</td>\n",
              "      <td>292740</td>\n",
              "      <td>HOSPITAL DA BAHIA</td>\n",
              "      <td>3827992</td>\n",
              "      <td>M</td>\n",
              "      <td>13/06/1933</td>\n",
              "      <td>87</td>\n",
              "      <td>3</td>\n",
              "      <td>3087</td>\n",
              "      <td>6</td>\n",
              "      <td>4</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9.0</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1</td>\n",
              "      <td>BA</td>\n",
              "      <td>NUCLEO REGIONAL DE SAUDE LESTE</td>\n",
              "      <td>1380.0</td>\n",
              "      <td>SALVADOR</td>\n",
              "      <td>292740.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.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>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</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>NaN</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>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>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>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>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>04/01/2021</td>\n",
              "      <td>1</td>\n",
              "      <td>03/01/2021</td>\n",
              "      <td>1</td>\n",
              "      <td>MS</td>\n",
              "      <td>EX ARS DE CAMPO GRANDE</td>\n",
              "      <td>1975.0</td>\n",
              "      <td>CAMPO GRANDE</td>\n",
              "      <td>500270</td>\n",
              "      <td>HOSPITAL SAO JULIAO CEDAMI CASA VOVO TULIA</td>\n",
              "      <td>9733</td>\n",
              "      <td>M</td>\n",
              "      <td>07/10/1924</td>\n",
              "      <td>96</td>\n",
              "      <td>3</td>\n",
              "      <td>3096</td>\n",
              "      <td>6</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1</td>\n",
              "      <td>MS</td>\n",
              "      <td>EX ARS DE CAMPO GRANDE</td>\n",
              "      <td>1975.0</td>\n",
              "      <td>CAMPO GRANDE</td>\n",
              "      <td>500270.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</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>...</td>\n",
              "      <td>0</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>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>04/01/2021</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>04/01/2021</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>05/01/2021</td>\n",
              "      <td>1</td>\n",
              "      <td>05/01/2021</td>\n",
              "      <td>1</td>\n",
              "      <td>MG</td>\n",
              "      <td>BELO HORIZONTE</td>\n",
              "      <td>1449.0</td>\n",
              "      <td>BELO HORIZONTE</td>\n",
              "      <td>310620</td>\n",
              "      <td>HOSPITAL SOFIA FELDMAN</td>\n",
              "      <td>26794</td>\n",
              "      <td>M</td>\n",
              "      <td>26/11/1988</td>\n",
              "      <td>32</td>\n",
              "      <td>3</td>\n",
              "      <td>3032</td>\n",
              "      <td>6</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1</td>\n",
              "      <td>MG</td>\n",
              "      <td>BELO HORIZONTE</td>\n",
              "      <td>1449.0</td>\n",
              "      <td>BETIM</td>\n",
              "      <td>310670.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.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>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>...</td>\n",
              "      <td>2</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>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</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>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>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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>06/01/2021</td>\n",
              "      <td>1</td>\n",
              "      <td>04/01/2021</td>\n",
              "      <td>1</td>\n",
              "      <td>PR</td>\n",
              "      <td>02RS METROPOLITANA</td>\n",
              "      <td>1356.0</td>\n",
              "      <td>CURITIBA</td>\n",
              "      <td>410690</td>\n",
              "      <td>HOSPITAL PILAR</td>\n",
              "      <td>3000885</td>\n",
              "      <td>M</td>\n",
              "      <td>19/10/1928</td>\n",
              "      <td>92</td>\n",
              "      <td>3</td>\n",
              "      <td>3092</td>\n",
              "      <td>6</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9.0</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1</td>\n",
              "      <td>PR</td>\n",
              "      <td>02RS METROPOLITANA</td>\n",
              "      <td>1356.0</td>\n",
              "      <td>CURITIBA</td>\n",
              "      <td>410690.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</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>...</td>\n",
              "      <td>2</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>NaN</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>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>05/01/2021</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.0</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>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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>605847</th>\n",
              "      <td>17/04/2021</td>\n",
              "      <td>15</td>\n",
              "      <td>03/04/2021</td>\n",
              "      <td>13</td>\n",
              "      <td>RO</td>\n",
              "      <td>VI DRS PORTO VELHO</td>\n",
              "      <td>1483.0</td>\n",
              "      <td>PORTO VELHO</td>\n",
              "      <td>110020</td>\n",
              "      <td>HOSPITAL DE CAMPANHA DE RONDONIA</td>\n",
              "      <td>213837</td>\n",
              "      <td>F</td>\n",
              "      <td>01/03/1970</td>\n",
              "      <td>51</td>\n",
              "      <td>3</td>\n",
              "      <td>3051</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.0</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1</td>\n",
              "      <td>RO</td>\n",
              "      <td>VI DRS PORTO VELHO</td>\n",
              "      <td>1483.0</td>\n",
              "      <td>PORTO VELHO</td>\n",
              "      <td>110020.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</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>0</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>142105</td>\n",
              "      <td>GERENTE ADMINISTRATIVO</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>05/04/2021</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</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>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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>605848</th>\n",
              "      <td>04/04/2021</td>\n",
              "      <td>14</td>\n",
              "      <td>01/04/2021</td>\n",
              "      <td>13</td>\n",
              "      <td>RJ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>SAO GONCALO</td>\n",
              "      <td>330490</td>\n",
              "      <td>HOSPITAL FRANCISCANO</td>\n",
              "      <td>113891</td>\n",
              "      <td>M</td>\n",
              "      <td>01/04/1962</td>\n",
              "      <td>59</td>\n",
              "      <td>3</td>\n",
              "      <td>3059</td>\n",
              "      <td>6</td>\n",
              "      <td>4</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1</td>\n",
              "      <td>RJ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>SAO GONCALO</td>\n",
              "      <td>330490.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>0</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>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>9.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</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>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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>605849</th>\n",
              "      <td>16/04/2021</td>\n",
              "      <td>15</td>\n",
              "      <td>14/04/2021</td>\n",
              "      <td>15</td>\n",
              "      <td>MS</td>\n",
              "      <td>EX NRS DE CORUMBA</td>\n",
              "      <td>6256.0</td>\n",
              "      <td>CORUMBA</td>\n",
              "      <td>500320</td>\n",
              "      <td>PRONTO SOCORRO MUNICIPAL DE CORUMBA</td>\n",
              "      <td>2558815</td>\n",
              "      <td>M</td>\n",
              "      <td>30/03/1989</td>\n",
              "      <td>32</td>\n",
              "      <td>3</td>\n",
              "      <td>3032</td>\n",
              "      <td>6</td>\n",
              "      <td>4</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1</td>\n",
              "      <td>MS</td>\n",
              "      <td>EX NRS DE CORUMBA</td>\n",
              "      <td>6256.0</td>\n",
              "      <td>CORUMBA</td>\n",
              "      <td>500320.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</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>0</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>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>16/04/2021</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</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>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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>605850</th>\n",
              "      <td>17/04/2021</td>\n",
              "      <td>15</td>\n",
              "      <td>05/04/2021</td>\n",
              "      <td>14</td>\n",
              "      <td>SP</td>\n",
              "      <td>GVE I CAPITAL</td>\n",
              "      <td>1331.0</td>\n",
              "      <td>SAO PAULO</td>\n",
              "      <td>355030</td>\n",
              "      <td>UNIDADE DE PRONTO ATENDIMENTO CAMPO LIMPO DR F...</td>\n",
              "      <td>7479387</td>\n",
              "      <td>F</td>\n",
              "      <td>26/03/1968</td>\n",
              "      <td>53</td>\n",
              "      <td>3</td>\n",
              "      <td>3053</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1</td>\n",
              "      <td>SP</td>\n",
              "      <td>GVE I CAPITAL</td>\n",
              "      <td>1331.0</td>\n",
              "      <td>SAO PAULO</td>\n",
              "      <td>355030.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</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>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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</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>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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>605851</th>\n",
              "      <td>17/04/2021</td>\n",
              "      <td>15</td>\n",
              "      <td>10/04/2021</td>\n",
              "      <td>14</td>\n",
              "      <td>RS</td>\n",
              "      <td>003 CRS</td>\n",
              "      <td>1593.0</td>\n",
              "      <td>PELOTAS</td>\n",
              "      <td>431440</td>\n",
              "      <td>SOCIEDADE PORTUGUESA DE BENEFICENCIA</td>\n",
              "      <td>2252295</td>\n",
              "      <td>M</td>\n",
              "      <td>09/09/1958</td>\n",
              "      <td>62</td>\n",
              "      <td>3</td>\n",
              "      <td>3062</td>\n",
              "      <td>6</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>1</td>\n",
              "      <td>RS</td>\n",
              "      <td>003 CRS</td>\n",
              "      <td>1593.0</td>\n",
              "      <td>PELOTAS</td>\n",
              "      <td>431440.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</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>0</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>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>16/04/2021</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</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>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",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>605852 rows × 154 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        DT_NOTIFIC  SEM_NOT  DT_SIN_PRI  ...  RES_IGG RES_IGM RES_IGA\n",
              "0       05/01/2021        1  04/01/2021  ...      NaN     NaN     NaN\n",
              "1       14/04/2021       15  12/04/2021  ...      NaN     NaN     NaN\n",
              "2       04/01/2021        1  03/01/2021  ...      2.0     2.0     NaN\n",
              "3       05/01/2021        1  05/01/2021  ...      NaN     NaN     NaN\n",
              "4       06/01/2021        1  04/01/2021  ...      NaN     NaN     NaN\n",
              "...            ...      ...         ...  ...      ...     ...     ...\n",
              "605847  17/04/2021       15  03/04/2021  ...      NaN     NaN     NaN\n",
              "605848  04/04/2021       14  01/04/2021  ...      NaN     NaN     NaN\n",
              "605849  16/04/2021       15  14/04/2021  ...      NaN     NaN     NaN\n",
              "605850  17/04/2021       15  05/04/2021  ...      NaN     NaN     NaN\n",
              "605851  17/04/2021       15  10/04/2021  ...      NaN     NaN     NaN\n",
              "\n",
              "[605852 rows x 154 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 93
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "y-40h8NWAhcJ"
      },
      "source": [
        "Evolução dos Casos identificados por SARG"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Bq_j504Zs_Qc",
        "outputId": "e64a2958-66af-4767-bf1f-518501d3fa4c"
      },
      "source": [
        "# Verifica se tem NaN na target \"EVOLUCAO\"\n",
        "hasNan = df_n_sarg_2021['EVOLUCAO'].isnull().values.any()\n",
        "print(hasNan)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "False\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "1M-KiIcys_Ql",
        "outputId": "49dced36-8b3c-4c43-a8e0-b61f06fee4ad"
      },
      "source": [
        "# Verifica se tem NaN na target \"CLASSI_FIN\"\n",
        "hasNan = df_n_sarg_2021['CLASSI_FIN'].isnull().values.any()\n",
        "print(hasNan)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "False\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "v7dglUuDyIVV"
      },
      "source": [
        "Soma do óbitos por SRAG no ano de 2021, incluindo COVID-19"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "GmOYga3M4KeL",
        "outputId": "56012beb-cfa1-4bf8-f68d-c7cabb052ec8"
      },
      "source": [
        "df_n_sarg_2021.groupby('EVOLUCAO').size().sort_values()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "EVOLUCAO\n",
              "Óbito por outras causas      4906\n",
              "Óbito                      150248\n",
              "Ignorado                   220501\n",
              "Cura                       230198\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 96
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 279
        },
        "id": "QMSEVMmVt2we",
        "outputId": "023ed14e-bc51-4383-b5a6-0745bdf277d4"
      },
      "source": [
        "df_n_sarg_2021.groupby('EVOLUCAO').size().sort_values().plot(kind='barh')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7fbb29a3aa90>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 97
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAdgAAAD1CAYAAADznOTFAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAWq0lEQVR4nO3de5RdZXnH8e8QE25yqYBGWxF1wWO4SGFiiwUkoShoQLQBpXjBYIvFgiCCQlUUtDRFiyiwFJdWKhZRoVAQpCIKgrYQTkM1OHm42LgQjFARJVwCJNM/9h44zJyZw5B5z5kz8/2slZVz3n179jtnzW/23u/Zu29wcBBJkjSx1ut2AZIkTUUGrCRJBRiwkiQVYMBKklSAAStJUgEGrCRJBTyn2wVocmg0Gn5fS5Kehf7+/r5W7QasntTf39/tEiaVgYEB5syZ0+0yJh37ZST7ZKTp0ieNRmPUaZ4iliSpAANWkqQCDFhJkgowYCVJKsCAlSSpAANWkqQCDFhJkgowYCVJKsCAlSSpAANWkqQCDFhJkgrwXsR60jYnXtHtEiahn3e7gEnKfhnJPhlp8vfJisULiq3bI1hJkgowYCVJKsCAlSSpAANWkqQCDFhJkgowYCVJKsCAlSSpAANWkqQCDFhJkgrwTk49JCK2Bc4EtgJmAD8Gjs/M1V0tTJI0gkewPSIiZgAXA6dn5p8Ac+tJJ3evKknSaDyC7R2vBZZn5nUAmTkYER8Eto6ImzNzLkBE3AwcBHwceAzYAlgEXABsDGwEHJ2ZN3V+FyRp+vAItne8AriluSEzHwHGOj18f2YuBGYDX8rM+cBJwIeKVSlJAjyC7SWDVNddx2PoKPXXwEcj4nhgfeChiSxMknrVwMBAsXUbsL1jOXBUc0NErA+8ZNh8M5teP1b/fyxwd2a+IyLmAp8uVqUk9ZA5c+as0/KNRmPUaZ4i7h1XAy+JiAMAImI94B+prre+ICL6ImI28PIWy24J3Fm/fjMwqwP1StK0ZsD2iMxcC+wLHFEPZLoB+B1wDPA9YAnw98DSFot/FTguIr4L3AjMjohFHSlckqYpTxH3kMz8FXBAi0mtwvJdTcstAZrPg1w2sZVJkobzCFaSpAIMWEmSCjBgJUkqwICVJKkAA1aSpAIMWEmSCjBgJUkqwICVJKkAA1aSpAK8k5OetGLxgm6XMKkMDAys843ApyL7ZST7ZCT7xCNYSZKKMGAlSSrAgJUkqQADVpKkAgxYSZIKMGAlSSrAgJUkqQADVpKkAgxYSZIKMGAlSSrAgJUkqQADVpKkAgxYSZIKMGAlSSrAgJUkqQADVpKkAgxYSZIKMGAlSSrAgJUkqQADVpKkAgxYSZIKMGAlSSrAgJUkqQADVpKkAgxYSZIKMGAlSSrgOd0uQJPHNide0e0SJqGfd7uAScp+Gck+GamzfbJi8YKObq8dj2AlSSrAgJUkqQADVpKkAgxYSZIKMGAlSSrAgJUkqQADVpKkAgxYSZIKMGAlSSrAgO2AiNgmIm7uwnafGxErOr1dSZIBK0lSEd6LuIMi4pXAvwAPADcDWwEfr9vuBHYGlmbmX0XEHwH/DMwC1gLvBgaBrwGrgLOBzYCjgTXArZl5RERsClwMbADc0LTtecBpwOPAL4HDM3N12T2WpOnLgO2sjwGnZuYlEfFN4OG6vR94K3Av8MuI2Bw4FfhyZn4jIg6iCuKPAbsAW2fmbyLiCGC/zHwgIn4YETsBewLLMvP9EfFW4C/rbXwBeG1m3hURZwOHAl/pyF5LUgcMDAx0u4SnMWA7aw7wo/r1ZcA+9es7MnMlQETcQ3VkOhc4qZ7+A+Dk+vWdmfmb+vX9wL9HxNC6twC2B66rp19br/N5wGBm3tW0vr0wYCVNIXPmzOn4NhuNxqjTnvE12Ih4YUQ8f0Iqmr76qE73QnW6d8gTLeYbrP+Hp04TAzwGEBGzgHOAt2bmXsCNLbYx9PNtXtfw9UmSChgzYCOiLyJOjYhfApcDV0XE/0bEhyPCAVLjdyfVkSnA69vMuwSYX7/ei+qabbNNgCcyc2VEvLhe7ywgm7YxHyAzfwsMRsTWY6xPkjSB2oXkR4BNge0yc25m7grsRDU455Oli5uCPgl8OiL+g+p665ox5j0ZeGdEfB94F9X11yfVp4mvjogl9bTTgc8AXwd2i4hrgOCpI+W/Bi6IiGuBmcCFE7RPkqQW+gYHB0edGBGNzOwf7zS1FhG7AQ9n5k8i4iSgLzNP63ZdAI1GY3Dht1Z2uwxJetZWLF7Q8W02Gg36+/v7Wk1rN8jpsTGmPf7sS5q2VgNfjohHqEYQH9rleiRJhbQL2IcjYsfMXNbcGBG7Un0XU+OQmUuBV3W7DklSee0C9oPAxRFxCbAUmEEVEAuANxSuTZKknjXmIKfMbFDdBOF/gd2oRqcOALtk5h3ly5MkqTe1vdFEZq4Czh16X9+K7y0RcUhm7luyOEmSetUzupNTRGwIvJFqUM7ewDeATxSsS5KknjZmwEbEG4FDqG7pdy1wHvDSzPyr4pVJktTD2t1o4t+APwYOycy3ZOYljLytnyRJGqbdKeKtqY5gT6+vvV5I9Rg0TUHd+JL2ZDYwMNCVm4dPdvbLSPbJSPZJ+1HE92TmGZk5F9if6gbxMyJiSUS8tyMVSpLUg57x4+oy8zaqZ5J+PCLm4l2IJEkaVbun6cyKiE9ExMymth2AAzLzuOLVSZLUo9oNcvoU1dN0mue7Hdg0Ik5uvYgkSWoXsH+Wmcdk5uqhhsx8DPgA8LqilUmS1MPaBWzL55Vm5lqqh3tLkqQW2gXs/0XEHsMbI2IB4MNDJUkaRbtRxMdSPU1nALiF6mk6f0r1/VjvQyxJ0ijafQ/2DmAX4CvAI8CDwNlUT9P5dfnyJEnqTe3uRbx9/fKu+t8g8KvMHCxdmCRJvazdKeJzWrRtFREPAG/PzBUTX5IkSb1vzIDNzPmt2uuBT58FDixRlCRJva7dKOKWMvMGYJMJrkWSpCnjWQVs/QD29Se4FkmSpox2g5xaPTFnc+BNwBlFKpIkaQpoN8hpqxZt9wGLMvPWAvVIkjQltBvkdMpo0yJi/8z89sSXJElS73tW12BrPq5OkqRRrEvA9k1YFZIkTTHrErDezUmSpFG0G0V8H1WQNh+tDr3ftGBdkiT1tHaDnFqNIpYkSW20+5oOEbE5cDgQVA9g/xlwXmauKlybJEk9a8xrsBGxA3AjsBHwbeAq4HnAjRHRX748SZJ6U7sj2M8BB2bm8qa2yyLim1RP2vnzYpVJktTD2o0i3nBYuAJQt21UpiRJknpfuyPYDVo1RsR6GLBTzjYnXtHtEiahn3e7gEnKfmn2ncNe1u0SNAm1O4L9TkR8MSKefDRdRGwBfAX4etHKJEnqYe2OYD8KfBD4aUQ8AswAZgLnZOanSxcnSVKvahewO2fmYmBxRGwKkJm/L1+WJEm9rV3AnhMRmwEXAhdk5p0dqEmSpJ435jXYzPwzYD/gIeBrEfFfEXFMRLygI9VJktSj2t7sPzPvyswzMvPVwFuorsN+PSK+W7w6SZJ61DN+mk5EPAfYCdgZ2JLqlomSJKmFdk/TmQHsAxwC7AX8ADgfWJSZa8uXpyERsR/wXuDgzFzd7XokSWNrN8jp98CVVN95/ZvmX+wRMTczby5ZnJ5mC+DNmbmm24VIktprF7CZmQcPvYmIz2fmkfXb04G9i1UmACLi5cCZwGzgAxHxI6rvJn8euCgzv90072zglMx8T0S8Bliemfd2o25Jmu7aXYN9YNj7VzS97kNF1bekvBg4MzNflZm7AiuAL7aaPzNXZuZ76reHA8/vSKGSpBHaPg92DIMTVoVG8zrgtsy8pqntDCCBO4ADIuJYYCtgEXA/cBFwEvAmYIeIWAjsBhwHPAE0MvOYzu2CJE1Pz3gUcc1Q7axXAEubGzJzEFhGdcvKwczcB/hw/W9onquBW3gqdE8D9snMPYCXRcT8zpQvSdNXuyPYuRFxU/26D4j6fR+wXdHKBNUfNDNatPcBa6hGdQPcBCweZR3bAbdn5qr6/bXALk3LSlpHjz76KAMDA90uY1KxT9oH7E4dqUKjWQ4c2dwQEX3ADvW05jMKo51dGOTp18tnAY9MYI3StLfBBhswZ86cbpcxqQwMDEyLPmk0GqNOGzNgM/MXE16NxuNq4PSIeENmXlm3vR+4nurIdk/gm1TXWIf/qbiW6ud7G7BtRGySmQ9SfZ/5k50oXpKms/Feg1UH1Tfz2Bc4IiJujoj/prou+76heSLicuBU4BPDFr+OasDTNsAJwFURcT2wNDNv6ED5kjStrcsoYnVAZq6kGhE83LtGWWRuvdwpwCl1263Av014cZKkUXkEK0lSAQasJEkFGLCSJBVgwEqSVIABK0lSAQasJEkFGLCSJBVgwEqSVIA3mtCTVixe0O0SJpXpci/V8bJfRpruN7VXax7BSpJUgAErSVIBBqwkSQUYsJIkFWDASpJUgAErSVIBBqwkSQUYsJIkFWDASpJUgAErSVIBBqwkSQUYsJIkFWDASpJUgAErSVIBBqwkSQUYsJIkFWDASpJUgAErSVIBBqwkSQUYsJIkFWDASpJUgAErSVIBBqwkSQUYsJIkFWDASpJUgAErSVIBBqwkSQU8p9sFaPLY5sQrWravWLygw5VIUu/zCFaSpAIMWEmSCjBgJUkqwICVJKkAA1aSpAIMWEmSCjBgJUkqoPj3YCNiP+C9wMGZubr09iRJmgw6caOJLYA3Z+aaDmxLkqRJodgp4oh4eURcDhwLLImIsyJiw3raeRGx/7D5Z0fEufXr10TE80vVti4i4pURsV2365AkTW5FAjYi1gMuBs7MzFdl5q7ACuCLoy2TmSsz8z3128OBSRmwwF8ABqwkaUylThG/DrgtM69pajsDyKYj0wMi4lhgK2ARcD9wEXAS8CZgh4hYCOwGHAc8ATQy85jmDUXEtcASYC6wIfDWzPxFRJwO7E61j2dn5vn1vMsAMvOopnXsBJwDrAUeBA4DXgkclZkH1fP8HzAf+Bvgvoi4F/hX4ErgXuDb9Toer9dzcL2urwEvBNYHPpaZVzVtdybwL8BLgEeBd9bLXABsDGwEHJ2ZN0XECmDHzFwVEZ+u9+P79frX1Pv5duC3oyz/Iao/DtYCl2fmaS1+bpKkCVIqYF8BLG1uyMzBiFgGbFs3DWbmPvWp4g8DH6jnuzoibgGOogrd04A/roPl8oiYn5k/GLa932Tm/Ig4Gjg2Ii6hCqPdI2Jj4CcRcWk977LM/MKw5T8LnJCZN0bE8cAxwPBtkJk/jYirgIvq0JoJfCczr4qI11KF2dKIOBV4G/AjYMvMfE1EbA68YdgqDwNWZuahEXEI8EbgGuBLmXlpROwNfAhYOEo/HwRcnZmfiIhdeSrIWy1/fD19DdUfCc/YwMDAeGafMh599NFpu+9jsV9Gsk9Gsk/KBewgMKNFex/VL3h4KsBuAhaPsp7tgNszc1X9/lpgF0aG3/fq//8TeD3V0ex1AJn5UET8jKeC/aYW29k+M29squtjLbYxmqH1/Rr4x4jYCHgR1dHtcmCTiDgfuAS4cNiyu1IFKpl5IUBEbAZ8tA769YGHxtj2d4FL6vC+KDP/c4zlL6Lqpwvq2p6xOXPmjGf2KWNgYGDa7vtY7JeR7JORpkufNBqNUaeVGuS0nCrknhQRfcAOwG1102DT5ObXDGvva3o/i+oU53BD+9FXLzPWco+1qX1o3uE1zRxl/qH1fRb4bGbuBZwLkJkPU53iPpfq6PVLw5Zdw8ifwbHA3Zm5B3BkU3tzPTPr9S8DdgauB/4hIt452vKZeSTVkets4NqI8FGFklRQqYC9GnhpRDSfEn0/cH1m3l+/37P+fzdg+HmEtVRH17cB20bEJnX7XsDNLbY3tK5XAz+juiY7DyAingu8HLh9jHqXRcSrh23j91SnVImIVwJDNQzVNtyWwJ0RsT5VmM6qT9sempk3UIXd9sOWWQLsXW9j/4j4u6H11NPfTBX4DNUTETOo+oz6tPKOmXkp8BGqP2pGLB8Rm0XEyZm5PDNPpTr1vukY/SFJWkdFjmIyc21E7At8ob4euR5VaL2veb76azwvBt4xbBXXUZ3SPBA4AbgqItYCN9RhNdzW9bXRzYGFmXl3RDQi4odUR3sn1qeKRyv5fcA5ETFINUhoEbAKeCgifkx1LXVFPe/1wOci4sFh6zgLuJQq3M4Czgb+A3h7RLyH6mj1U8OWuRDYJyKuoxocdRjV6eWvRsTB9Tr+MiIW1a8vBxK4tV7+Nqo+XlWv/33Ac4cvTzW4aauIuKnerx83/aEjSSqgb3BwtLOzvaEeGXxUfbpUz1Kj0Rhc+K2VLaetWLygw9VMDtPlGtJ42S8j2ScjTZc+aTQa9Pf397Wa5r2IJUkqoOcHumTmvG7XIEnScB7BSpJUgAErSVIBBqwkSQUYsJIkFWDASpJUgAErSVIBPf81HU2c6XpDCUkqwSNYSZIKMGAlSSrAgJUkqQADVpKkAgxYSZIKMGAlSSrAgJUkqQADVpKkAgxYSZIKMGAlSSrAgJUkqQADVpKkAvoGBwe7XYMmgUaj4QdBkp6F/v7+vlbtBqwkSQV4iliSpAIMWEmSCvCB6yIiPgPsBgwCx2Tmki6XNOEiYh7wLeDWuumnwOnA+cAM4FfAOzJzdUS8DTgWWAt8MTO/HBEzgfOAlwBrgEWZ+fOI2Bn4PFXf/SQzj+zcXj17EbEj8O/AZzLz7Ih4MYX6IiJOAA6u20/JzCs7ua/PVIs+OQ/oB35Tz/KpzLximvXJ6cCeVFnxD8ASpvnnZDw8gp3mImIvYNvMfDXwbuBzXS6ppOsyc17972jgVOCczNwTuAM4PCI2Bk4G9gHmAe+PiOcBhwIPZOYewN9T/bIBOJPqj5Ldgc0i4vWd3aXxq/fxLOCapuYifRERLwUOAfYA9gfOiIgZpfdxvEbpE4CTmj4zV0yzPpkP7Fj/btiPal+m9edkvAxY/TlwKUBmDgB/EBGbdrekjpkHXFa/vpzqF8SfAksy83eZ+QjwI2B3qn66pJ73e8DuETELeGnTEf/QOia71cAbgHua2uZRpi/mA9/JzMcy8z7gF8D2pXZsHbTqk1amU5/8kOqIEuABYGP8nIyLAavZwH1N7++r26ai7SPisoi4ISJeC2ycmavrafcCL2Rkf4xoz8y1VKexZgO/bTHvpJaZT9S/CJuV6ovR1jGpjNInAEdFxPcj4sKI2JLp1SdrMvOh+u27gSuZ5p+T8TJgNVzL73NNAbcDpwAHAocBX+bpYxBG2+/xtE+VvivZF73UR+cDJ2bm3sAtwMdbzDPl+yQiDqQK2KOGTfJz0oYBq3t4+hHri6gGL0wpmXl3Zn4jMwcz805gJdXp8A3rWf6Qqi+G98eI9nrwRh9VP23RYt5etKpQX4y2jkkvM6/JzFvqt5cBOzHN+iQi9gU+DLw+M3+Hn5NxMWD1XeAggIjYFbgnMx/sbkkTLyLeFhHH169nAy8AvgIsrGdZCFwF3Ai8KiI2j4jnUl1Lup6qn4auRx0A/CAzHweWR8Qedftf1OvoRd+jTF98H1gQEbMi4kVUvzh/1okdWlcRcXFEvKx+Ow9YxjTqk4jYDPgUsH9m3l83+zkZB+/kJCJiMfAaqiH2f5uZ/9PlkiZcRGwCXABsDsyiOl28FPgqsAHVoIpFmfl4RBwEnEB1zeiszPzXekTjl4BtqQbEvCsz74qI7YFzqf5YvTEzj+vwro1bRPQD/wRsAzwO3A28jeorFRPeFxFxdL3+QeAjmTl8pG7XjdInZwEnAg8Dq6j65N5p1CdHUJ0Wv62p+TCq/ZyWn5PxMmAlSSrAU8SSJBVgwEqSVIABK0lSAQasJEkFGLCSJBVgwEqSVIABK0lSAQasJEkF/D/MTOE5sRGFMAAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "w4UuFPbLzByn"
      },
      "source": [
        "Todos os óbitos por SARG em 2021"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "D_bXxpm3ndll",
        "outputId": "a91fb7a5-1638-4731-8320-abb963610682"
      },
      "source": [
        "df_n_obito_sarg_2021 = df_n_sarg_2021.query('EVOLUCAO == \"Óbito\"')\n",
        "n_obito_sarg_2021 = df_n_obito_sarg_2021.query('EVOLUCAO == \"Óbito\"')['EVOLUCAO'].value_counts()\n",
        "print(\"SARG EM 2021\", n_obito_sarg_2021)\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "SARG EM 2021 Óbito    150248\n",
            "Name: EVOLUCAO, dtype: int64\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Q_hMCeH8zqRy"
      },
      "source": [
        "Óbitos por SRAG, sem confirmação de covid-19 em 2021:"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "CxZmJzIOzqRz",
        "outputId": "eca8ea7b-67b7-4128-8213-e02742de6258"
      },
      "source": [
        "n_obito_sarg_sem_covid_2021 = n_obito_sarg_2021 - n_obito_covid_2021\n",
        "print(\"Óbitos por SRAG, sem confirmação de covid-19 em 2021:\", n_obito_sarg_sem_covid_2021)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Óbitos por SRAG, sem confirmação de covid-19 em 2021: Óbito    16034\n",
            "Name: EVOLUCAO, dtype: int64\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "_iloLKZ4zqRx"
      },
      "source": [
        "Óbitos por SARG com confirmação por COVID-19 em 2021"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ylJITNxA1QF0",
        "outputId": "8b79133f-6966-46a5-9901-50786c624e1c"
      },
      "source": [
        "n_obito_covid_2021 = df_n_obito_sarg_2021.query('CLASSI_FIN == \"SRAG por COVID-19\"')['CLASSI_FIN'].count()\n",
        "print(\"SARG com confirmação por COVID-19 em 2021:\", n_obito_covid_2021)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "SARG com confirmação por COVID-19 em 2021: 134214\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "FKIJksKRgXuQ"
      },
      "source": [
        "Cálcula Sub-notificação COVID-19 ano 2021"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "3Fqqc0oyAYsi",
        "outputId": "e9fe2028-edf0-4711-fcc6-464f865cab06"
      },
      "source": [
        "calculaSubnotificacao(n_obito_covid_2021)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "180972.75271898584"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 188
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "PqzN9nYcyz6n"
      },
      "source": [
        "### Cálculo da subnotificação de óbitos por covid-19\n",
        "\n",
        "Exemplificando, com os valores divulgados pelo OpenDataSUS:\n",
        "* 2019 06/01/2019 até 29/10/2019.\n",
        "* 2020 dia 29/10/2020.\n",
        "* 2021 dia 10/04/2021. \n",
        "\n",
        "Obtém-se:\n",
        "\n",
        "* Óbitos por SRAG em 2019: 5.370\n",
        "* Óbitos por SRAG em 2020: 301.804\n",
        "* Óbitos por SRAG, com confirmação de covid-19, em 2020: 219.843\n",
        "* Óbitos por SRAG, sem confirmação de covid-19 em 2020: 81.961\n",
        "\n",
        "\n",
        "Tomando como base os 5.370 óbitos por SRAG em 2019, tem-se, em 2020, 76.591 óbitos a mais que 2019 por SRAG que não foram confirmados por covid-19. Portanto, esses óbitos poderão ser sim óbitos por covid-19 que não foram notificados devidamente.\n"
      ]
    }
  ]
}