Candidatos que mudaram declaração de raça-cor.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "f1fb628d-7939-45c0-b1ba-dfbd8a1886e0",
   "metadata": {},
   "source": [
    "## Código utilizado para análise de dados da reportagem: [4,4 mil candidatos que se declararam negros voltam a se declarar brancos em 2024, quando verba para negros será menor](https://g1.globo.com/politica/eleicoes/2024/eleicao-em-numeros/noticia/2024/10/05/44-mil-candidatos-voltam-a-se-declarar-brancos-em-2024-quando-verba-para-negros-sera-menor.ghtml)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "d0f6439a-79c4-4d25-8e88-0548a595bb32",
   "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"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "2e1ecea0-04b6-4ffc-895c-adf060c8da56",
   "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": "63e75ac8-2f8d-47a0-9f1d-447c54ae0c77",
   "metadata": {},
   "source": [
    "## 📅 2016"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "4e23e44e-3542-4468-ab6f-68eaf2326f6e",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\judite\\AppData\\Local\\Temp\\ipykernel_1896\\1729244441.py:1: DtypeWarning: Columns (61) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  df_2016 = pd.read_csv(\"consulta_cand_2016_BRASIL.csv\", delimiter =';', encoding='latin-1')\n"
     ]
    }
   ],
   "source": [
    "df_2016 = pd.read_csv(\"data/consulta_cand_2016_BRASIL.csv\", delimiter =';', encoding='latin-1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "08f7485f-d1ee-4db3-b62d-f783759fd50e",
   "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>DT_GERACAO</th>\n",
       "      <th>HH_GERACAO</th>\n",
       "      <th>ANO_ELEICAO</th>\n",
       "      <th>CD_TIPO_ELEICAO</th>\n",
       "      <th>NM_TIPO_ELEICAO</th>\n",
       "      <th>NR_TURNO</th>\n",
       "      <th>CD_ELEICAO</th>\n",
       "      <th>DS_ELEICAO</th>\n",
       "      <th>DT_ELEICAO</th>\n",
       "      <th>TP_ABRANGENCIA</th>\n",
       "      <th>SG_UF</th>\n",
       "      <th>SG_UE</th>\n",
       "      <th>NM_UE</th>\n",
       "      <th>CD_CARGO</th>\n",
       "      <th>DS_CARGO</th>\n",
       "      <th>SQ_CANDIDATO</th>\n",
       "      <th>NR_CANDIDATO</th>\n",
       "      <th>NM_CANDIDATO</th>\n",
       "      <th>NM_URNA_CANDIDATO</th>\n",
       "      <th>NM_SOCIAL_CANDIDATO</th>\n",
       "      <th>NR_CPF_CANDIDATO</th>\n",
       "      <th>NM_EMAIL</th>\n",
       "      <th>CD_SITUACAO_CANDIDATURA</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA</th>\n",
       "      <th>CD_DETALHE_SITUACAO_CAND</th>\n",
       "      <th>DS_DETALHE_SITUACAO_CAND</th>\n",
       "      <th>TP_AGREMIACAO</th>\n",
       "      <th>NR_PARTIDO</th>\n",
       "      <th>SG_PARTIDO</th>\n",
       "      <th>NM_PARTIDO</th>\n",
       "      <th>NR_FEDERACAO</th>\n",
       "      <th>NM_FEDERACAO</th>\n",
       "      <th>SG_FEDERACAO</th>\n",
       "      <th>DS_COMPOSICAO_FEDERACAO</th>\n",
       "      <th>SQ_COLIGACAO</th>\n",
       "      <th>NM_COLIGACAO</th>\n",
       "      <th>DS_COMPOSICAO_COLIGACAO</th>\n",
       "      <th>CD_NACIONALIDADE</th>\n",
       "      <th>DS_NACIONALIDADE</th>\n",
       "      <th>SG_UF_NASCIMENTO</th>\n",
       "      <th>CD_MUNICIPIO_NASCIMENTO</th>\n",
       "      <th>NM_MUNICIPIO_NASCIMENTO</th>\n",
       "      <th>DT_NASCIMENTO</th>\n",
       "      <th>NR_IDADE_DATA_POSSE</th>\n",
       "      <th>NR_TITULO_ELEITORAL_CANDIDATO</th>\n",
       "      <th>CD_GENERO</th>\n",
       "      <th>DS_GENERO</th>\n",
       "      <th>CD_GRAU_INSTRUCAO</th>\n",
       "      <th>DS_GRAU_INSTRUCAO</th>\n",
       "      <th>CD_ESTADO_CIVIL</th>\n",
       "      <th>DS_ESTADO_CIVIL</th>\n",
       "      <th>CD_COR_RACA</th>\n",
       "      <th>DS_COR_RACA</th>\n",
       "      <th>CD_OCUPACAO</th>\n",
       "      <th>DS_OCUPACAO</th>\n",
       "      <th>VR_DESPESA_MAX_CAMPANHA</th>\n",
       "      <th>CD_SIT_TOT_TURNO</th>\n",
       "      <th>DS_SIT_TOT_TURNO</th>\n",
       "      <th>ST_REELEICAO</th>\n",
       "      <th>ST_DECLARAR_BENS</th>\n",
       "      <th>NR_PROTOCOLO_CANDIDATURA</th>\n",
       "      <th>NR_PROCESSO</th>\n",
       "      <th>CD_SITUACAO_CANDIDATO_PLEITO</th>\n",
       "      <th>DS_SITUACAO_CANDIDATO_PLEITO</th>\n",
       "      <th>CD_SITUACAO_CANDIDATO_URNA</th>\n",
       "      <th>DS_SITUACAO_CANDIDATO_URNA</th>\n",
       "      <th>ST_CANDIDATO_INSERIDO_URNA</th>\n",
       "      <th>NM_TIPO_DESTINACAO_VOTOS</th>\n",
       "      <th>CD_SITUACAO_CANDIDATO_TOT</th>\n",
       "      <th>DS_SITUACAO_CANDIDATO_TOT</th>\n",
       "      <th>ST_PREST_CONTAS</th>\n",
       "      <th>ST_SUBSTITUIDO</th>\n",
       "      <th>SQ_SUBSTITUIDO</th>\n",
       "      <th>SQ_ORDEM_SUPLENCIA</th>\n",
       "      <th>DT_ACEITE_CANDIDATURA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>13/03/2023</td>\n",
       "      <td>15:28:45</td>\n",
       "      <td>2016</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
       "      <td>1</td>\n",
       "      <td>220</td>\n",
       "      <td>Eleições Municipais 2016</td>\n",
       "      <td>02/10/2016</td>\n",
       "      <td>MUNICIPAL</td>\n",
       "      <td>MA</td>\n",
       "      <td>7439</td>\n",
       "      <td>BURITI BRAVO</td>\n",
       "      <td>13</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>100000004568</td>\n",
       "      <td>14456</td>\n",
       "      <td>MARIA SOLIDADE COSME DE OLIVEIRA</td>\n",
       "      <td>XUXA</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>95168559387</td>\n",
       "      <td>NÃO DIVULGÁVEL</td>\n",
       "      <td>12</td>\n",
       "      <td>APTO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>COLIGAÇÃO</td>\n",
       "      <td>14</td>\n",
       "      <td>PTB</td>\n",
       "      <td>PARTIDO TRABALHISTA BRASILEIRO</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>100000000354</td>\n",
       "      <td>BURITI BRAVO NO RUMO CERTO I</td>\n",
       "      <td>PTB / DEM / PTN</td>\n",
       "      <td>1</td>\n",
       "      <td>BRASILEIRA NATA</td>\n",
       "      <td>MA</td>\n",
       "      <td>-3</td>\n",
       "      <td>PASSAGEM FRANCA</td>\n",
       "      <td>08/01/1943</td>\n",
       "      <td>73.0</td>\n",
       "      <td>35741881104</td>\n",
       "      <td>4</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>3</td>\n",
       "      <td>ENSINO FUNDAMENTAL INCOMPLETO</td>\n",
       "      <td>3</td>\n",
       "      <td>CASADO(A)</td>\n",
       "      <td>3</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>606</td>\n",
       "      <td>TRABALHADOR RURAL</td>\n",
       "      <td>10803.91</td>\n",
       "      <td>5</td>\n",
       "      <td>SUPLENTE</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>516812016</td>\n",
       "      <td>1604620166100044</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>SIM</td>\n",
       "      <td>Válido</td>\n",
       "      <td>2</td>\n",
       "      <td>Deferido</td>\n",
       "      <td>S</td>\n",
       "      <td>N</td>\n",
       "      <td>-1</td>\n",
       "      <td>9</td>\n",
       "      <td>12/08/2016 11:13:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>13/03/2023</td>\n",
       "      <td>15:28:45</td>\n",
       "      <td>2016</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
       "      <td>1</td>\n",
       "      <td>220</td>\n",
       "      <td>Eleições Municipais 2016</td>\n",
       "      <td>02/10/2016</td>\n",
       "      <td>MUNICIPAL</td>\n",
       "      <td>PI</td>\n",
       "      <td>11231</td>\n",
       "      <td>MIGUEL ALVES</td>\n",
       "      <td>13</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>180000010685</td>\n",
       "      <td>25000</td>\n",
       "      <td>FRANCINETE ALVES ALMEIDA</td>\n",
       "      <td>FRANCINETE</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>84681454320</td>\n",
       "      <td>NÃO DIVULGÁVEL</td>\n",
       "      <td>12</td>\n",
       "      <td>APTO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>COLIGAÇÃO</td>\n",
       "      <td>25</td>\n",
       "      <td>DEM</td>\n",
       "      <td>DEMOCRATAS</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>180000000950</td>\n",
       "      <td>O POVO QUER: NOVO TEMPO, NOVAS IDEIAS</td>\n",
       "      <td>PSOL / PP / PSDB / PR / PSD / PMN / PSL / PHS ...</td>\n",
       "      <td>1</td>\n",
       "      <td>BRASILEIRA NATA</td>\n",
       "      <td>PI</td>\n",
       "      <td>-3</td>\n",
       "      <td>MIGUEL ALVES</td>\n",
       "      <td>17/09/1979</td>\n",
       "      <td>37.0</td>\n",
       "      <td>24351441503</td>\n",
       "      <td>2</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>8</td>\n",
       "      <td>SUPERIOR COMPLETO</td>\n",
       "      <td>3</td>\n",
       "      <td>CASADO(A)</td>\n",
       "      <td>3</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>265</td>\n",
       "      <td>PROFESSOR DE ENSINO FUNDAMENTAL</td>\n",
       "      <td>32499.97</td>\n",
       "      <td>5</td>\n",
       "      <td>SUPLENTE</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>434672016</td>\n",
       "      <td>969520166180017</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>SIM</td>\n",
       "      <td>Válido</td>\n",
       "      <td>2</td>\n",
       "      <td>Deferido</td>\n",
       "      <td>S</td>\n",
       "      <td>N</td>\n",
       "      <td>-1</td>\n",
       "      <td>9</td>\n",
       "      <td>16/08/2016 15:00:12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>13/03/2023</td>\n",
       "      <td>15:28:45</td>\n",
       "      <td>2016</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
       "      <td>1</td>\n",
       "      <td>220</td>\n",
       "      <td>Eleições Municipais 2016</td>\n",
       "      <td>02/10/2016</td>\n",
       "      <td>MUNICIPAL</td>\n",
       "      <td>PI</td>\n",
       "      <td>11231</td>\n",
       "      <td>MIGUEL ALVES</td>\n",
       "      <td>13</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>180000010695</td>\n",
       "      <td>11000</td>\n",
       "      <td>IVANILDO SOUSA MOREIRA</td>\n",
       "      <td>PROFESSOR IVANILDO</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>53564901353</td>\n",
       "      <td>NÃO DIVULGÁVEL</td>\n",
       "      <td>12</td>\n",
       "      <td>APTO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>COLIGAÇÃO</td>\n",
       "      <td>11</td>\n",
       "      <td>PP</td>\n",
       "      <td>PARTIDO PROGRESSISTA</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>180000000950</td>\n",
       "      <td>O POVO QUER: NOVO TEMPO, NOVAS IDEIAS</td>\n",
       "      <td>PSOL / PP / PSDB / PR / PSD / PMN / PSL / PHS ...</td>\n",
       "      <td>1</td>\n",
       "      <td>BRASILEIRA NATA</td>\n",
       "      <td>PI</td>\n",
       "      <td>-3</td>\n",
       "      <td>MIGUEL ALVES</td>\n",
       "      <td>31/10/1974</td>\n",
       "      <td>42.0</td>\n",
       "      <td>27355661570</td>\n",
       "      <td>2</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>8</td>\n",
       "      <td>SUPERIOR COMPLETO</td>\n",
       "      <td>1</td>\n",
       "      <td>SOLTEIRO(A)</td>\n",
       "      <td>3</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>265</td>\n",
       "      <td>PROFESSOR DE ENSINO FUNDAMENTAL</td>\n",
       "      <td>32499.97</td>\n",
       "      <td>5</td>\n",
       "      <td>SUPLENTE</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>434622016</td>\n",
       "      <td>917320166180017</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>SIM</td>\n",
       "      <td>Válido</td>\n",
       "      <td>2</td>\n",
       "      <td>Deferido</td>\n",
       "      <td>S</td>\n",
       "      <td>N</td>\n",
       "      <td>-1</td>\n",
       "      <td>11</td>\n",
       "      <td>16/08/2016 15:00:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13/03/2023</td>\n",
       "      <td>15:28:45</td>\n",
       "      <td>2016</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
       "      <td>1</td>\n",
       "      <td>220</td>\n",
       "      <td>Eleições Municipais 2016</td>\n",
       "      <td>02/10/2016</td>\n",
       "      <td>MUNICIPAL</td>\n",
       "      <td>PI</td>\n",
       "      <td>11231</td>\n",
       "      <td>MIGUEL ALVES</td>\n",
       "      <td>13</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>180000010700</td>\n",
       "      <td>11333</td>\n",
       "      <td>INÁCIO ALVES DA SILVA</td>\n",
       "      <td>INÁCIO</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>75498189320</td>\n",
       "      <td>NÃO DIVULGÁVEL</td>\n",
       "      <td>12</td>\n",
       "      <td>APTO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>COLIGAÇÃO</td>\n",
       "      <td>11</td>\n",
       "      <td>PP</td>\n",
       "      <td>PARTIDO PROGRESSISTA</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>180000000950</td>\n",
       "      <td>O POVO QUER: NOVO TEMPO, NOVAS IDEIAS</td>\n",
       "      <td>PSOL / PP / PSDB / PR / PSD / PMN / PSL / PHS ...</td>\n",
       "      <td>1</td>\n",
       "      <td>BRASILEIRA NATA</td>\n",
       "      <td>PI</td>\n",
       "      <td>-3</td>\n",
       "      <td>MIGUEL ALVES</td>\n",
       "      <td>17/05/1977</td>\n",
       "      <td>39.0</td>\n",
       "      <td>23500221503</td>\n",
       "      <td>2</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>5</td>\n",
       "      <td>ENSINO MÉDIO INCOMPLETO</td>\n",
       "      <td>1</td>\n",
       "      <td>SOLTEIRO(A)</td>\n",
       "      <td>3</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>999</td>\n",
       "      <td>OUTROS</td>\n",
       "      <td>32499.97</td>\n",
       "      <td>5</td>\n",
       "      <td>SUPLENTE</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>434662016</td>\n",
       "      <td>951320166180017</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>SIM</td>\n",
       "      <td>Válido</td>\n",
       "      <td>2</td>\n",
       "      <td>Deferido</td>\n",
       "      <td>S</td>\n",
       "      <td>N</td>\n",
       "      <td>-1</td>\n",
       "      <td>16</td>\n",
       "      <td>16/08/2016 15:00:10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>13/03/2023</td>\n",
       "      <td>15:28:45</td>\n",
       "      <td>2016</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
       "      <td>1</td>\n",
       "      <td>220</td>\n",
       "      <td>Eleições Municipais 2016</td>\n",
       "      <td>02/10/2016</td>\n",
       "      <td>MUNICIPAL</td>\n",
       "      <td>SP</td>\n",
       "      <td>65196</td>\n",
       "      <td>IPAUSSU</td>\n",
       "      <td>13</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>250000061354</td>\n",
       "      <td>11133</td>\n",
       "      <td>WILSON DE ANDRADE</td>\n",
       "      <td>PAQUITO</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>1575640880</td>\n",
       "      <td>NÃO DIVULGÁVEL</td>\n",
       "      <td>3</td>\n",
       "      <td>INAPTO</td>\n",
       "      <td>14</td>\n",
       "      <td>INDEFERIDO</td>\n",
       "      <td>COLIGAÇÃO</td>\n",
       "      <td>11</td>\n",
       "      <td>PP</td>\n",
       "      <td>PARTIDO PROGRESSISTA</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>250000004086</td>\n",
       "      <td>PP-DEM</td>\n",
       "      <td>DEM / PP</td>\n",
       "      <td>1</td>\n",
       "      <td>BRASILEIRA NATA</td>\n",
       "      <td>SP</td>\n",
       "      <td>-3</td>\n",
       "      <td>OURINHOS</td>\n",
       "      <td>07/03/1960</td>\n",
       "      <td>56.0</td>\n",
       "      <td>33635740191</td>\n",
       "      <td>2</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>3</td>\n",
       "      <td>ENSINO FUNDAMENTAL INCOMPLETO</td>\n",
       "      <td>9</td>\n",
       "      <td>DIVORCIADO(A)</td>\n",
       "      <td>1</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>999</td>\n",
       "      <td>OUTROS</td>\n",
       "      <td>10803.91</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>2258152016</td>\n",
       "      <td>4067920166260114</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>NÃO</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>14/08/2016 13:34:50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   DT_GERACAO HH_GERACAO  ANO_ELEICAO  CD_TIPO_ELEICAO    NM_TIPO_ELEICAO  \\\n",
       "0  13/03/2023   15:28:45         2016                2  ELEIÇÃO ORDINÁRIA   \n",
       "1  13/03/2023   15:28:45         2016                2  ELEIÇÃO ORDINÁRIA   \n",
       "2  13/03/2023   15:28:45         2016                2  ELEIÇÃO ORDINÁRIA   \n",
       "3  13/03/2023   15:28:45         2016                2  ELEIÇÃO ORDINÁRIA   \n",
       "4  13/03/2023   15:28:45         2016                2  ELEIÇÃO ORDINÁRIA   \n",
       "\n",
       "   NR_TURNO  CD_ELEICAO                DS_ELEICAO  DT_ELEICAO TP_ABRANGENCIA  \\\n",
       "0         1         220  Eleições Municipais 2016  02/10/2016      MUNICIPAL   \n",
       "1         1         220  Eleições Municipais 2016  02/10/2016      MUNICIPAL   \n",
       "2         1         220  Eleições Municipais 2016  02/10/2016      MUNICIPAL   \n",
       "3         1         220  Eleições Municipais 2016  02/10/2016      MUNICIPAL   \n",
       "4         1         220  Eleições Municipais 2016  02/10/2016      MUNICIPAL   \n",
       "\n",
       "  SG_UF  SG_UE         NM_UE  CD_CARGO  DS_CARGO  SQ_CANDIDATO  NR_CANDIDATO  \\\n",
       "0    MA   7439  BURITI BRAVO        13  VEREADOR  100000004568         14456   \n",
       "1    PI  11231  MIGUEL ALVES        13  VEREADOR  180000010685         25000   \n",
       "2    PI  11231  MIGUEL ALVES        13  VEREADOR  180000010695         11000   \n",
       "3    PI  11231  MIGUEL ALVES        13  VEREADOR  180000010700         11333   \n",
       "4    SP  65196       IPAUSSU        13  VEREADOR  250000061354         11133   \n",
       "\n",
       "                       NM_CANDIDATO   NM_URNA_CANDIDATO NM_SOCIAL_CANDIDATO  \\\n",
       "0  MARIA SOLIDADE COSME DE OLIVEIRA                XUXA              #NULO#   \n",
       "1          FRANCINETE ALVES ALMEIDA          FRANCINETE              #NULO#   \n",
       "2            IVANILDO SOUSA MOREIRA  PROFESSOR IVANILDO              #NULO#   \n",
       "3             INÁCIO ALVES DA SILVA              INÁCIO              #NULO#   \n",
       "4                 WILSON DE ANDRADE             PAQUITO              #NULO#   \n",
       "\n",
       "   NR_CPF_CANDIDATO        NM_EMAIL  CD_SITUACAO_CANDIDATURA  \\\n",
       "0       95168559387  NÃO DIVULGÁVEL                       12   \n",
       "1       84681454320  NÃO DIVULGÁVEL                       12   \n",
       "2       53564901353  NÃO DIVULGÁVEL                       12   \n",
       "3       75498189320  NÃO DIVULGÁVEL                       12   \n",
       "4        1575640880  NÃO DIVULGÁVEL                        3   \n",
       "\n",
       "  DS_SITUACAO_CANDIDATURA  CD_DETALHE_SITUACAO_CAND DS_DETALHE_SITUACAO_CAND  \\\n",
       "0                    APTO                         2                 DEFERIDO   \n",
       "1                    APTO                         2                 DEFERIDO   \n",
       "2                    APTO                         2                 DEFERIDO   \n",
       "3                    APTO                         2                 DEFERIDO   \n",
       "4                  INAPTO                        14               INDEFERIDO   \n",
       "\n",
       "  TP_AGREMIACAO  NR_PARTIDO SG_PARTIDO                      NM_PARTIDO  \\\n",
       "0     COLIGAÇÃO          14        PTB  PARTIDO TRABALHISTA BRASILEIRO   \n",
       "1     COLIGAÇÃO          25        DEM                      DEMOCRATAS   \n",
       "2     COLIGAÇÃO          11         PP            PARTIDO PROGRESSISTA   \n",
       "3     COLIGAÇÃO          11         PP            PARTIDO PROGRESSISTA   \n",
       "4     COLIGAÇÃO          11         PP            PARTIDO PROGRESSISTA   \n",
       "\n",
       "   NR_FEDERACAO NM_FEDERACAO SG_FEDERACAO DS_COMPOSICAO_FEDERACAO  \\\n",
       "0            -1       #NULO#       #NULO#                  #NULO#   \n",
       "1            -1       #NULO#       #NULO#                  #NULO#   \n",
       "2            -1       #NULO#       #NULO#                  #NULO#   \n",
       "3            -1       #NULO#       #NULO#                  #NULO#   \n",
       "4            -1       #NULO#       #NULO#                  #NULO#   \n",
       "\n",
       "   SQ_COLIGACAO                           NM_COLIGACAO  \\\n",
       "0  100000000354           BURITI BRAVO NO RUMO CERTO I   \n",
       "1  180000000950  O POVO QUER: NOVO TEMPO, NOVAS IDEIAS   \n",
       "2  180000000950  O POVO QUER: NOVO TEMPO, NOVAS IDEIAS   \n",
       "3  180000000950  O POVO QUER: NOVO TEMPO, NOVAS IDEIAS   \n",
       "4  250000004086                                 PP-DEM   \n",
       "\n",
       "                             DS_COMPOSICAO_COLIGACAO  CD_NACIONALIDADE  \\\n",
       "0                                    PTB / DEM / PTN                 1   \n",
       "1  PSOL / PP / PSDB / PR / PSD / PMN / PSL / PHS ...                 1   \n",
       "2  PSOL / PP / PSDB / PR / PSD / PMN / PSL / PHS ...                 1   \n",
       "3  PSOL / PP / PSDB / PR / PSD / PMN / PSL / PHS ...                 1   \n",
       "4                                           DEM / PP                 1   \n",
       "\n",
       "  DS_NACIONALIDADE SG_UF_NASCIMENTO  CD_MUNICIPIO_NASCIMENTO  \\\n",
       "0  BRASILEIRA NATA               MA                       -3   \n",
       "1  BRASILEIRA NATA               PI                       -3   \n",
       "2  BRASILEIRA NATA               PI                       -3   \n",
       "3  BRASILEIRA NATA               PI                       -3   \n",
       "4  BRASILEIRA NATA               SP                       -3   \n",
       "\n",
       "  NM_MUNICIPIO_NASCIMENTO DT_NASCIMENTO  NR_IDADE_DATA_POSSE  \\\n",
       "0         PASSAGEM FRANCA    08/01/1943                 73.0   \n",
       "1            MIGUEL ALVES    17/09/1979                 37.0   \n",
       "2            MIGUEL ALVES    31/10/1974                 42.0   \n",
       "3            MIGUEL ALVES    17/05/1977                 39.0   \n",
       "4                OURINHOS    07/03/1960                 56.0   \n",
       "\n",
       "   NR_TITULO_ELEITORAL_CANDIDATO  CD_GENERO  DS_GENERO  CD_GRAU_INSTRUCAO  \\\n",
       "0                    35741881104          4   FEMININO                  3   \n",
       "1                    24351441503          2  MASCULINO                  8   \n",
       "2                    27355661570          2  MASCULINO                  8   \n",
       "3                    23500221503          2  MASCULINO                  5   \n",
       "4                    33635740191          2  MASCULINO                  3   \n",
       "\n",
       "               DS_GRAU_INSTRUCAO  CD_ESTADO_CIVIL DS_ESTADO_CIVIL  \\\n",
       "0  ENSINO FUNDAMENTAL INCOMPLETO                3       CASADO(A)   \n",
       "1              SUPERIOR COMPLETO                3       CASADO(A)   \n",
       "2              SUPERIOR COMPLETO                1     SOLTEIRO(A)   \n",
       "3        ENSINO MÉDIO INCOMPLETO                1     SOLTEIRO(A)   \n",
       "4  ENSINO FUNDAMENTAL INCOMPLETO                9   DIVORCIADO(A)   \n",
       "\n",
       "   CD_COR_RACA DS_COR_RACA  CD_OCUPACAO                      DS_OCUPACAO  \\\n",
       "0            3       PARDA          606                TRABALHADOR RURAL   \n",
       "1            3       PARDA          265  PROFESSOR DE ENSINO FUNDAMENTAL   \n",
       "2            3       PARDA          265  PROFESSOR DE ENSINO FUNDAMENTAL   \n",
       "3            3       PARDA          999                           OUTROS   \n",
       "4            1      BRANCA          999                           OUTROS   \n",
       "\n",
       "   VR_DESPESA_MAX_CAMPANHA  CD_SIT_TOT_TURNO DS_SIT_TOT_TURNO ST_REELEICAO  \\\n",
       "0                 10803.91                 5         SUPLENTE            N   \n",
       "1                 32499.97                 5         SUPLENTE            N   \n",
       "2                 32499.97                 5         SUPLENTE            N   \n",
       "3                 32499.97                 5         SUPLENTE            N   \n",
       "4                 10803.91                -1           #NULO#            N   \n",
       "\n",
       "  ST_DECLARAR_BENS  NR_PROTOCOLO_CANDIDATURA       NR_PROCESSO  \\\n",
       "0                N                 516812016  1604620166100044   \n",
       "1                S                 434672016   969520166180017   \n",
       "2                N                 434622016   917320166180017   \n",
       "3                N                 434662016   951320166180017   \n",
       "4                S                2258152016  4067920166260114   \n",
       "\n",
       "   CD_SITUACAO_CANDIDATO_PLEITO DS_SITUACAO_CANDIDATO_PLEITO  \\\n",
       "0                             2                     DEFERIDO   \n",
       "1                             2                     DEFERIDO   \n",
       "2                             2                     DEFERIDO   \n",
       "3                             2                     DEFERIDO   \n",
       "4                            -1                       #NULO#   \n",
       "\n",
       "   CD_SITUACAO_CANDIDATO_URNA DS_SITUACAO_CANDIDATO_URNA  \\\n",
       "0                           2                   DEFERIDO   \n",
       "1                           2                   DEFERIDO   \n",
       "2                           2                   DEFERIDO   \n",
       "3                           2                   DEFERIDO   \n",
       "4                          -1                     #NULO#   \n",
       "\n",
       "  ST_CANDIDATO_INSERIDO_URNA NM_TIPO_DESTINACAO_VOTOS  \\\n",
       "0                        SIM                   Válido   \n",
       "1                        SIM                   Válido   \n",
       "2                        SIM                   Válido   \n",
       "3                        SIM                   Válido   \n",
       "4                        NÃO                   #NULO#   \n",
       "\n",
       "   CD_SITUACAO_CANDIDATO_TOT DS_SITUACAO_CANDIDATO_TOT ST_PREST_CONTAS  \\\n",
       "0                          2                  Deferido               S   \n",
       "1                          2                  Deferido               S   \n",
       "2                          2                  Deferido               S   \n",
       "3                          2                  Deferido               S   \n",
       "4                         -1                    #NULO#               N   \n",
       "\n",
       "  ST_SUBSTITUIDO  SQ_SUBSTITUIDO  SQ_ORDEM_SUPLENCIA DT_ACEITE_CANDIDATURA  \n",
       "0              N              -1                   9   12/08/2016 11:13:45  \n",
       "1              N              -1                   9   16/08/2016 15:00:12  \n",
       "2              N              -1                  11   16/08/2016 15:00:04  \n",
       "3              N              -1                  16   16/08/2016 15:00:10  \n",
       "4              N              -1                  -1   14/08/2016 13:34:50  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2016.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a2a562d7-b0ca-4fc8-8653-218663bb4bf8",
   "metadata": {},
   "source": [
    "### 🧹 Limpando duplicados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "513195fb-6005-441a-8622-9d39804ef524",
   "metadata": {},
   "outputs": [],
   "source": [
    "# checando os duplicados segundo o número de identificação do título de eleitor\n",
    "duplicados = df_2016[df_2016.duplicated(subset='NR_TITULO_ELEITORAL_CANDIDATO', keep=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "3c73ad83-9e1e-434e-b9bd-6b55f0c26a49",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2016 = df_2016.drop_duplicates(subset='NR_TITULO_ELEITORAL_CANDIDATO')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "e2021465-507a-4993-aeaf-7d321681f39a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "496415"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2016[\"NR_TITULO_ELEITORAL_CANDIDATO\"].nunique()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1624f237-451d-44a3-a575-9a1021ca5f6a",
   "metadata": {},
   "source": [
    "### 🆗 Filtrando aptos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "8d26419d-4bc7-411b-b5f0-38c48a8fb322",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2016 = df_2016[df_2016[\"CD_SITUACAO_CANDIDATURA\"] == 12]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4bcf7f4e-db33-42fe-9115-0c8bab58a719",
   "metadata": {},
   "source": [
    "### 🧩 Padronizando o DF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "d94fb978-6d50-439f-9da4-976eaa2ae7ba",
   "metadata": {},
   "outputs": [],
   "source": [
    "colunas_selecionadas = ['NR_TITULO_ELEITORAL_CANDIDATO', 'DS_COR_RACA', 'NM_CANDIDATO', 'NM_URNA_CANDIDATO', 'DS_CARGO', 'DS_SITUACAO_CANDIDATURA', 'SG_PARTIDO', 'SG_UF', 'NM_UE']\n",
    "df_2016 = df_2016[colunas_selecionadas]\n",
    "df_2016.columns = [f\"{coluna}_2016\" for coluna in df_2016.columns]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "6182ff36-1dfc-4a88-b544-72bf775c4699",
   "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>NR_TITULO_ELEITORAL_CANDIDATO_2016</th>\n",
       "      <th>DS_COR_RACA_2016</th>\n",
       "      <th>NM_CANDIDATO_2016</th>\n",
       "      <th>NM_URNA_CANDIDATO_2016</th>\n",
       "      <th>DS_CARGO_2016</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA_2016</th>\n",
       "      <th>SG_PARTIDO_2016</th>\n",
       "      <th>SG_UF_2016</th>\n",
       "      <th>NM_UE_2016</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>35741881104</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>MARIA SOLIDADE COSME DE OLIVEIRA</td>\n",
       "      <td>XUXA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PTB</td>\n",
       "      <td>MA</td>\n",
       "      <td>BURITI BRAVO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>24351441503</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>FRANCINETE ALVES ALMEIDA</td>\n",
       "      <td>FRANCINETE</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>DEM</td>\n",
       "      <td>PI</td>\n",
       "      <td>MIGUEL ALVES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>27355661570</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>IVANILDO SOUSA MOREIRA</td>\n",
       "      <td>PROFESSOR IVANILDO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PP</td>\n",
       "      <td>PI</td>\n",
       "      <td>MIGUEL ALVES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>23500221503</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>INÁCIO ALVES DA SILVA</td>\n",
       "      <td>INÁCIO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PP</td>\n",
       "      <td>PI</td>\n",
       "      <td>MIGUEL ALVES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>41891390922</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>RONALDO BELLO DAS CHAGAS</td>\n",
       "      <td>RONALDO CHAGAS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PMDB</td>\n",
       "      <td>SC</td>\n",
       "      <td>IBICARÉ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   NR_TITULO_ELEITORAL_CANDIDATO_2016 DS_COR_RACA_2016  \\\n",
       "0                         35741881104            PARDA   \n",
       "1                         24351441503            PARDA   \n",
       "2                         27355661570            PARDA   \n",
       "3                         23500221503            PARDA   \n",
       "5                         41891390922            PARDA   \n",
       "\n",
       "                  NM_CANDIDATO_2016 NM_URNA_CANDIDATO_2016 DS_CARGO_2016  \\\n",
       "0  MARIA SOLIDADE COSME DE OLIVEIRA                   XUXA      VEREADOR   \n",
       "1          FRANCINETE ALVES ALMEIDA             FRANCINETE      VEREADOR   \n",
       "2            IVANILDO SOUSA MOREIRA     PROFESSOR IVANILDO      VEREADOR   \n",
       "3             INÁCIO ALVES DA SILVA                 INÁCIO      VEREADOR   \n",
       "5          RONALDO BELLO DAS CHAGAS         RONALDO CHAGAS      VEREADOR   \n",
       "\n",
       "  DS_SITUACAO_CANDIDATURA_2016 SG_PARTIDO_2016 SG_UF_2016    NM_UE_2016  \n",
       "0                         APTO             PTB         MA  BURITI BRAVO  \n",
       "1                         APTO             DEM         PI  MIGUEL ALVES  \n",
       "2                         APTO              PP         PI  MIGUEL ALVES  \n",
       "3                         APTO              PP         PI  MIGUEL ALVES  \n",
       "5                         APTO            PMDB         SC       IBICARÉ  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2016.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "879de96d-0c68-465c-8c6e-6e887f1e31cd",
   "metadata": {},
   "source": [
    "## 📅 2020"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "0e904086-261c-4f49-b845-de2d482f2db7",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2020 = pd.read_csv(\"data/consulta_cand_2020_BRASIL.csv\", delimiter =';', encoding='latin-1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "d6929759-f4d8-4cbc-b0c9-4dd77d50bac8",
   "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>DT_GERACAO</th>\n",
       "      <th>HH_GERACAO</th>\n",
       "      <th>ANO_ELEICAO</th>\n",
       "      <th>CD_TIPO_ELEICAO</th>\n",
       "      <th>NM_TIPO_ELEICAO</th>\n",
       "      <th>NR_TURNO</th>\n",
       "      <th>CD_ELEICAO</th>\n",
       "      <th>DS_ELEICAO</th>\n",
       "      <th>DT_ELEICAO</th>\n",
       "      <th>TP_ABRANGENCIA</th>\n",
       "      <th>SG_UF</th>\n",
       "      <th>SG_UE</th>\n",
       "      <th>NM_UE</th>\n",
       "      <th>CD_CARGO</th>\n",
       "      <th>DS_CARGO</th>\n",
       "      <th>SQ_CANDIDATO</th>\n",
       "      <th>NR_CANDIDATO</th>\n",
       "      <th>NM_CANDIDATO</th>\n",
       "      <th>NM_URNA_CANDIDATO</th>\n",
       "      <th>NM_SOCIAL_CANDIDATO</th>\n",
       "      <th>NR_CPF_CANDIDATO</th>\n",
       "      <th>NM_EMAIL</th>\n",
       "      <th>CD_SITUACAO_CANDIDATURA</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA</th>\n",
       "      <th>CD_DETALHE_SITUACAO_CAND</th>\n",
       "      <th>DS_DETALHE_SITUACAO_CAND</th>\n",
       "      <th>TP_AGREMIACAO</th>\n",
       "      <th>NR_PARTIDO</th>\n",
       "      <th>SG_PARTIDO</th>\n",
       "      <th>NM_PARTIDO</th>\n",
       "      <th>NR_FEDERACAO</th>\n",
       "      <th>NM_FEDERACAO</th>\n",
       "      <th>SG_FEDERACAO</th>\n",
       "      <th>DS_COMPOSICAO_FEDERACAO</th>\n",
       "      <th>SQ_COLIGACAO</th>\n",
       "      <th>NM_COLIGACAO</th>\n",
       "      <th>DS_COMPOSICAO_COLIGACAO</th>\n",
       "      <th>CD_NACIONALIDADE</th>\n",
       "      <th>DS_NACIONALIDADE</th>\n",
       "      <th>SG_UF_NASCIMENTO</th>\n",
       "      <th>CD_MUNICIPIO_NASCIMENTO</th>\n",
       "      <th>NM_MUNICIPIO_NASCIMENTO</th>\n",
       "      <th>DT_NASCIMENTO</th>\n",
       "      <th>NR_IDADE_DATA_POSSE</th>\n",
       "      <th>NR_TITULO_ELEITORAL_CANDIDATO</th>\n",
       "      <th>CD_GENERO</th>\n",
       "      <th>DS_GENERO</th>\n",
       "      <th>CD_GRAU_INSTRUCAO</th>\n",
       "      <th>DS_GRAU_INSTRUCAO</th>\n",
       "      <th>CD_ESTADO_CIVIL</th>\n",
       "      <th>DS_ESTADO_CIVIL</th>\n",
       "      <th>CD_COR_RACA</th>\n",
       "      <th>DS_COR_RACA</th>\n",
       "      <th>CD_OCUPACAO</th>\n",
       "      <th>DS_OCUPACAO</th>\n",
       "      <th>VR_DESPESA_MAX_CAMPANHA</th>\n",
       "      <th>CD_SIT_TOT_TURNO</th>\n",
       "      <th>DS_SIT_TOT_TURNO</th>\n",
       "      <th>ST_REELEICAO</th>\n",
       "      <th>ST_DECLARAR_BENS</th>\n",
       "      <th>NR_PROTOCOLO_CANDIDATURA</th>\n",
       "      <th>NR_PROCESSO</th>\n",
       "      <th>CD_SITUACAO_CANDIDATO_PLEITO</th>\n",
       "      <th>DS_SITUACAO_CANDIDATO_PLEITO</th>\n",
       "      <th>CD_SITUACAO_CANDIDATO_URNA</th>\n",
       "      <th>DS_SITUACAO_CANDIDATO_URNA</th>\n",
       "      <th>ST_CANDIDATO_INSERIDO_URNA</th>\n",
       "      <th>NM_TIPO_DESTINACAO_VOTOS</th>\n",
       "      <th>CD_SITUACAO_CANDIDATO_TOT</th>\n",
       "      <th>DS_SITUACAO_CANDIDATO_TOT</th>\n",
       "      <th>ST_PREST_CONTAS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>02/05/2024</td>\n",
       "      <td>00:33:52</td>\n",
       "      <td>2020</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
       "      <td>1</td>\n",
       "      <td>426</td>\n",
       "      <td>Eleições Municipais 2020</td>\n",
       "      <td>15/11/2020</td>\n",
       "      <td>MUNICIPAL</td>\n",
       "      <td>BA</td>\n",
       "      <td>34592</td>\n",
       "      <td>COARACI</td>\n",
       "      <td>11</td>\n",
       "      <td>PREFEITO</td>\n",
       "      <td>50001251223</td>\n",
       "      <td>13</td>\n",
       "      <td>JOSEFINA MARIA CASTRO DOS SANTOS</td>\n",
       "      <td>JOSEFINA CASTRO</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>8348235515</td>\n",
       "      <td>NÃO DIVULGÁVEL</td>\n",
       "      <td>12</td>\n",
       "      <td>APTO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>COLIGAÇÃO</td>\n",
       "      <td>13</td>\n",
       "      <td>PT</td>\n",
       "      <td>PARTIDO DOS TRABALHADORES</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>50000155260</td>\n",
       "      <td>A FORÇA DA UNIÃO</td>\n",
       "      <td>PSD / PROS / PSB / PT</td>\n",
       "      <td>1</td>\n",
       "      <td>BRASILEIRA NATA</td>\n",
       "      <td>BA</td>\n",
       "      <td>-3</td>\n",
       "      <td>ILHÉUS</td>\n",
       "      <td>21/08/1951</td>\n",
       "      <td>69.0</td>\n",
       "      <td>16854590540</td>\n",
       "      <td>4</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>8</td>\n",
       "      <td>SUPERIOR COMPLETO</td>\n",
       "      <td>3</td>\n",
       "      <td>CASADO(A)</td>\n",
       "      <td>2</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>142</td>\n",
       "      <td>PROFESSOR DE ENSINO SUPERIOR</td>\n",
       "      <td>123077.42</td>\n",
       "      <td>4</td>\n",
       "      <td>NÃO ELEITO</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>-1</td>\n",
       "      <td>6003559620206050135</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>16</td>\n",
       "      <td>DEFERIDO COM RECURSO</td>\n",
       "      <td>SIM</td>\n",
       "      <td>Válido</td>\n",
       "      <td>2</td>\n",
       "      <td>Deferido</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>02/05/2024</td>\n",
       "      <td>00:33:52</td>\n",
       "      <td>2020</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
       "      <td>1</td>\n",
       "      <td>426</td>\n",
       "      <td>Eleições Municipais 2020</td>\n",
       "      <td>15/11/2020</td>\n",
       "      <td>MUNICIPAL</td>\n",
       "      <td>PR</td>\n",
       "      <td>74420</td>\n",
       "      <td>NOVO ITACOLOMI</td>\n",
       "      <td>11</td>\n",
       "      <td>PREFEITO</td>\n",
       "      <td>160000773419</td>\n",
       "      <td>55</td>\n",
       "      <td>MOACIR ANDREOLLA</td>\n",
       "      <td>MOACIR</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>64465160968</td>\n",
       "      <td>NÃO DIVULGÁVEL</td>\n",
       "      <td>12</td>\n",
       "      <td>APTO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>COLIGAÇÃO</td>\n",
       "      <td>55</td>\n",
       "      <td>PSD</td>\n",
       "      <td>PARTIDO SOCIAL DEMOCRÁTICO</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>160000074895</td>\n",
       "      <td>RUMO CERTO AO FUTURO</td>\n",
       "      <td>PSD / PP / PSL</td>\n",
       "      <td>1</td>\n",
       "      <td>BRASILEIRA NATA</td>\n",
       "      <td>RS</td>\n",
       "      <td>-3</td>\n",
       "      <td>ERECHIM</td>\n",
       "      <td>01/07/1966</td>\n",
       "      <td>54.0</td>\n",
       "      <td>35542450647</td>\n",
       "      <td>2</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>6</td>\n",
       "      <td>ENSINO MÉDIO COMPLETO</td>\n",
       "      <td>3</td>\n",
       "      <td>CASADO(A)</td>\n",
       "      <td>1</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>275</td>\n",
       "      <td>PREFEITO</td>\n",
       "      <td>123077.42</td>\n",
       "      <td>1</td>\n",
       "      <td>ELEITO</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>-1</td>\n",
       "      <td>6003032720206160028</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>SIM</td>\n",
       "      <td>Válido</td>\n",
       "      <td>2</td>\n",
       "      <td>Deferido</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>02/05/2024</td>\n",
       "      <td>00:33:52</td>\n",
       "      <td>2020</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
       "      <td>1</td>\n",
       "      <td>426</td>\n",
       "      <td>Eleições Municipais 2020</td>\n",
       "      <td>15/11/2020</td>\n",
       "      <td>MUNICIPAL</td>\n",
       "      <td>PA</td>\n",
       "      <td>5231</td>\n",
       "      <td>SALINÓPOLIS</td>\n",
       "      <td>13</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>140000641433</td>\n",
       "      <td>12345</td>\n",
       "      <td>JOÃO VICTOR DE BORGES CORREA</td>\n",
       "      <td>VICTOR FAROL</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>71324038268</td>\n",
       "      <td>NÃO DIVULGÁVEL</td>\n",
       "      <td>12</td>\n",
       "      <td>APTO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>12</td>\n",
       "      <td>PDT</td>\n",
       "      <td>PARTIDO DEMOCRÁTICO TRABALHISTA</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>140000056321</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>PDT</td>\n",
       "      <td>1</td>\n",
       "      <td>BRASILEIRA NATA</td>\n",
       "      <td>PA</td>\n",
       "      <td>-3</td>\n",
       "      <td>SALINÓPOLIS</td>\n",
       "      <td>01/03/1982</td>\n",
       "      <td>38.0</td>\n",
       "      <td>43353371317</td>\n",
       "      <td>2</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>6</td>\n",
       "      <td>ENSINO MÉDIO COMPLETO</td>\n",
       "      <td>1</td>\n",
       "      <td>SOLTEIRO(A)</td>\n",
       "      <td>3</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>999</td>\n",
       "      <td>OUTROS</td>\n",
       "      <td>34729.59</td>\n",
       "      <td>5</td>\n",
       "      <td>SUPLENTE</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>-1</td>\n",
       "      <td>6001321620206140064</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>SIM</td>\n",
       "      <td>Válido</td>\n",
       "      <td>2</td>\n",
       "      <td>Deferido</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>02/05/2024</td>\n",
       "      <td>00:33:52</td>\n",
       "      <td>2020</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
       "      <td>1</td>\n",
       "      <td>426</td>\n",
       "      <td>Eleições Municipais 2020</td>\n",
       "      <td>15/11/2020</td>\n",
       "      <td>MUNICIPAL</td>\n",
       "      <td>SP</td>\n",
       "      <td>71072</td>\n",
       "      <td>SÃO PAULO</td>\n",
       "      <td>13</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>250001206039</td>\n",
       "      <td>70078</td>\n",
       "      <td>MARIA DAS GRAÇAS DA SILVA LOPES</td>\n",
       "      <td>GRAÇA LOPES</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>1191949885</td>\n",
       "      <td>NÃO DIVULGÁVEL</td>\n",
       "      <td>12</td>\n",
       "      <td>APTO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>70</td>\n",
       "      <td>AVANTE</td>\n",
       "      <td>AVANTE</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>250000148339</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>AVANTE</td>\n",
       "      <td>1</td>\n",
       "      <td>BRASILEIRA NATA</td>\n",
       "      <td>PB</td>\n",
       "      <td>-3</td>\n",
       "      <td>UMBUZEIRO</td>\n",
       "      <td>26/11/1960</td>\n",
       "      <td>60.0</td>\n",
       "      <td>798110183</td>\n",
       "      <td>4</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>8</td>\n",
       "      <td>SUPERIOR COMPLETO</td>\n",
       "      <td>3</td>\n",
       "      <td>CASADO(A)</td>\n",
       "      <td>1</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>999</td>\n",
       "      <td>OUTROS</td>\n",
       "      <td>3675197.12</td>\n",
       "      <td>4</td>\n",
       "      <td>NÃO ELEITO</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>-1</td>\n",
       "      <td>6020510220206260001</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>SIM</td>\n",
       "      <td>Válido</td>\n",
       "      <td>2</td>\n",
       "      <td>Deferido</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>02/05/2024</td>\n",
       "      <td>00:33:52</td>\n",
       "      <td>2020</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
       "      <td>1</td>\n",
       "      <td>426</td>\n",
       "      <td>Eleições Municipais 2020</td>\n",
       "      <td>15/11/2020</td>\n",
       "      <td>MUNICIPAL</td>\n",
       "      <td>PR</td>\n",
       "      <td>75213</td>\n",
       "      <td>CONTENDA</td>\n",
       "      <td>13</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>160000659785</td>\n",
       "      <td>17333</td>\n",
       "      <td>LEANDRO DOS PRAZERES GONÇALVES</td>\n",
       "      <td>LEANDRO GONÇALVES COBRADOR</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>5073603974</td>\n",
       "      <td>NÃO DIVULGÁVEL</td>\n",
       "      <td>12</td>\n",
       "      <td>APTO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>17</td>\n",
       "      <td>PSL</td>\n",
       "      <td>PARTIDO SOCIAL LIBERAL</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>160000058855</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>PSL</td>\n",
       "      <td>1</td>\n",
       "      <td>BRASILEIRA NATA</td>\n",
       "      <td>PR</td>\n",
       "      <td>-3</td>\n",
       "      <td>CURITIBA</td>\n",
       "      <td>13/08/1983</td>\n",
       "      <td>37.0</td>\n",
       "      <td>80291980680</td>\n",
       "      <td>2</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>6</td>\n",
       "      <td>ENSINO MÉDIO COMPLETO</td>\n",
       "      <td>3</td>\n",
       "      <td>CASADO(A)</td>\n",
       "      <td>1</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>160</td>\n",
       "      <td>COBRADOR DE TRANSPORTE COLETIVO</td>\n",
       "      <td>12307.75</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEITO POR QP</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>-1</td>\n",
       "      <td>6000905220206160050</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>SIM</td>\n",
       "      <td>Válido</td>\n",
       "      <td>2</td>\n",
       "      <td>Deferido</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   DT_GERACAO HH_GERACAO  ANO_ELEICAO  CD_TIPO_ELEICAO    NM_TIPO_ELEICAO  \\\n",
       "0  02/05/2024   00:33:52         2020                2  ELEIÇÃO ORDINÁRIA   \n",
       "1  02/05/2024   00:33:52         2020                2  ELEIÇÃO ORDINÁRIA   \n",
       "2  02/05/2024   00:33:52         2020                2  ELEIÇÃO ORDINÁRIA   \n",
       "3  02/05/2024   00:33:52         2020                2  ELEIÇÃO ORDINÁRIA   \n",
       "4  02/05/2024   00:33:52         2020                2  ELEIÇÃO ORDINÁRIA   \n",
       "\n",
       "   NR_TURNO  CD_ELEICAO                DS_ELEICAO  DT_ELEICAO TP_ABRANGENCIA  \\\n",
       "0         1         426  Eleições Municipais 2020  15/11/2020      MUNICIPAL   \n",
       "1         1         426  Eleições Municipais 2020  15/11/2020      MUNICIPAL   \n",
       "2         1         426  Eleições Municipais 2020  15/11/2020      MUNICIPAL   \n",
       "3         1         426  Eleições Municipais 2020  15/11/2020      MUNICIPAL   \n",
       "4         1         426  Eleições Municipais 2020  15/11/2020      MUNICIPAL   \n",
       "\n",
       "  SG_UF  SG_UE           NM_UE  CD_CARGO  DS_CARGO  SQ_CANDIDATO  \\\n",
       "0    BA  34592         COARACI        11  PREFEITO   50001251223   \n",
       "1    PR  74420  NOVO ITACOLOMI        11  PREFEITO  160000773419   \n",
       "2    PA   5231     SALINÓPOLIS        13  VEREADOR  140000641433   \n",
       "3    SP  71072       SÃO PAULO        13  VEREADOR  250001206039   \n",
       "4    PR  75213        CONTENDA        13  VEREADOR  160000659785   \n",
       "\n",
       "   NR_CANDIDATO                      NM_CANDIDATO           NM_URNA_CANDIDATO  \\\n",
       "0            13  JOSEFINA MARIA CASTRO DOS SANTOS             JOSEFINA CASTRO   \n",
       "1            55                  MOACIR ANDREOLLA                      MOACIR   \n",
       "2         12345      JOÃO VICTOR DE BORGES CORREA                VICTOR FAROL   \n",
       "3         70078   MARIA DAS GRAÇAS DA SILVA LOPES                 GRAÇA LOPES   \n",
       "4         17333    LEANDRO DOS PRAZERES GONÇALVES  LEANDRO GONÇALVES COBRADOR   \n",
       "\n",
       "  NM_SOCIAL_CANDIDATO  NR_CPF_CANDIDATO        NM_EMAIL  \\\n",
       "0              #NULO#        8348235515  NÃO DIVULGÁVEL   \n",
       "1              #NULO#       64465160968  NÃO DIVULGÁVEL   \n",
       "2              #NULO#       71324038268  NÃO DIVULGÁVEL   \n",
       "3              #NULO#        1191949885  NÃO DIVULGÁVEL   \n",
       "4              #NULO#        5073603974  NÃO DIVULGÁVEL   \n",
       "\n",
       "   CD_SITUACAO_CANDIDATURA DS_SITUACAO_CANDIDATURA  CD_DETALHE_SITUACAO_CAND  \\\n",
       "0                       12                    APTO                         2   \n",
       "1                       12                    APTO                         2   \n",
       "2                       12                    APTO                         2   \n",
       "3                       12                    APTO                         2   \n",
       "4                       12                    APTO                         2   \n",
       "\n",
       "  DS_DETALHE_SITUACAO_CAND    TP_AGREMIACAO  NR_PARTIDO SG_PARTIDO  \\\n",
       "0                 DEFERIDO        COLIGAÇÃO          13         PT   \n",
       "1                 DEFERIDO        COLIGAÇÃO          55        PSD   \n",
       "2                 DEFERIDO  PARTIDO ISOLADO          12        PDT   \n",
       "3                 DEFERIDO  PARTIDO ISOLADO          70     AVANTE   \n",
       "4                 DEFERIDO  PARTIDO ISOLADO          17        PSL   \n",
       "\n",
       "                        NM_PARTIDO  NR_FEDERACAO NM_FEDERACAO SG_FEDERACAO  \\\n",
       "0        PARTIDO DOS TRABALHADORES            -1       #NULO#       #NULO#   \n",
       "1       PARTIDO SOCIAL DEMOCRÁTICO            -1       #NULO#       #NULO#   \n",
       "2  PARTIDO DEMOCRÁTICO TRABALHISTA            -1       #NULO#       #NULO#   \n",
       "3                           AVANTE            -1       #NULO#       #NULO#   \n",
       "4           PARTIDO SOCIAL LIBERAL            -1       #NULO#       #NULO#   \n",
       "\n",
       "  DS_COMPOSICAO_FEDERACAO  SQ_COLIGACAO          NM_COLIGACAO  \\\n",
       "0                  #NULO#   50000155260      A FORÇA DA UNIÃO   \n",
       "1                  #NULO#  160000074895  RUMO CERTO AO FUTURO   \n",
       "2                  #NULO#  140000056321       PARTIDO ISOLADO   \n",
       "3                  #NULO#  250000148339       PARTIDO ISOLADO   \n",
       "4                  #NULO#  160000058855       PARTIDO ISOLADO   \n",
       "\n",
       "  DS_COMPOSICAO_COLIGACAO  CD_NACIONALIDADE DS_NACIONALIDADE SG_UF_NASCIMENTO  \\\n",
       "0   PSD / PROS / PSB / PT                 1  BRASILEIRA NATA               BA   \n",
       "1          PSD / PP / PSL                 1  BRASILEIRA NATA               RS   \n",
       "2                     PDT                 1  BRASILEIRA NATA               PA   \n",
       "3                  AVANTE                 1  BRASILEIRA NATA               PB   \n",
       "4                     PSL                 1  BRASILEIRA NATA               PR   \n",
       "\n",
       "   CD_MUNICIPIO_NASCIMENTO NM_MUNICIPIO_NASCIMENTO DT_NASCIMENTO  \\\n",
       "0                       -3                  ILHÉUS    21/08/1951   \n",
       "1                       -3                 ERECHIM    01/07/1966   \n",
       "2                       -3             SALINÓPOLIS    01/03/1982   \n",
       "3                       -3               UMBUZEIRO    26/11/1960   \n",
       "4                       -3                CURITIBA    13/08/1983   \n",
       "\n",
       "   NR_IDADE_DATA_POSSE  NR_TITULO_ELEITORAL_CANDIDATO  CD_GENERO  DS_GENERO  \\\n",
       "0                 69.0                    16854590540          4   FEMININO   \n",
       "1                 54.0                    35542450647          2  MASCULINO   \n",
       "2                 38.0                    43353371317          2  MASCULINO   \n",
       "3                 60.0                      798110183          4   FEMININO   \n",
       "4                 37.0                    80291980680          2  MASCULINO   \n",
       "\n",
       "   CD_GRAU_INSTRUCAO      DS_GRAU_INSTRUCAO  CD_ESTADO_CIVIL DS_ESTADO_CIVIL  \\\n",
       "0                  8      SUPERIOR COMPLETO                3       CASADO(A)   \n",
       "1                  6  ENSINO MÉDIO COMPLETO                3       CASADO(A)   \n",
       "2                  6  ENSINO MÉDIO COMPLETO                1     SOLTEIRO(A)   \n",
       "3                  8      SUPERIOR COMPLETO                3       CASADO(A)   \n",
       "4                  6  ENSINO MÉDIO COMPLETO                3       CASADO(A)   \n",
       "\n",
       "   CD_COR_RACA DS_COR_RACA  CD_OCUPACAO                      DS_OCUPACAO  \\\n",
       "0            2       PRETA          142     PROFESSOR DE ENSINO SUPERIOR   \n",
       "1            1      BRANCA          275                         PREFEITO   \n",
       "2            3       PARDA          999                           OUTROS   \n",
       "3            1      BRANCA          999                           OUTROS   \n",
       "4            1      BRANCA          160  COBRADOR DE TRANSPORTE COLETIVO   \n",
       "\n",
       "   VR_DESPESA_MAX_CAMPANHA  CD_SIT_TOT_TURNO DS_SIT_TOT_TURNO ST_REELEICAO  \\\n",
       "0                123077.42                 4       NÃO ELEITO            N   \n",
       "1                123077.42                 1           ELEITO            N   \n",
       "2                 34729.59                 5         SUPLENTE            N   \n",
       "3               3675197.12                 4       NÃO ELEITO            N   \n",
       "4                 12307.75                 2    ELEITO POR QP            N   \n",
       "\n",
       "  ST_DECLARAR_BENS  NR_PROTOCOLO_CANDIDATURA          NR_PROCESSO  \\\n",
       "0                S                        -1  6003559620206050135   \n",
       "1                S                        -1  6003032720206160028   \n",
       "2                S                        -1  6001321620206140064   \n",
       "3                S                        -1  6020510220206260001   \n",
       "4                S                        -1  6000905220206160050   \n",
       "\n",
       "   CD_SITUACAO_CANDIDATO_PLEITO DS_SITUACAO_CANDIDATO_PLEITO  \\\n",
       "0                             2                     DEFERIDO   \n",
       "1                             2                     DEFERIDO   \n",
       "2                             2                     DEFERIDO   \n",
       "3                             2                     DEFERIDO   \n",
       "4                             2                     DEFERIDO   \n",
       "\n",
       "   CD_SITUACAO_CANDIDATO_URNA DS_SITUACAO_CANDIDATO_URNA  \\\n",
       "0                          16       DEFERIDO COM RECURSO   \n",
       "1                           2                   DEFERIDO   \n",
       "2                           2                   DEFERIDO   \n",
       "3                           2                   DEFERIDO   \n",
       "4                           2                   DEFERIDO   \n",
       "\n",
       "  ST_CANDIDATO_INSERIDO_URNA NM_TIPO_DESTINACAO_VOTOS  \\\n",
       "0                        SIM                   Válido   \n",
       "1                        SIM                   Válido   \n",
       "2                        SIM                   Válido   \n",
       "3                        SIM                   Válido   \n",
       "4                        SIM                   Válido   \n",
       "\n",
       "   CD_SITUACAO_CANDIDATO_TOT DS_SITUACAO_CANDIDATO_TOT ST_PREST_CONTAS  \n",
       "0                          2                  Deferido               S  \n",
       "1                          2                  Deferido               S  \n",
       "2                          2                  Deferido               S  \n",
       "3                          2                  Deferido               S  \n",
       "4                          2                  Deferido               S  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2020.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f4e92487-2093-4ef5-b55f-31abf4d135a8",
   "metadata": {},
   "source": [
    "### 🧹 Limpando duplicados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "0e7d29a1-3c3d-4f2f-85e8-2b5b892d9817",
   "metadata": {},
   "outputs": [],
   "source": [
    "# checando os duplicados segundo o número de identificação do título de eleitor\n",
    "duplicados = df_2020[df_2020.duplicated(subset='NR_TITULO_ELEITORAL_CANDIDATO', keep=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "3b7721a3-43ea-473d-bf82-61d31de60c88",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2020 = df_2020.drop_duplicates(subset='NR_TITULO_ELEITORAL_CANDIDATO')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "9995fd46-a0db-47f1-b937-04b11335570a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "556498"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2020[\"NR_TITULO_ELEITORAL_CANDIDATO\"].nunique()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1927086b-2715-4dac-8d8e-06744b9aa792",
   "metadata": {},
   "source": [
    "### 🆗 Filtrando aptos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "a422b582-5e74-4e8b-9620-126c6c299cc3",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2020 = df_2020[df_2020[\"CD_SITUACAO_CANDIDATURA\"] == 12]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2ed49191-58a7-4ecd-bbc2-1224d2457f07",
   "metadata": {},
   "source": [
    "### 🧩 Padronizando o DF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "cceaecc1-57cc-42f8-98b5-495febe63ed7",
   "metadata": {},
   "outputs": [],
   "source": [
    "colunas_selecionadas = ['NR_TITULO_ELEITORAL_CANDIDATO', 'DS_COR_RACA', 'NM_CANDIDATO', 'NM_URNA_CANDIDATO', 'DS_CARGO', 'DS_SITUACAO_CANDIDATURA', 'SG_PARTIDO', 'SG_UF', 'NM_UE']\n",
    "df_2020 = df_2020[colunas_selecionadas]\n",
    "df_2020.columns = [f\"{coluna}_2020\" for coluna in df_2020.columns]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "3dfa6ced-9715-4699-b744-4707104c2260",
   "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>NR_TITULO_ELEITORAL_CANDIDATO_2020</th>\n",
       "      <th>DS_COR_RACA_2020</th>\n",
       "      <th>NM_CANDIDATO_2020</th>\n",
       "      <th>NM_URNA_CANDIDATO_2020</th>\n",
       "      <th>DS_CARGO_2020</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA_2020</th>\n",
       "      <th>SG_PARTIDO_2020</th>\n",
       "      <th>SG_UF_2020</th>\n",
       "      <th>NM_UE_2020</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16854590540</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>JOSEFINA MARIA CASTRO DOS SANTOS</td>\n",
       "      <td>JOSEFINA CASTRO</td>\n",
       "      <td>PREFEITO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PT</td>\n",
       "      <td>BA</td>\n",
       "      <td>COARACI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>35542450647</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>MOACIR ANDREOLLA</td>\n",
       "      <td>MOACIR</td>\n",
       "      <td>PREFEITO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PSD</td>\n",
       "      <td>PR</td>\n",
       "      <td>NOVO ITACOLOMI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>43353371317</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>JOÃO VICTOR DE BORGES CORREA</td>\n",
       "      <td>VICTOR FAROL</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PDT</td>\n",
       "      <td>PA</td>\n",
       "      <td>SALINÓPOLIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>798110183</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>MARIA DAS GRAÇAS DA SILVA LOPES</td>\n",
       "      <td>GRAÇA LOPES</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>AVANTE</td>\n",
       "      <td>SP</td>\n",
       "      <td>SÃO PAULO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>80291980680</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>LEANDRO DOS PRAZERES GONÇALVES</td>\n",
       "      <td>LEANDRO GONÇALVES COBRADOR</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PSL</td>\n",
       "      <td>PR</td>\n",
       "      <td>CONTENDA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   NR_TITULO_ELEITORAL_CANDIDATO_2020 DS_COR_RACA_2020  \\\n",
       "0                         16854590540            PRETA   \n",
       "1                         35542450647           BRANCA   \n",
       "2                         43353371317            PARDA   \n",
       "3                           798110183           BRANCA   \n",
       "4                         80291980680           BRANCA   \n",
       "\n",
       "                  NM_CANDIDATO_2020      NM_URNA_CANDIDATO_2020 DS_CARGO_2020  \\\n",
       "0  JOSEFINA MARIA CASTRO DOS SANTOS             JOSEFINA CASTRO      PREFEITO   \n",
       "1                  MOACIR ANDREOLLA                      MOACIR      PREFEITO   \n",
       "2      JOÃO VICTOR DE BORGES CORREA                VICTOR FAROL      VEREADOR   \n",
       "3   MARIA DAS GRAÇAS DA SILVA LOPES                 GRAÇA LOPES      VEREADOR   \n",
       "4    LEANDRO DOS PRAZERES GONÇALVES  LEANDRO GONÇALVES COBRADOR      VEREADOR   \n",
       "\n",
       "  DS_SITUACAO_CANDIDATURA_2020 SG_PARTIDO_2020 SG_UF_2020      NM_UE_2020  \n",
       "0                         APTO              PT         BA         COARACI  \n",
       "1                         APTO             PSD         PR  NOVO ITACOLOMI  \n",
       "2                         APTO             PDT         PA     SALINÓPOLIS  \n",
       "3                         APTO          AVANTE         SP       SÃO PAULO  \n",
       "4                         APTO             PSL         PR        CONTENDA  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2020.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d228dfe4-816a-4daf-adaf-0c6ded21cd91",
   "metadata": {},
   "source": [
    "## 📅 2024"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "fb8a0e58-fe8b-4da9-90a2-dd0fc7b5f0b5",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2024 = pd.read_csv(\"data/consulta_cand_2024_BRASIL.csv\", delimiter =';', encoding='latin-1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "e25f6a20-1817-4587-bb15-492da113d5f8",
   "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>DT_GERACAO</th>\n",
       "      <th>HH_GERACAO</th>\n",
       "      <th>ANO_ELEICAO</th>\n",
       "      <th>CD_TIPO_ELEICAO</th>\n",
       "      <th>NM_TIPO_ELEICAO</th>\n",
       "      <th>NR_TURNO</th>\n",
       "      <th>CD_ELEICAO</th>\n",
       "      <th>DS_ELEICAO</th>\n",
       "      <th>DT_ELEICAO</th>\n",
       "      <th>TP_ABRANGENCIA_ELEICAO</th>\n",
       "      <th>SG_UF</th>\n",
       "      <th>SG_UE</th>\n",
       "      <th>NM_UE</th>\n",
       "      <th>CD_CARGO</th>\n",
       "      <th>DS_CARGO</th>\n",
       "      <th>SQ_CANDIDATO</th>\n",
       "      <th>NR_CANDIDATO</th>\n",
       "      <th>NM_CANDIDATO</th>\n",
       "      <th>NM_URNA_CANDIDATO</th>\n",
       "      <th>NM_SOCIAL_CANDIDATO</th>\n",
       "      <th>NR_CPF_CANDIDATO</th>\n",
       "      <th>DS_EMAIL</th>\n",
       "      <th>CD_SITUACAO_CANDIDATURA</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA</th>\n",
       "      <th>TP_AGREMIACAO</th>\n",
       "      <th>NR_PARTIDO</th>\n",
       "      <th>SG_PARTIDO</th>\n",
       "      <th>NM_PARTIDO</th>\n",
       "      <th>NR_FEDERACAO</th>\n",
       "      <th>NM_FEDERACAO</th>\n",
       "      <th>SG_FEDERACAO</th>\n",
       "      <th>DS_COMPOSICAO_FEDERACAO</th>\n",
       "      <th>SQ_COLIGACAO</th>\n",
       "      <th>NM_COLIGACAO</th>\n",
       "      <th>DS_COMPOSICAO_COLIGACAO</th>\n",
       "      <th>SG_UF_NASCIMENTO</th>\n",
       "      <th>DT_NASCIMENTO</th>\n",
       "      <th>NR_TITULO_ELEITORAL_CANDIDATO</th>\n",
       "      <th>CD_GENERO</th>\n",
       "      <th>DS_GENERO</th>\n",
       "      <th>CD_GRAU_INSTRUCAO</th>\n",
       "      <th>DS_GRAU_INSTRUCAO</th>\n",
       "      <th>CD_ESTADO_CIVIL</th>\n",
       "      <th>DS_ESTADO_CIVIL</th>\n",
       "      <th>CD_COR_RACA</th>\n",
       "      <th>DS_COR_RACA</th>\n",
       "      <th>CD_OCUPACAO</th>\n",
       "      <th>DS_OCUPACAO</th>\n",
       "      <th>CD_SIT_TOT_TURNO</th>\n",
       "      <th>DS_SIT_TOT_TURNO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17/09/2024</td>\n",
       "      <td>16:31:28</td>\n",
       "      <td>2024</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
       "      <td>1</td>\n",
       "      <td>619</td>\n",
       "      <td>Eleições Municipais 2024</td>\n",
       "      <td>06/10/2024</td>\n",
       "      <td>MUNICIPAL</td>\n",
       "      <td>BA</td>\n",
       "      <td>33782</td>\n",
       "      <td>BOM JESUS DA SERRA</td>\n",
       "      <td>13</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>50002239886</td>\n",
       "      <td>20357</td>\n",
       "      <td>MARIA ROCHA DIAS</td>\n",
       "      <td>MARY DIAS</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>-4</td>\n",
       "      <td>NÃO DIVULGÁVEL</td>\n",
       "      <td>-3</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>20</td>\n",
       "      <td>PODE</td>\n",
       "      <td>PODEMOS</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>50001744185</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>PODE</td>\n",
       "      <td>BA</td>\n",
       "      <td>12/11/1985</td>\n",
       "      <td>106637890540</td>\n",
       "      <td>4</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>3</td>\n",
       "      <td>ENSINO FUNDAMENTAL INCOMPLETO</td>\n",
       "      <td>1</td>\n",
       "      <td>SOLTEIRO(A)</td>\n",
       "      <td>1</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>999</td>\n",
       "      <td>OUTROS</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>17/09/2024</td>\n",
       "      <td>16:31:28</td>\n",
       "      <td>2024</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
       "      <td>1</td>\n",
       "      <td>619</td>\n",
       "      <td>Eleições Municipais 2024</td>\n",
       "      <td>06/10/2024</td>\n",
       "      <td>MUNICIPAL</td>\n",
       "      <td>BA</td>\n",
       "      <td>35815</td>\n",
       "      <td>IPIRÁ</td>\n",
       "      <td>13</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>50002239960</td>\n",
       "      <td>36366</td>\n",
       "      <td>EDMILSON ARAUJO DA PAZ</td>\n",
       "      <td>MESTRE EDMILSON</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>-4</td>\n",
       "      <td>NÃO DIVULGÁVEL</td>\n",
       "      <td>-3</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>36</td>\n",
       "      <td>AGIR</td>\n",
       "      <td>AGIR</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>50001744200</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>AGIR</td>\n",
       "      <td>BA</td>\n",
       "      <td>03/10/1976</td>\n",
       "      <td>108334920590</td>\n",
       "      <td>2</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>4</td>\n",
       "      <td>ENSINO FUNDAMENTAL COMPLETO</td>\n",
       "      <td>1</td>\n",
       "      <td>SOLTEIRO(A)</td>\n",
       "      <td>2</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>999</td>\n",
       "      <td>OUTROS</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>17/09/2024</td>\n",
       "      <td>16:31:28</td>\n",
       "      <td>2024</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
       "      <td>1</td>\n",
       "      <td>619</td>\n",
       "      <td>Eleições Municipais 2024</td>\n",
       "      <td>06/10/2024</td>\n",
       "      <td>MUNICIPAL</td>\n",
       "      <td>BA</td>\n",
       "      <td>38253</td>\n",
       "      <td>RIACHÃO DAS NEVES</td>\n",
       "      <td>13</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>50002239560</td>\n",
       "      <td>12444</td>\n",
       "      <td>VERILMA LIMA DOS SANTOS</td>\n",
       "      <td>VERINHA</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>-4</td>\n",
       "      <td>NÃO DIVULGÁVEL</td>\n",
       "      <td>-3</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>12</td>\n",
       "      <td>PDT</td>\n",
       "      <td>PARTIDO DEMOCRÁTICO TRABALHISTA</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>50001744130</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>PDT</td>\n",
       "      <td>BA</td>\n",
       "      <td>04/12/1980</td>\n",
       "      <td>101448370566</td>\n",
       "      <td>4</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>3</td>\n",
       "      <td>ENSINO FUNDAMENTAL INCOMPLETO</td>\n",
       "      <td>1</td>\n",
       "      <td>SOLTEIRO(A)</td>\n",
       "      <td>2</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>402</td>\n",
       "      <td>VENDEDOR PRACISTA, REPRESENTANTE, CAIXEIRO-VIA...</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17/09/2024</td>\n",
       "      <td>16:31:28</td>\n",
       "      <td>2024</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
       "      <td>1</td>\n",
       "      <td>619</td>\n",
       "      <td>Eleições Municipais 2024</td>\n",
       "      <td>06/10/2024</td>\n",
       "      <td>MUNICIPAL</td>\n",
       "      <td>BA</td>\n",
       "      <td>34711</td>\n",
       "      <td>CONDE</td>\n",
       "      <td>13</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>50002239720</td>\n",
       "      <td>25610</td>\n",
       "      <td>JORGE CARDOSO DE ALMEIDA</td>\n",
       "      <td>JORGE DA ILHA</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>-4</td>\n",
       "      <td>NÃO DIVULGÁVEL</td>\n",
       "      <td>-3</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>25</td>\n",
       "      <td>PRD</td>\n",
       "      <td>PARTIDO RENOVAÇÃO DEMOCRÁTICA</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>50001744156</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>PRD</td>\n",
       "      <td>BA</td>\n",
       "      <td>30/03/1974</td>\n",
       "      <td>62709510582</td>\n",
       "      <td>2</td>\n",
       "      <td>MASCULINO</td>\n",
       "      <td>4</td>\n",
       "      <td>ENSINO FUNDAMENTAL COMPLETO</td>\n",
       "      <td>1</td>\n",
       "      <td>SOLTEIRO(A)</td>\n",
       "      <td>2</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>999</td>\n",
       "      <td>OUTROS</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>17/09/2024</td>\n",
       "      <td>16:31:28</td>\n",
       "      <td>2024</td>\n",
       "      <td>2</td>\n",
       "      <td>ELEIÇÃO ORDINÁRIA</td>\n",
       "      <td>1</td>\n",
       "      <td>619</td>\n",
       "      <td>Eleições Municipais 2024</td>\n",
       "      <td>06/10/2024</td>\n",
       "      <td>MUNICIPAL</td>\n",
       "      <td>BA</td>\n",
       "      <td>33910</td>\n",
       "      <td>BRUMADO</td>\n",
       "      <td>13</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>50002301448</td>\n",
       "      <td>40321</td>\n",
       "      <td>MARCIA SOUZA MACHADO GOMES</td>\n",
       "      <td>MARCIA MACHADO</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>-4</td>\n",
       "      <td>NÃO DIVULGÁVEL</td>\n",
       "      <td>-3</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>50001744137</td>\n",
       "      <td>PARTIDO ISOLADO</td>\n",
       "      <td>PSB</td>\n",
       "      <td>BA</td>\n",
       "      <td>31/10/1969</td>\n",
       "      <td>53326730531</td>\n",
       "      <td>4</td>\n",
       "      <td>FEMININO</td>\n",
       "      <td>8</td>\n",
       "      <td>SUPERIOR COMPLETO</td>\n",
       "      <td>3</td>\n",
       "      <td>CASADO(A)</td>\n",
       "      <td>1</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>143</td>\n",
       "      <td>PROFESSOR DE ENSINO DE PRIMEIRO E SEGUNDO GRAUS</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   DT_GERACAO HH_GERACAO  ANO_ELEICAO  CD_TIPO_ELEICAO    NM_TIPO_ELEICAO  \\\n",
       "0  17/09/2024   16:31:28         2024                2  ELEIÇÃO ORDINÁRIA   \n",
       "1  17/09/2024   16:31:28         2024                2  ELEIÇÃO ORDINÁRIA   \n",
       "2  17/09/2024   16:31:28         2024                2  ELEIÇÃO ORDINÁRIA   \n",
       "3  17/09/2024   16:31:28         2024                2  ELEIÇÃO ORDINÁRIA   \n",
       "4  17/09/2024   16:31:28         2024                2  ELEIÇÃO ORDINÁRIA   \n",
       "\n",
       "   NR_TURNO  CD_ELEICAO                DS_ELEICAO  DT_ELEICAO  \\\n",
       "0         1         619  Eleições Municipais 2024  06/10/2024   \n",
       "1         1         619  Eleições Municipais 2024  06/10/2024   \n",
       "2         1         619  Eleições Municipais 2024  06/10/2024   \n",
       "3         1         619  Eleições Municipais 2024  06/10/2024   \n",
       "4         1         619  Eleições Municipais 2024  06/10/2024   \n",
       "\n",
       "  TP_ABRANGENCIA_ELEICAO SG_UF  SG_UE               NM_UE  CD_CARGO  DS_CARGO  \\\n",
       "0              MUNICIPAL    BA  33782  BOM JESUS DA SERRA        13  VEREADOR   \n",
       "1              MUNICIPAL    BA  35815               IPIRÁ        13  VEREADOR   \n",
       "2              MUNICIPAL    BA  38253   RIACHÃO DAS NEVES        13  VEREADOR   \n",
       "3              MUNICIPAL    BA  34711               CONDE        13  VEREADOR   \n",
       "4              MUNICIPAL    BA  33910             BRUMADO        13  VEREADOR   \n",
       "\n",
       "   SQ_CANDIDATO  NR_CANDIDATO                NM_CANDIDATO NM_URNA_CANDIDATO  \\\n",
       "0   50002239886         20357            MARIA ROCHA DIAS         MARY DIAS   \n",
       "1   50002239960         36366      EDMILSON ARAUJO DA PAZ   MESTRE EDMILSON   \n",
       "2   50002239560         12444     VERILMA LIMA DOS SANTOS           VERINHA   \n",
       "3   50002239720         25610    JORGE CARDOSO DE ALMEIDA     JORGE DA ILHA   \n",
       "4   50002301448         40321  MARCIA SOUZA MACHADO GOMES    MARCIA MACHADO   \n",
       "\n",
       "  NM_SOCIAL_CANDIDATO  NR_CPF_CANDIDATO        DS_EMAIL  \\\n",
       "0              #NULO#                -4  NÃO DIVULGÁVEL   \n",
       "1              #NULO#                -4  NÃO DIVULGÁVEL   \n",
       "2              #NULO#                -4  NÃO DIVULGÁVEL   \n",
       "3              #NULO#                -4  NÃO DIVULGÁVEL   \n",
       "4              #NULO#                -4  NÃO DIVULGÁVEL   \n",
       "\n",
       "   CD_SITUACAO_CANDIDATURA DS_SITUACAO_CANDIDATURA    TP_AGREMIACAO  \\\n",
       "0                       -3                     #NE  PARTIDO ISOLADO   \n",
       "1                       -3                     #NE  PARTIDO ISOLADO   \n",
       "2                       -3                     #NE  PARTIDO ISOLADO   \n",
       "3                       -3                     #NE  PARTIDO ISOLADO   \n",
       "4                       -3                     #NE  PARTIDO ISOLADO   \n",
       "\n",
       "   NR_PARTIDO SG_PARTIDO                       NM_PARTIDO  NR_FEDERACAO  \\\n",
       "0          20       PODE                          PODEMOS            -1   \n",
       "1          36       AGIR                             AGIR            -1   \n",
       "2          12        PDT  PARTIDO DEMOCRÁTICO TRABALHISTA            -1   \n",
       "3          25        PRD    PARTIDO RENOVAÇÃO DEMOCRÁTICA            -1   \n",
       "4          40        PSB    PARTIDO SOCIALISTA BRASILEIRO            -1   \n",
       "\n",
       "  NM_FEDERACAO SG_FEDERACAO DS_COMPOSICAO_FEDERACAO  SQ_COLIGACAO  \\\n",
       "0       #NULO#       #NULO#                  #NULO#   50001744185   \n",
       "1       #NULO#       #NULO#                  #NULO#   50001744200   \n",
       "2       #NULO#       #NULO#                  #NULO#   50001744130   \n",
       "3       #NULO#       #NULO#                  #NULO#   50001744156   \n",
       "4       #NULO#       #NULO#                  #NULO#   50001744137   \n",
       "\n",
       "      NM_COLIGACAO DS_COMPOSICAO_COLIGACAO SG_UF_NASCIMENTO DT_NASCIMENTO  \\\n",
       "0  PARTIDO ISOLADO                    PODE               BA    12/11/1985   \n",
       "1  PARTIDO ISOLADO                    AGIR               BA    03/10/1976   \n",
       "2  PARTIDO ISOLADO                     PDT               BA    04/12/1980   \n",
       "3  PARTIDO ISOLADO                     PRD               BA    30/03/1974   \n",
       "4  PARTIDO ISOLADO                     PSB               BA    31/10/1969   \n",
       "\n",
       "   NR_TITULO_ELEITORAL_CANDIDATO  CD_GENERO  DS_GENERO  CD_GRAU_INSTRUCAO  \\\n",
       "0                   106637890540          4   FEMININO                  3   \n",
       "1                   108334920590          2  MASCULINO                  4   \n",
       "2                   101448370566          4   FEMININO                  3   \n",
       "3                    62709510582          2  MASCULINO                  4   \n",
       "4                    53326730531          4   FEMININO                  8   \n",
       "\n",
       "               DS_GRAU_INSTRUCAO  CD_ESTADO_CIVIL DS_ESTADO_CIVIL  \\\n",
       "0  ENSINO FUNDAMENTAL INCOMPLETO                1     SOLTEIRO(A)   \n",
       "1    ENSINO FUNDAMENTAL COMPLETO                1     SOLTEIRO(A)   \n",
       "2  ENSINO FUNDAMENTAL INCOMPLETO                1     SOLTEIRO(A)   \n",
       "3    ENSINO FUNDAMENTAL COMPLETO                1     SOLTEIRO(A)   \n",
       "4              SUPERIOR COMPLETO                3       CASADO(A)   \n",
       "\n",
       "   CD_COR_RACA DS_COR_RACA  CD_OCUPACAO  \\\n",
       "0            1      BRANCA          999   \n",
       "1            2       PRETA          999   \n",
       "2            2       PRETA          402   \n",
       "3            2       PRETA          999   \n",
       "4            1      BRANCA          143   \n",
       "\n",
       "                                         DS_OCUPACAO  CD_SIT_TOT_TURNO  \\\n",
       "0                                             OUTROS                -1   \n",
       "1                                             OUTROS                -1   \n",
       "2  VENDEDOR PRACISTA, REPRESENTANTE, CAIXEIRO-VIA...                -1   \n",
       "3                                             OUTROS                -1   \n",
       "4    PROFESSOR DE ENSINO DE PRIMEIRO E SEGUNDO GRAUS                -1   \n",
       "\n",
       "  DS_SIT_TOT_TURNO  \n",
       "0           #NULO#  \n",
       "1           #NULO#  \n",
       "2           #NULO#  \n",
       "3           #NULO#  \n",
       "4           #NULO#  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2024.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cadde42b-e698-40a9-b17b-7717dd8ede8b",
   "metadata": {},
   "source": [
    "### 🧹 Limpando duplicados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "f8b407b2-8f4f-40a0-81e8-b0277f7dac75",
   "metadata": {},
   "outputs": [],
   "source": [
    "# checando os duplicados segundo o número de identificação do título de eleitor\n",
    "duplicados = df_2024[df_2024.duplicated(subset='NR_TITULO_ELEITORAL_CANDIDATO', keep=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "9c005e9d-e78d-4d5e-89be-80ce2b53a43f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2024 = df_2024.drop_duplicates(subset='NR_TITULO_ELEITORAL_CANDIDATO')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "e8b57e49-cf94-499c-9920-e3821807f3d7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "462590"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2024[\"NR_TITULO_ELEITORAL_CANDIDATO\"].nunique()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "023a6756-9b80-4521-b043-80a72d8e557b",
   "metadata": {},
   "source": [
    "### 🧩 Padronizando o DF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "fc7de6cd-1a0d-40d1-9a7e-777ed772c557",
   "metadata": {},
   "outputs": [],
   "source": [
    "colunas_selecionadas = ['NR_TITULO_ELEITORAL_CANDIDATO', 'DS_COR_RACA', 'NM_CANDIDATO', 'NM_URNA_CANDIDATO', 'DS_CARGO', 'DS_SITUACAO_CANDIDATURA', 'SG_PARTIDO', 'SG_UF', 'NM_UE']\n",
    "df_2024 = df_2024[colunas_selecionadas]\n",
    "df_2024.columns = [f\"{coluna}_2024\" for coluna in df_2024.columns]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "d8a25e1e-7d5d-4e0d-bb0a-be83dfb293c7",
   "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>NR_TITULO_ELEITORAL_CANDIDATO_2024</th>\n",
       "      <th>DS_COR_RACA_2024</th>\n",
       "      <th>NM_CANDIDATO_2024</th>\n",
       "      <th>NM_URNA_CANDIDATO_2024</th>\n",
       "      <th>DS_CARGO_2024</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA_2024</th>\n",
       "      <th>SG_PARTIDO_2024</th>\n",
       "      <th>SG_UF_2024</th>\n",
       "      <th>NM_UE_2024</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>106637890540</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>MARIA ROCHA DIAS</td>\n",
       "      <td>MARY DIAS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PODE</td>\n",
       "      <td>BA</td>\n",
       "      <td>BOM JESUS DA SERRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>108334920590</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>EDMILSON ARAUJO DA PAZ</td>\n",
       "      <td>MESTRE EDMILSON</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>AGIR</td>\n",
       "      <td>BA</td>\n",
       "      <td>IPIRÁ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>101448370566</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>VERILMA LIMA DOS SANTOS</td>\n",
       "      <td>VERINHA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PDT</td>\n",
       "      <td>BA</td>\n",
       "      <td>RIACHÃO DAS NEVES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>62709510582</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>JORGE CARDOSO DE ALMEIDA</td>\n",
       "      <td>JORGE DA ILHA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PRD</td>\n",
       "      <td>BA</td>\n",
       "      <td>CONDE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>53326730531</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>MARCIA SOUZA MACHADO GOMES</td>\n",
       "      <td>MARCIA MACHADO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PSB</td>\n",
       "      <td>BA</td>\n",
       "      <td>BRUMADO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   NR_TITULO_ELEITORAL_CANDIDATO_2024 DS_COR_RACA_2024  \\\n",
       "0                        106637890540           BRANCA   \n",
       "1                        108334920590            PRETA   \n",
       "2                        101448370566            PRETA   \n",
       "3                         62709510582            PRETA   \n",
       "4                         53326730531           BRANCA   \n",
       "\n",
       "            NM_CANDIDATO_2024 NM_URNA_CANDIDATO_2024 DS_CARGO_2024  \\\n",
       "0            MARIA ROCHA DIAS              MARY DIAS      VEREADOR   \n",
       "1      EDMILSON ARAUJO DA PAZ        MESTRE EDMILSON      VEREADOR   \n",
       "2     VERILMA LIMA DOS SANTOS                VERINHA      VEREADOR   \n",
       "3    JORGE CARDOSO DE ALMEIDA          JORGE DA ILHA      VEREADOR   \n",
       "4  MARCIA SOUZA MACHADO GOMES         MARCIA MACHADO      VEREADOR   \n",
       "\n",
       "  DS_SITUACAO_CANDIDATURA_2024 SG_PARTIDO_2024 SG_UF_2024          NM_UE_2024  \n",
       "0                          #NE            PODE         BA  BOM JESUS DA SERRA  \n",
       "1                          #NE            AGIR         BA               IPIRÁ  \n",
       "2                          #NE             PDT         BA   RIACHÃO DAS NEVES  \n",
       "3                          #NE             PRD         BA               CONDE  \n",
       "4                          #NE             PSB         BA             BRUMADO  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2024.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "27fadae9-5612-4c9c-96b7-70369b49bac3",
   "metadata": {},
   "source": [
    "## 🔗 Unindo DFs de anos diferentes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "74de67a3-af5c-4edb-904b-4e497c2fb7cd",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Juntando df_2016 e df_2020 com base nas colunas corretas\n",
    "df_raça_part1 = pd.merge(df_2016, df_2020, left_on='NR_TITULO_ELEITORAL_CANDIDATO_2016', right_on='NR_TITULO_ELEITORAL_CANDIDATO_2020', how='inner')\n",
    "\n",
    "# Agora, juntando o resultado com df_2024\n",
    "df_raça = pd.merge(df_raça_part1, df_2024, left_on='NR_TITULO_ELEITORAL_CANDIDATO_2016', right_on='NR_TITULO_ELEITORAL_CANDIDATO_2024', how='inner')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "5c170c5e-73f3-42fa-9967-cba98b90e1b9",
   "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>NR_TITULO_ELEITORAL_CANDIDATO_2016</th>\n",
       "      <th>DS_COR_RACA_2016</th>\n",
       "      <th>NM_CANDIDATO_2016</th>\n",
       "      <th>NM_URNA_CANDIDATO_2016</th>\n",
       "      <th>DS_CARGO_2016</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA_2016</th>\n",
       "      <th>SG_PARTIDO_2016</th>\n",
       "      <th>SG_UF_2016</th>\n",
       "      <th>NM_UE_2016</th>\n",
       "      <th>NR_TITULO_ELEITORAL_CANDIDATO_2020</th>\n",
       "      <th>DS_COR_RACA_2020</th>\n",
       "      <th>NM_CANDIDATO_2020</th>\n",
       "      <th>NM_URNA_CANDIDATO_2020</th>\n",
       "      <th>DS_CARGO_2020</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA_2020</th>\n",
       "      <th>SG_PARTIDO_2020</th>\n",
       "      <th>SG_UF_2020</th>\n",
       "      <th>NM_UE_2020</th>\n",
       "      <th>NR_TITULO_ELEITORAL_CANDIDATO_2024</th>\n",
       "      <th>DS_COR_RACA_2024</th>\n",
       "      <th>NM_CANDIDATO_2024</th>\n",
       "      <th>NM_URNA_CANDIDATO_2024</th>\n",
       "      <th>DS_CARGO_2024</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA_2024</th>\n",
       "      <th>SG_PARTIDO_2024</th>\n",
       "      <th>SG_UF_2024</th>\n",
       "      <th>NM_UE_2024</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>47554410205</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>EDIVALDO RODRIGUES DOS SANTOS</td>\n",
       "      <td>EDIVALDO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PTB</td>\n",
       "      <td>MG</td>\n",
       "      <td>JEQUITINHONHA</td>\n",
       "      <td>47554410205</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>EDIVALDO RODRIGUES DOS SANTOS</td>\n",
       "      <td>EDIVALDO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PSD</td>\n",
       "      <td>MG</td>\n",
       "      <td>JEQUITINHONHA</td>\n",
       "      <td>47554410205</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>EDIVALDO RODRIGUES DOS SANTOS</td>\n",
       "      <td>EDIVALDO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PSDB</td>\n",
       "      <td>MG</td>\n",
       "      <td>JEQUITINHONHA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3919891074</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLÁUDIO LÚCIO RODRIGUES</td>\n",
       "      <td>CACÁ LÚCIO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PRB</td>\n",
       "      <td>GO</td>\n",
       "      <td>CATALÃO</td>\n",
       "      <td>3919891074</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>CLAUDIO LUCIO RODRIGUES</td>\n",
       "      <td>KAKA DOS ANIMAIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>REPUBLICANOS</td>\n",
       "      <td>GO</td>\n",
       "      <td>CATALÃO</td>\n",
       "      <td>3919891074</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLAUDIO LUCIO RODRIGUES</td>\n",
       "      <td>KAKA AMIGO DOS ANIMAIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PSDB</td>\n",
       "      <td>GO</td>\n",
       "      <td>CATALÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20926432704</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>JOSE XAVIER DE OLIVEIRA</td>\n",
       "      <td>REIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PSB</td>\n",
       "      <td>PA</td>\n",
       "      <td>SANTA MARIA DAS BARREIRAS</td>\n",
       "      <td>20926432704</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>JOSE XAVIER DE OLIVEIRA</td>\n",
       "      <td>REIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PSB</td>\n",
       "      <td>PA</td>\n",
       "      <td>SANTA MARIA DAS BARREIRAS</td>\n",
       "      <td>20926432704</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>JOSE XAVIER DE OLIVEIRA</td>\n",
       "      <td>REIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PL</td>\n",
       "      <td>PA</td>\n",
       "      <td>SANTA MARIA DAS BARREIRAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>81735530272</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>ANORINO SOUZA SANTOS</td>\n",
       "      <td>MIZIM</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PTN</td>\n",
       "      <td>BA</td>\n",
       "      <td>JUCURUÇU</td>\n",
       "      <td>81735530272</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>ANORINO SOUZA SANTOS</td>\n",
       "      <td>MIZIN</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PSD</td>\n",
       "      <td>BA</td>\n",
       "      <td>JUCURUÇU</td>\n",
       "      <td>81735530272</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>ANORINO SOUZA SANTOS</td>\n",
       "      <td>MIZIM DE ITAMARATY</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PSDB</td>\n",
       "      <td>BA</td>\n",
       "      <td>JUCURUÇU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4952270281</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLEUSA MARIA DA COSTA</td>\n",
       "      <td>CLEUSA MARIA DA COSTA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PT</td>\n",
       "      <td>MG</td>\n",
       "      <td>UBÁ</td>\n",
       "      <td>4952270281</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLEUSA MARIA DA COSTA</td>\n",
       "      <td>CLEUSINHA DO LACTÁRIO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PDT</td>\n",
       "      <td>MG</td>\n",
       "      <td>UBÁ</td>\n",
       "      <td>4952270281</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLEUSA MARIA DA COSTA</td>\n",
       "      <td>CLEUSINHA DO LACTARIO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>MOBILIZA</td>\n",
       "      <td>MG</td>\n",
       "      <td>UBÁ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   NR_TITULO_ELEITORAL_CANDIDATO_2016 DS_COR_RACA_2016  \\\n",
       "0                         47554410205            PARDA   \n",
       "1                          3919891074           BRANCA   \n",
       "2                         20926432704            PARDA   \n",
       "3                         81735530272            PARDA   \n",
       "4                          4952270281           BRANCA   \n",
       "\n",
       "               NM_CANDIDATO_2016 NM_URNA_CANDIDATO_2016 DS_CARGO_2016  \\\n",
       "0  EDIVALDO RODRIGUES DOS SANTOS               EDIVALDO      VEREADOR   \n",
       "1        CLÁUDIO LÚCIO RODRIGUES             CACÁ LÚCIO      VEREADOR   \n",
       "2        JOSE XAVIER DE OLIVEIRA                   REIS      VEREADOR   \n",
       "3           ANORINO SOUZA SANTOS                  MIZIM      VEREADOR   \n",
       "4          CLEUSA MARIA DA COSTA  CLEUSA MARIA DA COSTA      VEREADOR   \n",
       "\n",
       "  DS_SITUACAO_CANDIDATURA_2016 SG_PARTIDO_2016 SG_UF_2016  \\\n",
       "0                         APTO             PTB         MG   \n",
       "1                         APTO             PRB         GO   \n",
       "2                         APTO             PSB         PA   \n",
       "3                         APTO             PTN         BA   \n",
       "4                         APTO              PT         MG   \n",
       "\n",
       "                  NM_UE_2016  NR_TITULO_ELEITORAL_CANDIDATO_2020  \\\n",
       "0              JEQUITINHONHA                         47554410205   \n",
       "1                    CATALÃO                          3919891074   \n",
       "2  SANTA MARIA DAS BARREIRAS                         20926432704   \n",
       "3                   JUCURUÇU                         81735530272   \n",
       "4                        UBÁ                          4952270281   \n",
       "\n",
       "  DS_COR_RACA_2020              NM_CANDIDATO_2020 NM_URNA_CANDIDATO_2020  \\\n",
       "0            PARDA  EDIVALDO RODRIGUES DOS SANTOS               EDIVALDO   \n",
       "1            PARDA        CLAUDIO LUCIO RODRIGUES       KAKA DOS ANIMAIS   \n",
       "2            PRETA        JOSE XAVIER DE OLIVEIRA                   REIS   \n",
       "3            PARDA           ANORINO SOUZA SANTOS                  MIZIN   \n",
       "4           BRANCA          CLEUSA MARIA DA COSTA  CLEUSINHA DO LACTÁRIO   \n",
       "\n",
       "  DS_CARGO_2020 DS_SITUACAO_CANDIDATURA_2020 SG_PARTIDO_2020 SG_UF_2020  \\\n",
       "0      VEREADOR                         APTO             PSD         MG   \n",
       "1      VEREADOR                         APTO    REPUBLICANOS         GO   \n",
       "2      VEREADOR                         APTO             PSB         PA   \n",
       "3      VEREADOR                         APTO             PSD         BA   \n",
       "4      VEREADOR                         APTO             PDT         MG   \n",
       "\n",
       "                  NM_UE_2020  NR_TITULO_ELEITORAL_CANDIDATO_2024  \\\n",
       "0              JEQUITINHONHA                         47554410205   \n",
       "1                    CATALÃO                          3919891074   \n",
       "2  SANTA MARIA DAS BARREIRAS                         20926432704   \n",
       "3                   JUCURUÇU                         81735530272   \n",
       "4                        UBÁ                          4952270281   \n",
       "\n",
       "  DS_COR_RACA_2024              NM_CANDIDATO_2024  NM_URNA_CANDIDATO_2024  \\\n",
       "0            PARDA  EDIVALDO RODRIGUES DOS SANTOS                EDIVALDO   \n",
       "1           BRANCA        CLAUDIO LUCIO RODRIGUES  KAKA AMIGO DOS ANIMAIS   \n",
       "2            PRETA        JOSE XAVIER DE OLIVEIRA                    REIS   \n",
       "3            PARDA           ANORINO SOUZA SANTOS      MIZIM DE ITAMARATY   \n",
       "4           BRANCA          CLEUSA MARIA DA COSTA   CLEUSINHA DO LACTARIO   \n",
       "\n",
       "  DS_CARGO_2024 DS_SITUACAO_CANDIDATURA_2024 SG_PARTIDO_2024 SG_UF_2024  \\\n",
       "0      VEREADOR                          #NE            PSDB         MG   \n",
       "1      VEREADOR                          #NE            PSDB         GO   \n",
       "2      VEREADOR                          #NE              PL         PA   \n",
       "3      VEREADOR                          #NE            PSDB         BA   \n",
       "4      VEREADOR                          #NE        MOBILIZA         MG   \n",
       "\n",
       "                  NM_UE_2024  \n",
       "0              JEQUITINHONHA  \n",
       "1                    CATALÃO  \n",
       "2  SANTA MARIA DAS BARREIRAS  \n",
       "3                   JUCURUÇU  \n",
       "4                        UBÁ  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raça.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "f9fb4a10-50f2-4b20-ac91-5c920cc137a0",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Definindo as condições\n",
    "condicoes = [\n",
    "    (df_raça['DS_COR_RACA_2016'] != df_raça['DS_COR_RACA_2020'])\n",
    "]\n",
    "\n",
    "# Definindo os valores correspondentes\n",
    "valores = [\"mudou 2016 para 2020\"]\n",
    "\n",
    "# Criando a nova coluna com base nas condições\n",
    "df_raça['Resultado'] = np.select(condicoes, valores, default=\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "25ad281c-450a-4794-87a7-14ccef377305",
   "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>NR_TITULO_ELEITORAL_CANDIDATO_2016</th>\n",
       "      <th>DS_COR_RACA_2016</th>\n",
       "      <th>NM_CANDIDATO_2016</th>\n",
       "      <th>NM_URNA_CANDIDATO_2016</th>\n",
       "      <th>DS_CARGO_2016</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA_2016</th>\n",
       "      <th>SG_PARTIDO_2016</th>\n",
       "      <th>SG_UF_2016</th>\n",
       "      <th>NM_UE_2016</th>\n",
       "      <th>NR_TITULO_ELEITORAL_CANDIDATO_2020</th>\n",
       "      <th>DS_COR_RACA_2020</th>\n",
       "      <th>NM_CANDIDATO_2020</th>\n",
       "      <th>NM_URNA_CANDIDATO_2020</th>\n",
       "      <th>DS_CARGO_2020</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA_2020</th>\n",
       "      <th>SG_PARTIDO_2020</th>\n",
       "      <th>SG_UF_2020</th>\n",
       "      <th>NM_UE_2020</th>\n",
       "      <th>NR_TITULO_ELEITORAL_CANDIDATO_2024</th>\n",
       "      <th>DS_COR_RACA_2024</th>\n",
       "      <th>NM_CANDIDATO_2024</th>\n",
       "      <th>NM_URNA_CANDIDATO_2024</th>\n",
       "      <th>DS_CARGO_2024</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA_2024</th>\n",
       "      <th>SG_PARTIDO_2024</th>\n",
       "      <th>SG_UF_2024</th>\n",
       "      <th>NM_UE_2024</th>\n",
       "      <th>Resultado</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>47554410205</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>EDIVALDO RODRIGUES DOS SANTOS</td>\n",
       "      <td>EDIVALDO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PTB</td>\n",
       "      <td>MG</td>\n",
       "      <td>JEQUITINHONHA</td>\n",
       "      <td>47554410205</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>EDIVALDO RODRIGUES DOS SANTOS</td>\n",
       "      <td>EDIVALDO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PSD</td>\n",
       "      <td>MG</td>\n",
       "      <td>JEQUITINHONHA</td>\n",
       "      <td>47554410205</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>EDIVALDO RODRIGUES DOS SANTOS</td>\n",
       "      <td>EDIVALDO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PSDB</td>\n",
       "      <td>MG</td>\n",
       "      <td>JEQUITINHONHA</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3919891074</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLÁUDIO LÚCIO RODRIGUES</td>\n",
       "      <td>CACÁ LÚCIO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PRB</td>\n",
       "      <td>GO</td>\n",
       "      <td>CATALÃO</td>\n",
       "      <td>3919891074</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>CLAUDIO LUCIO RODRIGUES</td>\n",
       "      <td>KAKA DOS ANIMAIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>REPUBLICANOS</td>\n",
       "      <td>GO</td>\n",
       "      <td>CATALÃO</td>\n",
       "      <td>3919891074</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLAUDIO LUCIO RODRIGUES</td>\n",
       "      <td>KAKA AMIGO DOS ANIMAIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PSDB</td>\n",
       "      <td>GO</td>\n",
       "      <td>CATALÃO</td>\n",
       "      <td>mudou 2016 para 2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20926432704</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>JOSE XAVIER DE OLIVEIRA</td>\n",
       "      <td>REIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PSB</td>\n",
       "      <td>PA</td>\n",
       "      <td>SANTA MARIA DAS BARREIRAS</td>\n",
       "      <td>20926432704</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>JOSE XAVIER DE OLIVEIRA</td>\n",
       "      <td>REIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PSB</td>\n",
       "      <td>PA</td>\n",
       "      <td>SANTA MARIA DAS BARREIRAS</td>\n",
       "      <td>20926432704</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>JOSE XAVIER DE OLIVEIRA</td>\n",
       "      <td>REIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PL</td>\n",
       "      <td>PA</td>\n",
       "      <td>SANTA MARIA DAS BARREIRAS</td>\n",
       "      <td>mudou 2016 para 2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>81735530272</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>ANORINO SOUZA SANTOS</td>\n",
       "      <td>MIZIM</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PTN</td>\n",
       "      <td>BA</td>\n",
       "      <td>JUCURUÇU</td>\n",
       "      <td>81735530272</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>ANORINO SOUZA SANTOS</td>\n",
       "      <td>MIZIN</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PSD</td>\n",
       "      <td>BA</td>\n",
       "      <td>JUCURUÇU</td>\n",
       "      <td>81735530272</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>ANORINO SOUZA SANTOS</td>\n",
       "      <td>MIZIM DE ITAMARATY</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PSDB</td>\n",
       "      <td>BA</td>\n",
       "      <td>JUCURUÇU</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4952270281</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLEUSA MARIA DA COSTA</td>\n",
       "      <td>CLEUSA MARIA DA COSTA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PT</td>\n",
       "      <td>MG</td>\n",
       "      <td>UBÁ</td>\n",
       "      <td>4952270281</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLEUSA MARIA DA COSTA</td>\n",
       "      <td>CLEUSINHA DO LACTÁRIO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PDT</td>\n",
       "      <td>MG</td>\n",
       "      <td>UBÁ</td>\n",
       "      <td>4952270281</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLEUSA MARIA DA COSTA</td>\n",
       "      <td>CLEUSINHA DO LACTARIO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>MOBILIZA</td>\n",
       "      <td>MG</td>\n",
       "      <td>UBÁ</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   NR_TITULO_ELEITORAL_CANDIDATO_2016 DS_COR_RACA_2016  \\\n",
       "0                         47554410205            PARDA   \n",
       "1                          3919891074           BRANCA   \n",
       "2                         20926432704            PARDA   \n",
       "3                         81735530272            PARDA   \n",
       "4                          4952270281           BRANCA   \n",
       "\n",
       "               NM_CANDIDATO_2016 NM_URNA_CANDIDATO_2016 DS_CARGO_2016  \\\n",
       "0  EDIVALDO RODRIGUES DOS SANTOS               EDIVALDO      VEREADOR   \n",
       "1        CLÁUDIO LÚCIO RODRIGUES             CACÁ LÚCIO      VEREADOR   \n",
       "2        JOSE XAVIER DE OLIVEIRA                   REIS      VEREADOR   \n",
       "3           ANORINO SOUZA SANTOS                  MIZIM      VEREADOR   \n",
       "4          CLEUSA MARIA DA COSTA  CLEUSA MARIA DA COSTA      VEREADOR   \n",
       "\n",
       "  DS_SITUACAO_CANDIDATURA_2016 SG_PARTIDO_2016 SG_UF_2016  \\\n",
       "0                         APTO             PTB         MG   \n",
       "1                         APTO             PRB         GO   \n",
       "2                         APTO             PSB         PA   \n",
       "3                         APTO             PTN         BA   \n",
       "4                         APTO              PT         MG   \n",
       "\n",
       "                  NM_UE_2016  NR_TITULO_ELEITORAL_CANDIDATO_2020  \\\n",
       "0              JEQUITINHONHA                         47554410205   \n",
       "1                    CATALÃO                          3919891074   \n",
       "2  SANTA MARIA DAS BARREIRAS                         20926432704   \n",
       "3                   JUCURUÇU                         81735530272   \n",
       "4                        UBÁ                          4952270281   \n",
       "\n",
       "  DS_COR_RACA_2020              NM_CANDIDATO_2020 NM_URNA_CANDIDATO_2020  \\\n",
       "0            PARDA  EDIVALDO RODRIGUES DOS SANTOS               EDIVALDO   \n",
       "1            PARDA        CLAUDIO LUCIO RODRIGUES       KAKA DOS ANIMAIS   \n",
       "2            PRETA        JOSE XAVIER DE OLIVEIRA                   REIS   \n",
       "3            PARDA           ANORINO SOUZA SANTOS                  MIZIN   \n",
       "4           BRANCA          CLEUSA MARIA DA COSTA  CLEUSINHA DO LACTÁRIO   \n",
       "\n",
       "  DS_CARGO_2020 DS_SITUACAO_CANDIDATURA_2020 SG_PARTIDO_2020 SG_UF_2020  \\\n",
       "0      VEREADOR                         APTO             PSD         MG   \n",
       "1      VEREADOR                         APTO    REPUBLICANOS         GO   \n",
       "2      VEREADOR                         APTO             PSB         PA   \n",
       "3      VEREADOR                         APTO             PSD         BA   \n",
       "4      VEREADOR                         APTO             PDT         MG   \n",
       "\n",
       "                  NM_UE_2020  NR_TITULO_ELEITORAL_CANDIDATO_2024  \\\n",
       "0              JEQUITINHONHA                         47554410205   \n",
       "1                    CATALÃO                          3919891074   \n",
       "2  SANTA MARIA DAS BARREIRAS                         20926432704   \n",
       "3                   JUCURUÇU                         81735530272   \n",
       "4                        UBÁ                          4952270281   \n",
       "\n",
       "  DS_COR_RACA_2024              NM_CANDIDATO_2024  NM_URNA_CANDIDATO_2024  \\\n",
       "0            PARDA  EDIVALDO RODRIGUES DOS SANTOS                EDIVALDO   \n",
       "1           BRANCA        CLAUDIO LUCIO RODRIGUES  KAKA AMIGO DOS ANIMAIS   \n",
       "2            PRETA        JOSE XAVIER DE OLIVEIRA                    REIS   \n",
       "3            PARDA           ANORINO SOUZA SANTOS      MIZIM DE ITAMARATY   \n",
       "4           BRANCA          CLEUSA MARIA DA COSTA   CLEUSINHA DO LACTARIO   \n",
       "\n",
       "  DS_CARGO_2024 DS_SITUACAO_CANDIDATURA_2024 SG_PARTIDO_2024 SG_UF_2024  \\\n",
       "0      VEREADOR                          #NE            PSDB         MG   \n",
       "1      VEREADOR                          #NE            PSDB         GO   \n",
       "2      VEREADOR                          #NE              PL         PA   \n",
       "3      VEREADOR                          #NE            PSDB         BA   \n",
       "4      VEREADOR                          #NE        MOBILIZA         MG   \n",
       "\n",
       "                  NM_UE_2024             Resultado  \n",
       "0              JEQUITINHONHA                        \n",
       "1                    CATALÃO  mudou 2016 para 2020  \n",
       "2  SANTA MARIA DAS BARREIRAS  mudou 2016 para 2020  \n",
       "3                   JUCURUÇU                        \n",
       "4                        UBÁ                        "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raça.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "441f7f61-f3dd-4951-892c-190da74c11d2",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_raça.to_csv('data/mudaram_2016_2020.csv', decimal=\";\", index=False, encoding='latin-1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "a2357cec-348a-4fe2-a7b1-6dcb83e8932f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Definindo as condições, que foram modificadas segundo a pauta\n",
    "condicoes = [\n",
    "    #(df_raça['DS_COR_RACA_2016'] != df_raça['DS_COR_RACA_2020']) & (df_raça['DS_COR_RACA_2016'] == df_raça['DS_COR_RACA_2024']),\n",
    "   # (df_raça['DS_COR_RACA_2016'] != df_raça['DS_COR_RACA_2020']) & (df_raça['DS_COR_RACA_2016'] != df_raça['DS_COR_RACA_2024']) & (df_raça['DS_COR_RACA_2020'] != df_raça['DS_COR_RACA_2024']),\n",
    "    (df_raça['DS_COR_RACA_2020'] != df_raça['DS_COR_RACA_2024'])\n",
    "]\n",
    "\n",
    "# Definindo os valores correspondentes\n",
    "valores = [\n",
    "   # \"2016 e 2024 igual\",\n",
    "   # \"cores diferentes todos os anos\",\n",
    "    \"mudou de 2020 para 2024\"\n",
    "]\n",
    "\n",
    "# Criando a nova coluna com base nas condições\n",
    "df_raça['Resultado'] = np.select(condicoes, valores, default=\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "9c70813b-7241-44cf-8a6a-6b47acad1922",
   "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>NR_TITULO_ELEITORAL_CANDIDATO_2016</th>\n",
       "      <th>DS_COR_RACA_2016</th>\n",
       "      <th>NM_CANDIDATO_2016</th>\n",
       "      <th>NM_URNA_CANDIDATO_2016</th>\n",
       "      <th>DS_CARGO_2016</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA_2016</th>\n",
       "      <th>SG_PARTIDO_2016</th>\n",
       "      <th>SG_UF_2016</th>\n",
       "      <th>NM_UE_2016</th>\n",
       "      <th>NR_TITULO_ELEITORAL_CANDIDATO_2020</th>\n",
       "      <th>DS_COR_RACA_2020</th>\n",
       "      <th>NM_CANDIDATO_2020</th>\n",
       "      <th>NM_URNA_CANDIDATO_2020</th>\n",
       "      <th>DS_CARGO_2020</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA_2020</th>\n",
       "      <th>SG_PARTIDO_2020</th>\n",
       "      <th>SG_UF_2020</th>\n",
       "      <th>NM_UE_2020</th>\n",
       "      <th>NR_TITULO_ELEITORAL_CANDIDATO_2024</th>\n",
       "      <th>DS_COR_RACA_2024</th>\n",
       "      <th>NM_CANDIDATO_2024</th>\n",
       "      <th>NM_URNA_CANDIDATO_2024</th>\n",
       "      <th>DS_CARGO_2024</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA_2024</th>\n",
       "      <th>SG_PARTIDO_2024</th>\n",
       "      <th>SG_UF_2024</th>\n",
       "      <th>NM_UE_2024</th>\n",
       "      <th>Resultado</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>47554410205</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>EDIVALDO RODRIGUES DOS SANTOS</td>\n",
       "      <td>EDIVALDO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PTB</td>\n",
       "      <td>MG</td>\n",
       "      <td>JEQUITINHONHA</td>\n",
       "      <td>47554410205</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>EDIVALDO RODRIGUES DOS SANTOS</td>\n",
       "      <td>EDIVALDO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PSD</td>\n",
       "      <td>MG</td>\n",
       "      <td>JEQUITINHONHA</td>\n",
       "      <td>47554410205</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>EDIVALDO RODRIGUES DOS SANTOS</td>\n",
       "      <td>EDIVALDO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PSDB</td>\n",
       "      <td>MG</td>\n",
       "      <td>JEQUITINHONHA</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3919891074</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLÁUDIO LÚCIO RODRIGUES</td>\n",
       "      <td>CACÁ LÚCIO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PRB</td>\n",
       "      <td>GO</td>\n",
       "      <td>CATALÃO</td>\n",
       "      <td>3919891074</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>CLAUDIO LUCIO RODRIGUES</td>\n",
       "      <td>KAKA DOS ANIMAIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>REPUBLICANOS</td>\n",
       "      <td>GO</td>\n",
       "      <td>CATALÃO</td>\n",
       "      <td>3919891074</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLAUDIO LUCIO RODRIGUES</td>\n",
       "      <td>KAKA AMIGO DOS ANIMAIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PSDB</td>\n",
       "      <td>GO</td>\n",
       "      <td>CATALÃO</td>\n",
       "      <td>mudou de 2020 para 2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20926432704</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>JOSE XAVIER DE OLIVEIRA</td>\n",
       "      <td>REIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PSB</td>\n",
       "      <td>PA</td>\n",
       "      <td>SANTA MARIA DAS BARREIRAS</td>\n",
       "      <td>20926432704</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>JOSE XAVIER DE OLIVEIRA</td>\n",
       "      <td>REIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PSB</td>\n",
       "      <td>PA</td>\n",
       "      <td>SANTA MARIA DAS BARREIRAS</td>\n",
       "      <td>20926432704</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>JOSE XAVIER DE OLIVEIRA</td>\n",
       "      <td>REIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PL</td>\n",
       "      <td>PA</td>\n",
       "      <td>SANTA MARIA DAS BARREIRAS</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>81735530272</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>ANORINO SOUZA SANTOS</td>\n",
       "      <td>MIZIM</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PTN</td>\n",
       "      <td>BA</td>\n",
       "      <td>JUCURUÇU</td>\n",
       "      <td>81735530272</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>ANORINO SOUZA SANTOS</td>\n",
       "      <td>MIZIN</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PSD</td>\n",
       "      <td>BA</td>\n",
       "      <td>JUCURUÇU</td>\n",
       "      <td>81735530272</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>ANORINO SOUZA SANTOS</td>\n",
       "      <td>MIZIM DE ITAMARATY</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PSDB</td>\n",
       "      <td>BA</td>\n",
       "      <td>JUCURUÇU</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4952270281</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLEUSA MARIA DA COSTA</td>\n",
       "      <td>CLEUSA MARIA DA COSTA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PT</td>\n",
       "      <td>MG</td>\n",
       "      <td>UBÁ</td>\n",
       "      <td>4952270281</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLEUSA MARIA DA COSTA</td>\n",
       "      <td>CLEUSINHA DO LACTÁRIO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PDT</td>\n",
       "      <td>MG</td>\n",
       "      <td>UBÁ</td>\n",
       "      <td>4952270281</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLEUSA MARIA DA COSTA</td>\n",
       "      <td>CLEUSINHA DO LACTARIO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>MOBILIZA</td>\n",
       "      <td>MG</td>\n",
       "      <td>UBÁ</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   NR_TITULO_ELEITORAL_CANDIDATO_2016 DS_COR_RACA_2016  \\\n",
       "0                         47554410205            PARDA   \n",
       "1                          3919891074           BRANCA   \n",
       "2                         20926432704            PARDA   \n",
       "3                         81735530272            PARDA   \n",
       "4                          4952270281           BRANCA   \n",
       "\n",
       "               NM_CANDIDATO_2016 NM_URNA_CANDIDATO_2016 DS_CARGO_2016  \\\n",
       "0  EDIVALDO RODRIGUES DOS SANTOS               EDIVALDO      VEREADOR   \n",
       "1        CLÁUDIO LÚCIO RODRIGUES             CACÁ LÚCIO      VEREADOR   \n",
       "2        JOSE XAVIER DE OLIVEIRA                   REIS      VEREADOR   \n",
       "3           ANORINO SOUZA SANTOS                  MIZIM      VEREADOR   \n",
       "4          CLEUSA MARIA DA COSTA  CLEUSA MARIA DA COSTA      VEREADOR   \n",
       "\n",
       "  DS_SITUACAO_CANDIDATURA_2016 SG_PARTIDO_2016 SG_UF_2016  \\\n",
       "0                         APTO             PTB         MG   \n",
       "1                         APTO             PRB         GO   \n",
       "2                         APTO             PSB         PA   \n",
       "3                         APTO             PTN         BA   \n",
       "4                         APTO              PT         MG   \n",
       "\n",
       "                  NM_UE_2016  NR_TITULO_ELEITORAL_CANDIDATO_2020  \\\n",
       "0              JEQUITINHONHA                         47554410205   \n",
       "1                    CATALÃO                          3919891074   \n",
       "2  SANTA MARIA DAS BARREIRAS                         20926432704   \n",
       "3                   JUCURUÇU                         81735530272   \n",
       "4                        UBÁ                          4952270281   \n",
       "\n",
       "  DS_COR_RACA_2020              NM_CANDIDATO_2020 NM_URNA_CANDIDATO_2020  \\\n",
       "0            PARDA  EDIVALDO RODRIGUES DOS SANTOS               EDIVALDO   \n",
       "1            PARDA        CLAUDIO LUCIO RODRIGUES       KAKA DOS ANIMAIS   \n",
       "2            PRETA        JOSE XAVIER DE OLIVEIRA                   REIS   \n",
       "3            PARDA           ANORINO SOUZA SANTOS                  MIZIN   \n",
       "4           BRANCA          CLEUSA MARIA DA COSTA  CLEUSINHA DO LACTÁRIO   \n",
       "\n",
       "  DS_CARGO_2020 DS_SITUACAO_CANDIDATURA_2020 SG_PARTIDO_2020 SG_UF_2020  \\\n",
       "0      VEREADOR                         APTO             PSD         MG   \n",
       "1      VEREADOR                         APTO    REPUBLICANOS         GO   \n",
       "2      VEREADOR                         APTO             PSB         PA   \n",
       "3      VEREADOR                         APTO             PSD         BA   \n",
       "4      VEREADOR                         APTO             PDT         MG   \n",
       "\n",
       "                  NM_UE_2020  NR_TITULO_ELEITORAL_CANDIDATO_2024  \\\n",
       "0              JEQUITINHONHA                         47554410205   \n",
       "1                    CATALÃO                          3919891074   \n",
       "2  SANTA MARIA DAS BARREIRAS                         20926432704   \n",
       "3                   JUCURUÇU                         81735530272   \n",
       "4                        UBÁ                          4952270281   \n",
       "\n",
       "  DS_COR_RACA_2024              NM_CANDIDATO_2024  NM_URNA_CANDIDATO_2024  \\\n",
       "0            PARDA  EDIVALDO RODRIGUES DOS SANTOS                EDIVALDO   \n",
       "1           BRANCA        CLAUDIO LUCIO RODRIGUES  KAKA AMIGO DOS ANIMAIS   \n",
       "2            PRETA        JOSE XAVIER DE OLIVEIRA                    REIS   \n",
       "3            PARDA           ANORINO SOUZA SANTOS      MIZIM DE ITAMARATY   \n",
       "4           BRANCA          CLEUSA MARIA DA COSTA   CLEUSINHA DO LACTARIO   \n",
       "\n",
       "  DS_CARGO_2024 DS_SITUACAO_CANDIDATURA_2024 SG_PARTIDO_2024 SG_UF_2024  \\\n",
       "0      VEREADOR                          #NE            PSDB         MG   \n",
       "1      VEREADOR                          #NE            PSDB         GO   \n",
       "2      VEREADOR                          #NE              PL         PA   \n",
       "3      VEREADOR                          #NE            PSDB         BA   \n",
       "4      VEREADOR                          #NE        MOBILIZA         MG   \n",
       "\n",
       "                  NM_UE_2024                Resultado  \n",
       "0              JEQUITINHONHA                           \n",
       "1                    CATALÃO  mudou de 2020 para 2024  \n",
       "2  SANTA MARIA DAS BARREIRAS                           \n",
       "3                   JUCURUÇU                           \n",
       "4                        UBÁ                           "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raça.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "1cb0eb9c-5765-4c29-a656-82c984473416",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Filtrando o DataFrame para manter apenas as linhas onde Resultado_Cores não está vazio\n",
    "df_filtrado = df_raça[df_raça['Resultado'] != \"\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "1144cc33-412a-41a1-b45b-69a1c018ed90",
   "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>NR_TITULO_ELEITORAL_CANDIDATO_2016</th>\n",
       "      <th>DS_COR_RACA_2016</th>\n",
       "      <th>NM_CANDIDATO_2016</th>\n",
       "      <th>NM_URNA_CANDIDATO_2016</th>\n",
       "      <th>DS_CARGO_2016</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA_2016</th>\n",
       "      <th>SG_PARTIDO_2016</th>\n",
       "      <th>SG_UF_2016</th>\n",
       "      <th>NM_UE_2016</th>\n",
       "      <th>NR_TITULO_ELEITORAL_CANDIDATO_2020</th>\n",
       "      <th>DS_COR_RACA_2020</th>\n",
       "      <th>NM_CANDIDATO_2020</th>\n",
       "      <th>NM_URNA_CANDIDATO_2020</th>\n",
       "      <th>DS_CARGO_2020</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA_2020</th>\n",
       "      <th>SG_PARTIDO_2020</th>\n",
       "      <th>SG_UF_2020</th>\n",
       "      <th>NM_UE_2020</th>\n",
       "      <th>NR_TITULO_ELEITORAL_CANDIDATO_2024</th>\n",
       "      <th>DS_COR_RACA_2024</th>\n",
       "      <th>NM_CANDIDATO_2024</th>\n",
       "      <th>NM_URNA_CANDIDATO_2024</th>\n",
       "      <th>DS_CARGO_2024</th>\n",
       "      <th>DS_SITUACAO_CANDIDATURA_2024</th>\n",
       "      <th>SG_PARTIDO_2024</th>\n",
       "      <th>SG_UF_2024</th>\n",
       "      <th>NM_UE_2024</th>\n",
       "      <th>Resultado</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3919891074</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLÁUDIO LÚCIO RODRIGUES</td>\n",
       "      <td>CACÁ LÚCIO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PRB</td>\n",
       "      <td>GO</td>\n",
       "      <td>CATALÃO</td>\n",
       "      <td>3919891074</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>CLAUDIO LUCIO RODRIGUES</td>\n",
       "      <td>KAKA DOS ANIMAIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>REPUBLICANOS</td>\n",
       "      <td>GO</td>\n",
       "      <td>CATALÃO</td>\n",
       "      <td>3919891074</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>CLAUDIO LUCIO RODRIGUES</td>\n",
       "      <td>KAKA AMIGO DOS ANIMAIS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PSDB</td>\n",
       "      <td>GO</td>\n",
       "      <td>CATALÃO</td>\n",
       "      <td>mudou de 2020 para 2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>41324280850</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>ELIONILDA JOSÉ DE SANTANA</td>\n",
       "      <td>IRMÃ ELIONILDA</td>\n",
       "      <td>VICE-PREFEITO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PP</td>\n",
       "      <td>PE</td>\n",
       "      <td>ITAPISSUMA</td>\n",
       "      <td>41324280850</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>ELIONILDA JOSÉ DE SANTANA</td>\n",
       "      <td>IRMÃ ELIONILDA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>MDB</td>\n",
       "      <td>PE</td>\n",
       "      <td>ITAPISSUMA</td>\n",
       "      <td>41324280850</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>ELIONILDA JOSE DE SANTANA</td>\n",
       "      <td>IRMÃ ELIONILDA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PSB</td>\n",
       "      <td>PE</td>\n",
       "      <td>ITAPISSUMA</td>\n",
       "      <td>mudou de 2020 para 2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>122129830213</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>THARCILA CRISTINA DA SILVA</td>\n",
       "      <td>THARCILA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PSL</td>\n",
       "      <td>MG</td>\n",
       "      <td>CLÁUDIO</td>\n",
       "      <td>122129830213</td>\n",
       "      <td>PRETA</td>\n",
       "      <td>THARCILA CRISTINA DA SILVA</td>\n",
       "      <td>THARCILA DO SÃO FRANCISCO</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PODE</td>\n",
       "      <td>MG</td>\n",
       "      <td>CLÁUDIO</td>\n",
       "      <td>122129830213</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>THARCILA CRISTINA DA SILVA</td>\n",
       "      <td>THARCILA</td>\n",
       "      <td>VICE-PREFEITO</td>\n",
       "      <td>#NE</td>\n",
       "      <td>PODE</td>\n",
       "      <td>MG</td>\n",
       "      <td>CLÁUDIO</td>\n",
       "      <td>mudou de 2020 para 2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>21263391767</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>PAULO GOMES DOS SANTOS</td>\n",
       "      <td>PAULO GOMES</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PDT</td>\n",
       "      <td>SP</td>\n",
       "      <td>TAQUARAL</td>\n",
       "      <td>21263391767</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>PAULO GOMES DOS SANTOS</td>\n",
       "      <td>PAULO GOMES</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>REPUBLICANOS</td>\n",
       "      <td>SP</td>\n",
       "      <td>TAQUARAL</td>\n",
       "      <td>21263391767</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>PAULO GOMES DOS SANTOS</td>\n",
       "      <td>PAULO GOMES</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>MDB</td>\n",
       "      <td>SP</td>\n",
       "      <td>TAQUARAL</td>\n",
       "      <td>mudou de 2020 para 2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>181437430213</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>LORENA SANTOS OLIVEIRA</td>\n",
       "      <td>LORENA SANTOS</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>PMDB</td>\n",
       "      <td>MG</td>\n",
       "      <td>UBERLÂNDIA</td>\n",
       "      <td>181437430213</td>\n",
       "      <td>BRANCA</td>\n",
       "      <td>LORENA SANTOS OLIVEIRA</td>\n",
       "      <td>LORENA OLIVEIRA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>MDB</td>\n",
       "      <td>MG</td>\n",
       "      <td>UBERLÂNDIA</td>\n",
       "      <td>181437430213</td>\n",
       "      <td>PARDA</td>\n",
       "      <td>LORENA SANTOS OLIVEIRA</td>\n",
       "      <td>LORENA OLIVEIRA</td>\n",
       "      <td>VEREADOR</td>\n",
       "      <td>#NE</td>\n",
       "      <td>MDB</td>\n",
       "      <td>MG</td>\n",
       "      <td>UBERLÂNDIA</td>\n",
       "      <td>mudou de 2020 para 2024</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    NR_TITULO_ELEITORAL_CANDIDATO_2016 DS_COR_RACA_2016  \\\n",
       "1                           3919891074           BRANCA   \n",
       "8                          41324280850           BRANCA   \n",
       "9                         122129830213            PRETA   \n",
       "13                         21263391767            PARDA   \n",
       "17                        181437430213           BRANCA   \n",
       "\n",
       "             NM_CANDIDATO_2016 NM_URNA_CANDIDATO_2016  DS_CARGO_2016  \\\n",
       "1      CLÁUDIO LÚCIO RODRIGUES             CACÁ LÚCIO       VEREADOR   \n",
       "8    ELIONILDA JOSÉ DE SANTANA         IRMÃ ELIONILDA  VICE-PREFEITO   \n",
       "9   THARCILA CRISTINA DA SILVA               THARCILA       VEREADOR   \n",
       "13      PAULO GOMES DOS SANTOS            PAULO GOMES       VEREADOR   \n",
       "17      LORENA SANTOS OLIVEIRA          LORENA SANTOS       VEREADOR   \n",
       "\n",
       "   DS_SITUACAO_CANDIDATURA_2016 SG_PARTIDO_2016 SG_UF_2016  NM_UE_2016  \\\n",
       "1                          APTO             PRB         GO     CATALÃO   \n",
       "8                          APTO              PP         PE  ITAPISSUMA   \n",
       "9                          APTO             PSL         MG     CLÁUDIO   \n",
       "13                         APTO             PDT         SP    TAQUARAL   \n",
       "17                         APTO            PMDB         MG  UBERLÂNDIA   \n",
       "\n",
       "    NR_TITULO_ELEITORAL_CANDIDATO_2020 DS_COR_RACA_2020  \\\n",
       "1                           3919891074            PARDA   \n",
       "8                          41324280850            PARDA   \n",
       "9                         122129830213            PRETA   \n",
       "13                         21263391767           BRANCA   \n",
       "17                        181437430213           BRANCA   \n",
       "\n",
       "             NM_CANDIDATO_2020     NM_URNA_CANDIDATO_2020 DS_CARGO_2020  \\\n",
       "1      CLAUDIO LUCIO RODRIGUES           KAKA DOS ANIMAIS      VEREADOR   \n",
       "8    ELIONILDA JOSÉ DE SANTANA             IRMÃ ELIONILDA      VEREADOR   \n",
       "9   THARCILA CRISTINA DA SILVA  THARCILA DO SÃO FRANCISCO      VEREADOR   \n",
       "13      PAULO GOMES DOS SANTOS                PAULO GOMES      VEREADOR   \n",
       "17      LORENA SANTOS OLIVEIRA            LORENA OLIVEIRA      VEREADOR   \n",
       "\n",
       "   DS_SITUACAO_CANDIDATURA_2020 SG_PARTIDO_2020 SG_UF_2020  NM_UE_2020  \\\n",
       "1                          APTO    REPUBLICANOS         GO     CATALÃO   \n",
       "8                          APTO             MDB         PE  ITAPISSUMA   \n",
       "9                          APTO            PODE         MG     CLÁUDIO   \n",
       "13                         APTO    REPUBLICANOS         SP    TAQUARAL   \n",
       "17                         APTO             MDB         MG  UBERLÂNDIA   \n",
       "\n",
       "    NR_TITULO_ELEITORAL_CANDIDATO_2024 DS_COR_RACA_2024  \\\n",
       "1                           3919891074           BRANCA   \n",
       "8                          41324280850           BRANCA   \n",
       "9                         122129830213            PARDA   \n",
       "13                         21263391767            PARDA   \n",
       "17                        181437430213            PARDA   \n",
       "\n",
       "             NM_CANDIDATO_2024  NM_URNA_CANDIDATO_2024  DS_CARGO_2024  \\\n",
       "1      CLAUDIO LUCIO RODRIGUES  KAKA AMIGO DOS ANIMAIS       VEREADOR   \n",
       "8    ELIONILDA JOSE DE SANTANA          IRMÃ ELIONILDA       VEREADOR   \n",
       "9   THARCILA CRISTINA DA SILVA                THARCILA  VICE-PREFEITO   \n",
       "13      PAULO GOMES DOS SANTOS             PAULO GOMES       VEREADOR   \n",
       "17      LORENA SANTOS OLIVEIRA         LORENA OLIVEIRA       VEREADOR   \n",
       "\n",
       "   DS_SITUACAO_CANDIDATURA_2024 SG_PARTIDO_2024 SG_UF_2024  NM_UE_2024  \\\n",
       "1                           #NE            PSDB         GO     CATALÃO   \n",
       "8                           #NE             PSB         PE  ITAPISSUMA   \n",
       "9                           #NE            PODE         MG     CLÁUDIO   \n",
       "13                          #NE             MDB         SP    TAQUARAL   \n",
       "17                          #NE             MDB         MG  UBERLÂNDIA   \n",
       "\n",
       "                  Resultado  \n",
       "1   mudou de 2020 para 2024  \n",
       "8   mudou de 2020 para 2024  \n",
       "9   mudou de 2020 para 2024  \n",
       "13  mudou de 2020 para 2024  \n",
       "17  mudou de 2020 para 2024  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_filtrado.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "24f0902c-f473-4016-8b31-692c3b0ee813",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_filtrado.to_csv('data/cand_mudaram_declaracao.csv', decimal=\";\", index=False, encoding='latin-1')"
   ]
  }
 ],
 "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
}