notebooks/Análise_Exploratória_Dados_Hospitalares.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Análise Exploratória - Dados Hospitalares",
      "provenance": [],
      "collapsed_sections": [
        "esN1cFxUbOZz",
        "TtGEgvz2ZhiB"
      ]
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "xRvLs2L0WUQy"
      },
      "source": [
        "# Informações Sobre os Dados"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "esN1cFxUbOZz"
      },
      "source": [
        "# Instalando Bibliotecas Adicionais"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3uhCuTiWbRtE"
      },
      "source": [
        "!pip install https://github.com/pandas-profiling/pandas-profiling/archive/master.zip &> /dev/null"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "TtGEgvz2ZhiB"
      },
      "source": [
        "# Importando Bibliotecas"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Jjcgkc1KZk2d"
      },
      "source": [
        "import altair as alt\n",
        "import pandas as pd\n",
        "from ipywidgets import widgets\n",
        "from pandas_profiling import ProfileReport\n",
        "from tabulate import tabulate"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "T-tdOfYObbqO"
      },
      "source": [
        "# Carregando os Dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 407
        },
        "id": "OqkRXctgbhi0",
        "outputId": "303dcec6-a15e-48c3-9154-6829f4f51ce9"
      },
      "source": [
        "df_hosp = pd.read_csv(\n",
        "    f'https://raw.githubusercontent.com/george-gca/MO826_IA368_CF044/main/data/processed/dengue_internacoes.csv')\n",
        "\n",
        "df_hosp"
      ],
      "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>Municipio</th>\n",
              "      <th>CodIbge</th>\n",
              "      <th>Estado</th>\n",
              "      <th>2008</th>\n",
              "      <th>2009</th>\n",
              "      <th>2010</th>\n",
              "      <th>2011</th>\n",
              "      <th>2012</th>\n",
              "      <th>2013</th>\n",
              "      <th>2014</th>\n",
              "      <th>2015</th>\n",
              "      <th>2016</th>\n",
              "      <th>2017</th>\n",
              "      <th>2018</th>\n",
              "      <th>2019</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Acrelândia</td>\n",
              "      <td>120001</td>\n",
              "      <td>AC</td>\n",
              "      <td>0.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>154.0</td>\n",
              "      <td>72.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Assis Brasil</td>\n",
              "      <td>120005</td>\n",
              "      <td>AC</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Brasiléia</td>\n",
              "      <td>120010</td>\n",
              "      <td>AC</td>\n",
              "      <td>1.0</td>\n",
              "      <td>63.0</td>\n",
              "      <td>27.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>41.0</td>\n",
              "      <td>25.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>19.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>16.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Bujari</td>\n",
              "      <td>120013</td>\n",
              "      <td>AC</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Capixaba</td>\n",
              "      <td>120017</td>\n",
              "      <td>AC</td>\n",
              "      <td>3.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>785</th>\n",
              "      <td>Tocantínia</td>\n",
              "      <td>172110</td>\n",
              "      <td>TO</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>8.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>786</th>\n",
              "      <td>Tupirama</td>\n",
              "      <td>172125</td>\n",
              "      <td>TO</td>\n",
              "      <td>3.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>787</th>\n",
              "      <td>Tupiratins</td>\n",
              "      <td>172130</td>\n",
              "      <td>TO</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>788</th>\n",
              "      <td>Wanderlândia</td>\n",
              "      <td>172208</td>\n",
              "      <td>TO</td>\n",
              "      <td>5.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>789</th>\n",
              "      <td>Xambioá</td>\n",
              "      <td>172210</td>\n",
              "      <td>TO</td>\n",
              "      <td>40.0</td>\n",
              "      <td>37.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>13.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>19.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>24.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>790 rows × 15 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        Municipio  CodIbge Estado  2008  2009  ...  2015  2016  2017  2018  2019\n",
              "0      Acrelândia   120001     AC   0.0   7.0  ...   0.0   0.0   4.0   3.0   1.0\n",
              "1    Assis Brasil   120005     AC   2.0   2.0  ...   1.0   3.0   0.0   0.0   2.0\n",
              "2       Brasiléia   120010     AC   1.0  63.0  ...  14.0  19.0   7.0   9.0  16.0\n",
              "3          Bujari   120013     AC   1.0   1.0  ...   0.0   0.0   0.0   0.0   0.0\n",
              "4        Capixaba   120017     AC   3.0   5.0  ...   1.0   4.0   0.0   3.0   3.0\n",
              "..            ...      ...    ...   ...   ...  ...   ...   ...   ...   ...   ...\n",
              "785    Tocantínia   172110     TO   4.0   0.0  ...   2.0   0.0   1.0   1.0   8.0\n",
              "786      Tupirama   172125     TO   3.0   6.0  ...   1.0   0.0   1.0   0.0   1.0\n",
              "787    Tupiratins   172130     TO   4.0   2.0  ...   0.0   0.0   0.0   0.0   2.0\n",
              "788  Wanderlândia   172208     TO   5.0   3.0  ...   0.0   0.0   0.0   1.0   2.0\n",
              "789       Xambioá   172210     TO  40.0  37.0  ...   1.0  12.0  19.0   5.0  24.0\n",
              "\n",
              "[790 rows x 15 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 407
        },
        "id": "qYTm7MEd2E8g",
        "outputId": "903c8262-6488-4c43-ba13-9f02cda86baf"
      },
      "source": [
        "df_hosp_ano = pd.read_csv(\n",
        "    f'https://raw.githubusercontent.com/george-gca/MO826_IA368_CF044/main/data/processed/dengue_internacoes_col_ano.csv')\n",
        "\n",
        "df_hosp_ano"
      ],
      "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>Municipio</th>\n",
              "      <th>CodIbge</th>\n",
              "      <th>Estado</th>\n",
              "      <th>Ano</th>\n",
              "      <th>Internações - Dengue</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Acrelândia</td>\n",
              "      <td>120001</td>\n",
              "      <td>AC</td>\n",
              "      <td>2008</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Assis Brasil</td>\n",
              "      <td>120005</td>\n",
              "      <td>AC</td>\n",
              "      <td>2008</td>\n",
              "      <td>2.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Brasiléia</td>\n",
              "      <td>120010</td>\n",
              "      <td>AC</td>\n",
              "      <td>2008</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Bujari</td>\n",
              "      <td>120013</td>\n",
              "      <td>AC</td>\n",
              "      <td>2008</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Capixaba</td>\n",
              "      <td>120017</td>\n",
              "      <td>AC</td>\n",
              "      <td>2008</td>\n",
              "      <td>3.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9475</th>\n",
              "      <td>Tocantínia</td>\n",
              "      <td>172110</td>\n",
              "      <td>TO</td>\n",
              "      <td>2019</td>\n",
              "      <td>8.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9476</th>\n",
              "      <td>Tupirama</td>\n",
              "      <td>172125</td>\n",
              "      <td>TO</td>\n",
              "      <td>2019</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9477</th>\n",
              "      <td>Tupiratins</td>\n",
              "      <td>172130</td>\n",
              "      <td>TO</td>\n",
              "      <td>2019</td>\n",
              "      <td>2.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9478</th>\n",
              "      <td>Wanderlândia</td>\n",
              "      <td>172208</td>\n",
              "      <td>TO</td>\n",
              "      <td>2019</td>\n",
              "      <td>2.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9479</th>\n",
              "      <td>Xambioá</td>\n",
              "      <td>172210</td>\n",
              "      <td>TO</td>\n",
              "      <td>2019</td>\n",
              "      <td>24.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>9480 rows × 5 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "         Municipio  CodIbge Estado   Ano  Internações - Dengue\n",
              "0       Acrelândia   120001     AC  2008                   0.0\n",
              "1     Assis Brasil   120005     AC  2008                   2.0\n",
              "2        Brasiléia   120010     AC  2008                   1.0\n",
              "3           Bujari   120013     AC  2008                   1.0\n",
              "4         Capixaba   120017     AC  2008                   3.0\n",
              "...            ...      ...    ...   ...                   ...\n",
              "9475    Tocantínia   172110     TO  2019                   8.0\n",
              "9476      Tupirama   172125     TO  2019                   1.0\n",
              "9477    Tupiratins   172130     TO  2019                   2.0\n",
              "9478  Wanderlândia   172208     TO  2019                   2.0\n",
              "9479       Xambioá   172210     TO  2019                  24.0\n",
              "\n",
              "[9480 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 318
        },
        "id": "EmYHlnG42XEo",
        "outputId": "153a942b-0b65-4a33-e9b1-030e686727ca"
      },
      "source": [
        "df_hosp_estados = pd.read_csv(\n",
        "    f'https://raw.githubusercontent.com/george-gca/MO826_IA368_CF044/main/data/processed/dengue_internacoes_estado.csv')\n",
        "\n",
        "df_hosp_estados"
      ],
      "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>Estado</th>\n",
              "      <th>2008</th>\n",
              "      <th>2009</th>\n",
              "      <th>2010</th>\n",
              "      <th>2011</th>\n",
              "      <th>2012</th>\n",
              "      <th>2013</th>\n",
              "      <th>2014</th>\n",
              "      <th>2015</th>\n",
              "      <th>2016</th>\n",
              "      <th>2017</th>\n",
              "      <th>2018</th>\n",
              "      <th>2019</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>AC</td>\n",
              "      <td>150.0</td>\n",
              "      <td>652.0</td>\n",
              "      <td>754.0</td>\n",
              "      <td>455.0</td>\n",
              "      <td>225.0</td>\n",
              "      <td>248.0</td>\n",
              "      <td>670.0</td>\n",
              "      <td>351.0</td>\n",
              "      <td>109.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>207.0</td>\n",
              "      <td>277.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>AM</td>\n",
              "      <td>881.0</td>\n",
              "      <td>220.0</td>\n",
              "      <td>701.0</td>\n",
              "      <td>1853.0</td>\n",
              "      <td>230.0</td>\n",
              "      <td>486.0</td>\n",
              "      <td>201.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>261.0</td>\n",
              "      <td>112.0</td>\n",
              "      <td>59.0</td>\n",
              "      <td>142.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>AP</td>\n",
              "      <td>166.0</td>\n",
              "      <td>133.0</td>\n",
              "      <td>205.0</td>\n",
              "      <td>229.0</td>\n",
              "      <td>147.0</td>\n",
              "      <td>87.0</td>\n",
              "      <td>112.0</td>\n",
              "      <td>191.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>36.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>MA</td>\n",
              "      <td>3000.0</td>\n",
              "      <td>2254.0</td>\n",
              "      <td>3645.0</td>\n",
              "      <td>5835.0</td>\n",
              "      <td>4066.0</td>\n",
              "      <td>3015.0</td>\n",
              "      <td>2740.0</td>\n",
              "      <td>3963.0</td>\n",
              "      <td>5124.0</td>\n",
              "      <td>2205.0</td>\n",
              "      <td>549.0</td>\n",
              "      <td>1963.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>MT</td>\n",
              "      <td>745.0</td>\n",
              "      <td>4619.0</td>\n",
              "      <td>3804.0</td>\n",
              "      <td>988.0</td>\n",
              "      <td>2766.0</td>\n",
              "      <td>1769.0</td>\n",
              "      <td>521.0</td>\n",
              "      <td>902.0</td>\n",
              "      <td>681.0</td>\n",
              "      <td>363.0</td>\n",
              "      <td>387.0</td>\n",
              "      <td>735.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>PA</td>\n",
              "      <td>7797.0</td>\n",
              "      <td>4742.0</td>\n",
              "      <td>7412.0</td>\n",
              "      <td>7848.0</td>\n",
              "      <td>5601.0</td>\n",
              "      <td>3941.0</td>\n",
              "      <td>1898.0</td>\n",
              "      <td>2326.0</td>\n",
              "      <td>3045.0</td>\n",
              "      <td>2170.0</td>\n",
              "      <td>831.0</td>\n",
              "      <td>1082.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>RO</td>\n",
              "      <td>1076.0</td>\n",
              "      <td>4130.0</td>\n",
              "      <td>4423.0</td>\n",
              "      <td>2078.0</td>\n",
              "      <td>1505.0</td>\n",
              "      <td>2832.0</td>\n",
              "      <td>1362.0</td>\n",
              "      <td>1252.0</td>\n",
              "      <td>1469.0</td>\n",
              "      <td>587.0</td>\n",
              "      <td>338.0</td>\n",
              "      <td>429.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>RR</td>\n",
              "      <td>951.0</td>\n",
              "      <td>754.0</td>\n",
              "      <td>1188.0</td>\n",
              "      <td>234.0</td>\n",
              "      <td>293.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>122.0</td>\n",
              "      <td>41.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>123.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>TO</td>\n",
              "      <td>1195.0</td>\n",
              "      <td>946.0</td>\n",
              "      <td>1224.0</td>\n",
              "      <td>1038.0</td>\n",
              "      <td>1053.0</td>\n",
              "      <td>1073.0</td>\n",
              "      <td>726.0</td>\n",
              "      <td>483.0</td>\n",
              "      <td>393.0</td>\n",
              "      <td>299.0</td>\n",
              "      <td>164.0</td>\n",
              "      <td>569.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  Estado    2008    2009    2010    2011  ...    2015    2016    2017   2018    2019\n",
              "0     AC   150.0   652.0   754.0   455.0  ...   351.0   109.0    79.0  207.0   277.0\n",
              "1     AM   881.0   220.0   701.0  1853.0  ...   319.0   261.0   112.0   59.0   142.0\n",
              "2     AP   166.0   133.0   205.0   229.0  ...   191.0     0.0     0.0   36.0     0.0\n",
              "3     MA  3000.0  2254.0  3645.0  5835.0  ...  3963.0  5124.0  2205.0  549.0  1963.0\n",
              "4     MT   745.0  4619.0  3804.0   988.0  ...   902.0   681.0   363.0  387.0   735.0\n",
              "5     PA  7797.0  4742.0  7412.0  7848.0  ...  2326.0  3045.0  2170.0  831.0  1082.0\n",
              "6     RO  1076.0  4130.0  4423.0  2078.0  ...  1252.0  1469.0   587.0  338.0   429.0\n",
              "7     RR   951.0   754.0  1188.0   234.0  ...   122.0    41.0     0.0    0.0   123.0\n",
              "8     TO  1195.0   946.0  1224.0  1038.0  ...   483.0   393.0   299.0  164.0   569.0\n",
              "\n",
              "[9 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 407
        },
        "id": "z_PZk4Ih2Xdm",
        "outputId": "f26ec87c-7bed-4eff-99c9-9e68c232f09d"
      },
      "source": [
        "df_hosp_estados_ano = pd.read_csv(\n",
        "    f'https://raw.githubusercontent.com/george-gca/MO826_IA368_CF044/main/data/processed/dengue_internacoes_estado_col_ano.csv')\n",
        "\n",
        "df_hosp_estados_ano"
      ],
      "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>Estado</th>\n",
              "      <th>Ano</th>\n",
              "      <th>Internações - Dengue</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>AC</td>\n",
              "      <td>2008</td>\n",
              "      <td>150.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>AM</td>\n",
              "      <td>2008</td>\n",
              "      <td>881.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>AP</td>\n",
              "      <td>2008</td>\n",
              "      <td>166.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>MA</td>\n",
              "      <td>2008</td>\n",
              "      <td>3000.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>MT</td>\n",
              "      <td>2008</td>\n",
              "      <td>745.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>103</th>\n",
              "      <td>MT</td>\n",
              "      <td>2019</td>\n",
              "      <td>735.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>104</th>\n",
              "      <td>PA</td>\n",
              "      <td>2019</td>\n",
              "      <td>1082.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>105</th>\n",
              "      <td>RO</td>\n",
              "      <td>2019</td>\n",
              "      <td>429.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>106</th>\n",
              "      <td>RR</td>\n",
              "      <td>2019</td>\n",
              "      <td>123.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>107</th>\n",
              "      <td>TO</td>\n",
              "      <td>2019</td>\n",
              "      <td>569.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>108 rows × 3 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "    Estado   Ano  Internações - Dengue\n",
              "0       AC  2008                 150.0\n",
              "1       AM  2008                 881.0\n",
              "2       AP  2008                 166.0\n",
              "3       MA  2008                3000.0\n",
              "4       MT  2008                 745.0\n",
              "..     ...   ...                   ...\n",
              "103     MT  2019                 735.0\n",
              "104     PA  2019                1082.0\n",
              "105     RO  2019                 429.0\n",
              "106     RR  2019                 123.0\n",
              "107     TO  2019                 569.0\n",
              "\n",
              "[108 rows x 3 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "fXBIhizwdCo8"
      },
      "source": [
        "# Gerando Estatísticas Básicas Sobre os Dados"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "vl_s4FfcvvYx"
      },
      "source": [
        "Quantos municípios possuem cada estado na base de dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4Zyd07WkvqVH",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "1b6b3ae6-3763-4e2b-861d-716af49fa03c"
      },
      "source": [
        "states = df_hosp_estados.Estado.unique()\n",
        "for state in states:\n",
        "  print(f'{state} possui informação de {len(df_hosp[df_hosp.Estado == state].Municipio.unique())} municípios')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "AC possui informação de 22 municípios\n",
            "AM possui informação de 54 municípios\n",
            "AP possui informação de 14 municípios\n",
            "MA possui informação de 216 municípios\n",
            "MT possui informação de 140 municípios\n",
            "PA possui informação de 143 municípios\n",
            "RO possui informação de 51 municípios\n",
            "RR possui informação de 15 municípios\n",
            "TO possui informação de 135 municípios\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "M4IVcxz904qY"
      },
      "source": [
        "Gerando dados básicos sobre todos os anos, somente nas colunas de interesse"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 288
        },
        "id": "rp9v-Da9Fqc1",
        "outputId": "00daa098-5244-4882-e2f0-96f369cf3758"
      },
      "source": [
        "df_hosp[df_hosp.columns[3:]].describe()"
      ],
      "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>2008</th>\n",
              "      <th>2009</th>\n",
              "      <th>2010</th>\n",
              "      <th>2011</th>\n",
              "      <th>2012</th>\n",
              "      <th>2013</th>\n",
              "      <th>2014</th>\n",
              "      <th>2015</th>\n",
              "      <th>2016</th>\n",
              "      <th>2017</th>\n",
              "      <th>2018</th>\n",
              "      <th>2019</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>786.000000</td>\n",
              "      <td>786.000000</td>\n",
              "      <td>786.000000</td>\n",
              "      <td>786.000000</td>\n",
              "      <td>786.000000</td>\n",
              "      <td>786.000000</td>\n",
              "      <td>771.000000</td>\n",
              "      <td>786.000000</td>\n",
              "      <td>772.000000</td>\n",
              "      <td>757.000000</td>\n",
              "      <td>771.000000</td>\n",
              "      <td>772.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>20.306616</td>\n",
              "      <td>23.473282</td>\n",
              "      <td>29.715013</td>\n",
              "      <td>26.155216</td>\n",
              "      <td>20.211196</td>\n",
              "      <td>17.199746</td>\n",
              "      <td>10.674449</td>\n",
              "      <td>12.606870</td>\n",
              "      <td>14.408031</td>\n",
              "      <td>7.681638</td>\n",
              "      <td>3.334630</td>\n",
              "      <td>6.891192</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>59.879594</td>\n",
              "      <td>65.238064</td>\n",
              "      <td>71.838213</td>\n",
              "      <td>79.858737</td>\n",
              "      <td>46.509761</td>\n",
              "      <td>41.404601</td>\n",
              "      <td>30.720637</td>\n",
              "      <td>26.362624</td>\n",
              "      <td>33.061286</td>\n",
              "      <td>21.890791</td>\n",
              "      <td>8.034476</td>\n",
              "      <td>15.260422</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>13.000000</td>\n",
              "      <td>19.750000</td>\n",
              "      <td>25.000000</td>\n",
              "      <td>23.750000</td>\n",
              "      <td>19.000000</td>\n",
              "      <td>16.000000</td>\n",
              "      <td>9.000000</td>\n",
              "      <td>13.000000</td>\n",
              "      <td>13.000000</td>\n",
              "      <td>6.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>6.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>804.000000</td>\n",
              "      <td>1112.000000</td>\n",
              "      <td>709.000000</td>\n",
              "      <td>1631.000000</td>\n",
              "      <td>459.000000</td>\n",
              "      <td>547.000000</td>\n",
              "      <td>539.000000</td>\n",
              "      <td>249.000000</td>\n",
              "      <td>306.000000</td>\n",
              "      <td>208.000000</td>\n",
              "      <td>91.000000</td>\n",
              "      <td>140.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "             2008         2009        2010  ...        2017        2018        2019\n",
              "count  786.000000   786.000000  786.000000  ...  757.000000  771.000000  772.000000\n",
              "mean    20.306616    23.473282   29.715013  ...    7.681638    3.334630    6.891192\n",
              "std     59.879594    65.238064   71.838213  ...   21.890791    8.034476   15.260422\n",
              "min      0.000000     0.000000    0.000000  ...    0.000000    0.000000    0.000000\n",
              "25%      0.000000     0.000000    1.000000  ...    0.000000    0.000000    0.000000\n",
              "50%      2.000000     2.000000    4.000000  ...    1.000000    1.000000    1.000000\n",
              "75%     13.000000    19.750000   25.000000  ...    6.000000    3.000000    6.000000\n",
              "max    804.000000  1112.000000  709.000000  ...  208.000000   91.000000  140.000000\n",
              "\n",
              "[8 rows x 12 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 288
        },
        "id": "eqXhZueUAKv9",
        "outputId": "958b6eae-6915-429a-db8b-2ad13b858bfc"
      },
      "source": [
        "df_hosp_estados[df_hosp_estados.columns[1:]].describe()"
      ],
      "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>2008</th>\n",
              "      <th>2009</th>\n",
              "      <th>2010</th>\n",
              "      <th>2011</th>\n",
              "      <th>2012</th>\n",
              "      <th>2013</th>\n",
              "      <th>2014</th>\n",
              "      <th>2015</th>\n",
              "      <th>2016</th>\n",
              "      <th>2017</th>\n",
              "      <th>2018</th>\n",
              "      <th>2019</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>9.000000</td>\n",
              "      <td>9.000000</td>\n",
              "      <td>9.000000</td>\n",
              "      <td>9.000000</td>\n",
              "      <td>9.000000</td>\n",
              "      <td>9.000000</td>\n",
              "      <td>9.000000</td>\n",
              "      <td>9.000000</td>\n",
              "      <td>9.000000</td>\n",
              "      <td>9.000000</td>\n",
              "      <td>9.000000</td>\n",
              "      <td>9.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>1773.444444</td>\n",
              "      <td>2050.000000</td>\n",
              "      <td>2595.111111</td>\n",
              "      <td>2284.222222</td>\n",
              "      <td>1765.111111</td>\n",
              "      <td>1502.111111</td>\n",
              "      <td>914.444444</td>\n",
              "      <td>1101.000000</td>\n",
              "      <td>1235.888889</td>\n",
              "      <td>646.111111</td>\n",
              "      <td>285.666667</td>\n",
              "      <td>591.111111</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>2407.247033</td>\n",
              "      <td>1939.435034</td>\n",
              "      <td>2388.963187</td>\n",
              "      <td>2711.060483</td>\n",
              "      <td>1971.629240</td>\n",
              "      <td>1454.539140</td>\n",
              "      <td>917.846135</td>\n",
              "      <td>1279.480363</td>\n",
              "      <td>1754.938136</td>\n",
              "      <td>894.309293</td>\n",
              "      <td>272.957872</td>\n",
              "      <td>616.383696</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>150.000000</td>\n",
              "      <td>133.000000</td>\n",
              "      <td>205.000000</td>\n",
              "      <td>229.000000</td>\n",
              "      <td>147.000000</td>\n",
              "      <td>68.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>122.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>745.000000</td>\n",
              "      <td>652.000000</td>\n",
              "      <td>754.000000</td>\n",
              "      <td>455.000000</td>\n",
              "      <td>230.000000</td>\n",
              "      <td>248.000000</td>\n",
              "      <td>201.000000</td>\n",
              "      <td>319.000000</td>\n",
              "      <td>109.000000</td>\n",
              "      <td>79.000000</td>\n",
              "      <td>59.000000</td>\n",
              "      <td>142.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>951.000000</td>\n",
              "      <td>946.000000</td>\n",
              "      <td>1224.000000</td>\n",
              "      <td>1038.000000</td>\n",
              "      <td>1053.000000</td>\n",
              "      <td>1073.000000</td>\n",
              "      <td>670.000000</td>\n",
              "      <td>483.000000</td>\n",
              "      <td>393.000000</td>\n",
              "      <td>299.000000</td>\n",
              "      <td>207.000000</td>\n",
              "      <td>429.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>1195.000000</td>\n",
              "      <td>4130.000000</td>\n",
              "      <td>3804.000000</td>\n",
              "      <td>2078.000000</td>\n",
              "      <td>2766.000000</td>\n",
              "      <td>2832.000000</td>\n",
              "      <td>1362.000000</td>\n",
              "      <td>1252.000000</td>\n",
              "      <td>1469.000000</td>\n",
              "      <td>587.000000</td>\n",
              "      <td>387.000000</td>\n",
              "      <td>735.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>7797.000000</td>\n",
              "      <td>4742.000000</td>\n",
              "      <td>7412.000000</td>\n",
              "      <td>7848.000000</td>\n",
              "      <td>5601.000000</td>\n",
              "      <td>3941.000000</td>\n",
              "      <td>2740.000000</td>\n",
              "      <td>3963.000000</td>\n",
              "      <td>5124.000000</td>\n",
              "      <td>2205.000000</td>\n",
              "      <td>831.000000</td>\n",
              "      <td>1963.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "              2008         2009  ...        2018         2019\n",
              "count     9.000000     9.000000  ...    9.000000     9.000000\n",
              "mean   1773.444444  2050.000000  ...  285.666667   591.111111\n",
              "std    2407.247033  1939.435034  ...  272.957872   616.383696\n",
              "min     150.000000   133.000000  ...    0.000000     0.000000\n",
              "25%     745.000000   652.000000  ...   59.000000   142.000000\n",
              "50%     951.000000   946.000000  ...  207.000000   429.000000\n",
              "75%    1195.000000  4130.000000  ...  387.000000   735.000000\n",
              "max    7797.000000  4742.000000  ...  831.000000  1963.000000\n",
              "\n",
              "[8 rows x 12 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "uwYOB8yOL68r"
      },
      "source": [
        "Gerando o gráfico da média e desvio padrão de internações por dengue no período dos dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 382
        },
        "id": "VJXYWDxoF9M2",
        "outputId": "c8700a22-15ed-4569-b434-456f744cbfe0"
      },
      "source": [
        "line = alt.Chart(df_hosp_estados_ano).mark_line().encode(\n",
        "    x='Ano:O',\n",
        "    y='mean(Internações - Dengue):Q'\n",
        ")\n",
        "\n",
        "# https://vega.github.io/vega-lite/docs/errorband.html#properties\n",
        "band = alt.Chart(df_hosp_estados_ano).mark_errorband(extent='stdev').encode(\n",
        "    x='Ano:O',\n",
        "    y=alt.Y('Internações - Dengue:Q', title='Internações por Dengue'),\n",
        ")\n",
        "\n",
        "band + line"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "alt.LayerChart(...)"
            ],
            "text/html": [
              "\n",
              "<div id=\"altair-viz-89b881b20f1b422ab53951dfba7fbd94\"></div>\n",
              "<script type=\"text/javascript\">\n",
              "  (function(spec, embedOpt){\n",
              "    let outputDiv = document.currentScript.previousElementSibling;\n",
              "    if (outputDiv.id !== \"altair-viz-89b881b20f1b422ab53951dfba7fbd94\") {\n",
              "      outputDiv = document.getElementById(\"altair-viz-89b881b20f1b422ab53951dfba7fbd94\");\n",
              "    }\n",
              "    const paths = {\n",
              "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
              "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
              "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.8.1?noext\",\n",
              "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
              "    };\n",
              "\n",
              "    function loadScript(lib) {\n",
              "      return new Promise(function(resolve, reject) {\n",
              "        var s = document.createElement('script');\n",
              "        s.src = paths[lib];\n",
              "        s.async = true;\n",
              "        s.onload = () => resolve(paths[lib]);\n",
              "        s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
              "        document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
              "      });\n",
              "    }\n",
              "\n",
              "    function showError(err) {\n",
              "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
              "      throw err;\n",
              "    }\n",
              "\n",
              "    function displayChart(vegaEmbed) {\n",
              "      vegaEmbed(outputDiv, spec, embedOpt)\n",
              "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
              "    }\n",
              "\n",
              "    if(typeof define === \"function\" && define.amd) {\n",
              "      requirejs.config({paths});\n",
              "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
              "    } else if (typeof vegaEmbed === \"function\") {\n",
              "      displayChart(vegaEmbed);\n",
              "    } else {\n",
              "      loadScript(\"vega\")\n",
              "        .then(() => loadScript(\"vega-lite\"))\n",
              "        .then(() => loadScript(\"vega-embed\"))\n",
              "        .catch(showError)\n",
              "        .then(() => displayChart(vegaEmbed));\n",
              "    }\n",
              "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300}}, \"layer\": [{\"mark\": {\"type\": \"errorband\", \"extent\": \"stdev\"}, \"encoding\": {\"x\": {\"type\": \"ordinal\", \"field\": \"Ano\"}, \"y\": {\"type\": \"quantitative\", \"field\": \"Interna\\u00e7\\u00f5es - Dengue\", \"title\": \"Interna\\u00e7\\u00f5es por Dengue\"}}}, {\"mark\": \"line\", \"encoding\": {\"x\": {\"type\": \"ordinal\", \"field\": \"Ano\"}, \"y\": {\"type\": \"quantitative\", \"aggregate\": \"mean\", \"field\": \"Interna\\u00e7\\u00f5es - Dengue\"}}}], \"data\": {\"name\": \"data-8c6d5d77fdb2b1e00f667b4351898158\"}, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.8.1.json\", \"datasets\": {\"data-8c6d5d77fdb2b1e00f667b4351898158\": [{\"Estado\": \"AC\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 150.0}, {\"Estado\": \"AM\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 881.0}, {\"Estado\": \"AP\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 166.0}, {\"Estado\": \"MA\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 3000.0}, {\"Estado\": \"MT\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 745.0}, {\"Estado\": \"PA\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 7797.0}, {\"Estado\": \"RO\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 1076.0}, {\"Estado\": \"RR\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 951.0}, {\"Estado\": \"TO\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 1195.0}, {\"Estado\": \"AC\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 652.0}, {\"Estado\": \"AM\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 220.0}, {\"Estado\": \"AP\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 133.0}, {\"Estado\": \"MA\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 2254.0}, {\"Estado\": \"MT\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 4619.0}, {\"Estado\": \"PA\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 4742.0}, {\"Estado\": \"RO\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 4130.0}, {\"Estado\": \"RR\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 754.0}, {\"Estado\": \"TO\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 946.0}, {\"Estado\": \"AC\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 754.0}, {\"Estado\": \"AM\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 701.0}, {\"Estado\": \"AP\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 205.0}, {\"Estado\": \"MA\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 3645.0}, {\"Estado\": \"MT\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 3804.0}, {\"Estado\": \"PA\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 7412.0}, {\"Estado\": \"RO\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 4423.0}, {\"Estado\": \"RR\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 1188.0}, {\"Estado\": \"TO\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 1224.0}, {\"Estado\": \"AC\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 455.0}, {\"Estado\": \"AM\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 1853.0}, {\"Estado\": \"AP\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 229.0}, {\"Estado\": \"MA\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 5835.0}, {\"Estado\": \"MT\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 988.0}, {\"Estado\": \"PA\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 7848.0}, {\"Estado\": \"RO\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 2078.0}, {\"Estado\": \"RR\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 234.0}, {\"Estado\": \"TO\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 1038.0}, {\"Estado\": \"AC\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 225.0}, {\"Estado\": \"AM\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 230.0}, {\"Estado\": \"AP\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 147.0}, {\"Estado\": \"MA\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 4066.0}, {\"Estado\": \"MT\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 2766.0}, {\"Estado\": \"PA\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 5601.0}, {\"Estado\": \"RO\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 1505.0}, {\"Estado\": \"RR\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 293.0}, {\"Estado\": \"TO\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 1053.0}, {\"Estado\": \"AC\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 248.0}, {\"Estado\": \"AM\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 486.0}, {\"Estado\": \"AP\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 87.0}, {\"Estado\": \"MA\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 3015.0}, {\"Estado\": \"MT\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 1769.0}, {\"Estado\": \"PA\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 3941.0}, {\"Estado\": \"RO\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 2832.0}, {\"Estado\": \"RR\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 68.0}, {\"Estado\": \"TO\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 1073.0}, {\"Estado\": \"AC\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 670.0}, {\"Estado\": \"AM\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 201.0}, {\"Estado\": \"AP\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 112.0}, {\"Estado\": \"MA\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 2740.0}, {\"Estado\": \"MT\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 521.0}, {\"Estado\": \"PA\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 1898.0}, {\"Estado\": \"RO\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 1362.0}, {\"Estado\": \"RR\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"TO\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 726.0}, {\"Estado\": \"AC\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 351.0}, {\"Estado\": \"AM\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 319.0}, {\"Estado\": \"AP\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 191.0}, {\"Estado\": \"MA\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 3963.0}, {\"Estado\": \"MT\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 902.0}, {\"Estado\": \"PA\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 2326.0}, {\"Estado\": \"RO\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 1252.0}, {\"Estado\": \"RR\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 122.0}, {\"Estado\": \"TO\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 483.0}, {\"Estado\": \"AC\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 109.0}, {\"Estado\": \"AM\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 261.0}, {\"Estado\": \"AP\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"MA\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 5124.0}, {\"Estado\": \"MT\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 681.0}, {\"Estado\": \"PA\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 3045.0}, {\"Estado\": \"RO\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 1469.0}, {\"Estado\": \"RR\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 41.0}, {\"Estado\": \"TO\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 393.0}, {\"Estado\": \"AC\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 79.0}, {\"Estado\": \"AM\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 112.0}, {\"Estado\": \"AP\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"MA\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 2205.0}, {\"Estado\": \"MT\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 363.0}, {\"Estado\": \"PA\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 2170.0}, {\"Estado\": \"RO\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 587.0}, {\"Estado\": \"RR\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"TO\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 299.0}, {\"Estado\": \"AC\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 207.0}, {\"Estado\": \"AM\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 59.0}, {\"Estado\": \"AP\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 36.0}, {\"Estado\": \"MA\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 549.0}, {\"Estado\": \"MT\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 387.0}, {\"Estado\": \"PA\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 831.0}, {\"Estado\": \"RO\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 338.0}, {\"Estado\": \"RR\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"TO\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 164.0}, {\"Estado\": \"AC\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 277.0}, {\"Estado\": \"AM\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 142.0}, {\"Estado\": \"AP\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"MA\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 1963.0}, {\"Estado\": \"MT\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 735.0}, {\"Estado\": \"PA\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 1082.0}, {\"Estado\": \"RO\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 429.0}, {\"Estado\": \"RR\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 123.0}, {\"Estado\": \"TO\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 569.0}]}}, {\"mode\": \"vega-lite\"});\n",
              "</script>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "whckii6gI3ps"
      },
      "source": [
        "# Verificando Completude dos Dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ptwCT3IgI9jJ"
      },
      "source": [
        "def print_completion_table(df: pd.DataFrame):\n",
        "  print(f'Total de linhas: {len(df):n}')\n",
        "  data = []\n",
        "  for c in df:\n",
        "    data.append([c, f'{df[c].isna().sum():n}'])\n",
        "  \n",
        "  print(tabulate(data, headers=['Coluna', 'Dados Faltantes'], tablefmt='pretty'))"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "29kVbkE5OwQj",
        "outputId": "5c8bb4f6-4c1f-4261-e25a-fe24410672dc"
      },
      "source": [
        "print_completion_table(df_hosp)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Total de linhas: 790\n",
            "+-----------+-----------------+\n",
            "|  Coluna   | Dados Faltantes |\n",
            "+-----------+-----------------+\n",
            "| Municipio |        0        |\n",
            "|  CodIbge  |        0        |\n",
            "|  Estado   |        0        |\n",
            "|   2008    |        4        |\n",
            "|   2009    |        4        |\n",
            "|   2010    |        4        |\n",
            "|   2011    |        4        |\n",
            "|   2012    |        4        |\n",
            "|   2013    |        4        |\n",
            "|   2014    |       19        |\n",
            "|   2015    |        4        |\n",
            "|   2016    |       18        |\n",
            "|   2017    |       33        |\n",
            "|   2018    |       19        |\n",
            "|   2019    |       18        |\n",
            "+-----------+-----------------+\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Aetbju7XPPTI",
        "outputId": "fbaa4300-2f60-4282-eb45-8929e3569c80"
      },
      "source": [
        "print_completion_table(df_hosp_ano)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Total de linhas: 9480\n",
            "+----------------------+-----------------+\n",
            "|        Coluna        | Dados Faltantes |\n",
            "+----------------------+-----------------+\n",
            "|      Municipio       |        0        |\n",
            "|       CodIbge        |        0        |\n",
            "|        Estado        |        0        |\n",
            "|         Ano          |        0        |\n",
            "| Internações - Dengue |       135       |\n",
            "+----------------------+-----------------+\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "DAdkr-tkPPxt",
        "outputId": "1522f8e9-3f28-4f52-e74e-f2fd57d0fe64"
      },
      "source": [
        "print_completion_table(df_hosp_estados)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Total de linhas: 9\n",
            "+--------+-----------------+\n",
            "| Coluna | Dados Faltantes |\n",
            "+--------+-----------------+\n",
            "| Estado |        0        |\n",
            "|  2008  |        0        |\n",
            "|  2009  |        0        |\n",
            "|  2010  |        0        |\n",
            "|  2011  |        0        |\n",
            "|  2012  |        0        |\n",
            "|  2013  |        0        |\n",
            "|  2014  |        0        |\n",
            "|  2015  |        0        |\n",
            "|  2016  |        0        |\n",
            "|  2017  |        0        |\n",
            "|  2018  |        0        |\n",
            "|  2019  |        0        |\n",
            "+--------+-----------------+\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "C_e4bYLQPQDV",
        "outputId": "4a6a57db-0541-4b8e-fd9d-600f9017f634"
      },
      "source": [
        "print_completion_table(df_hosp_estados_ano)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Total de linhas: 108\n",
            "+----------------------+-----------------+\n",
            "|        Coluna        | Dados Faltantes |\n",
            "+----------------------+-----------------+\n",
            "|        Estado        |        0        |\n",
            "|         Ano          |        0        |\n",
            "| Internações - Dengue |        0        |\n",
            "+----------------------+-----------------+\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "AZL_Vt201b6I"
      },
      "source": [
        "Valores faltantes por ano e estado"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 318
        },
        "id": "NOCAXQrkya4j",
        "outputId": "24361970-f25a-446c-9e81-ce10d6eeb768"
      },
      "source": [
        "df_hosp.drop('Estado', 1).isna().groupby(df_hosp.Estado, sort=False).sum().reset_index()"
      ],
      "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>Estado</th>\n",
              "      <th>Municipio</th>\n",
              "      <th>CodIbge</th>\n",
              "      <th>2008</th>\n",
              "      <th>2009</th>\n",
              "      <th>2010</th>\n",
              "      <th>2011</th>\n",
              "      <th>2012</th>\n",
              "      <th>2013</th>\n",
              "      <th>2014</th>\n",
              "      <th>2015</th>\n",
              "      <th>2016</th>\n",
              "      <th>2017</th>\n",
              "      <th>2018</th>\n",
              "      <th>2019</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>AC</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>AP</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>14</td>\n",
              "      <td>14</td>\n",
              "      <td>0</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>AM</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>MA</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>MT</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>PA</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>RO</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>RR</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>15</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>15</td>\n",
              "      <td>15</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>TO</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  Estado  Municipio  CodIbge  2008  2009  ...  2015  2016  2017  2018  2019\n",
              "0     AC          0        0     0     0  ...     0     0     0     0     0\n",
              "1     AP          0        0     0     0  ...     0    14    14     0    14\n",
              "2     AM          0        0     1     1  ...     1     1     1     1     1\n",
              "3     MA          0        0     0     0  ...     0     0     0     0     0\n",
              "4     MT          0        0     1     1  ...     1     1     1     1     1\n",
              "5     PA          0        0     1     1  ...     1     1     1     1     1\n",
              "6     RO          0        0     0     0  ...     0     0     0     0     0\n",
              "7     RR          0        0     0     0  ...     0     0    15    15     0\n",
              "8     TO          0        0     1     1  ...     1     1     1     1     1\n",
              "\n",
              "[9 rows x 15 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Q6bIThwMlUHr"
      },
      "source": [
        "# Estado com Maior Número de Internações por Dengue Anual"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "lxtuJ5XtjWzt",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "e362435b-0680-4d73-9bd0-bea465209b45"
      },
      "source": [
        "years = df_hosp_estados_ano.Ano.unique()\n",
        "for year in years:\n",
        "  highest_hosp_admissions = df_hosp_estados.iloc[df_hosp_estados[f'{year}'].argmax()]\n",
        "  print(f'Estado com maior número de internações em {year}: '\n",
        "        f'{highest_hosp_admissions.Estado} - {highest_hosp_admissions[f\"{year}\"]:n}')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Estado com maior número de internações em 2008: PA - 7797\n",
            "Estado com maior número de internações em 2009: PA - 4742\n",
            "Estado com maior número de internações em 2010: PA - 7412\n",
            "Estado com maior número de internações em 2011: PA - 7848\n",
            "Estado com maior número de internações em 2012: PA - 5601\n",
            "Estado com maior número de internações em 2013: PA - 3941\n",
            "Estado com maior número de internações em 2014: MA - 2740\n",
            "Estado com maior número de internações em 2015: MA - 3963\n",
            "Estado com maior número de internações em 2016: MA - 5124\n",
            "Estado com maior número de internações em 2017: MA - 2205\n",
            "Estado com maior número de internações em 2018: PA - 831\n",
            "Estado com maior número de internações em 2019: MA - 1963\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "VC8Ks1mcFroc",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 382
        },
        "outputId": "78718991-df7c-41f6-d600-0da86c673e55"
      },
      "source": [
        "alt.Chart(df_hosp_estados_ano).mark_line().encode(\n",
        "    x='Ano:O',\n",
        "    y='Internações - Dengue:Q',\n",
        "    color='Estado:N',\n",
        "    strokeDash='Estado:N',\n",
        ")"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "alt.Chart(...)"
            ],
            "text/html": [
              "\n",
              "<div id=\"altair-viz-fd5693e750b44e36968f730e64b193ed\"></div>\n",
              "<script type=\"text/javascript\">\n",
              "  (function(spec, embedOpt){\n",
              "    let outputDiv = document.currentScript.previousElementSibling;\n",
              "    if (outputDiv.id !== \"altair-viz-fd5693e750b44e36968f730e64b193ed\") {\n",
              "      outputDiv = document.getElementById(\"altair-viz-fd5693e750b44e36968f730e64b193ed\");\n",
              "    }\n",
              "    const paths = {\n",
              "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
              "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
              "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.8.1?noext\",\n",
              "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
              "    };\n",
              "\n",
              "    function loadScript(lib) {\n",
              "      return new Promise(function(resolve, reject) {\n",
              "        var s = document.createElement('script');\n",
              "        s.src = paths[lib];\n",
              "        s.async = true;\n",
              "        s.onload = () => resolve(paths[lib]);\n",
              "        s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
              "        document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
              "      });\n",
              "    }\n",
              "\n",
              "    function showError(err) {\n",
              "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
              "      throw err;\n",
              "    }\n",
              "\n",
              "    function displayChart(vegaEmbed) {\n",
              "      vegaEmbed(outputDiv, spec, embedOpt)\n",
              "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
              "    }\n",
              "\n",
              "    if(typeof define === \"function\" && define.amd) {\n",
              "      requirejs.config({paths});\n",
              "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
              "    } else if (typeof vegaEmbed === \"function\") {\n",
              "      displayChart(vegaEmbed);\n",
              "    } else {\n",
              "      loadScript(\"vega\")\n",
              "        .then(() => loadScript(\"vega-lite\"))\n",
              "        .then(() => loadScript(\"vega-embed\"))\n",
              "        .catch(showError)\n",
              "        .then(() => displayChart(vegaEmbed));\n",
              "    }\n",
              "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300}}, \"data\": {\"name\": \"data-8c6d5d77fdb2b1e00f667b4351898158\"}, \"mark\": \"line\", \"encoding\": {\"color\": {\"type\": \"nominal\", \"field\": \"Estado\"}, \"strokeDash\": {\"type\": \"nominal\", \"field\": \"Estado\"}, \"x\": {\"type\": \"ordinal\", \"field\": \"Ano\"}, \"y\": {\"type\": \"quantitative\", \"field\": \"Interna\\u00e7\\u00f5es - Dengue\"}}, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.8.1.json\", \"datasets\": {\"data-8c6d5d77fdb2b1e00f667b4351898158\": [{\"Estado\": \"AC\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 150.0}, {\"Estado\": \"AM\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 881.0}, {\"Estado\": \"AP\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 166.0}, {\"Estado\": \"MA\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 3000.0}, {\"Estado\": \"MT\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 745.0}, {\"Estado\": \"PA\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 7797.0}, {\"Estado\": \"RO\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 1076.0}, {\"Estado\": \"RR\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 951.0}, {\"Estado\": \"TO\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 1195.0}, {\"Estado\": \"AC\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 652.0}, {\"Estado\": \"AM\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 220.0}, {\"Estado\": \"AP\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 133.0}, {\"Estado\": \"MA\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 2254.0}, {\"Estado\": \"MT\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 4619.0}, {\"Estado\": \"PA\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 4742.0}, {\"Estado\": \"RO\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 4130.0}, {\"Estado\": \"RR\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 754.0}, {\"Estado\": \"TO\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 946.0}, {\"Estado\": \"AC\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 754.0}, {\"Estado\": \"AM\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 701.0}, {\"Estado\": \"AP\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 205.0}, {\"Estado\": \"MA\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 3645.0}, {\"Estado\": \"MT\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 3804.0}, {\"Estado\": \"PA\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 7412.0}, {\"Estado\": \"RO\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 4423.0}, {\"Estado\": \"RR\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 1188.0}, {\"Estado\": \"TO\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 1224.0}, {\"Estado\": \"AC\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 455.0}, {\"Estado\": \"AM\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 1853.0}, {\"Estado\": \"AP\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 229.0}, {\"Estado\": \"MA\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 5835.0}, {\"Estado\": \"MT\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 988.0}, {\"Estado\": \"PA\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 7848.0}, {\"Estado\": \"RO\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 2078.0}, {\"Estado\": \"RR\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 234.0}, {\"Estado\": \"TO\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 1038.0}, {\"Estado\": \"AC\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 225.0}, {\"Estado\": \"AM\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 230.0}, {\"Estado\": \"AP\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 147.0}, {\"Estado\": \"MA\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 4066.0}, {\"Estado\": \"MT\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 2766.0}, {\"Estado\": \"PA\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 5601.0}, {\"Estado\": \"RO\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 1505.0}, {\"Estado\": \"RR\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 293.0}, {\"Estado\": \"TO\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 1053.0}, {\"Estado\": \"AC\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 248.0}, {\"Estado\": \"AM\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 486.0}, {\"Estado\": \"AP\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 87.0}, {\"Estado\": \"MA\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 3015.0}, {\"Estado\": \"MT\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 1769.0}, {\"Estado\": \"PA\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 3941.0}, {\"Estado\": \"RO\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 2832.0}, {\"Estado\": \"RR\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 68.0}, {\"Estado\": \"TO\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 1073.0}, {\"Estado\": \"AC\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 670.0}, {\"Estado\": \"AM\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 201.0}, {\"Estado\": \"AP\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 112.0}, {\"Estado\": \"MA\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 2740.0}, {\"Estado\": \"MT\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 521.0}, {\"Estado\": \"PA\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 1898.0}, {\"Estado\": \"RO\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 1362.0}, {\"Estado\": \"RR\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"TO\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 726.0}, {\"Estado\": \"AC\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 351.0}, {\"Estado\": \"AM\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 319.0}, {\"Estado\": \"AP\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 191.0}, {\"Estado\": \"MA\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 3963.0}, {\"Estado\": \"MT\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 902.0}, {\"Estado\": \"PA\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 2326.0}, {\"Estado\": \"RO\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 1252.0}, {\"Estado\": \"RR\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 122.0}, {\"Estado\": \"TO\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 483.0}, {\"Estado\": \"AC\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 109.0}, {\"Estado\": \"AM\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 261.0}, {\"Estado\": \"AP\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"MA\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 5124.0}, {\"Estado\": \"MT\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 681.0}, {\"Estado\": \"PA\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 3045.0}, {\"Estado\": \"RO\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 1469.0}, {\"Estado\": \"RR\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 41.0}, {\"Estado\": \"TO\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 393.0}, {\"Estado\": \"AC\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 79.0}, {\"Estado\": \"AM\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 112.0}, {\"Estado\": \"AP\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"MA\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 2205.0}, {\"Estado\": \"MT\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 363.0}, {\"Estado\": \"PA\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 2170.0}, {\"Estado\": \"RO\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 587.0}, {\"Estado\": \"RR\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"TO\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 299.0}, {\"Estado\": \"AC\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 207.0}, {\"Estado\": \"AM\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 59.0}, {\"Estado\": \"AP\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 36.0}, {\"Estado\": \"MA\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 549.0}, {\"Estado\": \"MT\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 387.0}, {\"Estado\": \"PA\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 831.0}, {\"Estado\": \"RO\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 338.0}, {\"Estado\": \"RR\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"TO\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 164.0}, {\"Estado\": \"AC\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 277.0}, {\"Estado\": \"AM\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 142.0}, {\"Estado\": \"AP\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"MA\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 1963.0}, {\"Estado\": \"MT\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 735.0}, {\"Estado\": \"PA\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 1082.0}, {\"Estado\": \"RO\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 429.0}, {\"Estado\": \"RR\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 123.0}, {\"Estado\": \"TO\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 569.0}]}}, {\"mode\": \"vega-lite\"});\n",
              "</script>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 449
        },
        "id": "T7DSWhp1iyVD",
        "outputId": "d828f6af-1fcf-4bff-c7bc-27df1e929dfe"
      },
      "source": [
        "alt.Chart(df_hosp_estados_ano).mark_bar().encode(\n",
        "    x='Ano:O',\n",
        "    y='Internações - Dengue:Q',\n",
        "    color='Estado:N',\n",
        "    column='Estado:N',\n",
        "    tooltip=['Internações - Dengue']\n",
        ")"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "alt.Chart(...)"
            ],
            "text/html": [
              "\n",
              "<div id=\"altair-viz-1620797996f643469fa4753028becb20\"></div>\n",
              "<script type=\"text/javascript\">\n",
              "  (function(spec, embedOpt){\n",
              "    let outputDiv = document.currentScript.previousElementSibling;\n",
              "    if (outputDiv.id !== \"altair-viz-1620797996f643469fa4753028becb20\") {\n",
              "      outputDiv = document.getElementById(\"altair-viz-1620797996f643469fa4753028becb20\");\n",
              "    }\n",
              "    const paths = {\n",
              "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
              "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
              "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.8.1?noext\",\n",
              "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
              "    };\n",
              "\n",
              "    function loadScript(lib) {\n",
              "      return new Promise(function(resolve, reject) {\n",
              "        var s = document.createElement('script');\n",
              "        s.src = paths[lib];\n",
              "        s.async = true;\n",
              "        s.onload = () => resolve(paths[lib]);\n",
              "        s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
              "        document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
              "      });\n",
              "    }\n",
              "\n",
              "    function showError(err) {\n",
              "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
              "      throw err;\n",
              "    }\n",
              "\n",
              "    function displayChart(vegaEmbed) {\n",
              "      vegaEmbed(outputDiv, spec, embedOpt)\n",
              "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
              "    }\n",
              "\n",
              "    if(typeof define === \"function\" && define.amd) {\n",
              "      requirejs.config({paths});\n",
              "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
              "    } else if (typeof vegaEmbed === \"function\") {\n",
              "      displayChart(vegaEmbed);\n",
              "    } else {\n",
              "      loadScript(\"vega\")\n",
              "        .then(() => loadScript(\"vega-lite\"))\n",
              "        .then(() => loadScript(\"vega-embed\"))\n",
              "        .catch(showError)\n",
              "        .then(() => displayChart(vegaEmbed));\n",
              "    }\n",
              "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300}}, \"data\": {\"name\": \"data-8c6d5d77fdb2b1e00f667b4351898158\"}, \"mark\": \"bar\", \"encoding\": {\"color\": {\"type\": \"nominal\", \"field\": \"Estado\"}, \"column\": {\"type\": \"nominal\", \"field\": \"Estado\"}, \"tooltip\": [{\"type\": \"quantitative\", \"field\": \"Interna\\u00e7\\u00f5es - Dengue\"}], \"x\": {\"type\": \"ordinal\", \"field\": \"Ano\"}, \"y\": {\"type\": \"quantitative\", \"field\": \"Interna\\u00e7\\u00f5es - Dengue\"}}, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.8.1.json\", \"datasets\": {\"data-8c6d5d77fdb2b1e00f667b4351898158\": [{\"Estado\": \"AC\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 150.0}, {\"Estado\": \"AM\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 881.0}, {\"Estado\": \"AP\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 166.0}, {\"Estado\": \"MA\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 3000.0}, {\"Estado\": \"MT\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 745.0}, {\"Estado\": \"PA\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 7797.0}, {\"Estado\": \"RO\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 1076.0}, {\"Estado\": \"RR\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 951.0}, {\"Estado\": \"TO\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 1195.0}, {\"Estado\": \"AC\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 652.0}, {\"Estado\": \"AM\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 220.0}, {\"Estado\": \"AP\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 133.0}, {\"Estado\": \"MA\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 2254.0}, {\"Estado\": \"MT\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 4619.0}, {\"Estado\": \"PA\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 4742.0}, {\"Estado\": \"RO\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 4130.0}, {\"Estado\": \"RR\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 754.0}, {\"Estado\": \"TO\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 946.0}, {\"Estado\": \"AC\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 754.0}, {\"Estado\": \"AM\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 701.0}, {\"Estado\": \"AP\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 205.0}, {\"Estado\": \"MA\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 3645.0}, {\"Estado\": \"MT\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 3804.0}, {\"Estado\": \"PA\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 7412.0}, {\"Estado\": \"RO\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 4423.0}, {\"Estado\": \"RR\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 1188.0}, {\"Estado\": \"TO\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 1224.0}, {\"Estado\": \"AC\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 455.0}, {\"Estado\": \"AM\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 1853.0}, {\"Estado\": \"AP\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 229.0}, {\"Estado\": \"MA\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 5835.0}, {\"Estado\": \"MT\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 988.0}, {\"Estado\": \"PA\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 7848.0}, {\"Estado\": \"RO\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 2078.0}, {\"Estado\": \"RR\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 234.0}, {\"Estado\": \"TO\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 1038.0}, {\"Estado\": \"AC\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 225.0}, {\"Estado\": \"AM\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 230.0}, {\"Estado\": \"AP\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 147.0}, {\"Estado\": \"MA\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 4066.0}, {\"Estado\": \"MT\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 2766.0}, {\"Estado\": \"PA\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 5601.0}, {\"Estado\": \"RO\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 1505.0}, {\"Estado\": \"RR\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 293.0}, {\"Estado\": \"TO\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 1053.0}, {\"Estado\": \"AC\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 248.0}, {\"Estado\": \"AM\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 486.0}, {\"Estado\": \"AP\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 87.0}, {\"Estado\": \"MA\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 3015.0}, {\"Estado\": \"MT\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 1769.0}, {\"Estado\": \"PA\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 3941.0}, {\"Estado\": \"RO\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 2832.0}, {\"Estado\": \"RR\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 68.0}, {\"Estado\": \"TO\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 1073.0}, {\"Estado\": \"AC\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 670.0}, {\"Estado\": \"AM\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 201.0}, {\"Estado\": \"AP\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 112.0}, {\"Estado\": \"MA\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 2740.0}, {\"Estado\": \"MT\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 521.0}, {\"Estado\": \"PA\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 1898.0}, {\"Estado\": \"RO\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 1362.0}, {\"Estado\": \"RR\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"TO\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 726.0}, {\"Estado\": \"AC\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 351.0}, {\"Estado\": \"AM\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 319.0}, {\"Estado\": \"AP\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 191.0}, {\"Estado\": \"MA\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 3963.0}, {\"Estado\": \"MT\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 902.0}, {\"Estado\": \"PA\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 2326.0}, {\"Estado\": \"RO\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 1252.0}, {\"Estado\": \"RR\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 122.0}, {\"Estado\": \"TO\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 483.0}, {\"Estado\": \"AC\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 109.0}, {\"Estado\": \"AM\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 261.0}, {\"Estado\": \"AP\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"MA\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 5124.0}, {\"Estado\": \"MT\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 681.0}, {\"Estado\": \"PA\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 3045.0}, {\"Estado\": \"RO\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 1469.0}, {\"Estado\": \"RR\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 41.0}, {\"Estado\": \"TO\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 393.0}, {\"Estado\": \"AC\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 79.0}, {\"Estado\": \"AM\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 112.0}, {\"Estado\": \"AP\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"MA\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 2205.0}, {\"Estado\": \"MT\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 363.0}, {\"Estado\": \"PA\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 2170.0}, {\"Estado\": \"RO\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 587.0}, {\"Estado\": \"RR\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"TO\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 299.0}, {\"Estado\": \"AC\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 207.0}, {\"Estado\": \"AM\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 59.0}, {\"Estado\": \"AP\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 36.0}, {\"Estado\": \"MA\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 549.0}, {\"Estado\": \"MT\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 387.0}, {\"Estado\": \"PA\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 831.0}, {\"Estado\": \"RO\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 338.0}, {\"Estado\": \"RR\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"TO\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 164.0}, {\"Estado\": \"AC\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 277.0}, {\"Estado\": \"AM\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 142.0}, {\"Estado\": \"AP\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"MA\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 1963.0}, {\"Estado\": \"MT\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 735.0}, {\"Estado\": \"PA\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 1082.0}, {\"Estado\": \"RO\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 429.0}, {\"Estado\": \"RR\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 123.0}, {\"Estado\": \"TO\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 569.0}]}}, {\"mode\": \"vega-lite\"});\n",
              "</script>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "s1cTtOOQVM9d"
      },
      "source": [
        "Para todos os anos os estados com o maior número de internações foram o Pará e posteriormente o Maranhão. Podemos observar analisando os histogramas que há uma tendência à diminuição do número de internações por casos de dengue no período de 2008 a 2018 em todos os estados. Em 2019 houve um aumento em relação a 2018 para todos os estados, com exceção do Amapá.\n",
        "\n",
        "Pretendemos fazer uma análise mais apurada para avaliar individualmente os anos que tiveram aumento/redução e observar padrões, focando em estados como os de maior número de casos (PA e MA)."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "z3rm6xhvpQ-A"
      },
      "source": [
        "# Município com Maior Número de Internações por Dengue Anual"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CfdNKXRglInV",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "6598adb7-f095-4b9f-dbe2-d56662dbd3da"
      },
      "source": [
        "for year in years:\n",
        "  highest_hosp_admissions = df_hosp.iloc[df_hosp[f'{year}'].argmax()]\n",
        "  print(f'Municipio com maior número de internações em {year}: '\n",
        "        f'{highest_hosp_admissions.Municipio} ({highest_hosp_admissions.Estado}) - '\n",
        "        f'{highest_hosp_admissions[f\"{year}\"]:n}')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Municipio com maior número de internações em 2008: Manaus (AM) - 804\n",
            "Municipio com maior número de internações em 2009: Várzea Grande (MT) - 1112\n",
            "Municipio com maior número de internações em 2010: Ananindeua (PA) - 709\n",
            "Municipio com maior número de internações em 2011: Manaus (AM) - 1631\n",
            "Municipio com maior número de internações em 2012: Ananindeua (PA) - 459\n",
            "Municipio com maior número de internações em 2013: Ji-Paraná (RO) - 547\n",
            "Municipio com maior número de internações em 2014: Cruzeiro do Sul (AC) - 539\n",
            "Municipio com maior número de internações em 2015: Cruzeiro do Sul (AC) - 249\n",
            "Municipio com maior número de internações em 2016: Ji-Paraná (RO) - 306\n",
            "Municipio com maior número de internações em 2017: Aldeias Altas (MA) - 208\n",
            "Municipio com maior número de internações em 2018: Augusto Corrêa (PA) - 91\n",
            "Municipio com maior número de internações em 2019: Colinas (MA) - 140\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "wn02sD6dd6re"
      },
      "source": [
        "Como podemos perceber, tirando os anos de 2008 e 2011, em que o município com maior número de casos foi uma capital (Manaus) que possui população elevada, para todos os outros anos os municípios com maior número de internações foram municípios do interior, com provável acesso menor da população a serviços de conscientização e atenção à saúde. Para confirmar tal hipótese será necessário acesso a dados de investimento em conscientização e saneamento básico."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "EUVWkk_KH8ZS"
      },
      "source": [
        "Selecionando os 10 municípios com maior número de internações por dengue em 2019"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "jagdMPq9ICVq"
      },
      "source": [
        "highest_hosp_admissions = df_hosp.nlargest(10, f'{years[-1]}').Municipio"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "kDwfaCyrmuLK",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 382
        },
        "outputId": "b411527a-c63b-44b2-f253-ebefb3884241"
      },
      "source": [
        "alt.Chart(df_hosp_ano[df_hosp_ano.Municipio.isin(highest_hosp_admissions)]).mark_line().encode(\n",
        "    x='Ano:O',\n",
        "    y='Internações - Dengue:Q',\n",
        "    color='Municipio:N',\n",
        "    strokeDash='Estado:N',\n",
        ").interactive()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "alt.Chart(...)"
            ],
            "text/html": [
              "\n",
              "<div id=\"altair-viz-d192707a560a4883bf66ba42848c1e53\"></div>\n",
              "<script type=\"text/javascript\">\n",
              "  (function(spec, embedOpt){\n",
              "    let outputDiv = document.currentScript.previousElementSibling;\n",
              "    if (outputDiv.id !== \"altair-viz-d192707a560a4883bf66ba42848c1e53\") {\n",
              "      outputDiv = document.getElementById(\"altair-viz-d192707a560a4883bf66ba42848c1e53\");\n",
              "    }\n",
              "    const paths = {\n",
              "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
              "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
              "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.8.1?noext\",\n",
              "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
              "    };\n",
              "\n",
              "    function loadScript(lib) {\n",
              "      return new Promise(function(resolve, reject) {\n",
              "        var s = document.createElement('script');\n",
              "        s.src = paths[lib];\n",
              "        s.async = true;\n",
              "        s.onload = () => resolve(paths[lib]);\n",
              "        s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
              "        document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
              "      });\n",
              "    }\n",
              "\n",
              "    function showError(err) {\n",
              "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
              "      throw err;\n",
              "    }\n",
              "\n",
              "    function displayChart(vegaEmbed) {\n",
              "      vegaEmbed(outputDiv, spec, embedOpt)\n",
              "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
              "    }\n",
              "\n",
              "    if(typeof define === \"function\" && define.amd) {\n",
              "      requirejs.config({paths});\n",
              "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
              "    } else if (typeof vegaEmbed === \"function\") {\n",
              "      displayChart(vegaEmbed);\n",
              "    } else {\n",
              "      loadScript(\"vega\")\n",
              "        .then(() => loadScript(\"vega-lite\"))\n",
              "        .then(() => loadScript(\"vega-embed\"))\n",
              "        .catch(showError)\n",
              "        .then(() => displayChart(vegaEmbed));\n",
              "    }\n",
              "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300}}, \"data\": {\"name\": \"data-c1af655b8b1472753ac686e1717d347c\"}, \"mark\": \"line\", \"encoding\": {\"color\": {\"type\": \"nominal\", \"field\": \"Municipio\"}, \"strokeDash\": {\"type\": \"nominal\", \"field\": \"Estado\"}, \"x\": {\"type\": \"ordinal\", \"field\": \"Ano\"}, \"y\": {\"type\": \"quantitative\", \"field\": \"Interna\\u00e7\\u00f5es - Dengue\"}}, \"selection\": {\"selector001\": {\"type\": \"interval\", \"bind\": \"scales\", \"encodings\": [\"x\", \"y\"]}}, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.8.1.json\", \"datasets\": {\"data-c1af655b8b1472753ac686e1717d347c\": [{\"Municipio\": \"Cruzeiro do Sul\", \"CodIbge\": 120020, \"Estado\": \"AC\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 3.0}, {\"Municipio\": \"Amarante do Maranh\\u00e3o\", \"CodIbge\": 210060, \"Estado\": \"MA\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 49.0}, {\"Municipio\": \"Colinas\", \"CodIbge\": 210350, \"Estado\": \"MA\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Municipio\": \"S\\u00e3o Lu\\u00eds Gonzaga do Maranh\\u00e3o\", \"CodIbge\": 211140, \"Estado\": \"MA\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 72.0}, {\"Municipio\": \"S\\u00edtio Novo\", \"CodIbge\": 211180, \"Estado\": \"MA\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 1.0}, {\"Municipio\": \"Curion\\u00f3polis\", \"CodIbge\": 150277, \"Estado\": \"PA\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 37.0}, {\"Municipio\": \"Cabixi\", \"CodIbge\": 110003, \"Estado\": \"RO\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Municipio\": \"Boa Vista\", \"CodIbge\": 140010, \"Estado\": \"RR\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 702.0}, {\"Municipio\": \"Aragua\\u00edna\", \"CodIbge\": 170210, \"Estado\": \"TO\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 126.0}, {\"Municipio\": \"Porto Nacional\", \"CodIbge\": 171820, \"Estado\": \"TO\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 46.0}, {\"Municipio\": \"Cruzeiro do Sul\", \"CodIbge\": 120020, \"Estado\": \"AC\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 4.0}, {\"Municipio\": \"Amarante do Maranh\\u00e3o\", \"CodIbge\": 210060, \"Estado\": \"MA\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 4.0}, {\"Municipio\": \"Colinas\", \"CodIbge\": 210350, \"Estado\": \"MA\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 3.0}, {\"Municipio\": \"S\\u00e3o Lu\\u00eds Gonzaga do Maranh\\u00e3o\", \"CodIbge\": 211140, \"Estado\": \"MA\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 11.0}, {\"Municipio\": \"S\\u00edtio Novo\", \"CodIbge\": 211180, \"Estado\": \"MA\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 19.0}, {\"Municipio\": \"Curion\\u00f3polis\", \"CodIbge\": 150277, \"Estado\": \"PA\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 69.0}, {\"Municipio\": \"Cabixi\", \"CodIbge\": 110003, \"Estado\": \"RO\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 1.0}, {\"Municipio\": \"Boa Vista\", \"CodIbge\": 140010, \"Estado\": \"RR\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 428.0}, {\"Municipio\": \"Aragua\\u00edna\", \"CodIbge\": 170210, \"Estado\": \"TO\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 24.0}, {\"Municipio\": \"Porto Nacional\", \"CodIbge\": 171820, \"Estado\": \"TO\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 60.0}, {\"Municipio\": \"Cruzeiro do Sul\", \"CodIbge\": 120020, \"Estado\": \"AC\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 10.0}, {\"Municipio\": \"Amarante do Maranh\\u00e3o\", \"CodIbge\": 210060, \"Estado\": \"MA\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 9.0}, {\"Municipio\": \"Colinas\", \"CodIbge\": 210350, \"Estado\": \"MA\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Municipio\": \"S\\u00e3o Lu\\u00eds Gonzaga do Maranh\\u00e3o\", \"CodIbge\": 211140, \"Estado\": \"MA\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 25.0}, {\"Municipio\": \"S\\u00edtio Novo\", \"CodIbge\": 211180, \"Estado\": \"MA\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 5.0}, {\"Municipio\": \"Curion\\u00f3polis\", \"CodIbge\": 150277, \"Estado\": \"PA\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 16.0}, {\"Municipio\": \"Cabixi\", \"CodIbge\": 110003, \"Estado\": \"RO\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 24.0}, {\"Municipio\": \"Boa Vista\", \"CodIbge\": 140010, \"Estado\": \"RR\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 467.0}, {\"Municipio\": \"Aragua\\u00edna\", \"CodIbge\": 170210, \"Estado\": \"TO\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 28.0}, {\"Municipio\": \"Porto Nacional\", \"CodIbge\": 171820, \"Estado\": \"TO\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 63.0}, {\"Municipio\": \"Cruzeiro do Sul\", \"CodIbge\": 120020, \"Estado\": \"AC\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 13.0}, {\"Municipio\": \"Amarante do Maranh\\u00e3o\", \"CodIbge\": 210060, \"Estado\": \"MA\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 23.0}, {\"Municipio\": \"Colinas\", \"CodIbge\": 210350, \"Estado\": \"MA\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 2.0}, {\"Municipio\": \"S\\u00e3o Lu\\u00eds Gonzaga do Maranh\\u00e3o\", \"CodIbge\": 211140, \"Estado\": \"MA\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 11.0}, {\"Municipio\": \"S\\u00edtio Novo\", \"CodIbge\": 211180, \"Estado\": \"MA\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 42.0}, {\"Municipio\": \"Curion\\u00f3polis\", \"CodIbge\": 150277, \"Estado\": \"PA\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 30.0}, {\"Municipio\": \"Cabixi\", \"CodIbge\": 110003, \"Estado\": \"RO\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 11.0}, {\"Municipio\": \"Boa Vista\", \"CodIbge\": 140010, \"Estado\": \"RR\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 86.0}, {\"Municipio\": \"Aragua\\u00edna\", \"CodIbge\": 170210, \"Estado\": \"TO\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 60.0}, {\"Municipio\": \"Porto Nacional\", \"CodIbge\": 171820, \"Estado\": \"TO\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 34.0}, {\"Municipio\": \"Cruzeiro do Sul\", \"CodIbge\": 120020, \"Estado\": \"AC\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 1.0}, {\"Municipio\": \"Amarante do Maranh\\u00e3o\", \"CodIbge\": 210060, \"Estado\": \"MA\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 21.0}, {\"Municipio\": \"Colinas\", \"CodIbge\": 210350, \"Estado\": \"MA\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 4.0}, {\"Municipio\": \"S\\u00e3o Lu\\u00eds Gonzaga do Maranh\\u00e3o\", \"CodIbge\": 211140, \"Estado\": \"MA\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 8.0}, {\"Municipio\": \"S\\u00edtio Novo\", \"CodIbge\": 211180, \"Estado\": \"MA\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 36.0}, {\"Municipio\": \"Curion\\u00f3polis\", \"CodIbge\": 150277, \"Estado\": \"PA\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 4.0}, {\"Municipio\": \"Cabixi\", \"CodIbge\": 110003, \"Estado\": \"RO\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 11.0}, {\"Municipio\": \"Boa Vista\", \"CodIbge\": 140010, \"Estado\": \"RR\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 86.0}, {\"Municipio\": \"Aragua\\u00edna\", \"CodIbge\": 170210, \"Estado\": \"TO\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 25.0}, {\"Municipio\": \"Porto Nacional\", \"CodIbge\": 171820, \"Estado\": \"TO\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 21.0}, {\"Municipio\": \"Cruzeiro do Sul\", \"CodIbge\": 120020, \"Estado\": \"AC\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 2.0}, {\"Municipio\": \"Amarante do Maranh\\u00e3o\", \"CodIbge\": 210060, \"Estado\": \"MA\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 11.0}, {\"Municipio\": \"Colinas\", \"CodIbge\": 210350, \"Estado\": \"MA\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 5.0}, {\"Municipio\": \"S\\u00e3o Lu\\u00eds Gonzaga do Maranh\\u00e3o\", \"CodIbge\": 211140, \"Estado\": \"MA\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 23.0}, {\"Municipio\": \"S\\u00edtio Novo\", \"CodIbge\": 211180, \"Estado\": \"MA\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Municipio\": \"Curion\\u00f3polis\", \"CodIbge\": 150277, \"Estado\": \"PA\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 3.0}, {\"Municipio\": \"Cabixi\", \"CodIbge\": 110003, \"Estado\": \"RO\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 8.0}, {\"Municipio\": \"Boa Vista\", \"CodIbge\": 140010, \"Estado\": \"RR\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 27.0}, {\"Municipio\": \"Aragua\\u00edna\", \"CodIbge\": 170210, \"Estado\": \"TO\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 10.0}, {\"Municipio\": \"Porto Nacional\", \"CodIbge\": 171820, \"Estado\": \"TO\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 14.0}, {\"Municipio\": \"Cruzeiro do Sul\", \"CodIbge\": 120020, \"Estado\": \"AC\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 539.0}, {\"Municipio\": \"Amarante do Maranh\\u00e3o\", \"CodIbge\": 210060, \"Estado\": \"MA\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 8.0}, {\"Municipio\": \"Colinas\", \"CodIbge\": 210350, \"Estado\": \"MA\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 1.0}, {\"Municipio\": \"S\\u00e3o Lu\\u00eds Gonzaga do Maranh\\u00e3o\", \"CodIbge\": 211140, \"Estado\": \"MA\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 14.0}, {\"Municipio\": \"S\\u00edtio Novo\", \"CodIbge\": 211180, \"Estado\": \"MA\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 12.0}, {\"Municipio\": \"Curion\\u00f3polis\", \"CodIbge\": 150277, \"Estado\": \"PA\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 6.0}, {\"Municipio\": \"Cabixi\", \"CodIbge\": 110003, \"Estado\": \"RO\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 14.0}, {\"Municipio\": \"Boa Vista\", \"CodIbge\": 140010, \"Estado\": \"RR\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": null}, {\"Municipio\": \"Aragua\\u00edna\", \"CodIbge\": 170210, \"Estado\": \"TO\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 7.0}, {\"Municipio\": \"Porto Nacional\", \"CodIbge\": 171820, \"Estado\": \"TO\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 13.0}, {\"Municipio\": \"Cruzeiro do Sul\", \"CodIbge\": 120020, \"Estado\": \"AC\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 249.0}, {\"Municipio\": \"Amarante do Maranh\\u00e3o\", \"CodIbge\": 210060, \"Estado\": \"MA\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 25.0}, {\"Municipio\": \"Colinas\", \"CodIbge\": 210350, \"Estado\": \"MA\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 13.0}, {\"Municipio\": \"S\\u00e3o Lu\\u00eds Gonzaga do Maranh\\u00e3o\", \"CodIbge\": 211140, \"Estado\": \"MA\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 49.0}, {\"Municipio\": \"S\\u00edtio Novo\", \"CodIbge\": 211180, \"Estado\": \"MA\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 16.0}, {\"Municipio\": \"Curion\\u00f3polis\", \"CodIbge\": 150277, \"Estado\": \"PA\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 1.0}, {\"Municipio\": \"Cabixi\", \"CodIbge\": 110003, \"Estado\": \"RO\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 59.0}, {\"Municipio\": \"Boa Vista\", \"CodIbge\": 140010, \"Estado\": \"RR\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 57.0}, {\"Municipio\": \"Aragua\\u00edna\", \"CodIbge\": 170210, \"Estado\": \"TO\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 12.0}, {\"Municipio\": \"Porto Nacional\", \"CodIbge\": 171820, \"Estado\": \"TO\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 10.0}, {\"Municipio\": \"Cruzeiro do Sul\", \"CodIbge\": 120020, \"Estado\": \"AC\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 16.0}, {\"Municipio\": \"Amarante do Maranh\\u00e3o\", \"CodIbge\": 210060, \"Estado\": \"MA\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 30.0}, {\"Municipio\": \"Colinas\", \"CodIbge\": 210350, \"Estado\": \"MA\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 200.0}, {\"Municipio\": \"S\\u00e3o Lu\\u00eds Gonzaga do Maranh\\u00e3o\", \"CodIbge\": 211140, \"Estado\": \"MA\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 17.0}, {\"Municipio\": \"S\\u00edtio Novo\", \"CodIbge\": 211180, \"Estado\": \"MA\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 50.0}, {\"Municipio\": \"Curion\\u00f3polis\", \"CodIbge\": 150277, \"Estado\": \"PA\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Municipio\": \"Cabixi\", \"CodIbge\": 110003, \"Estado\": \"RO\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 32.0}, {\"Municipio\": \"Boa Vista\", \"CodIbge\": 140010, \"Estado\": \"RR\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 24.0}, {\"Municipio\": \"Aragua\\u00edna\", \"CodIbge\": 170210, \"Estado\": \"TO\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 16.0}, {\"Municipio\": \"Porto Nacional\", \"CodIbge\": 171820, \"Estado\": \"TO\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 5.0}, {\"Municipio\": \"Cruzeiro do Sul\", \"CodIbge\": 120020, \"Estado\": \"AC\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 12.0}, {\"Municipio\": \"Amarante do Maranh\\u00e3o\", \"CodIbge\": 210060, \"Estado\": \"MA\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 16.0}, {\"Municipio\": \"Colinas\", \"CodIbge\": 210350, \"Estado\": \"MA\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 44.0}, {\"Municipio\": \"S\\u00e3o Lu\\u00eds Gonzaga do Maranh\\u00e3o\", \"CodIbge\": 211140, \"Estado\": \"MA\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 1.0}, {\"Municipio\": \"S\\u00edtio Novo\", \"CodIbge\": 211180, \"Estado\": \"MA\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 34.0}, {\"Municipio\": \"Curion\\u00f3polis\", \"CodIbge\": 150277, \"Estado\": \"PA\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 14.0}, {\"Municipio\": \"Cabixi\", \"CodIbge\": 110003, \"Estado\": \"RO\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 3.0}, {\"Municipio\": \"Boa Vista\", \"CodIbge\": 140010, \"Estado\": \"RR\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": null}, {\"Municipio\": \"Aragua\\u00edna\", \"CodIbge\": 170210, \"Estado\": \"TO\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 35.0}, {\"Municipio\": \"Porto Nacional\", \"CodIbge\": 171820, \"Estado\": \"TO\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 4.0}, {\"Municipio\": \"Cruzeiro do Sul\", \"CodIbge\": 120020, \"Estado\": \"AC\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 13.0}, {\"Municipio\": \"Amarante do Maranh\\u00e3o\", \"CodIbge\": 210060, \"Estado\": \"MA\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 19.0}, {\"Municipio\": \"Colinas\", \"CodIbge\": 210350, \"Estado\": \"MA\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 7.0}, {\"Municipio\": \"S\\u00e3o Lu\\u00eds Gonzaga do Maranh\\u00e3o\", \"CodIbge\": 211140, \"Estado\": \"MA\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Municipio\": \"S\\u00edtio Novo\", \"CodIbge\": 211180, \"Estado\": \"MA\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 16.0}, {\"Municipio\": \"Curion\\u00f3polis\", \"CodIbge\": 150277, \"Estado\": \"PA\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 17.0}, {\"Municipio\": \"Cabixi\", \"CodIbge\": 110003, \"Estado\": \"RO\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 18.0}, {\"Municipio\": \"Boa Vista\", \"CodIbge\": 140010, \"Estado\": \"RR\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": null}, {\"Municipio\": \"Aragua\\u00edna\", \"CodIbge\": 170210, \"Estado\": \"TO\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 6.0}, {\"Municipio\": \"Porto Nacional\", \"CodIbge\": 171820, \"Estado\": \"TO\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 35.0}, {\"Municipio\": \"Cruzeiro do Sul\", \"CodIbge\": 120020, \"Estado\": \"AC\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 99.0}, {\"Municipio\": \"Amarante do Maranh\\u00e3o\", \"CodIbge\": 210060, \"Estado\": \"MA\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 124.0}, {\"Municipio\": \"Colinas\", \"CodIbge\": 210350, \"Estado\": \"MA\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 140.0}, {\"Municipio\": \"S\\u00e3o Lu\\u00eds Gonzaga do Maranh\\u00e3o\", \"CodIbge\": 211140, \"Estado\": \"MA\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 84.0}, {\"Municipio\": \"S\\u00edtio Novo\", \"CodIbge\": 211180, \"Estado\": \"MA\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 122.0}, {\"Municipio\": \"Curion\\u00f3polis\", \"CodIbge\": 150277, \"Estado\": \"PA\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 77.0}, {\"Municipio\": \"Cabixi\", \"CodIbge\": 110003, \"Estado\": \"RO\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 80.0}, {\"Municipio\": \"Boa Vista\", \"CodIbge\": 140010, \"Estado\": \"RR\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 86.0}, {\"Municipio\": \"Aragua\\u00edna\", \"CodIbge\": 170210, \"Estado\": \"TO\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 81.0}, {\"Municipio\": \"Porto Nacional\", \"CodIbge\": 171820, \"Estado\": \"TO\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 99.0}]}}, {\"mode\": \"vega-lite\"});\n",
              "</script>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 22
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ahR2mLmafmoM"
      },
      "source": [
        "Podemos destacar no gráfico uma variação muito grande dos valores de internações nos municípios de Boa Vista (RR), Cruzeiro do Sul (AC) e Colinas (MA). No caso de Boa Vista, pelo fato de a mudança ter acontecido e a redução ter sido constante, é provável que seja fruto de ações de conscientização e investimento em saúde na região. Nos casos de Cruzeiro do Sul e Colinas, pelo fato de serem valores muito diferentes dos anos anteriores e posteriores, podendo ser erros nos dados ou mesmo um surto de casos."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "3w5MRpuP_VMP"
      },
      "source": [
        "# 10 Municípios com Maior Número de Internações a cada Ano"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "RIvLr-38_aOp",
        "outputId": "24c3a90a-7db4-43a8-ddf0-d6b8c64ff562"
      },
      "source": [
        "for year in years:\n",
        "  highest_hosp_admissions = df_hosp.nlargest(10, f'{year}')\n",
        "  print(f'\\nMunicipios com maior número de internações em {year}:\\n')\n",
        "\n",
        "  df_highest_per_state = highest_hosp_admissions.groupby('Estado')[f'{year}'].nunique().to_frame()\n",
        "  df_highest_per_state.index.name = None\n",
        "\n",
        "  sum_per_state = highest_hosp_admissions.groupby('Estado')[f'{year}'].sum()\n",
        "  total_per_state = df_hosp[df_hosp.Estado.isin(highest_hosp_admissions.Estado.unique())].groupby('Estado')[f'{year}'].sum()\n",
        "  percentage = (sum_per_state / total_per_state)\n",
        "  df_highest_per_state['Porcentagem do Estado'] = percentage\n",
        "\n",
        "  print(df_highest_per_state, '\\n')\n",
        "  \n",
        "  for i in range(len(highest_hosp_admissions)):\n",
        "    print(f'({highest_hosp_admissions.iloc[i].Estado}) '\n",
        "          f'{highest_hosp_admissions.iloc[i][f\"{year}\"]:n}'\n",
        "          f' \\t{highest_hosp_admissions.iloc[i].Municipio}')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "\n",
            "Municipios com maior número de internações em 2008:\n",
            "\n",
            "    2008  Porcentagem do Estado\n",
            "AM     1               0.912599\n",
            "PA     8               0.343722\n",
            "RR     1               0.738170 \n",
            "\n",
            "(AM) 804 \tManaus\n",
            "(RR) 702 \tBoa Vista\n",
            "(PA) 575 \tAnanindeua\n",
            "(PA) 511 \tSanta Izabel do Pará\n",
            "(PA) 356 \tParauapebas\n",
            "(PA) 262 \tXinguara\n",
            "(PA) 250 \tBragança\n",
            "(PA) 246 \tConceição do Araguaia\n",
            "(PA) 244 \tSantana do Araguaia\n",
            "(PA) 236 \tBelém\n",
            "\n",
            "Municipios com maior número de internações em 2009:\n",
            "\n",
            "    2009  Porcentagem do Estado\n",
            "AC     1               0.657975\n",
            "MT     2               0.342498\n",
            "PA     2               0.095529\n",
            "RO     4               0.373123\n",
            "RR     1               0.567639 \n",
            "\n",
            "(MT) 1112 \tVárzea Grande\n",
            "(RO) 544 \tJi-Paraná\n",
            "(RO) 481 \tRolim de Moura\n",
            "(MT) 470 \tCuiabá\n",
            "(AC) 429 \tRio Branco\n",
            "(RR) 428 \tBoa Vista\n",
            "(RO) 267 \tSão Miguel do Guaporé\n",
            "(RO) 249 \tJaru\n",
            "(PA) 227 \tAnanindeua\n",
            "(PA) 226 \tSanta Izabel do Pará\n",
            "\n",
            "Municipios com maior número de internações em 2010:\n",
            "\n",
            "    2010  Porcentagem do Estado\n",
            "AM     1               0.784593\n",
            "MA     1               0.133333\n",
            "MT     1               0.130652\n",
            "PA     4               0.283189\n",
            "RO     2               0.209586\n",
            "RR     1               0.393098 \n",
            "\n",
            "(PA) 709 \tAnanindeua\n",
            "(AM) 550 \tManaus\n",
            "(RO) 514 \tJi-Paraná\n",
            "(MT) 497 \tCuiabá\n",
            "(PA) 494 \tUruará\n",
            "(MA) 486 \tSão Luís\n",
            "(PA) 482 \tBelém\n",
            "(RR) 467 \tBoa Vista\n",
            "(PA) 414 \tAltamira\n",
            "(RO) 413 \tRolim de Moura\n",
            "\n",
            "Municipios com maior número de internações em 2011:\n",
            "\n",
            "    2011  Porcentagem do Estado\n",
            "AM     1               0.880194\n",
            "MA     3               0.145330\n",
            "PA     6               0.314985 \n",
            "\n",
            "(AM) 1631 \tManaus\n",
            "(PA) 750 \tAnanindeua\n",
            "(PA) 524 \tAltamira\n",
            "(PA) 361 \tJacundá\n",
            "(PA) 296 \tTucumã\n",
            "(MA) 294 \tSão Luís\n",
            "(MA) 285 \tBrejo\n",
            "(PA) 277 \tBragança\n",
            "(MA) 269 \tTuriaçu\n",
            "(PA) 264 \tBelém\n",
            "\n",
            "Municipios com maior número de internações em 2012:\n",
            "\n",
            "    2012  Porcentagem do Estado\n",
            "MA     1               0.085096\n",
            "MT     2               0.267173\n",
            "PA     6               0.324942\n",
            "RO     1               0.162126 \n",
            "\n",
            "(PA) 459 \tAnanindeua\n",
            "(PA) 447 \tAltamira\n",
            "(MT) 419 \tCuiabá\n",
            "(MA) 346 \tPedreiras\n",
            "(MT) 320 \tVárzea Grande\n",
            "(RO) 244 \tColorado do Oeste\n",
            "(PA) 238 \tAbaetetuba\n",
            "(PA) 231 \tSoure\n",
            "(PA) 223 \tJacundá\n",
            "(PA) 222 \tUruará\n",
            "\n",
            "Municipios com maior número de internações em 2013:\n",
            "\n",
            "    2013  Porcentagem do Estado\n",
            "AM     1               0.794239\n",
            "MA     1               0.064013\n",
            "MT     1               0.127191\n",
            "PA     3               0.228876\n",
            "RO     4               0.403249 \n",
            "\n",
            "(RO) 547 \tJi-Paraná\n",
            "(AM) 386 \tManaus\n",
            "(PA) 369 \tAltamira\n",
            "(PA) 291 \tUruará\n",
            "(PA) 242 \tPlacas\n",
            "(MT) 225 \tPontes e Lacerda\n",
            "(RO) 225 \tMirante da Serra\n",
            "(MA) 193 \tTuriaçu\n",
            "(RO) 189 \tRolim de Moura\n",
            "(RO) 181 \tCerejeiras\n",
            "\n",
            "Municipios com maior número de internações em 2014:\n",
            "\n",
            "    2014  Porcentagem do Estado\n",
            "AC     1               0.804478\n",
            "MA     5               0.242701\n",
            "PA     2               0.193361\n",
            "RO     1               0.221733\n",
            "TO     1               0.236915 \n",
            "\n",
            "(AC) 539 \tCruzeiro do Sul\n",
            "(RO) 302 \tJi-Paraná\n",
            "(PA) 254 \tAltamira\n",
            "(TO) 172 \tAraguaçu\n",
            "(MA) 167 \tSão Bernardo\n",
            "(MA) 147 \tSão Benedito do Rio Preto\n",
            "(MA) 142 \tItinga do Maranhão\n",
            "(PA) 113 \tUruará\n",
            "(MA) 109 \tSanta Quitéria do Maranhão\n",
            "(MA) 100 \tTuriaçu\n",
            "\n",
            "Municipios com maior número de internações em 2015:\n",
            "\n",
            "    2015  Porcentagem do Estado\n",
            "AC     1               0.709402\n",
            "MA     5               0.195307\n",
            "PA     3               0.197334\n",
            "RO     1               0.198083 \n",
            "\n",
            "(AC) 249 \tCruzeiro do Sul\n",
            "(RO) 248 \tJi-Paraná\n",
            "(PA) 215 \tAltamira\n",
            "(MA) 185 \tBrejo\n",
            "(MA) 179 \tTuriaçu\n",
            "(MA) 145 \tAldeias Altas\n",
            "(MA) 143 \tItinga do Maranhão\n",
            "(PA) 130 \tViseu\n",
            "(MA) 122 \tNova Olinda do Maranhão\n",
            "(PA) 114 \tUruará\n",
            "\n",
            "Municipios com maior número de internações em 2016:\n",
            "\n",
            "    2016  Porcentagem do Estado\n",
            "MA     6               0.248829\n",
            "PA     3               0.214122\n",
            "RO     1               0.208305 \n",
            "\n",
            "(RO) 306 \tJi-Paraná\n",
            "(PA) 290 \tDom Eliseu\n",
            "(MA) 276 \tAldeias Altas\n",
            "(MA) 256 \tTuriaçu\n",
            "(MA) 200 \tColinas\n",
            "(MA) 189 \tGraça Aranha\n",
            "(PA) 186 \tBragança\n",
            "(MA) 179 \tItinga do Maranhão\n",
            "(PA) 176 \tViseu\n",
            "(MA) 175 \tGrajaú\n",
            "\n",
            "Municipios com maior número de internações em 2017:\n",
            "\n",
            "    2017  Porcentagem do Estado\n",
            "MA     4               0.288889\n",
            "PA     6               0.476037 \n",
            "\n",
            "(MA) 208 \tAldeias Altas\n",
            "(MA) 204 \tGraça Aranha\n",
            "(PA) 204 \tTucumã\n",
            "(PA) 193 \tÁgua Azul do Norte\n",
            "(PA) 191 \tSão Geraldo do Araguaia\n",
            "(PA) 189 \tBragança\n",
            "(MA) 130 \tTimon\n",
            "(PA) 130 \tGoianésia do Pará\n",
            "(PA) 126 \tXinguara\n",
            "(MA) 95 \tFortaleza dos Nogueiras\n",
            "\n",
            "Municipios com maior número de internações em 2018:\n",
            "\n",
            "    2018  Porcentagem do Estado\n",
            "AC     2               0.565217\n",
            "MA     1               0.140255\n",
            "MT     1               0.124031\n",
            "PA     4               0.281588\n",
            "RO     1               0.150888\n",
            "TO     1               0.213415 \n",
            "\n",
            "(PA) 91 \tAugusto Corrêa\n",
            "(AC) 83 \tSena Madureira\n",
            "(MA) 77 \tAldeias Altas\n",
            "(PA) 55 \tViseu\n",
            "(RO) 51 \tJi-Paraná\n",
            "(PA) 49 \tSão João do Araguaia\n",
            "(MT) 48 \tRosário Oeste\n",
            "(PA) 39 \tBragança\n",
            "(TO) 35 \tPorto Nacional\n",
            "(AC) 34 \tSenador Guiomard\n",
            "\n",
            "Municipios com maior número de internações em 2019:\n",
            "\n",
            "    2019  Porcentagem do Estado\n",
            "AC     1               0.357401\n",
            "MA     4               0.239429\n",
            "PA     1               0.071165\n",
            "RO     1               0.186480\n",
            "RR     1               0.699187\n",
            "TO     2               0.316344 \n",
            "\n",
            "(MA) 140 \tColinas\n",
            "(MA) 124 \tAmarante do Maranhão\n",
            "(MA) 122 \tSítio Novo\n",
            "(AC) 99 \tCruzeiro do Sul\n",
            "(TO) 99 \tPorto Nacional\n",
            "(RR) 86 \tBoa Vista\n",
            "(MA) 84 \tSão Luís Gonzaga do Maranhão\n",
            "(TO) 81 \tAraguaína\n",
            "(RO) 80 \tCabixi\n",
            "(PA) 77 \tCurionópolis\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "wKc6CYIo79AO"
      },
      "source": [
        "# Boxplots por Estado"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SYhMc8Xi9IL2"
      },
      "source": [
        "def boxplot(df: pd.DataFrame, x: str, y: str, title: str=''):\n",
        "  return alt.Chart(df).mark_boxplot(size=50, extent=0.5).encode(\n",
        "      x=x,\n",
        "      y=alt.Y(y, scale=alt.Scale(zero=False)),\n",
        "      color=alt.Color(x, legend=None)\n",
        "  ).properties(\n",
        "      title=title,\n",
        "      width=800\n",
        "  ).configure_axis(\n",
        "      labelFontSize=12,\n",
        "      titleFontSize=12\n",
        "  )"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 404
        },
        "id": "eZhZXR5x8DCj",
        "outputId": "d544bde4-f5da-4df1-a579-4b26f2c524dd"
      },
      "source": [
        "boxplot(df_hosp_estados_ano, 'Ano:O', 'Internações - Dengue:Q', 'Internações por Dengue Anual')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "alt.Chart(...)"
            ],
            "text/html": [
              "\n",
              "<div id=\"altair-viz-a749409897bd4580b2a1cf6328e104c1\"></div>\n",
              "<script type=\"text/javascript\">\n",
              "  (function(spec, embedOpt){\n",
              "    let outputDiv = document.currentScript.previousElementSibling;\n",
              "    if (outputDiv.id !== \"altair-viz-a749409897bd4580b2a1cf6328e104c1\") {\n",
              "      outputDiv = document.getElementById(\"altair-viz-a749409897bd4580b2a1cf6328e104c1\");\n",
              "    }\n",
              "    const paths = {\n",
              "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
              "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
              "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.8.1?noext\",\n",
              "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
              "    };\n",
              "\n",
              "    function loadScript(lib) {\n",
              "      return new Promise(function(resolve, reject) {\n",
              "        var s = document.createElement('script');\n",
              "        s.src = paths[lib];\n",
              "        s.async = true;\n",
              "        s.onload = () => resolve(paths[lib]);\n",
              "        s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
              "        document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
              "      });\n",
              "    }\n",
              "\n",
              "    function showError(err) {\n",
              "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
              "      throw err;\n",
              "    }\n",
              "\n",
              "    function displayChart(vegaEmbed) {\n",
              "      vegaEmbed(outputDiv, spec, embedOpt)\n",
              "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
              "    }\n",
              "\n",
              "    if(typeof define === \"function\" && define.amd) {\n",
              "      requirejs.config({paths});\n",
              "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
              "    } else if (typeof vegaEmbed === \"function\") {\n",
              "      displayChart(vegaEmbed);\n",
              "    } else {\n",
              "      loadScript(\"vega\")\n",
              "        .then(() => loadScript(\"vega-lite\"))\n",
              "        .then(() => loadScript(\"vega-embed\"))\n",
              "        .catch(showError)\n",
              "        .then(() => displayChart(vegaEmbed));\n",
              "    }\n",
              "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300}, \"axis\": {\"labelFontSize\": 12, \"titleFontSize\": 12}}, \"data\": {\"name\": \"data-8c6d5d77fdb2b1e00f667b4351898158\"}, \"mark\": {\"type\": \"boxplot\", \"extent\": 0.5, \"size\": 50}, \"encoding\": {\"color\": {\"type\": \"ordinal\", \"field\": \"Ano\", \"legend\": null}, \"x\": {\"type\": \"ordinal\", \"field\": \"Ano\"}, \"y\": {\"type\": \"quantitative\", \"field\": \"Interna\\u00e7\\u00f5es - Dengue\", \"scale\": {\"zero\": false}}}, \"title\": \"Interna\\u00e7\\u00f5es por Dengue Anual\", \"width\": 800, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.8.1.json\", \"datasets\": {\"data-8c6d5d77fdb2b1e00f667b4351898158\": [{\"Estado\": \"AC\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 150.0}, {\"Estado\": \"AM\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 881.0}, {\"Estado\": \"AP\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 166.0}, {\"Estado\": \"MA\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 3000.0}, {\"Estado\": \"MT\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 745.0}, {\"Estado\": \"PA\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 7797.0}, {\"Estado\": \"RO\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 1076.0}, {\"Estado\": \"RR\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 951.0}, {\"Estado\": \"TO\", \"Ano\": 2008, \"Interna\\u00e7\\u00f5es - Dengue\": 1195.0}, {\"Estado\": \"AC\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 652.0}, {\"Estado\": \"AM\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 220.0}, {\"Estado\": \"AP\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 133.0}, {\"Estado\": \"MA\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 2254.0}, {\"Estado\": \"MT\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 4619.0}, {\"Estado\": \"PA\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 4742.0}, {\"Estado\": \"RO\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 4130.0}, {\"Estado\": \"RR\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 754.0}, {\"Estado\": \"TO\", \"Ano\": 2009, \"Interna\\u00e7\\u00f5es - Dengue\": 946.0}, {\"Estado\": \"AC\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 754.0}, {\"Estado\": \"AM\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 701.0}, {\"Estado\": \"AP\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 205.0}, {\"Estado\": \"MA\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 3645.0}, {\"Estado\": \"MT\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 3804.0}, {\"Estado\": \"PA\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 7412.0}, {\"Estado\": \"RO\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 4423.0}, {\"Estado\": \"RR\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 1188.0}, {\"Estado\": \"TO\", \"Ano\": 2010, \"Interna\\u00e7\\u00f5es - Dengue\": 1224.0}, {\"Estado\": \"AC\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 455.0}, {\"Estado\": \"AM\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 1853.0}, {\"Estado\": \"AP\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 229.0}, {\"Estado\": \"MA\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 5835.0}, {\"Estado\": \"MT\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 988.0}, {\"Estado\": \"PA\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 7848.0}, {\"Estado\": \"RO\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 2078.0}, {\"Estado\": \"RR\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 234.0}, {\"Estado\": \"TO\", \"Ano\": 2011, \"Interna\\u00e7\\u00f5es - Dengue\": 1038.0}, {\"Estado\": \"AC\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 225.0}, {\"Estado\": \"AM\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 230.0}, {\"Estado\": \"AP\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 147.0}, {\"Estado\": \"MA\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 4066.0}, {\"Estado\": \"MT\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 2766.0}, {\"Estado\": \"PA\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 5601.0}, {\"Estado\": \"RO\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 1505.0}, {\"Estado\": \"RR\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 293.0}, {\"Estado\": \"TO\", \"Ano\": 2012, \"Interna\\u00e7\\u00f5es - Dengue\": 1053.0}, {\"Estado\": \"AC\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 248.0}, {\"Estado\": \"AM\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 486.0}, {\"Estado\": \"AP\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 87.0}, {\"Estado\": \"MA\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 3015.0}, {\"Estado\": \"MT\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 1769.0}, {\"Estado\": \"PA\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 3941.0}, {\"Estado\": \"RO\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 2832.0}, {\"Estado\": \"RR\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 68.0}, {\"Estado\": \"TO\", \"Ano\": 2013, \"Interna\\u00e7\\u00f5es - Dengue\": 1073.0}, {\"Estado\": \"AC\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 670.0}, {\"Estado\": \"AM\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 201.0}, {\"Estado\": \"AP\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 112.0}, {\"Estado\": \"MA\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 2740.0}, {\"Estado\": \"MT\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 521.0}, {\"Estado\": \"PA\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 1898.0}, {\"Estado\": \"RO\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 1362.0}, {\"Estado\": \"RR\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"TO\", \"Ano\": 2014, \"Interna\\u00e7\\u00f5es - Dengue\": 726.0}, {\"Estado\": \"AC\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 351.0}, {\"Estado\": \"AM\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 319.0}, {\"Estado\": \"AP\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 191.0}, {\"Estado\": \"MA\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 3963.0}, {\"Estado\": \"MT\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 902.0}, {\"Estado\": \"PA\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 2326.0}, {\"Estado\": \"RO\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 1252.0}, {\"Estado\": \"RR\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 122.0}, {\"Estado\": \"TO\", \"Ano\": 2015, \"Interna\\u00e7\\u00f5es - Dengue\": 483.0}, {\"Estado\": \"AC\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 109.0}, {\"Estado\": \"AM\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 261.0}, {\"Estado\": \"AP\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"MA\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 5124.0}, {\"Estado\": \"MT\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 681.0}, {\"Estado\": \"PA\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 3045.0}, {\"Estado\": \"RO\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 1469.0}, {\"Estado\": \"RR\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 41.0}, {\"Estado\": \"TO\", \"Ano\": 2016, \"Interna\\u00e7\\u00f5es - Dengue\": 393.0}, {\"Estado\": \"AC\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 79.0}, {\"Estado\": \"AM\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 112.0}, {\"Estado\": \"AP\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"MA\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 2205.0}, {\"Estado\": \"MT\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 363.0}, {\"Estado\": \"PA\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 2170.0}, {\"Estado\": \"RO\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 587.0}, {\"Estado\": \"RR\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"TO\", \"Ano\": 2017, \"Interna\\u00e7\\u00f5es - Dengue\": 299.0}, {\"Estado\": \"AC\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 207.0}, {\"Estado\": \"AM\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 59.0}, {\"Estado\": \"AP\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 36.0}, {\"Estado\": \"MA\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 549.0}, {\"Estado\": \"MT\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 387.0}, {\"Estado\": \"PA\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 831.0}, {\"Estado\": \"RO\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 338.0}, {\"Estado\": \"RR\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"TO\", \"Ano\": 2018, \"Interna\\u00e7\\u00f5es - Dengue\": 164.0}, {\"Estado\": \"AC\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 277.0}, {\"Estado\": \"AM\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 142.0}, {\"Estado\": \"AP\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 0.0}, {\"Estado\": \"MA\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 1963.0}, {\"Estado\": \"MT\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 735.0}, {\"Estado\": \"PA\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 1082.0}, {\"Estado\": \"RO\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 429.0}, {\"Estado\": \"RR\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 123.0}, {\"Estado\": \"TO\", \"Ano\": 2019, \"Interna\\u00e7\\u00f5es - Dengue\": 569.0}]}}, {\"mode\": \"vega-lite\"});\n",
              "</script>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 25
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "DW6Nd-TxWPtV"
      },
      "source": [
        "Nessa imagem está representado o agrupamento de todos os estados por ano, onde podemos observar que nos anos de 2009 a 2013 tivemos uma maior quantidade de internações por dengue, o que está representado tanto pela mediana das caixas como pelos 1o e 3o quartis. Após esse período podemos perceber uma tendência à redução do número de casos, levando a redução tanto da mediana quando dos quartis das caixas, o que não se manteve para o ano de 2019."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "mVdVQZh5cE5P"
      },
      "source": [
        "# alt.Chart(df_hosp_ano.sample(5_000)).mark_circle(size=40).encode(\n",
        "#     x=alt.X(\n",
        "#         'jitter:Q',\n",
        "#         title=None,\n",
        "#         axis=alt.Axis(values=[0], ticks=True, grid=False, labels=False),\n",
        "#         scale=alt.Scale(),\n",
        "#     ),\n",
        "#     y=alt.Y('Internações - Dengue:Q',\n",
        "#           #  scale=alt.Scale(\n",
        "#           #   domain=(0,300))\n",
        "#            ),\n",
        "#     color=alt.Color('Estado:N'),\n",
        "#     column=alt.Column(\n",
        "#         'Ano:O',\n",
        "#         header=alt.Header(\n",
        "#             labelFontSize=16,\n",
        "#             labelAngle=0,\n",
        "#             titleOrient='top',\n",
        "#             labelOrient='bottom',\n",
        "#             labelAlign='center',\n",
        "#             labelPadding=25,\n",
        "#         ),\n",
        "#     ),\n",
        "#     tooltip=['Municipio', 'Estado']\n",
        "# ).properties(\n",
        "#     width=40\n",
        "# ).transform_calculate(\n",
        "#     # Generate Gaussian jitter with a Box-Muller transform\n",
        "#     jitter='sqrt(-2*log(random()))*cos(2*PI*random())'\n",
        "# ).configure_facet(\n",
        "#     spacing=0\n",
        "# ).configure_view(\n",
        "#     stroke=None\n",
        "# ).configure_axis(\n",
        "#     labelFontSize=16,\n",
        "#     titleFontSize=16\n",
        "# )"
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}