Eleicoes.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "!pip install pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import os"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Coordenadas"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Sintetização dos arquivos de coordenadas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "estadoCoordenadasCSV = 'Coordenadas/estados_coord.csv'\n",
    "municipioCoordenadasCSV = 'Coordenadas/municipios_coord.csv'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "estadoCoord = pd.read_csv(estadoCoordenadasCSV)\n",
    "colunasParaRemover1 = ['latitude', 'longitude', 'regiao']\n",
    "estadoCoord = estadoCoord.drop(colunasParaRemover1, axis = 1)\n",
    "estadoCoord = estadoCoord.rename(columns={'nome': 'estado_nome'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "municipioCoord = pd.read_csv(municipioCoordenadasCSV)\n",
    "colunasParaRemover2 = ['codigo_ibge', 'siafi_id', 'ddd', 'fuso_horario']\n",
    "municipioCoord = municipioCoord.drop(colunasParaRemover2, axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>codigo_uf</th>\n",
       "      <th>uf</th>\n",
       "      <th>estado_nome</th>\n",
       "      <th>pais</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11</td>\n",
       "      <td>RO</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>Brasil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12</td>\n",
       "      <td>AC</td>\n",
       "      <td>Acre</td>\n",
       "      <td>Brasil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>13</td>\n",
       "      <td>AM</td>\n",
       "      <td>Amazonas</td>\n",
       "      <td>Brasil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>14</td>\n",
       "      <td>RR</td>\n",
       "      <td>Roraima</td>\n",
       "      <td>Brasil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>15</td>\n",
       "      <td>PA</td>\n",
       "      <td>Pará</td>\n",
       "      <td>Brasil</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   codigo_uf  uf estado_nome    pais\n",
       "0         11  RO    Rondônia  Brasil\n",
       "1         12  AC        Acre  Brasil\n",
       "2         13  AM    Amazonas  Brasil\n",
       "3         14  RR     Roraima  Brasil\n",
       "4         15  PA        Pará  Brasil"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "estadoCoord.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>nome</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>capital</th>\n",
       "      <th>codigo_uf</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Abadia de Goiás</td>\n",
       "      <td>-16.75730</td>\n",
       "      <td>-49.4412</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Abadia dos Dourados</td>\n",
       "      <td>-18.48310</td>\n",
       "      <td>-47.3916</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Abadiânia</td>\n",
       "      <td>-16.19700</td>\n",
       "      <td>-48.7057</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Abaeté</td>\n",
       "      <td>-19.15510</td>\n",
       "      <td>-45.4444</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Abaetetuba</td>\n",
       "      <td>-1.72183</td>\n",
       "      <td>-48.8788</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  nome  latitude  longitude  capital  codigo_uf\n",
       "0      Abadia de Goiás -16.75730   -49.4412        0         52\n",
       "1  Abadia dos Dourados -18.48310   -47.3916        0         31\n",
       "2            Abadiânia -16.19700   -48.7057        0         52\n",
       "3               Abaeté -19.15510   -45.4444        0         31\n",
       "4           Abaetetuba  -1.72183   -48.8788        0         15"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "municipioCoord.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "coordenadas = pd.merge(municipioCoord, estadoCoord, on='codigo_uf', how='inner')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>nome</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>capital</th>\n",
       "      <th>codigo_uf</th>\n",
       "      <th>uf</th>\n",
       "      <th>estado_nome</th>\n",
       "      <th>pais</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Abadia de Goiás</td>\n",
       "      <td>-16.7573</td>\n",
       "      <td>-49.4412</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>GO</td>\n",
       "      <td>Goiás</td>\n",
       "      <td>Brasil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Abadiânia</td>\n",
       "      <td>-16.1970</td>\n",
       "      <td>-48.7057</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>GO</td>\n",
       "      <td>Goiás</td>\n",
       "      <td>Brasil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Acreúna</td>\n",
       "      <td>-17.3960</td>\n",
       "      <td>-50.3749</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>GO</td>\n",
       "      <td>Goiás</td>\n",
       "      <td>Brasil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Adelândia</td>\n",
       "      <td>-16.4127</td>\n",
       "      <td>-50.1657</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>GO</td>\n",
       "      <td>Goiás</td>\n",
       "      <td>Brasil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Água Fria de Goiás</td>\n",
       "      <td>-14.9778</td>\n",
       "      <td>-47.7823</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>GO</td>\n",
       "      <td>Goiás</td>\n",
       "      <td>Brasil</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 nome  latitude  longitude  capital  codigo_uf  uf   \n",
       "0     Abadia de Goiás  -16.7573   -49.4412        0         52  GO  \\\n",
       "1           Abadiânia  -16.1970   -48.7057        0         52  GO   \n",
       "2             Acreúna  -17.3960   -50.3749        0         52  GO   \n",
       "3           Adelândia  -16.4127   -50.1657        0         52  GO   \n",
       "4  Água Fria de Goiás  -14.9778   -47.7823        0         52  GO   \n",
       "\n",
       "  estado_nome    pais  \n",
       "0       Goiás  Brasil  \n",
       "1       Goiás  Brasil  \n",
       "2       Goiás  Brasil  \n",
       "3       Goiás  Brasil  \n",
       "4       Goiás  Brasil  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "coordenadas.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "coordenadas.to_csv('Coordenadas/coordenadas.csv', index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Organização dos Boletins de Urna"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Redução de colunas para processamento no Tableau"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>CD_PLEITO</th>\n",
       "      <th>DT_PLEITO</th>\n",
       "      <th>NR_TURNO</th>\n",
       "      <th>CD_ELEICAO</th>\n",
       "      <th>DS_ELEICAO</th>\n",
       "      <th>...</th>\n",
       "      <th>CD_FLASHCARD_URNA_EFETIVADA</th>\n",
       "      <th>DT_CARGA_URNA_EFETIVADA</th>\n",
       "      <th>DS_CARGO_PERGUNTA_SECAO</th>\n",
       "      <th>DS_AGREGADAS</th>\n",
       "      <th>DT_ABERTURA</th>\n",
       "      <th>DT_ENCERRAMENTO</th>\n",
       "      <th>QT_ELEITORES_BIOMETRIA_NH</th>\n",
       "      <th>DT_EMISSAO_BU</th>\n",
       "      <th>NR_JUNTA_APURADORA</th>\n",
       "      <th>NR_TURMA_APURADORA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>31/10/2022</td>\n",
       "      <td>15:51:14</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>Eleição Ordinária</td>\n",
       "      <td>407</td>\n",
       "      <td>30/10/2022</td>\n",
       "      <td>2</td>\n",
       "      <td>545</td>\n",
       "      <td>Eleição Geral Federal 2022</td>\n",
       "      <td>...</td>\n",
       "      <td>1941091E</td>\n",
       "      <td>21/09/2022 10:11:00</td>\n",
       "      <td>1 - 1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>30/10/2022 08:00:01</td>\n",
       "      <td>30/10/2022 17:00:18</td>\n",
       "      <td>13</td>\n",
       "      <td>30/10/2022 17:01:50</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>31/10/2022</td>\n",
       "      <td>15:51:14</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>Eleição Ordinária</td>\n",
       "      <td>407</td>\n",
       "      <td>30/10/2022</td>\n",
       "      <td>2</td>\n",
       "      <td>545</td>\n",
       "      <td>Eleição Geral Federal 2022</td>\n",
       "      <td>...</td>\n",
       "      <td>1941091E</td>\n",
       "      <td>21/09/2022 10:11:00</td>\n",
       "      <td>1 - 1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>30/10/2022 08:00:01</td>\n",
       "      <td>30/10/2022 17:00:18</td>\n",
       "      <td>13</td>\n",
       "      <td>30/10/2022 17:01:50</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>31/10/2022</td>\n",
       "      <td>15:51:14</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>Eleição Ordinária</td>\n",
       "      <td>407</td>\n",
       "      <td>30/10/2022</td>\n",
       "      <td>2</td>\n",
       "      <td>545</td>\n",
       "      <td>Eleição Geral Federal 2022</td>\n",
       "      <td>...</td>\n",
       "      <td>1941091E</td>\n",
       "      <td>21/09/2022 10:11:00</td>\n",
       "      <td>1 - 1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>30/10/2022 08:00:01</td>\n",
       "      <td>30/10/2022 17:00:18</td>\n",
       "      <td>13</td>\n",
       "      <td>30/10/2022 17:01:50</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>31/10/2022</td>\n",
       "      <td>15:51:14</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>Eleição Ordinária</td>\n",
       "      <td>407</td>\n",
       "      <td>30/10/2022</td>\n",
       "      <td>2</td>\n",
       "      <td>545</td>\n",
       "      <td>Eleição Geral Federal 2022</td>\n",
       "      <td>...</td>\n",
       "      <td>1941091E</td>\n",
       "      <td>21/09/2022 10:11:00</td>\n",
       "      <td>1 - 1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>30/10/2022 08:00:01</td>\n",
       "      <td>30/10/2022 17:00:18</td>\n",
       "      <td>13</td>\n",
       "      <td>30/10/2022 17:01:50</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31/10/2022</td>\n",
       "      <td>15:51:14</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>Eleição Ordinária</td>\n",
       "      <td>407</td>\n",
       "      <td>30/10/2022</td>\n",
       "      <td>2</td>\n",
       "      <td>545</td>\n",
       "      <td>Eleição Geral Federal 2022</td>\n",
       "      <td>...</td>\n",
       "      <td>1941091E</td>\n",
       "      <td>21/09/2022 10:25:00</td>\n",
       "      <td>1 - 2</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>30/10/2022 08:00:01</td>\n",
       "      <td>30/10/2022 17:01:08</td>\n",
       "      <td>20</td>\n",
       "      <td>30/10/2022 17:02:36</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 45 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   DT_GERACAO HH_GERACAO  ANO_ELEICAO  CD_TIPO_ELEICAO    NM_TIPO_ELEICAO   \n",
       "0  31/10/2022   15:51:14         2022                0  Eleição Ordinária  \\\n",
       "1  31/10/2022   15:51:14         2022                0  Eleição Ordinária   \n",
       "2  31/10/2022   15:51:14         2022                0  Eleição Ordinária   \n",
       "3  31/10/2022   15:51:14         2022                0  Eleição Ordinária   \n",
       "4  31/10/2022   15:51:14         2022                0  Eleição Ordinária   \n",
       "\n",
       "   CD_PLEITO   DT_PLEITO  NR_TURNO  CD_ELEICAO                  DS_ELEICAO   \n",
       "0        407  30/10/2022         2         545  Eleição Geral Federal 2022  \\\n",
       "1        407  30/10/2022         2         545  Eleição Geral Federal 2022   \n",
       "2        407  30/10/2022         2         545  Eleição Geral Federal 2022   \n",
       "3        407  30/10/2022         2         545  Eleição Geral Federal 2022   \n",
       "4        407  30/10/2022         2         545  Eleição Geral Federal 2022   \n",
       "\n",
       "   ... CD_FLASHCARD_URNA_EFETIVADA  DT_CARGA_URNA_EFETIVADA   \n",
       "0  ...                    1941091E      21/09/2022 10:11:00  \\\n",
       "1  ...                    1941091E      21/09/2022 10:11:00   \n",
       "2  ...                    1941091E      21/09/2022 10:11:00   \n",
       "3  ...                    1941091E      21/09/2022 10:11:00   \n",
       "4  ...                    1941091E      21/09/2022 10:25:00   \n",
       "\n",
       "  DS_CARGO_PERGUNTA_SECAO  DS_AGREGADAS          DT_ABERTURA   \n",
       "0                   1 - 1        #NULO#  30/10/2022 08:00:01  \\\n",
       "1                   1 - 1        #NULO#  30/10/2022 08:00:01   \n",
       "2                   1 - 1        #NULO#  30/10/2022 08:00:01   \n",
       "3                   1 - 1        #NULO#  30/10/2022 08:00:01   \n",
       "4                   1 - 2        #NULO#  30/10/2022 08:00:01   \n",
       "\n",
       "       DT_ENCERRAMENTO  QT_ELEITORES_BIOMETRIA_NH        DT_EMISSAO_BU   \n",
       "0  30/10/2022 17:00:18                         13  30/10/2022 17:01:50  \\\n",
       "1  30/10/2022 17:00:18                         13  30/10/2022 17:01:50   \n",
       "2  30/10/2022 17:00:18                         13  30/10/2022 17:01:50   \n",
       "3  30/10/2022 17:00:18                         13  30/10/2022 17:01:50   \n",
       "4  30/10/2022 17:01:08                         20  30/10/2022 17:02:36   \n",
       "\n",
       "   NR_JUNTA_APURADORA NR_TURMA_APURADORA  \n",
       "0                  -1                 -1  \n",
       "1                  -1                 -1  \n",
       "2                  -1                 -1  \n",
       "3                  -1                 -1  \n",
       "4                  -1                 -1  \n",
       "\n",
       "[5 rows x 45 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bwebCSV = 'BUs/2022/bweb_2t_RN_311020221535.csv'\n",
    "bweb = pd.read_csv(bwebCSV, encoding='latin-1', sep=';')\n",
    "bweb.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "colunasParaRemover3 = ['DT_GERACAO', 'HH_GERACAO', 'CD_TIPO_ELEICAO', 'NM_TIPO_ELEICAO', 'CD_PLEITO', 'DT_PLEITO', \n",
    "                       'NR_TURNO', 'CD_ELEICAO', 'DS_ELEICAO', 'CD_FLASHCARD_URNA_EFETIVADA', 'DT_CARGA_URNA_EFETIVADA', \n",
    "                       'DS_CARGO_PERGUNTA_SECAO', 'DS_AGREGADAS', 'DT_ABERTURA', 'DT_ENCERRAMENTO', 'QT_ELEITORES_BIOMETRIA_NH', \n",
    "                       'DT_EMISSAO_BU', 'NR_JUNTA_APURADORA', 'NR_TURMA_APURADORA', 'CD_MUNICIPIO', 'NR_ZONA', 'NR_SECAO',\n",
    "                       'NR_LOCAL_VOTACAO', 'CD_CARGO_PERGUNTA', 'DS_CARGO_PERGUNTA', 'CD_TIPO_URNA', 'DS_TIPO_URNA', 'CD_TIPO_VOTAVEL',\n",
    "                       'NR_URNA_EFETIVADA', 'CD_CARGA_1_URNA_EFETIVADA', 'CD_CARGA_2_URNA_EFETIVADA']\n",
    "\n",
    "bweb = bweb.drop(colunasParaRemover3, axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>ANO_ELEICAO</th>\n",
       "      <th>SG_UF</th>\n",
       "      <th>NM_MUNICIPIO</th>\n",
       "      <th>NR_PARTIDO</th>\n",
       "      <th>SG_PARTIDO</th>\n",
       "      <th>NM_PARTIDO</th>\n",
       "      <th>DT_BU_RECEBIDO</th>\n",
       "      <th>QT_APTOS</th>\n",
       "      <th>QT_COMPARECIMENTO</th>\n",
       "      <th>QT_ABSTENCOES</th>\n",
       "      <th>DS_TIPO_VOTAVEL</th>\n",
       "      <th>NR_VOTAVEL</th>\n",
       "      <th>NM_VOTAVEL</th>\n",
       "      <th>QT_VOTOS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022</td>\n",
       "      <td>RN</td>\n",
       "      <td>NATAL</td>\n",
       "      <td>13</td>\n",
       "      <td>PT</td>\n",
       "      <td>Partido dos Trabalhadores</td>\n",
       "      <td>30/10/2022 17:14:27</td>\n",
       "      <td>329</td>\n",
       "      <td>260</td>\n",
       "      <td>69</td>\n",
       "      <td>Nominal</td>\n",
       "      <td>13</td>\n",
       "      <td>LULA</td>\n",
       "      <td>156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>RN</td>\n",
       "      <td>NATAL</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>30/10/2022 17:14:27</td>\n",
       "      <td>329</td>\n",
       "      <td>260</td>\n",
       "      <td>69</td>\n",
       "      <td>Branco</td>\n",
       "      <td>95</td>\n",
       "      <td>Branco</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022</td>\n",
       "      <td>RN</td>\n",
       "      <td>NATAL</td>\n",
       "      <td>22</td>\n",
       "      <td>PL</td>\n",
       "      <td>Partido Liberal</td>\n",
       "      <td>30/10/2022 17:14:27</td>\n",
       "      <td>329</td>\n",
       "      <td>260</td>\n",
       "      <td>69</td>\n",
       "      <td>Nominal</td>\n",
       "      <td>22</td>\n",
       "      <td>JAIR BOLSONARO</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022</td>\n",
       "      <td>RN</td>\n",
       "      <td>NATAL</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>30/10/2022 17:14:27</td>\n",
       "      <td>329</td>\n",
       "      <td>260</td>\n",
       "      <td>69</td>\n",
       "      <td>Nulo</td>\n",
       "      <td>96</td>\n",
       "      <td>Nulo</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022</td>\n",
       "      <td>RN</td>\n",
       "      <td>NATAL</td>\n",
       "      <td>-1</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>#NULO#</td>\n",
       "      <td>30/10/2022 17:15:26</td>\n",
       "      <td>336</td>\n",
       "      <td>283</td>\n",
       "      <td>53</td>\n",
       "      <td>Nulo</td>\n",
       "      <td>96</td>\n",
       "      <td>Nulo</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ANO_ELEICAO SG_UF NM_MUNICIPIO  NR_PARTIDO SG_PARTIDO   \n",
       "0         2022    RN        NATAL          13         PT  \\\n",
       "1         2022    RN        NATAL          -1     #NULO#   \n",
       "2         2022    RN        NATAL          22         PL   \n",
       "3         2022    RN        NATAL          -1     #NULO#   \n",
       "4         2022    RN        NATAL          -1     #NULO#   \n",
       "\n",
       "                  NM_PARTIDO       DT_BU_RECEBIDO  QT_APTOS   \n",
       "0  Partido dos Trabalhadores  30/10/2022 17:14:27       329  \\\n",
       "1                     #NULO#  30/10/2022 17:14:27       329   \n",
       "2            Partido Liberal  30/10/2022 17:14:27       329   \n",
       "3                     #NULO#  30/10/2022 17:14:27       329   \n",
       "4                     #NULO#  30/10/2022 17:15:26       336   \n",
       "\n",
       "   QT_COMPARECIMENTO  QT_ABSTENCOES DS_TIPO_VOTAVEL  NR_VOTAVEL   \n",
       "0                260             69         Nominal          13  \\\n",
       "1                260             69          Branco          95   \n",
       "2                260             69         Nominal          22   \n",
       "3                260             69            Nulo          96   \n",
       "4                283             53            Nulo          96   \n",
       "\n",
       "       NM_VOTAVEL  QT_VOTOS  \n",
       "0            LULA       156  \n",
       "1          Branco         1  \n",
       "2  JAIR BOLSONARO       100  \n",
       "3            Nulo         3  \n",
       "4            Nulo         4  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bweb.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "bweb.to_csv('BUs/2022/bweb.csv', index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Automatização"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "def processar_arquivos_csv(diretorio_entrada, diretorio_saida):\n",
    "    # Lista todos os arquivos no diretório de entrada que têm extensão .csv\n",
    "    arquivos_csv = [arquivo for arquivo in os.listdir(diretorio_entrada) if arquivo.endswith('.csv')]\n",
    "\n",
    "    # Loop através de cada arquivo CSV\n",
    "    for arquivo in arquivos_csv:\n",
    "        # Caminho completo para o arquivo de entrada\n",
    "        caminho_entrada = os.path.join(diretorio_entrada, arquivo)\n",
    "\n",
    "        # Carrega o arquivo CSV em um DataFrame pandas\n",
    "        df = pd.read_csv(caminho_entrada, encoding='latin-1', sep=';')\n",
    "\n",
    "        # Realiza as operações desejadas (por exemplo, remover colunas)\n",
    "        # Substitua este passo pelo seu processamento real\n",
    "        # Neste exemplo, estamos removendo uma coluna chamada 'Coluna_para_Remover'\n",
    "        if 'DT_GERACAO' in df.columns:\n",
    "            df = df.drop(colunasParaRemover3, axis = 1)\n",
    "\n",
    "        # Caminho completo para o arquivo de saída no diretório de saída\n",
    "        caminho_saida = os.path.join(diretorio_saida, arquivo)\n",
    "\n",
    "        # Salva o DataFrame resultante em um arquivo CSV no diretório de saída\n",
    "        df.to_csv(caminho_saida, index=False, encoding='latin-1')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "diretorio_entrada = 'BUs/2022/'\n",
    "diretorio_saida = 'BUsProc/2022/'\n",
    "\n",
    "processar_arquivos_csv(diretorio_entrada, diretorio_saida)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.11.5"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}