Untitled0.ipynb

{
 "metadata": {
  "name": "",
  "signature": "sha256:c210b8cb56f7d0653a3d836125ea64befb56f22f6b12ab6f78ffa5b88f6c5a0b"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import pandas as pd\n",
      "import json\n",
      "import colour"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 295
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "def load_data(file_name):\n",
      "    header_file = '../data/{}.txt'.format(file_name)\n",
      "    header = !cut -f1 $header_file\n",
      "    data = pd.read_csv('../data/{}.csv'.format(file_name), sep=';',encoding='utf-8', header=None)\n",
      "    data.columns = header + ['noname_{}'.format(i) for i in range(len(data.columns) - len(header))]\n",
      "    \n",
      "    return data\n",
      "\n",
      "ct = pd.read_csv('ct.csv', encoding='utf-8')\n",
      "\n",
      "obras = load_data('../copa2014/data/20140620_Empreendimento')\n",
      "cidades = load_data('../copa2014/data/20140620_CidadeSede')\n",
      "obras_tema = load_data('../copa2014/data/20140620_Tema')\n",
      "\n"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 296
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "cid_obra = []\n",
      "\n",
      "total = ct['Total Previsto'].sum()\n",
      "\n",
      "for cid, cid_obras in obras[(obras['IdTema'] == 6) | (obras['IdTema'] == 8)].groupby('IdCidadeSede'):\n",
      "    if len(cidades[cidades['IdCidadeSede'] == int(cid)]['DescCidadeSede']) > 0:\n",
      "        cidade = cidades[cidades['IdCidadeSede'] == int(cid)]['DescCidadeSede'].values[0]\n",
      "        cid_obra.append({'label': cidade.encode('utf-8'), \n",
      "                         'amount': cid_obras['ValTotalPrevisto'].sum(), \n",
      "                         'color': colour.Color(hsl=(float(cid_obras['ValTotalPrevisto'].sum())/(total), 0.7, 0.5)).hex,\n",
      "                         'children':[]})\n",
      "        for idx, obra in cid_obras.iterrows():\n",
      "            cid_obra[-1]['children'].append({'label': obra['DescEmpreendimento'].encode('utf-8'), 'amount': obra['ValTotalPrevisto']})\n",
      "                             \n",
      "                             \n",
      "                             \n",
      "                             "
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 297
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "d = {'label': 'Total gasto em Est\u00e1dios e Mobilidade'\n",
      "    ,'amount': total\n",
      "    ,'children': []}\n",
      "\n",
      "d['children'] = cid_obra"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 298
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "f = json.dumps(d, ensure_ascii=False)\n",
      "ff = open('j', 'w')\n",
      "ff.write(f)\n",
      "ff.flush()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 265
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "lo = {o: [] for o in list(obras[(obras['IdTema'] == 6) | (obras['IdTema'] == 8)]['DescEmpreendimento'])}"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 292
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "0, Construcap\n",
      "1, Egesa \n",
      "2, Hap\n",
      "3, Mendes J\u00fanior\n",
      "4, Via Engenharia\n",
      "5, Andrade Gutierrez\n",
      "6, Cowan\n",
      "7, Delta\n",
      "8, Barbosa Mello\n",
      "9, Consol Engenheiros Consultores\n",
      "10, Tratenge\n",
      "11, Cetenco\n",
      "12, Constran\n",
      "13, Convap\n",
      "14, Cons\u00f3rcio CGP - Logit\n",
      "\n",
      "lo[u'Reforma e adapta\\xe7\\xe3o do Est\\xe1dio Magalh\\xe3es Pinto (Mineir\\xe3o)'] = [0, 1, 2]\n",
      "lo[u'Boulevard Arrudas / Tereza Cristina'] = [3,4,5]\n",
      "lo[u'BRT: Ant\\xf4nio Carlos / Pedro I'] = [6, 7, 5, 8, 9]\n",
      "lo[u'BRT: \\xc1rea Central'] = [10, 11]\n",
      "lo[u'BRT: Cristiano Machado'] = [12, 13]\n",
      "lo[u\"Corredor Pedro II e Obras Complementares nos BRT's Ant\\xf4nio Carlos/Pedro I e Cristiano Machado\"] = [14]\n",
      "\n"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 294,
       "text": [
        "{u'Acesso ao Novo Aeroporto de S\\xe3o Gon\\xe7alo do Amarante': [],\n",
        " u'Adequa\\xe7\\xe3o Vi\\xe1ria e Obras de Acessibilidade \\xe0 Arena Multiuso Pantanal': [],\n",
        " u'Amplia\\xe7\\xe3o da DF-047': [],\n",
        " u'BRT Avenida Alberto Craveiro': [],\n",
        " u'BRT Avenida Ded\\xe9 Brasil': [],\n",
        " u'BRT Avenida Paulino Rocha': [],\n",
        " u'BRT Transcarioca (Aeroporto / Penha / Barra)': [],\n",
        " u'BRT: Ant\\xf4nio Carlos / Pedro I': [],\n",
        " u'BRT: Cristiano Machado': [],\n",
        " u'BRT: Extens\\xe3o da Linha Verde Sul e Obras Complementares da Requalifica\\xe7\\xe3o do Corredor Marechal Floriano': [],\n",
        " u'BRT: Leste/Oeste - Ramal Cidade da Copa': [],\n",
        " u'BRT: Norte / Sul - Trecho Igarassu / Tacaruna / Centro do Recife': [],\n",
        " u'BRT: \\xc1rea Central': [],\n",
        " u'Boulevard Arrudas / Tereza Cristina': [],\n",
        " u'Complexo Esportivo Curitiba 2014 (Reforma e Amplia\\xe7\\xe3o do Est\\xe1dio)': [],\n",
        " u'Constru\\xe7\\xe3o da Arena Multiuso Pantanal': [],\n",
        " u'Constru\\xe7\\xe3o da Arena Pernambuco': [],\n",
        " u'Constru\\xe7\\xe3o da Arena S\\xe3o Paulo (Itaquera)': [],\n",
        " u'Constru\\xe7\\xe3o da Arena das Dunas': [],\n",
        " u'Corredor Aeroporto / Rodoferrovi\\xe1ria - Trecho Estadual': [],\n",
        " u'Corredor Aeroporto / Rodoferrovi\\xe1ria - Trecho Municipal': [],\n",
        " u'Corredor Caxang\\xe1 (Leste-Oeste)': [],\n",
        " u'Corredor Estruturante \\u2013 Zona Norte/Est\\xe1dio Arena das Dunas': [],\n",
        " u'Corredor M\\xe1rio Andreazza': [],\n",
        " u\"Corredor Pedro II e Obras Complementares nos BRT's Ant\\xf4nio Carlos/Pedro I e Cristiano Machado\": [],\n",
        " u'Corredor da Via Mangue': [],\n",
        " u'Eixo 2: Implanta\\xe7\\xe3o da Via Prudente de Morais': [],\n",
        " u'Eixo Via Expressa/Raul Barbosa': [],\n",
        " u'Entorno Arena Pernambuco: Esta\\xe7\\xe3o de metr\\xf4 Cosme e Dami\\xe3o': [],\n",
        " u'Entorno Arena Pernambuco: Viaduto da BR-408': [],\n",
        " u'Entorno Beira Rio: 3 Vias de Acesso': [],\n",
        " u'Entorno Est\\xe1dio Fonte Nova: Microacessibilidade': [],\n",
        " u'Entorno Est\\xe1dio Fonte Nova: rotas de Pedestres': [],\n",
        " u'Entorno do Est\\xe1dio do Maracan\\xe3: Projeto de Reurbaniza\\xe7\\xe3o do Entorno do Est\\xe1dio do Maracan\\xe3 e Liga\\xe7\\xe3o com a Quinta da Boa Vista - 1\\xaa Fase': [],\n",
        " u'Entorno do Est\\xe1dio do Maracan\\xe3: Reformula\\xe7\\xe3o e Moderniza\\xe7\\xe3o da Esta\\xe7\\xe3o Multimodal do Maracan\\xe3': [],\n",
        " u'Esta\\xe7\\xf5es Padre C\\xedcero e Juscelino Kubitschek': [],\n",
        " u'Expans\\xe3o da Central de Controle de Tr\\xe2nsito': [],\n",
        " u'Interven\\xe7\\xf5es Vi\\xe1rias no entorno do Polo de  Desenvolvimento da Zona Leste': [],\n",
        " u'Metr\\xf4: Terminal Cosme e Dami\\xe3o': [],\n",
        " u'Projeto de Pavimenta\\xe7\\xe3o do Entorno do  Est\\xe1dio Beira-Rio': [],\n",
        " u'Reconstru\\xe7\\xe3o da Arena da Amaz\\xf4nia': [],\n",
        " u'Reconstru\\xe7\\xe3o do Est\\xe1dio da Fonte Nova': [],\n",
        " u'Reforma do Est\\xe1dio Beira Rio': [],\n",
        " u'Reforma do Est\\xe1dio Governador Pl\\xe1cido Castelo (Castel\\xe3o)': [],\n",
        " u'Reforma do Est\\xe1dio M\\xe1rio Filho (Maracan\\xe3)': [],\n",
        " u'Reforma do Est\\xe1dio Nacional de Bras\\xedlia': [],\n",
        " u'Reforma e adapta\\xe7\\xe3o do Est\\xe1dio Magalh\\xe3es Pinto (Mineir\\xe3o)': [],\n",
        " u'Requalifica\\xe7\\xe3o da Rodoferrovi\\xe1ria (inclusive acessos)': [],\n",
        " u'Requalifica\\xe7\\xe3o do Corredor Marechal Floriano - Trecho Estadual': [],\n",
        " u'Requalifica\\xe7\\xe3o do Corredor Marechal Floriano - Trecho Municipal': [],\n",
        " u'Requalifica\\xe7\\xe3o do Terminal Santa C\\xe2ndida (reforma e amplia\\xe7\\xe3o)': [],\n",
        " u'Sistema Integrado de Monitoramento - Trecho Metropolitano': [],\n",
        " u'Sistema Integrado de Monitoramento - Trecho Municipal': [],\n",
        " u'VLT: Cuiab\\xe1 / V\\xe1rzea Grande': [],\n",
        " u'VLT: Parangaba/Mucuripe': [],\n",
        " u'Via 210 (Liga\\xe7\\xe3o Via Min\\xe9rio / Tereza Cristina)': [],\n",
        " u'Vias de Integra\\xe7\\xe3o Radial Metropolitanas': []}"
       ]
      }
     ],
     "prompt_number": 294
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "s.encode('iso8859-1')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 151,
       "text": [
        "'S\\xe3o Paulo'"
       ]
      }
     ],
     "prompt_number": 151
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "u= s.encode('utf-8')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 160
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "u = 'S\u00e3o Paulo'"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 162
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "print u"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "S\u00e3o Paulo\n"
       ]
      }
     ],
     "prompt_number": 164
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "print cid_obra"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "[{'color': '#d93f26', 'amount': 2916600000.0, 'children': [{'amount': 1050000000.0, 'label': 'Reforma do Est\\xc3\\xa1dio M\\xc3\\xa1rio Filho (Maracan\\xc3\\xa3)'}, {'amount': 1582200000.0, 'label': 'BRT Transcarioca (Aeroporto / Penha / Barra)'}, {'amount': 109600000.0, 'label': 'Entorno do Est\\xc3\\xa1dio do Maracan\\xc3\\xa3: Projeto de Reurbaniza\\xc3\\xa7\\xc3\\xa3o do Entorno do Est\\xc3\\xa1dio do Maracan\\xc3\\xa3 e Liga\\xc3\\xa7\\xc3\\xa3o com a Quinta da Boa Vista - 1\\xc2\\xaa Fase'}, {'amount': 174800000.0, 'label': 'Entorno do Est\\xc3\\xa1dio do Maracan\\xc3\\xa3: Reformula\\xc3\\xa7\\xc3\\xa3o e Moderniza\\xc3\\xa7\\xc3\\xa3o da Esta\\xc3\\xa7\\xc3\\xa3o Multimodal do Maracan\\xc3\\xa3'}], 'label': 'Rio de Janeiro'}, {'color': '#d94226', 'amount': 710024335.61000001, 'children': [{'amount': 689400000.0, 'label': 'Reconstru\\xc3\\xa7\\xc3\\xa3o do Est\\xc3\\xa1dio da Fonte Nova'}, {'amount': 13474335.61, 'label': 'Entorno Est\\xc3\\xa1dio Fonte Nova: Microacessibilidade'}, {'amount': 7150000.0, 'label': 'Entorno Est\\xc3\\xa1dio Fonte Nova: rotas de Pedestres'}], 'label': 'Salvador'}, {'color': '#d94426', 'amount': 1368507000.0, 'children': [{'amount': 820000000.0, 'label': 'Constru\\xc3\\xa7\\xc3\\xa3o da Arena S\\xc3\\xa3o Paulo (Itaquera)'}, {'amount': 548507000.0, 'label': 'Interven\\xc3\\xa7\\xc3\\xb5es Vi\\xc3\\xa1rias no entorno do Polo de  Desenvolvimento da Zona Leste'}], 'label': 'S\\xc3\\xa3o Paulo'}, {'color': '#d92b26', 'amount': 1447500000.0, 'children': [{'amount': 1403300000.0, 'label': 'Reforma do Est\\xc3\\xa1dio Nacional de Bras\\xc3\\xadlia'}, {'amount': 44200000.0, 'label': 'Amplia\\xc3\\xa7\\xc3\\xa3o da DF-047'}], 'label': 'Bras\\xc3\\xadlia'}, {'color': '#d92e26', 'amount': 2289500000.0, 'children': [{'amount': 570100000.0, 'label': 'Constru\\xc3\\xa7\\xc3\\xa3o da Arena Multiuso Pantanal'}, {'amount': 46000000.0, 'label': 'Corredor M\\xc3\\xa1rio Andreazza'}, {'amount': 1577600000.0, 'label': 'VLT: Cuiab\\xc3\\xa1 / V\\xc3\\xa1rzea Grande'}, {'amount': 95800000.0, 'label': 'Adequa\\xc3\\xa7\\xc3\\xa3o Vi\\xc3\\xa1ria e Obras de Acessibilidade \\xc3\\xa0 Arena Multiuso Pantanal'}], 'label': 'Cuiab\\xc3\\xa1'}, {'color': '#d93026', 'amount': 792900000.0, 'children': [{'amount': 326700000.0, 'label': 'Complexo Esportivo Curitiba 2014 (Reforma e Amplia\\xc3\\xa7\\xc3\\xa3o do Est\\xc3\\xa1dio)'}, {'amount': 131700000.0, 'label': 'Corredor Aeroporto / Rodoferrovi\\xc3\\xa1ria - Trecho Municipal'}, {'amount': 61600000.0, 'label': 'Sistema Integrado de Monitoramento - Trecho Municipal'}, {'amount': 48900000.0, 'label': 'Requalifica\\xc3\\xa7\\xc3\\xa3o da Rodoferrovi\\xc3\\xa1ria (inclusive acessos)'}, {'amount': 24200000.0, 'label': 'BRT: Extens\\xc3\\xa3o da Linha Verde Sul e Obras Complementares da Requalifica\\xc3\\xa7\\xc3\\xa3o do Corredor Marechal Floriano'}, {'amount': 12600000.0, 'label': 'Requalifica\\xc3\\xa7\\xc3\\xa3o do Terminal Santa C\\xc3\\xa2ndida (reforma e amplia\\xc3\\xa7\\xc3\\xa3o)'}, {'amount': 23400000.0, 'label': 'Requalifica\\xc3\\xa7\\xc3\\xa3o do Corredor Marechal Floriano - Trecho Estadual'}, {'amount': 53300000.0, 'label': 'Vias de Integra\\xc3\\xa7\\xc3\\xa3o Radial Metropolitanas'}, {'amount': 20400000.0, 'label': 'Sistema Integrado de Monitoramento - Trecho Metropolitano'}, {'amount': 38600000.0, 'label': 'Requalifica\\xc3\\xa7\\xc3\\xa3o do Corredor Marechal Floriano - Trecho Municipal'}, {'amount': 51500000.0, 'label': 'Corredor Aeroporto / Rodoferrovi\\xc3\\xa1ria - Trecho Estadual'}], 'label': 'Curitiba'}, {'color': '#d93326', 'amount': 1055554557.98, 'children': [{'amount': 518606000.0, 'label': 'Reforma do Est\\xc3\\xa1dio Governador Pl\\xc3\\xa1cido Castelo (Castel\\xc3\\xa3o)'}, {'amount': 275448557.98, 'label': 'VLT: Parangaba/Mucuripe'}, {'amount': 151600000.0, 'label': 'Eixo Via Expressa/Raul Barbosa'}, {'amount': 41600000.0, 'label': 'BRT Avenida Ded\\xc3\\xa9 Brasil'}, {'amount': 33700000.0, 'label': 'BRT Avenida Alberto Craveiro'}, {'amount': 34600000.0, 'label': 'BRT Avenida Paulino Rocha'}, {'amount': nan, 'label': 'Esta\\xc3\\xa7\\xc3\\xb5es Padre C\\xc3\\xadcero e Juscelino Kubitschek'}], 'label': 'Fortaleza'}, {'color': '#d93526', 'amount': 669500000.0, 'children': [{'amount': 669500000.0, 'label': 'Reconstru\\xc3\\xa7\\xc3\\xa3o da Arena da Amaz\\xc3\\xb4nia'}], 'label': 'Manaus'}, {'color': '#d93826', 'amount': 872247996.91000009, 'children': [{'amount': 400000000.0, 'label': 'Constru\\xc3\\xa7\\xc3\\xa3o da Arena das Dunas'}, {'amount': 73100000.0, 'label': 'Acesso ao Novo Aeroporto de S\\xc3\\xa3o Gon\\xc3\\xa7alo do Amarante'}, {'amount': 370947996.91, 'label': 'Corredor Estruturante \\xe2\\x80\\x93 Zona Norte/Est\\xc3\\xa1dio Arena das Dunas'}, {'amount': 28200000.0, 'label': 'Eixo 2: Implanta\\xc3\\xa7\\xc3\\xa3o da Via Prudente de Morais'}], 'label': 'Natal'}, {'color': '#d93a26', 'amount': 345872222.22000003, 'children': [{'amount': 330000000.0, 'label': 'Reforma do Est\\xc3\\xa1dio Beira Rio'}, {'amount': 8000000.0, 'label': 'Entorno Beira Rio: 3 Vias de Acesso'}, {'amount': 7872222.22, 'label': 'Projeto de Pavimenta\\xc3\\xa7\\xc3\\xa3o do Entorno do  Est\\xc3\\xa1dio Beira-Rio'}], 'label': 'Porto Alegre'}, {'color': '#d93d26', 'amount': 1423272973.73, 'children': [{'amount': 532600000.0, 'label': 'Constru\\xc3\\xa7\\xc3\\xa3o da Arena Pernambuco'}, {'amount': 137000000.0, 'label': 'BRT: Leste/Oeste - Ramal Cidade da Copa'}, {'amount': 180900000.0, 'label': 'BRT: Norte / Sul - Trecho Igarassu / Tacaruna / Centro do Recife'}, {'amount': 88100000.0, 'label': 'Corredor Caxang\\xc3\\xa1 (Leste-Oeste)'}, {'amount': 433202973.73, 'label': 'Corredor da Via Mangue'}, {'amount': 19100000.0, 'label': 'Metr\\xc3\\xb4: Terminal Cosme e Dami\\xc3\\xa3o'}, {'amount': 25000000.0, 'label': 'Entorno Arena Pernambuco: Viaduto da BR-408'}, {'amount': 7370000.0, 'label': 'Entorno Arena Pernambuco: Esta\\xc3\\xa7\\xc3\\xa3o de metr\\xc3\\xb4 Cosme e Dami\\xc3\\xa3o'}], 'label': 'Recife'}]\n"
       ]
      }
     ],
     "prompt_number": 252
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "obras"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>IdEmpreendimento</th>\n",
        "      <th>DescEmpreendimento</th>\n",
        "      <th>IdCidadeSede</th>\n",
        "      <th>IdTema</th>\n",
        "      <th>IdAgrupador</th>\n",
        "      <th>FlgFonteMatriz</th>\n",
        "      <th>FlgDireto</th>\n",
        "      <th>DescObservacao</th>\n",
        "      <th>IdAndamento</th>\n",
        "      <th>FlgAtivo</th>\n",
        "      <th>...</th>\n",
        "      <th>noname_2</th>\n",
        "      <th>noname_3</th>\n",
        "      <th>noname_4</th>\n",
        "      <th>noname_5</th>\n",
        "      <th>noname_6</th>\n",
        "      <th>noname_7</th>\n",
        "      <th>noname_8</th>\n",
        "      <th>noname_9</th>\n",
        "      <th>noname_10</th>\n",
        "      <th>noname_11</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0  </th>\n",
        "      <td>   1</td>\n",
        "      <td> Reforma e adapta\u00e7\u00e3o do Est\u00e1dio Magalh\u00e3es Pinto...</td>\n",
        "      <td>  1</td>\n",
        "      <td>  6</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td> O Est\u00e1dio do Mineir\u00e3o, Governador Magalh\u00e3es Pi...</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 15/01/2013</td>\n",
        "      <td> 100</td>\n",
        "      <td>                 Governo do Estado de Minas Gerais</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 11</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1  </th>\n",
        "      <td>   2</td>\n",
        "      <td>           Reforma do Est\u00e1dio Nacional de Bras\u00edlia</td>\n",
        "      <td>  2</td>\n",
        "      <td>  6</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td> Segundo o Governo do Distrito Federal, o proje...</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 31/10/2013</td>\n",
        "      <td> 100</td>\n",
        "      <td> 5\u00ba Balan\u00e7o da Copa publicado pelo Minist\u00e9rio d...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  7</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2  </th>\n",
        "      <td>   3</td>\n",
        "      <td>             Constru\u00e7\u00e3o da Arena Multiuso Pantanal</td>\n",
        "      <td>  3</td>\n",
        "      <td>  6</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td> Obra executada pelo Governo do Estado de Mato ...</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 31/03/2014</td>\n",
        "      <td>  97</td>\n",
        "      <td>                  Governo do Estado de Mato Grosso</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 13</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3  </th>\n",
        "      <td>   4</td>\n",
        "      <td> Reforma do Est\u00e1dio Governador Pl\u00e1cido Castelo ...</td>\n",
        "      <td>  5</td>\n",
        "      <td>  6</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td> O entorno do est\u00e1dio \u00e9 composto por estacionam...</td>\n",
        "      <td> 3</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 16/12/2012</td>\n",
        "      <td> 100</td>\n",
        "      <td>                        Governo do Estado do Cear\u00e1</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  6</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4  </th>\n",
        "      <td>   5</td>\n",
        "      <td>                 Reconstru\u00e7\u00e3o da Arena da Amaz\u00f4nia</td>\n",
        "      <td>  6</td>\n",
        "      <td>  6</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td> O entorno do est\u00e1dio \u00e9 composto por esplanada ...</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 21/05/2014</td>\n",
        "      <td>  99</td>\n",
        "      <td>  Secretaria de Estado de Infraestrutura - SEINFRA</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  3</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5  </th>\n",
        "      <td>   6</td>\n",
        "      <td>                     Constru\u00e7\u00e3o da Arena das Dunas</td>\n",
        "      <td>  7</td>\n",
        "      <td>  6</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td> O entorno do est\u00e1dio \u00e9 composto por estacionam...</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 30/09/2013</td>\n",
        "      <td>  91</td>\n",
        "      <td> 5\u00ba Balan\u00e7o da Copa publicado pelo Minist\u00e9rio d...</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 20</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6  </th>\n",
        "      <td>   7</td>\n",
        "      <td>                    Constru\u00e7\u00e3o da Arena Pernambuco</td>\n",
        "      <td>  9</td>\n",
        "      <td>  6</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td> O entorno \u00e9 composto por estacionamento e \u00e1rea...</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 15/05/2013</td>\n",
        "      <td> 100</td>\n",
        "      <td>                   Governo do Estado de Pernambuco</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7  </th>\n",
        "      <td>   8</td>\n",
        "      <td>        Terraplenagem do Terminal de Passageiros 3</td>\n",
        "      <td> 12</td>\n",
        "      <td>  1</td>\n",
        "      <td>  5</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 3</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 17/01/2013</td>\n",
        "      <td> 100</td>\n",
        "      <td>                                    Concession\u00e1rio</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 26</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8  </th>\n",
        "      <td>   9</td>\n",
        "      <td> Reforma e Amplia\u00e7\u00e3o do Terminal de Passageiros...</td>\n",
        "      <td>  5</td>\n",
        "      <td>  1</td>\n",
        "      <td> 11</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 28/02/2014</td>\n",
        "      <td>  16</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  6</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9  </th>\n",
        "      <td>  10</td>\n",
        "      <td> Constru\u00e7\u00e3o do Terminal de Passageiros, Sistema...</td>\n",
        "      <td>  7</td>\n",
        "      <td>  1</td>\n",
        "      <td> 13</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 20</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10 </th>\n",
        "      <td>  11</td>\n",
        "      <td> Infraestrutura de Pista de Pouso, Infraestrutu...</td>\n",
        "      <td>  7</td>\n",
        "      <td>  1</td>\n",
        "      <td> 13</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td> EXECU\u00c7\u00c3O 1\u00aa E 2\u00aa ETAPAS\\r\\nO percentual inform...</td>\n",
        "      <td> 3</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 21/02/2014</td>\n",
        "      <td> 100</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 20</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11 </th>\n",
        "      <td>  12</td>\n",
        "      <td>                Terminal de Passageiros 4 (Fase 1)</td>\n",
        "      <td> 12</td>\n",
        "      <td>  1</td>\n",
        "      <td>  5</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 3</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 31/10/2012</td>\n",
        "      <td> 100</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 26</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12 </th>\n",
        "      <td>  15</td>\n",
        "      <td> Reforma  e  Moderniza\u00e7\u00e3o  do  Terminal  de  Pa...</td>\n",
        "      <td>  3</td>\n",
        "      <td>  1</td>\n",
        "      <td> 10</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 30/04/2014</td>\n",
        "      <td>  64</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 13</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13 </th>\n",
        "      <td>  16</td>\n",
        "      <td>                 Implanta\u00e7\u00e3o do M\u00f3dulo Operacional</td>\n",
        "      <td>  3</td>\n",
        "      <td>  1</td>\n",
        "      <td> 10</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 3</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 29/02/2012</td>\n",
        "      <td> 100</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 13</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14 </th>\n",
        "      <td>  18</td>\n",
        "      <td> Reforma e Amplia\u00e7\u00e3o do Terminal de Passageiros...</td>\n",
        "      <td>  6</td>\n",
        "      <td>  1</td>\n",
        "      <td>  9</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 30/04/2014</td>\n",
        "      <td>  89</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  3</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15 </th>\n",
        "      <td>  19</td>\n",
        "      <td> Amplia\u00e7\u00e3o e Revitaliza\u00e7\u00e3o do Sistema de Pistas...</td>\n",
        "      <td> 12</td>\n",
        "      <td>  1</td>\n",
        "      <td>  5</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 3</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 20/03/2012</td>\n",
        "      <td> 100</td>\n",
        "      <td>                                          Infraero</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 26</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16 </th>\n",
        "      <td>  22</td>\n",
        "      <td>            Constru\u00e7\u00e3o do M\u00f3dulo Operacional - MOP</td>\n",
        "      <td> 12</td>\n",
        "      <td>  1</td>\n",
        "      <td>  6</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 26/05/2011</td>\n",
        "      <td> 100</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 26</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17 </th>\n",
        "      <td>  24</td>\n",
        "      <td>           Implanta\u00e7\u00e3o do M\u00f3dulo Operacional \u2013 MOP</td>\n",
        "      <td>  2</td>\n",
        "      <td>  1</td>\n",
        "      <td>  3</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 01/07/2012</td>\n",
        "      <td> 100</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  7</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18 </th>\n",
        "      <td>  26</td>\n",
        "      <td> Reforma e Moderniza\u00e7\u00e3o do Terminal de Passagei...</td>\n",
        "      <td>  1</td>\n",
        "      <td>  1</td>\n",
        "      <td>  1</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 30/04/2014</td>\n",
        "      <td>  47</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 11</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19 </th>\n",
        "      <td>  27</td>\n",
        "      <td> Reforma e Amplia\u00e7\u00e3o da Pista de Pouso e do Sis...</td>\n",
        "      <td>  1</td>\n",
        "      <td>  1</td>\n",
        "      <td>  1</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                           Concluido 100% projetos</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 30/04/2014</td>\n",
        "      <td>  41</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 11</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20 </th>\n",
        "      <td>  30</td>\n",
        "      <td> Amplia\u00e7\u00e3o do Terminal de Passageiros e Amplia\u00e7...</td>\n",
        "      <td>  4</td>\n",
        "      <td>  1</td>\n",
        "      <td>  2</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 30/04/2014</td>\n",
        "      <td>  25</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 18</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21 </th>\n",
        "      <td>  32</td>\n",
        "      <td> Amplia\u00e7\u00e3o do Sistema de Pistas e P\u00e1tios, Infra...</td>\n",
        "      <td>  4</td>\n",
        "      <td>  1</td>\n",
        "      <td>  2</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 28/02/2014</td>\n",
        "      <td>  98</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 18</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22 </th>\n",
        "      <td>  33</td>\n",
        "      <td> Restaura\u00e7\u00e3o das Pistas de Pouso e Decolagem e ...</td>\n",
        "      <td>  4</td>\n",
        "      <td>  1</td>\n",
        "      <td>  2</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 3</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 31/07/2012</td>\n",
        "      <td> 100</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 18</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23 </th>\n",
        "      <td>  34</td>\n",
        "      <td> Reforma do Terminal de Passageiros 1 e Obras C...</td>\n",
        "      <td> 10</td>\n",
        "      <td>  1</td>\n",
        "      <td>  8</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 30/04/2014</td>\n",
        "      <td>  53</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 19</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24 </th>\n",
        "      <td>  35</td>\n",
        "      <td>              Reforma do Terminal de Passageiros 2</td>\n",
        "      <td> 10</td>\n",
        "      <td>  1</td>\n",
        "      <td>  8</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 30/04/2014</td>\n",
        "      <td>  81</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 19</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25 </th>\n",
        "      <td>  36</td>\n",
        "      <td> Recupera\u00e7\u00e3o e revitaliza\u00e7\u00e3o dos sistemas de pi...</td>\n",
        "      <td> 10</td>\n",
        "      <td>  1</td>\n",
        "      <td>  8</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 3</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 16/03/2014</td>\n",
        "      <td> 100</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 19</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>26 </th>\n",
        "      <td>  37</td>\n",
        "      <td>    Reforma e Adequa\u00e7\u00e3o do Terminal de Passageiros</td>\n",
        "      <td> 11</td>\n",
        "      <td>  1</td>\n",
        "      <td>  4</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 30/04/2014</td>\n",
        "      <td>  56</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>27 </th>\n",
        "      <td>  38</td>\n",
        "      <td>                   Amplia\u00e7\u00e3o do P\u00e1tio de Aeronaves</td>\n",
        "      <td> 11</td>\n",
        "      <td>  1</td>\n",
        "      <td>  4</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 3</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 30/09/2013</td>\n",
        "      <td> 100</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>28 </th>\n",
        "      <td>  39</td>\n",
        "      <td>                   Constru\u00e7\u00e3o de Torre de Controle</td>\n",
        "      <td> 11</td>\n",
        "      <td>  1</td>\n",
        "      <td>  4</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 30/04/2014</td>\n",
        "      <td>  97</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>29 </th>\n",
        "      <td>  40</td>\n",
        "      <td> Reforma e Amplia\u00e7\u00e3o do Terminal de Passageiros...</td>\n",
        "      <td>  8</td>\n",
        "      <td>  1</td>\n",
        "      <td> 12</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td> Executado 100% em 01/12/2013 da amplia\u00e7\u00e3o da \u00c1...</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 30/04/2014</td>\n",
        "      <td>   2</td>\n",
        "      <td>                                          INFRAERO</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 23</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  5</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>...</th>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>294</th>\n",
        "      <td> 615</td>\n",
        "      <td> Sinaliza\u00e7\u00e3o Tur\u00edstica nos atrativos tur\u00edsticos...</td>\n",
        "      <td>  4</td>\n",
        "      <td>  4</td>\n",
        "      <td> 24</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 1</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>295</th>\n",
        "      <td> 620</td>\n",
        "      <td> Acessibilidade nos atrativos tur\u00edsticos - S\u00e3o ...</td>\n",
        "      <td> 12</td>\n",
        "      <td>  4</td>\n",
        "      <td> 24</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td> Implanta\u00e7\u00e3o de infraestrutura de acessibilidad...</td>\n",
        "      <td> 1</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>296</th>\n",
        "      <td> 621</td>\n",
        "      <td> Sinaliza\u00e7\u00e3o Tur\u00edstica nos atrativos tur\u00edsticos...</td>\n",
        "      <td> 12</td>\n",
        "      <td>  4</td>\n",
        "      <td> 24</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>    Sinaliza\u00e7\u00e3o tur\u00edstica dos atrativos principais</td>\n",
        "      <td> 1</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>297</th>\n",
        "      <td> 646</td>\n",
        "      <td> A\u00e7\u00f5es de promo\u00e7\u00e3o do Brasil como destino tur\u00eds...</td>\n",
        "      <td> 14</td>\n",
        "      <td> 18</td>\n",
        "      <td> 30</td>\n",
        "      <td> False</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td> Os eventos visam divulgar o potencial tur\u00edstic...</td>\n",
        "      <td> 3</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 11/03/2014</td>\n",
        "      <td> 100</td>\n",
        "      <td>                                          EMBRATUR</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>298</th>\n",
        "      <td> 647</td>\n",
        "      <td>                Sistema de P\u00e1tios e Pistas de T\u00e1xi</td>\n",
        "      <td>  8</td>\n",
        "      <td>  1</td>\n",
        "      <td> 12</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 30/04/2014</td>\n",
        "      <td>  42</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>299</th>\n",
        "      <td> 651</td>\n",
        "      <td> Aquisi\u00e7\u00e3o de solu\u00e7\u00e3o para integra\u00e7\u00e3o dos siste...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 14</td>\n",
        "      <td> 15</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td> Secretaria Extraordin\u00e1ria de Seguran\u00e7a para Gr...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>300</th>\n",
        "      <td> 655</td>\n",
        "      <td> Implanta\u00e7\u00e3o de hotel no bairro do Leme, Munic\u00ed...</td>\n",
        "      <td> 10</td>\n",
        "      <td>  4</td>\n",
        "      <td> 22</td>\n",
        "      <td> False</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 16/04/2014</td>\n",
        "      <td>  13</td>\n",
        "      <td>                            Arena Leme Hotel Ltda.</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>301</th>\n",
        "      <td> 656</td>\n",
        "      <td> Implanta\u00e7\u00e3o de hotel de padr\u00e3o upscale, na Bar...</td>\n",
        "      <td> 10</td>\n",
        "      <td>  4</td>\n",
        "      <td> 22</td>\n",
        "      <td> False</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 12/05/2014</td>\n",
        "      <td>  58</td>\n",
        "      <td>                   Windsor Mar da Barra Hotel Ltda</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>302</th>\n",
        "      <td> 657</td>\n",
        "      <td> Implanta\u00e7\u00e3o de hotel de padr\u00e3o budget em Porto...</td>\n",
        "      <td>  8</td>\n",
        "      <td>  4</td>\n",
        "      <td> 22</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td> 16/04/2014</td>\n",
        "      <td>  78</td>\n",
        "      <td>                       Hotelaria Accor Brasil S.A.</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>303</th>\n",
        "      <td> 659</td>\n",
        "      <td> Implanta\u00e7\u00e3o, Reforma e Adequa\u00e7\u00e3o de Centros de...</td>\n",
        "      <td> 10</td>\n",
        "      <td>  4</td>\n",
        "      <td> 24</td>\n",
        "      <td>  True</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                          Distrato</td>\n",
        "      <td> 1</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>304</th>\n",
        "      <td> 661</td>\n",
        "      <td> A\u00e7\u00f5es de Seguran\u00e7a P\u00fablica - Secretaria de Seg...</td>\n",
        "      <td> 10</td>\n",
        "      <td> 14</td>\n",
        "      <td> 25</td>\n",
        "      <td> False</td>\n",
        "      <td>  TRUE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>305</th>\n",
        "      <td> 663</td>\n",
        "      <td>           Adequa\u00e7\u00e3o e Reforma do Estadio Rei Pel\u00e9</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>306</th>\n",
        "      <td> 664</td>\n",
        "      <td> Constru\u00e7\u00e3o do Centro de Treinamento de Sele\u00e7\u00f5e...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>307</th>\n",
        "      <td> 665</td>\n",
        "      <td> Aquisi\u00e7\u00e3o de equipamentos e de servi\u00e7os para m...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>308</th>\n",
        "      <td> 666</td>\n",
        "      <td>      Reforma do Est\u00e1dio Municipal de Porto Seguro</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>309</th>\n",
        "      <td> 667</td>\n",
        "      <td> Revitaliza\u00e7\u00e3o e Reforma do Est\u00e1dio Ant\u00f4nio Oto...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>310</th>\n",
        "      <td> 668</td>\n",
        "      <td> Reforma e Revitaliza\u00e7\u00e3o do Est\u00e1dio Elmo Serejo...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>311</th>\n",
        "      <td> 669</td>\n",
        "      <td> Reforma e Revitaliza\u00e7\u00e3o do Est\u00e1dio Valmir Camp...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>312</th>\n",
        "      <td> 670</td>\n",
        "      <td>   Reforma e moderniza\u00e7\u00e3o do Est\u00e1dio Serra Dourada</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>313</th>\n",
        "      <td> 671</td>\n",
        "      <td> Reforma, Melhoria e Adapta\u00e7\u00e3o do Est\u00e1dio Munic...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>314</th>\n",
        "      <td> 672</td>\n",
        "      <td> Reforma do Est\u00e1dio Municipal Radialista M\u00e1rio ...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>315</th>\n",
        "      <td> 673</td>\n",
        "      <td> Implanta\u00e7\u00e3o e Moderniza\u00e7\u00e3o do Centro Oficial d...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>316</th>\n",
        "      <td> 674</td>\n",
        "      <td> Implanta\u00e7\u00e3o e Moderniza\u00e7\u00e3o do Centro Oficial d...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>317</th>\n",
        "      <td> 675</td>\n",
        "      <td>             Melhorias no Est\u00e1dio Ol\u00edmpico do Par\u00e1</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>318</th>\n",
        "      <td> 676</td>\n",
        "      <td> Obras de adequa\u00e7\u00e3o do Est\u00e1dio General Sylvio R...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>319</th>\n",
        "      <td> 677</td>\n",
        "      <td> Implanta\u00e7\u00e3o de Melhorias no Centro de Treiname...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>320</th>\n",
        "      <td> 678</td>\n",
        "      <td> Amplia\u00e7\u00e3o dos vesti\u00e1rios atuais e constru\u00e7\u00e3o d...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>321</th>\n",
        "      <td> 679</td>\n",
        "      <td> Reforma, Estrutura\u00e7\u00e3o e Aquisi\u00e7\u00e3o de Equipamen...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>322</th>\n",
        "      <td> 680</td>\n",
        "      <td> Constru\u00e7\u00e3o de Alojamento e Centro de Imprensa ...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>323</th>\n",
        "      <td> 681</td>\n",
        "      <td> Promo\u00e7\u00e3o de melhorias nos Centros de Treinamen...</td>\n",
        "      <td> 13</td>\n",
        "      <td> 16</td>\n",
        "      <td>NaN</td>\n",
        "      <td> False</td>\n",
        "      <td> FALSE</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td> 2</td>\n",
        "      <td> TRUE</td>\n",
        "      <td>...</td>\n",
        "      <td>        NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>324 rows \u00d7 29 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 291,
       "text": [
        "    IdEmpreendimento                                 DescEmpreendimento  \\\n",
        "0                  1  Reforma e adapta\u00e7\u00e3o do Est\u00e1dio Magalh\u00e3es Pinto...   \n",
        "1                  2            Reforma do Est\u00e1dio Nacional de Bras\u00edlia   \n",
        "2                  3              Constru\u00e7\u00e3o da Arena Multiuso Pantanal   \n",
        "3                  4  Reforma do Est\u00e1dio Governador Pl\u00e1cido Castelo ...   \n",
        "4                  5                  Reconstru\u00e7\u00e3o da Arena da Amaz\u00f4nia   \n",
        "5                  6                      Constru\u00e7\u00e3o da Arena das Dunas   \n",
        "6                  7                     Constru\u00e7\u00e3o da Arena Pernambuco   \n",
        "7                  8         Terraplenagem do Terminal de Passageiros 3   \n",
        "8                  9  Reforma e Amplia\u00e7\u00e3o do Terminal de Passageiros...   \n",
        "9                 10  Constru\u00e7\u00e3o do Terminal de Passageiros, Sistema...   \n",
        "10                11  Infraestrutura de Pista de Pouso, Infraestrutu...   \n",
        "11                12                 Terminal de Passageiros 4 (Fase 1)   \n",
        "12                15  Reforma  e  Moderniza\u00e7\u00e3o  do  Terminal  de  Pa...   \n",
        "13                16                  Implanta\u00e7\u00e3o do M\u00f3dulo Operacional   \n",
        "14                18  Reforma e Amplia\u00e7\u00e3o do Terminal de Passageiros...   \n",
        "15                19  Amplia\u00e7\u00e3o e Revitaliza\u00e7\u00e3o do Sistema de Pistas...   \n",
        "16                22             Constru\u00e7\u00e3o do M\u00f3dulo Operacional - MOP   \n",
        "17                24            Implanta\u00e7\u00e3o do M\u00f3dulo Operacional \u2013 MOP   \n",
        "18                26  Reforma e Moderniza\u00e7\u00e3o do Terminal de Passagei...   \n",
        "19                27  Reforma e Amplia\u00e7\u00e3o da Pista de Pouso e do Sis...   \n",
        "20                30  Amplia\u00e7\u00e3o do Terminal de Passageiros e Amplia\u00e7...   \n",
        "21                32  Amplia\u00e7\u00e3o do Sistema de Pistas e P\u00e1tios, Infra...   \n",
        "22                33  Restaura\u00e7\u00e3o das Pistas de Pouso e Decolagem e ...   \n",
        "23                34  Reforma do Terminal de Passageiros 1 e Obras C...   \n",
        "24                35               Reforma do Terminal de Passageiros 2   \n",
        "25                36  Recupera\u00e7\u00e3o e revitaliza\u00e7\u00e3o dos sistemas de pi...   \n",
        "26                37     Reforma e Adequa\u00e7\u00e3o do Terminal de Passageiros   \n",
        "27                38                    Amplia\u00e7\u00e3o do P\u00e1tio de Aeronaves   \n",
        "28                39                    Constru\u00e7\u00e3o de Torre de Controle   \n",
        "29                40  Reforma e Amplia\u00e7\u00e3o do Terminal de Passageiros...   \n",
        "..               ...                                                ...   \n",
        "294              615  Sinaliza\u00e7\u00e3o Tur\u00edstica nos atrativos tur\u00edsticos...   \n",
        "295              620  Acessibilidade nos atrativos tur\u00edsticos - S\u00e3o ...   \n",
        "296              621  Sinaliza\u00e7\u00e3o Tur\u00edstica nos atrativos tur\u00edsticos...   \n",
        "297              646  A\u00e7\u00f5es de promo\u00e7\u00e3o do Brasil como destino tur\u00eds...   \n",
        "298              647                 Sistema de P\u00e1tios e Pistas de T\u00e1xi   \n",
        "299              651  Aquisi\u00e7\u00e3o de solu\u00e7\u00e3o para integra\u00e7\u00e3o dos siste...   \n",
        "300              655  Implanta\u00e7\u00e3o de hotel no bairro do Leme, Munic\u00ed...   \n",
        "301              656  Implanta\u00e7\u00e3o de hotel de padr\u00e3o upscale, na Bar...   \n",
        "302              657  Implanta\u00e7\u00e3o de hotel de padr\u00e3o budget em Porto...   \n",
        "303              659  Implanta\u00e7\u00e3o, Reforma e Adequa\u00e7\u00e3o de Centros de...   \n",
        "304              661  A\u00e7\u00f5es de Seguran\u00e7a P\u00fablica - Secretaria de Seg...   \n",
        "305              663            Adequa\u00e7\u00e3o e Reforma do Estadio Rei Pel\u00e9   \n",
        "306              664  Constru\u00e7\u00e3o do Centro de Treinamento de Sele\u00e7\u00f5e...   \n",
        "307              665  Aquisi\u00e7\u00e3o de equipamentos e de servi\u00e7os para m...   \n",
        "308              666       Reforma do Est\u00e1dio Municipal de Porto Seguro   \n",
        "309              667  Revitaliza\u00e7\u00e3o e Reforma do Est\u00e1dio Ant\u00f4nio Oto...   \n",
        "310              668  Reforma e Revitaliza\u00e7\u00e3o do Est\u00e1dio Elmo Serejo...   \n",
        "311              669  Reforma e Revitaliza\u00e7\u00e3o do Est\u00e1dio Valmir Camp...   \n",
        "312              670    Reforma e moderniza\u00e7\u00e3o do Est\u00e1dio Serra Dourada   \n",
        "313              671  Reforma, Melhoria e Adapta\u00e7\u00e3o do Est\u00e1dio Munic...   \n",
        "314              672  Reforma do Est\u00e1dio Municipal Radialista M\u00e1rio ...   \n",
        "315              673  Implanta\u00e7\u00e3o e Moderniza\u00e7\u00e3o do Centro Oficial d...   \n",
        "316              674  Implanta\u00e7\u00e3o e Moderniza\u00e7\u00e3o do Centro Oficial d...   \n",
        "317              675              Melhorias no Est\u00e1dio Ol\u00edmpico do Par\u00e1   \n",
        "318              676  Obras de adequa\u00e7\u00e3o do Est\u00e1dio General Sylvio R...   \n",
        "319              677  Implanta\u00e7\u00e3o de Melhorias no Centro de Treiname...   \n",
        "320              678  Amplia\u00e7\u00e3o dos vesti\u00e1rios atuais e constru\u00e7\u00e3o d...   \n",
        "321              679  Reforma, Estrutura\u00e7\u00e3o e Aquisi\u00e7\u00e3o de Equipamen...   \n",
        "322              680  Constru\u00e7\u00e3o de Alojamento e Centro de Imprensa ...   \n",
        "323              681  Promo\u00e7\u00e3o de melhorias nos Centros de Treinamen...   \n",
        "\n",
        "    IdCidadeSede  IdTema  IdAgrupador FlgFonteMatriz FlgDireto  \\\n",
        "0              1       6          NaN           True      TRUE   \n",
        "1              2       6          NaN           True      TRUE   \n",
        "2              3       6          NaN           True      TRUE   \n",
        "3              5       6          NaN           True      TRUE   \n",
        "4              6       6          NaN           True      TRUE   \n",
        "5              7       6          NaN           True      TRUE   \n",
        "6              9       6          NaN           True      TRUE   \n",
        "7             12       1            5           True      TRUE   \n",
        "8              5       1           11           True      TRUE   \n",
        "9              7       1           13           True      TRUE   \n",
        "10             7       1           13           True      TRUE   \n",
        "11            12       1            5           True      TRUE   \n",
        "12             3       1           10           True      TRUE   \n",
        "13             3       1           10           True      TRUE   \n",
        "14             6       1            9           True      TRUE   \n",
        "15            12       1            5           True      TRUE   \n",
        "16            12       1            6           True      TRUE   \n",
        "17             2       1            3           True      TRUE   \n",
        "18             1       1            1           True      TRUE   \n",
        "19             1       1            1           True      TRUE   \n",
        "20             4       1            2           True      TRUE   \n",
        "21             4       1            2           True      TRUE   \n",
        "22             4       1            2           True      TRUE   \n",
        "23            10       1            8           True      TRUE   \n",
        "24            10       1            8           True      TRUE   \n",
        "25            10       1            8           True      TRUE   \n",
        "26            11       1            4           True      TRUE   \n",
        "27            11       1            4           True      TRUE   \n",
        "28            11       1            4           True      TRUE   \n",
        "29             8       1           12           True      TRUE   \n",
        "..           ...     ...          ...            ...       ...   \n",
        "294            4       4           24           True      TRUE   \n",
        "295           12       4           24           True      TRUE   \n",
        "296           12       4           24           True      TRUE   \n",
        "297           14      18           30          False      TRUE   \n",
        "298            8       1           12           True      TRUE   \n",
        "299           13      14           15           True      TRUE   \n",
        "300           10       4           22          False      TRUE   \n",
        "301           10       4           22          False      TRUE   \n",
        "302            8       4           22          False     FALSE   \n",
        "303           10       4           24           True      TRUE   \n",
        "304           10      14           25          False      TRUE   \n",
        "305           13      16          NaN          False     FALSE   \n",
        "306           13      16          NaN          False     FALSE   \n",
        "307           13      16          NaN          False     FALSE   \n",
        "308           13      16          NaN          False     FALSE   \n",
        "309           13      16          NaN          False     FALSE   \n",
        "310           13      16          NaN          False     FALSE   \n",
        "311           13      16          NaN          False     FALSE   \n",
        "312           13      16          NaN          False     FALSE   \n",
        "313           13      16          NaN          False     FALSE   \n",
        "314           13      16          NaN          False     FALSE   \n",
        "315           13      16          NaN          False     FALSE   \n",
        "316           13      16          NaN          False     FALSE   \n",
        "317           13      16          NaN          False     FALSE   \n",
        "318           13      16          NaN          False     FALSE   \n",
        "319           13      16          NaN          False     FALSE   \n",
        "320           13      16          NaN          False     FALSE   \n",
        "321           13      16          NaN          False     FALSE   \n",
        "322           13      16          NaN          False     FALSE   \n",
        "323           13      16          NaN          False     FALSE   \n",
        "\n",
        "                                        DescObservacao  IdAndamento FlgAtivo  \\\n",
        "0    O Est\u00e1dio do Mineir\u00e3o, Governador Magalh\u00e3es Pi...            2     TRUE   \n",
        "1    Segundo o Governo do Distrito Federal, o proje...            2     TRUE   \n",
        "2    Obra executada pelo Governo do Estado de Mato ...            2     TRUE   \n",
        "3    O entorno do est\u00e1dio \u00e9 composto por estacionam...            3     TRUE   \n",
        "4    O entorno do est\u00e1dio \u00e9 composto por esplanada ...            2     TRUE   \n",
        "5    O entorno do est\u00e1dio \u00e9 composto por estacionam...            2     TRUE   \n",
        "6    O entorno \u00e9 composto por estacionamento e \u00e1rea...            2     TRUE   \n",
        "7                                                  NaN            3     TRUE   \n",
        "8                                                  NaN            2     TRUE   \n",
        "9                                                  NaN            2     TRUE   \n",
        "10   EXECU\u00c7\u00c3O 1\u00aa E 2\u00aa ETAPAS\\r\\nO percentual inform...            3     TRUE   \n",
        "11                                                 NaN            3     TRUE   \n",
        "12                                                 NaN            2     TRUE   \n",
        "13                                                 NaN            3     TRUE   \n",
        "14                                                 NaN            2     TRUE   \n",
        "15                                                 NaN            3     TRUE   \n",
        "16                                                 NaN            2     TRUE   \n",
        "17                                                 NaN            2     TRUE   \n",
        "18                                                 NaN            2     TRUE   \n",
        "19                             Concluido 100% projetos            2     TRUE   \n",
        "20                                                 NaN            2     TRUE   \n",
        "21                                                 NaN            2     TRUE   \n",
        "22                                                 NaN            3     TRUE   \n",
        "23                                                 NaN            2     TRUE   \n",
        "24                                                 NaN            2     TRUE   \n",
        "25                                                 NaN            3     TRUE   \n",
        "26                                                 NaN            2     TRUE   \n",
        "27                                                 NaN            3     TRUE   \n",
        "28                                                 NaN            2     TRUE   \n",
        "29   Executado 100% em 01/12/2013 da amplia\u00e7\u00e3o da \u00c1...            2     TRUE   \n",
        "..                                                 ...          ...      ...   \n",
        "294                                                NaN            1     TRUE   \n",
        "295  Implanta\u00e7\u00e3o de infraestrutura de acessibilidad...            1     TRUE   \n",
        "296     Sinaliza\u00e7\u00e3o tur\u00edstica dos atrativos principais            1     TRUE   \n",
        "297  Os eventos visam divulgar o potencial tur\u00edstic...            3     TRUE   \n",
        "298                                                NaN            2     TRUE   \n",
        "299                                                NaN            2     TRUE   \n",
        "300                                                NaN            2     TRUE   \n",
        "301                                                NaN            2     TRUE   \n",
        "302                                                NaN            2     TRUE   \n",
        "303                                           Distrato            1     TRUE   \n",
        "304                                                NaN            2     TRUE   \n",
        "305                                                NaN            2     TRUE   \n",
        "306                                                NaN            2     TRUE   \n",
        "307                                                NaN            2     TRUE   \n",
        "308                                                NaN            2     TRUE   \n",
        "309                                                NaN            2     TRUE   \n",
        "310                                                NaN            2     TRUE   \n",
        "311                                                NaN            2     TRUE   \n",
        "312                                                NaN            2     TRUE   \n",
        "313                                                NaN            2     TRUE   \n",
        "314                                                NaN            2     TRUE   \n",
        "315                                                NaN            2     TRUE   \n",
        "316                                                NaN            2     TRUE   \n",
        "317                                                NaN            2     TRUE   \n",
        "318                                                NaN            2     TRUE   \n",
        "319                                                NaN            2     TRUE   \n",
        "320                                                NaN            2     TRUE   \n",
        "321                                                NaN            2     TRUE   \n",
        "322                                                NaN            2     TRUE   \n",
        "323                                                NaN            2     TRUE   \n",
        "\n",
        "      ...       noname_2 noname_3  \\\n",
        "0     ...     15/01/2013      100   \n",
        "1     ...     31/10/2013      100   \n",
        "2     ...     31/03/2014       97   \n",
        "3     ...     16/12/2012      100   \n",
        "4     ...     21/05/2014       99   \n",
        "5     ...     30/09/2013       91   \n",
        "6     ...     15/05/2013      100   \n",
        "7     ...     17/01/2013      100   \n",
        "8     ...     28/02/2014       16   \n",
        "9     ...            NaN      NaN   \n",
        "10    ...     21/02/2014      100   \n",
        "11    ...     31/10/2012      100   \n",
        "12    ...     30/04/2014       64   \n",
        "13    ...     29/02/2012      100   \n",
        "14    ...     30/04/2014       89   \n",
        "15    ...     20/03/2012      100   \n",
        "16    ...     26/05/2011      100   \n",
        "17    ...     01/07/2012      100   \n",
        "18    ...     30/04/2014       47   \n",
        "19    ...     30/04/2014       41   \n",
        "20    ...     30/04/2014       25   \n",
        "21    ...     28/02/2014       98   \n",
        "22    ...     31/07/2012      100   \n",
        "23    ...     30/04/2014       53   \n",
        "24    ...     30/04/2014       81   \n",
        "25    ...     16/03/2014      100   \n",
        "26    ...     30/04/2014       56   \n",
        "27    ...     30/09/2013      100   \n",
        "28    ...     30/04/2014       97   \n",
        "29    ...     30/04/2014        2   \n",
        "..    ...            ...      ...   \n",
        "294   ...            NaN      NaN   \n",
        "295   ...            NaN      NaN   \n",
        "296   ...            NaN      NaN   \n",
        "297   ...     11/03/2014      100   \n",
        "298   ...     30/04/2014       42   \n",
        "299   ...            NaN      NaN   \n",
        "300   ...     16/04/2014       13   \n",
        "301   ...     12/05/2014       58   \n",
        "302   ...     16/04/2014       78   \n",
        "303   ...            NaN      NaN   \n",
        "304   ...            NaN      NaN   \n",
        "305   ...            NaN      NaN   \n",
        "306   ...            NaN      NaN   \n",
        "307   ...            NaN      NaN   \n",
        "308   ...            NaN      NaN   \n",
        "309   ...            NaN      NaN   \n",
        "310   ...            NaN      NaN   \n",
        "311   ...            NaN      NaN   \n",
        "312   ...            NaN      NaN   \n",
        "313   ...            NaN      NaN   \n",
        "314   ...            NaN      NaN   \n",
        "315   ...            NaN      NaN   \n",
        "316   ...            NaN      NaN   \n",
        "317   ...            NaN      NaN   \n",
        "318   ...            NaN      NaN   \n",
        "319   ...            NaN      NaN   \n",
        "320   ...            NaN      NaN   \n",
        "321   ...            NaN      NaN   \n",
        "322   ...            NaN      NaN   \n",
        "323   ...            NaN      NaN   \n",
        "\n",
        "                                              noname_4 noname_5 noname_6  \\\n",
        "0                    Governo do Estado de Minas Gerais      NaN       11   \n",
        "1    5\u00ba Balan\u00e7o da Copa publicado pelo Minist\u00e9rio d...      NaN        7   \n",
        "2                     Governo do Estado de Mato Grosso      NaN       13   \n",
        "3                           Governo do Estado do Cear\u00e1      NaN        6   \n",
        "4     Secretaria de Estado de Infraestrutura - SEINFRA      NaN        3   \n",
        "5    5\u00ba Balan\u00e7o da Copa publicado pelo Minist\u00e9rio d...      NaN       20   \n",
        "6                      Governo do Estado de Pernambuco      NaN       16   \n",
        "7                                       Concession\u00e1rio      NaN       26   \n",
        "8                                             INFRAERO      NaN        6   \n",
        "9                                                  NaN      NaN       20   \n",
        "10                                            INFRAERO      NaN       20   \n",
        "11                                            INFRAERO      NaN       26   \n",
        "12                                            INFRAERO      NaN       13   \n",
        "13                                            INFRAERO      NaN       13   \n",
        "14                                            INFRAERO      NaN        3   \n",
        "15                                            Infraero      NaN       26   \n",
        "16                                                 NaN      NaN       26   \n",
        "17                                            INFRAERO      NaN        7   \n",
        "18                                            INFRAERO      NaN       11   \n",
        "19                                            INFRAERO      NaN       11   \n",
        "20                                            INFRAERO      NaN       18   \n",
        "21                                            INFRAERO      NaN       18   \n",
        "22                                                 NaN      NaN       18   \n",
        "23                                            INFRAERO      NaN       19   \n",
        "24                                            INFRAERO      NaN       19   \n",
        "25                                            INFRAERO      NaN       19   \n",
        "26                                            INFRAERO      NaN        5   \n",
        "27                                            INFRAERO      NaN        5   \n",
        "28                                            INFRAERO      NaN        5   \n",
        "29                                            INFRAERO      NaN       23   \n",
        "..                                                 ...      ...      ...   \n",
        "294                                                NaN      NaN      NaN   \n",
        "295                                                NaN      NaN      NaN   \n",
        "296                                                NaN      NaN      NaN   \n",
        "297                                           EMBRATUR      NaN      NaN   \n",
        "298                                                NaN      NaN      NaN   \n",
        "299  Secretaria Extraordin\u00e1ria de Seguran\u00e7a para Gr...      NaN      NaN   \n",
        "300                             Arena Leme Hotel Ltda.      NaN      NaN   \n",
        "301                    Windsor Mar da Barra Hotel Ltda      NaN      NaN   \n",
        "302                        Hotelaria Accor Brasil S.A.      NaN      NaN   \n",
        "303                                                NaN      NaN      NaN   \n",
        "304                                                NaN      NaN      NaN   \n",
        "305                                                NaN      NaN      NaN   \n",
        "306                                                NaN      NaN      NaN   \n",
        "307                                                NaN      NaN      NaN   \n",
        "308                                                NaN      NaN      NaN   \n",
        "309                                                NaN      NaN      NaN   \n",
        "310                                                NaN      NaN      NaN   \n",
        "311                                                NaN      NaN      NaN   \n",
        "312                                                NaN      NaN      NaN   \n",
        "313                                                NaN      NaN      NaN   \n",
        "314                                                NaN      NaN      NaN   \n",
        "315                                                NaN      NaN      NaN   \n",
        "316                                                NaN      NaN      NaN   \n",
        "317                                                NaN      NaN      NaN   \n",
        "318                                                NaN      NaN      NaN   \n",
        "319                                                NaN      NaN      NaN   \n",
        "320                                                NaN      NaN      NaN   \n",
        "321                                                NaN      NaN      NaN   \n",
        "322                                                NaN      NaN      NaN   \n",
        "323                                                NaN      NaN      NaN   \n",
        "\n",
        "     noname_7  noname_8  noname_9  noname_10 noname_11  \n",
        "0         NaN       NaN         1        NaN       NaN  \n",
        "1         NaN       NaN         1        NaN       NaN  \n",
        "2         NaN       NaN         1        NaN       NaN  \n",
        "3         NaN       NaN         1        NaN       NaN  \n",
        "4         NaN       NaN         1        NaN       NaN  \n",
        "5         NaN       NaN         1        NaN       NaN  \n",
        "6         NaN       NaN         1        NaN       NaN  \n",
        "7         NaN       NaN         5        NaN       NaN  \n",
        "8         NaN       NaN         5        NaN       NaN  \n",
        "9         NaN       NaN         5        NaN       NaN  \n",
        "10        NaN       NaN         5        NaN       NaN  \n",
        "11        NaN       NaN         5        NaN       NaN  \n",
        "12        NaN       NaN         5        NaN       NaN  \n",
        "13        NaN       NaN         5        NaN       NaN  \n",
        "14        NaN       NaN         5        NaN       NaN  \n",
        "15        NaN       NaN         5        NaN       NaN  \n",
        "16        NaN       NaN         5        NaN       NaN  \n",
        "17        NaN       NaN         5        NaN       NaN  \n",
        "18        NaN       NaN         5        NaN       NaN  \n",
        "19        NaN       NaN         5        NaN       NaN  \n",
        "20        NaN       NaN         5        NaN       NaN  \n",
        "21        NaN       NaN         5        NaN       NaN  \n",
        "22        NaN       NaN         5        NaN       NaN  \n",
        "23        NaN       NaN         5        NaN       NaN  \n",
        "24        NaN       NaN         5        NaN       NaN  \n",
        "25        NaN       NaN         5        NaN       NaN  \n",
        "26        NaN       NaN         5        NaN       NaN  \n",
        "27        NaN       NaN         5        NaN       NaN  \n",
        "28        NaN       NaN         5        NaN       NaN  \n",
        "29        NaN       NaN         5        NaN       NaN  \n",
        "..        ...       ...       ...        ...       ...  \n",
        "294       NaN       NaN       NaN        NaN       NaN  \n",
        "295       NaN       NaN       NaN        NaN       NaN  \n",
        "296       NaN       NaN       NaN        NaN       NaN  \n",
        "297       NaN       NaN       NaN        NaN       NaN  \n",
        "298       NaN       NaN       NaN        NaN       NaN  \n",
        "299       NaN       NaN       NaN        NaN       NaN  \n",
        "300       NaN       NaN       NaN        NaN       NaN  \n",
        "301       NaN       NaN       NaN        NaN       NaN  \n",
        "302       NaN       NaN       NaN        NaN       NaN  \n",
        "303       NaN       NaN       NaN        NaN       NaN  \n",
        "304       NaN       NaN       NaN        NaN       NaN  \n",
        "305       NaN       NaN       NaN        NaN       NaN  \n",
        "306       NaN       NaN       NaN        NaN       NaN  \n",
        "307       NaN       NaN       NaN        NaN       NaN  \n",
        "308       NaN       NaN       NaN        NaN       NaN  \n",
        "309       NaN       NaN       NaN        NaN       NaN  \n",
        "310       NaN       NaN       NaN        NaN       NaN  \n",
        "311       NaN       NaN       NaN        NaN       NaN  \n",
        "312       NaN       NaN       NaN        NaN       NaN  \n",
        "313       NaN       NaN       NaN        NaN       NaN  \n",
        "314       NaN       NaN       NaN        NaN       NaN  \n",
        "315       NaN       NaN       NaN        NaN       NaN  \n",
        "316       NaN       NaN       NaN        NaN       NaN  \n",
        "317       NaN       NaN       NaN        NaN       NaN  \n",
        "318       NaN       NaN       NaN        NaN       NaN  \n",
        "319       NaN       NaN       NaN        NaN       NaN  \n",
        "320       NaN       NaN       NaN        NaN       NaN  \n",
        "321       NaN       NaN       NaN        NaN       NaN  \n",
        "322       NaN       NaN       NaN        NaN       NaN  \n",
        "323       NaN       NaN       NaN        NaN       NaN  \n",
        "\n",
        "[324 rows x 29 columns]"
       ]
      }
     ],
     "prompt_number": 291
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": []
    }
   ],
   "metadata": {}
  }
 ]
}