ImersaoDadosAlura2020.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "ImersaoDadosAlura2020.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyP3TdbKX9OvEpm66uxK2OlQ",
      "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/palomabareli/imersaoDeDadosAlura2020/blob/main/ImersaoDadosAlura2020.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "_-lfZCMbgztl"
      },
      "source": [
        "**Aula 01 - #ImersaoDeDados**"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "nfZ8c00Wf8aa"
      },
      "source": [
        "Este é um projeto que esta sendo desenvolvido na semana de #ImersaoDados promovido pela Alura que esta ocorrendo no período de 19/10/2020 à 23/10/2020.\n",
        "No caso,o foco dessa primeira aula será um Dataset educacional, com os dados do ENEM 2019 - com dados pré-processados, cujo dataset teve sua volumetria reduzida, afim de não termos problemas com o processamento do Colab (os dataset original pode ser encontrado em http://inep.gov.br/microdados.\n",
        "O dicionário de dados pode ser encontrado no link do Github da Alura: https://github.com/alura-cursos/imersao-dados-2-2020/tree/master/DICION%C3%81RIO)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "S1rYibDQnwAk"
      },
      "source": [
        "Deste modo, o dataset pré-processado pode ser encontrado em: https://github.com/alura-cursos/imersao-dados-2-2020/blob/master/MICRODADOS_ENEM_2019_SAMPLE_43278.csv"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "yg3ElI9roDKA"
      },
      "source": [
        "**Pandas**:\n",
        "\n",
        "Uma das bibliotecas mais utilizadas em Data Sciense. Essa biblioteca é destinada para tratamento de grande volumes de dados. Existem basicamente dois tipos principais de dados nesta biblioteca: Series e DataFrame. "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NVXyJ9tFf0Wi",
        "outputId": "086057c2-98b3-4182-c0ed-afa7f5e7399a",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 256
        }
      },
      "source": [
        "import pandas as pd\n",
        "\n",
        "#Arquivo com os dados pré-processados (amostra)\n",
        "file = 'https://github.com/alura-cursos/imersao-dados-2-2020/blob/master/MICRODADOS_ENEM_2019_SAMPLE_43278.csv?raw=true'\n",
        "\n",
        "#Lendo os dados do CSV e transformando em um Dataframe\n",
        "data = pd.read_csv(file)\n",
        "\n",
        "#Exibindo as 5 primeiras linhas, por default\n",
        "data.head()"
      ],
      "execution_count": 1,
      "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>NU_INSCRICAO</th>\n",
              "      <th>NU_ANO</th>\n",
              "      <th>CO_MUNICIPIO_RESIDENCIA</th>\n",
              "      <th>NO_MUNICIPIO_RESIDENCIA</th>\n",
              "      <th>CO_UF_RESIDENCIA</th>\n",
              "      <th>SG_UF_RESIDENCIA</th>\n",
              "      <th>NU_IDADE</th>\n",
              "      <th>TP_SEXO</th>\n",
              "      <th>TP_ESTADO_CIVIL</th>\n",
              "      <th>TP_COR_RACA</th>\n",
              "      <th>TP_NACIONALIDADE</th>\n",
              "      <th>CO_MUNICIPIO_NASCIMENTO</th>\n",
              "      <th>NO_MUNICIPIO_NASCIMENTO</th>\n",
              "      <th>CO_UF_NASCIMENTO</th>\n",
              "      <th>SG_UF_NASCIMENTO</th>\n",
              "      <th>TP_ST_CONCLUSAO</th>\n",
              "      <th>TP_ANO_CONCLUIU</th>\n",
              "      <th>TP_ESCOLA</th>\n",
              "      <th>TP_ENSINO</th>\n",
              "      <th>IN_TREINEIRO</th>\n",
              "      <th>CO_ESCOLA</th>\n",
              "      <th>CO_MUNICIPIO_ESC</th>\n",
              "      <th>NO_MUNICIPIO_ESC</th>\n",
              "      <th>CO_UF_ESC</th>\n",
              "      <th>SG_UF_ESC</th>\n",
              "      <th>TP_DEPENDENCIA_ADM_ESC</th>\n",
              "      <th>TP_LOCALIZACAO_ESC</th>\n",
              "      <th>TP_SIT_FUNC_ESC</th>\n",
              "      <th>IN_BAIXA_VISAO</th>\n",
              "      <th>IN_CEGUEIRA</th>\n",
              "      <th>IN_SURDEZ</th>\n",
              "      <th>IN_DEFICIENCIA_AUDITIVA</th>\n",
              "      <th>IN_SURDO_CEGUEIRA</th>\n",
              "      <th>IN_DEFICIENCIA_FISICA</th>\n",
              "      <th>IN_DEFICIENCIA_MENTAL</th>\n",
              "      <th>IN_DEFICIT_ATENCAO</th>\n",
              "      <th>IN_DISLEXIA</th>\n",
              "      <th>IN_DISCALCULIA</th>\n",
              "      <th>IN_AUTISMO</th>\n",
              "      <th>IN_VISAO_MONOCULAR</th>\n",
              "      <th>...</th>\n",
              "      <th>TX_RESPOSTAS_CH</th>\n",
              "      <th>TX_RESPOSTAS_LC</th>\n",
              "      <th>TX_RESPOSTAS_MT</th>\n",
              "      <th>TP_LINGUA</th>\n",
              "      <th>TX_GABARITO_CN</th>\n",
              "      <th>TX_GABARITO_CH</th>\n",
              "      <th>TX_GABARITO_LC</th>\n",
              "      <th>TX_GABARITO_MT</th>\n",
              "      <th>TP_STATUS_REDACAO</th>\n",
              "      <th>NU_NOTA_COMP1</th>\n",
              "      <th>NU_NOTA_COMP2</th>\n",
              "      <th>NU_NOTA_COMP3</th>\n",
              "      <th>NU_NOTA_COMP4</th>\n",
              "      <th>NU_NOTA_COMP5</th>\n",
              "      <th>NU_NOTA_REDACAO</th>\n",
              "      <th>Q001</th>\n",
              "      <th>Q002</th>\n",
              "      <th>Q003</th>\n",
              "      <th>Q004</th>\n",
              "      <th>Q005</th>\n",
              "      <th>Q006</th>\n",
              "      <th>Q007</th>\n",
              "      <th>Q008</th>\n",
              "      <th>Q009</th>\n",
              "      <th>Q010</th>\n",
              "      <th>Q011</th>\n",
              "      <th>Q012</th>\n",
              "      <th>Q013</th>\n",
              "      <th>Q014</th>\n",
              "      <th>Q015</th>\n",
              "      <th>Q016</th>\n",
              "      <th>Q017</th>\n",
              "      <th>Q018</th>\n",
              "      <th>Q019</th>\n",
              "      <th>Q020</th>\n",
              "      <th>Q021</th>\n",
              "      <th>Q022</th>\n",
              "      <th>Q023</th>\n",
              "      <th>Q024</th>\n",
              "      <th>Q025</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>190001004661</td>\n",
              "      <td>2019</td>\n",
              "      <td>1506138</td>\n",
              "      <td>Redenção</td>\n",
              "      <td>15</td>\n",
              "      <td>PA</td>\n",
              "      <td>17</td>\n",
              "      <td>M</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>1506138.0</td>\n",
              "      <td>Redenção</td>\n",
              "      <td>15.0</td>\n",
              "      <td>PA</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>ACAEAAACABEBABAADCEEEDE*CBDCCCADADCCCBEBBBBDB</td>\n",
              "      <td>99999CCCABBCAADDBCEBCCADBEEBDECBAABDEACACAEABB...</td>\n",
              "      <td>DEEDCAECDDEEECBCBECABEBAECBBCDAECAEBBBBBDCCDB</td>\n",
              "      <td>1</td>\n",
              "      <td>DEADBAAAEBEECEBCBCBCBDADAEABCEDDDDADCBEECACBC</td>\n",
              "      <td>ACACEEBCCBABADBBBACDBBACCCCADCEBADCBEEDBBEADB</td>\n",
              "      <td>EBBADCABDABACBCEBDEEAAADDBECDECDDBADBCDAAECBCC...</td>\n",
              "      <td>AADDDBEEEBEDDBEBACABCDBABECECACAECDCBDCCEDCDA</td>\n",
              "      <td>1.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>420.0</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>4</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>190001004674</td>\n",
              "      <td>2019</td>\n",
              "      <td>1504208</td>\n",
              "      <td>Marabá</td>\n",
              "      <td>15</td>\n",
              "      <td>PA</td>\n",
              "      <td>23</td>\n",
              "      <td>M</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>1504208.0</td>\n",
              "      <td>Marabá</td>\n",
              "      <td>15.0</td>\n",
              "      <td>PA</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>ABBCEADCEBAAACACEDCDCDACCCACDCBCABCAACBDBDEDE</td>\n",
              "      <td>99999ABCEBCEDDECEEEBBCCEECCABDABEEBCDEAEBBEAEA...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CBABADBBCEEEBCBADCBEEDBBEADBBACDBBACCCCADACAC</td>\n",
              "      <td>BBEDABDACACBABAECBBCCADCEBDBBCDDEEAAADDBECDECA...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>400.0</td>\n",
              "      <td>C</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>4</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>190001004722</td>\n",
              "      <td>2019</td>\n",
              "      <td>1501402</td>\n",
              "      <td>Belém</td>\n",
              "      <td>15</td>\n",
              "      <td>PA</td>\n",
              "      <td>35</td>\n",
              "      <td>F</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1501402.0</td>\n",
              "      <td>Belém</td>\n",
              "      <td>15.0</td>\n",
              "      <td>PA</td>\n",
              "      <td>1</td>\n",
              "      <td>12</td>\n",
              "      <td>1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>CDCAACCAAADEACBBEBAAEECDABDEBAEAABEDCABABAABC</td>\n",
              "      <td>99999ECBCECEBBABECCCECECCEECCDECEEEDADDDDECEDD...</td>\n",
              "      <td>DDBEADEBBCADCEEACABECBCEBADECADCEDAACBDABABCE</td>\n",
              "      <td>1</td>\n",
              "      <td>AAECACDEADCBCDDDBCBDADAEABCEBABEEBCBEECEBDADC</td>\n",
              "      <td>CBABADBBCEEEBCBADCBEEDBBEADBBACDBBACCCCADACAC</td>\n",
              "      <td>BBEDABDACACBABAECBBCCADCEBDBBCDDEEAAADDBECDECA...</td>\n",
              "      <td>EEEADBEBACABCDBABECECACDCBDCCEDCDABEDECDDDBAA</td>\n",
              "      <td>1.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>560.0</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>5</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>190001004735</td>\n",
              "      <td>2019</td>\n",
              "      <td>1507300</td>\n",
              "      <td>São Félix do Xingu</td>\n",
              "      <td>15</td>\n",
              "      <td>PA</td>\n",
              "      <td>23</td>\n",
              "      <td>F</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>1505437.0</td>\n",
              "      <td>Ourilândia do Norte</td>\n",
              "      <td>15.0</td>\n",
              "      <td>PA</td>\n",
              "      <td>1</td>\n",
              "      <td>7</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>EECCCEDBADBEAAAAEBAECEAAAAEEEBACCAC*CEAEDAECE</td>\n",
              "      <td>99999BABCDABBCBDDAAECADBDDADDCBCEEDCAEBCEAEABD...</td>\n",
              "      <td>CBDEBBCBDEBCABCDBDEDADCCBEDBCAECEBEBDEBAEECBC</td>\n",
              "      <td>1</td>\n",
              "      <td>BEEAAEBEEBADEADDADAEABCEDDDBCBCBCCACBCDADCCEB</td>\n",
              "      <td>EEBCEEDBADBBCBABCCADCEBACDBBACCACACBEADBBADCB</td>\n",
              "      <td>ADBBEDCABAABBCBCDAAECDDDBAAAECADECDCEBDEEAECBD...</td>\n",
              "      <td>BEDEEEAADBEBACABCDBABECECACADCBDCCEDCDABECDDD</td>\n",
              "      <td>1.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>E</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>1</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>190001004776</td>\n",
              "      <td>2019</td>\n",
              "      <td>1500800</td>\n",
              "      <td>Ananindeua</td>\n",
              "      <td>15</td>\n",
              "      <td>PA</td>\n",
              "      <td>16</td>\n",
              "      <td>F</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>1500800.0</td>\n",
              "      <td>Ananindeua</td>\n",
              "      <td>15.0</td>\n",
              "      <td>PA</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>CCBCBEACABACABBBBACCBCEBDCBABCADADCBCADBAADEA</td>\n",
              "      <td>EBCAB99999BBCECBCACBEACBDAABDBCBBDACEBBACDCAEC...</td>\n",
              "      <td>AECCBBCBBCBDEDECACBAABEDABBEDDADCEADDBEBDBBEB</td>\n",
              "      <td>0</td>\n",
              "      <td>DEADBAAAEBEECEBCBCBCBDADAEABCEDDDDADCBEECACBC</td>\n",
              "      <td>ACACEEBCCBABADBBBACDBBACCCCADCEBADCBEEDBBEADB</td>\n",
              "      <td>EBBADCABDABACBCEBDEEAAADDBECDECDDBADBCDAAECBCC...</td>\n",
              "      <td>AADDDBEEEBEDDBEBACABCDBABECECACAECDCBDCCEDCDA</td>\n",
              "      <td>1.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>140.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>780.0</td>\n",
              "      <td>E</td>\n",
              "      <td>E</td>\n",
              "      <td>B</td>\n",
              "      <td>D</td>\n",
              "      <td>3</td>\n",
              "      <td>E</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>D</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 136 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "   NU_INSCRICAO  NU_ANO  CO_MUNICIPIO_RESIDENCIA  ... Q023  Q024 Q025\n",
              "0  190001004661    2019                  1506138  ...    A     B    B\n",
              "1  190001004674    2019                  1504208  ...    A     A    B\n",
              "2  190001004722    2019                  1501402  ...    A     A    B\n",
              "3  190001004735    2019                  1507300  ...    A     A    B\n",
              "4  190001004776    2019                  1500800  ...    A     A    B\n",
              "\n",
              "[5 rows x 136 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 1
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "0lx_R1lRqJ2m",
        "outputId": "68a834ae-4ac2-4795-bbdd-26153ca41f9d",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "#Analisando a quantidade de linhas e colunas do Dataset\n",
        "data.shape"
      ],
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(127380, 136)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 2
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "u3yHtmEBqN0x",
        "outputId": "c765f3cf-ab85-4c88-f632-91aaab117d8e",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 225
        }
      },
      "source": [
        "#Selecionando uma das colunas do Dataframe, cuja saída será uma Serie.\n",
        "data['SG_UF_RESIDENCIA']"
      ],
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0         PA\n",
              "1         PA\n",
              "2         PA\n",
              "3         PA\n",
              "4         PA\n",
              "          ..\n",
              "127375    MG\n",
              "127376    BA\n",
              "127377    BA\n",
              "127378    BA\n",
              "127379    MG\n",
              "Name: SG_UF_RESIDENCIA, Length: 127380, dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "hwkxR4ugtfU_",
        "outputId": "530459ad-1b03-4414-dc96-6f0e1fbcb4ae",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        }
      },
      "source": [
        "#Selecionando mais de uma coluna do Dataframe, cuja saída será uma Serie.\n",
        "#Atentar-se que agora os parâmetros são do tipo list!\n",
        "data[['SG_UF_RESIDENCIA','NO_MUNICIPIO_RESIDENCIA']]"
      ],
      "execution_count": 4,
      "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>SG_UF_RESIDENCIA</th>\n",
              "      <th>NO_MUNICIPIO_RESIDENCIA</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>PA</td>\n",
              "      <td>Redenção</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>PA</td>\n",
              "      <td>Marabá</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>PA</td>\n",
              "      <td>Belém</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>PA</td>\n",
              "      <td>São Félix do Xingu</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>PA</td>\n",
              "      <td>Ananindeua</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127375</th>\n",
              "      <td>MG</td>\n",
              "      <td>Montalvânia</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127376</th>\n",
              "      <td>BA</td>\n",
              "      <td>Barra da Estiva</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127377</th>\n",
              "      <td>BA</td>\n",
              "      <td>Salvador</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127378</th>\n",
              "      <td>BA</td>\n",
              "      <td>Simões Filho</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127379</th>\n",
              "      <td>MG</td>\n",
              "      <td>Belo Horizonte</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>127380 rows × 2 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       SG_UF_RESIDENCIA NO_MUNICIPIO_RESIDENCIA\n",
              "0                    PA                Redenção\n",
              "1                    PA                  Marabá\n",
              "2                    PA                   Belém\n",
              "3                    PA      São Félix do Xingu\n",
              "4                    PA              Ananindeua\n",
              "...                 ...                     ...\n",
              "127375               MG             Montalvânia\n",
              "127376               BA         Barra da Estiva\n",
              "127377               BA                Salvador\n",
              "127378               BA            Simões Filho\n",
              "127379               MG          Belo Horizonte\n",
              "\n",
              "[127380 rows x 2 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "UTh9SQjns10S",
        "outputId": "a552acab-fb18-485a-ae40-e482cd966e1f",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 694
        }
      },
      "source": [
        "#Retornando todas as colunas do Dataframe\n",
        "data.columns.values"
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array(['NU_INSCRICAO', 'NU_ANO', 'CO_MUNICIPIO_RESIDENCIA',\n",
              "       'NO_MUNICIPIO_RESIDENCIA', 'CO_UF_RESIDENCIA', 'SG_UF_RESIDENCIA',\n",
              "       'NU_IDADE', 'TP_SEXO', 'TP_ESTADO_CIVIL', 'TP_COR_RACA',\n",
              "       'TP_NACIONALIDADE', 'CO_MUNICIPIO_NASCIMENTO',\n",
              "       'NO_MUNICIPIO_NASCIMENTO', 'CO_UF_NASCIMENTO', 'SG_UF_NASCIMENTO',\n",
              "       'TP_ST_CONCLUSAO', 'TP_ANO_CONCLUIU', 'TP_ESCOLA', 'TP_ENSINO',\n",
              "       'IN_TREINEIRO', 'CO_ESCOLA', 'CO_MUNICIPIO_ESC',\n",
              "       'NO_MUNICIPIO_ESC', 'CO_UF_ESC', 'SG_UF_ESC',\n",
              "       'TP_DEPENDENCIA_ADM_ESC', 'TP_LOCALIZACAO_ESC', 'TP_SIT_FUNC_ESC',\n",
              "       'IN_BAIXA_VISAO', 'IN_CEGUEIRA', 'IN_SURDEZ',\n",
              "       'IN_DEFICIENCIA_AUDITIVA', 'IN_SURDO_CEGUEIRA',\n",
              "       'IN_DEFICIENCIA_FISICA', 'IN_DEFICIENCIA_MENTAL',\n",
              "       'IN_DEFICIT_ATENCAO', 'IN_DISLEXIA', 'IN_DISCALCULIA',\n",
              "       'IN_AUTISMO', 'IN_VISAO_MONOCULAR', 'IN_OUTRA_DEF', 'IN_GESTANTE',\n",
              "       'IN_LACTANTE', 'IN_IDOSO', 'IN_ESTUDA_CLASSE_HOSPITALAR',\n",
              "       'IN_SEM_RECURSO', 'IN_BRAILLE', 'IN_AMPLIADA_24', 'IN_AMPLIADA_18',\n",
              "       'IN_LEDOR', 'IN_ACESSO', 'IN_TRANSCRICAO', 'IN_LIBRAS',\n",
              "       'IN_TEMPO_ADICIONAL', 'IN_LEITURA_LABIAL', 'IN_MESA_CADEIRA_RODAS',\n",
              "       'IN_MESA_CADEIRA_SEPARADA', 'IN_APOIO_PERNA', 'IN_GUIA_INTERPRETE',\n",
              "       'IN_COMPUTADOR', 'IN_CADEIRA_ESPECIAL', 'IN_CADEIRA_CANHOTO',\n",
              "       'IN_CADEIRA_ACOLCHOADA', 'IN_PROVA_DEITADO', 'IN_MOBILIARIO_OBESO',\n",
              "       'IN_LAMINA_OVERLAY', 'IN_PROTETOR_AURICULAR', 'IN_MEDIDOR_GLICOSE',\n",
              "       'IN_MAQUINA_BRAILE', 'IN_SOROBAN', 'IN_MARCA_PASSO', 'IN_SONDA',\n",
              "       'IN_MEDICAMENTOS', 'IN_SALA_INDIVIDUAL', 'IN_SALA_ESPECIAL',\n",
              "       'IN_SALA_ACOMPANHANTE', 'IN_MOBILIARIO_ESPECIFICO',\n",
              "       'IN_MATERIAL_ESPECIFICO', 'IN_NOME_SOCIAL', 'CO_MUNICIPIO_PROVA',\n",
              "       'NO_MUNICIPIO_PROVA', 'CO_UF_PROVA', 'SG_UF_PROVA',\n",
              "       'TP_PRESENCA_CN', 'TP_PRESENCA_CH', 'TP_PRESENCA_LC',\n",
              "       'TP_PRESENCA_MT', 'CO_PROVA_CN', 'CO_PROVA_CH', 'CO_PROVA_LC',\n",
              "       'CO_PROVA_MT', 'NU_NOTA_CN', 'NU_NOTA_CH', 'NU_NOTA_LC',\n",
              "       'NU_NOTA_MT', 'TX_RESPOSTAS_CN', 'TX_RESPOSTAS_CH',\n",
              "       'TX_RESPOSTAS_LC', 'TX_RESPOSTAS_MT', 'TP_LINGUA',\n",
              "       'TX_GABARITO_CN', 'TX_GABARITO_CH', 'TX_GABARITO_LC',\n",
              "       'TX_GABARITO_MT', 'TP_STATUS_REDACAO', 'NU_NOTA_COMP1',\n",
              "       'NU_NOTA_COMP2', 'NU_NOTA_COMP3', 'NU_NOTA_COMP4', 'NU_NOTA_COMP5',\n",
              "       'NU_NOTA_REDACAO', 'Q001', 'Q002', 'Q003', 'Q004', 'Q005', 'Q006',\n",
              "       'Q007', 'Q008', 'Q009', 'Q010', 'Q011', 'Q012', 'Q013', 'Q014',\n",
              "       'Q015', 'Q016', 'Q017', 'Q018', 'Q019', 'Q020', 'Q021', 'Q022',\n",
              "       'Q023', 'Q024', 'Q025'], dtype=object)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "iMUY1PqCvzQb",
        "outputId": "613c84bd-7594-4611-daff-8526ebf73dca",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 69
        }
      },
      "source": [
        "#Selecionando todos os estados da amosta\n",
        "data['SG_UF_RESIDENCIA'].unique()"
      ],
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array(['PA', 'RO', 'MT', 'AC', 'AM', 'RR', 'MA', 'PR', 'BA', 'PI', 'CE',\n",
              "       'PE', 'AP', 'TO', 'SC', 'GO', 'MG', 'SP', 'SE', 'RJ', 'PB', 'AL',\n",
              "       'RN', 'ES', 'DF', 'RS', 'MS'], dtype=object)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "gAuTIE6Sv_FB",
        "outputId": "7ee52f00-fdc2-49f4-b251-d43905f28e11",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "#Selecionando a quantidade de estados da amosta\n",
        "#Por trás está executando o Numpy,já que é um array\n",
        "len(data['SG_UF_RESIDENCIA'].unique())"
      ],
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "27"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xhd8N2k7wl0C",
        "outputId": "6e67cd4c-d715-44de-bcfb-d975ee2b6ed1",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 503
        }
      },
      "source": [
        "#Selecionando a quantidade de estados da amosta\n",
        "data['SG_UF_RESIDENCIA'].value_counts()"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "SP    20264\n",
              "MG    13547\n",
              "BA    10040\n",
              "RJ     8467\n",
              "CE     7381\n",
              "PA     7170\n",
              "PE     6941\n",
              "MA     5543\n",
              "RS     5466\n",
              "PR     5259\n",
              "GO     4268\n",
              "PB     3690\n",
              "PI     3034\n",
              "RN     2959\n",
              "AM     2820\n",
              "SC     2673\n",
              "ES     2550\n",
              "DF     2408\n",
              "AL     2263\n",
              "MT     2230\n",
              "SE     1815\n",
              "MS     1655\n",
              "RO     1400\n",
              "TO     1178\n",
              "AP     1047\n",
              "AC      946\n",
              "RR      366\n",
              "Name: SG_UF_RESIDENCIA, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Gvis_j4-z8Rk",
        "outputId": "8a543257-bb2b-4c79-afd4-5e9622aeb911",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 225
        }
      },
      "source": [
        "#Agrupa a quantidade de pessoas pela idade da amosta\n",
        "#Ordenando pelo index\n",
        "data['NU_IDADE'].value_counts().sort_index()"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "13        4\n",
              "14      141\n",
              "15     2009\n",
              "16     7830\n",
              "17    21256\n",
              "      ...  \n",
              "73        2\n",
              "75        2\n",
              "76        1\n",
              "77        1\n",
              "82        1\n",
              "Name: NU_IDADE, Length: 65, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "rjnOT9OJ6jSB"
      },
      "source": [
        "Existem outras formas, além de tabelas para reinterpretação de dados visuais.\n",
        "Para isso são usados gráficos.\n",
        "Os gráficos aqui estão usando por baixo dos panos a biblioteca **Matplotlib**."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "TOeeOrnv6wvM",
        "outputId": "2a007e73-26d3-4087-861c-1d46851f8103",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 285
        }
      },
      "source": [
        "#utilizando o gráfico de Histograma para visulizar os dados de idade\n",
        "#cuidado com o padrão dos ranges para não gerar um gráfico confuso!\n",
        "data['NU_IDADE'].hist()"
      ],
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f83a5c342b0>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYMAAAD7CAYAAACIYvgKAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAXTklEQVR4nO3df6zddZ3n8edrqCjDiC3i3nRbsmVjo2FgRbiBGs3kjKxQ0Fj+cAiEDMWwdhNxVjdNZuruZom/EkzWcSBxSBrpUIwjsowuDVQ73erJZjcpUgT5KeGKZdqmULX82EpGp+57/zifyrHecs+9veee0/H5SE7u9/v+fr7f+z6np33d7+f7PbepKiRJv9t+b9QNSJJGzzCQJBkGkiTDQJKEYSBJwjCQJDFAGCR5W5KH+x4vJ/lEktOTbE/ydPu6pI1PkluSTCV5JMn5fcda28Y/nWRtX/2CJI+2fW5JkuE8XUnSdGYMg6p6qqrOq6rzgAuAV4BvAhuAHVW1EtjR1gEuA1a2xzrgVoAkpwM3AhcBFwI3HgmQNuYjffutnpdnJ0kayKJZjr8Y+FFVPZtkDdBp9c1AF/gLYA1wR/U+zbYzyeIkS9vY7VV1ECDJdmB1ki5wWlXtbPU7gCuAb71WI2eccUatWLGCn//855x66qmzfBqjY7/DZb/DZb/DNex+H3zwwZ9W1Vum2zbbMLgK+Fpbnqiq/W35OWCiLS8D9vTts7fVXqu+d5r6a1qxYgW7du2i2+3S6XRm+TRGx36Hy36Hy36Ha9j9Jnn2WNsGDoMkJwMfBD559LaqqiRD/70WSdbRm3piYmKCbrfLoUOH6Ha7w/7W88Z+h8t+h8t+h2uU/c7mzOAy4PtV9Xxbfz7J0qra36aBDrT6PuDMvv2Wt9o+Xp1WOlLvtvryacb/lqraCGwEmJycrE6nY/IPmf0Ol/0Ol/0Obja3ll7Nq1NEAFuAI3cErQXu6atf2+4qWgW81KaTtgGXJFnSLhxfAmxr215OsqrdRXRt37EkSQtgoDODJKcC7wP+fV/5JuCuJNcDzwJXtvpW4HJgit6dRx8GqKqDST4DPNDGffrIxWTgo8DtwCn0Lhy/5sVjSdL8GigMqurnwJuPqv2M3t1FR48t4IZjHGcTsGma+i7gnEF6kSTNPz+BLEkyDCRJhoEkCcNAksTsP4H8z8KKDfeN5Pvuvun9I/m+kjQTzwwkSYaBJMkwkCRhGEiSMAwkSRgGkiQMA0kShoEkCcNAkoRhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJLEgGGQZHGSu5P8MMmTSd6V5PQk25M83b4uaWOT5JYkU0keSXJ+33HWtvFPJ1nbV78gyaNtn1uSZP6fqiTpWAY9M7gZ+HZVvR14B/AksAHYUVUrgR1tHeAyYGV7rANuBUhyOnAjcBFwIXDjkQBpYz7St9/q43takqTZmDEMkrwJ+CPgNoCq+mVVvQisATa3YZuBK9ryGuCO6tkJLE6yFLgU2F5VB6vqBWA7sLptO62qdlZVAXf0HUuStAAGOTM4C/gJ8DdJHkry5SSnAhNVtb+NeQ6YaMvLgD19++9ttdeq752mLklaIIsGHHM+8GdVdX+Sm3l1SgiAqqokNYwG+yVZR2/qiYmJCbrdLocOHaLb7c7qOOvPPTyE7mY2135HyX6Hy36Hy34HN0gY7AX2VtX9bf1uemHwfJKlVbW/TfUcaNv3AWf27b+81fYBnaPq3VZfPs3431JVG4GNAJOTk9XpdOh2u3Q6nemGH9N1G+6b1fj5svuaufU7SvY7XPY7XPY7uBmniarqOWBPkre10sXAE8AW4MgdQWuBe9ryFuDadlfRKuClNp20DbgkyZJ24fgSYFvb9nKSVe0uomv7jiVJWgCDnBkA/Bnw1SQnA88AH6YXJHcluR54Friyjd0KXA5MAa+0sVTVwSSfAR5o4z5dVQfb8keB24FTgG+1hyRpgQwUBlX1MDA5zaaLpxlbwA3HOM4mYNM09V3AOYP0Ikmaf34CWZJkGEiSDANJEoaBJAnDQJKEYSBJwjCQJGEYSJIwDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiSMAwkSRgGkiQMA0kShoEkCcNAkoRhIEliwDBIsjvJo0keTrKr1U5Psj3J0+3rklZPkluSTCV5JMn5fcdZ28Y/nWRtX/2Cdvyptm/m+4lKko5tNmcGf1xV51XVZFvfAOyoqpXAjrYOcBmwsj3WAbdCLzyAG4GLgAuBG48ESBvzkb79Vs/5GUmSZu14ponWAJvb8mbgir76HdWzE1icZClwKbC9qg5W1QvAdmB123ZaVe2sqgLu6DuWJGkBDBoGBfx9kgeTrGu1iara35afAyba8jJgT9++e1vttep7p6lLkhbIogHHvaeq9iX5F8D2JD/s31hVlaTmv73f1IJoHcDExATdbpdDhw7R7XZndZz15x4eQnczm2u/o2S/w2W/w2W/gxsoDKpqX/t6IMk36c35P59kaVXtb1M9B9rwfcCZfbsvb7V9QOeoerfVl08zfro+NgIbASYnJ6vT6dDtdul0OtMNP6brNtw3q/HzZfc1c+t3lOx3uOx3uOx3cDNOEyU5NckbjywDlwCPAVuAI3cErQXuactbgGvbXUWrgJfadNI24JIkS9qF40uAbW3by0lWtbuIru07liRpAQxyZjABfLPd7bkI+Nuq+naSB4C7klwPPAtc2cZvBS4HpoBXgA8DVNXBJJ8BHmjjPl1VB9vyR4HbgVOAb7WHJGmBzBgGVfUM8I5p6j8DLp6mXsANxzjWJmDTNPVdwDkD9CtJGgI/gSxJMgwkSYaBJAnDQJKEYSBJwjCQJGEYSJIwDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiSMAwkSRgGkiQMA0kShoEkCcNAkoRhIEnCMJAkMYswSHJSkoeS3NvWz0pyf5KpJF9PcnKrv76tT7XtK/qO8clWfyrJpX311a02lWTD/D09SdIgZnNm8HHgyb71zwNfrKq3Ai8A17f69cALrf7FNo4kZwNXAX8IrAb+ugXMScCXgMuAs4Gr21hJ0gIZKAySLAfeD3y5rQd4L3B3G7IZuKItr2nrtO0Xt/FrgDur6hdV9WNgCriwPaaq6pmq+iVwZxsrSVogiwYc91fAnwNvbOtvBl6sqsNtfS+wrC0vA/YAVNXhJC+18cuAnX3H7N9nz1H1i6ZrIsk6YB3AxMQE3W6XQ4cO0e12B3waPevPPTzzoCGYa7+jZL/DZb/DZb+DmzEMknwAOFBVDybpDL+lY6uqjcBGgMnJyep0OnS7XTqd2bV13Yb7htDdzHZfM7d+R8l+h8t+h8t+BzfImcG7gQ8muRx4A3AacDOwOMmidnawHNjXxu8DzgT2JlkEvAn4WV/9iP59jlWXJC2AGa8ZVNUnq2p5Va2gdwH4O1V1DfBd4ENt2Frgnra8pa3Ttn+nqqrVr2p3G50FrAS+BzwArGx3J53cvseWeXl2kqSBDHrNYDp/AdyZ5LPAQ8BtrX4b8JUkU8BBev+4U1WPJ7kLeAI4DNxQVb8CSPIxYBtwErCpqh4/jr4kSbM0qzCoqi7QbcvP0LsT6Ogx/wj8yTH2/xzwuWnqW4Gts+lFkjR//ASyJOm4pok0Sys23Mf6cw+P5G6m3Te9f8G/p6QTh2cGkiTDQJJkGEiSMAwkSRgGkiQMA0kShoEkCcNAkoRhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJKEYSBJwjCQJGEYSJIwDCRJDBAGSd6Q5HtJfpDk8SSfavWzktyfZCrJ15Oc3Oqvb+tTbfuKvmN9stWfSnJpX311q00l2TD/T1OS9FoGOTP4BfDeqnoHcB6wOskq4PPAF6vqrcALwPVt/PXAC63+xTaOJGcDVwF/CKwG/jrJSUlOAr4EXAacDVzdxkqSFsiMYVA9h9rq69qjgPcCd7f6ZuCKtrymrdO2X5wkrX5nVf2iqn4MTAEXtsdUVT1TVb8E7mxjJUkLZNEgg9pP7w8Cb6X3U/yPgBer6nAbshdY1paXAXsAqupwkpeAN7f6zr7D9u+z56j6RcfoYx2wDmBiYoJut8uhQ4fodruDPI1fW3/u4ZkHDcnEKaP5/rN9jY6Yy+s7SvY7XPY7XKPsd6AwqKpfAeclWQx8E3j7ULs6dh8bgY0Ak5OT1el06Ha7dDqdWR3nug33DaG7waw/9zBfeHSgl31e7b6mM6f95vL6jpL9Dpf9Dtco+53V3URV9SLwXeBdwOIkR/5VWw7sa8v7gDMB2vY3AT/rrx+1z7HqkqQFMsjdRG9pZwQkOQV4H/AkvVD4UBu2FrinLW9p67Tt36mqavWr2t1GZwErge8BDwAr291JJ9O7yLxlPp6cJGkwg8xXLAU2t+sGvwfcVVX3JnkCuDPJZ4GHgNva+NuArySZAg7S+8edqno8yV3AE8Bh4IY2/USSjwHbgJOATVX1+Lw9Q0nSjGYMg6p6BHjnNPVn6N0JdHT9H4E/OcaxPgd8bpr6VmDrAP1KkobATyBLkgwDSZJhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJKEYSBJwjCQJGEYSJIwDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiSGCAMkpyZ5LtJnkjyeJKPt/rpSbYnebp9XdLqSXJLkqkkjyQ5v+9Ya9v4p5Os7atfkOTRts8tSTKMJytJmt4gZwaHgfVVdTawCrghydnABmBHVa0EdrR1gMuAle2xDrgVeuEB3AhcBFwI3HgkQNqYj/Ttt/r4n5okaVAzhkFV7a+q77fl/ws8CSwD1gCb27DNwBVteQ1wR/XsBBYnWQpcCmyvqoNV9QKwHVjdtp1WVTurqoA7+o4lSVoAs7pmkGQF8E7gfmCiqva3Tc8BE215GbCnb7e9rfZa9b3T1CVJC2TRoAOT/AHwd8Anqurl/mn9qqokNYT+ju5hHb2pJyYmJuh2uxw6dIhutzur46w/9/AQuhvMxCmj+f6zfY2OmMvrO0r2O1z2O1yj7HegMEjyOnpB8NWq+kYrP59kaVXtb1M9B1p9H3Bm3+7LW20f0Dmq3m315dOM/y1VtRHYCDA5OVmdTodut0un05lu+DFdt+G+WY2fT+vPPcwXHh04g+fN7ms6c9pvLq/vKNnvcNnvcI2y30HuJgpwG/BkVf1l36YtwJE7gtYC9/TVr213Fa0CXmrTSduAS5IsaReOLwG2tW0vJ1nVvte1fceSJC2AQX5EfTfwp8CjSR5utf8E3ATcleR64FngyrZtK3A5MAW8AnwYoKoOJvkM8EAb9+mqOtiWPwrcDpwCfKs9JEkLZMYwqKr/DRzrvv+LpxlfwA3HONYmYNM09V3AOTP1IkkaDj+BLEkyDCRJhoEkCcNAkoRhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJKEYSBJwjCQJGEYSJIwDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCQBi2YakGQT8AHgQFWd02qnA18HVgC7gSur6oUkAW4GLgdeAa6rqu+3fdYC/6Ud9rNVtbnVLwBuB04BtgIfr6qap+enZsWG++a03/pzD3PdHPcF2H3T++e8r6SFM8iZwe3A6qNqG4AdVbUS2NHWAS4DVrbHOuBW+HV43AhcBFwI3JhkSdvnVuAjffsd/b0kSUM2YxhU1f8CDh5VXgNsbsubgSv66ndUz05gcZKlwKXA9qo6WFUvANuB1W3baVW1s50N3NF3LEnSApnrNYOJqtrflp8DJtryMmBP37i9rfZa9b3T1CVJC2jGawYzqapKsiBz/EnW0Zt+YmJigm63y6FDh+h2u7M6zvpzDw+hu8FMnDLa7z9bx9vvbP9sjtdc3g+jZL/DZb+Dm2sYPJ9kaVXtb1M9B1p9H3Bm37jlrbYP6BxV77b68mnGT6uqNgIbASYnJ6vT6dDtdul0OsfaZVrHc0H0eK0/9zBfePS4M3jBHG+/u6/pzF8zA5jL+2GU7He47Hdwc50m2gKsbctrgXv66temZxXwUptO2gZckmRJu3B8CbCtbXs5yap2J9K1fceSJC2QQW4t/Rq9n+rPSLKX3l1BNwF3JbkeeBa4sg3fSu+20il6t5Z+GKCqDib5DPBAG/fpqjpyUfqjvHpr6bfaQ5K0gGYMg6q6+hibLp5mbAE3HOM4m4BN09R3AefM1IckaXj8BLIkyTCQJBkGkiQMA0kShoEkCcNAkoRhIEnCMJAkMQ+/qE56LXP9T3Xmqv8/4/E/1pEG55mBJMkwkCQZBpIkDANJEoaBJAnDQJKEYSBJwjCQJOGHzvTP2EJ/4O0IP+ymE5FnBpIkw0CSZBhIkvCagTTvZnOtov8X6x0vr1XoeIzNmUGS1UmeSjKVZMOo+5Gk3yVjEQZJTgK+BFwGnA1cneTs0XYlSb87xmWa6EJgqqqeAUhyJ7AGeGKkXUknkIW4lfZY01pOUZ34xiUMlgF7+tb3AheNqBdJs+RnOk58qapR90CSDwGrq+rftfU/BS6qqo8dNW4dsK6tvg14CjgD+OkCtnu87He47He47He4ht3vv6qqt0y3YVzODPYBZ/atL2+131BVG4GN/bUku6pqcrjtzR/7HS77HS77Ha5R9jsWF5CBB4CVSc5KcjJwFbBlxD1J0u+MsTgzqKrDST4GbANOAjZV1eMjbkuSfmeMRRgAVNVWYOscdt0485CxYr/DZb/DZb/DNbJ+x+ICsiRptMblmoEkaYROmDBIsinJgSSP9dVOT7I9ydPt65JR9tgvyZlJvpvkiSSPJ/l4q49lz0nekOR7SX7Q+v1Uq5+V5P72a0K+3i7wj40kJyV5KMm9bX3c+92d5NEkDyfZ1Wpj+Z4ASLI4yd1JfpjkySTvGtd+k7ytva5HHi8n+cS49guQ5D+2v2+PJfla+3s4kvfwCRMGwO3A6qNqG4AdVbUS2NHWx8VhYH1VnQ2sAm5ov2JjXHv+BfDeqnoHcB6wOskq4PPAF6vqrcALwPUj7HE6Hwee7Fsf934B/riqzuu7hXBc3xMANwPfrqq3A++g91qPZb9V9VR7Xc8DLgBeAb7JmPabZBnwH4DJqjqH3s0zVzGq93BVnTAPYAXwWN/6U8DStrwUeGrUPb5G7/cA7zsRegZ+H/g+vU+B/xRY1OrvAraNur++PpfT+8v9XuBeIOPcb+tpN3DGUbWxfE8AbwJ+TLu2OO79HtXjJcD/Ged+efU3L5xO72aee4FLR/UePpHODKYzUVX72/JzwMQomzmWJCuAdwL3M8Y9tymXh4EDwHbgR8CLVXW4DdlL7w08Lv4K+HPg/7X1NzPe/QIU8PdJHmyfqIfxfU+cBfwE+Js2FfflJKcyvv32uwr4Wlsey36rah/w34B/APYDLwEPMqL38IkeBr9WvRgdu1ujkvwB8HfAJ6rq5f5t49ZzVf2qeqfYy+n98sC3j7ilY0ryAeBAVT046l5m6T1VdT6939B7Q5I/6t84Zu+JRcD5wK1V9U7g5xw1xTJm/QLQ5tg/CPz3o7eNU7/t2sUaeqH7L4FT+e2p8AVzoofB80mWArSvB0bcz29I8jp6QfDVqvpGK491zwBV9SLwXXqnqIuTHPk8yrS/JmRE3g18MMlu4E56U0U3M779Ar/+aZCqOkBvPvtCxvc9sRfYW1X3t/W76YXDuPZ7xGXA96vq+bY+rv3+W+DHVfWTqvon4Bv03tcjeQ+f6GGwBVjbltfSm5cfC0kC3AY8WVV/2bdpLHtO8pYki9vyKfSubzxJLxQ+1IaNTb9V9cmqWl5VK+hNCXynqq5hTPsFSHJqkjceWaY3r/0YY/qeqKrngD1J3tZKF9P7tfJj2W+fq3l1igjGt99/AFYl+f3278WR13c07+FRX0SZxcWWr9GbV/snej+xXE9vjngH8DTwP4HTR91nX7/voXc6+gjwcHtcPq49A/8GeKj1+xjwX1v9XwPfA6bonXa/ftS9TtN7B7h33Pttvf2gPR4H/nOrj+V7ovV2HrCrvS/+B7BkzPs9FfgZ8Ka+2jj3+yngh+3v3FeA14/qPewnkCVJJ/w0kSRpHhgGkiTDQJJkGEiSMAwkSRgGkiQMA0kShoEkCfj/d/6B1W1BlUIAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "J9LwzKTf7xT_",
        "outputId": "8d3bc184-f572-486f-f6ca-a865fe5329b9",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 500
        }
      },
      "source": [
        "#utilizando o gráfico de Histograma para visulizar os dados de idade\n",
        "#só que agora customizando o intervalo para 20\n",
        "#e o tamanho da imagem para 10 por 8\n",
        "data['NU_IDADE'].hist(bins=20, figsize = (10,8))"
      ],
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f83a5b700b8>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAmIAAAHSCAYAAABPdKcOAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAan0lEQVR4nO3df6zldX3n8de7jLaUVvHX3rgMu0MjaUNlRZ0gTZtmKlsc1BT/sC7GrYOh5Y9iVjdsumP/IbV1Q5Ntbd20ZkmhYNOKrK0rKbSUoDfd/QMEqhWBGqYUZSYobUHsaGp32vf+cb6Dh8sM94Az93PP5fFIbuZ7Pud7zvneN/den37POfdWdwcAgI33XaMPAADguUqIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCDbRh/As/XSl760d+zYkST5xje+kZNOOmnsAW1yZrQYc1qfGS3GnNZnRosxp8Vs9jndddddf9fdL1u7vrQhtmPHjtx5551JktXV1ezatWvsAW1yZrQYc1qfGS3GnNZnRosxp8Vs9jlV1ZeOtO6pSQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYJBtow/guW7H3hs35HGu2X3ShjwOALA4Z8QAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGGShEKuqB6vq7qr6XFXdOa29uKpuqar7p39fNK1XVX2oqvZV1eer6jVz97Nn2v/+qtozt/7a6f73TbetY/2JAgBsNs/kjNhPdPdZ3b1zurw3ya3dfXqSW6fLSXJ+ktOnj0uSfDiZhVuSy5O8LsnZSS4/HG/TPj83d7vdz/ozAgBYEt/JU5MXJLl22r42yVvm1j/SM7clObmqXp7kDUlu6e5Hu/uxJLck2T1d94Luvq27O8lH5u4LAGDL2rbgfp3kz6qqk/zP7r4yyUp3Pzxd/5UkK9P2KUkemrvt/mnt6db3H2H9KarqkszOsmVlZSWrq6tJkoMHDz6xvWwuO/PQhjzOMs9oI5nT+sxoMea0PjNajDktZlnntGiI/Vh3H6iqf5Xklqr6q/kru7unSDuupgC8Mkl27tzZu3btSpKsrq7m8PayuWjvjRvyONfsPmlpZ7SRlvlraaOY0WLMaX1mtBhzWsyyzmmhpya7+8D07yNJPpHZa7y+Oj2tmOnfR6bdDyQ5de7m26e1p1vffoR1AIAtbd0Qq6qTqur7D28nOS/JF5LckOTwOx/3JPnktH1DkndO7548J8nj01OYNyc5r6peNL1I/7wkN0/Xfb2qzpneLfnOufsCANiyFnlqciXJJ6bfKLEtyR90959W1R1Jrq+qi5N8Kcnbpv1vSvLGJPuSfDPJu5Kkux+tql9Ocse03/u7+9Fp++eTXJPkxCR/Mn0AAGxp64ZYdz+Q5FVHWP/7JOceYb2TXHqU+7o6ydVHWL8zySsXOF4AgC3Db9YHABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYJCFQ6yqTqiqz1bVH0+XT6uq26tqX1V9rKqeP61/93R533T9jrn7eN+0/sWqesPc+u5pbV9V7T12nx4AwOb1TM6IvSfJfXOXfzXJB7v7FUkeS3LxtH5xksem9Q9O+6WqzkhyYZIfTrI7yW9PcXdCkt9Kcn6SM5K8fdoXAGBLWyjEqmp7kjcl+Z3pciV5fZKPT7tcm+Qt0/YF0+VM15877X9Bkuu6+1vd/TdJ9iU5e/rY190PdPc/Jblu2hcAYEtb9IzYbyT5hST/Ml1+SZKvdfeh6fL+JKdM26ckeShJpusfn/Z/Yn3NbY62DgCwpW1bb4eqenOSR7r7rqradfwP6WmP5ZIklyTJyspKVldXkyQHDx58YnvZXHbmofV3OgaWeUYbyZzWZ0aLMaf1mdFizGkxyzqndUMsyY8m+amqemOS70nygiS/meTkqto2nfXanuTAtP+BJKcm2V9V25K8MMnfz60fNn+bo60/SXdfmeTKJNm5c2fv2rUrSbK6uprD28vmor03bsjjXLP7pKWd0UZa5q+ljWJGizGn9ZnRYsxpMcs6p3Wfmuzu93X39u7ekdmL7T/V3e9I8ukkb51225Pkk9P2DdPlTNd/qrt7Wr9welflaUlOT/KZJHckOX16F+bzp8e44Zh8dgAAm9giZ8SO5r8mua6qfiXJZ5NcNa1fleT3qmpfkkczC6t09z1VdX2Se5McSnJpd/9zklTVu5PcnOSEJFd39z3fwXEBACyFZxRi3b2aZHXafiCzdzyu3ecfk/z0UW7/gSQfOML6TUlueibHAgCw7PxmfQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQYQYAMAgQgwAYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIOsG2JV9T1V9Zmq+suquqeqfmlaP62qbq+qfVX1sap6/rT+3dPlfdP1O+bu633T+her6g1z67untX1VtffYf5oAAJvPImfEvpXk9d39qiRnJdldVeck+dUkH+zuVyR5LMnF0/4XJ3lsWv/gtF+q6owkFyb54SS7k/x2VZ1QVSck+a0k5yc5I8nbp30BALa0dUOsZw5OF583fXSS1yf5+LR+bZK3TNsXTJczXX9uVdW0fl13f6u7/ybJviRnTx/7uvuB7v6nJNdN+wIAbGnbFtlpOmt1V5JXZHb26q+TfK27D0277E9yyrR9SpKHkqS7D1XV40leMq3fNne387d5aM36645yHJckuSRJVlZWsrq6miQ5ePDgE9vL5rIzD62/0zGwzDPaSOa0PjNajDmtz4wWY06LWdY5LRRi3f3PSc6qqpOTfCLJDx3Xozr6cVyZ5Mok2blzZ+/atStJsrq6msPby+aivTduyONcs/ukpZ3RRlrmr6WNYkaLMaf1mdFizGkxyzqnZ/Suye7+WpJPJ/mRJCdX1eGQ257kwLR9IMmpSTJd/8Ikfz+/vuY2R1sHANjSFnnX5MumM2GpqhOT/GSS+zILsrdOu+1J8slp+4bpcqbrP9XdPa1fOL2r8rQkpyf5TJI7kpw+vQvz+Zm9oP+GY/HJAQBsZos8NfnyJNdOrxP7riTXd/cfV9W9Sa6rql9J8tkkV037X5Xk96pqX5JHMwurdPc9VXV9knuTHEpy6fSUZ6rq3UluTnJCkqu7+55j9hkCAGxS64ZYd38+yauPsP5AZu94XLv+j0l++ij39YEkHzjC+k1JblrgeAEAtgy/WR8AYBAhBgAwiBADABhEiAEADCLEAAAGEWIAAIMIMQCAQRb6W5Msv7sPPH7c/67lg1e86bjePwBsNc6IAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADDIuiFWVadW1aer6t6quqeq3jOtv7iqbqmq+6d/XzStV1V9qKr2VdXnq+o1c/e1Z9r//qraM7f+2qq6e7rNh6qqjscnCwCwmSxyRuxQksu6+4wk5yS5tKrOSLI3ya3dfXqSW6fLSXJ+ktOnj0uSfDiZhVuSy5O8LsnZSS4/HG/TPj83d7vd3/mnBgCwua0bYt39cHf/xbT9D0nuS3JKkguSXDvtdm2St0zbFyT5SM/cluTkqnp5kjckuaW7H+3ux5LckmT3dN0Luvu27u4kH5m7LwCALesZvUasqnYkeXWS25OsdPfD01VfSbIybZ+S5KG5m+2f1p5uff8R1gEAtrRti+5YVd+X5A+TvLe7vz7/Mq7u7qrq43B8a4/hksye7szKykpWV1eTJAcPHnxie9lcduahDXmclROP/2Mt63+Decv8tbRRzGgx5rQ+M1qMOS1mWee0UIhV1fMyi7Df7+4/mpa/WlUv7+6Hp6cXH5nWDyQ5de7m26e1A0l2rVlfnda3H2H/p+juK5NcmSQ7d+7sXbtmd7e6uprD28vmor03bsjjXHbmofza3Qt397Py4Dt2Hdf73wjL/LW0UcxoMea0PjNajDktZlnntMi7JivJVUnu6+5fn7vqhiSH3/m4J8kn59bfOb178pwkj09PYd6c5LyqetH0Iv3zktw8Xff1qjpneqx3zt0XAMCWtcgpkh9N8jNJ7q6qz01rv5jkiiTXV9XFSb6U5G3TdTcleWOSfUm+meRdSdLdj1bVLye5Y9rv/d396LT980muSXJikj+ZPgAAtrR1Q6y7/2+So/1er3OPsH8nufQo93V1kquPsH5nkleudywAAFuJ36wPADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgkHVDrKqurqpHquoLc2svrqpbqur+6d8XTetVVR+qqn1V9fmqes3cbfZM+99fVXvm1l9bVXdPt/lQVdWx/iQBADajRc6IXZNk95q1vUlu7e7Tk9w6XU6S85OcPn1ckuTDySzcklye5HVJzk5y+eF4m/b5ubnbrX0sAIAtad0Q6+4/T/LomuULklw7bV+b5C1z6x/pmduSnFxVL0/yhiS3dPej3f1YkluS7J6ue0F339bdneQjc/cFALClbXuWt1vp7oen7a8kWZm2T0ny0Nx++6e1p1vff4T1I6qqSzI705aVlZWsrq4mSQ4ePPjE9rF094HHj/l9rnXZmcf9IZIkKycml5156Lg+xvH4b7DRjtfX0lZiRosxp/WZ0WLMaTHLOqdnG2JP6O6uqj4WB7PAY12Z5Mok2blzZ+/atSvJLAAObx9LF+298Zjf5yiXnXkov3b3d/yf+2k9+I5dx/X+N8Lx+lraSsxoMea0PjNajDktZlnn9GzfNfnV6WnFTP8+Mq0fSHLq3H7bp7WnW99+hHUAgC3v2Z4iuSHJniRXTP9+cm793VV1XWYvzH+8ux+uqpuT/Le5F+ifl+R93f1oVX29qs5JcnuSdyb5H8/ymBhsxwacQXzwijcd98cAgI2ybohV1UeT7Ery0qran9m7H69Icn1VXZzkS0neNu1+U5I3JtmX5JtJ3pUkU3D9cpI7pv3e392H3wDw85m9M/PEJH8yfQAAbHnrhlh3v/0oV517hH07yaVHuZ+rk1x9hPU7k7xyveMAANhq/GZ9AIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGGTb6AOAZ2LH3huP6/1fduahXLT3xjx4xZuO6+MAQOKMGADAMEIMAGAQIQYAMIgQAwAYRIgBAAwixAAABhFiAACDCDEAgEGEGADAIEIMAGAQIQYAMIgQAwAYRIgBAAwixAAABhFiAACDCDEAgEGEGADAIEIMAGAQIQYAMIgQAwAYRIgBAAwixAAABhFiAACDCDEAgEG2jT4A2Ix27L3xuD/Gg1e86bg/BgCbmzNiAACDOCMGgzjrBoAzYgAAgwgxAIBBhBgAwCBCDABgECEGADCIEAMAGESIAQAMIsQAAAYRYgAAgwgxAIBB/Ikj2MKOx59RuuzMQ7lozf36U0oAz44zYgAAgzgjBnzH/AFzgGfHGTEAgEGEGADAIEIMAGAQIQYAMIgQAwAYxLsmgaWwEe/MTLw7E9hYzogBAAzijBjAnGN15u1If4HgMGfdgMOEGMAG8wtwgcM2zVOTVbW7qr5YVfuqau/o4wEAON42xRmxqjohyW8l+ckk+5PcUVU3dPe9Y48MYDl5cwMsh00RYknOTrKvux9Ikqq6LskFSYQYwCb2nQTf072Obp7YYyvbLCF2SpKH5i7vT/K6QccCwCayUWf3NoKoZK3q7tHHkKp6a5Ld3f2z0+WfSfK67n73mv0uSXLJdPEHk3xx2n5pkr/boMNdVma0GHNanxktxpzWZ0aLMafFbPY5/dvuftnaxc1yRuxAklPnLm+f1p6ku69McuXa9aq6s7t3Hr/DW35mtBhzWp8ZLcac1mdGizGnxSzrnDbLuybvSHJ6VZ1WVc9PcmGSGwYfEwDAcbUpzoh196GqeneSm5OckOTq7r5n8GEBABxXmyLEkqS7b0py07O8+VOeruQpzGgx5rQ+M1qMOa3PjBZjTotZyjltihfrAwA8F22W14gBADznLF2IVdXVVfVIVX1hbu3FVXVLVd0//fuikcc4WlWdWlWfrqp7q+qeqnrPtG5Ok6r6nqr6TFX95TSjX5rWT6uq26c/tfWx6c0jz3lVdUJVfbaq/ni6bE5zqurBqrq7qj5XVXdOa77f1qiqk6vq41X1V1V1X1X9iDl9W1X94PQ1dPjj61X1XjN6qqr6z9PP7i9U1Uenn+lL+XNp6UIsyTVJdq9Z25vk1u4+Pcmt0+XnskNJLuvuM5Kck+TSqjoj5jTvW0le392vSnJWkt1VdU6SX03ywe5+RZLHklw88Bg3k/ckuW/usjk91U9091lzb5/3/fZUv5nkT7v7h5K8KrOvKXOadPcXp6+hs5K8Nsk3k3wiZvQkVXVKkv+UZGd3vzKzN/ldmCX9ubR0Idbdf57k0TXLFyS5dtq+NslbNvSgNpnufri7/2La/ofMftidEnN6Qs8cnC4+b/roJK9P8vFp/Tk9o8OqanuSNyX5nelyxZwW4fttTlW9MMmPJ7kqSbr7n7r7azGnozk3yV9395diRkeyLcmJVbUtyfcmeThL+nNp6ULsKFa6++Fp+ytJVkYezGZSVTuSvDrJ7TGnJ5mebvtckkeS3JLkr5N8rbsPTbvszyxgn+t+I8kvJPmX6fJLYk5rdZI/q6q7pr8Akvh+W+u0JH+b5Henp7l/p6pOijkdzYVJPjptm9Gc7j6Q5L8n+XJmAfZ4kruypD+XtkqIPaFnbwP1VtAkVfV9Sf4wyXu7++vz15lT0t3/PD0FsD2zPzz/Q4MPadOpqjcneaS77xp9LJvcj3X3a5Kcn9lLAX58/krfb0lmZzBek+TD3f3qJN/ImqfYzGlmem3TTyX5X2uvM6Nkeo3cBZnF/b9OclKe+pKlpbFVQuyrVfXyJJn+fWTw8QxXVc/LLMJ+v7v/aFo2pyOYnh75dJIfSXLydKo7Ocqf2nqO+dEkP1VVDya5LrNT/78Zc3qS6f+hp7sfyew1PWfH99ta+5Ps7+7bp8sfzyzMzOmpzk/yF9391emyGT3Zv0/yN939t939/5L8UWY/q5by59JWCbEbkuyZtvck+eTAYxlueg3PVUnu6+5fn7vKnCZV9bKqOnnaPjHJT2b2WrpPJ3nrtNtzekZJ0t3v6+7t3b0js6dKPtXd74g5PaGqTqqq7z+8neS8JF+I77cn6e6vJHmoqn5wWjo3yb0xpyN5e779tGRiRmt9Ock5VfW90//eHf5aWsqfS0v3C12r6qNJdmX2V9a/muTyJP87yfVJ/k2SLyV5W3evfUH/c0ZV/ViS/5Pk7nz7dT2/mNnrxMwpSVX9u8xezHlCZv+H5Prufn9V/UBmZ35enOSzSf5jd39r3JFuHlW1K8l/6e43m9O3TbP4xHRxW5I/6O4PVNVL4vvtSarqrMze9PH8JA8keVem77+YU5InYv7LSX6gux+f1nwtrTH9yqH/kNlvCfhskp/N7DVhS/dzaelCDABgq9gqT00CACwdIQYAMIgQAwAYRIgBAAwixAAABhFiAACDCDEAgEGEGADAIP8fS0VwWQdpBXQAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 720x576 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "RigaQmL4-syy",
        "outputId": "2b53adaf-97e1-4d2c-9276-5c53efb70207",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 444
        }
      },
      "source": [
        "#Treineiro: são as pessoas que participam do processo\n",
        "#mas sua nota não é contabilizada para notas\n",
        "#das faculdades. Neste caso,estamos selecionando \n",
        "#somente os treineiros\n",
        "\n",
        "#Retonar um Dataframe\n",
        "data.query('IN_TREINEIRO == 1')\n",
        "\n",
        "#Para conferencia dos dados\n",
        "#Retorna uma Serie\n",
        "#data.query('IN_TREINEIRO == 1')['IN_TREINEIRO']"
      ],
      "execution_count": 12,
      "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>NU_INSCRICAO</th>\n",
              "      <th>NU_ANO</th>\n",
              "      <th>CO_MUNICIPIO_RESIDENCIA</th>\n",
              "      <th>NO_MUNICIPIO_RESIDENCIA</th>\n",
              "      <th>CO_UF_RESIDENCIA</th>\n",
              "      <th>SG_UF_RESIDENCIA</th>\n",
              "      <th>NU_IDADE</th>\n",
              "      <th>TP_SEXO</th>\n",
              "      <th>TP_ESTADO_CIVIL</th>\n",
              "      <th>TP_COR_RACA</th>\n",
              "      <th>TP_NACIONALIDADE</th>\n",
              "      <th>CO_MUNICIPIO_NASCIMENTO</th>\n",
              "      <th>NO_MUNICIPIO_NASCIMENTO</th>\n",
              "      <th>CO_UF_NASCIMENTO</th>\n",
              "      <th>SG_UF_NASCIMENTO</th>\n",
              "      <th>TP_ST_CONCLUSAO</th>\n",
              "      <th>TP_ANO_CONCLUIU</th>\n",
              "      <th>TP_ESCOLA</th>\n",
              "      <th>TP_ENSINO</th>\n",
              "      <th>IN_TREINEIRO</th>\n",
              "      <th>CO_ESCOLA</th>\n",
              "      <th>CO_MUNICIPIO_ESC</th>\n",
              "      <th>NO_MUNICIPIO_ESC</th>\n",
              "      <th>CO_UF_ESC</th>\n",
              "      <th>SG_UF_ESC</th>\n",
              "      <th>TP_DEPENDENCIA_ADM_ESC</th>\n",
              "      <th>TP_LOCALIZACAO_ESC</th>\n",
              "      <th>TP_SIT_FUNC_ESC</th>\n",
              "      <th>IN_BAIXA_VISAO</th>\n",
              "      <th>IN_CEGUEIRA</th>\n",
              "      <th>IN_SURDEZ</th>\n",
              "      <th>IN_DEFICIENCIA_AUDITIVA</th>\n",
              "      <th>IN_SURDO_CEGUEIRA</th>\n",
              "      <th>IN_DEFICIENCIA_FISICA</th>\n",
              "      <th>IN_DEFICIENCIA_MENTAL</th>\n",
              "      <th>IN_DEFICIT_ATENCAO</th>\n",
              "      <th>IN_DISLEXIA</th>\n",
              "      <th>IN_DISCALCULIA</th>\n",
              "      <th>IN_AUTISMO</th>\n",
              "      <th>IN_VISAO_MONOCULAR</th>\n",
              "      <th>...</th>\n",
              "      <th>TX_RESPOSTAS_CH</th>\n",
              "      <th>TX_RESPOSTAS_LC</th>\n",
              "      <th>TX_RESPOSTAS_MT</th>\n",
              "      <th>TP_LINGUA</th>\n",
              "      <th>TX_GABARITO_CN</th>\n",
              "      <th>TX_GABARITO_CH</th>\n",
              "      <th>TX_GABARITO_LC</th>\n",
              "      <th>TX_GABARITO_MT</th>\n",
              "      <th>TP_STATUS_REDACAO</th>\n",
              "      <th>NU_NOTA_COMP1</th>\n",
              "      <th>NU_NOTA_COMP2</th>\n",
              "      <th>NU_NOTA_COMP3</th>\n",
              "      <th>NU_NOTA_COMP4</th>\n",
              "      <th>NU_NOTA_COMP5</th>\n",
              "      <th>NU_NOTA_REDACAO</th>\n",
              "      <th>Q001</th>\n",
              "      <th>Q002</th>\n",
              "      <th>Q003</th>\n",
              "      <th>Q004</th>\n",
              "      <th>Q005</th>\n",
              "      <th>Q006</th>\n",
              "      <th>Q007</th>\n",
              "      <th>Q008</th>\n",
              "      <th>Q009</th>\n",
              "      <th>Q010</th>\n",
              "      <th>Q011</th>\n",
              "      <th>Q012</th>\n",
              "      <th>Q013</th>\n",
              "      <th>Q014</th>\n",
              "      <th>Q015</th>\n",
              "      <th>Q016</th>\n",
              "      <th>Q017</th>\n",
              "      <th>Q018</th>\n",
              "      <th>Q019</th>\n",
              "      <th>Q020</th>\n",
              "      <th>Q021</th>\n",
              "      <th>Q022</th>\n",
              "      <th>Q023</th>\n",
              "      <th>Q024</th>\n",
              "      <th>Q025</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>190001004661</td>\n",
              "      <td>2019</td>\n",
              "      <td>1506138</td>\n",
              "      <td>Redenção</td>\n",
              "      <td>15</td>\n",
              "      <td>PA</td>\n",
              "      <td>17</td>\n",
              "      <td>M</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>1506138.0</td>\n",
              "      <td>Redenção</td>\n",
              "      <td>15.0</td>\n",
              "      <td>PA</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>ACAEAAACABEBABAADCEEEDE*CBDCCCADADCCCBEBBBBDB</td>\n",
              "      <td>99999CCCABBCAADDBCEBCCADBEEBDECBAABDEACACAEABB...</td>\n",
              "      <td>DEEDCAECDDEEECBCBECABEBAECBBCDAECAEBBBBBDCCDB</td>\n",
              "      <td>1</td>\n",
              "      <td>DEADBAAAEBEECEBCBCBCBDADAEABCEDDDDADCBEECACBC</td>\n",
              "      <td>ACACEEBCCBABADBBBACDBBACCCCADCEBADCBEEDBBEADB</td>\n",
              "      <td>EBBADCABDABACBCEBDEEAAADDBECDECDDBADBCDAAECBCC...</td>\n",
              "      <td>AADDDBEEEBEDDBEBACABCDBABECECACAECDCBDCCEDCDA</td>\n",
              "      <td>1.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>420.0</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>4</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>190001004776</td>\n",
              "      <td>2019</td>\n",
              "      <td>1500800</td>\n",
              "      <td>Ananindeua</td>\n",
              "      <td>15</td>\n",
              "      <td>PA</td>\n",
              "      <td>16</td>\n",
              "      <td>F</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>1500800.0</td>\n",
              "      <td>Ananindeua</td>\n",
              "      <td>15.0</td>\n",
              "      <td>PA</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>CCBCBEACABACABBBBACCBCEBDCBABCADADCBCADBAADEA</td>\n",
              "      <td>EBCAB99999BBCECBCACBEACBDAABDBCBBDACEBBACDCAEC...</td>\n",
              "      <td>AECCBBCBBCBDEDECACBAABEDABBEDDADCEADDBEBDBBEB</td>\n",
              "      <td>0</td>\n",
              "      <td>DEADBAAAEBEECEBCBCBCBDADAEABCEDDDDADCBEECACBC</td>\n",
              "      <td>ACACEEBCCBABADBBBACDBBACCCCADCEBADCBEEDBBEADB</td>\n",
              "      <td>EBBADCABDABACBCEBDEEAAADDBECDECDDBADBCDAAECBCC...</td>\n",
              "      <td>AADDDBEEEBEDDBEBACABCDBABECECACAECDCBDCCEDCDA</td>\n",
              "      <td>1.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>140.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>780.0</td>\n",
              "      <td>E</td>\n",
              "      <td>E</td>\n",
              "      <td>B</td>\n",
              "      <td>D</td>\n",
              "      <td>3</td>\n",
              "      <td>E</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>D</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>190001005076</td>\n",
              "      <td>2019</td>\n",
              "      <td>1506138</td>\n",
              "      <td>Redenção</td>\n",
              "      <td>15</td>\n",
              "      <td>PA</td>\n",
              "      <td>15</td>\n",
              "      <td>M</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>1506138.0</td>\n",
              "      <td>Redenção</td>\n",
              "      <td>15.0</td>\n",
              "      <td>PA</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>AADCCEDCCDBEABAECBABCEEACDEBDBBDBACBBEEDCADCB</td>\n",
              "      <td>AECBA99999ACDBECAACEAADBEAAAECDAECDEBAAEBCECEA...</td>\n",
              "      <td>DAADCAABECBBCBDADDEEEBCCAABADBBBECAACBDBDDCBC</td>\n",
              "      <td>0</td>\n",
              "      <td>BEEAAEBEEBADEADDADAEABCEDDDBCBCBCCACBCDADCCEB</td>\n",
              "      <td>EEBCEEDBADBBCBABCCADCEBACDBBACCACACBEADBBADCB</td>\n",
              "      <td>ADBBEDCABAABBCBCDAAECDDDBAAAECADECDCEBDEEAECBD...</td>\n",
              "      <td>BEDEEEAADBEBACABCDBABECECACADCBDCCEDCDABECDDD</td>\n",
              "      <td>1.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>180.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>140.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>720.0</td>\n",
              "      <td>C</td>\n",
              "      <td>E</td>\n",
              "      <td>D</td>\n",
              "      <td>D</td>\n",
              "      <td>4</td>\n",
              "      <td>F</td>\n",
              "      <td>A</td>\n",
              "      <td>C</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>190001005081</td>\n",
              "      <td>2019</td>\n",
              "      <td>1506807</td>\n",
              "      <td>Santarém</td>\n",
              "      <td>15</td>\n",
              "      <td>PA</td>\n",
              "      <td>17</td>\n",
              "      <td>F</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>AABCDEBCEBCADAAAAEEEBCEEBDECDBACBEDEAABAACDBA</td>\n",
              "      <td>99999ADABAADAEABBAACDAABCDE*DABBABDAAEDAAAACBE...</td>\n",
              "      <td>AAAEDBCCEACBDDCBEAEBBCAAAABCCBABDCAAECCABCBDE</td>\n",
              "      <td>1</td>\n",
              "      <td>AAECACDEADCBCDDDBCBDADAEABCEBABEEBCBEECEBDADC</td>\n",
              "      <td>ACACEEBCCBABADBBBACDBBACCCCADCEBADCBEEDBBEADB</td>\n",
              "      <td>EBBADCABDABACBCEBDEEAAADDBECDECDDBADBCDAAECBCC...</td>\n",
              "      <td>EEEADBEBACABCDBABECECACDCBDCCEDCDABEDECDDDBAA</td>\n",
              "      <td>1.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>20.0</td>\n",
              "      <td>400.0</td>\n",
              "      <td>D</td>\n",
              "      <td>E</td>\n",
              "      <td>F</td>\n",
              "      <td>F</td>\n",
              "      <td>4</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>D</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>190001005202</td>\n",
              "      <td>2019</td>\n",
              "      <td>1502301</td>\n",
              "      <td>Capitão Poço</td>\n",
              "      <td>15</td>\n",
              "      <td>PA</td>\n",
              "      <td>17</td>\n",
              "      <td>F</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>EEEAABAADADCBCEDBCCACEEDBCBCBADBBAABDBBABCEAB</td>\n",
              "      <td>99999ECABECCBABCDAEADABEBEEBEEEEEDBDDBAACDAEAA...</td>\n",
              "      <td>ACBEDECCABCEDDEDCEDAACBCAADEEDCDEECBABEBAEC*B</td>\n",
              "      <td>1</td>\n",
              "      <td>AAECACDEADCBCDDDBCBDADAEABCEBABEEBCBEECEBDADC</td>\n",
              "      <td>BACCCBABBADCBCEEEBCACACEEDBCCADBEADBADBBBACDB</td>\n",
              "      <td>BDABEABCADBCBAADDBECDAAECDAECBECBCCDEEAAADDBBC...</td>\n",
              "      <td>EEEADBEBACABCDBABECECACDCBDCCEDCDABEDECDDDBAA</td>\n",
              "      <td>1.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>580.0</td>\n",
              "      <td>D</td>\n",
              "      <td>E</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>3</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127328</th>\n",
              "      <td>190006117441</td>\n",
              "      <td>2019</td>\n",
              "      <td>3126752</td>\n",
              "      <td>Franciscópolis</td>\n",
              "      <td>31</td>\n",
              "      <td>MG</td>\n",
              "      <td>16</td>\n",
              "      <td>M</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>3126752.0</td>\n",
              "      <td>Franciscópolis</td>\n",
              "      <td>31.0</td>\n",
              "      <td>MG</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>EBCCABEAEAABACBEBBBBDCABABECDCACBDACCCBEEBCDE</td>\n",
              "      <td>DDADD99999DAABCDAECECBBBDDABBDECCBBACDDEABCCCE...</td>\n",
              "      <td>DCCBABCBCBDCCDAEACAADCCCDECBECBCA*BBCBCEBEBAB</td>\n",
              "      <td>0</td>\n",
              "      <td>DADCCEBBCCACBEEBEEBACBCDDDDADBCBBCEAEADEADAAE</td>\n",
              "      <td>CBABADBBCEEEBCBADCBEEDBBEADBBACDBBACCCCADACAC</td>\n",
              "      <td>BBEDABDACACBABAECBBCCADCEBDBBCDDEEAAADDBECDECA...</td>\n",
              "      <td>DBEBACABCDBABECEEEDCBDCCEDCDABEDAADDDECACAECB</td>\n",
              "      <td>1.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>140.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>340.0</td>\n",
              "      <td>B</td>\n",
              "      <td>C</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>6</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>D</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127340</th>\n",
              "      <td>190006117776</td>\n",
              "      <td>2019</td>\n",
              "      <td>4305108</td>\n",
              "      <td>Caxias do Sul</td>\n",
              "      <td>43</td>\n",
              "      <td>RS</td>\n",
              "      <td>17</td>\n",
              "      <td>F</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>4305108.0</td>\n",
              "      <td>Caxias do Sul</td>\n",
              "      <td>43.0</td>\n",
              "      <td>RS</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>CABBABABABDCDBEEEBCACABEEADCCEECAACBADEAEDCCE</td>\n",
              "      <td>BDABE99999CCBABDACDCDAEECBEEACDABACDEBAAADDAAB...</td>\n",
              "      <td>ECAAECEBAECABDEACEABBAEEBAAEBCBCEBABAECBDCCAB</td>\n",
              "      <td>0</td>\n",
              "      <td>AAECACDEADCBCDDDBCBDADAEABCEBABEEBCBEECEBDADC</td>\n",
              "      <td>BACCCBABBADCBCEEEBCACACEEDBCCADBEADBADBBBACDB</td>\n",
              "      <td>BDABEABCADBCBAADDBECDAAECDAECBECBCCDEEAAADDBBC...</td>\n",
              "      <td>EEEADBEBACABCDBABECECACDCBDCCEDCDABEDECDDDBAA</td>\n",
              "      <td>1.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>140.0</td>\n",
              "      <td>140.0</td>\n",
              "      <td>720.0</td>\n",
              "      <td>E</td>\n",
              "      <td>G</td>\n",
              "      <td>D</td>\n",
              "      <td>E</td>\n",
              "      <td>2</td>\n",
              "      <td>H</td>\n",
              "      <td>A</td>\n",
              "      <td>C</td>\n",
              "      <td>D</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127349</th>\n",
              "      <td>190006118483</td>\n",
              "      <td>2019</td>\n",
              "      <td>2511301</td>\n",
              "      <td>Piancó</td>\n",
              "      <td>25</td>\n",
              "      <td>PB</td>\n",
              "      <td>15</td>\n",
              "      <td>F</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2511301.0</td>\n",
              "      <td>Piancó</td>\n",
              "      <td>25.0</td>\n",
              "      <td>PB</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>AACEBDCBCBECACEBEABDCADBACBBECAEABCCCAEDBBDCE</td>\n",
              "      <td>99999AEACBAABCEECBCECBDABAAADCBEBCDCDECBAEEDEB...</td>\n",
              "      <td>DACEAEABDEACAECCBCCBCDDCABEEBABBCDABBADCDAEAE</td>\n",
              "      <td>1</td>\n",
              "      <td>BEEAAEBEEBADEADDADAEABCEDDDBCBCBCCACBCDADCCEB</td>\n",
              "      <td>EEBCEEDBADBBCBABCCADCEBACDBBACCACACBEADBBADCB</td>\n",
              "      <td>ADBBEDCABAABBCBCDAAECDDDBAAAECADECDCEBDEEAECBD...</td>\n",
              "      <td>BEDEEEAADBEBACABCDBABECECACADCBDCCEDCDABECDDD</td>\n",
              "      <td>1.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>140.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>540.0</td>\n",
              "      <td>C</td>\n",
              "      <td>E</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>3</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127350</th>\n",
              "      <td>190006118551</td>\n",
              "      <td>2019</td>\n",
              "      <td>2611606</td>\n",
              "      <td>Recife</td>\n",
              "      <td>26</td>\n",
              "      <td>PE</td>\n",
              "      <td>16</td>\n",
              "      <td>M</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>4113700.0</td>\n",
              "      <td>Londrina</td>\n",
              "      <td>41.0</td>\n",
              "      <td>PR</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>EEACCADBADBEABAECCDDCEEACDBBAECCCBCBDECBDBDCD</td>\n",
              "      <td>ADBBE99999BDECBCCDAEDCDDDAAAECBEECDCBBDEADEEBD...</td>\n",
              "      <td>DEEBBECBCDEACECEEEECBDCCEDCECBEDAADDDEDAEAECD</td>\n",
              "      <td>0</td>\n",
              "      <td>DADCCEBBCCACBEEBEEBACBCDDDDADBCBBCEAEADEADAAE</td>\n",
              "      <td>EEBCEEDBADBBCBABCCADCEBACDBBACCACACBEADBBADCB</td>\n",
              "      <td>ADBBEDCABAABBCBCDAAECDDDBAAAECADECDCEBDEEAECBD...</td>\n",
              "      <td>DBEBACABCDBABECEEEDCBDCCEDCDABEDAADDDECACAECB</td>\n",
              "      <td>1.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>180.0</td>\n",
              "      <td>180.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>840.0</td>\n",
              "      <td>G</td>\n",
              "      <td>G</td>\n",
              "      <td>D</td>\n",
              "      <td>D</td>\n",
              "      <td>4</td>\n",
              "      <td>H</td>\n",
              "      <td>D</td>\n",
              "      <td>E</td>\n",
              "      <td>D</td>\n",
              "      <td>D</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>E</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>E</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127352</th>\n",
              "      <td>190006118561</td>\n",
              "      <td>2019</td>\n",
              "      <td>2600807</td>\n",
              "      <td>Altinho</td>\n",
              "      <td>26</td>\n",
              "      <td>PE</td>\n",
              "      <td>18</td>\n",
              "      <td>M</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>2611606.0</td>\n",
              "      <td>Recife</td>\n",
              "      <td>26.0</td>\n",
              "      <td>PE</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>CDBBBABBDBBCDCAECADBABBDACBEACCABDCDCDCDBACDD</td>\n",
              "      <td>CEDBC99999CEDBCEDDECDDCCBAEEBCBBEACBDADABCADEA...</td>\n",
              "      <td>CEDCBBDEBDEDCACCCDECCACDBECDCABAEDBAABDDDEDEE</td>\n",
              "      <td>0</td>\n",
              "      <td>DADCCEBBCCACBEEBEEBACBCDDDDADBCBBCEAEADEADAAE</td>\n",
              "      <td>BACCCBABBADCBCEEEBCACACEEDBCCADBEADBADBBBACDB</td>\n",
              "      <td>BDABEABCADBCBAADDBECDAAECDAECBECBCCDEEAAADDBBC...</td>\n",
              "      <td>DBEBACABCDBABECEEEDCBDCCEDCDABEDAADDDECACAECB</td>\n",
              "      <td>1.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>260.0</td>\n",
              "      <td>E</td>\n",
              "      <td>D</td>\n",
              "      <td>C</td>\n",
              "      <td>C</td>\n",
              "      <td>3</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>C</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "      <td>A</td>\n",
              "      <td>A</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>15401 rows × 136 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        NU_INSCRICAO  NU_ANO  CO_MUNICIPIO_RESIDENCIA  ... Q023  Q024 Q025\n",
              "0       190001004661    2019                  1506138  ...    A     B    B\n",
              "4       190001004776    2019                  1500800  ...    A     A    B\n",
              "12      190001005076    2019                  1506138  ...    A     A    B\n",
              "14      190001005081    2019                  1506807  ...    A     A    B\n",
              "16      190001005202    2019                  1502301  ...    A     A    A\n",
              "...              ...     ...                      ...  ...  ...   ...  ...\n",
              "127328  190006117441    2019                  3126752  ...    A     A    B\n",
              "127340  190006117776    2019                  4305108  ...    A     C    B\n",
              "127349  190006118483    2019                  2511301  ...    A     A    A\n",
              "127350  190006118551    2019                  2611606  ...    B     B    B\n",
              "127352  190006118561    2019                  2600807  ...    A     A    B\n",
              "\n",
              "[15401 rows x 136 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "5RPHjNwMBCxU",
        "outputId": "fed9a2ef-8b82-4a68-9151-71fed8331675",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 677
        }
      },
      "source": [
        "#Treineiros por idade\n",
        "#Retorna uma Serie\n",
        "data.query('IN_TREINEIRO == 1')['NU_IDADE'].value_counts().sort_index"
      ],
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<bound method Series.sort_index of 16    7142\n",
              "17    4901\n",
              "15    1927\n",
              "18     858\n",
              "19     228\n",
              "20      83\n",
              "14      64\n",
              "21      44\n",
              "22      30\n",
              "23      21\n",
              "24      13\n",
              "26      13\n",
              "29      10\n",
              "27       9\n",
              "25       8\n",
              "28       6\n",
              "38       4\n",
              "40       4\n",
              "31       4\n",
              "30       4\n",
              "42       4\n",
              "34       3\n",
              "36       2\n",
              "39       2\n",
              "32       2\n",
              "46       2\n",
              "44       2\n",
              "35       2\n",
              "45       1\n",
              "41       1\n",
              "33       1\n",
              "62       1\n",
              "48       1\n",
              "51       1\n",
              "37       1\n",
              "47       1\n",
              "55       1\n",
              "Name: NU_IDADE, dtype: int64>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pZUPw_OnCV25",
        "outputId": "4990ee43-2860-49fa-dc67-4fdf153baf6c",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 391
        }
      },
      "source": [
        "#Histograma por nota de Redação\n",
        "data['NU_NOTA_REDACAO'].hist(bins = 20, figsize = (8,6))"
      ],
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f83a540a080>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 14
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAfMAAAFlCAYAAAD/MAEVAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAcfUlEQVR4nO3df4xd5X3n8fd37UIcssEmdGeztrV2Nm4qB2+2ZBZcZbeaQGUMRDF/0AjEFpN6a2lL0rTrVWJaraxNgkR2Q2lIE1be4GIihKFutrYCDeslXKGVys8kxfwIZQIO2II4iY3TSZrQSb77x32cXMyMZ3zP8cw83PdLupp7vuc5zzz3mTPzuefcM/dGZiJJkur1T2Z7AJIkqRnDXJKkyhnmkiRVzjCXJKlyhrkkSZUzzCVJqtz82R5Av84888xctmxZa/398Ic/5LTTTmutv0HkHDbnHDbnHLbDeWyu7Tl89NFHv5eZvzzRumrDfNmyZTzyyCOt9dfpdBgZGWmtv0HkHDbnHDbnHLbDeWyu7TmMiG9Pts7T7JIkVc4wlySpcoa5JEmVM8wlSaqcYS5JUuUMc0mSKmeYS5JUOcNckqTKGeaSJFXOMJckqXKGuSRJlTPMJUmqnGEuSVLlqv3UNEmayN4DR7hq812t9rnvuotb7U9qm0fmkiRVzjCXJKlyhrkkSZUzzCVJqpxhLklS5QxzSZIqZ5hLklQ5w1ySpMoZ5pIkVc4wlySpcoa5JEmVM8wlSaqcYS5JUuUMc0mSKjdlmEfEtog4GBGPH1P/cER8MyKeiIj/3lO/JiJGI+LpiLigp7621EYjYnNPfXlEPFjqd0TEKW09OEmSBsF0jsxvAdb2FiLivcA64F2Z+U7g06W+ErgMeGfZ5vMRMS8i5gGfAy4EVgKXl7YAnwJuyMy3A4eBDU0flCRJg2TKMM/M+4FDx5T/E3BdZv6ktDlY6uuAHZn5k8x8DhgFzim30cx8NjNfAXYA6yIigPOAnWX77cAlDR+TJEkDZX6f2/0K8O8j4lrgx8B/ycyHgcXAAz3t9pcawAvH1M8F3gK8nJnjE7R/jYjYCGwEGBoaotPp9Dn81xobG2u1v0HkHDbnHDY3tAA2rRqfuuEJGMSfifticzM5h/2G+XzgDGA18G+BOyPiba2NahKZuRXYCjA8PJwjIyOt9d3pdGizv0HkHDbnHDb32dt2cf3efv+0TWzfFSOt9lcD98XmZnIO+93j9wNfyswEHoqInwFnAgeApT3tlpQak9S/DyyMiPnl6Ly3vSRJmoZ+/zXtr4D3AkTErwCnAN8DdgOXRcSpEbEcWAE8BDwMrChXrp9C9yK53eXJwH3ApaXf9cCufh+MJEmDaMoj84i4HRgBzoyI/cAWYBuwrfy72ivA+hLMT0TEncCTwDhwdWb+tPTzIeAeYB6wLTOfKN/iY8COiPgk8HXg5hYfnyRJr3tThnlmXj7Jqv8wSftrgWsnqN8N3D1B/Vm6V7tLkqQ++A5wkiRVzjCXJKlyhrkkSZUzzCVJqpxhLklS5QxzSZIqZ5hLklQ5w1ySpMoZ5pIkVc4wlySpcoa5JEmVM8wlSaqcYS5JUuUMc0mSKmeYS5JUOcNckqTKGeaSJFXOMJckqXKGuSRJlTPMJUmqnGEuSVLlDHNJkipnmEuSVDnDXJKkyhnmkiRVzjCXJKlyhrkkSZUzzCVJqtyUYR4R2yLiYEQ8PsG6TRGREXFmWY6IuDEiRiPisYg4u6ft+oh4ptzW99TfHRF7yzY3RkS09eAkSRoE0zkyvwVYe2wxIpYCa4Dne8oXAivKbSNwU2l7BrAFOBc4B9gSEYvKNjcBv9uz3Wu+lyRJmtyUYZ6Z9wOHJlh1A/BRIHtq64Bbs+sBYGFEvBW4ANiTmYcy8zCwB1hb1r05Mx/IzARuBS5p9pAkSRos8/vZKCLWAQcy82+POSu+GHihZ3l/qR2vvn+C+mTfdyPdI36GhobodDr9DH9CY2NjrfY3iJzD5pzD5oYWwKZV4632OYg/E/fF5mZyDk84zCPijcAf0T3FPqMycyuwFWB4eDhHRkZa67vT6dBmf4PIOWzOOWzus7ft4vq9fR2nTGrfFSOt9lcD98XmZnIO+7ma/V8By4G/jYh9wBLgaxHxz4EDwNKetktK7Xj1JRPUJUnSNJ1wmGfm3sz8Z5m5LDOX0T01fnZmvgTsBq4sV7WvBo5k5ovAPcCaiFhULnxbA9xT1v0gIlaXq9ivBHa19NgkSRoI0/nXtNuBvwHeERH7I2LDcZrfDTwLjAL/C/g9gMw8BHwCeLjcPl5qlDZfKNt8C/jr/h6KJEmDacoXljLz8inWL+u5n8DVk7TbBmyboP4IcNZU45AkSRPzHeAkSaqcYS5JUuUMc0mSKmeYS5JUOcNckqTKGeaSJFXOMJckqXLtvoGxpNe9ZZvvmu0hHNemVbM9AmnmeWQuSVLlDHNJkipnmEuSVDnDXJKkyhnmkiRVzjCXJKlyhrkkSZUzzCVJqpxhLklS5QxzSZIqZ5hLklQ5w1ySpMoZ5pIkVc4wlySpcoa5JEmVM8wlSaqcYS5JUuUMc0mSKmeYS5JUuSnDPCK2RcTBiHi8p/Y/IuKbEfFYRPzviFjYs+6aiBiNiKcj4oKe+tpSG42IzT315RHxYKnfERGntPkAJUl6vZvOkfktwNpjanuAszLzXwN/B1wDEBErgcuAd5ZtPh8R8yJiHvA54EJgJXB5aQvwKeCGzHw7cBjY0OgRSZI0YKYM88y8Hzh0TO3/ZOZ4WXwAWFLurwN2ZOZPMvM5YBQ4p9xGM/PZzHwF2AGsi4gAzgN2lu23A5c0fEySJA2U+S308TvAHeX+YrrhftT+UgN44Zj6ucBbgJd7nhj0tn+NiNgIbAQYGhqi0+k0HfvPjY2NtdrfIHIOm6thDjetGp+60SwaWtD+GOf6z+RkqGFfnOtmcg4bhXlE/DEwDtzWznCOLzO3AlsBhoeHc2RkpLW+O50ObfY3iJzD5mqYw6s23zXbQziuTavGuX5vG8cpv7DvipFW+6tBDfviXDeTc9j3Hh8RVwHvA87PzCzlA8DSnmZLSo1J6t8HFkbE/HJ03ttekiRNQ1//mhYRa4GPAu/PzB/1rNoNXBYRp0bEcmAF8BDwMLCiXLl+Ct2L5HaXJwH3AZeW7dcDu/p7KJIkDabp/Gva7cDfAO+IiP0RsQH4M+CfAnsi4hsR8T8BMvMJ4E7gSeArwNWZ+dNy1P0h4B7gKeDO0hbgY8B/johRuq+h39zqI5Qk6XVuytPsmXn5BOVJAzczrwWunaB+N3D3BPVn6V7tLkmS+uA7wEmSVDnDXJKkyhnmkiRVzjCXJKlyhrkkSZUzzCVJqpxhLklS5QxzSZIqZ5hLklQ5w1ySpMoZ5pIkVc4wlySpcoa5JEmVM8wlSaqcYS5JUuUMc0mSKmeYS5JUOcNckqTKGeaSJFXOMJckqXKGuSRJlTPMJUmqnGEuSVLlDHNJkipnmEuSVDnDXJKkyhnmkiRVzjCXJKlyU4Z5RGyLiIMR8XhP7YyI2BMRz5Svi0o9IuLGiBiNiMci4uyebdaX9s9ExPqe+rsjYm/Z5saIiLYfpCRJr2fTOTK/BVh7TG0zcG9mrgDuLcsAFwIrym0jcBN0wx/YApwLnANsOfoEoLT53Z7tjv1ekiTpOKYM88y8Hzh0THkdsL3c3w5c0lO/NbseABZGxFuBC4A9mXkoMw8De4C1Zd2bM/OBzEzg1p6+JEnSNMzvc7uhzHyx3H8JGCr3FwMv9LTbX2rHq++foD6hiNhI94ifoaEhOp1On8N/rbGxsVb7G0TOYXM1zOGmVeOzPYTjGlrQ/hjn+s/kZKhhX5zrZnIO+w3zn8vMjIhsYzDT+F5bga0Aw8PDOTIy0lrfnU6HNvsbRM5hczXM4VWb75rtIRzXplXjXL+38Z+2V9l3xUir/dWghn1xrpvJOez3avbvlFPklK8HS/0AsLSn3ZJSO159yQR1SZI0Tf2G+W7g6BXp64FdPfUry1Xtq4Ej5XT8PcCaiFhULnxbA9xT1v0gIlaXq9iv7OlLkiRNw5TnoiLidmAEODMi9tO9Kv064M6I2AB8G/hAaX43cBEwCvwI+CBAZh6KiE8AD5d2H8/MoxfV/R7dK+YXAH9dbpIkaZqmDPPMvHySVedP0DaBqyfpZxuwbYL6I8BZU41DkiRNzHeAkySpcoa5JEmVM8wlSaqcYS5JUuUMc0mSKmeYS5JUOcNckqTKGeaSJFXOMJckqXKGuSRJlTPMJUmqnGEuSVLlDHNJkipnmEuSVDnDXJKkyhnmkiRVzjCXJKlyhrkkSZUzzCVJqpxhLklS5QxzSZIqZ5hLklQ5w1ySpMoZ5pIkVc4wlySpcoa5JEmVM8wlSapcozCPiD+MiCci4vGIuD0i3hARyyPiwYgYjYg7IuKU0vbUsjxa1i/r6eeaUn86Ii5o9pAkSRosfYd5RCwGfh8YzsyzgHnAZcCngBsy8+3AYWBD2WQDcLjUbyjtiIiVZbt3AmuBz0fEvH7HJUnSoGl6mn0+sCAi5gNvBF4EzgN2lvXbgUvK/XVlmbL+/IiIUt+RmT/JzOeAUeCchuOSJGlg9B3mmXkA+DTwPN0QPwI8CrycmeOl2X5gcbm/GHihbDte2r+ltz7BNpIkaQrz+90wIhbRPapeDrwM/AXd0+QnTURsBDYCDA0N0el0Wut7bGys1f4GkXPYXA1zuGnV+NSNZtHQgvbHONd/JidDDfviXDeTc9h3mAO/CTyXmd8FiIgvAe8BFkbE/HL0vQQ4UNofAJYC+8tp+dOB7/fUj+rd5lUycyuwFWB4eDhHRkYaDP/VOp0ObfY3iJzD5mqYw6s23zXbQziuTavGuX5vkz9tr7XvipFW+6tBDfviXDeTc9jkNfPngdUR8cby2vf5wJPAfcClpc16YFe5v7ssU9Z/NTOz1C8rV7svB1YADzUYlyRJA6Xvp6+Z+WBE7AS+BowDX6d71HwXsCMiPllqN5dNbga+GBGjwCG6V7CTmU9ExJ10nwiMA1dn5k/7HZckSYOm0bmozNwCbDmm/CwTXI2emT8GfmuSfq4Frm0yFkmSBpXvACdJUuUMc0mSKmeYS5JUOcNckqTKGeaSJFXOMJckqXKGuSRJlTPMJUmqnGEuSVLlDHNJkipnmEuSVDnDXJKkyhnmkiRVzjCXJKlyjT4CVdLct2zzXbM9BEknmWEuSTOs7SdY+667uNX+VB9Ps0uSVDmPzCVpCr5UobnOI3NJkipnmEuSVDnDXJKkyhnmkiRVzjCXJKlyhrkkSZUzzCVJqpxhLklS5QxzSZIqZ5hLklS5RmEeEQsjYmdEfDMinoqIX4+IMyJiT0Q8U74uKm0jIm6MiNGIeCwizu7pZ31p/0xErG/6oCRJGiRNj8w/A3wlM38VeBfwFLAZuDczVwD3lmWAC4EV5bYRuAkgIs4AtgDnAucAW44+AZAkSVPr+4NWIuJ04DeAqwAy8xXglYhYB4yUZtuBDvAxYB1wa2Ym8EA5qn9rabsnMw+VfvcAa4Hb+x2bVKu9B45wlR/qIekENfnUtOXAd4E/j4h3AY8CHwGGMvPF0uYlYKjcXwy80LP9/lKbrP4aEbGR7lE9Q0NDdDqdBsN/tbGxsVb7G0TOYXNDC2DTqvHZHkbVBnEOT8bvnb/Pzc3kHDYJ8/nA2cCHM/PBiPgMvzilDkBmZkRkkwEe099WYCvA8PBwjoyMtNU1nU6HNvsbRM5hc5+9bRfX7/WTiZvYtGp84OZw3xUjrffp73NzMzmHTV4z3w/sz8wHy/JOuuH+nXL6nPL1YFl/AFjas/2SUpusLkmSpqHvMM/Ml4AXIuIdpXQ+8CSwGzh6Rfp6YFe5vxu4slzVvho4Uk7H3wOsiYhF5cK3NaUmSZKmoem5qA8Dt0XEKcCzwAfpPkG4MyI2AN8GPlDa3g1cBIwCPyptycxDEfEJ4OHS7uNHL4aTJElTaxTmmfkNYHiCVedP0DaBqyfpZxuwrclYJEkaVL4DnCRJlTPMJUmqnGEuSVLlDHNJkipnmEuSVDnDXJKkyhnmkiRVzjCXJKlyhrkkSZUzzCVJqpxhLklS5QxzSZIqZ5hLklQ5w1ySpMoZ5pIkVc4wlySpcoa5JEmVM8wlSaqcYS5JUuUMc0mSKjd/tgcgSZp79h44wlWb72qtv33XXdxaX3otj8wlSaqcYS5JUuUMc0mSKmeYS5JUOcNckqTKGeaSJFWucZhHxLyI+HpEfLksL4+IByNiNCLuiIhTSv3Usjxa1i/r6eOaUn86Ii5oOiZJkgZJG0fmHwGe6ln+FHBDZr4dOAxsKPUNwOFSv6G0IyJWApcB7wTWAp+PiHktjEuSpIHQKMwjYglwMfCFshzAecDO0mQ7cEm5v64sU9afX9qvA3Zk5k8y8zlgFDinybgkSRokTY/M/xT4KPCzsvwW4OXMHC/L+4HF5f5i4AWAsv5Iaf/z+gTbSJKkKfT9dq4R8T7gYGY+GhEj7Q3puN9zI7ARYGhoiE6n01rfY2NjrfY3iGqYw70HjrTa36rFp7fa39AC2LRqfOqGmtQgzuHJ+L1rex7n+t+Gk2Em/yY2eW/29wDvj4iLgDcAbwY+AyyMiPnl6HsJcKC0PwAsBfZHxHzgdOD7PfWjerd5lczcCmwFGB4ezpGRkQbDf7VOp0Ob/Q2iGuawzfeaBth3xUir/X32tl1cv9ePTGhi06rxgZvDtvdDaH9fPBljnOtm8m9i36fZM/OazFySmcvoXsD21cy8ArgPuLQ0Ww/sKvd3l2XK+q9mZpb6ZeVq9+XACuChfsclSdKgORlPXz8G7IiITwJfB24u9ZuBL0bEKHCI7hMAMvOJiLgTeBIYB67OzJ+ehHFJkvS61EqYZ2YH6JT7zzLB1eiZ+WPgtybZ/lrg2jbGIknSoBmsF5Yk6XVoWcvXggBsWtV6lzqJfDtXSZIqZ5hLklQ5w1ySpMr5mnmx98CRVv8Hed91F7fWlyRJx+ORuSRJlfPIXJJUnZNxBX/NZ1Q9MpckqXKGuSRJlTPMJUmqnGEuSVLlDHNJkipnmEuSVDnDXJKkyhnmkiRVzjCXJKlyhrkkSZUzzCVJqpxhLklS5fygFamBtj/sYdOqVruTNCA8MpckqXIemUuSTrqT8ZGl+gWPzCVJqpxhLklS5QxzSZIqZ5hLklQ5w1ySpMoZ5pIkVa7vMI+IpRFxX0Q8GRFPRMRHSv2MiNgTEc+Ur4tKPSLixogYjYjHIuLsnr7Wl/bPRMT65g9LkqTB0eTIfBzYlJkrgdXA1RGxEtgM3JuZK4B7yzLAhcCKctsI3ATd8Ae2AOcC5wBbjj4BkCRJU+s7zDPzxcz8Wrn/98BTwGJgHbC9NNsOXFLurwNuza4HgIUR8VbgAmBPZh7KzMPAHmBtv+OSJGnQRGY27yRiGXA/cBbwfGYuLPUADmfmwoj4MnBdZv6/su5e4GPACPCGzPxkqf9X4B8y89MTfJ+NdI/qGRoaeveOHTsaj/2og4eO8J1/aK07Vi0+vb3OKjE2Nsab3vSm2R7Gce09cGS2h3BcQwtodT8cRM5hOwZxHtv+u93238T3vve9j2bm8ETrGr+da0S8CfhL4A8y8wfd/O7KzIyI5s8WftHfVmArwPDwcI6MjLTVNZ+9bRfX723v3W33XTHSWl+16HQ6tPkzORmumuNvKblp1Xir++Egcg7bMYjz2Pbf7Zn8m9joavaI+CW6QX5bZn6plL9TTp9Tvh4s9QPA0p7Nl5TaZHVJkjQNTa5mD+Bm4KnM/JOeVbuBo1ekrwd29dSvLFe1rwaOZOaLwD3AmohYVC58W1NqkiRpGpqcQ3kP8NvA3oj4Rqn9EXAdcGdEbAC+DXygrLsbuAgYBX4EfBAgMw9FxCeAh0u7j2fmoQbjkiRpoPQd5uVCtphk9fkTtE/g6kn62gZs63csen3yIxMlaXp8BzhJkipnmEuSVDnDXJKkyhnmkiRVzjCXJKlyhrkkSZUzzCVJqpxhLklS5QxzSZIqZ5hLklQ5w1ySpMoZ5pIkVc4wlySpcoa5JEmVa/J55pIkvW60/bHLt6w9rdX+jscjc0mSKmeYS5JUOU+zqzV7DxzhqpZPU0mSpuaRuSRJlTPMJUmqnGEuSVLlDHNJkipnmEuSVDnDXJKkyhnmkiRVzjCXJKlyhrkkSZWbM2EeEWsj4umIGI2IzbM9HkmSajEnwjwi5gGfAy4EVgKXR8TK2R2VJEl1mBNhDpwDjGbms5n5CrADWDfLY5IkqQpz5YNWFgMv9CzvB86dpbHMWW1/1m7bNq2a7RFI0mCKzJztMRARlwJrM/M/luXfBs7NzA8d024jsLEsvgN4usVhnAl8r8X+BpFz2Jxz2Jxz2A7nsbm25/BfZuYvT7RirhyZHwCW9iwvKbVXycytwNaTMYCIeCQzh09G34PCOWzOOWzOOWyH89jcTM7hXHnN/GFgRUQsj4hTgMuA3bM8JkmSqjAnjswzczwiPgTcA8wDtmXmE7M8LEmSqjAnwhwgM+8G7p7FIZyU0/cDxjlszjlszjlsh/PY3IzN4Zy4AE6SJPVvrrxmLkmS+jTwYe7byE5PRCyNiPsi4smIeCIiPlLqZ0TEnoh4pnxdVOoRETeWeX0sIs6e3Ucwd0TEvIj4ekR8uSwvj4gHy1zdUS4CJSJOLcujZf2y2Rz3XBIRCyNiZ0R8MyKeiohfd188MRHxh+V3+fGIuD0i3uC+eHwRsS0iDkbE4z21E97vImJ9af9MRKxvY2wDHea+jewJGQc2ZeZKYDVwdZmrzcC9mbkCuLcsQ3dOV5TbRuCmmR/ynPUR4Kme5U8BN2Tm24HDwIZS3wAcLvUbSjt1fQb4Smb+KvAuuvPpvjhNEbEY+H1gODPPonvh8WW4L07lFmDtMbUT2u8i4gxgC903RjsH2HL0CUATAx3m+Day05aZL2bm18r9v6f7x3Mx3fnaXpptBy4p99cBt2bXA8DCiHjrDA97zomIJcDFwBfKcgDnATtLk2Pn8Ojc7gTOL+0HWkScDvwGcDNAZr6SmS/jvnii5gMLImI+8EbgRdwXjysz7wcOHVM+0f3uAmBPZh7KzMPAHl77BOGEDXqYT/Q2sotnaSzVKKfYfg14EBjKzBfLqpeAoXLfuZ3YnwIfBX5Wlt8CvJyZ42W5d55+Podl/ZHSftAtB74L/Hl5ueILEXEa7ovTlpkHgE8Dz9MN8SPAo7gv9uNE97uTsj8OepjrBEXEm4C/BP4gM3/Quy67/xrhv0dMIiLeBxzMzEdneyyVmw+cDdyUmb8G/JBfnNoE3BenUk7rrqP7xOhfAKfRwtHhoJvN/W7Qw3xabyOrroj4JbpBfltmfqmUv3P0lGX5erDUndvXeg/w/ojYR/clnfPovva7sJzqhFfP08/nsKw/Hfj+TA54jtoP7M/MB8vyTrrh7r44fb8JPJeZ383MfwS+RHf/dF88cSe6352U/XHQw9y3kZ2m8vrYzcBTmfknPat2A0evxlwP7OqpX1mu6FwNHOk5FTWQMvOazFySmcvo7mtfzcwrgPuAS0uzY+fw6NxeWtoP/NFmZr4EvBAR7yil84EncV88Ec8DqyPijeV3++gcui+euBPd7+4B1kTEonKGZE2pNZOZA30DLgL+DvgW8MezPZ65egP+Hd3TR48B3yi3i+i+bnYv8Azwf4EzSvug+58C3wL20r1qdtYfx1y5ASPAl8v9twEPAaPAXwCnlvobyvJoWf+22R73XLkB/wZ4pOyPfwUscl884Tn8b8A3gceBLwKnui9OOWe3073G4B/pniHa0M9+B/xOmctR4INtjM13gJMkqXKDfppdkqTqGeaSJFXOMJckqXKGuSRJlTPMJUmqnGEuSVLlDHNJkipnmEuSVLn/D5qCrCVllzQEAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 576x432 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "T98K0HdWEq5C",
        "outputId": "a05f6ef7-3f5c-454d-b98c-d52eb4c63ba3",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "#Estatística por média de nota de Redação\n",
        "data['NU_NOTA_REDACAO'].mean()"
      ],
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "571.5700253970197"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "49Ql3mW8E30t",
        "outputId": "8887fb97-082a-493c-fa7e-9733c6902fb0",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "#Estatística por desvio padrão de nota de Redação\n",
        "data['NU_NOTA_REDACAO'].std()"
      ],
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "188.07645455749753"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "JXN0ikNmFEsQ",
        "outputId": "e9a59f30-52e5-4329-c006-a190e50156a9",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 300
        }
      },
      "source": [
        "#Selecionando somente as variáveis de interesse\n",
        "#para ser utilizada em filtro\n",
        "test = ['NU_NOTA_CN', 'NU_NOTA_CH', 'NU_NOTA_MT', 'NU_NOTA_LC', 'NU_NOTA_REDACAO']\n",
        "\n",
        "#Descrição Estatística\n",
        "data[test].describe()\n",
        "\n",
        "#Função para os quartis -> os 10% mais alto da amostra\n",
        "#data['NU_NOTA_CN'].quantile(0.9)"
      ],
      "execution_count": 17,
      "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>NU_NOTA_CN</th>\n",
              "      <th>NU_NOTA_CH</th>\n",
              "      <th>NU_NOTA_MT</th>\n",
              "      <th>NU_NOTA_LC</th>\n",
              "      <th>NU_NOTA_REDACAO</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>92758.000000</td>\n",
              "      <td>98043.000000</td>\n",
              "      <td>92758.000000</td>\n",
              "      <td>98043.000000</td>\n",
              "      <td>98043.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>477.964015</td>\n",
              "      <td>507.365912</td>\n",
              "      <td>523.555206</td>\n",
              "      <td>520.463928</td>\n",
              "      <td>571.570025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>76.296099</td>\n",
              "      <td>82.972839</td>\n",
              "      <td>109.416939</td>\n",
              "      <td>64.556578</td>\n",
              "      <td>188.076455</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>418.000000</td>\n",
              "      <td>447.900000</td>\n",
              "      <td>435.300000</td>\n",
              "      <td>483.700000</td>\n",
              "      <td>480.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>470.200000</td>\n",
              "      <td>510.900000</td>\n",
              "      <td>501.600000</td>\n",
              "      <td>526.100000</td>\n",
              "      <td>580.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>533.300000</td>\n",
              "      <td>567.100000</td>\n",
              "      <td>598.200000</td>\n",
              "      <td>565.100000</td>\n",
              "      <td>680.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>797.300000</td>\n",
              "      <td>809.400000</td>\n",
              "      <td>985.000000</td>\n",
              "      <td>801.700000</td>\n",
              "      <td>1000.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         NU_NOTA_CN    NU_NOTA_CH    NU_NOTA_MT    NU_NOTA_LC  NU_NOTA_REDACAO\n",
              "count  92758.000000  98043.000000  92758.000000  98043.000000     98043.000000\n",
              "mean     477.964015    507.365912    523.555206    520.463928       571.570025\n",
              "std       76.296099     82.972839    109.416939     64.556578       188.076455\n",
              "min        0.000000      0.000000      0.000000      0.000000         0.000000\n",
              "25%      418.000000    447.900000    435.300000    483.700000       480.000000\n",
              "50%      470.200000    510.900000    501.600000    526.100000       580.000000\n",
              "75%      533.300000    567.100000    598.200000    565.100000       680.000000\n",
              "max      797.300000    809.400000    985.000000    801.700000      1000.000000"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "VNClxxWTHpVz",
        "outputId": "fc6c8728-8e1a-4cfb-9178-c198ab574e15",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 392
        }
      },
      "source": [
        "#Descrição Estatística via gráfico Boxplot\n",
        "data['NU_NOTA_CN'].plot.box(grid = True, figsize=(8,6))"
      ],
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f83a431c630>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 18
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAeYAAAFmCAYAAAC4IzkXAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAXT0lEQVR4nO3df7DldX3f8eerLIhSw/LD3tnZJV06bpMQMiLeQaxpuLoaBRKWdtBAbdw4m26HQWOSZsqKaSnTXzCJJdBmnOy4xMVJVqmGYRWGyOCeaTutVFCCCiZs6CK7s4Aii1kxhnXe/eN+0MPmsvfs/cH5eO/zMXPmfr6fz+f7Pe/DcOZ1v5/vd783VYUkSerD3xl3AZIk6YcMZkmSOmIwS5LUEYNZkqSOGMySJHXEYJYkqSMrxl0AwKmnnlpr164ddxnSsvOd73yHE044YdxlSMvOfffd982qetVMY10E89q1a7n33nvHXYa07AwGA6ampsZdhrTsJHn0xcZcypYkqSMGsyRJHTGYJUnqiMEsSVJHDGZJkjpiMEuS1BGDWZKkjhjMkiR1ZKRgTvIbSb6a5CtJdiQ5PsnpSe5JsjvJJ5Ic1+a+rG3vbuNrF/MDSJK0lMwazElWA78GTFbVmcAxwKXAdcD1VfVq4GlgU9tlE/B067++zZMkSSMYdSl7BfDyJCuAVwD7gTcDn2zj24GLW3tD26aNr0+ShSlX0kLYsWMHZ555JuvXr+fMM89kx44d4y5JUjPrs7Kral+S3wW+DnwX+CxwH3Cgqg61aXuB1a29Gnis7XsoyTPAKcA3F7h2SXOwY8cOPvjBD7Jt2za+//3vc8wxx7Bp0/SC12WXXTbm6iTNGsxJTmL6LPh04ADw34G3z/eNk2wGNgNMTEwwGAzme0hJI7jqqqtYvXo1b3vb23juuec49thjOeecc7jqqqtYtWrVuMuTlr1R/rrUW4D/V1XfAEjyJ8AbgZVJVrSz5jXAvjZ/H3AasLctfZ8IPHX4QatqK7AVYHJysvwLN9JLY8+ePezdu5frrruOM844gwcffJArr7ySQ4cO+ZempA6Mco3568C5SV7RrhWvBx4EdgGXtDkbgdtae2fbpo1/rqpq4UqWNB9JOO+887jpppu48MILuemmmzjvvPPwVhCpDxklM5NcA/wScAj4EvCrTF9L/jhwcuv751X1vSTHAx8DXgt8C7i0qh450vEnJyfLv8csvTSOFMD+Di29NJLcV1WTM4718EU0mKWXjsEsjd+Rgtknf0nL1EUXXcStt97KRRddNO5SJA0Z5eYvSUvMypUr2blzJzt37vzB9oEDB8ZclSTwjFlalg4cOMDll1/Opz/9aS6//HJDWeqI15ilZcZrzNL4eY1ZkqQfEQazJEkdMZglSeqIwSxJUkcMZkmSOmIwS5LUEYNZkqSOGMySJHXEYJYkqSMGsyRJHTGYJUnqiMEsSVJHDGZJkjpiMEuS1BGDWZKkjhjMkiR1xGCWJKkjBrMkSR0xmCVJ6ojBLElSRwxmSZI6YjBLktQRg1mSpI4YzJIkdWTWYE7yE0nuH3p9O8mvJzk5yV1JHm4/T2rzk+TGJLuTPJDk7MX/GJIkLQ2zBnNV/XlVnVVVZwGvA54FbgW2AHdX1Trg7rYNcD6wrr02Ax9ejMIlQZKjfi308WY7pqSjc7RL2euBv6yqR4ENwPbWvx24uLU3ADfXtM8DK5OsWpBqJb1AVR31a6GPN9sxJR2dow3mS4EdrT1RVftb+3FgorVXA48N7bO39UmSpFmsGHVikuOAi4APHD5WVZXkqH5tTrKZ6aVuJiYmGAwGR7O7pDnatWsXb3rTm2bs93sojd/Iwcz0teMvVtUTbfuJJKuqan9bqn6y9e8DThvab03re4Gq2gpsBZicnKypqamjrV3SHD2//Lx2y+3sufbCMVcjadjRLGVfxg+XsQF2AhtbeyNw21D/u9vd2ecCzwwteUuSpCMY6Yw5yQnAW4F/OdR9LXBLkk3Ao8A7W/8dwAXAbqbv4H7PglUrSdISN1IwV9V3gFMO63uK6bu0D59bwBULUp0kScuMT/6SJKkjBrMkSR0xmCVJ6ojBLElSRwxmSZI6YjBLktQRg1mSpI4YzJIkdcRgliSpIwazJEkdMZglSeqIwSxJUkcMZkmSOmIwS5LUEYNZkqSOGMySJHXEYJYkqSMGsyRJHTGYJUnqiMEsSVJHDGZJkjpiMEuS1BGDWZKkjhjMkiR1xGCWJKkjBrMkSR0xmCVJ6ojBLElSR0YK5iQrk3wyydeSPJTkDUlOTnJXkofbz5Pa3CS5McnuJA8kOXtxP4IkSUvHqGfMNwB3VtVPAq8BHgK2AHdX1Trg7rYNcD6wrr02Ax9e0IolSVrCZg3mJCcCPwdsA6iqv6mqA8AGYHubth24uLU3ADfXtM8DK5OsWvDKJUlagkY5Yz4d+Abwh0m+lOQjSU4AJqpqf5vzODDR2quBx4b239v6JEnSLFaMOOds4H1VdU+SG/jhsjUAVVVJ6mjeOMlmppe6mZiYYDAYHM3ukhaI3z2pL6ME815gb1Xd07Y/yXQwP5FkVVXtb0vVT7bxfcBpQ/uvaX0vUFVbga0Ak5OTNTU1NbdPIGnu7rwdv3tSX2Zdyq6qx4HHkvxE61oPPAjsBDa2vo3Aba29E3h3uzv7XOCZoSVvSZJ0BKOcMQO8D/ijJMcBjwDvYTrUb0myCXgUeGebewdwAbAbeLbNlSRJIxgpmKvqfmByhqH1M8wt4Ip51iVJ0rLkk78kSeqIwSxJUkcMZkmSOmIwS5LUEYNZkqSOGMySJHXEYJYkqSMGsyRJHTGYJUnqiMEsSVJHDGZJkjpiMEuS1BGDWZKkjhjMkiR1xGCWJKkjBrMkSR0xmCVJ6ojBLElSRwxmSZI6YjBLktSRFeMuQFquXnPNZ3nmu8+NuwzWbrl93CVw4suP5c+u/vlxlyF1wWCWxuSZ7z7HnmsvHGsNg8GAqampsdYAffxyIPXCpWxJkjpiMEuS1BGDWZKkjhjMkiR1xGCWJKkjBrMkSR0xmCVJ6shIwZxkT5IvJ7k/yb2t7+QkdyV5uP08qfUnyY1Jdid5IMnZi/kBJElaSo7mjPlNVXVWVU227S3A3VW1Dri7bQOcD6xrr83AhxeqWEmSlrr5LGVvALa39nbg4qH+m2va54GVSVbN430kSVo2Rn0kZwGfTVLAH1TVVmCiqva38ceBidZeDTw2tO/e1rd/qI8km5k+o2ZiYoLBYDCnDyD9KBv3//cHDx4cew3P66UOadxGDeafrap9Sf4ecFeSrw0PVlW10B5ZC/etAJOTk9XD83qll9Sdt4/9OdW9PCu7h/8WUi9GWsquqn3t55PArcA5wBPPL1G3n0+26fuA04Z2X9P6JEnSLGYN5iQnJHnl823g54GvADuBjW3aRuC21t4JvLvdnX0u8MzQkrckSTqCUZayJ4Bbkzw//4+r6s4kXwBuSbIJeBR4Z5t/B3ABsBt4FnjPglctSdISNWswV9UjwGtm6H8KWD9DfwFXLEh1kiQtMz75S5KkjhjMkiR1xGCWJKkjBrMkSR0xmCVJ6sioT/6StMBe+VNb+JntW2afuNi2zz5lsb3ypwAuHHcZUhcMZmlM/uqha9lz7XjDqJdHcq7dcvu4S5C64VK2JEkdMZglSeqIwSxJUkcMZkmSOmIwS5LUEYNZkqSOGMySJHXEYJYkqSMGsyRJHTGYJUnqiMEsSVJHDGZJkjpiMEuS1BGDWZKkjhjMkiR1xGCWJKkjBrMkSR0xmCVJ6siKcRcgLWdrt9w+7hLgzvHXcOLLjx13CVI3DGZpTPZce+G4S2Dtltu7qEPSD7mULUlSR0YO5iTHJPlSks+07dOT3JNkd5JPJDmu9b+sbe9u42sXp3RJkpaeozljfj/w0ND2dcD1VfVq4GlgU+vfBDzd+q9v8yRJ0ghGCuYka4ALgY+07QBvBj7ZpmwHLm7tDW2bNr6+zZckSbMY9eav3wP+NfDKtn0KcKCqDrXtvcDq1l4NPAZQVYeSPNPmf3P4gEk2A5sBJiYmGAwGc/wIkubD757Ul1mDOckvAE9W1X1JphbqjatqK7AVYHJysqamFuzQkkZ15+343ZP6MsoZ8xuBi5JcABwP/BhwA7AyyYp21rwG2Nfm7wNOA/YmWQGcCDy14JVLkrQEzXqNuao+UFVrqmotcCnwuap6F7ALuKRN2wjc1to72zZt/HNVVQtatSRJS9R8/h3zlcBvJtnN9DXkba1/G3BK6/9NYMv8SpQkafk4qid/VdUAGLT2I8A5M8z5a+AdC1CbJEnLjk/+kiSpIwazJEkdMZglSeqIwSxJUkcMZkmSOmIwS5LUEYNZkqSOGMySJHXEYJYkqSMGsyRJHTGYJUnqiMEsSVJHDGZJkjpiMEuS1BGDWZKkjhjMkiR1xGCWJKkjBrMkSR0xmCVJ6ojBLElSRwxmSZI6smLcBUiauyTzP8Z186+jquZ/EEmAZ8zSj7Sqmtdr165d8z6GoSwtLINZkqSOGMySJHXEYJYkqSMGsyRJHTGYJUnqyKzBnOT4JP83yZ8l+WqSa1r/6UnuSbI7ySeSHNf6X9a2d7fxtYv7ESRJWjpGOWP+HvDmqnoNcBbw9iTnAtcB11fVq4GngU1t/ibg6dZ/fZsnSZJGMGsw17SDbfPY9irgzcAnW/924OLW3tC2aePrsxBPQZAkaRkY6RpzkmOS3A88CdwF/CVwoKoOtSl7gdWtvRp4DKCNPwOcspBFS5K0VI30SM6q+j5wVpKVwK3AT873jZNsBjYDTExMMBgM5ntISUfp4MGDfvekzhzVs7Kr6kCSXcAbgJVJVrSz4jXAvjZtH3AasDfJCuBE4KkZjrUV2AowOTlZU1NTc/4QkuZmMBjgd0/qyyh3Zb+qnSmT5OXAW4GHgF3AJW3aRuC21t7ZtmnjnysfpitJ0khGOWNeBWxPcgzTQX5LVX0myYPAx5P8B+BLwLY2fxvwsSS7gW8Bly5C3ZIkLUmzBnNVPQC8dob+R4BzZuj/a+AdC1KdJEnLjE/+kiSpIwazJEkdMZglSeqIwSxJUkcMZkmSOmIwS5LUEYNZkqSOGMySJHXEYJYkqSMGsyRJHTGYJUnqiMEsSVJHDGZJkjpiMEuS1BGDWZKkjhjMkiR1xGCWJKkjBrMkSR0xmCVJ6ojBLElSRwxmSZI6YjBLktQRg1mSpI4YzJIkdcRgliSpIwazJEkdMZglSeqIwSxJUkdmDeYkpyXZleTBJF9N8v7Wf3KSu5I83H6e1PqT5MYku5M8kOTsxf4QkiQtFaOcMR8C/lVVnQGcC1yR5AxgC3B3Va0D7m7bAOcD69prM/DhBa9akqQlatZgrqr9VfXF1v4r4CFgNbAB2N6mbQcubu0NwM017fPAyiSrFrxySZKWoKO6xpxkLfBa4B5goqr2t6HHgYnWXg08NrTb3tYnSZJmsWLUiUn+LvAp4Ner6ttJfjBWVZWkjuaNk2xmeqmbiYkJBoPB0ewuaQEcPHjQ757UmZGCOcmxTIfyH1XVn7TuJ5Ksqqr9ban6yda/DzhtaPc1re8FqmorsBVgcnKypqam5vYJJM3ZYDDA757Ul1Huyg6wDXioqv7L0NBOYGNrbwRuG+p/d7s7+1zgmaElb0mSdASjnDG/Efhl4MtJ7m99VwHXArck2QQ8Cryzjd0BXADsBp4F3rOgFUuStITNGsxV9b+AvMjw+hnmF3DFPOuSJGlZ8slfkiR1xGCWJKkjBrMkSR0xmCVJ6ojBLElSRwxmSZI6YjBLktQRg1mSpI4YzJIkdcRgliSpIwazJEkdMZglSeqIwSxJUkcMZkmSOmIwS5LUEYNZkqSOGMySJHXEYJYkqSMGsyRJHTGYJUnqiMEsSVJHDGZJkjpiMEuS1BGDWZKkjhjMkiR1xGCWJKkjBrMkSR0xmCVJ6siswZzkpiRPJvnKUN/JSe5K8nD7eVLrT5Ibk+xO8kCSsxezeEmSlppRzpg/Crz9sL4twN1VtQ64u20DnA+sa6/NwIcXpkxJkpaHWYO5qv4H8K3DujcA21t7O3DxUP/NNe3zwMokqxaqWEmSlrq5XmOeqKr9rf04MNHaq4HHhubtbX2SJGkEK+Z7gKqqJHW0+yXZzPRyNxMTEwwGg/mWIukoHTx40O+e1Jm5BvMTSVZV1f62VP1k698HnDY0b03r+1uqaiuwFWBycrKmpqbmWIqkuRoMBvjdk/oy16XsncDG1t4I3DbU/+52d/a5wDNDS96SJGkWs54xJ9kBTAGnJtkLXA1cC9ySZBPwKPDONv0O4AJgN/As8J5FqFmSpCVr1mCuqsteZGj9DHMLuGK+RUmStFz55C9JkjpiMEuS1BGDWZKkjhjMkiR1xGCWJKkjBrMkSR0xmCVJ6ojBLElSRwxmSZI6YjBLktQRg1mSpI4YzJIkdcRgliSpIwazJEkdMZglSeqIwSxJUkcMZkmSOmIwS5LUEYNZkqSOGMySJHXEYJYkqSMGsyRJHTGYJUnqiMEsSVJHDGZJkjpiMEuS1BGDWZKkjhjMkiR1xGCWJKkjKxbjoEneDtwAHAN8pKquXYz3kTQ3Sf5WX1WNoRJJh1vwM+YkxwC/D5wPnAFcluSMhX4fSXMzHMpXX331jP2SxmcxlrLPAXZX1SNV9TfAx4ENi/A+kuahqpiamvJMWerMYixlrwYeG9reC7z+8ElJNgObASYmJhgMBotQiqSZXH311QwGAw4ePMhgMODqq6/mmmuu8XsodSAL/dtykkuAt1fVr7btXwZeX1XvfbF9Jicn6957713QOiTN7Pkl66piMBgwNTX1gj5Jiy/JfVU1OdPYYixl7wNOG9pe0/okdSQJg8HAa8tSZxYjmL8ArEtyepLjgEuBnYvwPpLmYPis+JprrpmxX9L4LHgwV9Uh4L3AnwIPAbdU1VcX+n0kzV1VUVXs2rXrB21JfViUf8dcVXcAdyzGsSVJWsp88pckSR0xmCVJ6ojBLElSRwxmSZI6YjBLktQRg1mSpI4YzJIkdcRgliSpIwazJEkdWfC/LjWnIpJvAI+Ouw5pGToV+Oa4i5CWob9fVa+aaaCLYJY0HknufbE/PSdpPFzKliSpIwazJEkdMZil5W3ruAuQ9EJeY5YkqSOeMUuS1BGDWZKkjhjM0hglqSQfGtr+rST/rrU/muSSw+YfPMKx1rbjvW+o778l+ZXWTpLfTvJwkr9IsivJT7exe5Lcn+TrSb7R2ve3Y65ofdeO8HmOTXJte48vJvk/Sc5vY3uSfGpo7iVJPjrifypp2TCYpfH6HvBPk5y6QMd7Enh/kuNmGLsC+EfAa6rqHwL/GdiZ5Piqen1VnQX8W+ATVXVWe+0B3gr8BfCOJJnl/f89sAo4s6rOBi4GXjk0/rokZ8znA0pLncEsjdchpu+M/o0FOt43gLuBjTOMXQm8t6qeBaiqzwL/G3jXLMe8DLgB+DrwhheblOQVwL8A3ldV32vv8URV3TI07UPAB0f7KNLyZDBL4/f7wLuSnLhAx7sO+K0kxzzfkeTHgBOq6pHD5t4L/PSLHSjJ8cBbgE8DO5gO6RfzauDrVfXtI8y5BTg7yauP/BGk5ctglsasBdnNwK8dPjTT9BGO9whwD/DP5l8dvwDsqqrvAp8CLh4O/Dn4PvA7wAcWoDZpSTKYpT78HrAJOGGo7yngpOc3kpzM6H9w4j8xvXQd+EH4fyfJPzhs3uuArx7hOJcBb0myB7gPOAV484vM3Q38eDs7P5KPAT8HnDbLPGlZMpilDlTVt5he5t001D0AfmnoRq5fAXaNeLyvAQ8CvzjU/TvAjUleDpDkLcDPAn880zFawP5j4Meram1VrWX6BrIZl7PbtettwA3P15zkVUnecdi854DrWbjr6tKSYjBL/fgQ03+GEYCq+gzwP4H7ktwPvJHps+BR/UdgzdD2fwW+AHw5yZ8D/wbY0JapZ/JPgM89fyNXcxvwi0le9iL7/DbTN6A9mOQrwGeAma45bwNWjPxJpGXER3JKktQRz5glSeqIS0nSj5gkP8P0DVTDvldVr38Ja7gVOP2w7iur6k9fqhqkpcqlbEmSOuJStiRJHTGYJUnqiMEsSVJHDGZJkjpiMEuS1JH/D4htVLyJ4jErAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 576x432 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NrRxfpsKJxXk",
        "outputId": "f0af6a26-6f9e-45cf-9fca-7667ba4d4265",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 392
        }
      },
      "source": [
        "#Gráfico Boxplot de todas as notas\n",
        "data[test].boxplot(grid = True, figsize=(8,6))\n",
        "#Explicando:\n",
        "#NU_NOTA_LC = concentrou mais indivíduos com a mesma notas próximas\n",
        "\n",
        "#Medidas de Resumo\n",
        "#Média Central: tendência a medir o centro\n",
        "#Medida de dispersão: como estes dados estão distribuidos na amostra"
      ],
      "execution_count": 19,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f83a42a6550>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 19
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAfIAAAFmCAYAAACWZhiFAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAfxElEQVR4nO3df5TcdX3v8ec7mx+L1EKIdYsQiD1yW2I4Vs1Re+X2bMBLRXsJ1yOW4LFUUzgB3UBDvUuxvdHbhktuC1ZDFYnBoqcGUUtdwSb1Yqa9PVc5BbFQsy3mioRwCP4Akm5+LPnxuX/Md5dJ2Gx2d+Y7s5+Z5+OcPTvfz3zmO595Z7Ov+X6+n/1OpJSQJEl5mtHqAUiSpKkzyCVJyphBLklSxgxySZIyZpBLkpQxg1ySpIzNbPUAxvOKV7wiLViwoNXDmJQ9e/Zw4okntnoYbc0aN4d1Lp81Ll+ONX7ooYd+mlL6hYn2n9ZBvmDBAh588MFWD2NSKpUKvb29rR5GW7PGzWGdy2eNy5djjSPiicn0d2pdkqSMGeSSJGXMIJckKWMGuSRJGTPIJUnKmEEuSVLGDHJJkjJmkEuSlDGDXJKkjB03yCPijoj4cUT8S03bKRHxzYj4QfF9btEeEfHJiNgWEY9ExBtqHnN50f8HEXF5OS9HkqTOMpEj8r8E3n5U2/XA/Smls4D7i22AC4Gziq8rgU9DNfiB1cCbgTcBq0fCX5KkRuvr66O7u5slS5bQ3d1NX19fq4dUmuNeaz2l9A8RseCo5qVAb3H7TqAC9Bftn08pJeA7EXFyRJxa9P1mSulZgIj4JtU3BxvrfgWSJNXo6+vjtttuY+3atSxcuJCtW7fS398PwLp161o8usab6jnynpTS08XtnUBPcfs04MmafjuKtmO1S5LUUOvXr2ft2rWsWrWK7u5uVq1axdq1a1m/fn2rh1aKuj/9LKWUIiI1YjAAEXEl1Wl5enp6qFQqjdp1UwwNDWU35txY4+awzuWzxuUYHh5m4cKFVCqV0RovXLiQ4eHhtqz3VIP8mYg4NaX0dDF1/uOi/Slgfk2/04u2p3hxKn6kvTLWjlNKtwO3AyxevDjl9vFzOX5kXm6scbn6+vpYv349w8PDzJkzhyuuuKItpyOnA3+WyzFnzhy2bt3KqlWrRmt8yy23MGfOnLas91SDfAC4HLip+P61mvYPRcRdVBe27SrCfjNwY80CtwuAP5j6sCWVodPOLao9XXHFFaM/twsXLuSWW26hv7+fFStWtHhk5ThukEfERqpH06+IiB1UV5/fBNwdEcuBJ4D3FN2/AbwD2AbsBd4PkFJ6NiL+GPinot//GFn4Jmn6qD23WKlUWLVqFQA33HCDQa5sjPys3nDDDaMzSytWrGjbn+GJrFpfdoy7zh+jbwI+eIz93AHcManRSWqq4eFh5s6dy6JFixgcHOTss8/muuuuY3h4uNVDkyZl3bp1rFu3riNOX9S92E1S+5g5cyZXXXUVhw8f5vDhwzz22GNcddVVzJzprwpNHxFR2r6rx6N58RKtkkZ1dXUxPDzMhRdeyD333MOFF17I8PAwXV1drR6aNCqlNOGvM/vvnVT/HPk2W9Ko4eFhTjjhBAYGBhgYGADghBNOYN++fS0emaRj8Yhc0hH27ds3OnUZEYa4NM0Z5JJeYsWKFXz9619v2z/XkdqJU+uSXuKee+7hM5/5DK985StbPRRJx2GQS3qJnTt3HvFd0vTl1LokSRkzyCVJyphBLklSxgxySS8xd+5cZsyYwdy5c4/fWVJLudhN0ks899xzR3yXNH15RC5JUsYMckmSMmaQS5KUMYNckqSMGeSSJGXMIJckKWMGuSRJGTPIJUnKmEEuSVLGDHJJkjJmkEuSlDGDXJKkjBnkkiRlzCCXJCljBrkkSRkzyCVJyphBLklSxgxySZIyZpBLkpQxg1ySpIwZ5JIkZcwglyQpYwa5JEkZM8glScqYQS5JUsYMckmSMmaQS5KUMYNckqSMGeSSJGVsZqsHIKk5IqLUx6eU6tq/pKkxyKUOMZGgHS+sDWppenJqXZKkjBnkkkYd66jbo3Fp+jLIJR0hpURKiTP77x29LWn6MsglScqYQS5JUsYMcmVj48aNLFq0iPPPP59FixaxcePGVg9JklrOPz9TFjZu3MhHPvIRNmzYwKFDh+jq6mL58uUALFu2rMWjk6TWqeuIPCJ+LyK+HxH/EhEbI6I7Il4dEQ9ExLaI+FJEzC76zim2txX3L2jEC1BnWLNmDRs2bGDJkiXMnDmTJUuWsGHDBtasWdPqoUmT5uySGmnKR+QRcRqwEliYUtoXEXcDlwLvAD6eUrorIm4DlgOfLr4/l1J6TURcCqwFfqvuV6COMDg4yI4dO1i0aBGDg4OcffbZ9Pf3Mzg42OqhSZPi7JIard5z5DOBEyJiJvAy4GngPOArxf13AhcXt5cW2xT3nx/1XjNyGvEddrle9apXsXLlSvbs2UNKiT179rBy5Upe9apXtXpo0qQ4u6RGm3KQp5SeAv4M2E41wHcBDwHPp5QOFt12AKcVt08Dniwee7DoP2+qzz+dbNy4kWuuuYY9e/YAsGfPHq655hrDvIH27t3Lrl272L9/PxHB/v372bVrF3v37m310KRJGRwc5Nxzzz2i7dxzz3V2SVNWz9T6XKpH2a8Gnge+DLy93gFFxJXAlQA9PT1UKpV6d1m6lStXsm/fPrq6ugDYv38/e/fuZeXKlZx66qktHl17ePbZZ4kIdu7cCcDOnTuJCJ599tksfkZyZW0b74wzzuDWW2/l9a9/PUNDQ1QqFR5++GHOOOMM612Sdq9rPavW3wY8nlL6CUBE/DXwVuDkiJhZHHWfDjxV9H8KmA/sKKbiTwJ+dvROU0q3A7cDLF68OPX29tYxxOb46U9/yi/+4i/yxS9+cfSc12WXXcbOnTvJYfy5SClx0UUX8f73v5/Pfe5zDAwMAFjjsmy6z9qW4MYbbxw9R97d3U1KiXXr1nHjjTda7zJ0wM9xPUG+HXhLRLwM2AecDzwIbAHeDdwFXA58reg/UGx/u7j/W6mNrv2YUuK8884b3e7p6WnhaNrT7Nmzufbaazl06BDXXnstmzZt4oUXXmj1sKRJGVnQ1tfXN7pwc82aNS5005RNOchTSg9ExFeA7wIHgYepHknfB9wVEX9StG0oHrIB+EJEbAOepbrCvW0888wz426rfocOHTrizdLIqQwpN8uWLWPZsmVUKpW2P1pU+eq6IExKaTWw+qjmHwJvGqPvfuCSep5Pne3QoUPjbktSJ/ISrQ00d+7cI75LklQ2g7xBIoLnnnsOgOeee442+hN5SdI0ZpA3yNHr9tpoHd+0MWPGDGbNmgXArFmzmDHDH19J8kNTlI3Dhw9z+PBhAA4cONDi0UjS9OAhjSRJGTPIJanJ/GwGNZJT65LURH76mRrNIJekJlqzZg2XXXbZEVd2u+yyy7y6m6bMIJekJtq6dSt79uzhjjvuGD0i/8AHPsATTzzR6qEpU54jl6Qmmj17Nn19fUd8HnlfXx+zZ89u9dCUKY/IJamJXnjhBT760Y9y/fXXc+DAAWbNmkV3d7cfAKQp84hc00JEjPtV1mOlZps7dy5DQ0PMmzePGTNmMG/ePIaGhry0s6bMI3JNC8e7Et54gexV9JST3bt309XVxc6dOwHYuXMnM2fOZPfu3S0emXLlEbmycOKJJ06qXZquDh48yMGDB0cvMTxjxozRNmkqDHJlYWho6CWhfeKJJzI0NNSiEUlTFxF0dXUB0NXV5Skg1cUgVzaGhoZIKXFm/72klAxxZSulNPp5AQcOHPD0kOpikEuSlDGDXJKkjBnkkiRlzCCXJCljBrkkSRkzyCVJyphBLklSxrxE6wTUc7GG4z3Wvx+VJNXDIJ8ArwMuSZqunFpvgAsuuGBS7ZIkNYpB3gCbN2/mggsuGD0yjwguuOACNm/e3OKRSZLanUHeIJs3b+bw4cOc2X8vhw8fNsQlSU3hOXJJaiAXx6rZDHJJaiAXx6rZDHJJUsu97mN/x659B0rZ94Lr72v4Pk86YRb/vHp6LGg2yCWpiVJKYx6Vd/rR+K59B/jRTe9s+H4rlQq9vb0N328Zbw6mysVuktRkKSVSSpzZf+/obWmqDHJJkjJmkEuSlDGDXJKkjBnkkiRlzCCXJCljBrkkSRkzyCVJyphBLklSxgxySZIyZpBLkpQxg1ySpIwZ5JIkZcwglyQpYwa5JEkZM8glScqYQS5JUsYMckmSMmaQS5KUsbqCPCJOjoivRMS/RsRgRPxaRJwSEd+MiB8U3+cWfSMiPhkR2yLikYh4Q2NegiRJnaveI/JPAJtSSr8CvA4YBK4H7k8pnQXcX2wDXAicVXxdCXy6zueWJKnjTTnII+Ik4NeBDQAppRdSSs8DS4E7i253AhcXt5cCn09V3wFOjohTpzxySZLEzDoe+2rgJ8DnIuJ1wEPANUBPSunpos9OoKe4fRrwZM3jdxRtT9e0ERFXUj1ip6enh0qlUscQWyPHMefGGjeHdS6fNX5RGbUYGhoqrcbT5d+uniCfCbwB6EspPRARn+DFaXQAUkopItJkdppSuh24HWDx4sWpt7e3jiG2wKb7yG7MubHGo173sb9j174Dpe3/dzbtafg+TzphFv+8+oKG7zdL/iy/qKRaVCqVcmo8jf7t6gnyHcCOlNIDxfZXqAb5MxFxakrp6WLq/MfF/U8B82sef3rRJmmKdu07wI9uemcp+y7rF+CC6+9r+D6lTjblc+QppZ3AkxHxy0XT+cBWYAC4vGi7HPhacXsA+O1i9fpbgF01U/CSJGkK6jkiB+gD/ioiZgM/BN5P9c3B3RGxHHgCeE/R9xvAO4BtwN6iryRJqkNdQZ5S+h6weIy7zh+jbwI+WM/zSZKkI9V7RC5JUt1efvb1nHPn9cfvOBV3Hr/LZL38bIBy1qdMlkEuSWq5fx+8qZSFm52waNNrrUuSlDGDXJKkjDm1rtKUebGSsqa1vFiJpNwY5CpNWRcrKe1KTUyv816aHsq+el4ZP3O+Ie0sBrkkjcOr52m68xy5JEkZM8glScqYQS5JUsYMckmSMmaQS5KUMYNckqSMGeSSJGWsY/+OPLerjnmBB0nSWDo2yHO76pgXeJAkjaVjg1ySJqLUz8mGtv+sbJXPIJekcZT1OdngDJ4aw8VukiRlzCCXJCljBrkkSRnzHLlKU+oioRIWCIGLhCTlxyBXacpaJFTWAiFwkZCk/BjkUsb80yhJBrmUMf80SpKL3SRJyphBLklSxgxySZIyZpBLkpQxF7tJ0nGUukBvUzkfe6zOYZBL0jjK+qsAqL5BKHP/uSntDVObv1kyyCVJLVfWG5pOeLPkOXJJkjLWsUfkuV0H3KthSZLG0rFBntt1wL0aliRpLE6tS5KUMYNckqSMGeSSJGXMIJckKWMdu9hNzZHTBR5gel3kQZImwiBXabzAgySVz6l1SZIyZpBLkpQxp9alzPnJXFJnM8iljPnJXJKcWpckKWMGuSRJGTPIJUnKWEefI8/pYiUuEJIkjaVjg9yLlUiS2kHdU+sR0RURD0fEvcX2qyPigYjYFhFfiojZRfucYntbcf+Cep9bkqRO14hz5NcAgzXba4GPp5ReAzwHLC/alwPPFe0fL/pJkqQ61BXkEXE68E7gs8V2AOcBXym63AlcXNxeWmxT3H9+0V+SJE1RvefI/xz4b8DLi+15wPMppYPF9g7gtOL2acCTACmlgxGxq+j/09odRsSVwJUAPT09VCqVOofYfDmOOTfWuDmsc/mscfnavcZTDvKI+E3gxymlhyKit1EDSindDtwOsHjx4tTb27BdN8em+8huzLmxxs1hnctnjcvXATWu54j8rcBFEfEOoBv4eeATwMkRMbM4Kj8deKro/xQwH9gRETOBk4Cf1fH8kiR1vCmfI08p/UFK6fSU0gLgUuBbKaX3AluAdxfdLge+VtweKLYp7v9WSilN9fklSVI5V3brB1ZFxDaq58A3FO0bgHlF+yrg+hKeW5KkjtKQC8KklCpApbj9Q+BNY/TZD1zSiOeTJElVXmtdkqSMGeSSJGXMIJckKWMd+6EpktQqtRe1jOJi1f4Rj6bKI3JJaqJjXZnaK1ZrqgxySZIy5tS6JDVQPUfWx3us0+8ai0EudYipBExM4sOGDZmq49VhvH8Ha6ipcGpd6hAppUl9bdmyZVL9JbWGQS5JUsYMckmSMmaQS5KUMYNckqSMGeSSJGXMIJckKWMGuSRJGfOCMBMw2QtpeBENSVKzeEQ+AV5EQ5I0XRnkkiRlzKl1TQuevpCkqfGIXNOCpy/UKebPnz+pdul4DHJJaqLt27e/JLTnz5/P9u3bWzQi5c4gl6Qm2759+xGzS4a46mGQS5KUMYNckqSMGeSSJGXMIJckKWMGuSRJGTPIJUnKmEEuSVLGDHJJkjJmkEuSlDGDXJKkjBnkkiRlzCCXJCljBrkkSRkzyCVJyphBLklSxgxySZIyZpBLkpQxg1ySpIwZ5JIkZcwglyQpYwa5JEkZM8glScqYQS5JUsYMckmSMmaQS5KUMYNckqSMGeSSJGVsykEeEfMjYktEbI2I70fENUX7KRHxzYj4QfF9btEeEfHJiNgWEY9ExBsa9SIkSepU9RyRHwSuSyktBN4CfDAiFgLXA/enlM4C7i+2AS4Eziq+rgQ+XcdzS5Ik6gjylNLTKaXvFrf/HRgETgOWAncW3e4ELi5uLwU+n6q+A5wcEadOeeSSJKkx58gjYgHweuABoCel9HRx106gp7h9GvBkzcN2FG2SJGmKZta7g4j4OeCrwLUppd0RMXpfSilFRJrk/q6kOvVOT08PlUql3iE21dDQUHZjzo01bg7rXD5r3BztXuO6gjwiZlEN8b9KKf110fxMRJyaUnq6mDr/cdH+FDC/5uGnF21HSCndDtwOsHjx4tTb21vPEJuuUqmQ25hzY42bwzqXzxo3wab72r7G9axaD2ADMJhSuqXmrgHg8uL25cDXatp/u1i9/hZgV80UvCRJmoJ6jsjfCrwPeDQivle03QDcBNwdEcuBJ4D3FPd9A3gHsA3YC7y/jueWJEnUEeQppX8E4hh3nz9G/wR8cKrPJ0mSXsoru0mSlLG6V61LktRMtX8dNaH+ayfetzp5nBePyCVJWUkpTfhry5Ytk+qfI4NckqSMObUuSWo7Y02/53rEfTwekUuS2kptiH/gAx8Ys72dGOSSpLaUUuJ973tf2x6JjzDIJUltZ+3ateNutxODXJLUdvr7+8fdbicGuSSpLUUEX/jCF9r23PgIg1yS1FZqz4nfcccdY7a3E4NcktRWZsyoRlt3dze33nor3d3dR7S3m/Z8VZKkjpVSoru7m3379vHa176Wffv20d3d7RG5JEm5qFQq4263E4NcktR2ent7x91uJ16iVZLUViKC/fv3v2S1eruuXveIXJLUVhYtWjSp9twZ5JKktvLoo49y0UUXHfExphdddBGPPvpoq4dWCoNcktR2NmzYMO52OzHIJUltZ/ny5eNutxODXJLUVs455xwGBgZYunQpzz//PEuXLmVgYIBzzjmn1UMrhavWJUlt5ZFHHmHevHkMDAwwMDAAwCmnnMIjjzzS4pGVwyNySVJb6evrY/fu3dx888387d/+LTfffDO7d++mr6+v1UMrhUEuSWor69evZ+3ataxatYru7m5WrVrF2rVrWb9+fauHVgqDXJLUVoaHh1mxYsURbStWrGB4eLhFIyqXQS5Jaitz5szhtttuO6LttttuY86cOS0aUblc7CZJaitXXHEF/f39ACxcuJBbbrmF/v7+lxyltwuDXJLUVtatW8ff//3fc9111422nXPOOaxbt66FoyqPU+uSpLbS19fH4ODgEavWBwcHXbUuSVIOXLUuSVLGXLUuSVLGXLUuSVLGXLUuSVLGXLUuSVLGXLUuSVLGXLUuSVLGXLUuSVLGXLUuSVLGXLUuSVLGXLUuSVLGXLUuSVLGXLUuSVLGXLUuSVLGXLUuSVLGXLUuSVLGRlan33DDDQwPDzNnzhxWrFjhqnVJknKxbt069u/fz5YtW9i/f3/bhjgY5JIkZc0glyQpYwa5JEkZM8glScpY01etR8TbgU8AXcBnU0o3NXsMZYiIl7SllFowkvZljZvDOpfPGpevk2rc1CPyiOgC/gK4EFgILIuIhc0cQxlqf2BWr149Zrvqc6xaWuPGqq3n1VdfPWa76lNby9mzZ4/Zrvp02u+LZk+tvwnYllL6YUrpBeAuYGmTx1CalBK9vb1t+65vOkgpsWXLFmtcspQSl1xyiXUuUUqJzZs3W+MSdcrvi2ZPrZ8GPFmzvQN4c22HiLgSuBKgp6eHSqXStMHVY/Xq1VQqFYaGhqhUKqxevZqPfexj2Yw/F7U1rm1T41x99dVH1Pnqq6/mU5/6lHVuoNmzZx9R49mzZ/PCCy9Y4wbrlN8X0cx3KhHxbuDtKaXfLbbfB7w5pfShsfovXrw4Pfjgg00b31SNTNeklKhUKvT29h7RpvpZ4+awzuWzxuXLvcYR8VBKafFE+zd7av0pYH7N9ulFW1uICCqVStueh5kOIoIlS5ZY45JFBF/+8petc4kigt/4jd+wxiXqlN8XzT4inwk8BpxPNcD/CbgspfT9sfrnckQOnbVCslWscXNY5/JZ4/LlXONpfUSeUjoIfAjYDAwCdx8rxHOTUjpiYUUuPzA5scbNYZ3LZ43L10k1bvrfkaeUvgF8o9nPK0lSO/LKbpIkZcwglyQpYwa5JEkZM8glScqYQS5JUsYMckmSMmaQS5KUMYNckqSMGeSSJGWsqddan6yI+AnwRKvHMUmvAH7a6kG0OWvcHNa5fNa4fDnW+MyU0i9MtPO0DvIcRcSDk7nYvSbPGjeHdS6fNS5fJ9TYqXVJkjJmkEuSlDGDvPFub/UAOoA1bg7rXD5rXL62r7HnyCVJyphH5JIkZcwglyQpY20X5BGRIuLmmu3fj4iPFrf/MiLefVT/oXH2taDYX19N260R8TvF7YiIP4yIH0TEYxGxJSJeW9z3QER8LyK2R8RPitvfK/Y5s2i7aQKvZ1ZE3FQ8x3cj4tsRcWFx348i4qs1fd8dEX85wVJNWQfW+BU1fXsj4t6J1mqq2rDGlWIfUdP2NxExFBHn1Oz32Yh4vLj9vydesalp0zq/5E+tIuJNEfEPEfFvEfFwRHw2Il7WofX5t4j454j4p4j41Zr7fhQRj9bs+5M1r/Px4jGPRcTnI+L0o/Z7cfHafuWo9nHrXvwf+M5RjzlmHY6l7YIcGAbeFTW/fOv0Y+CaiJg9xn0fBP4j8LqU0n8A/icwEBHdKaU3p5R+FfjvwJdSSr9afP0I+M/AY8Altb/YjuGPgVOBRSmlNwAXAy+vuf+NEbGwnhc4BZ1W41ZotxoDPA+8FSAiTqZac1JKj47sFxgAPlxsv62uVzwx7VjnI0RED/BloD+l9MsppdcDm5jYz3g71ue9KaXXAZ8C/vSo+5bU7HtlTfuHi8f8MvAw8K2jXsMy4B+L78Dx6178H3gjcFJE/NJE6nCsF9SOQX6Q6irF32vQ/n4C3A9cPsZ9/cCHUkp7AVJKfwf8X+C9x9nnMuATwHbg147VqXjndgXQl1IaLp7jmZTS3TXdbgY+MrGX0jCdVuNWaJsa17gLuLS4/S7gryfwmLK1Y52P9kHgzpTSt0caUkpfSSk9M4HHtnN9vg2cNon+pKqPAzuBkVm7nwPOBZbz4s83HL/u7wK+zpH/L2AKdWjHIAf4C+C9EXFSg/a3Fvj9iOgaaYiInwdOTCn98Ki+DwLHnAYp3lW9jeo/4EZq3sGN4TXA9pTS7nH63A28ISJeM/5LaLhOqvGWkek24LPjv4yGapcaj7gf+PXi+S8FvjS54Zem3ep8tEXAQ1N43Ih2rc/bgb85qm30/3pEjPfm5bvAyDT6UmBTSukx4GcR8cai/Xh1X1aMeXTcU61DWwZ58Uv588DKo+8aq/sE9vdD4AHgsvpHx28CW1JK+4CvAhfX/kBPwSGq00N/0ICxTViH1Xh0ug343QaMb0LasMaHqE4/XgqcUEyLtlwb1rmh2rA+fxURj1OdyfyLo+6rnVr/+Dj7qJ3CX0b1qJri+3HfTBTT7mcB/1i8ATgQEYuO97hjacsgL/w51amOE2vafgbMHdmIiFOY+MX0b6Q65REw+sO956hzG1A95/H9cfazDHhbRPyI6ru1ecB5x+i7DTijeJc2ni8Avw7MP06/RuukGrdKO9S41l3AJ6nOJE0n7VbnWt8vnqce7VSf9wK/BNwJrJvgeI/2emCweM3nAZ8txvBh4D3Fufrx6v4eqrV7vHjcAmDZVOvQtkGeUnqW6i+L5TXNFeC3ahYp/A6wZYL7+1dgK/Bfapr/FPhkRJwAEBFvo3qu5Itj7aMIi/8EnJFSWpBSWkD1PMqY7+CKcyQbgE+MjDkifiEiLjmq3wHg4zTuPNaEdFKNW6UdanyU/0N18c7GiYy3WdqwzrVuBS6PiDfX7PtdxVHhhLRbfVJKCfgj4C1x1Erz8UTVSqoLNTcB7wa+kFI6sxjDfODxYlzj1X0Z8Paacb+RF8+TT6oOADMn+gIydTPwoZGNlNK9xfmLhyLiEPD/gBWT2N8aqisWR6yj+q7q0WJ/O4GlxTTPWP4r8K2RRVWFrwH/KyLmHNU+4g+BPwG2RsR+YA/VlZtH21D0bbZOqnGrtEONR8aegD+bxFibqV3qfF9EHChufzuldElEXAr8WUS8EjgM/APVIJqMdqnPyPj3RfVP6z7Mi29QthTPDfBISum3i9t/GhF/BLwM+A7VKfgXImIZ1XP+tb5K9ej6qmPU/V+BM4v9jIzl8YjYVYT+ZOvgJVolScpZ206tS5LUCdp9an1CIuIcqgvGag2nlN48Vv+SxnAP8OqjmvtTSpubNYYyWePyWePmsM7jsz7N59S6JEkZc2pdkqSMGeSSJGXMIJckKWMGuSRJGTPIJUnK2P8Hiabhttlbi9AAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 576x432 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "2djNWljD5QhG"
      },
      "source": [
        "**Exercícios:**"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "VqN9z9wV5T50"
      },
      "source": [
        "\n",
        "\n",
        "1.   Avaliar o proporção de inscritos por idade em relação ao todo (números relativos);\n",
        "2.   Avaliar de quais estados são os inscritos com 13 anos;\n",
        "3.   Modificar o Histograma para que reporte o Título junto ao gráfico;\n",
        "4.   Plotar dois Histogramas (um acima e outro abaixo) para treineiros e não treineiros;\n",
        "5.   Comparar as distribuições (Histograma ou Boxplot) em Inglês e Espanhol;\n",
        "6.   Explorar a documentaçãão e as visualizações;\n",
        "\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "M4JEuTe-NPjv"
      },
      "source": [
        "**Resoluções:**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZMD0ZOsRNZyh"
      },
      "source": [
        "# 1.   Avaliar o proporção de inscritos por idade em relação ao todo (números relativos);"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Jnzh80fsNiPz"
      },
      "source": [
        "# 2.   Avaliar de quais estados são os inscritos com 13 anos;"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "qKFBFtfONi_V"
      },
      "source": [
        "# 3.   Modificar o Histograma para que reporte o Título junto ao gráfico;"
      ],
      "execution_count": 20,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "P4Kr71HlNlQP"
      },
      "source": [
        "# 4.   Plotar dois Histogramas (um acima e outro abaixo) para treineiros e não treineiros;"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YJvih4zaNmho"
      },
      "source": [
        "# 5.   Comparar as distribuições (Histograma ou Boxplot) em Inglês e Espanhol;"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "uMHm77PCNnJQ"
      },
      "source": [
        "# 6.   Explorar a documentaçãão e as visualizações;"
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}