base_vacinacao_Grupo2.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "base_vacinacao_Grupo2.ipynb",
      "provenance": [],
      "toc_visible": true,
      "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/JamileSantos/Modelos_Ciencia_de_Dados/blob/master/base_vacinacao_Grupo2.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "bY1V1c1JwDy2"
      },
      "source": [
        "# importando a biblioteca\r\n",
        "import pandas as pd # pandas\r\n",
        "import numpy as np  # numpy\r\n",
        "import matplotlib.pyplot as plt"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "E3OyiMhDzIgk",
        "outputId": "654a9162-511c-435e-b004-dbe8e9e18045"
      },
      "source": [
        "# Importando os dados para o Google Colab\n",
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "OevDcAKtxO_U"
      },
      "source": [
        "## Importando dados de Arquivo \".csv\""
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "T9dFGrUNzUg2",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 355
        },
        "outputId": "2334faef-5c26-473b-baa6-fdec31286dc0"
      },
      "source": [
        "# Importanto os dados\r\n",
        "dadosx = pd.read_csv('/content/drive/My Drive/base_vacina.csv')\r\n",
        "\r\n",
        "dadosx.head(3)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>document_id</th>\n",
              "      <th>paciente_id</th>\n",
              "      <th>paciente_idade</th>\n",
              "      <th>paciente_dataNascimento</th>\n",
              "      <th>paciente_enumSexoBiologico</th>\n",
              "      <th>paciente_racaCor_codigo</th>\n",
              "      <th>paciente_racaCor_valor</th>\n",
              "      <th>paciente_endereco_coIbgeMunicipio</th>\n",
              "      <th>paciente_endereco_coPais</th>\n",
              "      <th>paciente_endereco_nmMunicipio</th>\n",
              "      <th>paciente_endereco_nmPais</th>\n",
              "      <th>paciente_endereco_uf</th>\n",
              "      <th>paciente_endereco_cep</th>\n",
              "      <th>paciente_nacionalidade_enumNacionalidade</th>\n",
              "      <th>estabelecimento_valor</th>\n",
              "      <th>estabelecimento_razaoSocial</th>\n",
              "      <th>estalecimento_noFantasia</th>\n",
              "      <th>estabelecimento_municipio_codigo</th>\n",
              "      <th>estabelecimento_municipio_nome</th>\n",
              "      <th>estabelecimento_uf</th>\n",
              "      <th>vacina_grupoAtendimento_codigo</th>\n",
              "      <th>vacina_grupoAtendimento_nome</th>\n",
              "      <th>vacina_categoria_codigo</th>\n",
              "      <th>vacina_categoria_nome</th>\n",
              "      <th>vacina_lote</th>\n",
              "      <th>vacina_fabricante_nome</th>\n",
              "      <th>vacina_fabricante_referencia</th>\n",
              "      <th>vacina_dataAplicacao</th>\n",
              "      <th>vacina_descricao_dose</th>\n",
              "      <th>vacina_codigo</th>\n",
              "      <th>vacina_nome</th>\n",
              "      <th>sistema_origem</th>\n",
              "      <th>data_importacao_rnds</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>60aeb975-94ed-4113-a8b0-ac55dbb8ab41-i0b0</td>\n",
              "      <td>433768b2c569be2ff29976dea5cddd0eeb907de38c254e...</td>\n",
              "      <td>79.0</td>\n",
              "      <td>1942-01-28</td>\n",
              "      <td>F</td>\n",
              "      <td>1.0</td>\n",
              "      <td>BRANCA</td>\n",
              "      <td>432225.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>TUPANDI</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>RS</td>\n",
              "      <td>95775.0</td>\n",
              "      <td>B</td>\n",
              "      <td>2227428</td>\n",
              "      <td>PREFEITURA MUNICIPAL DE SAO SEBASTIAO DO CAI</td>\n",
              "      <td>CENTRO DE SAUDE DR BRUNO CASSEL</td>\n",
              "      <td>431950.0</td>\n",
              "      <td>SAO SEBASTIAO DO CAI</td>\n",
              "      <td>RS</td>\n",
              "      <td>301</td>\n",
              "      <td>Pessoas de 60 nos ou mais Institucionalizadas</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Pessoas de 60 anos ou mais institucionalizadas</td>\n",
              "      <td>210018A</td>\n",
              "      <td>FUNDACAO BUTANTAN</td>\n",
              "      <td>Organization/61189445000156</td>\n",
              "      <td>2021-02-16T03:00:00.000Z</td>\n",
              "      <td>2ª Dose</td>\n",
              "      <td>86</td>\n",
              "      <td>Covid-19-Coronavac-Sinovac/Butantan</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-19 03:20:03</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>b68c468e-8083-4cca-8da1-ea9a8decbaba-i0b0</td>\n",
              "      <td>8499ef2ad9174cee4bd4dac8ae172a706775f4c835cb17...</td>\n",
              "      <td>90.0</td>\n",
              "      <td>1930-09-11</td>\n",
              "      <td>M</td>\n",
              "      <td>2.0</td>\n",
              "      <td>PRETA</td>\n",
              "      <td>430930.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>GUAIBA</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>RS</td>\n",
              "      <td>92500.0</td>\n",
              "      <td>B</td>\n",
              "      <td>2225999</td>\n",
              "      <td>PREFEITURA MUNICIPAL DE GUAIBA</td>\n",
              "      <td>UNIDADE BASICA DE SAUDE COHAB</td>\n",
              "      <td>430930.0</td>\n",
              "      <td>GUAIBA</td>\n",
              "      <td>RS</td>\n",
              "      <td>205</td>\n",
              "      <td>Pessoas de 80 anos ou mais</td>\n",
              "      <td>2.0</td>\n",
              "      <td>Faixa Etária</td>\n",
              "      <td>210018A</td>\n",
              "      <td>FUNDACAO BUTANTAN</td>\n",
              "      <td>Organization/61189445000156</td>\n",
              "      <td>2021-02-11T03:00:00.000Z</td>\n",
              "      <td>1ª Dose</td>\n",
              "      <td>86</td>\n",
              "      <td>Covid-19-Coronavac-Sinovac/Butantan</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-19 16:04:01</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>db74d38d-be6e-4b1a-82d0-e2797c3b55e7-i0b0</td>\n",
              "      <td>1c8b855733d6ea88081712bd74f95ca36bef67ac83b168...</td>\n",
              "      <td>91.0</td>\n",
              "      <td>1929-06-25</td>\n",
              "      <td>F</td>\n",
              "      <td>1.0</td>\n",
              "      <td>BRANCA</td>\n",
              "      <td>316900.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>TOCANTINS</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>MG</td>\n",
              "      <td>36512.0</td>\n",
              "      <td>B</td>\n",
              "      <td>2162776</td>\n",
              "      <td>PREFEITURA MUNICIPAL DE TOCANTINS</td>\n",
              "      <td>CENTRO INTEGRADO DE SAUDE DE TOCANTINS</td>\n",
              "      <td>316900.0</td>\n",
              "      <td>TOCANTINS</td>\n",
              "      <td>MG</td>\n",
              "      <td>205</td>\n",
              "      <td>Pessoas de 80 anos ou mais</td>\n",
              "      <td>2.0</td>\n",
              "      <td>Faixa Etária</td>\n",
              "      <td>202010031</td>\n",
              "      <td>FUNDACAO BUTANTAN</td>\n",
              "      <td>Organization/61189445000156</td>\n",
              "      <td>2021-02-12T03:00:00.000Z</td>\n",
              "      <td>1ª Dose</td>\n",
              "      <td>86</td>\n",
              "      <td>Covid-19-Coronavac-Sinovac/Butantan</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-15 19:32:10</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                 document_id  ... data_importacao_rnds\n",
              "0  60aeb975-94ed-4113-a8b0-ac55dbb8ab41-i0b0  ...  2021-02-19 03:20:03\n",
              "1  b68c468e-8083-4cca-8da1-ea9a8decbaba-i0b0  ...  2021-02-19 16:04:01\n",
              "2  db74d38d-be6e-4b1a-82d0-e2797c3b55e7-i0b0  ...  2021-02-15 19:32:10\n",
              "\n",
              "[3 rows x 33 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "WzyvDYc7y3l-",
        "outputId": "1b11e1e0-c106-4c3d-ce83-83973596f832"
      },
      "source": [
        "# visualiza o total de registros\r\n",
        "print('Total de Registros :> ',len(dadosx))"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Total de Registros :>  7908949\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 285
        },
        "id": "KA2pqq82QeTA",
        "outputId": "da5b9c29-a3de-480d-f540-045ab45b597f"
      },
      "source": [
        "# Extraindo uma amostra de Dados por UF do estabelecimento\r\n",
        "\r\n",
        "estado_rj = dadosx[dadosx['estabelecimento_uf']=='RJ']\r\n",
        "estado_rj.head(3)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>document_id</th>\n",
              "      <th>paciente_id</th>\n",
              "      <th>paciente_idade</th>\n",
              "      <th>paciente_dataNascimento</th>\n",
              "      <th>paciente_enumSexoBiologico</th>\n",
              "      <th>paciente_racaCor_codigo</th>\n",
              "      <th>paciente_racaCor_valor</th>\n",
              "      <th>paciente_endereco_coIbgeMunicipio</th>\n",
              "      <th>paciente_endereco_coPais</th>\n",
              "      <th>paciente_endereco_nmMunicipio</th>\n",
              "      <th>paciente_endereco_nmPais</th>\n",
              "      <th>paciente_endereco_uf</th>\n",
              "      <th>paciente_endereco_cep</th>\n",
              "      <th>paciente_nacionalidade_enumNacionalidade</th>\n",
              "      <th>estabelecimento_valor</th>\n",
              "      <th>estabelecimento_razaoSocial</th>\n",
              "      <th>estalecimento_noFantasia</th>\n",
              "      <th>estabelecimento_municipio_codigo</th>\n",
              "      <th>estabelecimento_municipio_nome</th>\n",
              "      <th>estabelecimento_uf</th>\n",
              "      <th>vacina_grupoAtendimento_codigo</th>\n",
              "      <th>vacina_grupoAtendimento_nome</th>\n",
              "      <th>vacina_categoria_codigo</th>\n",
              "      <th>vacina_categoria_nome</th>\n",
              "      <th>vacina_lote</th>\n",
              "      <th>vacina_fabricante_nome</th>\n",
              "      <th>vacina_fabricante_referencia</th>\n",
              "      <th>vacina_dataAplicacao</th>\n",
              "      <th>vacina_descricao_dose</th>\n",
              "      <th>vacina_codigo</th>\n",
              "      <th>vacina_nome</th>\n",
              "      <th>sistema_origem</th>\n",
              "      <th>data_importacao_rnds</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>69</th>\n",
              "      <td>8b6308bb-3914-4781-8abd-a15dcdf58b42-i0b0</td>\n",
              "      <td>bc7cff0d921fa6ab18d4f989212908ca706ebc7a3eb9db...</td>\n",
              "      <td>39.0</td>\n",
              "      <td>1981-11-24</td>\n",
              "      <td>F</td>\n",
              "      <td>99.0</td>\n",
              "      <td>SEM INFORMACAO</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>RJ</td>\n",
              "      <td>20510.0</td>\n",
              "      <td>B</td>\n",
              "      <td>7873565</td>\n",
              "      <td>SMS RIO CF JOSE DE SOUZA HERDY AP 40</td>\n",
              "      <td>SMS CF JOSE DE SOUZA HERDY AP 40</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>915</td>\n",
              "      <td>Nutricionista</td>\n",
              "      <td>9.0</td>\n",
              "      <td>Trabalhadores de Saúde</td>\n",
              "      <td>210011A</td>\n",
              "      <td>FUNDACAO BUTANTAN</td>\n",
              "      <td>Organization/61189445000156</td>\n",
              "      <td>2021-02-16T03:00:00.000Z</td>\n",
              "      <td>2ª Dose</td>\n",
              "      <td>86</td>\n",
              "      <td>Covid-19-Coronavac-Sinovac/Butantan</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-20 01:49:09</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>78</th>\n",
              "      <td>0e18ba11-0a6e-4d59-ad1d-545b32cc11fc-i0b0</td>\n",
              "      <td>bebecaf422997259cd169a30ee3cffb3338ef17f66d1f3...</td>\n",
              "      <td>64.0</td>\n",
              "      <td>1956-07-28</td>\n",
              "      <td>F</td>\n",
              "      <td>99.0</td>\n",
              "      <td>SEM INFORMACAO</td>\n",
              "      <td>330330.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>NITEROI</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>RJ</td>\n",
              "      <td>24120.0</td>\n",
              "      <td>B</td>\n",
              "      <td>12580</td>\n",
              "      <td>FUNDACAO MUNICIPAL DE SAUDE</td>\n",
              "      <td>POLICLINICA COMUNITARIA DR SERGIO AROUCA</td>\n",
              "      <td>330330.0</td>\n",
              "      <td>NITEROI</td>\n",
              "      <td>RJ</td>\n",
              "      <td>919</td>\n",
              "      <td>Psicólogo</td>\n",
              "      <td>9.0</td>\n",
              "      <td>Trabalhadores de Saúde</td>\n",
              "      <td>4120Z005</td>\n",
              "      <td>FUNDACAO OSWALDO CRUZ</td>\n",
              "      <td>Organization/33781055000135</td>\n",
              "      <td>2021-02-04T03:00:00.000Z</td>\n",
              "      <td>1ª Dose</td>\n",
              "      <td>85</td>\n",
              "      <td>Vacina Covid-19 - Covishield</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-12 22:22:06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>118</th>\n",
              "      <td>cc86de35-3743-41bb-9036-f64e26e76edb-i0b0</td>\n",
              "      <td>7f18c0668751ab4ba0fe18e6c4bb97557be27923f322eb...</td>\n",
              "      <td>86.0</td>\n",
              "      <td>1934-02-20</td>\n",
              "      <td>F</td>\n",
              "      <td>99.0</td>\n",
              "      <td>SEM INFORMACAO</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>RJ</td>\n",
              "      <td>20550.0</td>\n",
              "      <td>B</td>\n",
              "      <td>2269376</td>\n",
              "      <td>SMS RIO CMS HEITOR BELTRAO AP 22</td>\n",
              "      <td>SMS CMS HEITOR BELTRAO AP 22</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>301</td>\n",
              "      <td>Pessoas de 60 nos ou mais Institucionalizadas</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Pessoas de 60 anos ou mais institucionalizadas</td>\n",
              "      <td>202009015</td>\n",
              "      <td>FUNDACAO BUTANTAN</td>\n",
              "      <td>Organization/61189445000156</td>\n",
              "      <td>2021-02-11T03:00:00.000Z</td>\n",
              "      <td>1ª Dose</td>\n",
              "      <td>86</td>\n",
              "      <td>Covid-19-Coronavac-Sinovac/Butantan</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-18 14:29:52</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                   document_id  ... data_importacao_rnds\n",
              "69   8b6308bb-3914-4781-8abd-a15dcdf58b42-i0b0  ...  2021-02-20 01:49:09\n",
              "78   0e18ba11-0a6e-4d59-ad1d-545b32cc11fc-i0b0  ...  2021-02-12 22:22:06\n",
              "118  cc86de35-3743-41bb-9036-f64e26e76edb-i0b0  ...  2021-02-18 14:29:52\n",
              "\n",
              "[3 rows x 33 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 730
        },
        "id": "lTlh0NuCp32O",
        "outputId": "3f2d15dd-e192-4411-f05f-cf785cc88229"
      },
      "source": [
        "## Extraindo dados dos Pacientes que moram no RJ\r\n",
        "\r\n",
        "estado_rj_paciente = dadosx[dadosx['paciente_endereco_nmMunicipio']=='RIO DE JANEIRO']\r\n",
        "estado_rj_paciente.head(10)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>document_id</th>\n",
              "      <th>paciente_id</th>\n",
              "      <th>paciente_idade</th>\n",
              "      <th>paciente_dataNascimento</th>\n",
              "      <th>paciente_enumSexoBiologico</th>\n",
              "      <th>paciente_racaCor_codigo</th>\n",
              "      <th>paciente_racaCor_valor</th>\n",
              "      <th>paciente_endereco_coIbgeMunicipio</th>\n",
              "      <th>paciente_endereco_coPais</th>\n",
              "      <th>paciente_endereco_nmMunicipio</th>\n",
              "      <th>paciente_endereco_nmPais</th>\n",
              "      <th>paciente_endereco_uf</th>\n",
              "      <th>paciente_endereco_cep</th>\n",
              "      <th>paciente_nacionalidade_enumNacionalidade</th>\n",
              "      <th>estabelecimento_valor</th>\n",
              "      <th>estabelecimento_razaoSocial</th>\n",
              "      <th>estalecimento_noFantasia</th>\n",
              "      <th>estabelecimento_municipio_codigo</th>\n",
              "      <th>estabelecimento_municipio_nome</th>\n",
              "      <th>estabelecimento_uf</th>\n",
              "      <th>vacina_grupoAtendimento_codigo</th>\n",
              "      <th>vacina_grupoAtendimento_nome</th>\n",
              "      <th>vacina_categoria_codigo</th>\n",
              "      <th>vacina_categoria_nome</th>\n",
              "      <th>vacina_lote</th>\n",
              "      <th>vacina_fabricante_nome</th>\n",
              "      <th>vacina_fabricante_referencia</th>\n",
              "      <th>vacina_dataAplicacao</th>\n",
              "      <th>vacina_descricao_dose</th>\n",
              "      <th>vacina_codigo</th>\n",
              "      <th>vacina_nome</th>\n",
              "      <th>sistema_origem</th>\n",
              "      <th>data_importacao_rnds</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>69</th>\n",
              "      <td>8b6308bb-3914-4781-8abd-a15dcdf58b42-i0b0</td>\n",
              "      <td>bc7cff0d921fa6ab18d4f989212908ca706ebc7a3eb9db...</td>\n",
              "      <td>39.0</td>\n",
              "      <td>1981-11-24</td>\n",
              "      <td>F</td>\n",
              "      <td>99.0</td>\n",
              "      <td>SEM INFORMACAO</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>RJ</td>\n",
              "      <td>20510.0</td>\n",
              "      <td>B</td>\n",
              "      <td>7873565</td>\n",
              "      <td>SMS RIO CF JOSE DE SOUZA HERDY AP 40</td>\n",
              "      <td>SMS CF JOSE DE SOUZA HERDY AP 40</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>915</td>\n",
              "      <td>Nutricionista</td>\n",
              "      <td>9.0</td>\n",
              "      <td>Trabalhadores de Saúde</td>\n",
              "      <td>210011A</td>\n",
              "      <td>FUNDACAO BUTANTAN</td>\n",
              "      <td>Organization/61189445000156</td>\n",
              "      <td>2021-02-16T03:00:00.000Z</td>\n",
              "      <td>2ª Dose</td>\n",
              "      <td>86</td>\n",
              "      <td>Covid-19-Coronavac-Sinovac/Butantan</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-20 01:49:09</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>118</th>\n",
              "      <td>cc86de35-3743-41bb-9036-f64e26e76edb-i0b0</td>\n",
              "      <td>7f18c0668751ab4ba0fe18e6c4bb97557be27923f322eb...</td>\n",
              "      <td>86.0</td>\n",
              "      <td>1934-02-20</td>\n",
              "      <td>F</td>\n",
              "      <td>99.0</td>\n",
              "      <td>SEM INFORMACAO</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>RJ</td>\n",
              "      <td>20550.0</td>\n",
              "      <td>B</td>\n",
              "      <td>2269376</td>\n",
              "      <td>SMS RIO CMS HEITOR BELTRAO AP 22</td>\n",
              "      <td>SMS CMS HEITOR BELTRAO AP 22</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>301</td>\n",
              "      <td>Pessoas de 60 nos ou mais Institucionalizadas</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Pessoas de 60 anos ou mais institucionalizadas</td>\n",
              "      <td>202009015</td>\n",
              "      <td>FUNDACAO BUTANTAN</td>\n",
              "      <td>Organization/61189445000156</td>\n",
              "      <td>2021-02-11T03:00:00.000Z</td>\n",
              "      <td>1ª Dose</td>\n",
              "      <td>86</td>\n",
              "      <td>Covid-19-Coronavac-Sinovac/Butantan</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-18 14:29:52</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>137</th>\n",
              "      <td>b8f7d175-ead5-4a24-ae88-bb49103bf6ab-i0b0</td>\n",
              "      <td>1d56ff050247f4b4bae2cd44d0e42e75787f4baefa39f5...</td>\n",
              "      <td>27.0</td>\n",
              "      <td>1993-12-01</td>\n",
              "      <td>F</td>\n",
              "      <td>1.0</td>\n",
              "      <td>BRANCA</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>RJ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>B</td>\n",
              "      <td>2269902</td>\n",
              "      <td>SMS RIO CMS DOUTOR JOSE BREVES DOS SANTOS AP 31</td>\n",
              "      <td>SMS CMS JOSE BREVES DOS SANTOS AP 31</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>923</td>\n",
              "      <td>Técnico de Enfermagem</td>\n",
              "      <td>9.0</td>\n",
              "      <td>Trabalhadores de Saúde</td>\n",
              "      <td>4120Z005</td>\n",
              "      <td>FUNDACAO OSWALDO CRUZ</td>\n",
              "      <td>Organization/33781055000135</td>\n",
              "      <td>2021-02-01T03:00:00.000Z</td>\n",
              "      <td>1ª Dose</td>\n",
              "      <td>85</td>\n",
              "      <td>Vacina Covid-19 - Covishield</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-01 17:34:57</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>164</th>\n",
              "      <td>d25a1f02-355d-4b92-88dc-91c0e0dda704-i0b0</td>\n",
              "      <td>36555374e8243b1cab283fa7e38169f8cda5813e58b670...</td>\n",
              "      <td>77.0</td>\n",
              "      <td>1943-10-28</td>\n",
              "      <td>F</td>\n",
              "      <td>1.0</td>\n",
              "      <td>BRANCA</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>RJ</td>\n",
              "      <td>22783.0</td>\n",
              "      <td>B</td>\n",
              "      <td>2289458</td>\n",
              "      <td>SMS BELFORD ROXO</td>\n",
              "      <td>PRS HELIOPOLIS MONSENHOR SOLANO DE MENEZES</td>\n",
              "      <td>330045.0</td>\n",
              "      <td>BELFORD ROXO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>205</td>\n",
              "      <td>Pessoas de 80 anos ou mais</td>\n",
              "      <td>2.0</td>\n",
              "      <td>Faixa Etária</td>\n",
              "      <td>210011A</td>\n",
              "      <td>FUNDACAO BUTANTAN</td>\n",
              "      <td>Organization/61189445000156</td>\n",
              "      <td>2021-02-18T03:00:00.000Z</td>\n",
              "      <td>1ª Dose</td>\n",
              "      <td>86</td>\n",
              "      <td>Covid-19-Coronavac-Sinovac/Butantan</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-26 12:09:16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>176</th>\n",
              "      <td>e62ea991-bb7a-4ef3-af88-2e377cc7b45d-i0b0</td>\n",
              "      <td>4d39a8db2a9378d38764e6a6c727419d37e08976b35ad8...</td>\n",
              "      <td>61.0</td>\n",
              "      <td>1960-01-21</td>\n",
              "      <td>M</td>\n",
              "      <td>3.0</td>\n",
              "      <td>PARDA</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>RJ</td>\n",
              "      <td>21866.0</td>\n",
              "      <td>B</td>\n",
              "      <td>5546583</td>\n",
              "      <td>SMS RIO CMS CATIRI AP 51</td>\n",
              "      <td>SMS CMS CATIRI AP 51</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>926</td>\n",
              "      <td>Outros</td>\n",
              "      <td>9.0</td>\n",
              "      <td>Trabalhadores de Saúde</td>\n",
              "      <td>202009015</td>\n",
              "      <td>FUNDACAO BUTANTAN</td>\n",
              "      <td>Organization/61189445000156</td>\n",
              "      <td>2021-02-16T03:00:00.000Z</td>\n",
              "      <td>2ª Dose</td>\n",
              "      <td>86</td>\n",
              "      <td>Covid-19-Coronavac-Sinovac/Butantan</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-16 18:22:41</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>209</th>\n",
              "      <td>afbec498-78b6-49a3-a8b5-558eaf1ddfc6-i0b0</td>\n",
              "      <td>6871fb3159bd97fb3cbe1b4c4d0e6b5a78e0934f5714df...</td>\n",
              "      <td>80.0</td>\n",
              "      <td>1940-11-19</td>\n",
              "      <td>F</td>\n",
              "      <td>3.0</td>\n",
              "      <td>PARDA</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>RJ</td>\n",
              "      <td>20271.0</td>\n",
              "      <td>B</td>\n",
              "      <td>7414226</td>\n",
              "      <td>SMS RIO CMS HELIO PELLEGRINO AP 22</td>\n",
              "      <td>SMS CMS HELIO PELLEGRINO AP 22</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>205</td>\n",
              "      <td>Pessoas de 80 anos ou mais</td>\n",
              "      <td>2.0</td>\n",
              "      <td>Faixa Etária</td>\n",
              "      <td>4120Z026</td>\n",
              "      <td>FUNDACAO OSWALDO CRUZ</td>\n",
              "      <td>Organization/33781055000135</td>\n",
              "      <td>2021-02-27T03:00:00.000Z</td>\n",
              "      <td>1ª Dose</td>\n",
              "      <td>85</td>\n",
              "      <td>Vacina Covid-19 - Covishield</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-27 14:25:04</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>210</th>\n",
              "      <td>aeae8990-b66e-4b77-966f-56f06c83a217-i0b0</td>\n",
              "      <td>d7e331d57507419706cf8826567ec24197d6c0c54ef9cd...</td>\n",
              "      <td>83.0</td>\n",
              "      <td>1937-11-18</td>\n",
              "      <td>M</td>\n",
              "      <td>99.0</td>\n",
              "      <td>SEM INFORMACAO</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>RJ</td>\n",
              "      <td>22080.0</td>\n",
              "      <td>B</td>\n",
              "      <td>2280795</td>\n",
              "      <td>SMS RIO CMS JOAO BARROS BARRETO AP 21</td>\n",
              "      <td>SMS CMS JOAO BARROS BARRETO AP 21</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>205</td>\n",
              "      <td>Pessoas de 80 anos ou mais</td>\n",
              "      <td>2.0</td>\n",
              "      <td>Faixa Etária</td>\n",
              "      <td>210011A</td>\n",
              "      <td>FUNDACAO BUTANTAN</td>\n",
              "      <td>Organization/61189445000156</td>\n",
              "      <td>2021-02-16T03:00:00.000Z</td>\n",
              "      <td>1ª Dose</td>\n",
              "      <td>86</td>\n",
              "      <td>Covid-19-Coronavac-Sinovac/Butantan</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-22 14:28:26</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>224</th>\n",
              "      <td>5a20e342-fad5-4dab-ae68-e2bf254ce114-i0b0</td>\n",
              "      <td>f568f9c5e002a96992375930ce15de6a36d1ede15a93aa...</td>\n",
              "      <td>92.0</td>\n",
              "      <td>1929-01-10</td>\n",
              "      <td>F</td>\n",
              "      <td>1.0</td>\n",
              "      <td>BRANCA</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>RJ</td>\n",
              "      <td>20931.0</td>\n",
              "      <td>B</td>\n",
              "      <td>2277298</td>\n",
              "      <td>SMS RIO CF FERNANDO ANTONIO BRAGA LOPES AP 10</td>\n",
              "      <td>SMS CF FERNANDO A BRAGA LOPES AP 10</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>301</td>\n",
              "      <td>Pessoas de 60 nos ou mais Institucionalizadas</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Pessoas de 60 anos ou mais institucionalizadas</td>\n",
              "      <td>210017</td>\n",
              "      <td>FUNDACAO BUTANTAN</td>\n",
              "      <td>Organization/61189445000156</td>\n",
              "      <td>2021-02-26T03:00:00.000Z</td>\n",
              "      <td>2ª Dose</td>\n",
              "      <td>86</td>\n",
              "      <td>Covid-19-Coronavac-Sinovac/Butantan</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-27 15:04:57</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>263</th>\n",
              "      <td>5c1d3622-1af6-4eb1-ad3c-b27db4d4f982-i0b0</td>\n",
              "      <td>75ba0f4089d4e9325241e0e9338c1186edeb5eaca4b389...</td>\n",
              "      <td>88.0</td>\n",
              "      <td>1932-10-03</td>\n",
              "      <td>F</td>\n",
              "      <td>99.0</td>\n",
              "      <td>SEM INFORMACAO</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>RJ</td>\n",
              "      <td>20771.0</td>\n",
              "      <td>B</td>\n",
              "      <td>7996675</td>\n",
              "      <td>SMS RIO CF GERSON BERGHER AP 40</td>\n",
              "      <td>SMS CF GERSON BERGHER AP 40</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>205</td>\n",
              "      <td>Pessoas de 80 anos ou mais</td>\n",
              "      <td>2.0</td>\n",
              "      <td>Faixa Etária</td>\n",
              "      <td>202009015</td>\n",
              "      <td>FUNDACAO BUTANTAN</td>\n",
              "      <td>Organization/61189445000156</td>\n",
              "      <td>2021-02-11T03:00:00.000Z</td>\n",
              "      <td>1ª Dose</td>\n",
              "      <td>86</td>\n",
              "      <td>Covid-19-Coronavac-Sinovac/Butantan</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-11 15:28:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>281</th>\n",
              "      <td>48ac8add-a6ec-4a5b-9d90-e0a996db6438-i0b0</td>\n",
              "      <td>52954945bbbc88369c13c5c994b7d9addb26d496b595c3...</td>\n",
              "      <td>65.0</td>\n",
              "      <td>1955-11-08</td>\n",
              "      <td>F</td>\n",
              "      <td>3.0</td>\n",
              "      <td>PARDA</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>RJ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>B</td>\n",
              "      <td>2269929</td>\n",
              "      <td>SMS RIO CMS DR CATTAPRETA AP 53</td>\n",
              "      <td>SMS CMS CATTAPRETA AP 53</td>\n",
              "      <td>330455.0</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>301</td>\n",
              "      <td>Pessoas de 60 nos ou mais Institucionalizadas</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Pessoas de 60 anos ou mais institucionalizadas</td>\n",
              "      <td>210011A</td>\n",
              "      <td>FUNDACAO BUTANTAN</td>\n",
              "      <td>Organization/61189445000156</td>\n",
              "      <td>2021-02-16T03:00:00.000Z</td>\n",
              "      <td>2ª Dose</td>\n",
              "      <td>86</td>\n",
              "      <td>Covid-19-Coronavac-Sinovac/Butantan</td>\n",
              "      <td>Novo PNI</td>\n",
              "      <td>2021-02-16 14:51:23</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                   document_id  ... data_importacao_rnds\n",
              "69   8b6308bb-3914-4781-8abd-a15dcdf58b42-i0b0  ...  2021-02-20 01:49:09\n",
              "118  cc86de35-3743-41bb-9036-f64e26e76edb-i0b0  ...  2021-02-18 14:29:52\n",
              "137  b8f7d175-ead5-4a24-ae88-bb49103bf6ab-i0b0  ...  2021-02-01 17:34:57\n",
              "164  d25a1f02-355d-4b92-88dc-91c0e0dda704-i0b0  ...  2021-02-26 12:09:16\n",
              "176  e62ea991-bb7a-4ef3-af88-2e377cc7b45d-i0b0  ...  2021-02-16 18:22:41\n",
              "209  afbec498-78b6-49a3-a8b5-558eaf1ddfc6-i0b0  ...  2021-02-27 14:25:04\n",
              "210  aeae8990-b66e-4b77-966f-56f06c83a217-i0b0  ...  2021-02-22 14:28:26\n",
              "224  5a20e342-fad5-4dab-ae68-e2bf254ce114-i0b0  ...  2021-02-27 15:04:57\n",
              "263  5c1d3622-1af6-4eb1-ad3c-b27db4d4f982-i0b0  ...  2021-02-11 15:28:00\n",
              "281  48ac8add-a6ec-4a5b-9d90-e0a996db6438-i0b0  ...  2021-02-16 14:51:23\n",
              "\n",
              "[10 rows x 33 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "RH8yCRDBq-Ab",
        "outputId": "cc5ba40a-0310-420b-f65c-cd50a05fa5ec"
      },
      "source": [
        "# visualiza o total de registros\r\n",
        "print('Total de Registros de Pacientes :> ',len(estado_rj_paciente))"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Total de Registros de Pacientes :>  291063\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Qe6bu0wDxB1B"
      },
      "source": [
        "# Tratamentos dos dados\r\n",
        " \r\n",
        "1.   Verificar se existe a falta de dados, dados nulos, etc.\r\n",
        "2.    Se existe falta de dados, por exemplo, usar os métodos que usa o pandas vistos na última aula. Cada dataset tem suas próprias características.\r\n",
        "\r\n",
        "\r\n",
        "3. Antes de aplicar qualquer método, devem pensar sobre o dado ou os dados, eles são relevantes para o estudo? Eliminar? substituir? usar Zero? Por quê?\r\n",
        "4. Sobre os métodos de visualização: \r\n",
        "  1. Estático (Matplotlib, ..). \r\n",
        "  2. Interativo (plotly, ...)\r\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "w7rtA0eChJo8",
        "outputId": "76685ad1-7398-42ba-d70b-7562874b1006"
      },
      "source": [
        "#Filtering rows with null values\r\n",
        "dadosx.isnull().sum()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "document_id                                       0\n",
              "paciente_id                                       1\n",
              "paciente_idade                                    1\n",
              "paciente_dataNascimento                           1\n",
              "paciente_enumSexoBiologico                        1\n",
              "paciente_racaCor_codigo                           1\n",
              "paciente_racaCor_valor                            1\n",
              "paciente_endereco_coIbgeMunicipio             43868\n",
              "paciente_endereco_coPais                      43748\n",
              "paciente_endereco_nmMunicipio                 43814\n",
              "paciente_endereco_nmPais                      43748\n",
              "paciente_endereco_uf                          43868\n",
              "paciente_endereco_cep                       1393174\n",
              "paciente_nacionalidade_enumNacionalidade      12772\n",
              "estabelecimento_valor                             0\n",
              "estabelecimento_razaoSocial                     376\n",
              "estalecimento_noFantasia                        376\n",
              "estabelecimento_municipio_codigo                376\n",
              "estabelecimento_municipio_nome                  376\n",
              "estabelecimento_uf                              376\n",
              "vacina_grupoAtendimento_codigo                    0\n",
              "vacina_grupoAtendimento_nome                  96005\n",
              "vacina_categoria_codigo                       96005\n",
              "vacina_categoria_nome                         96005\n",
              "vacina_lote                                       0\n",
              "vacina_fabricante_nome                       155783\n",
              "vacina_fabricante_referencia                3120939\n",
              "vacina_dataAplicacao                              0\n",
              "vacina_descricao_dose                             0\n",
              "vacina_codigo                                     0\n",
              "vacina_nome                                       0\n",
              "sistema_origem                               101947\n",
              "data_importacao_rnds                              0\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ZUG_jP9IRqp5",
        "outputId": "fe042e25-09ea-42a2-955b-68b0e5bfa495"
      },
      "source": [
        "dadosx.info()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 7908949 entries, 0 to 7908948\n",
            "Data columns (total 33 columns):\n",
            " #   Column                                    Dtype  \n",
            "---  ------                                    -----  \n",
            " 0   document_id                               object \n",
            " 1   paciente_id                               object \n",
            " 2   paciente_idade                            float64\n",
            " 3   paciente_dataNascimento                   object \n",
            " 4   paciente_enumSexoBiologico                object \n",
            " 5   paciente_racaCor_codigo                   float64\n",
            " 6   paciente_racaCor_valor                    object \n",
            " 7   paciente_endereco_coIbgeMunicipio         float64\n",
            " 8   paciente_endereco_coPais                  float64\n",
            " 9   paciente_endereco_nmMunicipio             object \n",
            " 10  paciente_endereco_nmPais                  object \n",
            " 11  paciente_endereco_uf                      object \n",
            " 12  paciente_endereco_cep                     float64\n",
            " 13  paciente_nacionalidade_enumNacionalidade  object \n",
            " 14  estabelecimento_valor                     int64  \n",
            " 15  estabelecimento_razaoSocial               object \n",
            " 16  estalecimento_noFantasia                  object \n",
            " 17  estabelecimento_municipio_codigo          float64\n",
            " 18  estabelecimento_municipio_nome            object \n",
            " 19  estabelecimento_uf                        object \n",
            " 20  vacina_grupoAtendimento_codigo            int64  \n",
            " 21  vacina_grupoAtendimento_nome              object \n",
            " 22  vacina_categoria_codigo                   float64\n",
            " 23  vacina_categoria_nome                     object \n",
            " 24  vacina_lote                               object \n",
            " 25  vacina_fabricante_nome                    object \n",
            " 26  vacina_fabricante_referencia              object \n",
            " 27  vacina_dataAplicacao                      object \n",
            " 28  vacina_descricao_dose                     object \n",
            " 29  vacina_codigo                             int64  \n",
            " 30  vacina_nome                               object \n",
            " 31  sistema_origem                            object \n",
            " 32  data_importacao_rnds                      object \n",
            "dtypes: float64(7), int64(3), object(23)\n",
            "memory usage: 1.9+ GB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "TKWdjU6gY8_8"
      },
      "source": [
        "# Estatísticas descritivas"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "rzcVqhhkYRFB",
        "outputId": "d4010348-164d-4709-c1f7-02ea3f676947"
      },
      "source": [
        "# media das colunas\r\n",
        "media_c = estado_rj['paciente_idade'].mean()\r\n",
        "print(\"A media de idade da População Vacinada é:\", media_c)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "A media de idade da População Vacinada é: 62.710188937979495\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "BQ_YBcHnZ-We",
        "outputId": "893e65c6-f1a1-4fc7-b16c-86e251ca6246"
      },
      "source": [
        "group_sexo = estado_rj.groupby('paciente_enumSexoBiologico')    # agrupado por sexo\r\n",
        "print('Sexo:',group_sexo.groups)\r\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Sexo: {'F': [69, 78, 118, 136, 137, 164, 209, 224, 263, 281, 397, 452, 482, 501, 509, 540, 571, 604, 606, 611, 668, 701, 712, 716, 754, 786, 803, 849, 876, 934, 935, 967, 972, 973, 1023, 1039, 1045, 1065, 1066, 1082, 1123, 1224, 1254, 1314, 1332, 1336, 1344, 1356, 1381, 1436, 1461, 1497, 1524, 1569, 1589, 1615, 1690, 1694, 1728, 1762, 1831, 1835, 1846, 1853, 1936, 1940, 1943, 1962, 1964, 1994, 2011, 2046, 2058, 2085, 2094, 2113, 2137, 2146, 2166, 2167, 2185, 2214, 2256, 2262, 2270, 2334, 2335, 2342, 2404, 2413, 2417, 2419, 2430, 2438, 2439, 2443, 2455, 2489, 2513, 2528, ...], 'M': [141, 176, 179, 210, 318, 323, 462, 465, 470, 527, 633, 717, 778, 815, 842, 857, 940, 991, 1050, 1091, 1182, 1244, 1371, 1488, 1498, 1648, 1695, 1702, 1793, 1800, 1844, 1854, 1895, 1983, 2010, 2067, 2153, 2163, 2192, 2288, 2340, 2344, 2364, 2374, 2380, 2394, 2540, 2573, 2578, 2609, 2639, 2648, 2659, 2676, 2760, 2767, 2782, 2784, 2817, 2876, 2937, 2941, 3017, 3040, 3088, 3138, 3207, 3268, 3279, 3291, 3295, 3495, 3546, 3582, 3617, 3710, 3796, 3875, 3913, 4037, 4111, 4197, 4206, 4231, 4302, 4442, 4508, 4546, 4557, 4626, 4653, 4759, 4806, 4815, 4824, 4848, 4891, 4917, 4939, 4959, ...]}\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "OZg3VT5WaWgA"
      },
      "source": [
        "# Contablizando grupo de atendimento\r\n",
        "\r\n",
        "G_atendimento = estado_rj['vacina_grupoAtendimento_nome']\r\n",
        "\r\n",
        "\r\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "lT7IeG4QMYoV"
      },
      "source": [
        "# Proviniência de Dados\r\n",
        "\r\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SD3Ah6fGMup6"
      },
      "source": [
        "#Import ProvDocument to you Python Code\r\n",
        "#from prov.model import ProvDocument\r\n",
        "\r\n",
        "# Criando um novo documento de Proveniência\r\n",
        "#d1 = ProvDocument()  # d1 is now an empty provenance document\r\n",
        "\r\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "N-io_jNm0P06"
      },
      "source": [
        "# Visualização Gráfica"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Nhw6PHmGhEwS"
      },
      "source": [
        "# Nova seção"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "99VkKo-Y0YgB",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 265
        },
        "outputId": "7c587360-3715-4451-9f12-c1738f947a3c"
      },
      "source": [
        "# histogramas\r\n",
        "estado_rj['paciente_idade'].plot.hist(bins=15);"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZcAAAD4CAYAAAAgs6s2AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAXYUlEQVR4nO3dfbRddX3n8ffHRBDsSEAYRhNs0jFLJ1IdMSJdTjuOtBLAEmZGLYwtqWWZmSVW7XSWgnYNHS2zcLUjSpcyzUhKYKwR8YFMDaURta5Za3gI6uJRyi2gJIKkhgcrCka/88f5pRwvN8lJ7j7n5Ny8X2uddff+7t/e+/e7h5sP++Hsk6pCkqQuPWPcHZAkzT2GiySpc4aLJKlzhoskqXOGiySpc/PH3YH9xZFHHlmLFy8edzckaaLcfPPNf19VR02vGy7N4sWL2bx587i7IUkTJcm3Zqp7WkyS1DnDRZLUOcNFktQ5w0WS1DnDRZLUuaGFS5K1SR5Kcltf7Y+TfDPJLUk+l2RB37LzkkwluSvJSX31Fa02leTcvvqSJDe0+qeSHNTqB7f5qbZ88bDGKEma2TCPXC4DVkyrbQKOraqXAn8LnAeQZBlwBvCSts7HksxLMg/4KHAysAw4s7UF+CBwUVW9EHgYOLvVzwYebvWLWjtJ0ggNLVyq6qvA9mm1v66qHW32emBRm14JrK+qJ6rqXmAKOL69pqrqnqp6ElgPrEwS4LXAVW39dcDpfdta16avAk5s7SVJIzLOay6/A1zTphcC9/ct29Jqu6o/F3ikL6h21n9mW235o6390yRZnWRzks3btm2b9YAkST1j+YR+kvcBO4BPjGP/O1XVGmANwPLly/3WNGnIFp/7hU63d9+Fp3a6PXVn5OGS5LeB1wMn1lNfg7kVOKav2aJWYxf17wELksxvRyf97Xdua0uS+cBhrb0kaURGelosyQrg3cBpVfV436INwBntTq8lwFLgRuAmYGm7M+wgehf9N7RQ+jLwhrb+KuDqvm2tatNvAL5UfpezJI3U0I5cknwSeA1wZJItwPn07g47GNjUrrFfX1X/qapuT3IlcAe902XnVNVP2nbeDlwLzAPWVtXtbRfvAdYn+SPg68ClrX4pcEWSKXo3FJwxrDFKkmY2tHCpqjNnKF86Q21n+wuAC2aobwQ2zlC/h97dZNPrPwLeuFedlSR1yk/oS5I6Z7hIkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6Z7hIkjo3tHBJsjbJQ0lu66sdkWRTkrvbz8NbPUkuTjKV5JYkx/Wts6q1vzvJqr76K5Lc2ta5OEl2tw9J0ugM88jlMmDFtNq5wHVVtRS4rs0DnAwsba/VwCXQCwrgfOBVwPHA+X1hcQnw1r71VuxhH5KkERlauFTVV4Ht08orgXVteh1wel/98uq5HliQ5HnAScCmqtpeVQ8Dm4AVbdlzqur6qirg8mnbmmkfkqQRGfU1l6Or6oE2/SBwdJteCNzf125Lq+2uvmWG+u728TRJVifZnGTztm3b9mE4kqSZjO2CfjviqHHuo6rWVNXyqlp+1FFHDbMrknRAGXW4fLed0qL9fKjVtwLH9LVb1Gq7qy+aob67fUiSRmTU4bIB2HnH1yrg6r76We2usROAR9uprWuB1yU5vF3Ifx1wbVv2WJIT2l1iZ03b1kz7kCSNyPxhbTjJJ4HXAEcm2ULvrq8LgSuTnA18C3hTa74ROAWYAh4H3gJQVduTfAC4qbV7f1XtvEngbfTuSDsEuKa92M0+JEkjMrRwqaozd7HoxBnaFnDOLrazFlg7Q30zcOwM9e/NtA9J0uj4CX1JUucMF0lS5wwXSVLnDBdJUucMF0lS5wwXSVLnDBdJUucMF0lS5wwXSVLnDBdJUucMF0lS5wwXSVLnDBdJUucMF0lS5wwXSVLnDBdJUucMF0lS5wwXSVLnDBdJUucMF0lS5wwXSVLnDBdJUucMF0lS5wwXSVLnDBdJUufGEi5Jfi/J7UluS/LJJM9KsiTJDUmmknwqyUGt7cFtfqotX9y3nfNa/a4kJ/XVV7TaVJJzRz9CSTqwjTxckiwE3gEsr6pjgXnAGcAHgYuq6oXAw8DZbZWzgYdb/aLWjiTL2novAVYAH0syL8k84KPAycAy4MzWVpI0IuM6LTYfOCTJfOBQ4AHgtcBVbfk64PQ2vbLN05afmCStvr6qnqiqe4Ep4Pj2mqqqe6rqSWB9aytJGpGRh0tVbQX+BPg2vVB5FLgZeKSqdrRmW4CFbXohcH9bd0dr/9z++rR1dlV/miSrk2xOsnnbtm2zH5wkCRjPabHD6R1JLAGeDzyb3mmtkauqNVW1vKqWH3XUUePogiTNSeM4LfarwL1Vta2qfgx8Fng1sKCdJgNYBGxt01uBYwDa8sOA7/XXp62zq7okaUTGES7fBk5Icmi7dnIicAfwZeANrc0q4Oo2vaHN05Z/qaqq1c9od5MtAZYCNwI3AUvb3WcH0bvov2EE45IkNfP33KRbVXVDkquArwE7gK8Da4AvAOuT/FGrXdpWuRS4IskUsJ1eWFBVtye5kl4w7QDOqaqfACR5O3AtvTvR1lbV7aManyRpDOECUFXnA+dPK99D706v6W1/BLxxF9u5ALhghvpGYOPseypJ2hd+Ql+S1LmBwiXJLw67I5KkuWPQI5ePJbkxyduSHDbUHkmSJt5A4VJVvwy8md4tvjcn+YskvzbUnkmSJtbA11yq6m7gD4D3AP8auDjJN5P8u2F1TpI0mQa95vLSJBcBd9J7BtivV9W/aNMXDbF/kqQJNOityH8KfBx4b1X9cGexqr6T5A+G0jNJ0sQaNFxOBX7Y9yHFZwDPqqrHq+qKofVOkjSRBr3m8kXgkL75Q1tNkqSnGTRcnlVV/7Bzpk0fOpwuSZIm3aDh8oMkx+2cSfIK4Ie7aS9JOoANes3lXcCnk3wHCPDPgN8YWq8kSRNtoHCpqpuSvBh4USvd1b6LRZKkp9mbpyK/Eljc1jkuCVV1+VB6JUmaaAOFS5IrgH8OfAP4SSsXYLhIkp5m0COX5cCy9g2QkiTt1qB3i91G7yK+JEl7NOiRy5HAHUluBJ7YWayq04bSK0nSRBs0XP5wmJ2QJM0tg96K/DdJfh5YWlVfTHIoMG+4XZMkTapBH7n/VuAq4M9aaSHw+WF1SpI02Qa9oH8O8GrgMfjHLw77p8PqlCRpsg0aLk9U1ZM7Z5LMp/c5F0mSnmbQcPmbJO8FDknya8Cngf8zvG5JkibZoOFyLrANuBX4j8BGwG+glCTNaNC7xX4K/K/2kiRptwa9W+zeJPdMf+3rTpMsSHJVkm8muTPJLyU5IsmmJHe3n4e3tklycZKpJLdM+16ZVa393UlW9dVfkeTWts7FSbKvfZUk7b1BT4stp/dU5FcCvwxcDPzvWez3I8BfVdWLgZcBd9I79XZdVS0FrmvzACcDS9trNXAJQJIjgPOBVwHHA+fvDKTW5q19662YRV8lSXtpoHCpqu/1vbZW1YeBU/dlh0kOA34FuLRt+8mqegRYCaxrzdYBp7fplcDl1XM9sCDJ84CTgE1Vtb2qHgY2ASvasudU1fXtQZuX921LkjQCgz5y/7i+2WfQO5LZm++C6beE3s0Bf57kZcDNwDuBo6vqgdbmQeDoNr0QuL9v/S2ttrv6lhnqT5NkNb2jIV7wghfs43AkSdMNGhD/o296B3Af8KZZ7PM44Her6oYkH+GpU2AAVFUlGfrnaKpqDbAGYPny5X5uZ4wWn/uFzrd534X7dHAtqQOD3i32bzrc5xZgS1Xd0Oavohcu303yvKp6oJ3aeqgt3woc07f+olbbCrxmWv0rrb5ohvaSpBEZ9LTYf97d8qr60KA7rKoHk9yf5EVVdRdwInBHe60CLmw/r26rbADenmQ9vYv3j7YAuhb4730X8V8HnFdV25M8luQE4AbgLOBPB+2fJGn29uabKF9J7x96gF8HbgTu3sf9/i7wiSQHAfcAb6F3LefKJGcD3+Kp024bgVOAKeDx1pYWIh8Abmrt3l9V29v024DLgEOAa9pLkjQig4bLIuC4qvo+QJI/BL5QVb+5Lzutqm/QC6zpTpyhbdF7cOZM21kLrJ2hvhk4dl/6JkmavUE/53I08GTf/JM8dTeXJEk/Y9Ajl8uBG5N8rs2fzlOfSZEk6WcMerfYBUmuoffpfIC3VNXXh9ctSdIkG/S0GMChwGNV9RFgS5IlQ+qTJGnCDfrgyvOB9wDntdIzmd2zxSRJc9igRy7/FjgN+AFAVX0H+CfD6pQkabINGi5PtluCCyDJs4fXJUnSpBs0XK5M8mf0nkj8VuCL+MVhkqRd2OPdYu2Ltj4FvBh4DHgR8F+ratOQ+yZJmlB7DJf2hOKNVfWL9L4zRZKk3Rr0Q5RfS/LKqrppz02l/UPXj/H3Ef7S4AYNl1cBv5nkPnp3jIXeQc1Lh9UxSdLk2m24JHlBVX2b3lcKS5I0kD0duXye3tOQv5XkM1X170fRKUnSZNtTuKRv+heG2RFJ2lt+Pfb+a0+fc6ldTEuStEt7OnJ5WZLH6B3BHNKm4akL+s8Zau8kSRNpt+FSVfNG1RFJ+59hnHbSgWFvHrkvSdJADBdJUucMF0lS5wwXSVLnDBdJUucMF0lS5wwXSVLnBn0qcueSzAM2A1ur6vVJlgDrgecCNwO/VVVPJjkYuBx4BfA94Deq6r62jfOAs4GfAO+oqmtbfQXwEWAe8PGqunCkgzsA+PkHSbszziOXdwJ39s1/ELioql4IPEwvNGg/H271i1o7kiwDzgBeAqwAPpZkXgutjwInA8uAM1tbSdKIjCVckiwCTgU+3uYDvBa4qjVZB5zeple2edryE1v7lcD6qnqiqu4FpoDj22uqqu6pqifpHQ2tHP6oJEk7jevI5cPAu4GftvnnAo9U1Y42vwVY2KYXAvcDtOWPtvb/WJ+2zq7qkqQRGXm4JHk98FBV3Tzqfc/Ql9VJNifZvG3btnF3R5LmjHFc0H81cFqSU4BnAc+hd/F9QZL57ehkEbC1td8KHANsSTIfOIzehf2d9Z3619lV/WdU1RpgDcDy5cv9SgHtVtc3Mfi9IZrLRh4uVXUecB5AktcA/6Wq3pzk08Ab6F0jWQVc3VbZ0Ob/X1v+paqqJBuAv0jyIeD5wFLgRnpfB7C03X22ld5F//8wouFJAzOsNJeN7VbkGbwHWJ/kj4CvA5e2+qXAFUmmgO30woKquj3JlcAdwA7gnKr6CUCStwPX0rsVeW1V3T7SkUjSAW6s4VJVXwG+0qbvoXen1/Q2PwLeuIv1LwAumKG+EdjYYVclSXvBT+hLkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6tz99WZikWej6my2l2fDIRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUuZGHS5Jjknw5yR1Jbk/yzlY/IsmmJHe3n4e3epJcnGQqyS1Jjuvb1qrW/u4kq/rqr0hya1vn4iQZ9Tgl6UA2jiOXHcDvV9Uy4ATgnCTLgHOB66pqKXBdmwc4GVjaXquBS6AXRsD5wKuA44HzdwZSa/PWvvVWjGBckqRm5OFSVQ9U1dfa9PeBO4GFwEpgXWu2Dji9Ta8ELq+e64EFSZ4HnARsqqrtVfUwsAlY0ZY9p6qur6oCLu/bliRpBMZ6zSXJYuDlwA3A0VX1QFv0IHB0m14I3N+32pZW2119ywz1mfa/OsnmJJu3bds2q7FIkp4ytnBJ8nPAZ4B3VdVj/cvaEUcNuw9VtaaqllfV8qOOOmrYu5OkA8ZYwiXJM+kFyyeq6rOt/N12Sov286FW3woc07f6olbbXX3RDHVJ0oiM426xAJcCd1bVh/oWbQB23vG1Cri6r35Wu2vsBODRdvrsWuB1SQ5vF/JfB1zblj2W5IS2r7P6tiVJGoFxfBPlq4HfAm5N8o1Wey9wIXBlkrOBbwFvass2AqcAU8DjwFsAqmp7kg8AN7V276+q7W36bcBlwCHANe0lSRqRkYdLVf1fYFefOzlxhvYFnLOLba0F1s5Q3wwcO4tuSpJmwU/oS5I6Z7hIkjpnuEiSOjeOC/oag8XnfmHcXZB0APHIRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5v4lSkvp0/a2t9114aqfbmxQeuUiSOme4SJI6Z7hIkjpnuEiSOjdnwyXJiiR3JZlKcu64+yNJB5I5GS5J5gEfBU4GlgFnJlk23l5J0oFjToYLcDwwVVX3VNWTwHpg5Zj7JEkHjLn6OZeFwP1981uAV01vlGQ1sLrN/kOSu/Zxf0cCf7+P6+5P5so4YO6MxXHsf/ZqLPngEHsyO129Jz8/U3GuhstAqmoNsGa220myuaqWd9ClsZor44C5MxbHsf+ZK2MZ9jjm6mmxrcAxffOLWk2SNAJzNVxuApYmWZLkIOAMYMOY+yRJB4w5eVqsqnYkeTtwLTAPWFtVtw9xl7M+tbafmCvjgLkzFsex/5krYxnqOFJVw9y+JOkANFdPi0mSxshwkSR1znCZpUl9zEySY5J8OckdSW5P8s5WPyLJpiR3t5+Hj7uvg0gyL8nXk/xlm1+S5Ib2vnyq3dix30uyIMlVSb6Z5M4kvzSJ70mS32v/Xd2W5JNJnjUJ70mStUkeSnJbX23G3396Lm7juSXJcePr+dPtYix/3P7buiXJ55Is6Ft2XhvLXUlOmu3+DZdZmPDHzOwAfr+qlgEnAOe0vp8LXFdVS4Hr2vwkeCdwZ9/8B4GLquqFwMPA2WPp1d77CPBXVfVi4GX0xjRR70mShcA7gOVVdSy9m2rOYDLek8uAFdNqu/r9nwwsba/VwCUj6uOgLuPpY9kEHFtVLwX+FjgPoP3tnwG8pK3zsfbv2z4zXGZnYh8zU1UPVNXX2vT36f0jtpBe/9e1ZuuA08fTw8ElWQScCny8zQd4LXBVazIp4zgM+BXgUoCqerKqHmEC3xN6d6IekmQ+cCjwABPwnlTVV4Ht08q7+v2vBC6vnuuBBUmeN5qe7tlMY6mqv66qHW32enqfAYTeWNZX1RNVdS8wRe/ft31muMzOTI+ZWTimvuyzJIuBlwM3AEdX1QNt0YPA0WPq1t74MPBu4Kdt/rnAI31/RJPyviwBtgF/3k7xfTzJs5mw96SqtgJ/AnybXqg8CtzMZL4nsOvf/6T//f8OcE2b7nwshssBLsnPAZ8B3lVVj/Uvq9596vv1vepJXg88VFU3j7svHZgPHAdcUlUvB37AtFNgE/KeHE7v/4SXAM8Hns3TT89MpEn4/Q8iyfvonRr/xLD2YbjMzkQ/ZibJM+kFyyeq6rOt/N2dh/bt50Pj6t+AXg2cluQ+eqclX0vvusWCdkoGJud92QJsqaob2vxV9MJm0t6TXwXuraptVfVj4LP03qdJfE9g17//ifz7T/LbwOuBN9dTH3TsfCyGy+xM7GNm2nWJS4E7q+pDfYs2AKva9Crg6lH3bW9U1XlVtaiqFtP7/X+pqt4MfBl4Q2u2348DoKoeBO5P8qJWOhG4gwl7T+idDjshyaHtv7Od45i496TZ1e9/A3BWu2vsBODRvtNn+6UkK+idQj6tqh7vW7QBOCPJwUmW0LtJ4cZZ7ayqfM3iBZxC766LvwPeN+7+7EW//xW9w/tbgG+01yn0rldcB9wNfBE4Ytx93YsxvQb4yzb9C+2PYwr4NHDwuPs34Bj+JbC5vS+fBw6fxPcE+G/AN4HbgCuAgyfhPQE+Se860Y/pHUmevavfPxB6d4v+HXArvbvjxj6GPYxlit61lZ1/8/+zr/372ljuAk6e7f59/IskqXOeFpMkdc5wkSR1znCRJHXOcJEkdc5wkSR1znCRJHXOcJEkde7/A8RwOG1HNyCTAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 267
        },
        "id": "OWZTGWeAndff",
        "outputId": "84eed8bb-a95c-48e9-eeec-19edb306fe8d"
      },
      "source": [
        "# histogramas\r\n",
        "estado_rj['vacina_codigo'].plot.hist(bins=15);"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZcAAAD6CAYAAABtewo9AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAZQ0lEQVR4nO3df7RdZX3n8ffHRBG1SJDIUAKCmqmNVhGuyIzTVZURAk4NzvgDOkqGYYwz4qid/iE4XYNVWQu7ptIyS1lFiQRbRYo/YDRMGlHbca3yIyjyU8otoCRGSQmC1goFv/PHee54vJx7c5Lsc+69yfu11ll3n+9+nr2fZ+2sfO7+cc5NVSFJUpeeNNcDkCTteQwXSVLnDBdJUucMF0lS5wwXSVLnDBdJUudGFi5Jnprk+iTfTnJbkj9o9UuS3JPkpvY6stWT5IIkk0luTnJU37ZWJ7mrvVb31Y9Ockvrc0GStPoBSTa29huTLBnVPCVJT5RRfc6l/Uf/9Kr6SZInA98A3g38Z+BLVXXFtPYnAf8VOAl4OfAnVfXyJAcAm4AJoIAbgaOr6sEk1wPvAq4D1gMXVNXVSf4Q2F5V5yU5C1hSVe+dbbwHHnhgHX744Z3NX5L2BjfeeOPfV9XS6fXFo9ph9VLrJ+3tk9trtiRbBVza+l2bZP8kBwOvBDZW1XaAJBuBlUm+DuxXVde2+qXAycDVbVuvbNtdB3wdmDVcDj/8cDZt2rRzk5SkvVyS7w6qj/SeS5JFSW4C7qcXENe1Vee2S1/nJ9mn1Q4B7uvrvrnVZqtvHlAHOKiqtrblHwAHdTUnSdKOjTRcqurxqjoSWAYck+RFwNnAC4CXAQewgzOKDsZQzHDGlGRNkk1JNm3btm2Uw5CkvcpYnharqh8BXwNWVtXW6nkE+CRwTGu2BTi0r9uyVputvmxAHeCH7ZIa7ef9M4zroqqaqKqJpUufcMlQkrSLRvm02NIk+7flfYHXAN/p+08/9O6R3Nq6XAWc1p4aOxZ4qF3a2gAcn2RJe+rreGBDW/dwkmPbtk4Druzb1tRTZav76pKkMRjZDX3gYGBdkkX0QuzyqvpSkq8mWQoEuIne02PQe9rrJGAS+ClwOkBVbU/yQeCG1u4DUzf3gXcAlwD70ruRf3WrnwdcnuQM4LvAm0Y2S0nSE4zsUeSFZmJionxaTJJ2TpIbq2piet1P6EuSOme4SJI6Z7hIkjo3yhv60pw6/Kwvd7q9e897bafbk/ZknrlIkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6Z7hIkjpnuEiSOme4SJI6N7JwSfLUJNcn+XaS25L8QasfkeS6JJNJPpvkKa2+T3s/2dYf3rets1v9ziQn9NVXttpkkrP66gP3IUkaj1GeuTwCvLqqXgIcCaxMcizwYeD8qno+8CBwRmt/BvBgq5/f2pFkBXAK8EJgJfCxJIuSLAI+CpwIrABObW2ZZR+SpDEYWbhUz0/a2ye3VwGvBq5o9XXAyW15VXtPW39ckrT6ZVX1SFXdA0wCx7TXZFXdXVWPApcBq1qfmfYhSRqDkd5zaWcYNwH3AxuBvwN+VFWPtSabgUPa8iHAfQBt/UPAs/rr0/rMVH/WLPuQJI3BSMOlqh6vqiOBZfTONF4wyv3trCRrkmxKsmnbtm1zPRxJ2mOM5WmxqvoR8DXgXwD7J1ncVi0DtrTlLcChAG39M4EH+uvT+sxUf2CWfUwf10VVNVFVE0uXLt2tOUqSfmGUT4stTbJ/W94XeA1wB72QeUNrthq4si1f1d7T1n+1qqrVT2lPkx0BLAeuB24Alrcnw55C76b/Va3PTPuQJI3B4h032WUHA+vaU11PAi6vqi8luR24LMmHgG8BF7f2FwOfSjIJbKcXFlTVbUkuB24HHgPOrKrHAZK8E9gALALWVtVtbVvvnWEfkqQxGFm4VNXNwEsH1O+md/9lev1nwBtn2Na5wLkD6uuB9cPuQ5I0Hn5CX5LUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUuZGFS5JDk3wtye1Jbkvy7lZ/f5ItSW5qr5P6+pydZDLJnUlO6KuvbLXJJGf11Y9Icl2rfzbJU1p9n/Z+sq0/fFTzlCQ90SjPXB4Dfq+qVgDHAmcmWdHWnV9VR7bXeoC27hTghcBK4GNJFiVZBHwUOBFYAZzat50Pt209H3gQOKPVzwAebPXzWztJ0piMLFyqamtVfbMt/xi4Azhkli6rgMuq6pGqugeYBI5pr8mquruqHgUuA1YlCfBq4IrWfx1wct+21rXlK4DjWntJ0hiM5Z5Luyz1UuC6VnpnkpuTrE2ypNUOAe7r67a51WaqPwv4UVU9Nq3+S9tq6x9q7aePa02STUk2bdu2bbfmKEn6hZGHS5JnAJ8D3lNVDwMXAs8DjgS2An806jHMpKouqqqJqppYunTpXA1DkvY4Iw2XJE+mFyx/XlWfB6iqH1bV41X1c+Dj9C57AWwBDu3rvqzVZqo/AOyfZPG0+i9tq61/ZmsvSRqDUT4tFuBi4I6q+khf/eC+Zq8Hbm3LVwGntCe9jgCWA9cDNwDL25NhT6F30/+qqirga8AbWv/VwJV921rdlt8AfLW1lySNweIdN9llrwDeCtyS5KZWex+9p72OBAq4F3g7QFXdluRy4HZ6T5qdWVWPAyR5J7ABWASsrarb2vbeC1yW5EPAt+iFGe3np5JMAtvpBZIkaUxGFi5V9Q1g0BNa62fpcy5w7oD6+kH9qupufnFZrb/+M+CNOzNeSVJ3/IS+JKlzhoskqXOGiySpc4aLJKlzhoskqXOGiySpc4aLJKlzhoskqXOGiySpc4aLJKlzhoskqXOGiySpc4aLJKlzhoskqXOGiySpc0OFS5LfGPVAJEl7jmHPXD6W5Pok70jyzJGOSJK04A0VLlX1m8C/Bw4Fbkzy6SSvGenIJEkL1tD3XKrqLuD36f3d+t8CLkjynST/dlSDkyQtTMPec3lxkvOBO4BXA79dVb/els8f4fgkSQvQ4iHb/S/gE8D7quofp4pV9f0kvz+SkUmSFqxhL4u9Fvj0VLAkeVKSpwFU1acGdUhyaJKvJbk9yW1J3t3qByTZmOSu9nNJqyfJBUkmk9yc5Ki+ba1u7e9KsrqvfnSSW1qfC5Jktn1IksZj2HD5CrBv3/untdpsHgN+r6pWAMcCZyZZAZwFXFNVy4Fr2nuAE4Hl7bUGuBB6QQGcA7wcOAY4py8sLgTe1tdvZavPtA9J0hgMGy5PraqfTL1py0+brUNVba2qb7blH9O7X3MIsApY15qtA05uy6uAS6vnWmD/JAcDJwAbq2p7VT0IbARWtnX7VdW1VVXApdO2NWgfkqQxGDZc/mHaZaqjgX+cpf0vSXI48FLgOuCgqtraVv0AOKgtHwLc19dtc6vNVt88oM4s+5AkjcGwN/TfA/xFku8DAf4Z8OZhOiZ5BvA54D1V9XC7LQJAVVWS2rkh75zZ9pFkDb1LcBx22GGjHIYk7VWGCpequiHJC4Bfa6U7q+qfdtQvyZPpBcufV9XnW/mHSQ6uqq3t0tb9rb6F3oc0pyxrtS3AK6fVv97qywa0n20f0+d1EXARwMTExEhDTpL2JjvzxZUvA14MHAWcmuS02Rq3J7cuBu6oqo/0rboKmHriazVwZV/9tPbU2LHAQ+3S1gbg+CRL2o3844ENbd3DSY5t+zpt2rYG7UOSNAZDnbkk+RTwPOAm4PFWnrqJPpNXAG8FbklyU6u9DzgPuDzJGcB3gTe1deuBk4BJ4KfA6QBVtT3JB4EbWrsPVNX2tvwO4BJ6T7Jd3V7Msg9J0hgMe89lAljRnsoaSlV9g979mUGOG9C+gDNn2NZaYO2A+ibgRQPqDwzahyRpPIa9LHYrvZv4kiTt0LBnLgcCtye5HnhkqlhVrxvJqCRJC9qw4fL+UQ5CkrRnGfZR5L9K8hxgeVV9pX2v2KLRDk2StFAN+5X7bwOuAP60lQ4BvjiqQUmSFrZhb+ifSe/R4ofh///hsGePalCSpIVt2HB5pKoenXqTZDG9z7lIkvQEw4bLXyV5H7BvktcAfwH879ENS5K0kA0bLmcB24BbgLfT+zS9f4FSkjTQsE+L/Rz4eHtJkjSrYb9b7B4G3GOpqud2PiJJ0oK3M98tNuWpwBuBA7ofjiRpTzDUPZeqeqDvtaWq/hh47YjHJklaoIa9LHZU39sn0TuTGfasR5K0lxk2IP6ob/kx4F78GymSpBkM+7TYq0Y9EEnSnmPYy2L/bbb10/6MsSRpL7czT4u9jN7fpgf4beB64K5RDEqStLANGy7LgKOq6scASd4PfLmq3jKqgUmSFq5hv/7lIODRvvePtpokSU8w7JnLpcD1Sb7Q3p8MrBvNkCRJC92wT4udm+Rq4Ddb6fSq+tbohiVJWsh25oOQTwMerqpPJlma5IiqumemxknWAv8GuL+qXtRq7wfeRu8blgHeV1Xr27qzgTOAx4F3VdWGVl8J/Am9P6v8iao6r9WPAC4DngXcCLy1qh5Nsg+9M62jgQeAN1fVvTsxz512+Flf7nR7957nlx9IWtiG/TPH5wDvBc5upScDf7aDbpcAKwfUz6+qI9trKlhWAKcAL2x9PpZkUZJFwEeBE4EVwKmtLcCH27aeDzxIL5hoPx9s9fNbO0nSGA17Q//1wOuAfwCoqu8DvzJbh6r6a2D7kNtfBVxWVY+0s6FJ4Jj2mqyqu9tfwrwMWJUkwKuBK1r/dfTuA01ta+p+0BXAca29JGlMhg2XR6uqaF+7n+Tpu7HPdya5OcnaJEta7RDgvr42m1ttpvqzgB9V1WPT6r+0rbb+odZekjQmw4bL5Un+FNg/yduAr7BrfzjsQuB5wJHAVn75O8vGLsmaJJuSbNq2bduOO0iShrLDG/rtktJngRcADwO/BvyPqtq4szurqh/2bffjwJfa2y3AoX1Nl7UaM9QfoBd0i9vZSX/7qW1tTrIYeGZrP2g8FwEXAUxMTDzhj6FJknbNDsOlqirJ+qr6DWCnA6VfkoOramt7+3rg1rZ8FfDpJB8BfhVYTu/rZQIsb0+GbaF30/932pi+BryB3n2Y1cCVfdtaDfxNW//VdklPkjQmwz6K/M0kL6uqG4bdcJLPAK8EDkyyGTgHeGWSI+ndu7kXeDtAVd2W5HLgdnpf6X9mVT3etvNOYAO9R5HXVtVtbRfvBS5L8iHgW8DFrX4x8Kkkk/QeKDhl2DFLkroxbLi8HHhLknvpPTEWeic1L56pQ1WdOqB88YDaVPtzgXMH1NcD6wfU76b3NNn0+s/o/RlmSdIcmTVckhxWVd8DThjTeCRJe4Adnbl8kd63IX83yeeq6t+NY1CSpIVtR48i93/48LmjHIgkac+xo3CpGZYlSZrRji6LvSTJw/TOYPZty/CLG/r7jXR0kqQFadZwqapF4xqIJGnPMezXv0iSNDTDRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1LmRhUuStUnuT3JrX+2AJBuT3NV+Lmn1JLkgyWSSm5Mc1ddndWt/V5LVffWjk9zS+lyQJLPtQ5I0PqM8c7kEWDmtdhZwTVUtB65p7wFOBJa31xrgQugFBXAO8HLgGOCcvrC4EHhbX7+VO9iHJGlMRhYuVfXXwPZp5VXAura8Dji5r35p9VwL7J/kYOAEYGNVba+qB4GNwMq2br+quraqCrh02rYG7UOSNCbjvudyUFVtbcs/AA5qy4cA9/W129xqs9U3D6jPto8nSLImyaYkm7Zt27YL05EkDTJnN/TbGUfN5T6q6qKqmqiqiaVLl45yKJK0Vxl3uPywXdKi/by/1bcAh/a1W9Zqs9WXDajPtg9J0piMO1yuAqae+FoNXNlXP609NXYs8FC7tLUBOD7JknYj/3hgQ1v3cJJj21Nip03b1qB9SJLGZPGoNpzkM8ArgQOTbKb31Nd5wOVJzgC+C7ypNV8PnARMAj8FTgeoqu1JPgjc0Np9oKqmHhJ4B70n0vYFrm4vZtmHJGlMRhYuVXXqDKuOG9C2gDNn2M5aYO2A+ibgRQPqDwzahyRpfPyEviSpc4aLJKlzhoskqXOGiySpc4aLJKlzhoskqXOGiySpc4aLJKlzhoskqXOGiySpc4aLJKlzhoskqXOGiySpc4aLJKlzhoskqXOGiySpc4aLJKlzhoskqXOGiySpc4aLJKlzhoskqXNzEi5J7k1yS5KbkmxqtQOSbExyV/u5pNWT5IIkk0luTnJU33ZWt/Z3JVndVz+6bX+y9c34ZylJe6+5PHN5VVUdWVUT7f1ZwDVVtRy4pr0HOBFY3l5rgAuhF0bAOcDLgWOAc6YCqbV5W1+/laOfjiRpyny6LLYKWNeW1wEn99UvrZ5rgf2THAycAGysqu1V9SCwEVjZ1u1XVddWVQGX9m1LkjQGcxUuBfxlkhuTrGm1g6pqa1v+AXBQWz4EuK+v7+ZWm62+eUBdkjQmi+dov/+qqrYkeTawMcl3+ldWVSWpUQ+iBdsagMMOO2zUu5OkvcacnLlU1Zb2837gC/TumfywXdKi/by/Nd8CHNrXfVmrzVZfNqA+aBwXVdVEVU0sXbp0d6clSWrGHi5Jnp7kV6aWgeOBW4GrgKknvlYDV7blq4DT2lNjxwIPtctnG4DjkyxpN/KPBza0dQ8nObY9JXZa37YkSWMwF5fFDgK+0J4OXgx8uqr+T5IbgMuTnAF8F3hTa78eOAmYBH4KnA5QVduTfBC4obX7QFVtb8vvAC4B9gWubi9J0piMPVyq6m7gJQPqDwDHDagXcOYM21oLrB1Q3wS8aLcHK0naJfPpUWRJ0h7CcJEkdc5wkSR1znCRJHXOcJEkdc5wkSR1znCRJHXOcJEkdc5wkSR1znCRJHXOcJEkdc5wkSR1znCRJHXOcJEkdc5wkSR1znCRJHXOcJEkdc5wkSR1znCRJHXOcJEkdc5wkSR1znCRJHVujw2XJCuT3JlkMslZcz0eSdqb7JHhkmQR8FHgRGAFcGqSFXM7Kknae+yR4QIcA0xW1d1V9ShwGbBqjsckSXuNPTVcDgHu63u/udUkSWOweK4HMJeSrAHWtLc/SXLnLm7qQODvuxkV5MNdbWmXdDqXObanHBePyfzkXHqeM6i4p4bLFuDQvvfLWu2XVNVFwEW7u7Mkm6pqYne3Mx84l/lnT5kHOJf5ahRz2VMvi90ALE9yRJKnAKcAV83xmCRpr7FHnrlU1WNJ3glsABYBa6vqtjkeliTtNfbIcAGoqvXA+jHtbrcvrc0jzmX+2VPmAc5lvup8LqmqrrcpSdrL7an3XCRJc8hw2YEkv5vktiS3JvlMkqcmuSTJPUluaq8jZ+i7Osld7bV63GOfNpbdmcfjfW3m/MGIGeaSJOcm+dskdyR51wx9580xaePZnbkshOPyf/vG+P0kX5yh77w5Lrs5j4VwTI5L8s02xm8kef4Mfc9uX591Z5ITdnrnVeVrhhe9D17eA+zb3l8O/AfgEuANO+h7AHB3+7mkLS9ZaPNo7X8y18diiLmcDlwKPKnVnz2fj8nuzmWhHJdpbT4HnDafj8vuzGOhHBPgb4Ffb7V3AJcM6LsC+DawD3AE8HfAop3Zv2cuO7YY2DfJYuBpwPeH7HcCsLGqtlfVg8BGYOWIxjiMXZ3HfDRoLv8F+EBV/Rygqu4f0G++HRPY9bnMRzP+G0uyH/BqYNBv/PPtuOzqPOajQXMpYL+2/pkM/r9gFXBZVT1SVfcAk/S+VmtohsssqmoL8D+B7wFbgYeq6i/b6nOT3Jzk/CT7DOg+b76CZjfnAfDUJJuSXJvk5HGMeSazzOV5wJvbOK9OsnxA93lzTGC35wIL47hMORm4pqoeHtB93hyX3ZwHLIxj8p+A9Uk2A28FzhvQfbePieEyiyRL6CX4EcCvAk9P8hbgbOAFwMvoncq/d84GOYQO5vGc6n1693eAP07yvNGPerBZ5rIP8LM2zo8Da+dqjMPqYC4L4bhMORX4zFyMbWd0MI+FcEx+FzipqpYBnwQ+Mor9Gy6z+9fAPVW1rar+Cfg88C+ramv1PELv4Aw6XRzqK2jGZHfmMfUbEFV1N/B14KXjGfZAA+dC7zerz7c2XwBePKDvfDomsHtzWSjHhSQH0vu39eUZ+s6n47I781gIx+QVwEuq6rrW5rO0+U2z28fEcJnd94BjkzwtSYDjgDuSHAzQaicDtw7ouwE4PsmS9hvE8a02F3Z5Hm38+7TlA+n947x9bCN/ooFzoXcN/FWtzW/Ru2k53Xw6JrAbc1lAxwXgDcCXqupnM/SdT8dll+exQI7J7cAzk/zz1uY1/GJ+/a4CTkmyT5IjgOXA9Tu197l+omG+v4A/AL5D7z/eT9G7ZPFV4JZW+zPgGa3tBPCJvr7/kd6NsEng9IU4D3q/1dxC78mRW4Az5ukx2Z/eb5S3AH9D77ezeX1MdmcuC+W4tPrXgZXT2s7b47Kr81goxwR4fd84vw48t7V9Hb0HSab6/nd6T4ndCZy4s/v2E/qSpM55WUyS1DnDRZLUOcNFktQ5w0WS1DnDRZLUOcNFktQ5w0WS1DnDRZLUuf8H+x1y7oxL3bUAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 276
        },
        "id": "yFmMelw6rOit",
        "outputId": "15e002b1-1a81-4c5c-ba07-5d5dcd058363"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXgAAAEDCAYAAAA/eB+kAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAP/ElEQVR4nO3da5BlVXnG8f/jDMpFIxpaYgAdMAihUGRsLwlqFGOComASNVqaWIZyUhVjMDFRNJbRD6nSqsRbSi0niIIXVFAIQcWAosSUgjOIOgwqiqijmGkvyCWWgL75cPZIzzDTc2b6rO6e1f9fVVefvc8+e72b1Tyzep3V+6SqkCT1526LXYAkqQ0DXpI6ZcBLUqcMeEnqlAEvSZ0y4CWpU0su4JOckWRzkg1jHv+sJBuTXJ3k/a3rk6Q9RZbaOvgkjwNuAc6qqqN3cuzhwIeA46vqJ0nuV1WbF6JOSVrqltwIvqouA348e1+SByW5KMn6JP+d5MjhqRcCb62qnwyvNdwlabDkAn4H1gIvrqqHA38PvG3Y/2DgwUn+J8nnk5ywaBVK0hKzcrEL2Jkk9wR+FzgnyZbd9xi+rwQOBx4PHAxcluQhVXXjQtcpSUvNkg94Rr9l3FhVD9vOc5uAy6vqduBbSb7OKPC/sJAFStJStOSnaKrqJkbh/UyAjBwzPH0+o9E7SQ5gNGVz3WLUKUlLzZIL+CRnA58DjkiyKckpwHOBU5J8CbgaOHk4/BPAj5JsBC4F/qGqfrQYdUvSUtN0mWSS/YHTgaOBAv6iqj7XrEFJ0q+0noN/M3BRVT0jyd2BfRu3J0kaNBvBJ7k3cBVwWI3ZyAEHHFCrVq1qUo8k9Wj9+vU/rKqp7T3XcgR/KDADvGt4U3Q9cGpV3Tr7oCRrgDUAD3jAA1i3bl3DkiSpL0m+vaPnWr7JuhJYDby9qo4FbgVO2/agqlpbVdNVNT01td1/hCRJu6FlwG8CNlXV5cP2uYwCX5K0AJoFfFX9APhukiOGXU8ENrZqT5K0tdaraF4MvG9YQXMd8ILG7UmSBk0DvqquAqZbtiFJ2r4l95eskqTJMOAlqVMGvCR1yoCXpE7tCfeDH8uq0z460fNd/7oTJ3o+SVpojuAlqVMGvCR1yoCXpE4Z8JLUKQNekjplwEtSpwx4SeqUAS9JnTLgJalTBrwkdcqAl6ROGfCS1CkDXpI6ZcBLUqcMeEnqlAEvSZ0y4CWpUwa8JHXKgJekThnwktQpA16SOmXAS1KnVrY8eZLrgZuBXwB3VNV0y/YkSXdqGvCDJ1TVDxegHUnSLE7RSFKnWgd8Af+VZH2SNds7IMmaJOuSrJuZmWlcjiQtH60D/jFVtRp4MvCiJI/b9oCqWltV01U1PTU11bgcSVo+mgZ8VX1v+L4ZOA94ZMv2JEl3ahbwSfZLcq8tj4E/ADa0ak+StLWWq2gOBM5LsqWd91fVRQ3bkyTN0izgq+o64JhW55ckzc1lkpLUKQNekjplwEtSpwx4SeqUAS9JnTLgJalTBrwkdcqAl6ROGfCS1CkDXpI6ZcBLUqcMeEnqlAEvSZ0y4CWpUwa8JHXKgJekThnwktQpA16SOmXAS1KnDHhJ6pQBL0mdMuAlqVMGvCR1yoCXpE4Z8JLUKQNekjplwEtSp5oHfJIVSb6Y5MLWbUmS7rQQI/hTgWsWoB1J0ixNAz7JwcCJwOkt25Ek3VXrEfybgJcBv9zRAUnWJFmXZN3MzEzjciRp+WgW8EmeCmyuqvVzHVdVa6tquqqmp6amWpUjSctOyxH8ccBJSa4HPgAcn+S9DduTJM3SLOCr6hVVdXBVrQKeDXyqqp7Xqj1J0tZcBy9JnVq5EI1U1aeBTy9EW5KkEUfwktQpA16SOmXAS1KnDHhJ6pQBL0mdMuAlqVMGvCR1aqyAT/KQ1oVIkiZr3BH825JckeSvkty7aUWSpIkYK+Cr6rHAc4FDgPVJ3p/kSU0rkyTNy9hz8FV1LfAq4OXA7wFvSfLVJH/cqjhJ0u4bdw7+oUneyOij944HnlZVvz08fmPD+iRJu2ncm439G6OP3XtlVf1sy86q+n6SVzWpTJI0L+MG/InAz6rqFwBJ7gbsXVX/V1XvaVadJGm3jTsHfwmwz6ztfYd9kqQlatyA37uqbtmyMTzet01JkqRJGDfgb02yestGkocDP5vjeEnSIht3Dv4lwDlJvg8E+A3gT5tVJUmat7ECvqq+kORI4Ihh19eq6vZ2ZUmS5mtXPpP1EcCq4TWrk1BVZzWpSpI0b2MFfJL3AA8CrgJ+MewuwICXpCVq3BH8NHBUVVXLYiRJkzPuKpoNjN5YlSTtIcYdwR8AbExyBfDzLTur6qQmVUmS5m3cgH9NyyIkSZM37jLJzyR5IHB4VV2SZF9gRdvSJEnzMe7tgl8InAu8Y9h1EHB+q6IkSfM37pusLwKOA26CX334x/3mekGSvYeP+ftSkquTvHZ+pUqSdsW4c/A/r6rbkgCQZCWjdfBzvgY4vqpuSbIX8NkkH6+qz+9+uZKkcY07gv9MklcC+wyfxXoO8J9zvaBGttyBcq/hy3X0krRAxg3404AZ4CvAXwIfY/T5rHNKsiLJVcBm4OKqunw7x6xJsi7JupmZmfErlyTNadxVNL8E/n34GtvwCVAPS7I/cF6So6tqwzbHrAXWAkxPTzvCl6QJGfdeNN9iO9MrVXXYOK+vqhuTXAqcwOivYiVJje3KvWi22Bt4JnDfuV6QZAq4fQj3fYAnAa/frSolSbts3CmaH22z601J1gOvnuNl9wfOTLKC0Vz/h6rqwt0rU5K0q8adolk9a/NujEb0c762qr4MHLv7pUmS5mPcKZp/nfX4DuB64FkTr0aSNDHjTtE8oXUhkqTJGneK5u/mer6q3jCZciRJk7Irq2geAVwwbD8NuAK4tkVRkqT5GzfgDwZWV9XNAEleA3y0qp7XqjBJ0vyMe6uCA4HbZm3fNuyTJC1R447gzwKuSHLesP104Mw2JUmSJmHcVTT/nOTjwGOHXS+oqi+2K0uSNF/jTtEA7AvcVFVvBjYlObRRTZKkCRj3I/v+CXg58Iph117Ae1sVJUmav3FH8H8EnATcClBV3wfu1aooSdL8jRvwt1VVMdwyOMl+7UqSJE3CuAH/oSTvAPZP8kLgEnbxwz8kSQtrp6toMvqk7Q8CRwI3AUcAr66qixvXJkmah50GfFVVko9V1UMAQ12S9hDjTtFcmeQRTSuRJE3UuH/J+ijgeUmuZ7SSJowG9w9tVZgkaX7mDPgkD6iq7wB/uED1SJImZGcj+PMZ3UXy20k+XFV/shBFSZLmb2dz8Jn1+LCWhUiSJmtnAV87eCxJWuJ2NkVzTJKbGI3k9xkew51vsv5a0+okSbttzoCvqhULVYgkabJ25XbBkqQ9yLjr4CVJg1WnfXSi57v+dSdO9HxbOIKXpE4Z8JLUqWYBn+SQJJcm2Zjk6iSntmpLknRXLefg7wBeWlVXJrkXsD7JxVW1sWGbkqRBsxF8Vd1QVVcOj28GrgEOatWeJGlrCzIHn2QVcCxw+XaeW5NkXZJ1MzMzC1GOJC0LzQM+yT2BDwMvqaqbtn2+qtZW1XRVTU9NTbUuR5KWjaYBn2QvRuH+vqr6SMu2JElba7mKJsA7gWuq6g2t2pEkbV/LEfxxwJ8Bxye5avh6SsP2JEmzNFsmWVWfZev7yUuSFpB/ySpJnTLgJalTBrwkdcqAl6ROGfCS1CkDXpI6ZcBLUqcMeEnqlAEvSZ0y4CWpUwa8JHXKgJekThnwktQpA16SOmXAS1KnDHhJ6pQBL0mdMuAlqVMGvCR1yoCXpE4Z8JLUKQNekjplwEtSpwx4SeqUAS9JnTLgJalTBrwkdapZwCc5I8nmJBtatSFJ2rGWI/h3Ayc0PL8kaQ7NAr6qLgN+3Or8kqS5OQcvSZ1a9IBPsibJuiTrZmZmFrscSerGogd8Va2tqumqmp6amlrsciSpG4se8JKkNloukzwb+BxwRJJNSU5p1ZYk6a5WtjpxVT2n1bklSTvnFI0kdcqAl6ROGfCS1CkDXpI6ZcBLUqcMeEnqlAEvSZ0y4CWpUwa8JHXKgJekThnwktQpA16SOmXAS1KnDHhJ6pQBL0mdMuAlqVMGvCR1yoCXpE4Z8JLUKQNekjplwEtSpwx4SeqUAS9JnTLgJalTBrwkdcqAl6ROGfCS1CkDXpI61TTgk5yQ5GtJvpHktJZtSZK21izgk6wA3go8GTgKeE6So1q1J0naWssR/COBb1TVdVV1G/AB4OSG7UmSZlnZ8NwHAd+dtb0JeNS2ByVZA6wZNm9J8rVdaOMA4Ie7XeEc8voWZ52YZte9xHndy8uyue5t8mZXr/uBO3qiZcCPparWAmt357VJ1lXV9IRLWvK87uXF615eJnndLadovgccMmv74GGfJGkBtAz4LwCHJzk0yd2BZwMXNGxPkjRLsymaqrojyV8DnwBWAGdU1dUTbma3pnY64HUvL1738jKx605VTepckqQlxL9klaROGfCS1Kk9MuCXyy0QkhyS5NIkG5NcneTUYf99k1yc5Nrh+30Wu9YWkqxI8sUkFw7bhya5fOj3Dw5v3nclyf5Jzk3y1STXJPmdZdTffzv8nG9IcnaSvXvs8yRnJNmcZMOsfdvt44y8Zbj+LydZvStt7XEBv8xugXAH8NKqOgp4NPCi4VpPAz5ZVYcDnxy2e3QqcM2s7dcDb6yq3wJ+ApyyKFW19Wbgoqo6EjiG0fV3399JDgL+BpiuqqMZLcx4Nn32+buBE7bZt6M+fjJw+PC1Bnj7rjS0xwU8y+gWCFV1Q1VdOTy+mdH/7Acxut4zh8POBJ6+OBW2k+Rg4ETg9GE7wPHAucMh3V13knsDjwPeCVBVt1XVjSyD/h6sBPZJshLYF7iBDvu8qi4DfrzN7h318cnAWTXyeWD/JPcft609MeC3dwuEgxaplgWTZBVwLHA5cGBV3TA89QPgwEUqq6U3AS8Dfjls/zpwY1XdMWz32O+HAjPAu4apqdOT7Mcy6O+q+h7wL8B3GAX7T4H19N/nW+yoj+eVd3tiwC87Se4JfBh4SVXdNPu5Gq1z7Wqta5KnApurav1i17LAVgKrgbdX1bHArWwzHdNjfwMMc84nM/pH7jeB/bjrNMayMMk+3hMDflndAiHJXozC/X1V9ZFh9/9u+TVt+L55sepr5DjgpCTXM5qCO57R3PT+w6/v0Ge/bwI2VdXlw/a5jAK/9/4G+H3gW1U1U1W3Ax9h9HPQe59vsaM+nlfe7YkBv2xugTDMO78TuKaq3jDrqQuA5w+Pnw/8x0LX1lJVvaKqDq6qVYz691NV9VzgUuAZw2E9XvcPgO8mOWLY9URgI5339+A7wKOT7Dv83G+59q77fJYd9fEFwJ8Pq2keDfx01lTOzlXVHvcFPAX4OvBN4B8Xu56G1/kYRr+qfRm4avh6CqP56E8C1wKXAPdd7Fob/jd4PHDh8Pgw4ArgG8A5wD0Wu74G1/swYN3Q5+cD91ku/Q28FvgqsAF4D3CPHvscOJvR+wy3M/qt7ZQd9TEQRqsGvwl8hdEqo7Hb8lYFktSpPXGKRpI0BgNekjplwEtSpwx4SeqUAS9JnTLgJalTBrwkder/AUWV65hro/RHAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    }
  ]
}