Skip to content

Instantly share code, notes, and snippets.

@nportinari

nportinari/verba_ministerio_saude.ipynb

Last active March 12, 2020 17:40
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save nportinari/aec65d3ee2cf928a222012fb039acd64 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save nportinari/aec65d3ee2cf928a222012fb039acd64 to your computer and use it in GitHub Desktop.
Download ZIP
Verba - Ministério da Saúde
Display the source blob
Display the rendered blob
Raw
verba_ministerio_saude.ipynb
{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"name": "Verba - Ministério da Saúde",
"version": "0.3.2",
"provenance": [],
"collapsed_sections": [],
"include_colab_link": true
},
"kernelspec": {
"name": "python3",
"display_name": "Python 3"
},
"accelerator": "GPU"
},
"cells": [
{
"cell_type": "markdown",
"metadata": {
"id": "view-in-github",
"colab_type": "text"
},
"source": [
"<a href=\"https://colab.research.google.com/gist/nportinari/aec65d3ee2cf928a222012fb039acd64/verba-minist-rio-da-sa-de.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "krQQ8RAAqvEh",
"colab_type": "text"
},
"source": [
"Esse código é uma instrução simples de como compilar e limpar uma base de dados de municípios que receberam verbas de ações extraorçamentárias do Ministério da Saúde. As ações foram liberadas na negociação da reforma da Previdência e os municípios contemplados foram indicados por deputados, como mostrou uma reportagem do jornal O Globo.\n",
"\n",
"https://oglobo.globo.com/brasil/governo-paga-21-bi-municipios-por-acordos-com-deputados-pela-reforma-da-previdencia-23932654"
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "4U-SbIYtUcaP",
"colab_type": "text"
},
"source": [
"# **Importando as bases de dados**"
]
},
{
"cell_type": "code",
"metadata": {
"id": "xvsd1HDHaqzX",
"colab_type": "code",
"colab": {}
},
"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",
"pd.options.display.float_format = \"{:.2f}\".format"
],
"execution_count": 0,
"outputs": []
},
{
"cell_type": "code",
"metadata": {
"id": "LNurE-WRZehO",
"colab_type": "code",
"colab": {}
},
"source": [
"!pip install -q xlrd"
],
"execution_count": 0,
"outputs": []
},
{
"cell_type": "markdown",
"metadata": {
"id": "0k99O8jOpZdd",
"colab_type": "text"
},
"source": [
"As tabelas de todos os Estados foram importadas manualmente desse link:\n",
"http://www.fns2.saude.gov.br/propostaconsulta/inicio.asp"
]
},
{
"cell_type": "code",
"metadata": {
"id": "kF6vxH1Ggwdp",
"colab_type": "code",
"colab": {}
},
"source": [
"df = pd.DataFrame()\n",
"\n",
"cods = ['1Y6XYivfJ2dV4AMDgQF86ZamzFfqY2mgq',\n",
"'1vwX2IdQi2G2h5roUF50UsvpfDzw6X2Lr',\n",
"'1AdNP2eOAxWMpd0rGL4_QprSP6JgJYa6w',\n",
"'1EW6wMNVKPwu6lehUB88q60LaeaMgn5xY',\n",
"'1yZyWLIHJ2bZwfygzqxXftLVzg2Ly7xnk',\n",
"'1UQ9U128nTv4MtH6ovJUq-A92lEzZUxt7',\n",
"'1iFaRrr4dyCCqlZ-kxa1PtA7RXQlRdMrC',\n",
"'12NWRebic8z5dyY4Y5VJj2wP9WiyJ3aUU',\n",
"'1-lWcbTD_wJ5ZCOpsQURaDywl2DZmnSbv',\n",
"'1k1h7py8fF4jingkH_ZQyPoMC_gPFf9th',\n",
"'1p1P5SSmZZSKc7JKO6D9aPOICYazxe6Tt',\n",
"'1ttsq8JAYb0iHSFszTRmqEbEJklInsw-h',\n",
"'1qpGHeApBINfv18GZf0kmT3PbGmc-G4R4',\n",
"'1uauWf3v3mWz2qPE2xJLkoTPbcnId1dHF',\n",
"'18WrGCHRZ1ho50W0GIMZD9K5DFJQTrMP_',\n",
"'1RwY0lclXyDuxG52Z52a0BjclVHY9mbve',\n",
"'1q3m6TK2c7snjVz53MTw2jlL3v7TVuyvq',\n",
"'1xYkRZMTpQ_lAk2nR_DS-KKiOcth5glM2',\n",
"'1c1xNSQuRkvVldmGG4lK02N24sjKjoTYh',\n",
"'1VNfFnbhNUmIy0CJUexjcI0KNXCO6WrHM',\n",
"'1EWXoZqzuPOVeilbigd7ZJKa3ydS6RkG8',\n",
"'1FsGRBvT-O7j3M8TJvEO19TFIuZnkT2Uq',\n",
"'1brnBUrDmQsvqYQ2jDz3vnAfjKJBGGQYl',\n",
"'1z0CFcuYjz1ChyrIXShuhPJSPpcXpRFF4',\n",
"'10v3PtlZsbmz1EDYzExxl_Dh-Ev317X4j',\n",
"'119pRRZ91dhvhQdK3J6Z3ObsjBaUrYG6g',\n",
"'1vZEQa4yRdSLvNn75eftSUPpz_TtJ3pxX',\n",
"'1hi2lizKMyEMubzZNorNVzD17kWw-8__i',\n",
"'1pADlGIuHIJggUuUQPsoSmk3EOUh0Eyla',\n",
"'1qqzneUSOCf6MBEZd4UKj50QrfHAjKtzO',\n",
"'1XJcjF51Gby4Rzp3Vk56ukuJFxMyz2Jpz',\n",
"'1_CuHmLajDAnk5YqLRCueXEQ51P165peo',\n",
"'1B3OjjpslgrMnMW8x0RJ70kPAF7j0eY0E',\n",
"'1nUqZ73gvfES901gXsxkn1bewzfQdw731',\n",
"'1GAHfrbjefqsj2BD37QndiH3UrDuPkDWP',\n",
"'1N1xKAlL0YfrNagRxch3vGQhvchSV9byb',\n",
"'1hPkL2Ww4nGLqkYr02S9My0eOWkmqKcWs',\n",
"'1cjpZ9YvIF9uCBI4mdFpp8HGwpTz2B8dV',\n",
"'17k6Sc0K6YvpZpPdOxLfAK-b6CID-uO2R',\n",
"'1fhlX_CwHZ-XWc74YnK3BSbXeLEQJfpok',\n",
"'1pcItybz6qwqk_n1n27xpitii1ru97nyT',\n",
"'1dOAjoO1Qtd0_u8tk6P1sCmiQxX7cJ5e9',\n",
"'1llGV4hDopcrdg8UNBQy9-FhMThwNhfXQ',\n",
"'1N8SD2vG2XYzrtQfZeMZ0y9IMCkcsQpnq',\n",
"'19NN-TSYrz5H9wl1WmH6fgHHCTQyzOh-U',\n",
"'1W381haLW7NUMyiu26_sokgQf6PAlZqXz',\n",
"'1J5I6xXdWJpg9x4rX9MpD8nY6I_TL9gdw',\n",
"'1vseunzylPXleIDsPgz0C__IM2FRZztxl',\n",
"'12jspFyNuTP098m-KJNfWS17uYFodwbQH',\n",
"'1E97jTWjx69_Ubo2eJxxFmm6dB_-GiLIm',\n",
"'16toJh9duzvNNUH9QkZMOvBWQq_rNcx5X',\n",
"'1A5u5tNhH0Wp75tGU_1tlQcDphLIAkvCd',\n",
"'1c4vzPBVF5aPwWbCC4EOPNafzqkuKkem-',\n",
"'1O_Fqu1cAhw2KGhVMhOVYqtdJVfLUsq7h',\n",
"'1PFQqkwmRElkZG1GXWImUJe__8vBNKvgc',\n",
"'16BYLCvQf3OrWi6FXxA793vMKrSvWvC5p',\n",
"'1xqlMTzo27qZ0xuULmIFgcRFHTqtD7oT7']\n",
"\n",
"for cod in cods:\n",
" tabela = drive.CreateFile({'id':cod})\n",
" tabela.GetContentFile('tabela')\n",
" tabela = pd.read_html('tabela', encoding = 'latin-1',skiprows=1)\n",
" resultado = tabela[0]\n",
" df = pd.concat([df, resultado])"
],
"execution_count": 0,
"outputs": []
},
{
"cell_type": "code",
"metadata": {
"id": "GxC6O3vMbdCb",
"colab_type": "code",
"colab": {}
},
"source": [
"df.columns = ['NU_PROPOSTA',\n",
" 'UF',\n",
" 'MUNICIPIO',\n",
" 'ENTIDADE',\n",
" 'NU_CNPJ_ENTIDADE',\n",
" 'NU_PROCESSO',\n",
" 'ANO',\n",
" 'NU_PORTARIA',\n",
" 'DT_PORTARIA',\n",
" 'TIPO',\n",
" 'VALOR_PROPOSTA',\n",
" 'VL_EMPENHADO',\n",
" 'VL_PAGO',\n",
" 'LOCALIZACAO',\n",
" 'TIPO_RECURSO',\n",
" 'NU_PROCESSO_PGTO',\n",
" 'CO_SITUACAO_INTERNA',\n",
" 'LOCALIZACAO_PGTO',\n",
" 'SG_PARTIDO_POLITICO',\n",
" 'NO_APELIDO',\n",
" 'VL_IND_OBJETO',\n",
" 'DS_SITUACAO_PROPOSTA']"
],
"execution_count": 0,
"outputs": []
},
{
"cell_type": "markdown",
"metadata": {
"id": "ob_Ccj_aphoc",
"colab_type": "text"
},
"source": [
"Criei uma regra específica para as tabelas de Tocantinas e Mato Grosso do Sul com uma formatação diferente."
]
},
{
"cell_type": "code",
"metadata": {
"id": "Z8_cSyFtbjbo",
"colab_type": "code",
"colab": {}
},
"source": [
"copia = df[df.UF.isin(['TO','MS'])]"
],
"execution_count": 0,
"outputs": []
},
{
"cell_type": "markdown",
"metadata": {
"id": "be3GTFlBp-H_",
"colab_type": "text"
},
"source": [
"Corrigindo os dígitos com formato brasileiro."
]
},
{
"cell_type": "code",
"metadata": {
"id": "-sFW8evSjHm8",
"colab_type": "code",
"colab": {}
},
"source": [
"df['VL_PAGO'] = df['VL_PAGO'].str[:-2].str.replace('.','')\n",
"df['VL_PAGO'] = df['VL_PAGO'].astype(float)\n",
"\n",
"df['VL_EMPENHADO'] = df['VL_EMPENHADO'].str[:-2].str.replace('.','')\n",
"df['VL_EMPENHADO'] = df['VL_EMPENHADO'].astype(float)\n",
"\n",
"df['VALOR_PROPOSTA'] = df['VALOR_PROPOSTA'].str[:-2].str.replace('.','')\n",
"df['VALOR_PROPOSTA'] = df['VALOR_PROPOSTA'].astype(float)"
],
"execution_count": 0,
"outputs": []
},
{
"cell_type": "code",
"metadata": {
"id": "HzYOFt_4l73W",
"colab_type": "code",
"outputId": "612665ff-ca99-4d20-d22a-6353da6e58d6",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 124
}
},
"source": [
"copia.loc[:,'VL_PAGO'] = copia['VL_PAGO'].astype(float) * 1000\n",
"copia.loc[:,'VALOR_PROPOSTA'] = copia['VALOR_PROPOSTA'].astype(float) * 1000\n",
"copia.loc[:,'VL_EMPENHADO'] = copia['VL_EMPENHADO'].astype(float) * 1000"
],
"execution_count": 8,
"outputs": [
{
"output_type": "stream",
"text": [
"/usr/local/lib/python3.6/dist-packages/pandas/core/indexing.py:543: SettingWithCopyWarning: \n",
"A value is trying to be set on a copy of a slice from a DataFrame.\n",
"Try using .loc[row_indexer,col_indexer] = value instead\n",
"\n",
"See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
" self.obj[item] = s\n"
],
"name": "stderr"
}
]
},
{
"cell_type": "code",
"metadata": {
"id": "zgcGodNEnV5A",
"colab_type": "code",
"outputId": "1c741c4b-a71a-4eb5-da86-9569b98c62f5",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 35
}
},
"source": [
"df['VL_PAGO'].sum()"
],
"execution_count": 9,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"2106677620.0"
]
},
"metadata": {
"tags": []
},
"execution_count": 9
}
]
},
{
"cell_type": "code",
"metadata": {
"id": "g9HqHvjM9CDf",
"colab_type": "code",
"colab": {}
},
"source": [
"df[df.UF.isin(['TO','MS'])] = copia"
],
"execution_count": 0,
"outputs": []
},
{
"cell_type": "code",
"metadata": {
"id": "5WrGiT0qnZgg",
"colab_type": "code",
"colab": {}
},
"source": [
"df['DT_PORTARIA'] = pd.to_datetime(df['DT_PORTARIA'],dayfirst = True)"
],
"execution_count": 0,
"outputs": []
},
{
"cell_type": "code",
"metadata": {
"id": "68x5SxSVoiDm",
"colab_type": "code",
"colab": {}
},
"source": [
"df['MES'] = df['DT_PORTARIA'].dt.month"
],
"execution_count": 0,
"outputs": []
},
{
"cell_type": "markdown",
"metadata": {
"id": "9XTK-wBzprJ6",
"colab_type": "text"
},
"source": [
"Checando se corrigiu."
]
},
{
"cell_type": "code",
"metadata": {
"id": "_i4QWvpv9OSL",
"colab_type": "code",
"outputId": "cd3e12b2-25da-4efc-c4e3-dd2d06c790bd",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 510
}
},
"source": [
"df[df.UF.isin(['TO','MS'])]"
],
"execution_count": 13,
"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>NU_PROPOSTA</th>\n",
" <th>UF</th>\n",
" <th>MUNICIPIO</th>\n",
" <th>ENTIDADE</th>\n",
" <th>NU_CNPJ_ENTIDADE</th>\n",
" <th>NU_PROCESSO</th>\n",
" <th>ANO</th>\n",
" <th>NU_PORTARIA</th>\n",
" <th>DT_PORTARIA</th>\n",
" <th>TIPO</th>\n",
" <th>VALOR_PROPOSTA</th>\n",
" <th>VL_EMPENHADO</th>\n",
" <th>VL_PAGO</th>\n",
" <th>LOCALIZACAO</th>\n",
" <th>TIPO_RECURSO</th>\n",
" <th>NU_PROCESSO_PGTO</th>\n",
" <th>CO_SITUACAO_INTERNA</th>\n",
" <th>LOCALIZACAO_PGTO</th>\n",
" <th>SG_PARTIDO_POLITICO</th>\n",
" <th>NO_APELIDO</th>\n",
" <th>VL_IND_OBJETO</th>\n",
" <th>DS_SITUACAO_PROPOSTA</th>\n",
" <th>MES</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>36000.2717472/01-900</td>\n",
" <td>MS</td>\n",
" <td>PONTA PORA</td>\n",
" <td>FUNDO MUNICIPAL DE SAUDE</td>\n",
" <td>11.084.263/0001-42</td>\n",
" <td>00000.000000/0000-00</td>\n",
" <td>2019</td>\n",
" <td>2099.00</td>\n",
" <td>2019-08-07</td>\n",
" <td>INCREMENTO PAB</td>\n",
" <td>300000.00</td>\n",
" <td>300000.00</td>\n",
" <td>300000.00</td>\n",
" <td>nan</td>\n",
" <td>PROPOSTA FAF</td>\n",
" <td>25000.135141/2019-91</td>\n",
" <td>APROVADO</td>\n",
" <td>DICOG em 19/08/2019 11:50</td>\n",
" <td>nan</td>\n",
" <td>PROGRAMAÇÃO</td>\n",
" <td>300.00</td>\n",
" <td>Proposta em análise de Pagamento</td>\n",
" <td>8.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>36000.2718232/01-900</td>\n",
" <td>MS</td>\n",
" <td>BATAGUASSU</td>\n",
" <td>FUNDO MUNICIPAL DE SAUDE</td>\n",
" <td>10.836.939/0001-44</td>\n",
" <td>00000.000000/0000-00</td>\n",
" <td>2019</td>\n",
" <td>2099.00</td>\n",
" <td>2019-08-07</td>\n",
" <td>INCREMENTO PAB</td>\n",
" <td>500000.00</td>\n",
" <td>500000.00</td>\n",
" <td>500000.00</td>\n",
" <td>nan</td>\n",
" <td>PROPOSTA FAF</td>\n",
" <td>25000.135141/2019-91</td>\n",
" <td>PAGO</td>\n",
" <td>DICOG em 19/08/2019 11:50</td>\n",
" <td>nan</td>\n",
" <td>PROGRAMAÇÃO</td>\n",
" <td>500.00</td>\n",
" <td>Proposta em análise de Pagamento</td>\n",
" <td>8.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>36000.2719262/01-900</td>\n",
" <td>MS</td>\n",
" <td>LADARIO</td>\n",
" <td>FUNDO MUNICIPAL DE SAUDE</td>\n",
" <td>15.363.895/0001-04</td>\n",
" <td>00000.000000/0000-00</td>\n",
" <td>2019</td>\n",
" <td>2099.00</td>\n",
" <td>2019-08-07</td>\n",
" <td>INCREMENTO PAB</td>\n",
" <td>160000.00</td>\n",
" <td>160000.00</td>\n",
" <td>160000.00</td>\n",
" <td>nan</td>\n",
" <td>PROPOSTA FAF</td>\n",
" <td>25000.135141/2019-91</td>\n",
" <td>APROVADO</td>\n",
" <td>DICOG em 19/08/2019 11:50</td>\n",
" <td>nan</td>\n",
" <td>PROGRAMAÇÃO</td>\n",
" <td>160.00</td>\n",
" <td>Proposta em análise de Pagamento</td>\n",
" <td>8.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>36000.2719482/01-900</td>\n",
" <td>MS</td>\n",
" <td>INOCENCIA</td>\n",
" <td>FUNDO MUNICIPAL DE SAUDE</td>\n",
" <td>11.095.923/0001-90</td>\n",
" <td>00000.000000/0000-00</td>\n",
" <td>2019</td>\n",
" <td>2099.00</td>\n",
" <td>2019-08-07</td>\n",
" <td>INCREMENTO PAB</td>\n",
" <td>650000.00</td>\n",
" <td>650000.00</td>\n",
" <td>650000.00</td>\n",
" <td>nan</td>\n",
" <td>PROPOSTA FAF</td>\n",
" <td>25000.135141/2019-91</td>\n",
" <td>APROVADO</td>\n",
" <td>DICOG em 19/08/2019 11:50</td>\n",
" <td>nan</td>\n",
" <td>PROGRAMAÇÃO</td>\n",
" <td>650.00</td>\n",
" <td>Proposta em análise de Pagamento</td>\n",
" <td>8.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>36000.2720822/01-900</td>\n",
" <td>MS</td>\n",
" <td>NOVA ALVORADA DO SUL</td>\n",
" <td>FUNDO MUNICIPAL DE SAUDE DE NOVA ALVORADA DO SUL</td>\n",
" <td>10.474.017/0001-34</td>\n",
" <td>00000.000000/0000-00</td>\n",
" <td>2019</td>\n",
" <td>2099.00</td>\n",
" <td>2019-08-07</td>\n",
" <td>INCREMENTO PAB</td>\n",
" <td>500000.00</td>\n",
" <td>500000.00</td>\n",
" <td>500000.00</td>\n",
" <td>nan</td>\n",
" <td>PROPOSTA FAF</td>\n",
" <td>25000.135141/2019-91</td>\n",
" <td>APROVADO</td>\n",
" <td>DICOG em 19/08/2019 11:50</td>\n",
" <td>nan</td>\n",
" <td>PROGRAMAÇÃO</td>\n",
" <td>500.00</td>\n",
" <td>Proposta em análise de Pagamento</td>\n",
" <td>8.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>36000.2722532/01-900</td>\n",
" <td>TO</td>\n",
" <td>AUGUSTINOPOLIS</td>\n",
" <td>FUNDO MUNICIPAL DE SAUDE DE AUGUSTINOPOLIS</td>\n",
" <td>11.421.097/0001-22</td>\n",
" <td>00000.000000/0000-00</td>\n",
" <td>2019</td>\n",
" <td>2061.00</td>\n",
" <td>2019-08-05</td>\n",
" <td>INCREMENTO PAB</td>\n",
" <td>300000.00</td>\n",
" <td>300000.00</td>\n",
" <td>300000.00</td>\n",
" <td>nan</td>\n",
" <td>PROPOSTA FAF</td>\n",
" <td>25000.131173/2019-18</td>\n",
" <td>PAGO</td>\n",
" <td>DICOG em 12/08/2019 14:06</td>\n",
" <td>nan</td>\n",
" <td>PROGRAMAÇÃO</td>\n",
" <td>300.00</td>\n",
" <td>Proposta em análise de Pagamento</td>\n",
" <td>8.00</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" NU_PROPOSTA UF MUNICIPIO \\\n",
"0 36000.2717472/01-900 MS PONTA PORA \n",
"1 36000.2718232/01-900 MS BATAGUASSU \n",
"2 36000.2719262/01-900 MS LADARIO \n",
"3 36000.2719482/01-900 MS INOCENCIA \n",
"4 36000.2720822/01-900 MS NOVA ALVORADA DO SUL \n",
"0 36000.2722532/01-900 TO AUGUSTINOPOLIS \n",
"\n",
" ENTIDADE NU_CNPJ_ENTIDADE \\\n",
"0 FUNDO MUNICIPAL DE SAUDE 11.084.263/0001-42 \n",
"1 FUNDO MUNICIPAL DE SAUDE 10.836.939/0001-44 \n",
"2 FUNDO MUNICIPAL DE SAUDE 15.363.895/0001-04 \n",
"3 FUNDO MUNICIPAL DE SAUDE 11.095.923/0001-90 \n",
"4 FUNDO MUNICIPAL DE SAUDE DE NOVA ALVORADA DO SUL 10.474.017/0001-34 \n",
"0 FUNDO MUNICIPAL DE SAUDE DE AUGUSTINOPOLIS 11.421.097/0001-22 \n",
"\n",
" NU_PROCESSO ANO NU_PORTARIA DT_PORTARIA TIPO \\\n",
"0 00000.000000/0000-00 2019 2099.00 2019-08-07 INCREMENTO PAB \n",
"1 00000.000000/0000-00 2019 2099.00 2019-08-07 INCREMENTO PAB \n",
"2 00000.000000/0000-00 2019 2099.00 2019-08-07 INCREMENTO PAB \n",
"3 00000.000000/0000-00 2019 2099.00 2019-08-07 INCREMENTO PAB \n",
"4 00000.000000/0000-00 2019 2099.00 2019-08-07 INCREMENTO PAB \n",
"0 00000.000000/0000-00 2019 2061.00 2019-08-05 INCREMENTO PAB \n",
"\n",
" VALOR_PROPOSTA VL_EMPENHADO VL_PAGO LOCALIZACAO TIPO_RECURSO \\\n",
"0 300000.00 300000.00 300000.00 nan PROPOSTA FAF \n",
"1 500000.00 500000.00 500000.00 nan PROPOSTA FAF \n",
"2 160000.00 160000.00 160000.00 nan PROPOSTA FAF \n",
"3 650000.00 650000.00 650000.00 nan PROPOSTA FAF \n",
"4 500000.00 500000.00 500000.00 nan PROPOSTA FAF \n",
"0 300000.00 300000.00 300000.00 nan PROPOSTA FAF \n",
"\n",
" NU_PROCESSO_PGTO CO_SITUACAO_INTERNA LOCALIZACAO_PGTO \\\n",
"0 25000.135141/2019-91 APROVADO DICOG em 19/08/2019 11:50 \n",
"1 25000.135141/2019-91 PAGO DICOG em 19/08/2019 11:50 \n",
"2 25000.135141/2019-91 APROVADO DICOG em 19/08/2019 11:50 \n",
"3 25000.135141/2019-91 APROVADO DICOG em 19/08/2019 11:50 \n",
"4 25000.135141/2019-91 APROVADO DICOG em 19/08/2019 11:50 \n",
"0 25000.131173/2019-18 PAGO DICOG em 12/08/2019 14:06 \n",
"\n",
" SG_PARTIDO_POLITICO NO_APELIDO VL_IND_OBJETO \\\n",
"0 nan PROGRAMAÇÃO 300.00 \n",
"1 nan PROGRAMAÇÃO 500.00 \n",
"2 nan PROGRAMAÇÃO 160.00 \n",
"3 nan PROGRAMAÇÃO 650.00 \n",
"4 nan PROGRAMAÇÃO 500.00 \n",
"0 nan PROGRAMAÇÃO 300.00 \n",
"\n",
" DS_SITUACAO_PROPOSTA MES \n",
"0 Proposta em análise de Pagamento 8.00 \n",
"1 Proposta em análise de Pagamento 8.00 \n",
"2 Proposta em análise de Pagamento 8.00 \n",
"3 Proposta em análise de Pagamento 8.00 \n",
"4 Proposta em análise de Pagamento 8.00 \n",
"0 Proposta em análise de Pagamento 8.00 "
]
},
"metadata": {
"tags": []
},
"execution_count": 13
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "1Zb8dJozoqtt",
"colab_type": "text"
},
"source": [
"# **Análise**"
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "DPr2TSmDpDUc",
"colab_type": "text"
},
"source": [
"Em que meses o dinheiro foi transferido?"
]
},
{
"cell_type": "code",
"metadata": {
"id": "shzsnOgGos9V",
"colab_type": "code",
"outputId": "342bb2ac-648a-49df-d581-1627365ce609",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 88
}
},
"source": [
"df.groupby(['MES']).sum()['VL_PAGO']"
],
"execution_count": 14,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"MES\n",
"7.00 1849583007.00\n",
"8.00 259504613.00\n",
"Name: VL_PAGO, dtype: float64"
]
},
"metadata": {
"tags": []
},
"execution_count": 14
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "HKknKdYWpJ2-",
"colab_type": "text"
},
"source": [
"Quais foram os programas/ações utilizados?"
]
},
{
"cell_type": "code",
"metadata": {
"id": "d91eL6TRBUiM",
"colab_type": "code",
"outputId": "214d9baf-9c62-450a-dcb9-ab7e79f4fba9",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 88
}
},
"source": [
"df.groupby(['TIPO']).sum()['VL_PAGO']"
],
"execution_count": 15,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"TIPO\n",
"INCREMENTO MAC 900870043.00\n",
"INCREMENTO PAB 1208217577.00\n",
"Name: VL_PAGO, dtype: float64"
]
},
"metadata": {
"tags": []
},
"execution_count": 15
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "EwbbBov8pPJV",
"colab_type": "text"
},
"source": [
"Soma total dos pagamentos."
]
},
{
"cell_type": "code",
"metadata": {
"id": "qIjEpcfFpJ0b",
"colab_type": "code",
"outputId": "c0693981-fed6-471b-b386-1994a8dc3c8a",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 35
}
},
"source": [
"df['VL_PAGO'].sum()"
],
"execution_count": 16,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"2109087620.0"
]
},
"metadata": {
"tags": []
},
"execution_count": 16
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "x1Oq_Nd2pRj-",
"colab_type": "text"
},
"source": [
"Soma total das propostas."
]
},
{
"cell_type": "code",
"metadata": {
"id": "ZuUSF581pLmT",
"colab_type": "code",
"outputId": "c8aac3cb-f1f3-4838-d633-8773a7402fb6",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 35
}
},
"source": [
"df['VALOR_PROPOSTA'].sum()"
],
"execution_count": 17,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"2215684990.0"
]
},
"metadata": {
"tags": []
},
"execution_count": 17
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "KxLR6nHOo9SR",
"colab_type": "text"
},
"source": [
"UFs que mais receberam."
]
},
{
"cell_type": "code",
"metadata": {
"id": "xX21wHMrqs8C",
"colab_type": "code",
"outputId": "136ce054-f281-4f35-b668-6e7c732aa4df",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 904
}
},
"source": [
"df.groupby('UF').sum().sort_values(by=['VL_PAGO'],ascending = False)['VL_PAGO'].to_frame()"
],
"execution_count": 18,
"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>VL_PAGO</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UF</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>BA</th>\n",
" <td>228995738.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MA</th>\n",
" <td>226677089.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SP</th>\n",
" <td>209763137.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MG</th>\n",
" <td>168112843.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>AL</th>\n",
" <td>131422902.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RJ</th>\n",
" <td>126551790.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PE</th>\n",
" <td>120349792.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PB</th>\n",
" <td>113577959.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CE</th>\n",
" <td>94089318.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PR</th>\n",
" <td>83775666.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DF</th>\n",
" <td>82400000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PA</th>\n",
" <td>81166628.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RS</th>\n",
" <td>69298961.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PI</th>\n",
" <td>63420108.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>AM</th>\n",
" <td>48671416.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GO</th>\n",
" <td>43481365.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>AP</th>\n",
" <td>29800000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MT</th>\n",
" <td>29072725.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SE</th>\n",
" <td>28759567.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SC</th>\n",
" <td>26891866.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RN</th>\n",
" <td>24472388.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ES</th>\n",
" <td>23200000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RO</th>\n",
" <td>21129392.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RR</th>\n",
" <td>19918846.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>AC</th>\n",
" <td>11678124.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MS</th>\n",
" <td>2110000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TO</th>\n",
" <td>300000.00</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" VL_PAGO\n",
"UF \n",
"BA 228995738.00\n",
"MA 226677089.00\n",
"SP 209763137.00\n",
"MG 168112843.00\n",
"AL 131422902.00\n",
"RJ 126551790.00\n",
"PE 120349792.00\n",
"PB 113577959.00\n",
"CE 94089318.00\n",
"PR 83775666.00\n",
"DF 82400000.00\n",
"PA 81166628.00\n",
"RS 69298961.00\n",
"PI 63420108.00\n",
"AM 48671416.00\n",
"GO 43481365.00\n",
"AP 29800000.00\n",
"MT 29072725.00\n",
"SE 28759567.00\n",
"SC 26891866.00\n",
"RN 24472388.00\n",
"ES 23200000.00\n",
"RO 21129392.00\n",
"RR 19918846.00\n",
"AC 11678124.00\n",
"MS 2110000.00\n",
"TO 300000.00"
]
},
"metadata": {
"tags": []
},
"execution_count": 18
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "ywvSllAlo1fn",
"colab_type": "text"
},
"source": [
"Municípios que mais receberam no Brasil."
]
},
{
"cell_type": "code",
"metadata": {
"id": "aUHsSN_eCru1",
"colab_type": "code",
"outputId": "53908e1a-3ce3-472e-c086-17614b1f05ff",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 384
}
},
"source": [
"df.groupby(['MUNICIPIO','UF']).sum().sort_values(by=['VL_PAGO'],ascending = False)['VL_PAGO'].to_frame().head(10)"
],
"execution_count": 19,
"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></th>\n",
" <th>VL_PAGO</th>\n",
" </tr>\n",
" <tr>\n",
" <th>MUNICIPIO</th>\n",
" <th>UF</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>BRASILIA</th>\n",
" <th>DF</th>\n",
" <td>82400000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>IMPERATRIZ</th>\n",
" <th>MA</th>\n",
" <td>42859000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MACEIO</th>\n",
" <th>AL</th>\n",
" <td>39136599.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CAMPINA GRANDE</th>\n",
" <th>PB</th>\n",
" <td>37754145.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>JABOATAO DOS GUARARAPES</th>\n",
" <th>PE</th>\n",
" <td>35852578.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CAXIAS</th>\n",
" <th>MA</th>\n",
" <td>34358213.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DUQUE DE CAXIAS</th>\n",
" <th>RJ</th>\n",
" <td>30044000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MACAPA</th>\n",
" <th>AP</th>\n",
" <td>29000000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAO LUIS</th>\n",
" <th>MA</th>\n",
" <td>26300000.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NOVA IGUACU</th>\n",
" <th>RJ</th>\n",
" <td>25500000.00</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" VL_PAGO\n",
"MUNICIPIO UF \n",
"BRASILIA DF 82400000.00\n",
"IMPERATRIZ MA 42859000.00\n",
"MACEIO AL 39136599.00\n",
"CAMPINA GRANDE PB 37754145.00\n",
"JABOATAO DOS GUARARAPES PE 35852578.00\n",
"CAXIAS MA 34358213.00\n",
"DUQUE DE CAXIAS RJ 30044000.00\n",
"MACAPA AP 29000000.00\n",
"SAO LUIS MA 26300000.00\n",
"NOVA IGUACU RJ 25500000.00"
]
},
"metadata": {
"tags": []
},
"execution_count": 19
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "QyARsHmtou_n",
"colab_type": "text"
},
"source": [
"Municípios que mais receberam em São Paulo."
]
},
{
"cell_type": "code",
"metadata": {
"id": "cDS7YDNnUn3X",
"colab_type": "code",
"outputId": "5f689758-11d5-4fd1-c541-9ad9b8d264f0",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 1000
}
},
"source": [
"df[df['UF'] == 'SP'].groupby(['MUNICIPIO']).sum().sort_values(by=['VL_PAGO'],ascending = False)"
],
"execution_count": 20,
"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>ANO</th>\n",
" <th>NU_PORTARIA</th>\n",
" <th>VALOR_PROPOSTA</th>\n",
" <th>VL_EMPENHADO</th>\n",
" <th>VL_PAGO</th>\n",
" <th>LOCALIZACAO</th>\n",
" <th>SG_PARTIDO_POLITICO</th>\n",
" <th>MES</th>\n",
" </tr>\n",
" <tr>\n",
" <th>MUNICIPIO</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>SAO PAULO</th>\n",
" <td>48456</td>\n",
" <td>41030.00</td>\n",
" <td>21696153.00</td>\n",
" <td>21696153.00</td>\n",
" <td>21696153.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>168.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ITAQUAQUECETUBA</th>\n",
" <td>6057</td>\n",
" <td>5293.00</td>\n",
" <td>6430484.00</td>\n",
" <td>6430484.00</td>\n",
" <td>6430484.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>21.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LIMEIRA</th>\n",
" <td>8076</td>\n",
" <td>6805.00</td>\n",
" <td>5900000.00</td>\n",
" <td>5900000.00</td>\n",
" <td>5900000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>28.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CARAGUATATUBA</th>\n",
" <td>8076</td>\n",
" <td>6654.00</td>\n",
" <td>5750000.00</td>\n",
" <td>5750000.00</td>\n",
" <td>5750000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>28.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>EMBU DAS ARTES</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>5000000.00</td>\n",
" <td>5000000.00</td>\n",
" <td>5000000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GUARULHOS</th>\n",
" <td>12114</td>\n",
" <td>10665.00</td>\n",
" <td>5000000.00</td>\n",
" <td>5000000.00</td>\n",
" <td>5000000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>43.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUZANO</th>\n",
" <td>12114</td>\n",
" <td>10659.00</td>\n",
" <td>4800000.00</td>\n",
" <td>4800000.00</td>\n",
" <td>4800000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>43.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DIADEMA</th>\n",
" <td>4038</td>\n",
" <td>3488.00</td>\n",
" <td>4000000.00</td>\n",
" <td>4000000.00</td>\n",
" <td>4000000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>14.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>IBIUNA</th>\n",
" <td>4038</td>\n",
" <td>3474.00</td>\n",
" <td>4000000.00</td>\n",
" <td>4000000.00</td>\n",
" <td>4000000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>14.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MAUA</th>\n",
" <td>6057</td>\n",
" <td>5373.00</td>\n",
" <td>3602801.00</td>\n",
" <td>3602801.00</td>\n",
" <td>3602801.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>21.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INDAIATUBA</th>\n",
" <td>4038</td>\n",
" <td>3436.00</td>\n",
" <td>3000000.00</td>\n",
" <td>3000000.00</td>\n",
" <td>3000000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>14.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ARARAQUARA</th>\n",
" <td>8076</td>\n",
" <td>6876.00</td>\n",
" <td>3000000.00</td>\n",
" <td>3000000.00</td>\n",
" <td>3000000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>28.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PINDAMONHANGABA</th>\n",
" <td>8076</td>\n",
" <td>6757.00</td>\n",
" <td>2975000.00</td>\n",
" <td>2975000.00</td>\n",
" <td>2975000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>28.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MOGI DAS CRUZES</th>\n",
" <td>8076</td>\n",
" <td>6679.00</td>\n",
" <td>2850000.00</td>\n",
" <td>2850000.00</td>\n",
" <td>2850000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>28.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PIRACICABA</th>\n",
" <td>4038</td>\n",
" <td>3531.00</td>\n",
" <td>2800000.00</td>\n",
" <td>2800000.00</td>\n",
" <td>2800000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>14.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRANCISCO MORATO</th>\n",
" <td>4038</td>\n",
" <td>3499.00</td>\n",
" <td>2250000.00</td>\n",
" <td>2250000.00</td>\n",
" <td>2250000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>14.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CAMPINAS</th>\n",
" <td>8076</td>\n",
" <td>7041.00</td>\n",
" <td>2100000.00</td>\n",
" <td>2100000.00</td>\n",
" <td>2100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>28.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIBEIRAO PRETO</th>\n",
" <td>2019</td>\n",
" <td>1584.00</td>\n",
" <td>2000000.00</td>\n",
" <td>2000000.00</td>\n",
" <td>2000000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAO VICENTE</th>\n",
" <td>2019</td>\n",
" <td>2060.00</td>\n",
" <td>2000000.00</td>\n",
" <td>2000000.00</td>\n",
" <td>2000000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>8.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>OSASCO</th>\n",
" <td>4038</td>\n",
" <td>3489.00</td>\n",
" <td>2000000.00</td>\n",
" <td>2000000.00</td>\n",
" <td>2000000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>14.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TAUBATE</th>\n",
" <td>4038</td>\n",
" <td>3658.00</td>\n",
" <td>1800000.00</td>\n",
" <td>1800000.00</td>\n",
" <td>1800000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>15.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CUBATAO</th>\n",
" <td>6057</td>\n",
" <td>5180.00</td>\n",
" <td>1700000.00</td>\n",
" <td>1700000.00</td>\n",
" <td>1700000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>21.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UBATUBA</th>\n",
" <td>6057</td>\n",
" <td>5091.00</td>\n",
" <td>1650000.00</td>\n",
" <td>1650000.00</td>\n",
" <td>1650000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>21.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LENCOIS PAULISTA</th>\n",
" <td>8076</td>\n",
" <td>6582.00</td>\n",
" <td>1600000.00</td>\n",
" <td>1600000.00</td>\n",
" <td>1600000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>28.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ANDRADINA</th>\n",
" <td>8076</td>\n",
" <td>6765.00</td>\n",
" <td>1550000.00</td>\n",
" <td>1550000.00</td>\n",
" <td>1550000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>28.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ELIAS FAUSTO</th>\n",
" <td>4038</td>\n",
" <td>3290.00</td>\n",
" <td>1500000.00</td>\n",
" <td>1500000.00</td>\n",
" <td>1500000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>14.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>AMERICANA</th>\n",
" <td>8076</td>\n",
" <td>6680.00</td>\n",
" <td>1500000.00</td>\n",
" <td>1500000.00</td>\n",
" <td>1500000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>28.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAO JOSE DOS CAMPOS</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>1500000.00</td>\n",
" <td>1500000.00</td>\n",
" <td>1500000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PEDERNEIRAS</th>\n",
" <td>8076</td>\n",
" <td>6604.00</td>\n",
" <td>1350000.00</td>\n",
" <td>1350000.00</td>\n",
" <td>1350000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>28.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>JABOTICABAL</th>\n",
" <td>6057</td>\n",
" <td>5104.00</td>\n",
" <td>1350000.00</td>\n",
" <td>1350000.00</td>\n",
" <td>1350000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>21.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ITUVERAVA</th>\n",
" <td>4038</td>\n",
" <td>3805.00</td>\n",
" <td>1300000.00</td>\n",
" <td>1300000.00</td>\n",
" <td>1300000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>15.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SOROCABA</th>\n",
" <td>4038</td>\n",
" <td>3400.00</td>\n",
" <td>1300000.00</td>\n",
" <td>1300000.00</td>\n",
" <td>1300000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>14.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ARUJA</th>\n",
" <td>6057</td>\n",
" <td>5292.00</td>\n",
" <td>1269424.00</td>\n",
" <td>1269424.00</td>\n",
" <td>1269424.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>21.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MARILIA</th>\n",
" <td>8076</td>\n",
" <td>6614.00</td>\n",
" <td>1250000.00</td>\n",
" <td>1250000.00</td>\n",
" <td>1250000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>28.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ITAPETININGA</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>1250000.00</td>\n",
" <td>1250000.00</td>\n",
" <td>1250000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAO PEDRO</th>\n",
" <td>4038</td>\n",
" <td>3300.00</td>\n",
" <td>1200000.00</td>\n",
" <td>1200000.00</td>\n",
" <td>1200000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>14.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BIRIGUI</th>\n",
" <td>2019</td>\n",
" <td>1598.00</td>\n",
" <td>1200000.00</td>\n",
" <td>1200000.00</td>\n",
" <td>1200000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SALTO DE PIRAPORA</th>\n",
" <td>6057</td>\n",
" <td>5804.00</td>\n",
" <td>1200000.00</td>\n",
" <td>1200000.00</td>\n",
" <td>1200000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>23.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PORTO FERREIRA</th>\n",
" <td>4038</td>\n",
" <td>3644.00</td>\n",
" <td>1162250.00</td>\n",
" <td>1162250.00</td>\n",
" <td>1162250.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>15.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MONTE ALTO</th>\n",
" <td>4038</td>\n",
" <td>3182.00</td>\n",
" <td>1150000.00</td>\n",
" <td>1150000.00</td>\n",
" <td>1150000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>14.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>JUQUITIBA</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>1126899.00</td>\n",
" <td>1126899.00</td>\n",
" <td>1126899.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BATATAIS</th>\n",
" <td>4038</td>\n",
" <td>3267.00</td>\n",
" <td>1100000.00</td>\n",
" <td>1100000.00</td>\n",
" <td>1100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>14.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAO MIGUEL ARCANJO</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>1080127.00</td>\n",
" <td>1080127.00</td>\n",
" <td>1080127.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAO CARLOS</th>\n",
" <td>8076</td>\n",
" <td>6614.00</td>\n",
" <td>1050000.00</td>\n",
" <td>1050000.00</td>\n",
" <td>1050000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>28.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ITAPOLIS</th>\n",
" <td>6057</td>\n",
" <td>4756.00</td>\n",
" <td>1040000.00</td>\n",
" <td>1040000.00</td>\n",
" <td>1040000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>21.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CAMPINA DO MONTE ALEGRE</th>\n",
" <td>2019</td>\n",
" <td>2078.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>8.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GUARARAPES</th>\n",
" <td>2019</td>\n",
" <td>1716.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PIRACAIA</th>\n",
" <td>2019</td>\n",
" <td>1584.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PINDORAMA</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CAMPOS NOVOS PAULISTA</th>\n",
" <td>2019</td>\n",
" <td>2078.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>8.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>IRAPURU</th>\n",
" <td>2019</td>\n",
" <td>2078.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>8.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GUAREI</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PEDRA BELA</th>\n",
" <td>2019</td>\n",
" <td>1598.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NOVA ALIANCA</th>\n",
" <td>2019</td>\n",
" <td>1598.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ITANHAEM</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PARANAPUA</th>\n",
" <td>2019</td>\n",
" <td>1598.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PARANAPANEMA</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PANORAMA</th>\n",
" <td>2019</td>\n",
" <td>1598.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PALESTINA</th>\n",
" <td>2019</td>\n",
" <td>1598.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PACAEMBU</th>\n",
" <td>2019</td>\n",
" <td>1598.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CASSIA DOS COQUEIROS</th>\n",
" <td>2019</td>\n",
" <td>1588.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CASTILHO</th>\n",
" <td>2019</td>\n",
" <td>1598.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NOVO HORIZONTE</th>\n",
" <td>2019</td>\n",
" <td>1584.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NOVA INDEPENDENCIA</th>\n",
" <td>2019</td>\n",
" <td>1598.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>100000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PAULO DE FARIA</th>\n",
" <td>4038</td>\n",
" <td>3432.00</td>\n",
" <td>95453.00</td>\n",
" <td>95453.00</td>\n",
" <td>95453.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>14.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GAVIAO PEIXOTO</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>90000.00</td>\n",
" <td>90000.00</td>\n",
" <td>90000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BARAO DE ANTONINA</th>\n",
" <td>2019</td>\n",
" <td>1683.00</td>\n",
" <td>90000.00</td>\n",
" <td>90000.00</td>\n",
" <td>90000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>IACANGA</th>\n",
" <td>2019</td>\n",
" <td>1598.00</td>\n",
" <td>90000.00</td>\n",
" <td>90000.00</td>\n",
" <td>90000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ITAPIRA</th>\n",
" <td>2019</td>\n",
" <td>1598.00</td>\n",
" <td>90000.00</td>\n",
" <td>90000.00</td>\n",
" <td>90000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SANTA RITA D'OESTE</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>80000.00</td>\n",
" <td>80000.00</td>\n",
" <td>80000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TACIBA</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>80000.00</td>\n",
" <td>80000.00</td>\n",
" <td>80000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>QUINTANA</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VITORIA BRASIL</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GABRIEL MONTEIRO</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CORUMBATAI</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MENDONCA</th>\n",
" <td>2019</td>\n",
" <td>1598.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NANTES</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BOCAINA</th>\n",
" <td>2019</td>\n",
" <td>1683.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CANDIDO RODRIGUES</th>\n",
" <td>2019</td>\n",
" <td>1598.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PIRANGI</th>\n",
" <td>2019</td>\n",
" <td>1716.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ZACARIAS</th>\n",
" <td>2019</td>\n",
" <td>1717.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>50000.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MACEDONIA</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>48450.00</td>\n",
" <td>48450.00</td>\n",
" <td>48450.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VERA CRUZ</th>\n",
" <td>2019</td>\n",
" <td>1716.00</td>\n",
" <td>36262.00</td>\n",
" <td>36262.00</td>\n",
" <td>36262.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DOURADO</th>\n",
" <td>2019</td>\n",
" <td>1588.00</td>\n",
" <td>35674.00</td>\n",
" <td>35674.00</td>\n",
" <td>35674.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LUTECIA</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>30744.00</td>\n",
" <td>30744.00</td>\n",
" <td>30744.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FLOREAL</th>\n",
" <td>2019</td>\n",
" <td>1598.00</td>\n",
" <td>27994.00</td>\n",
" <td>27994.00</td>\n",
" <td>27994.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PAULISTANIA</th>\n",
" <td>2019</td>\n",
" <td>1684.00</td>\n",
" <td>20366.00</td>\n",
" <td>20366.00</td>\n",
" <td>20366.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>IPEUNA</th>\n",
" <td>2019</td>\n",
" <td>1598.00</td>\n",
" <td>13909.00</td>\n",
" <td>13909.00</td>\n",
" <td>13909.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GUARANTA</th>\n",
" <td>2019</td>\n",
" <td>1716.00</td>\n",
" <td>6843.00</td>\n",
" <td>6843.00</td>\n",
" <td>6843.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAO JOAO DA BOA VISTA</th>\n",
" <td>2019</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>326 rows × 8 columns</p>\n",
"</div>"
],
"text/plain": [
" ANO NU_PORTARIA VALOR_PROPOSTA VL_EMPENHADO \\\n",
"MUNICIPIO \n",
"SAO PAULO 48456 41030.00 21696153.00 21696153.00 \n",
"ITAQUAQUECETUBA 6057 5293.00 6430484.00 6430484.00 \n",
"LIMEIRA 8076 6805.00 5900000.00 5900000.00 \n",
"CARAGUATATUBA 8076 6654.00 5750000.00 5750000.00 \n",
"EMBU DAS ARTES 2019 1684.00 5000000.00 5000000.00 \n",
"GUARULHOS 12114 10665.00 5000000.00 5000000.00 \n",
"SUZANO 12114 10659.00 4800000.00 4800000.00 \n",
"DIADEMA 4038 3488.00 4000000.00 4000000.00 \n",
"IBIUNA 4038 3474.00 4000000.00 4000000.00 \n",
"MAUA 6057 5373.00 3602801.00 3602801.00 \n",
"INDAIATUBA 4038 3436.00 3000000.00 3000000.00 \n",
"ARARAQUARA 8076 6876.00 3000000.00 3000000.00 \n",
"PINDAMONHANGABA 8076 6757.00 2975000.00 2975000.00 \n",
"MOGI DAS CRUZES 8076 6679.00 2850000.00 2850000.00 \n",
"PIRACICABA 4038 3531.00 2800000.00 2800000.00 \n",
"FRANCISCO MORATO 4038 3499.00 2250000.00 2250000.00 \n",
"CAMPINAS 8076 7041.00 2100000.00 2100000.00 \n",
"RIBEIRAO PRETO 2019 1584.00 2000000.00 2000000.00 \n",
"SAO VICENTE 2019 2060.00 2000000.00 2000000.00 \n",
"OSASCO 4038 3489.00 2000000.00 2000000.00 \n",
"TAUBATE 4038 3658.00 1800000.00 1800000.00 \n",
"CUBATAO 6057 5180.00 1700000.00 1700000.00 \n",
"UBATUBA 6057 5091.00 1650000.00 1650000.00 \n",
"LENCOIS PAULISTA 8076 6582.00 1600000.00 1600000.00 \n",
"ANDRADINA 8076 6765.00 1550000.00 1550000.00 \n",
"ELIAS FAUSTO 4038 3290.00 1500000.00 1500000.00 \n",
"AMERICANA 8076 6680.00 1500000.00 1500000.00 \n",
"SAO JOSE DOS CAMPOS 2019 1684.00 1500000.00 1500000.00 \n",
"PEDERNEIRAS 8076 6604.00 1350000.00 1350000.00 \n",
"JABOTICABAL 6057 5104.00 1350000.00 1350000.00 \n",
"ITUVERAVA 4038 3805.00 1300000.00 1300000.00 \n",
"SOROCABA 4038 3400.00 1300000.00 1300000.00 \n",
"ARUJA 6057 5292.00 1269424.00 1269424.00 \n",
"MARILIA 8076 6614.00 1250000.00 1250000.00 \n",
"ITAPETININGA 2019 1684.00 1250000.00 1250000.00 \n",
"SAO PEDRO 4038 3300.00 1200000.00 1200000.00 \n",
"BIRIGUI 2019 1598.00 1200000.00 1200000.00 \n",
"SALTO DE PIRAPORA 6057 5804.00 1200000.00 1200000.00 \n",
"PORTO FERREIRA 4038 3644.00 1162250.00 1162250.00 \n",
"MONTE ALTO 4038 3182.00 1150000.00 1150000.00 \n",
"JUQUITIBA 2019 1684.00 1126899.00 1126899.00 \n",
"BATATAIS 4038 3267.00 1100000.00 1100000.00 \n",
"SAO MIGUEL ARCANJO 2019 1684.00 1080127.00 1080127.00 \n",
"SAO CARLOS 8076 6614.00 1050000.00 1050000.00 \n",
"ITAPOLIS 6057 4756.00 1040000.00 1040000.00 \n",
"... ... ... ... ... \n",
"CAMPINA DO MONTE ALEGRE 2019 2078.00 100000.00 100000.00 \n",
"GUARARAPES 2019 1716.00 100000.00 100000.00 \n",
"PIRACAIA 2019 1584.00 100000.00 100000.00 \n",
"PINDORAMA 2019 1684.00 100000.00 100000.00 \n",
"CAMPOS NOVOS PAULISTA 2019 2078.00 100000.00 100000.00 \n",
"IRAPURU 2019 2078.00 100000.00 100000.00 \n",
"GUAREI 2019 1684.00 100000.00 100000.00 \n",
"PEDRA BELA 2019 1598.00 100000.00 100000.00 \n",
"NOVA ALIANCA 2019 1598.00 100000.00 100000.00 \n",
"ITANHAEM 2019 1684.00 100000.00 100000.00 \n",
"PARANAPUA 2019 1598.00 100000.00 100000.00 \n",
"PARANAPANEMA 2019 1684.00 100000.00 100000.00 \n",
"PANORAMA 2019 1598.00 100000.00 100000.00 \n",
"PALESTINA 2019 1598.00 100000.00 100000.00 \n",
"PACAEMBU 2019 1598.00 100000.00 100000.00 \n",
"CASSIA DOS COQUEIROS 2019 1588.00 100000.00 100000.00 \n",
"CASTILHO 2019 1598.00 100000.00 100000.00 \n",
"NOVO HORIZONTE 2019 1584.00 100000.00 100000.00 \n",
"NOVA INDEPENDENCIA 2019 1598.00 100000.00 100000.00 \n",
"PAULO DE FARIA 4038 3432.00 95453.00 95453.00 \n",
"GAVIAO PEIXOTO 2019 1684.00 90000.00 90000.00 \n",
"BARAO DE ANTONINA 2019 1683.00 90000.00 90000.00 \n",
"IACANGA 2019 1598.00 90000.00 90000.00 \n",
"ITAPIRA 2019 1598.00 90000.00 90000.00 \n",
"SANTA RITA D'OESTE 2019 1684.00 80000.00 80000.00 \n",
"TACIBA 2019 1684.00 80000.00 80000.00 \n",
"QUINTANA 2019 1684.00 50000.00 50000.00 \n",
"VITORIA BRASIL 2019 1684.00 50000.00 50000.00 \n",
"GABRIEL MONTEIRO 2019 1684.00 50000.00 50000.00 \n",
"CORUMBATAI 2019 1684.00 50000.00 50000.00 \n",
"MENDONCA 2019 1598.00 50000.00 50000.00 \n",
"NANTES 2019 1684.00 50000.00 50000.00 \n",
"BOCAINA 2019 1683.00 50000.00 50000.00 \n",
"CANDIDO RODRIGUES 2019 1598.00 50000.00 50000.00 \n",
"PIRANGI 2019 1716.00 50000.00 50000.00 \n",
"ZACARIAS 2019 1717.00 50000.00 50000.00 \n",
"MACEDONIA 2019 1684.00 48450.00 48450.00 \n",
"VERA CRUZ 2019 1716.00 36262.00 36262.00 \n",
"DOURADO 2019 1588.00 35674.00 35674.00 \n",
"LUTECIA 2019 1684.00 30744.00 30744.00 \n",
"FLOREAL 2019 1598.00 27994.00 27994.00 \n",
"PAULISTANIA 2019 1684.00 20366.00 20366.00 \n",
"IPEUNA 2019 1598.00 13909.00 13909.00 \n",
"GUARANTA 2019 1716.00 6843.00 6843.00 \n",
"SAO JOAO DA BOA VISTA 2019 0.00 0.00 0.00 \n",
"\n",
" VL_PAGO LOCALIZACAO SG_PARTIDO_POLITICO MES \n",
"MUNICIPIO \n",
"SAO PAULO 21696153.00 0.00 0.00 168.00 \n",
"ITAQUAQUECETUBA 6430484.00 0.00 0.00 21.00 \n",
"LIMEIRA 5900000.00 0.00 0.00 28.00 \n",
"CARAGUATATUBA 5750000.00 0.00 0.00 28.00 \n",
"EMBU DAS ARTES 5000000.00 0.00 0.00 7.00 \n",
"GUARULHOS 5000000.00 0.00 0.00 43.00 \n",
"SUZANO 4800000.00 0.00 0.00 43.00 \n",
"DIADEMA 4000000.00 0.00 0.00 14.00 \n",
"IBIUNA 4000000.00 0.00 0.00 14.00 \n",
"MAUA 3602801.00 0.00 0.00 21.00 \n",
"INDAIATUBA 3000000.00 0.00 0.00 14.00 \n",
"ARARAQUARA 3000000.00 0.00 0.00 28.00 \n",
"PINDAMONHANGABA 2975000.00 0.00 0.00 28.00 \n",
"MOGI DAS CRUZES 2850000.00 0.00 0.00 28.00 \n",
"PIRACICABA 2800000.00 0.00 0.00 14.00 \n",
"FRANCISCO MORATO 2250000.00 0.00 0.00 14.00 \n",
"CAMPINAS 2100000.00 0.00 0.00 28.00 \n",
"RIBEIRAO PRETO 2000000.00 0.00 0.00 7.00 \n",
"SAO VICENTE 2000000.00 0.00 0.00 8.00 \n",
"OSASCO 2000000.00 0.00 0.00 14.00 \n",
"TAUBATE 1800000.00 0.00 0.00 15.00 \n",
"CUBATAO 1700000.00 0.00 0.00 21.00 \n",
"UBATUBA 1650000.00 0.00 0.00 21.00 \n",
"LENCOIS PAULISTA 1600000.00 0.00 0.00 28.00 \n",
"ANDRADINA 1550000.00 0.00 0.00 28.00 \n",
"ELIAS FAUSTO 1500000.00 0.00 0.00 14.00 \n",
"AMERICANA 1500000.00 0.00 0.00 28.00 \n",
"SAO JOSE DOS CAMPOS 1500000.00 0.00 0.00 7.00 \n",
"PEDERNEIRAS 1350000.00 0.00 0.00 28.00 \n",
"JABOTICABAL 1350000.00 0.00 0.00 21.00 \n",
"ITUVERAVA 1300000.00 0.00 0.00 15.00 \n",
"SOROCABA 1300000.00 0.00 0.00 14.00 \n",
"ARUJA 1269424.00 0.00 0.00 21.00 \n",
"MARILIA 1250000.00 0.00 0.00 28.00 \n",
"ITAPETININGA 1250000.00 0.00 0.00 7.00 \n",
"SAO PEDRO 1200000.00 0.00 0.00 14.00 \n",
"BIRIGUI 1200000.00 0.00 0.00 7.00 \n",
"SALTO DE PIRAPORA 1200000.00 0.00 0.00 23.00 \n",
"PORTO FERREIRA 1162250.00 0.00 0.00 15.00 \n",
"MONTE ALTO 1150000.00 0.00 0.00 14.00 \n",
"JUQUITIBA 1126899.00 0.00 0.00 7.00 \n",
"BATATAIS 1100000.00 0.00 0.00 14.00 \n",
"SAO MIGUEL ARCANJO 1080127.00 0.00 0.00 7.00 \n",
"SAO CARLOS 1050000.00 0.00 0.00 28.00 \n",
"ITAPOLIS 1040000.00 0.00 0.00 21.00 \n",
"... ... ... ... ... \n",
"CAMPINA DO MONTE ALEGRE 100000.00 0.00 0.00 8.00 \n",
"GUARARAPES 100000.00 0.00 0.00 7.00 \n",
"PIRACAIA 100000.00 0.00 0.00 7.00 \n",
"PINDORAMA 100000.00 0.00 0.00 7.00 \n",
"CAMPOS NOVOS PAULISTA 100000.00 0.00 0.00 8.00 \n",
"IRAPURU 100000.00 0.00 0.00 8.00 \n",
"GUAREI 100000.00 0.00 0.00 7.00 \n",
"PEDRA BELA 100000.00 0.00 0.00 7.00 \n",
"NOVA ALIANCA 100000.00 0.00 0.00 7.00 \n",
"ITANHAEM 100000.00 0.00 0.00 7.00 \n",
"PARANAPUA 100000.00 0.00 0.00 7.00 \n",
"PARANAPANEMA 100000.00 0.00 0.00 7.00 \n",
"PANORAMA 100000.00 0.00 0.00 7.00 \n",
"PALESTINA 100000.00 0.00 0.00 7.00 \n",
"PACAEMBU 100000.00 0.00 0.00 7.00 \n",
"CASSIA DOS COQUEIROS 100000.00 0.00 0.00 7.00 \n",
"CASTILHO 100000.00 0.00 0.00 7.00 \n",
"NOVO HORIZONTE 100000.00 0.00 0.00 7.00 \n",
"NOVA INDEPENDENCIA 100000.00 0.00 0.00 7.00 \n",
"PAULO DE FARIA 95453.00 0.00 0.00 14.00 \n",
"GAVIAO PEIXOTO 90000.00 0.00 0.00 7.00 \n",
"BARAO DE ANTONINA 90000.00 0.00 0.00 7.00 \n",
"IACANGA 90000.00 0.00 0.00 7.00 \n",
"ITAPIRA 90000.00 0.00 0.00 7.00 \n",
"SANTA RITA D'OESTE 80000.00 0.00 0.00 7.00 \n",
"TACIBA 80000.00 0.00 0.00 7.00 \n",
"QUINTANA 50000.00 0.00 0.00 7.00 \n",
"VITORIA BRASIL 50000.00 0.00 0.00 7.00 \n",
"GABRIEL MONTEIRO 50000.00 0.00 0.00 7.00 \n",
"CORUMBATAI 50000.00 0.00 0.00 7.00 \n",
"MENDONCA 50000.00 0.00 0.00 7.00 \n",
"NANTES 50000.00 0.00 0.00 7.00 \n",
"BOCAINA 50000.00 0.00 0.00 7.00 \n",
"CANDIDO RODRIGUES 50000.00 0.00 0.00 7.00 \n",
"PIRANGI 50000.00 0.00 0.00 7.00 \n",
"ZACARIAS 50000.00 0.00 0.00 7.00 \n",
"MACEDONIA 48450.00 0.00 0.00 7.00 \n",
"VERA CRUZ 36262.00 0.00 0.00 7.00 \n",
"DOURADO 35674.00 0.00 0.00 7.00 \n",
"LUTECIA 30744.00 0.00 0.00 7.00 \n",
"FLOREAL 27994.00 0.00 0.00 7.00 \n",
"PAULISTANIA 20366.00 0.00 0.00 7.00 \n",
"IPEUNA 13909.00 0.00 0.00 7.00 \n",
"GUARANTA 6843.00 0.00 0.00 7.00 \n",
"SAO JOAO DA BOA VISTA 0.00 0.00 0.00 0.00 \n",
"\n",
"[326 rows x 8 columns]"
]
},
"metadata": {
"tags": []
},
"execution_count": 20
}
]
},
{
"cell_type": "code",
"metadata": {
"id": "osBMtJlLEcPn",
"colab_type": "code",
"outputId": "504daa4d-46a6-4c65-941a-98034c73ac6b",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 373
}
},
"source": [
"df.sum()"
],
"execution_count": 21,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"NU_PROPOSTA 36000.2679752/01-90036000.2721932/01-90036000....\n",
"UF APAPAPMAMAMAMAMAMAMAMAMAMAMAMAMAMAMAMAMAMAMAMA...\n",
"MUNICIPIO SANTANAMACAPAPEDRA BRANCA DO AMAPARISAO BERNAR...\n",
"ENTIDADE FUNDO MUNICIPAL DE SAUDE DE SANTANAFUNDO MUNIC...\n",
"NU_CNPJ_ENTIDADE 11.193.442/0001-1818.604.334/0001-3011.831.471...\n",
"NU_PROCESSO 00000.000000/0000-0000000.000000/0000-0000000....\n",
"ANO 6705099\n",
"NU_PORTARIA 5752310.00\n",
"TIPO INCREMENTO PABINCREMENTO PABINCREMENTO PABINCR...\n",
"VALOR_PROPOSTA 2215684990.00\n",
"VL_EMPENHADO 2125634407.00\n",
"VL_PAGO 2109087620.00\n",
"LOCALIZACAO 0.00\n",
"TIPO_RECURSO PROPOSTA FAFPROPOSTA FAFPROPOSTA FAFPROPOSTA F...\n",
"CO_SITUACAO_INTERNA PAGOPAGOPAGOAPROVADOAPROVADOAPROVADOAPROVADOAP...\n",
"LOCALIZACAO_PGTO DICOG em 23/07/2019 15:49DICOG em 12/08/2019 1...\n",
"SG_PARTIDO_POLITICO 0.00\n",
"DS_SITUACAO_PROPOSTA Proposta em análise de PagamentoProposta em an...\n",
"MES 23497.00\n",
"dtype: object"
]
},
"metadata": {
"tags": []
},
"execution_count": 21
}
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment