Análise_SUS_2018.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Análise_SUS_2018.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "mount_file_id": "1Ups_As3nPrPYd3avc1Bec7yBdtqEMcMt",
      "authorship_tag": "ABX9TyMpGCgI/RD3+cz5C5nmLnyr",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Rosangelafl/embaixadoras_inovacao_SUS/blob/master/An%C3%A1lise_SUS_2018.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "UGpmkro7MlxJ",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import csv"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "MJBtX_Ew7Ad7",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 54
        },
        "outputId": "913e76d1-e16e-436e-d5bc-86cc477db73f"
      },
      "source": [
        "arquivo = open('/content/drive/My Drive/SUS_DADOS/tbEstabelecimento201809.csv', encoding='latin-1')\n",
        "leitor = csv.reader(arquivo)\n",
        "print(next(leitor))"
      ],
      "execution_count": 120,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "['CO_UNIDADE;\"CO_CNES\";\"NU_CNPJ_MANTENEDORA\";\"TP_PFPJ\";\"NIVEL_DEP\";\"NO_RAZAO_SOCIAL\";\"NO_FANTASIA\";\"NO_LOGRADOURO\";\"NU_ENDERECO\";\"NO_COMPLEMENTO\";\"NO_BAIRRO\";\"CO_CEP\";\"CO_REGIAO_SAUDE\";\"CO_MICRO_REGIAO\";\"CO_DISTRITO_SANITARIO\";\"CO_DISTRITO_ADMINISTRATIVO\";\"NU_TELEFONE\";\"NU_FAX\";\"NO_EMAIL\";\"NU_CPF\";\"NU_CNPJ\";\"CO_ATIVIDADE\";\"CO_CLIENTELA\";\"NU_ALVARA\";\"DT_EXPEDICAO\";\"TP_ORGAO_EXPEDIDOR\";\"DT_VAL_LIC_SANI\";\"TP_LIC_SANI\";\"TP_UNIDADE\";\"CO_TURNO_ATENDIMENTO\";\"CO_ESTADO_GESTOR\";\"CO_MUNICIPIO_GESTOR\";\"TO_CHAR(DT_ATUALIZACAO', '\\'DD/MM/YYYY\\')\";\"CO_USUARIO\";\"CO_CPFDIRETORCLN\";\"REG_DIRETORCLN\";\"ST_ADESAO_FILANTROP\";\"CO_MOTIVO_DESAB\";\"NO_URL\";\"NU_LATITUDE\";\"NU_LONGITUDE\";\"TO_CHAR(DT_ATU_GEO', '\\'DD/MM/YYYY\\')\";\"NO_USUARIO_GEO\";\"CO_NATUREZA_JUR\";\"TP_ESTAB_SEMPRE_ABERTO\";\"ST_GERACREDITO_GERENTE_SGIF\";\"ST_CONEXAO_INTERNET\";\"CO_TIPO_UNIDADE\";\"NO_FANTASIA_ABREV\";\"TP_GESTAO\";\"TO_CHAR(DT_ATUALIZACAO_ORIGEM', '\\'DD/MM/YYYY\\')\"']\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ibbdbbtxnP6F",
        "colab_type": "text"
      },
      "source": [
        "Dimensionando e analisando o SUS com microdados do Datasus. \n",
        "Guia para trabalhar com os dados compilados por Rodrigo Silva, do LAIS - Laboratório de Inovação Tecnológica em Saúde [https://github.com/rdsilva], oficina do CodaBr 2018."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Z3Hk5xOSoIwb",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n"
      ],
      "execution_count": 121,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "PyJ-jFY5onLX",
        "colab_type": "text"
      },
      "source": [
        "Trabalhando com |CNES|Cadastro Nacional de Estabelecimentos de Saúde|Estabelecimentos, Profissionais, Equipamentos, Vínculos, etc\n",
        "\n",
        "Dimensionando os Estabelecimentos de Saúde, dados outubro de 2018"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "f-lwLXJ6ovj9",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 328
        },
        "outputId": "df54222d-7941-43d2-f681-3591d703ab47"
      },
      "source": [
        "cnes = pd.read_csv('/content/drive/My Drive/SUS_DADOS/tbEstabelecimento201809.csv', sep=';', encoding='Latin-1',\n",
        "                   error_bad_lines=False, quotechar='\"', low_memory=False, usecols=['CO_UNIDADE', 'CO_CNES','CO_ATIVIDADE','TP_UNIDADE', 'CO_REGIAO_SAUDE', 'TP_UNIDADE', \n",
        "                                                                                   'CO_TURNO_ATENDIMENTO', 'CO_MUNICIPIO_GESTOR','TP_ESTAB_SEMPRE_ABERTO','TP_GESTAO'])\n",
        "cnes.head(2).T\n"
      ],
      "execution_count": 122,
      "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>0</th>\n",
              "      <th>1</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>CO_UNIDADE</th>\n",
              "      <td>2928707453280</td>\n",
              "      <td>2301307450184</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CO_CNES</th>\n",
              "      <td>7453280</td>\n",
              "      <td>7450184</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CO_REGIAO_SAUDE</th>\n",
              "      <td>4</td>\n",
              "      <td>20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CO_ATIVIDADE</th>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TP_UNIDADE</th>\n",
              "      <td>1</td>\n",
              "      <td>74</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CO_TURNO_ATENDIMENTO</th>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CO_MUNICIPIO_GESTOR</th>\n",
              "      <td>292870</td>\n",
              "      <td>230130</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TP_ESTAB_SEMPRE_ABERTO</th>\n",
              "      <td>NaN</td>\n",
              "      <td>N</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TP_GESTAO</th>\n",
              "      <td>M</td>\n",
              "      <td>M</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                    0              1\n",
              "CO_UNIDADE              2928707453280  2301307450184\n",
              "CO_CNES                       7453280        7450184\n",
              "CO_REGIAO_SAUDE                     4             20\n",
              "CO_ATIVIDADE                        4              4\n",
              "TP_UNIDADE                          1             74\n",
              "CO_TURNO_ATENDIMENTO                4              3\n",
              "CO_MUNICIPIO_GESTOR            292870         230130\n",
              "TP_ESTAB_SEMPRE_ABERTO            NaN              N\n",
              "TP_GESTAO                           M              M"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 122
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "feJTfhMPGxr_",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "cnes_red = pd.read_csv('/content/drive/My Drive/SUS_DADOS/tbEstabelecimento201809.csv', sep=';', encoding='Latin-1',\n",
        "                   error_bad_lines=False, quotechar='\"', low_memory=False, usecols=['CO_UNIDADE', 'CO_CNES','CO_ATIVIDADE','TP_UNIDADE', 'CO_REGIAO_SAUDE', 'TP_UNIDADE', \n",
        "                                                                                   'CO_TURNO_ATENDIMENTO', 'CO_MUNICIPIO_GESTOR','TP_ESTAB_SEMPRE_ABERTO','TP_GESTAO'])"
      ],
      "execution_count": 123,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PTdlw2waqdyT",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "outputId": "5542e3e5-ab9c-4fe1-9211-2607f1d5994a"
      },
      "source": [
        "cnes_red.head()"
      ],
      "execution_count": 124,
      "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>CO_UNIDADE</th>\n",
              "      <th>CO_CNES</th>\n",
              "      <th>CO_REGIAO_SAUDE</th>\n",
              "      <th>CO_ATIVIDADE</th>\n",
              "      <th>TP_UNIDADE</th>\n",
              "      <th>CO_TURNO_ATENDIMENTO</th>\n",
              "      <th>CO_MUNICIPIO_GESTOR</th>\n",
              "      <th>TP_ESTAB_SEMPRE_ABERTO</th>\n",
              "      <th>TP_GESTAO</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2928707453280</td>\n",
              "      <td>7453280</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>1</td>\n",
              "      <td>4.0</td>\n",
              "      <td>292870</td>\n",
              "      <td>NaN</td>\n",
              "      <td>M</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2301307450184</td>\n",
              "      <td>7450184</td>\n",
              "      <td>20</td>\n",
              "      <td>4</td>\n",
              "      <td>74</td>\n",
              "      <td>3.0</td>\n",
              "      <td>230130</td>\n",
              "      <td>N</td>\n",
              "      <td>M</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2307307462956</td>\n",
              "      <td>7462956</td>\n",
              "      <td>21</td>\n",
              "      <td>4</td>\n",
              "      <td>22</td>\n",
              "      <td>3.0</td>\n",
              "      <td>230730</td>\n",
              "      <td>N</td>\n",
              "      <td>M</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2313407462476</td>\n",
              "      <td>7462476</td>\n",
              "      <td>13</td>\n",
              "      <td>4</td>\n",
              "      <td>2</td>\n",
              "      <td>3.0</td>\n",
              "      <td>231340</td>\n",
              "      <td>N</td>\n",
              "      <td>M</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2510107416490</td>\n",
              "      <td>7416490</td>\n",
              "      <td>004</td>\n",
              "      <td>4</td>\n",
              "      <td>71</td>\n",
              "      <td>3.0</td>\n",
              "      <td>251010</td>\n",
              "      <td>N</td>\n",
              "      <td>M</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      CO_UNIDADE  CO_CNES  ... TP_ESTAB_SEMPRE_ABERTO  TP_GESTAO\n",
              "0  2928707453280  7453280  ...                    NaN          M\n",
              "1  2301307450184  7450184  ...                      N          M\n",
              "2  2307307462956  7462956  ...                      N          M\n",
              "3  2313407462476  7462476  ...                      N          M\n",
              "4  2510107416490  7416490  ...                      N          M\n",
              "\n",
              "[5 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 124
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "JuRdbstYHL79",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 85
        },
        "outputId": "d447f5e5-a2a3-4d3b-fb1d-40f31a2cd0c3"
      },
      "source": [
        "cnes_red.columns"
      ],
      "execution_count": 125,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['CO_UNIDADE', 'CO_CNES', 'CO_REGIAO_SAUDE', 'CO_ATIVIDADE',\n",
              "       'TP_UNIDADE', 'CO_TURNO_ATENDIMENTO', 'CO_MUNICIPIO_GESTOR',\n",
              "       'TP_ESTAB_SEMPRE_ABERTO', 'TP_GESTAO'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 125
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Yn3lEs7SxPLK",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 289
        },
        "outputId": "4d0a508f-2b2e-40a0-9af9-652b4a38c0c8"
      },
      "source": [
        "cnes_red.info()"
      ],
      "execution_count": 126,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 364701 entries, 0 to 364700\n",
            "Data columns (total 9 columns):\n",
            " #   Column                  Non-Null Count   Dtype  \n",
            "---  ------                  --------------   -----  \n",
            " 0   CO_UNIDADE              364701 non-null  object \n",
            " 1   CO_CNES                 364701 non-null  int64  \n",
            " 2   CO_REGIAO_SAUDE         192424 non-null  object \n",
            " 3   CO_ATIVIDADE            364701 non-null  int64  \n",
            " 4   TP_UNIDADE              364701 non-null  int64  \n",
            " 5   CO_TURNO_ATENDIMENTO    364006 non-null  float64\n",
            " 6   CO_MUNICIPIO_GESTOR     364701 non-null  int64  \n",
            " 7   TP_ESTAB_SEMPRE_ABERTO  198787 non-null  object \n",
            " 8   TP_GESTAO               364701 non-null  object \n",
            "dtypes: float64(1), int64(4), object(4)\n",
            "memory usage: 25.0+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "lZU8QYytSFpR",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "cnes_red.rename(columns={'TP_UNIDADE' : 'cod_unidades'}, inplace=True)"
      ],
      "execution_count": 150,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ezfEnBGb46r8",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 663
        },
        "outputId": "8c211426-28a2-45b0-f408-6dbf57274891"
      },
      "source": [
        "cnes_red['cod_unidades'].value_counts()"
      ],
      "execution_count": 151,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "22    180265\n",
              "36     55028\n",
              "2      39253\n",
              "39     27822\n",
              "1      11328\n",
              "4       8770\n",
              "68      6145\n",
              "5       5795\n",
              "42      4769\n",
              "43      3573\n",
              "70      3100\n",
              "50      3048\n",
              "74      2635\n",
              "40      1497\n",
              "81      1304\n",
              "73      1284\n",
              "7       1245\n",
              "71      1200\n",
              "72      1148\n",
              "77       750\n",
              "62       731\n",
              "15       703\n",
              "60       695\n",
              "20       448\n",
              "80       447\n",
              "69       409\n",
              "83       373\n",
              "76       238\n",
              "82       139\n",
              "64       139\n",
              "21       127\n",
              "75        89\n",
              "32        63\n",
              "78        39\n",
              "67        38\n",
              "61        33\n",
              "79        31\n",
              "Name: cod_unidades, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 151
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "sHCibfK0PesN",
        "colab_type": "text"
      },
      "source": [
        "Para traduzir o código do Tipo de unidade, temos que ler o arquivo cod_atividade.csv e fazer as correspondências e/ou filtros"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "vuWYaH6V5wki",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "8d414375-9de4-44c1-d9d2-4a5c0ba2c3a7"
      },
      "source": [
        "codigo_atividade = pd.read_csv('/content/drive/My Drive/SUS_DADOS/cod_atividade.csv', sep=',', quotechar='\"', error_bad_lines=False, encoding='utf8')\n",
        "codigo_atividade"
      ],
      "execution_count": 135,
      "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>cod_unidades</th>\n",
              "      <th>descricao</th>\n",
              "      <th>total</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>POSTO DE SAUDE</td>\n",
              "      <td>11328</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>CENTRO DE SAUDE/UNIDADE BASICA</td>\n",
              "      <td>39253</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>4</td>\n",
              "      <td>POLICLINICA</td>\n",
              "      <td>8770</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>5</td>\n",
              "      <td>HOSPITAL GERAL</td>\n",
              "      <td>5795</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>7</td>\n",
              "      <td>HOSPITAL ESPECIALIZADO</td>\n",
              "      <td>1245</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>15</td>\n",
              "      <td>UNIDADE MISTA</td>\n",
              "      <td>703</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>20</td>\n",
              "      <td>PRONTO SOCORRO GERAL</td>\n",
              "      <td>344</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>21</td>\n",
              "      <td>PRONTO SOCORRO ESPECIALIZADO</td>\n",
              "      <td>127</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>22</td>\n",
              "      <td>CONSULTORIO ISOLADO</td>\n",
              "      <td>180265</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>32</td>\n",
              "      <td>UNIDADE MOVEL FLUVIAL</td>\n",
              "      <td>63</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>36</td>\n",
              "      <td>CLINICA/CENTRO DE ESPECIALIDADE</td>\n",
              "      <td>55028</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>39</td>\n",
              "      <td>UNIDADE DE APOIO DIAGNOSE E TERAPIA (SADT ISOL...</td>\n",
              "      <td>27822</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>40</td>\n",
              "      <td>UNIDADE MOVEL TERRESTRE</td>\n",
              "      <td>1497</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>42</td>\n",
              "      <td>UNIDADE MOVEL DE NIVEL PRE-HOSPITALAR NA AREA ...</td>\n",
              "      <td>4769</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>43</td>\n",
              "      <td>FARMACIA</td>\n",
              "      <td>3573</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>50</td>\n",
              "      <td>UNIDADE DE VIGILANCIA EM SAUDE</td>\n",
              "      <td>3048</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>60</td>\n",
              "      <td>COOPERATIVA OU EMPRESA DE CESSAO DE TRABALHADO...</td>\n",
              "      <td>695</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>61</td>\n",
              "      <td>CENTRO DE PARTO NORMAL � ISOLADO</td>\n",
              "      <td>33</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>62</td>\n",
              "      <td>HOSPITAL/DIA � ISOLADO</td>\n",
              "      <td>647</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>67</td>\n",
              "      <td>LABORATORIO CENTRAL DE SAUDE PUBLICA LACEN</td>\n",
              "      <td>33</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>68</td>\n",
              "      <td>CENTRAL DE GESTAO EM SAUDE</td>\n",
              "      <td>6145</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>69</td>\n",
              "      <td>CENTRO DE ATENCAO HEMOTERAPIA E OU HEMATOLOGICA</td>\n",
              "      <td>409</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>70</td>\n",
              "      <td>CENTRO DE ATENCAO PSICOSSOCIAL</td>\n",
              "      <td>3100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>71</td>\n",
              "      <td>CENTRO DE APOIO A SAUDE DA FAMILIA</td>\n",
              "      <td>3100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>72</td>\n",
              "      <td>UNIDADE DE ATENCAO A SAUDE INDIGENA</td>\n",
              "      <td>1148</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>73</td>\n",
              "      <td>PRONTO ATENDIMENTO</td>\n",
              "      <td>1284</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>74</td>\n",
              "      <td>POLO ACADEMIA DA SAUDE</td>\n",
              "      <td>2635</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>75</td>\n",
              "      <td>TELESSAUDE</td>\n",
              "      <td>89</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>76</td>\n",
              "      <td>CENTRAL DE REGULACAO MEDICA DAS URGENCIAS</td>\n",
              "      <td>238</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>77</td>\n",
              "      <td>SERVICO DE ATENCAO DOMICILIAR ISOLADO(HOME CARE)</td>\n",
              "      <td>39</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>78</td>\n",
              "      <td>UNIDADE DE ATENCAO EM REGIME RESIDENCIAL</td>\n",
              "      <td>39</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>79</td>\n",
              "      <td>OFICINA ORTOPEDICA</td>\n",
              "      <td>31</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>80</td>\n",
              "      <td>LABORATORIO DE SAUDE PUBLICA</td>\n",
              "      <td>447</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>81</td>\n",
              "      <td>CENTRAL DE REGULACAO DO ACESSO</td>\n",
              "      <td>1304</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>82</td>\n",
              "      <td>CENTRAL DE NOTIFICACAO,CAPTACAO E DISTRIB DE O...</td>\n",
              "      <td>139</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>83</td>\n",
              "      <td>POLO DE PREVENCAO DE DOENCAS E AGRAVOS E PROMO...</td>\n",
              "      <td>373</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    cod_unidades                                          descricao   total\n",
              "0              1                                     POSTO DE SAUDE   11328\n",
              "1              2                     CENTRO DE SAUDE/UNIDADE BASICA   39253\n",
              "2              4                                        POLICLINICA    8770\n",
              "3              5                                     HOSPITAL GERAL    5795\n",
              "4              7                             HOSPITAL ESPECIALIZADO    1245\n",
              "5             15                                      UNIDADE MISTA     703\n",
              "6             20                               PRONTO SOCORRO GERAL     344\n",
              "7             21                       PRONTO SOCORRO ESPECIALIZADO     127\n",
              "8             22                                CONSULTORIO ISOLADO  180265\n",
              "9             32                              UNIDADE MOVEL FLUVIAL      63\n",
              "10            36                    CLINICA/CENTRO DE ESPECIALIDADE   55028\n",
              "11            39  UNIDADE DE APOIO DIAGNOSE E TERAPIA (SADT ISOL...   27822\n",
              "12            40                            UNIDADE MOVEL TERRESTRE    1497\n",
              "13            42  UNIDADE MOVEL DE NIVEL PRE-HOSPITALAR NA AREA ...    4769\n",
              "14            43                                           FARMACIA    3573\n",
              "15            50                     UNIDADE DE VIGILANCIA EM SAUDE    3048\n",
              "16            60  COOPERATIVA OU EMPRESA DE CESSAO DE TRABALHADO...     695\n",
              "17            61                   CENTRO DE PARTO NORMAL � ISOLADO      33\n",
              "18            62                             HOSPITAL/DIA � ISOLADO     647\n",
              "19            67         LABORATORIO CENTRAL DE SAUDE PUBLICA LACEN      33\n",
              "20            68                         CENTRAL DE GESTAO EM SAUDE    6145\n",
              "21            69    CENTRO DE ATENCAO HEMOTERAPIA E OU HEMATOLOGICA     409\n",
              "22            70                     CENTRO DE ATENCAO PSICOSSOCIAL    3100\n",
              "23            71                 CENTRO DE APOIO A SAUDE DA FAMILIA    3100\n",
              "24            72                UNIDADE DE ATENCAO A SAUDE INDIGENA    1148\n",
              "25            73                                 PRONTO ATENDIMENTO    1284\n",
              "26            74                             POLO ACADEMIA DA SAUDE    2635\n",
              "27            75                                         TELESSAUDE      89\n",
              "28            76          CENTRAL DE REGULACAO MEDICA DAS URGENCIAS     238\n",
              "29            77   SERVICO DE ATENCAO DOMICILIAR ISOLADO(HOME CARE)      39\n",
              "30            78           UNIDADE DE ATENCAO EM REGIME RESIDENCIAL      39\n",
              "31            79                                 OFICINA ORTOPEDICA      31\n",
              "32            80                       LABORATORIO DE SAUDE PUBLICA     447\n",
              "33            81                     CENTRAL DE REGULACAO DO ACESSO    1304\n",
              "34            82  CENTRAL DE NOTIFICACAO,CAPTACAO E DISTRIB DE O...     139\n",
              "35            83  POLO DE PREVENCAO DE DOENCAS E AGRAVOS E PROMO...     373"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 135
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "j9jUafFIT71P",
        "colab_type": "text"
      },
      "source": [
        "Dropando a coluna total, podemos fazer a contagem. O que interessa é o códigos dos tipos de unidades que não mudam, enquanto o total pode mudar em outro conjunto de dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1-HQHN9rP7rv",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "9f32bd6d-2869-4444-d59b-8a822147c458"
      },
      "source": [
        "codigo_atividade = codigo_atividade.drop(columns='total')\n",
        "codigo_atividade\n"
      ],
      "execution_count": 164,
      "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>cod_unidades</th>\n",
              "      <th>descricao</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>POSTO DE SAUDE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>CENTRO DE SAUDE/UNIDADE BASICA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>4</td>\n",
              "      <td>POLICLINICA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>5</td>\n",
              "      <td>HOSPITAL GERAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>7</td>\n",
              "      <td>HOSPITAL ESPECIALIZADO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>15</td>\n",
              "      <td>UNIDADE MISTA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>20</td>\n",
              "      <td>PRONTO SOCORRO GERAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>21</td>\n",
              "      <td>PRONTO SOCORRO ESPECIALIZADO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>22</td>\n",
              "      <td>CONSULTORIO ISOLADO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>32</td>\n",
              "      <td>UNIDADE MOVEL FLUVIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>36</td>\n",
              "      <td>CLINICA/CENTRO DE ESPECIALIDADE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>39</td>\n",
              "      <td>UNIDADE DE APOIO DIAGNOSE E TERAPIA (SADT ISOL...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>40</td>\n",
              "      <td>UNIDADE MOVEL TERRESTRE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>42</td>\n",
              "      <td>UNIDADE MOVEL DE NIVEL PRE-HOSPITALAR NA AREA ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>43</td>\n",
              "      <td>FARMACIA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>50</td>\n",
              "      <td>UNIDADE DE VIGILANCIA EM SAUDE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>60</td>\n",
              "      <td>COOPERATIVA OU EMPRESA DE CESSAO DE TRABALHADO...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>61</td>\n",
              "      <td>CENTRO DE PARTO NORMAL � ISOLADO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>62</td>\n",
              "      <td>HOSPITAL/DIA � ISOLADO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>67</td>\n",
              "      <td>LABORATORIO CENTRAL DE SAUDE PUBLICA LACEN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>68</td>\n",
              "      <td>CENTRAL DE GESTAO EM SAUDE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>69</td>\n",
              "      <td>CENTRO DE ATENCAO HEMOTERAPIA E OU HEMATOLOGICA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>70</td>\n",
              "      <td>CENTRO DE ATENCAO PSICOSSOCIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>71</td>\n",
              "      <td>CENTRO DE APOIO A SAUDE DA FAMILIA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>72</td>\n",
              "      <td>UNIDADE DE ATENCAO A SAUDE INDIGENA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>73</td>\n",
              "      <td>PRONTO ATENDIMENTO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>74</td>\n",
              "      <td>POLO ACADEMIA DA SAUDE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>75</td>\n",
              "      <td>TELESSAUDE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>76</td>\n",
              "      <td>CENTRAL DE REGULACAO MEDICA DAS URGENCIAS</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>77</td>\n",
              "      <td>SERVICO DE ATENCAO DOMICILIAR ISOLADO(HOME CARE)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>78</td>\n",
              "      <td>UNIDADE DE ATENCAO EM REGIME RESIDENCIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>79</td>\n",
              "      <td>OFICINA ORTOPEDICA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>80</td>\n",
              "      <td>LABORATORIO DE SAUDE PUBLICA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>81</td>\n",
              "      <td>CENTRAL DE REGULACAO DO ACESSO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>82</td>\n",
              "      <td>CENTRAL DE NOTIFICACAO,CAPTACAO E DISTRIB DE O...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>83</td>\n",
              "      <td>POLO DE PREVENCAO DE DOENCAS E AGRAVOS E PROMO...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    cod_unidades                                          descricao\n",
              "0              1                                     POSTO DE SAUDE\n",
              "1              2                     CENTRO DE SAUDE/UNIDADE BASICA\n",
              "2              4                                        POLICLINICA\n",
              "3              5                                     HOSPITAL GERAL\n",
              "4              7                             HOSPITAL ESPECIALIZADO\n",
              "5             15                                      UNIDADE MISTA\n",
              "6             20                               PRONTO SOCORRO GERAL\n",
              "7             21                       PRONTO SOCORRO ESPECIALIZADO\n",
              "8             22                                CONSULTORIO ISOLADO\n",
              "9             32                              UNIDADE MOVEL FLUVIAL\n",
              "10            36                    CLINICA/CENTRO DE ESPECIALIDADE\n",
              "11            39  UNIDADE DE APOIO DIAGNOSE E TERAPIA (SADT ISOL...\n",
              "12            40                            UNIDADE MOVEL TERRESTRE\n",
              "13            42  UNIDADE MOVEL DE NIVEL PRE-HOSPITALAR NA AREA ...\n",
              "14            43                                           FARMACIA\n",
              "15            50                     UNIDADE DE VIGILANCIA EM SAUDE\n",
              "16            60  COOPERATIVA OU EMPRESA DE CESSAO DE TRABALHADO...\n",
              "17            61                   CENTRO DE PARTO NORMAL � ISOLADO\n",
              "18            62                             HOSPITAL/DIA � ISOLADO\n",
              "19            67         LABORATORIO CENTRAL DE SAUDE PUBLICA LACEN\n",
              "20            68                         CENTRAL DE GESTAO EM SAUDE\n",
              "21            69    CENTRO DE ATENCAO HEMOTERAPIA E OU HEMATOLOGICA\n",
              "22            70                     CENTRO DE ATENCAO PSICOSSOCIAL\n",
              "23            71                 CENTRO DE APOIO A SAUDE DA FAMILIA\n",
              "24            72                UNIDADE DE ATENCAO A SAUDE INDIGENA\n",
              "25            73                                 PRONTO ATENDIMENTO\n",
              "26            74                             POLO ACADEMIA DA SAUDE\n",
              "27            75                                         TELESSAUDE\n",
              "28            76          CENTRAL DE REGULACAO MEDICA DAS URGENCIAS\n",
              "29            77   SERVICO DE ATENCAO DOMICILIAR ISOLADO(HOME CARE)\n",
              "30            78           UNIDADE DE ATENCAO EM REGIME RESIDENCIAL\n",
              "31            79                                 OFICINA ORTOPEDICA\n",
              "32            80                       LABORATORIO DE SAUDE PUBLICA\n",
              "33            81                     CENTRAL DE REGULACAO DO ACESSO\n",
              "34            82  CENTRAL DE NOTIFICACAO,CAPTACAO E DISTRIB DE O...\n",
              "35            83  POLO DE PREVENCAO DE DOENCAS E AGRAVOS E PROMO..."
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 164
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "wgZQDw5CWg9H",
        "colab_type": "text"
      },
      "source": [
        "UNIDADE DE ATENCAO A SAUDE INDIGENA = 72 e UNIDADE MOVEL FLUVIAL = 32\n",
        "Vamos contar a quantidade de unidades de saúde indígena e o qtd de návios hospitais para a população ribeirinha."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "IAt0u1SmVwKQ",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "indigena = cnes_red[cnes_red['cod_unidades'] == 72]"
      ],
      "execution_count": 153,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8krBoqi9i720",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 187
        },
        "outputId": "505d5713-224a-46d6-a92b-fda7bc84fea4"
      },
      "source": [
        "indigena.count()"
      ],
      "execution_count": 154,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "CO_UNIDADE                1148\n",
              "CO_CNES                   1148\n",
              "CO_REGIAO_SAUDE            298\n",
              "CO_ATIVIDADE              1148\n",
              "cod_unidades              1148\n",
              "CO_TURNO_ATENDIMENTO      1148\n",
              "CO_MUNICIPIO_GESTOR       1148\n",
              "TP_ESTAB_SEMPRE_ABERTO     927\n",
              "TP_GESTAO                 1148\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 154
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "dO9CM5poi8FQ",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 282
        },
        "outputId": "bc93b422-11db-4e56-c7fd-bcaea29803c2"
      },
      "source": [
        "#Quantas unidades de atendimento indigenas tem atendimento 24 horas?\n",
        "indigena.groupby('TP_ESTAB_SEMPRE_ABERTO').size().sort_values(ascending=False).plot(kind='barh')"
      ],
      "execution_count": 155,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7feeb5c58e10>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 155
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD4CAYAAADiry33AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAR20lEQVR4nO3de4wudX3H8fenBxHkwEEEFAE5h9TQIFjAk1aKVSrRKCgm1hvaSqsGW2uQEkWoxtSmsbTRRlCr9Q5GrYo3gq03lJqaFHoQEBC5qIDgBbxwqXfw2z+eWXy67u7ssjO784zvV7I5v5nZ8zyfPXnOZ2d/z+xvUlVIksbrt9Y7gCSpXxa9JI2cRS9JI2fRS9LIWfSSNHLbrXeAhey+++61efPm9Y4hSTPj4osv/l5V7bHQsUEW/ebNm9m2bdt6x5CkmZHkhsWOOXUjSSNn0UvSyFn0kjRyFr0kjZxFL0kjZ9FL0shZ9JI0cha9JI2cRS9JI2fRS9LIWfSSNHIWvSSNnEUvSSNn0UvSyFn0kjRyFr0kjZxFL0kjZ9FL0shZ9JI0cha9JI2cRS9JI2fRS9LIWfSSNHIWvSSNnEUvSSNn0UvSyG233gEWcvnNt7P51E+sd4xRuP70Y9Y7gqR15hm9JI2cRS9JI2fRS9LIWfSSNHIWvSSNnEUvSSNn0UvSyFn0kjRyFr0kjZxFL0kjZ9FL0shZ9JI0cssu+iQbk2zsM4wkqXutRZ/kRUluBG4AbkxyQ5IX9R9NktSFJYs+ySuBJwFHVtUDqmo34I+AJzbHJEkD13ZG/6fAU6vq63M7mvEzgOf2GUyS1I22oq+q+ukCO38C/LKfSJKkLrUV/c1Jjpq/M8ljgW/3E0mS1KW2WwmeCHw8yX8BFzf7tgJHAE/pM5gkqRtLntFX1ZXAQcAXgM3NxxeAg5pjkqSBW/KMPsmnq+rxwDvXKI8kqWNtc/R7rEkKSVJv2uboNyV56mIHq+ojHeeRJHWsteiZ/MJUFjhWwLKKPskrgGcDdzO5LPOFVXXhCnJKku6ltqK/oaqet5onSHI4k28Wh1XVz5LsDmy/mseUJC1f2xz9QmfykwPJQ5b5HHsB36uqnwFU1feq6lvL/LuSpFVqXQIhyeFJnpZkT4AkD0/yPuCLy3yOTwP7Jrkmyb8kecxCn5TkhCTbkmy7+8e3L/8rkCQtqa3oj2dyaeUfA59I8vdMivtC4KHLeYKq+l/gEcAJwK3AB5L82QKf99aq2lpVWzfcb9PyvwJJ0pLa5uiPAQ6tqp8muT/wTSa/LHX9Sp6kqu4GLgAuSHI5k28g715xWknSirWd0f90blGzqvohcO1KSz7JAUmmz/4PYbK2vSRpDbSd0e+f5Nyp7S3T21V17DKeYyPwhiS7AncB1zGZxpEkrYG2op+/cNnrVvoEVXUx8Acr/XuSpG60Ff0lVXXHQgdWcHmlJGkdtc3RXzA3SHL+vGMf6zyNJKlzK/mFqd2WOCZJGqjWWwkuMl5oW5I0QG1z9HsmOZnJ2fvcmGbbJYwlaQa0Ff3bgJ0XGAO8vZdEkqROLVn0VfXqtQoiSerHknP0SXZIcnySYzNxSpLzkpzRLDcsSRq4tjdjzwYeDzyPyaWW+wFvBO7EtWokaSa0zdEfWFUHJdkOuKmq5pYY/mSSy3rOJknqQNsZ/c8BquouYP7NQu7uJZEkqVNtZ/T7JDmTyeWUc2Oa7b17TSZJ6kRb0b9sarxt3rH525KkAWq7vPKshfYn2QF4ci+JJEmdapujv0eSDUmOTvIeJjcOeWZ/sSRJXWmbuqG5mfezgaOBi4AjgC1V9eOes0mSOrBk0Se5CbgReDPw0qq6M8k3LHlJmh1tUzfnAA9mMk3z5CQ74aqVkjRTliz6qjoJ2MLkFoJHAlcDeyR5RpKN/ceTJK1W65uxNfH5qjqBSekfx+Restf3nE2S1IFlX3UDUFW/qKrzquo5wL5z+5N8uPNkkqROtF51s5iq+snU5v4dZLnHwXtvYtvpx3T5kJL0G2tFZ/RL8A1aSRqoropekjRQXRV9OnocSVLH2u4wtcsSxx4ytfnyzhJJkjrVdkZ/wdwgyfnzjn1sblBVn+4wkySpQ21FPz0ls9sSxyRJA9VW9LXIeKFtSdIAtV1Hv2eSk5mcvc+Nabb36DWZJKkTbUX/NmDnBcYAb+8lkSSpU213mHr1YsealSwlSQPXeh19kr2TbE2yfbO9Z5LXANf2nk6StGpt19GfBFwKvAH47yQvAK4CdgQe0X88SdJqtc3RnwAcUFU/aH5B6hrgiKq6uP9okqQutE3d/LSqfgBQVTcCV1vykjRb2s7o90ly5tT2XtPbVXViP7EkSV1pK/qXzdv2bF6SZkzb5ZVnJdkD2A+4rqpuW5tYkqSutF118wLgSiZX3Xw1ybFrkkqS1Jm2qZuTgIdV1a1J9gfeC5zbfyxJUlfarrr5eVXdClBVXwfu238kSVKXVnrVzT5edSNJs8WrbiRp5FqvulmrIJKkfixZ9EmWfOO1qrwKR5IGrm3q5nDgm8D7gQvx9oGSNHPaiv5BwOOA44BnA58A3l9VV/YdTJLUjSUvr6yqu6vqk1V1PPBI4DrggiQvXpN0kqRVazujJ8l9gWOYnNVvBs4EPtpvLElSV9rejD0bOAj4d+DVVXXFmqSSJHWm7Yz+T4AfAS8BTkzueS82QFXVLj1mkyR1oO06+tZ7ykqShq1t9crHTo23zDv21L5CSZK603bG/tqp8YfnHXtlx1kkST1oK/osMl5oW5I0QG1FX4uMF9qWJA1Q21U3+zfr3WRqTLO9ZfG/Jkkairaif8rU+LXzjs3fliQNUNvllf85vZ3kPkx+germqrqlz2CSpG60XV75liQPa8abgMuAs4FLkhy3BvkkSavU9mbsH06tVPnnwDVVdTDwCOCUXpNJkjrRenPwqfHjgI8BVNV3ekskSepUW9HfluRJSQ4FjgA+CZBkO2DHvsNJklav7aqbFzJZlvhBwElTZ/JHMbkJiSRp4NquurkGeMIC+z8FfGpuO8lpVfUP3ceTJK1WV6tTPr2jx5EkdayronfdG0kaqK6K3nVvJGmgPKOXpJHrqug/1NHjSJI61rYEwg5Jjk9ybCZenuS8JGck2X3u86rqNf1HlSTdG21n9GcDjweeB1wAPAR4I3An8O4+g0mSutH2C1MHVtVBzW/C3lRVj2n2fzLJZT1nkyR1YFlr3VTVXcC35h27u5dEkqROtZ3R75PkTCZX1cyNabb37ivU5TffzuZTXWFB0m+O608/prfHbiv6l02Nt807Nn9bkjRAbWvdnLXQ/iQ7AE/uJZEkqVPLvo4+yYYkRyd5D3AD8Mz+YkmSutI2dUOSxwDPBo4GLmKyLv2Wqvpxz9kkSR1YsuiT3ATcCLwZeGlV3ZnkG5a8JM2Otqmbc4AHM5mmeXKSnXABM0maKUsWfVWdBGwBXgccCVwN7JHkGUk29h9PkrRabWvdvLgmPl9VJzAp/eOApwDXr0E+SdIqtU3dPG96o6p+UVXnVdVzgH37iyVJ6sq9Xqa4qn7SZRBJUj/aLq98eJI7FtgfoKpqlx4ySZI61Fb0l1fVoWuSRJLUi67uMCVJGqi2ovcWgZI049qK/tYkDwVobiX4riR3JPlyksPWIJ8kaZXaiv4l/Op6+eOAhzO5lv5k4Iz+YkmSutJW9HdV1S+a8ZOAs6vq+1X1WWCnfqNJkrrQVvS/TLJXs/78UcBnp47t2F8sSVJX2i6vfBWTO0ltAM6tqivhnqWLv95zNklSB9ruMHVekv2Anavqh1OHtuGNRyRpJrQtanZKVd1VVT9M8vS5/VX1I+Bvek8nSVq1tjn6Z02NT5t37AkdZ5Ek9aCt6LPIeKFtSdIAtRV9LTJeaPvXJKkkr5vafmmSv11+PEnSarUV/e82vwl7J81KllPbBy/j8X8GPDXJ7qtOKkm6V9puJbihqnapqp2rartmPLd9n7nPS3L/RR7iLuCtwF93mFmStAJdrV55/hLH3gQ8J8mmpR4gyQlJtiXZdvePb+8oliSpq6Jf9I3ZqroDOBs4cakHqKq3VtXWqtq64X5Lfk+QJK1AV0Xf9sbs64Hn4/o4krTm1uTGI1X1A+CDTMpekrSGep+6mfI6wKtvJGmNLbnWTbNq5V8Avw1cDryjqu5a4FOPWujvV9XGqfF3gfvd+6iSpHuj7Yz+LGArk5J/IpOz8l/TTM1IkgaobZniA6vqYIAk7wAu6j+SJKlLbWf0c3eXYpEpG0nSwLWd0R+S5I5mHGDHZjtAVdUuvaaTJK1aW9FfVlWHrkkSSVIvVrJ6pSRpBrWd0e+Z5OTFDlbVP3ecR5LUsbai3wBsxJuMSNLMaiv6b1fV361JEklSL1ZyK0FJ0gxqK/oFlzaQJM2OtjtMubSBJM24NVmmWJK0fix6SRo5i16SRs6il6SRs+glaeQsekkaOYtekkbOopekkbPoJWnkLHpJGrm21SvXxcF7b2Lb6cesdwxJGgXP6CVp5Cx6SRo5i16SRs6il6SRs+glaeQsekkaOYtekkbOopekkbPoJWnkLHpJGjmLXpJGzqKXpJGz6CVp5Cx6SRo5i16SRs6il6SRs+glaeQsekkaOYtekkbOopekkbPoJWnkLHpJGjmLXpJGzqKXpJGz6CVp5Cx6SRq5VNV6Z/g1Se4Erl7vHMu0O/C99Q6xTLOUFWYr7yxlhdnKO0tZYf3y7ldVeyx0YLu1TrJMV1fV1vUOsRxJtpm1H7OUd5aywmzlnaWsMMy8Tt1I0shZ9JI0ckMt+reud4AVMGt/ZinvLGWF2co7S1lhgHkH+WasJKk7Qz2jlyR1xKKXpJEbVNEneUKSq5Ncl+TU9c4DkOSdSW5JcsXUvt2SfCbJtc2f92/2J8mZTf4vJzlsjbPum+TzSb6S5MokLxlq3iQ7JLkoyWVN1lc3+7ckubDJ9IEk2zf779tsX9cc37xWWacyb0hySZLzZiDr9UkuT3Jpkm3NvsG9Dqby7prknCRfTXJVksOHmDfJAc2/6dzHHUlOGmLW/6eqBvEBbAC+BuwPbA9cBhw4gFyPBg4Drpja90/Aqc34VOAfm/HRwH8AAR4JXLjGWfcCDmvGOwPXAAcOMW/znBub8X2AC5sMHwSe1ex/C/CXzfhFwFua8bOAD6zDa+Fk4H3Aec32kLNeD+w+b9/gXgdT2c4CXtCMtwd2HXLeJscG4DvAfoPPuh5Pusg/2uHAp6a2TwNOW+9cTZbN84r+amCvZrwXk1/wAvhX4LiFPm+dcn8ceNzQ8wL3A74E/D6T3yjcbv5rAvgUcHgz3q75vKxhxn2A84HHAuc1/3EHmbV53oWKfpCvA2AT8I35/0ZDzTv1vI8HvjgLWYc0dbM38M2p7ZuafUP0wKr6djP+DvDAZjyYr6GZLjiUyZnyIPM2UyGXArcAn2HyE91tVXXXAnnuydocvx14wFplBV4PnAL8stl+AMPNClDAp5NcnOSEZt8gXwfAFuBW4F3N1Njbk+zEcPPOeRbw/mY86KxDKvqZVJNv04O6RjXJRuDDwElVdcf0sSHlraq7q+oQJmfLvwf8zjpHWlCSJwG3VNXF651lBR5VVYcBTwT+Ksmjpw8O6XXA5Keew4A3V9WhwI+YTH/cY2B5ad6PORb40PxjQ8sKwyr6m4F9p7b3afYN0XeT7AXQ/HlLs3/dv4Yk92FS8u+tqo80uwebF6CqbgM+z2T6Y9ckc2swTee5J2tzfBPw/TWKeARwbJLrgX9jMn1zxkCzAlBVNzd/3gJ8lMk30qG+Dm4CbqqqC5vtc5gU/1DzwuQb6Jeq6rvN9pCzDqro/wd4aHMlw/ZMfiw6d50zLeZc4PhmfDyTufC5/c9t3ml/JHD71I9zvUsS4B3AVVX1z0POm2SPJLs24x2ZvJdwFZPCf9oiWee+hqcBn2vOnHpXVadV1T5VtZnJ6/JzVfWcIWYFSLJTkp3nxkzmkq9ggK8DgKr6DvDNJAc0u44CvjLUvI3j+NW0zVymoWYdzpuxzf+Do5lcKfI14BXrnafJ9H7g28AvmJx5PJ/JfOv5wLXAZ4Hdms8N8KYm/+XA1jXO+igmPzJ+Gbi0+Th6iHmBhwOXNFmvAF7V7N8fuAi4jsmPxfdt9u/QbF/XHN9/nV4PR/Krq24GmbXJdVnzceXc/6Uhvg6mMh8CbGteDx8D7j/UvMBOTH5C2zS1b5BZ5z5cAkGSRm5IUzeSpB5Y9JI0cha9JI2cRS9JI2fRS9LIWfSSNHIWvSSN3P8Bm1YFphtPpbAAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "UzAtU35Clrs6",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 85
        },
        "outputId": "498e88f7-4fd6-42eb-cd9a-f3165b37316f"
      },
      "source": [
        "indigena['TP_GESTAO'].value_counts()"
      ],
      "execution_count": 156,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "M    1145\n",
              "D       2\n",
              "E       1\n",
              "Name: TP_GESTAO, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 156
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ofCxOFuzPdTv",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 439
        },
        "outputId": "6aaad2ab-f895-4dca-ca01-5b24c8a292ad"
      },
      "source": [
        "#idem para barcos hospitais\n",
        "barcos = cnes_red[cnes_red['cod_unidades'] == 32]\n",
        "barcos"
      ],
      "execution_count": 158,
      "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>CO_UNIDADE</th>\n",
              "      <th>CO_CNES</th>\n",
              "      <th>CO_REGIAO_SAUDE</th>\n",
              "      <th>CO_ATIVIDADE</th>\n",
              "      <th>cod_unidades</th>\n",
              "      <th>CO_TURNO_ATENDIMENTO</th>\n",
              "      <th>CO_MUNICIPIO_GESTOR</th>\n",
              "      <th>TP_ESTAB_SEMPRE_ABERTO</th>\n",
              "      <th>TP_GESTAO</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>818</th>\n",
              "      <td>1501407383436</td>\n",
              "      <td>7383436</td>\n",
              "      <td>001</td>\n",
              "      <td>4</td>\n",
              "      <td>32</td>\n",
              "      <td>4.0</td>\n",
              "      <td>150140</td>\n",
              "      <td>NaN</td>\n",
              "      <td>E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1107</th>\n",
              "      <td>1503305293251</td>\n",
              "      <td>5293251</td>\n",
              "      <td>006</td>\n",
              "      <td>4</td>\n",
              "      <td>32</td>\n",
              "      <td>3.0</td>\n",
              "      <td>150330</td>\n",
              "      <td>N</td>\n",
              "      <td>M</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6420</th>\n",
              "      <td>1505807167288</td>\n",
              "      <td>7167288</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "      <td>32</td>\n",
              "      <td>3.0</td>\n",
              "      <td>150580</td>\n",
              "      <td>N</td>\n",
              "      <td>M</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6954</th>\n",
              "      <td>1302609222537</td>\n",
              "      <td>9222537</td>\n",
              "      <td>001</td>\n",
              "      <td>4</td>\n",
              "      <td>32</td>\n",
              "      <td>3.0</td>\n",
              "      <td>130260</td>\n",
              "      <td>N</td>\n",
              "      <td>E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7271</th>\n",
              "      <td>1303909184694</td>\n",
              "      <td>9184694</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "      <td>32</td>\n",
              "      <td>5.0</td>\n",
              "      <td>130390</td>\n",
              "      <td>N</td>\n",
              "      <td>M</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>359446</th>\n",
              "      <td>1304209503307</td>\n",
              "      <td>9503307</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "      <td>32</td>\n",
              "      <td>5.0</td>\n",
              "      <td>130420</td>\n",
              "      <td>N</td>\n",
              "      <td>M</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>360983</th>\n",
              "      <td>1302409451862</td>\n",
              "      <td>9451862</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "      <td>32</td>\n",
              "      <td>4.0</td>\n",
              "      <td>130240</td>\n",
              "      <td>N</td>\n",
              "      <td>M</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>364003</th>\n",
              "      <td>1302609222553</td>\n",
              "      <td>9222553</td>\n",
              "      <td>001</td>\n",
              "      <td>4</td>\n",
              "      <td>32</td>\n",
              "      <td>3.0</td>\n",
              "      <td>130260</td>\n",
              "      <td>N</td>\n",
              "      <td>E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>364555</th>\n",
              "      <td>1301959312544</td>\n",
              "      <td>9312544</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "      <td>32</td>\n",
              "      <td>3.0</td>\n",
              "      <td>130195</td>\n",
              "      <td>N</td>\n",
              "      <td>M</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>364556</th>\n",
              "      <td>1500109294805</td>\n",
              "      <td>9294805</td>\n",
              "      <td>6</td>\n",
              "      <td>4</td>\n",
              "      <td>32</td>\n",
              "      <td>3.0</td>\n",
              "      <td>150010</td>\n",
              "      <td>N</td>\n",
              "      <td>M</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>63 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "           CO_UNIDADE  CO_CNES  ... TP_ESTAB_SEMPRE_ABERTO  TP_GESTAO\n",
              "818     1501407383436  7383436  ...                    NaN          E\n",
              "1107    1503305293251  5293251  ...                      N          M\n",
              "6420    1505807167288  7167288  ...                      N          M\n",
              "6954    1302609222537  9222537  ...                      N          E\n",
              "7271    1303909184694  9184694  ...                      N          M\n",
              "...               ...      ...  ...                    ...        ...\n",
              "359446  1304209503307  9503307  ...                      N          M\n",
              "360983  1302409451862  9451862  ...                      N          M\n",
              "364003  1302609222553  9222553  ...                      N          E\n",
              "364555  1301959312544  9312544  ...                      N          M\n",
              "364556  1500109294805  9294805  ...                      N          M\n",
              "\n",
              "[63 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 158
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4IqdoT1hPdj0",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 282
        },
        "outputId": "9b34da85-17d4-4c15-f69c-fa7f1f2876f9"
      },
      "source": [
        "barco['TP_GESTAO'].value_counts().sort_values(ascending=False).plot(kind='barh')"
      ],
      "execution_count": 159,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7feeb5bc2588>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 159
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAWwAAAD4CAYAAADIH9xYAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAJCElEQVR4nO3dX6jneV3H8de7Of5Z/7Dm7iaya53ChVjSNlhEyYt1QdkayS4iFQMvgr3pwqCIqRspECaI0sCbJRcF/6yiWYuKuOhKXW2eya2xbEljJQdzktrVMgy3dxe/r3QaZnbn6PnuOe/feTzgcH7fz/z4fT8f5nue58vnnN9MdXcAOP5+6KgnAMDVEWyAIQQbYAjBBhhCsAGG2Fnzxa+//vre3d1d8xQAW+fcuXPf6O4bLh1fNdi7u7vZ29tb8xQAW6eqvnK5cVsiAEMINsAQgg0whGADDCHYAEMINsAQgg0whGADDCHYAEMINsAQgg0whGADDCHYAEMINsAQgg0whGADDCHYAEMINsAQgg0whGADDCHYAEMINsAQgg0whGADDCHYAEMINsAQO2u++PkLj2X3zMfXPMUYj5w9fdRTAIZzhw0whGADDCHYAEMINsAQgg0whGADDCHYAEMINsAQgg0whGADDCHYAEMINsAQgg0whGADDCHYAEMINsAQgg0whGADDCHYAEMINsAQgg0whGADDCHYAEPsHOTJVfV4kvP7hu7t7rOHOyUALudAwU7yX9196yozAeAJ2RIBGOKgwb6mqh7a9/H6S59QVXdV1V5V7T3+7ccOaZoAHPqWSHffneTuJHnGC2/u73diAPx/tkQAhhBsgCEOuiVyTVU9tO/4k9195jAnBMDlHSjY3X1qrYkA8MRsiQAMIdgAQwg2wBCCDTCEYAMMIdgAQwg2wBCCDTCEYAMMIdgAQwg2wBCCDTCEYAMMIdgAQwg2wBCCDTCEYAMMIdgAQwg2wBCCDTCEYAMMcaD/Nf2gXnLjtdk7e3rNUwCcGO6wAYYQbIAhBBtgCMEGGEKwAYYQbIAhBBtgCMEGGEKwAYYQbIAhBBtgCMEGGEKwAYYQbIAhBBtgCMEGGEKwAYYQbIAhBBtgCMEGGEKwAYYQbIAhBBtgCMEGGEKwAYYQbIAhBBtgCMEGGEKwAYYQbIAhBBtgCMEGGEKwAYYQbIAhBBtgCMEGGEKwAYYQbIAhBBtgCMEGGEKwAYYQbIAhBBtgCMEGGEKwAYYQbIAhBBtgCMEGGEKwAYYQbIAhBBtgCMEGGEKwAYbYWfPFz194LLtnPr7mKQCOnUfOnl7ldd1hAwwh2ABDCDbAEIINMIRgAwwh2ABDCDbAEIINMIRgAwwh2ABDCDbAEIINMIRgAwwh2ABDCDbAEIINMIRgAwwh2ABDCDbAEIINMIRgAwwh2ABDCDbAEE8a7KrqqnrvvuOdqvrXqvrYulMDYL+rucP+zyQ/VVXXLMevTnJhvSkBcDlXuyXyiSSnl8dvTPKBdaYDwJVcbbDvTfKGqnpmkpcmefBKT6yqu6pqr6r2Hv/2Y4cxRwBylcHu7r9NspvN3fUnnuS5d3f3bd1926lnXfuDzxCAJMnOAZ57X5I/SHJ7kutWmQ0AV3SQYN+T5NHuPl9Vt680HwCu4KqD3d1fTfLHK84FgCfwpMHu7udcZuyzST67wnwAuALvdAQYQrABhhBsgCEEG2AIwQYYQrABhhBsgCEEG2AIwQYYQrABhhBsgCEEG2AIwQYYQrABhhBsgCEEG2AIwQYYQrABhhBsgCEEG2AIwQYYQrABhthZ88VfcuO12Tt7es1TAJwY7rABhhBsgCEEG2AIwQYYQrABhhBsgCEEG2AIwQYYQrABhhBsgCEEG2AIwQYYQrABhhBsgCEEG2AIwQYYQrABhhBsgCEEG2AIwQYYQrABhhBsgCEEG2AIwQYYQrABhhBsgCGqu9d78apvJXl4tRMcT9cn+cZRT+IpdhLXnJzMdVvzU+PHuvuGSwd3Vj7pw91928rnOFaqas+aT4aTuG5rPlq2RACGEGyAIdYO9t0rv/5xZM0nx0lctzUfoVV/6AjA4bElAjCEYAMMsUqwq+rOqnq4qr5UVWfWOMdxUFX3VNXFqvrCvrHnV9X9VfWPy+cfPso5HraqelFVPVBVf19Vf1dVb1nGt3bdVfXMqvqrqvqbZc2/u4z/eFU9uFznH6yqpx/1XA9bVZ2qqs9X1ceW45Ow5keq6nxVPVRVe8vYsbi+Dz3YVXUqyTuT/FySW5K8sapuOezzHBPvTnLnJWNnkny6u29O8unleJt8N8lvdPctSV6e5NeWv99tXvd3ktzR3T+d5NYkd1bVy5P8fpI/6u4XJ/n3JL96hHNcy1uSfHHf8UlYc5K8qrtv3ff718fi+l7jDvtlSb7U3f/U3f+d5N4kr1vhPEeuu/8iyb9dMvy6JO9ZHr8nyS8+pZNaWXd/rbv/enn8rWy+mG/MFq+7N/5jOXza8tFJ7kjy4WV8q9acJFV1U5LTSf5kOa5s+ZqfwLG4vtcI9o1J/nnf8VeXsZPiBd39teXxvyR5wVFOZk1VtZvkZ5I8mC1f97I18FCSi0nuT/LlJI9293eXp2zjdf72JL+V5H+W4+uy/WtONt+MP1VV56rqrmXsWFzfa781/UTr7q6qrfy9yap6TpKPJPn17v7m5uZrYxvX3d2PJ7m1qp6X5KNJfvKIp7Sqqnptkovdfa6qbj/q+TzFXtndF6rqR5LcX1X/sP8Pj/L6XuMO+0KSF+07vmkZOym+XlUvTJLl88Ujns+hq6qnZRPr93X3ny7DW7/uJOnuR5M8kOQVSZ5XVd+76dm26/xnk/xCVT2SzbbmHUneke1ec5Kkuy8sny9m8835ZTkm1/cawf5ckpuXnyY/Pckbkty3wnmOq/uSvHl5/OYkf36Eczl0yz7mu5J8sbv/cN8fbe26q+qG5c46VXVNkldns3f/QJJfWp62VWvu7t/u7pu6ezebr+HPdPebssVrTpKqenZVPfd7j5O8JskXckyu71Xe6VhVP5/N/tepJPd099sO/STHQFV9IMnt2fzzi19P8tYkf5bkQ0l+NMlXkvxyd1/6g8mxquqVSf4yyfn8397m72Szj72V666ql2bzg6ZT2dzkfKi7f6+qfiKbu8/nJ/l8kl/p7u8c3UzXsWyJ/GZ3v3bb17ys76PL4U6S93f326rquhyD69tb0wGG8E5HgCEEG2AIwQYYQrABhhBsgCEEG2AIwQYY4n8BIEbmVs5+q+gAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "G6xP6rUIoBWp",
        "colab_type": "text"
      },
      "source": [
        "É fácil filtrar para saber a qtd de unidades de saúde por tipo de atendimento."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "hrwIx8ifTvzv",
        "colab_type": "text"
      },
      "source": [
        "Merged dos datasets cnes_red e codigo_atividade"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "D5vVRDmET8jU",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 85
        },
        "outputId": "1105cb6d-201e-4621-d5a8-44001694eaa2"
      },
      "source": [
        "#Lembrando as colunas de ambos\n",
        "cnes_red.columns"
      ],
      "execution_count": 165,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['CO_UNIDADE', 'CO_CNES', 'CO_REGIAO_SAUDE', 'CO_ATIVIDADE',\n",
              "       'cod_unidades', 'CO_TURNO_ATENDIMENTO', 'CO_MUNICIPIO_GESTOR',\n",
              "       'TP_ESTAB_SEMPRE_ABERTO', 'TP_GESTAO'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 165
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "kM-B9C7hT8Ts",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "a3573b79-a3f0-46ae-8490-577c3c707fce"
      },
      "source": [
        "codigo_atividade.columns"
      ],
      "execution_count": 166,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['cod_unidades', 'descricao'], dtype='object')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 166
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "oC2NavOUT8GH",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 394
        },
        "outputId": "531447c0-3684-4b96-ce6a-70b6314a90f4"
      },
      "source": [
        "\n",
        "\n",
        "df_cnes = pd.merge(cnes_red, codigo_atividade, on='cod_unidades')\n",
        "df_cnes.head()"
      ],
      "execution_count": 167,
      "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>CO_UNIDADE</th>\n",
              "      <th>CO_CNES</th>\n",
              "      <th>CO_REGIAO_SAUDE</th>\n",
              "      <th>CO_ATIVIDADE</th>\n",
              "      <th>cod_unidades</th>\n",
              "      <th>CO_TURNO_ATENDIMENTO</th>\n",
              "      <th>CO_MUNICIPIO_GESTOR</th>\n",
              "      <th>TP_ESTAB_SEMPRE_ABERTO</th>\n",
              "      <th>TP_GESTAO</th>\n",
              "      <th>descricao</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2928707453280</td>\n",
              "      <td>7453280</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>1</td>\n",
              "      <td>4.0</td>\n",
              "      <td>292870</td>\n",
              "      <td>NaN</td>\n",
              "      <td>M</td>\n",
              "      <td>POSTO DE SAUDE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2202707466803</td>\n",
              "      <td>7466803</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "      <td>1</td>\n",
              "      <td>4.0</td>\n",
              "      <td>220270</td>\n",
              "      <td>N</td>\n",
              "      <td>M</td>\n",
              "      <td>POSTO DE SAUDE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3106207467591</td>\n",
              "      <td>7467591</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "      <td>1</td>\n",
              "      <td>3.0</td>\n",
              "      <td>310620</td>\n",
              "      <td>NaN</td>\n",
              "      <td>M</td>\n",
              "      <td>POSTO DE SAUDE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3161107465823</td>\n",
              "      <td>7465823</td>\n",
              "      <td>030</td>\n",
              "      <td>4</td>\n",
              "      <td>1</td>\n",
              "      <td>3.0</td>\n",
              "      <td>316110</td>\n",
              "      <td>NaN</td>\n",
              "      <td>M</td>\n",
              "      <td>POSTO DE SAUDE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>3504907462484</td>\n",
              "      <td>7462484</td>\n",
              "      <td>17</td>\n",
              "      <td>4</td>\n",
              "      <td>1</td>\n",
              "      <td>3.0</td>\n",
              "      <td>350490</td>\n",
              "      <td>N</td>\n",
              "      <td>M</td>\n",
              "      <td>POSTO DE SAUDE</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      CO_UNIDADE  CO_CNES  ... TP_GESTAO       descricao\n",
              "0  2928707453280  7453280  ...         M  POSTO DE SAUDE\n",
              "1  2202707466803  7466803  ...         M  POSTO DE SAUDE\n",
              "2  3106207467591  7467591  ...         M  POSTO DE SAUDE\n",
              "3  3161107465823  7465823  ...         M  POSTO DE SAUDE\n",
              "4  3504907462484  7462484  ...         M  POSTO DE SAUDE\n",
              "\n",
              "[5 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 167
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "XAtRTFs6T76P",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 306
        },
        "outputId": "928dea88-c81c-4c30-df82-fba9b4cbd35e"
      },
      "source": [
        "df_cnes.info()"
      ],
      "execution_count": 168,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Int64Index: 364562 entries, 0 to 364561\n",
            "Data columns (total 10 columns):\n",
            " #   Column                  Non-Null Count   Dtype  \n",
            "---  ------                  --------------   -----  \n",
            " 0   CO_UNIDADE              364562 non-null  object \n",
            " 1   CO_CNES                 364562 non-null  int64  \n",
            " 2   CO_REGIAO_SAUDE         192370 non-null  object \n",
            " 3   CO_ATIVIDADE            364562 non-null  int64  \n",
            " 4   cod_unidades            364562 non-null  int64  \n",
            " 5   CO_TURNO_ATENDIMENTO    363867 non-null  float64\n",
            " 6   CO_MUNICIPIO_GESTOR     364562 non-null  int64  \n",
            " 7   TP_ESTAB_SEMPRE_ABERTO  198781 non-null  object \n",
            " 8   TP_GESTAO               364562 non-null  object \n",
            " 9   descricao               364562 non-null  object \n",
            "dtypes: float64(1), int64(4), object(5)\n",
            "memory usage: 30.6+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7kJCU1-bVzn-",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 646
        },
        "outputId": "846fa775-ea95-4605-dcf3-d9b0ffdcc1e2"
      },
      "source": [
        "df_cnes['descricao'].value_counts()"
      ],
      "execution_count": 171,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "CONSULTORIO ISOLADO                                             180265\n",
              "CLINICA/CENTRO DE ESPECIALIDADE                                  55028\n",
              "CENTRO DE SAUDE/UNIDADE BASICA                                   39253\n",
              "UNIDADE DE APOIO DIAGNOSE E TERAPIA (SADT ISOLADO)               27822\n",
              "POSTO DE SAUDE                                                   11328\n",
              "POLICLINICA                                                       8770\n",
              "CENTRAL DE GESTAO EM SAUDE                                        6145\n",
              "HOSPITAL GERAL                                                    5795\n",
              "UNIDADE MOVEL DE NIVEL PRE-HOSPITALAR NA AREA DE URGENCIA         4769\n",
              "FARMACIA                                                          3573\n",
              "CENTRO DE ATENCAO PSICOSSOCIAL                                    3100\n",
              "UNIDADE DE VIGILANCIA EM SAUDE                                    3048\n",
              "POLO ACADEMIA DA SAUDE                                            2635\n",
              "UNIDADE MOVEL TERRESTRE                                           1497\n",
              "CENTRAL DE REGULACAO DO ACESSO                                    1304\n",
              "PRONTO ATENDIMENTO                                                1284\n",
              "HOSPITAL ESPECIALIZADO                                            1245\n",
              "CENTRO DE APOIO A SAUDE DA FAMILIA                                1200\n",
              "UNIDADE DE ATENCAO A SAUDE INDIGENA                               1148\n",
              "SERVICO DE ATENCAO DOMICILIAR ISOLADO(HOME CARE)                   750\n",
              "HOSPITAL/DIA � ISOLADO                                             731\n",
              "UNIDADE MISTA                                                      703\n",
              "COOPERATIVA OU EMPRESA DE CESSAO DE TRABALHADORES NA SAUDE         695\n",
              "PRONTO SOCORRO GERAL                                               448\n",
              "LABORATORIO DE SAUDE PUBLICA                                       447\n",
              "CENTRO DE ATENCAO HEMOTERAPIA E OU HEMATOLOGICA                    409\n",
              "POLO DE PREVENCAO DE DOENCAS E AGRAVOS E PROMOCAO DA SAUDE         373\n",
              "CENTRAL DE REGULACAO MEDICA DAS URGENCIAS                          238\n",
              "CENTRAL DE NOTIFICACAO,CAPTACAO E DISTRIB DE ORGAOS ESTADUAL       139\n",
              "PRONTO SOCORRO ESPECIALIZADO                                       127\n",
              "TELESSAUDE                                                          89\n",
              "UNIDADE MOVEL FLUVIAL                                               63\n",
              "UNIDADE DE ATENCAO EM REGIME RESIDENCIAL                            39\n",
              "LABORATORIO CENTRAL DE SAUDE PUBLICA LACEN                          38\n",
              "CENTRO DE PARTO NORMAL � ISOLADO                                    33\n",
              "OFICINA ORTOPEDICA                                                  31\n",
              "Name: descricao, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 171
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "HmY4sPq-V2fc",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 238
        },
        "outputId": "3148e2d1-c1b6-430b-d6e3-a66540aab43f"
      },
      "source": [
        "df_cnes.groupby('descricao')['CO_CNES'].value_counts()"
      ],
      "execution_count": 175,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "descricao                   CO_CNES\n",
              "CENTRAL DE GESTAO EM SAUDE  14117      1\n",
              "                            16608      1\n",
              "                            17620      1\n",
              "                            22012      1\n",
              "                            24309      1\n",
              "                                      ..\n",
              "UNIDADE MOVEL TERRESTRE     9614478    1\n",
              "                            9615148    1\n",
              "                            9617418    1\n",
              "                            9622136    1\n",
              "                            9624961    1\n",
              "Name: CO_CNES, Length: 364562, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 175
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Zd9t8vxrQ-Nx",
        "colab_type": "text"
      },
      "source": [
        "Agora vamos focar na atenção especializada e ver quantos leitos existiam no Brasil em outubro 2018(data dos dados)"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fjIwKx1Goi0t",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 224
        },
        "outputId": "5f9043da-de0b-471b-b4ea-23fbb5522752"
      },
      "source": [
        "leitos = pd.read_csv('/content/drive/My Drive/SUS_DADOS/Cópia de rlEstabComplementar201809.csv', sep=';', encoding='Latin-1',\n",
        "                   error_bad_lines=False, quotechar='\"', low_memory=False)\n",
        "leitos.head()"
      ],
      "execution_count": 176,
      "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>CO_UNIDADE</th>\n",
              "      <th>CO_LEITO</th>\n",
              "      <th>CO_TIPO_LEITO</th>\n",
              "      <th>TP_ALTACOMP</th>\n",
              "      <th>QT_EXIST</th>\n",
              "      <th>QT_CONTR</th>\n",
              "      <th>QT_SUS</th>\n",
              "      <th>TO_CHAR(DT_ATUALIZACAO,'DD/MM/YYYY')</th>\n",
              "      <th>CO_USUARIO</th>\n",
              "      <th>TO_CHAR(DT_ATUALIZACAO_ORIGEM,'DD/MM/YYYY')</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>5208006587518</td>\n",
              "      <td>32</td>\n",
              "      <td>2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>11/06/2013</td>\n",
              "      <td>SMSFSA</td>\n",
              "      <td>10/09/2010</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>5208006587518</td>\n",
              "      <td>42</td>\n",
              "      <td>2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>11/06/2013</td>\n",
              "      <td>SMSFSA</td>\n",
              "      <td>10/09/2010</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>5208006587518</td>\n",
              "      <td>45</td>\n",
              "      <td>5</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>11/06/2013</td>\n",
              "      <td>SMSFSA</td>\n",
              "      <td>10/09/2010</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>5208006587518</td>\n",
              "      <td>48</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>11/06/2013</td>\n",
              "      <td>SMSFSA</td>\n",
              "      <td>10/09/2010</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>3552202708566</td>\n",
              "      <td>81</td>\n",
              "      <td>3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>27/07/2018</td>\n",
              "      <td>NLIMA</td>\n",
              "      <td>23/03/2013</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      CO_UNIDADE  ...  TO_CHAR(DT_ATUALIZACAO_ORIGEM,'DD/MM/YYYY')\n",
              "0  5208006587518  ...                                   10/09/2010\n",
              "1  5208006587518  ...                                   10/09/2010\n",
              "2  5208006587518  ...                                   10/09/2010\n",
              "3  5208006587518  ...                                   10/09/2010\n",
              "4  3552202708566  ...                                   23/03/2013\n",
              "\n",
              "[5 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 176
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_kcT7T-6qsLO",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 187
        },
        "outputId": "0f8bcad1-4f2f-483a-e668-b054fa0af9cc"
      },
      "source": [
        "leitos.columns.tolist()"
      ],
      "execution_count": 177,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['CO_UNIDADE',\n",
              " 'CO_LEITO',\n",
              " 'CO_TIPO_LEITO',\n",
              " 'TP_ALTACOMP',\n",
              " 'QT_EXIST',\n",
              " 'QT_CONTR',\n",
              " 'QT_SUS',\n",
              " \"TO_CHAR(DT_ATUALIZACAO,'DD/MM/YYYY')\",\n",
              " 'CO_USUARIO',\n",
              " \"TO_CHAR(DT_ATUALIZACAO_ORIGEM,'DD/MM/YYYY')\"]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 177
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YyDkhDrVYcyg",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "outputId": "e1f034eb-25e1-45e5-80c2-ae08a035c439"
      },
      "source": [
        "leitos = leitos[['CO_UNIDADE','CO_LEITO','QT_EXIST', 'QT_CONTR', 'QT_SUS']]\n",
        "leitos.head()"
      ],
      "execution_count": 186,
      "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>CO_UNIDADE</th>\n",
              "      <th>CO_LEITO</th>\n",
              "      <th>QT_EXIST</th>\n",
              "      <th>QT_CONTR</th>\n",
              "      <th>QT_SUS</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>5208006587518</td>\n",
              "      <td>32</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>5208006587518</td>\n",
              "      <td>42</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>5208006587518</td>\n",
              "      <td>45</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>5208006587518</td>\n",
              "      <td>48</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>3552202708566</td>\n",
              "      <td>81</td>\n",
              "      <td>9</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      CO_UNIDADE  CO_LEITO  QT_EXIST  QT_CONTR  QT_SUS\n",
              "0  5208006587518        32         1       NaN       0\n",
              "1  5208006587518        42         1       NaN       0\n",
              "2  5208006587518        45         1       NaN       0\n",
              "3  5208006587518        48         1       NaN       0\n",
              "4  3552202708566        81         9       NaN       0"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 186
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "AuY_HLImq057",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 221
        },
        "outputId": "18ec405d-82c7-4daa-e0e8-b92a2224da2c"
      },
      "source": [
        "leitos.info()"
      ],
      "execution_count": 187,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 54458 entries, 0 to 54457\n",
            "Data columns (total 5 columns):\n",
            " #   Column      Non-Null Count  Dtype  \n",
            "---  ------      --------------  -----  \n",
            " 0   CO_UNIDADE  54458 non-null  object \n",
            " 1   CO_LEITO    54458 non-null  int64  \n",
            " 2   QT_EXIST    54458 non-null  int64  \n",
            " 3   QT_CONTR    93 non-null     float64\n",
            " 4   QT_SUS      54458 non-null  int64  \n",
            "dtypes: float64(1), int64(3), object(1)\n",
            "memory usage: 2.1+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "VscmjxEpsxZi",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "36bc809f-00c5-43e2-bb7b-f7cc3ef14086"
      },
      "source": [
        "#Abrindo arquivo que descreve o tipo de leito e o tpleito\n",
        "desc_leito = pd.read_csv('/content/drive/My Drive/SUS_DADOS/tpleitos.csv', sep=',', encoding='Latin-1')\n",
        "desc_leito"
      ],
      "execution_count": 188,
      "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>cod_leito</th>\n",
              "      <th>descricao_leito</th>\n",
              "      <th>tpleito</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>BUCO MAXILO FACIAL</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>CARDIOLOGIA</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>CIRURGIA GERAL</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>ENDOCRINOLOGIA</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>GASTROENTEROLOGIA</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>6</td>\n",
              "      <td>GINECOLOGIA</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>7</td>\n",
              "      <td>CIRURGICO/DIAGNOSTICO/TERAPEUTICO</td>\n",
              "      <td>REGULACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>8</td>\n",
              "      <td>NEFROLOGIAUROLOGIA</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>9</td>\n",
              "      <td>NEUROCIRURGIA</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>10</td>\n",
              "      <td>OBSTETRICIA CIRURGICA</td>\n",
              "      <td>URGENCIA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>11</td>\n",
              "      <td>OFTALMOLOGIA</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>12</td>\n",
              "      <td>ONCOLOGIA</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>13</td>\n",
              "      <td>ORTOPEDIATRAUMATOLOGIA</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>14</td>\n",
              "      <td>OTORRINOLARINGOLOGIA</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>15</td>\n",
              "      <td>PLASTICA</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>16</td>\n",
              "      <td>TORACICA</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>31</td>\n",
              "      <td>AIDS</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>32</td>\n",
              "      <td>CARDIOLOGIA</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>33</td>\n",
              "      <td>CLINICA GERAL</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>34</td>\n",
              "      <td>CRONICOS</td>\n",
              "      <td>VIGILANCIA EM SAUDE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>35</td>\n",
              "      <td>DERMATOLOGIA</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>36</td>\n",
              "      <td>GERIATRIA</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>37</td>\n",
              "      <td>HANSENOLOGIA</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>38</td>\n",
              "      <td>HEMATOLOGIA</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>40</td>\n",
              "      <td>NEFROUROLOGIA</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>41</td>\n",
              "      <td>NEONATOLOGIA</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>42</td>\n",
              "      <td>NEUROLOGIA</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>43</td>\n",
              "      <td>OBSTETRICIA CLINICA</td>\n",
              "      <td>URGENCIA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>44</td>\n",
              "      <td>ONCOLOGIA</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>45</td>\n",
              "      <td>PEDIATRIA CLINICA</td>\n",
              "      <td>OUTROS</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>66</td>\n",
              "      <td>UNIDADE ISOLAMENTO</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>67</td>\n",
              "      <td>TRANSPLANTE</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>68</td>\n",
              "      <td>PEDIATRIA CIRURGICA</td>\n",
              "      <td>OUTROS</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>69</td>\n",
              "      <td>AIDS</td>\n",
              "      <td>REGULACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>70</td>\n",
              "      <td>FIBROSE CISTICA</td>\n",
              "      <td>REGULACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>71</td>\n",
              "      <td>INTERCORRENCIA POS-TRANSPLANTE</td>\n",
              "      <td>REGULACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>72</td>\n",
              "      <td>GERIATRIA</td>\n",
              "      <td>REGULACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>73</td>\n",
              "      <td>SAUDE MENTAL</td>\n",
              "      <td>REGULACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>74</td>\n",
              "      <td>UTI ADULTO - TIPO I</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>75</td>\n",
              "      <td>UTI ADULTO - TIPO II</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>76</td>\n",
              "      <td>UTI ADULTO - TIPO III</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>77</td>\n",
              "      <td>UTI PEDIATRICA - TIPO I</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>78</td>\n",
              "      <td>UTI PEDIATRICA - TIPO II</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>79</td>\n",
              "      <td>UTI PEDIATRICA - TIPO III</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>80</td>\n",
              "      <td>UTI NEONATAL - TIPO I</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>81</td>\n",
              "      <td>UTI NEONATAL - TIPO II</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>82</td>\n",
              "      <td>UTI NEONATAL - TIPO III</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>83</td>\n",
              "      <td>UTI DE QUEIMADOS</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>84</td>\n",
              "      <td>ACOLHIMENTO NOTURNO</td>\n",
              "      <td>VIGILANCIA EM SAUDE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>85</td>\n",
              "      <td>UTI CORONARIANA TIPO II - UCO TIPO II</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50</th>\n",
              "      <td>86</td>\n",
              "      <td>UTI CORONARIANA TIPO III - UCO TIPO III</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>51</th>\n",
              "      <td>87</td>\n",
              "      <td>SAUDE MENTAL</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>52</th>\n",
              "      <td>88</td>\n",
              "      <td>QUEIMADO ADULTO</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>53</th>\n",
              "      <td>89</td>\n",
              "      <td>QUEIMADO PEDIATRICO</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>54</th>\n",
              "      <td>90</td>\n",
              "      <td>QUEIMADO ADULTO</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>55</th>\n",
              "      <td>91</td>\n",
              "      <td>QUEIMADO PEDIATRICO</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>56</th>\n",
              "      <td>92</td>\n",
              "      <td>UNIDADE DE CUIDADOS INTERMEDIARIOS NEONATAL CO...</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>57</th>\n",
              "      <td>93</td>\n",
              "      <td>UNIDADE DE CUIDADOS INTERMEDIARIOS NEONATAL CA...</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>58</th>\n",
              "      <td>94</td>\n",
              "      <td>UNIDADE DE CUIDADOS INTERMEDIARIOS PEDIATRICO</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>59</th>\n",
              "      <td>95</td>\n",
              "      <td>UNIDADE DE CUIDADOS INTERMEDIARIOS ADULTO</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    cod_leito  ...              tpleito\n",
              "0           1  ...           INTERNACAO\n",
              "1           2  ...           INTERNACAO\n",
              "2           3  ...           INTERNACAO\n",
              "3           4  ...           INTERNACAO\n",
              "4           5  ...           INTERNACAO\n",
              "5           6  ...           INTERNACAO\n",
              "6           7  ...            REGULACAO\n",
              "7           8  ...           INTERNACAO\n",
              "8           9  ...           INTERNACAO\n",
              "9          10  ...             URGENCIA\n",
              "10         11  ...           INTERNACAO\n",
              "11         12  ...           INTERNACAO\n",
              "12         13  ...           INTERNACAO\n",
              "13         14  ...           INTERNACAO\n",
              "14         15  ...           INTERNACAO\n",
              "15         16  ...           INTERNACAO\n",
              "16         31  ...         AMBULATORIAL\n",
              "17         32  ...         AMBULATORIAL\n",
              "18         33  ...         AMBULATORIAL\n",
              "19         34  ...  VIGILANCIA EM SAUDE\n",
              "20         35  ...         AMBULATORIAL\n",
              "21         36  ...         AMBULATORIAL\n",
              "22         37  ...         AMBULATORIAL\n",
              "23         38  ...         AMBULATORIAL\n",
              "24         40  ...         AMBULATORIAL\n",
              "25         41  ...         AMBULATORIAL\n",
              "26         42  ...         AMBULATORIAL\n",
              "27         43  ...             URGENCIA\n",
              "28         44  ...         AMBULATORIAL\n",
              "29         45  ...               OUTROS\n",
              "30         66  ...                 SADT\n",
              "31         67  ...           INTERNACAO\n",
              "32         68  ...               OUTROS\n",
              "33         69  ...            REGULACAO\n",
              "34         70  ...            REGULACAO\n",
              "35         71  ...            REGULACAO\n",
              "36         72  ...            REGULACAO\n",
              "37         73  ...            REGULACAO\n",
              "38         74  ...                 SADT\n",
              "39         75  ...                 SADT\n",
              "40         76  ...                 SADT\n",
              "41         77  ...                 SADT\n",
              "42         78  ...                 SADT\n",
              "43         79  ...                 SADT\n",
              "44         80  ...                 SADT\n",
              "45         81  ...                 SADT\n",
              "46         82  ...                 SADT\n",
              "47         83  ...                 SADT\n",
              "48         84  ...  VIGILANCIA EM SAUDE\n",
              "49         85  ...                 SADT\n",
              "50         86  ...                 SADT\n",
              "51         87  ...         AMBULATORIAL\n",
              "52         88  ...         AMBULATORIAL\n",
              "53         89  ...         AMBULATORIAL\n",
              "54         90  ...           INTERNACAO\n",
              "55         91  ...           INTERNACAO\n",
              "56         92  ...                 SADT\n",
              "57         93  ...                 SADT\n",
              "58         94  ...                 SADT\n",
              "59         95  ...                 SADT\n",
              "\n",
              "[60 rows x 3 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 188
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PIz-rOCksxrs",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "desc_leito.rename(columns={'cod_leito': 'CO_LEITO'}, inplace=True)"
      ],
      "execution_count": 193,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "6zRyQLIEsx_I",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "6b5c4f23-18b5-4737-fadf-2b95194aeedf"
      },
      "source": [
        "desc_leito.columns"
      ],
      "execution_count": 194,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['CO_LEITO', 'descricao_leito', 'tpleito'], dtype='object')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 194
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "bEsRP5GfsyQO",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "df_leitos = leitos.merge(desc_leito, on='CO_LEITO', how='left')"
      ],
      "execution_count": 195,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "tA018cDu1cuR",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "outputId": "7ebcf41e-b296-4208-8e64-0933e5e5e75e"
      },
      "source": [
        "df_leitos.head()"
      ],
      "execution_count": 196,
      "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>CO_UNIDADE</th>\n",
              "      <th>CO_LEITO</th>\n",
              "      <th>QT_EXIST</th>\n",
              "      <th>QT_CONTR</th>\n",
              "      <th>QT_SUS</th>\n",
              "      <th>descricao_leito</th>\n",
              "      <th>tpleito</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>5208006587518</td>\n",
              "      <td>32</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>CARDIOLOGIA</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>5208006587518</td>\n",
              "      <td>42</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>NEUROLOGIA</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>5208006587518</td>\n",
              "      <td>45</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>PEDIATRIA CLINICA</td>\n",
              "      <td>OUTROS</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>5208006587518</td>\n",
              "      <td>48</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>3552202708566</td>\n",
              "      <td>81</td>\n",
              "      <td>9</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>UTI NEONATAL - TIPO II</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      CO_UNIDADE  CO_LEITO  ...         descricao_leito       tpleito\n",
              "0  5208006587518        32  ...             CARDIOLOGIA  AMBULATORIAL\n",
              "1  5208006587518        42  ...              NEUROLOGIA  AMBULATORIAL\n",
              "2  5208006587518        45  ...       PEDIATRIA CLINICA        OUTROS\n",
              "3  5208006587518        48  ...                     NaN           NaN\n",
              "4  3552202708566        81  ...  UTI NEONATAL - TIPO II          SADT\n",
              "\n",
              "[5 rows x 7 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 196
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "41yDsXQ_3wrj",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 153
        },
        "outputId": "2cf2f699-07fb-42d7-c42d-ade4cf2e91d5"
      },
      "source": [
        "df_leitos.isnull().sum()"
      ],
      "execution_count": 197,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "CO_UNIDADE             0\n",
              "CO_LEITO               0\n",
              "QT_EXIST               0\n",
              "QT_CONTR           54365\n",
              "QT_SUS                 0\n",
              "descricao_leito     2373\n",
              "tpleito             2373\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 197
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "sD8R2HWXbavn",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "df_leitos.drop(columns=['QT_CONTR'],inplace=True)"
      ],
      "execution_count": 200,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "i26unBa-8AvM",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "c1c55db5-faa3-4d42-c6b1-e86a4edaefae"
      },
      "source": [
        "df_leitos['QT_SUS'].sum()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "357192"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 112
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "AUgazA09cDe2",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "0c3a4e67-0d83-466c-f21d-4dd7cdc2d1a6"
      },
      "source": [
        "df_leitos['QT_EXIST'].sum()"
      ],
      "execution_count": 201,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "547830"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 201
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "z5cJMo2E8yO4",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 170
        },
        "outputId": "e5c44e86-77df-4cac-b706-40b06aa3fe38"
      },
      "source": [
        "df_leitos.groupby('tpleito')['QT_SUS'].sum()"
      ],
      "execution_count": 202,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "tpleito\n",
              "AMBULATORIAL           112757\n",
              "INTERNACAO              78327\n",
              "OUTROS                  43293\n",
              "REGULACAO                5483\n",
              "SADT                    30248\n",
              "URGENCIA                42928\n",
              "VIGILANCIA EM SAUDE     11189\n",
              "Name: QT_SUS, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 202
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rdbGDkeocUkk",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 170
        },
        "outputId": "41bba2ac-f716-4a9f-82b2-f4eaa6978940"
      },
      "source": [
        "df_leitos.groupby('tpleito')['QT_EXIST'].sum()"
      ],
      "execution_count": 203,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "tpleito\n",
              "AMBULATORIAL           166630\n",
              "INTERNACAO             126717\n",
              "OUTROS                  56530\n",
              "REGULACAO               11805\n",
              "SADT                    60683\n",
              "URGENCIA                59308\n",
              "VIGILANCIA EM SAUDE     13849\n",
              "Name: QT_EXIST, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 203
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4O5bj-pu9QDm",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 282
        },
        "outputId": "ac49452a-081b-475c-e660-a9b06010a068"
      },
      "source": [
        "df_leitos.groupby('tpleito')['QT_EXIST'].size().sort_values().tail().plot(kind='barh')"
      ],
      "execution_count": 205,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7feeb592ccc0>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 205
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAcAAAAD4CAYAAAB7ezYHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAY/klEQVR4nO3de7RkZX3m8e9DdwAbEGjx0oPAkQQvKNpKe5dEUUcUR9So0DFLUGcclXGpUQRFHZ2FCmImqGgMy1EZAoiiYtREjUS8JAx4OjY0yF1atDUKmLQgXhB/80e9B6rLc6k+59Q5p93fz1q1zt7vvv3qhaqn3713VaWqkCSpa7Zb7AIkSVoMBqAkqZMMQElSJxmAkqROMgAlSZ20fLEL0HD22GOPGhsbW+wyJGmbsm7dupuq6p6TLTMAtxFjY2OMj48vdhmStE1J8r2plnkKVJLUSQagJKmTDEBJUicZgJKkTjIAJUmdZABKkjrJAJQkdZIBKEnqJANQktRJfhPMNmLDps2MHfeFxS5DkhbUxhMPHdm+HQFKkjrJAJQkdZIBKEnqJANQktRJBqAkqZMMQElSJxmAkqROWlIBmOTW9ncsSSV5Vd+yU5McleQDSdYn+U6SX7Tp9Umel+RjSa7va/uXtu1RSW5sbVcmeW3fft+W5LYk9xqso2/+2a2eBw60PyrJ15NcleTbST6cZEXf8vOS/L+BbZLkzUmuSXJ1kq8mefB89aEkaThLKgAH/AR4dZLt+xur6uiqWg08A7iuqla3x7ltlWP62h7Xt+k5bbvHA8cn2atv2U3A66apZS3wzfYXgCT3Bj4JHFtVD6iqhwNfBHZpy3cDDgR2TbJv376OBh4HPKyq7g+8C/i7JDsO1SuSpHmxlAPwRuB84Mj53GlV3QxcC6zqa/4IcHiSlYPrJ9kZeALwUuCIvkVHA6dX1YV9+z63qn7cZp8LfA74+MB2xwL/o6pua9t8GfgX4IVzfGqSpK2wlAMQ4CTg9UmWbcU2J/edAj1zcGGSvYEdgUv7mm+lF4KvnmR/hwFfrKqrgZuTHNjaHwKsm6aOtcDZ7bG2HfvuwE5V9d2BdceB3zkNmuRlScaTjN9x2+ZpDiVJ2lpLOgBbUFwE/NlWbNZ/CrR/VHV4kkvpjf4+WFW/HNjufcCRSXYZaF9LbxRH+7uWGbTTo/sB32zBeXuSh2zFcwCgqk6rqjVVtWbZil23dnNJ0jSWdAA276R32jBz3M85VfVQetffTkxyn/6FVfUfwFn0Tm0C0E6JHgx8OMlG4BjgBUkCXE7vGt9kXgDsDlzfthsD1lbVz4CfD1wTpO3n8jk9O0nSVlnyAVhVVwLfAf7LPO1vHDiDyU93/m/gv3PXr2Q8DzijqvapqrGq2gu4HjgIOJXeiPHRExsneW4b/a0FDmnbjNELuInrgCcD70tyt7bNU+hdYzxrPp6fJGk4Sz4Am3cA9x1y3f5rgOsH7yJtTgJePHi6s6puAj4D7NCa1rb5fp+iN5r7Mb1Qe0/7GMQVwNOAewD7AHd+/KGqrgc2t7B8P/AtYEOSq4C3AIdV1S+GfH6SpHmQqlrsGjSEHVbtV6uOPGWxy5CkBTXX3wNMsq6q1ky2bFsZAUqSNK8MQElSJxmAkqROMgAlSZ1kAEqSOmn5zKtoKThgz10Zn+PdUJKkuzgClCR1kgEoSeokA1CS1EkGoCSpkwxASVInGYCSpE4yACVJnWQASpI6yQCUJHWSAShJ6iQDUJLUSQagJKmTDEBJUicZgJKkTjIAJUmdZABKkjrJAJQkdZIBKEnqJANQktRJBqAkqZMMQElSJy1f7AI0nA2bNjN23BcWuwxJ82TjiYcudgmd5whQktRJBqAkqZMMQElSJxmAkqROMgAlSZ1kAEqSOmmkAZjk2UkqyQPb/FibP6FvnT2S3J7k1Db/tiSbkqxPcmWSv06yXVt2QZI1fduOJbmsTT8xyeenqWV9ko+36Re3+fVJfp1kQ5s+sa/uS5Nc0ZY9u28/H0tyfVv/kiRP7ls2WN/q9nwPGajl1tn2qSRpfox6BLgW+Gb7O+F6oP8DMM8HLh/Y7q+qajWwP3AA8CdzKSLJg4BlwEFJdqqqj1bV6naMHwJPavPHJXkY8B7gsKp6EPAs4D1JHtq3y2Patq8BPjTNoSd7/pKkJWBkAZhkZ+AJwEuBI/oW3QZc0TdSOhz4xBS72R7YEfj3OZazFjgD+DJw2Azrvh54Z1VdD9D+vgs4ZpJ1LwT2nGwnSUIv3I8Cnppkx1lVLkkaiVGOAA8DvlhVVwM3Jzmwb9nHgSOS7AXcQW8U1u+1SdYDPwKurqr1c6zl8HbMs5l5NPZgYN1A23hrH3QIcN4U+3kccH1VXQdcwJajXknSIhtlAK6lFzq0v/3B80XgqfRGhudMsu3EKdB7ATslmRhB1iTrTtZ2pzbSvKmqbgDOBx6eZOXQz2JyJye5GjgLOGmKdaZ7/kNJ8rIk40nG77ht8+wqlSRNaiQB2ALmYODDSTbSO334AiAAVfVreqOs1wHnTrWfqrqdXlj+cWu6Gdi9b5WVwE0zlLMWeGCr4zrg7sCfTrP+d4ADB9oOZMvrlMdU1f2BY4GPDO4gybJ2jLe2474fOCTJLjPUuoWqOq2q1lTVmmUrdt2aTSVJMxjVCPB5wBlVtU9VjVXVXvRuftmrb52/BI6tqp9OtZN2He3x9IILeqcS/7y1AxwJfHWa7bejF7wHtDrG6J2anW409h7gjUnG2j7GgDe1egedCmyX5GkD7U8GLq2qvdpx9wE+BTxnmuNKkhbQqAJwLfCZgbZPAW+cmKmqy6vq9Cm2n7gGeBm9uzc/2NpPA24BLklyCbAzvcCa8OQkP5h4AAcBm6qq/xrj14H9k6ya7MDteuOxwOeSXAl8DnjDZNchq6qAE4A3DPn8J4J3RX+dSf5iin6QJI1Ieu/hWup2WLVfrTrylMUuQ9I88eeQFkaSdVW1ZrJlfhOMJKmTDEBJUicZgJKkTjIAJUmdZABKkjpp+WIXoOEcsOeujHvXmCTNG0eAkqROMgAlSZ1kAEqSOskAlCR1kgEoSeokA1CS1EkGoCSpkwxASVInGYCSpE4yACVJnWQASpI6yQCUJHWSAShJ6iQDUJLUSQagJKmTDEBJUicZgJKkTjIAJUmdZABKkjpp+TArJbk38Mg2e3FV/WR0JUmSNHozjgCTvAC4GHg+8ALgoiTPG3VhkiSN0jAjwOOBR06M+pLcE/gKcO4oC9OWNmzazNhxX1jsMtQxG088dLFLkEZmmGuA2w2c8rx5yO0kSVqyhhkBfjHJl4Cz2/zhwD+MriRJkkZvxgCsqmOSPBd4Qms6rao+M9qyJEkarRkDMMlJVXUs8OlJ2iRJ2iYNcy3vqZO0PX2+C5EkaSFNOQJM8grglcC+SS7tW7QL8M+jLkySpFGa7hToWfRudnkXcFxf+y1V9dORViVJ0ohNdwq0qmojcDRwS9+DJCtHX9rMkowluWyg7W1JXp/kY0muT7I+ySVJnty3zvIk70xyTVu+Psnxfcvv6Gtfn+S41n5BkvG+9dYkuaBv/lFJvp7kqiTfTvLhJCuSHJXk1IE61yf5+Ai6RZI0hJlGgM8E1gEFpG9ZAfuOsK75ckxVnZvkScBpwH6t/QTgPsABVfXLJLsAr+vb7hdVtXqKfd4rydOraouPgrSvi/skcERVXdjankfvlDED6z4IWAYclGSnqvr5HJ6jJGkWpgzAqnpm+3u/hStnZC4E9gRIsgL4b8BYVf0SoKpuAd425L5OpvftOIOfhTwaOH0i/Np+z23HHNzHWuAM4EHAYfT+sSFJWkDDfBdokvx5kre0+b2TPGr0pc2rQ4Dz2vQfATe00JvK3QZOgR7et+xC4NdtVNnvIfRGy8M4HPg4vS8XWDvVSklelmQ8yfgdt20ecteSpGEM8zGIDwKPBf6szd8CfGBkFW2dmqH95CRX0xthnTTZikle3ELu+0n2as2/qKrVfY9zBjY7AXjzbApOsga4qapuAM4HHj7VNdWqOq2q1lTVmmUrdp3N4SRJUxgmAB9dVUcDE6cL/x3YfqRVDe9mYPeBtpXATW36mKq6P3As8JHWdi2wd7vuR1V9tF3v20zvutyMquqfgLsBj+lrvhw4cIjN1wIPTLIRuA64O/CnwxxXkjR/hgnA25Mso42q2q9B/HakVQ2pqm4FfpTkYLjz7tRDgG8OrHoqsF2Sp1XVbcD/AU5NsmPbbhlbH+onAG8YOMaRSR490ZDkue3mmIn57ej9pNQBVTVWVWP0rgFOeRpUkjQawwTg+4DP0Lv78R30wuWdI61q67wIeEuS9cA/AW+vquv6V6iqYsvAOh74EXBZkm8D3wBOB37Ylg9eAzxx8KBV9ffAjX3zPwaOAN7TPgZxBfA02kdHmoOATVX1w762rwP7J1k1y+cvSZqF9LJhhpWSBwJPpvdRiPOr6opRF6Yt7bBqv1p15CmLXYY6xt8D1LYuybqqWjPZsum+Cq3/xoyfcNfPIZFkpd8GI0nalk33QfjJPgA/YVv5ILwkSZOa7oPwvw8fgJckaVLD/CI8fT+IW8A3quq8GTaRJGlJG+abYD4IvBzYAFwGvDzJUvkgvCRJszLMCPBg4EHtowQkOZ3eh761gA7Yc1fGvSNPkubNMJ8DvBbYu29+r9YmSdI2a5gR4C7AFUkupncN8FHAt5L8HUBVPWuE9UmSNBLDBODdgKf3zYfeF0v/z5FUJEnSAhgmAJdX1df6G5LcbbBNkqRtyXTfBPMK4JXAvkku7Vu0C/DPoy5MkqRRmm4EeBa9Xz1/F3BcX/stfg2aJGlbN903wWym9xt5/lSPJOn3zjAfg5Ak6feOAShJ6iQDUJLUSQagJKmTDEBJUicZgJKkTjIAJUmdZABKkjrJAJQkdZIBKEnqJANQktRJBqAkqZMMQElSJxmAkqROGuYX4bUEbNi0mbHjvrDYZWgbsfHEQxe7BGnJcwQoSeokA1CS1EkGoCSpkwxASVInGYCSpE4yACVJnWQADiHJ8UkuT3JpkvVJHt3alye5McmJA+tfkOSqtv6VSU5NsluSe7Tt1yf5tySb+ua3X5xnJ0ndZADOIMljgWcCj6iqhwJPAb7fFj8VuBp4fpIMbPrCtv5DgV8Bn62qm6tqdVWtBj4E/NXEfFX9ekGekCQJMACHsQq4qap+BVBVN1XVD9uytcB7gRuAx062cQu2NwB7J3nYAtQrSRqCATizLwN7Jbk6yQeT/AlAkh3pjQY/B5xNLwwnVVV3AJcAD1yAeiVJQzAAZ1BVtwIHAi8DbgTOSXIUvdOiX62qXwCfAp6dZNk0uxo8RTqjJC9LMp5k/I7bNm998ZKkKfldoENoI7gLgAuSbACOBH4NPCHJxrbaPYCDgX8c3L4F4wHAFVt53NOA0wB2WLVfzbJ8SdIkHAHOIMkDkuzX17Sa3kjwIGDvqhqrqjHgaCY5DZrkD4B3Ad+vqksXoGRJ0hAcAc5sZ+D9SXYDfgNcC3wWWDFxY0zzWeDdSXZo82cm+RWwA/AV4LAFrFmSNAMDcAZVtQ543CSLTh9Y76fAPdvsE4fY79vmWpskafY8BSpJ6iQDUJLUSQagJKmTDEBJUicZgJKkTvIu0G3EAXvuyviJhy52GZL0e8MRoCSpkwxASVInGYCSpE4yACVJnWQASpI6yQCUJHWSAShJ6iQDUJLUSQagJKmTDEBJUicZgJKkTjIAJUmdZABKkjrJAJQkdZIBKEnqJANQktRJBqAkqZMMQElSJxmAkqROMgAlSZ1kAEqSOmn5Yheg4WzYtJmx476w2GVoidh44qGLXYK0zXMEKEnqJANQktRJBqAkqZMMQElSJxmAkqROMgAlSZ1kAEqSOqkzAZjkvkk+m+SaJNcleW+S7ZMcleTUgXUvSLImyUVJ1ie5IcmNbXp9krEkG5NsSHJpkq8l2WemY7VlK5Kc2ba9LMk3k+y80P0hSV3XiQBMEuDTwHlVtR9wf2Bn4B3TbVdVj66q1cBbgXOqanV7bGyrPKmqHgpcALx5yGO9GvhxVR1QVQ8BXgrcPm9PVpI0lE4EIHAw8Muq+ihAVd0BvBZ4CbBiHvZ/IbDnTMdKsgJYBWya2LCqrqqqX81DDZKkrdCVAHwwsK6/oap+BtzA/Hwd3CHAeUMc64+AjwDHJrkwyQlJ9ptqp0lelmQ8yfgdt22ehzIlSRO6EoDT2X2K9hpi268m2QQ8HTh7mINV1XpgX+BkYCXwrSQPmmLd06pqTVWtWbZi12F2L0kaUlcC8DvAgf0NSe4O7A18m98NwZXATUPs90nAPsB64O1DHOtagKq6tao+XVWvBP4WeMbWPBlJ0tx1JQDPB1YkeRFAkmXAXwIfAy4CHp/kPm3ZGmAH4PvD7LiqfgO8BnhRkpXTHauqbkvy+CS7t2XbA/sD35uvJypJGk4nArCqCngO8Pwk1wBXA78E3lRVP6Z3Z+bfJ1kPnAKsrarfbsX+f0TvFOjR0x2rrf6HwNeSbKA3+hwHPjUPT1OStBXSe7/WUrfDqv1q1ZGnLHYZWiL8PUBpOEnWVdWayZZ1YgQoSdIgA1CS1EkGoCSpkwxASVInGYCSpE6aj68B0wI4YM9dGffOP0maN44AJUmdZABKkjrJAJQkdZIBKEnqJANQktRJBqAkqZMMQElSJxmAkqROMgAlSZ1kAEqSOskfxN1GJLkFuGqx65jGHsBNi13ENKxvbpZyfUu5NrC+uZprfftU1T0nW+B3gW47rprqV42XgiTj1jd71jd7S7k2sL65GmV9ngKVJHWSAShJ6iQDcNtx2mIXMAPrmxvrm72lXBtY31yNrD5vgpEkdZIjQElSJxmAkqROMgCXuCSHJLkqybVJjlvA4+6V5KtJvpPk8iSvbu0rk/xjkmva391be5K8r9V5aZJH9O3ryLb+NUmOnOc6lyX5dpLPt/n7Jbmo1XFOku1b+w5t/tq2fKxvH29s7Vcledo81rZbknOTXJnkiiSPXUr9l+S17b/tZUnOTrLjYvZfko8k+UmSy/ra5q2/khyYZEPb5n1JMg/1ndz++16a5DNJdpupX6Z6TU/V93Opr2/Z65JUkj3a/JLov9b+qtaHlyd5d1/76Puvqnws0QewDLgO2BfYHrgE2H+Bjr0KeESb3gW4GtgfeDdwXGs/DjipTT8D+AcgwGOAi1r7SuC77e/ubXr3eazzL4CzgM+3+U8AR7TpDwGvaNOvBD7Upo8AzmnT+7d+3QG4X+vvZfNU2+nAf23T2wO7LZX+A/YErgfu1tdvRy1m/wF/DDwCuKyvbd76C7i4rZu27dPnob7/DCxv0yf11TdpvzDNa3qqvp9Lfa19L+BLwPeAPZZY/z0J+AqwQ5u/10L238jfSH3M/gE8FvhS3/wbgTcuUi2fBZ5K79toVrW2VfQ+oA/wN8DavvWvasvXAn/T177FenOs6b7A+cDBwOfbC/OmvjekO/uvvQE8tk0vb+tlsE/715tjbbvSC5gMtC+J/qMXgN9vb3TLW/89bbH7DxgbeIOcl/5qy67sa99ivdnWN7DsOcCZbXrSfmGK1/R0/+/OtT7gXOBhwEbuCsAl0X/0Quspk6y3IP3nKdClbeJNasIPWtuCaqe7Hg5cBNy7qn7UFv0bcO82PVWto3wOpwBvAH7b5u8B/EdV/WaSY91ZR1u+ua0/qvruB9wIfDS9U7QfTrITS6T/qmoT8B7gBuBH9PpjHUun/ybMV3/t2aZHVSfAS+iNjGZT33T/785aksOATVV1ycCipdJ/9wcOaqcuv5bkkbOsb1b9ZwBqWkl2Bj4FvKaqfta/rHr/1FqUz9EkeSbwk6patxjHH8Jyeqd7/rqqHg78nN4pvDstcv/tDhxGL6j/E7ATcMhi1DKsxeyvmSQ5HvgNcOZi1zIhyQrgTcBbF7uWaSyndxbiMcAxwCe29triXBiAS9smeufvJ9y3tS2IJH9AL/zOrKpPt+YfJ1nVlq8CfjJDraN6Do8HnpVkI/BxeqdB3wvslmTiO277j3VnHW35rsDNI6zvB8APquqiNn8uvUBcKv33FOD6qrqxqm4HPk2vT5dK/02Yr/7a1Kbnvc4kRwHPBF7YQno29d3M1H0/W39I7x84l7TXyX2Bf01yn1nUN6r++wHw6eq5mN7ZnD1mUd/s+m9rz+H6WLgHvX8dfZfe/8QTF3wfvEDHDvB/gVMG2k9my5sS3t2mD2XLi+oXt/aV9K6F7d4e1wMr57nWJ3LXTTCfZMsL4a9s00ez5U0cn2jTD2bLi+3fZf5ugvkG8IA2/bbWd0ui/4BHA5cDK9oxTwdetdj9x+9eI5q3/uJ3b+J4xjzUdwjwHeCeA+tN2i9M85qequ/nUt/Aso3cdQ1wqfTfy4H/1abvT+/0Zhaq/+btTcjHaB707ta6mt6dT8cv4HGfQO9006XA+vZ4Br1z7ecD19C7e2vixRHgA63ODcCavn29BLi2PV48glqfyF0BuG97oV7bXhATd5ft2Oavbcv37dv++Fb3VWzlnW0z1LUaGG99eF57Q1ky/Qe8HbgSuAw4o73ZLFr/AWfTux55O72RwUvns7+ANe25XgecysANSrOs71p6b9oTr5EPzdQvTPGanqrv51LfwPKN3BWAS6X/tgf+tu33X4GDF7L//Co0SVIneQ1QktRJBqAkqZMMQElSJxmAkqROMgAlSZ1kAEqSOskAlCR10v8HiYpL9XkjjVMAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fnVhSjnV9zwt",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 282
        },
        "outputId": "687dfaa0-a044-4490-ea6c-a877375dd0a4"
      },
      "source": [
        "df_leitos.groupby('descricao_leito')['QT_EXIST'].size().sort_values().head().plot(kind='barh')"
      ],
      "execution_count": 206,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7feeb59a6c50>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 206
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAjsAAAD4CAYAAAAKNSdoAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3debwcVZ338c+XICEh7EsIm1cwBAhLkIwowgyyaAQdZOcOSHAZdAwPGIcIsjjgM2hkEcQwSkQIzLDvCCogJA8oCNzADQlLCCEBDbuMQAgQCb/njzotRaX73u7c7tx7i+/79erX7TpVdc7vVDf0L3VOVSkiMDMzMyurFXo7ADMzM7NWcrJjZmZmpeZkx8zMzErNyY6ZmZmVmpMdMzMzK7UVezsAM1vaOuusE21tbb0dhplZvzJ9+vSXI2LdYrmTHbM+qK2tjY6Ojt4Ow8ysX5H0dLVyD2OZmZlZqTnZMTMzs1JzsmNmZmal5mTHzMzMSs3JjpmZmZWakx0zMzMrNSc7ZmZmVmpOdszMzKzUnOyYmZlZqfkOymZ90MwFr9J2/C29HYaZ2XI1f+LeLanXZ3bMzMys1JzsmJmZWak52TEzM7NSc7JjZmZmpeZkx8zMzErNyY6ZmZmVmpMdMzMzKzUnO/2EpI0k3ShpjqSnJE2SNDCtO0LSpML20ySNTu/nS5opqTO9zk3lUyQdkNv+GUnK1XGDpIWFer8l6S1Jq+fKdpX0qqSHJM2WdJekzxf2O1LS4+l1v6Sda/RziqR5Kc4HJX2ySnmnpHtyfX8ptT1H0q2SdirUd0BueR1Jf5P0jbR8XqrvUUlv5uo/oNDmDEm71zi+QySdL2mupOlp3Y5VPre5kn4iaaXuP3EzM2sWJzv9QEpArgNuiIjhwHBgEHB6A9V8OiJGpdfRNbb5K/Cp1OYawLAq27QDDwD7FcrvjojtI2IEcDQwqZIcpMTn68DOEbEF8A3gMknr14hjQkSMAo4Hzi+Wp9dOufIrU9vDgYnAdZK2rFH3gcAfUz+IiHGprb2Aubn6rynE8i3g5zXqvAB4BRgeETsAXwbWqfK5bQ4MAU6rUY+ZmbWAk53+YTfgrYi4CCAilgDjgcMlDWliO1cAh6T3+5H9UP+dpM3IfqxPIiUL1UREJ/B94KhUdBxZ0vByWv8gcDEwrpt47gI+2kgHImIqMBk4ssYm7cC/AxtK2qiBqu8FNiwWpmOyI3BSRLybYpgXEbdQ+3P7iqTBDbRtZmY94GSnfxgJTM8XRMRrwHzqTwam5oZoxtfY5g7gHyUNIEt6riysP4QsIbobGCFpaBftPQhsUSt+oCOVd+ULwMzc8hm5PlxaZ9t/J2ljYFhE3A9cBRzcTft5Y4AbqpSPBDpTIlNtXbXP7RmqfG5pqK9DUseSRa82EJqZmXXFz8Yqh6ij/NOVMytdWAL8niypGRQR83NTeCA7K7JvRLwr6VqyIaFJS1cDgGqU1+MMSScBLwFfzZVPyA0vdaVW2weTJTmQJW0XAmfVEcsPgI2AT9bR9jKLiMlkZ6UYOGx4rc/UzMwa5DM7/cOjwA75AkmrAesDs4G/AGsW9lkL6C65qeYK4FzeSwoq7W1DNlfodknzyRKimkNZwPbAY7XiT8uP1Ni3Mjdnz4iY1Vj4S7Wd1w4ckeK/CdhW0vBu6poQEZuTDcVdWGX9I8B26WxYUa3PbRPgyW7aNTOzJnGy0z/cAQyWdDhA+mE9C5gUEW+STRj+VGXCb7pKaCDwp2Vo627gh8DlhfJ24JSIaEuvDYANJH24WIGkbYGTgfNS0enAjyStndaPAo4A/msZ4uuSpH8im6/zi0L55sCQiNiw0geyfnaVsOVNAlaQ9Nl8YUTMJRuSO7VyJZukNkl7U/tzmxIRi5a1j2Zm1hgnO/1ARASwL3CApDlkZ3LejYjT0voXgGOAX0vqBM4B2isTZpP8nJ1LumorIs6sMuR1CHB9oex63pvQvEvl0nOyJOfoiLgj1XkT2VmReyQ9TpaIHBYRzzV4KPJzdjpzl3AfnJafAE4A9o+I4pmd9irxX0udyU76DP4T+E6V1V8DhgJPSpoFTAFezH1uB6bP7QngrRSjmZktJ8r+f2z9SbqPzOVk82ce7O14rPkGDhsew8ae09thmJktV/Mn7t2j/SVNj4jRxXJPUO6HIuIeYKnhIzMzM1uah7HMzMys1JzsmJmZWak52TEzM7NSc7JjZmZmpeYJymZ90DYbrk5HD69KMDOzjM/smJmZWak52TEzM7NSc7JjZmZmpeZkx8zMzErNyY6ZmZmVmpMdMzMzKzUnO2ZmZlZqTnbMzMys1JzsmJmZWak52TEzM7NSc7JjZmZmpeZkx8zMzErNyY6ZmZmVmpMdMzMzKzUnO2ZmZlZqTnbMzMys1JzsmJmZWak52TEzM7NSc7JjZmZmpeZkx8zMzErNyY6ZmZmV2oq9HYCZLW3mgldpO/6W3g7DzKxH5k/cu7dDAHxmx8zMzErOyY6ZmZmVmpMdMzMzKzUnO2ZmZlZqTnbMzMys1JzsmJmZWan16WRH0sL0t01SSPo/uXWTJB0h6TxJnZIelfRmet8p6QBJUyTNy5Xdk/Y9QtJLqexxSeNz9a4v6QpJcyVNl/RrSZundSMl3SlptqQ5kk6WpDrqPEXSglyc7bl1XcX4rqRtc9vOktSW3g+RdH4uzmmSdswft9x+35L0lqTVaxznttyxe1TSzyWtUEefh0q6WdKMtN+vC/V+OdevxZJmpvcTuzpead9R6TMfUygPSWfllo+VdEp6PyIdh05Jj0manMp3lfRqrvw/cuU3VzsmaX2npCsKZVPSZzkwLa8jab6kbXJ9fSX3mf6ucHwrr8NrtWtmZs3Vp5OdgheBYyStlC+MiHERMQrYC5gbEaPS65q0yYRc2U65Xa9M+30KOFHSxulH/HpgWkRsFhE7AN8FhkoaBNwETIyIEcB2wE7AN7uqM7fu7LRuH+B8SR/KrasV45+BE2scjwuAV4DhKc4vA+vU2LYdeADYr8Z6SMcO2BbYCvhiHX3+PnB7RGwXEVsBx+crjIiLKv0CngU+nZYr23V1vNqB36e/eW8D+0mq1tdzScc5IrYEfppbd3dqazRwmKSPdXEskLQlMADYRdIqhdVLgK8U+joz19ebeO8z3SNtkv9ujoqIS7pq38zMmqc/JTsvAXcAY5tZaUT8BXgSGAZ8GvhbRPw8t35GRNwN/Avwh4i4LZUvAo6i8ANfpc7iujnAImDNOsK7GRgpaUS+UNJmwI7ASRHxbqp3XkQsdRe6tO0Q4CSWThyWEhHvAPcAH6X7Pg8jS8gq+z5cR5+qtfm+45WSzgOBI4A9Ja2c2/wdYDIwnqUV45lZpa03gOmpf11pB/4buI0sQc07BxgvyTflNDPrB/pTsgPwI+BYSQMa2OeM3NDBpcWVkjYBVgYeBrYm+yGsZmRxXUTMBYZIWq2LOovtfQyYExEv1hHju8DpwAlVYumMiCU1Ys07BLgCuBsYIWloVxtLGgzsDsyk+z6fB/xS0lRJJ0raoI54qrVZPF47AfNSW9OA4i04zwMOrTIsdzZwp6TfSBovaY0qba0NfAJ4pJuwDiY7bpezdJL4DNlZpy91U0feZoVhrF0a2NfMzHqgXyU7EfEUcB/ZGYd65YeIDs2VHyzpYbIzCv8VEW81IcSu6hwv6RGy+E+rM0aAy4BPSPrIMsbUDlyRzgBdS3bGpJrNJHUCfwBuiYjfdFdxRNwKbAr8AtgCeEjSug3EVut4tZMlGqS/70s2IuI14BLg6EL5RcCWwNXArsAfK3NryIajHiI7UzMxImomO5JGAy9HxDNkZxO3l7RWYbMfAhOo/7+h4jDW3VXaPVJSh6SOJYterbNaMzPrTr9KdpIfAMcB6mE9V0bEtmRnESZKWp/sX/s71Nj+0eI6SZsCC9OPb606K86OiJHA/mRnQ/JDMzWlYaWzyPpc8QiwXXdnuCRtAwwHbpc0n+wsT62hrMqP8fYRcUoq67bPEfFKRFwWEV8imxf0j5JOq5zB6KZ7Sx2v1Kf9ge+lmH8KjJG0amHfc4CvAu+bTxMRz0bEhRGxD9mQ19Zp1d2pbzvkhylraAe2SO3PBVZLMeXbmQN0Agd1U1fdImJyRIyOiNEDBledS25mZsug3yU7EfE42Y/wF5pUXwfZ3IxjgDuBgZKOrKyXtG0acrgU2FnSHql8ENmE2NO7qbO47iagg8bmHk0B9gDWTXXMTXWcmua3VK6oKg73tAOnRERbem0AbCDpw3W222WfJe2Whr1IychmwDMRcWJusm63Csdrd+DhiNg4xfxhsjNS+xb2eQW4iizhIcUwpjLxOyWaawML6uxrpY4VyBKYbSrHjWzOTrUk8TTg2EbqNzOz5a/fJTvJacBGdW6bnw/TWbyaK/kR2dVMQ8h+VPdQdkn3I2TDFc9HxJtkP3onSZpNNqflAWBSjXZ/BHy5yhkJyK5i+nb6Ye02xohYTJZkrJcr/howFHhS0iyyhCg/DwiyMznXF8quT+XdqqPPOwAdaSjqXuCCiHignrqrqHwG7VVivpbqycZZvP8KtM8AsyTNAG4lGx58vpt2d5f058oL2AVYEBHP5ra5C9hK0vsmnKehsAe7qb+iOGfn6O53MTOzZlBE9HYMZlYwcNjwGDb2nN4Ow8ysR+ZPLA44tJak6RExuljeX8/smJmZmdXFyY6ZmZmVmpMdMzMzK7WGkx1lz2Qa0opgzMzMzJqt7mRH2YMOHyK7x8ujyh4+uXV3+5mZmZn1pkae7XM+8O2ImArZE6PJnlG0U1c7mVnjttlwdTqW81UMZmZl1cgw1iqVRAcgIqZRuHutmZmZWV/TyJmdpySdTHanW4DDgKeaH5KZmZlZ8zRyZucrZI8ruI7sjrbrkN3x1szMzKzPauTMzh4R8b5b3Es6kOwJ02ZmZmZ9UiNndr5bZ5mZmZlZn9HtmR1JnwP2AjaUdG5u1WrAO60KzMzMzKwZ6hnGehboAP4ZmJ4rfx0Y34qgzMzMzJql22QnImYAMyRdGhE+k2NmZmb9Sj3DWFdFxEHAQ5KiuD4itm1JZGZmZmZNUM8w1jHp7+dbGYiZmZlZK3R7NVZEPJf+Pp2Khqf3LwKvtDA2MzMzsx5r5EGg/wpcQ/aMLICNgBtaEZSZmZlZszRyn51xwKeA1wAiYg6wXiuCMjMzM2uWRpKdtyNicWVB0orAUhOWzczMzPqSRpKd/yfpBGCQpD3JHhPxq9aEZWZmZtYcjSQ7xwMvATOBrwO/Bk5qRVBmZmZmzVL3g0Aj4l3gF+llZmZm1i/Uc1PBmXQxN8c3FTQzM7O+rJ4zO76ZoJmZmfVb9Twb6+nutgGQdG9EfLLnIZmZmZk1TyMTlLuzchPrMjMzM2uKuico18H33DFrkpkLXqXt+Ft6Owwzs7rMn7h3b4fQpWae2TEzMzPrc5qZ7KiJdZmZmZk1RUPDWJKGAv+QFu+PiBdzq7/UtKjMzMzMmqSRp54fBNwPHAgcBNwn6YDK+oiY1fzwzMzMzHqmkTM7JwL/UDmbI2ld4HfANa0IzMzMzKwZGpmzs0Jh2OovDe5vZmZmttw1cmbnt5JuBS5PyweTPQzUzMzMrM+q+8xMREwAJgPbptfkiDiuVYFZ60hqkzSrUHaKpGMlnSepU9Kjkt5M7zslHSBpSn6eVm7fKZLmSZoh6QlJl0jaKLd+vqSZubrOrRHXkZIeT68OSbsW6lgnt7yrpJvT+yMkvZSrv1PSVvl+pu1D0tdydYxKZcfmylZMdU0sxDZN0mxJD6f4JklaI7d+I0k3Spojaa6kn0haKa0bLOnSdAxmSfq9pCF1fFRmZtYEDQ1DRcS1EfHt9Lq+VUFZ74mIcRExCtgLmBsRo9Kru7lZEyJiO2AE8BBwZ+XHPvl0rq6jiztL+jzwdWDniNgCOBL4H0kb1hn6lbn6R0XEo1W2mUU2ub6iHZhR2GZP4AngQEnF2ykcmh58uy3wNnBjil3AdcANETEc2BwYApyW9jsGeCEitomIrYGvAn+rs19mZtZDjVyN9QlJD0haKGmxpCWSXmtlcNb/ROZs4Hngcw3sehxZwvRyqudB4CJgXBPDexpYWdLQlKCMAX5T2KYd+AnwDFD1WW8RsRj4DrCJpO2A3YC3IuKitH4JMB74iqTBwDBgQW7/2RHxdhP7ZWZmXWjkzM4ksh+COcAg4GvAea0IykrhQWCL3PLU3BDT+CrbjwSmF8o6gK3qbO/gwjDWoBrbXUN2+4SdUox/TzokrQzsAfyKbG5ae63GUkIzg6yPS8UeEa+RJUwfBS4EjpN0r6T/lDS8Wp1pGK9DUseSRa/W1WkzM+teo8NYTwIDImJJ+lfsmNaEZS1W6zlmzXy+WXEIKD+MdfYy1FcttnxZcRjrzRr1XEWW7LTz3mT7is8DU9O+1wJflDSgi5jqumt4RHQCmwJnAGsBD0jassp2kyNidESMHjB49XqqNjOzOjSS7CxKczA6JZ2e/nXuS8/7p78AaxbK1gJebmIb2wOPNbD9o8AOhbIdyM7uwNIxL1O8EfE82XyZPYE7CqvbgT0kzSc7U7M22RDVUlIStA1ZH5eKXdJqwCbAk6ndhRFxXUR8E/gfsjlRZma2HDSSrHwpbX8U8AawMbB/K4Ky1oqIhcBzknYDkLQW2Vm63/e0bmWOJpun8tsGdj0d+JGktVM9o4B9gfPT+mmkR5KkROMwYOoyhvk94Lg0FFWJezVgF2CTiGiLiDay+UJLDWVJ+hDwQ+BPEfEwWdI0WNLhufjOAqZExCJJn5K0Zlq3EtnQ3NPLGLuZmTWokfvsvAwsjoi3gFPT/9AHtiYsWw4OB86T9OO0fGpEzO1BfWdIOhkYDPyRbNhqcW79VEmV5OLhiDg8v3NE3CRpA+APklYE1ge2i4iX0ib/F/iZpBlkw0e/JTtDUnGwpJ1zy98Enq0WaETcU6V4X+DOwsThG4HTJVW+55dKepvse/87YJ9UX0jaF/ivdAxWILsH1Qlpv81S7ErrbiEbJjMzs+VAEfVN05D0R2CPdFaAdJ+Q2yJipxbGZx9AKdm5iCwxOCzq/ZKWyMBhw2PY2HN6Owwzs7rMn7h3b4cAgKTpETG6WN7ImZ2VK4kOZEMh6bJas6aKiHdIQ1ZmZmY91cicnTckfayyIGkHoNYVL2ZmZmZ9QiNndr4FXC3pWbI5E+uTPR/LzMzMrM+qO9mJiAckbUH2OACA2RHhW96bmZlZn9ZtsiNpt4i4U9J+hVWbSyIirmtRbGZmZmY9Vs+ZnX8C7gS+UGVdkD0A0cyaaJsNV6ejj1zdYGbW33Wb7ETEf0haAfhNRFy1HGIyMzMza5q6rsaKiHfJnvJsZmZm1q80cun57yQdK2ljSWtVXi2LzMzMzKwJGrn0vHKZ+bhcWZA9zdnMzMysT2rk0vOPtDIQMzMzs1aoexhL0jhJa+SW15T0zdaEZWZmZtYcjczZ+deI+GtlISL+F/jX5odkZmZm1jyNJDsDJKmyIGkAsFLzQzIzMzNrnkYmKP8WuFLS+Wn566nMzMzMrM9qJNk5DjgS+Le0fDtwQdMjMjMzM2uiRq7Gehf4OfDzdH+djSJiScsiMzMzM2uCRq7GmiZptZToTAd+Iens1oVmZmZm1nONTFBePSJeA/YDLomIHYHdWxOWmZmZWXM0kuysKGkYcBBwc4viMTMzM2uqRpKd7wO3AnMj4gFJmwJzWhOWmZmZWXM0MkH5auDq3PJTwP6tCMrMzMysWRqZoLy5pDskzUrL20o6qXWhmZmZmfVcI8NYvwC+C/wNICIeBg5pRVBmZmZmzdJIsjM4Iu4vlL3TzGDMzMzMmq2RZOdlSZsBASDpAOC5lkRlZmZm1iSNPC5iHDAZ2ELSAmAecGhLojIzMzNrEkVE1xtI3y4UDSI7I/QGQET8uDWhmX1wDRw2PIaNPae3w7Aemj9x794OwewDRdL0iBhdLK/nzM6q6e8I4B+AGwEBXwKKc3jMzMzM+pRuk52IOBVA0l3AxyLi9bR8CnBLS6MzMzMz66FGJigPBRbnlhenMjMzM7M+q5EJypcA90u6Pi1/EZjS9IjMzMzMmqiRx0WcJuk3wC6p6MsR8VBrwjIzMzNrjkbO7BARDwIPtigWMzMzs6ZrZM5OQyS1VZ6jlSs7RdKxks6T1CnpUUlvpvedkg6QNCXdsLBancdKejxt+4Ckw1P5SpLOkfSkpDmSbpS0UW6/JWmfWZJ+JWmN3LqRku6UNDvte7IkpXVHSHpX0ra57WdJasstj5IUksYUYq3aZo3jco6kBZJWyJUtc9u59felGJ6R9FLuOLdJmi9pnSqxXi1pcCrfKB3LOZLmSvqJpJWqtPP3PknaVdLNuT5MqhZbLZKmSRqdW37f8ZL0cUl3pc/rIUkX5OL9oqSHJT0maaakL1ap/8TccViSe3905fuZtpsiaV5a96CkT6ZySTopHZMnJE2VNLK7vhSO98JGjomZmfVMy5KdrkTEuIgYBewFzI2IUel1Ta19JH0D2BP4eNp3d7JL4AF+QHaJ/IiIGA7cAFxXSVqAN1P9WwOvkN0gEUmDgJuAiRExAtgO2An4Zq7pPwMndtGdduD36W9e1Tar9GsFYF/gT8A/FVYva9sARMSO6Vh9D7gyd5zndxHrYuAb6dhdB9yQjunmwBDgtC7iaSlJQ4GrgeMiYkREbA/8FlhV0nbAmcA+EbEl8M/AmflkEbLh2Mpx4L1+j4qIc6s0OSFtdzxwfiobR/Yd2S4iNgd+CNwkaeUWdNnMzJqgV5KdZXQC8G8R8RpARLwWERenf9V/GRgfEUvSuouAt4HdqtRzL7Bhev8vwB8i4ra03yLgKLIft4qbgZGSRhQrSgnBgcARwJ5d/ODl2yzaFXgE+BlLJy3NaLtRdwMfJTt2b6VjSTq244GvVM6k9IJxwMURcW+lICKuiYgXgGOBH0TEvFQ+jywRmdCEdu8iOyYAxwFHpe8K6btzD76buJlZn9Uvkh1JqwGrRsRTVVZ/FHimkgTldADvG16QNIDsjNBNqWgkMD2/TUTMBYakNgHeBU4nS7aKdgLmpX2mAUvdLrVKm0XtwOXA9cDekj6UW9ejthslaUXgc8BMqh+b14BneO+Hf3nbmkJMOUvFS5XvwDL6AjAzfSdWqfI9bFY7ZmbWAq1Mdmo9h6Lr51O0xiBJncDzZPcGur3B/S8DPiHpI4XyduCK9P4K3n9mpts20/yXvciGil4D7gM+24S2G1WJtYMsmfllD+rqqWrfj974zgCckY7LkcBXW92YpCMldUjqWLLo1VY3Z2b2gdHKZOcvwJqFsrWAlxutKCUCCyVtWmX1XGATSasWyncgGx6CNDcD+DDZPJ/K/JlH03Z/l9pYmD9TFBHvAGeRDWFUthsA7A98T9J84KfAmFwctdrM+yywBtlZg/nAzhSSlmVsu1H5uSv/JyIWU/3YrAZsAjy5jO1U6rk1Tfy9oMrq4vcm/515pBhTzlLx8v7vwLKYkI7JnhExK30n3qjyPexpOwBExOSIGB0RowcMXr2n1ZmZWdKyZCciFgLPSdoNQNJawBiyCbXL4ofAeZXhJUlDJB0eEW8AFwM/TkkAyq7SGgzcWYhpEXA08O9pyOZSYGdJe6T9BgHnkg0dFU0B9gDWTcu7Aw9HxMYR0RYRHwauJZts3FWbee3A19L+bcBHyObfFOfELFPbPXQHMFjvXfE2gCzpmlKZr7KsIuKzKYn4WpXV04DDcpPLxwJT0/tJwFhJO1Y2lrRfmrh8JvBdpavV0t8TUszNdAZwbvqukL47O5OdgTMzsz6o1XN2DgdOTkMBdwKnpjkmy+JnZD96D6RLke8mm9MC8F3gLeAJSXPIJu7uG1Ue6Z5uhPgw0B4RbwL7ACdJmk02V+UBsh/V4n6LyRKh9VJRO9k8m7xrqTKclG+zUpYSmjHkni+WErffk80RaUrbyyodu32BA9MxfYLsGFebP9RMk4HXgRmSZpBdAXZmiukF4BCyq6xmS3qM7OzY6xHRSXb261eSHgd+BXwnlTfTT8m+IzPTd+ZksivA3mxyO2Zm1iSqkg+YWS8bOGx4DBt7Tm+HYT00f2KPrxswswZImh4Ro4vl/eJqLDMzM7Nl5WTHzMzMSs3JjpmZmZWakx0zMzMrNSc7ZmZmVmrF+76YWR+wzYar0+EreczMmsJndszMzKzUnOyYmZlZqTnZMTMzs1JzsmNmZmal5mTHzMzMSs3JjpmZmZWakx0zMzMrNSc7ZmZmVmpOdszMzKzUnOyYmZlZqTnZMTMzs1JzsmNmZmal5mTHzMzMSs3JjpmZmZWakx0zMzMrNSc7ZmZmVmpOdszMzKzUnOyYmZlZqTnZMTMzs1JzsmNmZmal5mTHzMzMSm3F3g7AzJY2c8GrtB1/S2+HsdzMn7h3b4dgZiXmMztmZmZWak52zMzMrNSc7JiZmVmpOdkxMzOzUnOyY2ZmZqXmZMfMzMxKzcmOmZmZlZqTHWuIpCWSOnOvNkm7Sro5rT9C0ktp3SOSrpE0OK07RdKCtO5RSe25eiXpJElzJD0haaqkkbn1X5E0U9LDkmZJ2ieVT5E0LxfPPTXi/rikuyTNlvSQpAskDU7xTkrbjJA0LdXzmKTJkj6bq3th2r9T0iX5fqf9PyepI/XtIUlnFWLolHRFMz8PMzPrnm8qaI16MyJG5QsktRW2uTIijkrrLgMOBi5K686OiDMlDQemS7omIv4GjAN2AraLiEWSPgPclBKedYATgY9FxKuShgDr5tqbEBHX1ApY0lDgauCQiLg3lR0ArFrY9NwU341pm20iYiZwa1qeBhwbER1peddcG1sDk4C9I+JxSQOAI3PrtwQGALtIWiUi3qgVr5mZNZfP7FjLSFoRWAX43+K6iJgDLALWTEXHAUdFxKK0/jbgHuBQYD3gdWBhWrcwIuY1EMo44OJKopPquCYiXihsNwz4c26bmQ208R3gtIh4PO27JCJ+llvfDvw3cBuwTwP1mplZDznZsUYNyg3rXF9jm4MldQILgLWAXxU3kPQxYE5EvChpNWCViHiqsFkHMBKYAbwAzJN0kaQvFLY7IxfTpVXi2RqYXkffzgbulPQbSeMlrVHHPtp5i+cAAAYaSURBVPW2cTBwBXA5WeKzFElHpmGwjiWLXm2gaTMz64qTHWvUmxExKr32rbHNlWmoa31gJjAht268pEeA+4DT6mkwIpYAY4ADgCeAsyWdkttkQi6mQxvsT76di4AtyYa8dgX+KGngstZXIWk08HJEPAPcAWwvaa0q7U+OiNERMXrA4NV72qyZmSVOdqxlIiLIzur8Y6747IgYCewP/FLSyhHxGvCGpE0LVewAPFKpKyLuj4gfAoek/ev1SKqrnpifjYgLI2If4B2yMzY9baMd2ELSfGAusBqNxW9mZj3gZMdabWeyH/j3iYibyIapxqaiM4BzJQ0CkLRH2vcySRukYa+KUcDTDcQwCRgracdKgaT90sRlcmVjJH0ovV8fWJtsKK4eZwAnSNo87b+CpG9IWgE4CNgmItoioo1szk7VoSwzM2s+X41lrXCwpJ3Jkuk/A0fU2O77ZMnML4Cfkk1WnilpCfA8sE9EvClpPeBMSRsAbwEvAd/I1XOGpJNyyx+PiMWVhYh4QdIhqY71gHeBu4DfFuL5DPATSW+l5QkR8Xw9HY6IhyV9C7g8XWofwM3ALsCCiHg2t/ldwFaShkXEc/XUb2Zmy07ZSIOZ9SUDhw2PYWPP6e0wlpv5E/fu7RDMrAQkTY+I0cVyD2OZmZlZqTnZMTMzs1JzsmNmZmal5mTHzMzMSs3JjpmZmZWaLz0364O22XB1OnyFkplZU/jMjpmZmZWakx0zMzMrNSc7ZmZmVmpOdszMzKzUnOyYmZlZqTnZMTMzs1JzsmNmZmal5mTHzMzMSs3JjpmZmZWakx0zMzMrNUVEb8dgZgWSXgdm93Ycy9E6wMu9HcRy5P6W3wetz32lvx+OiHWLhX42llnfNDsiRvd2EMuLpA73t7w+aP2FD16f+3p/PYxlZmZmpeZkx8zMzErNyY5Z3zS5twNYztzfcvug9Rc+eH3u0/31BGUzMzMrNZ/ZMTMzs1JzsmNmZmal5mTHrA+RNEbSbElPSjq+t+NpBUkXSnpR0qxc2VqSbpc0J/1dszdjbCZJG0uaKulRSY9IOiaVl7LPklaWdL+kGam/p6byj0i6L323r5S0Um/H2kySBkh6SNLNabm0/ZU0X9JMSZ2SOlJZn/4+O9kx6yMkDQDOAz4HbAW0S9qqd6NqiSnAmELZ8cAdETEcuCMtl8U7wL9HxFbAJ4Bx6XMta5/fBnaLiO2AUcAYSZ8AfgScHREfBf4X+GovxtgKxwCP5ZbL3t9PR8So3L11+vT32cmOWd/xceDJiHgqIhYDVwD79HJMTRcRdwGvFIr3AS5O7y8Gvrhcg2qhiHguIh5M718n+0HckJL2OTIL0+KH0iuA3YBrUnlp+gsgaSNgb+CCtCxK3N8a+vT32cmOWd+xIfCn3PKfU9kHwdCIeC69fx4Y2pvBtIqkNmB74D5K3Oc0pNMJvAjcDswF/hoR76RNyvbdPgf4DvBuWl6bcvc3gNskTZd0ZCrr099nPy7CzPqUiAhJpbsnhqQhwLXAtyLitewf/5my9TkilgCjJK0BXA9s0cshtYykzwMvRsR0Sbv2djzLyc4RsUDSesDtkh7Pr+yL32ef2THrOxYAG+eWN0plHwQvSBoGkP6+2MvxNJWkD5ElOpdGxHWpuNR9BoiIvwJTgU8Ca0iq/AO7TN/tTwH/LGk+2dDzbsBPKG9/iYgF6e+LZMnsx+nj32cnO2Z9xwPA8HQVx0rAIcBNvRzT8nITMDa9Hwvc2IuxNFWav/FL4LGI+HFuVSn7LGnddEYHSYOAPcnmKU0FDkiblaa/EfHdiNgoItrI/pu9MyIOpaT9lbSKpFUr74HPALPo499n30HZrA+RtBfZ+P8A4MKIOK2XQ2o6SZcDuwLrAC8A/wHcAFwFbAI8DRwUEcVJzP2SpJ2Bu4GZvDen4wSyeTul67OkbckmqA4g+wf1VRHxfUmbkp35WAt4CDgsIt7uvUibLw1jHRsRny9rf1O/rk+LKwKXRcRpktamD3+fneyYmZlZqXkYy8zMzErNyY6ZmZmVmpMdMzMzKzUnO2ZmZlZqTnbMzMys1JzsmJmZWak52TEzM7NS+//UwYM9vYYXoQAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "84BTbAMt-mJb",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 282
        },
        "outputId": "89d8848e-686b-4cb4-e34e-d0695acec5e1"
      },
      "source": [
        "df_leitos.groupby('descricao_leito')['QT_EXIST'].size().sort_values().tail().plot(kind='barh')"
      ],
      "execution_count": 207,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7feeb5872b00>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 207
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAfgAAAD4CAYAAAAAX/TLAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3de5QcVbn38e+PQAIhEEAQYkAGMIRLEkOIgko8CMhFVAQCZFaUoCBHT95XCRcB8bwvumSBggYVXy4iF1lIEDAYuYVrTvAcBCbkDoQQiUggREACmCAYnveP2o1F0z3TPTM9PVP8Pmv1mqpdu3Y91Wl4eu/aXaWIwMzMzIplvWYHYGZmZt3PCd7MzKyAnODNzMwKyAnezMysgJzgzczMCmj9ZgdgxbfllltGS0tLs8MwM+tT5syZ80JEbNXZ/Z3greFaWlpoa2trdhhmZn2KpD93ZX8P0ZuZmRWQE7yZmVkBOcGbmZkVkBO8mZlZATnBm5mZFZATvJmZWQE5wZuZmRWQE7yZmVkBOcGbmZkVkO9kZw23cMVqWs64tdlhmJn1qOXnHdrU47sHb2ZmVkBO8GZmZgXkBG9mZlZATvBmZmYF5ARvZmZWQE7wZmZmBeQEb2ZmVkBO8O2QtI2kaZKWSZoj6TZJO0tqkbSoQv2rJI1Py7MkteW2jZU0Ky3vK+mW3LZDJLVJelTSXEk/Kmt3nqRpHcT6RUkLJC2WNF/S5ZI2y8WyJLUzT9KNqfxsSStS2aOSWsva/IKkkLRLrqziuZuZWe/iBF+FJAHTgVkRsVNE7AmcCWxdRzPvl3RIB8cZAVwEfDEidgPGAk/mtu8K9APGSdq4ShsHA1OAQyJid2AM8D9lsU6MiNHpNT5XPjUiRgOHAZdK2iC3rRX4Q/prZmZ9iBN8dZ8C3oyIS0oFETE/Iu6vo43zgbM6qPMt4JyIeDwdY11EXJzb3gpcA9xJloQrOQs4NSJW5Nq4IiKW1BpoRCwF1gCbA0gaBOwDHA9MqLUdMzPrHZzgqxsBzOliGw8Ab0j6VBeOcwwwDbiO6j3p3YFHOojl2twQ/fnlGyWNAZZGxKpUdBhwR0Q8Abwoac8O2i9v78R02aFt3ZrV9exqZmbdwAm+8b4PfKczO0oaC7wQEU8D9wB7SNqig31GpiS+TNIxuU35IfrTcuVTJC0GHgTOyZW3kn2xIP2ta5g+Ii6LiLERMbbfwMH17GpmZt3ACb66xUBdvdZKIuJeYCNg704cpxXYRdJyYBmwKXBklTbGpOMtTNfUb0/H7cjUdN3+SOCXkjZMXyL2Ay5Pxz4NODrNSzAzsz7ACb66e4EBkk4sFUgaJWlcJ9r6Ptm19krOB74taed0jPUkfU3SesDRwMiIaImIFrJh80o96XOBCyRtmyurJbm/LSJmAG3AJGA8cE1EbJ+OvR3wFNCZczczsybw42KriIiQdDhwoaTTgdeB5cBJqcpwSc/kdpnSTlu3SfprlW0LJJ0EXCdpIBDALWTJdEVEPJurPhvYTdKQiHiurP2tgNsl9QNeBhYBM3P7XitpbVp+ISIOqBDO94BfA88CPyjbdhPZl4sfVDr3iLih2vmbmVnPU0Q0OwYruAFDhsWQSRc2Owwzsx7V1efBS5oTEWM7u7+H6M3MzArICd7MzKyAnODNzMwKyAnezMysgJzgzczMCsg/k7OGGzl0MG1dnE1qZmb1cQ/ezMysgJzgzczMCsgJ3szMrICc4M3MzArICd7MzKyAnODNzMwKyAnezMysgJzgzczMCsgJ3szMrICc4M3MzArICd7MzKyAnODNzMwKyAnezMysgJzgzczMCsgJ3szMrICc4M3MzArICd7MzKyAnODNzMwKyAnezMysgJzgzczMCsgJ3szMrIDWb3YAVnwLV6ym5Yxbmx2GmfUCy887tNkhvGe4B29mZlZATvBmZmYF5ARvZmZWQE7wZmZmBeQEb2ZmVkBO8GZmZgVUyAQvaZ2keZIWSbpB0sCy8tLrjFQ+S9ISSQskPS7pIkmb5dp7raz9kyS9LmmwpPfl2lspaUVuvX9ZLL8vtSupRdKisnYvTPtX/XeR9FFJs1O8cyVdLmmgpOMkXVSh/nJJW6blkPSj3LZTJZ2dls+WdGrZtsdT7A9LOja3bUtJb0r6Wo3/JGZm1sMKmeCBtRExOiJGAG8AXysrL73Oy+0zMSJGAaOAfwC/a6f9VuBh4IiIeLHUHnAJMDXX/htlsbwETK7UYErqhwN/Af6tSp2tgRuA0yNieETsAdwBbFLLm5LO64hSwq8mJe5PAx9N57U/oFyVo4A/kr0PZmbWCxU1wefdD3yo1sopKX8L+KCkD5dvl7QTMAj4DvUnuAeAoVW27QssBi5up93JwNUR8UAu3hsj4vkaj/9P4DJgSgf1vg18PSJeScd4JSKuzm1vBU4BhkratsZjm5lZDyp0gpe0PnAIsDAVbVQ2RH9Mpf0iYh0wH9ilwuYJwDSyLw7DU6+6llj6kfWEZ1Sp0gpcB0wHDpW0QYU6I4A5tRyvHT8HJkoaXCXOTYFNIuJPVbZvBwyJiIeA3wAV30MzM2uuoib4jSTNA9qAp4FfpvLyIfrr22lDVcpbgWkR8RZwE9lwdS2xrAS2Bu5614Gk/sBngJtTr/lB4KAO2u2U1P6vgG90soljyBI7ZF90Ko42SDpRUpuktnVrVnfyUGZm1llFvRf92nTtuFNSb3sk8FhZ+UhgGHCXJID+wFPAuya3lceSJvrNJBtm/2lZnYOAzYCFqd2BwFrglrJ6i4E9aX9+QC0uBB4BrizfEBGvSHpN0o5VevGtwDaSJqb1D0gaFhFLy9q5jOxyAAOGDIsuxmtmZnUqag++09LQ+LnAXyJiQdnmVuDsiGhJrw+QJbjtO2o3ItaQ9ZpPSZcOyts9odQusAPw6dLs/5yLgEmS9srFe0StlwlysbxE1gs/vkqVc4Gfp+F6JA2SdKyknYFBETE0F+u5eLKdmVmv815L8OXX4POz6K+VtABYBGwMHFZh/wlk18jzpqfyDkXEXGABuYSYkvjBwK25en8H/gB8rmz/59OxLkg/k3uMrPf/aqpynKRncq/2JsD9CKg2m/5i4D7g4fRTvvuBt1Lc5ed/E07wZma9jiI8emqNNWDIsBgy6cJmh2FmvYAfF1s7SXMiYmxn93+v9eDNzMzeE5zgzczMCsgJ3szMrIDqTvBpRvWgRgRjZmZm3aPmBC9ppKS5ZL/FflTSHEkjGheamZmZdVY9N7q5FDg5Iu4DkLQv2Y1MPt6AuKxARg4dTJtnzpqZ9ah6hug3LiV3gIiYRfZ7cTMzM+tl6unB/0nSfwLXpPUvAhUfSGJmZmbNVU8P/ivAVsBvye5etiXw5UYEZWZmZl1TTw/+gIh4xxPIJB0F3NC9IZmZmVlX1dODP7PGMjMzM2uyDnvwkg4he1b5UEn5x5xuCvyzUYGZmZlZ59UyRP8s0AZ8HpiTK38VmNKIoMzMzKxrOkzwETEfmC/p2ohwj93MzKwPqGWI/jcRcTQwV9K7ni0bEaMaEpmZmZl1Wi1D9N9Mfz/byEDMzMys+3Q4iz4inkt//5yKhqXlVcBLDYzNzMzMOqmeh818FbiR7J70ANsCNzciKDMzM+uaen4HPxn4BPAKQEQsBd7fiKDMzMysa+pJ8P+IiDdKK5LWB9416c7MzMyar54E/1+Svg1sJOnTZLeo/X1jwjIzM7OuqCfBnwH8FVgI/DtwG/CdRgRlZmZmXVPzw2Yi4i3gF+llZmZmvVgtN7pZSDvX2n2jGzMzs96nlh68b3BjZmbWx9RyL/o/d1QHQNIDEfGxrodkZmZmXVXPJLuObNiNbZmZmVkX1DzJrgb+TbxVtHDFalrOuLXZYZhZD1l+3qHNDsHo3h68mZmZ9RLdmeDVjW2ZmZlZF9Q1RC9pa+AjafWhiFiV2/ylbovKzMzMuqSep8kdDTwEHAUcDTwoaXxpe0Qs6v7wzMzMrDPq6cGfBXyk1GuXtBVwN9kjZM3MzKwXqeca/HplQ/Iv1rm/mZmZ9ZB6evB3SJoJXJfWjyF74IyZmZn1MjX3wCPiNOAyYFR6XRYRpzcqsEaTtI2kaZKWSZoj6TZJO0tqkbQo1dlX0mpJ8yQ9LumC3P5nSzq1rM3lkrZMy+vSfosk/V7SZrl6wyTdkjv2fZI+mbYdJ+misnbnSZrWwfl8UdICSYslzZd0eemYkmZJWpLamSfpxtw5rEhlj0pqLWvzC5JC0i65srffHzMz673qGmKPiJsi4uT0mt6ooBpNkoDpwKyI2Cki9gTOBLauUP3+iBgN7AF8VtInajzM2ogYHREjgJeAyenYGwK3kn1BKh37fwM7Vol1V6AfME7SxlXqHAxMAQ6JiN2BMcD/lJ3PxBTP6IgYnyufms7vMOBSSRvktrUCf0h/zcysD6lnFv3ekh6W9JqkN1IP9ZVGBtdAnwLejIhLSgURMT8i7q+2Q0SsBeYBQztxvAdy+00EHoiIGbm2F0XEVVX2bQWuAe4kS8KVnAWcGhErUnvrIuKKiFhSa4ARsRRYA2wOIGkQsA9wPDCh1nbMzKx3qKcHfxFZslkKbAScAPy8EUH1gBHAnHp2kLQ5MAyYXed+/YD9gVJC3x14pI4mjgGmkc19qNaTrqXNa3ND9OdXiHMMsDQ3kfIw4I6IeAJ4UdKedcSMpBMltUlqW7dmdT27mplZN6h3iP5JoF/qIV4JHNyYsHqVcZLmAyuAmRGxMpVXu/d+qXwjSfOAlWRD5XdVqixperpO/9sK28YCL0TE08A9wB6StmgvWEkjUxJfJumY3Kb8EP1pufIpkhYDDwLn5Mpbyb5YkP7WNUwfEZdFxNiIGNtv4OB6djUzs25QT4JfI6k/ME/SDyVNqXP/3mQxUGuP9P6I+DBZL/l4SaNT+Yuk4eycTYCX0/LadG17e7Lb+E7OHXtMaYeIOBw4DqiUuFuBXSQtB5YBmwJHVjmfMam9hem4t5ONtHRkarpufyTwS0kbpi8R+wGXp2OfBhyd5i6YmVkfUE+C/lKq/7+AvwPbUTnZ9AX3AgMknVgqkDRK0rhqO0TEU8B5QOmXA7OBz0vaJO1/BDA/ItaV7bcG+AZwiqT1gV8Dn5D0+Vy1geXHk7Qe2R0DR0ZES0S0kA2bV+pJnwtcIGnbXFktyT0f5wygDZgEjAeuiYjt07G3A54Cqr4/ZmbWu9TzO/gXgDci4nXgu+na8oDGhNVYERGSDgculHQ68DqwHDipg10vAU6V1BIRC9LP2f4gKYBVZPMSKh1vrqQFQGtEXCPps8CPJV0IPA+8Cny/bLdxwIqIeDZXNhvYTdKQiHgu1/5t6c6Ct6d/l5eBRcDM3L7XSlqbll+IiAMqhPo9si8gzwI/KNt2E9mXix8AwyU9k9s2JSJuqHTuZmbWHIqo7THukv4IHBARr6X1QcCdEfHxBsZnBTBgyLAYMunCZodhZj3Ez4PvHpLmRMTYzu5fzxD9hqXkDpCW3zW0bGZmZs1XT4L/e/opFQDpZ1Nr26lvZmZmTVLPNfiTgBskPUs2K3wbst9om5mZWS9Tc4KPiIfTPcmHp6IlEfFmY8IyMzOzrugwwUvaLyLuTT8Dy9tZEhHxrhu0mJmZWXPV0oP/N7LfjX+uwrYAnOCtXSOHDqbNs2rNzHpUhwk+Iv5vuunK7RHxmx6IyczMzLqopln0EfEW8K0Gx2JmZmbdpJ6fyd0t6VRJ20naovRqWGRmZmbWafX8TK70k7jJubIAduy+cMzMzKw71PMzuR0aGYiZmZl1n5qH6CVNlrRZbn1zSf/RmLDMzMysK+q5Bv/ViCg965yI+Bvw1e4PyczMzLqqngTfT5JKK+mxpP27PyQzMzPrqnom2d0BXC/p0rT+76nMzMzMepl6EvzpwInA19P6XcDl3R6RmZmZdVk9s+jfAi4BLkm/f982ItY1LDIzMzPrtHpm0c+StGlK7nOAX0ia2rjQzMzMrLPqmWQ3OCJeAY4AfhURewH7NyYsMzMz64p6Evz6koYARwO3NCgeMzMz6wb1JPjvATOBZRHxsKQdgaWNCcvMzMy6op5JdjcAN+TW/wQc2YigzMzMrGvqmWS3s6R7JC1K66MkfadxoZmZmVln1TNE/wvgTOBNgIhYAExoRFBmZmbWNfUk+IER8VBZ2T+7MxgzMzPrHvUk+Bck7UT2DHgkjQeea0hUZmZm1iX13Kp2MnAZsIukFcBTwMSGRGVmZmZdoohov4J0clnRRmQ9/78DRMSPGxOaFcWAIcNiyKQLmx2GWa+1/LxDmx2C9UKS5kTE2M7uX0sPfpP0dzjwEeB3gIAvAeXX5M3MzKwX6DDBR8R3ASTNBsZExKtp/Wzg1oZGZ2ZmZp1SzyS7rYE3cutvpDIzMzPrZeqZZPcr4CFJ09P6F4Cruj0iMzMz67J6blV7jqTbgXGp6MsRMbcxYZmZmVlX1NODJyIeAR5pUCxmZmbWTeq5Bt/jJG0r6XeSlkpaJuknkvqnbftKWi1pnqQFku6W9P60bbikWWnbY5Iuk3RQWp8n6TVJS9Lyr8raKr2OyS2vlLQit95f0rq0vEjS7yVtlo7dUrpff1r/qKTZ6XhzJV0uaaCk4yRdVHa+8yRN6+A9OTYdc2Fq79RUflW6+VC+7tuxpHMMSZ/Lbb9F0r5peZaksWl5kKRL03s+J23bK7ffF1Jbu3Tin9XMzHpAr03wkgT8Frg5IoYBOwODgHNy1e6PiNERMQp4mOxmPAA/BaambbsCP4uImWl9NNAGTEzrx5a1VXpdn6t/Sa690RHxBrA2LY8AXsodO38OW5M9ge/0iBgeEXsAd/Cvnx7m6+4K9APGSdq4yntyCHAScGBEjAT2BlbX+JYCPAOcVUO9y8nOaVhE7Al8Gdgyt70V+EP6a2ZmvVCvTfDAfsDrEXElQESsA6YAX5E0MF8xfRnYBPhbKhpClsxI+y5scKwPAEMrlE8Gro6IB3Kx3BgRz1eo2wpcA9wJHFblOGcCp0bEs6mtf0TEL+qIcz6wWtKnq1VItyPeC/hORLyVjvNURNyatg8C9gGOxw8bMjPrtXpzgt8dmJMviIhXgKeBD6WicZLmpbIDgCtS+VTgXkm3S5pSGj7vwLiyIfqdaglSUj9gf2BGhc0jys+hHccA04DrqN4zrqe9as4B2nvM7+7AvPSFqpLDgDsi4gngRUl7djEeMzNrgN6c4GtRGlbfDrgS+CFA6vXvSjY8vi/wR0kDamyr9FrWQf2N0peLlWT3A7irsyeRrn2/EBFPA/cAe0jaorPttSciZqdj7tPJJlrJvoiQ/lb8MiLpREltktrWrannKoKZmXWH3pzgHwXe0TuUtCnwQeDJCvVnAJ8srUTEsxFxRUQcRvZY2xHdHN/adH1+e7Jb977rGjywmLJzqKKV7CE+y4FlwKbAkV1oryPt9eIXAx9OIxPvkL507AdcnmI9DTg6XSJ5h4i4LCLGRsTYfgMHd0PIZmZWj96c4O8BBko6Ft4eCv8RcFVErKlQfx+y5IikgyVtkJa3Ad4HrGhEkCmWbwCnSCr/2eFFwKSyGehHpMl3pfX1gKOBkRHREhEtZMPglXrG5wLnp3MizeY/oRMx3wlsDoyqsG0Z2STE75YSd5qNfygwHrgmIrZPsW5H9lTBceXtmJlZc/XaBB/ZY+4OB46StBR4Angd+HauWum6+Xyyh9+cksoPBBal8pnAaRGxsoNDll+DH99B/Xysc4EFlCXlNJluAnBB+pncY8BBwKv54wIrShPnktnAbpKGlLV3G9mXhrslLSa7J8GmuSqXSnomvR6gfecA21XZdgLZZYcn08/srgJWpfObXlb3Jjyb3sys1+nwcbFmXeXHxZq1z4+LtUrUxcfF9toevJmZmXWeE7yZmVkBOcGbmZkVkBO8mZlZATnBm5mZFVBdj4s164yRQwfT5lnCZmY9yj14MzOzAnKCNzMzKyAneDMzswJygjczMysgJ3gzM7MCcoI3MzMrICd4MzOzAnKCNzMzKyAneDMzswJygjczMysgJ3gzM7MCcoI3MzMrICd4MzOzAnKCNzMzKyAneDMzswJygjczMysgJ3gzM7MCcoI3MzMrICd4MzOzAnKCNzMzKyAneDMzswJav9kBWPEtXLGaljNubXYYZnVZft6hzQ7BrEvcgzczMysgJ3gzM7MCcoI3MzMrICd4MzOzAnKCNzMzKyAneDMzswJygjczMyughiZ4SdtK+p2kpZKWSfqJpP5p276SVkuaJ2mBpLslvT9tGy5pVtr2mKTLJB2U1udJek3SkrT8q7K2Sq9jcssrJa3IrfeXtC4tL5L0e0mbpWO3SFqUO4ePSpqdjjdX0uWSBko6TtJFZec7T9K0Dt6TY9MxF6b2Tk3lV0kan5ZnpePNl/SwpNG5/V8ra+/tOCSdnTvPRyW1ltU9WdLj6djzJf1Y0gZp23JJW6blbSRNS/9mcyTdJmnnXDsnSXpd0uBaPwtmZtazGpbgJQn4LXBzRAwDdgYGAefkqt0fEaMjYhTwMDA5lf8UmJq27Qr8LCJmpvXRQBswMa0fW9ZW6XV9rv4lufZGR8QbwNq0PAJ4KXfs/DlsDdwAnB4RwyNiD+AOYJMKdXcF+gHjJG1c5T05BDgJODAiRgJ7A6urvIUTI+LDwP8Dzq9Sp5Kp6ZwPAy7NJfCvAQcCe6djfwRYBWxUFqOA6cCsiNgpIvYEzgS2zlVrJfv3OqKOuMzMrAc1sge/H/B6RFwJEBHrgCnAVyQNzFdMSWUT4G+paAjwTGl7RCxsYJwADwBDK5RPBq6OiAdysdwYEc9XqNsKXAPcSZZcKzkTODUink1t/SMiftHJ2NoVEUuBNcDmqegs4OsR8XLa/kZEnBcRr5Tt+ingzYi4JNfW/Ii4H0DSTmRf1L5Dds5mZtYLNTLB7w7MyRekZPI08KFUNE7SvFR2AHBFKp8K3CvpdklTSsPnHRhXNkS/Uy1BSuoH7A/MqLB5RPk5tOMYYBpwHdUTXz3tlRwM3FznPkgaAyyNiFWSNgUGRcRTNezaUYwTyM7zfmB4GuWodPwTJbVJalu3ptoghZmZNUqzJ9mVhtW3A64EfgiQev27kg2P7wv8UdKAGtsqvZZ1UH+j9OViJdnw812dPQlJY4EXIuJp4B5gD0lbdLa95FpJT5H1vH/eQd3ILU+RtBh4kHdeDsnHW5rPsFzSx+uMqxWYFhFvATcBR1UMKOKyiBgbEWP7DfSlejOzntbIBP8osGe+IPUkPwg8WaH+DOCTpZWIeDYiroiIw4B/kvUsu9PadK16e0BUuAYPLKbsHKpoBXaRtBxYBmwKHNmF9gAmAjsCVwM/y8ddmqiYbAG8kFufGhG7p+P/UtKGaeTkNUk7AJTmMwCLgHxb7cYoaSQwDLgrnesEPExvZtYrNTLB3wMMlHQsvD0U/iPgqohYU6H+PmTJEUkH5yaHbQO8D1jRiCBTLN8ATpFU/nS9i4BJkvYqFUg6Ij8sLWk94GhgZES0REQL2TX4SonvXOD8dE6k2fwntBNbAP8J7C1pl1T8X8AX0/4bpWPfV2HfGWSTESfljn1x7tcCAjascNh7gQGSTsyd4yhJ49I5nV06z4j4APABSdtXOwczM2uOhiX4lJwOB46StBR4Angd+HauWum6+XzgS8ApqfxAYFEqnwmcFhErOzhk+TX48XXEOhdYQFlSTpPpJgAXpJ+tPQYcBLyaPy6wojRxLpkN7CZpSFl7t5F9abg7DaM/Qtbbby+2tWRfjE5LRd8EjkiXF/4I3BARs6vs/j3g5PQl5GKyL10PSloA/DcwN73yxyv9ux2Qfia3mOzLwcr0XkwvO8b0VG5mZr2Isv+fmzXOgCHDYsikC5sdhlld/Dx4azZJcyJibGf3b/YkOzMzM2sAJ3gzM7MCcoI3MzMrICd4MzOzAnKCNzMzK6Dy332bdbuRQwfT5hnJZmY9yj14MzOzAnKCNzMzKyAneDMzswJygjczMysgJ3gzM7MCcoI3MzMrICd4MzOzAnKCNzMzKyAneDMzswJygjczMysgRUSzY7CCk/QqsKTZcXTSlsALzQ6iC/py/H05dujb8Tv25snHv31EbNXZhnwveusJSyJibLOD6AxJbX01dujb8ffl2KFvx+/Ym6c74/cQvZmZWQE5wZuZmRWQE7z1hMuaHUAX9OXYoW/H35djh74dv2Nvnm6L35PszMzMCsg9eDMzswJygjczMysgJ3hrGEkHS1oi6UlJZzQ7nhJJV0haJWlRrmwLSXdJWpr+bp7KJemn6RwWSBqT22dSqr9U0qQein07SfdJelTSYknf7CvxS9pQ0kOS5qfYv5vKd5D0YIrxekn9U/mAtP5k2t6Sa+vMVL5E0kGNjr3sPPpJmivplr4Uv6TlkhZKmiepLZX1+s9N7ribSbpR0uOSHpP0sb4Qv6Th6T0vvV6RdFKPxB4RfvnV7S+gH7AM2BHoD8wHdmt2XCm2TwJjgEW5sh8CZ6TlM4AfpOXPALcDAvYGHkzlWwB/Sn83T8ub90DsQ4AxaXkT4Algt74Qf4phUFreAHgwxfQbYEIqvwT4elr+D+CStDwBuD4t75Y+TwOAHdLnrF8Pfn5OBn4N3JLW+0T8wHJgy7KyXv+5ycV6NXBCWu4PbNaX4k/H7wesBLbvidh75KT8eu+9gI8BM3PrZwJnNjuuXDwtvDPBLwGGpOUhZDfnAbgUaC2vB7QCl+bK31GvB8/jd8Cn+1r8wEDgEWAvsrt2rV/+uQFmAh9Ly+uneir/LOXr9UDc2wL3APsBt6R4+kT8VE7wfeJzAwwGniJNDO9r8eeOdyDw3z0Vu4forVGGAn/JrT+TynqrrSPiubS8Etg6LVc7j6afXxry3YOsJ9wn4k/D2/OAVcBdZL3XlyPinxXieDvGtH018L5mxZ5cCHwLeCutv4++E38Ad0qaI+nEVNYnPjdkIx1/Ba5Ml0cul7QxfSf+kgnAdWm54bE7wZuViezrca/+/aikQcBNwEkR8Up+W2+OPyLWRcRosp7wR4FdmhxSzSR9FlgVEXOaHUsn7RMRY4BDgMmSPpnf2Js/N2QjIGOAiyNiD+DvZMPab+vl8ZPmZnweuKF8W6Nid4K3RlkBbM0irioAAAHzSURBVJdb3zaV9VbPSxoCkP6uSuXVzqNp5ydpA7Lkfm1E/DYV95n4ASLiZeA+siHtzSSVnouRj+PtGNP2wcCLNC/2TwCfl7QcmEY2TP8T+kj8EbEi/V0FTCf7gtVXPjfPAM9ExINp/UayhN9X4ofsi9UjEfF8Wm947E7w1igPA8PSDOP+ZENTM5ocU3tmAKVZqZPIrm2Xyo9NM1v3BlanYbWZwIGSNk+zXw9MZQ0lScAvgcci4sd9KX5JW0naLC1vRDZ34DGyRD++SuylcxoP3Jt6OjOACWmW+g7AMOChRsYOEBFnRsS2EdFC9nm+NyIm9oX4JW0saZPSMtm/9yL6wOcGICJWAn+RNDwV7Q882lfiT1r51/B8KcbGxt5Tkwv8eu+9yGaDPkF2nfWsZseTi+s64DngTbKewfFk10bvAZYCdwNbpLoCfp7OYSEwNtfOV4An0+vLPRT7PmRDeQuAeen1mb4QPzAKmJtiXwT8n1S+I1mCe5Js+HJAKt8wrT+Ztu+Ya+usdE5LgEOa8Bnal3/Nou/18acY56fX4tJ/j33hc5M77migLX1+biabSd4n4gc2Jhu9GZwra3jsvlWtmZlZAXmI3szMrICc4M3MzArICd7MzKyAnODNzMwKyAnezMysgJzgzczMCsgJ3szMrID+P/7QF2bRntoYAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "S5iV3EWydFzR",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 85
        },
        "outputId": "0961dd50-0dd5-4319-8a3f-d0e9edfca709"
      },
      "source": [
        "df_cnes.columns"
      ],
      "execution_count": 209,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['CO_UNIDADE', 'CO_CNES', 'CO_REGIAO_SAUDE', 'CO_ATIVIDADE',\n",
              "       'cod_unidades', 'CO_TURNO_ATENDIMENTO', 'CO_MUNICIPIO_GESTOR',\n",
              "       'TP_ESTAB_SEMPRE_ABERTO', 'TP_GESTAO', 'descricao'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 209
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "G0hEJPA2dGDp",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 68
        },
        "outputId": "67b8aaf9-62ef-43be-a911-4226932c92fa"
      },
      "source": [
        "df_leitos.columns"
      ],
      "execution_count": 210,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['CO_UNIDADE', 'CO_LEITO', 'QT_EXIST', 'QT_SUS', 'descricao_leito',\n",
              "       'tpleito'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 210
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pegoknDNdGUt",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "df_final = pd.merge(df_cnes, df_leitos, on='CO_UNIDADE')"
      ],
      "execution_count": 211,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DJ6aoii4dG0L",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 394
        },
        "outputId": "7e382d93-cba0-4a91-c457-32032e3e83b5"
      },
      "source": [
        "df_final.head()"
      ],
      "execution_count": 212,
      "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>CO_UNIDADE</th>\n",
              "      <th>CO_CNES</th>\n",
              "      <th>CO_REGIAO_SAUDE</th>\n",
              "      <th>CO_ATIVIDADE</th>\n",
              "      <th>cod_unidades</th>\n",
              "      <th>CO_TURNO_ATENDIMENTO</th>\n",
              "      <th>CO_MUNICIPIO_GESTOR</th>\n",
              "      <th>TP_ESTAB_SEMPRE_ABERTO</th>\n",
              "      <th>TP_GESTAO</th>\n",
              "      <th>descricao</th>\n",
              "      <th>CO_LEITO</th>\n",
              "      <th>QT_EXIST</th>\n",
              "      <th>QT_SUS</th>\n",
              "      <th>descricao_leito</th>\n",
              "      <th>tpleito</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>3303307383851</td>\n",
              "      <td>7383851</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "      <td>36</td>\n",
              "      <td>3.0</td>\n",
              "      <td>330330</td>\n",
              "      <td>S</td>\n",
              "      <td>M</td>\n",
              "      <td>CLINICA/CENTRO DE ESPECIALIDADE</td>\n",
              "      <td>33</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>CLINICA GERAL</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>3303307384920</td>\n",
              "      <td>7384920</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "      <td>36</td>\n",
              "      <td>4.0</td>\n",
              "      <td>330330</td>\n",
              "      <td>S</td>\n",
              "      <td>M</td>\n",
              "      <td>CLINICA/CENTRO DE ESPECIALIDADE</td>\n",
              "      <td>33</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>CLINICA GERAL</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3202207394780</td>\n",
              "      <td>7394780</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "      <td>36</td>\n",
              "      <td>6.0</td>\n",
              "      <td>320220</td>\n",
              "      <td>S</td>\n",
              "      <td>M</td>\n",
              "      <td>CLINICA/CENTRO DE ESPECIALIDADE</td>\n",
              "      <td>47</td>\n",
              "      <td>60</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1500805994047</td>\n",
              "      <td>5994047</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "      <td>36</td>\n",
              "      <td>3.0</td>\n",
              "      <td>150080</td>\n",
              "      <td>NaN</td>\n",
              "      <td>M</td>\n",
              "      <td>CLINICA/CENTRO DE ESPECIALIDADE</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>BUCO MAXILO FACIAL</td>\n",
              "      <td>INTERNACAO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>3304557473699</td>\n",
              "      <td>7473699</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "      <td>36</td>\n",
              "      <td>6.0</td>\n",
              "      <td>330455</td>\n",
              "      <td>NaN</td>\n",
              "      <td>M</td>\n",
              "      <td>CLINICA/CENTRO DE ESPECIALIDADE</td>\n",
              "      <td>74</td>\n",
              "      <td>21</td>\n",
              "      <td>0</td>\n",
              "      <td>UTI ADULTO - TIPO I</td>\n",
              "      <td>SADT</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      CO_UNIDADE  CO_CNES  ...      descricao_leito       tpleito\n",
              "0  3303307383851  7383851  ...        CLINICA GERAL  AMBULATORIAL\n",
              "1  3303307384920  7384920  ...        CLINICA GERAL  AMBULATORIAL\n",
              "2  3202207394780  7394780  ...                  NaN           NaN\n",
              "3  1500805994047  5994047  ...   BUCO MAXILO FACIAL    INTERNACAO\n",
              "4  3304557473699  7473699  ...  UTI ADULTO - TIPO I          SADT\n",
              "\n",
              "[5 rows x 15 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 212
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "JjoBCPine5G8",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 102
        },
        "outputId": "036ff2b3-00eb-4969-fed3-995ea38087aa"
      },
      "source": [
        "df_final.columns"
      ],
      "execution_count": 213,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['CO_UNIDADE', 'CO_CNES', 'CO_REGIAO_SAUDE', 'CO_ATIVIDADE',\n",
              "       'cod_unidades', 'CO_TURNO_ATENDIMENTO', 'CO_MUNICIPIO_GESTOR',\n",
              "       'TP_ESTAB_SEMPRE_ABERTO', 'TP_GESTAO', 'descricao', 'CO_LEITO',\n",
              "       'QT_EXIST', 'QT_SUS', 'descricao_leito', 'tpleito'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 213
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "KSnqYBFGe8IM",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 213
        },
        "outputId": "c88b8021-a19a-45c0-b999-28dcf28e9dae"
      },
      "source": [
        "#verificando a quantidade de leitos em hospitais gerais\n",
        "hospitais = df_final[df_final['cod_unidades'] == 5]\n",
        "hospitais.head(3)\n"
      ],
      "execution_count": 216,
      "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>CO_UNIDADE</th>\n",
              "      <th>CO_CNES</th>\n",
              "      <th>CO_REGIAO_SAUDE</th>\n",
              "      <th>CO_ATIVIDADE</th>\n",
              "      <th>cod_unidades</th>\n",
              "      <th>CO_TURNO_ATENDIMENTO</th>\n",
              "      <th>CO_MUNICIPIO_GESTOR</th>\n",
              "      <th>TP_ESTAB_SEMPRE_ABERTO</th>\n",
              "      <th>TP_GESTAO</th>\n",
              "      <th>descricao</th>\n",
              "      <th>CO_LEITO</th>\n",
              "      <th>QT_EXIST</th>\n",
              "      <th>QT_SUS</th>\n",
              "      <th>descricao_leito</th>\n",
              "      <th>tpleito</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>860</th>\n",
              "      <td>4312905230241</td>\n",
              "      <td>5230241</td>\n",
              "      <td>5CRS</td>\n",
              "      <td>4</td>\n",
              "      <td>5</td>\n",
              "      <td>4.0</td>\n",
              "      <td>431290</td>\n",
              "      <td>S</td>\n",
              "      <td>M</td>\n",
              "      <td>HOSPITAL GERAL</td>\n",
              "      <td>33</td>\n",
              "      <td>14</td>\n",
              "      <td>6</td>\n",
              "      <td>CLINICA GERAL</td>\n",
              "      <td>AMBULATORIAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>861</th>\n",
              "      <td>4312905230241</td>\n",
              "      <td>5230241</td>\n",
              "      <td>5CRS</td>\n",
              "      <td>4</td>\n",
              "      <td>5</td>\n",
              "      <td>4.0</td>\n",
              "      <td>431290</td>\n",
              "      <td>S</td>\n",
              "      <td>M</td>\n",
              "      <td>HOSPITAL GERAL</td>\n",
              "      <td>10</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>OBSTETRICIA CIRURGICA</td>\n",
              "      <td>URGENCIA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>862</th>\n",
              "      <td>4312905230241</td>\n",
              "      <td>5230241</td>\n",
              "      <td>5CRS</td>\n",
              "      <td>4</td>\n",
              "      <td>5</td>\n",
              "      <td>4.0</td>\n",
              "      <td>431290</td>\n",
              "      <td>S</td>\n",
              "      <td>M</td>\n",
              "      <td>HOSPITAL GERAL</td>\n",
              "      <td>45</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>PEDIATRIA CLINICA</td>\n",
              "      <td>OUTROS</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        CO_UNIDADE  CO_CNES  ...        descricao_leito       tpleito\n",
              "860  4312905230241  5230241  ...          CLINICA GERAL  AMBULATORIAL\n",
              "861  4312905230241  5230241  ...  OBSTETRICIA CIRURGICA      URGENCIA\n",
              "862  4312905230241  5230241  ...      PEDIATRIA CLINICA        OUTROS\n",
              "\n",
              "[3 rows x 15 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 216
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "AzDw-kHngB11",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "b8d0df12-d799-4ea8-fdd2-8426ac1e56a1"
      },
      "source": [
        "hospitais['QT_EXIST'].sum()"
      ],
      "execution_count": 219,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "423194"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 219
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Sv2pfVxOhWFl",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 918
        },
        "outputId": "153251f3-3a16-4213-b37e-491190915fb6"
      },
      "source": [
        "hospitais['descricao_leito'].value_counts().sort_values(ascending=False)"
      ],
      "execution_count": 220,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "CLINICA GERAL                                        5450\n",
              "CIRURGIA GERAL                                       4739\n",
              "PEDIATRIA CLINICA                                    4480\n",
              "OBSTETRICIA CLINICA                                  3542\n",
              "OBSTETRICIA CIRURGICA                                3238\n",
              "UNIDADE ISOLAMENTO                                   1632\n",
              "GINECOLOGIA                                          1536\n",
              "ORTOPEDIATRAUMATOLOGIA                               1442\n",
              "CARDIOLOGIA                                          1363\n",
              "UTI ADULTO - TIPO II                                 1126\n",
              "PEDIATRIA CIRURGICA                                   959\n",
              "ONCOLOGIA                                             897\n",
              "NEFROLOGIAUROLOGIA                                    729\n",
              "PLASTICA                                              696\n",
              "NEFROUROLOGIA                                         659\n",
              "NEUROCIRURGIA                                         651\n",
              "OTORRINOLARINGOLOGIA                                  648\n",
              "NEUROLOGIA                                            645\n",
              "UTI ADULTO - TIPO I                                   602\n",
              "GASTROENTEROLOGIA                                     547\n",
              "CRONICOS                                              540\n",
              "BUCO MAXILO FACIAL                                    537\n",
              "CIRURGICO/DIAGNOSTICO/TERAPEUTICO                     532\n",
              "NEONATOLOGIA                                          497\n",
              "OFTALMOLOGIA                                          490\n",
              "UTI NEONATAL - TIPO II                                452\n",
              "AIDS                                                  422\n",
              "SAUDE MENTAL                                          419\n",
              "TORACICA                                              419\n",
              "UNIDADE DE CUIDADOS INTERMEDIARIOS NEONATAL CO...     414\n",
              "GERIATRIA                                             347\n",
              "HEMATOLOGIA                                           319\n",
              "UTI PEDIATRICA - TIPO II                              309\n",
              "UNIDADE DE CUIDADOS INTERMEDIARIOS ADULTO             276\n",
              "DERMATOLOGIA                                          235\n",
              "ENDOCRINOLOGIA                                        214\n",
              "UTI NEONATAL - TIPO I                                 197\n",
              "UTI ADULTO - TIPO III                                 187\n",
              "UNIDADE DE CUIDADOS INTERMEDIARIOS NEONATAL CA...     179\n",
              "TRANSPLANTE                                           174\n",
              "UTI PEDIATRICA - TIPO I                               161\n",
              "UTI NEONATAL - TIPO III                                85\n",
              "UTI PEDIATRICA - TIPO III                              79\n",
              "UTI CORONARIANA TIPO II - UCO TIPO II                  71\n",
              "HANSENOLOGIA                                           68\n",
              "UNIDADE DE CUIDADOS INTERMEDIARIOS PEDIATRICO          64\n",
              "QUEIMADO ADULTO                                        62\n",
              "QUEIMADO PEDIATRICO                                    48\n",
              "UTI DE QUEIMADOS                                       46\n",
              "INTERCORRENCIA POS-TRANSPLANTE                         36\n",
              "UTI CORONARIANA TIPO III - UCO TIPO III                16\n",
              "FIBROSE CISTICA                                         9\n",
              "Name: descricao_leito, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 220
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4w2uRTHuib3l",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 935
        },
        "outputId": "55032832-6824-4be3-9d43-15a4dc04ac84"
      },
      "source": [
        "hospitais.groupby('descricao_leito')['QT_EXIST'].sum().sort_values(ascending=False)"
      ],
      "execution_count": 223,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "descricao_leito\n",
              "CLINICA GERAL                                        118170\n",
              "CIRURGIA GERAL                                        61434\n",
              "PEDIATRIA CLINICA                                     39982\n",
              "OBSTETRICIA CIRURGICA                                 24886\n",
              "OBSTETRICIA CLINICA                                   23248\n",
              "UTI ADULTO - TIPO II                                  16876\n",
              "ORTOPEDIATRAUMATOLOGIA                                16400\n",
              "CARDIOLOGIA                                           10808\n",
              "UTI ADULTO - TIPO I                                    7219\n",
              "CRONICOS                                               7168\n",
              "ONCOLOGIA                                              7089\n",
              "GINECOLOGIA                                            6471\n",
              "NEUROCIRURGIA                                          4710\n",
              "UTI ADULTO - TIPO III                                  4541\n",
              "UTI NEONATAL - TIPO II                                 4504\n",
              "PEDIATRIA CIRURGICA                                    4374\n",
              "CIRURGICO/DIAGNOSTICO/TERAPEUTICO                      4128\n",
              "UNIDADE ISOLAMENTO                                     4015\n",
              "NEUROLOGIA                                             3932\n",
              "UNIDADE DE CUIDADOS INTERMEDIARIOS NEONATAL CO...      3437\n",
              "NEFROLOGIAUROLOGIA                                     3068\n",
              "NEFROUROLOGIA                                          2991\n",
              "NEONATOLOGIA                                           2841\n",
              "SAUDE MENTAL                                           2409\n",
              "PLASTICA                                               2197\n",
              "UNIDADE DE CUIDADOS INTERMEDIARIOS ADULTO              2190\n",
              "GERIATRIA                                              2177\n",
              "AIDS                                                   2096\n",
              "GASTROENTEROLOGIA                                      2015\n",
              "UTI PEDIATRICA - TIPO II                               2001\n",
              "OTORRINOLARINGOLOGIA                                   1810\n",
              "UTI NEONATAL - TIPO I                                  1409\n",
              "OFTALMOLOGIA                                           1263\n",
              "HEMATOLOGIA                                            1220\n",
              "TRANSPLANTE                                            1105\n",
              "UTI NEONATAL - TIPO III                                1092\n",
              "BUCO MAXILO FACIAL                                     1088\n",
              "TORACICA                                               1044\n",
              "UNIDADE DE CUIDADOS INTERMEDIARIOS NEONATAL CA...       855\n",
              "UTI PEDIATRICA - TIPO I                                 814\n",
              "UTI PEDIATRICA - TIPO III                               778\n",
              "UTI CORONARIANA TIPO II - UCO TIPO II                   610\n",
              "DERMATOLOGIA                                            493\n",
              "ENDOCRINOLOGIA                                          412\n",
              "QUEIMADO ADULTO                                         251\n",
              "UTI DE QUEIMADOS                                        224\n",
              "UNIDADE DE CUIDADOS INTERMEDIARIOS PEDIATRICO           217\n",
              "INTERCORRENCIA POS-TRANSPLANTE                          176\n",
              "HANSENOLOGIA                                            147\n",
              "UTI CORONARIANA TIPO III - UCO TIPO III                 145\n",
              "QUEIMADO PEDIATRICO                                     115\n",
              "FIBROSE CISTICA                                          20\n",
              "Name: QT_EXIST, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 223
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "sPaJRGhUjEKc",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 935
        },
        "outputId": "21bfedee-d4b4-4e9f-bc2a-c535d46c7216"
      },
      "source": [
        "hospitais.groupby('descricao_leito')['QT_SUS'].sum().sort_values(ascending=False)"
      ],
      "execution_count": 224,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "descricao_leito\n",
              "CLINICA GERAL                                        81953\n",
              "CIRURGIA GERAL                                       37956\n",
              "PEDIATRIA CLINICA                                    31150\n",
              "OBSTETRICIA CLINICA                                  17699\n",
              "OBSTETRICIA CIRURGICA                                16621\n",
              "ORTOPEDIATRAUMATOLOGIA                               12507\n",
              "UTI ADULTO - TIPO II                                 10582\n",
              "CARDIOLOGIA                                           6039\n",
              "CRONICOS                                              5882\n",
              "ONCOLOGIA                                             4400\n",
              "GINECOLOGIA                                           3901\n",
              "NEUROCIRURGIA                                         3281\n",
              "PEDIATRIA CIRURGICA                                   3062\n",
              "UTI NEONATAL - TIPO II                                3003\n",
              "UNIDADE ISOLAMENTO                                    2875\n",
              "NEUROLOGIA                                            2587\n",
              "AIDS                                                  1870\n",
              "UNIDADE DE CUIDADOS INTERMEDIARIOS NEONATAL CO...     1861\n",
              "UTI ADULTO - TIPO III                                 1812\n",
              "NEONATOLOGIA                                          1792\n",
              "NEFROUROLOGIA                                         1785\n",
              "CIRURGICO/DIAGNOSTICO/TERAPEUTICO                     1785\n",
              "NEFROLOGIAUROLOGIA                                    1752\n",
              "SAUDE MENTAL                                          1682\n",
              "UTI PEDIATRICA - TIPO II                              1373\n",
              "UNIDADE DE CUIDADOS INTERMEDIARIOS ADULTO              999\n",
              "PLASTICA                                               901\n",
              "TRANSPLANTE                                            899\n",
              "GASTROENTEROLOGIA                                      850\n",
              "GERIATRIA                                              835\n",
              "OTORRINOLARINGOLOGIA                                   731\n",
              "OFTALMOLOGIA                                           672\n",
              "HEMATOLOGIA                                            657\n",
              "BUCO MAXILO FACIAL                                     652\n",
              "UTI NEONATAL - TIPO III                                616\n",
              "TORACICA                                               527\n",
              "UTI PEDIATRICA - TIPO III                              453\n",
              "UNIDADE DE CUIDADOS INTERMEDIARIOS NEONATAL CA...      445\n",
              "UTI ADULTO - TIPO I                                    414\n",
              "DERMATOLOGIA                                           259\n",
              "QUEIMADO ADULTO                                        213\n",
              "UTI DE QUEIMADOS                                       165\n",
              "INTERCORRENCIA POS-TRANSPLANTE                         164\n",
              "UTI CORONARIANA TIPO II - UCO TIPO II                  158\n",
              "ENDOCRINOLOGIA                                         148\n",
              "UNIDADE DE CUIDADOS INTERMEDIARIOS PEDIATRICO          124\n",
              "HANSENOLOGIA                                           110\n",
              "QUEIMADO PEDIATRICO                                     86\n",
              "UTI PEDIATRICA - TIPO I                                 51\n",
              "UTI CORONARIANA TIPO III - UCO TIPO III                 26\n",
              "FIBROSE CISTICA                                         14\n",
              "UTI NEONATAL - TIPO I                                    7\n",
              "Name: QT_SUS, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 224
        }
      ]
    }
  ]
}