bdeducacao.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyNnASb6Qmq9HUmrJ5LhdHU6",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/nadiduno/linkColabGoogle/blob/main/bdeducacao.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "#Dados do Sistema Educacional Brasileiro (SEB)\n",
        "\n",
        "<br> Quantidade de alunos estrangeiros por nacionalidade\n",
        "[Dados disponível em](https://dados.educacao.sp.gov.br/dataset/quantidade-de-alunos-estrangeiros-por-nacionalidade)\n",
        "\n",
        "<br>O banco de dados de Alunos Estrangeiros por Nacionalidade apresenta o número de alunos estrangeiros matriculados em todas as redes de ensino do Estado, por nacionalidade.\n",
        "\n",
        "<br>Grupo de Estudo | Dados | Toti Diversidade - Agosto/2023"
      ],
      "metadata": {
        "id": "VmsERvFvIzwN"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "#Importando Bibliotecas"
      ],
      "metadata": {
        "id": "HCPJaHvXI5ns"
      }
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "QYFgYxW5fgq8"
      },
      "outputs": [],
      "source": [
        "#Importing depending libraries to read csv files\n",
        "from pandas.io.parsers.readers import read_csv\n",
        "import pandas as pd\n",
        "import matplotlib.pyplot as plt #para fazer os gráficos\n",
        "from sklearn.preprocessing import LabelEncoder"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "#Importando Dados"
      ],
      "metadata": {
        "id": "AJ_sUVj4JEef"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "## Dataset is now stored in a Pandas Dataframe\n",
        "\n",
        "url_2019_1 = 'https://raw.githubusercontent.com/juan-jm90/Analise_grupo_de_estudos/main/VW_ALUNOS_ESTRANGEIROS_POR_NACIONALIDADE_20190517.csv'\n",
        "\n",
        "url_2020_1 = 'https://raw.githubusercontent.com/juan-jm90/Analise_grupo_de_estudos/main/VW_ALUNOS_ESTRANGEIROS_POR_NACIONALIDADE_31012020.csv'\n",
        "\n",
        "url_2020_2 = 'https://raw.githubusercontent.com/juan-jm90/Analise_grupo_de_estudos/main/VW_ALUNOS_ESTRANGEIROS_POR_NACIONALIDADE_31122020.csv'\n",
        "\n",
        "url_2021_1 = 'https://raw.githubusercontent.com/juan-jm90/Analise_grupo_de_estudos/main/VW_MENSAL_ALUNOS_ESTRANGEIROS_POR_NACIONALIDADE_31032021.csv'\n",
        "\n",
        "url_2021_2 = 'https://raw.githubusercontent.com/juan-jm90/Analise_grupo_de_estudos/main/Estrangeiros_por_nacionalidade_2021_2.csv'\n",
        "\n",
        "url_2022_1 = 'https://raw.githubusercontent.com/juan-jm90/Analise_grupo_de_estudos/main/Estrangeiros_por_nacionalidade_2022_1.csv'\n"
      ],
      "metadata": {
        "id": "8W5NIpUzgO7k"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#Reading the files uploades with the read csv methods\n",
        "df_2019_1 = pd.read_csv(url_2019_1, encoding='utf-8', sep=\";\")\n",
        "df_2020_1 = pd.read_csv(url_2020_1, encoding='utf-8', sep=\";\")\n",
        "df_2020_2 = pd.read_csv(url_2020_2,  encoding='utf-8', sep=\";\")\n",
        "df_2021_1 = pd.read_csv(url_2021_1,  encoding='utf-8', sep=\";\")\n",
        "df_2021_2 = pd.read_csv(url_2021_2,  encoding='latin-1', sep=\";\")\n",
        "df_2022_1 = pd.read_csv(url_2022_1,  encoding='latin-1', sep=\";\")"
      ],
      "metadata": {
        "id": "kfbinKETgV2H"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "#Tratando os Dados"
      ],
      "metadata": {
        "id": "O6CaSJJGJJm2"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#changing in table df_2019_1 the column name \"N° alunos\" para \"N° ALUNOS\"\n",
        "df_2019_1_ren = df_2019_1.rename(columns={\"Nº alunos\":\"Nº ALUNOS\"})"
      ],
      "metadata": {
        "id": "q2wNPSzCgltx"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#Adicionando o ano nas tabelas\n",
        "df_2019_1_ano = df_2019_1_ren.assign(ANO= 2019)\n",
        "df_2020_1_ano = df_2020_1.assign(ANO= 2020)\n",
        "df_2020_2_ano = df_2020_2.assign(ANO= 2020)\n",
        "df_2021_1_ano = df_2021_1.assign(ANO= 2021)\n",
        "df_2021_2_ano = df_2021_2.assign(ANO= 2021)\n",
        "df_2022_1_ano = df_2022_1.assign(ANO= 2022)\n"
      ],
      "metadata": {
        "id": "wYYi7tYqgy_h"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#Concatenar tabelas\n",
        "lista_tabelas = [df_2019_1_ano, df_2020_1_ano, df_2020_2_ano, df_2021_1_ano, df_2021_2_ano, df_2022_1_ano]\n",
        "tabela_todos = pd.concat(lista_tabelas)\n",
        "tabela_todos"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "CDnWWWV_g3pW",
        "outputId": "19ad221f-a7c2-41e3-add4-5c58dd665775"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                 NOMEDEP              DE           DISTR        MUN  TIPOESC  \\\n",
              "0      ESTADUAL - OUTROS  CAMPINAS LESTE  CAMPINAS LESTE   CAMPINAS       27   \n",
              "1      ESTADUAL - OUTROS    CENTRO OESTE  RAPOSO TAVARES  SAO PAULO       11   \n",
              "2      ESTADUAL - OUTROS      CENTRO SUL      BELA VISTA  SAO PAULO       11   \n",
              "3      ESTADUAL - OUTROS        SOROCABA        SOROCABA   SOROCABA       11   \n",
              "4      ESTADUAL - OUTROS         TAUBATE        CACAPAVA   CACAPAVA       11   \n",
              "...                  ...             ...             ...        ...      ...   \n",
              "13825  ESTADUAL - OUTROS         JUNDIAI         JUNDIAI    JUNDIAI       11   \n",
              "13826  ESTADUAL - OUTROS         LESTE 5      ARICANDUVA  SAO PAULO       11   \n",
              "13827  ESTADUAL - OUTROS         LESTE 5      ARICANDUVA  SAO PAULO       11   \n",
              "13828  ESTADUAL - OUTROS         LESTE 4     ARTUR ALVIM  SAO PAULO       11   \n",
              "13829  ESTADUAL - OUTROS         LESTE 4     ARTUR ALVIM  SAO PAULO       11   \n",
              "\n",
              "       COD_ESC                                 NOMESC    DS_PAIS  Nº ALUNOS  \\\n",
              "0        45949  CAMPINAS COLEGIO TECNICO DE - UNICAMP     França          1   \n",
              "1       438820                    RAPOSO TAVARES ETEC  Argentina          1   \n",
              "2       299364         MARIA AUGUSTA SARAIVA DRA ETEC    Bolívia          2   \n",
              "3        16354           RUBENS DE FARIA E SOUZA ETEC       Peru          1   \n",
              "4        14308                  MACHADO DE ASSIS ETEC   Portugal          1   \n",
              "...        ...                                    ...        ...        ...   \n",
              "13825    45986        VASCO ANTONIO VENCHIARUTTI ETEC   Colômbia          1   \n",
              "13826   405243                   VILA FORMOSA ETEC DE     Angola          1   \n",
              "13827   405243                   VILA FORMOSA ETEC DE    Bolívia          1   \n",
              "13828   925871                        ZONA LESTE ETEC    Bolívia          3   \n",
              "13829   925871                        ZONA LESTE ETEC      Japão          1   \n",
              "\n",
              "        ANO  \n",
              "0      2019  \n",
              "1      2019  \n",
              "2      2019  \n",
              "3      2019  \n",
              "4      2019  \n",
              "...     ...  \n",
              "13825  2022  \n",
              "13826  2022  \n",
              "13827  2022  \n",
              "13828  2022  \n",
              "13829  2022  \n",
              "\n",
              "[70574 rows x 10 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-4da64082-fe0b-441a-9da5-13fd6ebbcdc9\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>NOMEDEP</th>\n",
              "      <th>DE</th>\n",
              "      <th>DISTR</th>\n",
              "      <th>MUN</th>\n",
              "      <th>TIPOESC</th>\n",
              "      <th>COD_ESC</th>\n",
              "      <th>NOMESC</th>\n",
              "      <th>DS_PAIS</th>\n",
              "      <th>Nº ALUNOS</th>\n",
              "      <th>ANO</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>ESTADUAL - OUTROS</td>\n",
              "      <td>CAMPINAS LESTE</td>\n",
              "      <td>CAMPINAS LESTE</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>27</td>\n",
              "      <td>45949</td>\n",
              "      <td>CAMPINAS COLEGIO TECNICO DE - UNICAMP</td>\n",
              "      <td>França</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>ESTADUAL - OUTROS</td>\n",
              "      <td>CENTRO OESTE</td>\n",
              "      <td>RAPOSO TAVARES</td>\n",
              "      <td>SAO PAULO</td>\n",
              "      <td>11</td>\n",
              "      <td>438820</td>\n",
              "      <td>RAPOSO TAVARES ETEC</td>\n",
              "      <td>Argentina</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>ESTADUAL - OUTROS</td>\n",
              "      <td>CENTRO SUL</td>\n",
              "      <td>BELA VISTA</td>\n",
              "      <td>SAO PAULO</td>\n",
              "      <td>11</td>\n",
              "      <td>299364</td>\n",
              "      <td>MARIA AUGUSTA SARAIVA DRA ETEC</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>2</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ESTADUAL - OUTROS</td>\n",
              "      <td>SOROCABA</td>\n",
              "      <td>SOROCABA</td>\n",
              "      <td>SOROCABA</td>\n",
              "      <td>11</td>\n",
              "      <td>16354</td>\n",
              "      <td>RUBENS DE FARIA E SOUZA ETEC</td>\n",
              "      <td>Peru</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>ESTADUAL - OUTROS</td>\n",
              "      <td>TAUBATE</td>\n",
              "      <td>CACAPAVA</td>\n",
              "      <td>CACAPAVA</td>\n",
              "      <td>11</td>\n",
              "      <td>14308</td>\n",
              "      <td>MACHADO DE ASSIS ETEC</td>\n",
              "      <td>Portugal</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13825</th>\n",
              "      <td>ESTADUAL - OUTROS</td>\n",
              "      <td>JUNDIAI</td>\n",
              "      <td>JUNDIAI</td>\n",
              "      <td>JUNDIAI</td>\n",
              "      <td>11</td>\n",
              "      <td>45986</td>\n",
              "      <td>VASCO ANTONIO VENCHIARUTTI ETEC</td>\n",
              "      <td>Colômbia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13826</th>\n",
              "      <td>ESTADUAL - OUTROS</td>\n",
              "      <td>LESTE 5</td>\n",
              "      <td>ARICANDUVA</td>\n",
              "      <td>SAO PAULO</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>VILA FORMOSA ETEC DE</td>\n",
              "      <td>Angola</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13827</th>\n",
              "      <td>ESTADUAL - OUTROS</td>\n",
              "      <td>LESTE 5</td>\n",
              "      <td>ARICANDUVA</td>\n",
              "      <td>SAO PAULO</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>VILA FORMOSA ETEC DE</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13828</th>\n",
              "      <td>ESTADUAL - OUTROS</td>\n",
              "      <td>LESTE 4</td>\n",
              "      <td>ARTUR ALVIM</td>\n",
              "      <td>SAO PAULO</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>ZONA LESTE ETEC</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>3</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13829</th>\n",
              "      <td>ESTADUAL - OUTROS</td>\n",
              "      <td>LESTE 4</td>\n",
              "      <td>ARTUR ALVIM</td>\n",
              "      <td>SAO PAULO</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>ZONA LESTE ETEC</td>\n",
              "      <td>Japão</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>70574 rows × 10 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-4da64082-fe0b-441a-9da5-13fd6ebbcdc9')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-df520fa3-0d23-4ba0-a5e6-42149c6271bd\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-df520fa3-0d23-4ba0-a5e6-42149c6271bd')\"\n",
              "              title=\"Suggest charts.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "      </button>\n",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "    <script>\n",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-df520fa3-0d23-4ba0-a5e6-42149c6271bd button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-4da64082-fe0b-441a-9da5-13fd6ebbcdc9 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-4da64082-fe0b-441a-9da5-13fd6ebbcdc9');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 211
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Trocando as maiúsculas\n",
        "dados = tabela_todos.applymap(lambda s:s.lower().capitalize() if type(s) == str else s)\n",
        "dados"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "72o14VJ7hKsM",
        "outputId": "afa1fbcb-00ae-4fbc-cc94-59a26cb03ba8"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                 NOMEDEP              DE           DISTR        MUN  TIPOESC  \\\n",
              "0      Estadual - outros  Campinas leste  Campinas leste   Campinas       27   \n",
              "1      Estadual - outros    Centro oeste  Raposo tavares  Sao paulo       11   \n",
              "2      Estadual - outros      Centro sul      Bela vista  Sao paulo       11   \n",
              "3      Estadual - outros        Sorocaba        Sorocaba   Sorocaba       11   \n",
              "4      Estadual - outros         Taubate        Cacapava   Cacapava       11   \n",
              "...                  ...             ...             ...        ...      ...   \n",
              "13825  Estadual - outros         Jundiai         Jundiai    Jundiai       11   \n",
              "13826  Estadual - outros         Leste 5      Aricanduva  Sao paulo       11   \n",
              "13827  Estadual - outros         Leste 5      Aricanduva  Sao paulo       11   \n",
              "13828  Estadual - outros         Leste 4     Artur alvim  Sao paulo       11   \n",
              "13829  Estadual - outros         Leste 4     Artur alvim  Sao paulo       11   \n",
              "\n",
              "       COD_ESC                                 NOMESC    DS_PAIS  Nº ALUNOS  \\\n",
              "0        45949  Campinas colegio tecnico de - unicamp     França          1   \n",
              "1       438820                    Raposo tavares etec  Argentina          1   \n",
              "2       299364         Maria augusta saraiva dra etec    Bolívia          2   \n",
              "3        16354           Rubens de faria e souza etec       Peru          1   \n",
              "4        14308                  Machado de assis etec   Portugal          1   \n",
              "...        ...                                    ...        ...        ...   \n",
              "13825    45986        Vasco antonio venchiarutti etec   Colômbia          1   \n",
              "13826   405243                   Vila formosa etec de     Angola          1   \n",
              "13827   405243                   Vila formosa etec de    Bolívia          1   \n",
              "13828   925871                        Zona leste etec    Bolívia          3   \n",
              "13829   925871                        Zona leste etec      Japão          1   \n",
              "\n",
              "        ANO  \n",
              "0      2019  \n",
              "1      2019  \n",
              "2      2019  \n",
              "3      2019  \n",
              "4      2019  \n",
              "...     ...  \n",
              "13825  2022  \n",
              "13826  2022  \n",
              "13827  2022  \n",
              "13828  2022  \n",
              "13829  2022  \n",
              "\n",
              "[70574 rows x 10 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-489b9d43-f5e4-4f38-85c8-ccf7fd5e57a3\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>NOMEDEP</th>\n",
              "      <th>DE</th>\n",
              "      <th>DISTR</th>\n",
              "      <th>MUN</th>\n",
              "      <th>TIPOESC</th>\n",
              "      <th>COD_ESC</th>\n",
              "      <th>NOMESC</th>\n",
              "      <th>DS_PAIS</th>\n",
              "      <th>Nº ALUNOS</th>\n",
              "      <th>ANO</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Campinas leste</td>\n",
              "      <td>Campinas leste</td>\n",
              "      <td>Campinas</td>\n",
              "      <td>27</td>\n",
              "      <td>45949</td>\n",
              "      <td>Campinas colegio tecnico de - unicamp</td>\n",
              "      <td>França</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Centro oeste</td>\n",
              "      <td>Raposo tavares</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>438820</td>\n",
              "      <td>Raposo tavares etec</td>\n",
              "      <td>Argentina</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Centro sul</td>\n",
              "      <td>Bela vista</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>299364</td>\n",
              "      <td>Maria augusta saraiva dra etec</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>2</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>11</td>\n",
              "      <td>16354</td>\n",
              "      <td>Rubens de faria e souza etec</td>\n",
              "      <td>Peru</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Taubate</td>\n",
              "      <td>Cacapava</td>\n",
              "      <td>Cacapava</td>\n",
              "      <td>11</td>\n",
              "      <td>14308</td>\n",
              "      <td>Machado de assis etec</td>\n",
              "      <td>Portugal</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13825</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>11</td>\n",
              "      <td>45986</td>\n",
              "      <td>Vasco antonio venchiarutti etec</td>\n",
              "      <td>Colômbia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13826</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Leste 5</td>\n",
              "      <td>Aricanduva</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>Vila formosa etec de</td>\n",
              "      <td>Angola</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13827</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Leste 5</td>\n",
              "      <td>Aricanduva</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>Vila formosa etec de</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13828</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Leste 4</td>\n",
              "      <td>Artur alvim</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>Zona leste etec</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>3</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13829</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Leste 4</td>\n",
              "      <td>Artur alvim</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>Zona leste etec</td>\n",
              "      <td>Japão</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>70574 rows × 10 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-489b9d43-f5e4-4f38-85c8-ccf7fd5e57a3')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-5cfc8ec0-4808-43af-8bb9-9f13ea15bada\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-5cfc8ec0-4808-43af-8bb9-9f13ea15bada')\"\n",
              "              title=\"Suggest charts.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "      </button>\n",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "    <script>\n",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-5cfc8ec0-4808-43af-8bb9-9f13ea15bada button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-489b9d43-f5e4-4f38-85c8-ccf7fd5e57a3 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-489b9d43-f5e4-4f38-85c8-ccf7fd5e57a3');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 212
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Usando o DIC para renomear as columnas\n",
        "dados.rename(columns={'NOMEDEP': 'Clasificaçõ','DE': 'Dependência','DISTR': 'Distrito','MUN': 'Município','TIPOESC': 'Tipo da Escola','COD_ESC': 'Código da Escola','NOMESC': 'Nome Escola','DS_PAIS': 'País de Origem','Nº ALUNOS': 'Número de alunos','ANO': 'Ano'}, inplace=True)\n",
        "dados"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "fBriZjrjkD5j",
        "outputId": "a51962e7-a856-44dc-81dd-df307e1257ce"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "             Clasificaçõ     Dependência        Distrito  Município  \\\n",
              "0      Estadual - outros  Campinas leste  Campinas leste   Campinas   \n",
              "1      Estadual - outros    Centro oeste  Raposo tavares  Sao paulo   \n",
              "2      Estadual - outros      Centro sul      Bela vista  Sao paulo   \n",
              "3      Estadual - outros        Sorocaba        Sorocaba   Sorocaba   \n",
              "4      Estadual - outros         Taubate        Cacapava   Cacapava   \n",
              "...                  ...             ...             ...        ...   \n",
              "13825  Estadual - outros         Jundiai         Jundiai    Jundiai   \n",
              "13826  Estadual - outros         Leste 5      Aricanduva  Sao paulo   \n",
              "13827  Estadual - outros         Leste 5      Aricanduva  Sao paulo   \n",
              "13828  Estadual - outros         Leste 4     Artur alvim  Sao paulo   \n",
              "13829  Estadual - outros         Leste 4     Artur alvim  Sao paulo   \n",
              "\n",
              "       Tipo da Escola  Código da Escola  \\\n",
              "0                  27             45949   \n",
              "1                  11            438820   \n",
              "2                  11            299364   \n",
              "3                  11             16354   \n",
              "4                  11             14308   \n",
              "...               ...               ...   \n",
              "13825              11             45986   \n",
              "13826              11            405243   \n",
              "13827              11            405243   \n",
              "13828              11            925871   \n",
              "13829              11            925871   \n",
              "\n",
              "                                 Nome Escola País de Origem  Número de alunos  \\\n",
              "0      Campinas colegio tecnico de - unicamp         França                 1   \n",
              "1                        Raposo tavares etec      Argentina                 1   \n",
              "2             Maria augusta saraiva dra etec        Bolívia                 2   \n",
              "3               Rubens de faria e souza etec           Peru                 1   \n",
              "4                      Machado de assis etec       Portugal                 1   \n",
              "...                                      ...            ...               ...   \n",
              "13825        Vasco antonio venchiarutti etec       Colômbia                 1   \n",
              "13826                   Vila formosa etec de         Angola                 1   \n",
              "13827                   Vila formosa etec de        Bolívia                 1   \n",
              "13828                        Zona leste etec        Bolívia                 3   \n",
              "13829                        Zona leste etec          Japão                 1   \n",
              "\n",
              "        Ano  \n",
              "0      2019  \n",
              "1      2019  \n",
              "2      2019  \n",
              "3      2019  \n",
              "4      2019  \n",
              "...     ...  \n",
              "13825  2022  \n",
              "13826  2022  \n",
              "13827  2022  \n",
              "13828  2022  \n",
              "13829  2022  \n",
              "\n",
              "[70574 rows x 10 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-20af99c5-a528-4615-8965-7cac54860dc8\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Clasificaçõ</th>\n",
              "      <th>Dependência</th>\n",
              "      <th>Distrito</th>\n",
              "      <th>Município</th>\n",
              "      <th>Tipo da Escola</th>\n",
              "      <th>Código da Escola</th>\n",
              "      <th>Nome Escola</th>\n",
              "      <th>País de Origem</th>\n",
              "      <th>Número de alunos</th>\n",
              "      <th>Ano</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Campinas leste</td>\n",
              "      <td>Campinas leste</td>\n",
              "      <td>Campinas</td>\n",
              "      <td>27</td>\n",
              "      <td>45949</td>\n",
              "      <td>Campinas colegio tecnico de - unicamp</td>\n",
              "      <td>França</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Centro oeste</td>\n",
              "      <td>Raposo tavares</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>438820</td>\n",
              "      <td>Raposo tavares etec</td>\n",
              "      <td>Argentina</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Centro sul</td>\n",
              "      <td>Bela vista</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>299364</td>\n",
              "      <td>Maria augusta saraiva dra etec</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>2</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>11</td>\n",
              "      <td>16354</td>\n",
              "      <td>Rubens de faria e souza etec</td>\n",
              "      <td>Peru</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Taubate</td>\n",
              "      <td>Cacapava</td>\n",
              "      <td>Cacapava</td>\n",
              "      <td>11</td>\n",
              "      <td>14308</td>\n",
              "      <td>Machado de assis etec</td>\n",
              "      <td>Portugal</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13825</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>11</td>\n",
              "      <td>45986</td>\n",
              "      <td>Vasco antonio venchiarutti etec</td>\n",
              "      <td>Colômbia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13826</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Leste 5</td>\n",
              "      <td>Aricanduva</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>Vila formosa etec de</td>\n",
              "      <td>Angola</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13827</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Leste 5</td>\n",
              "      <td>Aricanduva</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>Vila formosa etec de</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13828</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Leste 4</td>\n",
              "      <td>Artur alvim</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>Zona leste etec</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>3</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13829</th>\n",
              "      <td>Estadual - outros</td>\n",
              "      <td>Leste 4</td>\n",
              "      <td>Artur alvim</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>Zona leste etec</td>\n",
              "      <td>Japão</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>70574 rows × 10 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-20af99c5-a528-4615-8965-7cac54860dc8')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-10992d66-f3a6-453e-a712-b83022a09545\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-10992d66-f3a6-453e-a712-b83022a09545')\"\n",
              "              title=\"Suggest charts.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "      </button>\n",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "    <script>\n",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-10992d66-f3a6-453e-a712-b83022a09545 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-20af99c5-a528-4615-8965-7cac54860dc8 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-20af99c5-a528-4615-8965-7cac54860dc8');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 213
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Conhecendo os dados\n",
        "print('Clasificaçõ')\n",
        "dados['Clasificaçõ'].value_counts()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "0qcl0nfhoTvg",
        "outputId": "f8a5dfa6-b9df-4b11-8f53-320786484b0b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Clasificaçõ\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Estadual - se        30631\n",
              "Municipal            20378\n",
              "Privada              18545\n",
              "Estadual - outros     1013\n",
              "Federal                  7\n",
              "Name: Clasificaçõ, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 214
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#O sistema se classifica em Estadual, Municipal, Privada e Federal, vamos a remplazar\n",
        "dados['Clasificaçõ'] = dados['Clasificaçõ'].str.replace('Estadual - se', 'Estadual')\n",
        "dados['Clasificaçõ'] = dados['Clasificaçõ'].str.replace('Estadual - outros', 'Estadual')\n",
        "print('Clasificaçõ')\n",
        "dados['Clasificaçõ'].value_counts()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "WF32MrRlrJFE",
        "outputId": "278d9507-bfae-4ed3-ea27-549905a29884"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Clasificaçõ\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Estadual     31644\n",
              "Municipal    20378\n",
              "Privada      18545\n",
              "Federal          7\n",
              "Name: Clasificaçõ, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 215
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "print('País de Origem')\n",
        "dados['País de Origem'].value_counts()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "q81hcggWpnnx",
        "outputId": "430f266a-6ad8-4a2e-bf4a-d9f3c3f03db7"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "País de Origem\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Venezuela    10843\n",
              "Bolívia       9941\n",
              "Japão         7626\n",
              "Haiti         6339\n",
              "Colômbia      3628\n",
              "             ...  \n",
              "Sri lanka        1\n",
              "Etiópia          1\n",
              "Botswana         1\n",
              "Fiji             1\n",
              "Kuwait           1\n",
              "Name: País de Origem, Length: 188, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 216
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Verificando não ter campos vazios, se retorna true tem campos vazios nessa columna\n",
        "dados['Clasificaçõ'].isna().any()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "rTsrQjin0E86",
        "outputId": "df40d24e-d976-4c0f-b61e-19c41d0521b7"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "False"
            ]
          },
          "metadata": {},
          "execution_count": 217
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "print(f\"Quantidades de registros \\n{len(dados)} \\n\")\n",
        "print(f\"Estatísticas geral dos dados \\n\\n\")\n",
        "dados.describe(include='all').head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 311
        },
        "id": "3ec5vFj_ukpo",
        "outputId": "3662042e-7d9e-4932-f695-0bb03d136828"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Quantidades de registros \n",
            "70574 \n",
            "\n",
            "Estatísticas geral dos dados \n",
            "\n",
            "\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       Clasificaçõ Dependência  Distrito  Município  Tipo da Escola  \\\n",
              "count        70574       70574     70574      70574    70574.000000   \n",
              "unique           4          92       647        482             NaN   \n",
              "top       Estadual      Centro  Sorocaba  Sao paulo             NaN   \n",
              "freq         31644        3358      1636      24065             NaN   \n",
              "mean           NaN         NaN       NaN        NaN        5.504152   \n",
              "\n",
              "        Código da Escola                                    Nome Escola  \\\n",
              "count       70574.000000                                          70574   \n",
              "unique               NaN                                          12317   \n",
              "top                  NaN  Penitenciaria cabo p m marcelo pires da silva   \n",
              "freq                 NaN                                            176   \n",
              "mean       232835.418794                                            NaN   \n",
              "\n",
              "       País de Origem  Número de alunos           Ano  \n",
              "count           70574      70574.000000  70574.000000  \n",
              "unique            188               NaN           NaN  \n",
              "top         Venezuela               NaN           NaN  \n",
              "freq            10843               NaN           NaN  \n",
              "mean              NaN          2.076105   2020.630827  "
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-13a965cb-7d99-4601-b34e-40c043cd4a67\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Clasificaçõ</th>\n",
              "      <th>Dependência</th>\n",
              "      <th>Distrito</th>\n",
              "      <th>Município</th>\n",
              "      <th>Tipo da Escola</th>\n",
              "      <th>Código da Escola</th>\n",
              "      <th>Nome Escola</th>\n",
              "      <th>País de Origem</th>\n",
              "      <th>Número de alunos</th>\n",
              "      <th>Ano</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>70574</td>\n",
              "      <td>70574</td>\n",
              "      <td>70574</td>\n",
              "      <td>70574</td>\n",
              "      <td>70574.000000</td>\n",
              "      <td>70574.000000</td>\n",
              "      <td>70574</td>\n",
              "      <td>70574</td>\n",
              "      <td>70574.000000</td>\n",
              "      <td>70574.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>unique</th>\n",
              "      <td>4</td>\n",
              "      <td>92</td>\n",
              "      <td>647</td>\n",
              "      <td>482</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12317</td>\n",
              "      <td>188</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>top</th>\n",
              "      <td>Estadual</td>\n",
              "      <td>Centro</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Penitenciaria cabo p m marcelo pires da silva</td>\n",
              "      <td>Venezuela</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>freq</th>\n",
              "      <td>31644</td>\n",
              "      <td>3358</td>\n",
              "      <td>1636</td>\n",
              "      <td>24065</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>176</td>\n",
              "      <td>10843</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.504152</td>\n",
              "      <td>232835.418794</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.076105</td>\n",
              "      <td>2020.630827</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-13a965cb-7d99-4601-b34e-40c043cd4a67')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-9a1a0f5b-85db-44b0-a5a3-ffb0b58e7125\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-9a1a0f5b-85db-44b0-a5a3-ffb0b58e7125')\"\n",
              "              title=\"Suggest charts.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "      </button>\n",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "    <script>\n",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-9a1a0f5b-85db-44b0-a5a3-ffb0b58e7125 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-13a965cb-7d99-4601-b34e-40c043cd4a67 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-13a965cb-7d99-4601-b34e-40c043cd4a67');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 218
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dados\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "3awMOeWupykb",
        "outputId": "85313451-a1e7-49a7-db27-c38cbad3e4f8"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      Clasificaçõ     Dependência        Distrito  Município  Tipo da Escola  \\\n",
              "0        Estadual  Campinas leste  Campinas leste   Campinas              27   \n",
              "1        Estadual    Centro oeste  Raposo tavares  Sao paulo              11   \n",
              "2        Estadual      Centro sul      Bela vista  Sao paulo              11   \n",
              "3        Estadual        Sorocaba        Sorocaba   Sorocaba              11   \n",
              "4        Estadual         Taubate        Cacapava   Cacapava              11   \n",
              "...           ...             ...             ...        ...             ...   \n",
              "13825    Estadual         Jundiai         Jundiai    Jundiai              11   \n",
              "13826    Estadual         Leste 5      Aricanduva  Sao paulo              11   \n",
              "13827    Estadual         Leste 5      Aricanduva  Sao paulo              11   \n",
              "13828    Estadual         Leste 4     Artur alvim  Sao paulo              11   \n",
              "13829    Estadual         Leste 4     Artur alvim  Sao paulo              11   \n",
              "\n",
              "       Código da Escola                            Nome Escola País de Origem  \\\n",
              "0                 45949  Campinas colegio tecnico de - unicamp         França   \n",
              "1                438820                    Raposo tavares etec      Argentina   \n",
              "2                299364         Maria augusta saraiva dra etec        Bolívia   \n",
              "3                 16354           Rubens de faria e souza etec           Peru   \n",
              "4                 14308                  Machado de assis etec       Portugal   \n",
              "...                 ...                                    ...            ...   \n",
              "13825             45986        Vasco antonio venchiarutti etec       Colômbia   \n",
              "13826            405243                   Vila formosa etec de         Angola   \n",
              "13827            405243                   Vila formosa etec de        Bolívia   \n",
              "13828            925871                        Zona leste etec        Bolívia   \n",
              "13829            925871                        Zona leste etec          Japão   \n",
              "\n",
              "       Número de alunos   Ano  \n",
              "0                     1  2019  \n",
              "1                     1  2019  \n",
              "2                     2  2019  \n",
              "3                     1  2019  \n",
              "4                     1  2019  \n",
              "...                 ...   ...  \n",
              "13825                 1  2022  \n",
              "13826                 1  2022  \n",
              "13827                 1  2022  \n",
              "13828                 3  2022  \n",
              "13829                 1  2022  \n",
              "\n",
              "[70574 rows x 10 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-06357294-9a84-4b70-aa3f-f672750c3f58\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Clasificaçõ</th>\n",
              "      <th>Dependência</th>\n",
              "      <th>Distrito</th>\n",
              "      <th>Município</th>\n",
              "      <th>Tipo da Escola</th>\n",
              "      <th>Código da Escola</th>\n",
              "      <th>Nome Escola</th>\n",
              "      <th>País de Origem</th>\n",
              "      <th>Número de alunos</th>\n",
              "      <th>Ano</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Estadual</td>\n",
              "      <td>Campinas leste</td>\n",
              "      <td>Campinas leste</td>\n",
              "      <td>Campinas</td>\n",
              "      <td>27</td>\n",
              "      <td>45949</td>\n",
              "      <td>Campinas colegio tecnico de - unicamp</td>\n",
              "      <td>França</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Estadual</td>\n",
              "      <td>Centro oeste</td>\n",
              "      <td>Raposo tavares</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>438820</td>\n",
              "      <td>Raposo tavares etec</td>\n",
              "      <td>Argentina</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Estadual</td>\n",
              "      <td>Centro sul</td>\n",
              "      <td>Bela vista</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>299364</td>\n",
              "      <td>Maria augusta saraiva dra etec</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>2</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Estadual</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>11</td>\n",
              "      <td>16354</td>\n",
              "      <td>Rubens de faria e souza etec</td>\n",
              "      <td>Peru</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Estadual</td>\n",
              "      <td>Taubate</td>\n",
              "      <td>Cacapava</td>\n",
              "      <td>Cacapava</td>\n",
              "      <td>11</td>\n",
              "      <td>14308</td>\n",
              "      <td>Machado de assis etec</td>\n",
              "      <td>Portugal</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13825</th>\n",
              "      <td>Estadual</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>11</td>\n",
              "      <td>45986</td>\n",
              "      <td>Vasco antonio venchiarutti etec</td>\n",
              "      <td>Colômbia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13826</th>\n",
              "      <td>Estadual</td>\n",
              "      <td>Leste 5</td>\n",
              "      <td>Aricanduva</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>Vila formosa etec de</td>\n",
              "      <td>Angola</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13827</th>\n",
              "      <td>Estadual</td>\n",
              "      <td>Leste 5</td>\n",
              "      <td>Aricanduva</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>Vila formosa etec de</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13828</th>\n",
              "      <td>Estadual</td>\n",
              "      <td>Leste 4</td>\n",
              "      <td>Artur alvim</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>Zona leste etec</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>3</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13829</th>\n",
              "      <td>Estadual</td>\n",
              "      <td>Leste 4</td>\n",
              "      <td>Artur alvim</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>Zona leste etec</td>\n",
              "      <td>Japão</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>70574 rows × 10 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-06357294-9a84-4b70-aa3f-f672750c3f58')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-0eb8894e-137d-4b03-af84-93078b5682d6\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-0eb8894e-137d-4b03-af84-93078b5682d6')\"\n",
              "              title=\"Suggest charts.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "      </button>\n",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "    <script>\n",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-0eb8894e-137d-4b03-af84-93078b5682d6 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-06357294-9a84-4b70-aa3f-f672750c3f58 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-06357294-9a84-4b70-aa3f-f672750c3f58');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 219
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "#Normalizando as tabelas da Base de Dados"
      ],
      "metadata": {
        "id": "eTNXJ6wNI3d1"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Criando novas columnas para os codigos usando labelEncoder\n",
        "#Para normalizar as tabelas da BD\n",
        "dadosBD = dados\n",
        "convertidor = LabelEncoder()"
      ],
      "metadata": {
        "id": "N7rQl4Gl4sgS"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "dadosBD.insert(0, 'Cod Cla', None)\n",
        "dadosBD['Cod Cla'] = convertidor.fit_transform(dadosBD['Clasificaçõ'])\n",
        "dadosBD"
      ],
      "metadata": {
        "id": "biqwP-D7EB5E"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "dadosBD.insert(2, 'Cod Dep', None)\n",
        "dadosBD['Cod Dep'] = convertidor.fit_transform(dadosBD['Dependência'])\n",
        "dadosBD"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "_5uDA6iwBxZv",
        "outputId": "df33e764-d0ca-4db9-812c-db7034250e17"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       Cod Cla Clasificaçõ  Cod Dep     Dependência        Distrito  \\\n",
              "0            0    Estadual       14  Campinas leste  Campinas leste   \n",
              "1            0    Estadual       21    Centro oeste  Raposo tavares   \n",
              "2            0    Estadual       22      Centro sul      Bela vista   \n",
              "3            0    Estadual       80        Sorocaba        Sorocaba   \n",
              "4            0    Estadual       88         Taubate        Cacapava   \n",
              "...        ...         ...      ...             ...             ...   \n",
              "13825        0    Estadual       41         Jundiai         Jundiai   \n",
              "13826        0    Estadual       46         Leste 5      Aricanduva   \n",
              "13827        0    Estadual       46         Leste 5      Aricanduva   \n",
              "13828        0    Estadual       45         Leste 4     Artur alvim   \n",
              "13829        0    Estadual       45         Leste 4     Artur alvim   \n",
              "\n",
              "       Município  Tipo da Escola  Código da Escola  \\\n",
              "0       Campinas              27             45949   \n",
              "1      Sao paulo              11            438820   \n",
              "2      Sao paulo              11            299364   \n",
              "3       Sorocaba              11             16354   \n",
              "4       Cacapava              11             14308   \n",
              "...          ...             ...               ...   \n",
              "13825    Jundiai              11             45986   \n",
              "13826  Sao paulo              11            405243   \n",
              "13827  Sao paulo              11            405243   \n",
              "13828  Sao paulo              11            925871   \n",
              "13829  Sao paulo              11            925871   \n",
              "\n",
              "                                 Nome Escola País de Origem  Número de alunos  \\\n",
              "0      Campinas colegio tecnico de - unicamp         França                 1   \n",
              "1                        Raposo tavares etec      Argentina                 1   \n",
              "2             Maria augusta saraiva dra etec        Bolívia                 2   \n",
              "3               Rubens de faria e souza etec           Peru                 1   \n",
              "4                      Machado de assis etec       Portugal                 1   \n",
              "...                                      ...            ...               ...   \n",
              "13825        Vasco antonio venchiarutti etec       Colômbia                 1   \n",
              "13826                   Vila formosa etec de         Angola                 1   \n",
              "13827                   Vila formosa etec de        Bolívia                 1   \n",
              "13828                        Zona leste etec        Bolívia                 3   \n",
              "13829                        Zona leste etec          Japão                 1   \n",
              "\n",
              "        Ano  \n",
              "0      2019  \n",
              "1      2019  \n",
              "2      2019  \n",
              "3      2019  \n",
              "4      2019  \n",
              "...     ...  \n",
              "13825  2022  \n",
              "13826  2022  \n",
              "13827  2022  \n",
              "13828  2022  \n",
              "13829  2022  \n",
              "\n",
              "[70574 rows x 12 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-1e3871e8-9e53-4f70-a221-84db77f9c399\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Cod Cla</th>\n",
              "      <th>Clasificaçõ</th>\n",
              "      <th>Cod Dep</th>\n",
              "      <th>Dependência</th>\n",
              "      <th>Distrito</th>\n",
              "      <th>Município</th>\n",
              "      <th>Tipo da Escola</th>\n",
              "      <th>Código da Escola</th>\n",
              "      <th>Nome Escola</th>\n",
              "      <th>País de Origem</th>\n",
              "      <th>Número de alunos</th>\n",
              "      <th>Ano</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>14</td>\n",
              "      <td>Campinas leste</td>\n",
              "      <td>Campinas leste</td>\n",
              "      <td>Campinas</td>\n",
              "      <td>27</td>\n",
              "      <td>45949</td>\n",
              "      <td>Campinas colegio tecnico de - unicamp</td>\n",
              "      <td>França</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>21</td>\n",
              "      <td>Centro oeste</td>\n",
              "      <td>Raposo tavares</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>438820</td>\n",
              "      <td>Raposo tavares etec</td>\n",
              "      <td>Argentina</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>22</td>\n",
              "      <td>Centro sul</td>\n",
              "      <td>Bela vista</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>299364</td>\n",
              "      <td>Maria augusta saraiva dra etec</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>2</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>80</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>11</td>\n",
              "      <td>16354</td>\n",
              "      <td>Rubens de faria e souza etec</td>\n",
              "      <td>Peru</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>88</td>\n",
              "      <td>Taubate</td>\n",
              "      <td>Cacapava</td>\n",
              "      <td>Cacapava</td>\n",
              "      <td>11</td>\n",
              "      <td>14308</td>\n",
              "      <td>Machado de assis etec</td>\n",
              "      <td>Portugal</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13825</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>41</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>11</td>\n",
              "      <td>45986</td>\n",
              "      <td>Vasco antonio venchiarutti etec</td>\n",
              "      <td>Colômbia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13826</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>46</td>\n",
              "      <td>Leste 5</td>\n",
              "      <td>Aricanduva</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>Vila formosa etec de</td>\n",
              "      <td>Angola</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13827</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>46</td>\n",
              "      <td>Leste 5</td>\n",
              "      <td>Aricanduva</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>Vila formosa etec de</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13828</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>45</td>\n",
              "      <td>Leste 4</td>\n",
              "      <td>Artur alvim</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>Zona leste etec</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>3</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13829</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>45</td>\n",
              "      <td>Leste 4</td>\n",
              "      <td>Artur alvim</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>Zona leste etec</td>\n",
              "      <td>Japão</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>70574 rows × 12 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1e3871e8-9e53-4f70-a221-84db77f9c399')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-df7545f9-0a9b-40fd-8d65-f8febf8523a5\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-df7545f9-0a9b-40fd-8d65-f8febf8523a5')\"\n",
              "              title=\"Suggest charts.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "      </button>\n",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "    <script>\n",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-df7545f9-0a9b-40fd-8d65-f8febf8523a5 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-1e3871e8-9e53-4f70-a221-84db77f9c399 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-1e3871e8-9e53-4f70-a221-84db77f9c399');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 222
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dadosBD.insert(4, 'Cod Dist', None)\n",
        "dadosBD['Cod Dist'] = convertidor.fit_transform(dadosBD['Distrito'])\n",
        "dadosBD"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "kSbz4hCCB6DE",
        "outputId": "ced910e4-b269-41b9-9404-74bad4f289cf"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       Cod Cla Clasificaçõ  Cod Dep     Dependência  Cod Dist        Distrito  \\\n",
              "0            0    Estadual       14  Campinas leste       111  Campinas leste   \n",
              "1            0    Estadual       21    Centro oeste       479  Raposo tavares   \n",
              "2            0    Estadual       22      Centro sul        66      Bela vista   \n",
              "3            0    Estadual       80        Sorocaba       581        Sorocaba   \n",
              "4            0    Estadual       88         Taubate        97        Cacapava   \n",
              "...        ...         ...      ...             ...       ...             ...   \n",
              "13825        0    Estadual       41         Jundiai       309         Jundiai   \n",
              "13826        0    Estadual       46         Leste 5        38      Aricanduva   \n",
              "13827        0    Estadual       46         Leste 5        38      Aricanduva   \n",
              "13828        0    Estadual       45         Leste 4        40     Artur alvim   \n",
              "13829        0    Estadual       45         Leste 4        40     Artur alvim   \n",
              "\n",
              "       Município  Tipo da Escola  Código da Escola  \\\n",
              "0       Campinas              27             45949   \n",
              "1      Sao paulo              11            438820   \n",
              "2      Sao paulo              11            299364   \n",
              "3       Sorocaba              11             16354   \n",
              "4       Cacapava              11             14308   \n",
              "...          ...             ...               ...   \n",
              "13825    Jundiai              11             45986   \n",
              "13826  Sao paulo              11            405243   \n",
              "13827  Sao paulo              11            405243   \n",
              "13828  Sao paulo              11            925871   \n",
              "13829  Sao paulo              11            925871   \n",
              "\n",
              "                                 Nome Escola País de Origem  Número de alunos  \\\n",
              "0      Campinas colegio tecnico de - unicamp         França                 1   \n",
              "1                        Raposo tavares etec      Argentina                 1   \n",
              "2             Maria augusta saraiva dra etec        Bolívia                 2   \n",
              "3               Rubens de faria e souza etec           Peru                 1   \n",
              "4                      Machado de assis etec       Portugal                 1   \n",
              "...                                      ...            ...               ...   \n",
              "13825        Vasco antonio venchiarutti etec       Colômbia                 1   \n",
              "13826                   Vila formosa etec de         Angola                 1   \n",
              "13827                   Vila formosa etec de        Bolívia                 1   \n",
              "13828                        Zona leste etec        Bolívia                 3   \n",
              "13829                        Zona leste etec          Japão                 1   \n",
              "\n",
              "        Ano  \n",
              "0      2019  \n",
              "1      2019  \n",
              "2      2019  \n",
              "3      2019  \n",
              "4      2019  \n",
              "...     ...  \n",
              "13825  2022  \n",
              "13826  2022  \n",
              "13827  2022  \n",
              "13828  2022  \n",
              "13829  2022  \n",
              "\n",
              "[70574 rows x 13 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-25f8e29c-ef3d-4740-abb3-cf36fd705a9d\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Cod Cla</th>\n",
              "      <th>Clasificaçõ</th>\n",
              "      <th>Cod Dep</th>\n",
              "      <th>Dependência</th>\n",
              "      <th>Cod Dist</th>\n",
              "      <th>Distrito</th>\n",
              "      <th>Município</th>\n",
              "      <th>Tipo da Escola</th>\n",
              "      <th>Código da Escola</th>\n",
              "      <th>Nome Escola</th>\n",
              "      <th>País de Origem</th>\n",
              "      <th>Número de alunos</th>\n",
              "      <th>Ano</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>14</td>\n",
              "      <td>Campinas leste</td>\n",
              "      <td>111</td>\n",
              "      <td>Campinas leste</td>\n",
              "      <td>Campinas</td>\n",
              "      <td>27</td>\n",
              "      <td>45949</td>\n",
              "      <td>Campinas colegio tecnico de - unicamp</td>\n",
              "      <td>França</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>21</td>\n",
              "      <td>Centro oeste</td>\n",
              "      <td>479</td>\n",
              "      <td>Raposo tavares</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>438820</td>\n",
              "      <td>Raposo tavares etec</td>\n",
              "      <td>Argentina</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>22</td>\n",
              "      <td>Centro sul</td>\n",
              "      <td>66</td>\n",
              "      <td>Bela vista</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>299364</td>\n",
              "      <td>Maria augusta saraiva dra etec</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>2</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>80</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>581</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>11</td>\n",
              "      <td>16354</td>\n",
              "      <td>Rubens de faria e souza etec</td>\n",
              "      <td>Peru</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>88</td>\n",
              "      <td>Taubate</td>\n",
              "      <td>97</td>\n",
              "      <td>Cacapava</td>\n",
              "      <td>Cacapava</td>\n",
              "      <td>11</td>\n",
              "      <td>14308</td>\n",
              "      <td>Machado de assis etec</td>\n",
              "      <td>Portugal</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13825</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>41</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>309</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>11</td>\n",
              "      <td>45986</td>\n",
              "      <td>Vasco antonio venchiarutti etec</td>\n",
              "      <td>Colômbia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13826</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>46</td>\n",
              "      <td>Leste 5</td>\n",
              "      <td>38</td>\n",
              "      <td>Aricanduva</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>Vila formosa etec de</td>\n",
              "      <td>Angola</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13827</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>46</td>\n",
              "      <td>Leste 5</td>\n",
              "      <td>38</td>\n",
              "      <td>Aricanduva</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>Vila formosa etec de</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13828</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>45</td>\n",
              "      <td>Leste 4</td>\n",
              "      <td>40</td>\n",
              "      <td>Artur alvim</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>Zona leste etec</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>3</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13829</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>45</td>\n",
              "      <td>Leste 4</td>\n",
              "      <td>40</td>\n",
              "      <td>Artur alvim</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>Zona leste etec</td>\n",
              "      <td>Japão</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>70574 rows × 13 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-25f8e29c-ef3d-4740-abb3-cf36fd705a9d')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-ba907bd9-c6c7-4cd9-b49b-f6c7988b9142\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-ba907bd9-c6c7-4cd9-b49b-f6c7988b9142')\"\n",
              "              title=\"Suggest charts.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "      </button>\n",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "    <script>\n",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-ba907bd9-c6c7-4cd9-b49b-f6c7988b9142 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-25f8e29c-ef3d-4740-abb3-cf36fd705a9d button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-25f8e29c-ef3d-4740-abb3-cf36fd705a9d');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 223
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dadosBD.insert(6, 'Cod Mun', None)\n",
        "dadosBD['Cod Mun'] = convertidor.fit_transform(dadosBD['Município'])\n",
        "dadosBD"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 468
        },
        "id": "OMCBNBZZGI28",
        "outputId": "b4ca6b86-c85f-4659-e157-614f1a895bfc"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       Cod Cla Clasificaçõ  Cod Dep     Dependência  Cod Dist        Distrito  \\\n",
              "0            0    Estadual       14  Campinas leste       111  Campinas leste   \n",
              "1            0    Estadual       21    Centro oeste       479  Raposo tavares   \n",
              "2            0    Estadual       22      Centro sul        66      Bela vista   \n",
              "3            0    Estadual       80        Sorocaba       581        Sorocaba   \n",
              "4            0    Estadual       88         Taubate        97        Cacapava   \n",
              "...        ...         ...      ...             ...       ...             ...   \n",
              "13825        0    Estadual       41         Jundiai       309         Jundiai   \n",
              "13826        0    Estadual       46         Leste 5        38      Aricanduva   \n",
              "13827        0    Estadual       46         Leste 5        38      Aricanduva   \n",
              "13828        0    Estadual       45         Leste 4        40     Artur alvim   \n",
              "13829        0    Estadual       45         Leste 4        40     Artur alvim   \n",
              "\n",
              "       Cod Mun  Município  Tipo da Escola  Código da Escola  \\\n",
              "0           86   Campinas              27             45949   \n",
              "1          426  Sao paulo              11            438820   \n",
              "2          426  Sao paulo              11            299364   \n",
              "3          442   Sorocaba              11             16354   \n",
              "4           75   Cacapava              11             14308   \n",
              "...        ...        ...             ...               ...   \n",
              "13825      232    Jundiai              11             45986   \n",
              "13826      426  Sao paulo              11            405243   \n",
              "13827      426  Sao paulo              11            405243   \n",
              "13828      426  Sao paulo              11            925871   \n",
              "13829      426  Sao paulo              11            925871   \n",
              "\n",
              "                                 Nome Escola País de Origem  Número de alunos  \\\n",
              "0      Campinas colegio tecnico de - unicamp         França                 1   \n",
              "1                        Raposo tavares etec      Argentina                 1   \n",
              "2             Maria augusta saraiva dra etec        Bolívia                 2   \n",
              "3               Rubens de faria e souza etec           Peru                 1   \n",
              "4                      Machado de assis etec       Portugal                 1   \n",
              "...                                      ...            ...               ...   \n",
              "13825        Vasco antonio venchiarutti etec       Colômbia                 1   \n",
              "13826                   Vila formosa etec de         Angola                 1   \n",
              "13827                   Vila formosa etec de        Bolívia                 1   \n",
              "13828                        Zona leste etec        Bolívia                 3   \n",
              "13829                        Zona leste etec          Japão                 1   \n",
              "\n",
              "        Ano  \n",
              "0      2019  \n",
              "1      2019  \n",
              "2      2019  \n",
              "3      2019  \n",
              "4      2019  \n",
              "...     ...  \n",
              "13825  2022  \n",
              "13826  2022  \n",
              "13827  2022  \n",
              "13828  2022  \n",
              "13829  2022  \n",
              "\n",
              "[70574 rows x 14 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-86b8906c-047d-4317-8465-8ca407f51a8c\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Cod Cla</th>\n",
              "      <th>Clasificaçõ</th>\n",
              "      <th>Cod Dep</th>\n",
              "      <th>Dependência</th>\n",
              "      <th>Cod Dist</th>\n",
              "      <th>Distrito</th>\n",
              "      <th>Cod Mun</th>\n",
              "      <th>Município</th>\n",
              "      <th>Tipo da Escola</th>\n",
              "      <th>Código da Escola</th>\n",
              "      <th>Nome Escola</th>\n",
              "      <th>País de Origem</th>\n",
              "      <th>Número de alunos</th>\n",
              "      <th>Ano</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>14</td>\n",
              "      <td>Campinas leste</td>\n",
              "      <td>111</td>\n",
              "      <td>Campinas leste</td>\n",
              "      <td>86</td>\n",
              "      <td>Campinas</td>\n",
              "      <td>27</td>\n",
              "      <td>45949</td>\n",
              "      <td>Campinas colegio tecnico de - unicamp</td>\n",
              "      <td>França</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>21</td>\n",
              "      <td>Centro oeste</td>\n",
              "      <td>479</td>\n",
              "      <td>Raposo tavares</td>\n",
              "      <td>426</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>438820</td>\n",
              "      <td>Raposo tavares etec</td>\n",
              "      <td>Argentina</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>22</td>\n",
              "      <td>Centro sul</td>\n",
              "      <td>66</td>\n",
              "      <td>Bela vista</td>\n",
              "      <td>426</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>299364</td>\n",
              "      <td>Maria augusta saraiva dra etec</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>2</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>80</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>581</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>442</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>11</td>\n",
              "      <td>16354</td>\n",
              "      <td>Rubens de faria e souza etec</td>\n",
              "      <td>Peru</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>88</td>\n",
              "      <td>Taubate</td>\n",
              "      <td>97</td>\n",
              "      <td>Cacapava</td>\n",
              "      <td>75</td>\n",
              "      <td>Cacapava</td>\n",
              "      <td>11</td>\n",
              "      <td>14308</td>\n",
              "      <td>Machado de assis etec</td>\n",
              "      <td>Portugal</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13825</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>41</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>309</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>232</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>11</td>\n",
              "      <td>45986</td>\n",
              "      <td>Vasco antonio venchiarutti etec</td>\n",
              "      <td>Colômbia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13826</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>46</td>\n",
              "      <td>Leste 5</td>\n",
              "      <td>38</td>\n",
              "      <td>Aricanduva</td>\n",
              "      <td>426</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>Vila formosa etec de</td>\n",
              "      <td>Angola</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13827</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>46</td>\n",
              "      <td>Leste 5</td>\n",
              "      <td>38</td>\n",
              "      <td>Aricanduva</td>\n",
              "      <td>426</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>Vila formosa etec de</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13828</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>45</td>\n",
              "      <td>Leste 4</td>\n",
              "      <td>40</td>\n",
              "      <td>Artur alvim</td>\n",
              "      <td>426</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>Zona leste etec</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>3</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13829</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>45</td>\n",
              "      <td>Leste 4</td>\n",
              "      <td>40</td>\n",
              "      <td>Artur alvim</td>\n",
              "      <td>426</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>Zona leste etec</td>\n",
              "      <td>Japão</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>70574 rows × 14 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-86b8906c-047d-4317-8465-8ca407f51a8c')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-874be743-c6b1-4e27-a1a4-7be303962b28\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-874be743-c6b1-4e27-a1a4-7be303962b28')\"\n",
              "              title=\"Suggest charts.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "      </button>\n",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "    <script>\n",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-874be743-c6b1-4e27-a1a4-7be303962b28 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-86b8906c-047d-4317-8465-8ca407f51a8c button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-86b8906c-047d-4317-8465-8ca407f51a8c');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 224
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dadosBD.insert(11, 'Cod País', None)\n",
        "dadosBD['Cod País'] = convertidor.fit_transform(dadosBD['País de Origem'])\n",
        "dadosBD"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 468
        },
        "id": "6Hk0uHDJHAob",
        "outputId": "ca0134ad-c124-4ee4-bbac-68ee94c712d1"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       Cod Cla Clasificaçõ  Cod Dep     Dependência  Cod Dist        Distrito  \\\n",
              "0            0    Estadual       14  Campinas leste       111  Campinas leste   \n",
              "1            0    Estadual       21    Centro oeste       479  Raposo tavares   \n",
              "2            0    Estadual       22      Centro sul        66      Bela vista   \n",
              "3            0    Estadual       80        Sorocaba       581        Sorocaba   \n",
              "4            0    Estadual       88         Taubate        97        Cacapava   \n",
              "...        ...         ...      ...             ...       ...             ...   \n",
              "13825        0    Estadual       41         Jundiai       309         Jundiai   \n",
              "13826        0    Estadual       46         Leste 5        38      Aricanduva   \n",
              "13827        0    Estadual       46         Leste 5        38      Aricanduva   \n",
              "13828        0    Estadual       45         Leste 4        40     Artur alvim   \n",
              "13829        0    Estadual       45         Leste 4        40     Artur alvim   \n",
              "\n",
              "       Cod Mun  Município  Tipo da Escola  Código da Escola  \\\n",
              "0           86   Campinas              27             45949   \n",
              "1          426  Sao paulo              11            438820   \n",
              "2          426  Sao paulo              11            299364   \n",
              "3          442   Sorocaba              11             16354   \n",
              "4           75   Cacapava              11             14308   \n",
              "...        ...        ...             ...               ...   \n",
              "13825      232    Jundiai              11             45986   \n",
              "13826      426  Sao paulo              11            405243   \n",
              "13827      426  Sao paulo              11            405243   \n",
              "13828      426  Sao paulo              11            925871   \n",
              "13829      426  Sao paulo              11            925871   \n",
              "\n",
              "                                 Nome Escola  Cod País País de Origem  \\\n",
              "0      Campinas colegio tecnico de - unicamp        69         França   \n",
              "1                        Raposo tavares etec         6      Argentina   \n",
              "2             Maria augusta saraiva dra etec        20        Bolívia   \n",
              "3               Rubens de faria e souza etec       140           Peru   \n",
              "4                      Machado de assis etec       144       Portugal   \n",
              "...                                      ...       ...            ...   \n",
              "13825        Vasco antonio venchiarutti etec        42       Colômbia   \n",
              "13826                   Vila formosa etec de         4         Angola   \n",
              "13827                   Vila formosa etec de        20        Bolívia   \n",
              "13828                        Zona leste etec        20        Bolívia   \n",
              "13829                        Zona leste etec        96          Japão   \n",
              "\n",
              "       Número de alunos   Ano  \n",
              "0                     1  2019  \n",
              "1                     1  2019  \n",
              "2                     2  2019  \n",
              "3                     1  2019  \n",
              "4                     1  2019  \n",
              "...                 ...   ...  \n",
              "13825                 1  2022  \n",
              "13826                 1  2022  \n",
              "13827                 1  2022  \n",
              "13828                 3  2022  \n",
              "13829                 1  2022  \n",
              "\n",
              "[70574 rows x 15 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-4050cb8f-d5cc-414e-9f34-8243f20c5af2\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Cod Cla</th>\n",
              "      <th>Clasificaçõ</th>\n",
              "      <th>Cod Dep</th>\n",
              "      <th>Dependência</th>\n",
              "      <th>Cod Dist</th>\n",
              "      <th>Distrito</th>\n",
              "      <th>Cod Mun</th>\n",
              "      <th>Município</th>\n",
              "      <th>Tipo da Escola</th>\n",
              "      <th>Código da Escola</th>\n",
              "      <th>Nome Escola</th>\n",
              "      <th>Cod País</th>\n",
              "      <th>País de Origem</th>\n",
              "      <th>Número de alunos</th>\n",
              "      <th>Ano</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>14</td>\n",
              "      <td>Campinas leste</td>\n",
              "      <td>111</td>\n",
              "      <td>Campinas leste</td>\n",
              "      <td>86</td>\n",
              "      <td>Campinas</td>\n",
              "      <td>27</td>\n",
              "      <td>45949</td>\n",
              "      <td>Campinas colegio tecnico de - unicamp</td>\n",
              "      <td>69</td>\n",
              "      <td>França</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>21</td>\n",
              "      <td>Centro oeste</td>\n",
              "      <td>479</td>\n",
              "      <td>Raposo tavares</td>\n",
              "      <td>426</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>438820</td>\n",
              "      <td>Raposo tavares etec</td>\n",
              "      <td>6</td>\n",
              "      <td>Argentina</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>22</td>\n",
              "      <td>Centro sul</td>\n",
              "      <td>66</td>\n",
              "      <td>Bela vista</td>\n",
              "      <td>426</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>299364</td>\n",
              "      <td>Maria augusta saraiva dra etec</td>\n",
              "      <td>20</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>2</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>80</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>581</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>442</td>\n",
              "      <td>Sorocaba</td>\n",
              "      <td>11</td>\n",
              "      <td>16354</td>\n",
              "      <td>Rubens de faria e souza etec</td>\n",
              "      <td>140</td>\n",
              "      <td>Peru</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>88</td>\n",
              "      <td>Taubate</td>\n",
              "      <td>97</td>\n",
              "      <td>Cacapava</td>\n",
              "      <td>75</td>\n",
              "      <td>Cacapava</td>\n",
              "      <td>11</td>\n",
              "      <td>14308</td>\n",
              "      <td>Machado de assis etec</td>\n",
              "      <td>144</td>\n",
              "      <td>Portugal</td>\n",
              "      <td>1</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13825</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>41</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>309</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>232</td>\n",
              "      <td>Jundiai</td>\n",
              "      <td>11</td>\n",
              "      <td>45986</td>\n",
              "      <td>Vasco antonio venchiarutti etec</td>\n",
              "      <td>42</td>\n",
              "      <td>Colômbia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13826</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>46</td>\n",
              "      <td>Leste 5</td>\n",
              "      <td>38</td>\n",
              "      <td>Aricanduva</td>\n",
              "      <td>426</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>Vila formosa etec de</td>\n",
              "      <td>4</td>\n",
              "      <td>Angola</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13827</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>46</td>\n",
              "      <td>Leste 5</td>\n",
              "      <td>38</td>\n",
              "      <td>Aricanduva</td>\n",
              "      <td>426</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>405243</td>\n",
              "      <td>Vila formosa etec de</td>\n",
              "      <td>20</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13828</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>45</td>\n",
              "      <td>Leste 4</td>\n",
              "      <td>40</td>\n",
              "      <td>Artur alvim</td>\n",
              "      <td>426</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>Zona leste etec</td>\n",
              "      <td>20</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>3</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13829</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>45</td>\n",
              "      <td>Leste 4</td>\n",
              "      <td>40</td>\n",
              "      <td>Artur alvim</td>\n",
              "      <td>426</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>11</td>\n",
              "      <td>925871</td>\n",
              "      <td>Zona leste etec</td>\n",
              "      <td>96</td>\n",
              "      <td>Japão</td>\n",
              "      <td>1</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>70574 rows × 15 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-4050cb8f-d5cc-414e-9f34-8243f20c5af2')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-cc1663ad-421c-49f0-ae96-10f4bcc1a483\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-cc1663ad-421c-49f0-ae96-10f4bcc1a483')\"\n",
              "              title=\"Suggest charts.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "      </button>\n",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "    <script>\n",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-cc1663ad-421c-49f0-ae96-10f4bcc1a483 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-4050cb8f-d5cc-414e-9f34-8243f20c5af2 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-4050cb8f-d5cc-414e-9f34-8243f20c5af2');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 225
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Ver 5 registros aleatórios\n",
        "dadosBD.sample(5)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 285
        },
        "id": "tycRzJoFH8nO",
        "outputId": "e9f7fd18-5cad-404f-be74-9271368e69ac"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      Cod Cla Clasificaçõ  Cod Dep      Dependência  Cod Dist  \\\n",
              "3354        0    Estadual       42          Leste 1       185   \n",
              "7621        2   Municipal       68      Santo andre       531   \n",
              "8894        3     Privada       60  Pindamonhangaba       436   \n",
              "8789        2   Municipal        1        Americana        19   \n",
              "1297        0    Estadual       20           Centro       515   \n",
              "\n",
              "                Distrito  Cod Mun        Município  Tipo da Escola  \\\n",
              "3354  Ermelino matarazzo      426        Sao paulo               8   \n",
              "7621         Santo andre      405      Santo andre               0   \n",
              "8894     Pindamonhangaba      327  Pindamonhangaba               0   \n",
              "8789           Americana       14        Americana               0   \n",
              "1297       Santa cecilia      426        Sao paulo               8   \n",
              "\n",
              "      Código da Escola                          Nome Escola  Cod País  \\\n",
              "3354             39238  Lucio de carvalho marques professor        20   \n",
              "7621            232099              Herbert de souza creche        42   \n",
              "8894            286527                   Progressao colegio        20   \n",
              "8789            283447                Urupe casa da crianca        20   \n",
              "1297              3670     Fidelino de figueiredo professor        94   \n",
              "\n",
              "     País de Origem  Número de alunos   Ano  \n",
              "3354        Bolívia                 3  2022  \n",
              "7621       Colômbia                 1  2020  \n",
              "8894        Bolívia                 2  2020  \n",
              "8789        Bolívia                 1  2021  \n",
              "1297          Iémen                 1  2021  "
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-1e6c521e-4dd3-42e5-896f-41946a457dac\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Cod Cla</th>\n",
              "      <th>Clasificaçõ</th>\n",
              "      <th>Cod Dep</th>\n",
              "      <th>Dependência</th>\n",
              "      <th>Cod Dist</th>\n",
              "      <th>Distrito</th>\n",
              "      <th>Cod Mun</th>\n",
              "      <th>Município</th>\n",
              "      <th>Tipo da Escola</th>\n",
              "      <th>Código da Escola</th>\n",
              "      <th>Nome Escola</th>\n",
              "      <th>Cod País</th>\n",
              "      <th>País de Origem</th>\n",
              "      <th>Número de alunos</th>\n",
              "      <th>Ano</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>3354</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>42</td>\n",
              "      <td>Leste 1</td>\n",
              "      <td>185</td>\n",
              "      <td>Ermelino matarazzo</td>\n",
              "      <td>426</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>8</td>\n",
              "      <td>39238</td>\n",
              "      <td>Lucio de carvalho marques professor</td>\n",
              "      <td>20</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>3</td>\n",
              "      <td>2022</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7621</th>\n",
              "      <td>2</td>\n",
              "      <td>Municipal</td>\n",
              "      <td>68</td>\n",
              "      <td>Santo andre</td>\n",
              "      <td>531</td>\n",
              "      <td>Santo andre</td>\n",
              "      <td>405</td>\n",
              "      <td>Santo andre</td>\n",
              "      <td>0</td>\n",
              "      <td>232099</td>\n",
              "      <td>Herbert de souza creche</td>\n",
              "      <td>42</td>\n",
              "      <td>Colômbia</td>\n",
              "      <td>1</td>\n",
              "      <td>2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8894</th>\n",
              "      <td>3</td>\n",
              "      <td>Privada</td>\n",
              "      <td>60</td>\n",
              "      <td>Pindamonhangaba</td>\n",
              "      <td>436</td>\n",
              "      <td>Pindamonhangaba</td>\n",
              "      <td>327</td>\n",
              "      <td>Pindamonhangaba</td>\n",
              "      <td>0</td>\n",
              "      <td>286527</td>\n",
              "      <td>Progressao colegio</td>\n",
              "      <td>20</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>2</td>\n",
              "      <td>2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8789</th>\n",
              "      <td>2</td>\n",
              "      <td>Municipal</td>\n",
              "      <td>1</td>\n",
              "      <td>Americana</td>\n",
              "      <td>19</td>\n",
              "      <td>Americana</td>\n",
              "      <td>14</td>\n",
              "      <td>Americana</td>\n",
              "      <td>0</td>\n",
              "      <td>283447</td>\n",
              "      <td>Urupe casa da crianca</td>\n",
              "      <td>20</td>\n",
              "      <td>Bolívia</td>\n",
              "      <td>1</td>\n",
              "      <td>2021</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1297</th>\n",
              "      <td>0</td>\n",
              "      <td>Estadual</td>\n",
              "      <td>20</td>\n",
              "      <td>Centro</td>\n",
              "      <td>515</td>\n",
              "      <td>Santa cecilia</td>\n",
              "      <td>426</td>\n",
              "      <td>Sao paulo</td>\n",
              "      <td>8</td>\n",
              "      <td>3670</td>\n",
              "      <td>Fidelino de figueiredo professor</td>\n",
              "      <td>94</td>\n",
              "      <td>Iémen</td>\n",
              "      <td>1</td>\n",
              "      <td>2021</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1e6c521e-4dd3-42e5-896f-41946a457dac')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-24f1bf97-8419-4ff8-828c-765339e447c8\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-24f1bf97-8419-4ff8-828c-765339e447c8')\"\n",
              "              title=\"Suggest charts.\"\n",
              "              style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "      </button>\n",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "    <script>\n",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-24f1bf97-8419-4ff8-828c-765339e447c8 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-1e6c521e-4dd3-42e5-896f-41946a457dac button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-1e6c521e-4dd3-42e5-896f-41946a457dac');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 226
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "#Separando as tabelas"
      ],
      "metadata": {
        "id": "zk4Q0Ic7Q-G1"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Tabela fato\n",
        "escolaestrageiros=dadosBD[['Cod Cla','Cod Dep','Cod Dist','Cod Mun','Código da Escola','Cod País','Número de alunos','Ano']]\n",
        "\n",
        "\n",
        "#Tabelas dimensôes\n",
        "clasificacao=dadosBD[['Cod Cla','Clasificaçõ']]\n",
        "clasificacao = clasificacao.value_counts()\n",
        "dependencia=dadosBD[['Cod Dep','Dependência']]\n",
        "dependencia = dependencia.value_counts()\n",
        "distrito=dadosBD[['Cod Dist','Distrito']]\n",
        "distrito = distrito.value_counts()\n",
        "municipio=dadosBD[['Cod Mun','Município']]\n",
        "municipio = municipio.value_counts()\n",
        "escola=dadosBD[['Código da Escola','Nome Escola','Tipo da Escola']]\n",
        "escola = escola.value_counts()\n",
        "pais=dadosBD[['Cod País','País de Origem']]\n",
        "pais = pais.value_counts()"
      ],
      "metadata": {
        "id": "doElzM9fNPSM"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "print(f\"Quantidades de registros na tabela principal \\n{len(escolaestrageiros)} \\n\")\n",
        "print(f\"Quantidades de registros na tabela Clasificação \\n{len(clasificacao)} \\n\")\n",
        "print(f\"Quantidades de registros na tabela dependencia\\n{len(dependencia)} \\n\")\n",
        "print(f\"Quantidades de registros na tabela distrito\\n{len(distrito)} \\n\")\n",
        "print(f\"Quantidades de registros na tabela municipio\\n{len(municipio)} \\n\")\n",
        "print(f\"Quantidades de registros na tabela escola\\n{len(escola)} \\n\")\n",
        "print(f\"Quantidades de registros na tabela país\\n{len(pais)} \\n\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "7Sy9x5wdYvLH",
        "outputId": "c10cfe3a-bfa6-4309-96a3-fd4a9af4401b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Quantidades de registros na tabela principal \n",
            "70574 \n",
            "\n",
            "Quantidades de registros na tabela Clasificação \n",
            "4 \n",
            "\n",
            "Quantidades de registros na tabela dependencia\n",
            "92 \n",
            "\n",
            "Quantidades de registros na tabela distrito\n",
            "647 \n",
            "\n",
            "Quantidades de registros na tabela municipio\n",
            "482 \n",
            "\n",
            "Quantidades de registros na tabela escola\n",
            "12525 \n",
            "\n",
            "Quantidades de registros na tabela pais\n",
            "188 \n",
            "\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "#Exportando Dados"
      ],
      "metadata": {
        "id": "aAp4oU5GIV1_"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#dadosBD.to_csv('BDEducacao.csv')\n",
        "clasificacao.to_csv('clasificacao.csv')\n",
        "dependencia.to_csv('dependencia.csv')\n",
        "distrito.to_csv('distrito.csv')\n",
        "municipio.to_csv('municipio.csv')\n",
        "escola.to_csv('escola.csv')\n",
        "pais.to_csv('pais.csv')\n",
        "escolaestrageiros.to_csv('escolaestrageiros.csv')"
      ],
      "metadata": {
        "id": "PbaXpnbEIYgK"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "7XP4ymHHJRWr"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}