Live-TeoCalvo-30012021.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "based-crown",
   "metadata": {},
   "source": [
    "## Imersão Pandas - Teo Calvo\n",
    "\n",
    "Date: 30/01/2021\n",
    "\n",
    "https://github.com/TeoCalvo/imersao-pandas\n",
    "\n",
    "https://www.twitch.tv/teomewhy\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "adopted-guard",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T15:08:52.893958Z",
     "start_time": "2021-01-30T15:08:52.890959Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "democratic-course",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T15:08:54.678354Z",
     "start_time": "2021-01-30T15:08:54.657355Z"
    }
   },
   "outputs": [],
   "source": [
    "%config Completer.use_jedi = False "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "disciplinary-roommate",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Halisson\\anaconda3\\envs\\zero-ao-ds\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3146: DtypeWarning: Columns (8) have mixed types.Specify dtype option on import or set low_memory=False.\n",
      "  has_raised = await self.run_ast_nodes(code_ast.body, cell_name,\n"
     ]
    }
   ],
   "source": [
    "# cada linha desse dataframe é um candidato em um turno de determinado ano de eleição\n",
    "\n",
    "df_votacao = pd.read_csv('dados/originais/dados-teo/votacao_agg_estado.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "about-mistake",
   "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>descricao_eleicao</th>\n",
       "      <th>numero_turno</th>\n",
       "      <th>nome_partido</th>\n",
       "      <th>numero_partido</th>\n",
       "      <th>sigla_partido</th>\n",
       "      <th>descricao_cargo</th>\n",
       "      <th>descricao_situacao_candidatura</th>\n",
       "      <th>descricao_situacao_candidatura_superior</th>\n",
       "      <th>nome</th>\n",
       "      <th>...</th>\n",
       "      <th>total_votos_to</th>\n",
       "      <th>total_votos_pa</th>\n",
       "      <th>total_votos_ms</th>\n",
       "      <th>total_votos_pi</th>\n",
       "      <th>total_votos_ma</th>\n",
       "      <th>total_votos_df</th>\n",
       "      <th>total_votos_es</th>\n",
       "      <th>total_votos_rr</th>\n",
       "      <th>total_votos_sc</th>\n",
       "      <th>total_votos</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO DEMOCRATICO TRABALHISTA</td>\n",
       "      <td>12</td>\n",
       "      <td>PDT</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>AMAZONINO ARMANDO MENDES</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>577397</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO DO MOVIMENTO DEMOCRATICO BRASILEIRO</td>\n",
       "      <td>15</td>\n",
       "      <td>PMDB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>CARLOS EDUARDO DE SOUZA BRAGA</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>377680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO DOS TRABALHADORES</td>\n",
       "      <td>13</td>\n",
       "      <td>PT</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>JOSE RICARDO WENDLING</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>181257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO HUMANISTA DA SOLIDARIEDADE</td>\n",
       "      <td>31</td>\n",
       "      <td>PHS</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>MAURICIO WILKER DE AZEVEDO BARRETO</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>22623</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO PATRIA LIVRE</td>\n",
       "      <td>54</td>\n",
       "      <td>PPL</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>JADELVONE NOGUEIRA DELTRUDES</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3362</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   ano_eleicao                  descricao_eleicao  numero_turno  \\\n",
       "0         2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "1         2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "2         2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "3         2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "4         2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "\n",
       "                                  nome_partido  numero_partido sigla_partido  \\\n",
       "0              PARTIDO DEMOCRATICO TRABALHISTA              12           PDT   \n",
       "1  PARTIDO DO MOVIMENTO DEMOCRATICO BRASILEIRO              15          PMDB   \n",
       "2                    PARTIDO DOS TRABALHADORES              13            PT   \n",
       "3           PARTIDO HUMANISTA DA SOLIDARIEDADE              31           PHS   \n",
       "4                         PARTIDO PATRIA LIVRE              54           PPL   \n",
       "\n",
       "  descricao_cargo descricao_situacao_candidatura  \\\n",
       "0      GOVERNADOR                       DEFERIDO   \n",
       "1      GOVERNADOR                       DEFERIDO   \n",
       "2      GOVERNADOR                       DEFERIDO   \n",
       "3      GOVERNADOR                       DEFERIDO   \n",
       "4      GOVERNADOR                       DEFERIDO   \n",
       "\n",
       "  descricao_situacao_candidatura_superior                                nome  \\\n",
       "0                                    APTO            AMAZONINO ARMANDO MENDES   \n",
       "1                                    APTO       CARLOS EDUARDO DE SOUZA BRAGA   \n",
       "2                                    APTO               JOSE RICARDO WENDLING   \n",
       "3                                    APTO  MAURICIO WILKER DE AZEVEDO BARRETO   \n",
       "4                                    APTO        JADELVONE NOGUEIRA DELTRUDES   \n",
       "\n",
       "   ...  total_votos_to total_votos_pa  total_votos_ms  total_votos_pi  \\\n",
       "0  ...               0              0               0               0   \n",
       "1  ...               0              0               0               0   \n",
       "2  ...               0              0               0               0   \n",
       "3  ...               0              0               0               0   \n",
       "4  ...               0              0               0               0   \n",
       "\n",
       "   total_votos_ma  total_votos_df  total_votos_es  total_votos_rr  \\\n",
       "0               0               0               0               0   \n",
       "1               0               0               0               0   \n",
       "2               0               0               0               0   \n",
       "3               0               0               0               0   \n",
       "4               0               0               0               0   \n",
       "\n",
       "   total_votos_sc  total_votos  \n",
       "0               0       577397  \n",
       "1               0       377680  \n",
       "2               0       181257  \n",
       "3               0        22623  \n",
       "4               0         3362  \n",
       "\n",
       "[5 rows x 43 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_votacao.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "collective-fever",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(511105, 43)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_votacao.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "mediterranean-polymer",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['ano_eleicao', 'descricao_eleicao', 'numero_turno', 'nome_partido',\n",
       "       'numero_partido', 'sigla_partido', 'descricao_cargo',\n",
       "       'descricao_situacao_candidatura',\n",
       "       'descricao_situacao_candidatura_superior', 'nome', 'nome_social',\n",
       "       'nome_urna', 'numero_sequencial', 'numero_urna', 'total_votos_ac',\n",
       "       'total_votos_al', 'total_votos_am', 'total_votos_ap', 'total_votos_ba',\n",
       "       'total_votos_rj', 'total_votos_sp', 'total_votos_ce', 'total_votos_ro',\n",
       "       'total_votos_se', 'total_votos_pr', 'total_votos_mg', 'total_votos_mt',\n",
       "       'total_votos_pe', 'total_votos_pb', 'total_votos_zz', 'total_votos_go',\n",
       "       'total_votos_rs', 'total_votos_rn', 'total_votos_to', 'total_votos_pa',\n",
       "       'total_votos_ms', 'total_votos_pi', 'total_votos_ma', 'total_votos_df',\n",
       "       'total_votos_es', 'total_votos_rr', 'total_votos_sc', 'total_votos'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_votacao.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "atomic-exhibition",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T15:08:42.264692Z",
     "start_time": "2021-01-30T15:08:41.989692Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 511105 entries, 0 to 511104\n",
      "Data columns (total 43 columns):\n",
      " #   Column                                   Non-Null Count   Dtype  \n",
      "---  ------                                   --------------   -----  \n",
      " 0   ano_eleicao                              511105 non-null  int64  \n",
      " 1   descricao_eleicao                        511105 non-null  object \n",
      " 2   numero_turno                             511105 non-null  int64  \n",
      " 3   nome_partido                             511105 non-null  object \n",
      " 4   numero_partido                           511105 non-null  int64  \n",
      " 5   sigla_partido                            511105 non-null  object \n",
      " 6   descricao_cargo                          511105 non-null  object \n",
      " 7   descricao_situacao_candidatura           511105 non-null  object \n",
      " 8   descricao_situacao_candidatura_superior  484655 non-null  object \n",
      " 9   nome                                     511105 non-null  object \n",
      " 10  nome_social                              0 non-null       float64\n",
      " 11  nome_urna                                511095 non-null  object \n",
      " 12  numero_sequencial                        511105 non-null  int64  \n",
      " 13  numero_urna                              511105 non-null  int64  \n",
      " 14  total_votos_ac                           511105 non-null  int64  \n",
      " 15  total_votos_al                           511105 non-null  int64  \n",
      " 16  total_votos_am                           511105 non-null  int64  \n",
      " 17  total_votos_ap                           511105 non-null  int64  \n",
      " 18  total_votos_ba                           511105 non-null  int64  \n",
      " 19  total_votos_rj                           511105 non-null  int64  \n",
      " 20  total_votos_sp                           511105 non-null  int64  \n",
      " 21  total_votos_ce                           511105 non-null  int64  \n",
      " 22  total_votos_ro                           511105 non-null  int64  \n",
      " 23  total_votos_se                           511105 non-null  int64  \n",
      " 24  total_votos_pr                           511105 non-null  int64  \n",
      " 25  total_votos_mg                           511105 non-null  int64  \n",
      " 26  total_votos_mt                           511105 non-null  int64  \n",
      " 27  total_votos_pe                           511105 non-null  int64  \n",
      " 28  total_votos_pb                           511105 non-null  int64  \n",
      " 29  total_votos_zz                           511105 non-null  int64  \n",
      " 30  total_votos_go                           511105 non-null  int64  \n",
      " 31  total_votos_rs                           511105 non-null  int64  \n",
      " 32  total_votos_rn                           511105 non-null  int64  \n",
      " 33  total_votos_to                           511105 non-null  int64  \n",
      " 34  total_votos_pa                           511105 non-null  int64  \n",
      " 35  total_votos_ms                           511105 non-null  int64  \n",
      " 36  total_votos_pi                           511105 non-null  int64  \n",
      " 37  total_votos_ma                           511105 non-null  int64  \n",
      " 38  total_votos_df                           511105 non-null  int64  \n",
      " 39  total_votos_es                           511105 non-null  int64  \n",
      " 40  total_votos_rr                           511105 non-null  int64  \n",
      " 41  total_votos_sc                           511105 non-null  int64  \n",
      " 42  total_votos                              511105 non-null  int64  \n",
      "dtypes: float64(1), int64(34), object(8)\n",
      "memory usage: 167.7+ MB\n"
     ]
    }
   ],
   "source": [
    "df_votacao.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "seasonal-connecticut",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ano_eleicao                                     0\n",
      "descricao_eleicao                               0\n",
      "numero_turno                                    0\n",
      "nome_partido                                    0\n",
      "numero_partido                                  0\n",
      "sigla_partido                                   0\n",
      "descricao_cargo                                 0\n",
      "descricao_situacao_candidatura                  0\n",
      "descricao_situacao_candidatura_superior     26450\n",
      "nome                                            0\n",
      "nome_social                                511105\n",
      "nome_urna                                      10\n",
      "numero_sequencial                               0\n",
      "numero_urna                                     0\n",
      "total_votos_ac                                  0\n",
      "total_votos_al                                  0\n",
      "total_votos_am                                  0\n",
      "total_votos_ap                                  0\n",
      "total_votos_ba                                  0\n",
      "total_votos_rj                                  0\n",
      "total_votos_sp                                  0\n",
      "total_votos_ce                                  0\n",
      "total_votos_ro                                  0\n",
      "total_votos_se                                  0\n",
      "total_votos_pr                                  0\n",
      "total_votos_mg                                  0\n",
      "total_votos_mt                                  0\n",
      "total_votos_pe                                  0\n",
      "total_votos_pb                                  0\n",
      "total_votos_zz                                  0\n",
      "total_votos_go                                  0\n",
      "total_votos_rs                                  0\n",
      "total_votos_rn                                  0\n",
      "total_votos_to                                  0\n",
      "total_votos_pa                                  0\n",
      "total_votos_ms                                  0\n",
      "total_votos_pi                                  0\n",
      "total_votos_ma                                  0\n",
      "total_votos_df                                  0\n",
      "total_votos_es                                  0\n",
      "total_votos_rr                                  0\n",
      "total_votos_sc                                  0\n",
      "total_votos                                     0\n",
      "dtype: int64\n",
      "\n",
      "ano_eleicao                                     0\n",
      "descricao_eleicao                               0\n",
      "numero_turno                                    0\n",
      "nome_partido                                    0\n",
      "numero_partido                                  0\n",
      "sigla_partido                                   0\n",
      "descricao_cargo                                 0\n",
      "descricao_situacao_candidatura                  0\n",
      "descricao_situacao_candidatura_superior     26450\n",
      "nome                                            0\n",
      "nome_social                                511105\n",
      "nome_urna                                      10\n",
      "numero_sequencial                               0\n",
      "numero_urna                                     0\n",
      "total_votos_ac                                  0\n",
      "total_votos_al                                  0\n",
      "total_votos_am                                  0\n",
      "total_votos_ap                                  0\n",
      "total_votos_ba                                  0\n",
      "total_votos_rj                                  0\n",
      "total_votos_sp                                  0\n",
      "total_votos_ce                                  0\n",
      "total_votos_ro                                  0\n",
      "total_votos_se                                  0\n",
      "total_votos_pr                                  0\n",
      "total_votos_mg                                  0\n",
      "total_votos_mt                                  0\n",
      "total_votos_pe                                  0\n",
      "total_votos_pb                                  0\n",
      "total_votos_zz                                  0\n",
      "total_votos_go                                  0\n",
      "total_votos_rs                                  0\n",
      "total_votos_rn                                  0\n",
      "total_votos_to                                  0\n",
      "total_votos_pa                                  0\n",
      "total_votos_ms                                  0\n",
      "total_votos_pi                                  0\n",
      "total_votos_ma                                  0\n",
      "total_votos_df                                  0\n",
      "total_votos_es                                  0\n",
      "total_votos_rr                                  0\n",
      "total_votos_sc                                  0\n",
      "total_votos                                     0\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# verificando nulos no dataframe\n",
    "print(df_votacao.isnull().sum(), end='\\n\\n')\n",
    "print(df_votacao.isna().sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "ordinary-conspiracy",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T15:09:21.141222Z",
     "start_time": "2021-01-30T15:09:19.186219Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Wall time: 1.86 s\n"
     ]
    },
    {
     "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>descricao_eleicao</th>\n",
       "      <th>numero_turno</th>\n",
       "      <th>nome_partido</th>\n",
       "      <th>numero_partido</th>\n",
       "      <th>sigla_partido</th>\n",
       "      <th>descricao_cargo</th>\n",
       "      <th>descricao_situacao_candidatura</th>\n",
       "      <th>descricao_situacao_candidatura_superior</th>\n",
       "      <th>nome</th>\n",
       "      <th>...</th>\n",
       "      <th>total_votos_to</th>\n",
       "      <th>total_votos_pa</th>\n",
       "      <th>total_votos_ms</th>\n",
       "      <th>total_votos_pi</th>\n",
       "      <th>total_votos_ma</th>\n",
       "      <th>total_votos_df</th>\n",
       "      <th>total_votos_es</th>\n",
       "      <th>total_votos_rr</th>\n",
       "      <th>total_votos_sc</th>\n",
       "      <th>total_votos</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2014.0</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1.0</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40.0</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>MARCELO AUGUSTO DA EIRA CORREA</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18877.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16720</th>\n",
       "      <td>2014.0</td>\n",
       "      <td>ELEICOES GERAIS 2014</td>\n",
       "      <td>1.0</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40.0</td>\n",
       "      <td>PSB</td>\n",
       "      <td>DEPUTADO DISTRITAL</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>ADECIO SARTORI</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4194.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4194.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16721</th>\n",
       "      <td>2014.0</td>\n",
       "      <td>ELEICOES GERAIS 2014</td>\n",
       "      <td>1.0</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40.0</td>\n",
       "      <td>PSB</td>\n",
       "      <td>DEPUTADO DISTRITAL</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>ALESSANDRO FABRICIO CLEMENTE PAIVA</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6086.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6086.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16722</th>\n",
       "      <td>2014.0</td>\n",
       "      <td>ELEICOES GERAIS 2014</td>\n",
       "      <td>1.0</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40.0</td>\n",
       "      <td>PSB</td>\n",
       "      <td>DEPUTADO DISTRITAL</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>ANDRE DUTRA SILVA MAGALHAES</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1608.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16723</th>\n",
       "      <td>2014.0</td>\n",
       "      <td>ELEICOES GERAIS 2014</td>\n",
       "      <td>1.0</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40.0</td>\n",
       "      <td>PSB</td>\n",
       "      <td>DEPUTADO DISTRITAL</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>ANTONIO SARAZATE LUZ DA SILVA</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>592.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>592.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>505250</th>\n",
       "      <td>2018.0</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>1.0</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40.0</td>\n",
       "      <td>PSB</td>\n",
       "      <td>SENADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WILSON NUNES MARTINS</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>570065.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>570065.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511101</th>\n",
       "      <td>2018.0</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2.0</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40.0</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANTONIO CARLOS VALADARES FILHO</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>370161.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511102</th>\n",
       "      <td>2018.0</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2.0</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40.0</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JOAO ALBERTO RODRIGUES CAPIBERIBE</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>174540.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511103</th>\n",
       "      <td>2018.0</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2.0</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40.0</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MARCIO LUIZ FRANCA GOMES</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20497480.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511104</th>\n",
       "      <td>2018.0</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2.0</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40.0</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RODRIGO SOBRAL ROLLEMBERG</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>451329.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>451329.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>27278 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ano_eleicao                  descricao_eleicao  numero_turno  \\\n",
       "7            2014.0  ELEICAO SUPLEMENTAR GOVERNADOR AM           1.0   \n",
       "16720        2014.0               ELEICOES GERAIS 2014           1.0   \n",
       "16721        2014.0               ELEICOES GERAIS 2014           1.0   \n",
       "16722        2014.0               ELEICOES GERAIS 2014           1.0   \n",
       "16723        2014.0               ELEICOES GERAIS 2014           1.0   \n",
       "...             ...                                ...           ...   \n",
       "505250       2018.0     ELEICOES GERAIS ESTADUAIS 2018           1.0   \n",
       "511101       2018.0     ELEICOES GERAIS ESTADUAIS 2018           2.0   \n",
       "511102       2018.0     ELEICOES GERAIS ESTADUAIS 2018           2.0   \n",
       "511103       2018.0     ELEICOES GERAIS ESTADUAIS 2018           2.0   \n",
       "511104       2018.0     ELEICOES GERAIS ESTADUAIS 2018           2.0   \n",
       "\n",
       "                         nome_partido  numero_partido sigla_partido  \\\n",
       "7       PARTIDO SOCIALISTA BRASILEIRO            40.0           PSB   \n",
       "16720   PARTIDO SOCIALISTA BRASILEIRO            40.0           PSB   \n",
       "16721   PARTIDO SOCIALISTA BRASILEIRO            40.0           PSB   \n",
       "16722   PARTIDO SOCIALISTA BRASILEIRO            40.0           PSB   \n",
       "16723   PARTIDO SOCIALISTA BRASILEIRO            40.0           PSB   \n",
       "...                               ...             ...           ...   \n",
       "505250  PARTIDO SOCIALISTA BRASILEIRO            40.0           PSB   \n",
       "511101  PARTIDO SOCIALISTA BRASILEIRO            40.0           PSB   \n",
       "511102  PARTIDO SOCIALISTA BRASILEIRO            40.0           PSB   \n",
       "511103  PARTIDO SOCIALISTA BRASILEIRO            40.0           PSB   \n",
       "511104  PARTIDO SOCIALISTA BRASILEIRO            40.0           PSB   \n",
       "\n",
       "           descricao_cargo descricao_situacao_candidatura  \\\n",
       "7               GOVERNADOR                       DEFERIDO   \n",
       "16720   DEPUTADO DISTRITAL                       DEFERIDO   \n",
       "16721   DEPUTADO DISTRITAL                       DEFERIDO   \n",
       "16722   DEPUTADO DISTRITAL                       DEFERIDO   \n",
       "16723   DEPUTADO DISTRITAL                       DEFERIDO   \n",
       "...                    ...                            ...   \n",
       "505250             SENADOR                           APTO   \n",
       "511101          GOVERNADOR                           APTO   \n",
       "511102          GOVERNADOR                           APTO   \n",
       "511103          GOVERNADOR                           APTO   \n",
       "511104          GOVERNADOR                           APTO   \n",
       "\n",
       "       descricao_situacao_candidatura_superior  \\\n",
       "7                                         APTO   \n",
       "16720                                     APTO   \n",
       "16721                                     APTO   \n",
       "16722                                     APTO   \n",
       "16723                                     APTO   \n",
       "...                                        ...   \n",
       "505250                                     NaN   \n",
       "511101                                     NaN   \n",
       "511102                                     NaN   \n",
       "511103                                     NaN   \n",
       "511104                                     NaN   \n",
       "\n",
       "                                      nome  ...  total_votos_to  \\\n",
       "7           MARCELO AUGUSTO DA EIRA CORREA  ...             0.0   \n",
       "16720                       ADECIO SARTORI  ...             0.0   \n",
       "16721   ALESSANDRO FABRICIO CLEMENTE PAIVA  ...             0.0   \n",
       "16722          ANDRE DUTRA SILVA MAGALHAES  ...             0.0   \n",
       "16723        ANTONIO SARAZATE LUZ DA SILVA  ...             0.0   \n",
       "...                                    ...  ...             ...   \n",
       "505250                WILSON NUNES MARTINS  ...             0.0   \n",
       "511101      ANTONIO CARLOS VALADARES FILHO  ...             0.0   \n",
       "511102   JOAO ALBERTO RODRIGUES CAPIBERIBE  ...             0.0   \n",
       "511103            MARCIO LUIZ FRANCA GOMES  ...             0.0   \n",
       "511104           RODRIGO SOBRAL ROLLEMBERG  ...             0.0   \n",
       "\n",
       "       total_votos_pa  total_votos_ms  total_votos_pi  total_votos_ma  \\\n",
       "7                 0.0             0.0             0.0             0.0   \n",
       "16720             0.0             0.0             0.0             0.0   \n",
       "16721             0.0             0.0             0.0             0.0   \n",
       "16722             0.0             0.0             0.0             0.0   \n",
       "16723             0.0             0.0             0.0             0.0   \n",
       "...               ...             ...             ...             ...   \n",
       "505250            0.0             0.0        570065.0             0.0   \n",
       "511101            0.0             0.0             0.0             0.0   \n",
       "511102            0.0             0.0             0.0             0.0   \n",
       "511103            0.0             0.0             0.0             0.0   \n",
       "511104            0.0             0.0             0.0             0.0   \n",
       "\n",
       "        total_votos_df  total_votos_es  total_votos_rr  total_votos_sc  \\\n",
       "7                  0.0             0.0             0.0             0.0   \n",
       "16720           4194.0             0.0             0.0             0.0   \n",
       "16721           6086.0             0.0             0.0             0.0   \n",
       "16722           1608.0             0.0             0.0             0.0   \n",
       "16723            592.0             0.0             0.0             0.0   \n",
       "...                ...             ...             ...             ...   \n",
       "505250             0.0             0.0             0.0             0.0   \n",
       "511101             0.0             0.0             0.0             0.0   \n",
       "511102             0.0             0.0             0.0             0.0   \n",
       "511103             0.0             0.0             0.0             0.0   \n",
       "511104        451329.0             0.0             0.0             0.0   \n",
       "\n",
       "        total_votos  \n",
       "7           18877.0  \n",
       "16720        4194.0  \n",
       "16721        6086.0  \n",
       "16722        1608.0  \n",
       "16723         592.0  \n",
       "...             ...  \n",
       "505250     570065.0  \n",
       "511101     370161.0  \n",
       "511102     174540.0  \n",
       "511103   20497480.0  \n",
       "511104     451329.0  \n",
       "\n",
       "[27278 rows x 43 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%time\n",
    "df_votacao.where(df_votacao['sigla_partido'] == 'PSB').dropna(how='all')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "id": "handy-legislation",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:50:36.167612Z",
     "start_time": "2021-01-30T20:50:36.018611Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Wall time: 88 ms\n"
     ]
    },
    {
     "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>descricao_eleicao</th>\n",
       "      <th>numero_turno</th>\n",
       "      <th>nome_partido</th>\n",
       "      <th>numero_partido</th>\n",
       "      <th>sigla_partido</th>\n",
       "      <th>descricao_cargo</th>\n",
       "      <th>descricao_situacao_candidatura</th>\n",
       "      <th>descricao_situacao_candidatura_superior</th>\n",
       "      <th>nome</th>\n",
       "      <th>...</th>\n",
       "      <th>total_votos_to</th>\n",
       "      <th>total_votos_pa</th>\n",
       "      <th>total_votos_ms</th>\n",
       "      <th>total_votos_pi</th>\n",
       "      <th>total_votos_ma</th>\n",
       "      <th>total_votos_df</th>\n",
       "      <th>total_votos_es</th>\n",
       "      <th>total_votos_rr</th>\n",
       "      <th>total_votos_sc</th>\n",
       "      <th>total_votos</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>MARCELO AUGUSTO DA EIRA CORREA</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16720</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICOES GERAIS 2014</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>DEPUTADO DISTRITAL</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>ADECIO SARTORI</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4194</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16721</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICOES GERAIS 2014</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>DEPUTADO DISTRITAL</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>ALESSANDRO FABRICIO CLEMENTE PAIVA</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6086</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16722</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICOES GERAIS 2014</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>DEPUTADO DISTRITAL</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>ANDRE DUTRA SILVA MAGALHAES</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1608</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16723</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICOES GERAIS 2014</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>DEPUTADO DISTRITAL</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>ANTONIO SARAZATE LUZ DA SILVA</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>592</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>505250</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>SENADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WILSON NUNES MARTINS</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>570065</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>570065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511101</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANTONIO CARLOS VALADARES FILHO</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>370161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511102</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JOAO ALBERTO RODRIGUES CAPIBERIBE</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>174540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511103</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MARCIO LUIZ FRANCA GOMES</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20497480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511104</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RODRIGO SOBRAL ROLLEMBERG</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>451329</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>451329</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>27278 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ano_eleicao                  descricao_eleicao  numero_turno  \\\n",
       "7              2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "16720          2014               ELEICOES GERAIS 2014             1   \n",
       "16721          2014               ELEICOES GERAIS 2014             1   \n",
       "16722          2014               ELEICOES GERAIS 2014             1   \n",
       "16723          2014               ELEICOES GERAIS 2014             1   \n",
       "...             ...                                ...           ...   \n",
       "505250         2018     ELEICOES GERAIS ESTADUAIS 2018             1   \n",
       "511101         2018     ELEICOES GERAIS ESTADUAIS 2018             2   \n",
       "511102         2018     ELEICOES GERAIS ESTADUAIS 2018             2   \n",
       "511103         2018     ELEICOES GERAIS ESTADUAIS 2018             2   \n",
       "511104         2018     ELEICOES GERAIS ESTADUAIS 2018             2   \n",
       "\n",
       "                         nome_partido  numero_partido sigla_partido  \\\n",
       "7       PARTIDO SOCIALISTA BRASILEIRO              40           PSB   \n",
       "16720   PARTIDO SOCIALISTA BRASILEIRO              40           PSB   \n",
       "16721   PARTIDO SOCIALISTA BRASILEIRO              40           PSB   \n",
       "16722   PARTIDO SOCIALISTA BRASILEIRO              40           PSB   \n",
       "16723   PARTIDO SOCIALISTA BRASILEIRO              40           PSB   \n",
       "...                               ...             ...           ...   \n",
       "505250  PARTIDO SOCIALISTA BRASILEIRO              40           PSB   \n",
       "511101  PARTIDO SOCIALISTA BRASILEIRO              40           PSB   \n",
       "511102  PARTIDO SOCIALISTA BRASILEIRO              40           PSB   \n",
       "511103  PARTIDO SOCIALISTA BRASILEIRO              40           PSB   \n",
       "511104  PARTIDO SOCIALISTA BRASILEIRO              40           PSB   \n",
       "\n",
       "           descricao_cargo descricao_situacao_candidatura  \\\n",
       "7               GOVERNADOR                       DEFERIDO   \n",
       "16720   DEPUTADO DISTRITAL                       DEFERIDO   \n",
       "16721   DEPUTADO DISTRITAL                       DEFERIDO   \n",
       "16722   DEPUTADO DISTRITAL                       DEFERIDO   \n",
       "16723   DEPUTADO DISTRITAL                       DEFERIDO   \n",
       "...                    ...                            ...   \n",
       "505250             SENADOR                           APTO   \n",
       "511101          GOVERNADOR                           APTO   \n",
       "511102          GOVERNADOR                           APTO   \n",
       "511103          GOVERNADOR                           APTO   \n",
       "511104          GOVERNADOR                           APTO   \n",
       "\n",
       "       descricao_situacao_candidatura_superior  \\\n",
       "7                                         APTO   \n",
       "16720                                     APTO   \n",
       "16721                                     APTO   \n",
       "16722                                     APTO   \n",
       "16723                                     APTO   \n",
       "...                                        ...   \n",
       "505250                                     NaN   \n",
       "511101                                     NaN   \n",
       "511102                                     NaN   \n",
       "511103                                     NaN   \n",
       "511104                                     NaN   \n",
       "\n",
       "                                      nome  ...  total_votos_to  \\\n",
       "7           MARCELO AUGUSTO DA EIRA CORREA  ...               0   \n",
       "16720                       ADECIO SARTORI  ...               0   \n",
       "16721   ALESSANDRO FABRICIO CLEMENTE PAIVA  ...               0   \n",
       "16722          ANDRE DUTRA SILVA MAGALHAES  ...               0   \n",
       "16723        ANTONIO SARAZATE LUZ DA SILVA  ...               0   \n",
       "...                                    ...  ...             ...   \n",
       "505250                WILSON NUNES MARTINS  ...               0   \n",
       "511101      ANTONIO CARLOS VALADARES FILHO  ...               0   \n",
       "511102   JOAO ALBERTO RODRIGUES CAPIBERIBE  ...               0   \n",
       "511103            MARCIO LUIZ FRANCA GOMES  ...               0   \n",
       "511104           RODRIGO SOBRAL ROLLEMBERG  ...               0   \n",
       "\n",
       "       total_votos_pa  total_votos_ms  total_votos_pi  total_votos_ma  \\\n",
       "7                   0               0               0               0   \n",
       "16720               0               0               0               0   \n",
       "16721               0               0               0               0   \n",
       "16722               0               0               0               0   \n",
       "16723               0               0               0               0   \n",
       "...               ...             ...             ...             ...   \n",
       "505250              0               0          570065               0   \n",
       "511101              0               0               0               0   \n",
       "511102              0               0               0               0   \n",
       "511103              0               0               0               0   \n",
       "511104              0               0               0               0   \n",
       "\n",
       "        total_votos_df  total_votos_es  total_votos_rr  total_votos_sc  \\\n",
       "7                    0               0               0               0   \n",
       "16720             4194               0               0               0   \n",
       "16721             6086               0               0               0   \n",
       "16722             1608               0               0               0   \n",
       "16723              592               0               0               0   \n",
       "...                ...             ...             ...             ...   \n",
       "505250               0               0               0               0   \n",
       "511101               0               0               0               0   \n",
       "511102               0               0               0               0   \n",
       "511103               0               0               0               0   \n",
       "511104          451329               0               0               0   \n",
       "\n",
       "        total_votos  \n",
       "7             18877  \n",
       "16720          4194  \n",
       "16721          6086  \n",
       "16722          1608  \n",
       "16723           592  \n",
       "...             ...  \n",
       "505250       570065  \n",
       "511101       370161  \n",
       "511102       174540  \n",
       "511103     20497480  \n",
       "511104       451329  \n",
       "\n",
       "[27278 rows x 43 columns]"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%time\n",
    "df_votacao.loc[df_votacao['sigla_partido'] == 'PSB']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "continued-scoop",
   "metadata": {},
   "source": [
    "#### Quanto cada partido teve de votos totais em cada ano de eleicao em cada turno?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "id": "sexual-deputy",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:50:40.744996Z",
     "start_time": "2021-01-30T20:50:40.604998Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ano_eleicao  numero_turno  sigla_partido\n",
      "2014         1             DEM              13644709\n",
      "                           PC DO B           7110362\n",
      "                           PCB                270270\n",
      "                           PCO                 54507\n",
      "                           PDT              13036163\n",
      "Name: total_votos, dtype: int64\n",
      "102239868\n"
     ]
    }
   ],
   "source": [
    "df_group = df_votacao.groupby(['ano_eleicao', 'numero_turno', 'sigla_partido'])['total_votos'].sum()\n",
    "print(df_group.head())\n",
    "print(df_group.loc[2014][1]['PT'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "id": "independent-arbitration",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:51:01.038155Z",
     "start_time": "2021-01-30T20:51:01.016159Z"
    }
   },
   "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>index</th>\n",
       "      <th>ano_eleicao</th>\n",
       "      <th>numero_turno</th>\n",
       "      <th>sigla_partido</th>\n",
       "      <th>total_votos</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>2014</td>\n",
       "      <td>1</td>\n",
       "      <td>PSDB</td>\n",
       "      <td>103432738</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>2014</td>\n",
       "      <td>1</td>\n",
       "      <td>PT</td>\n",
       "      <td>102239868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>42</td>\n",
       "      <td>2014</td>\n",
       "      <td>2</td>\n",
       "      <td>PT</td>\n",
       "      <td>60159420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>41</td>\n",
       "      <td>2014</td>\n",
       "      <td>2</td>\n",
       "      <td>PSDB</td>\n",
       "      <td>56959640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>2014</td>\n",
       "      <td>1</td>\n",
       "      <td>PMDB</td>\n",
       "      <td>55073506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>115</td>\n",
       "      <td>2018</td>\n",
       "      <td>1</td>\n",
       "      <td>PPL</td>\n",
       "      <td>1237879</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>128</td>\n",
       "      <td>2018</td>\n",
       "      <td>1</td>\n",
       "      <td>PSTU</td>\n",
       "      <td>670753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>111</td>\n",
       "      <td>2018</td>\n",
       "      <td>1</td>\n",
       "      <td>PMB</td>\n",
       "      <td>619102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>107</td>\n",
       "      <td>2018</td>\n",
       "      <td>1</td>\n",
       "      <td>PCB</td>\n",
       "      <td>327372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>108</td>\n",
       "      <td>2018</td>\n",
       "      <td>1</td>\n",
       "      <td>PCO</td>\n",
       "      <td>53536</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>145 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     index  ano_eleicao  numero_turno sigla_partido  total_votos\n",
       "20      20         2014             1          PSDB    103432738\n",
       "25      25         2014             1            PT    102239868\n",
       "42      42         2014             2            PT     60159420\n",
       "41      41         2014             2          PSDB     56959640\n",
       "7        7         2014             1          PMDB     55073506\n",
       "..     ...          ...           ...           ...          ...\n",
       "115    115         2018             1           PPL      1237879\n",
       "128    128         2018             1          PSTU       670753\n",
       "111    111         2018             1           PMB       619102\n",
       "107    107         2018             1           PCB       327372\n",
       "108    108         2018             1           PCO        53536\n",
       "\n",
       "[145 rows x 5 columns]"
      ]
     },
     "execution_count": 116,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_group = df_group.reset_index()\n",
    "df_group.sort_values ( by = [\"ano_eleicao\", \"total_votos\"], ascending = [True, False])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "id": "processed-magazine",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:51:06.490842Z",
     "start_time": "2021-01-30T20:51:06.455841Z"
    }
   },
   "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></th>\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>total_votos</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ano_eleicao</th>\n",
       "      <th>numero_turno</th>\n",
       "      <th>sigla_partido</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2014</th>\n",
       "      <th rowspan=\"2\" valign=\"top\">1</th>\n",
       "      <th>PSDB</th>\n",
       "      <td>20</td>\n",
       "      <td>103432738</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PT</th>\n",
       "      <td>25</td>\n",
       "      <td>102239868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2</th>\n",
       "      <th>PT</th>\n",
       "      <td>42</td>\n",
       "      <td>60159420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PSDB</th>\n",
       "      <td>41</td>\n",
       "      <td>56959640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <th>PMDB</th>\n",
       "      <td>7</td>\n",
       "      <td>55073506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2018</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">1</th>\n",
       "      <th>PPL</th>\n",
       "      <td>115</td>\n",
       "      <td>1237879</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PSTU</th>\n",
       "      <td>128</td>\n",
       "      <td>670753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PMB</th>\n",
       "      <td>111</td>\n",
       "      <td>619102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PCB</th>\n",
       "      <td>107</td>\n",
       "      <td>327372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PCO</th>\n",
       "      <td>108</td>\n",
       "      <td>53536</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>145 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        index  total_votos\n",
       "ano_eleicao numero_turno sigla_partido                    \n",
       "2014        1            PSDB              20    103432738\n",
       "                         PT                25    102239868\n",
       "            2            PT                42     60159420\n",
       "                         PSDB              41     56959640\n",
       "            1            PMDB               7     55073506\n",
       "...                                       ...          ...\n",
       "2018        1            PPL              115      1237879\n",
       "                         PSTU             128       670753\n",
       "                         PMB              111       619102\n",
       "                         PCB              107       327372\n",
       "                         PCO              108        53536\n",
       "\n",
       "[145 rows x 2 columns]"
      ]
     },
     "execution_count": 117,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_group = df_group.sort_values ( by = [\"ano_eleicao\", \"total_votos\"], ascending = [True, False])\n",
    "df_group = df_group.set_index ([ \"ano_eleicao\", \"numero_turno\", \"sigla_partido\"])\n",
    "df_group"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "id": "gorgeous-darwin",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:51:10.140317Z",
     "start_time": "2021-01-30T20:51:10.048316Z"
    }
   },
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th colspan=\"10\" halign=\"left\">index</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"10\" halign=\"left\">total_votos</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>sigla_partido</th>\n",
       "      <th>AVANTE</th>\n",
       "      <th>DC</th>\n",
       "      <th>DEM</th>\n",
       "      <th>MDB</th>\n",
       "      <th>NOVO</th>\n",
       "      <th>PATRI</th>\n",
       "      <th>PC DO B</th>\n",
       "      <th>PCB</th>\n",
       "      <th>PCO</th>\n",
       "      <th>PDT</th>\n",
       "      <th>...</th>\n",
       "      <th>PSTU</th>\n",
       "      <th>PT</th>\n",
       "      <th>PT DO B</th>\n",
       "      <th>PTB</th>\n",
       "      <th>PTC</th>\n",
       "      <th>PTN</th>\n",
       "      <th>PV</th>\n",
       "      <th>REDE</th>\n",
       "      <th>SD</th>\n",
       "      <th>SOLIDARIEDADE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ano_eleicao</th>\n",
       "      <th>numero_turno</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2014</th>\n",
       "      <th>1</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>836982.0</td>\n",
       "      <td>102239868.0</td>\n",
       "      <td>1917630.0</td>\n",
       "      <td>11102062.0</td>\n",
       "      <td>1328023.0</td>\n",
       "      <td>2185297.0</td>\n",
       "      <td>6300115.0</td>\n",
       "      <td>39240.0</td>\n",
       "      <td>5312229.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60159420.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2016</th>\n",
       "      <th>1</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>...</td>\n",
       "      <td>117457.0</td>\n",
       "      <td>12058070.0</td>\n",
       "      <td>1560504.0</td>\n",
       "      <td>8119323.0</td>\n",
       "      <td>1901801.0</td>\n",
       "      <td>2861682.0</td>\n",
       "      <td>4786533.0</td>\n",
       "      <td>1784134.0</td>\n",
       "      <td>4309957.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>810578.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>308837.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>403009.0</td>\n",
       "      <td>403730.0</td>\n",
       "      <td>315160.0</td>\n",
       "      <td>211259.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2018</th>\n",
       "      <th>1</th>\n",
       "      <td>100.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>102.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>107.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>109.0</td>\n",
       "      <td>...</td>\n",
       "      <td>670753.0</td>\n",
       "      <td>90866573.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7675311.0</td>\n",
       "      <td>1640635.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5217905.0</td>\n",
       "      <td>10312993.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8562515.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>137.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>138.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>95104722.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6 rows × 82 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          index                                             \\\n",
       "sigla_partido            AVANTE     DC    DEM    MDB   NOVO  PATRI PC DO B   \n",
       "ano_eleicao numero_turno                                                     \n",
       "2014        1               0.0    0.0    0.0    0.0    0.0    0.0     1.0   \n",
       "            2               0.0    0.0    0.0    0.0    0.0    0.0     0.0   \n",
       "2016        1               0.0    0.0   43.0    0.0   44.0    0.0    45.0   \n",
       "            2               0.0    0.0   79.0    0.0    0.0    0.0    80.0   \n",
       "2018        1             100.0  101.0  102.0  103.0  104.0  105.0   106.0   \n",
       "            2               0.0    0.0  135.0  136.0  137.0    0.0     0.0   \n",
       "\n",
       "                                               ... total_votos               \\\n",
       "sigla_partido               PCB    PCO    PDT  ...        PSTU           PT   \n",
       "ano_eleicao numero_turno                       ...                            \n",
       "2014        1               2.0    3.0    4.0  ...    836982.0  102239868.0   \n",
       "            2               0.0    0.0   33.0  ...         0.0   60159420.0   \n",
       "2016        1              46.0   47.0   48.0  ...    117457.0   12058070.0   \n",
       "            2               0.0    0.0   81.0  ...         0.0     810578.0   \n",
       "2018        1             107.0  108.0  109.0  ...    670753.0   90866573.0   \n",
       "            2               0.0    0.0  138.0  ...         0.0   95104722.0   \n",
       "\n",
       "                                                                       \\\n",
       "sigla_partido               PT DO B         PTB        PTC        PTN   \n",
       "ano_eleicao numero_turno                                                \n",
       "2014        1             1917630.0  11102062.0  1328023.0  2185297.0   \n",
       "            2                   0.0         0.0        0.0        0.0   \n",
       "2016        1             1560504.0   8119323.0  1901801.0  2861682.0   \n",
       "            2                   0.0    308837.0        0.0   403009.0   \n",
       "2018        1                   0.0   7675311.0  1640635.0        0.0   \n",
       "            2                   0.0         0.0        0.0        0.0   \n",
       "\n",
       "                                                                          \n",
       "sigla_partido                    PV        REDE         SD SOLIDARIEDADE  \n",
       "ano_eleicao numero_turno                                                  \n",
       "2014        1             6300115.0     39240.0  5312229.0           0.0  \n",
       "            2                   0.0         0.0        0.0           0.0  \n",
       "2016        1             4786533.0   1784134.0  4309957.0           0.0  \n",
       "            2              403730.0    315160.0   211259.0           0.0  \n",
       "2018        1             5217905.0  10312993.0        0.0     8562515.0  \n",
       "            2                   0.0         0.0        0.0           0.0  \n",
       "\n",
       "[6 rows x 82 columns]"
      ]
     },
     "execution_count": 118,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Group by com transposse\n",
    "\n",
    "df_unstack = df_group.unstack().fillna(0)\n",
    "df_unstack"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "id": "industrial-cardiff",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:51:13.916574Z",
     "start_time": "2021-01-30T20:51:13.868575Z"
    }
   },
   "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></th>\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>total_votos</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ano_eleicao</th>\n",
       "      <th>numero_turno</th>\n",
       "      <th>sigla_partido</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2014</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">1</th>\n",
       "      <th>AVANTE</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DC</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DEM</th>\n",
       "      <td>0.0</td>\n",
       "      <td>13644709.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MDB</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOVO</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2018</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">2</th>\n",
       "      <th>PTN</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PV</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REDE</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SD</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SOLIDARIEDADE</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>246 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        index  total_votos\n",
       "ano_eleicao numero_turno sigla_partido                    \n",
       "2014        1            AVANTE           0.0          0.0\n",
       "                         DC               0.0          0.0\n",
       "                         DEM              0.0   13644709.0\n",
       "                         MDB              0.0          0.0\n",
       "                         NOVO             0.0          0.0\n",
       "...                                       ...          ...\n",
       "2018        2            PTN              0.0          0.0\n",
       "                         PV               0.0          0.0\n",
       "                         REDE             0.0          0.0\n",
       "                         SD               0.0          0.0\n",
       "                         SOLIDARIEDADE    0.0          0.0\n",
       "\n",
       "[246 rows x 2 columns]"
      ]
     },
     "execution_count": 119,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_unstack.stack()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "id": "reliable-sheffield",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:51:24.503703Z",
     "start_time": "2021-01-30T20:51:22.073700Z"
    }
   },
   "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>descricao_eleicao</th>\n",
       "      <th>numero_turno</th>\n",
       "      <th>nome_partido</th>\n",
       "      <th>numero_partido</th>\n",
       "      <th>sigla_partido</th>\n",
       "      <th>descricao_cargo</th>\n",
       "      <th>descricao_situacao_candidatura</th>\n",
       "      <th>descricao_situacao_candidatura_superior</th>\n",
       "      <th>nome</th>\n",
       "      <th>...</th>\n",
       "      <th>total_votos_pi</th>\n",
       "      <th>total_votos_ma</th>\n",
       "      <th>total_votos_df</th>\n",
       "      <th>total_votos_es</th>\n",
       "      <th>total_votos_rr</th>\n",
       "      <th>total_votos_sc</th>\n",
       "      <th>total_votos</th>\n",
       "      <th>index</th>\n",
       "      <th>total_votos_partido</th>\n",
       "      <th>representacao_partido</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO DEMOCRATICO TRABALHISTA</td>\n",
       "      <td>12</td>\n",
       "      <td>PDT</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>AMAZONINO ARMANDO MENDES</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>577397</td>\n",
       "      <td>4</td>\n",
       "      <td>13036163</td>\n",
       "      <td>0.044292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO DO MOVIMENTO DEMOCRATICO BRASILEIRO</td>\n",
       "      <td>15</td>\n",
       "      <td>PMDB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>CARLOS EDUARDO DE SOUZA BRAGA</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>377680</td>\n",
       "      <td>7</td>\n",
       "      <td>55073506</td>\n",
       "      <td>0.006858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO DOS TRABALHADORES</td>\n",
       "      <td>13</td>\n",
       "      <td>PT</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>JOSE RICARDO WENDLING</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>181257</td>\n",
       "      <td>25</td>\n",
       "      <td>102239868</td>\n",
       "      <td>0.001773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO HUMANISTA DA SOLIDARIEDADE</td>\n",
       "      <td>31</td>\n",
       "      <td>PHS</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>MAURICIO WILKER DE AZEVEDO BARRETO</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>22623</td>\n",
       "      <td>6</td>\n",
       "      <td>2147026</td>\n",
       "      <td>0.010537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO PATRIA LIVRE</td>\n",
       "      <td>54</td>\n",
       "      <td>PPL</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>JADELVONE NOGUEIRA DELTRUDES</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3362</td>\n",
       "      <td>10</td>\n",
       "      <td>560105</td>\n",
       "      <td>0.006002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511100</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2</td>\n",
       "      <td>PARTIDO SOCIAL LIBERAL</td>\n",
       "      <td>17</td>\n",
       "      <td>PSL</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MARCOS JOSE ROCHA DOS SANTOS</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>530188</td>\n",
       "      <td>143</td>\n",
       "      <td>121550852</td>\n",
       "      <td>0.004362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511101</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANTONIO CARLOS VALADARES FILHO</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>370161</td>\n",
       "      <td>139</td>\n",
       "      <td>21493510</td>\n",
       "      <td>0.017222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511102</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JOAO ALBERTO RODRIGUES CAPIBERIBE</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>174540</td>\n",
       "      <td>139</td>\n",
       "      <td>21493510</td>\n",
       "      <td>0.008121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511103</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MARCIO LUIZ FRANCA GOMES</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20497480</td>\n",
       "      <td>139</td>\n",
       "      <td>21493510</td>\n",
       "      <td>0.953659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511104</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RODRIGO SOBRAL ROLLEMBERG</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>451329</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>451329</td>\n",
       "      <td>139</td>\n",
       "      <td>21493510</td>\n",
       "      <td>0.020998</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>511105 rows × 46 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ano_eleicao                  descricao_eleicao  numero_turno  \\\n",
       "0              2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "1              2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "2              2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "3              2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "4              2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "...             ...                                ...           ...   \n",
       "511100         2018     ELEICOES GERAIS ESTADUAIS 2018             2   \n",
       "511101         2018     ELEICOES GERAIS ESTADUAIS 2018             2   \n",
       "511102         2018     ELEICOES GERAIS ESTADUAIS 2018             2   \n",
       "511103         2018     ELEICOES GERAIS ESTADUAIS 2018             2   \n",
       "511104         2018     ELEICOES GERAIS ESTADUAIS 2018             2   \n",
       "\n",
       "                                       nome_partido  numero_partido  \\\n",
       "0                   PARTIDO DEMOCRATICO TRABALHISTA              12   \n",
       "1       PARTIDO DO MOVIMENTO DEMOCRATICO BRASILEIRO              15   \n",
       "2                         PARTIDO DOS TRABALHADORES              13   \n",
       "3                PARTIDO HUMANISTA DA SOLIDARIEDADE              31   \n",
       "4                              PARTIDO PATRIA LIVRE              54   \n",
       "...                                             ...             ...   \n",
       "511100                       PARTIDO SOCIAL LIBERAL              17   \n",
       "511101                PARTIDO SOCIALISTA BRASILEIRO              40   \n",
       "511102                PARTIDO SOCIALISTA BRASILEIRO              40   \n",
       "511103                PARTIDO SOCIALISTA BRASILEIRO              40   \n",
       "511104                PARTIDO SOCIALISTA BRASILEIRO              40   \n",
       "\n",
       "       sigla_partido descricao_cargo descricao_situacao_candidatura  \\\n",
       "0                PDT      GOVERNADOR                       DEFERIDO   \n",
       "1               PMDB      GOVERNADOR                       DEFERIDO   \n",
       "2                 PT      GOVERNADOR                       DEFERIDO   \n",
       "3                PHS      GOVERNADOR                       DEFERIDO   \n",
       "4                PPL      GOVERNADOR                       DEFERIDO   \n",
       "...              ...             ...                            ...   \n",
       "511100           PSL      GOVERNADOR                           APTO   \n",
       "511101           PSB      GOVERNADOR                           APTO   \n",
       "511102           PSB      GOVERNADOR                           APTO   \n",
       "511103           PSB      GOVERNADOR                           APTO   \n",
       "511104           PSB      GOVERNADOR                           APTO   \n",
       "\n",
       "       descricao_situacao_candidatura_superior  \\\n",
       "0                                         APTO   \n",
       "1                                         APTO   \n",
       "2                                         APTO   \n",
       "3                                         APTO   \n",
       "4                                         APTO   \n",
       "...                                        ...   \n",
       "511100                                     NaN   \n",
       "511101                                     NaN   \n",
       "511102                                     NaN   \n",
       "511103                                     NaN   \n",
       "511104                                     NaN   \n",
       "\n",
       "                                      nome  ...  total_votos_pi  \\\n",
       "0                 AMAZONINO ARMANDO MENDES  ...               0   \n",
       "1            CARLOS EDUARDO DE SOUZA BRAGA  ...               0   \n",
       "2                    JOSE RICARDO WENDLING  ...               0   \n",
       "3       MAURICIO WILKER DE AZEVEDO BARRETO  ...               0   \n",
       "4             JADELVONE NOGUEIRA DELTRUDES  ...               0   \n",
       "...                                    ...  ...             ...   \n",
       "511100        MARCOS JOSE ROCHA DOS SANTOS  ...               0   \n",
       "511101      ANTONIO CARLOS VALADARES FILHO  ...               0   \n",
       "511102   JOAO ALBERTO RODRIGUES CAPIBERIBE  ...               0   \n",
       "511103            MARCIO LUIZ FRANCA GOMES  ...               0   \n",
       "511104           RODRIGO SOBRAL ROLLEMBERG  ...               0   \n",
       "\n",
       "       total_votos_ma  total_votos_df  total_votos_es  total_votos_rr  \\\n",
       "0                   0               0               0               0   \n",
       "1                   0               0               0               0   \n",
       "2                   0               0               0               0   \n",
       "3                   0               0               0               0   \n",
       "4                   0               0               0               0   \n",
       "...               ...             ...             ...             ...   \n",
       "511100              0               0               0               0   \n",
       "511101              0               0               0               0   \n",
       "511102              0               0               0               0   \n",
       "511103              0               0               0               0   \n",
       "511104              0          451329               0               0   \n",
       "\n",
       "        total_votos_sc  total_votos  index  total_votos_partido  \\\n",
       "0                    0       577397      4             13036163   \n",
       "1                    0       377680      7             55073506   \n",
       "2                    0       181257     25            102239868   \n",
       "3                    0        22623      6              2147026   \n",
       "4                    0         3362     10               560105   \n",
       "...                ...          ...    ...                  ...   \n",
       "511100               0       530188    143            121550852   \n",
       "511101               0       370161    139             21493510   \n",
       "511102               0       174540    139             21493510   \n",
       "511103               0     20497480    139             21493510   \n",
       "511104               0       451329    139             21493510   \n",
       "\n",
       "        representacao_partido  \n",
       "0                    0.044292  \n",
       "1                    0.006858  \n",
       "2                    0.001773  \n",
       "3                    0.010537  \n",
       "4                    0.006002  \n",
       "...                       ...  \n",
       "511100               0.004362  \n",
       "511101               0.017222  \n",
       "511102               0.008121  \n",
       "511103               0.953659  \n",
       "511104               0.020998  \n",
       "\n",
       "[511105 rows x 46 columns]"
      ]
     },
     "execution_count": 120,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Calcular a representatividade de cada político no total de votos do seu respectivo partido político\n",
    "\n",
    "df1 = df_group.reset_index()\n",
    "df_votos = df_votacao.merge(right=df1, on=['ano_eleicao', 'numero_turno', 'sigla_partido'], how='left',\n",
    "                      suffixes=['','_partido'])\n",
    "df_votos['representacao_partido'] = df_votos['total_votos'] / df_votos['total_votos_partido']\n",
    "df_votos"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "passing-intro",
   "metadata": {},
   "source": [
    "#### # Análise de qual partido tem mais bens declarados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "id": "thermal-jesus",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:55:33.768043Z",
     "start_time": "2021-01-30T20:55:28.336762Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting openpyxl\n",
      "  Downloading openpyxl-3.0.6-py2.py3-none-any.whl (242 kB)\n",
      "Collecting et-xmlfile\n",
      "  Downloading et_xmlfile-1.0.1.tar.gz (8.4 kB)\n",
      "Collecting jdcal\n",
      "  Downloading jdcal-1.4.1-py2.py3-none-any.whl (9.5 kB)\n",
      "Building wheels for collected packages: et-xmlfile\n",
      "  Building wheel for et-xmlfile (setup.py): started\n",
      "  Building wheel for et-xmlfile (setup.py): finished with status 'done'\n",
      "  Created wheel for et-xmlfile: filename=et_xmlfile-1.0.1-py3-none-any.whl size=8913 sha256=30657b91e0246a710d4f93462312029fb6e91156225ab507c36ee15e3e765aea\n",
      "  Stored in directory: c:\\users\\halisson\\appdata\\local\\pip\\cache\\wheels\\bb\\9b\\ff\\8fdf015c95a57224237bf88fbb9e45237cbe8177213bc13732\n",
      "Successfully built et-xmlfile\n",
      "Installing collected packages: jdcal, et-xmlfile, openpyxl\n",
      "Successfully installed et-xmlfile-1.0.1 jdcal-1.4.1 openpyxl-3.0.6\n"
     ]
    }
   ],
   "source": [
    "!pip install openpyxl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "id": "nutritional-politics",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:56:42.846044Z",
     "start_time": "2021-01-30T20:55:42.999680Z"
    }
   },
   "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>codigo_eleicao</th>\n",
       "      <th>codigo_tipo_eleicao</th>\n",
       "      <th>data_eleicao</th>\n",
       "      <th>descricao_eleicao</th>\n",
       "      <th>nome_tipo_eleicao</th>\n",
       "      <th>nome_ue</th>\n",
       "      <th>sigla_ue</th>\n",
       "      <th>sigla_uf</th>\n",
       "      <th>numero_sequencial</th>\n",
       "      <th>codigo_tipo</th>\n",
       "      <th>data_ultima_atualizacao</th>\n",
       "      <th>descricao_tipo</th>\n",
       "      <th>detalhe</th>\n",
       "      <th>hora_ultima_atualizacao</th>\n",
       "      <th>numero_ordem</th>\n",
       "      <th>valor</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014</td>\n",
       "      <td>143</td>\n",
       "      <td>2</td>\n",
       "      <td>05/10/2014</td>\n",
       "      <td>ELEICOES GERAIS 2014</td>\n",
       "      <td>ELEICAO ORDINARIA</td>\n",
       "      <td>ACRE</td>\n",
       "      <td>AC</td>\n",
       "      <td>AC</td>\n",
       "      <td>10000000001</td>\n",
       "      <td>32</td>\n",
       "      <td>12/07/2018</td>\n",
       "      <td>QUOTAS OU QUINHOES DE CAPITAL</td>\n",
       "      <td>8360 QUOTAS DE CAPITAL SOCIAL DA EMPRESA MARMU...</td>\n",
       "      <td>16:36:00</td>\n",
       "      <td>1</td>\n",
       "      <td>8360.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014</td>\n",
       "      <td>143</td>\n",
       "      <td>2</td>\n",
       "      <td>05/10/2014</td>\n",
       "      <td>ELEICOES GERAIS 2014</td>\n",
       "      <td>ELEICAO ORDINARIA</td>\n",
       "      <td>ACRE</td>\n",
       "      <td>AC</td>\n",
       "      <td>AC</td>\n",
       "      <td>10000000001</td>\n",
       "      <td>21</td>\n",
       "      <td>12/07/2018</td>\n",
       "      <td>VEICULO AUTOMOTOR TERRESTRE: CAMINHAO, AUTOMOV...</td>\n",
       "      <td>AUTOMOVEL HILUX CD,</td>\n",
       "      <td>16:36:00</td>\n",
       "      <td>2</td>\n",
       "      <td>143000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014</td>\n",
       "      <td>143</td>\n",
       "      <td>2</td>\n",
       "      <td>05/10/2014</td>\n",
       "      <td>ELEICOES GERAIS 2014</td>\n",
       "      <td>ELEICAO ORDINARIA</td>\n",
       "      <td>ACRE</td>\n",
       "      <td>AC</td>\n",
       "      <td>AC</td>\n",
       "      <td>10000000058</td>\n",
       "      <td>21</td>\n",
       "      <td>12/07/2018</td>\n",
       "      <td>VEICULO AUTOMOTOR TERRESTRE: CAMINHAO, AUTOMOV...</td>\n",
       "      <td>CAMINHAO MERCEDES-BENZ, MODELO 2726, ANO 2010</td>\n",
       "      <td>16:36:00</td>\n",
       "      <td>2</td>\n",
       "      <td>150000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014</td>\n",
       "      <td>143</td>\n",
       "      <td>2</td>\n",
       "      <td>05/10/2014</td>\n",
       "      <td>ELEICOES GERAIS 2014</td>\n",
       "      <td>ELEICAO ORDINARIA</td>\n",
       "      <td>ACRE</td>\n",
       "      <td>AC</td>\n",
       "      <td>AC</td>\n",
       "      <td>10000000001</td>\n",
       "      <td>45</td>\n",
       "      <td>12/07/2018</td>\n",
       "      <td>APLICACAO DE RENDA FIXA (CDB, RDB E OUTROS)</td>\n",
       "      <td>POUPEX BANCO DO BRASIL</td>\n",
       "      <td>16:36:00</td>\n",
       "      <td>3</td>\n",
       "      <td>148.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014</td>\n",
       "      <td>143</td>\n",
       "      <td>2</td>\n",
       "      <td>05/10/2014</td>\n",
       "      <td>ELEICOES GERAIS 2014</td>\n",
       "      <td>ELEICAO ORDINARIA</td>\n",
       "      <td>ACRE</td>\n",
       "      <td>AC</td>\n",
       "      <td>AC</td>\n",
       "      <td>10000000001</td>\n",
       "      <td>61</td>\n",
       "      <td>12/07/2018</td>\n",
       "      <td>DEPOSITO BANCARIO EM CONTA CORRENTE NO PAIS</td>\n",
       "      <td>SALDO EM CONTA BANCARIA (BANCO DO BRASIL)</td>\n",
       "      <td>16:36:00</td>\n",
       "      <td>4</td>\n",
       "      <td>937.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176316</th>\n",
       "      <td>2018</td>\n",
       "      <td>297</td>\n",
       "      <td>2</td>\n",
       "      <td>07/10/2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>ELEICAO ORDINARIA</td>\n",
       "      <td>TOCANTINS</td>\n",
       "      <td>TO</td>\n",
       "      <td>TO</td>\n",
       "      <td>270000629137</td>\n",
       "      <td>32</td>\n",
       "      <td>13/12/2018</td>\n",
       "      <td>QUOTAS OU QUINHOES DE CAPITAL</td>\n",
       "      <td>QUOTAS DE CAPITAL SOCIAL NA EMPRESA TERRAPLAN,...</td>\n",
       "      <td>17:02:46</td>\n",
       "      <td>1</td>\n",
       "      <td>126667.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176317</th>\n",
       "      <td>2018</td>\n",
       "      <td>297</td>\n",
       "      <td>2</td>\n",
       "      <td>07/10/2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>ELEICAO ORDINARIA</td>\n",
       "      <td>TOCANTINS</td>\n",
       "      <td>TO</td>\n",
       "      <td>TO</td>\n",
       "      <td>270000629137</td>\n",
       "      <td>32</td>\n",
       "      <td>13/12/2018</td>\n",
       "      <td>QUOTAS OU QUINHOES DE CAPITAL</td>\n",
       "      <td>QUOTAS  DE CAPITAL SOCIAL NA EMPRESA FAROL EMP...</td>\n",
       "      <td>17:02:46</td>\n",
       "      <td>2</td>\n",
       "      <td>25000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176318</th>\n",
       "      <td>2018</td>\n",
       "      <td>297</td>\n",
       "      <td>2</td>\n",
       "      <td>07/10/2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>ELEICAO ORDINARIA</td>\n",
       "      <td>TOCANTINS</td>\n",
       "      <td>TO</td>\n",
       "      <td>TO</td>\n",
       "      <td>270000629137</td>\n",
       "      <td>97</td>\n",
       "      <td>13/12/2018</td>\n",
       "      <td>VGBL - VIDA GERADOR DE BENEFICIO LIVRE</td>\n",
       "      <td>SALDO EM APLICACOES JUNTO AO BANCO BRADESCO, VGBL</td>\n",
       "      <td>17:02:46</td>\n",
       "      <td>3</td>\n",
       "      <td>265783.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176319</th>\n",
       "      <td>2018</td>\n",
       "      <td>297</td>\n",
       "      <td>2</td>\n",
       "      <td>07/10/2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>ELEICAO ORDINARIA</td>\n",
       "      <td>TOCANTINS</td>\n",
       "      <td>TO</td>\n",
       "      <td>TO</td>\n",
       "      <td>270000629137</td>\n",
       "      <td>79</td>\n",
       "      <td>13/12/2018</td>\n",
       "      <td>OUTROS FUNDOS</td>\n",
       "      <td>DISPONIBILIDADES DE RESGATES DE APLICACOES E A...</td>\n",
       "      <td>17:02:46</td>\n",
       "      <td>4</td>\n",
       "      <td>1200000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176320</th>\n",
       "      <td>2018</td>\n",
       "      <td>297</td>\n",
       "      <td>2</td>\n",
       "      <td>07/10/2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>ELEICAO ORDINARIA</td>\n",
       "      <td>TOCANTINS</td>\n",
       "      <td>TO</td>\n",
       "      <td>TO</td>\n",
       "      <td>270000629137</td>\n",
       "      <td>41</td>\n",
       "      <td>13/12/2018</td>\n",
       "      <td>CADERNETA DE POUPANCA</td>\n",
       "      <td>SALDO EM CADERNETA DE POUPANCA JUNTO AO BANCO ...</td>\n",
       "      <td>17:02:46</td>\n",
       "      <td>5</td>\n",
       "      <td>30239.10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>176321 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ano_eleicao  codigo_eleicao  codigo_tipo_eleicao data_eleicao  \\\n",
       "0              2014             143                    2   05/10/2014   \n",
       "1              2014             143                    2   05/10/2014   \n",
       "2              2014             143                    2   05/10/2014   \n",
       "3              2014             143                    2   05/10/2014   \n",
       "4              2014             143                    2   05/10/2014   \n",
       "...             ...             ...                  ...          ...   \n",
       "176316         2018             297                    2   07/10/2018   \n",
       "176317         2018             297                    2   07/10/2018   \n",
       "176318         2018             297                    2   07/10/2018   \n",
       "176319         2018             297                    2   07/10/2018   \n",
       "176320         2018             297                    2   07/10/2018   \n",
       "\n",
       "                     descricao_eleicao  nome_tipo_eleicao    nome_ue sigla_ue  \\\n",
       "0                 ELEICOES GERAIS 2014  ELEICAO ORDINARIA       ACRE       AC   \n",
       "1                 ELEICOES GERAIS 2014  ELEICAO ORDINARIA       ACRE       AC   \n",
       "2                 ELEICOES GERAIS 2014  ELEICAO ORDINARIA       ACRE       AC   \n",
       "3                 ELEICOES GERAIS 2014  ELEICAO ORDINARIA       ACRE       AC   \n",
       "4                 ELEICOES GERAIS 2014  ELEICAO ORDINARIA       ACRE       AC   \n",
       "...                                ...                ...        ...      ...   \n",
       "176316  ELEICOES GERAIS ESTADUAIS 2018  ELEICAO ORDINARIA  TOCANTINS       TO   \n",
       "176317  ELEICOES GERAIS ESTADUAIS 2018  ELEICAO ORDINARIA  TOCANTINS       TO   \n",
       "176318  ELEICOES GERAIS ESTADUAIS 2018  ELEICAO ORDINARIA  TOCANTINS       TO   \n",
       "176319  ELEICOES GERAIS ESTADUAIS 2018  ELEICAO ORDINARIA  TOCANTINS       TO   \n",
       "176320  ELEICOES GERAIS ESTADUAIS 2018  ELEICAO ORDINARIA  TOCANTINS       TO   \n",
       "\n",
       "       sigla_uf  numero_sequencial  codigo_tipo data_ultima_atualizacao  \\\n",
       "0            AC        10000000001           32              12/07/2018   \n",
       "1            AC        10000000001           21              12/07/2018   \n",
       "2            AC        10000000058           21              12/07/2018   \n",
       "3            AC        10000000001           45              12/07/2018   \n",
       "4            AC        10000000001           61              12/07/2018   \n",
       "...         ...                ...          ...                     ...   \n",
       "176316       TO       270000629137           32              13/12/2018   \n",
       "176317       TO       270000629137           32              13/12/2018   \n",
       "176318       TO       270000629137           97              13/12/2018   \n",
       "176319       TO       270000629137           79              13/12/2018   \n",
       "176320       TO       270000629137           41              13/12/2018   \n",
       "\n",
       "                                           descricao_tipo  \\\n",
       "0                           QUOTAS OU QUINHOES DE CAPITAL   \n",
       "1       VEICULO AUTOMOTOR TERRESTRE: CAMINHAO, AUTOMOV...   \n",
       "2       VEICULO AUTOMOTOR TERRESTRE: CAMINHAO, AUTOMOV...   \n",
       "3             APLICACAO DE RENDA FIXA (CDB, RDB E OUTROS)   \n",
       "4             DEPOSITO BANCARIO EM CONTA CORRENTE NO PAIS   \n",
       "...                                                   ...   \n",
       "176316                      QUOTAS OU QUINHOES DE CAPITAL   \n",
       "176317                      QUOTAS OU QUINHOES DE CAPITAL   \n",
       "176318             VGBL - VIDA GERADOR DE BENEFICIO LIVRE   \n",
       "176319                                      OUTROS FUNDOS   \n",
       "176320                              CADERNETA DE POUPANCA   \n",
       "\n",
       "                                                  detalhe  \\\n",
       "0       8360 QUOTAS DE CAPITAL SOCIAL DA EMPRESA MARMU...   \n",
       "1                                     AUTOMOVEL HILUX CD,   \n",
       "2           CAMINHAO MERCEDES-BENZ, MODELO 2726, ANO 2010   \n",
       "3                                  POUPEX BANCO DO BRASIL   \n",
       "4               SALDO EM CONTA BANCARIA (BANCO DO BRASIL)   \n",
       "...                                                   ...   \n",
       "176316  QUOTAS DE CAPITAL SOCIAL NA EMPRESA TERRAPLAN,...   \n",
       "176317  QUOTAS  DE CAPITAL SOCIAL NA EMPRESA FAROL EMP...   \n",
       "176318  SALDO EM APLICACOES JUNTO AO BANCO BRADESCO, VGBL   \n",
       "176319  DISPONIBILIDADES DE RESGATES DE APLICACOES E A...   \n",
       "176320  SALDO EM CADERNETA DE POUPANCA JUNTO AO BANCO ...   \n",
       "\n",
       "       hora_ultima_atualizacao  numero_ordem       valor  \n",
       "0                     16:36:00             1     8360.00  \n",
       "1                     16:36:00             2   143000.00  \n",
       "2                     16:36:00             2   150000.00  \n",
       "3                     16:36:00             3      148.84  \n",
       "4                     16:36:00             4      937.91  \n",
       "...                        ...           ...         ...  \n",
       "176316                17:02:46             1   126667.00  \n",
       "176317                17:02:46             2    25000.00  \n",
       "176318                17:02:46             3   265783.16  \n",
       "176319                17:02:46             4  1200000.00  \n",
       "176320                17:02:46             5    30239.10  \n",
       "\n",
       "[176321 rows x 17 columns]"
      ]
     },
     "execution_count": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_bens = pd.read_excel( \"dados/originais/dados-teo/tb_bens.xlsx\" )\n",
    "df_bens"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "id": "earned-express",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:57:57.781719Z",
     "start_time": "2021-01-30T20:57:57.696716Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ano_eleicao  descricao_eleicao                    numero_sequencial\n",
       "2014         ELEICAO SUPLEMENTAR GOVERNADOR - TO  270000010427          3851225.78\n",
       "                                                  270000010428         89443068.71\n",
       "                                                  270000010429         15703130.86\n",
       "                                                  270000010430          1139685.88\n",
       "                                                  270000010431         18943005.55\n",
       "                                                                          ...     \n",
       "2018         ELEICOES GERAIS ESTADUAIS 2018       270000627773           205000.00\n",
       "                                                  270000627774           200000.00\n",
       "                                                  270000628397           615000.00\n",
       "                                                  270000628492           685000.00\n",
       "                                                  270000629137          1647689.26\n",
       "Name: valor, Length: 32915, dtype: float64"
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_total_bens = df_bens.groupby ([ \"ano_eleicao\", \"descricao_eleicao\", \"numero_sequencial\" ]) [\"valor\"].sum()\n",
    "df_total_bens"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "id": "descending-thomson",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:59:29.950433Z",
     "start_time": "2021-01-30T20:59:27.818458Z"
    }
   },
   "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>descricao_eleicao</th>\n",
       "      <th>numero_turno</th>\n",
       "      <th>nome_partido</th>\n",
       "      <th>numero_partido</th>\n",
       "      <th>sigla_partido</th>\n",
       "      <th>descricao_cargo</th>\n",
       "      <th>descricao_situacao_candidatura</th>\n",
       "      <th>descricao_situacao_candidatura_superior</th>\n",
       "      <th>nome</th>\n",
       "      <th>...</th>\n",
       "      <th>total_votos_pa</th>\n",
       "      <th>total_votos_ms</th>\n",
       "      <th>total_votos_pi</th>\n",
       "      <th>total_votos_ma</th>\n",
       "      <th>total_votos_df</th>\n",
       "      <th>total_votos_es</th>\n",
       "      <th>total_votos_rr</th>\n",
       "      <th>total_votos_sc</th>\n",
       "      <th>total_votos</th>\n",
       "      <th>valor</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO DEMOCRATICO TRABALHISTA</td>\n",
       "      <td>12</td>\n",
       "      <td>PDT</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>AMAZONINO ARMANDO MENDES</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>577397</td>\n",
       "      <td>3273469.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO DO MOVIMENTO DEMOCRATICO BRASILEIRO</td>\n",
       "      <td>15</td>\n",
       "      <td>PMDB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>CARLOS EDUARDO DE SOUZA BRAGA</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>377680</td>\n",
       "      <td>31251331.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO DOS TRABALHADORES</td>\n",
       "      <td>13</td>\n",
       "      <td>PT</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>JOSE RICARDO WENDLING</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>181257</td>\n",
       "      <td>1387838.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO HUMANISTA DA SOLIDARIEDADE</td>\n",
       "      <td>31</td>\n",
       "      <td>PHS</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>MAURICIO WILKER DE AZEVEDO BARRETO</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>22623</td>\n",
       "      <td>953343.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO PATRIA LIVRE</td>\n",
       "      <td>54</td>\n",
       "      <td>PPL</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>JADELVONE NOGUEIRA DELTRUDES</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3362</td>\n",
       "      <td>350000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511100</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2</td>\n",
       "      <td>PARTIDO SOCIAL LIBERAL</td>\n",
       "      <td>17</td>\n",
       "      <td>PSL</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MARCOS JOSE ROCHA DOS SANTOS</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>530188</td>\n",
       "      <td>281000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511101</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANTONIO CARLOS VALADARES FILHO</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>370161</td>\n",
       "      <td>602900.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511102</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JOAO ALBERTO RODRIGUES CAPIBERIBE</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>174540</td>\n",
       "      <td>231951.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511103</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MARCIO LUIZ FRANCA GOMES</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20497480</td>\n",
       "      <td>427944.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511104</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>2</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>APTO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RODRIGO SOBRAL ROLLEMBERG</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>451329</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>451329</td>\n",
       "      <td>930152.75</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>511105 rows × 44 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ano_eleicao                  descricao_eleicao  numero_turno  \\\n",
       "0              2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "1              2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "2              2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "3              2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "4              2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "...             ...                                ...           ...   \n",
       "511100         2018     ELEICOES GERAIS ESTADUAIS 2018             2   \n",
       "511101         2018     ELEICOES GERAIS ESTADUAIS 2018             2   \n",
       "511102         2018     ELEICOES GERAIS ESTADUAIS 2018             2   \n",
       "511103         2018     ELEICOES GERAIS ESTADUAIS 2018             2   \n",
       "511104         2018     ELEICOES GERAIS ESTADUAIS 2018             2   \n",
       "\n",
       "                                       nome_partido  numero_partido  \\\n",
       "0                   PARTIDO DEMOCRATICO TRABALHISTA              12   \n",
       "1       PARTIDO DO MOVIMENTO DEMOCRATICO BRASILEIRO              15   \n",
       "2                         PARTIDO DOS TRABALHADORES              13   \n",
       "3                PARTIDO HUMANISTA DA SOLIDARIEDADE              31   \n",
       "4                              PARTIDO PATRIA LIVRE              54   \n",
       "...                                             ...             ...   \n",
       "511100                       PARTIDO SOCIAL LIBERAL              17   \n",
       "511101                PARTIDO SOCIALISTA BRASILEIRO              40   \n",
       "511102                PARTIDO SOCIALISTA BRASILEIRO              40   \n",
       "511103                PARTIDO SOCIALISTA BRASILEIRO              40   \n",
       "511104                PARTIDO SOCIALISTA BRASILEIRO              40   \n",
       "\n",
       "       sigla_partido descricao_cargo descricao_situacao_candidatura  \\\n",
       "0                PDT      GOVERNADOR                       DEFERIDO   \n",
       "1               PMDB      GOVERNADOR                       DEFERIDO   \n",
       "2                 PT      GOVERNADOR                       DEFERIDO   \n",
       "3                PHS      GOVERNADOR                       DEFERIDO   \n",
       "4                PPL      GOVERNADOR                       DEFERIDO   \n",
       "...              ...             ...                            ...   \n",
       "511100           PSL      GOVERNADOR                           APTO   \n",
       "511101           PSB      GOVERNADOR                           APTO   \n",
       "511102           PSB      GOVERNADOR                           APTO   \n",
       "511103           PSB      GOVERNADOR                           APTO   \n",
       "511104           PSB      GOVERNADOR                           APTO   \n",
       "\n",
       "       descricao_situacao_candidatura_superior  \\\n",
       "0                                         APTO   \n",
       "1                                         APTO   \n",
       "2                                         APTO   \n",
       "3                                         APTO   \n",
       "4                                         APTO   \n",
       "...                                        ...   \n",
       "511100                                     NaN   \n",
       "511101                                     NaN   \n",
       "511102                                     NaN   \n",
       "511103                                     NaN   \n",
       "511104                                     NaN   \n",
       "\n",
       "                                      nome  ...  total_votos_pa  \\\n",
       "0                 AMAZONINO ARMANDO MENDES  ...               0   \n",
       "1            CARLOS EDUARDO DE SOUZA BRAGA  ...               0   \n",
       "2                    JOSE RICARDO WENDLING  ...               0   \n",
       "3       MAURICIO WILKER DE AZEVEDO BARRETO  ...               0   \n",
       "4             JADELVONE NOGUEIRA DELTRUDES  ...               0   \n",
       "...                                    ...  ...             ...   \n",
       "511100        MARCOS JOSE ROCHA DOS SANTOS  ...               0   \n",
       "511101      ANTONIO CARLOS VALADARES FILHO  ...               0   \n",
       "511102   JOAO ALBERTO RODRIGUES CAPIBERIBE  ...               0   \n",
       "511103            MARCIO LUIZ FRANCA GOMES  ...               0   \n",
       "511104           RODRIGO SOBRAL ROLLEMBERG  ...               0   \n",
       "\n",
       "       total_votos_ms  total_votos_pi  total_votos_ma  total_votos_df  \\\n",
       "0                   0               0               0               0   \n",
       "1                   0               0               0               0   \n",
       "2                   0               0               0               0   \n",
       "3                   0               0               0               0   \n",
       "4                   0               0               0               0   \n",
       "...               ...             ...             ...             ...   \n",
       "511100              0               0               0               0   \n",
       "511101              0               0               0               0   \n",
       "511102              0               0               0               0   \n",
       "511103              0               0               0               0   \n",
       "511104              0               0               0          451329   \n",
       "\n",
       "        total_votos_es  total_votos_rr  total_votos_sc  total_votos  \\\n",
       "0                    0               0               0       577397   \n",
       "1                    0               0               0       377680   \n",
       "2                    0               0               0       181257   \n",
       "3                    0               0               0        22623   \n",
       "4                    0               0               0         3362   \n",
       "...                ...             ...             ...          ...   \n",
       "511100               0               0               0       530188   \n",
       "511101               0               0               0       370161   \n",
       "511102               0               0               0       174540   \n",
       "511103               0               0               0     20497480   \n",
       "511104               0               0               0       451329   \n",
       "\n",
       "              valor  \n",
       "0        3273469.94  \n",
       "1       31251331.95  \n",
       "2        1387838.10  \n",
       "3         953343.83  \n",
       "4         350000.00  \n",
       "...             ...  \n",
       "511100    281000.00  \n",
       "511101    602900.90  \n",
       "511102    231951.66  \n",
       "511103    427944.87  \n",
       "511104    930152.75  \n",
       "\n",
       "[511105 rows x 44 columns]"
      ]
     },
     "execution_count": 134,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_votos = df_votacao.merge( right=df_total_bens,\n",
    "                          on=[\"ano_eleicao\", \"descricao_eleicao\", \"numero_sequencial\"],\n",
    "                          how=\"left\")\n",
    "df_votos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "id": "injured-china",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T21:00:04.939066Z",
     "start_time": "2021-01-30T21:00:04.872067Z"
    }
   },
   "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>sigla_partido</th>\n",
       "      <th>valor</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AVANTE</td>\n",
       "      <td>$246,442,481.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DC</td>\n",
       "      <td>$176,812,714.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DEM</td>\n",
       "      <td>$1,132,036,919.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>MDB</td>\n",
       "      <td>$1,531,634,979.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NOVO</td>\n",
       "      <td>$1,150,841,769.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PATRI</td>\n",
       "      <td>$259,527,532.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>PC DO B</td>\n",
       "      <td>$291,890,408.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>PCB</td>\n",
       "      <td>$17,225,983.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>PCO</td>\n",
       "      <td>$7,317,898.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>PDT</td>\n",
       "      <td>$1,484,045,781.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>PEN</td>\n",
       "      <td>$170,630,725.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>PHS</td>\n",
       "      <td>$448,562,055.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>PMB</td>\n",
       "      <td>$70,479,543.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>PMDB</td>\n",
       "      <td>$2,273,467,372.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>PMN</td>\n",
       "      <td>$352,530,903.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>PODE</td>\n",
       "      <td>$727,617,635.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>PP</td>\n",
       "      <td>$1,137,303,364.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>PPL</td>\n",
       "      <td>$195,207,206.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>PPS</td>\n",
       "      <td>$423,081,741.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>PR</td>\n",
       "      <td>$961,123,189.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>PRB</td>\n",
       "      <td>$454,925,237.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>PROS</td>\n",
       "      <td>$3,904,561,401.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>PRP</td>\n",
       "      <td>$351,542,899.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>PRTB</td>\n",
       "      <td>$273,542,699.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>PSB</td>\n",
       "      <td>$1,252,259,927.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>PSC</td>\n",
       "      <td>$615,269,719.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>PSD</td>\n",
       "      <td>$1,397,626,268.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>PSDB</td>\n",
       "      <td>$2,748,437,520.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>PSDC</td>\n",
       "      <td>$96,230,388.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>PSL</td>\n",
       "      <td>$1,541,065,021.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>PSOL</td>\n",
       "      <td>$348,534,708.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>PSTU</td>\n",
       "      <td>$25,891,037.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>PT</td>\n",
       "      <td>$909,356,330.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>PT DO B</td>\n",
       "      <td>$137,455,828.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>PTB</td>\n",
       "      <td>$911,582,831.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>PTC</td>\n",
       "      <td>$277,377,199.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>PTN</td>\n",
       "      <td>$122,512,487.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>PV</td>\n",
       "      <td>$975,045,767.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>REDE</td>\n",
       "      <td>$1,196,219,483.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>SD</td>\n",
       "      <td>$213,238,798.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>SOLIDARIEDADE</td>\n",
       "      <td>$927,805,527.59</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    sigla_partido             valor\n",
       "0          AVANTE   $246,442,481.72\n",
       "1              DC   $176,812,714.04\n",
       "2             DEM $1,132,036,919.14\n",
       "3             MDB $1,531,634,979.66\n",
       "4            NOVO $1,150,841,769.71\n",
       "5           PATRI   $259,527,532.37\n",
       "6         PC DO B   $291,890,408.49\n",
       "7             PCB    $17,225,983.72\n",
       "8             PCO     $7,317,898.14\n",
       "9             PDT $1,484,045,781.29\n",
       "10            PEN   $170,630,725.70\n",
       "11            PHS   $448,562,055.18\n",
       "12            PMB    $70,479,543.92\n",
       "13           PMDB $2,273,467,372.16\n",
       "14            PMN   $352,530,903.00\n",
       "15           PODE   $727,617,635.94\n",
       "16             PP $1,137,303,364.54\n",
       "17            PPL   $195,207,206.81\n",
       "18            PPS   $423,081,741.19\n",
       "19             PR   $961,123,189.32\n",
       "20            PRB   $454,925,237.99\n",
       "21           PROS $3,904,561,401.04\n",
       "22            PRP   $351,542,899.55\n",
       "23           PRTB   $273,542,699.27\n",
       "24            PSB $1,252,259,927.89\n",
       "25            PSC   $615,269,719.33\n",
       "26            PSD $1,397,626,268.74\n",
       "27           PSDB $2,748,437,520.63\n",
       "28           PSDC    $96,230,388.23\n",
       "29            PSL $1,541,065,021.08\n",
       "30           PSOL   $348,534,708.71\n",
       "31           PSTU    $25,891,037.37\n",
       "32             PT   $909,356,330.44\n",
       "33        PT DO B   $137,455,828.76\n",
       "34            PTB   $911,582,831.69\n",
       "35            PTC   $277,377,199.19\n",
       "36            PTN   $122,512,487.24\n",
       "37             PV   $975,045,767.12\n",
       "38           REDE $1,196,219,483.17\n",
       "39             SD   $213,238,798.98\n",
       "40  SOLIDARIEDADE   $927,805,527.59"
      ]
     },
     "execution_count": 135,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.options.display.float_format = '${:,.2f}'.format\n",
    "df_votos.groupby ([\"sigla_partido\"]) [\"valor\"].sum().reset_index() "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "id": "filled-framing",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T21:01:01.757538Z",
     "start_time": "2021-01-30T21:01:00.096566Z"
    }
   },
   "outputs": [],
   "source": [
    "df_analysis = df_votos.sort_values ( by = [\"ano_eleicao\", \"numero_sequencial\", \"numero_turno\"])\n",
    "\n",
    "colunas_interesse = [\"ano_eleicao\",\n",
    "                       \"descricao_eleicao\",\n",
    "                       \"sigla_partido\",\n",
    "                       \"nome\",\n",
    "                       \"numero_turno\",\n",
    "                       \"numero_sequencial\",\n",
    "                      \"valor\"] \n",
    "                     \n",
    "             \n",
    "df_analysis = df_analysis [ colunas_interesse ]\n",
    "  \n",
    "df_analysis = df_analysis.drop_duplicates ( subset = [ \"ano_eleicao\", \"numero_sequencial\"],\n",
    "                            keep=\"first\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "id": "relative-suspect",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T21:01:07.995056Z",
     "start_time": "2021-01-30T21:01:07.744064Z"
    }
   },
   "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>descricao_eleicao</th>\n",
       "      <th>sigla_partido</th>\n",
       "      <th>nome</th>\n",
       "      <th>numero_turno</th>\n",
       "      <th>numero_sequencial</th>\n",
       "      <th>valor</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>503176</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>PSL</td>\n",
       "      <td>FLAVIO NANTES BOLSONARO</td>\n",
       "      <td>1</td>\n",
       "      <td>190000614721</td>\n",
       "      <td>$1,741,758.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>502601</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>PSL</td>\n",
       "      <td>VALERIA MULLER RAMOS BOLSONARO</td>\n",
       "      <td>1</td>\n",
       "      <td>250000613301</td>\n",
       "      <td>$17,950.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>502818</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICOES GERAIS ESTADUAIS 2018</td>\n",
       "      <td>PSL</td>\n",
       "      <td>EDUARDO NANTES BOLSONARO</td>\n",
       "      <td>1</td>\n",
       "      <td>250000613378</td>\n",
       "      <td>$1,395,109.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484662</th>\n",
       "      <td>2018</td>\n",
       "      <td>ELEICAO GERAL FEDERAL 2018</td>\n",
       "      <td>PSL</td>\n",
       "      <td>JAIR MESSIAS BOLSONARO</td>\n",
       "      <td>1</td>\n",
       "      <td>280000614517</td>\n",
       "      <td>$2,286,779.48</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        ano_eleicao               descricao_eleicao sigla_partido  \\\n",
       "503176         2018  ELEICOES GERAIS ESTADUAIS 2018           PSL   \n",
       "502601         2018  ELEICOES GERAIS ESTADUAIS 2018           PSL   \n",
       "502818         2018  ELEICOES GERAIS ESTADUAIS 2018           PSL   \n",
       "484662         2018      ELEICAO GERAL FEDERAL 2018           PSL   \n",
       "\n",
       "                                  nome  numero_turno  numero_sequencial  \\\n",
       "503176         FLAVIO NANTES BOLSONARO             1       190000614721   \n",
       "502601  VALERIA MULLER RAMOS BOLSONARO             1       250000613301   \n",
       "502818        EDUARDO NANTES BOLSONARO             1       250000613378   \n",
       "484662          JAIR MESSIAS BOLSONARO             1       280000614517   \n",
       "\n",
       "               valor  \n",
       "503176 $1,741,758.15  \n",
       "502601    $17,950.12  \n",
       "502818 $1,395,109.14  \n",
       "484662 $2,286,779.48  "
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_analysis[ (df_analysis[\"ano_eleicao\"] == 2018) & ( df_analysis[\"nome\"].apply(lambda x: \"BOLSONARO\" in x) ) ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "id": "limiting-worse",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T21:02:04.415890Z",
     "start_time": "2021-01-30T21:02:04.307911Z"
    }
   },
   "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>sigla_partido</th>\n",
       "      <th>valor</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014</td>\n",
       "      <td>DEM</td>\n",
       "      <td>$386,048,089.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014</td>\n",
       "      <td>PC DO B</td>\n",
       "      <td>$146,995,871.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014</td>\n",
       "      <td>PCB</td>\n",
       "      <td>$10,507,337.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014</td>\n",
       "      <td>PCO</td>\n",
       "      <td>$742,150.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014</td>\n",
       "      <td>PDT</td>\n",
       "      <td>$470,827,805.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>2018</td>\n",
       "      <td>PTB</td>\n",
       "      <td>$342,213,791.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>2018</td>\n",
       "      <td>PTC</td>\n",
       "      <td>$137,771,162.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>2018</td>\n",
       "      <td>PV</td>\n",
       "      <td>$703,288,700.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>2018</td>\n",
       "      <td>REDE</td>\n",
       "      <td>$1,195,373,329.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>2018</td>\n",
       "      <td>SOLIDARIEDADE</td>\n",
       "      <td>$927,805,527.59</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>104 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     ano_eleicao  sigla_partido             valor\n",
       "0           2014            DEM   $386,048,089.81\n",
       "1           2014        PC DO B   $146,995,871.55\n",
       "2           2014            PCB    $10,507,337.52\n",
       "3           2014            PCO       $742,150.00\n",
       "4           2014            PDT   $470,827,805.52\n",
       "..           ...            ...               ...\n",
       "99          2018            PTB   $342,213,791.87\n",
       "100         2018            PTC   $137,771,162.42\n",
       "101         2018             PV   $703,288,700.24\n",
       "102         2018           REDE $1,195,373,329.89\n",
       "103         2018  SOLIDARIEDADE   $927,805,527.59\n",
       "\n",
       "[104 rows x 3 columns]"
      ]
     },
     "execution_count": 138,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_resultado = df_analysis.groupby ( [ \"ano_eleicao\", \"sigla_partido\"]) [\"valor\"].sum().reset_index()\n",
    "df_resultado"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "id": "exact-variation",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T21:04:03.617571Z",
     "start_time": "2021-01-30T21:04:03.531663Z"
    }
   },
   "outputs": [],
   "source": [
    "#salvando no arquivo excel\n",
    "df_resultado.to_excel(\"dados/processados/resultado_analise_partido_halisson.xlsx\")#salvando no arquivo excel"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "recorded-share",
   "metadata": {},
   "source": [
    "### Utilizando Banco de Dados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "emerging-insider",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T19:54:00.442939Z",
     "start_time": "2021-01-30T19:53:53.873689Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting sqlalchemy\n",
      "  Downloading SQLAlchemy-1.3.22-cp39-cp39-win_amd64.whl (1.2 MB)\n",
      "Installing collected packages: sqlalchemy\n",
      "Successfully installed sqlalchemy-1.3.22\n"
     ]
    }
   ],
   "source": [
    "!pip install sqlalchemy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "dangerous-newfoundland",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T19:55:07.788396Z",
     "start_time": "2021-01-30T19:55:07.785420Z"
    }
   },
   "outputs": [],
   "source": [
    "import sqlalchemy as sql"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "unique-aquatic",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T19:56:17.224931Z",
     "start_time": "2021-01-30T19:56:17.174929Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['tb_bens', 'tb_candidatura', 'tb_votacao']"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# criando a engine de conexão\n",
    "con = sql.create_engine('sqlite:///dados/originais/dados-teo/banco.db')\n",
    "\n",
    "# Tabelas que estão presentes no banco\n",
    "con.table_names()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "atlantic-drill",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T19:57:36.125559Z",
     "start_time": "2021-01-30T19:57:04.861314Z"
    }
   },
   "outputs": [],
   "source": [
    "df_bens  = pd.read_sql_table('tb_bens', con)\n",
    "df_votos = pd.read_sql_table('tb_votacao', con)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "featured-newfoundland",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:02:45.701493Z",
     "start_time": "2021-01-30T20:02:45.626515Z"
    }
   },
   "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>descricao_eleicao</th>\n",
       "      <th>numero_turno</th>\n",
       "      <th>nome_partido</th>\n",
       "      <th>numero_partido</th>\n",
       "      <th>sigla_partido</th>\n",
       "      <th>descricao_cargo</th>\n",
       "      <th>descricao_situacao_candidatura</th>\n",
       "      <th>descricao_situacao_candidatura_superior</th>\n",
       "      <th>nome</th>\n",
       "      <th>...</th>\n",
       "      <th>total_votos_to</th>\n",
       "      <th>total_votos_pa</th>\n",
       "      <th>total_votos_ms</th>\n",
       "      <th>total_votos_pi</th>\n",
       "      <th>total_votos_ma</th>\n",
       "      <th>total_votos_df</th>\n",
       "      <th>total_votos_es</th>\n",
       "      <th>total_votos_rr</th>\n",
       "      <th>total_votos_sc</th>\n",
       "      <th>total_votos</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO DEMOCRATICO TRABALHISTA</td>\n",
       "      <td>12</td>\n",
       "      <td>PDT</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>AMAZONINO ARMANDO MENDES</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>577397</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO DO MOVIMENTO DEMOCRATICO BRASILEIRO</td>\n",
       "      <td>15</td>\n",
       "      <td>PMDB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>CARLOS EDUARDO DE SOUZA BRAGA</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>377680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO DOS TRABALHADORES</td>\n",
       "      <td>13</td>\n",
       "      <td>PT</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>JOSE RICARDO WENDLING</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>181257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO HUMANISTA DA SOLIDARIEDADE</td>\n",
       "      <td>31</td>\n",
       "      <td>PHS</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>MAURICIO WILKER DE AZEVEDO BARRETO</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>22623</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO PATRIA LIVRE</td>\n",
       "      <td>54</td>\n",
       "      <td>PPL</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>JADELVONE NOGUEIRA DELTRUDES</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO POPULAR SOCIALISTA</td>\n",
       "      <td>23</td>\n",
       "      <td>PPS</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>INDEFERIDO COM RECURSO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>LILIANE ARAUJO DE ALMEIDA</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO PROGRESSISTA</td>\n",
       "      <td>11</td>\n",
       "      <td>PP</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>SUBSTITUTO PENDENTE DE JULGAMENTO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>REBECCA MARTINS GARCIA</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>268922</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>PARTIDO SOCIALISTA BRASILEIRO</td>\n",
       "      <td>40</td>\n",
       "      <td>PSB</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>MARCELO AUGUSTO DA EIRA CORREA</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>1</td>\n",
       "      <td>REDE SUSTENTABILIDADE</td>\n",
       "      <td>18</td>\n",
       "      <td>REDE</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>LUIZ CASTRO ANDRADE NETO</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>39240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2014</td>\n",
       "      <td>ELEICAO SUPLEMENTAR GOVERNADOR AM</td>\n",
       "      <td>2</td>\n",
       "      <td>PARTIDO DEMOCRATICO TRABALHISTA</td>\n",
       "      <td>12</td>\n",
       "      <td>PDT</td>\n",
       "      <td>GOVERNADOR</td>\n",
       "      <td>DEFERIDO</td>\n",
       "      <td>APTO</td>\n",
       "      <td>AMAZONINO ARMANDO MENDES</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>782933</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   ano_eleicao                  descricao_eleicao  numero_turno  \\\n",
       "0         2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "1         2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "2         2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "3         2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "4         2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "5         2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "6         2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "7         2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "8         2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             1   \n",
       "9         2014  ELEICAO SUPLEMENTAR GOVERNADOR AM             2   \n",
       "\n",
       "                                  nome_partido  numero_partido sigla_partido  \\\n",
       "0              PARTIDO DEMOCRATICO TRABALHISTA              12           PDT   \n",
       "1  PARTIDO DO MOVIMENTO DEMOCRATICO BRASILEIRO              15          PMDB   \n",
       "2                    PARTIDO DOS TRABALHADORES              13            PT   \n",
       "3           PARTIDO HUMANISTA DA SOLIDARIEDADE              31           PHS   \n",
       "4                         PARTIDO PATRIA LIVRE              54           PPL   \n",
       "5                   PARTIDO POPULAR SOCIALISTA              23           PPS   \n",
       "6                         PARTIDO PROGRESSISTA              11            PP   \n",
       "7                PARTIDO SOCIALISTA BRASILEIRO              40           PSB   \n",
       "8                        REDE SUSTENTABILIDADE              18          REDE   \n",
       "9              PARTIDO DEMOCRATICO TRABALHISTA              12           PDT   \n",
       "\n",
       "  descricao_cargo     descricao_situacao_candidatura  \\\n",
       "0      GOVERNADOR                           DEFERIDO   \n",
       "1      GOVERNADOR                           DEFERIDO   \n",
       "2      GOVERNADOR                           DEFERIDO   \n",
       "3      GOVERNADOR                           DEFERIDO   \n",
       "4      GOVERNADOR                           DEFERIDO   \n",
       "5      GOVERNADOR             INDEFERIDO COM RECURSO   \n",
       "6      GOVERNADOR  SUBSTITUTO PENDENTE DE JULGAMENTO   \n",
       "7      GOVERNADOR                           DEFERIDO   \n",
       "8      GOVERNADOR                           DEFERIDO   \n",
       "9      GOVERNADOR                           DEFERIDO   \n",
       "\n",
       "  descricao_situacao_candidatura_superior                                nome  \\\n",
       "0                                    APTO            AMAZONINO ARMANDO MENDES   \n",
       "1                                    APTO       CARLOS EDUARDO DE SOUZA BRAGA   \n",
       "2                                    APTO               JOSE RICARDO WENDLING   \n",
       "3                                    APTO  MAURICIO WILKER DE AZEVEDO BARRETO   \n",
       "4                                    APTO        JADELVONE NOGUEIRA DELTRUDES   \n",
       "5                                    APTO           LILIANE ARAUJO DE ALMEIDA   \n",
       "6                                    APTO              REBECCA MARTINS GARCIA   \n",
       "7                                    APTO      MARCELO AUGUSTO DA EIRA CORREA   \n",
       "8                                    APTO            LUIZ CASTRO ANDRADE NETO   \n",
       "9                                    APTO            AMAZONINO ARMANDO MENDES   \n",
       "\n",
       "   ... total_votos_to total_votos_pa  total_votos_ms  total_votos_pi  \\\n",
       "0  ...              0              0               0               0   \n",
       "1  ...              0              0               0               0   \n",
       "2  ...              0              0               0               0   \n",
       "3  ...              0              0               0               0   \n",
       "4  ...              0              0               0               0   \n",
       "5  ...              0              0               0               0   \n",
       "6  ...              0              0               0               0   \n",
       "7  ...              0              0               0               0   \n",
       "8  ...              0              0               0               0   \n",
       "9  ...              0              0               0               0   \n",
       "\n",
       "   total_votos_ma  total_votos_df  total_votos_es  total_votos_rr  \\\n",
       "0               0               0               0               0   \n",
       "1               0               0               0               0   \n",
       "2               0               0               0               0   \n",
       "3               0               0               0               0   \n",
       "4               0               0               0               0   \n",
       "5               0               0               0               0   \n",
       "6               0               0               0               0   \n",
       "7               0               0               0               0   \n",
       "8               0               0               0               0   \n",
       "9               0               0               0               0   \n",
       "\n",
       "   total_votos_sc  total_votos  \n",
       "0               0       577397  \n",
       "1               0       377680  \n",
       "2               0       181257  \n",
       "3               0        22623  \n",
       "4               0         3362  \n",
       "5               0            0  \n",
       "6               0       268922  \n",
       "7               0        18877  \n",
       "8               0        39240  \n",
       "9               0       782933  \n",
       "\n",
       "[10 rows x 43 columns]"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_head = pd.read_sql_query('SELECT * FROM tb_votacao limit 10', con)\n",
    "df_head"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "modular-meter",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:04:15.921750Z",
     "start_time": "2021-01-30T20:04:07.537697Z"
    }
   },
   "outputs": [],
   "source": [
    "query = '''\n",
    "select \n",
    "    t1.ano_eleicao,\n",
    "    t1.sigla_partido,\n",
    "    t1.nome,\n",
    "    t1.numero_sequencial,\n",
    "    t2.valor\n",
    "from tb_votacao as t1\n",
    "left join tb_bens as t2\n",
    "on t1.ano_eleicao = t2.ano_eleicao\n",
    "and t1.descricao_eleicao  = t2.descricao_eleicao\n",
    "and t1.numero_sequencial  = t2.numero_sequencial\n",
    "\n",
    "where t1.numero_turno = 1\n",
    "\n",
    "group by t1.ano_eleicao,\n",
    "        t1.sigla_partido,\n",
    "        t1.nome,\n",
    "        t1.numero_sequencial\n",
    "'''\n",
    "df_resposta = pd.read_sql_query(query, con)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "capable-walnut",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:04:20.817284Z",
     "start_time": "2021-01-30T20:04:20.673655Z"
    }
   },
   "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>sigla_partido</th>\n",
       "      <th>valor</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014</td>\n",
       "      <td>DEM</td>\n",
       "      <td>12775706.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014</td>\n",
       "      <td>PC DO B</td>\n",
       "      <td>20719409.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014</td>\n",
       "      <td>PCB</td>\n",
       "      <td>2094590.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014</td>\n",
       "      <td>PCO</td>\n",
       "      <td>441150.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014</td>\n",
       "      <td>PDT</td>\n",
       "      <td>20689929.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>2018</td>\n",
       "      <td>PTB</td>\n",
       "      <td>22210520.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>2018</td>\n",
       "      <td>PTC</td>\n",
       "      <td>15806799.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>2018</td>\n",
       "      <td>PV</td>\n",
       "      <td>32957303.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>2018</td>\n",
       "      <td>REDE</td>\n",
       "      <td>29575929.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>2018</td>\n",
       "      <td>SOLIDARIEDADE</td>\n",
       "      <td>17276970.42</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>104 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     ano_eleicao  sigla_partido        valor\n",
       "0           2014            DEM  12775706.09\n",
       "1           2014        PC DO B  20719409.55\n",
       "2           2014            PCB   2094590.31\n",
       "3           2014            PCO    441150.00\n",
       "4           2014            PDT  20689929.52\n",
       "..           ...            ...          ...\n",
       "99          2018            PTB  22210520.08\n",
       "100         2018            PTC  15806799.19\n",
       "101         2018             PV  32957303.49\n",
       "102         2018           REDE  29575929.16\n",
       "103         2018  SOLIDARIEDADE  17276970.42\n",
       "\n",
       "[104 rows x 3 columns]"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_analisys = df_resposta.groupby(['ano_eleicao', 'sigla_partido'])['valor'].sum().reset_index()\n",
    "df_analisys"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "junior-blank",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:09:03.444111Z",
     "start_time": "2021-01-30T20:09:03.361110Z"
    }
   },
   "outputs": [],
   "source": [
    "df_analisys.to_sql('tb_patrimonio_partido', con, if_exists='replace', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "id": "rental-offset",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:05:15.601227Z",
     "start_time": "2021-01-30T20:05:15.578225Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['tb_bens', 'tb_candidatura', 'tb_patrimonio_partido', 'tb_votacao']"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "con.table_names()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "id": "north-shape",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-01-30T20:09:06.846712Z",
     "start_time": "2021-01-30T20:09:06.810714Z"
    }
   },
   "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>sigla_partido</th>\n",
       "      <th>valor</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014</td>\n",
       "      <td>DEM</td>\n",
       "      <td>12775706.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014</td>\n",
       "      <td>PC DO B</td>\n",
       "      <td>20719409.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014</td>\n",
       "      <td>PCB</td>\n",
       "      <td>2094590.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014</td>\n",
       "      <td>PCO</td>\n",
       "      <td>441150.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014</td>\n",
       "      <td>PDT</td>\n",
       "      <td>20689929.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2014</td>\n",
       "      <td>PEN</td>\n",
       "      <td>15092873.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2014</td>\n",
       "      <td>PHS</td>\n",
       "      <td>22821138.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2014</td>\n",
       "      <td>PMDB</td>\n",
       "      <td>25349487.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2014</td>\n",
       "      <td>PMN</td>\n",
       "      <td>14476563.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2014</td>\n",
       "      <td>PP</td>\n",
       "      <td>14927207.71</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ano_eleicao sigla_partido        valor\n",
       "0         2014           DEM  12775706.09\n",
       "1         2014       PC DO B  20719409.55\n",
       "2         2014           PCB   2094590.31\n",
       "3         2014           PCO    441150.00\n",
       "4         2014           PDT  20689929.52\n",
       "5         2014           PEN  15092873.61\n",
       "6         2014           PHS  22821138.97\n",
       "7         2014          PMDB  25349487.44\n",
       "8         2014           PMN  14476563.09\n",
       "9         2014            PP  14927207.71"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_head = pd.read_sql_query('SELECT * FROM tb_patrimonio_partido limit 10', con)\n",
    "df_head"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "stable-pittsburgh",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "zero-ao-ds",
   "language": "python",
   "name": "zero-ao-ds"
  },
  "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.9.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}