As cidades sem mulheres na política.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "98734fd4-bdbc-4af3-aae8-ba9bffe05966",
   "metadata": {},
   "source": [
    "## Código utilizado para análise de dados da reportagem: [As cidades brasileiras que há mais de 20 anos só elegem homens para prefeito, vice e vereador](https://g1.globo.com/politica/eleicoes/2024/eleicao-em-numeros/noticia/2024/10/19/as-cidades-brasileiras-que-ha-mais-de-20-anos-so-elegem-homens-para-prefeito-vice-e-vereador.ghtml)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "93a972ba-2b58-4570-966f-a00308281ba8",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importa as bibliotecas necessárias para a análise\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import re\n",
    "import numpy as np\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "ee53aa47-d821-4fcd-9bc8-61001b5bc412",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Me mostre tudo\n",
    "pd.set_option(\"display.max_rows\", None)\n",
    "pd.set_option(\"display.max_columns\", None)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d81c4832-82b0-4690-a966-33461a8b2af4",
   "metadata": {},
   "source": [
    "## 📅 2020"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "51dcb9d8-4c83-44ce-be1c-f09db660fe4a",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Definindo as colunas do df\n",
    "colunas_desejadas = ['SG_UE', 'DS_SIT_TOT_TURNO', 'NM_CANDIDATO', 'NM_URNA_CANDIDATO', 'SG_UF', 'NM_UE', 'SG_PARTIDO', 'DS_GENERO', 'DS_CARGO']\n",
    "\n",
    "# Lendo o arquivo CSV apenas com as colunas especificadas\n",
    "df_2000 = pd.read_csv(\"data/consulta_cand_2000_BRASIL.csv\", delimiter=';', encoding='latin-1', usecols=colunas_desejadas)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "8f6dd7fe-f897-4344-9a95-e7c2cfa98d46",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SG_UF</th>\n",
       "      <th>SG_UE</th>\n",
       "      <th>NM_UE</th>\n",
       "      <th>DS_CARGO</th>\n",
       "      <th>NM_CANDIDATO</th>\n",
       "      <th>NM_URNA_CANDIDATO</th>\n",
       "      <th>SG_PARTIDO</th>\n",
       "      <th>DS_GENERO</th>\n",
       "      <th>DS_SIT_TOT_TURNO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BA</td>\n",
       "      <td>36170</td>\n",
       "      <td>ITAMBE</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>PAULO RUCAS BRITO ACHY</td>\n",
       "      <td>TO</td>\n",
       "      <td>PMDB</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>ELEITO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SC</td>\n",
       "      <td>80551</td>\n",
       "      <td>BRUSQUE</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>EDEMIR DE SOUZA</td>\n",
       "      <td>EDEMIR ELETRECISTA</td>\n",
       "      <td>PDT</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SP</td>\n",
       "      <td>63614</td>\n",
       "      <td>COTIA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>WAGNER LUIS DO PRADO</td>\n",
       "      <td>TRILILI</td>\n",
       "      <td>PRTB</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BA</td>\n",
       "      <td>37150</td>\n",
       "      <td>MARAU</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>VALQUÍRIA DE LEMOS MELO</td>\n",
       "      <td>VALQUÍRIA</td>\n",
       "      <td>PL</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SC</td>\n",
       "      <td>81051</td>\n",
       "      <td>FLORIANOPOLIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>ALVARO LUIZ BORTOLOTTO PREIS</td>\n",
       "      <td>ÁLVARO LUIZ BORTOLOTTO PREIS</td>\n",
       "      <td>PSDB</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  SG_UF  SG_UE          NM_UE  DS_CARGO                  NM_CANDIDATO  \\\n",
       "0    BA  36170         ITAMBE  VEREADOR        PAULO RUCAS BRITO ACHY   \n",
       "1    SC  80551        BRUSQUE  VEREADOR               EDEMIR DE SOUZA   \n",
       "2    SP  63614          COTIA  VEREADOR          WAGNER LUIS DO PRADO   \n",
       "3    BA  37150          MARAU  VEREADOR       VALQUÍRIA DE LEMOS MELO   \n",
       "4    SC  81051  FLORIANOPOLIS  VEREADOR  ALVARO LUIZ BORTOLOTTO PREIS   \n",
       "\n",
       "              NM_URNA_CANDIDATO SG_PARTIDO  DS_GENERO DS_SIT_TOT_TURNO  \n",
       "0                            TO       PMDB  MASCULINO           ELEITO  \n",
       "1            EDEMIR ELETRECISTA        PDT  MASCULINO         SUPLENTE  \n",
       "2                       TRILILI       PRTB  MASCULINO         SUPLENTE  \n",
       "3                     VALQUÍRIA         PL   FEMININO         SUPLENTE  \n",
       "4  ÁLVARO LUIZ BORTOLOTTO PREIS       PSDB  MASCULINO         SUPLENTE  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2000.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "7ee2e191-ac4f-479d-be55-af0e1dbccdd1",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2000 = df_2000[df_2000['DS_SIT_TOT_TURNO'].isin(['ELEITO', 'ELEITO POR MÉDIA'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "25ad46c9-30b2-466a-91ad-e37273a6e153",
   "metadata": {},
   "outputs": [],
   "source": [
    "mulheres_eleitas = df_2000[(df_2000['DS_GENERO'] == 'FEMININO')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "d19e38c7-1944-4ebb-af1d-4ce2886fe5c0",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obter SG_UE das cidades que elegeram mulheres\n",
    "sg_ue_com_mulheres = mulheres_eleitas['SG_UE'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "704acaa4-fb5e-4f60-a9dc-79b02758b51f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obter todas as cidades (SG_UF, SG_UE, NM_UE)\n",
    "cidades_completas = df_2000[['SG_UF', 'SG_UE', 'NM_UE']].drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "676cacf5-b7b4-4dd6-845a-79fa5ebc29a4",
   "metadata": {},
   "outputs": [],
   "source": [
    "cidades_sem_mulheres_2000 = cidades_completas[~cidades_completas['SG_UE'].isin(sg_ue_com_mulheres)]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a9fb5c2a-968d-4670-8242-6b55026757b4",
   "metadata": {},
   "source": [
    "## 📅 2004"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "f1696f4f-8d38-44e2-a5c6-cd184d93b6eb",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Definir as colunas que você deseja ler\n",
    "colunas_desejadas = ['SG_UE', 'DS_SIT_TOT_TURNO', 'NM_CANDIDATO', 'NM_URNA_CANDIDATO', 'SG_UF', 'NM_UE', 'SG_PARTIDO', 'DS_GENERO', 'DS_CARGO']\n",
    "\n",
    "# Ler o arquivo CSV apenas com as colunas especificadas\n",
    "df_2004 = pd.read_csv(\"data/consulta_cand_2004_BRASIL.csv\", delimiter=';', encoding='latin-1', usecols=colunas_desejadas)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "91b987f4-2843-41ec-a30c-f0ff529fb30e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SG_UF</th>\n",
       "      <th>SG_UE</th>\n",
       "      <th>NM_UE</th>\n",
       "      <th>DS_CARGO</th>\n",
       "      <th>NM_CANDIDATO</th>\n",
       "      <th>NM_URNA_CANDIDATO</th>\n",
       "      <th>SG_PARTIDO</th>\n",
       "      <th>DS_GENERO</th>\n",
       "      <th>DS_SIT_TOT_TURNO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>PA</td>\n",
       "      <td>5738</td>\n",
       "      <td>RONDON DO PARA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>JOSÉ MARIA RICARDO DA SILVA</td>\n",
       "      <td>JOSÉ MARIA</td>\n",
       "      <td>PTB</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>NÃO ELEITO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PA</td>\n",
       "      <td>5630</td>\n",
       "      <td>VIGIA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>JOSÉ ARNALDO DE ALMEIDA COSTA</td>\n",
       "      <td>CALAFATE</td>\n",
       "      <td>PRONA</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>NÃO ELEITO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PA</td>\n",
       "      <td>5193</td>\n",
       "      <td>PRAINHA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>LEONAM MENDES DA SILVA</td>\n",
       "      <td>LEONAM</td>\n",
       "      <td>PPS</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>MG</td>\n",
       "      <td>49590</td>\n",
       "      <td>PATOS DE MINAS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>RUBENS CANDIDO DE AQUINO</td>\n",
       "      <td>RUBENS CANDIDO</td>\n",
       "      <td>PL</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>NÃO ELEITO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>MG</td>\n",
       "      <td>42790</td>\n",
       "      <td>CARMO DA MATA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>JOAQUIM CUSTODIO SOBRINHO</td>\n",
       "      <td>CAQUINHO</td>\n",
       "      <td>PDT</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>RENÚNCIA/FALECIMENTO/CASSAÇÃO ANTES DA ELEIÇÃO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  SG_UF  SG_UE           NM_UE  DS_CARGO                   NM_CANDIDATO  \\\n",
       "0    PA   5738  RONDON DO PARA  VEREADOR    JOSÉ MARIA RICARDO DA SILVA   \n",
       "1    PA   5630           VIGIA  VEREADOR  JOSÉ ARNALDO DE ALMEIDA COSTA   \n",
       "2    PA   5193         PRAINHA  VEREADOR         LEONAM MENDES DA SILVA   \n",
       "3    MG  49590  PATOS DE MINAS  VEREADOR       RUBENS CANDIDO DE AQUINO   \n",
       "4    MG  42790   CARMO DA MATA  VEREADOR      JOAQUIM CUSTODIO SOBRINHO   \n",
       "\n",
       "  NM_URNA_CANDIDATO SG_PARTIDO  DS_GENERO  \\\n",
       "0        JOSÉ MARIA        PTB  MASCULINO   \n",
       "1          CALAFATE      PRONA  MASCULINO   \n",
       "2            LEONAM        PPS  MASCULINO   \n",
       "3    RUBENS CANDIDO         PL  MASCULINO   \n",
       "4          CAQUINHO        PDT  MASCULINO   \n",
       "\n",
       "                                 DS_SIT_TOT_TURNO  \n",
       "0                                      NÃO ELEITO  \n",
       "1                                      NÃO ELEITO  \n",
       "2                                        SUPLENTE  \n",
       "3                                      NÃO ELEITO  \n",
       "4  RENÚNCIA/FALECIMENTO/CASSAÇÃO ANTES DA ELEIÇÃO  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2004.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "014e59a8-1019-428a-9d43-820b5356f16a",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2004 = df_2004[df_2004['DS_SIT_TOT_TURNO'].isin(['ELEITO', 'MÉDIA'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "ba606d2f-b86a-4bc7-89a5-c4e81de41b0d",
   "metadata": {},
   "outputs": [],
   "source": [
    "mulheres_eleitas = df_2004[(df_2004['DS_GENERO'] == 'FEMININO')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "eed53a03-43a2-41e3-a2d7-7fa7ff6ddd7d",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obter SG_UE das cidades que elegeram mulheres\n",
    "sg_ue_com_mulheres = mulheres_eleitas['SG_UE'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "6621ba05-0722-4998-aeeb-c838aaf6193e",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obter todas as cidades (SG_UF, SG_UE, NM_UE)\n",
    "cidades_completas = df_2004[['SG_UF', 'SG_UE', 'NM_UE']].drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "0c878e2b-1d86-41ea-b918-86aea575fee6",
   "metadata": {},
   "outputs": [],
   "source": [
    "cidades_sem_mulheres_2004 = cidades_completas[~cidades_completas['SG_UE'].isin(sg_ue_com_mulheres)]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a5e7b4e6-40dd-4d51-9e20-6397bfdd912f",
   "metadata": {},
   "source": [
    "## 📅 2008"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "d455395d-1748-42b9-86ee-d7219a1e184b",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Definir as colunas que você deseja ler\n",
    "colunas_desejadas = ['SG_UE', 'DS_SIT_TOT_TURNO', 'NM_CANDIDATO', 'NM_URNA_CANDIDATO', 'SG_UF', 'NM_UE', 'SG_PARTIDO', 'DS_GENERO']\n",
    "\n",
    "# Ler o arquivo CSV apenas com as colunas especificadas\n",
    "df_2008 = pd.read_csv(\"data/consulta_cand_2008_BRASIL.csv\", delimiter=';', encoding='latin-1', usecols=colunas_desejadas)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "3e9065ea-11e0-4ffc-b756-2e569fe2be0e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SG_UF</th>\n",
       "      <th>SG_UE</th>\n",
       "      <th>NM_UE</th>\n",
       "      <th>NM_CANDIDATO</th>\n",
       "      <th>NM_URNA_CANDIDATO</th>\n",
       "      <th>SG_PARTIDO</th>\n",
       "      <th>DS_GENERO</th>\n",
       "      <th>DS_SIT_TOT_TURNO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>MG</td>\n",
       "      <td>42501</td>\n",
       "      <td>VARJÃO DE MINAS</td>\n",
       "      <td>ANTONIO ILSON DOS SANTOS</td>\n",
       "      <td>ANTONIO ILSON</td>\n",
       "      <td>PP</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>#NULO#</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>MG</td>\n",
       "      <td>40606</td>\n",
       "      <td>RIACHINHO</td>\n",
       "      <td>IRENE RODRIGUES DA SILVA CARDOSO</td>\n",
       "      <td>IRENE</td>\n",
       "      <td>PSDB</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SC</td>\n",
       "      <td>82295</td>\n",
       "      <td>ORLEANS</td>\n",
       "      <td>FERNANDO ASCARI</td>\n",
       "      <td>FERNANDO ASCARI VIEIRA</td>\n",
       "      <td>DEM</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PA</td>\n",
       "      <td>5452</td>\n",
       "      <td>SÃO FÉLIX DO XINGU</td>\n",
       "      <td>TARCISIO COELHO FILHO</td>\n",
       "      <td>TARCISIO</td>\n",
       "      <td>PT</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>MG</td>\n",
       "      <td>43990</td>\n",
       "      <td>CÓRREGO NOVO</td>\n",
       "      <td>WILSON RODRIGUES DA COSTA</td>\n",
       "      <td>WILSON GORDO</td>\n",
       "      <td>PRTB</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  SG_UF  SG_UE               NM_UE                      NM_CANDIDATO  \\\n",
       "0    MG  42501     VARJÃO DE MINAS          ANTONIO ILSON DOS SANTOS   \n",
       "1    MG  40606           RIACHINHO  IRENE RODRIGUES DA SILVA CARDOSO   \n",
       "2    SC  82295             ORLEANS                   FERNANDO ASCARI   \n",
       "3    PA   5452  SÃO FÉLIX DO XINGU             TARCISIO COELHO FILHO   \n",
       "4    MG  43990        CÓRREGO NOVO         WILSON RODRIGUES DA COSTA   \n",
       "\n",
       "        NM_URNA_CANDIDATO SG_PARTIDO  DS_GENERO DS_SIT_TOT_TURNO  \n",
       "0           ANTONIO ILSON         PP  MASCULINO           #NULO#  \n",
       "1                   IRENE       PSDB   FEMININO         SUPLENTE  \n",
       "2  FERNANDO ASCARI VIEIRA        DEM  MASCULINO         SUPLENTE  \n",
       "3                TARCISIO         PT  MASCULINO         SUPLENTE  \n",
       "4            WILSON GORDO       PRTB  MASCULINO         SUPLENTE  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2008.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "9fae0bc6-2d11-4a05-9bec-afd6e80096ca",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2008 = df_2008[df_2008['DS_SIT_TOT_TURNO'].isin(['ELEITO', 'MÉDIA'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "ab81560b-c2b3-423e-a3ca-964cb990caac",
   "metadata": {},
   "outputs": [],
   "source": [
    "mulheres_eleitas = df_2008[(df_2008['DS_GENERO'] == 'FEMININO')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "bf805bc7-9ca1-4d93-9a1c-80e4894b5132",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obter SG_UE das cidades que elegeram mulheres\n",
    "sg_ue_com_mulheres = mulheres_eleitas['SG_UE'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "a5a2f92b-903f-44c0-a6de-49052d48b4c2",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obter todas as cidades (SG_UF, SG_UE, NM_UE)\n",
    "cidades_completas = df_2008[['SG_UF', 'SG_UE', 'NM_UE']].drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "d62165d2-1023-454d-994a-60f260f08cf0",
   "metadata": {},
   "outputs": [],
   "source": [
    "cidades_sem_mulheres_2008 = cidades_completas[~cidades_completas['SG_UE'].isin(sg_ue_com_mulheres)]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b43693c3-5dc1-44df-b8a0-301b975e6a9e",
   "metadata": {},
   "source": [
    "## 📅 2012"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "2dc9b98a-d24b-49fc-b48b-19bcad87a373",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Definir as colunas que você deseja ler\n",
    "colunas_desejadas = ['SG_UE', 'DS_SIT_TOT_TURNO', 'NM_CANDIDATO', 'NM_URNA_CANDIDATO', 'SG_UF', 'NM_UE', 'SG_PARTIDO', 'DS_GENERO']\n",
    "\n",
    "# Ler o arquivo CSV apenas com as colunas especificadas\n",
    "df_2012 = pd.read_csv(\"data/consulta_cand_2012_BRASIL.csv\", delimiter=';', encoding='latin-1', usecols=colunas_desejadas)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "be886c01-3352-49c4-a37b-dae2e3856f1b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SG_UF</th>\n",
       "      <th>SG_UE</th>\n",
       "      <th>NM_UE</th>\n",
       "      <th>NM_CANDIDATO</th>\n",
       "      <th>NM_URNA_CANDIDATO</th>\n",
       "      <th>SG_PARTIDO</th>\n",
       "      <th>DS_GENERO</th>\n",
       "      <th>DS_SIT_TOT_TURNO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ES</td>\n",
       "      <td>56170</td>\n",
       "      <td>BARRA DE SÃO FRANCISCO</td>\n",
       "      <td>PEDRINHO GODOY DE OLIVEIRA</td>\n",
       "      <td>PEDRINHO GODOY</td>\n",
       "      <td>PT do B</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>NÃO ELEITO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>MA</td>\n",
       "      <td>7455</td>\n",
       "      <td>CAJAPIÓ</td>\n",
       "      <td>PEDROLINA DE JESUS PINTO</td>\n",
       "      <td>PEDROLINA</td>\n",
       "      <td>PC do B</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>GO</td>\n",
       "      <td>92274</td>\n",
       "      <td>APARECIDA DE GOIÂNIA</td>\n",
       "      <td>ALBANICE FERREIRA DA CUZ</td>\n",
       "      <td>ALBANICE</td>\n",
       "      <td>PPL</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>#NULO#</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>MA</td>\n",
       "      <td>9474</td>\n",
       "      <td>VARGEM GRANDE</td>\n",
       "      <td>ENEAS SOUSA COSTA</td>\n",
       "      <td>ENEAS</td>\n",
       "      <td>PTB</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GO</td>\n",
       "      <td>94250</td>\n",
       "      <td>ITUMBIARA</td>\n",
       "      <td>ONEIDA MARIA DO CARMO ARAUJO</td>\n",
       "      <td>ONEIDA DA CAMARA</td>\n",
       "      <td>PHS</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  SG_UF  SG_UE                   NM_UE                  NM_CANDIDATO  \\\n",
       "0    ES  56170  BARRA DE SÃO FRANCISCO    PEDRINHO GODOY DE OLIVEIRA   \n",
       "1    MA   7455                 CAJAPIÓ      PEDROLINA DE JESUS PINTO   \n",
       "2    GO  92274    APARECIDA DE GOIÂNIA      ALBANICE FERREIRA DA CUZ   \n",
       "3    MA   9474           VARGEM GRANDE             ENEAS SOUSA COSTA   \n",
       "4    GO  94250               ITUMBIARA  ONEIDA MARIA DO CARMO ARAUJO   \n",
       "\n",
       "  NM_URNA_CANDIDATO SG_PARTIDO  DS_GENERO DS_SIT_TOT_TURNO  \n",
       "0    PEDRINHO GODOY    PT do B  MASCULINO       NÃO ELEITO  \n",
       "1         PEDROLINA    PC do B   FEMININO         SUPLENTE  \n",
       "2          ALBANICE        PPL   FEMININO           #NULO#  \n",
       "3             ENEAS        PTB  MASCULINO         SUPLENTE  \n",
       "4  ONEIDA DA CAMARA        PHS   FEMININO         SUPLENTE  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2012.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "33cc0914-7e89-4a93-85d5-128d91d09ea5",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2012 = df_2012[df_2012['DS_SIT_TOT_TURNO'].isin(['ELEITO', 'ELEITO POR MÉDIA', 'ELEITO POR QP'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "4b798433-74f7-4a4d-bb2c-39b184891dfb",
   "metadata": {},
   "outputs": [],
   "source": [
    "mulheres_eleitas = df_2012[(df_2012['DS_GENERO'] == 'FEMININO')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "b8631ee8-498d-4cc3-9598-c89c595942b9",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obter SG_UE das cidades que elegeram mulheres\n",
    "sg_ue_com_mulheres = mulheres_eleitas['SG_UE'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "5182423a-da71-42e5-a7d7-8d7f06732d1c",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obter todas as cidades (SG_UF, SG_UE, NM_UE)\n",
    "cidades_completas = df_2012[['SG_UF', 'SG_UE', 'NM_UE']].drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "b68eb29b-8334-442b-9e76-e827b4b31404",
   "metadata": {},
   "outputs": [],
   "source": [
    "cidades_sem_mulheres_2012 = cidades_completas[~cidades_completas['SG_UE'].isin(sg_ue_com_mulheres)]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1cc13d1d-fd39-4ff6-8011-b5311cf2f90f",
   "metadata": {},
   "source": [
    "## 📅 2016"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "75c44a2e-f454-464f-b905-2918a78d385a",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Definir as colunas que você deseja ler\n",
    "colunas_desejadas = ['SG_UE', 'DS_SIT_TOT_TURNO', 'NM_CANDIDATO', 'NM_URNA_CANDIDATO', 'SG_UF', 'NM_UE', 'SG_PARTIDO', 'DS_GENERO']\n",
    "\n",
    "# Ler o arquivo CSV apenas com as colunas especificadas\n",
    "df_2016 = pd.read_csv(\"data/consulta_cand_2016_BRASIL.csv\", delimiter=';', encoding='latin-1', usecols=colunas_desejadas)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "492ad8b4-ba12-4883-acfd-d2b000ef9cf0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SG_UF</th>\n",
       "      <th>SG_UE</th>\n",
       "      <th>NM_UE</th>\n",
       "      <th>NM_CANDIDATO</th>\n",
       "      <th>NM_URNA_CANDIDATO</th>\n",
       "      <th>SG_PARTIDO</th>\n",
       "      <th>DS_GENERO</th>\n",
       "      <th>DS_SIT_TOT_TURNO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>MA</td>\n",
       "      <td>7439</td>\n",
       "      <td>BURITI BRAVO</td>\n",
       "      <td>MARIA SOLIDADE COSME DE OLIVEIRA</td>\n",
       "      <td>XUXA</td>\n",
       "      <td>PTB</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PI</td>\n",
       "      <td>11231</td>\n",
       "      <td>MIGUEL ALVES</td>\n",
       "      <td>FRANCINETE ALVES ALMEIDA</td>\n",
       "      <td>FRANCINETE</td>\n",
       "      <td>DEM</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PI</td>\n",
       "      <td>11231</td>\n",
       "      <td>MIGUEL ALVES</td>\n",
       "      <td>IVANILDO SOUSA MOREIRA</td>\n",
       "      <td>PROFESSOR IVANILDO</td>\n",
       "      <td>PP</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PI</td>\n",
       "      <td>11231</td>\n",
       "      <td>MIGUEL ALVES</td>\n",
       "      <td>INÁCIO ALVES DA SILVA</td>\n",
       "      <td>INÁCIO</td>\n",
       "      <td>PP</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>SUPLENTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SP</td>\n",
       "      <td>65196</td>\n",
       "      <td>IPAUSSU</td>\n",
       "      <td>WILSON DE ANDRADE</td>\n",
       "      <td>PAQUITO</td>\n",
       "      <td>PP</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>#NULO#</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  SG_UF  SG_UE         NM_UE                      NM_CANDIDATO  \\\n",
       "0    MA   7439  BURITI BRAVO  MARIA SOLIDADE COSME DE OLIVEIRA   \n",
       "1    PI  11231  MIGUEL ALVES          FRANCINETE ALVES ALMEIDA   \n",
       "2    PI  11231  MIGUEL ALVES            IVANILDO SOUSA MOREIRA   \n",
       "3    PI  11231  MIGUEL ALVES             INÁCIO ALVES DA SILVA   \n",
       "4    SP  65196       IPAUSSU                 WILSON DE ANDRADE   \n",
       "\n",
       "    NM_URNA_CANDIDATO SG_PARTIDO  DS_GENERO DS_SIT_TOT_TURNO  \n",
       "0                XUXA        PTB   FEMININO         SUPLENTE  \n",
       "1          FRANCINETE        DEM  MASCULINO         SUPLENTE  \n",
       "2  PROFESSOR IVANILDO         PP  MASCULINO         SUPLENTE  \n",
       "3              INÁCIO         PP  MASCULINO         SUPLENTE  \n",
       "4             PAQUITO         PP  MASCULINO           #NULO#  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2016.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "f047adc8-b7f1-464f-8875-362896926115",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2016 = df_2016[df_2016['DS_SIT_TOT_TURNO'].isin(['ELEITO', 'ELEITO POR MÉDIA', 'ELEITO POR QP'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "7c5c5322-b109-4c4e-b8ef-55043a3ed164",
   "metadata": {},
   "outputs": [],
   "source": [
    "mulheres_eleitas = df_2016[(df_2016['DS_GENERO'] == 'FEMININO')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "e63dceed-91c7-4da5-ba7a-b6a174549c16",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obter SG_UE das cidades que elegeram mulheres\n",
    "sg_ue_com_mulheres = mulheres_eleitas['SG_UE'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "7fb66cdb-ed99-465a-bc8e-d0cc3b7efc90",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obter todas as cidades (SG_UF, SG_UE, NM_UE)\n",
    "cidades_completas = df_2016[['SG_UF', 'SG_UE', 'NM_UE']].drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "6ce91b57-4181-4eda-8aa1-08984e663b8b",
   "metadata": {},
   "outputs": [],
   "source": [
    "cidades_sem_mulheres_2016 = cidades_completas[~cidades_completas['SG_UE'].isin(sg_ue_com_mulheres)]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "01f92424-659d-41f9-b32f-a0067b865c7a",
   "metadata": {},
   "source": [
    "## 📅 2020"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "aade6eea-fc6b-45d4-aa24-84f77e6d3eff",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Definir as colunas que você deseja ler\n",
    "colunas_desejadas = ['SG_UE', 'DS_SIT_TOT_TURNO', 'NM_CANDIDATO', 'NM_URNA_CANDIDATO', 'SG_UF', 'NM_UE', 'SG_PARTIDO', 'DS_GENERO']\n",
    "\n",
    "# Ler o arquivo CSV apenas com as colunas especificadas\n",
    "df_2020 = pd.read_csv(\"data/consulta_cand_2020_BRASIL.csv\", delimiter=';', encoding='latin-1', usecols=colunas_desejadas)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "e354b17c-b207-44f7-a408-36c9408ad53a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SG_UF</th>\n",
       "      <th>SG_UE</th>\n",
       "      <th>NM_UE</th>\n",
       "      <th>NM_CANDIDATO</th>\n",
       "      <th>NM_URNA_CANDIDATO</th>\n",
       "      <th>SG_PARTIDO</th>\n",
       "      <th>DS_GENERO</th>\n",
       "      <th>DS_SIT_TOT_TURNO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SP</td>\n",
       "      <td>69833</td>\n",
       "      <td>RIO GRANDE DA SERRA</td>\n",
       "      <td>RICARDO AKIRA ONO AURIANI</td>\n",
       "      <td>AKIRA AURIANI</td>\n",
       "      <td>PSB</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>#NULO#</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PE</td>\n",
       "      <td>24570</td>\n",
       "      <td>JABOATÃO DOS GUARARAPES</td>\n",
       "      <td>FABIO ANDRADE DE OLIVEIRA</td>\n",
       "      <td>FABIO ANDRADE</td>\n",
       "      <td>PROS</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>#NULO#</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PE</td>\n",
       "      <td>24570</td>\n",
       "      <td>JABOATÃO DOS GUARARAPES</td>\n",
       "      <td>EDILEUZA ROSA SILVA DO NASCIMENTO</td>\n",
       "      <td>LEU DO DOM HELDER</td>\n",
       "      <td>PRTB</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>#NULO#</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PB</td>\n",
       "      <td>20478</td>\n",
       "      <td>JACARAÚ</td>\n",
       "      <td>LUCINEIDE GOMES DA SILVA</td>\n",
       "      <td>NINA GOMES</td>\n",
       "      <td>PV</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>#NULO#</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>RJ</td>\n",
       "      <td>58360</td>\n",
       "      <td>TANGUÁ</td>\n",
       "      <td>MARCILEA BRAGA MATOS</td>\n",
       "      <td>MARCIA MATOS</td>\n",
       "      <td>PSL</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>ELEITO POR QP</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  SG_UF  SG_UE                    NM_UE                       NM_CANDIDATO  \\\n",
       "0    SP  69833      RIO GRANDE DA SERRA          RICARDO AKIRA ONO AURIANI   \n",
       "1    PE  24570  JABOATÃO DOS GUARARAPES          FABIO ANDRADE DE OLIVEIRA   \n",
       "2    PE  24570  JABOATÃO DOS GUARARAPES  EDILEUZA ROSA SILVA DO NASCIMENTO   \n",
       "3    PB  20478                  JACARAÚ           LUCINEIDE GOMES DA SILVA   \n",
       "4    RJ  58360                   TANGUÁ               MARCILEA BRAGA MATOS   \n",
       "\n",
       "   NM_URNA_CANDIDATO SG_PARTIDO  DS_GENERO DS_SIT_TOT_TURNO  \n",
       "0      AKIRA AURIANI        PSB  MASCULINO           #NULO#  \n",
       "1      FABIO ANDRADE       PROS  MASCULINO           #NULO#  \n",
       "2  LEU DO DOM HELDER       PRTB   FEMININO           #NULO#  \n",
       "3         NINA GOMES         PV   FEMININO           #NULO#  \n",
       "4       MARCIA MATOS        PSL   FEMININO    ELEITO POR QP  "
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2020.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "c0865508-c4c5-4db9-9299-13353c7773d3",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2020 = df_2020[df_2020['DS_SIT_TOT_TURNO'].isin(['ELEITO', 'ELEITO POR MÉDIA', 'ELEITO POR QP'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "8cd7dfc5-78d7-4878-bed6-a97580178c53",
   "metadata": {},
   "outputs": [],
   "source": [
    "mulheres_eleitas = df_2020[(df_2020['DS_GENERO'] == 'FEMININO')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "c6d5b7d4-aa8b-44e6-87bf-eb4971c4b8e3",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obter SG_UE das cidades que elegeram mulheres\n",
    "sg_ue_com_mulheres = mulheres_eleitas['SG_UE'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "f7a800b2-8857-4ca9-99e2-98070392131f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obter todas as cidades (SG_UF, SG_UE, NM_UE)\n",
    "cidades_completas = df_2020[['SG_UF', 'SG_UE', 'NM_UE']].drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "b1b88cbf-34ee-4c66-81c5-29d230368b3f",
   "metadata": {},
   "outputs": [],
   "source": [
    "cidades_sem_mulheres_2020 = cidades_completas[~cidades_completas['SG_UE'].isin(sg_ue_com_mulheres)]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7939bb6f-ad58-4a48-9cde-e8bfd9527932",
   "metadata": {},
   "source": [
    "## 📅 2024"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "b44bc60b-4afe-4c2c-b0ed-1158ad87e9ca",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Definir as colunas que você deseja ler\n",
    "colunas_desejadas = ['SG_UE', 'DS_SIT_TOT_TURNO', 'NM_CANDIDATO', 'NM_URNA_CANDIDATO', 'SG_UF', 'NM_UE', 'SG_PARTIDO', 'DS_GENERO']\n",
    "\n",
    "# Ler o arquivo CSV apenas com as colunas especificadas\n",
    "df_2024 = pd.read_csv(\"data/consulta_cand_2024_BRASIL.csv\", delimiter=';', encoding='latin-1', usecols=colunas_desejadas)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "c56f9235-605d-4793-a18c-d3898c8bd877",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SG_UF</th>\n",
       "      <th>SG_UE</th>\n",
       "      <th>NM_UE</th>\n",
       "      <th>NM_CANDIDATO</th>\n",
       "      <th>NM_URNA_CANDIDATO</th>\n",
       "      <th>SG_PARTIDO</th>\n",
       "      <th>DS_GENERO</th>\n",
       "      <th>DS_SIT_TOT_TURNO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AM</td>\n",
       "      <td>2712</td>\n",
       "      <td>PAUINI</td>\n",
       "      <td>MANOEL NUNES DA SILVA</td>\n",
       "      <td>MANOEL SERINGUEIRO</td>\n",
       "      <td>PT</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>NÃO ELEITO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>MG</td>\n",
       "      <td>45411</td>\n",
       "      <td>FRUTAL</td>\n",
       "      <td>MARIA EDUARDA BATISTA CANDIDO PEPPE</td>\n",
       "      <td>EDUARDA BATISTA</td>\n",
       "      <td>PODE</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>NÃO ELEITO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>MG</td>\n",
       "      <td>46477</td>\n",
       "      <td>ITAJUBÁ</td>\n",
       "      <td>LUÍS HENRIQUE DOS SANTOS</td>\n",
       "      <td>LUÍS FILHO DO ZÉ BRAZÓPOLIS</td>\n",
       "      <td>PL</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>NÃO ELEITO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CE</td>\n",
       "      <td>15016</td>\n",
       "      <td>PALHANO</td>\n",
       "      <td>ANANIAS FERREIRA DE SOUSA</td>\n",
       "      <td>ANANIAS</td>\n",
       "      <td>UNIÃO</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>NÃO ELEITO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>MG</td>\n",
       "      <td>41998</td>\n",
       "      <td>CAETÉ</td>\n",
       "      <td>ARLISSON PAULINELLI DOS SANTOS</td>\n",
       "      <td>AZIA DO COQUINHO</td>\n",
       "      <td>PDT</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>NÃO ELEITO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  SG_UF  SG_UE    NM_UE                         NM_CANDIDATO  \\\n",
       "0    AM   2712   PAUINI                MANOEL NUNES DA SILVA   \n",
       "1    MG  45411   FRUTAL  MARIA EDUARDA BATISTA CANDIDO PEPPE   \n",
       "2    MG  46477  ITAJUBÁ             LUÍS HENRIQUE DOS SANTOS   \n",
       "3    CE  15016  PALHANO            ANANIAS FERREIRA DE SOUSA   \n",
       "4    MG  41998    CAETÉ       ARLISSON PAULINELLI DOS SANTOS   \n",
       "\n",
       "             NM_URNA_CANDIDATO SG_PARTIDO  DS_GENERO DS_SIT_TOT_TURNO  \n",
       "0           MANOEL SERINGUEIRO         PT  MASCULINO       NÃO ELEITO  \n",
       "1              EDUARDA BATISTA       PODE   FEMININO       NÃO ELEITO  \n",
       "2  LUÍS FILHO DO ZÉ BRAZÓPOLIS         PL  MASCULINO       NÃO ELEITO  \n",
       "3                      ANANIAS      UNIÃO  MASCULINO       NÃO ELEITO  \n",
       "4             AZIA DO COQUINHO        PDT  MASCULINO       NÃO ELEITO  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2024.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "489b71d6-f260-4781-9070-326363e8e375",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2024 = df_2024[df_2024['DS_SIT_TOT_TURNO'].isin(['ELEITO', 'ELEITO POR MÉDIA', 'ELEITO POR QP'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "0325326b-eeb6-44c8-bdbf-204b1d8a4681",
   "metadata": {},
   "outputs": [],
   "source": [
    "mulheres_eleitas = df_2024[(df_2024['DS_GENERO'] == 'FEMININO')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "a9177585-c280-44bc-98bc-5ce77d996b49",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obter SG_UE das cidades que elegeram mulheres\n",
    "sg_ue_com_mulheres = mulheres_eleitas['SG_UE'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "6afeb066-3bd2-42e4-af8a-216d339b9075",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obter todas as cidades (SG_UF, SG_UE, NM_UE)\n",
    "cidades_completas = df_2024[['SG_UF', 'SG_UE', 'NM_UE']].drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "96acc7e6-8f38-4068-ba1f-623ae96abb7f",
   "metadata": {},
   "outputs": [],
   "source": [
    "cidades_sem_mulheres_2024 = cidades_completas[~cidades_completas['SG_UE'].isin(sg_ue_com_mulheres)]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bba6c5eb-197f-488b-a067-7c0c7526bf75",
   "metadata": {},
   "source": [
    "## 🔎 Procurando as cidades sem mulheres"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "3865e87a-1c2e-4d9b-9973-1b8e31c50efa",
   "metadata": {},
   "outputs": [],
   "source": [
    "tabelas = [cidades_sem_mulheres_2000, cidades_sem_mulheres_2004, cidades_sem_mulheres_2008,\n",
    "           cidades_sem_mulheres_2012, cidades_sem_mulheres_2016, cidades_sem_mulheres_2020, cidades_sem_mulheres_2024]\n",
    "\n",
    "# Iniciar com a primeira tabela\n",
    "primeira_tabela = tabelas[0][['SG_UF', 'SG_UE', 'NM_UE']]\n",
    "\n",
    "# Cruzar com as demais tabelas, incluindo SG_UF\n",
    "for i, tabela in enumerate(tabelas[1:], start=1):\n",
    "    df_final = pd.merge(primeira_tabela, tabela[['SG_UF', 'SG_UE', 'NM_UE']], on=['SG_UF', 'SG_UE'], how='inner', suffixes=(f'', f'_ano_{i}'))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "90e50a0e-e578-42f2-8ab8-3390aedae158",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SG_UF</th>\n",
       "      <th>SG_UE</th>\n",
       "      <th>NM_UE</th>\n",
       "      <th>NM_UE_ano_6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>MG</td>\n",
       "      <td>40827</td>\n",
       "      <td>SEM-PEIXE</td>\n",
       "      <td>SEM PEIXE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>RJ</td>\n",
       "      <td>58718</td>\n",
       "      <td>PARACAMBI</td>\n",
       "      <td>PARACAMBI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>RS</td>\n",
       "      <td>98299</td>\n",
       "      <td>JOIA</td>\n",
       "      <td>JÓIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>RS</td>\n",
       "      <td>89435</td>\n",
       "      <td>TRIUNFO</td>\n",
       "      <td>TRIUNFO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>MG</td>\n",
       "      <td>40932</td>\n",
       "      <td>ATALEIA</td>\n",
       "      <td>ATALÉIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>RO</td>\n",
       "      <td>515</td>\n",
       "      <td>NOVO HORIZONTE DO OESTE</td>\n",
       "      <td>NOVO HORIZONTE DO OESTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>SC</td>\n",
       "      <td>81310</td>\n",
       "      <td>HERVAL DO OESTE</td>\n",
       "      <td>HERVAL D'OESTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>MG</td>\n",
       "      <td>40541</td>\n",
       "      <td>PEDRAS DE MARIA DA CRUZ</td>\n",
       "      <td>PEDRAS DE MARIA DA CRUZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>TO</td>\n",
       "      <td>73539</td>\n",
       "      <td>SANTA TEREZINHA DO TOCANTINS</td>\n",
       "      <td>SANTA TEREZINHA DO TOCANTINS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BA</td>\n",
       "      <td>39632</td>\n",
       "      <td>VERA CRUZ</td>\n",
       "      <td>VERA CRUZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>PR</td>\n",
       "      <td>78352</td>\n",
       "      <td>SALTO DO ITARARE</td>\n",
       "      <td>SALTO DO ITARARÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>MG</td>\n",
       "      <td>45039</td>\n",
       "      <td>FAMA</td>\n",
       "      <td>FAMA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>PR</td>\n",
       "      <td>78794</td>\n",
       "      <td>SAO JORGE DO IVAI</td>\n",
       "      <td>SÃO JORGE DO IVAÍ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>MG</td>\n",
       "      <td>43192</td>\n",
       "      <td>CHALE</td>\n",
       "      <td>CHALÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>AM</td>\n",
       "      <td>2135</td>\n",
       "      <td>BENJAMIN CONSTANT</td>\n",
       "      <td>BENJAMIN CONSTANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>MG</td>\n",
       "      <td>46892</td>\n",
       "      <td>ITUTINGA</td>\n",
       "      <td>ITUTINGA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>MG</td>\n",
       "      <td>49158</td>\n",
       "      <td>ONCA DE PITANGUI</td>\n",
       "      <td>ONÇA DE PITANGUI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>MG</td>\n",
       "      <td>46213</td>\n",
       "      <td>INIMUTABA</td>\n",
       "      <td>INIMUTABA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>MT</td>\n",
       "      <td>98736</td>\n",
       "      <td>NOVA OLIMPIA</td>\n",
       "      <td>NOVA OLÍMPIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>BA</td>\n",
       "      <td>33995</td>\n",
       "      <td>CACULE</td>\n",
       "      <td>CACULÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>MG</td>\n",
       "      <td>40053</td>\n",
       "      <td>ABRE CAMPO</td>\n",
       "      <td>ABRE CAMPO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>BA</td>\n",
       "      <td>36714</td>\n",
       "      <td>JUSSARA</td>\n",
       "      <td>JUSSARA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>MG</td>\n",
       "      <td>47570</td>\n",
       "      <td>LAMIM</td>\n",
       "      <td>LAMIM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>SP</td>\n",
       "      <td>61816</td>\n",
       "      <td>ATIBAIA</td>\n",
       "      <td>ATIBAIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>RS</td>\n",
       "      <td>85227</td>\n",
       "      <td>CERRO GRANDE</td>\n",
       "      <td>CERRO GRANDE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>BA</td>\n",
       "      <td>38598</td>\n",
       "      <td>SANTA INES</td>\n",
       "      <td>SANTA INÊS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>RJ</td>\n",
       "      <td>58203</td>\n",
       "      <td>RIO DAS OSTRAS</td>\n",
       "      <td>RIO DAS OSTRAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>BA</td>\n",
       "      <td>38377</td>\n",
       "      <td>RIO DO ANTONIO</td>\n",
       "      <td>RIO DO ANTÔNIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>BA</td>\n",
       "      <td>38210</td>\n",
       "      <td>REMANSO</td>\n",
       "      <td>REMANSO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>MG</td>\n",
       "      <td>40894</td>\n",
       "      <td>ARINOS</td>\n",
       "      <td>ARINOS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>MG</td>\n",
       "      <td>40878</td>\n",
       "      <td>ARGIRITA</td>\n",
       "      <td>ARGIRITA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>MG</td>\n",
       "      <td>49956</td>\n",
       "      <td>PERDIZES</td>\n",
       "      <td>PERDIZES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>MG</td>\n",
       "      <td>41289</td>\n",
       "      <td>PAI PEDRO</td>\n",
       "      <td>PAI PEDRO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>SC</td>\n",
       "      <td>81736</td>\n",
       "      <td>JAGUARUNA</td>\n",
       "      <td>JAGUARUNA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>MG</td>\n",
       "      <td>53015</td>\n",
       "      <td>SAO TOMAS DE AQUINO</td>\n",
       "      <td>SÃO TOMÁS DE AQUINO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>MG</td>\n",
       "      <td>52310</td>\n",
       "      <td>SAO GERALDO DA PIEDADE</td>\n",
       "      <td>SÃO GERALDO DA PIEDADE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>SP</td>\n",
       "      <td>64599</td>\n",
       "      <td>GUARACI</td>\n",
       "      <td>GUARACI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>MG</td>\n",
       "      <td>42188</td>\n",
       "      <td>GUARACIAMA</td>\n",
       "      <td>GUARACIAMA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>SP</td>\n",
       "      <td>61468</td>\n",
       "      <td>UBARANA</td>\n",
       "      <td>UBARANA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>PE</td>\n",
       "      <td>25534</td>\n",
       "      <td>SANTA MARIA DO CAMBUCA</td>\n",
       "      <td>SANTA MARIA DO CAMBUCÁ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>MG</td>\n",
       "      <td>42129</td>\n",
       "      <td>GLAUCILANDIA</td>\n",
       "      <td>GLAUCILÂNDIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>MG</td>\n",
       "      <td>46817</td>\n",
       "      <td>ITUETA</td>\n",
       "      <td>ITUETA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>TO</td>\n",
       "      <td>73393</td>\n",
       "      <td>SAO SALVADOR DO TOCANTINS</td>\n",
       "      <td>SÃO SALVADOR DO TOCANTINS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>GO</td>\n",
       "      <td>94650</td>\n",
       "      <td>MOIPORA</td>\n",
       "      <td>MOIPORÁ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>PR</td>\n",
       "      <td>75086</td>\n",
       "      <td>ARIRANHA DO IVAI</td>\n",
       "      <td>ARIRANHA DO IVAÍ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>GO</td>\n",
       "      <td>92150</td>\n",
       "      <td>ALVORADA DO NORTE</td>\n",
       "      <td>ALVORADA DO NORTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>MT</td>\n",
       "      <td>90409</td>\n",
       "      <td>SAO PEDRO DA CIPA</td>\n",
       "      <td>SÃO PEDRO DA CIPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>SP</td>\n",
       "      <td>61930</td>\n",
       "      <td>BALBINOS</td>\n",
       "      <td>BALBINOS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>ES</td>\n",
       "      <td>57070</td>\n",
       "      <td>MARILANDIA</td>\n",
       "      <td>MARILÂNDIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>PA</td>\n",
       "      <td>4626</td>\n",
       "      <td>PLACAS</td>\n",
       "      <td>PLACAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>MG</td>\n",
       "      <td>54119</td>\n",
       "      <td>VARGEM BONITA</td>\n",
       "      <td>VARGEM BONITA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>PA</td>\n",
       "      <td>4200</td>\n",
       "      <td>JACAREACANGA</td>\n",
       "      <td>JACAREACANGA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>ES</td>\n",
       "      <td>56758</td>\n",
       "      <td>MUQUI</td>\n",
       "      <td>MUQUI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>PA</td>\n",
       "      <td>4308</td>\n",
       "      <td>PAU D'ARCO</td>\n",
       "      <td>PAU D'ARCO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>RJ</td>\n",
       "      <td>58912</td>\n",
       "      <td>SANTA MARIA MADALENA</td>\n",
       "      <td>SANTA MARIA MADALENA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>MG</td>\n",
       "      <td>46493</td>\n",
       "      <td>ITAMARANDIBA</td>\n",
       "      <td>ITAMARANDIBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>GO</td>\n",
       "      <td>93530</td>\n",
       "      <td>FAZENDA NOVA</td>\n",
       "      <td>FAZENDA NOVA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>SP</td>\n",
       "      <td>70351</td>\n",
       "      <td>SANTA GERTRUDES</td>\n",
       "      <td>SANTA GERTRUDES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>RS</td>\n",
       "      <td>88234</td>\n",
       "      <td>ROLANTE</td>\n",
       "      <td>ROLANTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>RS</td>\n",
       "      <td>87955</td>\n",
       "      <td>PIRATINI</td>\n",
       "      <td>PIRATINI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>MG</td>\n",
       "      <td>51276</td>\n",
       "      <td>ROMARIA</td>\n",
       "      <td>ROMARIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>GO</td>\n",
       "      <td>92991</td>\n",
       "      <td>CARMO DO RIO VERDE</td>\n",
       "      <td>CARMO DO RIO VERDE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>MG</td>\n",
       "      <td>41300</td>\n",
       "      <td>PATIS</td>\n",
       "      <td>PATIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>RS</td>\n",
       "      <td>88625</td>\n",
       "      <td>BARRA DO QUARAI</td>\n",
       "      <td>BARRA DO QUARAÍ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>RJ</td>\n",
       "      <td>58459</td>\n",
       "      <td>LAJE DO MURIAE</td>\n",
       "      <td>LAJE DO MURIAÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>MG</td>\n",
       "      <td>45799</td>\n",
       "      <td>GUIRICEMA</td>\n",
       "      <td>GUIRICEMA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>SP</td>\n",
       "      <td>68977</td>\n",
       "      <td>POA</td>\n",
       "      <td>POÁ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>CE</td>\n",
       "      <td>13013</td>\n",
       "      <td>ABAIARA</td>\n",
       "      <td>ABAIARA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>RJ</td>\n",
       "      <td>58750</td>\n",
       "      <td>PARATI</td>\n",
       "      <td>PARATY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>RJ</td>\n",
       "      <td>58360</td>\n",
       "      <td>TANGUA</td>\n",
       "      <td>TANGUÁ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>PI</td>\n",
       "      <td>12718</td>\n",
       "      <td>PAU DARCO DO PIAUI</td>\n",
       "      <td>PAU D'ARCO DO PIAUÍ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>PI</td>\n",
       "      <td>12394</td>\n",
       "      <td>JATOBA DO PIAUI</td>\n",
       "      <td>JATOBÁ DO PIAUÍ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>RO</td>\n",
       "      <td>655</td>\n",
       "      <td>CORUMBIARA</td>\n",
       "      <td>CORUMBIARA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>SP</td>\n",
       "      <td>71498</td>\n",
       "      <td>SUMARE</td>\n",
       "      <td>SUMARÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>ES</td>\n",
       "      <td>56456</td>\n",
       "      <td>GUACUI</td>\n",
       "      <td>GUAÇUÍ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>PR</td>\n",
       "      <td>78433</td>\n",
       "      <td>SANTA CRUZ DO MONTE CASTELO</td>\n",
       "      <td>SANTA CRUZ DE MONTE CASTELO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>SP</td>\n",
       "      <td>72419</td>\n",
       "      <td>VISTA ALEGRE DO ALTO</td>\n",
       "      <td>VISTA ALEGRE DO ALTO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>BA</td>\n",
       "      <td>30775</td>\n",
       "      <td>BARROCAS</td>\n",
       "      <td>BARROCAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>ES</td>\n",
       "      <td>56731</td>\n",
       "      <td>MUNIZ FREIRE</td>\n",
       "      <td>MUNIZ FREIRE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>SC</td>\n",
       "      <td>80241</td>\n",
       "      <td>SANTA ROSA DO SUL</td>\n",
       "      <td>SANTA ROSA DO SUL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>AM</td>\n",
       "      <td>2712</td>\n",
       "      <td>PAUINI</td>\n",
       "      <td>PAUINI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>RS</td>\n",
       "      <td>86088</td>\n",
       "      <td>CERRO BRANCO</td>\n",
       "      <td>CERRO BRANCO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>MG</td>\n",
       "      <td>41580</td>\n",
       "      <td>SAO GERALDO DO BAIXIO</td>\n",
       "      <td>SÃO GERALDO DO BAIXIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>RJ</td>\n",
       "      <td>58467</td>\n",
       "      <td>MESQUITA</td>\n",
       "      <td>MESQUITA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>MA</td>\n",
       "      <td>9393</td>\n",
       "      <td>TUNTUM</td>\n",
       "      <td>TUNTUM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>SC</td>\n",
       "      <td>81116</td>\n",
       "      <td>GOVERNADOR CELSO RAMOS</td>\n",
       "      <td>GOVERNADOR CELSO RAMOS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>PE</td>\n",
       "      <td>25615</td>\n",
       "      <td>SAO CAETANO</td>\n",
       "      <td>SÃO CAITANO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>MG</td>\n",
       "      <td>40266</td>\n",
       "      <td>IPABA</td>\n",
       "      <td>IPABA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>PR</td>\n",
       "      <td>75515</td>\n",
       "      <td>FENIX</td>\n",
       "      <td>FÊNIX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>ES</td>\n",
       "      <td>56359</td>\n",
       "      <td>DIVINO DE SAO LOURENCO</td>\n",
       "      <td>DIVINO DE SÃO LOURENÇO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>MG</td>\n",
       "      <td>46132</td>\n",
       "      <td>INDIANOPOLIS</td>\n",
       "      <td>INDIANÓPOLIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>MG</td>\n",
       "      <td>41645</td>\n",
       "      <td>SAO JOSE DA BARRA</td>\n",
       "      <td>SÃO JOSÉ DA BARRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>PR</td>\n",
       "      <td>75787</td>\n",
       "      <td>SULINA</td>\n",
       "      <td>SULINA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>MG</td>\n",
       "      <td>50733</td>\n",
       "      <td>QUARTEL GERAL</td>\n",
       "      <td>QUARTEL GERAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>MG</td>\n",
       "      <td>43990</td>\n",
       "      <td>CORREGO NOVO</td>\n",
       "      <td>CÓRREGO NOVO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>RJ</td>\n",
       "      <td>58130</td>\n",
       "      <td>CABO FRIO</td>\n",
       "      <td>CABO FRIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>ES</td>\n",
       "      <td>56057</td>\n",
       "      <td>ALFREDO CHAVES</td>\n",
       "      <td>ALFREDO CHAVES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>PR</td>\n",
       "      <td>74543</td>\n",
       "      <td>MAUA DA SERRA</td>\n",
       "      <td>MAUÁ DA SERRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>RS</td>\n",
       "      <td>87637</td>\n",
       "      <td>NOVA BRESCIA</td>\n",
       "      <td>NOVA BRÉSCIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>PB</td>\n",
       "      <td>19259</td>\n",
       "      <td>AROEIRAS</td>\n",
       "      <td>AROEIRAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>PR</td>\n",
       "      <td>78913</td>\n",
       "      <td>SAO PEDRO DO IVAI</td>\n",
       "      <td>SÃO PEDRO DO IVAÍ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>SP</td>\n",
       "      <td>66591</td>\n",
       "      <td>LUTECIA</td>\n",
       "      <td>LUTÉCIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>ES</td>\n",
       "      <td>56014</td>\n",
       "      <td>AFONSO CLAUDIO</td>\n",
       "      <td>AFONSO CLÁUDIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>ES</td>\n",
       "      <td>57991</td>\n",
       "      <td>AGUIA BRANCA</td>\n",
       "      <td>ÁGUIA BRANCA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>TO</td>\n",
       "      <td>73326</td>\n",
       "      <td>CARMOLANDIA</td>\n",
       "      <td>CARMOLÂNDIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>PI</td>\n",
       "      <td>12530</td>\n",
       "      <td>TAMBORIL DO PIAUI</td>\n",
       "      <td>TAMBORIL DO PIAUÍ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>SC</td>\n",
       "      <td>82996</td>\n",
       "      <td>ROMELANDIA</td>\n",
       "      <td>ROMELÂNDIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>MG</td>\n",
       "      <td>52019</td>\n",
       "      <td>SANTO ANTONIO DO GRAMA</td>\n",
       "      <td>SANTO ANTÔNIO DO GRAMA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>PE</td>\n",
       "      <td>25470</td>\n",
       "      <td>SANHARO</td>\n",
       "      <td>SANHARÓ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>MG</td>\n",
       "      <td>41386</td>\n",
       "      <td>PINTOPOLIS</td>\n",
       "      <td>PINTÓPOLIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>RJ</td>\n",
       "      <td>59293</td>\n",
       "      <td>ITALVA</td>\n",
       "      <td>ITALVA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>BA</td>\n",
       "      <td>30759</td>\n",
       "      <td>BARRO ALTO</td>\n",
       "      <td>BARRO ALTO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>MG</td>\n",
       "      <td>49131</td>\n",
       "      <td>OLIVEIRA FORTES</td>\n",
       "      <td>OLIVEIRA FORTES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>SP</td>\n",
       "      <td>61549</td>\n",
       "      <td>VARGEM</td>\n",
       "      <td>VARGEM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>SC</td>\n",
       "      <td>80721</td>\n",
       "      <td>SANTA HELENA</td>\n",
       "      <td>SANTA HELENA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>PR</td>\n",
       "      <td>74314</td>\n",
       "      <td>ARARUNA</td>\n",
       "      <td>ARARUNA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>RS</td>\n",
       "      <td>89184</td>\n",
       "      <td>CORONEL PILAR</td>\n",
       "      <td>CORONEL PILAR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>PB</td>\n",
       "      <td>19828</td>\n",
       "      <td>RIACHO DE SANTO ANTONIO</td>\n",
       "      <td>RIACHO DE SANTO ANTÔNIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>SE</td>\n",
       "      <td>32352</td>\n",
       "      <td>SAO DOMINGOS</td>\n",
       "      <td>SÃO DOMINGOS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>RO</td>\n",
       "      <td>736</td>\n",
       "      <td>ALTO ALEGRE DOS PARECIS</td>\n",
       "      <td>ALTO ALEGRE DOS PARECIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>RJ</td>\n",
       "      <td>58793</td>\n",
       "      <td>PIRAI</td>\n",
       "      <td>PIRAÍ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>RJ</td>\n",
       "      <td>58955</td>\n",
       "      <td>SAO FIDELIS</td>\n",
       "      <td>SÃO FIDÉLIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>PR</td>\n",
       "      <td>77895</td>\n",
       "      <td>PRIMEIRO DE MAIO</td>\n",
       "      <td>PRIMEIRO DE MAIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>AL</td>\n",
       "      <td>28010</td>\n",
       "      <td>MATRIZ DE CAMARAGIBE</td>\n",
       "      <td>MATRIZ DE CAMARAGIBE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>SP</td>\n",
       "      <td>67474</td>\n",
       "      <td>NATIVIDADE DA SERRA</td>\n",
       "      <td>NATIVIDADE DA SERRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>PI</td>\n",
       "      <td>12319</td>\n",
       "      <td>ALAGOINHA</td>\n",
       "      <td>ALAGOINHA DO PIAUÍ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>SP</td>\n",
       "      <td>61719</td>\n",
       "      <td>AREIOPOLIS</td>\n",
       "      <td>AREIÓPOLIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>RS</td>\n",
       "      <td>87670</td>\n",
       "      <td>NOVA PETROPOLIS</td>\n",
       "      <td>NOVA PETRÓPOLIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>AM</td>\n",
       "      <td>2879</td>\n",
       "      <td>URUCURITUBA</td>\n",
       "      <td>URUCURITUBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>SP</td>\n",
       "      <td>62405</td>\n",
       "      <td>PAULISTANIA</td>\n",
       "      <td>PAULISTÂNIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>MS</td>\n",
       "      <td>91073</td>\n",
       "      <td>MARACAJU</td>\n",
       "      <td>MARACAJU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>RS</td>\n",
       "      <td>86711</td>\n",
       "      <td>GAURAMA</td>\n",
       "      <td>GAURAMA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>SP</td>\n",
       "      <td>63614</td>\n",
       "      <td>COTIA</td>\n",
       "      <td>COTIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>MG</td>\n",
       "      <td>44652</td>\n",
       "      <td>DORES DO TURVO</td>\n",
       "      <td>DORES DO TURVO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>SP</td>\n",
       "      <td>61697</td>\n",
       "      <td>AREIAS</td>\n",
       "      <td>AREIAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>GO</td>\n",
       "      <td>93190</td>\n",
       "      <td>CORUMBAIBA</td>\n",
       "      <td>CORUMBAÍBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>MG</td>\n",
       "      <td>47414</td>\n",
       "      <td>LAGAMAR</td>\n",
       "      <td>LAGAMAR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>GO</td>\n",
       "      <td>92169</td>\n",
       "      <td>MORRO AGUDO DE GOIAS</td>\n",
       "      <td>MORRO AGUDO DE GOIÁS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>RS</td>\n",
       "      <td>86754</td>\n",
       "      <td>SAO VICENTE DO SUL</td>\n",
       "      <td>SÃO VICENTE DO SUL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>MG</td>\n",
       "      <td>43516</td>\n",
       "      <td>CONCEICAO DO PARA</td>\n",
       "      <td>CONCEIÇÃO DO PARÁ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>MG</td>\n",
       "      <td>42480</td>\n",
       "      <td>VARGEM GRANDE DO RIO PARDO</td>\n",
       "      <td>VARGEM GRANDE DO RIO PARDO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>MG</td>\n",
       "      <td>42145</td>\n",
       "      <td>GOIABEIRA</td>\n",
       "      <td>GOIABEIRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>PA</td>\n",
       "      <td>5797</td>\n",
       "      <td>SAO GERALDO DO ARAGUAIA</td>\n",
       "      <td>SÃO GERALDO DO ARAGUAIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>MG</td>\n",
       "      <td>49638</td>\n",
       "      <td>PATROCINIO DO MURIAE</td>\n",
       "      <td>PATROCÍNIO DO MURIAÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>MG</td>\n",
       "      <td>47139</td>\n",
       "      <td>JEQUITIBA</td>\n",
       "      <td>JEQUITIBÁ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>MG</td>\n",
       "      <td>52078</td>\n",
       "      <td>SANTO ANTONIO DO MONTE</td>\n",
       "      <td>SANTO ANTÔNIO DO MONTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>SP</td>\n",
       "      <td>65250</td>\n",
       "      <td>IPORANGA</td>\n",
       "      <td>IPORANGA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>MG</td>\n",
       "      <td>47090</td>\n",
       "      <td>JEQUERI</td>\n",
       "      <td>JEQUERI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>PR</td>\n",
       "      <td>75027</td>\n",
       "      <td>NOVA ESPERANCA DO SUDOESTE</td>\n",
       "      <td>NOVA ESPERANÇA DO SUDOESTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>PI</td>\n",
       "      <td>12548</td>\n",
       "      <td>VILA NOVA DO PIAUI</td>\n",
       "      <td>VILA NOVA DO PIAUÍ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>RJ</td>\n",
       "      <td>58378</td>\n",
       "      <td>ITABORAI</td>\n",
       "      <td>ITABORAÍ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>MG</td>\n",
       "      <td>49018</td>\n",
       "      <td>NOVA RESENDE</td>\n",
       "      <td>NOVA RESENDE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>SP</td>\n",
       "      <td>72230</td>\n",
       "      <td>VALENTIM GENTIL</td>\n",
       "      <td>VALENTIM GENTIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>RS</td>\n",
       "      <td>89206</td>\n",
       "      <td>CRUZALTENSE</td>\n",
       "      <td>CRUZALTENSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>MG</td>\n",
       "      <td>51233</td>\n",
       "      <td>ROCHEDO DE MINAS</td>\n",
       "      <td>ROCHEDO DE MINAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>PB</td>\n",
       "      <td>19330</td>\n",
       "      <td>BARRA DE SANTA ROSA</td>\n",
       "      <td>BARRA DE SANTA ROSA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>MA</td>\n",
       "      <td>7102</td>\n",
       "      <td>ARAGUANA</td>\n",
       "      <td>ARAGUANÃ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>BA</td>\n",
       "      <td>33057</td>\n",
       "      <td>ACAJUTIBA</td>\n",
       "      <td>ACAJUTIBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>RS</td>\n",
       "      <td>87092</td>\n",
       "      <td>INDEPENDENCIA</td>\n",
       "      <td>INDEPENDÊNCIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>MG</td>\n",
       "      <td>51713</td>\n",
       "      <td>SANTANA DO DESERTO</td>\n",
       "      <td>SANTANA DO DESERTO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>SC</td>\n",
       "      <td>83330</td>\n",
       "      <td>SAO LOURENCO DO OESTE</td>\n",
       "      <td>SÃO LOURENÇO DO OESTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>SC</td>\n",
       "      <td>83097</td>\n",
       "      <td>SANTO AMARO DA IMPERATRIZ</td>\n",
       "      <td>SANTO AMARO DA IMPERATRIZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>PB</td>\n",
       "      <td>19984</td>\n",
       "      <td>MATUREIA</td>\n",
       "      <td>MATURÉIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>PE</td>\n",
       "      <td>23337</td>\n",
       "      <td>BELO JARDIM</td>\n",
       "      <td>BELO JARDIM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>PI</td>\n",
       "      <td>12220</td>\n",
       "      <td>LAGOA DO SITIO</td>\n",
       "      <td>LAGOA DO SÍTIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>BA</td>\n",
       "      <td>39330</td>\n",
       "      <td>TERRA NOVA</td>\n",
       "      <td>TERRA NOVA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>SC</td>\n",
       "      <td>80942</td>\n",
       "      <td>SAO CRISTOVAO DO SUL</td>\n",
       "      <td>SÃO CRISTÓVÃO DO SUL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>BA</td>\n",
       "      <td>33952</td>\n",
       "      <td>CAATIBA</td>\n",
       "      <td>CAATIBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>PR</td>\n",
       "      <td>75396</td>\n",
       "      <td>DIAMANTE DO NORTE</td>\n",
       "      <td>DIAMANTE DO NORTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>MG</td>\n",
       "      <td>42374</td>\n",
       "      <td>CANA VERDE</td>\n",
       "      <td>CANA VERDE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>SC</td>\n",
       "      <td>81221</td>\n",
       "      <td>BELA VISTA DO TOLDO</td>\n",
       "      <td>BELA VISTA DO TOLDO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>GO</td>\n",
       "      <td>92053</td>\n",
       "      <td>ALEXANIA</td>\n",
       "      <td>ALEXÂNIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>MG</td>\n",
       "      <td>42870</td>\n",
       "      <td>CARMO DO RIO CLARO</td>\n",
       "      <td>CARMO DO RIO CLARO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>MG</td>\n",
       "      <td>42617</td>\n",
       "      <td>CARANAIBA</td>\n",
       "      <td>CARANAÍBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>RS</td>\n",
       "      <td>88340</td>\n",
       "      <td>CARAA</td>\n",
       "      <td>CARAÁ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>SP</td>\n",
       "      <td>64394</td>\n",
       "      <td>GENERAL SALGADO</td>\n",
       "      <td>GENERAL SALGADO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>MG</td>\n",
       "      <td>41467</td>\n",
       "      <td>SANTA CRUZ DE MINAS</td>\n",
       "      <td>SANTA CRUZ DE MINAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>PB</td>\n",
       "      <td>19941</td>\n",
       "      <td>BOA VISTA</td>\n",
       "      <td>BOA VISTA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>SP</td>\n",
       "      <td>71250</td>\n",
       "      <td>SARUTAIA</td>\n",
       "      <td>SARUTAIÁ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>GO</td>\n",
       "      <td>94919</td>\n",
       "      <td>NOVA AMERICA</td>\n",
       "      <td>NOVA AMÉRICA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>MG</td>\n",
       "      <td>51195</td>\n",
       "      <td>RIO VERMELHO</td>\n",
       "      <td>RIO VERMELHO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>GO</td>\n",
       "      <td>93637</td>\n",
       "      <td>FORMOSO</td>\n",
       "      <td>FORMOSO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>BA</td>\n",
       "      <td>37150</td>\n",
       "      <td>MARAU</td>\n",
       "      <td>MARAÚ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>RS</td>\n",
       "      <td>88048</td>\n",
       "      <td>UNIAO DA SERRA</td>\n",
       "      <td>UNIÃO DA SERRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>AM</td>\n",
       "      <td>2011</td>\n",
       "      <td>NOVO AYRAO</td>\n",
       "      <td>NOVO AIRÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>AM</td>\n",
       "      <td>2356</td>\n",
       "      <td>HUMAITA</td>\n",
       "      <td>HUMAITÁ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>RS</td>\n",
       "      <td>86525</td>\n",
       "      <td>CARLOS GOMES</td>\n",
       "      <td>CARLOS GOMES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>PR</td>\n",
       "      <td>79812</td>\n",
       "      <td>BOA VISTA DA APARECIDA</td>\n",
       "      <td>BOA VISTA DA APARECIDA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>MG</td>\n",
       "      <td>45632</td>\n",
       "      <td>GUARACIABA</td>\n",
       "      <td>GUARACIABA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>PR</td>\n",
       "      <td>74640</td>\n",
       "      <td>PINHAL DE SAO BENTO</td>\n",
       "      <td>PINHAL DE SÃO BENTO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>RS</td>\n",
       "      <td>89478</td>\n",
       "      <td>TUPANCIRETA</td>\n",
       "      <td>TUPANCIRETÃ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>MG</td>\n",
       "      <td>53813</td>\n",
       "      <td>TOLEDO</td>\n",
       "      <td>TOLEDO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>MG</td>\n",
       "      <td>45250</td>\n",
       "      <td>FORTALEZA DE MINAS</td>\n",
       "      <td>FORTALEZA DE MINAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>GO</td>\n",
       "      <td>92797</td>\n",
       "      <td>CABECEIRAS</td>\n",
       "      <td>CABECEIRAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>RS</td>\n",
       "      <td>87319</td>\n",
       "      <td>LAVRAS DO SUL</td>\n",
       "      <td>LAVRAS DO SUL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>SC</td>\n",
       "      <td>83615</td>\n",
       "      <td>TREZE DE MAIO</td>\n",
       "      <td>TREZE DE MAIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>MG</td>\n",
       "      <td>47376</td>\n",
       "      <td>JURUAIA</td>\n",
       "      <td>JURUAIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>BA</td>\n",
       "      <td>30910</td>\n",
       "      <td>FILADELFIA</td>\n",
       "      <td>FILADÉLFIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>RS</td>\n",
       "      <td>85081</td>\n",
       "      <td>EREBANGO</td>\n",
       "      <td>EREBANGO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    SG_UF  SG_UE                         NM_UE                   NM_UE_ano_6\n",
       "0      MG  40827                     SEM-PEIXE                     SEM PEIXE\n",
       "1      RJ  58718                     PARACAMBI                     PARACAMBI\n",
       "2      RS  98299                          JOIA                          JÓIA\n",
       "3      RS  89435                       TRIUNFO                       TRIUNFO\n",
       "4      MG  40932                       ATALEIA                       ATALÉIA\n",
       "5      RO    515       NOVO HORIZONTE DO OESTE       NOVO HORIZONTE DO OESTE\n",
       "6      SC  81310               HERVAL DO OESTE                HERVAL D'OESTE\n",
       "7      MG  40541       PEDRAS DE MARIA DA CRUZ       PEDRAS DE MARIA DA CRUZ\n",
       "8      TO  73539  SANTA TEREZINHA DO TOCANTINS  SANTA TEREZINHA DO TOCANTINS\n",
       "9      BA  39632                     VERA CRUZ                     VERA CRUZ\n",
       "10     PR  78352              SALTO DO ITARARE              SALTO DO ITARARÉ\n",
       "11     MG  45039                          FAMA                          FAMA\n",
       "12     PR  78794             SAO JORGE DO IVAI             SÃO JORGE DO IVAÍ\n",
       "13     MG  43192                         CHALE                         CHALÉ\n",
       "14     AM   2135             BENJAMIN CONSTANT             BENJAMIN CONSTANT\n",
       "15     MG  46892                      ITUTINGA                      ITUTINGA\n",
       "16     MG  49158              ONCA DE PITANGUI              ONÇA DE PITANGUI\n",
       "17     MG  46213                     INIMUTABA                     INIMUTABA\n",
       "18     MT  98736                  NOVA OLIMPIA                  NOVA OLÍMPIA\n",
       "19     BA  33995                        CACULE                        CACULÉ\n",
       "20     MG  40053                    ABRE CAMPO                    ABRE CAMPO\n",
       "21     BA  36714                       JUSSARA                       JUSSARA\n",
       "22     MG  47570                         LAMIM                         LAMIM\n",
       "23     SP  61816                       ATIBAIA                       ATIBAIA\n",
       "24     RS  85227                  CERRO GRANDE                  CERRO GRANDE\n",
       "25     BA  38598                    SANTA INES                    SANTA INÊS\n",
       "26     RJ  58203                RIO DAS OSTRAS                RIO DAS OSTRAS\n",
       "27     BA  38377                RIO DO ANTONIO                RIO DO ANTÔNIO\n",
       "28     BA  38210                       REMANSO                       REMANSO\n",
       "29     MG  40894                        ARINOS                        ARINOS\n",
       "30     MG  40878                      ARGIRITA                      ARGIRITA\n",
       "31     MG  49956                      PERDIZES                      PERDIZES\n",
       "32     MG  41289                     PAI PEDRO                     PAI PEDRO\n",
       "33     SC  81736                     JAGUARUNA                     JAGUARUNA\n",
       "34     MG  53015           SAO TOMAS DE AQUINO           SÃO TOMÁS DE AQUINO\n",
       "35     MG  52310        SAO GERALDO DA PIEDADE        SÃO GERALDO DA PIEDADE\n",
       "36     SP  64599                       GUARACI                       GUARACI\n",
       "37     MG  42188                    GUARACIAMA                    GUARACIAMA\n",
       "38     SP  61468                       UBARANA                       UBARANA\n",
       "39     PE  25534        SANTA MARIA DO CAMBUCA        SANTA MARIA DO CAMBUCÁ\n",
       "40     MG  42129                  GLAUCILANDIA                  GLAUCILÂNDIA\n",
       "41     MG  46817                        ITUETA                        ITUETA\n",
       "42     TO  73393     SAO SALVADOR DO TOCANTINS     SÃO SALVADOR DO TOCANTINS\n",
       "43     GO  94650                       MOIPORA                       MOIPORÁ\n",
       "44     PR  75086              ARIRANHA DO IVAI              ARIRANHA DO IVAÍ\n",
       "45     GO  92150             ALVORADA DO NORTE             ALVORADA DO NORTE\n",
       "46     MT  90409             SAO PEDRO DA CIPA             SÃO PEDRO DA CIPA\n",
       "47     SP  61930                      BALBINOS                      BALBINOS\n",
       "48     ES  57070                    MARILANDIA                    MARILÂNDIA\n",
       "49     PA   4626                        PLACAS                        PLACAS\n",
       "50     MG  54119                 VARGEM BONITA                 VARGEM BONITA\n",
       "51     PA   4200                  JACAREACANGA                  JACAREACANGA\n",
       "52     ES  56758                         MUQUI                         MUQUI\n",
       "53     PA   4308                    PAU D'ARCO                    PAU D'ARCO\n",
       "54     RJ  58912          SANTA MARIA MADALENA          SANTA MARIA MADALENA\n",
       "55     MG  46493                  ITAMARANDIBA                  ITAMARANDIBA\n",
       "56     GO  93530                  FAZENDA NOVA                  FAZENDA NOVA\n",
       "57     SP  70351               SANTA GERTRUDES               SANTA GERTRUDES\n",
       "58     RS  88234                       ROLANTE                       ROLANTE\n",
       "59     RS  87955                      PIRATINI                      PIRATINI\n",
       "60     MG  51276                       ROMARIA                       ROMARIA\n",
       "61     GO  92991            CARMO DO RIO VERDE            CARMO DO RIO VERDE\n",
       "62     MG  41300                         PATIS                         PATIS\n",
       "63     RS  88625               BARRA DO QUARAI               BARRA DO QUARAÍ\n",
       "64     RJ  58459                LAJE DO MURIAE                LAJE DO MURIAÉ\n",
       "65     MG  45799                     GUIRICEMA                     GUIRICEMA\n",
       "66     SP  68977                           POA                           POÁ\n",
       "67     CE  13013                       ABAIARA                       ABAIARA\n",
       "68     RJ  58750                        PARATI                        PARATY\n",
       "69     RJ  58360                        TANGUA                        TANGUÁ\n",
       "70     PI  12718            PAU DARCO DO PIAUI           PAU D'ARCO DO PIAUÍ\n",
       "71     PI  12394               JATOBA DO PIAUI               JATOBÁ DO PIAUÍ\n",
       "72     RO    655                    CORUMBIARA                    CORUMBIARA\n",
       "73     SP  71498                        SUMARE                        SUMARÉ\n",
       "74     ES  56456                        GUACUI                        GUAÇUÍ\n",
       "75     PR  78433   SANTA CRUZ DO MONTE CASTELO   SANTA CRUZ DE MONTE CASTELO\n",
       "76     SP  72419          VISTA ALEGRE DO ALTO          VISTA ALEGRE DO ALTO\n",
       "77     BA  30775                      BARROCAS                      BARROCAS\n",
       "78     ES  56731                  MUNIZ FREIRE                  MUNIZ FREIRE\n",
       "79     SC  80241             SANTA ROSA DO SUL             SANTA ROSA DO SUL\n",
       "80     AM   2712                        PAUINI                        PAUINI\n",
       "81     RS  86088                  CERRO BRANCO                  CERRO BRANCO\n",
       "82     MG  41580         SAO GERALDO DO BAIXIO         SÃO GERALDO DO BAIXIO\n",
       "83     RJ  58467                      MESQUITA                      MESQUITA\n",
       "84     MA   9393                        TUNTUM                        TUNTUM\n",
       "85     SC  81116        GOVERNADOR CELSO RAMOS        GOVERNADOR CELSO RAMOS\n",
       "86     PE  25615                   SAO CAETANO                   SÃO CAITANO\n",
       "87     MG  40266                         IPABA                         IPABA\n",
       "88     PR  75515                         FENIX                         FÊNIX\n",
       "89     ES  56359        DIVINO DE SAO LOURENCO        DIVINO DE SÃO LOURENÇO\n",
       "90     MG  46132                  INDIANOPOLIS                  INDIANÓPOLIS\n",
       "91     MG  41645             SAO JOSE DA BARRA             SÃO JOSÉ DA BARRA\n",
       "92     PR  75787                        SULINA                        SULINA\n",
       "93     MG  50733                 QUARTEL GERAL                 QUARTEL GERAL\n",
       "94     MG  43990                  CORREGO NOVO                  CÓRREGO NOVO\n",
       "95     RJ  58130                     CABO FRIO                     CABO FRIO\n",
       "96     ES  56057                ALFREDO CHAVES                ALFREDO CHAVES\n",
       "97     PR  74543                 MAUA DA SERRA                 MAUÁ DA SERRA\n",
       "98     RS  87637                  NOVA BRESCIA                  NOVA BRÉSCIA\n",
       "99     PB  19259                      AROEIRAS                      AROEIRAS\n",
       "100    PR  78913             SAO PEDRO DO IVAI             SÃO PEDRO DO IVAÍ\n",
       "101    SP  66591                       LUTECIA                       LUTÉCIA\n",
       "102    ES  56014                AFONSO CLAUDIO                AFONSO CLÁUDIO\n",
       "103    ES  57991                  AGUIA BRANCA                  ÁGUIA BRANCA\n",
       "104    TO  73326                   CARMOLANDIA                   CARMOLÂNDIA\n",
       "105    PI  12530             TAMBORIL DO PIAUI             TAMBORIL DO PIAUÍ\n",
       "106    SC  82996                    ROMELANDIA                    ROMELÂNDIA\n",
       "107    MG  52019        SANTO ANTONIO DO GRAMA        SANTO ANTÔNIO DO GRAMA\n",
       "108    PE  25470                       SANHARO                       SANHARÓ\n",
       "109    MG  41386                    PINTOPOLIS                    PINTÓPOLIS\n",
       "110    RJ  59293                        ITALVA                        ITALVA\n",
       "111    BA  30759                    BARRO ALTO                    BARRO ALTO\n",
       "112    MG  49131               OLIVEIRA FORTES               OLIVEIRA FORTES\n",
       "113    SP  61549                        VARGEM                        VARGEM\n",
       "114    SC  80721                  SANTA HELENA                  SANTA HELENA\n",
       "115    PR  74314                       ARARUNA                       ARARUNA\n",
       "116    RS  89184                 CORONEL PILAR                 CORONEL PILAR\n",
       "117    PB  19828       RIACHO DE SANTO ANTONIO       RIACHO DE SANTO ANTÔNIO\n",
       "118    SE  32352                  SAO DOMINGOS                  SÃO DOMINGOS\n",
       "119    RO    736       ALTO ALEGRE DOS PARECIS       ALTO ALEGRE DOS PARECIS\n",
       "120    RJ  58793                         PIRAI                         PIRAÍ\n",
       "121    RJ  58955                   SAO FIDELIS                   SÃO FIDÉLIS\n",
       "122    PR  77895              PRIMEIRO DE MAIO              PRIMEIRO DE MAIO\n",
       "123    AL  28010          MATRIZ DE CAMARAGIBE          MATRIZ DE CAMARAGIBE\n",
       "124    SP  67474           NATIVIDADE DA SERRA           NATIVIDADE DA SERRA\n",
       "125    PI  12319                     ALAGOINHA            ALAGOINHA DO PIAUÍ\n",
       "126    SP  61719                    AREIOPOLIS                    AREIÓPOLIS\n",
       "127    RS  87670               NOVA PETROPOLIS               NOVA PETRÓPOLIS\n",
       "128    AM   2879                   URUCURITUBA                   URUCURITUBA\n",
       "129    SP  62405                   PAULISTANIA                   PAULISTÂNIA\n",
       "130    MS  91073                      MARACAJU                      MARACAJU\n",
       "131    RS  86711                       GAURAMA                       GAURAMA\n",
       "132    SP  63614                         COTIA                         COTIA\n",
       "133    MG  44652                DORES DO TURVO                DORES DO TURVO\n",
       "134    SP  61697                        AREIAS                        AREIAS\n",
       "135    GO  93190                    CORUMBAIBA                    CORUMBAÍBA\n",
       "136    MG  47414                       LAGAMAR                       LAGAMAR\n",
       "137    GO  92169          MORRO AGUDO DE GOIAS          MORRO AGUDO DE GOIÁS\n",
       "138    RS  86754            SAO VICENTE DO SUL            SÃO VICENTE DO SUL\n",
       "139    MG  43516             CONCEICAO DO PARA             CONCEIÇÃO DO PARÁ\n",
       "140    MG  42480    VARGEM GRANDE DO RIO PARDO    VARGEM GRANDE DO RIO PARDO\n",
       "141    MG  42145                     GOIABEIRA                     GOIABEIRA\n",
       "142    PA   5797       SAO GERALDO DO ARAGUAIA       SÃO GERALDO DO ARAGUAIA\n",
       "143    MG  49638          PATROCINIO DO MURIAE          PATROCÍNIO DO MURIAÉ\n",
       "144    MG  47139                     JEQUITIBA                     JEQUITIBÁ\n",
       "145    MG  52078        SANTO ANTONIO DO MONTE        SANTO ANTÔNIO DO MONTE\n",
       "146    SP  65250                      IPORANGA                      IPORANGA\n",
       "147    MG  47090                       JEQUERI                       JEQUERI\n",
       "148    PR  75027    NOVA ESPERANCA DO SUDOESTE    NOVA ESPERANÇA DO SUDOESTE\n",
       "149    PI  12548            VILA NOVA DO PIAUI            VILA NOVA DO PIAUÍ\n",
       "150    RJ  58378                      ITABORAI                      ITABORAÍ\n",
       "151    MG  49018                  NOVA RESENDE                  NOVA RESENDE\n",
       "152    SP  72230               VALENTIM GENTIL               VALENTIM GENTIL\n",
       "153    RS  89206                   CRUZALTENSE                   CRUZALTENSE\n",
       "154    MG  51233              ROCHEDO DE MINAS              ROCHEDO DE MINAS\n",
       "155    PB  19330           BARRA DE SANTA ROSA           BARRA DE SANTA ROSA\n",
       "156    MA   7102                      ARAGUANA                      ARAGUANÃ\n",
       "157    BA  33057                     ACAJUTIBA                     ACAJUTIBA\n",
       "158    RS  87092                 INDEPENDENCIA                 INDEPENDÊNCIA\n",
       "159    MG  51713            SANTANA DO DESERTO            SANTANA DO DESERTO\n",
       "160    SC  83330         SAO LOURENCO DO OESTE         SÃO LOURENÇO DO OESTE\n",
       "161    SC  83097     SANTO AMARO DA IMPERATRIZ     SANTO AMARO DA IMPERATRIZ\n",
       "162    PB  19984                      MATUREIA                      MATURÉIA\n",
       "163    PE  23337                   BELO JARDIM                   BELO JARDIM\n",
       "164    PI  12220                LAGOA DO SITIO                LAGOA DO SÍTIO\n",
       "165    BA  39330                    TERRA NOVA                    TERRA NOVA\n",
       "166    SC  80942          SAO CRISTOVAO DO SUL          SÃO CRISTÓVÃO DO SUL\n",
       "167    BA  33952                       CAATIBA                       CAATIBA\n",
       "168    PR  75396             DIAMANTE DO NORTE             DIAMANTE DO NORTE\n",
       "169    MG  42374                    CANA VERDE                    CANA VERDE\n",
       "170    SC  81221           BELA VISTA DO TOLDO           BELA VISTA DO TOLDO\n",
       "171    GO  92053                      ALEXANIA                      ALEXÂNIA\n",
       "172    MG  42870            CARMO DO RIO CLARO            CARMO DO RIO CLARO\n",
       "173    MG  42617                     CARANAIBA                     CARANAÍBA\n",
       "174    RS  88340                         CARAA                         CARAÁ\n",
       "175    SP  64394               GENERAL SALGADO               GENERAL SALGADO\n",
       "176    MG  41467           SANTA CRUZ DE MINAS           SANTA CRUZ DE MINAS\n",
       "177    PB  19941                     BOA VISTA                     BOA VISTA\n",
       "178    SP  71250                      SARUTAIA                      SARUTAIÁ\n",
       "179    GO  94919                  NOVA AMERICA                  NOVA AMÉRICA\n",
       "180    MG  51195                  RIO VERMELHO                  RIO VERMELHO\n",
       "181    GO  93637                       FORMOSO                       FORMOSO\n",
       "182    BA  37150                         MARAU                         MARAÚ\n",
       "183    RS  88048                UNIAO DA SERRA                UNIÃO DA SERRA\n",
       "184    AM   2011                    NOVO AYRAO                    NOVO AIRÃO\n",
       "185    AM   2356                       HUMAITA                       HUMAITÁ\n",
       "186    RS  86525                  CARLOS GOMES                  CARLOS GOMES\n",
       "187    PR  79812        BOA VISTA DA APARECIDA        BOA VISTA DA APARECIDA\n",
       "188    MG  45632                    GUARACIABA                    GUARACIABA\n",
       "189    PR  74640           PINHAL DE SAO BENTO           PINHAL DE SÃO BENTO\n",
       "190    RS  89478                   TUPANCIRETA                   TUPANCIRETÃ\n",
       "191    MG  53813                        TOLEDO                        TOLEDO\n",
       "192    MG  45250            FORTALEZA DE MINAS            FORTALEZA DE MINAS\n",
       "193    GO  92797                    CABECEIRAS                    CABECEIRAS\n",
       "194    RS  87319                 LAVRAS DO SUL                 LAVRAS DO SUL\n",
       "195    SC  83615                 TREZE DE MAIO                 TREZE DE MAIO\n",
       "196    MG  47376                       JURUAIA                       JURUAIA\n",
       "197    BA  30910                    FILADELFIA                    FILADÉLFIA\n",
       "198    RS  85081                      EREBANGO                      EREBANGO"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_final"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a74a593f-2438-4444-b423-c4c9c7e86ccb",
   "metadata": {},
   "source": [
    "### 💡 Todas as cidades acima tiveram uma segundo checagem para validação, com envio de emails e pesquisa em jornais antigos sobre a presença de mulheres na política."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}