Skip to content

Instantly share code, notes, and snippets.

@nportinari

nportinari/pega-laranja.ipynb

Last active February 23, 2019 14:03
Show Gist options
  • Save nportinari/88f4a7c59a3866d8d7a2c08e39d0b0fa to your computer and use it in GitHub Desktop.
Save nportinari/88f4a7c59a3866d8d7a2c08e39d0b0fa to your computer and use it in GitHub Desktop.
Download ZIP
Pega-laranja
Display the source blob
Display the rendered blob
Raw
pega-laranja.ipynb
{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"name": "Pega-laranja",
"version": "0.3.2",
"provenance": [],
"include_colab_link": true
},
"kernelspec": {
"name": "python3",
"display_name": "Python 3"
}
},
"cells": [
{
"cell_type": "markdown",
"metadata": {
"id": "view-in-github",
"colab_type": "text"
},
"source": [
"<a href=\"https://colab.research.google.com/gist/nportinari/88f4a7c59a3866d8d7a2c08e39d0b0fa/pega-laranja.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
]
},
{
"metadata": {
"id": "xvsd1HDHaqzX",
"colab_type": "code",
"outputId": "f60d11b4-f236-431b-8d54-c2edb8da5669",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 70
}
},
"cell_type": "code",
"source": [
"import pandas as pd\n",
"import seaborn as sb\n",
"import numpy as np\n",
"import matplotlib.pyplot as plt\n",
"import io\n",
"\n",
"get_ipython().run_line_magic('matplotlib', 'inline')\n",
"low_memory = False\n",
"\n",
"pd.options.display.max_columns = 80\n",
"pd.options.display.max_rows = 90\n",
"\n",
"!pip install -U -q PyDrive \n",
"\n",
"from pydrive.auth import GoogleAuth\n",
"from pydrive.drive import GoogleDrive\n",
"from google.colab import auth\n",
"from oauth2client.client import GoogleCredentials\n",
"\n",
"auth.authenticate_user()\n",
"gauth = GoogleAuth()\n",
"gauth.credentials = GoogleCredentials.get_application_default()\n",
"drive = GoogleDrive(gauth)\n",
"\n",
"pd.options.display.float_format = \"{:.2f}\".format\n",
"!pip install xlrd"
],
"execution_count": 1,
"outputs": [
{
"output_type": "stream",
"text": [
"\u001b[?25l\r\u001b[K 1% |▎ | 10kB 20.3MB/s eta 0:00:01\r\u001b[K 2% |▋ | 20kB 1.9MB/s eta 0:00:01\r\u001b[K 3% |█ | 30kB 2.8MB/s eta 0:00:01\r\u001b[K 4% |█▎ | 40kB 1.8MB/s eta 0:00:01\r\u001b[K 5% |█▋ | 51kB 2.2MB/s eta 0:00:01\r\u001b[K 6% |██ | 61kB 2.6MB/s eta 0:00:01\r\u001b[K 7% |██▎ | 71kB 3.0MB/s eta 0:00:01\r\u001b[K 8% |██▋ | 81kB 3.4MB/s eta 0:00:01\r\u001b[K 9% |███ | 92kB 3.8MB/s eta 0:00:01\r\u001b[K 10% |███▎ | 102kB 2.9MB/s eta 0:00:01\r\u001b[K 11% |███▋ | 112kB 3.0MB/s eta 0:00:01\r\u001b[K 12% |████ | 122kB 4.2MB/s eta 0:00:01\r\u001b[K 13% |████▎ | 133kB 4.2MB/s eta 0:00:01\r\u001b[K 14% |████▋ | 143kB 8.0MB/s eta 0:00:01\r\u001b[K 15% |█████ | 153kB 8.1MB/s eta 0:00:01\r\u001b[K 16% |█████▎ | 163kB 8.1MB/s eta 0:00:01\r\u001b[K 17% |█████▋ | 174kB 7.9MB/s eta 0:00:01\r\u001b[K 18% |██████ | 184kB 7.9MB/s eta 0:00:01\r\u001b[K 19% |██████▎ | 194kB 8.0MB/s eta 0:00:01\r\u001b[K 20% |██████▋ | 204kB 8.5MB/s eta 0:00:01\r\u001b[K 21% |███████ | 215kB 8.4MB/s eta 0:00:01\r\u001b[K 22% |███████▎ | 225kB 8.4MB/s eta 0:00:01\r\u001b[K 23% |███████▋ | 235kB 8.4MB/s eta 0:00:01\r\u001b[K 24% |████████ | 245kB 8.4MB/s eta 0:00:01\r\u001b[K 25% |████████▎ | 256kB 8.4MB/s eta 0:00:01\r\u001b[K 26% |████████▋ | 266kB 8.2MB/s eta 0:00:01\r\u001b[K 27% |█████████ | 276kB 8.4MB/s eta 0:00:01\r\u001b[K 29% |█████████▎ | 286kB 8.4MB/s eta 0:00:01\r\u001b[K 30% |█████████▋ | 296kB 8.4MB/s eta 0:00:01\r\u001b[K 31% |██████████ | 307kB 45.0MB/s eta 0:00:01\r\u001b[K 32% |██████████▎ | 317kB 49.3MB/s eta 0:00:01\r\u001b[K 33% |██████████▋ | 327kB 50.7MB/s eta 0:00:01\r\u001b[K 34% |███████████ | 337kB 53.3MB/s eta 0:00:01\r\u001b[K 35% |███████████▎ | 348kB 49.5MB/s eta 0:00:01\r\u001b[K 36% |███████████▋ | 358kB 49.1MB/s eta 0:00:01\r\u001b[K 37% |████████████ | 368kB 58.3MB/s eta 0:00:01\r\u001b[K 38% |████████████▎ | 378kB 60.0MB/s eta 0:00:01\r\u001b[K 39% |████████████▋ | 389kB 61.1MB/s eta 0:00:01\r\u001b[K 40% |█████████████ | 399kB 61.0MB/s eta 0:00:01\r\u001b[K 41% |█████████████▎ | 409kB 60.9MB/s eta 0:00:01\r\u001b[K 42% |█████████████▋ | 419kB 62.4MB/s eta 0:00:01\r\u001b[K 43% |██████████████ | 430kB 10.3MB/s eta 0:00:01\r\u001b[K 44% |██████████████▎ | 440kB 10.1MB/s eta 0:00:01\r\u001b[K 45% |██████████████▋ | 450kB 10.1MB/s eta 0:00:01\r\u001b[K 46% |███████████████ | 460kB 10.1MB/s eta 0:00:01\r\u001b[K 47% |███████████████▎ | 471kB 10.1MB/s eta 0:00:01\r\u001b[K 48% |███████████████▋ | 481kB 10.1MB/s eta 0:00:01\r\u001b[K 49% |████████████████ | 491kB 10.1MB/s eta 0:00:01\r\u001b[K 50% |████████████████▎ | 501kB 10.1MB/s eta 0:00:01\r\u001b[K 51% |████████████████▋ | 512kB 9.9MB/s eta 0:00:01\r\u001b[K 52% |█████████████████ | 522kB 9.9MB/s eta 0:00:01\r\u001b[K 53% |█████████████████▎ | 532kB 50.5MB/s eta 0:00:01\r\u001b[K 54% |█████████████████▋ | 542kB 54.1MB/s eta 0:00:01\r\u001b[K 55% |██████████████████ | 552kB 65.1MB/s eta 0:00:01\r\u001b[K 57% |██████████████████▎ | 563kB 68.6MB/s eta 0:00:01\r\u001b[K 58% |██████████████████▋ | 573kB 68.2MB/s eta 0:00:01\r\u001b[K 59% |███████████████████ | 583kB 69.3MB/s eta 0:00:01\r\u001b[K 60% |███████████████████▎ | 593kB 70.6MB/s eta 0:00:01\r\u001b[K 61% |███████████████████▋ | 604kB 70.9MB/s eta 0:00:01\r\u001b[K 62% |████████████████████ | 614kB 86.2MB/s eta 0:00:01\r\u001b[K 63% |████████████████████▎ | 624kB 11.1MB/s eta 0:00:01\r\u001b[K 64% |████████████████████▋ | 634kB 10.9MB/s eta 0:00:01\r\u001b[K 65% |█████████████████████ | 645kB 10.9MB/s eta 0:00:01\r\u001b[K 66% |█████████████████████▎ | 655kB 10.8MB/s eta 0:00:01\r\u001b[K 67% |█████████████████████▋ | 665kB 10.0MB/s eta 0:00:01\r\u001b[K 68% |██████████████████████ | 675kB 9.9MB/s eta 0:00:01\r\u001b[K 69% |██████████████████████▎ | 686kB 9.8MB/s eta 0:00:01\r\u001b[K 70% |██████████████████████▋ | 696kB 9.7MB/s eta 0:00:01\r\u001b[K 71% |███████████████████████ | 706kB 9.6MB/s eta 0:00:01\r\u001b[K 72% |███████████████████████▎ | 716kB 9.6MB/s eta 0:00:01\r\u001b[K 73% |███████████████████████▋ | 727kB 38.9MB/s eta 0:00:01\r\u001b[K 74% |████████████████████████ | 737kB 41.0MB/s eta 0:00:01\r\u001b[K 75% |████████████████████████▎ | 747kB 41.3MB/s eta 0:00:01\r\u001b[K 76% |████████████████████████▋ | 757kB 41.4MB/s eta 0:00:01\r\u001b[K 77% |████████████████████████▉ | 768kB 60.5MB/s eta 0:00:01\r\u001b[K 78% |█████████████████████████▏ | 778kB 65.3MB/s eta 0:00:01\r\u001b[K 79% |█████████████████████████▌ | 788kB 67.2MB/s eta 0:00:01\r\u001b[K 80% |█████████████████████████▉ | 798kB 71.8MB/s eta 0:00:01\r\u001b[K 81% |██████████████████████████▏ | 808kB 76.4MB/s eta 0:00:01\r\u001b[K 82% |██████████████████████████▌ | 819kB 76.7MB/s eta 0:00:01\r\u001b[K 83% |██████████████████████████▉ | 829kB 77.6MB/s eta 0:00:01\r\u001b[K 85% |███████████████████████████▏ | 839kB 77.8MB/s eta 0:00:01\r\u001b[K 86% |███████████████████████████▌ | 849kB 79.5MB/s eta 0:00:01\r\u001b[K 87% |███████████████████████████▉ | 860kB 65.4MB/s eta 0:00:01\r\u001b[K 88% |████████████████████████████▏ | 870kB 63.6MB/s eta 0:00:01\r\u001b[K 89% |████████████████████████████▌ | 880kB 64.0MB/s eta 0:00:01\r\u001b[K 90% |████████████████████████████▉ | 890kB 63.1MB/s eta 0:00:01\r\u001b[K 91% |█████████████████████████████▏ | 901kB 63.3MB/s eta 0:00:01\r\u001b[K 92% |█████████████████████████████▌ | 911kB 63.8MB/s eta 0:00:01\r\u001b[K 93% |█████████████████████████████▉ | 921kB 63.0MB/s eta 0:00:01\r\u001b[K 94% |██████████████████████████████▏ | 931kB 62.8MB/s eta 0:00:01\r\u001b[K 95% |██████████████████████████████▌ | 942kB 63.8MB/s eta 0:00:01\r\u001b[K 96% |██████████████████████████████▉ | 952kB 63.0MB/s eta 0:00:01\r\u001b[K 97% |███████████████████████████████▏| 962kB 78.8MB/s eta 0:00:01\r\u001b[K 98% |███████████████████████████████▌| 972kB 79.0MB/s eta 0:00:01\r\u001b[K 99% |███████████████████████████████▉| 983kB 78.5MB/s eta 0:00:01\r\u001b[K 100% |████████████████████████████████| 993kB 13.8MB/s \n",
"\u001b[?25h Building wheel for PyDrive (setup.py) ... \u001b[?25ldone\n",
"\u001b[?25hRequirement already satisfied: xlrd in /usr/local/lib/python3.6/dist-packages (1.1.0)\n"
],
"name": "stdout"
}
]
},
{
"metadata": {
"id": "c7zE4FL0rjFy",
"colab_type": "text"
},
"cell_type": "markdown",
"source": [
"# **Candidatos 2014 e 2018**"
]
},
{
"metadata": {
"id": "zkBmVyGYrh3L",
"colab_type": "code",
"outputId": "49cf936b-e602-4397-c1b6-561cd3995aa4",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 73
}
},
"cell_type": "code",
"source": [
"cand2014 = drive.CreateFile({'id':'10r-vdQfKU7zAYNPeHl_9EF25NheIBpE5'})\n",
"cand2014.GetContentFile('cand2014')\n",
"cand2014 = pd.read_csv('cand2014', encoding = 'latin-1', error_bad_lines=False, delimiter = ';')\n",
"\n",
"cand2018 = drive.CreateFile({'id':'165fziX3_TayzsqpggJyILWSjyHfS50zE'})\n",
"cand2018.GetContentFile('cand2018')\n",
"cand2018 = pd.read_csv('cand2018', encoding = 'utf-8', error_bad_lines=False, delimiter = ';')"
],
"execution_count": 2,
"outputs": [
{
"output_type": "stream",
"text": [
"/usr/local/lib/python3.6/dist-packages/IPython/core/interactiveshell.py:2718: DtypeWarning: Columns (16,17,18,19,21,22,23,25,26,27,28,29,30,32,33,34,36,37,50,51,52,55,56,57,58) have mixed types. Specify dtype option on import or set low_memory=False.\n",
" interactivity=interactivity, compiler=compiler, result=result)\n"
],
"name": "stderr"
}
]
},
{
"metadata": {
"id": "IxfPGGGqvodW",
"colab_type": "code",
"outputId": "3365f14a-d89e-4402-e539-b675639cc94d",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 201
}
},
"cell_type": "code",
"source": [
"cand2018[['NR_CPF_CANDIDATO']].head(5)"
],
"execution_count": 3,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>NR_CPF_CANDIDATO</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>27896439549.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>36427721534.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>54600146620.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>3669784543.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5875488514.00</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" NR_CPF_CANDIDATO\n",
"0 27896439549.00\n",
"1 36427721534.00\n",
"2 54600146620.00\n",
"3 3669784543.00\n",
"4 5875488514.00"
]
},
"metadata": {
"tags": []
},
"execution_count": 3
}
]
},
{
"metadata": {
"id": "1pDlt31OsyQp",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"#cand2018.NR_CPF_CANDIDATO = cand2018.NR_CPF_CANDIDATO.astype(int, errors = 'ignore')\n",
"#cand2018.NR_CPF_CANDIDATO = cand2018.NR_CPF_CANDIDATO.replace('.0','')"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "wc26xXQXZxNv",
"colab_type": "code",
"outputId": "e42b7438-73af-4060-8de5-1549c53e82de",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 168
}
},
"cell_type": "code",
"source": [
"cand2018.head(1)"
],
"execution_count": 5,
"outputs": [
{
"output_type": "execute_result",
"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>Unnamed: 0</th>\n",
" <th>ANO_ELEICAO</th>\n",
" <th>CD_CARGO</th>\n",
" <th>CD_COR_RACA</th>\n",
" <th>CD_DETALHE_SITUACAO_CAND</th>\n",
" <th>CD_ELEICAO</th>\n",
" <th>CD_ESTADO_CIVIL</th>\n",
" <th>CD_GENERO</th>\n",
" <th>CD_GRAU_INSTRUCAO</th>\n",
" <th>CD_MUNICIPIO_NASCIMENTO</th>\n",
" <th>CD_NACIONALIDADE</th>\n",
" <th>CD_OCUPACAO</th>\n",
" <th>CD_SITUACAO_CANDIDATURA</th>\n",
" <th>CD_SIT_TOT_TURNO</th>\n",
" <th>CD_TIPO_ELEICAO</th>\n",
" <th>DS_CARGO</th>\n",
" <th>DS_COMPOSICAO_COLIGACAO</th>\n",
" <th>DS_COR_RACA</th>\n",
" <th>DS_DETALHE_SITUACAO_CAND</th>\n",
" <th>DS_ELEICAO</th>\n",
" <th>DS_ESTADO_CIVIL</th>\n",
" <th>DS_GENERO</th>\n",
" <th>DS_GRAU_INSTRUCAO</th>\n",
" <th>DS_NACIONALIDADE</th>\n",
" <th>DS_OCUPACAO</th>\n",
" <th>DS_SITUACAO_CANDIDATURA</th>\n",
" <th>DS_SIT_TOT_TURNO</th>\n",
" <th>DT_ELEICAO</th>\n",
" <th>DT_GERACAO</th>\n",
" <th>DT_NASCIMENTO</th>\n",
" <th>HH_GERACAO</th>\n",
" <th>NM_CANDIDATO</th>\n",
" <th>NM_COLIGACAO</th>\n",
" <th>NM_EMAIL</th>\n",
" <th>NM_MUNICIPIO_NASCIMENTO</th>\n",
" <th>NM_PARTIDO</th>\n",
" <th>NM_SOCIAL_CANDIDATO</th>\n",
" <th>NM_TIPO_ELEICAO</th>\n",
" <th>NM_UE</th>\n",
" <th>NM_URNA_CANDIDATO</th>\n",
" <th>NR_CANDIDATO</th>\n",
" <th>NR_CPF_CANDIDATO</th>\n",
" <th>NR_DESPESA_MAX_CAMPANHA</th>\n",
" <th>NR_IDADE_DATA_POSSE</th>\n",
" <th>NR_PARTIDO</th>\n",
" <th>NR_PROCESSO</th>\n",
" <th>NR_PROTOCOLO_CANDIDATURA</th>\n",
" <th>NR_TITULO_ELEITORAL_CANDIDATO</th>\n",
" <th>NR_TURNO</th>\n",
" <th>SG_PARTIDO</th>\n",
" <th>SG_UE</th>\n",
" <th>SG_UF</th>\n",
" <th>SG_UF_NASCIMENTO</th>\n",
" <th>SQ_CANDIDATO</th>\n",
" <th>SQ_COLIGACAO</th>\n",
" <th>ST_DECLARAR_BENS</th>\n",
" <th>ST_REELEICAO</th>\n",
" <th>TP_ABRANGENCIA</th>\n",
" <th>TP_AGREMIACAO</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0</td>\n",
" <td>2018.00</td>\n",
" <td>6.00</td>\n",
" <td>1.00</td>\n",
" <td>8.00</td>\n",
" <td>297.00</td>\n",
" <td>3.00</td>\n",
" <td>4.00</td>\n",
" <td>6.00</td>\n",
" <td>-3.00</td>\n",
" <td>1.00</td>\n",
" <td>999.00</td>\n",
" <td>1.00</td>\n",
" <td>-1.00</td>\n",
" <td>2.00</td>\n",
" <td>DEPUTADO FEDERAL</td>\n",
" <td>DEM / PRB / PV</td>\n",
" <td>BRANCA</td>\n",
" <td>AGUARDANDO JULGAMENTO</td>\n",
" <td>Eleições Gerais Estaduais 2018</td>\n",
" <td>CASADO(A)</td>\n",
" <td>FEMININO</td>\n",
" <td>ENSINO MÉDIO COMPLETO</td>\n",
" <td>BRASILEIRA NATA</td>\n",
" <td>OUTROS</td>\n",
" <td>CADASTRADO</td>\n",
" <td>#NULO#</td>\n",
" <td>07/10/2018</td>\n",
" <td>27/08/2018</td>\n",
" <td>16/01/1958</td>\n",
" <td>08:02:40</td>\n",
" <td>ANTONIA MAGALHÃES DA CRUZ</td>\n",
" <td>UNIDOS PARA MUDAR A BAHIA</td>\n",
" <td>ANTONIAMAGALHAES11@GMAIL.COM</td>\n",
" <td>SÃO FELIPE</td>\n",
" <td>DEMOCRATAS</td>\n",
" <td>#NULO#</td>\n",
" <td>ELEIÇÃO ORDINÁRIA</td>\n",
" <td>BAHIA</td>\n",
" <td>TONHA MAGALHÃES</td>\n",
" <td>2522.00</td>\n",
" <td>27896439549.00</td>\n",
" <td>-1.00</td>\n",
" <td>61.00</td>\n",
" <td>25.00</td>\n",
" <td>6012450000000000000.00</td>\n",
" <td>-1.00</td>\n",
" <td>33773240566.00</td>\n",
" <td>1.00</td>\n",
" <td>DEM</td>\n",
" <td>BA</td>\n",
" <td>BA</td>\n",
" <td>BA</td>\n",
" <td>50000608647.00</td>\n",
" <td>50000050223.00</td>\n",
" <td>N</td>\n",
" <td>N</td>\n",
" <td>ESTADUAL</td>\n",
" <td>COLIGAÇÃO</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Unnamed: 0 ANO_ELEICAO CD_CARGO CD_COR_RACA CD_DETALHE_SITUACAO_CAND \\\n",
"0 0 2018.00 6.00 1.00 8.00 \n",
"\n",
" CD_ELEICAO CD_ESTADO_CIVIL CD_GENERO CD_GRAU_INSTRUCAO \\\n",
"0 297.00 3.00 4.00 6.00 \n",
"\n",
" CD_MUNICIPIO_NASCIMENTO CD_NACIONALIDADE CD_OCUPACAO \\\n",
"0 -3.00 1.00 999.00 \n",
"\n",
" CD_SITUACAO_CANDIDATURA CD_SIT_TOT_TURNO CD_TIPO_ELEICAO \\\n",
"0 1.00 -1.00 2.00 \n",
"\n",
" DS_CARGO DS_COMPOSICAO_COLIGACAO DS_COR_RACA \\\n",
"0 DEPUTADO FEDERAL DEM / PRB / PV BRANCA \n",
"\n",
" DS_DETALHE_SITUACAO_CAND DS_ELEICAO DS_ESTADO_CIVIL \\\n",
"0 AGUARDANDO JULGAMENTO Eleições Gerais Estaduais 2018 CASADO(A) \n",
"\n",
" DS_GENERO DS_GRAU_INSTRUCAO DS_NACIONALIDADE DS_OCUPACAO \\\n",
"0 FEMININO ENSINO MÉDIO COMPLETO BRASILEIRA NATA OUTROS \n",
"\n",
" DS_SITUACAO_CANDIDATURA DS_SIT_TOT_TURNO DT_ELEICAO DT_GERACAO \\\n",
"0 CADASTRADO #NULO# 07/10/2018 27/08/2018 \n",
"\n",
" DT_NASCIMENTO HH_GERACAO NM_CANDIDATO \\\n",
"0 16/01/1958 08:02:40 ANTONIA MAGALHÃES DA CRUZ \n",
"\n",
" NM_COLIGACAO NM_EMAIL \\\n",
"0 UNIDOS PARA MUDAR A BAHIA ANTONIAMAGALHAES11@GMAIL.COM \n",
"\n",
" NM_MUNICIPIO_NASCIMENTO NM_PARTIDO NM_SOCIAL_CANDIDATO NM_TIPO_ELEICAO \\\n",
"0 SÃO FELIPE DEMOCRATAS #NULO# ELEIÇÃO ORDINÁRIA \n",
"\n",
" NM_UE NM_URNA_CANDIDATO NR_CANDIDATO NR_CPF_CANDIDATO \\\n",
"0 BAHIA TONHA MAGALHÃES 2522.00 27896439549.00 \n",
"\n",
" NR_DESPESA_MAX_CAMPANHA NR_IDADE_DATA_POSSE NR_PARTIDO \\\n",
"0 -1.00 61.00 25.00 \n",
"\n",
" NR_PROCESSO NR_PROTOCOLO_CANDIDATURA \\\n",
"0 6012450000000000000.00 -1.00 \n",
"\n",
" NR_TITULO_ELEITORAL_CANDIDATO NR_TURNO SG_PARTIDO SG_UE SG_UF \\\n",
"0 33773240566.00 1.00 DEM BA BA \n",
"\n",
" SG_UF_NASCIMENTO SQ_CANDIDATO SQ_COLIGACAO ST_DECLARAR_BENS \\\n",
"0 BA 50000608647.00 50000050223.00 N \n",
"\n",
" ST_REELEICAO TP_ABRANGENCIA TP_AGREMIACAO \n",
"0 N ESTADUAL COLIGAÇÃO "
]
},
"metadata": {
"tags": []
},
"execution_count": 5
}
]
},
{
"metadata": {
"id": "d5Ik6rZpKrFF",
"colab_type": "text"
},
"cell_type": "markdown",
"source": [
"# **Despesas 2018**"
]
},
{
"metadata": {
"id": "3a64_7VifBHc",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"#Despesas pagas e contratadas de 2018 (por candidato).\n",
"\n",
"cod18cont = ['137arallRrhcgYg9YGHtHKcSWbxleAqcM',\n",
"'1CR6nNwkC-YSInNUtkT_ryEAUhEzQQL7N',\n",
"'1G6s3MEr52HyN0b6mIl2hodC5232TN1zL',\n",
"'1spc3gebJ3oTkKMM1no93zMwRBGioEUP1',\n",
"'1stxjd2DL_e-_4GjIYv9vowSc9I5MZATY',\n",
"'1lzZ7sixHR8n2pTxtgVft-J5g6-EUtYiM',\n",
"'1IodfHJVT_0CgoYdXJOU7g-pDhXlNSWDu',\n",
"'1ScaQvhEB4pRXWou7ZwSgB-XB9HOOvKU4',\n",
"'1nrw3yNdcz9xlHuh1VXBxdXFJxbyvN4JQ',\n",
"'1LGgN3EaqCRPNPvz6zHOYHjlk9hC1PSIH',\n",
"'1XNDEv5ZESB01S7L32C5NlrQ3t1GC8TpS',\n",
"'15AzfhKXNUmAinxgv8xxjFGfICqyk0hct',\n",
"'1du5tMD8JqCw9xCVH2OZ2VqBmU69J3Zsb',\n",
"'1nA2CPLttFy1VdUKfLX5AfxnNMFaFAw5-',\n",
"'1Y7_gjqtteeWRzYGqhGYBSnEYaX9kbfLU',\n",
"'1laRghfZqqyfvKKV-D2sG7hGE_9e5EytR',\n",
"'17kUiO82KARQteVJ2JuAGT6xrqIF5DC_Q',\n",
"'1V2y4OGgOSErkOO2WlvL_MA24grb_B7K6',\n",
"'18nYV-cJ_XL1RYxzy3KDO3cn0HFK7k2cF',\n",
"'16IKKHJ3Oj0x0zzo-55l3RZ6Ux3AxXSF3',\n",
"'1U1kGaWuO24kYwzXszGHsD4jE9Adkb1tp',\n",
"'1W0pnwzs6E-aNxszlh7FWVIUFU6aAV8aT',\n",
"'1e-z7EFzCDAfCcnhS9ROXpSNEqShYt8LG',\n",
"'1V4H0a2hbz2UZO5kxlUEUMazM-DYo5V7e',\n",
"'1BhQn712U61HK3Br-yRRivygZuiMx35dK',\n",
"'1QsO1UZDUiCdTGgDPfsWcROtH5jlAzgKi',\n",
"'1byudnohBBd21n7j_HoSWbAp1dmMlyycL',\n",
"'1a9fFWNN16lVwfYSwrkvNfr088GZAeVJf']\n",
"\n",
"cod18pg = ['1MO4jeOEYGoGdZOWIrHm-n3fJoATUeHHf',\n",
"'13927VOlcY89aLJTTBAOsx5IUEmKDAx3Z',\n",
"'1sj93ywzP10tsBWRPaYgXv2alII9b4qcg',\n",
"'15bowYZ5GZ72hPw7ppvdqXC41ePGu0ONH',\n",
"'19FWBVAHm9ySpUS7QS2FX-VMWTZ7BgPH_',\n",
"'1kdDaJ-NzfgIebyf3MCMIkFm8wgyAI4A4',\n",
"'1G_bX7tO3wnWYAwt9NWVOk1wkbZK2kuSG',\n",
"'1Pl5i0F2cOFitSBhxMZnCVrnbp3A8NZL8',\n",
"'1cdawBzjyxn6FhqjGOns8kX7y51dU2Z5f',\n",
"'1yYO-jRfFX570Sc4mR7tvbbS_8pfUEec9',\n",
"'1hh3yTgBSpM5M1etrNQCzq_ZqNajmqNSM',\n",
"'1qEMFhYMrTSPcYB6uG2-Hs5WkiAG5zst5',\n",
"'1LgMRp66sJGFEv9fraizq33Srh21LBDcI',\n",
"'1N7k_vf5YivYUcqL7FVN_VfsQhY1bb6wC',\n",
"'175AhvFERpzG66oDS0_RIHd7-fduVpxhw',\n",
"'1HKa1HAzO-KUUeAp-v32DgyFSfiXSGfP0',\n",
"'1Yr3zCiCILn9VP41znYxGnlyIW6GfAt5i',\n",
"'1jzbW31HUPA__Nw-o-8NFgDg-s2SNBGey',\n",
"'10OnrETyJwD5Qt-BmQ5d7q0gwu-wMb3K4',\n",
"'124EFE5rk26wdwhEtVUEnugf2f90ZBxSU',\n",
"'1U2sj0d1SEHpFsTe3_vb2FoliUET3O3fe',\n",
"'1m4WYEAuaD3SuPVIT3cpnVWNgq7A4-Oud',\n",
"'1gRAAmZxRgshSK973UVbessA_p3giUycg',\n",
"'1eyQ1as8jhB5UomTdetG5FerqawHnKPAB',\n",
"'1wwCMSPqtj9YKBBrM5J793ThRE8jXAg3O',\n",
"'1ydfLMUUpY2VSqb-vRe8HA2HZXLANxQTU',\n",
"'1dcG1qjtVendXB_JFLO5ZSHUuEtPti59W',\n",
"'1i4_H0rcaGP5o_SFp8bch_Xi2ZqIALz1Z']"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "BhOQux1slvo8",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"df = drive.CreateFile({'id':'1isoBv5PzWSqmbJPAdTaiKLUvYEaOB3Lk'}) \n",
"df.GetContentFile('df')\n",
"df18cont = pd.read_csv('df', encoding = 'latin-1', error_bad_lines=False, delimiter = ';')\n",
"\n",
"for cod in cod18cont:\n",
" uf = drive.CreateFile({'id':cod})\n",
" uf.GetContentFile('uf')\n",
" uf = pd.read_csv('uf', encoding = 'latin-1', error_bad_lines=False, delimiter = ';')\n",
" df18cont = df18cont.merge(uf, how='outer')"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "wIcuYlD9vVul",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"df = drive.CreateFile({'id':'1qVrZrCp7HzTgtYgMV0bTIt0x_Sk7L6jw'}) \n",
"df.GetContentFile('df')\n",
"df18pg = pd.read_csv('df', encoding = 'latin-1', error_bad_lines=False, delimiter = ';')\n",
" \n",
"for cod in cod18pg:\n",
" uf = drive.CreateFile({'id':cod})\n",
" uf.GetContentFile('uf')\n",
" uf = pd.read_csv('uf', encoding = 'latin-1', error_bad_lines=False, delimiter = ';')\n",
" df18pg = df18pg.merge(uf, how='outer') "
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "_DInXxsZX2IH",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"df18cont['VR_DESPESA_CONTRATADA'] = df18cont['VR_DESPESA_CONTRATADA'].str.replace(',','.')\n",
"df18cont['VR_DESPESA_CONTRATADA'] = df18cont['VR_DESPESA_CONTRATADA'].astype(float)\n",
"\n",
"#O df18pg não tem a coluna \"nome do candidato\"; precisa cruzar para descobrir quem é o candidato que pagou\n",
"df18cont['NM_CANDIDATO'] = df18cont['NM_CANDIDATO'].str.normalize('NFKD').str.encode('ascii', errors='ignore').str.decode('utf-8')"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "CJSIdRNgFZI_",
"colab_type": "code",
"outputId": "f8b9c52e-ccdd-429c-bfa1-0afef8c69352",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 35
}
},
"cell_type": "code",
"source": [
"df18pg['VR_PAGTO_DESPESA'] = df18pg['VR_PAGTO_DESPESA'].str.replace(',','.')\n",
"df18pg['VR_PAGTO_DESPESA'] = df18pg['VR_PAGTO_DESPESA'].astype(float)\n",
"df18pg['VR_PAGTO_DESPESA'].sum()"
],
"execution_count": 10,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"2991250718.909998"
]
},
"metadata": {
"tags": []
},
"execution_count": 10
}
]
},
{
"metadata": {
"id": "PMsUxm2bENlX",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"nomes_pg = df18cont.groupby(['SQ_PRESTADOR_CONTAS','NM_CANDIDATO']).sum().reset_index()[['SQ_PRESTADOR_CONTAS','NM_CANDIDATO']]\n",
"cpfs_pg = df18cont.groupby(['SQ_PRESTADOR_CONTAS','NR_CPF_CANDIDATO']).sum().reset_index()[['SQ_PRESTADOR_CONTAS','NR_CPF_CANDIDATO']]\n",
"partidos_pg = df18cont.groupby(['SQ_PRESTADOR_CONTAS','SG_PARTIDO']).sum().reset_index()[['SQ_PRESTADOR_CONTAS','SG_PARTIDO']]"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "1FQ5fFf_EzYh",
"colab_type": "code",
"outputId": "6bf33f22-a839-40fe-b95d-afc925eed7c3",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 445
}
},
"cell_type": "code",
"source": [
"nomes_dic = nomes_pg.set_index('SQ_PRESTADOR_CONTAS')['NM_CANDIDATO'].to_dict()\n",
"cpfs_dic = cpfs_pg.set_index('SQ_PRESTADOR_CONTAS')['NR_CPF_CANDIDATO'].to_dict()\n",
"partidos_dic = partidos_pg.set_index('SQ_PRESTADOR_CONTAS')['SG_PARTIDO'].to_dict()\n",
"\n",
"\n",
"df18pg['NM_CANDIDATO'] = df18pg['SQ_PRESTADOR_CONTAS'].map(nomes_dic)\n",
"df18pg['NR_CPF_CANDIDATO'] = df18pg['SQ_PRESTADOR_CONTAS'].map(cpfs_dic)\n",
"df18pg['SG_PARTIDO'] = df18pg['SQ_PRESTADOR_CONTAS'].map(partidos_dic)\n",
"\n",
"df18pg.head(5)"
],
"execution_count": 12,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>DT_GERACAO</th>\n",
" <th>HH_GERACAO</th>\n",
" <th>ANO_ELEICAO</th>\n",
" <th>CD_TIPO_ELEICAO</th>\n",
" <th>NM_TIPO_ELEICAO</th>\n",
" <th>CD_ELEICAO</th>\n",
" <th>DS_ELEICAO</th>\n",
" <th>DT_ELEICAO</th>\n",
" <th>ST_TURNO</th>\n",
" <th>TP_PRESTACAO_CONTAS</th>\n",
" <th>DT_PRESTACAO_CONTAS</th>\n",
" <th>SQ_PRESTADOR_CONTAS</th>\n",
" <th>SG_UF</th>\n",
" <th>DS_TIPO_DOCUMENTO</th>\n",
" <th>NR_DOCUMENTO</th>\n",
" <th>CD_FONTE_DESPESA</th>\n",
" <th>DS_FONTE_DESPESA</th>\n",
" <th>CD_ORIGEM_DESPESA</th>\n",
" <th>DS_ORIGEM_DESPESA</th>\n",
" <th>CD_NATUREZA_DESPESA</th>\n",
" <th>DS_NATUREZA_DESPESA</th>\n",
" <th>CD_ESPECIE_RECURSO</th>\n",
" <th>DS_ESPECIE_RECURSO</th>\n",
" <th>SQ_DESPESA</th>\n",
" <th>SQ_PARCELAMENTO_DESPESA</th>\n",
" <th>DT_PAGTO_DESPESA</th>\n",
" <th>DS_DESPESA</th>\n",
" <th>VR_PAGTO_DESPESA</th>\n",
" <th>NM_CANDIDATO</th>\n",
" <th>NR_CPF_CANDIDATO</th>\n",
" <th>SG_PARTIDO</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>406838759</td>\n",
" <td>ES</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>1</td>\n",
" <td>Outros Recursos</td>\n",
" <td>20210000</td>\n",
" <td>Encargos financeiros, taxas bancárias e/ou op....</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>22662971</td>\n",
" <td>14731017</td>\n",
" <td>14/08/2018</td>\n",
" <td>Encargos financeiros, taxas bancárias e/ou op....</td>\n",
" <td>13.20</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE</td>\n",
" <td>88961117734</td>\n",
" <td>NOVO</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>406838759</td>\n",
" <td>ES</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>850006</td>\n",
" <td>1</td>\n",
" <td>Outros Recursos</td>\n",
" <td>20140000</td>\n",
" <td>Publicidade por materiais impressos</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>22662978</td>\n",
" <td>14731028</td>\n",
" <td>24/09/2018</td>\n",
" <td>Publicidade por materiais impressos</td>\n",
" <td>450.00</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE</td>\n",
" <td>88961117734</td>\n",
" <td>NOVO</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>406838759</td>\n",
" <td>ES</td>\n",
" <td>Duplicata</td>\n",
" <td>100201</td>\n",
" <td>1</td>\n",
" <td>Outros Recursos</td>\n",
" <td>20420000</td>\n",
" <td>Despesa com Impulsionamento de Conteúdos</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>22662982</td>\n",
" <td>14731024</td>\n",
" <td>02/10/2018</td>\n",
" <td>Despesa com Impulsionamento de Conteúdos</td>\n",
" <td>747.34</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE</td>\n",
" <td>88961117734</td>\n",
" <td>NOVO</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>406838759</td>\n",
" <td>ES</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>92601</td>\n",
" <td>1</td>\n",
" <td>Outros Recursos</td>\n",
" <td>20260000</td>\n",
" <td>Criação e inclusão de páginas na internet</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>22662975</td>\n",
" <td>14731030</td>\n",
" <td>28/09/2018</td>\n",
" <td>Criação e inclusão de páginas na internet</td>\n",
" <td>297.00</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE</td>\n",
" <td>88961117734</td>\n",
" <td>NOVO</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>406838759</td>\n",
" <td>ES</td>\n",
" <td>Outro</td>\n",
" <td>#NULO#</td>\n",
" <td>1</td>\n",
" <td>Outros Recursos</td>\n",
" <td>20410000</td>\n",
" <td>Taxa de Administração de Financiamento Coletivo</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>22662984</td>\n",
" <td>14731026</td>\n",
" <td>04/09/2018</td>\n",
" <td>Taxa Administração Financiamento Coletivo</td>\n",
" <td>12.50</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE</td>\n",
" <td>88961117734</td>\n",
" <td>NOVO</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" DT_GERACAO HH_GERACAO ANO_ELEICAO CD_TIPO_ELEICAO NM_TIPO_ELEICAO \\\n",
"0 10/02/2019 03:28:27 2018 2 Ordinária \n",
"1 10/02/2019 03:28:27 2018 2 Ordinária \n",
"2 10/02/2019 03:28:27 2018 2 Ordinária \n",
"3 10/02/2019 03:28:27 2018 2 Ordinária \n",
"4 10/02/2019 03:28:27 2018 2 Ordinária \n",
"\n",
" CD_ELEICAO DS_ELEICAO DT_ELEICAO ST_TURNO \\\n",
"0 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"1 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"2 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"3 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"4 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"\n",
" TP_PRESTACAO_CONTAS DT_PRESTACAO_CONTAS SQ_PRESTADOR_CONTAS SG_UF \\\n",
"0 Final 06/11/2018 406838759 ES \n",
"1 Final 06/11/2018 406838759 ES \n",
"2 Final 06/11/2018 406838759 ES \n",
"3 Final 06/11/2018 406838759 ES \n",
"4 Final 06/11/2018 406838759 ES \n",
"\n",
" DS_TIPO_DOCUMENTO NR_DOCUMENTO CD_FONTE_DESPESA DS_FONTE_DESPESA \\\n",
"0 #NULO# #NULO# 1 Outros Recursos \n",
"1 Nota Fiscal 850006 1 Outros Recursos \n",
"2 Duplicata 100201 1 Outros Recursos \n",
"3 Nota Fiscal 92601 1 Outros Recursos \n",
"4 Outro #NULO# 1 Outros Recursos \n",
"\n",
" CD_ORIGEM_DESPESA DS_ORIGEM_DESPESA \\\n",
"0 20210000 Encargos financeiros, taxas bancárias e/ou op.... \n",
"1 20140000 Publicidade por materiais impressos \n",
"2 20420000 Despesa com Impulsionamento de Conteúdos \n",
"3 20260000 Criação e inclusão de páginas na internet \n",
"4 20410000 Taxa de Administração de Financiamento Coletivo \n",
"\n",
" CD_NATUREZA_DESPESA DS_NATUREZA_DESPESA CD_ESPECIE_RECURSO \\\n",
"0 1 Financeiro 1 \n",
"1 1 Financeiro 1 \n",
"2 1 Financeiro 1 \n",
"3 1 Financeiro 1 \n",
"4 1 Financeiro 1 \n",
"\n",
" DS_ESPECIE_RECURSO SQ_DESPESA SQ_PARCELAMENTO_DESPESA DT_PAGTO_DESPESA \\\n",
"0 Financeiro 22662971 14731017 14/08/2018 \n",
"1 Financeiro 22662978 14731028 24/09/2018 \n",
"2 Financeiro 22662982 14731024 02/10/2018 \n",
"3 Financeiro 22662975 14731030 28/09/2018 \n",
"4 Financeiro 22662984 14731026 04/09/2018 \n",
"\n",
" DS_DESPESA VR_PAGTO_DESPESA \\\n",
"0 Encargos financeiros, taxas bancárias e/ou op.... 13.20 \n",
"1 Publicidade por materiais impressos 450.00 \n",
"2 Despesa com Impulsionamento de Conteúdos 747.34 \n",
"3 Criação e inclusão de páginas na internet 297.00 \n",
"4 Taxa Administração Financiamento Coletivo 12.50 \n",
"\n",
" NM_CANDIDATO NR_CPF_CANDIDATO SG_PARTIDO \n",
"0 ALEXANDRE MAGNO DE ANDRADE 88961117734 NOVO \n",
"1 ALEXANDRE MAGNO DE ANDRADE 88961117734 NOVO \n",
"2 ALEXANDRE MAGNO DE ANDRADE 88961117734 NOVO \n",
"3 ALEXANDRE MAGNO DE ANDRADE 88961117734 NOVO \n",
"4 ALEXANDRE MAGNO DE ANDRADE 88961117734 NOVO "
]
},
"metadata": {
"tags": []
},
"execution_count": 12
}
]
},
{
"metadata": {
"id": "ApgWgwxwGQUi",
"colab_type": "code",
"outputId": "ab72f0a0-d442-4b52-f68d-6c8bfc2341f5",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 35
}
},
"cell_type": "code",
"source": [
"len(df18pg.NM_CANDIDATO.unique())"
],
"execution_count": 13,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"18024"
]
},
"metadata": {
"tags": []
},
"execution_count": 13
}
]
},
{
"metadata": {
"id": "0_NZZwvtbcE7",
"colab_type": "code",
"outputId": "8cea3151-6c21-4705-eeeb-6a0c92f384c7",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 35
}
},
"cell_type": "code",
"source": [
"len(df18cont[df18cont.NM_CANDIDATO.str.contains('ibaneis',case=False)&(df18cont.DS_TIPO_FORNECEDOR == 'Pessoa Física')].NM_FORNECEDOR.unique())"
],
"execution_count": 14,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"649"
]
},
"metadata": {
"tags": []
},
"execution_count": 14
}
]
},
{
"metadata": {
"id": "r0M-KGx8VxXv",
"colab_type": "code",
"outputId": "3dbbccd9-e158-4a16-a004-01e7e6623e96",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 445
}
},
"cell_type": "code",
"source": [
"df18pg.head(5)"
],
"execution_count": 60,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>DT_GERACAO</th>\n",
" <th>HH_GERACAO</th>\n",
" <th>ANO_ELEICAO</th>\n",
" <th>CD_TIPO_ELEICAO</th>\n",
" <th>NM_TIPO_ELEICAO</th>\n",
" <th>CD_ELEICAO</th>\n",
" <th>DS_ELEICAO</th>\n",
" <th>DT_ELEICAO</th>\n",
" <th>ST_TURNO</th>\n",
" <th>TP_PRESTACAO_CONTAS</th>\n",
" <th>DT_PRESTACAO_CONTAS</th>\n",
" <th>SQ_PRESTADOR_CONTAS</th>\n",
" <th>SG_UF</th>\n",
" <th>DS_TIPO_DOCUMENTO</th>\n",
" <th>NR_DOCUMENTO</th>\n",
" <th>CD_FONTE_DESPESA</th>\n",
" <th>DS_FONTE_DESPESA</th>\n",
" <th>CD_ORIGEM_DESPESA</th>\n",
" <th>DS_ORIGEM_DESPESA</th>\n",
" <th>CD_NATUREZA_DESPESA</th>\n",
" <th>DS_NATUREZA_DESPESA</th>\n",
" <th>CD_ESPECIE_RECURSO</th>\n",
" <th>DS_ESPECIE_RECURSO</th>\n",
" <th>SQ_DESPESA</th>\n",
" <th>SQ_PARCELAMENTO_DESPESA</th>\n",
" <th>DT_PAGTO_DESPESA</th>\n",
" <th>DS_DESPESA</th>\n",
" <th>VR_PAGTO_DESPESA</th>\n",
" <th>NM_CANDIDATO</th>\n",
" <th>NR_CPF_CANDIDATO</th>\n",
" <th>SG_PARTIDO</th>\n",
" <th>nome_unico</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>406838759</td>\n",
" <td>ES</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>1</td>\n",
" <td>Outros Recursos</td>\n",
" <td>20210000</td>\n",
" <td>Encargos financeiros, taxas bancárias e/ou op....</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>22662971</td>\n",
" <td>14731017</td>\n",
" <td>14/08/2018</td>\n",
" <td>Encargos financeiros, taxas bancárias e/ou op....</td>\n",
" <td>13.20</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE</td>\n",
" <td>88961117734</td>\n",
" <td>NOVO</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE*NOVO</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>406838759</td>\n",
" <td>ES</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>850006</td>\n",
" <td>1</td>\n",
" <td>Outros Recursos</td>\n",
" <td>20140000</td>\n",
" <td>Publicidade por materiais impressos</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>22662978</td>\n",
" <td>14731028</td>\n",
" <td>24/09/2018</td>\n",
" <td>Publicidade por materiais impressos</td>\n",
" <td>450.00</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE</td>\n",
" <td>88961117734</td>\n",
" <td>NOVO</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE*NOVO</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>406838759</td>\n",
" <td>ES</td>\n",
" <td>Duplicata</td>\n",
" <td>100201</td>\n",
" <td>1</td>\n",
" <td>Outros Recursos</td>\n",
" <td>20420000</td>\n",
" <td>Despesa com Impulsionamento de Conteúdos</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>22662982</td>\n",
" <td>14731024</td>\n",
" <td>02/10/2018</td>\n",
" <td>Despesa com Impulsionamento de Conteúdos</td>\n",
" <td>747.34</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE</td>\n",
" <td>88961117734</td>\n",
" <td>NOVO</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE*NOVO</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>406838759</td>\n",
" <td>ES</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>92601</td>\n",
" <td>1</td>\n",
" <td>Outros Recursos</td>\n",
" <td>20260000</td>\n",
" <td>Criação e inclusão de páginas na internet</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>22662975</td>\n",
" <td>14731030</td>\n",
" <td>28/09/2018</td>\n",
" <td>Criação e inclusão de páginas na internet</td>\n",
" <td>297.00</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE</td>\n",
" <td>88961117734</td>\n",
" <td>NOVO</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE*NOVO</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>406838759</td>\n",
" <td>ES</td>\n",
" <td>Outro</td>\n",
" <td>#NULO#</td>\n",
" <td>1</td>\n",
" <td>Outros Recursos</td>\n",
" <td>20410000</td>\n",
" <td>Taxa de Administração de Financiamento Coletivo</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>22662984</td>\n",
" <td>14731026</td>\n",
" <td>04/09/2018</td>\n",
" <td>Taxa Administração Financiamento Coletivo</td>\n",
" <td>12.50</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE</td>\n",
" <td>88961117734</td>\n",
" <td>NOVO</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE*NOVO</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" DT_GERACAO HH_GERACAO ANO_ELEICAO CD_TIPO_ELEICAO NM_TIPO_ELEICAO \\\n",
"0 10/02/2019 03:28:27 2018 2 Ordinária \n",
"1 10/02/2019 03:28:27 2018 2 Ordinária \n",
"2 10/02/2019 03:28:27 2018 2 Ordinária \n",
"3 10/02/2019 03:28:27 2018 2 Ordinária \n",
"4 10/02/2019 03:28:27 2018 2 Ordinária \n",
"\n",
" CD_ELEICAO DS_ELEICAO DT_ELEICAO ST_TURNO \\\n",
"0 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"1 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"2 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"3 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"4 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"\n",
" TP_PRESTACAO_CONTAS DT_PRESTACAO_CONTAS SQ_PRESTADOR_CONTAS SG_UF \\\n",
"0 Final 06/11/2018 406838759 ES \n",
"1 Final 06/11/2018 406838759 ES \n",
"2 Final 06/11/2018 406838759 ES \n",
"3 Final 06/11/2018 406838759 ES \n",
"4 Final 06/11/2018 406838759 ES \n",
"\n",
" DS_TIPO_DOCUMENTO NR_DOCUMENTO CD_FONTE_DESPESA DS_FONTE_DESPESA \\\n",
"0 #NULO# #NULO# 1 Outros Recursos \n",
"1 Nota Fiscal 850006 1 Outros Recursos \n",
"2 Duplicata 100201 1 Outros Recursos \n",
"3 Nota Fiscal 92601 1 Outros Recursos \n",
"4 Outro #NULO# 1 Outros Recursos \n",
"\n",
" CD_ORIGEM_DESPESA DS_ORIGEM_DESPESA \\\n",
"0 20210000 Encargos financeiros, taxas bancárias e/ou op.... \n",
"1 20140000 Publicidade por materiais impressos \n",
"2 20420000 Despesa com Impulsionamento de Conteúdos \n",
"3 20260000 Criação e inclusão de páginas na internet \n",
"4 20410000 Taxa de Administração de Financiamento Coletivo \n",
"\n",
" CD_NATUREZA_DESPESA DS_NATUREZA_DESPESA CD_ESPECIE_RECURSO \\\n",
"0 1 Financeiro 1 \n",
"1 1 Financeiro 1 \n",
"2 1 Financeiro 1 \n",
"3 1 Financeiro 1 \n",
"4 1 Financeiro 1 \n",
"\n",
" DS_ESPECIE_RECURSO SQ_DESPESA SQ_PARCELAMENTO_DESPESA DT_PAGTO_DESPESA \\\n",
"0 Financeiro 22662971 14731017 14/08/2018 \n",
"1 Financeiro 22662978 14731028 24/09/2018 \n",
"2 Financeiro 22662982 14731024 02/10/2018 \n",
"3 Financeiro 22662975 14731030 28/09/2018 \n",
"4 Financeiro 22662984 14731026 04/09/2018 \n",
"\n",
" DS_DESPESA VR_PAGTO_DESPESA \\\n",
"0 Encargos financeiros, taxas bancárias e/ou op.... 13.20 \n",
"1 Publicidade por materiais impressos 450.00 \n",
"2 Despesa com Impulsionamento de Conteúdos 747.34 \n",
"3 Criação e inclusão de páginas na internet 297.00 \n",
"4 Taxa Administração Financiamento Coletivo 12.50 \n",
"\n",
" NM_CANDIDATO NR_CPF_CANDIDATO SG_PARTIDO \\\n",
"0 ALEXANDRE MAGNO DE ANDRADE 88961117734 NOVO \n",
"1 ALEXANDRE MAGNO DE ANDRADE 88961117734 NOVO \n",
"2 ALEXANDRE MAGNO DE ANDRADE 88961117734 NOVO \n",
"3 ALEXANDRE MAGNO DE ANDRADE 88961117734 NOVO \n",
"4 ALEXANDRE MAGNO DE ANDRADE 88961117734 NOVO \n",
"\n",
" nome_unico \n",
"0 ALEXANDRE MAGNO DE ANDRADE*NOVO \n",
"1 ALEXANDRE MAGNO DE ANDRADE*NOVO \n",
"2 ALEXANDRE MAGNO DE ANDRADE*NOVO \n",
"3 ALEXANDRE MAGNO DE ANDRADE*NOVO \n",
"4 ALEXANDRE MAGNO DE ANDRADE*NOVO "
]
},
"metadata": {
"tags": []
},
"execution_count": 60
}
]
},
{
"metadata": {
"colab_type": "text",
"id": "bdIPud5D7szb"
},
"cell_type": "markdown",
"source": [
"# **Receitas de 2018**"
]
},
{
"metadata": {
"colab_type": "code",
"id": "jKh5YeA07szi",
"colab": {}
},
"cell_type": "code",
"source": [
"cods = ['1_ErBJudSQjKKXJma3u51I_7gHx3GPgXq',\n",
"'1NXkZotiVjIzbSB-gDc9Hf70QmTiAONRy',\n",
"'1e6AVNUXKffMdW8aIrFjzOp4RM055UYKS',\n",
"'1BgYEFMg5gs9Cnr6djlGZt5MkRvJnNV9k',\n",
"'1BCg2cwdzAht2nYc79uCZkVadgO7h-o_6',\n",
"'1gGd9DKhqPUCPDIQbU9nh5zYI9vPWhXb0',\n",
"'11xn_417vtZnAezJlOhlfDIX0_JG0_rL-',\n",
"'15lDB17UP9Xhng_O5hrD1xREy7xLKVpSC',\n",
"'1aLpvsViy2ugOkUYkm9QjOrag0150PtpH',\n",
"'1cxMjFzeI2txh_V4l00jgDwh_H62O1zN3',\n",
"'1qtxvEgiKefGIeog-2gHy5z9jnqtejbOO',\n",
"'14-1EEtyspxjAI_ylOgOq4Cg_114QZTzE',\n",
"'10mAJzpEEOInQH7NWWjMeMXeoLlk_vRRg',\n",
"'1gvSDge2OHCwxxXnfiiNcqV6U34sK1mbg',\n",
"'1klVyTgU-7w_5Z0bby2ZsK4rZ2eL9RVOt',\n",
"'1XQ-Lgk5n3jImnrOZ-IZM18jpCxSUF8pn',\n",
"'1WSKDPvB3YVXDGNj84x1sl6qk3oq_3bOV',\n",
"'19N3qad9AeYD0qGIEXIWfyOD7k0kCZjn7',\n",
"'1LmIk4aF_vvXA6zMCbMxB3m44u6yfqVL7',\n",
"'1V8eK1YaFQGUhpG3w0h5d1vKFnIxF_n3s',\n",
"'1N1bxagtgBoqkfcdcVyaJFU79PT5pBeCb',\n",
"'1Srcxw-qZmKfiudWfLjCEItdrRHLOpFkt',\n",
"'1yLEyA0PV6JEM4Ay1pMon0Ua2SFMZDDIw',\n",
"'1jjVbU6LHTy-OaT_D3MCQ4jeieSTboIjU',\n",
"'1-Mqe-Ewja4ITvUh8le6WlHzCNb8ReKZo',\n",
"'1K0I6mirCEVLrzsSMZBtO7K-FWRYfZxr4',\n",
"'14VbY5bHoTBnE8Ct4u5uPT6L_A1j_GGPU',\n",
"'1OJB-dcEiWjl69uYK7tCV4Mzbskx8JbUy',\n",
"'1oKeVht0UEsJNwO0rdlbypazPqeO80rXi']"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"colab_type": "code",
"id": "PdEQrvBD7szp",
"colab": {}
},
"cell_type": "code",
"source": [
"df = drive.CreateFile({'id':'1s9MVmhdiwuYjMzULtsnOgswtaGeLXEWx'}) \n",
"df.GetContentFile('df')\n",
"re18 = pd.read_csv('df', encoding = 'latin-1', error_bad_lines=False, delimiter = ';')\n",
"\n",
"for cod in cods:\n",
" uf = drive.CreateFile({'id':cod})\n",
" uf.GetContentFile('uf')\n",
" uf = pd.read_csv('uf', encoding = 'latin-1', error_bad_lines=False, delimiter = ';')\n",
" re18 = re18.merge(uf, how='outer')"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "ekpnOwUce4ad",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"re18['NM_CANDIDATO'] = re18['NM_CANDIDATO'].str.normalize('NFKD').str.encode('ascii', errors='ignore').str.decode('utf-8')"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "RpHLmKJBzcBr",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"re18.loc[(re18.NM_CANDIDATO == 'GERENILDO JOS[E OLIVEIRA'),'NM_CANDIDATO'] = 'GERENILDO JOSE OLIVEIRA'\n",
"re18.loc[(re18.NM_CANDIDATO == 'JOS[E CHAGAS DA SILVA'),'NM_CANDIDATO'] = 'JOSE CHAGAS DA SILVA'"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "oCiOwVUfQTAk",
"colab_type": "text"
},
"cell_type": "markdown",
"source": [
"**Transformando os valores em números legíveis em Pandas.**"
]
},
{
"metadata": {
"id": "iheTcPpw6Pn2",
"colab_type": "code",
"outputId": "b578521e-7aee-46fe-fc87-738b46cecc79",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 35
}
},
"cell_type": "code",
"source": [
"re18.VR_RECEITA = re18.VR_RECEITA.str.replace(',','.')\n",
"re18.VR_RECEITA = re18.VR_RECEITA.astype(float)\n",
"re18.VR_RECEITA.sum()"
],
"execution_count": 20,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"3344890013.0099998"
]
},
"metadata": {
"tags": []
},
"execution_count": 20
}
]
},
{
"metadata": {
"id": "9RsvPwP9NhPw",
"colab_type": "code",
"outputId": "c272646a-033c-4246-e198-9615bf3b04c6",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 88
}
},
"cell_type": "code",
"source": [
"re18['DS_FONTE_RECEITA'].value_counts()"
],
"execution_count": 21,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"Outros Recursos 221920\n",
"Fundo Especial 68866\n",
"Fundo Partidario 26295\n",
"Name: DS_FONTE_RECEITA, dtype: int64"
]
},
"metadata": {
"tags": []
},
"execution_count": 21
}
]
},
{
"metadata": {
"id": "IpsPj4Jo5OM1",
"colab_type": "text"
},
"cell_type": "markdown",
"source": [
"# **Fundo especial**"
]
},
{
"metadata": {
"id": "atKGWE4o5_kS",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"dpub = re18[(re18.DS_FONTE_RECEITA == 'Fundo Especial')|(re18.DS_FONTE_RECEITA == 'Fundo Partidario')]\n",
"dpub = dpub[(dpub.NM_DOADOR.str.contains('Direção'))]\n",
"dpub['nome_unico'] = dpub['NM_CANDIDATO'] + '*' + dpub['SG_PARTIDO']"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "Ta2YmBR48anD",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"verba_publica = dpub.groupby('nome_unico').sum().reset_index().set_index('nome_unico')['VR_RECEITA'].to_dict()"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "D0pt8cnsAPT0",
"colab_type": "code",
"outputId": "d41717b8-1dd8-4d46-d8c2-50111d955e95",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 17813
}
},
"cell_type": "code",
"source": [
"verba_publica"
],
"execution_count": 24,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"{'ABDAEL AMBRUSTER*PT': 2796.23,\n",
" 'ABDIAS DE OLIVEIRA SILVA*DC': 2600.0,\n",
" 'ABEL ALVES DE OLIVEIRA*PT': 15000.0,\n",
" 'ABEL DO PORTO SANTOS*PRB': 12389.0,\n",
" 'ABEL ELIAS DE CAMARGO*PATRI': 7256.0,\n",
" 'ABEL ENRIQUE DUARTE*PHS': 9642.68,\n",
" 'ABEL HACK*PSB': 30000.0,\n",
" 'ABELARDO PEDRO NOBRE JUNIOR*PSOL': 936.16,\n",
" 'ABENONIZA MARIA MOURA*PSOL': 2320.0,\n",
" 'ABIAS DE SOUSA SILVA*PT': 15000.0,\n",
" 'ABIDENE SALUSTIANO DA SILVA*PSC': 45000.0,\n",
" 'ABIEZER JONATAS DE CAMARGO*PSOL': 1370.97,\n",
" 'ABIGAIL BENTO DA SILVA*PRP': 16683.28,\n",
" 'ABIGUAR RODRIGUES CLAUDIO FILHO*AVANTE': 3210.83,\n",
" 'ABILIO MACIEL DA SILVA FILHO*PRTB': 8784.23,\n",
" 'ABILIO OTILIO BEZERRA FILHO*PP': 4440.0,\n",
" 'ABRAAO BRAGA FERREIRA*PDT': 1000.0,\n",
" 'ABRAAO INACIO NETO*PHS': 300.0,\n",
" 'ABRAAO LINCOLN FERREIRA DA CRUZ*PRB': 668195.64,\n",
" 'ABRAHAO HISSA SAFAR NETO*PSB': 1250.0,\n",
" 'ABRAO FERNANDES GODOIS*PSOL': 9998.85,\n",
" 'ACACIO DA SILVA FAVACHO NETO*PROS': 720316.3,\n",
" 'ACELINO FREITAS*PDT': 80250.0,\n",
" 'ACEMAR DA SILVA*PPS': 11021.92,\n",
" 'ACENILDO FURTADO DA COSTA*PV': 8955.32,\n",
" 'ACHILES EDUARDO PONTES CAMPOS*PTB': 50000.0,\n",
" 'ACINOVIC ALVES FERREIRA*PRB': 2452.5,\n",
" 'ACIR FURTADO GONCALVES*PSB': 500.0,\n",
" 'ACIR MARCOS GURGACZ*PDT': 1009112.35,\n",
" 'ACIRIO PORFIRIO*PSB': 3000.0,\n",
" 'ACRAILTON FORDE*PTC': 4000.0,\n",
" 'ACSA JUNIA GERMANO*PHS': 617.5,\n",
" 'ADA CLEIA DANTAS SICHINEL BOABAID*PMN': 100000.0,\n",
" 'ADA LILI FARACO DE LUCA*MDB': 500000.0,\n",
" 'ADAIAS NERI DO NASCIMENTO*PROS': 30026.4,\n",
" 'ADAIL EDMUNDO LIMA*MDB': 30000.0,\n",
" 'ADAILTO GONCALVES DOS SANTOS*DC': 4157.91,\n",
" 'ADAILTON ANTUNES FERREIRA*PSD': 100000.0,\n",
" 'ADAILTON CERQUEIRA JUNIOR*PR': 142856.5,\n",
" 'ADAILTON MARTINS DE OLIVEIRA FILHO*PSD': 100000.0,\n",
" 'ADAILTON MARTINS DOS SANTOS*PT': 1000.0,\n",
" 'ADAIR OTAVIANO DE OLIVEIRA*MDB': 25956.69,\n",
" 'ADAIRES PEDROSA DOS SANTOS*PHS': 700.0,\n",
" 'ADAIRTO DA ROSA*PV': 407.55,\n",
" 'ADAIRTON MEDEIROS BARBOSA*PT': 6000.0,\n",
" 'ADALBERTO ALENCAR ALVES*PSOL': 5730.0,\n",
" 'ADALBERTO CARLOS RIGOBELLO*PV': 40000.0,\n",
" 'ADALBERTO CAVALCANTI RODRIGUES*AVANTE': 969000.0,\n",
" 'ADALBERTO DUTRA ROCHA*DEM': 50000.0,\n",
" 'ADALBERTO GODOY FREITAS*PSL': 8474.57,\n",
" 'ADALBERTO JOSE DA SILVA*DEM': 13700.0,\n",
" 'ADALBERTO MARIANO DOS SANTOS*PATRI': 1364.0,\n",
" 'ADALBERTO ROSA BARRETO*PC do B': 909.09,\n",
" 'ADALCLEVER RIBEIRO LOPES*MDB': 932081.25,\n",
" 'ADALEIA SOUZA DA SILVA*PSDB': 14293.75,\n",
" 'ADALGISA BREDA PESSOA DE MELLO*PPS': 3000.0,\n",
" 'ADALGISA HYODO*PTB': 10000.0,\n",
" 'ADALGISA SEVERINA DOS SANTOS*SOLIDARIEDADE': 250.0,\n",
" 'ADALGISA SOARES ALVES*PSDB': 6875.0,\n",
" 'ADALGIZA GONCALVES DOS SANTOS*AVANTE': 1194.4299999999998,\n",
" 'ADALMO ROMILSON ALVES*PRTB': 500.0,\n",
" 'ADALTO CUSTODIO DE MORAIS*DC': 3767.0,\n",
" 'ADALTO DAS DORES LIMA*PTC': 2000.0,\n",
" 'ADAMIR NIVALDO ANGHINONI*DC': 2600.0,\n",
" 'ADAO ALVES DE CARVALHO*PV': 1875.93,\n",
" 'ADAO AURELIO JAUVANIR GUIMARAES*PDT': 20000.0,\n",
" 'ADAO CAETNO DA SILVA*PSL': 2008.5,\n",
" 'ADAO CLEITON LEAL DA SILVA*PSB': 10600.0,\n",
" 'ADAO DIVINO DO NASCIMENTO*PRB': 14354.15,\n",
" 'ADAO FERNANDES DA SILVA*PSOL': 3114.45,\n",
" 'ADAO FERREIRA DA SILVA*PDT': 17636.140000000003,\n",
" 'ADAO FRANCISCO DE OLIVEIRA*PT': 20450.0,\n",
" 'ADAO TIMOTEO DE LIMA*PR': 3511.75,\n",
" 'ADAUTO VIANA JUNIOR*PRTB': 3504.84,\n",
" 'ADAUTON CESAR DE ALMEIDA*PROS': 232500.0,\n",
" 'ADECIR BERLE*PSOL': 458.41,\n",
" 'ADEILDE MARQUES*PPL': 25450.0,\n",
" 'ADEILDO SILAS DE SOUZA*PSC': 23636.36,\n",
" 'ADEILTON FERREIRA DE SOUZA*MDB': 10000.0,\n",
" 'ADEIR THEOFILO APOLINARIO*MDB': 3812.79,\n",
" 'ADELAIDE DA MOTTA TEIXEIRA*PDT': 10000.0,\n",
" 'ADELCIMARA AZEVEDO LIMA*SOLIDARIEDADE': 35714.28,\n",
" 'ADELE REGINA CARDOZO DE BRITO*PSB': 5142.9,\n",
" 'ADELIA COSTA DA SILVA*PSC': 12000.0,\n",
" 'ADELIA DE JESUS SOARES*PATRI': 103637.7,\n",
" 'ADELIA MARIA ALVES*PR': 291085.0,\n",
" 'ADELIA OLIVEIRA DE FARIAS*PT': 5000.0,\n",
" 'ADELIA PICHEK FAGANELLO*PV': 39464.3,\n",
" 'ADELINO RIBEIRO SILVA*PRP': 1363.63,\n",
" 'ADELIR PADILHA DA VEIGA*REDE': 625.0,\n",
" 'ADELITTA MONTEIRO NUNES*PSOL': 89832.78,\n",
" 'ADELMO CARNEIRO LEAO*PT': 729581.96,\n",
" 'ADELONES MARTINS DE MOURA*PTC': 293.5,\n",
" 'ADELSON BARRETO DOS SANTOS*PR': 1400000.0,\n",
" 'ADELSON FRANCISCO DA SILVA*PRB': 8113.93,\n",
" 'ADEMAR ALVES DE CARVALHO*PR': 33140.32,\n",
" 'ADEMAR COUTINHO DEVENS*PSD': 14000.0,\n",
" 'ADEMAR DO NASCIMENTO*PRB': 15160.46,\n",
" 'ADEMAR LINEU DORFSCHMIDT*MDB': 50000.0,\n",
" 'ADEMAR RIBAS NUNES*PV': 2500.0,\n",
" 'ADEMAR SIMOES DE AZEVEDO*MDB': 150000.0,\n",
" 'ADEMILSON DE SOUSA COSTA*MDB': 306800.0,\n",
" 'ADEMILSON DIAS DO NASCIMENTO*PSOL': 716.25,\n",
" 'ADEMILSON MIGUEL FERNANDES*PSOL': 1526.04,\n",
" 'ADEMIR ANDRADE DE OLIVEIRA*PTC': 373.5,\n",
" 'ADEMIR BITENCOURT AZEVEDO*PSOL': 8913.24,\n",
" 'ADEMIR CAMILO PRATES RODRIGUES*MDB': 1512469.49,\n",
" 'ADEMIR COSTA*PPS': 10500.0,\n",
" 'ADEMIR CUNHA BRANDAO*PATRI': 1800.0,\n",
" 'ADEMIR DA PENHA CLEMENTE*SOLIDARIEDADE': 14692.17,\n",
" 'ADEMIR DE SOUZA SILVA*PRP': 650.0,\n",
" 'ADEMIR GONCALVES*PPS': 5000.0,\n",
" 'ADEMIR JOSE DA SILVA*PRB': 15670.5,\n",
" 'ADEMIR MANES*AVANTE': 1850.0,\n",
" 'ADEMIR MENDONCA*PPS': 10000.0,\n",
" 'ADEMIR PINHEIRO GONCALVES*PSD': 20000.0,\n",
" 'ADENI CORREA LIMA*PSB': 1000.0,\n",
" 'ADENILSA CHAVES CONCEICAO*PHS': 700.0,\n",
" 'ADENILSON CANDIDO DE SOUZA*PRB': 1875.0,\n",
" 'ADENILSON LOPES TRINDADE*PRP': 72.0,\n",
" 'ADENILTON FERREIRA DA SILVA*PV': 40000.0,\n",
" 'ADENIZIA DA ROCHA PESSOA*PRB': 5000.0,\n",
" 'ADENOR LUIZ SIMOES COELHO*PSB': 350000.0,\n",
" 'ADERBAL FULCO CALDAS*PP': 100000.0,\n",
" 'ADERITO CASSIO DE ASSIS DUTRA*PSOL': 2346.27,\n",
" 'ADERLEY CARNEIRO GUEDES*PR': 20000.0,\n",
" 'ADERMIS MARINI JUNIOR*PSDB': 500000.0,\n",
" 'ADERVAL DA ROCHA FERREIRA FILHO*PSD': 50000.0,\n",
" 'ADESLON PEREIRA GUEDES*PT': 1000.0,\n",
" 'ADILA VALDEMIRA SEVERINO DAS NEVES*PTC': 1350.0,\n",
" 'ADILAINE ADRIANA GUIMARAES PIRES FONSECA*DC': 2554.64,\n",
" 'ADILCIMAR AGUIAR PARENTE*PSL': 900.0,\n",
" 'ADILCINEA DAS GRACAS DE GODOY FELIX*PHS': 200.0,\n",
" 'ADILENE DE LIMA NOBRE*PSOL': 2605.95,\n",
" 'ADILIO SALVADOR SARAIVA*PRTB': 1980.0,\n",
" 'ADILO ANGELO DIDOMENICO*PTB': 28000.0,\n",
" 'ADILOR GUGLIELMI*PSDB': 75000.0,\n",
" 'ADILSON BARBOSA DOS SANTOS*PSOL': 1857.92,\n",
" 'ADILSON BARROSO OLIVEIRA*PATRI': 1386053.0,\n",
" 'ADILSON CERQUEIRA*PATRI': 1890.11,\n",
" 'ADILSON CESAR DE OLIVEIRA SOUZA*PV': 10505.32,\n",
" 'ADILSON DA SILVA*PRP': 721.25,\n",
" 'ADILSON ESPINDULA*PTB': 9375.0,\n",
" 'ADILSON GONCALVES MOREIRA*PTC': 560.0,\n",
" 'ADILSON GUIMARAES LAVRA*PRB': 2247.5,\n",
" 'ADILSON JESUS DA SILVA*PSC': 2070.9700000000003,\n",
" 'ADILSON JOSE DA SILVA*DC': 4600.0,\n",
" 'ADILSON MARQUES DOS SANTOS*PDT': 2331.5,\n",
" 'ADILSON MENDES FONSECA*PDT': 20000.0,\n",
" 'ADILSON MORAES DE LUCENA*PC do B': 2115.38,\n",
" 'ADILSON NOGUEIRA PIRES*PT': 471000.0,\n",
" 'ADILSON PEREIRA DA COSTA*PMN': 2300.0,\n",
" 'ADILSON PEREIRA DE OLIVEIRA*PSB': 2977.61,\n",
" 'ADILSON PINHEIRO DA SILVA*AVANTE': 1400.0,\n",
" 'ADILSON ROSSI*PSB': 100000.0,\n",
" 'ADILSON SOARES DE ALMEIDA*PP': 4800.0,\n",
" 'ADILSON SOARES ZELA*PPL': 1200.0,\n",
" 'ADILSON TROCA*PSDB': 26875.0,\n",
" 'ADILTON DOMINGOS SACHETTI*PRB': 2105650.0,\n",
" 'ADIMAR BARRETO DE MELO*PV': 8955.32,\n",
" 'ADIMARIO TEODORO DA SILVA LEITE DE FARIA*PRB': 12766.15,\n",
" 'ADIMILSON DA ROSA BRITES*PRB': 35462.14,\n",
" 'ADIMILSON MENDES AMARAL JUNIOR*PHS': 80700.0,\n",
" 'ADINAN AMORIM MACHADO DE FREITAS*PHS': 300.0,\n",
" 'ADJUTO DIAS DE ARAUJO NETO*MDB': 58687.5,\n",
" 'ADJUTO RODRIGUES AFONSO*PDT': 50000.0,\n",
" 'ADMILSON LUCIO OLIVEIRA*PT': 17796.23,\n",
" 'ADMILSON MARINHO DE LIMA*PSOL': 4606.08,\n",
" 'ADMILSON NASCIMENTO SANTOS*PSC': 24770.97,\n",
" 'ADMIR GERVASIO MOREIRA*PPL': 5980.0,\n",
" 'ADNA ANA SIQUEIRA TEIXEIRA*PR': 60411.38,\n",
" 'ADNA LEAL PEREIRA*AVANTE': 50190.0,\n",
" 'ADOLFO EMANUEL MONTEIRO DE MENEZES*PSD': 150000.0,\n",
" 'ADOLFO FURTADO GONCALVES*PODE': 114.45,\n",
" 'ADOLFO JOSE BRITO*PP': 100015.0,\n",
" 'ADOLFO QUINTAS GONCALVES NETO*PSD': 75000.0,\n",
" 'ADOLFO RAPHAEL SILVA MARIANO DE OLIVEIRA*PSOL': 3286.66,\n",
" 'ADOLFO VIANA DE CASTRO NETO*PSDB': 1160000.0,\n",
" 'ADOLPH SCHICKELGRUBER RODRIGUES DE ALMEIDA*DC': 504.0,\n",
" 'ADOLPHO KONDER HOMEM DE CARVALHO FILHO*DEM': 50000.0,\n",
" 'ADONIAS MARQUES DE ABREU*PSL': 3000.0,\n",
" 'ADRIAN MUSSI RAMOS*SOLIDARIEDADE': 30000.0,\n",
" 'ADRIANA ALVES DE OLIVEIRA*PATRI': 2479.5,\n",
" 'ADRIANA ALVES RIBEIRO*PSC': 50000.0,\n",
" 'ADRIANA APARECIDA RAMOS PANTZIER*PRP': 1000.0,\n",
" 'ADRIANA ARAUJO BARGAS*MDB': 20000.0,\n",
" 'ADRIANA ASSIS FERREIRA DA SILVA*PSC': 5850.0,\n",
" 'ADRIANA BARBOSA ROCHA DE FARIA*REDE': 800.0,\n",
" 'ADRIANA BASTOS DE SOUZA*PSDB': 9401.03,\n",
" 'ADRIANA BORGES PIRES DA SILVEIRA*PODE': 355000.0,\n",
" 'ADRIANA CARDOSO AZEVEDO PERMINIO*PC do B': 16000.0,\n",
" 'ADRIANA COELHO DE OLIVEIRA*PC do B': 12000.0,\n",
" 'ADRIANA CRISTINA ARAUJO*PSOL': 4735.0599999999995,\n",
" 'ADRIANA CRISTINA BARCELOS FALCAO*PMB': 8762.5,\n",
" 'ADRIANA DA COSTA SOUSA*AVANTE': 3000.0,\n",
" 'ADRIANA DA ROSA*PPL': 2309.2200000000003,\n",
" 'ADRIANA DANTAS CARDOSO*PSL': 6000.0,\n",
" 'ADRIANA DE COSTA*PV': 27050.0,\n",
" 'ADRIANA DE FATIMA DA SILVA*PTC': 180.0,\n",
" 'ADRIANA DE MELO LOPES*PSOL': 1973.6299999999999,\n",
" 'ADRIANA DOS SANTOS DE OLIVEIRA*PRP': 6748.0,\n",
" 'ADRIANA ELIAS MARQUES*PTB': 110000.0,\n",
" 'ADRIANA FERNANDES MARTINS*PSB': 5142.9,\n",
" 'ADRIANA FERREIRA FERNANDES*PRP': 27122.83,\n",
" 'ADRIANA FERREIRA*PTB': 66200.0,\n",
" 'ADRIANA FRANCISCA SILVA DE ALMEIDA*PSC': 1125.0,\n",
" 'ADRIANA GALVAO DOS SANTOS*DEM': 2500.0,\n",
" 'ADRIANA GONCALVES BOAS*PSL': 10000.0,\n",
" 'ADRIANA GONCALVES NARDY*DEM': 400000.0,\n",
" 'ADRIANA GUEDES MACHADO*PATRI': 16110.5,\n",
" 'ADRIANA KARLA MELO MARTINS*PSC': 50600.0,\n",
" 'ADRIANA KUTRAS*PATRI': 690.0,\n",
" 'ADRIANA LEITE DA SILVA*PSL': 2000.0,\n",
" 'ADRIANA LOURENCO DAS CANDEIAS*PROS': 172565.47,\n",
" 'ADRIANA LUCIA BARRETO*PHS': 1000.0,\n",
" 'ADRIANA MARIA BARROZO DE MACEDO*PSL': 115000.0,\n",
" 'ADRIANA MARIA DE ARAUJO MENEZES*PODE': 25000.0,\n",
" 'ADRIANA MARIA LEITE AGUILERA*PP': 414713.0,\n",
" 'ADRIANA MARIA MOREIRA BORGES*PSL': 4000.0,\n",
" 'ADRIANA MARTINS GUIMARAES*PSOL': 4998.84,\n",
" 'ADRIANA MERY SCHLICHTING*PROS': 5000.0,\n",
" 'ADRIANA MICHELE DE ARAUJO MIRANDA*DEM': 300.0,\n",
" 'ADRIANA MONTEIRO DA ROCHA*SOLIDARIEDADE': 2418.75,\n",
" 'ADRIANA MOURA DE MENDONCA*PROS': 177150.0,\n",
" 'ADRIANA NEVES PEREIRA DOS SANTOS*DC': 7000.0,\n",
" 'ADRIANA OLIVEIRA DOS SANTOS LEITE*PRB': 300000.0,\n",
" 'ADRIANA PAULA HORTENCIANO*MDB': 20000.0,\n",
" 'ADRIANA PEDERNEIRAS REBELO DA SILVA*PRB': 88444.72,\n",
" 'ADRIANA PEREIRA NACIF*MDB': 68400.0,\n",
" 'ADRIANA PIERIN*PODE': 31301.28,\n",
" 'ADRIANA PINHEIRO GODINHO*PHS': 4842.0,\n",
" 'ADRIANA RAMOS AFONSO*PR': 200000.0,\n",
" 'ADRIANA ROCHA DE HOLANDA COUTINHO*REDE': 20000.0,\n",
" 'ADRIANA SANCHES GALDEANO BORGO*PROS': 33075.0,\n",
" 'ADRIANA SAUTHIER ACCORSI*PT': 52000.0,\n",
" 'ADRIANA SIMOES DE ARAUJO*PV': 5000.0,\n",
" 'ADRIANA SOUZA PEREIRA*PRP': 17450.94,\n",
" 'ADRIANA TAVARES*PSL': 6000.0,\n",
" 'ADRIANA TEREZINHA MACHADO DA SILVEIRA*DC': 6099.0,\n",
" 'ADRIANA VASCONCELLOS VIEIRA DE OLIVEIRA LUIZ*PSOL': 23928.350000000002,\n",
" 'ADRIANE CARDOSO SERRAO*PSOL': 43868.38,\n",
" 'ADRIANE CUNHA SIMOES PIRES*PR': 100000.0,\n",
" 'ADRIANE NAGEL PEREIRA*PRB': 308571.64,\n",
" 'ADRIANE PEREIRA DE FRANCA*PR': 21750.0,\n",
" 'ADRIANO ABRAAO VICENTE*PMB': 2000.0,\n",
" 'ADRIANO ANTONIO AVELAR*PP': 2243692.0,\n",
" 'ADRIANO APARECIDO SILVA*DEM': 350000.0,\n",
" 'ADRIANO ARAUJO DA SILVA*SOLIDARIEDADE': 6531.34,\n",
" 'ADRIANO BATISTA DE MORAES*AVANTE': 11808.0,\n",
" 'ADRIANO BENTO DA SILVA*PATRI': 1800.0,\n",
" 'ADRIANO CAMARGO ANTONIO*PSDB': 1875.0,\n",
" 'ADRIANO CANDIDO DE OLIVEIRA*PRP': 1000.0,\n",
" 'ADRIANO CARVALHO DOLZAN*PSDB': 1875.0,\n",
" 'ADRIANO DA COSTA E SILVA*DC': 40148.4,\n",
" 'ADRIANO DA SILVA NEIVA*PATRI': 1070.5,\n",
" 'ADRIANO DE ALMEIDA SILVA*PODE': 286.95,\n",
" 'ADRIANO DE ANDRADE MARROCOS*PSD': 5319.71,\n",
" 'ADRIANO DE MARTINI*PT': 38500.0,\n",
" 'ADRIANO DE SOUZA NUNES*PPS': 1021.8499999999999,\n",
" 'ADRIANO DIOGO*PT': 47796.229999999996,\n",
" 'ADRIANO ELI CORREA*DEM': 663000.0,\n",
" 'ADRIANO EUGENIO DA SILVA*PC do B': 1742.0,\n",
" 'ADRIANO FIRMINO TELES*PT': 5000.0,\n",
" 'ADRIANO JOSE DE OLIVEIRA SILVA*SOLIDARIEDADE': 30000.0,\n",
" 'ADRIANO JOSE DOS REIS*PRTB': 1023.64,\n",
" 'ADRIANO LIARIO*PSOL': 6048.43,\n",
" 'ADRIANO MARQUES*SOLIDARIEDADE': 200.0,\n",
" 'ADRIANO MIRANDA DE SOUSA*PHS': 1000.6600000000001,\n",
" 'ADRIANO NUNES SANTANA*SOLIDARIEDADE': 200.0,\n",
" 'ADRIANO ROSA*PSOL': 3167.92,\n",
" 'ADRIANO SANTOS*PSOL': 948.16,\n",
" 'ADRIANO SOUZA SANTANA*REDE': 110.0,\n",
" 'ADRIANO VIEIRA CHAVES*PHS': 2769.0,\n",
" 'ADRIANO VIEIRA DA SILVA*PSC': 810.31,\n",
" 'ADRIANO ZAGO*MDB': 30956.69,\n",
" 'ADRIELSON LAZARO COSTA SOUZA*SOLIDARIEDADE': 5000.0,\n",
" 'ADRIENNE MARQUES FONTES*PSDB': 2250.0,\n",
" 'ADRIERLIS RIBEIRO DUARTE*DC': 10000.0,\n",
" 'ADROALDO OLIVEIRA DOS SANTOS*PCO': 1350.0,\n",
" 'AECIO CLOVES PIMENTEL MATOS*MDB': 36916.66,\n",
" 'AECIO DE CASTRO BARBOSA*PV': 14320.0,\n",
" 'AECIO NEVES DA CUNHA*PSDB': 2031126.03,\n",
" 'AEDINEU PEREIRA DE MOURA*PRB': 1925.08,\n",
" 'AELTON JOSE DE FREITAS*PR': 1601560.0,\n",
" 'AENIA DANIELI FEITOSA BARBOSA*PSDB': 42125.0,\n",
" 'AERCI ARREAL OLM*AVANTE': 3949.2,\n",
" 'AERTON VIEIRA DOS SANTOS*PP': 215253.79,\n",
" 'AFFONSO SALATI FILHO*PRB': 8579.75,\n",
" 'AFONSO ANTONIO CANDIDO*DEM': 185200.0,\n",
" 'AFONSO ANTUNES DA MOTTA*PDT': 500000.0,\n",
" 'AFONSO AUGUSTO BARBOSA FONTES*PC do B': 2000.0,\n",
" 'AFONSO BANDEIRA FLORENCE*PT': 900000.0,\n",
" 'AFONSO LUIZ DE ALMEIDA*PT': 1000.0,\n",
" 'AFONSO VICTOR VIANNA DE ANDRADE*PHS': 23610.0,\n",
" 'AFRANIO TADEU BOPPRE*PSOL': 104533.25,\n",
" 'AGACIEL DA SILVA MAIA*PR': 970000.0,\n",
" 'AGATHA CRISTINA SANTOS CONCEICAO*SOLIDARIEDADE': 250000.0,\n",
" 'AGATHA REBECA DOS SANTOS*PTC': 1176.45,\n",
" 'AGENILDO NERI DA SILVA*PRB': 39462.14,\n",
" 'AGENOR GOMES DE ARAUJO NETO*MDB': 450000.0,\n",
" 'AGENOR JULIO XAVIER*PPS': 200.0,\n",
" 'AGENOR MARIANO DA SILVA NETO*MDB': 277500.0,\n",
" 'AGEU ALMEIDA DOS SANTOS*PC do B': 10735.880000000001,\n",
" 'AGEU DA CRUZ ALMEIDA*PSL': 5730.95,\n",
" 'AGNALDO DIAS DA CONCEICAO*PRB': 20035.0,\n",
" 'AGNALDO LEITE COUTINHO*PSC': 20000.0,\n",
" 'AGNALDO MAURICIO DANIEL*PPS': 1403.44,\n",
" 'AGNALDO ROMEIRO DE MELO*PPS': 2500.0,\n",
" 'AGNALDO ROSAS DE OLIVEIRA*PSB': 20000.0,\n",
" 'AGNALDO SANTOS CONCEICAO*PSB': 1431.5,\n",
" 'AGNALDO SILVA ALEXANDRE*PCB': 2000.0,\n",
" 'AGOSTINHO CELIO ANDRADE PATRUS*PV': 205956.69,\n",
" 'AGOSTINHO MARCAL MESSIAS*PPL': 2500.0,\n",
" 'AGRIPINO PEREIRA DE SENA*PRB': 17775.05,\n",
" 'AGRIPINO RODRIGUES GOMES MAGALHAES*PROS': 30424.0,\n",
" 'AGUEDA DE OLIVEIRA SARAIVA*PSDB': 13401.029999999999,\n",
" 'AGUINALDO FERNANDES ROSA*PRB': 18000.0,\n",
" 'AGUINALDO GRATIERI*PPL': 800.0,\n",
" 'AGUINALDO JUNIOR ARAUJO VIEIRA*PMB': 5925.0,\n",
" 'AGUINALDO ROCHA DE BARROS*PODE': 114.45,\n",
" 'AGUINALDO TRIUMPHO AVELLAR*MDB': 10000.0,\n",
" 'AGUINALDO VELLOSO BORGES RIBEIRO*PP': 1244054.32,\n",
" 'AGUSTIN FRANCISCO CARBALLO*PSL': 5730.95,\n",
" 'AICARO UMBERTO FERRARI*MDB': 85000.0,\n",
" 'AIDA RODRIGUES CARDOSO*PV': 26028.57,\n",
" 'AIDAN ANTONIO RAVIN*PODE': 140000.0,\n",
" 'AIDANOR SOARES MACIEL*PTC': 3378.3500000000004,\n",
" 'AIDE BATISTA DE SANTANA*PHS': 26000.0,\n",
" 'AILDO RODRIGUES FERREIRA*PRB': 1019373.4900000005,\n",
" 'AILTO BATISTA MACHADO*SOLIDARIEDADE': 15000.0,\n",
" 'AILTON AMARAL DOS SANTOS*PSOL': 3286.66,\n",
" 'AILTON CLAECIO LOPES DANTAS*PSOL': 91445.8,\n",
" 'AILTON COSTA AGUIAR*PC do B': 4150.0,\n",
" 'AILTON DOS SANTOS PENA*PRTB': 1330.0,\n",
" 'AILTON FREITAS DOS SANTOS*PSOL': 1904.68,\n",
" 'AILTON GUEDES DA SILVA*PROS': 3800.0,\n",
" 'AILTON JOSE DE LIMA*PSD': 500000.0,\n",
" 'AILTON NASCIMENTO FARIAS*PTB': 5400.0,\n",
" 'AILTON SANTOS SOUZA*PTC': 133.32,\n",
" 'AILTON SOUZA SANATANA*DC': 2500.0,\n",
" 'AILTON VALDEVINO*PSOL': 936.16,\n",
" 'AIMORE MARINHO DE CASTRO*DC': 12750.0,\n",
" 'AINA APARECIDA DORIA*PTC': 373.5,\n",
" 'AIRES RIBEIRO*PDT': 50000.0,\n",
" 'AIRES VICENTE TOMAZONI*MDB': 100000.0,\n",
" 'AIRTO JOAO FERRONATO*PSB': 5000.0,\n",
" 'AIRTON ANTONIO SOLIGO*PRB': 500000.0,\n",
" 'AIRTON CANOVA*PSB': 5600.0,\n",
" 'AIRTON CESAR DASILVA RATES*SOLIDARIEDADE': 3714.2799999999997,\n",
" 'AIRTON COSTA SANTOS*PV': 20000.0,\n",
" 'AIRTON JOSE DE SOUZA*MDB': 80000.0,\n",
" 'AIRTON LANGARO DIPP*PDT': 50000.0,\n",
" 'AIRTON LUIZ FALEIRO*PT': 435000.0,\n",
" 'AIRTON MARQUES SILVA*SOLIDARIEDADE': 500.0,\n",
" 'AIRTON MORENO FERNANDES*PATRI': 1600.0,\n",
" 'AIRTON PEDRO GURGACZ*PDT': 20.0,\n",
" 'AITON ARANTES CUNHA*DC': 3643.37,\n",
" 'ALAEL PEIXOTO MOZER*PRB': 3177.5,\n",
" 'ALAERTE LEANDRO MARTINS*PT': 10000.0,\n",
" 'ALAIDES DAMACENO NUNES*SOLIDARIEDADE': 22000.0,\n",
" 'ALAIE SILVA DE LIMA*PRTB': 100.0,\n",
" 'ALAIM VASCONCELOS DA LUZ*PTC': 560.0,\n",
" 'ALAN AQUINO GUEDES DE MENDONCA*DEM': 200000.0,\n",
" 'ALAN BEZERRA GOMES*PR': 33688.38,\n",
" 'ALAN BRUNO FREITAS MIRANDA*PHS': 600.0,\n",
" 'ALAN CARDOSO VIEIRA*PSB': 4331.5,\n",
" 'ALAN DA COSTA MACEDO*PDT': 1585.14,\n",
" 'ALAN DE CARVALHO BERNARDES*REDE': 172.41000000000003,\n",
" 'ALAN DE CASTRO DAYUBE*PSD': 150000.0,\n",
" 'ALAN DUCASBLE*PHS': 300.0,\n",
" 'ALAN EDUARDO SANCHES DOS SANTOS*DEM': 150000.0,\n",
" 'ALAN FABIO PRATO ZANATTA*PTB': 200000.0,\n",
" 'ALAN FIGUEIREDO BARROS*PSOL': 13143.39,\n",
" 'ALAN FREITAS PINHEIRO*PSB': 1000.0,\n",
" 'ALAN LEON FELIPPI*PR': 20000.0,\n",
" 'ALAN LUIZ DE LIMA*PSC': 810.31,\n",
" 'ALAN MAIA SILVA*PSOL': 1432.5,\n",
" 'ALAN MORAIS DE OLIVEIRA*PTB': 27937.86,\n",
" 'ALAN MOTA RIBEIRO*PV': 33000.0,\n",
" 'ALAN PATRICK SILVA*PROS': 20561.79,\n",
" 'ALAN RICK MIRANDA*DEM': 825300.0,\n",
" 'ALAN RODRIGUES AMANAJAS*PPL': 1690.0,\n",
" 'ALAN SOUSA ANDRADE*PRB': 20000.0,\n",
" 'ALAN XAVIER LINO*REDE': 2040.61,\n",
" 'ALANA DE OLIVEIRA PASSOS DE SOUZA*PSL': 40000.0,\n",
" 'ALANE KARINE DA SILVA SANTOS*PSOL': 8664.86,\n",
" 'ALANNA HOSANA ALBERNAZ*PT': 10000.0,\n",
" 'ALANNO RONDINELLY DE SOUSA RODRIGUES*PV': 6000.0,\n",
" 'ALBA CILENE SOUZA*PTC': 20000.0,\n",
" 'ALBA CRISTINA NOGUEIRA LOPES*PT': 90024.4,\n",
" 'ALBA REGINA CABRAL DE SANTANA RIBEIRO*PHS': 115000.0,\n",
" 'ALBA ROGERIA MONTEIRO ROSSI OTTERO*PC do B': 70.0,\n",
" 'ALBA VALERIA SANTOS DE OLIVEIRA*REDE': 2121.88,\n",
" 'ALBANISE PIRES FERREIRA DE AZEVEDO*PSOL': 22180.0,\n",
" 'ALBANIZA LOPES DIAS*PRB': 13820.36,\n",
" 'ALBENOR SILVANO RIBEIRO*REDE': 1400.0,\n",
" 'ALBERI GALVANI DIAS*PPS': 11021.849999999999,\n",
" 'ALBERISSON CARLOS DA SILVA*PRP': 115000.0,\n",
" 'ALBERTH KUAE GOMES OLIVEIRA*PP': 187307.6,\n",
" 'ALBERTINA ALVES NERI*PDT': 186.05,\n",
" 'ALBERTINA ROSSO*PSB': 77666.25,\n",
" 'ALBERTO AMARAL ALFARO*PSD': 30000.0,\n",
" 'ALBERTO AVILA SABACK*PRTB': 300.0,\n",
" 'ALBERTO BARROS CAVALCANTE NETO*PRB': 800000.0,\n",
" 'ALBERTO CORUNHA TAVARES*REDE': 1200.0,\n",
" 'ALBERTO DE JESUS ARAUJO*PV': 5000.0,\n",
" 'ALBERTO DE JESUS OLIVEIRA IMBIRIBA JUNIOR*PDT': 1000.0,\n",
" 'ALBERTO DE SOUZA GOMES*PC do B': 2280.0,\n",
" 'ALBERTO FERREIRA DE ANDRADE JUNIOR*PSOL': 16763.239999999998,\n",
" 'ALBERTO JORGE DO NASCIMENTO FEITOSA*SOLIDARIEDADE': 400000.0,\n",
" 'ALBERTO LUIZ VIEIRA COSTA*PT': 16000.0,\n",
" 'ALBERTO MARIO CONCEICAO SANTOS CAMPOS*PATRI': 1700.61,\n",
" 'ALBERTO MELO SANTOS*PTB': 5400.0,\n",
" 'ALBERTO NASCIMENTO CABRAL*DC': 4258.0,\n",
" 'ALBERTO VIEIRA DA CRUZ*PATRI': 1445.11,\n",
" 'ALBETIZA MOREIRA DE ARAUJO*PCO': 1600.0,\n",
" 'ALBINO PEREIRA MACHADO*PT': 1000.0,\n",
" 'ALBINO STEHR JUNIOR*DC': 2900.0,\n",
" 'ALCEBIADES MILTON CABRAL*PR': 10000.0,\n",
" 'ALCENIR JOSE CAETANO*PC do B': 1600.0,\n",
" 'ALCENIR MARIA DA CRUZ ROCHA*PSB': 100463.34,\n",
" 'ALCENIR SEIXAS DOS SANTOS*PSOL': 365.51,\n",
" 'ALCENORA NOGUEIRA ENCARNACAO*PV': 11410.0,\n",
" 'ALCEU JUNIOR DE FARIAS BARRA*PSOL': 458.41,\n",
" 'ALCEU MARON FILHO*PROS': 30000.0,\n",
" 'ALCEU MOREIRA DA SILVA*MDB': 1500000.0,\n",
" 'ALCEU TOTTI SILVEIRA*PSOL': 1432.5,\n",
" 'ALCIDEMAR SANPAIO DE ALMEIDA*PRB': 20000.0,\n",
" 'ALCIDES AMAZONA ARAUJO DOS SANTOS*PC do B': 44000.0,\n",
" 'ALCIDES BELUCI NETO*PRB': 211614.6,\n",
" 'ALCIDES COIMBRA*PSD': 53668.97,\n",
" 'ALCIDES JESUS PERALTA BERNAL*PP': 1312040.0,\n",
" 'ALCIDES RIBEIRO FILHO*PP': 1012040.0,\n",
" 'ALCIDES RODRIGUES FILHO*PRP': 500690.0,\n",
" 'ALCIMAR LOPES DE SOUZA*PR': 6375.0,\n",
" 'ALCIMAR MACIEL PEREIRA*PR': 100000.0,\n",
" 'ALCINDO GABRIELLI*MDB': 45000.0,\n",
" 'ALCIONE GONCALVES VALENTIM*PRTB': 800.0,\n",
" 'ALCIONE LOPES DO NASCIMENTO*PRB': 7295.5,\n",
" 'ALCIONE TONINI DA SILVA*MDB': 66916.7,\n",
" 'ALCIONES MARCOS DAROS*PTB': 4000.01,\n",
" 'ALCIONY REGIA SOARES SANTOS*PSB': 125000.0,\n",
" 'ALCIRA DIONE BUCKER*PV': 3668.9300000000003,\n",
" 'ALCIRIO ZANATA*PPS': 30000.0,\n",
" 'ALDA LUCIA MONTEIRO DE SOUZA*PCO': 2350.0,\n",
" 'ALDACY JESUS DOS SANTOS AGUIAR*PSC': 2625.0,\n",
" 'ALDAIR ALVES DA SILVA*PSOL': 3572.16,\n",
" 'ALDAIR CESAR DA SILVA*DC': 2000.0,\n",
" 'ALDAIR ELIANE SOARES*PR': 50000.0,\n",
" 'ALDAIR JOSE DE ALMEIDA SANTOS*PPL': 2831.5,\n",
" 'ALDALEIA MARREIROS DE SOUZA*PPS': 5000.0,\n",
" 'ALDECIRA PEREIRA FAVELA*PTC': 560.0,\n",
" 'ALDEINO GUIMARAES DOS SANTOS*PSOL': 400.0,\n",
" 'ALDEMIR DOMICIO DA SILVA*PC do B': 4600.0,\n",
" 'ALDEMIR GARCIA DOS SANTOS*PATRI': 14100.0,\n",
" 'ALDEN JOSE LAZARO DA SILVA*PSL': 3354.54,\n",
" 'ALDENICE QUARESMA UCHOA*PROS': 36240.0,\n",
" 'ALDENIR JOSE DA SILVA*PSOL': 365.51000000000005,\n",
" 'ALDERLANIA DA ROCHA SOUZA*SOLIDARIEDADE': 530.0,\n",
" 'ALDI FERREIRA DE SEPULVIDA*MDB': 61500.0,\n",
" 'ALDICLESIO ALVES MAIA*PSOL': 4056.3999999999996,\n",
" 'ALDILEIDE VIEIRA DE ARAUJO*PPS': 3067.0,\n",
" 'ALDILENE MATOS DE SOUZA*PPL': 1690.0,\n",
" 'ALDINEIDE ALMEIDA DE SOUZA SANTOS*PATRI': 1351.88,\n",
" 'ALDINO JORGE BUENO*PR': 150000.0,\n",
" 'ALDISON WISEMAN BARROS DE LYRA*AVANTE': 9972.0,\n",
" 'ALDO FERNANDO BARROS FIGUEREDO*PODE': 69.0,\n",
" 'ALDO JOSIAS DOS SANTOS*PSOL': 7351.83,\n",
" 'ALDO LIMA DA SILVA*PSOL': 5400.0,\n",
" 'ALDO PASSOS AMORIM*PODE': 10000.0,\n",
" 'ALDOVRANDO TELES TORRES*PPS': 3500.0,\n",
" 'ALDRIN NUNES TORRINHA*PROS': 53960.0,\n",
" 'ALEALDO HILARIO DOS SANTOS*PPL': 5831.5,\n",
" 'ALECIO BREDA DIAS*MDB': 156752.79,\n",
" 'ALECSANDRO DE SOUZA SANTOS*DEM': 30000.0,\n",
" 'ALEGNA TEIXEIRA NAZARIO GREIDINGER MODESTO*PSC': 30000.0,\n",
" 'ALEIXO ANDRE MANOEL NETO*PSL': 8474.57,\n",
" 'ALEKSANDER ALLEN NINA PALITOT*PTB': 100000.0,\n",
" 'ALEKSANDRA CARVALHO DA MOTTA*PV': 10000.0,\n",
" 'ALENCAR DACIOLO FONSECA DOS SANTOS*PATRI': 408000.0,\n",
" 'ALENCAR MAGALHAES DA SILVEIRA JUNIOR*PDT': 5956.6900000000005,\n",
" 'ALENCAR SANTANA BRAGA*PT': 516796.23,\n",
" 'ALESANDRO GOMES DE OLIVEIRA*PSC': 810.31,\n",
" 'ALESSANDO DE SOUZA BARBOSA*PRB': 1832.0,\n",
" 'ALESSANDRA ALVES BARBOSA*PR': 9000.0,\n",
" 'ALESSANDRA ALVES CARVALHO*PR': 100000.0,\n",
" 'ALESSANDRA CAMPELO DA SILVA*MDB': 912125.0,\n",
" 'ALESSANDRA CONCEICAO DOS SANTOS*PDT': 20975.0,\n",
" 'ALESSANDRA DA SILVA SANTOS*PRB': 50887.8,\n",
" 'ALESSANDRA DE ALCANTARA ARISTEU ASSIS*PSC': 810.31,\n",
" 'ALESSANDRA DE ASSIS BERRIEL*PPS': 26282.88,\n",
" 'ALESSANDRA DE SOUZA FERRET*PP': 59491.94,\n",
" 'ALESSANDRA FERREIRA DE LIMA*PC do B': 304.0,\n",
" 'ALESSANDRA FERREIRA ROSA*PP': 237450.0,\n",
" 'ALESSANDRA MACHADO DA SILVA*PHS': 1000.0,\n",
" 'ALESSANDRA MADUREIRA DA SILVA*PRTB': 800.0,\n",
" 'ALESSANDRA MAIA VASCONCELOS SANTOS*PSDB': 180516.44,\n",
" 'ALESSANDRA MARQUES RIBEIRO*AVANTE': 1125.0,\n",
" 'ALESSANDRA MOREIRA DA COSTA*AVANTE': 29334.84,\n",
" 'ALESSANDRA PINTO PINHEIRO*PDT': 17500.0,\n",
" 'ALESSANDRA REGINA BEGALLI ZAMORA*PP': 821922.0,\n",
" 'ALESSANDRA RODRIGUES CIACCI*PV': 3147.65,\n",
" 'ALESSANDRA ROSE DE RESENDE JACOB*PODE': 20000.0,\n",
" 'ALESSANDRA RUDOLPHO STRINGHETA BARBOSA*PSL': 10000.0,\n",
" 'ALESSANDRA TELES MARINHO TORRES BANDEIRA*PSDB': 117625.0,\n",
" 'ALESSANDRA TRINDADE SHIMOMOTO*PT': 7796.23,\n",
" 'ALESSANDRA XAVIER DA ROCHA VIEIRA*PSDB': 561875.0,\n",
" 'ALESSANDRI DA ROCHA ALMEIDA*PSDB': 252250.0,\n",
" 'ALESSANDRO AMORIM DE OLIVEIRA*AVANTE': 1101.79,\n",
" 'ALESSANDRO AQUINO CIRQUEIRA*PCO': 1350.0,\n",
" 'ALESSANDRO AUGUSTO DA SILVA*PSB': 1250.0,\n",
" 'ALESSANDRO BARBOSA DOS PRAZERES*PSL': 435.0,\n",
" 'ALESSANDRO CEZAR ARAUJO AZEVEDO*PT': 2796.23,\n",
" 'ALESSANDRO DA COSTA JERONIMO*DC': 1200.0,\n",
" 'ALESSANDRO DE OLIVEIRA GOMES*PSC': 120000.0,\n",
" 'ALESSANDRO FREZATTO*PPS': 5000.0,\n",
" 'ALESSANDRO JOSE DE OLIVEIRA*PTB': 202.0,\n",
" 'ALESSANDRO LUCCIOLA MOLON*PSB': 1300000.0,\n",
" 'ALESSANDRO MANOEL RODRIGUES*PHS': 300.0,\n",
" 'ALESSANDRO MARTINS ALVES*PROS': 158131.72999999998,\n",
" 'ALESSANDRO OTAVIO DE SOUZA RIBEIRO NEVES*PRTB': 20.0,\n",
" 'ALESSANDRO PEREIRA DOS SANTOS*AVANTE': 1101.79,\n",
" 'ALESSANDRO PINHEIRO*DC': 5028.0,\n",
" 'ALESSANDRO SILVA DA COSTA*PRB': 14387.5,\n",
" 'ALESSANDRO TAVARES TEIXEIRA*SOLIDARIEDADE': 15000.0,\n",
" 'ALESSANDRO VILLANE DA SILVA*SOLIDARIEDADE': 200.0,\n",
" 'ALESSON LOUREIRO CAVALCANTE*PP': 100000.0,\n",
" 'ALEX BATISTA GOMES*PODE': 1454.19,\n",
" 'ALEX CANZIANI SILVEIRA*PTB': 1395762.2200000002,\n",
" 'ALEX CLEITON SA*PSB': 1000.0,\n",
" 'ALEX DE CASTRO LIMA*PSB': 20000.0,\n",
" 'ALEX DE SOUSA OLIVEIRA*PSC': 810.31,\n",
" 'ALEX DOUGLAS DOS SANTOS*PSD': 50000.0,\n",
" 'ALEX FERREIRA ALMEIDA*DC': 4090.0,\n",
" 'ALEX FIGUEIREDO DE ARAUJO*REDE': 1760.0,\n",
" 'ALEX GOMES DA SILVA*PC do B': 1600.0,\n",
" 'ALEX JOSE DE AQUINO SANTIAGO*PR': 214325.3,\n",
" 'ALEX LIMA ROLA*PCO': 1350.0,\n",
" 'ALEX LOPES DA SILVA*PSD': 150000.0,\n",
" 'ALEX LUCIO DA SILVA*DC': 1000.0,\n",
" 'ALEX LUIS DE SOUZA*PR': 50000.0,\n",
" 'ALEX LUIZ DA ROSA*PHS': 300.0,\n",
" 'ALEX NECKER*PC do B': 40000.0,\n",
" 'ALEX OLIVEIRA DA SILVA*PT': 15000.0,\n",
" 'ALEX PEREIRA DIAS BOTELHO*PDT': 12502.3,\n",
" 'ALEX RABELO DE ARAUJO*MDB': 70000.0,\n",
" 'ALEX SANDRO DA CONCEICAO NUNES DA SILVA*SOLIDARIEDADE': 4307.400000000001,\n",
" 'ALEX SANDRO DIAS REIS*PPS': 10000.0,\n",
" 'ALEX SANDRO GOMES*PT': 15000.0,\n",
" 'ALEX SPINELLI MANENTE*PPS': 1168128.11,\n",
" 'ALEXANDER DA VEIGA*DC': 500.0,\n",
" 'ALEXANDER GONCALVES DA SILVA*PTC': 2180.0,\n",
" 'ALEXANDER MUNIZ DE OLIVEIRA*PSD': 500000.0,\n",
" 'ALEXANDRA PEREIRA DE OLIVEIRA GARRIDO*PATRI': 1121.88,\n",
" 'ALEXANDRE ABUTRAB NASCIMENTO GUERRA*PATRI': 5443.11,\n",
" 'ALEXANDRE AGUIAR CARDOSO*PSD': 950000.0,\n",
" 'ALEXANDRE ALELUIA DANTAS DA COSTA*DEM': 210000.0,\n",
" 'ALEXANDRE AMARO*PRB': 101140.45999999999,\n",
" 'ALEXANDRE APPEL DA SILVA*PSD': 25000.0,\n",
" 'ALEXANDRE ARANTES BISINOTTO*PHS': 13600.0,\n",
" 'ALEXANDRE ARAUJO COSTA*PSOL': 19074.08,\n",
" 'ALEXANDRE ARAUJO DAUAGE*PRB': 50000.0,\n",
" 'ALEXANDRE AUGUSTO FERREIRA*SOLIDARIEDADE': 213866.52000000002,\n",
" 'ALEXANDRE AUGUSTUS SERFIOTIS*PSD': 1050000.0,\n",
" 'ALEXANDRE BASTOS RODRIGUES*PSB': 10000.0,\n",
" 'ALEXANDRE BEZERRA CHAVES*PSC': 810.31,\n",
" 'ALEXANDRE BRITO DE FIGUEIREDO*MDB': 150000.0,\n",
" 'ALEXANDRE CARLOS ARAUJO DE SANTANA*PC do B': 5000.0,\n",
" 'ALEXANDRE COELHO DA CONCEICAO*PR': 10000.0,\n",
" 'ALEXANDRE DA COSTA BARBOSA*PSDB': 8475.0,\n",
" 'ALEXANDRE DA SILVA MACABU*PSC': 10810.310000000001,\n",
" 'ALEXANDRE DA SILVA PIMENTEL*PPL': 1877.77,\n",
" 'ALEXANDRE DAVID DE MIRANDA CARVALHO*PSD': 50000.0,\n",
" 'ALEXANDRE DE AVIZ PEREIRA*PMB': 2380.0,\n",
" 'ALEXANDRE DE JESUS SILVA YANEZ*PP': 1987.02,\n",
" 'ALEXANDRE DE MELO BAIA*PHS': 2875.75,\n",
" 'ALEXANDRE DE OLIVEIRA MORAIS*PATRI': 2300.0,\n",
" 'ALEXANDRE DE OLIVEIRA*AVANTE': 8601.79,\n",
" 'ALEXANDRE DE SOUZA ANDRADE*PSB': 500000.0,\n",
" 'ALEXANDRE DELAO DA SILVA*PODE': 956.69,\n",
" 'ALEXANDRE DOURADO MAPURUNGA*PSOL': 12438.72,\n",
" 'ALEXANDRE EURIPIDES DOS SANTOS*MDB': 20000.0,\n",
" 'ALEXANDRE FEITOSA DA SILVA*SOLIDARIEDADE': 3032.13,\n",
" 'ALEXANDRE FELIPE DUARTE CORRADI*PSD': 30000.0,\n",
" 'ALEXANDRE FERNANDES DA SILVA*PHS': 5000.0,\n",
" 'ALEXANDRE FERNANDES VIEIRA*PSC': 810.31,\n",
" 'ALEXANDRE FERREIRA DE CASTRO E SILVA*PT': 200.0,\n",
" 'ALEXANDRE FERREIRA DE SOUSA*PATRI': 20032.5,\n",
" 'ALEXANDRE FERREIRA DOS SANTOS*PRB': 28462.139999999996,\n",
" 'ALEXANDRE FERREIRA LIMA*PSOL': 365.51000000000005,\n",
" 'ALEXANDRE FIGUEIREDO DE ARAUJO*REDE': 1760.0,\n",
" 'ALEXANDRE FLACH DOMINGUES*PCO': 1350.0,\n",
" 'ALEXANDRE GEBLER*PSDB': 16875.0,\n",
" 'ALEXANDRE GLUSKOSKI VENEGAS*PSDB': 52250.0,\n",
" 'ALEXANDRE GOMES MARQUES*PRP': 200000.0,\n",
" 'ALEXANDRE GONCALVES PAIVA*PMN': 30000.0,\n",
" 'ALEXANDRE GONCALVES PINHEIRO*PROS': 350.0,\n",
" 'ALEXANDRE GUEDES BARBOSA*DC': 1000.0,\n",
" 'ALEXANDRE JACINTO*PSL': 20000.0,\n",
" 'ALEXANDRE JOSE PINHEIRO RODRIGUES*PHS': 3449.0,\n",
" 'ALEXANDRE LEITE DA SILVA*DEM': 875000.0,\n",
" 'ALEXANDRE LIMA DA COSTA*PMB': 6000.0,\n",
" 'ALEXANDRE LIMA DE OLIVEIRA*PV': 6673.68,\n",
" 'ALEXANDRE LIRA DE SOUZA*AVANTE': 12737.2,\n",
" 'ALEXANDRE LOPES DE REZENDE*PMN': 50000.0,\n",
" 'ALEXANDRE LUIS PINTO*PC do B': 670.0,\n",
" 'ALEXANDRE LUZ DE ALMEIDA*PMB': 1707.67,\n",
" 'ALEXANDRE MACHADO ANDRADE*SOLIDARIEDADE': 20000.0,\n",
" 'ALEXANDRE MACHADO MAIA*PSOL': 783.24,\n",
" 'ALEXANDRE MAGNO COLA*AVANTE': 18022.3,\n",
" 'ALEXANDRE MARANHAO KHURY*PSB': 100000.0,\n",
" 'ALEXANDRE MARCELO COUTINHO SANTOS*PDT': 5000.0,\n",
" 'ALEXANDRE MARTINS DE CASTRO*PRB': 4000.0,\n",
" 'ALEXANDRE MARTINS RICCI*SOLIDARIEDADE': 11503.17,\n",
" 'ALEXANDRE MAURO PRADO*PSL': 1850.0,\n",
" 'ALEXANDRE MEDEIROS DA SILVA*PRB': 2110.0,\n",
" 'ALEXANDRE MIGUEL COSTA*AVANTE': 1101.79,\n",
" 'ALEXANDRE MIGUEZ RIBEIRO*SOLIDARIEDADE': 3714.2799999999997,\n",
" 'ALEXANDRE MILANESE CAMILLO*PSD': 25000.0,\n",
" 'ALEXANDRE MILANI DAS CHAGAS*AVANTE': 8601.789999999999,\n",
" 'ALEXANDRE MOTTA CAMARA*PT': 260000.0,\n",
" 'ALEXANDRE PAIVA DAMASCENO*PROS': 30520.0,\n",
" 'ALEXANDRE PEREIRA DA SILVA*SOLIDARIEDADE': 759310.3399999999,\n",
" 'ALEXANDRE PERES SIMON*PV': 407.55,\n",
" 'ALEXANDRE PIMENTA ARAUJO*MDB': 10000.0,\n",
" 'ALEXANDRE PINHEIRO COSTA*PSOL': 1703.11,\n",
" 'ALEXANDRE QUINTINO MOREIRA*PSL': 14000.0,\n",
" 'ALEXANDRE ROCHA SANTOS PADILHA*PT': 902796.23,\n",
" 'ALEXANDRE RODRIGO XAVIER BERRETA*PRTB': 1380.0,\n",
" 'ALEXANDRE SAID BUSSAB*PSL': 8474.57,\n",
" 'ALEXANDRE SERGIO DE OLIVEIRA AZOUBEL*PRP': 30000.0,\n",
" 'ALEXANDRE SILVA*SOLIDARIEDADE': 3032.1299999999997,\n",
" 'ALEXANDRE SOARES DA SILVA*DC': 4509.0,\n",
" 'ALEXANDRE TADEU LUZIANI NEGRI*PV': 8000.0,\n",
" 'ALEXANDRE TEIXEIRA*PODE': 1234.0900000000001,\n",
" 'ALEXANDRE TOMAZ DA SILVA*AVANTE': 3535.05,\n",
" 'ALEXANDRE TORTORELLA MANDL*PSOL': 76.27,\n",
" 'ALEXANDRE TRAVASSOS SESTO*PMB': 4000.0,\n",
" 'ALEXANDRE VALLE CARDOSO*PR': 2310000.0,\n",
" 'ALEXANDRE VICENTE DE PAULA ALMEIDA*PSDB': 1065400.0,\n",
" 'ALEXANDRI FIGUEIREDO*PATRI': 1800.0,\n",
" 'ALEXANDRINA DA SILVA VASQUES*PRP': 10089.07,\n",
" 'ALEXANDRINA LOPES DE ALMEIDA FALCAO*PHS': 200.0,\n",
" 'ALEXANDRO DE ARAUJO*PRB': 110985.0,\n",
" 'ALEXANDRO DOS SANTOS TIMOTEO*PSL': 5730.95,\n",
" 'ALEXANDRO DUARTE COLI*PPL': 138.0,\n",
" 'ALEXANDRO MALVARUO*PSDB': 2673.14,\n",
" 'ALEXINA BEZERRA CAVALCANTI ALVES*MDB': 54800.0,\n",
" 'ALEXIS DEMOSTENES UCHOA*PSDB': 5678.32,\n",
" 'ALEXIS JEFFERSON DOS SANTOS*PRP': 360.0,\n",
" 'ALEXSANDER FRAGA DA SILVA*PSOL': 19989.85,\n",
" 'ALEXSANDER PRETTI DOMINGOS*PR': 22500.0,\n",
" 'ALEXSANDRA APARECIDA BECHELLI SILVA*MDB': 30000.0,\n",
" 'ALEXSANDRA GREGORIO DA SILVA*REDE': 400.0,\n",
" 'ALEXSANDRA MADEIRA DA SILVA*PR': 10900.0,\n",
" 'ALEXSANDRA SILVA SANTOS DE MELO*AVANTE': 2050.0,\n",
" 'ALEXSANDRA VIANA PEREIRA*PSDB': 7250.0,\n",
" 'ALEXSANDRO BRITO SANTOS*REDE': 2918.1099999999997,\n",
" 'ALEXSANDRO DA SILVA BARBOSA*PSD': 10000.0,\n",
" 'ALEXSANDRO DA SILVA GIGANTE*PTB': 4000.01,\n",
" 'ALEXSANDRO DA SILVA SANTOS*REDE': 110.0,\n",
" 'ALEXSANDRO DE JESUS PEREIRA*AVANTE': 8601.79,\n",
" 'ALEXSANDRO GOMES DA SILVA*DC': 2600.0,\n",
" 'ALEXSANDRO MANHAGUANHA*PSD': 57120.0,\n",
" 'ALEXYA LUCAS EVANGELISTA SALVADOR*PSOL': 1735.48,\n",
" 'ALEY SEGUNDO DAMASCENO GIRAO*PATRI': 1800.0,\n",
" 'ALFEN AIOLFI PINHEIRO*PR': 10000.0,\n",
" 'ALFINA MARIA DE ANDRADE*PC do B': 6909.1,\n",
" 'ALFREDO ALVES CAVALCANTE*PT': 509796.23,\n",
" 'ALFREDO BOA SORTE JUNIOR*PSOL': 3721.11,\n",
" 'ALFREDO BRAGA DE CASTRO*PDT': 61983.5,\n",
" 'ALFREDO CARDOSO COSTA*PT': 38500.0,\n",
" 'ALFREDO CARDOSO TEIXEIRA FILHO*AVANTE': 19891.5,\n",
" 'ALFREDO CROSSETTI SIMON*PSD': 15000.0,\n",
" 'ALFREDO DA SILVA AMBROZIONI*PRP': 460.0,\n",
" 'ALFREDO FARINA JUNIOR*PRTB': 216.64,\n",
" 'ALFREDO MOACIR DA SILVA*PR': 5000.0,\n",
" 'ALFREDO ORLANDO BENITES AQUINO*PPS': 10751.05,\n",
" 'ALFREDO PAULO MARQUES RODRIGUES*PSD': 100000.0,\n",
" 'ALFREDO PEREIRA DO NASCIMENTO*PR': 2678417.2,\n",
" 'ALFREDO SILVA DE AZEVEDO*PRB': 14320.0,\n",
" 'ALFREDO SOARES DE MOURA*PROS': 85750.0,\n",
" 'ALI MUSTAFA KARFAN NETO*PR': 350000.0,\n",
" 'ALIANY CAROLINE DE MORAIS GUEDES FAVACHO*PHS': 300000.0,\n",
" 'ALICE ARLINDA SANTOS SOBRAL*REDE': 1046.0,\n",
" 'ALICE CARULINA VAZ SANT ANA SANTOS*PSOL': 400.0,\n",
" 'ALICE CARVALHO DA SILVA DOS SANTOS*PSOL': 4989.85,\n",
" 'ALICE DE SOUZA DO NASCIMENTO*MDB': 10000.0,\n",
" 'ALICE DOS SANTOS GABINO*REDE': 40000.0,\n",
" 'ALICE LOPES DE ANDRADE E SILVA LEBRE*PV': 15493.96,\n",
" 'ALICE MAZZUCO PORTUGAL*PC do B': 1448438.23,\n",
" 'ALICE RODRIGUES DA SILVA COELHO*PTB': 120000.0,\n",
" 'ALICE SILVA*PV': 7703.12,\n",
" 'ALICE TERESINHA BOTH*PV': 4230.93,\n",
" 'ALIEL MACHADO BARK*PSB': 1350000.0,\n",
" 'ALINE APARECIDA RIBEIRO DE SOUZA*REDE': 800.0,\n",
" 'ALINE BRITO MARTINS DA FONSECA*PP': 65000.0,\n",
" 'ALINE CAVALCANTE CONCEICAO DA SILVA ROSA*PATRI': 6000.0,\n",
" 'ALINE DA SILVA GOMES*PRP': 10000.0,\n",
" 'ALINE DA SILVA GONCALVES RIBEIRO*PROS': 10540.0,\n",
" 'ALINE DE CARVALHO MARTINS REIS*DEM': 10000.0,\n",
" 'ALINE DE CARVALHO*PV': 2000.0,\n",
" 'ALINE DE OLIVEIRA BARROS FREITAS*PPS': 1555.55,\n",
" 'ALINE LEMOS CORREA DE OLIVEIRA ANDRADE*PR': 800000.0,\n",
" 'ALINE LIMA FERNANDES*PHS': 11550.0,\n",
" 'ALINE LOPES DA SILVA*PSL': 2857.14,\n",
" 'ALINE MANGUEIRA SANTOS*PTB': 20450.0,\n",
" 'ALINE MARIA DE MOURA*SOLIDARIEDADE': 27098.67,\n",
" 'ALINE MARIA DOS SANTOS PEREIRA*PSOL': 3572.16,\n",
" 'ALINE MULLER DA SILVEIRA*PDT': 10000.0,\n",
" 'ALINE NASCIMENTO BARROZO TORRES*PSDB': 102250.0,\n",
" 'ALINE PARANHOS VARONIL GURGEL*PRB': 1952976.22,\n",
" 'ALINE PINHEIRO ROCHA SILVEIRA*PATRI': 11619.0,\n",
" 'ALINE RENATA VENTURINI*PDT': 15000.0,\n",
" 'ALINE SOARES NOGUEIRA*PV': 57850.51,\n",
" 'ALINE STEINKE*MDB': 55000.0,\n",
" 'ALINI SANTANA DE OLIVEIRA SILVA*PDT': 10000.0,\n",
" 'ALINNE DE SOUZA MARQUES*PPL': 1500.0,\n",
" 'ALINNE DO ROSARIO BRITO*PSOL': 28685.39,\n",
" 'ALIPIO RODRIGUES DE OLIVEIRA*PATRI': 11483.2,\n",
" 'ALIRIO CAVALCANTI FERREIRA*DC': 3500.0,\n",
" 'ALIRIO VILLASANTI ROMERO*PHS': 10000.0,\n",
" 'ALISCINDA TIBERIO*PPS': 73008.01,\n",
" 'ALISSANDRA CARVALHO DA SILVA*DEM': 68750.0,\n",
" 'ALISSON ANTHONY WANDSCHEER*PMB': 739800.0,\n",
" 'ALISSON SOUSA CASTRO*PSOL': 4841.12,\n",
" 'ALISSON THIESEN BIAZUSSI*PT': 6250.0,\n",
" 'ALLAN ALBERT LOURENCO FERREIRA*PRB': 17500.0,\n",
" 'ALLAN MANOEL DE AGUIAR BRAZ*PV': 2000.0,\n",
" 'ALLAN ROSAS SALES*PPS': 67000.0,\n",
" 'ALLANA RAQUEL BERNARDINO DA CUNHA*PSOL': 3770.5699999999997,\n",
" 'ALLEFFE BRUCE DE OLIVEIRA MARTINS*PODE': 700956.69,\n",
" 'ALLINNY SOUSA DA ROCHA*DEM': 325000.0,\n",
" 'ALLINY FERNANDA SARTORI PADALINO ROGERIO*SOLIDARIEDADE': 320003.74000000017,\n",
" 'ALLISON ALBERTO TENORIO MADRUGA*PV': 3333.33,\n",
" 'ALLYSON LEANDRO BEZERRA SILVA*SOLIDARIEDADE': 12156.77,\n",
" 'ALMERINDA MARIA DA SILVA FERREIRA PACHECO*PHS': 9000.0,\n",
" 'ALMIR DE ALEXANDRES*PATRI': 37570.4,\n",
" 'ALMIR MARQUES*PRTB': 2284.23,\n",
" 'ALMIR ROBERTO CICOTE*AVANTE': 50000.0,\n",
" 'ALMIR VALENTE FELITTE*PSOL': 1861.27,\n",
" 'ALMIR VIEIRA*PP': 45000.0,\n",
" 'ALMIRANDO ANTONIO DE OLIVEIRA*PROS': 585067.98,\n",
" 'ALMIRO CRISTOVAO DO NASCIMENTO*PRB': 8400.0,\n",
" 'ALOISIO BAMBERG*PC do B': 83935.0,\n",
" 'ALOISIO BUENO*PSL': 18474.57,\n",
" 'ALOISIO CALSONI BOZZINI*REDE': 1200.0,\n",
" 'ALOISIO MOREIRA DOS SANTOS*DEM': 30206.19,\n",
" 'ALOISIO TALSO CLASSMANN*PTB': 140000.0,\n",
" 'ALONSO GOMES DE ANDRADE*PV': 17701.920000000002,\n",
" 'ALSOM PEREIRA DA SILVA*PRB': 26000.0,\n",
" 'ALTAIR BATISTA JUNIOR*PRB': 5324.1,\n",
" 'ALTAIR DA SILVA*PP': 170000.0,\n",
" 'ALTAIR DE LIMA BRANDAO*PC do B': 10000.0,\n",
" 'ALTAIR JOSE ZAMPIER*PR': 50000.0,\n",
" 'ALTAIR LEONILDO DA SILVA*PC do B': 600.0,\n",
" 'ALTAIR MORAES DE OLIVEIRA*PRB': 702303.35,\n",
" 'ALTAIR SALES COUTINHO*PR': 83995.0,\n",
" 'ALTAISA DA SILVA TEIXEIRA*PSL': 4160.139999999999,\n",
" 'ALTAMIR GUALBERTO SALGADO*PT': 15000.0,\n",
" 'ALTAMIRO MAXIMO DE OLIVEIRA*PP': 4513.0,\n",
" 'ALTANIRA ULCHOA ALMEIDA OLIVEIRA*MDB': 18240.0,\n",
" 'ALTEMIR ANTONIO TORTELLI*PT': 33000.0,\n",
" 'ALTINEU CORTES FREITAS COUTINHO*PR': 1354335.0,\n",
" 'ALTINO ALMEIDA SILVA*PSD': 5000.0,\n",
" 'ALTINO MENDES DA COSTA COBRINHO*PSOL': 4975.04,\n",
" 'ALTMIR ABDIAS JUVENCIO DE ALMEIDA*PTB': 24496.7,\n",
" 'ALTOMIRO LUCENA ROMAO*PSOL': 365.51000000000005,\n",
" 'ALTONOMISTA BEZERRA DA SILVA*PV': 10000.0,\n",
" 'ALUISIO GUIMARAES MENDES FILHO*PODE': 605000.0,\n",
" 'ALUIZIO VIDAL FLOR*REDE': 65000.0,\n",
" 'ALVACIR AIMI*PT': 15000.0,\n",
" 'ALVANIRA SOARES PALMELA*PT': 6900.0,\n",
" 'ALVARO ADERALDO CHAVES FILHO*PSDB': 3919.6299999999997,\n",
" 'ALVARO AMERICO CONCEICAO*PSL': 1551.0,\n",
" 'ALVARO BATISTA CAMILO*PSD': 505456.0,\n",
" 'ALVARO BRUNO CASTRO GARCIA*PV': 13000.0,\n",
" 'ALVARO CESAR MACHADO*PRP': 657.0,\n",
" 'ALVARO DAMIAO VIEIRA DA PAZ*DEM': 576186.13,\n",
" 'ALVARO DANTAS BRAGA*PDT': 1000.0,\n",
" 'ALVARO DAVI BOESSIO*MDB': 150000.0,\n",
" 'ALVARO DE ARAUJO LOBO*PSOL': 2931.56,\n",
" 'ALVARO FERNANDES DIAS*PODE': 3300000.0,\n",
" 'ALVARO HENRIQUE DE SOUZA OLIVEIRA*SOLIDARIEDADE': 2500.0,\n",
" 'ALVARO JOSE DA CONCEICAO SOUZA*PRB': 19735.0,\n",
" 'ALVARO PORTO DE BARROS*PTB': 50000.0,\n",
" 'ALVARO RODRIGUES COELHO*PTB': 50000.0,\n",
" 'ALVARO SOARES GUIMARAES*DEM': 50206.19,\n",
" 'ALVERINO BATISTA LEMOS*PSOL': 4974.74,\n",
" 'ALYSSON FRANCISCO DE LIMA*PRB': 100000.0,\n",
" 'ALYSSON LOPES PINTO*DC': 3500.0,\n",
" 'ALZEMIRA DE LIMA MARINS*SOLIDARIEDADE': 5000.0,\n",
" 'ALZENI RODRIGUES DOS SANTOS*MDB': 10000.0,\n",
" 'ALZENICE LIMA VITO*PMB': 4000.0,\n",
" 'ALZENIR DE SOUZA SANTOS*PSDB': 7250.0,\n",
" 'ALZERMIRIAN ALVES FREITAS*PATRI': 5005.0,\n",
" 'ALZIMAR ANDRADE SILVA*PSB': 5000.0,\n",
" 'ALZINIR SANTANA DE FREITAS*PTB': 254000.0,\n",
" 'ALZIRA ANTONIA DE SOUZA NOGUEIRA*PSOL': 4755.74,\n",
" 'ALZIRA BOMBONATO DE MELO RIOS DA SILVA*PSOL': 3569.42,\n",
" 'ALZIRA DE MORAES VIEIRA*PROS': 100000.0,\n",
" 'ALZIRA MARIA DOS PASSOS FOLHA*PSB': 74500.0,\n",
" 'ALZYRA IZABEL DA SILVA LIMA*PHS': 45000.0,\n",
" 'AMABILE APARECIDA PACIOS*PR': 320000.0,\n",
" 'AMADEU FERREIRA*PSD': 31337.5,\n",
" 'AMADEU JOSE DE OLIVEIRA AGUIAR SARINHO*PSDB': 250.0,\n",
" 'AMALIA FERNANDES*PRP': 16.0,\n",
" 'AMALIA MARIA SANTANA DA SILVA*PT': 210000.0,\n",
" 'AMANCIO DOS SANTOS FERREIRA*PSDB': 1875.0,\n",
" 'AMANDA ALBRECHT DE JESUS*PT': 5000.0,\n",
" 'AMANDA ALICE PRADO CHEIDA BILESKI*PV': 11358.18,\n",
" 'AMANDA BARBOSA ALVES*PATRI': 4800.0,\n",
" 'AMANDA CANDIDO DE SA SILVA*SOLIDARIEDADE': 250.0,\n",
" 'AMANDA CESARIO FERREIRA*PSDB': 98918.75,\n",
" 'AMANDA CRISTINA LOPES DA SILVA*PSC': 3450.0,\n",
" 'AMANDA FRUGOLI FERNANDES ALMEIDA*AVANTE': 1194.4299999999998,\n",
" 'AMANDA LIMA DE OLIVEIRA*DC': 800.0,\n",
" 'AMANDA MANOELE DOS SANTOS GONCALVES*PATRI': 235.0,\n",
" 'AMANDA SANTOS DA SILVA*PATRI': 13524.5,\n",
" 'AMANDA SIQUEIRA NOVAES*PROS': 217500.0,\n",
" 'AMANDA VICTORIA DE LIMA LESKA*PSDB': 40000.0,\n",
" 'AMANDA VIRGINIA ALBUQUERQUE DOS SANTOS*PSL': 13000.01,\n",
" 'AMANDALA MACHADO DE ARAUJO*PRTB': 2509.23,\n",
" 'AMANDIO CESAR DOS SANTOS AVILA*PV': 6673.68,\n",
" 'AMANTINO MOTA MENDES*PP': 4513.0,\n",
" 'AMARILDO CABRAL*PSDB': 1875.0,\n",
" 'AMARILDO DA SILVA PEREIRA*PSDB': 6678.32,\n",
" 'AMARILDO GONCALVES*PODE': 320000.0,\n",
" 'AMARILDO JORGE VILHENA DE SOUZA*PDT': 1000.0,\n",
" 'AMARILDO NARCISO*PSOL': 3371.22,\n",
" 'AMARILDO VALDO DA CRUZ*PT': 40000.0,\n",
" 'AMARILIO BRAGA*PSB': 3463.34,\n",
" 'AMARO FRANCISCO DE MORAES*DC': 2000.0,\n",
" 'AMARO ROCHA NASCIMENTO NETO*PRB': 1365000.0,\n",
" 'AMAURI CHAVES DE OLIVEIRA*PROS': 25000.0,\n",
" 'AMAURI COSTA SALES DA SILVA*PSOL': 2605.95,\n",
" 'AMAZONICA BRASIL MAGALLANS LUJAN*PROS': 179555.47,\n",
" 'AMAZONINO ARMANDO MENDES*PDT': 3900000.0,\n",
" 'AMELIA NAOMI OMURA*PT': 510796.23,\n",
" 'AMELIA RENATA MANARA DOMENI GASTI*PPL': 500.0,\n",
" 'AMELIA ROSA DO NASCIMENTO*MDB': 5000.0,\n",
" 'AMELIA VERONICA GONCALVES DE OLIVEIRA*PTB': 10000.0,\n",
" 'AMELIO CAYRES DE ALMEIDA*SOLIDARIEDADE': 208798.0,\n",
" 'AMERICA TEREZA NASCIMENTO DA SILVA*MDB': 380000.0,\n",
" 'AMERICO ALEXANDRE CIANFARANI XAVIER*DC': 500.0,\n",
" 'AMERICO FERREIRA DA SILVA*PSOL': 1085.67,\n",
" 'AMERICO RODRIGUES VIDINHA NETO*PTC': 87480.0,\n",
" 'AMILCAR XIMENES PONTE*PT': 15003.0,\n",
" 'AMILTON ALVES GOMES*PPS': 10000.0,\n",
" 'AMILTON BATISTA DE FARIA FILHO*SOLIDARIEDADE': 39000.0,\n",
" 'AMILTON DOS SANTOS*PROS': 10000.0,\n",
" 'AMILTON FARIAS*REDE': 625.0,\n",
" 'AMINTAS OLIVEIRA BATISTA*PTB': 52900.0,\n",
" 'AMIRALDO DA SILVA FAVACHO JUNIOR*DEM': 100000.0,\n",
" 'AMOS BISPO PEREIRA*MDB': 80000.0,\n",
" 'AMRIA DE RIBAMAR DO NASCIMENTO*DC': 5975.0,\n",
" 'ANA ALICE LOPES BOA NOVA*PPS': 11763.86,\n",
" 'ANA ANGELICA DE OLIVEIRA DA SILVA*PSL': 5245.139999999999,\n",
" 'ANA BARBOSA CORREIA*DC': 4157.910000000001,\n",
" 'ANA CARLA BEZERRA RIBEIRO*PC do B': 880.0,\n",
" 'ANA CARLA CARNEIRO DA CUNHA PINTO LAPA*PSC': 110000.0,\n",
" 'ANA CARLA CORREA COSTA*PPS': 6000.0,\n",
" 'ANA CARLA NOVAIS DOS SANTOS*PPL': 2500.0,\n",
" 'ANA CARLA VARELA DO NASCIMENTO*PODE': 650000.0,\n",
" 'ANA CARLOLINA DIAS RAMOS*PODE': 7366.0,\n",
" 'ANA CAROLINA BONDEZAN NOGUEIRA*PSOL': 577.0,\n",
" 'ANA CAROLINA PONTELO CANABRAVA*AVANTE': 241535.91,\n",
" 'ANA CAROLINA QUINTANA DE SERPA VIEIRA*PSOL': 6034.37,\n",
" 'ANA CAROLINE TEIXEIRA DIAS*PPS': 2000.0,\n",
" 'ANA CASSIA DE OLIVEIRA CONCEICAO SANTOS*PSC': 8616.54,\n",
" 'ANA CELIA BARBOSA DE ALMEIDA*PRB': 24082.8,\n",
" 'ANA CELIA BRAGA DE OLIVEIRA*MDB': 21880.0,\n",
" 'ANA CLAUDIA BELONCI DE CARVALHO*PPS': 5000.0,\n",
" 'ANA CLAUDIA BITENCOURT CLAUDINO*PMN': 200000.0,\n",
" 'ANA CLAUDIA CALLOU MATOS*PSB': 500000.0,\n",
" 'ANA CLAUDIA COTTAS SILVA*PSC': 810.31,\n",
" 'ANA CLAUDIA DA SILVA LIMA*DC': 100000.0,\n",
" 'ANA CLAUDIA DE MORAES NEVES*MDB': 63400.0,\n",
" 'ANA CLAUDIA FERREIRA DE PAIVA*PDT': 10000.0,\n",
" 'ANA CLAUDIA MARTIN CALDAS*PSDB': 31875.0,\n",
" 'ANA CLAUDIA NOGUEIRA*PRP': 4028.0,\n",
" 'ANA CLAUDIA NONATO CASTILHO*PMB': 4000.0,\n",
" 'ANA CLAUDIA OLIVEIRA DA NOBREGA VITAL DO REGO*PODE': 1000000.0,\n",
" 'ANA CLAUDIA PERES LUCAS LOPES*PSL': 13975.24,\n",
" 'ANA CLAUDIA QUEIROZ DE LIMA*DEM': 50000.0,\n",
" 'ANA CLAUDIA RIBEIRO DAMASCENO*PV': 6875.0,\n",
" 'ANA CLAUDIA SILVA DE MELO*PDT': 10000.0,\n",
" 'ANA CLAUDIA SILVA MIELKE*PSOL': 5458.67,\n",
" 'ANA CRISTINA ALVES*PODE': 30830.03,\n",
" 'ANA CRISTINA AUGUSTA DA SILVA ENCARNACAO*PDT': 13000.0,\n",
" 'ANA CRISTINA CAVALCANTE BEZERRA*PC do B': 9572.15,\n",
" 'ANA CRISTINA DA SILVA COSTA*PSDB': 51875.0,\n",
" 'ANA CRISTINA DE LIMA*PSOL': 2127.66,\n",
" 'ANA CRISTINA DE OLIVEIRA*AVANTE': 3000.0,\n",
" 'ANA CRISTINA DOS SANTOS NEVES BRAGA*PSL': 2857.14,\n",
" 'ANA CRISTINA ESPINOLA CANDIA*PSDB': 200891.44,\n",
" 'ANA CRISTINA GONCALVES DE ABREU SOUZA*PSB': 100000.0,\n",
" 'ANA CRISTINA JOSE DE SANTANA*PR': 1000.0,\n",
" 'ANA CRISTINA NEVES*SOLIDARIEDADE': 200.0,\n",
" 'ANA CRISTINA OLIVEIRA DOS SANTOS SILVA*PR': 11190.0,\n",
" 'ANA CRISTINA PIRES POLICARPO*DC': 20000.0,\n",
" 'ANA CRISTINA RIBEIRO CARDOSO*PV': 5000.0,\n",
" 'ANA CRISTINA ROBERTO*PT': 74500.0,\n",
" 'ANA CRISTINA SIQUEIRA VALLE*PODE': 45.45,\n",
" 'ANA CRISTINA TEIXEIRA ARAUJO*PATRI': 2210.5,\n",
" 'ANA CRISTINA WANDERLEY*PRP': 2866.0,\n",
" 'ANA CYNTIA AZEVEDO PINTO*PRP': 3600.0,\n",
" 'ANA DA SILVA FERNANDES*PV': 19000.0,\n",
" 'ANA ELISABETE FERREIRA BARBOSA*PSL': 1263.0,\n",
" 'ANA ELIZA BARRETO MACHADO*MDB': 20000.0,\n",
" 'ANA ELIZA CAMARGO CHACEL*AVANTE': 2244.4,\n",
" 'ANA ELIZABETH DE ANDRADE FARIAS SANTOS SALES*PRB': 124596.33,\n",
" 'ANA ELVIRA SANTOS SA*PHS': 2000.0,\n",
" 'ANA EMILIA IPANEMA BRASIL SOTERO*PRP': 120000.0,\n",
" 'ANA EVELINE MARQUES DE SANTANA*AVANTE': 3000.0,\n",
" 'ANA FABIA ALMEIDA PEREIRA DOS SANTOS DE TOLEDO ROCHA*PSD': 120878.98,\n",
" 'ANA FLAVIA BELEM DE BARROS*PSB': 202013.31,\n",
" 'ANA FLAVIA DE MATOS BEVILAQUA*REDE': 1100.0,\n",
" 'ANA FLAVIA DO NASCIMENTO*DEM': 82850.0,\n",
" 'ANA GLAUCIA ALMEIDA DE CASTRO MOURA*PRTB': 3338.2,\n",
" 'ANA ISLA ARRUDA FREITAS*PTB': 3700.0,\n",
" 'ANA JARLINE DOS SANTOS SILVA*PT': 19090.0,\n",
" 'ANA JULIA DE VASCONCELOS CAREPA*PC do B': 1237594.58,\n",
" 'ANA KARIN DIAS DE ALMEIDA ANDRADE*PRB': 353815.5,\n",
" 'ANA KARLA GUIMARAES LUCAS*PSC': 200000.0,\n",
" 'ANA KATIUCIA RUAS GONCALVES*PATRI': 6650.0,\n",
" 'ANA KELY PAULINO BARSCH*PMB': 4000.0,\n",
" 'ANA LEILA GALVAO MAIA MOREIRA*PT': 44000.0,\n",
" 'ANA LIDIA DE OLIVEIRA AGUIAR*PT': 12796.23,\n",
" 'ANA LUCIA BANHA PICANCO NUNES*PT': 5000.0,\n",
" 'ANA LUCIA BARRIGA BRITO*PR': 9000.0,\n",
" 'ANA LUCIA BATISTA PAVAO*PR': 399723.28,\n",
" 'ANA LUCIA BERNARDO CORDEIRO*PMB': 10000.0,\n",
" 'ANA LUCIA COUTO DE ALMEIDA*PV': 2528.57,\n",
" 'ANA LUCIA DE MELLO MACHADO*PRB': 9000.0,\n",
" 'ANA LUCIA DE MORAES YOSHIDA*REDE': 800.0,\n",
" 'ANA LUCIA DOMINGUES*PV': 5098.93,\n",
" 'ANA LUCIA DOS SANTOS ESTEVAO*DEM': 275500.0,\n",
" 'ANA LUCIA DOS SANTOS*REDE': 910.0,\n",
" 'ANA LUCIA FERNANDES DA MATA RESENDE*PODE': 21416.66,\n",
" 'ANA LUCIA FERREIRA DE MORAIS VEIGA*PPL': 479.37,\n",
" 'ANA LUCIA FONSECA NEGRAO*PV': 11410.0,\n",
" 'ANA LUCIA GUEDES NUNES*PRB': 6785.5,\n",
" 'ANA LUCIA LIPPAUS PERUGINI*PT': 1002796.23,\n",
" 'ANA LUCIA LOPES FARIA*MDB': 10000.0,\n",
" 'ANA LUCIA MARINHO LEITE*MDB': 9012.79,\n",
" 'ANA LUCIA MASCARENHAS DOS SANTOS*AVANTE': 13000.0,\n",
" 'ANA LUCIA NUNES SOARES*SOLIDARIEDADE': 200.0,\n",
" 'ANA LUCIA PANTALEAO JUSTINO*MDB': 20000.0,\n",
" 'ANA LUCIA RIBEIRO SERRA*PR': 10000.0,\n",
" 'ANA LUIZA CUNHA MARINHO*PHS': 2942.8599999999997,\n",
" 'ANA LUIZA DA SILVA*DC': 1000.0,\n",
" 'ANA LUIZA DE OLIVEIRA DIAS*PRB': 139444.72,\n",
" 'ANA LUIZA PRATA LIBORIO*REDE': 910.0,\n",
" 'ANA MARCIA BELEM MOURAO ARAUJO*PRP': 72.0,\n",
" 'ANA MARGARIDA MARQUES FASCIO*PHS': 80000.0,\n",
" 'ANA MARI SILVA DE OLIVEIRA*SOLIDARIEDADE': 200.0,\n",
" 'ANA MARIA AMORIM RIBEIRO*PRP': 2500.0,\n",
" 'ANA MARIA DA SILVA OLIVEIRA*PSOL': 190.0,\n",
" 'ANA MARIA DA SILVA*AVANTE': 2400.0,\n",
" 'ANA MARIA DA SILVA*PP': 6986.45,\n",
" 'ANA MARIA DA SILVA*PT': 5000.0,\n",
" 'ANA MARIA DE ALMEIDA RANGEL*SOLIDARIEDADE': 200.0,\n",
" 'ANA MARIA DE CARVALHO*PSOL': 1370.97,\n",
" 'ANA MARIA DE FARIAS*PATRI': 2000.0,\n",
" 'ANA MARIA DE OLIVEIRA LUIZ*MDB': 24012.79,\n",
" 'ANA MARIA DE SOUZA MOREIRA*MDB': 34519.0,\n",
" 'ANA MARIA DO CARMO ROSSETO*PT': 510796.23,\n",
" 'ANA MARIA DO NASCIMENTO ALVES*DEM': 240000.0,\n",
" 'ANA MARIA DO SOCORRO MAGNO CUNHA*PSDB': 589375.0,\n",
" 'ANA MARIA DOS SANTOS BRITO*MDB': 35663.5,\n",
" 'ANA MARIA FIGUEIREDO FORMIGA*PV': 24039.339999999997,\n",
" 'ANA MARIA FREIRE SILVA*AVANTE': 4069.43,\n",
" 'ANA MARIA GODOI*SOLIDARIEDADE': 32000.0,\n",
" 'ANA MARIA GRANATA AFONSO*PSL': 1237.5,\n",
" 'ANA MARIA MACHADO*PTB': 10000.0,\n",
" 'ANA MARIA MASCARENHAS DE SOUZA*AVANTE': 3500.0,\n",
" 'ANA MARIA MONTEIRO*PSDB': 7625.0,\n",
" 'ANA MARIA PRESTES RABELO*PC do B': 68760.0,\n",
" 'ANA MARIA RODRIGUES DA SILVA*PC do B': 5980.9800000000005,\n",
" 'ANA MARIA SOUZA E SILVA*PSOL': 1230.99,\n",
" 'ANA MARIA SOUZA RESINENTTI*REDE': 800.0,\n",
" 'ANA MARIA VAZ BEZERRA*PRP': 721.25,\n",
" 'ANA MARISA DO VALE*PROS': 10000.0,\n",
" 'ANA MICHELE DE FARIAS CABRAL*PT': 83590.0,\n",
" 'ANA MONTEIRO DA SILVA VIANA*PSOL': 400.0,\n",
" 'ANA NERI ALVES DE JESUS*PTC': 10133.32,\n",
" 'ANA PATRICIA ALVES*PCO': 600.0,\n",
" 'ANA PATRICIA CORDEIRO RAMOS*PP': 10000.0,\n",
" 'ANA PATRICIA DE SOUSA SANTIAGO*PC do B': 20352.0,\n",
" 'ANA PATRICIA ORSI*PDT': 30000.0,\n",
" 'ANA PAULA AGUIAR DE SOUSA*PRP': 5000.0,\n",
" 'ANA PAULA ALVES RIBEIRO*PHS': 5908.6900000000005,\n",
" 'ANA PAULA ALVES SALIBA*PCO': 2350.0,\n",
" 'ANA PAULA BENETE CROZUE*PSB': 73500.0,\n",
" 'ANA PAULA BORONI REIS*PRTB': 100.0,\n",
" 'ANA PAULA BRANDAO DA SILVA FARIAS*PATRI': 30000.0,\n",
" 'ANA PAULA CALVO FARIA*MDB': 170000.0,\n",
" 'ANA PAULA CARDOSO DE SOUZA*PT': 39250.0,\n",
" 'ANA PAULA CARDOSO MELQUIDE*MDB': 5000.0,\n",
" ...}"
]
},
"metadata": {
"tags": []
},
"execution_count": 24
}
]
},
{
"metadata": {
"id": "vnwQIAsUKjRo",
"colab_type": "text"
},
"cell_type": "markdown",
"source": [
"# Custo por **voto**"
]
},
{
"metadata": {
"id": "B5Ru1wDx0T5Z",
"colab_type": "code",
"outputId": "7a565ce6-d667-4c90-f876-fd11f0c1133e",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 198
}
},
"cell_type": "code",
"source": [
"df18pg[df18pg.NM_CANDIDATO == 'HELEN MACHADO ARAUJO']"
],
"execution_count": 25,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>DT_GERACAO</th>\n",
" <th>HH_GERACAO</th>\n",
" <th>ANO_ELEICAO</th>\n",
" <th>CD_TIPO_ELEICAO</th>\n",
" <th>NM_TIPO_ELEICAO</th>\n",
" <th>CD_ELEICAO</th>\n",
" <th>DS_ELEICAO</th>\n",
" <th>DT_ELEICAO</th>\n",
" <th>ST_TURNO</th>\n",
" <th>TP_PRESTACAO_CONTAS</th>\n",
" <th>DT_PRESTACAO_CONTAS</th>\n",
" <th>SQ_PRESTADOR_CONTAS</th>\n",
" <th>SG_UF</th>\n",
" <th>DS_TIPO_DOCUMENTO</th>\n",
" <th>NR_DOCUMENTO</th>\n",
" <th>CD_FONTE_DESPESA</th>\n",
" <th>DS_FONTE_DESPESA</th>\n",
" <th>CD_ORIGEM_DESPESA</th>\n",
" <th>DS_ORIGEM_DESPESA</th>\n",
" <th>CD_NATUREZA_DESPESA</th>\n",
" <th>DS_NATUREZA_DESPESA</th>\n",
" <th>CD_ESPECIE_RECURSO</th>\n",
" <th>DS_ESPECIE_RECURSO</th>\n",
" <th>SQ_DESPESA</th>\n",
" <th>SQ_PARCELAMENTO_DESPESA</th>\n",
" <th>DT_PAGTO_DESPESA</th>\n",
" <th>DS_DESPESA</th>\n",
" <th>VR_PAGTO_DESPESA</th>\n",
" <th>NM_CANDIDATO</th>\n",
" <th>NR_CPF_CANDIDATO</th>\n",
" <th>SG_PARTIDO</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>41781</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>09/11/2018</td>\n",
" <td>427248886</td>\n",
" <td>AP</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>850001</td>\n",
" <td>2</td>\n",
" <td>Fundo Especial de Financiamento de Campanha</td>\n",
" <td>20120000</td>\n",
" <td>Serviços prestados por terceiros</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>23610507</td>\n",
" <td>15756039</td>\n",
" <td>03/10/2018</td>\n",
" <td>Serviços prestados por terceiros</td>\n",
" <td>4950.00</td>\n",
" <td>HELEN MACHADO ARAUJO</td>\n",
" <td>826223290</td>\n",
" <td>PTC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41782</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>09/11/2018</td>\n",
" <td>427248886</td>\n",
" <td>AP</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>850004</td>\n",
" <td>2</td>\n",
" <td>Fundo Especial de Financiamento de Campanha</td>\n",
" <td>20140000</td>\n",
" <td>Publicidade por materiais impressos</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>23610508</td>\n",
" <td>15756038</td>\n",
" <td>04/10/2018</td>\n",
" <td>Publicidade por materiais impressos</td>\n",
" <td>14800.00</td>\n",
" <td>HELEN MACHADO ARAUJO</td>\n",
" <td>826223290</td>\n",
" <td>PTC</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" DT_GERACAO HH_GERACAO ANO_ELEICAO CD_TIPO_ELEICAO NM_TIPO_ELEICAO \\\n",
"41781 10/02/2019 03:28:27 2018 2 Ordinária \n",
"41782 10/02/2019 03:28:27 2018 2 Ordinária \n",
"\n",
" CD_ELEICAO DS_ELEICAO DT_ELEICAO ST_TURNO \\\n",
"41781 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"41782 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"\n",
" TP_PRESTACAO_CONTAS DT_PRESTACAO_CONTAS SQ_PRESTADOR_CONTAS SG_UF \\\n",
"41781 Final 09/11/2018 427248886 AP \n",
"41782 Final 09/11/2018 427248886 AP \n",
"\n",
" DS_TIPO_DOCUMENTO NR_DOCUMENTO CD_FONTE_DESPESA \\\n",
"41781 Nota Fiscal 850001 2 \n",
"41782 Nota Fiscal 850004 2 \n",
"\n",
" DS_FONTE_DESPESA CD_ORIGEM_DESPESA \\\n",
"41781 Fundo Especial de Financiamento de Campanha 20120000 \n",
"41782 Fundo Especial de Financiamento de Campanha 20140000 \n",
"\n",
" DS_ORIGEM_DESPESA CD_NATUREZA_DESPESA \\\n",
"41781 Serviços prestados por terceiros 1 \n",
"41782 Publicidade por materiais impressos 1 \n",
"\n",
" DS_NATUREZA_DESPESA CD_ESPECIE_RECURSO DS_ESPECIE_RECURSO SQ_DESPESA \\\n",
"41781 Financeiro 1 Financeiro 23610507 \n",
"41782 Financeiro 1 Financeiro 23610508 \n",
"\n",
" SQ_PARCELAMENTO_DESPESA DT_PAGTO_DESPESA \\\n",
"41781 15756039 03/10/2018 \n",
"41782 15756038 04/10/2018 \n",
"\n",
" DS_DESPESA VR_PAGTO_DESPESA \\\n",
"41781 Serviços prestados por terceiros 4950.00 \n",
"41782 Publicidade por materiais impressos 14800.00 \n",
"\n",
" NM_CANDIDATO NR_CPF_CANDIDATO SG_PARTIDO \n",
"41781 HELEN MACHADO ARAUJO 826223290 PTC \n",
"41782 HELEN MACHADO ARAUJO 826223290 PTC "
]
},
"metadata": {
"tags": []
},
"execution_count": 25
}
]
},
{
"metadata": {
"id": "Sb54cpI8xHgM",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"cand18 = drive.CreateFile({'id':'1rYRTSSzZggrr1UYtB0N5q8D5mQscuI03'})\n",
"cand18.GetContentFile('cand18')\n",
"cand18 = pd.read_csv('cand18', encoding = 'latin-1', error_bad_lines=False, delimiter = ';')\n",
"cand18['Nome do candidato'] = cand18['Nome do candidato'].str.normalize('NFKD').str.encode('ascii', errors='ignore').str.decode('utf-8')\n",
"cand18['nome_unico'] = cand18['Nome do candidato'] + '*' + cand18['Partido']"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "dTl96ddkx3XA",
"colab_type": "code",
"outputId": "ba753489-363f-449a-da33-6b6458cce0b3",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 148
}
},
"cell_type": "code",
"source": [
"cand18.head(1)"
],
"execution_count": 27,
"outputs": [
{
"output_type": "execute_result",
"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>UF</th>\n",
" <th>Partido</th>\n",
" <th>Número do candidato</th>\n",
" <th>Nome do candidato</th>\n",
" <th>Nome do candidato (urna)</th>\n",
" <th>Cargo</th>\n",
" <th>Situação da candidatura</th>\n",
" <th>Detalhe situação candidatura</th>\n",
" <th>Data eleição</th>\n",
" <th>Situação de totalização</th>\n",
" <th>Unnamed: 10</th>\n",
" <th>nome_unico</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>AC</td>\n",
" <td>PSL</td>\n",
" <td>17789</td>\n",
" <td>ABDIAS DAMASCENO DA SILVA</td>\n",
" <td>ABDIAS</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>Apto</td>\n",
" <td>Deferido</td>\n",
" <td>7.10.2018</td>\n",
" <td>Suplente</td>\n",
" <td>nan</td>\n",
" <td>ABDIAS DAMASCENO DA SILVA*PSL</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" UF Partido Número do candidato Nome do candidato \\\n",
"0 AC PSL 17789 ABDIAS DAMASCENO DA SILVA \n",
"\n",
" Nome do candidato (urna) Cargo Situação da candidatura \\\n",
"0 ABDIAS Deputado Estadual Apto \n",
"\n",
" Detalhe situação candidatura Data eleição Situação de totalização \\\n",
"0 Deferido 7.10.2018 Suplente \n",
"\n",
" Unnamed: 10 nome_unico \n",
"0 nan ABDIAS DAMASCENO DA SILVA*PSL "
]
},
"metadata": {
"tags": []
},
"execution_count": 27
}
]
},
{
"metadata": {
"id": "t5kKs2G_xUp-",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"deferidos = cand18[cand18['Detalhe situação candidatura'] == 'Deferido']['nome_unico'].tolist()"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "ycmByTyeZ522",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"mulheres = drive.CreateFile({'id':'1xp-Xz8KjrvNE50FcayZAlRfzibUtZZBZ'})\n",
"mulheres.GetContentFile('mulheres')\n",
"mulheres = pd.read_csv('mulheres', encoding = 'latin-1', error_bad_lines=False, delimiter = ';')\n",
"mulheres['Nome do candidato'] = mulheres['Nome do candidato'].str.normalize('NFKD').str.encode('ascii', errors='ignore').str.decode('utf-8')\n",
"mulheres_lista = mulheres['Nome do candidato'].tolist()"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "Ybu1fg5SxTo4",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"mulheres['Nome do candidato'] = mulheres['Nome do candidato'].str.normalize('NFKD').str.encode('ascii', errors='ignore').str.decode('utf-8')\n",
"mulheres_lista = mulheres['Nome do candidato'].tolist()"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "AuTSiEofHexL",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"votos = drive.CreateFile({'id':'1_TlcL5oKF38Sdhbf7goVDfZbImEMUM6c'}) \n",
"votos.GetContentFile('votos')\n",
"votos = pd.read_csv('votos', encoding = 'latin-1', error_bad_lines=False, delimiter = ';')\n",
"votos['Nome do candidato'] = votos['Nome do candidato'].str.normalize('NFKD').str.encode('ascii', errors='ignore').str.decode('utf-8')"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "zWtwDCetIvXp",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"votos['nome_unico'] = votos['Nome do candidato'] + '*' + votos['Partido']\n",
"votodic = votos.set_index('nome_unico')['Votos nominais do candidato'].to_dict()"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "Yrs-E2wc_201",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"cargodic = votos.set_index('nome_unico')['Cargo'].to_dict()\n",
"eleitodic = votos.set_index('nome_unico')['Situação de totalização'].to_dict()"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "j6SvWmMCI-zT",
"colab_type": "code",
"outputId": "c209cf71-6813-4a56-9689-57bcfe29e6d7",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 380
}
},
"cell_type": "code",
"source": [
"#Consertar na tabela final os nomes duplicados!\n",
"votos[votos.nome_unico.duplicated(keep=False)]"
],
"execution_count": 34,
"outputs": [
{
"output_type": "execute_result",
"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>UF</th>\n",
" <th>Cargo</th>\n",
" <th>Número do candidato</th>\n",
" <th>Nome do candidato</th>\n",
" <th>Nome do candidato (urna)</th>\n",
" <th>Partido</th>\n",
" <th>Coligação</th>\n",
" <th>Turno</th>\n",
" <th>Situação de totalização</th>\n",
" <th>Votos nominais do candidato</th>\n",
" <th>Voto em trânsito</th>\n",
" <th>Votos válidos por abrangência</th>\n",
" <th>% votos válidos</th>\n",
" <th>Data última totalização</th>\n",
" <th>nome_unico</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3581</th>\n",
" <td>CE</td>\n",
" <td>Deputado Federal</td>\n",
" <td>5112</td>\n",
" <td>MARIA DE FATIMA DA SILVA</td>\n",
" <td>FATIMA SILVA</td>\n",
" <td>PATRI</td>\n",
" <td>PPS / PRTB / PATRI</td>\n",
" <td>1</td>\n",
" <td>Suplente</td>\n",
" <td>816</td>\n",
" <td>0</td>\n",
" <td>4596080</td>\n",
" <td>,02</td>\n",
" <td>14/12/2018 09:45:55</td>\n",
" <td>MARIA DE FATIMA DA SILVA*PATRI</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9026</th>\n",
" <td>MG</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>31223</td>\n",
" <td>JOAO BATISTA DE OLIVEIRA</td>\n",
" <td>JOÃO VITA</td>\n",
" <td>PHS</td>\n",
" <td>PHS</td>\n",
" <td>1</td>\n",
" <td>Suplente</td>\n",
" <td>7614</td>\n",
" <td>0</td>\n",
" <td>10119302</td>\n",
" <td>,08</td>\n",
" <td>12/11/2018 16:43:41</td>\n",
" <td>JOAO BATISTA DE OLIVEIRA*PHS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9501</th>\n",
" <td>MG</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>31421</td>\n",
" <td>JOAO BATISTA DE OLIVEIRA</td>\n",
" <td>JOÃO DO FORRO</td>\n",
" <td>PHS</td>\n",
" <td>PHS</td>\n",
" <td>1</td>\n",
" <td>Suplente</td>\n",
" <td>577</td>\n",
" <td>0</td>\n",
" <td>10119302</td>\n",
" <td>,01</td>\n",
" <td>12/11/2018 16:43:41</td>\n",
" <td>JOAO BATISTA DE OLIVEIRA*PHS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21866</th>\n",
" <td>SC</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>51691</td>\n",
" <td>MARIA DE FATIMA DA SILVA</td>\n",
" <td>DODO VIGILANTE</td>\n",
" <td>PATRI</td>\n",
" <td>PMN / PATRI</td>\n",
" <td>1</td>\n",
" <td>Não eleito</td>\n",
" <td>409</td>\n",
" <td>0</td>\n",
" <td>3663271</td>\n",
" <td>,01</td>\n",
" <td>14/12/2018 13:45:40</td>\n",
" <td>MARIA DE FATIMA DA SILVA*PATRI</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" UF Cargo Número do candidato Nome do candidato \\\n",
"3581 CE Deputado Federal 5112 MARIA DE FATIMA DA SILVA \n",
"9026 MG Deputado Estadual 31223 JOAO BATISTA DE OLIVEIRA \n",
"9501 MG Deputado Estadual 31421 JOAO BATISTA DE OLIVEIRA \n",
"21866 SC Deputado Estadual 51691 MARIA DE FATIMA DA SILVA \n",
"\n",
" Nome do candidato (urna) Partido Coligação Turno \\\n",
"3581 FATIMA SILVA PATRI PPS / PRTB / PATRI 1 \n",
"9026 JOÃO VITA PHS PHS 1 \n",
"9501 JOÃO DO FORRO PHS PHS 1 \n",
"21866 DODO VIGILANTE PATRI PMN / PATRI 1 \n",
"\n",
" Situação de totalização Votos nominais do candidato Voto em trânsito \\\n",
"3581 Suplente 816 0 \n",
"9026 Suplente 7614 0 \n",
"9501 Suplente 577 0 \n",
"21866 Não eleito 409 0 \n",
"\n",
" Votos válidos por abrangência % votos válidos Data última totalização \\\n",
"3581 4596080 ,02 14/12/2018 09:45:55 \n",
"9026 10119302 ,08 12/11/2018 16:43:41 \n",
"9501 10119302 ,01 12/11/2018 16:43:41 \n",
"21866 3663271 ,01 14/12/2018 13:45:40 \n",
"\n",
" nome_unico \n",
"3581 MARIA DE FATIMA DA SILVA*PATRI \n",
"9026 JOAO BATISTA DE OLIVEIRA*PHS \n",
"9501 JOAO BATISTA DE OLIVEIRA*PHS \n",
"21866 MARIA DE FATIMA DA SILVA*PATRI "
]
},
"metadata": {
"tags": []
},
"execution_count": 34
}
]
},
{
"metadata": {
"id": "Avnldha9Rg99",
"colab_type": "code",
"outputId": "75fb79d2-8c74-4843-c06b-5cd20aa919da",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 219
}
},
"cell_type": "code",
"source": [
"votos[votos['Nome do candidato'] == 'GERALDO JOSE RODRIGUES ALCKMIN FILHO']"
],
"execution_count": 35,
"outputs": [
{
"output_type": "execute_result",
"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>UF</th>\n",
" <th>Cargo</th>\n",
" <th>Número do candidato</th>\n",
" <th>Nome do candidato</th>\n",
" <th>Nome do candidato (urna)</th>\n",
" <th>Partido</th>\n",
" <th>Coligação</th>\n",
" <th>Turno</th>\n",
" <th>Situação de totalização</th>\n",
" <th>Votos nominais do candidato</th>\n",
" <th>Voto em trânsito</th>\n",
" <th>Votos válidos por abrangência</th>\n",
" <th>% votos válidos</th>\n",
" <th>Data última totalização</th>\n",
" <th>nome_unico</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>BR</td>\n",
" <td>Presidente</td>\n",
" <td>45</td>\n",
" <td>GERALDO JOSE RODRIGUES ALCKMIN FILHO</td>\n",
" <td>GERALDO ALCKMIN</td>\n",
" <td>PSDB</td>\n",
" <td>PSDB / PTB / PP / PR / DEM / SOLIDARIEDADE / P...</td>\n",
" <td>1</td>\n",
" <td>Não eleito</td>\n",
" <td>5096350</td>\n",
" <td>0</td>\n",
" <td>107050749</td>\n",
" <td>4,76</td>\n",
" <td>22/01/2019 14:12:19</td>\n",
" <td>GERALDO JOSE RODRIGUES ALCKMIN FILHO*PSDB</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" UF Cargo Número do candidato Nome do candidato \\\n",
"3 BR Presidente 45 GERALDO JOSE RODRIGUES ALCKMIN FILHO \n",
"\n",
" Nome do candidato (urna) Partido \\\n",
"3 GERALDO ALCKMIN PSDB \n",
"\n",
" Coligação Turno \\\n",
"3 PSDB / PTB / PP / PR / DEM / SOLIDARIEDADE / P... 1 \n",
"\n",
" Situação de totalização Votos nominais do candidato Voto em trânsito \\\n",
"3 Não eleito 5096350 0 \n",
"\n",
" Votos válidos por abrangência % votos válidos Data última totalização \\\n",
"3 107050749 4,76 22/01/2019 14:12:19 \n",
"\n",
" nome_unico \n",
"3 GERALDO JOSE RODRIGUES ALCKMIN FILHO*PSDB "
]
},
"metadata": {
"tags": []
},
"execution_count": 35
}
]
},
{
"metadata": {
"id": "tOUW7UW5Noad",
"colab_type": "code",
"outputId": "8ef190e7-2806-4e06-89cd-155c38b14fbd",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 35
}
},
"cell_type": "code",
"source": [
"votos['Situação de totalização'].unique()"
],
"execution_count": 36,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"array(['2º turno', 'Não eleito', 'Eleito', 'Suplente'], dtype=object)"
]
},
"metadata": {
"tags": []
},
"execution_count": 36
}
]
},
{
"metadata": {
"id": "US2vGrgYKl1p",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"df18pg['nome_unico'] = df18pg['NM_CANDIDATO'] + '*' + df18pg['SG_PARTIDO']"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "mtsvkhuvNd-p",
"colab_type": "code",
"outputId": "55c3088e-64e7-45be-d7a8-925c838118dc",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 35
}
},
"cell_type": "code",
"source": [
"df18pg['NR_CPF_CANDIDATO'] = df18pg['NR_CPF_CANDIDATO'].astype(str)\n",
"df18_despesa = df18pg.groupby(['nome_unico','NR_CPF_CANDIDATO','SG_UF']).sum().reset_index()\n",
"df18_despesa.nome_unico.nunique()"
],
"execution_count": 38,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"18054"
]
},
"metadata": {
"tags": []
},
"execution_count": 38
}
]
},
{
"metadata": {
"id": "_D3iD3_8Pwt_",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"df18_despesa['votos_nominais'] = df18_despesa['nome_unico'].map(votodic)\n",
"df18_despesa['NM_CANDIDATO'], df18_despesa['SG_PARTIDO'] = df18_despesa['nome_unico'].str.split('*', 1).str"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "CU1U90Y9ao0-",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"def mulher(linha):\n",
" nome = linha['NM_CANDIDATO']\n",
" if nome in mulheres_lista:\n",
" return 'Mulher'\n",
" else:\n",
" return 'Homem'\n",
" \n",
"df18_despesa['Genero'] = df18_despesa.apply(mulher, axis = 1)"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "uaKzNj_7ytOq",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"def defer(linha):\n",
" nome = linha['nome_unico']\n",
" if nome in deferidos:\n",
" return 'Sim'\n",
" else:\n",
" return 'Nao'\n",
" \n",
"df18_despesa['Deferido'] = df18_despesa.apply(defer, axis = 1)"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "_A8bwqHwP4Ka",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"df18_despesa['custo_voto'] = df18_despesa['VR_PAGTO_DESPESA'] / df18_despesa['votos_nominais']"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "qJU10dCisKUp",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"df18_despesa['verba_publica'] = df18_despesa['nome_unico'].map(verba_publica)\n",
"df18_despesa['cargo'] = df18_despesa['nome_unico'].map(cargodic)\n",
"df18_despesa['eleito'] = df18_despesa['nome_unico'].map(eleitodic)"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "zPfar75KW5aE",
"colab_type": "code",
"outputId": "f35f1cff-7427-4eb6-ae2e-6f9739b4ece7",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 35
}
},
"cell_type": "code",
"source": [
"#gráfica no Macapá, capital do Amapá recebeu do PTC...\n",
"df18cont[df18cont.NM_FORNECEDOR == 'M. R. COM. E SERVIÇOS LTDA ME']['VR_DESPESA_CONTRATADA'].sum()"
],
"execution_count": 44,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"58950.0"
]
},
"metadata": {
"tags": []
},
"execution_count": 44
}
]
},
{
"metadata": {
"id": "iaGp-yWMCtEn",
"colab_type": "code",
"outputId": "8a5cd2f3-ed6c-433f-945f-5009f700c192",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 35
}
},
"cell_type": "code",
"source": [
"df18cont[df18cont.NM_FORNECEDOR == 'T. M. N. CONSTRUÇÕES E SERVIÇOS LTDA']['VR_DESPESA_CONTRATADA'].sum()"
],
"execution_count": 45,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"4000.0"
]
},
"metadata": {
"tags": []
},
"execution_count": 45
}
]
},
{
"metadata": {
"id": "JgPGMvHEC9SP",
"colab_type": "code",
"outputId": "39787ee6-5e91-42ae-fe0b-16b0c9ac24fd",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 410
}
},
"cell_type": "code",
"source": [
"df18cont[df18cont.NM_FORNECEDOR == 'GUSTAVO COSTA SILVEIRA ALVES'].head(5)"
],
"execution_count": 57,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>DT_GERACAO</th>\n",
" <th>HH_GERACAO</th>\n",
" <th>ANO_ELEICAO</th>\n",
" <th>CD_TIPO_ELEICAO</th>\n",
" <th>NM_TIPO_ELEICAO</th>\n",
" <th>CD_ELEICAO</th>\n",
" <th>DS_ELEICAO</th>\n",
" <th>DT_ELEICAO</th>\n",
" <th>ST_TURNO</th>\n",
" <th>TP_PRESTACAO_CONTAS</th>\n",
" <th>DT_PRESTACAO_CONTAS</th>\n",
" <th>SQ_PRESTADOR_CONTAS</th>\n",
" <th>SG_UF</th>\n",
" <th>SG_UE</th>\n",
" <th>NM_UE</th>\n",
" <th>NR_CNPJ_PRESTADOR_CONTA</th>\n",
" <th>CD_CARGO</th>\n",
" <th>DS_CARGO</th>\n",
" <th>SQ_CANDIDATO</th>\n",
" <th>NR_CANDIDATO</th>\n",
" <th>NM_CANDIDATO</th>\n",
" <th>NR_CPF_CANDIDATO</th>\n",
" <th>NR_CPF_VICE_CANDIDATO</th>\n",
" <th>NR_PARTIDO</th>\n",
" <th>SG_PARTIDO</th>\n",
" <th>NM_PARTIDO</th>\n",
" <th>CD_TIPO_FORNECEDOR</th>\n",
" <th>DS_TIPO_FORNECEDOR</th>\n",
" <th>CD_CNAE_FORNECEDOR</th>\n",
" <th>DS_CNAE_FORNECEDOR</th>\n",
" <th>NR_CPF_CNPJ_FORNECEDOR</th>\n",
" <th>NM_FORNECEDOR</th>\n",
" <th>NM_FORNECEDOR_RFB</th>\n",
" <th>CD_ESFERA_PART_FORNECEDOR</th>\n",
" <th>DS_ESFERA_PART_FORNECEDOR</th>\n",
" <th>SG_UF_FORNECEDOR</th>\n",
" <th>CD_MUNICIPIO_FORNECEDOR</th>\n",
" <th>NM_MUNICIPIO_FORNECEDOR</th>\n",
" <th>SQ_CANDIDATO_FORNECEDOR</th>\n",
" <th>NR_CANDIDATO_FORNECEDOR</th>\n",
" <th>CD_CARGO_FORNECEDOR</th>\n",
" <th>DS_CARGO_FORNECEDOR</th>\n",
" <th>NR_PARTIDO_FORNECEDOR</th>\n",
" <th>SG_PARTIDO_FORNECEDOR</th>\n",
" <th>NM_PARTIDO_FORNECEDOR</th>\n",
" <th>DS_TIPO_DOCUMENTO</th>\n",
" <th>NR_DOCUMENTO</th>\n",
" <th>CD_ORIGEM_DESPESA</th>\n",
" <th>DS_ORIGEM_DESPESA</th>\n",
" <th>SQ_DESPESA</th>\n",
" <th>DT_DESPESA</th>\n",
" <th>DS_DESPESA</th>\n",
" <th>VR_DESPESA_CONTRATADA</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>420362</th>\n",
" <td>09/02/2019</td>\n",
" <td>10:15:43</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>422494864</td>\n",
" <td>CE</td>\n",
" <td>CE</td>\n",
" <td>CEARÁ</td>\n",
" <td>31209352000185</td>\n",
" <td>7</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>60000611817</td>\n",
" <td>27590</td>\n",
" <td>TERESA CRISTINA CAVALCANTE QUEIROZ</td>\n",
" <td>38518465320</td>\n",
" <td>-1</td>\n",
" <td>27</td>\n",
" <td>DC</td>\n",
" <td>Democracia Cristã</td>\n",
" <td>1</td>\n",
" <td>Pessoa Jurídica</td>\n",
" <td>18121</td>\n",
" <td>Impressão de material de segurança</td>\n",
" <td>18001837000110</td>\n",
" <td>GUSTAVO COSTA SILVEIRA ALVES</td>\n",
" <td>GUSTAVO COSTA SILVEIRA ALVES</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>108 - NFSE</td>\n",
" <td>20140000</td>\n",
" <td>Publicidade por materiais impressos</td>\n",
" <td>23326403</td>\n",
" <td>28/09/2018</td>\n",
" <td>IMPRESSAO MATERIAL</td>\n",
" <td>3000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>451697</th>\n",
" <td>09/02/2019</td>\n",
" <td>10:15:43</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>05/12/2018</td>\n",
" <td>419416561</td>\n",
" <td>CE</td>\n",
" <td>CE</td>\n",
" <td>CEARÁ</td>\n",
" <td>31176866000181</td>\n",
" <td>7</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>60000605034</td>\n",
" <td>77000</td>\n",
" <td>HEITOR CORREIA FERRER</td>\n",
" <td>9338233391</td>\n",
" <td>-1</td>\n",
" <td>77</td>\n",
" <td>SOLIDARIEDADE</td>\n",
" <td>Solidariedade</td>\n",
" <td>1</td>\n",
" <td>Pessoa Jurídica</td>\n",
" <td>18121</td>\n",
" <td>Impressão de material de segurança</td>\n",
" <td>18001837000110</td>\n",
" <td>GUSTAVO COSTA SILVEIRA ALVES</td>\n",
" <td>GUSTAVO COSTA SILVEIRA ALVES</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>111 - 1</td>\n",
" <td>20140000</td>\n",
" <td>Publicidade por materiais impressos</td>\n",
" <td>24575513</td>\n",
" <td>08/10/2018</td>\n",
" <td>REF PGTO CARTAS</td>\n",
" <td>900.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>451698</th>\n",
" <td>09/02/2019</td>\n",
" <td>10:15:43</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>05/12/2018</td>\n",
" <td>419416561</td>\n",
" <td>CE</td>\n",
" <td>CE</td>\n",
" <td>CEARÁ</td>\n",
" <td>31176866000181</td>\n",
" <td>7</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>60000605034</td>\n",
" <td>77000</td>\n",
" <td>HEITOR CORREIA FERRER</td>\n",
" <td>9338233391</td>\n",
" <td>-1</td>\n",
" <td>77</td>\n",
" <td>SOLIDARIEDADE</td>\n",
" <td>Solidariedade</td>\n",
" <td>1</td>\n",
" <td>Pessoa Jurídica</td>\n",
" <td>18121</td>\n",
" <td>Impressão de material de segurança</td>\n",
" <td>18001837000110</td>\n",
" <td>GUSTAVO COSTA SILVEIRA ALVES</td>\n",
" <td>GUSTAVO COSTA SILVEIRA ALVES</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>111 - 1</td>\n",
" <td>20140000</td>\n",
" <td>Publicidade por materiais impressos</td>\n",
" <td>24575513</td>\n",
" <td>08/10/2018</td>\n",
" <td>REF PGTO BOTONS</td>\n",
" <td>1000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>451699</th>\n",
" <td>09/02/2019</td>\n",
" <td>10:15:43</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>05/12/2018</td>\n",
" <td>419416561</td>\n",
" <td>CE</td>\n",
" <td>CE</td>\n",
" <td>CEARÁ</td>\n",
" <td>31176866000181</td>\n",
" <td>7</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>60000605034</td>\n",
" <td>77000</td>\n",
" <td>HEITOR CORREIA FERRER</td>\n",
" <td>9338233391</td>\n",
" <td>-1</td>\n",
" <td>77</td>\n",
" <td>SOLIDARIEDADE</td>\n",
" <td>Solidariedade</td>\n",
" <td>1</td>\n",
" <td>Pessoa Jurídica</td>\n",
" <td>18121</td>\n",
" <td>Impressão de material de segurança</td>\n",
" <td>18001837000110</td>\n",
" <td>GUSTAVO COSTA SILVEIRA ALVES</td>\n",
" <td>GUSTAVO COSTA SILVEIRA ALVES</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>111 - 1</td>\n",
" <td>20140000</td>\n",
" <td>Publicidade por materiais impressos</td>\n",
" <td>24575513</td>\n",
" <td>08/10/2018</td>\n",
" <td>REF PGTO SANTINHOS</td>\n",
" <td>5800.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>451700</th>\n",
" <td>09/02/2019</td>\n",
" <td>10:15:43</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>05/12/2018</td>\n",
" <td>419416561</td>\n",
" <td>CE</td>\n",
" <td>CE</td>\n",
" <td>CEARÁ</td>\n",
" <td>31176866000181</td>\n",
" <td>7</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>60000605034</td>\n",
" <td>77000</td>\n",
" <td>HEITOR CORREIA FERRER</td>\n",
" <td>9338233391</td>\n",
" <td>-1</td>\n",
" <td>77</td>\n",
" <td>SOLIDARIEDADE</td>\n",
" <td>Solidariedade</td>\n",
" <td>1</td>\n",
" <td>Pessoa Jurídica</td>\n",
" <td>18121</td>\n",
" <td>Impressão de material de segurança</td>\n",
" <td>18001837000110</td>\n",
" <td>GUSTAVO COSTA SILVEIRA ALVES</td>\n",
" <td>GUSTAVO COSTA SILVEIRA ALVES</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>111 - 1</td>\n",
" <td>20140000</td>\n",
" <td>Publicidade por materiais impressos</td>\n",
" <td>24575513</td>\n",
" <td>08/10/2018</td>\n",
" <td>REF PGTO FOLDERES'</td>\n",
" <td>12600.00</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" DT_GERACAO HH_GERACAO ANO_ELEICAO CD_TIPO_ELEICAO NM_TIPO_ELEICAO \\\n",
"420362 09/02/2019 10:15:43 2018 2 Ordinária \n",
"451697 09/02/2019 10:15:43 2018 2 Ordinária \n",
"451698 09/02/2019 10:15:43 2018 2 Ordinária \n",
"451699 09/02/2019 10:15:43 2018 2 Ordinária \n",
"451700 09/02/2019 10:15:43 2018 2 Ordinária \n",
"\n",
" CD_ELEICAO DS_ELEICAO DT_ELEICAO ST_TURNO \\\n",
"420362 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"451697 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"451698 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"451699 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"451700 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"\n",
" TP_PRESTACAO_CONTAS DT_PRESTACAO_CONTAS SQ_PRESTADOR_CONTAS SG_UF \\\n",
"420362 Final 06/11/2018 422494864 CE \n",
"451697 Final 05/12/2018 419416561 CE \n",
"451698 Final 05/12/2018 419416561 CE \n",
"451699 Final 05/12/2018 419416561 CE \n",
"451700 Final 05/12/2018 419416561 CE \n",
"\n",
" SG_UE NM_UE NR_CNPJ_PRESTADOR_CONTA CD_CARGO DS_CARGO \\\n",
"420362 CE CEARÁ 31209352000185 7 Deputado Estadual \n",
"451697 CE CEARÁ 31176866000181 7 Deputado Estadual \n",
"451698 CE CEARÁ 31176866000181 7 Deputado Estadual \n",
"451699 CE CEARÁ 31176866000181 7 Deputado Estadual \n",
"451700 CE CEARÁ 31176866000181 7 Deputado Estadual \n",
"\n",
" SQ_CANDIDATO NR_CANDIDATO NM_CANDIDATO \\\n",
"420362 60000611817 27590 TERESA CRISTINA CAVALCANTE QUEIROZ \n",
"451697 60000605034 77000 HEITOR CORREIA FERRER \n",
"451698 60000605034 77000 HEITOR CORREIA FERRER \n",
"451699 60000605034 77000 HEITOR CORREIA FERRER \n",
"451700 60000605034 77000 HEITOR CORREIA FERRER \n",
"\n",
" NR_CPF_CANDIDATO NR_CPF_VICE_CANDIDATO NR_PARTIDO SG_PARTIDO \\\n",
"420362 38518465320 -1 27 DC \n",
"451697 9338233391 -1 77 SOLIDARIEDADE \n",
"451698 9338233391 -1 77 SOLIDARIEDADE \n",
"451699 9338233391 -1 77 SOLIDARIEDADE \n",
"451700 9338233391 -1 77 SOLIDARIEDADE \n",
"\n",
" NM_PARTIDO CD_TIPO_FORNECEDOR DS_TIPO_FORNECEDOR \\\n",
"420362 Democracia Cristã 1 Pessoa Jurídica \n",
"451697 Solidariedade 1 Pessoa Jurídica \n",
"451698 Solidariedade 1 Pessoa Jurídica \n",
"451699 Solidariedade 1 Pessoa Jurídica \n",
"451700 Solidariedade 1 Pessoa Jurídica \n",
"\n",
" CD_CNAE_FORNECEDOR DS_CNAE_FORNECEDOR \\\n",
"420362 18121 Impressão de material de segurança \n",
"451697 18121 Impressão de material de segurança \n",
"451698 18121 Impressão de material de segurança \n",
"451699 18121 Impressão de material de segurança \n",
"451700 18121 Impressão de material de segurança \n",
"\n",
" NR_CPF_CNPJ_FORNECEDOR NM_FORNECEDOR \\\n",
"420362 18001837000110 GUSTAVO COSTA SILVEIRA ALVES \n",
"451697 18001837000110 GUSTAVO COSTA SILVEIRA ALVES \n",
"451698 18001837000110 GUSTAVO COSTA SILVEIRA ALVES \n",
"451699 18001837000110 GUSTAVO COSTA SILVEIRA ALVES \n",
"451700 18001837000110 GUSTAVO COSTA SILVEIRA ALVES \n",
"\n",
" NM_FORNECEDOR_RFB CD_ESFERA_PART_FORNECEDOR \\\n",
"420362 GUSTAVO COSTA SILVEIRA ALVES -1 \n",
"451697 GUSTAVO COSTA SILVEIRA ALVES -1 \n",
"451698 GUSTAVO COSTA SILVEIRA ALVES -1 \n",
"451699 GUSTAVO COSTA SILVEIRA ALVES -1 \n",
"451700 GUSTAVO COSTA SILVEIRA ALVES -1 \n",
"\n",
" DS_ESFERA_PART_FORNECEDOR SG_UF_FORNECEDOR CD_MUNICIPIO_FORNECEDOR \\\n",
"420362 #NULO# #NULO# -1 \n",
"451697 #NULO# #NULO# -1 \n",
"451698 #NULO# #NULO# -1 \n",
"451699 #NULO# #NULO# -1 \n",
"451700 #NULO# #NULO# -1 \n",
"\n",
" NM_MUNICIPIO_FORNECEDOR SQ_CANDIDATO_FORNECEDOR \\\n",
"420362 #NULO# -1 \n",
"451697 #NULO# -1 \n",
"451698 #NULO# -1 \n",
"451699 #NULO# -1 \n",
"451700 #NULO# -1 \n",
"\n",
" NR_CANDIDATO_FORNECEDOR CD_CARGO_FORNECEDOR DS_CARGO_FORNECEDOR \\\n",
"420362 -1 -1 #NULO# \n",
"451697 -1 -1 #NULO# \n",
"451698 -1 -1 #NULO# \n",
"451699 -1 -1 #NULO# \n",
"451700 -1 -1 #NULO# \n",
"\n",
" NR_PARTIDO_FORNECEDOR SG_PARTIDO_FORNECEDOR NM_PARTIDO_FORNECEDOR \\\n",
"420362 -1 #NULO# #NULO# \n",
"451697 -1 #NULO# #NULO# \n",
"451698 -1 #NULO# #NULO# \n",
"451699 -1 #NULO# #NULO# \n",
"451700 -1 #NULO# #NULO# \n",
"\n",
" DS_TIPO_DOCUMENTO NR_DOCUMENTO CD_ORIGEM_DESPESA \\\n",
"420362 Nota Fiscal 108 - NFSE 20140000 \n",
"451697 Nota Fiscal 111 - 1 20140000 \n",
"451698 Nota Fiscal 111 - 1 20140000 \n",
"451699 Nota Fiscal 111 - 1 20140000 \n",
"451700 Nota Fiscal 111 - 1 20140000 \n",
"\n",
" DS_ORIGEM_DESPESA SQ_DESPESA DT_DESPESA \\\n",
"420362 Publicidade por materiais impressos 23326403 28/09/2018 \n",
"451697 Publicidade por materiais impressos 24575513 08/10/2018 \n",
"451698 Publicidade por materiais impressos 24575513 08/10/2018 \n",
"451699 Publicidade por materiais impressos 24575513 08/10/2018 \n",
"451700 Publicidade por materiais impressos 24575513 08/10/2018 \n",
"\n",
" DS_DESPESA VR_DESPESA_CONTRATADA \n",
"420362 IMPRESSAO MATERIAL 3000.00 \n",
"451697 REF PGTO CARTAS 900.00 \n",
"451698 REF PGTO BOTONS 1000.00 \n",
"451699 REF PGTO SANTINHOS 5800.00 \n",
"451700 REF PGTO FOLDERES' 12600.00 "
]
},
"metadata": {
"tags": []
},
"execution_count": 57
}
]
},
{
"metadata": {
"id": "tBqF7ewEwanh",
"colab_type": "code",
"outputId": "7960790d-934a-46cc-8e9b-70518288a787",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 35
}
},
"cell_type": "code",
"source": [
"len(df18cont[df18cont.NM_CANDIDATO == 'LUMA ALVES GOUVEIA'])"
],
"execution_count": 47,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"36"
]
},
"metadata": {
"tags": []
},
"execution_count": 47
}
]
},
{
"metadata": {
"id": "wQEZn_w2w4pm",
"colab_type": "code",
"outputId": "425c1ad4-b581-40e5-fa82-5a6d82845d74",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 35
}
},
"cell_type": "code",
"source": [
"df18cont[(df18cont.NM_CANDIDATO == 'LUMA ALVES GOUVEIA')&(df18cont.NM_FORNECEDOR == 'JANAINA BATISTA SALES 01174162406')]['VR_DESPESA_CONTRATADA'].sum()"
],
"execution_count": 48,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"45000.0"
]
},
"metadata": {
"tags": []
},
"execution_count": 48
}
]
},
{
"metadata": {
"id": "yn2gnydFv66F",
"colab_type": "code",
"outputId": "8b9eb857-646e-4610-fddb-6aa7a7294776",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 479
}
},
"cell_type": "code",
"source": [
"df18cont[df18cont.NM_CANDIDATO == 'LUCENIR VASCONCELOS DE OLIVEIRA LICATA'].sort_values(by=['VR_DESPESA_CONTRATADA'],ascending=False).head(5)"
],
"execution_count": 61,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>DT_GERACAO</th>\n",
" <th>HH_GERACAO</th>\n",
" <th>ANO_ELEICAO</th>\n",
" <th>CD_TIPO_ELEICAO</th>\n",
" <th>NM_TIPO_ELEICAO</th>\n",
" <th>CD_ELEICAO</th>\n",
" <th>DS_ELEICAO</th>\n",
" <th>DT_ELEICAO</th>\n",
" <th>ST_TURNO</th>\n",
" <th>TP_PRESTACAO_CONTAS</th>\n",
" <th>DT_PRESTACAO_CONTAS</th>\n",
" <th>SQ_PRESTADOR_CONTAS</th>\n",
" <th>SG_UF</th>\n",
" <th>SG_UE</th>\n",
" <th>NM_UE</th>\n",
" <th>NR_CNPJ_PRESTADOR_CONTA</th>\n",
" <th>CD_CARGO</th>\n",
" <th>DS_CARGO</th>\n",
" <th>SQ_CANDIDATO</th>\n",
" <th>NR_CANDIDATO</th>\n",
" <th>NM_CANDIDATO</th>\n",
" <th>NR_CPF_CANDIDATO</th>\n",
" <th>NR_CPF_VICE_CANDIDATO</th>\n",
" <th>NR_PARTIDO</th>\n",
" <th>SG_PARTIDO</th>\n",
" <th>NM_PARTIDO</th>\n",
" <th>CD_TIPO_FORNECEDOR</th>\n",
" <th>DS_TIPO_FORNECEDOR</th>\n",
" <th>CD_CNAE_FORNECEDOR</th>\n",
" <th>DS_CNAE_FORNECEDOR</th>\n",
" <th>NR_CPF_CNPJ_FORNECEDOR</th>\n",
" <th>NM_FORNECEDOR</th>\n",
" <th>NM_FORNECEDOR_RFB</th>\n",
" <th>CD_ESFERA_PART_FORNECEDOR</th>\n",
" <th>DS_ESFERA_PART_FORNECEDOR</th>\n",
" <th>SG_UF_FORNECEDOR</th>\n",
" <th>CD_MUNICIPIO_FORNECEDOR</th>\n",
" <th>NM_MUNICIPIO_FORNECEDOR</th>\n",
" <th>SQ_CANDIDATO_FORNECEDOR</th>\n",
" <th>NR_CANDIDATO_FORNECEDOR</th>\n",
" <th>CD_CARGO_FORNECEDOR</th>\n",
" <th>DS_CARGO_FORNECEDOR</th>\n",
" <th>NR_PARTIDO_FORNECEDOR</th>\n",
" <th>SG_PARTIDO_FORNECEDOR</th>\n",
" <th>NM_PARTIDO_FORNECEDOR</th>\n",
" <th>DS_TIPO_DOCUMENTO</th>\n",
" <th>NR_DOCUMENTO</th>\n",
" <th>CD_ORIGEM_DESPESA</th>\n",
" <th>DS_ORIGEM_DESPESA</th>\n",
" <th>SQ_DESPESA</th>\n",
" <th>DT_DESPESA</th>\n",
" <th>DS_DESPESA</th>\n",
" <th>VR_DESPESA_CONTRATADA</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1492795</th>\n",
" <td>09/02/2019</td>\n",
" <td>10:15:43</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>30/11/2018</td>\n",
" <td>416623533</td>\n",
" <td>RR</td>\n",
" <td>RR</td>\n",
" <td>RORAIMA</td>\n",
" <td>31135397000152</td>\n",
" <td>7</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>230000601213</td>\n",
" <td>55550</td>\n",
" <td>LUCENIR VASCONCELOS DE OLIVEIRA LICATA</td>\n",
" <td>67533981200</td>\n",
" <td>-1</td>\n",
" <td>55</td>\n",
" <td>PSD</td>\n",
" <td>Partido Social Democrático</td>\n",
" <td>0</td>\n",
" <td>Pessoa Física</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>1924246295</td>\n",
" <td>JOANDERSON SOARES DOS SANTOS</td>\n",
" <td>JOANDERSON SOARES DOS SANTOS</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>Outro</td>\n",
" <td>CONTRATO</td>\n",
" <td>20010000</td>\n",
" <td>Despesas com pessoal</td>\n",
" <td>24472382</td>\n",
" <td>14/09/2018</td>\n",
" <td>SERVIÇO DE SUPERVISOR GERAL DE CAMPANHA</td>\n",
" <td>10000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1492796</th>\n",
" <td>09/02/2019</td>\n",
" <td>10:15:43</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>30/11/2018</td>\n",
" <td>416623533</td>\n",
" <td>RR</td>\n",
" <td>RR</td>\n",
" <td>RORAIMA</td>\n",
" <td>31135397000152</td>\n",
" <td>7</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>230000601213</td>\n",
" <td>55550</td>\n",
" <td>LUCENIR VASCONCELOS DE OLIVEIRA LICATA</td>\n",
" <td>67533981200</td>\n",
" <td>-1</td>\n",
" <td>55</td>\n",
" <td>PSD</td>\n",
" <td>Partido Social Democrático</td>\n",
" <td>0</td>\n",
" <td>Pessoa Física</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>2129705260</td>\n",
" <td>WENDER RODRIGUES DA SILVA OLIVEIRA</td>\n",
" <td>WENDER RODRIGUES DA SILVA</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>Outro</td>\n",
" <td>CONTRATO</td>\n",
" <td>20010000</td>\n",
" <td>Despesas com pessoal</td>\n",
" <td>24472385</td>\n",
" <td>17/09/2018</td>\n",
" <td>SERVIÇO DE SUPERVISOR DE CAMPANHA</td>\n",
" <td>10000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1492798</th>\n",
" <td>09/02/2019</td>\n",
" <td>10:15:43</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>30/11/2018</td>\n",
" <td>416623533</td>\n",
" <td>RR</td>\n",
" <td>RR</td>\n",
" <td>RORAIMA</td>\n",
" <td>31135397000152</td>\n",
" <td>7</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>230000601213</td>\n",
" <td>55550</td>\n",
" <td>LUCENIR VASCONCELOS DE OLIVEIRA LICATA</td>\n",
" <td>67533981200</td>\n",
" <td>-1</td>\n",
" <td>55</td>\n",
" <td>PSD</td>\n",
" <td>Partido Social Democrático</td>\n",
" <td>0</td>\n",
" <td>Pessoa Física</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>9553576249</td>\n",
" <td>EUFLAVIO DIONIZIO LIMA</td>\n",
" <td>EUFLAVIO DIONIZIO LIMA</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>Outro</td>\n",
" <td>CONTRATO</td>\n",
" <td>20120000</td>\n",
" <td>Serviços prestados por terceiros</td>\n",
" <td>24472381</td>\n",
" <td>24/09/2018</td>\n",
" <td>SERVIÇO PROFISSIONAL DE ADVOCACIA</td>\n",
" <td>10000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1492802</th>\n",
" <td>09/02/2019</td>\n",
" <td>10:15:43</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>30/11/2018</td>\n",
" <td>416623533</td>\n",
" <td>RR</td>\n",
" <td>RR</td>\n",
" <td>RORAIMA</td>\n",
" <td>31135397000152</td>\n",
" <td>7</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>230000601213</td>\n",
" <td>55550</td>\n",
" <td>LUCENIR VASCONCELOS DE OLIVEIRA LICATA</td>\n",
" <td>67533981200</td>\n",
" <td>-1</td>\n",
" <td>55</td>\n",
" <td>PSD</td>\n",
" <td>Partido Social Democrático</td>\n",
" <td>0</td>\n",
" <td>Pessoa Física</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>4804416269</td>\n",
" <td>LIANDRA DE CASSIA RIBEIRO MARQUES</td>\n",
" <td>LIANDRA DE CASSIA RIBEIRO MARQUES</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>Outro</td>\n",
" <td>CONTRATO</td>\n",
" <td>20010000</td>\n",
" <td>Despesas com pessoal</td>\n",
" <td>24472383</td>\n",
" <td>14/09/2018</td>\n",
" <td>SERVIÇO DE COORDENADOR GERAL DE CAMPANHA</td>\n",
" <td>7940.40</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1492794</th>\n",
" <td>09/02/2019</td>\n",
" <td>10:15:43</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>30/11/2018</td>\n",
" <td>416623533</td>\n",
" <td>RR</td>\n",
" <td>RR</td>\n",
" <td>RORAIMA</td>\n",
" <td>31135397000152</td>\n",
" <td>7</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>230000601213</td>\n",
" <td>55550</td>\n",
" <td>LUCENIR VASCONCELOS DE OLIVEIRA LICATA</td>\n",
" <td>67533981200</td>\n",
" <td>-1</td>\n",
" <td>55</td>\n",
" <td>PSD</td>\n",
" <td>Partido Social Democrático</td>\n",
" <td>0</td>\n",
" <td>Pessoa Física</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>4229916272</td>\n",
" <td>FRANCISCO FERNANDES DE OLIVEIRA</td>\n",
" <td>FRANCISCO FERNANDES DE OLIVEIRA</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>Outro</td>\n",
" <td>CONTRATO</td>\n",
" <td>20120000</td>\n",
" <td>Serviços prestados por terceiros</td>\n",
" <td>24472378</td>\n",
" <td>24/09/2018</td>\n",
" <td>SERVIÇO PROFISSIONAL DE CONTABILIDADE</td>\n",
" <td>5000.00</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" DT_GERACAO HH_GERACAO ANO_ELEICAO CD_TIPO_ELEICAO NM_TIPO_ELEICAO \\\n",
"1492795 09/02/2019 10:15:43 2018 2 Ordinária \n",
"1492796 09/02/2019 10:15:43 2018 2 Ordinária \n",
"1492798 09/02/2019 10:15:43 2018 2 Ordinária \n",
"1492802 09/02/2019 10:15:43 2018 2 Ordinária \n",
"1492794 09/02/2019 10:15:43 2018 2 Ordinária \n",
"\n",
" CD_ELEICAO DS_ELEICAO DT_ELEICAO ST_TURNO \\\n",
"1492795 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"1492796 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"1492798 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"1492802 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"1492794 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"\n",
" TP_PRESTACAO_CONTAS DT_PRESTACAO_CONTAS SQ_PRESTADOR_CONTAS SG_UF \\\n",
"1492795 Final 30/11/2018 416623533 RR \n",
"1492796 Final 30/11/2018 416623533 RR \n",
"1492798 Final 30/11/2018 416623533 RR \n",
"1492802 Final 30/11/2018 416623533 RR \n",
"1492794 Final 30/11/2018 416623533 RR \n",
"\n",
" SG_UE NM_UE NR_CNPJ_PRESTADOR_CONTA CD_CARGO DS_CARGO \\\n",
"1492795 RR RORAIMA 31135397000152 7 Deputado Estadual \n",
"1492796 RR RORAIMA 31135397000152 7 Deputado Estadual \n",
"1492798 RR RORAIMA 31135397000152 7 Deputado Estadual \n",
"1492802 RR RORAIMA 31135397000152 7 Deputado Estadual \n",
"1492794 RR RORAIMA 31135397000152 7 Deputado Estadual \n",
"\n",
" SQ_CANDIDATO NR_CANDIDATO NM_CANDIDATO \\\n",
"1492795 230000601213 55550 LUCENIR VASCONCELOS DE OLIVEIRA LICATA \n",
"1492796 230000601213 55550 LUCENIR VASCONCELOS DE OLIVEIRA LICATA \n",
"1492798 230000601213 55550 LUCENIR VASCONCELOS DE OLIVEIRA LICATA \n",
"1492802 230000601213 55550 LUCENIR VASCONCELOS DE OLIVEIRA LICATA \n",
"1492794 230000601213 55550 LUCENIR VASCONCELOS DE OLIVEIRA LICATA \n",
"\n",
" NR_CPF_CANDIDATO NR_CPF_VICE_CANDIDATO NR_PARTIDO SG_PARTIDO \\\n",
"1492795 67533981200 -1 55 PSD \n",
"1492796 67533981200 -1 55 PSD \n",
"1492798 67533981200 -1 55 PSD \n",
"1492802 67533981200 -1 55 PSD \n",
"1492794 67533981200 -1 55 PSD \n",
"\n",
" NM_PARTIDO CD_TIPO_FORNECEDOR DS_TIPO_FORNECEDOR \\\n",
"1492795 Partido Social Democrático 0 Pessoa Física \n",
"1492796 Partido Social Democrático 0 Pessoa Física \n",
"1492798 Partido Social Democrático 0 Pessoa Física \n",
"1492802 Partido Social Democrático 0 Pessoa Física \n",
"1492794 Partido Social Democrático 0 Pessoa Física \n",
"\n",
" CD_CNAE_FORNECEDOR DS_CNAE_FORNECEDOR NR_CPF_CNPJ_FORNECEDOR \\\n",
"1492795 -1 #NULO# 1924246295 \n",
"1492796 -1 #NULO# 2129705260 \n",
"1492798 -1 #NULO# 9553576249 \n",
"1492802 -1 #NULO# 4804416269 \n",
"1492794 -1 #NULO# 4229916272 \n",
"\n",
" NM_FORNECEDOR \\\n",
"1492795 JOANDERSON SOARES DOS SANTOS \n",
"1492796 WENDER RODRIGUES DA SILVA OLIVEIRA \n",
"1492798 EUFLAVIO DIONIZIO LIMA \n",
"1492802 LIANDRA DE CASSIA RIBEIRO MARQUES \n",
"1492794 FRANCISCO FERNANDES DE OLIVEIRA \n",
"\n",
" NM_FORNECEDOR_RFB CD_ESFERA_PART_FORNECEDOR \\\n",
"1492795 JOANDERSON SOARES DOS SANTOS -1 \n",
"1492796 WENDER RODRIGUES DA SILVA -1 \n",
"1492798 EUFLAVIO DIONIZIO LIMA -1 \n",
"1492802 LIANDRA DE CASSIA RIBEIRO MARQUES -1 \n",
"1492794 FRANCISCO FERNANDES DE OLIVEIRA -1 \n",
"\n",
" DS_ESFERA_PART_FORNECEDOR SG_UF_FORNECEDOR CD_MUNICIPIO_FORNECEDOR \\\n",
"1492795 #NULO# #NULO# -1 \n",
"1492796 #NULO# #NULO# -1 \n",
"1492798 #NULO# #NULO# -1 \n",
"1492802 #NULO# #NULO# -1 \n",
"1492794 #NULO# #NULO# -1 \n",
"\n",
" NM_MUNICIPIO_FORNECEDOR SQ_CANDIDATO_FORNECEDOR \\\n",
"1492795 #NULO# -1 \n",
"1492796 #NULO# -1 \n",
"1492798 #NULO# -1 \n",
"1492802 #NULO# -1 \n",
"1492794 #NULO# -1 \n",
"\n",
" NR_CANDIDATO_FORNECEDOR CD_CARGO_FORNECEDOR DS_CARGO_FORNECEDOR \\\n",
"1492795 -1 -1 #NULO# \n",
"1492796 -1 -1 #NULO# \n",
"1492798 -1 -1 #NULO# \n",
"1492802 -1 -1 #NULO# \n",
"1492794 -1 -1 #NULO# \n",
"\n",
" NR_PARTIDO_FORNECEDOR SG_PARTIDO_FORNECEDOR NM_PARTIDO_FORNECEDOR \\\n",
"1492795 -1 #NULO# #NULO# \n",
"1492796 -1 #NULO# #NULO# \n",
"1492798 -1 #NULO# #NULO# \n",
"1492802 -1 #NULO# #NULO# \n",
"1492794 -1 #NULO# #NULO# \n",
"\n",
" DS_TIPO_DOCUMENTO NR_DOCUMENTO CD_ORIGEM_DESPESA \\\n",
"1492795 Outro CONTRATO 20010000 \n",
"1492796 Outro CONTRATO 20010000 \n",
"1492798 Outro CONTRATO 20120000 \n",
"1492802 Outro CONTRATO 20010000 \n",
"1492794 Outro CONTRATO 20120000 \n",
"\n",
" DS_ORIGEM_DESPESA SQ_DESPESA DT_DESPESA \\\n",
"1492795 Despesas com pessoal 24472382 14/09/2018 \n",
"1492796 Despesas com pessoal 24472385 17/09/2018 \n",
"1492798 Serviços prestados por terceiros 24472381 24/09/2018 \n",
"1492802 Despesas com pessoal 24472383 14/09/2018 \n",
"1492794 Serviços prestados por terceiros 24472378 24/09/2018 \n",
"\n",
" DS_DESPESA VR_DESPESA_CONTRATADA \n",
"1492795 SERVIÇO DE SUPERVISOR GERAL DE CAMPANHA 10000.00 \n",
"1492796 SERVIÇO DE SUPERVISOR DE CAMPANHA 10000.00 \n",
"1492798 SERVIÇO PROFISSIONAL DE ADVOCACIA 10000.00 \n",
"1492802 SERVIÇO DE COORDENADOR GERAL DE CAMPANHA 7940.40 \n",
"1492794 SERVIÇO PROFISSIONAL DE CONTABILIDADE 5000.00 "
]
},
"metadata": {
"tags": []
},
"execution_count": 61
}
]
},
{
"metadata": {
"id": "dLl0zJugylEW",
"colab_type": "code",
"outputId": "0a558ef1-b048-43b9-ce16-1c702a53cbaf",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 428
}
},
"cell_type": "code",
"source": [
"df18cont[df18cont.NM_CANDIDATO == 'TAMIRES ALMEIDA VASCONCELOS'].sort_values(by=['VR_DESPESA_CONTRATADA'],ascending=False).head(5)\n"
],
"execution_count": 63,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>DT_GERACAO</th>\n",
" <th>HH_GERACAO</th>\n",
" <th>ANO_ELEICAO</th>\n",
" <th>CD_TIPO_ELEICAO</th>\n",
" <th>NM_TIPO_ELEICAO</th>\n",
" <th>CD_ELEICAO</th>\n",
" <th>DS_ELEICAO</th>\n",
" <th>DT_ELEICAO</th>\n",
" <th>ST_TURNO</th>\n",
" <th>TP_PRESTACAO_CONTAS</th>\n",
" <th>DT_PRESTACAO_CONTAS</th>\n",
" <th>SQ_PRESTADOR_CONTAS</th>\n",
" <th>SG_UF</th>\n",
" <th>SG_UE</th>\n",
" <th>NM_UE</th>\n",
" <th>NR_CNPJ_PRESTADOR_CONTA</th>\n",
" <th>CD_CARGO</th>\n",
" <th>DS_CARGO</th>\n",
" <th>SQ_CANDIDATO</th>\n",
" <th>NR_CANDIDATO</th>\n",
" <th>NM_CANDIDATO</th>\n",
" <th>NR_CPF_CANDIDATO</th>\n",
" <th>NR_CPF_VICE_CANDIDATO</th>\n",
" <th>NR_PARTIDO</th>\n",
" <th>SG_PARTIDO</th>\n",
" <th>NM_PARTIDO</th>\n",
" <th>CD_TIPO_FORNECEDOR</th>\n",
" <th>DS_TIPO_FORNECEDOR</th>\n",
" <th>CD_CNAE_FORNECEDOR</th>\n",
" <th>DS_CNAE_FORNECEDOR</th>\n",
" <th>NR_CPF_CNPJ_FORNECEDOR</th>\n",
" <th>NM_FORNECEDOR</th>\n",
" <th>NM_FORNECEDOR_RFB</th>\n",
" <th>CD_ESFERA_PART_FORNECEDOR</th>\n",
" <th>DS_ESFERA_PART_FORNECEDOR</th>\n",
" <th>SG_UF_FORNECEDOR</th>\n",
" <th>CD_MUNICIPIO_FORNECEDOR</th>\n",
" <th>NM_MUNICIPIO_FORNECEDOR</th>\n",
" <th>SQ_CANDIDATO_FORNECEDOR</th>\n",
" <th>NR_CANDIDATO_FORNECEDOR</th>\n",
" <th>CD_CARGO_FORNECEDOR</th>\n",
" <th>DS_CARGO_FORNECEDOR</th>\n",
" <th>NR_PARTIDO_FORNECEDOR</th>\n",
" <th>SG_PARTIDO_FORNECEDOR</th>\n",
" <th>NM_PARTIDO_FORNECEDOR</th>\n",
" <th>DS_TIPO_DOCUMENTO</th>\n",
" <th>NR_DOCUMENTO</th>\n",
" <th>CD_ORIGEM_DESPESA</th>\n",
" <th>DS_ORIGEM_DESPESA</th>\n",
" <th>SQ_DESPESA</th>\n",
" <th>DT_DESPESA</th>\n",
" <th>DS_DESPESA</th>\n",
" <th>VR_DESPESA_CONTRATADA</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1119737</th>\n",
" <td>09/02/2019</td>\n",
" <td>10:15:43</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>14/12/2018</td>\n",
" <td>432177550</td>\n",
" <td>PI</td>\n",
" <td>PI</td>\n",
" <td>PIAUÍ</td>\n",
" <td>31299569000123</td>\n",
" <td>7</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>180000628749</td>\n",
" <td>22555</td>\n",
" <td>TAMIRES ALMEIDA VASCONCELOS</td>\n",
" <td>6336579301</td>\n",
" <td>-1</td>\n",
" <td>22</td>\n",
" <td>PR</td>\n",
" <td>Partido da República</td>\n",
" <td>1</td>\n",
" <td>Pessoa Jurídica</td>\n",
" <td>73114</td>\n",
" <td>Agências de publicidade</td>\n",
" <td>5074800000170</td>\n",
" <td>CHROMA COMUNICAÇÃO LTDA.</td>\n",
" <td>CHROMA COMUNICACAO LTDA</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>1789 - 00</td>\n",
" <td>20220000</td>\n",
" <td>Produção de programas de rádio, televisão ou v...</td>\n",
" <td>24722617</td>\n",
" <td>03/09/2018</td>\n",
" <td>CRIAÇÃO· PRODUÇÃO E GRAVAÇÃO DE VTS</td>\n",
" <td>50000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1119718</th>\n",
" <td>09/02/2019</td>\n",
" <td>10:15:43</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>14/12/2018</td>\n",
" <td>432177550</td>\n",
" <td>PI</td>\n",
" <td>PI</td>\n",
" <td>PIAUÍ</td>\n",
" <td>31299569000123</td>\n",
" <td>7</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>180000628749</td>\n",
" <td>22555</td>\n",
" <td>TAMIRES ALMEIDA VASCONCELOS</td>\n",
" <td>6336579301</td>\n",
" <td>-1</td>\n",
" <td>22</td>\n",
" <td>PR</td>\n",
" <td>Partido da República</td>\n",
" <td>1</td>\n",
" <td>Pessoa Jurídica</td>\n",
" <td>82300</td>\n",
" <td>Atividades de organização de eventos, exceto c...</td>\n",
" <td>31072000000120</td>\n",
" <td>MULTIPLA EVENTOS M C EMPRESARIAL EIRELI</td>\n",
" <td>MULTIPLA EVENTOS,MARKETING E CONSULTORIA EMPRE...</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>04 - 00</td>\n",
" <td>20200000</td>\n",
" <td>Eventos de promoção da candidatura</td>\n",
" <td>24722627</td>\n",
" <td>10/09/2018</td>\n",
" <td>ORGANIZAÇÃO DE REUNIOES</td>\n",
" <td>30000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1119725</th>\n",
" <td>09/02/2019</td>\n",
" <td>10:15:43</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>14/12/2018</td>\n",
" <td>432177550</td>\n",
" <td>PI</td>\n",
" <td>PI</td>\n",
" <td>PIAUÍ</td>\n",
" <td>31299569000123</td>\n",
" <td>7</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>180000628749</td>\n",
" <td>22555</td>\n",
" <td>TAMIRES ALMEIDA VASCONCELOS</td>\n",
" <td>6336579301</td>\n",
" <td>-1</td>\n",
" <td>22</td>\n",
" <td>PR</td>\n",
" <td>Partido da República</td>\n",
" <td>1</td>\n",
" <td>Pessoa Jurídica</td>\n",
" <td>47814</td>\n",
" <td>Comércio varejista de artigos do vestuário e a...</td>\n",
" <td>4935978000104</td>\n",
" <td>GLAUCIA A DE SOUSA SANTOS - ME</td>\n",
" <td>GLAUCIA A. DE SOUSA SANTOS</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>05 - 00</td>\n",
" <td>20140000</td>\n",
" <td>Publicidade por materiais impressos</td>\n",
" <td>24722626</td>\n",
" <td>10/09/2018</td>\n",
" <td>BOTONS</td>\n",
" <td>27000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1119736</th>\n",
" <td>09/02/2019</td>\n",
" <td>10:15:43</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>14/12/2018</td>\n",
" <td>432177550</td>\n",
" <td>PI</td>\n",
" <td>PI</td>\n",
" <td>PIAUÍ</td>\n",
" <td>31299569000123</td>\n",
" <td>7</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>180000628749</td>\n",
" <td>22555</td>\n",
" <td>TAMIRES ALMEIDA VASCONCELOS</td>\n",
" <td>6336579301</td>\n",
" <td>-1</td>\n",
" <td>22</td>\n",
" <td>PR</td>\n",
" <td>Partido da República</td>\n",
" <td>1</td>\n",
" <td>Pessoa Jurídica</td>\n",
" <td>59111</td>\n",
" <td>Atividades de produção cinematográfica, de víd...</td>\n",
" <td>14295873000183</td>\n",
" <td>EDUARDO DE AGUIAR COSTA - ME</td>\n",
" <td>EDUARDO DE AGUIAR COSTA</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>146 - 00</td>\n",
" <td>20220000</td>\n",
" <td>Produção de programas de rádio, televisão ou v...</td>\n",
" <td>24722636</td>\n",
" <td>14/09/2018</td>\n",
" <td>PROGRAMAS DE TV E RADIO</td>\n",
" <td>25000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1119744</th>\n",
" <td>09/02/2019</td>\n",
" <td>10:15:43</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>14/12/2018</td>\n",
" <td>432177550</td>\n",
" <td>PI</td>\n",
" <td>PI</td>\n",
" <td>PIAUÍ</td>\n",
" <td>31299569000123</td>\n",
" <td>7</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>180000628749</td>\n",
" <td>22555</td>\n",
" <td>TAMIRES ALMEIDA VASCONCELOS</td>\n",
" <td>6336579301</td>\n",
" <td>-1</td>\n",
" <td>22</td>\n",
" <td>PR</td>\n",
" <td>Partido da República</td>\n",
" <td>1</td>\n",
" <td>Pessoa Jurídica</td>\n",
" <td>18130</td>\n",
" <td>Impressão de materiais para outros usos</td>\n",
" <td>11613235000175</td>\n",
" <td>CLENILDA PLACIDO CORDEIRO ME</td>\n",
" <td>CLENILDA PLACIDO CORDEIRO</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>-1</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>412 - 001</td>\n",
" <td>20140000</td>\n",
" <td>Publicidade por materiais impressos</td>\n",
" <td>24722618</td>\n",
" <td>04/09/2018</td>\n",
" <td>CARTAZES</td>\n",
" <td>22000.00</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" DT_GERACAO HH_GERACAO ANO_ELEICAO CD_TIPO_ELEICAO NM_TIPO_ELEICAO \\\n",
"1119737 09/02/2019 10:15:43 2018 2 Ordinária \n",
"1119718 09/02/2019 10:15:43 2018 2 Ordinária \n",
"1119725 09/02/2019 10:15:43 2018 2 Ordinária \n",
"1119736 09/02/2019 10:15:43 2018 2 Ordinária \n",
"1119744 09/02/2019 10:15:43 2018 2 Ordinária \n",
"\n",
" CD_ELEICAO DS_ELEICAO DT_ELEICAO ST_TURNO \\\n",
"1119737 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"1119718 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"1119725 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"1119736 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"1119744 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"\n",
" TP_PRESTACAO_CONTAS DT_PRESTACAO_CONTAS SQ_PRESTADOR_CONTAS SG_UF \\\n",
"1119737 Final 14/12/2018 432177550 PI \n",
"1119718 Final 14/12/2018 432177550 PI \n",
"1119725 Final 14/12/2018 432177550 PI \n",
"1119736 Final 14/12/2018 432177550 PI \n",
"1119744 Final 14/12/2018 432177550 PI \n",
"\n",
" SG_UE NM_UE NR_CNPJ_PRESTADOR_CONTA CD_CARGO DS_CARGO \\\n",
"1119737 PI PIAUÍ 31299569000123 7 Deputado Estadual \n",
"1119718 PI PIAUÍ 31299569000123 7 Deputado Estadual \n",
"1119725 PI PIAUÍ 31299569000123 7 Deputado Estadual \n",
"1119736 PI PIAUÍ 31299569000123 7 Deputado Estadual \n",
"1119744 PI PIAUÍ 31299569000123 7 Deputado Estadual \n",
"\n",
" SQ_CANDIDATO NR_CANDIDATO NM_CANDIDATO \\\n",
"1119737 180000628749 22555 TAMIRES ALMEIDA VASCONCELOS \n",
"1119718 180000628749 22555 TAMIRES ALMEIDA VASCONCELOS \n",
"1119725 180000628749 22555 TAMIRES ALMEIDA VASCONCELOS \n",
"1119736 180000628749 22555 TAMIRES ALMEIDA VASCONCELOS \n",
"1119744 180000628749 22555 TAMIRES ALMEIDA VASCONCELOS \n",
"\n",
" NR_CPF_CANDIDATO NR_CPF_VICE_CANDIDATO NR_PARTIDO SG_PARTIDO \\\n",
"1119737 6336579301 -1 22 PR \n",
"1119718 6336579301 -1 22 PR \n",
"1119725 6336579301 -1 22 PR \n",
"1119736 6336579301 -1 22 PR \n",
"1119744 6336579301 -1 22 PR \n",
"\n",
" NM_PARTIDO CD_TIPO_FORNECEDOR DS_TIPO_FORNECEDOR \\\n",
"1119737 Partido da República 1 Pessoa Jurídica \n",
"1119718 Partido da República 1 Pessoa Jurídica \n",
"1119725 Partido da República 1 Pessoa Jurídica \n",
"1119736 Partido da República 1 Pessoa Jurídica \n",
"1119744 Partido da República 1 Pessoa Jurídica \n",
"\n",
" CD_CNAE_FORNECEDOR \\\n",
"1119737 73114 \n",
"1119718 82300 \n",
"1119725 47814 \n",
"1119736 59111 \n",
"1119744 18130 \n",
"\n",
" DS_CNAE_FORNECEDOR \\\n",
"1119737 Agências de publicidade \n",
"1119718 Atividades de organização de eventos, exceto c... \n",
"1119725 Comércio varejista de artigos do vestuário e a... \n",
"1119736 Atividades de produção cinematográfica, de víd... \n",
"1119744 Impressão de materiais para outros usos \n",
"\n",
" NR_CPF_CNPJ_FORNECEDOR NM_FORNECEDOR \\\n",
"1119737 5074800000170 CHROMA COMUNICAÇÃO LTDA. \n",
"1119718 31072000000120 MULTIPLA EVENTOS M C EMPRESARIAL EIRELI \n",
"1119725 4935978000104 GLAUCIA A DE SOUSA SANTOS - ME \n",
"1119736 14295873000183 EDUARDO DE AGUIAR COSTA - ME \n",
"1119744 11613235000175 CLENILDA PLACIDO CORDEIRO ME \n",
"\n",
" NM_FORNECEDOR_RFB \\\n",
"1119737 CHROMA COMUNICACAO LTDA \n",
"1119718 MULTIPLA EVENTOS,MARKETING E CONSULTORIA EMPRE... \n",
"1119725 GLAUCIA A. DE SOUSA SANTOS \n",
"1119736 EDUARDO DE AGUIAR COSTA \n",
"1119744 CLENILDA PLACIDO CORDEIRO \n",
"\n",
" CD_ESFERA_PART_FORNECEDOR DS_ESFERA_PART_FORNECEDOR SG_UF_FORNECEDOR \\\n",
"1119737 -1 #NULO# #NULO# \n",
"1119718 -1 #NULO# #NULO# \n",
"1119725 -1 #NULO# #NULO# \n",
"1119736 -1 #NULO# #NULO# \n",
"1119744 -1 #NULO# #NULO# \n",
"\n",
" CD_MUNICIPIO_FORNECEDOR NM_MUNICIPIO_FORNECEDOR \\\n",
"1119737 -1 #NULO# \n",
"1119718 -1 #NULO# \n",
"1119725 -1 #NULO# \n",
"1119736 -1 #NULO# \n",
"1119744 -1 #NULO# \n",
"\n",
" SQ_CANDIDATO_FORNECEDOR NR_CANDIDATO_FORNECEDOR \\\n",
"1119737 -1 -1 \n",
"1119718 -1 -1 \n",
"1119725 -1 -1 \n",
"1119736 -1 -1 \n",
"1119744 -1 -1 \n",
"\n",
" CD_CARGO_FORNECEDOR DS_CARGO_FORNECEDOR NR_PARTIDO_FORNECEDOR \\\n",
"1119737 -1 #NULO# -1 \n",
"1119718 -1 #NULO# -1 \n",
"1119725 -1 #NULO# -1 \n",
"1119736 -1 #NULO# -1 \n",
"1119744 -1 #NULO# -1 \n",
"\n",
" SG_PARTIDO_FORNECEDOR NM_PARTIDO_FORNECEDOR DS_TIPO_DOCUMENTO \\\n",
"1119737 #NULO# #NULO# Nota Fiscal \n",
"1119718 #NULO# #NULO# Nota Fiscal \n",
"1119725 #NULO# #NULO# Nota Fiscal \n",
"1119736 #NULO# #NULO# Nota Fiscal \n",
"1119744 #NULO# #NULO# Nota Fiscal \n",
"\n",
" NR_DOCUMENTO CD_ORIGEM_DESPESA \\\n",
"1119737 1789 - 00 20220000 \n",
"1119718 04 - 00 20200000 \n",
"1119725 05 - 00 20140000 \n",
"1119736 146 - 00 20220000 \n",
"1119744 412 - 001 20140000 \n",
"\n",
" DS_ORIGEM_DESPESA SQ_DESPESA \\\n",
"1119737 Produção de programas de rádio, televisão ou v... 24722617 \n",
"1119718 Eventos de promoção da candidatura 24722627 \n",
"1119725 Publicidade por materiais impressos 24722626 \n",
"1119736 Produção de programas de rádio, televisão ou v... 24722636 \n",
"1119744 Publicidade por materiais impressos 24722618 \n",
"\n",
" DT_DESPESA DS_DESPESA \\\n",
"1119737 03/09/2018 CRIAÇÃO· PRODUÇÃO E GRAVAÇÃO DE VTS \n",
"1119718 10/09/2018 ORGANIZAÇÃO DE REUNIOES \n",
"1119725 10/09/2018 BOTONS \n",
"1119736 14/09/2018 PROGRAMAS DE TV E RADIO \n",
"1119744 04/09/2018 CARTAZES \n",
"\n",
" VR_DESPESA_CONTRATADA \n",
"1119737 50000.00 \n",
"1119718 30000.00 \n",
"1119725 27000.00 \n",
"1119736 25000.00 \n",
"1119744 22000.00 "
]
},
"metadata": {
"tags": []
},
"execution_count": 63
}
]
},
{
"metadata": {
"id": "YGsMPe1W1Xs-",
"colab_type": "code",
"outputId": "495e1b75-201d-496d-b488-de097f82a359",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 133
}
},
"cell_type": "code",
"source": [
"df18_despesa[df18_despesa.NM_CANDIDATO == 'HELEN MACHADO ARAUJO'].head(1)"
],
"execution_count": 51,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>nome_unico</th>\n",
" <th>NR_CPF_CANDIDATO</th>\n",
" <th>SG_UF</th>\n",
" <th>ANO_ELEICAO</th>\n",
" <th>CD_TIPO_ELEICAO</th>\n",
" <th>CD_ELEICAO</th>\n",
" <th>ST_TURNO</th>\n",
" <th>SQ_PRESTADOR_CONTAS</th>\n",
" <th>CD_FONTE_DESPESA</th>\n",
" <th>CD_ORIGEM_DESPESA</th>\n",
" <th>CD_NATUREZA_DESPESA</th>\n",
" <th>CD_ESPECIE_RECURSO</th>\n",
" <th>SQ_DESPESA</th>\n",
" <th>SQ_PARCELAMENTO_DESPESA</th>\n",
" <th>VR_PAGTO_DESPESA</th>\n",
" <th>votos_nominais</th>\n",
" <th>NM_CANDIDATO</th>\n",
" <th>SG_PARTIDO</th>\n",
" <th>Genero</th>\n",
" <th>Deferido</th>\n",
" <th>custo_voto</th>\n",
" <th>verba_publica</th>\n",
" <th>cargo</th>\n",
" <th>eleito</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>7088</th>\n",
" <td>HELEN MACHADO ARAUJO*PTC</td>\n",
" <td>826223290</td>\n",
" <td>AP</td>\n",
" <td>4036</td>\n",
" <td>4</td>\n",
" <td>594</td>\n",
" <td>2</td>\n",
" <td>854497772</td>\n",
" <td>4</td>\n",
" <td>40260000</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>47221015</td>\n",
" <td>31512077</td>\n",
" <td>19750.00</td>\n",
" <td>1.00</td>\n",
" <td>HELEN MACHADO ARAUJO</td>\n",
" <td>PTC</td>\n",
" <td>Mulher</td>\n",
" <td>Sim</td>\n",
" <td>19750.00</td>\n",
" <td>20000.00</td>\n",
" <td>Deputado Estadual</td>\n",
" <td>Suplente</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" nome_unico NR_CPF_CANDIDATO SG_UF ANO_ELEICAO \\\n",
"7088 HELEN MACHADO ARAUJO*PTC 826223290 AP 4036 \n",
"\n",
" CD_TIPO_ELEICAO CD_ELEICAO ST_TURNO SQ_PRESTADOR_CONTAS \\\n",
"7088 4 594 2 854497772 \n",
"\n",
" CD_FONTE_DESPESA CD_ORIGEM_DESPESA CD_NATUREZA_DESPESA \\\n",
"7088 4 40260000 2 \n",
"\n",
" CD_ESPECIE_RECURSO SQ_DESPESA SQ_PARCELAMENTO_DESPESA \\\n",
"7088 2 47221015 31512077 \n",
"\n",
" VR_PAGTO_DESPESA votos_nominais NM_CANDIDATO SG_PARTIDO \\\n",
"7088 19750.00 1.00 HELEN MACHADO ARAUJO PTC \n",
"\n",
" Genero Deferido custo_voto verba_publica cargo eleito \n",
"7088 Mulher Sim 19750.00 20000.00 Deputado Estadual Suplente "
]
},
"metadata": {
"tags": []
},
"execution_count": 51
}
]
},
{
"metadata": {
"id": "YZ-ouwpzUXJQ",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"df18_despesa2 = df18_despesa[['NM_CANDIDATO','SG_PARTIDO','NR_CPF_CANDIDATO','SG_UF','votos_nominais','VR_PAGTO_DESPESA','custo_voto','Genero','Deferido','verba_publica','cargo','eleito']]"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "SsQc0zokb5D6",
"colab_type": "code",
"outputId": "1d39e837-d814-4a34-fc78-6c47626d92ed",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 140
}
},
"cell_type": "code",
"source": [
"df18_despesa2[df18_despesa.votos_nominais < 200].groupby('Genero').sum()"
],
"execution_count": 53,
"outputs": [
{
"output_type": "execute_result",
"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>votos_nominais</th>\n",
" <th>VR_PAGTO_DESPESA</th>\n",
" <th>custo_voto</th>\n",
" <th>verba_publica</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Genero</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>Homem</th>\n",
" <td>71153.00</td>\n",
" <td>20024331.54</td>\n",
" <td>inf</td>\n",
" <td>12113274.72</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Mulher</th>\n",
" <td>101534.00</td>\n",
" <td>21058885.84</td>\n",
" <td>inf</td>\n",
" <td>43017826.53</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" votos_nominais VR_PAGTO_DESPESA custo_voto verba_publica\n",
"Genero \n",
"Homem 71153.00 20024331.54 inf 12113274.72\n",
"Mulher 101534.00 21058885.84 inf 43017826.53"
]
},
"metadata": {
"tags": []
},
"execution_count": 53
}
]
},
{
"metadata": {
"id": "4LIihFDBup5i",
"colab_type": "code",
"outputId": "b728beeb-82ca-4dfa-90b2-4b8c2f9cf85e",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 445
}
},
"cell_type": "code",
"source": [
"df18pg.head(5)"
],
"execution_count": 62,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>DT_GERACAO</th>\n",
" <th>HH_GERACAO</th>\n",
" <th>ANO_ELEICAO</th>\n",
" <th>CD_TIPO_ELEICAO</th>\n",
" <th>NM_TIPO_ELEICAO</th>\n",
" <th>CD_ELEICAO</th>\n",
" <th>DS_ELEICAO</th>\n",
" <th>DT_ELEICAO</th>\n",
" <th>ST_TURNO</th>\n",
" <th>TP_PRESTACAO_CONTAS</th>\n",
" <th>DT_PRESTACAO_CONTAS</th>\n",
" <th>SQ_PRESTADOR_CONTAS</th>\n",
" <th>SG_UF</th>\n",
" <th>DS_TIPO_DOCUMENTO</th>\n",
" <th>NR_DOCUMENTO</th>\n",
" <th>CD_FONTE_DESPESA</th>\n",
" <th>DS_FONTE_DESPESA</th>\n",
" <th>CD_ORIGEM_DESPESA</th>\n",
" <th>DS_ORIGEM_DESPESA</th>\n",
" <th>CD_NATUREZA_DESPESA</th>\n",
" <th>DS_NATUREZA_DESPESA</th>\n",
" <th>CD_ESPECIE_RECURSO</th>\n",
" <th>DS_ESPECIE_RECURSO</th>\n",
" <th>SQ_DESPESA</th>\n",
" <th>SQ_PARCELAMENTO_DESPESA</th>\n",
" <th>DT_PAGTO_DESPESA</th>\n",
" <th>DS_DESPESA</th>\n",
" <th>VR_PAGTO_DESPESA</th>\n",
" <th>NM_CANDIDATO</th>\n",
" <th>NR_CPF_CANDIDATO</th>\n",
" <th>SG_PARTIDO</th>\n",
" <th>nome_unico</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>406838759</td>\n",
" <td>ES</td>\n",
" <td>#NULO#</td>\n",
" <td>#NULO#</td>\n",
" <td>1</td>\n",
" <td>Outros Recursos</td>\n",
" <td>20210000</td>\n",
" <td>Encargos financeiros, taxas bancárias e/ou op....</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>22662971</td>\n",
" <td>14731017</td>\n",
" <td>14/08/2018</td>\n",
" <td>Encargos financeiros, taxas bancárias e/ou op....</td>\n",
" <td>13.20</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE</td>\n",
" <td>88961117734</td>\n",
" <td>NOVO</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE*NOVO</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>406838759</td>\n",
" <td>ES</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>850006</td>\n",
" <td>1</td>\n",
" <td>Outros Recursos</td>\n",
" <td>20140000</td>\n",
" <td>Publicidade por materiais impressos</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>22662978</td>\n",
" <td>14731028</td>\n",
" <td>24/09/2018</td>\n",
" <td>Publicidade por materiais impressos</td>\n",
" <td>450.00</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE</td>\n",
" <td>88961117734</td>\n",
" <td>NOVO</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE*NOVO</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>406838759</td>\n",
" <td>ES</td>\n",
" <td>Duplicata</td>\n",
" <td>100201</td>\n",
" <td>1</td>\n",
" <td>Outros Recursos</td>\n",
" <td>20420000</td>\n",
" <td>Despesa com Impulsionamento de Conteúdos</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>22662982</td>\n",
" <td>14731024</td>\n",
" <td>02/10/2018</td>\n",
" <td>Despesa com Impulsionamento de Conteúdos</td>\n",
" <td>747.34</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE</td>\n",
" <td>88961117734</td>\n",
" <td>NOVO</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE*NOVO</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>406838759</td>\n",
" <td>ES</td>\n",
" <td>Nota Fiscal</td>\n",
" <td>92601</td>\n",
" <td>1</td>\n",
" <td>Outros Recursos</td>\n",
" <td>20260000</td>\n",
" <td>Criação e inclusão de páginas na internet</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>22662975</td>\n",
" <td>14731030</td>\n",
" <td>28/09/2018</td>\n",
" <td>Criação e inclusão de páginas na internet</td>\n",
" <td>297.00</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE</td>\n",
" <td>88961117734</td>\n",
" <td>NOVO</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE*NOVO</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>10/02/2019</td>\n",
" <td>03:28:27</td>\n",
" <td>2018</td>\n",
" <td>2</td>\n",
" <td>Ordinária</td>\n",
" <td>297</td>\n",
" <td>Eleição Geral Federal 2018</td>\n",
" <td>07/10/2018</td>\n",
" <td>1</td>\n",
" <td>Final</td>\n",
" <td>06/11/2018</td>\n",
" <td>406838759</td>\n",
" <td>ES</td>\n",
" <td>Outro</td>\n",
" <td>#NULO#</td>\n",
" <td>1</td>\n",
" <td>Outros Recursos</td>\n",
" <td>20410000</td>\n",
" <td>Taxa de Administração de Financiamento Coletivo</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>1</td>\n",
" <td>Financeiro</td>\n",
" <td>22662984</td>\n",
" <td>14731026</td>\n",
" <td>04/09/2018</td>\n",
" <td>Taxa Administração Financiamento Coletivo</td>\n",
" <td>12.50</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE</td>\n",
" <td>88961117734</td>\n",
" <td>NOVO</td>\n",
" <td>ALEXANDRE MAGNO DE ANDRADE*NOVO</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" DT_GERACAO HH_GERACAO ANO_ELEICAO CD_TIPO_ELEICAO NM_TIPO_ELEICAO \\\n",
"0 10/02/2019 03:28:27 2018 2 Ordinária \n",
"1 10/02/2019 03:28:27 2018 2 Ordinária \n",
"2 10/02/2019 03:28:27 2018 2 Ordinária \n",
"3 10/02/2019 03:28:27 2018 2 Ordinária \n",
"4 10/02/2019 03:28:27 2018 2 Ordinária \n",
"\n",
" CD_ELEICAO DS_ELEICAO DT_ELEICAO ST_TURNO \\\n",
"0 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"1 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"2 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"3 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"4 297 Eleição Geral Federal 2018 07/10/2018 1 \n",
"\n",
" TP_PRESTACAO_CONTAS DT_PRESTACAO_CONTAS SQ_PRESTADOR_CONTAS SG_UF \\\n",
"0 Final 06/11/2018 406838759 ES \n",
"1 Final 06/11/2018 406838759 ES \n",
"2 Final 06/11/2018 406838759 ES \n",
"3 Final 06/11/2018 406838759 ES \n",
"4 Final 06/11/2018 406838759 ES \n",
"\n",
" DS_TIPO_DOCUMENTO NR_DOCUMENTO CD_FONTE_DESPESA DS_FONTE_DESPESA \\\n",
"0 #NULO# #NULO# 1 Outros Recursos \n",
"1 Nota Fiscal 850006 1 Outros Recursos \n",
"2 Duplicata 100201 1 Outros Recursos \n",
"3 Nota Fiscal 92601 1 Outros Recursos \n",
"4 Outro #NULO# 1 Outros Recursos \n",
"\n",
" CD_ORIGEM_DESPESA DS_ORIGEM_DESPESA \\\n",
"0 20210000 Encargos financeiros, taxas bancárias e/ou op.... \n",
"1 20140000 Publicidade por materiais impressos \n",
"2 20420000 Despesa com Impulsionamento de Conteúdos \n",
"3 20260000 Criação e inclusão de páginas na internet \n",
"4 20410000 Taxa de Administração de Financiamento Coletivo \n",
"\n",
" CD_NATUREZA_DESPESA DS_NATUREZA_DESPESA CD_ESPECIE_RECURSO \\\n",
"0 1 Financeiro 1 \n",
"1 1 Financeiro 1 \n",
"2 1 Financeiro 1 \n",
"3 1 Financeiro 1 \n",
"4 1 Financeiro 1 \n",
"\n",
" DS_ESPECIE_RECURSO SQ_DESPESA SQ_PARCELAMENTO_DESPESA DT_PAGTO_DESPESA \\\n",
"0 Financeiro 22662971 14731017 14/08/2018 \n",
"1 Financeiro 22662978 14731028 24/09/2018 \n",
"2 Financeiro 22662982 14731024 02/10/2018 \n",
"3 Financeiro 22662975 14731030 28/09/2018 \n",
"4 Financeiro 22662984 14731026 04/09/2018 \n",
"\n",
" DS_DESPESA VR_PAGTO_DESPESA \\\n",
"0 Encargos financeiros, taxas bancárias e/ou op.... 13.20 \n",
"1 Publicidade por materiais impressos 450.00 \n",
"2 Despesa com Impulsionamento de Conteúdos 747.34 \n",
"3 Criação e inclusão de páginas na internet 297.00 \n",
"4 Taxa Administração Financiamento Coletivo 12.50 \n",
"\n",
" NM_CANDIDATO NR_CPF_CANDIDATO SG_PARTIDO \\\n",
"0 ALEXANDRE MAGNO DE ANDRADE 88961117734 NOVO \n",
"1 ALEXANDRE MAGNO DE ANDRADE 88961117734 NOVO \n",
"2 ALEXANDRE MAGNO DE ANDRADE 88961117734 NOVO \n",
"3 ALEXANDRE MAGNO DE ANDRADE 88961117734 NOVO \n",
"4 ALEXANDRE MAGNO DE ANDRADE 88961117734 NOVO \n",
"\n",
" nome_unico \n",
"0 ALEXANDRE MAGNO DE ANDRADE*NOVO \n",
"1 ALEXANDRE MAGNO DE ANDRADE*NOVO \n",
"2 ALEXANDRE MAGNO DE ANDRADE*NOVO \n",
"3 ALEXANDRE MAGNO DE ANDRADE*NOVO \n",
"4 ALEXANDRE MAGNO DE ANDRADE*NOVO "
]
},
"metadata": {
"tags": []
},
"execution_count": 62
}
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment