{ "metadata": { "name": "", "signature": "sha256:271a0d5d1858d736851b1778d5ed653c67a270b8c246a3d23ca6d75b7c808d52" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "code", "collapsed": false, "input": [ "import pandas as pd" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 165 }, { "cell_type": "markdown", "metadata": {}, "source": [ "A primeira coisa \u00e9 ter os arquivos CSV's j\u00e1 baixados. No caso do Portal da Transpar\u00eancia existe um pequeno problema que os arquivos est\u00e3o utilizando o encoding iso8859-1. Antes de mais nada vamos converter tais arquivos para UTF8." ] }, { "cell_type": "code", "collapsed": false, "input": [ "ls -l *csv" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "-rw-rw-r-- 1 walrus walrus 34218300 Jul 16 10:42 201401_Transferencias.csv\r\n", "-rw-rw-r-- 1 walrus walrus 43579484 Jul 16 10:42 201402_Transferencias.csv\r\n", "-rw-rw-r-- 1 walrus walrus 46026696 Jul 16 10:42 201403_Transferencias.csv\r\n", "-rw-rw-r-- 1 walrus walrus 102053489 Jul 16 10:44 201404_Transferencias.csv\r\n", "-rw-rw-r-- 1 walrus walrus 89307861 Jul 16 10:45 201405_Transferencias.csv\r\n" ] } ], "prompt_number": 203 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Para isso podemos utilizar o programa iconv:" ] }, { "cell_type": "code", "collapsed": false, "input": [ "!iconv -f iso8859-1 -t utf8 201401_Transferencias.csv > 201401_Transferencias.utf.csv" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 206 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Podemos agora carregar diretamente esse csv com o Pandas:" ] }, { "cell_type": "code", "collapsed": false, "input": [ "dados = pd.read_csv('201401_Transferencias.utf.csv', delimiter='\\t+', decimal='.', thousands=',')\n", "dados[0:4]" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Sigla Unidade Federa\u00e7\u00e3oCodigo SIAFI MunicipioNome MunicipioCodigo FuncaoNome FuncaoCodigo Sub Funcao Nome Sub FuncaoCodigo ProgramaNome ProgramaCodigo AcaoNome AcaoLinguagem Cidad\u00e3Codigo FavorecidoNome FavorecidoFonte-FinalidadeModalidade Aplica\u00e7\u00e3oN\u00famero Conv\u00eanioValor Parcela
0 MG 4123 BELO HORIZONTE 19 Ci\u00eancia e Tecnologia 572 Desenvolvimento Tecnol\u00f3gico e Engenharia 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o 2095 Fomento a Projetos de Implanta\u00e7\u00e3o e Recupera\u00e7\u00e3... CT-INFRA 18720938000141 FUNDACAO DE DESENVOLVIMENTO DA PESQUISA STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... 673120 444340.00
1 GO 1066 VALPARAISO DE GOIAS 11 Trabalho 334 Fomento ao Trabalho 1025 Promo\u00e7\u00e3o da Sustentabilidade de Espa\u00e7os Sub-Re... 6591 Apoio \u00e0 Gera\u00e7\u00e3o de Empreendimentos Produtivos ... \u0000 01616319000109 MUNICIPIO DE VALPARAISO DE GOIAS [PREFEITURA M... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios 735620 100000.00
2 MG 5221 SAO FRANCISCO 15 Urbanismo 452 Servi\u00e7os Urbanos 0660 Seguran\u00e7a e Educa\u00e7\u00e3o de Tr\u00e2nsito: Direito e Re... 8487 Fomento a Projetos Destinados \u00e0 Preven\u00e7\u00e3o e Re... \u0000 22679153000140 MUNICIPIO DE SAO FRANCISCO [SAO FRANCISCO PREF... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios 725369 66397.51
3 CE 1381 COREAU 15 Urbanismo 452 Servi\u00e7os Urbanos 0660 Seguran\u00e7a e Educa\u00e7\u00e3o de Tr\u00e2nsito: Direito e Re... 8487 Fomento a Projetos Destinados \u00e0 Preven\u00e7\u00e3o e Re... \u0000 07598618000144 MUNICIPIO DE COREAU [COREAU GABINETE DO PREFEITO] STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios 743035 246500.00
\n", "
" ], "metadata": {}, "output_type": "pyout", "prompt_number": 210, "text": [ " Sigla Unidade Federa\u00e7\u00e3o Codigo SIAFI Municipio Nome Municipio \\\n", "0 MG 4123 BELO HORIZONTE \n", "1 GO 1066 VALPARAISO DE GOIAS \n", "2 MG 5221 SAO FRANCISCO \n", "3 CE 1381 COREAU \n", "\n", " Codigo Funcao Nome Funcao Codigo Sub Funcao \\\n", "0 19 Ci\u00eancia e Tecnologia 572 \n", "1 11 Trabalho 334 \n", "2 15 Urbanismo 452 \n", "3 15 Urbanismo 452 \n", "\n", " Nome Sub Funcao Codigo Programa \\\n", "0 Desenvolvimento Tecnol\u00f3gico e Engenharia 2021 \n", "1 Fomento ao Trabalho 1025 \n", "2 Servi\u00e7os Urbanos 0660 \n", "3 Servi\u00e7os Urbanos 0660 \n", "\n", " Nome Programa Codigo Acao \\\n", "0 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o 2095 \n", "1 Promo\u00e7\u00e3o da Sustentabilidade de Espa\u00e7os Sub-Re... 6591 \n", "2 Seguran\u00e7a e Educa\u00e7\u00e3o de Tr\u00e2nsito: Direito e Re... 8487 \n", "3 Seguran\u00e7a e Educa\u00e7\u00e3o de Tr\u00e2nsito: Direito e Re... 8487 \n", "\n", " Nome Acao Linguagem Cidad\u00e3 \\\n", "0 Fomento a Projetos de Implanta\u00e7\u00e3o e Recupera\u00e7\u00e3... CT-INFRA \n", "1 Apoio \u00e0 Gera\u00e7\u00e3o de Empreendimentos Produtivos ... \u0000 \n", "2 Fomento a Projetos Destinados \u00e0 Preven\u00e7\u00e3o e Re... \u0000 \n", "3 Fomento a Projetos Destinados \u00e0 Preven\u00e7\u00e3o e Re... \u0000 \n", "\n", " Codigo Favorecido Nome Favorecido \\\n", "0 18720938000141 FUNDACAO DE DESENVOLVIMENTO DA PESQUISA \n", "1 01616319000109 MUNICIPIO DE VALPARAISO DE GOIAS [PREFEITURA M... \n", "2 22679153000140 MUNICIPIO DE SAO FRANCISCO [SAO FRANCISCO PREF... \n", "3 07598618000144 MUNICIPIO DE COREAU [COREAU GABINETE DO PREFEITO] \n", "\n", " Fonte-Finalidade \\\n", "0 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "1 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "2 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "3 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "\n", " Modalidade Aplica\u00e7\u00e3o N\u00famero Conv\u00eanio \\\n", "0 Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... 673120 \n", "1 Transfer\u00eancias a Munic\u00edpios 735620 \n", "2 Transfer\u00eancias a Munic\u00edpios 725369 \n", "3 Transfer\u00eancias a Munic\u00edpios 743035 \n", "\n", " Valor Parcela \n", "0 444340.00 \n", "1 100000.00 \n", "2 66397.51 \n", "3 246500.00 " ] } ], "prompt_number": 210 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Como pode-se notar acima, o arquivo foi devidamente importado com os acentos j\u00e1 em utf8. Vamos agora converter todos os outros arquivos com o comando iconv, mas para isso utilizaremos a possibilidade de mixar c\u00f3digo em Python com c\u00f3digo em shell script do IPython. Primeiro criamos um diret\u00f3rio, movemos o arquivo utf8 criado (201401_Transferencias.utf.csv), apagaremos o formato antigo 201401_Transferencias.csv e converteremos o resto:" ] }, { "cell_type": "code", "collapsed": false, "input": [ "!mkdir utf\n", "!mv 201401_Transferencias.utf.csv utf\n", "!rm 201401_Transferencias.csv" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 211 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Capturamos a lista de arquivos csv que falta serem convertidos e aplicamos a convers\u00e3o neles:" ] }, { "cell_type": "code", "collapsed": false, "input": [ "to_convert = !ls *csv\n", "for f in to_convert:\n", " utf_file = f.replace('csv', 'utf.csv')\n", " print \"Convertendo {}\".format(f)\n", " !iconv -f iso8859-1 -t utf8 $f > utf/$utf_file" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "Convertendo 201402_Transferencias.csv\n" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "Convertendo 201403_Transferencias.csv\n" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "Convertendo 201404_Transferencias.csv\n" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "Convertendo 201405_Transferencias.csv\n" ] } ], "prompt_number": 239 }, { "cell_type": "code", "collapsed": false, "input": [ "ls -l utf" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "total 320632\r\n", "-rw-rw-r-- 1 walrus walrus 35599266 Sep 17 17:05 201401_Transferencias.utf.csv\r\n", "-rw-rw-r-- 1 walrus walrus 45250632 Sep 17 17:20 201402_Transferencias.utf.csv\r\n", "-rw-rw-r-- 1 walrus walrus 47913588 Sep 17 17:20 201403_Transferencias.utf.csv\r\n", "-rw-rw-r-- 1 walrus walrus 106505705 Sep 17 17:20 201404_Transferencias.utf.csv\r\n", "-rw-rw-r-- 1 walrus walrus 93045122 Sep 17 17:20 201405_Transferencias.utf.csv\r\n" ] } ], "prompt_number": 241 }, { "cell_type": "code", "collapsed": false, "input": [ "!rm *csv" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 242 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Agora podemos carregar individualmente cada um desses csv com o Pandas:" ] }, { "cell_type": "code", "collapsed": false, "input": [ "dados = pd.read_csv('utf/201401_Transferencias.utf.csv', delimiter='\\t+', decimal='.', thousands=',')" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 243 }, { "cell_type": "heading", "level": 2, "metadata": {}, "source": [ "Contando total transferido pra Belo Horizonte" ] }, { "cell_type": "code", "collapsed": false, "input": [ "dados[dados['Nome Municipio'] == 'BELO HORIZONTE']['Valor Parcela'].sum()" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 244, "text": [ "244240718.58999994" ] } ], "prompt_number": 244 }, { "cell_type": "heading", "level": 2, "metadata": {}, "source": [ "Criando um novo CSV apenas com os dados de Belo Horizonte" ] }, { "cell_type": "code", "collapsed": false, "input": [ "dados[dados['Nome Municipio'] == 'BELO HORIZONTE'].to_csv('BeloHorizonte-201401_Transferencias.utf.csv')" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 245 }, { "cell_type": "code", "collapsed": false, "input": [ "!ls -l Belo*\n", "!wc -l BeloHorizonte-201401_Transferencias.utf.csv" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "-rw-rw-r-- 1 walrus walrus 47199 Sep 17 17:24 BeloHorizonte-201401_Transferencias.utf.csv\r\n" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "112 BeloHorizonte-201401_Transferencias.utf.csv\r\n" ] } ], "prompt_number": 249 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Verificando o cabe\u00e7alho do novo csv gerado:" ] }, { "cell_type": "code", "collapsed": false, "input": [ "!head -3 BeloHorizonte-201401_Transferencias.utf.csv" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ ",Sigla Unidade Federa\u00e7\u00e3o,Codigo SIAFI Municipio,Nome Municipio,Codigo Funcao,Nome Funcao,Codigo Sub Funcao ,Nome Sub Funcao,Codigo Programa,Nome Programa,Codigo Acao,Nome Acao,Linguagem Cidad\u00e3,Codigo Favorecido,Nome Favorecido,Fonte-Finalidade,Modalidade Aplica\u00e7\u00e3o,N\u00famero Conv\u00eanio,Valor Parcela\r\n", "0,MG,4123,BELO HORIZONTE,19,Ci\u00eancia e Tecnologia,572,Desenvolvimento Tecnol\u00f3gico e Engenharia,2021,\"Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o\",2095,Fomento a Projetos de Implanta\u00e7\u00e3o e Recupera\u00e7\u00e3o da Infraestrutura de Pesquisa das Institui\u00e7\u00f5es P\u00fablicas (CT-Infra),CT-INFRA,18720938000141,FUNDACAO DE DESENVOLVIMENTO DA PESQUISA,STN - Conv\u00eanios/Contratos de Repasses/Fundo a Fundo/Outros,Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins Lucrativos,673120,444340.0\r\n", "1448,MG,4123,BELO HORIZONTE,28,Encargos Especiais,845,Transfer\u00eancias,0903,Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constitucionais e as Decorrentes de Legisla\u00e7\u00e3o Espec\u00edfica,0547,\"Transfer\u00eancias de Cotas-Partes da Compensa\u00e7\u00e3o Financeira pela Explora\u00e7\u00e3o de Recursos Minerais (Lei n\u00ba 8.001, de 1990 - Art.2\u00ba)\",CFEM,18715383000140,MUNICIPIO DE BELO HORIZONTE [BELO HORIZONTE GABINETE DO PREFEITO],STN - Transfer\u00eancias a Munic\u00edpios,,,26593.72\r\n" ] } ], "prompt_number": 251 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Funcionou perfeitamente, apenas ocorreu a inclus\u00e3o de uma coluna adicional pelo Pandas com a numera\u00e7\u00e3o da linha. Caso n\u00e3o queira isso basta utilizar o m\u00e9todo to_csv com o argumento index=False:" ] }, { "cell_type": "code", "collapsed": false, "input": [ "dados[dados['Nome Municipio'] == 'BELO HORIZONTE'].to_csv('BeloHorizonte-201401_Transferencias.utf.csv', index=False)\n", "!head -3 BeloHorizonte-201401_Transferencias.utf.csv" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "Sigla Unidade Federa\u00e7\u00e3o,Codigo SIAFI Municipio,Nome Municipio,Codigo Funcao,Nome Funcao,Codigo Sub Funcao ,Nome Sub Funcao,Codigo Programa,Nome Programa,Codigo Acao,Nome Acao,Linguagem Cidad\u00e3,Codigo Favorecido,Nome Favorecido,Fonte-Finalidade,Modalidade Aplica\u00e7\u00e3o,N\u00famero Conv\u00eanio,Valor Parcela\r\n", "MG,4123,BELO HORIZONTE,19,Ci\u00eancia e Tecnologia,572,Desenvolvimento Tecnol\u00f3gico e Engenharia,2021,\"Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o\",2095,Fomento a Projetos de Implanta\u00e7\u00e3o e Recupera\u00e7\u00e3o da Infraestrutura de Pesquisa das Institui\u00e7\u00f5es P\u00fablicas (CT-Infra),CT-INFRA,18720938000141,FUNDACAO DE DESENVOLVIMENTO DA PESQUISA,STN - Conv\u00eanios/Contratos de Repasses/Fundo a Fundo/Outros,Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins Lucrativos,673120,444340.0\r\n", "MG,4123,BELO HORIZONTE,28,Encargos Especiais,845,Transfer\u00eancias,0903,Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constitucionais e as Decorrentes de Legisla\u00e7\u00e3o Espec\u00edfica,0547,\"Transfer\u00eancias de Cotas-Partes da Compensa\u00e7\u00e3o Financeira pela Explora\u00e7\u00e3o de Recursos Minerais (Lei n\u00ba 8.001, de 1990 - Art.2\u00ba)\",CFEM,18715383000140,MUNICIPIO DE BELO HORIZONTE [BELO HORIZONTE GABINETE DO PREFEITO],STN - Transfer\u00eancias a Munic\u00edpios,,,26593.72\r\n" ] } ], "prompt_number": 253 }, { "cell_type": "heading", "level": 2, "metadata": {}, "source": [ "Contanto transfer\u00eancias por sub fun\u00e7\u00e3o em Belo Horizonte" ] }, { "cell_type": "code", "collapsed": false, "input": [ "dados[dados['Nome Municipio'] == 'BELO HORIZONTE']['Nome Sub Funcao'].value_counts()" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 252, "text": [ "Assist\u00eancia Hospitalar e Ambulatorial 82\n", "Transfer\u00eancias 8\n", "Ensino Superior 6\n", "Educa\u00e7\u00e3o Infantil 5\n", "Aten\u00e7\u00e3o B\u00e1sica 5\n", "Saneamento B\u00e1sico Urbano 2\n", "Vigil\u00e2ncia Epidemiol\u00f3gica 1\n", "Suporte Profil\u00e1tico e Terap\u00eautico 1\n", "Desenvolvimento Tecnol\u00f3gico e Engenharia 1\n", "dtype: int64" ] } ], "prompt_number": 252 }, { "cell_type": "heading", "level": 2, "metadata": {}, "source": [ "Exibindo dados apenas de S\u00e3o Paulo" ] }, { "cell_type": "code", "collapsed": false, "input": [ "dados[dados['Sigla Unidade Federa\u00e7\u00e3o'] == 'SP']" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Sigla Unidade Federa\u00e7\u00e3oCodigo SIAFI MunicipioNome MunicipioCodigo FuncaoNome FuncaoCodigo Sub Funcao Nome Sub FuncaoCodigo ProgramaNome ProgramaCodigo AcaoNome AcaoLinguagem Cidad\u00e3Codigo FavorecidoNome FavorecidoFonte-FinalidadeModalidade Aplica\u00e7\u00e3oN\u00famero Conv\u00eanioValor Parcela
13 SP 7107 SAO PAULO 12 Educa\u00e7\u00e3o 364 Ensino Superior 2032 Educa\u00e7\u00e3o Superior - Gradua\u00e7\u00e3o, P\u00f3s-Gradua\u00e7\u00e3o, ... 0487 Concess\u00e3o de Bolsas de Estudos Bolsas de Estudos no Pa\u00eds 86982311000119 ASSOCIACAO NACIONAL DE POS-GRADUACAO E PESQUIS... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... 8.500000e+02
16 SP 7107 SAO PAULO 11 Trabalho 333 Empregabilidade 2071 Trabalho, Emprego e Renda 20ST Estudos e Pesquisas para Apoio e Gest\u00e3o do Sis... \u0000 60964996000187 DEPARTAMENTO INTERSINDICAL DE EST ESTS SOCIO E... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... 755158 4.604908e+05
66 SP 2999 CAMPINA DO MONTE ALEGRE 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 0547 Transfer\u00eancias de Cotas-Partes da Compensa\u00e7\u00e3o ... CFEM 67360404000167 MUNICIPIO DE CAMPINA DO MONTE ALEGRE [CAMPINA ... STN - Transfer\u00eancias a Munic\u00edpios \u0000 \u0000 7.615700e+02
138 SP 7097 SAO JOSE DO RIO PRETO 28 Encargos Especiais 846 Outros Encargos Especiais 0909 Opera\u00e7\u00f5es Especiais: Outros Encargos Especiais 0413 Manuten\u00e7\u00e3o e Opera\u00e7\u00e3o dos Partidos Pol\u00edticos \u0000 32095101000180 PARTIDO REPUBLICANO PROGRESSISTA-PRP STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... 1.150952e+05
147 SP 6689 MAUA 11 Trabalho 333 Empregabilidade 2071 Trabalho, Emprego e Renda 20JT Manuten\u00e7\u00e3o, Moderniza\u00e7\u00e3o e Amplia\u00e7\u00e3o da Rede d... \u0000 46522959000198 MUNICIPIO DE MAUA [MAUA GABINETE DO PREFEITO] STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios 775355 4.351648e+05
201 SP 7107 SAO PAULO 19 Ci\u00eancia e Tecnologia 572 Desenvolvimento Tecnol\u00f3gico e Engenharia 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o 0A29 Subven\u00e7\u00e3o Econ\u00f4mica a Projetos de Desenvolvime... \u0000 08636745000153 ODEBRECHT AGROINDUSTRIAL S.A. STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Institui\u00e7\u00f5es Privadas c/ Fins... 677494 1.344343e+06
204 SP 6213 BARUERI 19 Ci\u00eancia e Tecnologia 572 Desenvolvimento Tecnol\u00f3gico e Engenharia 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o 0A29 Subven\u00e7\u00e3o Econ\u00f4mica a Projetos de Desenvolvime... \u0000 06985928000159 PHYTOBIOS PESQUISA, DESENVOLVIMENTO E INOVACAO... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Institui\u00e7\u00f5es Privadas c/ Fins... 5.516234e+05
207 SP 3067 ARACARIGUAMA 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 0547 Transfer\u00eancias de Cotas-Partes da Compensa\u00e7\u00e3o ... CFEM 58993577000121 MUNICIPIO DE ARACARIGUAMA [GABINETE DO PREFEITO] STN - Transfer\u00eancias a Munic\u00edpios \u0000 \u0000 2.018012e+04
216 SP 2995 ALAMBARI 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 0547 Transfer\u00eancias de Cotas-Partes da Compensa\u00e7\u00e3o ... CFEM 67360420000150 MUNICIPIO DE ALAMBARI [NAO POSSUI] STN - Transfer\u00eancias a Munic\u00edpios \u0000 \u0000 1.498670e+03
242 SP 7059 SANTO ANTONIO DA ALEGRIA 10 Sa\u00fade 301 Aten\u00e7\u00e3o B\u00e1sica 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 20AD Piso de Aten\u00e7\u00e3o B\u00e1sica Vari\u00e1vel - Sa\u00fade da Fam... PAB Vari\u00e1vel - PSF 11389859000150 FUNDO MUNICIPAL DE SAUDE - FMS [FMS-SANTO ANTO... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 2.230000e+03
243 SP 7059 SANTO ANTONIO DA ALEGRIA 10 Sa\u00fade 301 Aten\u00e7\u00e3o B\u00e1sica 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 20AD Piso de Aten\u00e7\u00e3o B\u00e1sica Vari\u00e1vel - Sa\u00fade da Fam... PAB Vari\u00e1vel - PSF 11389859000150 FUNDO MUNICIPAL DE SAUDE - FMS [FMS-SANTO ANTO... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 8.000000e+03
244 SP 7059 SANTO ANTONIO DA ALEGRIA 10 Sa\u00fade 301 Aten\u00e7\u00e3o B\u00e1sica 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 20AD Piso de Aten\u00e7\u00e3o B\u00e1sica Vari\u00e1vel - Sa\u00fade da Fam... PAB Vari\u00e1vel - PSF 11389859000150 FUNDO MUNICIPAL DE SAUDE - FMS [FMS-SANTO ANTO... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 1.330000e+04
245 SP 7059 SANTO ANTONIO DA ALEGRIA 10 Sa\u00fade 301 Aten\u00e7\u00e3o B\u00e1sica 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 20AD Piso de Aten\u00e7\u00e3o B\u00e1sica Vari\u00e1vel - Sa\u00fade da Fam... PAB Vari\u00e1vel - PSF 11389859000150 FUNDO MUNICIPAL DE SAUDE - FMS [FMS-SANTO ANTO... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 1.426000e+04
280 SP 7107 SAO PAULO 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 0051 Transfer\u00eancias do Imposto sobre Opera\u00e7\u00f5es Fina... Transfer\u00eancia - IOF - Munic\u00edpios - Lei n.\u00ba 7.766 46395000000139 MUNICIPIO DE SAO PAULO [SECRETARIA DO GOVERNO ... STN - Transfer\u00eancias a Munic\u00edpios \u0000 \u0000 1.816120e+03
302 SP 6393 DUMONT 10 Sa\u00fade 301 Aten\u00e7\u00e3o B\u00e1sica 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 20AD Piso de Aten\u00e7\u00e3o B\u00e1sica Vari\u00e1vel - Sa\u00fade da Fam... PAB Vari\u00e1vel - PSF 11680230000165 FUNDO MUNICIPAL DE SAUDE DE DUMONT [FUNDO MUNI... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 5.700000e+03
303 SP 6393 DUMONT 10 Sa\u00fade 301 Aten\u00e7\u00e3o B\u00e1sica 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 20AD Piso de Aten\u00e7\u00e3o B\u00e1sica Vari\u00e1vel - Sa\u00fade da Fam... PAB Vari\u00e1vel - PSF 11680230000165 FUNDO MUNICIPAL DE SAUDE DE DUMONT [FUNDO MUNI... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 7.130000e+03
355 SP 6663 MACAUBAL 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 51848943000100 MUNICIPIO DE MACAUBAL [MACAUBAL PREFEITURA] STN - Transfer\u00eancias a Munic\u00edpios \u0000 \u0000 1.846670e+03
356 SP 6703 MIRANDOPOLIS 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 44438968000170 MUNICIPIO DE MIRANDOPOLIS [MIRANDOPOLIS GABINE... STN - Transfer\u00eancias a Munic\u00edpios \u0000 \u0000 5.103240e+03
357 SP 6691 MENDONCA 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 46935110000146 MUNICIPIO DE MENDONCA [MENDONCA GABINETE PREFE... STN - Transfer\u00eancias a Munic\u00edpios \u0000 \u0000 2.452660e+03
358 SP 6683 MARINOPOLIS 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 45132719000114 MUNICIPIO DE MARINOPOLIS [MARINOPOLIS GABINETE... STN - Transfer\u00eancias a Munic\u00edpios \u0000 \u0000 6.409100e+02
359 SP 6721 MONCOES 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 59854927000131 MUNICIPIO DE MONCOES [MONCOES GABINETE PREFEITO] STN - Transfer\u00eancias a Munic\u00edpios \u0000 \u0000 1.493080e+03
360 SP 6767 NOVA LUZITANIA 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 53099149000136 MUNICIPIO DE NOVA LUZITANIA [NOVA LUZITANIA GA... STN - Transfer\u00eancias a Munic\u00edpios \u0000 \u0000 7.611600e+02
361 SP 6809 PANORAMA 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 44918712000160 MUNICIPIO DE PANORAMA STN - Transfer\u00eancias a Munic\u00edpios \u0000 \u0000 2.557120e+03
362 SP 6825 PARIQUERA-ACU 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 45685120000108 MUNICIPIO DE PARIQUERA-ACU [PARIQUERA ACU GABI... STN - Transfer\u00eancias a Munic\u00edpios \u0000 \u0000 2.239600e+03
379 SP 7099 SAO JOSE DOS CAMPOS 19 Ci\u00eancia e Tecnologia 572 Desenvolvimento Tecnol\u00f3gico e Engenharia 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o 0A29 Subven\u00e7\u00e3o Econ\u00f4mica a Projetos de Desenvolvime... \u0000 04149569000174 EMG SYSTEM DO BRASIL LTDA - EPP STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Institui\u00e7\u00f5es Privadas c/ Fins... 3.913130e+05
382 SP 7107 SAO PAULO 19 Ci\u00eancia e Tecnologia 572 Desenvolvimento Tecnol\u00f3gico e Engenharia 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o 0A29 Subven\u00e7\u00e3o Econ\u00f4mica a Projetos de Desenvolvime... \u0000 57455818000116 QUANTA TECNOLOGIA ELETRONICA INDUSTRIA E COMER... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Institui\u00e7\u00f5es Privadas c/ Fins... 8.000000e+04
386 SP 7099 SAO JOSE DOS CAMPOS 19 Ci\u00eancia e Tecnologia 572 Desenvolvimento Tecnol\u00f3gico e Engenharia 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o 0A29 Subven\u00e7\u00e3o Econ\u00f4mica a Projetos de Desenvolvime... \u0000 65481012000120 MECTRON - ENGENHARIA, INDUSTRIA E COMERCIO S.A. STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Institui\u00e7\u00f5es Privadas c/ Fins... 6.178349e+05
387 SP 7099 SAO JOSE DOS CAMPOS 19 Ci\u00eancia e Tecnologia 572 Desenvolvimento Tecnol\u00f3gico e Engenharia 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o 0A29 Subven\u00e7\u00e3o Econ\u00f4mica a Projetos de Desenvolvime... \u0000 65481012000120 MECTRON - ENGENHARIA, INDUSTRIA E COMERCIO S.A. STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Institui\u00e7\u00f5es Privadas c/ Fins... 1.982551e+06
388 SP 7099 SAO JOSE DOS CAMPOS 19 Ci\u00eancia e Tecnologia 572 Desenvolvimento Tecnol\u00f3gico e Engenharia 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o 0A29 Subven\u00e7\u00e3o Econ\u00f4mica a Projetos de Desenvolvime... \u0000 72727167000160 PSS INDUSTRIA E COMERCIO LTDA - EPP STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Institui\u00e7\u00f5es Privadas c/ Fins... 676571 2.910237e+05
398 SP 7107 SAO PAULO 28 Encargos Especiais 846 Outros Encargos Especiais 0909 Opera\u00e7\u00f5es Especiais: Outros Encargos Especiais 0413 Manuten\u00e7\u00e3o e Opera\u00e7\u00e3o dos Partidos Pol\u00edticos \u0000 54956495000156 PARTIDO COMUNISTA DO BRASIL STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... 7.155255e+05
.........................................................
86795 SP 6863 PINDORAMA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 11861752000163 FUNDO MUNICIPAL DE SAUDE DE PINDORAMA [FUNDO M... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 1.822500e+04
86801 SP 6719 MOMBUCA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 11884769000136 FUNDO MUNICIPAL DE SAUDE [FUNDO MUNICIPAL DE S... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 1.146780e+03
86802 SP 6719 MOMBUCA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 11884769000136 FUNDO MUNICIPAL DE SAUDE [FUNDO MUNICIPAL DE S... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 4.180580e+03
86806 SP 6681 MARILIA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 14278219000161 FUNDO MUNICIPAL DE SAUDE DE MARILIA STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 2.840202e+04
86807 SP 6681 MARILIA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 14278219000161 FUNDO MUNICIPAL DE SAUDE DE MARILIA STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 3.942000e+04
86808 SP 6681 MARILIA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 14278219000161 FUNDO MUNICIPAL DE SAUDE DE MARILIA STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 2.788712e+04
86809 SP 6681 MARILIA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 14278219000161 FUNDO MUNICIPAL DE SAUDE DE MARILIA STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 5.191790e+03
86810 SP 6681 MARILIA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 14278219000161 FUNDO MUNICIPAL DE SAUDE DE MARILIA STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 5.562500e+03
86811 SP 6681 MARILIA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 14278219000161 FUNDO MUNICIPAL DE SAUDE DE MARILIA STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 5.220342e+04
86812 SP 6681 MARILIA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 14278219000161 FUNDO MUNICIPAL DE SAUDE DE MARILIA STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 6.331218e+04
86813 SP 6681 MARILIA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 14278219000161 FUNDO MUNICIPAL DE SAUDE DE MARILIA STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 2.018087e+06
86826 SP 6731 MONTE AZUL PAULISTA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 12183698000107 FUNDO MUNICIPAL DE SAUDE [FUNDO MUNICIPAL DE S... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 5.196600e+02
86827 SP 6731 MONTE AZUL PAULISTA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 12183698000107 FUNDO MUNICIPAL DE SAUDE [FUNDO MUNICIPAL DE S... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 1.398140e+03
86828 SP 6731 MONTE AZUL PAULISTA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 12183698000107 FUNDO MUNICIPAL DE SAUDE [FUNDO MUNICIPAL DE S... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 3.756300e+02
86829 SP 6731 MONTE AZUL PAULISTA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 12183698000107 FUNDO MUNICIPAL DE SAUDE [FUNDO MUNICIPAL DE S... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 4.437540e+03
86830 SP 6731 MONTE AZUL PAULISTA 10 Sa\u00fade 302 Assist\u00eancia Hospitalar e Ambulatorial 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... TETO MAC 12183698000107 FUNDO MUNICIPAL DE SAUDE [FUNDO MUNICIPAL DE S... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo 1.350073e+05
86855 SP 0000 Governo do Estado 12 Educa\u00e7\u00e3o 847 Transfer\u00eancias para Educa\u00e7\u00e3o B\u00e1sica 2030 Educa\u00e7\u00e3o B\u00e1sica 0509 Apoio ao Desenvolvimento da Educa\u00e7\u00e3o B\u00e1sica Promed 62823257000109 CENTRO ESTADUAL DE EDUCACAO TECNOLOGICA PAULA ... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \u0000 670594 7.276426e+06
86882 SP 0000 Governo do Estado 28 Encargos Especiais 847 Transfer\u00eancias para Educa\u00e7\u00e3o B\u00e1sica 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 0369 Transfer\u00eancia da Cota-Parte do Sal\u00e1rio-Educa\u00e7\u00e3... Cota-parte dos Estados e DF do Sal\u00e1rio-Educa\u00e7\u00e3o 46384111000140 SAO PAULO SECRETARIA DA EDUCACAO [SP SED GABIN... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \u0000 7.105874e+07
86904 SP 0000 Governo do Estado 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 0999 Recursos para a Reparti\u00e7\u00e3o da Contribui\u00e7\u00e3o de ... CIDE - Combust\u00edveis 46379400000150 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... STN - Transfer\u00eancias a Estados \u0000 1.555422e+07
86931 SP 0000 Governo do Estado 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 46379400000150 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... STN - Transfer\u00eancias a Estados \u0000 3.036326e+07
86938 SP 0000 Governo do Estado 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 0548 Transfer\u00eancias de Cotas-Partes dos Royalties p... Royalties 46379400000150 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... STN - Transfer\u00eancias a Estados \u0000 2.142356e+07
86981 SP 0000 Governo do Estado 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 0551 Transfer\u00eancias do Fundo Especial dos Royalties... Royalties 46379400000150 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... STN - Transfer\u00eancias a Estados \u0000 2.341315e+05
87008 SP 0000 Governo do Estado 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 0044 Fundo de Participa\u00e7\u00e3o dos Estados e do Distrit... FPE- CF art. 159 46379400000150 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... STN - Transfer\u00eancias a Estados \u0000 6.111261e+07
87036 SP 0000 Governo do Estado 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 0050 Transfer\u00eancias do Imposto sobre Opera\u00e7\u00f5es Fina... Transfer\u00eancia - IOF - Estados e DF - Lei n.\u00ba 7... 46379400000150 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... STN - Transfer\u00eancias a Estados \u0000 7.783300e+02
87045 SP 0000 Governo do Estado 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 0046 Transfer\u00eancia da Cota-Parte dos Estados e DF E... Cota-Parte IPI -LC n.\u00ba 61 46379400000150 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... STN - Transfer\u00eancias a Estados \u0000 6.677921e+07
87071 SP 0000 Governo do Estado 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 099E Auxilio Financeiro aos Entes Federados Exporta... Compensa\u00e7\u00e3o de Exporta\u00e7\u00e3o - CEX 46379400000150 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... STN - Transfer\u00eancias a Estados \u0000 6.127553e+07
87098 SP 0000 Governo do Estado 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 0C33 Fundo de Manuten\u00e7\u00e3o e Desenvolvimento da Educa... FUNDEB 46379400000150 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... STN - Transfer\u00eancias a Estados \u0000 1.338576e+08
87125 SP 0000 Governo do Estado 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 0547 Transfer\u00eancias de Cotas-Partes da Compensa\u00e7\u00e3o ... CFEM 46379400000150 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... STN - Transfer\u00eancias a Estados \u0000 1.096712e+06
87158 SP 0000 Governo do Estado 12 Educa\u00e7\u00e3o 122 Administra\u00e7\u00e3o Geral 2109 Programa de Gest\u00e3o e Manuten\u00e7\u00e3o do Minist\u00e9rio ... 20RH Gerenciamento das Pol\u00edticas de Educa\u00e7\u00e3o \u0000 61924981000158 INSTITUTO DE PESOS E MEDIDAS DO ESTADO DE SAO ... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \u0000 676977 6.436045e+04
87351 SP 0000 Governo do Estado 22 Ind\u00fastria 665 Normaliza\u00e7\u00e3o e Qualidade 2055 Desenvolvimento Produtivo 20TV Servi\u00e7os de Metrologia e Qualidade Industrial \u0000 61924981000158 INSTITUTO DE PESOS E MEDIDAS DO ESTADO DE SAO ... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \u0000 676977 3.440049e+06
\n", "

10789 rows \u00d7 18 columns

\n", "
" ], "metadata": {}, "output_type": "pyout", "prompt_number": 196, "text": [ " Sigla Unidade Federa\u00e7\u00e3o Codigo SIAFI Municipio \\\n", "13 SP 7107 \n", "16 SP 7107 \n", "66 SP 2999 \n", "138 SP 7097 \n", "147 SP 6689 \n", "201 SP 7107 \n", "204 SP 6213 \n", "207 SP 3067 \n", "216 SP 2995 \n", "242 SP 7059 \n", "243 SP 7059 \n", "244 SP 7059 \n", "245 SP 7059 \n", "280 SP 7107 \n", "302 SP 6393 \n", "303 SP 6393 \n", "355 SP 6663 \n", "356 SP 6703 \n", "357 SP 6691 \n", "358 SP 6683 \n", "359 SP 6721 \n", "360 SP 6767 \n", "361 SP 6809 \n", "362 SP 6825 \n", "379 SP 7099 \n", "382 SP 7107 \n", "386 SP 7099 \n", "387 SP 7099 \n", "388 SP 7099 \n", "398 SP 7107 \n", "... ... ... \n", "86795 SP 6863 \n", "86801 SP 6719 \n", "86802 SP 6719 \n", "86806 SP 6681 \n", "86807 SP 6681 \n", "86808 SP 6681 \n", "86809 SP 6681 \n", "86810 SP 6681 \n", "86811 SP 6681 \n", "86812 SP 6681 \n", "86813 SP 6681 \n", "86826 SP 6731 \n", "86827 SP 6731 \n", "86828 SP 6731 \n", "86829 SP 6731 \n", "86830 SP 6731 \n", "86855 SP 0000 \n", "86882 SP 0000 \n", "86904 SP 0000 \n", "86931 SP 0000 \n", "86938 SP 0000 \n", "86981 SP 0000 \n", "87008 SP 0000 \n", "87036 SP 0000 \n", "87045 SP 0000 \n", "87071 SP 0000 \n", "87098 SP 0000 \n", "87125 SP 0000 \n", "87158 SP 0000 \n", "87351 SP 0000 \n", "\n", " Nome Municipio Codigo Funcao Nome Funcao \\\n", "13 SAO PAULO 12 Educa\u00e7\u00e3o \n", "16 SAO PAULO 11 Trabalho \n", "66 CAMPINA DO MONTE ALEGRE 28 Encargos Especiais \n", "138 SAO JOSE DO RIO PRETO 28 Encargos Especiais \n", "147 MAUA 11 Trabalho \n", "201 SAO PAULO 19 Ci\u00eancia e Tecnologia \n", "204 BARUERI 19 Ci\u00eancia e Tecnologia \n", "207 ARACARIGUAMA 28 Encargos Especiais \n", "216 ALAMBARI 28 Encargos Especiais \n", "242 SANTO ANTONIO DA ALEGRIA 10 Sa\u00fade \n", "243 SANTO ANTONIO DA ALEGRIA 10 Sa\u00fade \n", "244 SANTO ANTONIO DA ALEGRIA 10 Sa\u00fade \n", "245 SANTO ANTONIO DA ALEGRIA 10 Sa\u00fade \n", "280 SAO PAULO 28 Encargos Especiais \n", "302 DUMONT 10 Sa\u00fade \n", "303 DUMONT 10 Sa\u00fade \n", "355 MACAUBAL 28 Encargos Especiais \n", "356 MIRANDOPOLIS 28 Encargos Especiais \n", "357 MENDONCA 28 Encargos Especiais \n", "358 MARINOPOLIS 28 Encargos Especiais \n", "359 MONCOES 28 Encargos Especiais \n", "360 NOVA LUZITANIA 28 Encargos Especiais \n", "361 PANORAMA 28 Encargos Especiais \n", "362 PARIQUERA-ACU 28 Encargos Especiais \n", "379 SAO JOSE DOS CAMPOS 19 Ci\u00eancia e Tecnologia \n", "382 SAO PAULO 19 Ci\u00eancia e Tecnologia \n", "386 SAO JOSE DOS CAMPOS 19 Ci\u00eancia e Tecnologia \n", "387 SAO JOSE DOS CAMPOS 19 Ci\u00eancia e Tecnologia \n", "388 SAO JOSE DOS CAMPOS 19 Ci\u00eancia e Tecnologia \n", "398 SAO PAULO 28 Encargos Especiais \n", "... ... ... ... \n", "86795 PINDORAMA 10 Sa\u00fade \n", "86801 MOMBUCA 10 Sa\u00fade \n", "86802 MOMBUCA 10 Sa\u00fade \n", "86806 MARILIA 10 Sa\u00fade \n", "86807 MARILIA 10 Sa\u00fade \n", "86808 MARILIA 10 Sa\u00fade \n", "86809 MARILIA 10 Sa\u00fade \n", "86810 MARILIA 10 Sa\u00fade \n", "86811 MARILIA 10 Sa\u00fade \n", "86812 MARILIA 10 Sa\u00fade \n", "86813 MARILIA 10 Sa\u00fade \n", "86826 MONTE AZUL PAULISTA 10 Sa\u00fade \n", "86827 MONTE AZUL PAULISTA 10 Sa\u00fade \n", "86828 MONTE AZUL PAULISTA 10 Sa\u00fade \n", "86829 MONTE AZUL PAULISTA 10 Sa\u00fade \n", "86830 MONTE AZUL PAULISTA 10 Sa\u00fade \n", "86855 Governo do Estado 12 Educa\u00e7\u00e3o \n", "86882 Governo do Estado 28 Encargos Especiais \n", "86904 Governo do Estado 28 Encargos Especiais \n", "86931 Governo do Estado 28 Encargos Especiais \n", "86938 Governo do Estado 28 Encargos Especiais \n", "86981 Governo do Estado 28 Encargos Especiais \n", "87008 Governo do Estado 28 Encargos Especiais \n", "87036 Governo do Estado 28 Encargos Especiais \n", "87045 Governo do Estado 28 Encargos Especiais \n", "87071 Governo do Estado 28 Encargos Especiais \n", "87098 Governo do Estado 28 Encargos Especiais \n", "87125 Governo do Estado 28 Encargos Especiais \n", "87158 Governo do Estado 12 Educa\u00e7\u00e3o \n", "87351 Governo do Estado 22 Ind\u00fastria \n", "\n", " Codigo Sub Funcao Nome Sub Funcao \\\n", "13 364 Ensino Superior \n", "16 333 Empregabilidade \n", "66 845 Transfer\u00eancias \n", "138 846 Outros Encargos Especiais \n", "147 333 Empregabilidade \n", "201 572 Desenvolvimento Tecnol\u00f3gico e Engenharia \n", "204 572 Desenvolvimento Tecnol\u00f3gico e Engenharia \n", "207 845 Transfer\u00eancias \n", "216 845 Transfer\u00eancias \n", "242 301 Aten\u00e7\u00e3o B\u00e1sica \n", "243 301 Aten\u00e7\u00e3o B\u00e1sica \n", "244 301 Aten\u00e7\u00e3o B\u00e1sica \n", "245 301 Aten\u00e7\u00e3o B\u00e1sica \n", "280 845 Transfer\u00eancias \n", "302 301 Aten\u00e7\u00e3o B\u00e1sica \n", "303 301 Aten\u00e7\u00e3o B\u00e1sica \n", "355 845 Transfer\u00eancias \n", "356 845 Transfer\u00eancias \n", "357 845 Transfer\u00eancias \n", "358 845 Transfer\u00eancias \n", "359 845 Transfer\u00eancias \n", "360 845 Transfer\u00eancias \n", "361 845 Transfer\u00eancias \n", "362 845 Transfer\u00eancias \n", "379 572 Desenvolvimento Tecnol\u00f3gico e Engenharia \n", "382 572 Desenvolvimento Tecnol\u00f3gico e Engenharia \n", "386 572 Desenvolvimento Tecnol\u00f3gico e Engenharia \n", "387 572 Desenvolvimento Tecnol\u00f3gico e Engenharia \n", "388 572 Desenvolvimento Tecnol\u00f3gico e Engenharia \n", "398 846 Outros Encargos Especiais \n", "... ... ... \n", "86795 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86801 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86802 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86806 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86807 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86808 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86809 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86810 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86811 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86812 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86813 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86826 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86827 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86828 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86829 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86830 302 Assist\u00eancia Hospitalar e Ambulatorial \n", "86855 847 Transfer\u00eancias para Educa\u00e7\u00e3o B\u00e1sica \n", "86882 847 Transfer\u00eancias para Educa\u00e7\u00e3o B\u00e1sica \n", "86904 845 Transfer\u00eancias \n", "86931 845 Transfer\u00eancias \n", "86938 845 Transfer\u00eancias \n", "86981 845 Transfer\u00eancias \n", "87008 845 Transfer\u00eancias \n", "87036 845 Transfer\u00eancias \n", "87045 845 Transfer\u00eancias \n", "87071 845 Transfer\u00eancias \n", "87098 845 Transfer\u00eancias \n", "87125 845 Transfer\u00eancias \n", "87158 122 Administra\u00e7\u00e3o Geral \n", "87351 665 Normaliza\u00e7\u00e3o e Qualidade \n", "\n", " Codigo Programa Nome Programa \\\n", "13 2032 Educa\u00e7\u00e3o Superior - Gradua\u00e7\u00e3o, P\u00f3s-Gradua\u00e7\u00e3o, ... \n", "16 2071 Trabalho, Emprego e Renda \n", "66 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "138 0909 Opera\u00e7\u00f5es Especiais: Outros Encargos Especiais \n", "147 2071 Trabalho, Emprego e Renda \n", "201 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o \n", "204 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o \n", "207 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "216 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "242 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "243 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "244 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "245 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "280 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "302 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "303 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "355 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "356 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "357 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "358 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "359 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "360 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "361 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "362 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "379 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o \n", "382 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o \n", "386 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o \n", "387 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o \n", "388 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o \n", "398 0909 Opera\u00e7\u00f5es Especiais: Outros Encargos Especiais \n", "... ... ... \n", "86795 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86801 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86802 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86806 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86807 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86808 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86809 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86810 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86811 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86812 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86813 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86826 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86827 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86828 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86829 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86830 2015 Aperfei\u00e7oamento do Sistema \u00danico de Sa\u00fade (SUS) \n", "86855 2030 Educa\u00e7\u00e3o B\u00e1sica \n", "86882 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "86904 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "86931 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "86938 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "86981 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "87008 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "87036 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "87045 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "87071 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "87098 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "87125 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... \n", "87158 2109 Programa de Gest\u00e3o e Manuten\u00e7\u00e3o do Minist\u00e9rio ... \n", "87351 2055 Desenvolvimento Produtivo \n", "\n", " Codigo Acao Nome Acao \\\n", "13 0487 Concess\u00e3o de Bolsas de Estudos \n", "16 20ST Estudos e Pesquisas para Apoio e Gest\u00e3o do Sis... \n", "66 0547 Transfer\u00eancias de Cotas-Partes da Compensa\u00e7\u00e3o ... \n", "138 0413 Manuten\u00e7\u00e3o e Opera\u00e7\u00e3o dos Partidos Pol\u00edticos \n", "147 20JT Manuten\u00e7\u00e3o, Moderniza\u00e7\u00e3o e Amplia\u00e7\u00e3o da Rede d... \n", "201 0A29 Subven\u00e7\u00e3o Econ\u00f4mica a Projetos de Desenvolvime... \n", "204 0A29 Subven\u00e7\u00e3o Econ\u00f4mica a Projetos de Desenvolvime... \n", "207 0547 Transfer\u00eancias de Cotas-Partes da Compensa\u00e7\u00e3o ... \n", "216 0547 Transfer\u00eancias de Cotas-Partes da Compensa\u00e7\u00e3o ... \n", "242 20AD Piso de Aten\u00e7\u00e3o B\u00e1sica Vari\u00e1vel - Sa\u00fade da Fam... \n", "243 20AD Piso de Aten\u00e7\u00e3o B\u00e1sica Vari\u00e1vel - Sa\u00fade da Fam... \n", "244 20AD Piso de Aten\u00e7\u00e3o B\u00e1sica Vari\u00e1vel - Sa\u00fade da Fam... \n", "245 20AD Piso de Aten\u00e7\u00e3o B\u00e1sica Vari\u00e1vel - Sa\u00fade da Fam... \n", "280 0051 Transfer\u00eancias do Imposto sobre Opera\u00e7\u00f5es Fina... \n", "302 20AD Piso de Aten\u00e7\u00e3o B\u00e1sica Vari\u00e1vel - Sa\u00fade da Fam... \n", "303 20AD Piso de Aten\u00e7\u00e3o B\u00e1sica Vari\u00e1vel - Sa\u00fade da Fam... \n", "355 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... \n", "356 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... \n", "357 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... \n", "358 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... \n", "359 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... \n", "360 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... \n", "361 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... \n", "362 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... \n", "379 0A29 Subven\u00e7\u00e3o Econ\u00f4mica a Projetos de Desenvolvime... \n", "382 0A29 Subven\u00e7\u00e3o Econ\u00f4mica a Projetos de Desenvolvime... \n", "386 0A29 Subven\u00e7\u00e3o Econ\u00f4mica a Projetos de Desenvolvime... \n", "387 0A29 Subven\u00e7\u00e3o Econ\u00f4mica a Projetos de Desenvolvime... \n", "388 0A29 Subven\u00e7\u00e3o Econ\u00f4mica a Projetos de Desenvolvime... \n", "398 0413 Manuten\u00e7\u00e3o e Opera\u00e7\u00e3o dos Partidos Pol\u00edticos \n", "... ... ... \n", "86795 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86801 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86802 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86806 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86807 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86808 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86809 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86810 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86811 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86812 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86813 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86826 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86827 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86828 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86829 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86830 8585 Aten\u00e7\u00e3o \u00e0 Sa\u00fade da Popula\u00e7\u00e3o para Procedimento... \n", "86855 0509 Apoio ao Desenvolvimento da Educa\u00e7\u00e3o B\u00e1sica \n", "86882 0369 Transfer\u00eancia da Cota-Parte do Sal\u00e1rio-Educa\u00e7\u00e3... \n", "86904 0999 Recursos para a Reparti\u00e7\u00e3o da Contribui\u00e7\u00e3o de ... \n", "86931 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... \n", "86938 0548 Transfer\u00eancias de Cotas-Partes dos Royalties p... \n", "86981 0551 Transfer\u00eancias do Fundo Especial dos Royalties... \n", "87008 0044 Fundo de Participa\u00e7\u00e3o dos Estados e do Distrit... \n", "87036 0050 Transfer\u00eancias do Imposto sobre Opera\u00e7\u00f5es Fina... \n", "87045 0046 Transfer\u00eancia da Cota-Parte dos Estados e DF E... \n", "87071 099E Auxilio Financeiro aos Entes Federados Exporta... \n", "87098 0C33 Fundo de Manuten\u00e7\u00e3o e Desenvolvimento da Educa... \n", "87125 0547 Transfer\u00eancias de Cotas-Partes da Compensa\u00e7\u00e3o ... \n", "87158 20RH Gerenciamento das Pol\u00edticas de Educa\u00e7\u00e3o \n", "87351 20TV Servi\u00e7os de Metrologia e Qualidade Industrial \n", "\n", " Linguagem Cidad\u00e3 Codigo Favorecido \\\n", "13 Bolsas de Estudos no Pa\u00eds 86982311000119 \n", "16 \u0000 60964996000187 \n", "66 CFEM 67360404000167 \n", "138 \u0000 32095101000180 \n", "147 \u0000 46522959000198 \n", "201 \u0000 08636745000153 \n", "204 \u0000 06985928000159 \n", "207 CFEM 58993577000121 \n", "216 CFEM 67360420000150 \n", "242 PAB Vari\u00e1vel - PSF 11389859000150 \n", "243 PAB Vari\u00e1vel - PSF 11389859000150 \n", "244 PAB Vari\u00e1vel - PSF 11389859000150 \n", "245 PAB Vari\u00e1vel - PSF 11389859000150 \n", "280 Transfer\u00eancia - IOF - Munic\u00edpios - Lei n.\u00ba 7.766 46395000000139 \n", "302 PAB Vari\u00e1vel - PSF 11680230000165 \n", "303 PAB Vari\u00e1vel - PSF 11680230000165 \n", "355 Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 51848943000100 \n", "356 Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 44438968000170 \n", "357 Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 46935110000146 \n", "358 Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 45132719000114 \n", "359 Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 59854927000131 \n", "360 Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 53099149000136 \n", "361 Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 44918712000160 \n", "362 Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 45685120000108 \n", "379 \u0000 04149569000174 \n", "382 \u0000 57455818000116 \n", "386 \u0000 65481012000120 \n", "387 \u0000 65481012000120 \n", "388 \u0000 72727167000160 \n", "398 \u0000 54956495000156 \n", "... ... ... \n", "86795 TETO MAC 11861752000163 \n", "86801 TETO MAC 11884769000136 \n", "86802 TETO MAC 11884769000136 \n", "86806 TETO MAC 14278219000161 \n", "86807 TETO MAC 14278219000161 \n", "86808 TETO MAC 14278219000161 \n", "86809 TETO MAC 14278219000161 \n", "86810 TETO MAC 14278219000161 \n", "86811 TETO MAC 14278219000161 \n", "86812 TETO MAC 14278219000161 \n", "86813 TETO MAC 14278219000161 \n", "86826 TETO MAC 12183698000107 \n", "86827 TETO MAC 12183698000107 \n", "86828 TETO MAC 12183698000107 \n", "86829 TETO MAC 12183698000107 \n", "86830 TETO MAC 12183698000107 \n", "86855 Promed 62823257000109 \n", "86882 Cota-parte dos Estados e DF do Sal\u00e1rio-Educa\u00e7\u00e3o 46384111000140 \n", "86904 CIDE - Combust\u00edveis 46379400000150 \n", "86931 Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 46379400000150 \n", "86938 Royalties 46379400000150 \n", "86981 Royalties 46379400000150 \n", "87008 FPE- CF art. 159 46379400000150 \n", "87036 Transfer\u00eancia - IOF - Estados e DF - Lei n.\u00ba 7... 46379400000150 \n", "87045 Cota-Parte IPI -LC n.\u00ba 61 46379400000150 \n", "87071 Compensa\u00e7\u00e3o de Exporta\u00e7\u00e3o - CEX 46379400000150 \n", "87098 FUNDEB 46379400000150 \n", "87125 CFEM 46379400000150 \n", "87158 \u0000 61924981000158 \n", "87351 \u0000 61924981000158 \n", "\n", " Nome Favorecido \\\n", "13 ASSOCIACAO NACIONAL DE POS-GRADUACAO E PESQUIS... \n", "16 DEPARTAMENTO INTERSINDICAL DE EST ESTS SOCIO E... \n", "66 MUNICIPIO DE CAMPINA DO MONTE ALEGRE [CAMPINA ... \n", "138 PARTIDO REPUBLICANO PROGRESSISTA-PRP \n", "147 MUNICIPIO DE MAUA [MAUA GABINETE DO PREFEITO] \n", "201 ODEBRECHT AGROINDUSTRIAL S.A. \n", "204 PHYTOBIOS PESQUISA, DESENVOLVIMENTO E INOVACAO... \n", "207 MUNICIPIO DE ARACARIGUAMA [GABINETE DO PREFEITO] \n", "216 MUNICIPIO DE ALAMBARI [NAO POSSUI] \n", "242 FUNDO MUNICIPAL DE SAUDE - FMS [FMS-SANTO ANTO... \n", "243 FUNDO MUNICIPAL DE SAUDE - FMS [FMS-SANTO ANTO... \n", "244 FUNDO MUNICIPAL DE SAUDE - FMS [FMS-SANTO ANTO... \n", "245 FUNDO MUNICIPAL DE SAUDE - FMS [FMS-SANTO ANTO... \n", "280 MUNICIPIO DE SAO PAULO [SECRETARIA DO GOVERNO ... \n", "302 FUNDO MUNICIPAL DE SAUDE DE DUMONT [FUNDO MUNI... \n", "303 FUNDO MUNICIPAL DE SAUDE DE DUMONT [FUNDO MUNI... \n", "355 MUNICIPIO DE MACAUBAL [MACAUBAL PREFEITURA] \n", "356 MUNICIPIO DE MIRANDOPOLIS [MIRANDOPOLIS GABINE... \n", "357 MUNICIPIO DE MENDONCA [MENDONCA GABINETE PREFE... \n", "358 MUNICIPIO DE MARINOPOLIS [MARINOPOLIS GABINETE... \n", "359 MUNICIPIO DE MONCOES [MONCOES GABINETE PREFEITO] \n", "360 MUNICIPIO DE NOVA LUZITANIA [NOVA LUZITANIA GA... \n", "361 MUNICIPIO DE PANORAMA \n", "362 MUNICIPIO DE PARIQUERA-ACU [PARIQUERA ACU GABI... \n", "379 EMG SYSTEM DO BRASIL LTDA - EPP \n", "382 QUANTA TECNOLOGIA ELETRONICA INDUSTRIA E COMER... \n", "386 MECTRON - ENGENHARIA, INDUSTRIA E COMERCIO S.A. \n", "387 MECTRON - ENGENHARIA, INDUSTRIA E COMERCIO S.A. \n", "388 PSS INDUSTRIA E COMERCIO LTDA - EPP \n", "398 PARTIDO COMUNISTA DO BRASIL \n", "... ... \n", "86795 FUNDO MUNICIPAL DE SAUDE DE PINDORAMA [FUNDO M... \n", "86801 FUNDO MUNICIPAL DE SAUDE [FUNDO MUNICIPAL DE S... \n", "86802 FUNDO MUNICIPAL DE SAUDE [FUNDO MUNICIPAL DE S... \n", "86806 FUNDO MUNICIPAL DE SAUDE DE MARILIA \n", "86807 FUNDO MUNICIPAL DE SAUDE DE MARILIA \n", "86808 FUNDO MUNICIPAL DE SAUDE DE MARILIA \n", "86809 FUNDO MUNICIPAL DE SAUDE DE MARILIA \n", "86810 FUNDO MUNICIPAL DE SAUDE DE MARILIA \n", "86811 FUNDO MUNICIPAL DE SAUDE DE MARILIA \n", "86812 FUNDO MUNICIPAL DE SAUDE DE MARILIA \n", "86813 FUNDO MUNICIPAL DE SAUDE DE MARILIA \n", "86826 FUNDO MUNICIPAL DE SAUDE [FUNDO MUNICIPAL DE S... \n", "86827 FUNDO MUNICIPAL DE SAUDE [FUNDO MUNICIPAL DE S... \n", "86828 FUNDO MUNICIPAL DE SAUDE [FUNDO MUNICIPAL DE S... \n", "86829 FUNDO MUNICIPAL DE SAUDE [FUNDO MUNICIPAL DE S... \n", "86830 FUNDO MUNICIPAL DE SAUDE [FUNDO MUNICIPAL DE S... \n", "86855 CENTRO ESTADUAL DE EDUCACAO TECNOLOGICA PAULA ... \n", "86882 SAO PAULO SECRETARIA DA EDUCACAO [SP SED GABIN... \n", "86904 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... \n", "86931 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... \n", "86938 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... \n", "86981 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... \n", "87008 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... \n", "87036 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... \n", "87045 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... \n", "87071 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... \n", "87098 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... \n", "87125 ESTADO DE SAO PAULO [SP GOV GABINETE DO GOVERN... \n", "87158 INSTITUTO DE PESOS E MEDIDAS DO ESTADO DE SAO ... \n", "87351 INSTITUTO DE PESOS E MEDIDAS DO ESTADO DE SAO ... \n", "\n", " Fonte-Finalidade \\\n", "13 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "16 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "66 STN - Transfer\u00eancias a Munic\u00edpios \n", "138 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "147 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "201 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "204 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "207 STN - Transfer\u00eancias a Munic\u00edpios \n", "216 STN - Transfer\u00eancias a Munic\u00edpios \n", "242 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "243 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "244 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "245 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "280 STN - Transfer\u00eancias a Munic\u00edpios \n", "302 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "303 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "355 STN - Transfer\u00eancias a Munic\u00edpios \n", "356 STN - Transfer\u00eancias a Munic\u00edpios \n", "357 STN - Transfer\u00eancias a Munic\u00edpios \n", "358 STN - Transfer\u00eancias a Munic\u00edpios \n", "359 STN - Transfer\u00eancias a Munic\u00edpios \n", "360 STN - Transfer\u00eancias a Munic\u00edpios \n", "361 STN - Transfer\u00eancias a Munic\u00edpios \n", "362 STN - Transfer\u00eancias a Munic\u00edpios \n", "379 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "382 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "386 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "387 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "388 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "398 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "... ... \n", "86795 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86801 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86802 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86806 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86807 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86808 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86809 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86810 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86811 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86812 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86813 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86826 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86827 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86828 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86829 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86830 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86855 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86882 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "86904 STN - Transfer\u00eancias a Estados \n", "86931 STN - Transfer\u00eancias a Estados \n", "86938 STN - Transfer\u00eancias a Estados \n", "86981 STN - Transfer\u00eancias a Estados \n", "87008 STN - Transfer\u00eancias a Estados \n", "87036 STN - Transfer\u00eancias a Estados \n", "87045 STN - Transfer\u00eancias a Estados \n", "87071 STN - Transfer\u00eancias a Estados \n", "87098 STN - Transfer\u00eancias a Estados \n", "87125 STN - Transfer\u00eancias a Estados \n", "87158 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "87351 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "\n", " Modalidade Aplica\u00e7\u00e3o N\u00famero Conv\u00eanio \\\n", "13 Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... \n", "16 Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... 755158 \n", "66 \u0000 \u0000 \n", "138 Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... \n", "147 Transfer\u00eancias a Munic\u00edpios 775355 \n", "201 Transfer\u00eancias a Institui\u00e7\u00f5es Privadas c/ Fins... 677494 \n", "204 Transfer\u00eancias a Institui\u00e7\u00f5es Privadas c/ Fins... \n", "207 \u0000 \u0000 \n", "216 \u0000 \u0000 \n", "242 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "243 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "244 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "245 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "280 \u0000 \u0000 \n", "302 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "303 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "355 \u0000 \u0000 \n", "356 \u0000 \u0000 \n", "357 \u0000 \u0000 \n", "358 \u0000 \u0000 \n", "359 \u0000 \u0000 \n", "360 \u0000 \u0000 \n", "361 \u0000 \u0000 \n", "362 \u0000 \u0000 \n", "379 Transfer\u00eancias a Institui\u00e7\u00f5es Privadas c/ Fins... \n", "382 Transfer\u00eancias a Institui\u00e7\u00f5es Privadas c/ Fins... \n", "386 Transfer\u00eancias a Institui\u00e7\u00f5es Privadas c/ Fins... \n", "387 Transfer\u00eancias a Institui\u00e7\u00f5es Privadas c/ Fins... \n", "388 Transfer\u00eancias a Institui\u00e7\u00f5es Privadas c/ Fins... 676571 \n", "398 Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... \n", "... ... ... \n", "86795 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86801 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86802 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86806 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86807 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86808 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86809 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86810 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86811 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86812 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86813 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86826 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86827 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86828 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86829 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86830 Transfer\u00eancias a Munic\u00edpios - Fundo a Fundo \n", "86855 \u0000 670594 \n", "86882 \u0000 \n", "86904 \u0000 \n", "86931 \u0000 \n", "86938 \u0000 \n", "86981 \u0000 \n", "87008 \u0000 \n", "87036 \u0000 \n", "87045 \u0000 \n", "87071 \u0000 \n", "87098 \u0000 \n", "87125 \u0000 \n", "87158 \u0000 676977 \n", "87351 \u0000 676977 \n", "\n", " Valor Parcela \n", "13 8.500000e+02 \n", "16 4.604908e+05 \n", "66 7.615700e+02 \n", "138 1.150952e+05 \n", "147 4.351648e+05 \n", "201 1.344343e+06 \n", "204 5.516234e+05 \n", "207 2.018012e+04 \n", "216 1.498670e+03 \n", "242 2.230000e+03 \n", "243 8.000000e+03 \n", "244 1.330000e+04 \n", "245 1.426000e+04 \n", "280 1.816120e+03 \n", "302 5.700000e+03 \n", "303 7.130000e+03 \n", "355 1.846670e+03 \n", "356 5.103240e+03 \n", "357 2.452660e+03 \n", "358 6.409100e+02 \n", "359 1.493080e+03 \n", "360 7.611600e+02 \n", "361 2.557120e+03 \n", "362 2.239600e+03 \n", "379 3.913130e+05 \n", "382 8.000000e+04 \n", "386 6.178349e+05 \n", "387 1.982551e+06 \n", "388 2.910237e+05 \n", "398 7.155255e+05 \n", "... ... \n", "86795 1.822500e+04 \n", "86801 1.146780e+03 \n", "86802 4.180580e+03 \n", "86806 2.840202e+04 \n", "86807 3.942000e+04 \n", "86808 2.788712e+04 \n", "86809 5.191790e+03 \n", "86810 5.562500e+03 \n", "86811 5.220342e+04 \n", "86812 6.331218e+04 \n", "86813 2.018087e+06 \n", "86826 5.196600e+02 \n", "86827 1.398140e+03 \n", "86828 3.756300e+02 \n", "86829 4.437540e+03 \n", "86830 1.350073e+05 \n", "86855 7.276426e+06 \n", "86882 7.105874e+07 \n", "86904 1.555422e+07 \n", "86931 3.036326e+07 \n", "86938 2.142356e+07 \n", "86981 2.341315e+05 \n", "87008 6.111261e+07 \n", "87036 7.783300e+02 \n", "87045 6.677921e+07 \n", "87071 6.127553e+07 \n", "87098 1.338576e+08 \n", "87125 1.096712e+06 \n", "87158 6.436045e+04 \n", "87351 3.440049e+06 \n", "\n", "[10789 rows x 18 columns]" ] } ], "prompt_number": 196 }, { "cell_type": "heading", "level": 2, "metadata": {}, "source": [ "Histograma das transfer\u00eancias por Estado" ] }, { "cell_type": "code", "collapsed": false, "input": [ "dados[dados['Sigla Unidade Federa\u00e7\u00e3o'] == 'SP']['Nome Funcao'].value_counts()" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 198, "text": [ "Sa\u00fade 5526\n", "Encargos Especiais 5054\n", "Educa\u00e7\u00e3o 143\n", "Assist\u00eancia Social 24\n", "Ci\u00eancia e Tecnologia 17\n", "Com\u00e9rcio e Servi\u00e7os 14\n", "Trabalho 7\n", "Cultura 2\n", "Ind\u00fastria 1\n", "Agricultura 1\n", "dtype: int64" ] } ], "prompt_number": 198 }, { "cell_type": "heading", "level": 2, "metadata": {}, "source": [ "Utilizando o index do DataFrame" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "\u00c9 poss\u00edvel filtrar por mais de uma condi\u00e7\u00e3o como os seguintes exemplos:" ] }, { "cell_type": "code", "collapsed": false, "input": [ "dados[(dados['Sigla Unidade Federa\u00e7\u00e3o'] == 'SP') | (dados['Sigla Unidade Federa\u00e7\u00e3o'] == 'MG')].head()" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Sigla Unidade Federa\u00e7\u00e3oCodigo SIAFI MunicipioNome MunicipioCodigo FuncaoNome FuncaoCodigo Sub Funcao Nome Sub FuncaoCodigo ProgramaNome ProgramaCodigo AcaoNome AcaoLinguagem Cidad\u00e3Codigo FavorecidoNome FavorecidoFonte-FinalidadeModalidade Aplica\u00e7\u00e3oN\u00famero Conv\u00eanioValor Parcela
0 MG 4123 BELO HORIZONTE 19 Ci\u00eancia e Tecnologia 572 Desenvolvimento Tecnol\u00f3gico e Engenharia 2021 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o 2095 Fomento a Projetos de Implanta\u00e7\u00e3o e Recupera\u00e7\u00e3... CT-INFRA 18720938000141 FUNDACAO DE DESENVOLVIMENTO DA PESQUISA STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... 673120 444340.00
2 MG 5221 SAO FRANCISCO 15 Urbanismo 452 Servi\u00e7os Urbanos 0660 Seguran\u00e7a e Educa\u00e7\u00e3o de Tr\u00e2nsito: Direito e Re... 8487 Fomento a Projetos Destinados \u00e0 Preven\u00e7\u00e3o e Re... \u0000 22679153000140 MUNICIPIO DE SAO FRANCISCO [SAO FRANCISCO PREF... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Munic\u00edpios 725369 66397.51
13 SP 7107 SAO PAULO 12 Educa\u00e7\u00e3o 364 Ensino Superior 2032 Educa\u00e7\u00e3o Superior - Gradua\u00e7\u00e3o, P\u00f3s-Gradua\u00e7\u00e3o, ... 0487 Concess\u00e3o de Bolsas de Estudos Bolsas de Estudos no Pa\u00eds 86982311000119 ASSOCIACAO NACIONAL DE POS-GRADUACAO E PESQUIS... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... 850.00
16 SP 7107 SAO PAULO 11 Trabalho 333 Empregabilidade 2071 Trabalho, Emprego e Renda 20ST Estudos e Pesquisas para Apoio e Gest\u00e3o do Sis... \u0000 60964996000187 DEPARTAMENTO INTERSINDICAL DE EST ESTS SOCIO E... STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... 755158 460490.76
18 MG 4907 OLARIA 28 Encargos Especiais 845 Transfer\u00eancias 0903 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 099B Transfer\u00eancia a Estados, Distrito Federal e Mu... Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 18338202000103 MUNICIPIO DE OLARIA [OLARIA GABINETE PREFEITO] STN - Transfer\u00eancias a Munic\u00edpios \u0000 \u0000 594.39
\n", "
" ], "metadata": {}, "output_type": "pyout", "prompt_number": 260, "text": [ " Sigla Unidade Federa\u00e7\u00e3o Codigo SIAFI Municipio Nome Municipio \\\n", "0 MG 4123 BELO HORIZONTE \n", "2 MG 5221 SAO FRANCISCO \n", "13 SP 7107 SAO PAULO \n", "16 SP 7107 SAO PAULO \n", "18 MG 4907 OLARIA \n", "\n", " Codigo Funcao Nome Funcao Codigo Sub Funcao \\\n", "0 19 Ci\u00eancia e Tecnologia 572 \n", "2 15 Urbanismo 452 \n", "13 12 Educa\u00e7\u00e3o 364 \n", "16 11 Trabalho 333 \n", "18 28 Encargos Especiais 845 \n", "\n", " Nome Sub Funcao Codigo Programa \\\n", "0 Desenvolvimento Tecnol\u00f3gico e Engenharia 2021 \n", "2 Servi\u00e7os Urbanos 0660 \n", "13 Ensino Superior 2032 \n", "16 Empregabilidade 2071 \n", "18 Transfer\u00eancias 0903 \n", "\n", " Nome Programa Codigo Acao \\\n", "0 Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o 2095 \n", "2 Seguran\u00e7a e Educa\u00e7\u00e3o de Tr\u00e2nsito: Direito e Re... 8487 \n", "13 Educa\u00e7\u00e3o Superior - Gradua\u00e7\u00e3o, P\u00f3s-Gradua\u00e7\u00e3o, ... 0487 \n", "16 Trabalho, Emprego e Renda 20ST \n", "18 Opera\u00e7\u00f5es Especiais: Transfer\u00eancias Constituci... 099B \n", "\n", " Nome Acao \\\n", "0 Fomento a Projetos de Implanta\u00e7\u00e3o e Recupera\u00e7\u00e3... \n", "2 Fomento a Projetos Destinados \u00e0 Preven\u00e7\u00e3o e Re... \n", "13 Concess\u00e3o de Bolsas de Estudos \n", "16 Estudos e Pesquisas para Apoio e Gest\u00e3o do Sis... \n", "18 Transfer\u00eancia a Estados, Distrito Federal e Mu... \n", "\n", " Linguagem Cidad\u00e3 Codigo Favorecido \\\n", "0 CT-INFRA 18720938000141 \n", "2 \u0000 22679153000140 \n", "13 Bolsas de Estudos no Pa\u00eds 86982311000119 \n", "16 \u0000 60964996000187 \n", "18 Transfer\u00eancias - LC n.\u00ba 87/96 e 115/2003 18338202000103 \n", "\n", " Nome Favorecido \\\n", "0 FUNDACAO DE DESENVOLVIMENTO DA PESQUISA \n", "2 MUNICIPIO DE SAO FRANCISCO [SAO FRANCISCO PREF... \n", "13 ASSOCIACAO NACIONAL DE POS-GRADUACAO E PESQUIS... \n", "16 DEPARTAMENTO INTERSINDICAL DE EST ESTS SOCIO E... \n", "18 MUNICIPIO DE OLARIA [OLARIA GABINETE PREFEITO] \n", "\n", " Fonte-Finalidade \\\n", "0 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "2 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "13 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "16 STN - Conv\u00eanios/Contratos de Repasses/Fundo a ... \n", "18 STN - Transfer\u00eancias a Munic\u00edpios \n", "\n", " Modalidade Aplica\u00e7\u00e3o N\u00famero Conv\u00eanio \\\n", "0 Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... 673120 \n", "2 Transfer\u00eancias a Munic\u00edpios 725369 \n", "13 Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... \n", "16 Transfer\u00eancias a Institui\u00e7\u00f5es Privadas s/ Fins... 755158 \n", "18 \u0000 \u0000 \n", "\n", " Valor Parcela \n", "0 444340.00 \n", "2 66397.51 \n", "13 850.00 \n", "16 460490.76 \n", "18 594.39 " ] } ], "prompt_number": 260 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Ou um exemplo mais interessante, vamos ver quanto foi transferido para 'Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o' em S\u00e3o Paulo:" ] }, { "cell_type": "code", "collapsed": false, "input": [ "dados[(dados['Sigla Unidade Federa\u00e7\u00e3o'] == 'SP') & (dados['Nome Programa'] == 'Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o')]['Valor Parcela'].sum()\n", "\n" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 264, "text": [ "42568238.469999999" ] } ], "prompt_number": 264 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Mas o Pandas \u00e9 m\u00e1gico, poder\u00edamos ter feito isso pra todos munic\u00edpios (**WARNING: A lot of magic below!**, nada melhor do que somar a totaliza\u00e7\u00e3o de todas as trasnfer\u00eancias s\u00f3 em 'Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o', agrupar por Estado, remover valores estranhos (NA) e imprimir em ordem descrescente tudo em uma linha de Python. Eu quebrei em v\u00e1rias pra ficar mais leg\u00edvel):" ] }, { "cell_type": "code", "collapsed": false, "input": [ "dados[dados['Nome Programa'] == 'Ci\u00eancia, Tecnologia e Inova\u00e7\u00e3o'] \\\n", " .groupby('Sigla Unidade Federa\u00e7\u00e3o') \\\n", " .sum() \\\n", " .dropna() \\\n", " .sort('Valor Parcela')[::-1]\n" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Valor Parcela
Sigla Unidade Federa\u00e7\u00e3o
SP 42568238.47
RJ 39723053.48
RS 2016691.03
PR 1359788.92
AM 593576.19
MG 444340.00
SC 362536.25
PB 261261.42
CE 189980.00
\n", "
" ], "metadata": {}, "output_type": "pyout", "prompt_number": 296, "text": [ " Valor Parcela\n", "Sigla Unidade Federa\u00e7\u00e3o \n", "SP 42568238.47\n", "RJ 39723053.48\n", "RS 2016691.03\n", "PR 1359788.92\n", "AM 593576.19\n", "MG 444340.00\n", "SC 362536.25\n", "PB 261261.42\n", "CE 189980.00" ] } ], "prompt_number": 296 } ], "metadata": {} } ] }