Skip to content

Instantly share code, notes, and snippets.

@ayr-ton

ayr-ton/leitos-hospitalares-em-tempo-real.ipynb

Created March 18, 2021 14:04
Show Gist options
  • Save ayr-ton/9c6d2ddb15b9d92ff95210c4b9dec9e0 to your computer and use it in GitHub Desktop.
Save ayr-ton/9c6d2ddb15b9d92ff95210c4b9dec9e0 to your computer and use it in GitHub Desktop.
Download ZIP
Leitos hospitalares em tempo real.ipynb
Display the source blob
Display the rendered blob
Raw
leitos-hospitalares-em-tempo-real.ipynb
{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"name": "Leitos hospitalares em tempo real.ipynb",
"provenance": [],
"collapsed_sections": [
"gPeDLM4il0Y2"
],
"authorship_tag": "ABX9TyPIMyh7TsPhSwZaaGqW9j4u",
"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/gist/ayr-ton/9c6d2ddb15b9d92ff95210c4b9dec9e0/leitos-hospitalares-em-tempo-real.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "gPeDLM4il0Y2"
},
"source": [
"## Conectando com API de leitos\n",
"\n",
"Documentação: https://opendatasus.saude.gov.br/dataset/registro-de-ocupacao-hospitalar"
]
},
{
"cell_type": "code",
"metadata": {
"id": "uKaN3uBNktyq",
"colab": {
"base_uri": "https://localhost:8080/"
},
"outputId": "13677c46-722f-42ba-ec7d-d4fe48a45121"
},
"source": [
"%pip install elasticsearch\n",
"import pandas as pd\n",
"from elasticsearch import Elasticsearch"
],
"execution_count": 2,
"outputs": [
{
"output_type": "stream",
"text": [
"Collecting elasticsearch\n",
"\u001b[?25l Downloading https://files.pythonhosted.org/packages/72/68/76c5d46cc6a48fddb759f585bc8728caa11bfc9b812ce6705fc5f99beab2/elasticsearch-7.11.0-py2.py3-none-any.whl (325kB)\n",
"\r\u001b[K |█ | 10kB 17.4MB/s eta 0:00:01\r\u001b[K |██ | 20kB 23.4MB/s eta 0:00:01\r\u001b[K |███ | 30kB 12.6MB/s eta 0:00:01\r\u001b[K |████ | 40kB 10.1MB/s eta 0:00:01\r\u001b[K |█████ | 51kB 9.2MB/s eta 0:00:01\r\u001b[K |██████ | 61kB 9.3MB/s eta 0:00:01\r\u001b[K |███████ | 71kB 9.1MB/s eta 0:00:01\r\u001b[K |████████ | 81kB 9.4MB/s eta 0:00:01\r\u001b[K |█████████ | 92kB 8.8MB/s eta 0:00:01\r\u001b[K |██████████ | 102kB 8.6MB/s eta 0:00:01\r\u001b[K |███████████ | 112kB 8.6MB/s eta 0:00:01\r\u001b[K |████████████ | 122kB 8.6MB/s eta 0:00:01\r\u001b[K |█████████████ | 133kB 8.6MB/s eta 0:00:01\r\u001b[K |██████████████ | 143kB 8.6MB/s eta 0:00:01\r\u001b[K |███████████████ | 153kB 8.6MB/s eta 0:00:01\r\u001b[K |████████████████ | 163kB 8.6MB/s eta 0:00:01\r\u001b[K |█████████████████ | 174kB 8.6MB/s eta 0:00:01\r\u001b[K |██████████████████▏ | 184kB 8.6MB/s eta 0:00:01\r\u001b[K |███████████████████▏ | 194kB 8.6MB/s eta 0:00:01\r\u001b[K |████████████████████▏ | 204kB 8.6MB/s eta 0:00:01\r\u001b[K |█████████████████████▏ | 215kB 8.6MB/s eta 0:00:01\r\u001b[K |██████████████████████▏ | 225kB 8.6MB/s eta 0:00:01\r\u001b[K |███████████████████████▏ | 235kB 8.6MB/s eta 0:00:01\r\u001b[K |████████████████████████▏ | 245kB 8.6MB/s eta 0:00:01\r\u001b[K |█████████████████████████▏ | 256kB 8.6MB/s eta 0:00:01\r\u001b[K |██████████████████████████▏ | 266kB 8.6MB/s eta 0:00:01\r\u001b[K |███████████████████████████▏ | 276kB 8.6MB/s eta 0:00:01\r\u001b[K |████████████████████████████▏ | 286kB 8.6MB/s eta 0:00:01\r\u001b[K |█████████████████████████████▏ | 296kB 8.6MB/s eta 0:00:01\r\u001b[K |██████████████████████████████▏ | 307kB 8.6MB/s eta 0:00:01\r\u001b[K |███████████████████████████████▏| 317kB 8.6MB/s eta 0:00:01\r\u001b[K |████████████████████████████████| 327kB 8.6MB/s \n",
"\u001b[?25hRequirement already satisfied: urllib3<2,>=1.21.1 in /usr/local/lib/python3.7/dist-packages (from elasticsearch) (1.24.3)\n",
"Requirement already satisfied: certifi in /usr/local/lib/python3.7/dist-packages (from elasticsearch) (2020.12.5)\n",
"Installing collected packages: elasticsearch\n",
"Successfully installed elasticsearch-7.11.0\n"
],
"name": "stdout"
}
]
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "c1Xt-woJlDIk",
"outputId": "10ac5159-09a5-4243-85a6-de2981a1d6ff"
},
"source": [
"elastic_client = Elasticsearch(['https://user-api-leitos:[email protected]:443/'])\n",
"schema_leitos = elastic_client.indices.get_mapping()\n",
"\n",
"schema_leitos"
],
"execution_count": 3,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"{'leito_ocupacao': {'mappings': {'properties': {'_created_at': {'type': 'date'},\n",
" '_p_usuario': {'type': 'keyword'},\n",
" '_updated_at': {'type': 'date'},\n",
" 'algumaOcupacaoInformada': {'type': 'boolean'},\n",
" 'altas': {'type': 'long'},\n",
" 'cnes': {'type': 'keyword'},\n",
" 'dataNotificacao': {'type': 'date'},\n",
" 'dataNotificacaoOcupacao': {'type': 'date'},\n",
" 'estado': {'fields': {'keyword': {'ignore_above': 256, 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'estadoNotificacao': {'type': 'keyword'},\n",
" 'estadoSigla': {'fields': {'keyword': {'ignore_above': 256,\n",
" 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'excluido': {'type': 'boolean'},\n",
" 'latitude': {'type': 'float'},\n",
" 'longitude': {'type': 'float'},\n",
" 'municipio': {'fields': {'keyword': {'ignore_above': 256,\n",
" 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'municipioNotificacao': {'fields': {'keyword': {'ignore_above': 256,\n",
" 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'nomeCnes': {'fields': {'keyword': {'ignore_above': 256,\n",
" 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'obitos': {'type': 'long'},\n",
" 'ocupHospCli': {'type': 'long'},\n",
" 'ocupHospUti': {'type': 'long'},\n",
" 'ocupSRAGCli': {'type': 'long'},\n",
" 'ocupSRAGUti': {'type': 'long'},\n",
" 'ocupacaoConfirmadoCli': {'type': 'long'},\n",
" 'ocupacaoConfirmadoExt': {'type': 'long'},\n",
" 'ocupacaoConfirmadoUti': {'type': 'long'},\n",
" 'ocupacaoInformada': {'type': 'boolean'},\n",
" 'ocupacaoSuspeitoCli': {'type': 'long'},\n",
" 'ocupacaoSuspeitoExt': {'type': 'long'},\n",
" 'ocupacaoSuspeitoUti': {'type': 'long'},\n",
" 'ocupacaoTotalCli': {'type': 'long'},\n",
" 'ocupacaoTotalUti': {'type': 'long'},\n",
" 'ofertaHospCli': {'type': 'long'},\n",
" 'ofertaHospUti': {'type': 'long'},\n",
" 'ofertaRespiradores': {'type': 'long'},\n",
" 'ofertaSRAGCli': {'type': 'long'},\n",
" 'ofertaSRAGUti': {'type': 'long'},\n",
" 'origem': {'type': 'keyword'},\n",
" 'saidaConfirmadaObitos': {'type': 'long'},\n",
" 'saidaConfirmadaOutros': {'type': 'long'},\n",
" 'saidaObito': {'type': 'long'},\n",
" 'saidaOutros': {'type': 'long'},\n",
" 'saidaSuspeitaObitos': {'type': 'long'},\n",
" 'saidaSuspeitaOutros': {'type': 'long'},\n",
" 'source_id': {'type': 'keyword'},\n",
" 'totalConfirmados': {'type': 'long'},\n",
" 'totalSuspeitos': {'type': 'long'},\n",
" 'validado': {'type': 'boolean'}}}},\n",
" 'leito_ocupacao_estadual': {'mappings': {'properties': {'_created_at': {'type': 'date'},\n",
" '_p_usuario': {'type': 'keyword'},\n",
" '_updated_at': {'type': 'date'},\n",
" 'cnes': {'type': 'keyword'},\n",
" 'dataNotificacao': {'type': 'date'},\n",
" 'esfera': {'fields': {'keyword': {'ignore_above': 256, 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'estado': {'fields': {'keyword': {'ignore_above': 256, 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'estadoNotificacao': {'type': 'keyword'},\n",
" 'excluido': {'type': 'boolean'},\n",
" 'latitude': {'type': 'float'},\n",
" 'longitude': {'type': 'float'},\n",
" 'municipio': {'fields': {'keyword': {'ignore_above': 256,\n",
" 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'municipioNotificacao': {'fields': {'keyword': {'ignore_above': 256,\n",
" 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'ocupacaoConfirmadoCli': {'type': 'long'},\n",
" 'ocupacaoConfirmadoExt': {'type': 'long'},\n",
" 'ocupacaoConfirmadoUti': {'type': 'long'},\n",
" 'ocupacaoHospPercCli': {'type': 'long'},\n",
" 'ocupacaoHospPercUti': {'type': 'long'},\n",
" 'ocupacaoSragPercCli': {'type': 'long'},\n",
" 'ocupacaoSragPercUti': {'type': 'long'},\n",
" 'ocupacaoSuspeitoCli': {'type': 'long'},\n",
" 'ocupacaoSuspeitoExt': {'type': 'long'},\n",
" 'ocupacaoSuspeitoUti': {'type': 'long'},\n",
" 'ocupacaoTotalCli': {'type': 'long'},\n",
" 'ocupacaoTotalUti': {'type': 'long'},\n",
" 'origem': {'type': 'keyword'},\n",
" 'saidaConfirmadaAltas': {'type': 'long'},\n",
" 'saidaConfirmadaObitos': {'type': 'long'},\n",
" 'saidaConfirmadaOutros': {'type': 'long'},\n",
" 'saidaObito': {'type': 'long'},\n",
" 'saidaOutros': {'type': 'long'},\n",
" 'saidaSuspeitaAltas': {'type': 'long'},\n",
" 'saidaSuspeitaObitos': {'type': 'long'},\n",
" 'saidaSuspeitaOutros': {'type': 'long'},\n",
" 'source_id': {'type': 'keyword'},\n",
" 'totalConfirmados': {'type': 'long'},\n",
" 'totalSuspeitos': {'type': 'long'},\n",
" 'validado': {'type': 'boolean'}}}},\n",
" 'leito_ocupacao_federal': {'mappings': {'properties': {'_created_at': {'type': 'date'},\n",
" '_p_usuario': {'type': 'keyword'},\n",
" '_updated_at': {'type': 'date'},\n",
" 'cnes': {'type': 'keyword'},\n",
" 'dataNotificacao': {'type': 'date'},\n",
" 'esfera': {'fields': {'keyword': {'ignore_above': 256, 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'estado': {'fields': {'keyword': {'ignore_above': 256, 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'estadoNotificacao': {'type': 'keyword'},\n",
" 'excluido': {'type': 'boolean'},\n",
" 'latitude': {'type': 'float'},\n",
" 'longitude': {'type': 'float'},\n",
" 'municipio': {'fields': {'keyword': {'ignore_above': 256,\n",
" 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'municipioNotificacao': {'fields': {'keyword': {'ignore_above': 256,\n",
" 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'ocupacaoConfirmadoCli': {'type': 'long'},\n",
" 'ocupacaoConfirmadoExt': {'type': 'long'},\n",
" 'ocupacaoConfirmadoUti': {'type': 'long'},\n",
" 'ocupacaoHospPercCli': {'type': 'long'},\n",
" 'ocupacaoHospPercUti': {'type': 'long'},\n",
" 'ocupacaoSragPercCli': {'type': 'long'},\n",
" 'ocupacaoSragPercUti': {'type': 'long'},\n",
" 'ocupacaoSuspeitoCli': {'type': 'long'},\n",
" 'ocupacaoSuspeitoExt': {'type': 'long'},\n",
" 'ocupacaoSuspeitoUti': {'type': 'long'},\n",
" 'ocupacaoTotalCli': {'type': 'long'},\n",
" 'ocupacaoTotalUti': {'type': 'long'},\n",
" 'origem': {'type': 'keyword'},\n",
" 'saidaConfirmadaAltas': {'type': 'long'},\n",
" 'saidaConfirmadaObitos': {'type': 'long'},\n",
" 'saidaConfirmadaOutros': {'type': 'long'},\n",
" 'saidaObito': {'type': 'long'},\n",
" 'saidaOutros': {'type': 'long'},\n",
" 'saidaSuspeitaAltas': {'type': 'long'},\n",
" 'saidaSuspeitaObitos': {'type': 'long'},\n",
" 'saidaSuspeitaOutros': {'type': 'long'},\n",
" 'source_id': {'type': 'keyword'},\n",
" 'totalConfirmados': {'type': 'long'},\n",
" 'totalSuspeitos': {'type': 'long'},\n",
" 'validado': {'type': 'boolean'}}}},\n",
" 'leito_ocupacao_municipal': {'mappings': {'properties': {'_created_at': {'type': 'date'},\n",
" '_p_usuario': {'type': 'keyword'},\n",
" '_updated_at': {'type': 'date'},\n",
" 'cnes': {'type': 'keyword'},\n",
" 'dataNotificacao': {'type': 'date'},\n",
" 'esfera': {'fields': {'keyword': {'ignore_above': 256, 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'estado': {'fields': {'keyword': {'ignore_above': 256, 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'estadoNotificacao': {'type': 'keyword'},\n",
" 'excluido': {'type': 'boolean'},\n",
" 'latitude': {'type': 'float'},\n",
" 'longitude': {'type': 'float'},\n",
" 'municipio': {'fields': {'keyword': {'ignore_above': 256,\n",
" 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'municipioNotificacao': {'fields': {'keyword': {'ignore_above': 256,\n",
" 'type': 'keyword'}},\n",
" 'type': 'text'},\n",
" 'ocupacaoConfirmadoCli': {'type': 'long'},\n",
" 'ocupacaoConfirmadoExt': {'type': 'long'},\n",
" 'ocupacaoConfirmadoUti': {'type': 'long'},\n",
" 'ocupacaoHospPercCli': {'type': 'long'},\n",
" 'ocupacaoHospPercUti': {'type': 'long'},\n",
" 'ocupacaoSragPercCli': {'type': 'long'},\n",
" 'ocupacaoSragPercUti': {'type': 'long'},\n",
" 'ocupacaoSuspeitoCli': {'type': 'long'},\n",
" 'ocupacaoSuspeitoExt': {'type': 'long'},\n",
" 'ocupacaoSuspeitoUti': {'type': 'long'},\n",
" 'ocupacaoTotalCli': {'type': 'long'},\n",
" 'ocupacaoTotalUti': {'type': 'long'},\n",
" 'origem': {'type': 'keyword'},\n",
" 'saidaConfirmadaAltas': {'type': 'long'},\n",
" 'saidaConfirmadaObitos': {'type': 'long'},\n",
" 'saidaConfirmadaOutros': {'type': 'long'},\n",
" 'saidaObito': {'type': 'long'},\n",
" 'saidaOutros': {'type': 'long'},\n",
" 'saidaSuspeitaAltas': {'type': 'long'},\n",
" 'saidaSuspeitaObitos': {'type': 'long'},\n",
" 'saidaSuspeitaOutros': {'type': 'long'},\n",
" 'source_id': {'type': 'keyword'},\n",
" 'totalConfirmados': {'type': 'long'},\n",
" 'totalSuspeitos': {'type': 'long'},\n",
" 'validado': {'type': 'boolean'}}}}}"
]
},
"metadata": {
"tags": []
},
"execution_count": 3
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "jGTEal1amUMW"
},
"source": [
"## Belo Horizonte (17/03/2021)"
]
},
{
"cell_type": "code",
"metadata": {
"id": "2Cu3FUCTlQWU"
},
"source": [
"# Filtrando pela cidade do seu interesse\n",
"body = {\n",
" \"query\": {\n",
" \"match\": {\n",
" \"municipio\": \"Belo Horizonte\"\n",
" }\n",
" }\n",
"}\n",
"\n",
"resultados_bh = elastic_client.search(index=\"leito_ocupacao\", body=body)\n",
"resultados_bh['hits']['hits']\n",
"\n",
"ocupação_hospitalar_bh = pd.DataFrame.from_dict([document['_source'] for document in resultados_bh['hits']['hits']])"
],
"execution_count": 4,
"outputs": []
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 719
},
"id": "f_oUuKG4lnUb",
"outputId": "6402f5b1-5e0a-4d85-d161-6d06a8a37f5c"
},
"source": [
"# Prioriza quem tem oferta de respiradores primeiro\n",
"ocupação_hospitalar_bh.sort_values(by='ofertaRespiradores', ascending=False)"
],
"execution_count": 6,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>estado</th>\n",
" <th>estadoSigla</th>\n",
" <th>municipio</th>\n",
" <th>cnes</th>\n",
" <th>dataNotificacaoOcupacao</th>\n",
" <th>ocupHospCli</th>\n",
" <th>ocupHospUti</th>\n",
" <th>ocupSRAGCli</th>\n",
" <th>ocupSRAGUti</th>\n",
" <th>altas</th>\n",
" <th>obitos</th>\n",
" <th>ocupacaoInformada</th>\n",
" <th>algumaOcupacaoInformada</th>\n",
" <th>nomeCnes</th>\n",
" <th>ofertaRespiradores</th>\n",
" <th>ofertaHospCli</th>\n",
" <th>ofertaHospUti</th>\n",
" <th>ofertaSRAGCli</th>\n",
" <th>ofertaSRAGUti</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Minas Gerais</td>\n",
" <td>MG</td>\n",
" <td>Belo Horizonte</td>\n",
" <td>7866801</td>\n",
" <td>2021-03-17T17:02:41.000Z</td>\n",
" <td>313</td>\n",
" <td>93</td>\n",
" <td>132</td>\n",
" <td>37</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>HOSPITAL METROPOLITANO DOUTOR CELIO DE CASTRO ...</td>\n",
" <td>106.0</td>\n",
" <td>433.0</td>\n",
" <td>80.0</td>\n",
" <td>228.0</td>\n",
" <td>40.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Minas Gerais</td>\n",
" <td>MG</td>\n",
" <td>Belo Horizonte</td>\n",
" <td>2200422</td>\n",
" <td>2021-03-17T17:02:41.000Z</td>\n",
" <td>21</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>HOSPITAL MADRE TERESA</td>\n",
" <td>55.0</td>\n",
" <td>279.0</td>\n",
" <td>16.0</td>\n",
" <td>3.0</td>\n",
" <td>5.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Minas Gerais</td>\n",
" <td>MG</td>\n",
" <td>Belo Horizonte</td>\n",
" <td>0026859</td>\n",
" <td>2021-03-17T17:02:41.000Z</td>\n",
" <td>53</td>\n",
" <td>13</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>HOSPITAL FELICIO ROCHO</td>\n",
" <td>50.0</td>\n",
" <td>304.0</td>\n",
" <td>9.0</td>\n",
" <td>10.0</td>\n",
" <td>4.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Minas Gerais</td>\n",
" <td>MG</td>\n",
" <td>Belo Horizonte</td>\n",
" <td>4034236</td>\n",
" <td>2021-03-17T17:02:41.000Z</td>\n",
" <td>141</td>\n",
" <td>28</td>\n",
" <td>10</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>HOSPITAL UNIVERSITARIO CIENCIAS MEDICAS</td>\n",
" <td>34.0</td>\n",
" <td>201.0</td>\n",
" <td>28.0</td>\n",
" <td>5.0</td>\n",
" <td>1.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Minas Gerais</td>\n",
" <td>MG</td>\n",
" <td>Belo Horizonte</td>\n",
" <td>0026808</td>\n",
" <td>2021-03-17T17:02:41.000Z</td>\n",
" <td>57</td>\n",
" <td>14</td>\n",
" <td>10</td>\n",
" <td>6</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>HOSPITAL EVANGELICO DE BELO HORIZONTE</td>\n",
" <td>24.0</td>\n",
" <td>146.0</td>\n",
" <td>12.0</td>\n",
" <td>15.0</td>\n",
" <td>16.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Minas Gerais</td>\n",
" <td>MG</td>\n",
" <td>Belo Horizonte</td>\n",
" <td>2181770</td>\n",
" <td>2021-03-17T17:02:41.000Z</td>\n",
" <td>59</td>\n",
" <td>30</td>\n",
" <td>50</td>\n",
" <td>30</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>HOSPITAL EDUARDO DE MENEZES</td>\n",
" <td>10.0</td>\n",
" <td>66.0</td>\n",
" <td>10.0</td>\n",
" <td>44.0</td>\n",
" <td>52.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Minas Gerais</td>\n",
" <td>MG</td>\n",
" <td>Belo Horizonte</td>\n",
" <td>2695375</td>\n",
" <td>2021-03-17T17:02:41.000Z</td>\n",
" <td>64</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>HOSPITAL PAULO DE TARSO</td>\n",
" <td>6.0</td>\n",
" <td>123.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Minas Gerais</td>\n",
" <td>MG</td>\n",
" <td>Belo Horizonte</td>\n",
" <td>0027820</td>\n",
" <td>2021-03-17T17:02:41.000Z</td>\n",
" <td>13</td>\n",
" <td>0</td>\n",
" <td>12</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>HOSPITAL INFANTIL PADRE ANCHIETA LTDA</td>\n",
" <td>5.0</td>\n",
" <td>47.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Minas Gerais</td>\n",
" <td>MG</td>\n",
" <td>Belo Horizonte</td>\n",
" <td>6437745</td>\n",
" <td>2021-03-13T03:00:56.261Z</td>\n",
" <td>88</td>\n",
" <td>16</td>\n",
" <td>70</td>\n",
" <td>30</td>\n",
" <td>11</td>\n",
" <td>1</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>HOSPITAL UNIMED UNIDADE CONTORNO</td>\n",
" <td>0.0</td>\n",
" <td>202.0</td>\n",
" <td>40.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Minas Gerais</td>\n",
" <td>mg</td>\n",
" <td>Belo Horizonte</td>\n",
" <td>708700189426695</td>\n",
" <td>2020-05-26T15:19:52.301Z</td>\n",
" <td>248</td>\n",
" <td>57</td>\n",
" <td>19</td>\n",
" <td>10</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" estado estadoSigla ... ofertaSRAGCli ofertaSRAGUti\n",
"5 Minas Gerais MG ... 228.0 40.0\n",
"2 Minas Gerais MG ... 3.0 5.0\n",
"7 Minas Gerais MG ... 10.0 4.0\n",
"4 Minas Gerais MG ... 5.0 1.0\n",
"6 Minas Gerais MG ... 15.0 16.0\n",
"1 Minas Gerais MG ... 44.0 52.0\n",
"3 Minas Gerais MG ... 0.0 0.0\n",
"8 Minas Gerais MG ... 0.0 0.0\n",
"9 Minas Gerais MG ... 0.0 0.0\n",
"0 Minas Gerais mg ... NaN NaN\n",
"\n",
"[10 rows x 19 columns]"
]
},
"metadata": {
"tags": []
},
"execution_count": 6
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "SjdlTriGph_O"
},
"source": [
""
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment