projetos/roboprojetos.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# -*- coding: utf-8\n",
    "# Repórter Brasil (http://ruralometro.reporterbrasil.org.br/)\n",
    "# Reinaldo Chaves (@paidatocandeira)\n",
    "# Programa para encontrar que projetos de lei têm autoria de deputados eleitos em 2014. Acessa a API da Câmara para isso\n",
    "#"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Documentação: dadosabertos.camara.leg.br/swagger/api.html"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "prefixo = 'https://dadosabertos.camara.leg.br/api/v2/proposicoes/'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>n_projeto</th>\n",
       "      <th>autor</th>\n",
       "      <th>ementa</th>\n",
       "      <th>resumo</th>\n",
       "      <th>votacao_nominal</th>\n",
       "      <th>votacao_nominal_alternativa_emenda</th>\n",
       "      <th>link_votacao</th>\n",
       "      <th>observacao</th>\n",
       "      <th>link_emenda</th>\n",
       "      <th>indicado_por</th>\n",
       "      <th>entidade_que_avalia</th>\n",
       "      <th>favoravel_desfavoravel_indiferente</th>\n",
       "      <th>explicacao</th>\n",
       "      <th>link_projeto</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>PL 10010/2018</td>\n",
       "      <td>Nilson Leitão (PSDB/MT)</td>\n",
       "      <td>Acrescenta os art. 565-A a 565-E à Lei 13.105,...</td>\n",
       "      <td>Cria o crime de espólio coletivo nos casos de ...</td>\n",
       "      <td>Não</td>\n",
       "      <td>Não</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Desfavorável</td>\n",
       "      <td>Trata do procedimento de execução de decisões ...</td>\n",
       "      <td>http://www.camara.gov.br/proposicoesWeb/fichad...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>PL 8262/2017</td>\n",
       "      <td>André Amaral (MBD/PB)</td>\n",
       "      <td>Dispõe sobre a retirada de invasores de propri...</td>\n",
       "      <td>Polícia pode fazer reintegração de posso por r...</td>\n",
       "      <td>Não</td>\n",
       "      <td>Não</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Desfavorável</td>\n",
       "      <td>Inclui no Código Civil a permissão para que pr...</td>\n",
       "      <td>http://www.camara.gov.br/proposicoesWeb/fichad...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>PL 9604/2018</td>\n",
       "      <td>Jerônimo Goergen (PP/RS)</td>\n",
       "      <td>Dispõe sobre o abuso do direito de articulação...</td>\n",
       "      <td>Criminaliza as condutas de movimentos sociais</td>\n",
       "      <td>Não</td>\n",
       "      <td>Não</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Desfavorável</td>\n",
       "      <td>Neste PL o próprio autor afirma que o objetivo...</td>\n",
       "      <td>http://www.camara.gov.br/proposicoesWeb/fichad...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Patrus Ananias (PT/MG)</td>\n",
       "      <td>Modifica o Artigo 11 da Lei nº 8.629, de 25 de...</td>\n",
       "      <td>Atualiza os meios para o calculo dos índices d...</td>\n",
       "      <td>Não</td>\n",
       "      <td>Não</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Favorável</td>\n",
       "      <td>A atualização dos índices de produtividade sem...</td>\n",
       "      <td>http://www.camara.gov.br/proposicoesWeb/fichad...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Erika Kokay (PT/DF)</td>\n",
       "      <td>Modifica o Artigo 11 da Lei nº 8.629, de 25 de...</td>\n",
       "      <td>Atualiza os meios para o calculo dos índices d...</td>\n",
       "      <td>Não</td>\n",
       "      <td>Não</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Favorável</td>\n",
       "      <td>A atualização dos índices de produtividade sem...</td>\n",
       "      <td>http://www.camara.gov.br/proposicoesWeb/fichad...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   index      n_projeto                     autor  \\\n",
       "0      0  PL 10010/2018   Nilson Leitão (PSDB/MT)   \n",
       "1      1   PL 8262/2017     André Amaral (MBD/PB)   \n",
       "2      2   PL 9604/2018  Jerônimo Goergen (PP/RS)   \n",
       "3      3   PL 6136/2016    Patrus Ananias (PT/MG)   \n",
       "4      4   PL 6136/2016       Erika Kokay (PT/DF)   \n",
       "\n",
       "                                              ementa  \\\n",
       "0  Acrescenta os art. 565-A a 565-E à Lei 13.105,...   \n",
       "1  Dispõe sobre a retirada de invasores de propri...   \n",
       "2  Dispõe sobre o abuso do direito de articulação...   \n",
       "3  Modifica o Artigo 11 da Lei nº 8.629, de 25 de...   \n",
       "4  Modifica o Artigo 11 da Lei nº 8.629, de 25 de...   \n",
       "\n",
       "                                              resumo votacao_nominal  \\\n",
       "0  Cria o crime de espólio coletivo nos casos de ...             Não   \n",
       "1  Polícia pode fazer reintegração de posso por r...             Não   \n",
       "2      Criminaliza as condutas de movimentos sociais             Não   \n",
       "3  Atualiza os meios para o calculo dos índices d...             Não   \n",
       "4  Atualiza os meios para o calculo dos índices d...             Não   \n",
       "\n",
       "  votacao_nominal_alternativa_emenda  link_votacao  observacao  link_emenda  \\\n",
       "0                                Não           NaN         NaN          NaN   \n",
       "1                                Não           NaN         NaN          NaN   \n",
       "2                                Não           NaN         NaN          NaN   \n",
       "3                                Não           NaN         NaN          NaN   \n",
       "4                                Não           NaN         NaN          NaN   \n",
       "\n",
       "  indicado_por entidade_que_avalia favoravel_desfavoravel_indiferente  \\\n",
       "0       Contag              Contag                       Desfavorável   \n",
       "1       Contag              Contag                       Desfavorável   \n",
       "2       Contag              Contag                       Desfavorável   \n",
       "3       Contag              Contag                          Favorável   \n",
       "4       Contag              Contag                          Favorável   \n",
       "\n",
       "                                          explicacao  \\\n",
       "0  Trata do procedimento de execução de decisões ...   \n",
       "1  Inclui no Código Civil a permissão para que pr...   \n",
       "2  Neste PL o próprio autor afirma que o objetivo...   \n",
       "3  A atualização dos índices de produtividade sem...   \n",
       "4  A atualização dos índices de produtividade sem...   \n",
       "\n",
       "                                        link_projeto  \n",
       "0  http://www.camara.gov.br/proposicoesWeb/fichad...  \n",
       "1  http://www.camara.gov.br/proposicoesWeb/fichad...  \n",
       "2  http://www.camara.gov.br/proposicoesWeb/fichad...  \n",
       "3  http://www.camara.gov.br/proposicoesWeb/fichad...  \n",
       "4  http://www.camara.gov.br/proposicoesWeb/fichad...  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#lista_projetos = pd.read_csv('dados/projetos_teste.csv', sep=',',encoding = 'utf-8', converters={'chave': lambda x: str(x)})\n",
    "\n",
    "lista_projetos = pd.read_excel('dados/projetos_dia25julho.xlsx',sheet_name='PLs propostos')\n",
    "lista_projetos.reset_index().head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 59 entries, 0 to 58\n",
      "Data columns (total 14 columns):\n",
      "n_projeto                             59 non-null object\n",
      "autor                                 59 non-null object\n",
      "ementa                                59 non-null object\n",
      "resumo                                59 non-null object\n",
      "votacao_nominal                       59 non-null object\n",
      "votacao_nominal_alternativa_emenda    59 non-null object\n",
      "link_votacao                          0 non-null float64\n",
      "observacao                            0 non-null float64\n",
      "link_emenda                           0 non-null float64\n",
      "indicado_por                          59 non-null object\n",
      "entidade_que_avalia                   59 non-null object\n",
      "favoravel_desfavoravel_indiferente    59 non-null object\n",
      "explicacao                            59 non-null object\n",
      "link_projeto                          59 non-null object\n",
      "dtypes: float64(3), object(11)\n",
      "memory usage: 6.5+ KB\n"
     ]
    }
   ],
   "source": [
    "lista_projetos.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "lista_projetos[\"chave\"] = lista_projetos.link_projeto.str.split(\"=\", 1).str[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>n_projeto</th>\n",
       "      <th>autor</th>\n",
       "      <th>ementa</th>\n",
       "      <th>resumo</th>\n",
       "      <th>votacao_nominal</th>\n",
       "      <th>votacao_nominal_alternativa_emenda</th>\n",
       "      <th>link_votacao</th>\n",
       "      <th>observacao</th>\n",
       "      <th>link_emenda</th>\n",
       "      <th>indicado_por</th>\n",
       "      <th>entidade_que_avalia</th>\n",
       "      <th>favoravel_desfavoravel_indiferente</th>\n",
       "      <th>explicacao</th>\n",
       "      <th>link_projeto</th>\n",
       "      <th>chave</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>PL 10010/2018</td>\n",
       "      <td>Nilson Leitão (PSDB/MT)</td>\n",
       "      <td>Acrescenta os art. 565-A a 565-E à Lei 13.105,...</td>\n",
       "      <td>Cria o crime de espólio coletivo nos casos de ...</td>\n",
       "      <td>Não</td>\n",
       "      <td>Não</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Desfavorável</td>\n",
       "      <td>Trata do procedimento de execução de decisões ...</td>\n",
       "      <td>http://www.camara.gov.br/proposicoesWeb/fichad...</td>\n",
       "      <td>2171854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>PL 8262/2017</td>\n",
       "      <td>André Amaral (MBD/PB)</td>\n",
       "      <td>Dispõe sobre a retirada de invasores de propri...</td>\n",
       "      <td>Polícia pode fazer reintegração de posso por r...</td>\n",
       "      <td>Não</td>\n",
       "      <td>Não</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Desfavorável</td>\n",
       "      <td>Inclui no Código Civil a permissão para que pr...</td>\n",
       "      <td>http://www.camara.gov.br/proposicoesWeb/fichad...</td>\n",
       "      <td>2147513</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>PL 9604/2018</td>\n",
       "      <td>Jerônimo Goergen (PP/RS)</td>\n",
       "      <td>Dispõe sobre o abuso do direito de articulação...</td>\n",
       "      <td>Criminaliza as condutas de movimentos sociais</td>\n",
       "      <td>Não</td>\n",
       "      <td>Não</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Desfavorável</td>\n",
       "      <td>Neste PL o próprio autor afirma que o objetivo...</td>\n",
       "      <td>http://www.camara.gov.br/proposicoesWeb/fichad...</td>\n",
       "      <td>2168253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Patrus Ananias (PT/MG)</td>\n",
       "      <td>Modifica o Artigo 11 da Lei nº 8.629, de 25 de...</td>\n",
       "      <td>Atualiza os meios para o calculo dos índices d...</td>\n",
       "      <td>Não</td>\n",
       "      <td>Não</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Favorável</td>\n",
       "      <td>A atualização dos índices de produtividade sem...</td>\n",
       "      <td>http://www.camara.gov.br/proposicoesWeb/fichad...</td>\n",
       "      <td>2111624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Erika Kokay (PT/DF)</td>\n",
       "      <td>Modifica o Artigo 11 da Lei nº 8.629, de 25 de...</td>\n",
       "      <td>Atualiza os meios para o calculo dos índices d...</td>\n",
       "      <td>Não</td>\n",
       "      <td>Não</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Contag</td>\n",
       "      <td>Favorável</td>\n",
       "      <td>A atualização dos índices de produtividade sem...</td>\n",
       "      <td>http://www.camara.gov.br/proposicoesWeb/fichad...</td>\n",
       "      <td>2111624</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   index      n_projeto                     autor  \\\n",
       "0      0  PL 10010/2018   Nilson Leitão (PSDB/MT)   \n",
       "1      1   PL 8262/2017     André Amaral (MBD/PB)   \n",
       "2      2   PL 9604/2018  Jerônimo Goergen (PP/RS)   \n",
       "3      3   PL 6136/2016    Patrus Ananias (PT/MG)   \n",
       "4      4   PL 6136/2016       Erika Kokay (PT/DF)   \n",
       "\n",
       "                                              ementa  \\\n",
       "0  Acrescenta os art. 565-A a 565-E à Lei 13.105,...   \n",
       "1  Dispõe sobre a retirada de invasores de propri...   \n",
       "2  Dispõe sobre o abuso do direito de articulação...   \n",
       "3  Modifica o Artigo 11 da Lei nº 8.629, de 25 de...   \n",
       "4  Modifica o Artigo 11 da Lei nº 8.629, de 25 de...   \n",
       "\n",
       "                                              resumo votacao_nominal  \\\n",
       "0  Cria o crime de espólio coletivo nos casos de ...             Não   \n",
       "1  Polícia pode fazer reintegração de posso por r...             Não   \n",
       "2      Criminaliza as condutas de movimentos sociais             Não   \n",
       "3  Atualiza os meios para o calculo dos índices d...             Não   \n",
       "4  Atualiza os meios para o calculo dos índices d...             Não   \n",
       "\n",
       "  votacao_nominal_alternativa_emenda  link_votacao  observacao  link_emenda  \\\n",
       "0                                Não           NaN         NaN          NaN   \n",
       "1                                Não           NaN         NaN          NaN   \n",
       "2                                Não           NaN         NaN          NaN   \n",
       "3                                Não           NaN         NaN          NaN   \n",
       "4                                Não           NaN         NaN          NaN   \n",
       "\n",
       "  indicado_por entidade_que_avalia favoravel_desfavoravel_indiferente  \\\n",
       "0       Contag              Contag                       Desfavorável   \n",
       "1       Contag              Contag                       Desfavorável   \n",
       "2       Contag              Contag                       Desfavorável   \n",
       "3       Contag              Contag                          Favorável   \n",
       "4       Contag              Contag                          Favorável   \n",
       "\n",
       "                                          explicacao  \\\n",
       "0  Trata do procedimento de execução de decisões ...   \n",
       "1  Inclui no Código Civil a permissão para que pr...   \n",
       "2  Neste PL o próprio autor afirma que o objetivo...   \n",
       "3  A atualização dos índices de produtividade sem...   \n",
       "4  A atualização dos índices de produtividade sem...   \n",
       "\n",
       "                                        link_projeto    chave  \n",
       "0  http://www.camara.gov.br/proposicoesWeb/fichad...  2171854  \n",
       "1  http://www.camara.gov.br/proposicoesWeb/fichad...  2147513  \n",
       "2  http://www.camara.gov.br/proposicoesWeb/fichad...  2168253  \n",
       "3  http://www.camara.gov.br/proposicoesWeb/fichad...  2111624  \n",
       "4  http://www.camara.gov.br/proposicoesWeb/fichad...  2111624  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lista_projetos.reset_index().head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 59 entries, 0 to 58\n",
      "Data columns (total 15 columns):\n",
      "n_projeto                             59 non-null object\n",
      "autor                                 59 non-null object\n",
      "ementa                                59 non-null object\n",
      "resumo                                59 non-null object\n",
      "votacao_nominal                       59 non-null object\n",
      "votacao_nominal_alternativa_emenda    59 non-null object\n",
      "link_votacao                          0 non-null float64\n",
      "observacao                            0 non-null float64\n",
      "link_emenda                           0 non-null float64\n",
      "indicado_por                          59 non-null object\n",
      "entidade_que_avalia                   59 non-null object\n",
      "favoravel_desfavoravel_indiferente    59 non-null object\n",
      "explicacao                            59 non-null object\n",
      "link_projeto                          59 non-null object\n",
      "chave                                 59 non-null object\n",
      "dtypes: float64(3), object(12)\n",
      "memory usage: 7.0+ KB\n"
     ]
    }
   ],
   "source": [
    "lista_projetos.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "PL 10010/2018\n",
      "PL 8262/2017\n",
      "PL 9604/2018\n",
      "PL 6136/2016\n",
      "PL 6136/2016\n",
      "PL 6136/2016\n",
      "PL 6136/2016\n",
      "PL 6136/2016\n",
      "PL 6136/2016\n",
      "PL 6136/2016\n",
      "PL 3729/2004\n",
      "PL 3729/2004\n",
      "PL 3729/2004\n",
      "PL 3729/2004\n",
      "PL 3729/2004\n",
      "PL 3729/2004\n",
      "PL 3729/2004\n",
      "PL 3729/2004\n",
      "PL 3729/2004\n",
      "PL 3729/2004\n",
      "PL 3729/2004\n",
      "PL 3729/2004\n",
      "PL 3729/2004\n",
      "PL 3729/2004\n",
      "PL 3729/2004\n",
      "PL 792/2007\n",
      "PL 3986/2000\n",
      "PL 3615/2012\n",
      "PL 52/2011\n",
      "PL 1486/2015\n",
      "PL 9793/2018\n",
      "PL 9263/2017\n",
      "PL 9263/2017\n",
      "PL 9263/2017\n",
      "PL 9263/2017\n",
      "PL 9263/2017\n",
      "PL 9263/2017\n",
      "PL 5422/2005\n",
      "PL 490/2007\n",
      "PL 2289/2007\n",
      "PL 6480/2009\n",
      "PL 3842/2012\n",
      "PL 3722/2012\n",
      "PL 1176/2015\n",
      "PL 6532/2016\n",
      "PL 5065/2016\n",
      "PDC 584/2017\n",
      "PL 2057/1991\n",
      "PL 2057/1991\n",
      "PL 2057/1991\n",
      "PL 2057/1991\n",
      "PL 2057/1991\n",
      "PL 2490/2007\n",
      "PL 5919/2013\n",
      "PDC 972/2018\n",
      "PL 3068/2015\n",
      "PL 7813/2017\n",
      "PL 9858/2018\n",
      "PL 5370/2016\n"
     ]
    }
   ],
   "source": [
    "projetos = []\n",
    "\n",
    "for num, row in lista_projetos.iterrows():\n",
    "    projeto = (row['n_projeto']).strip()\n",
    "    print(projeto)\n",
    "    chave = (row['chave']).strip()\n",
    "    url = prefixo + chave + '/autores'\n",
    "    \n",
    "    parametros = {'formato': 'json', 'itens': 100}\n",
    "    resposta = requests.get(url, parametros)\n",
    "    for vez in resposta.json()['dados']:\n",
    "        dicionario = {\"parlamentar\": vez['nome'], \n",
    "                          \"uri\": vez['uri'], \n",
    "                          \"projeto\": projeto, \n",
    "                          \"tipo\": vez['tipo'],\n",
    "                          \"cod_tipo\": vez['codTipo']\n",
    "                          }\n",
    "        projetos.append(dicionario)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_projetos_api = pd.DataFrame(projetos)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>cod_tipo</th>\n",
       "      <th>parlamentar</th>\n",
       "      <th>projeto</th>\n",
       "      <th>tipo</th>\n",
       "      <th>uri</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>10000</td>\n",
       "      <td>Nilson Leitão</td>\n",
       "      <td>PL 10010/2018</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>10000</td>\n",
       "      <td>André Amaral</td>\n",
       "      <td>PL 8262/2017</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>10000</td>\n",
       "      <td>Jerônimo Goergen</td>\n",
       "      <td>PL 9604/2018</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>10000</td>\n",
       "      <td>Patrus Ananias</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>10000</td>\n",
       "      <td>Erika Kokay</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>10000</td>\n",
       "      <td>João Daniel</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>10000</td>\n",
       "      <td>Marcon</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>10000</td>\n",
       "      <td>Valmir Assunção</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>10000</td>\n",
       "      <td>Nilto Tatto</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>10000</td>\n",
       "      <td>Zeca do Pt</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>10000</td>\n",
       "      <td>Patrus Ananias</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>10000</td>\n",
       "      <td>Erika Kokay</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>10000</td>\n",
       "      <td>João Daniel</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>10000</td>\n",
       "      <td>Marcon</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>10000</td>\n",
       "      <td>Valmir Assunção</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>10000</td>\n",
       "      <td>Nilto Tatto</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>10000</td>\n",
       "      <td>Zeca do Pt</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>10000</td>\n",
       "      <td>Patrus Ananias</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>10000</td>\n",
       "      <td>Erika Kokay</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>10000</td>\n",
       "      <td>João Daniel</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>10000</td>\n",
       "      <td>Marcon</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>10000</td>\n",
       "      <td>Valmir Assunção</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>10000</td>\n",
       "      <td>Nilto Tatto</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>10000</td>\n",
       "      <td>Zeca do Pt</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>10000</td>\n",
       "      <td>Patrus Ananias</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>10000</td>\n",
       "      <td>Erika Kokay</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>10000</td>\n",
       "      <td>João Daniel</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>10000</td>\n",
       "      <td>Marcon</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>10000</td>\n",
       "      <td>Valmir Assunção</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>10000</td>\n",
       "      <td>Nilto Tatto</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>331</th>\n",
       "      <td>331</td>\n",
       "      <td>10000</td>\n",
       "      <td>JOSE CARLOS SABOIA</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>332</th>\n",
       "      <td>332</td>\n",
       "      <td>10000</td>\n",
       "      <td>NELSON JOBIM</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>333</th>\n",
       "      <td>333</td>\n",
       "      <td>10000</td>\n",
       "      <td>SIDNEY DE MIGUEL</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>334</th>\n",
       "      <td>334</td>\n",
       "      <td>10000</td>\n",
       "      <td>Aloizio Mercadante</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335</th>\n",
       "      <td>335</td>\n",
       "      <td>10000</td>\n",
       "      <td>Fábio Feldmann</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>336</th>\n",
       "      <td>336</td>\n",
       "      <td>10000</td>\n",
       "      <td>JOSE CARLOS SABOIA</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>337</th>\n",
       "      <td>337</td>\n",
       "      <td>10000</td>\n",
       "      <td>NELSON JOBIM</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>338</th>\n",
       "      <td>338</td>\n",
       "      <td>10000</td>\n",
       "      <td>SIDNEY DE MIGUEL</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>339</th>\n",
       "      <td>339</td>\n",
       "      <td>10000</td>\n",
       "      <td>Aloizio Mercadante</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340</th>\n",
       "      <td>340</td>\n",
       "      <td>10000</td>\n",
       "      <td>Fábio Feldmann</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341</th>\n",
       "      <td>341</td>\n",
       "      <td>10000</td>\n",
       "      <td>JOSE CARLOS SABOIA</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>342</th>\n",
       "      <td>342</td>\n",
       "      <td>10000</td>\n",
       "      <td>NELSON JOBIM</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343</th>\n",
       "      <td>343</td>\n",
       "      <td>10000</td>\n",
       "      <td>SIDNEY DE MIGUEL</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>344</td>\n",
       "      <td>10000</td>\n",
       "      <td>Aloizio Mercadante</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>345</th>\n",
       "      <td>345</td>\n",
       "      <td>10000</td>\n",
       "      <td>Fábio Feldmann</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>346</td>\n",
       "      <td>10000</td>\n",
       "      <td>JOSE CARLOS SABOIA</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>347</th>\n",
       "      <td>347</td>\n",
       "      <td>10000</td>\n",
       "      <td>NELSON JOBIM</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>348</th>\n",
       "      <td>348</td>\n",
       "      <td>10000</td>\n",
       "      <td>SIDNEY DE MIGUEL</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>349</th>\n",
       "      <td>349</td>\n",
       "      <td>10000</td>\n",
       "      <td>Aloizio Mercadante</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>350</th>\n",
       "      <td>350</td>\n",
       "      <td>10000</td>\n",
       "      <td>Fábio Feldmann</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>351</th>\n",
       "      <td>351</td>\n",
       "      <td>10000</td>\n",
       "      <td>JOSE CARLOS SABOIA</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352</th>\n",
       "      <td>352</td>\n",
       "      <td>10000</td>\n",
       "      <td>NELSON JOBIM</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>353</th>\n",
       "      <td>353</td>\n",
       "      <td>10000</td>\n",
       "      <td>SIDNEY DE MIGUEL</td>\n",
       "      <td>PL 2057/1991</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>354</td>\n",
       "      <td>10000</td>\n",
       "      <td>Eduardo Valverde</td>\n",
       "      <td>PL 2490/2007</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>355</td>\n",
       "      <td>10000</td>\n",
       "      <td>Dr. Jorge Silva</td>\n",
       "      <td>PL 5919/2013</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>356</td>\n",
       "      <td>10000</td>\n",
       "      <td>Lindomar Garçon</td>\n",
       "      <td>PDC 972/2018</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>357</td>\n",
       "      <td>10000</td>\n",
       "      <td>Sérgio Brito</td>\n",
       "      <td>PL 3068/2015</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>358</td>\n",
       "      <td>10000</td>\n",
       "      <td>Jhonatan de Jesus</td>\n",
       "      <td>PL 7813/2017</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>359</th>\n",
       "      <td>359</td>\n",
       "      <td>10000</td>\n",
       "      <td>Rogério Marinho</td>\n",
       "      <td>PL 9858/2018</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>360</th>\n",
       "      <td>360</td>\n",
       "      <td>10000</td>\n",
       "      <td>Toninho Pinheiro</td>\n",
       "      <td>PL 5370/2016</td>\n",
       "      <td>Deputado</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>361 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     index  cod_tipo         parlamentar        projeto      tipo  \\\n",
       "0        0     10000       Nilson Leitão  PL 10010/2018  Deputado   \n",
       "1        1     10000        André Amaral   PL 8262/2017  Deputado   \n",
       "2        2     10000    Jerônimo Goergen   PL 9604/2018  Deputado   \n",
       "3        3     10000      Patrus Ananias   PL 6136/2016  Deputado   \n",
       "4        4     10000         Erika Kokay   PL 6136/2016  Deputado   \n",
       "5        5     10000         João Daniel   PL 6136/2016  Deputado   \n",
       "6        6     10000              Marcon   PL 6136/2016  Deputado   \n",
       "7        7     10000     Valmir Assunção   PL 6136/2016  Deputado   \n",
       "8        8     10000         Nilto Tatto   PL 6136/2016  Deputado   \n",
       "9        9     10000          Zeca do Pt   PL 6136/2016  Deputado   \n",
       "10      10     10000      Patrus Ananias   PL 6136/2016  Deputado   \n",
       "11      11     10000         Erika Kokay   PL 6136/2016  Deputado   \n",
       "12      12     10000         João Daniel   PL 6136/2016  Deputado   \n",
       "13      13     10000              Marcon   PL 6136/2016  Deputado   \n",
       "14      14     10000     Valmir Assunção   PL 6136/2016  Deputado   \n",
       "15      15     10000         Nilto Tatto   PL 6136/2016  Deputado   \n",
       "16      16     10000          Zeca do Pt   PL 6136/2016  Deputado   \n",
       "17      17     10000      Patrus Ananias   PL 6136/2016  Deputado   \n",
       "18      18     10000         Erika Kokay   PL 6136/2016  Deputado   \n",
       "19      19     10000         João Daniel   PL 6136/2016  Deputado   \n",
       "20      20     10000              Marcon   PL 6136/2016  Deputado   \n",
       "21      21     10000     Valmir Assunção   PL 6136/2016  Deputado   \n",
       "22      22     10000         Nilto Tatto   PL 6136/2016  Deputado   \n",
       "23      23     10000          Zeca do Pt   PL 6136/2016  Deputado   \n",
       "24      24     10000      Patrus Ananias   PL 6136/2016  Deputado   \n",
       "25      25     10000         Erika Kokay   PL 6136/2016  Deputado   \n",
       "26      26     10000         João Daniel   PL 6136/2016  Deputado   \n",
       "27      27     10000              Marcon   PL 6136/2016  Deputado   \n",
       "28      28     10000     Valmir Assunção   PL 6136/2016  Deputado   \n",
       "29      29     10000         Nilto Tatto   PL 6136/2016  Deputado   \n",
       "..     ...       ...                 ...            ...       ...   \n",
       "331    331     10000  JOSE CARLOS SABOIA   PL 2057/1991  Deputado   \n",
       "332    332     10000        NELSON JOBIM   PL 2057/1991  Deputado   \n",
       "333    333     10000    SIDNEY DE MIGUEL   PL 2057/1991  Deputado   \n",
       "334    334     10000  Aloizio Mercadante   PL 2057/1991  Deputado   \n",
       "335    335     10000      Fábio Feldmann   PL 2057/1991  Deputado   \n",
       "336    336     10000  JOSE CARLOS SABOIA   PL 2057/1991  Deputado   \n",
       "337    337     10000        NELSON JOBIM   PL 2057/1991  Deputado   \n",
       "338    338     10000    SIDNEY DE MIGUEL   PL 2057/1991  Deputado   \n",
       "339    339     10000  Aloizio Mercadante   PL 2057/1991  Deputado   \n",
       "340    340     10000      Fábio Feldmann   PL 2057/1991  Deputado   \n",
       "341    341     10000  JOSE CARLOS SABOIA   PL 2057/1991  Deputado   \n",
       "342    342     10000        NELSON JOBIM   PL 2057/1991  Deputado   \n",
       "343    343     10000    SIDNEY DE MIGUEL   PL 2057/1991  Deputado   \n",
       "344    344     10000  Aloizio Mercadante   PL 2057/1991  Deputado   \n",
       "345    345     10000      Fábio Feldmann   PL 2057/1991  Deputado   \n",
       "346    346     10000  JOSE CARLOS SABOIA   PL 2057/1991  Deputado   \n",
       "347    347     10000        NELSON JOBIM   PL 2057/1991  Deputado   \n",
       "348    348     10000    SIDNEY DE MIGUEL   PL 2057/1991  Deputado   \n",
       "349    349     10000  Aloizio Mercadante   PL 2057/1991  Deputado   \n",
       "350    350     10000      Fábio Feldmann   PL 2057/1991  Deputado   \n",
       "351    351     10000  JOSE CARLOS SABOIA   PL 2057/1991  Deputado   \n",
       "352    352     10000        NELSON JOBIM   PL 2057/1991  Deputado   \n",
       "353    353     10000    SIDNEY DE MIGUEL   PL 2057/1991  Deputado   \n",
       "354    354     10000    Eduardo Valverde   PL 2490/2007  Deputado   \n",
       "355    355     10000     Dr. Jorge Silva   PL 5919/2013  Deputado   \n",
       "356    356     10000     Lindomar Garçon   PDC 972/2018  Deputado   \n",
       "357    357     10000        Sérgio Brito   PL 3068/2015  Deputado   \n",
       "358    358     10000   Jhonatan de Jesus   PL 7813/2017  Deputado   \n",
       "359    359     10000     Rogério Marinho   PL 9858/2018  Deputado   \n",
       "360    360     10000    Toninho Pinheiro   PL 5370/2016  Deputado   \n",
       "\n",
       "                                                   uri  \n",
       "0    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "1    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "2    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "3    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "4    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "5    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "6    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "7    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "8    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "9    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "10   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "11   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "12   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "13   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "14   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "15   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "16   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "17   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "18   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "19   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "20   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "21   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "22   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "23   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "24   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "25   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "26   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "27   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "28   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "29   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "..                                                 ...  \n",
       "331                                               None  \n",
       "332                                               None  \n",
       "333                                               None  \n",
       "334  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "335                                               None  \n",
       "336                                               None  \n",
       "337                                               None  \n",
       "338                                               None  \n",
       "339  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "340                                               None  \n",
       "341                                               None  \n",
       "342                                               None  \n",
       "343                                               None  \n",
       "344  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "345                                               None  \n",
       "346                                               None  \n",
       "347                                               None  \n",
       "348                                               None  \n",
       "349  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "350                                               None  \n",
       "351                                               None  \n",
       "352                                               None  \n",
       "353                                               None  \n",
       "354  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "355  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "356  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "357  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "358  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "359  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "360  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "\n",
       "[361 rows x 6 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_projetos_api.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "#nome = df_projetos_api[(df_projetos_api['projeto'] == 'PL 6136/2016')]\n",
    "#nome"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "projetos_autores = []\n",
    "\n",
    "for num, row in df_projetos_api.iterrows():\n",
    "    projeto = (row['projeto']).strip()\n",
    "    url = (row['uri'])\n",
    "    autor = (row['parlamentar']).strip()\n",
    "    #print(projeto + \" de \" + autor)\n",
    "    tipo = (row['tipo']).strip()\n",
    "    if tipo == 'Deputado' and url != None: # None são deputados de legislaturas passadas, que não têm uri\n",
    "        parametros = {'formato': 'json', 'itens': 100}\n",
    "        resposta = requests.get(url, parametros)\n",
    "        dicionario = {\"deputado_id\": str(resposta.json()['dados']['id']),\n",
    "                      \"nome\": autor, \n",
    "                      \"uri\": url, \n",
    "                      \"projeto\": projeto, \n",
    "                      \"legislatura\": resposta.json()['dados']['ultimoStatus']['idLegislatura'],\n",
    "                      \"situacao\": resposta.json()['dados']['ultimoStatus']['situacao'],\n",
    "                      \"condicao\": resposta.json()['dados']['ultimoStatus']['condicaoEleitoral']}\n",
    "        projetos_autores.append(dicionario)\n",
    "    else:\n",
    "        dicionario = {\"deputado_id\": \"não_deputado\",\n",
    "                          \"nome\": autor, \n",
    "                          \"uri\": tipo, \n",
    "                          \"projeto\": projeto, \n",
    "                          \"legislatura\": 'nao_deputado',\n",
    "                          \"situacao\": 'nao_deputado'\n",
    "                          }\n",
    "        projetos_autores.append(dicionario)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_projetos_autores_api = pd.DataFrame(projetos_autores)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>condicao</th>\n",
       "      <th>deputado_id</th>\n",
       "      <th>legislatura</th>\n",
       "      <th>nome</th>\n",
       "      <th>projeto</th>\n",
       "      <th>situacao</th>\n",
       "      <th>uri</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Titular</td>\n",
       "      <td>166401</td>\n",
       "      <td>55</td>\n",
       "      <td>Nilson Leitão</td>\n",
       "      <td>PL 10010/2018</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Efetivado</td>\n",
       "      <td>195143</td>\n",
       "      <td>55</td>\n",
       "      <td>André Amaral</td>\n",
       "      <td>PL 8262/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160570</td>\n",
       "      <td>55</td>\n",
       "      <td>Jerônimo Goergen</td>\n",
       "      <td>PL 9604/2018</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Titular</td>\n",
       "      <td>74160</td>\n",
       "      <td>55</td>\n",
       "      <td>Patrus Ananias</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160575</td>\n",
       "      <td>55</td>\n",
       "      <td>Erika Kokay</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   index   condicao deputado_id legislatura              nome        projeto  \\\n",
       "0      0    Titular      166401          55     Nilson Leitão  PL 10010/2018   \n",
       "1      1  Efetivado      195143          55      André Amaral   PL 8262/2017   \n",
       "2      2    Titular      160570          55  Jerônimo Goergen   PL 9604/2018   \n",
       "3      3    Titular       74160          55    Patrus Ananias   PL 6136/2016   \n",
       "4      4    Titular      160575          55       Erika Kokay   PL 6136/2016   \n",
       "\n",
       "    situacao                                                uri  \n",
       "0  Exercício  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "1  Exercício  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "2  Exercício  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "3  Exercício  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "4  Exercício  https://dadosabertos.camara.leg.br/api/v2/depu...  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_projetos_autores_api.reset_index().head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 361 entries, 0 to 360\n",
      "Data columns (total 7 columns):\n",
      "condicao       340 non-null object\n",
      "deputado_id    361 non-null object\n",
      "legislatura    361 non-null object\n",
      "nome           361 non-null object\n",
      "projeto        361 non-null object\n",
      "situacao       356 non-null object\n",
      "uri            361 non-null object\n",
      "dtypes: object(7)\n",
      "memory usage: 19.8+ KB\n"
     ]
    }
   ],
   "source": [
    "df_projetos_autores_api.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "selecionados = df_projetos_autores_api[(df_projetos_autores_api['legislatura'] == 55) &\n",
    "                                       (df_projetos_autores_api['condicao'] == 'Titular')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>condicao</th>\n",
       "      <th>deputado_id</th>\n",
       "      <th>legislatura</th>\n",
       "      <th>nome</th>\n",
       "      <th>projeto</th>\n",
       "      <th>situacao</th>\n",
       "      <th>uri</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Titular</td>\n",
       "      <td>166401</td>\n",
       "      <td>55</td>\n",
       "      <td>Nilson Leitão</td>\n",
       "      <td>PL 10010/2018</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160570</td>\n",
       "      <td>55</td>\n",
       "      <td>Jerônimo Goergen</td>\n",
       "      <td>PL 9604/2018</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Titular</td>\n",
       "      <td>74160</td>\n",
       "      <td>55</td>\n",
       "      <td>Patrus Ananias</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160575</td>\n",
       "      <td>55</td>\n",
       "      <td>Erika Kokay</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178970</td>\n",
       "      <td>55</td>\n",
       "      <td>João Daniel</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160535</td>\n",
       "      <td>55</td>\n",
       "      <td>Marcon</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160610</td>\n",
       "      <td>55</td>\n",
       "      <td>Valmir Assunção</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178986</td>\n",
       "      <td>55</td>\n",
       "      <td>Nilto Tatto</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178902</td>\n",
       "      <td>55</td>\n",
       "      <td>Zeca do Pt</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Titular</td>\n",
       "      <td>74160</td>\n",
       "      <td>55</td>\n",
       "      <td>Patrus Ananias</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160575</td>\n",
       "      <td>55</td>\n",
       "      <td>Erika Kokay</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178970</td>\n",
       "      <td>55</td>\n",
       "      <td>João Daniel</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160535</td>\n",
       "      <td>55</td>\n",
       "      <td>Marcon</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160610</td>\n",
       "      <td>55</td>\n",
       "      <td>Valmir Assunção</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178986</td>\n",
       "      <td>55</td>\n",
       "      <td>Nilto Tatto</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178902</td>\n",
       "      <td>55</td>\n",
       "      <td>Zeca do Pt</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>Titular</td>\n",
       "      <td>74160</td>\n",
       "      <td>55</td>\n",
       "      <td>Patrus Ananias</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160575</td>\n",
       "      <td>55</td>\n",
       "      <td>Erika Kokay</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178970</td>\n",
       "      <td>55</td>\n",
       "      <td>João Daniel</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160535</td>\n",
       "      <td>55</td>\n",
       "      <td>Marcon</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160610</td>\n",
       "      <td>55</td>\n",
       "      <td>Valmir Assunção</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178986</td>\n",
       "      <td>55</td>\n",
       "      <td>Nilto Tatto</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178902</td>\n",
       "      <td>55</td>\n",
       "      <td>Zeca do Pt</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>Titular</td>\n",
       "      <td>74160</td>\n",
       "      <td>55</td>\n",
       "      <td>Patrus Ananias</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160575</td>\n",
       "      <td>55</td>\n",
       "      <td>Erika Kokay</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178970</td>\n",
       "      <td>55</td>\n",
       "      <td>João Daniel</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160535</td>\n",
       "      <td>55</td>\n",
       "      <td>Marcon</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160610</td>\n",
       "      <td>55</td>\n",
       "      <td>Valmir Assunção</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178986</td>\n",
       "      <td>55</td>\n",
       "      <td>Nilto Tatto</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178902</td>\n",
       "      <td>55</td>\n",
       "      <td>Zeca do Pt</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>300</td>\n",
       "      <td>Titular</td>\n",
       "      <td>74041</td>\n",
       "      <td>55</td>\n",
       "      <td>Luiz Couto</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>301</td>\n",
       "      <td>Titular</td>\n",
       "      <td>74160</td>\n",
       "      <td>55</td>\n",
       "      <td>Patrus Ananias</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>302</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160610</td>\n",
       "      <td>55</td>\n",
       "      <td>Valmir Assunção</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>303</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178970</td>\n",
       "      <td>55</td>\n",
       "      <td>João Daniel</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>304</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178986</td>\n",
       "      <td>55</td>\n",
       "      <td>Nilto Tatto</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>305</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160535</td>\n",
       "      <td>55</td>\n",
       "      <td>Marcon</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>306</td>\n",
       "      <td>Titular</td>\n",
       "      <td>74041</td>\n",
       "      <td>55</td>\n",
       "      <td>Luiz Couto</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>307</td>\n",
       "      <td>Titular</td>\n",
       "      <td>74160</td>\n",
       "      <td>55</td>\n",
       "      <td>Patrus Ananias</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>308</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160610</td>\n",
       "      <td>55</td>\n",
       "      <td>Valmir Assunção</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>309</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178970</td>\n",
       "      <td>55</td>\n",
       "      <td>João Daniel</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>310</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178986</td>\n",
       "      <td>55</td>\n",
       "      <td>Nilto Tatto</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>311</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160535</td>\n",
       "      <td>55</td>\n",
       "      <td>Marcon</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>312</td>\n",
       "      <td>Titular</td>\n",
       "      <td>74041</td>\n",
       "      <td>55</td>\n",
       "      <td>Luiz Couto</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>313</td>\n",
       "      <td>Titular</td>\n",
       "      <td>74160</td>\n",
       "      <td>55</td>\n",
       "      <td>Patrus Ananias</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>314</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160610</td>\n",
       "      <td>55</td>\n",
       "      <td>Valmir Assunção</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>315</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178970</td>\n",
       "      <td>55</td>\n",
       "      <td>João Daniel</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>316</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178986</td>\n",
       "      <td>55</td>\n",
       "      <td>Nilto Tatto</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>317</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160535</td>\n",
       "      <td>55</td>\n",
       "      <td>Marcon</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>318</td>\n",
       "      <td>Titular</td>\n",
       "      <td>74041</td>\n",
       "      <td>55</td>\n",
       "      <td>Luiz Couto</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>321</td>\n",
       "      <td>Titular</td>\n",
       "      <td>141335</td>\n",
       "      <td>55</td>\n",
       "      <td>Beto Faro</td>\n",
       "      <td>PL 2289/2007</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>324</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160651</td>\n",
       "      <td>55</td>\n",
       "      <td>Rogério Peninha Mendonça</td>\n",
       "      <td>PL 3722/2012</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>325</td>\n",
       "      <td>Titular</td>\n",
       "      <td>74213</td>\n",
       "      <td>55</td>\n",
       "      <td>Antonio Balhmann</td>\n",
       "      <td>PL 1176/2015</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>327</td>\n",
       "      <td>Titular</td>\n",
       "      <td>178893</td>\n",
       "      <td>55</td>\n",
       "      <td>Delegado Edson Moreira</td>\n",
       "      <td>PL 5065/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>328</td>\n",
       "      <td>Titular</td>\n",
       "      <td>166401</td>\n",
       "      <td>55</td>\n",
       "      <td>Nilson Leitão</td>\n",
       "      <td>PDC 584/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>355</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160643</td>\n",
       "      <td>55</td>\n",
       "      <td>Dr. Jorge Silva</td>\n",
       "      <td>PL 5919/2013</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>356</td>\n",
       "      <td>Titular</td>\n",
       "      <td>141483</td>\n",
       "      <td>55</td>\n",
       "      <td>Lindomar Garçon</td>\n",
       "      <td>PDC 972/2018</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>357</td>\n",
       "      <td>Titular</td>\n",
       "      <td>73808</td>\n",
       "      <td>55</td>\n",
       "      <td>Sérgio Brito</td>\n",
       "      <td>PL 3068/2015</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>358</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160531</td>\n",
       "      <td>55</td>\n",
       "      <td>Jhonatan de Jesus</td>\n",
       "      <td>PL 7813/2017</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>359</td>\n",
       "      <td>Titular</td>\n",
       "      <td>141535</td>\n",
       "      <td>55</td>\n",
       "      <td>Rogério Marinho</td>\n",
       "      <td>PL 9858/2018</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>360</td>\n",
       "      <td>Titular</td>\n",
       "      <td>160611</td>\n",
       "      <td>55</td>\n",
       "      <td>Toninho Pinheiro</td>\n",
       "      <td>PL 5370/2016</td>\n",
       "      <td>Exercício</td>\n",
       "      <td>https://dadosabertos.camara.leg.br/api/v2/depu...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>117 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     index condicao deputado_id legislatura                      nome  \\\n",
       "0        0  Titular      166401          55             Nilson Leitão   \n",
       "1        2  Titular      160570          55          Jerônimo Goergen   \n",
       "2        3  Titular       74160          55            Patrus Ananias   \n",
       "3        4  Titular      160575          55               Erika Kokay   \n",
       "4        5  Titular      178970          55               João Daniel   \n",
       "5        6  Titular      160535          55                    Marcon   \n",
       "6        7  Titular      160610          55           Valmir Assunção   \n",
       "7        8  Titular      178986          55               Nilto Tatto   \n",
       "8        9  Titular      178902          55                Zeca do Pt   \n",
       "9       10  Titular       74160          55            Patrus Ananias   \n",
       "10      11  Titular      160575          55               Erika Kokay   \n",
       "11      12  Titular      178970          55               João Daniel   \n",
       "12      13  Titular      160535          55                    Marcon   \n",
       "13      14  Titular      160610          55           Valmir Assunção   \n",
       "14      15  Titular      178986          55               Nilto Tatto   \n",
       "15      16  Titular      178902          55                Zeca do Pt   \n",
       "16      17  Titular       74160          55            Patrus Ananias   \n",
       "17      18  Titular      160575          55               Erika Kokay   \n",
       "18      19  Titular      178970          55               João Daniel   \n",
       "19      20  Titular      160535          55                    Marcon   \n",
       "20      21  Titular      160610          55           Valmir Assunção   \n",
       "21      22  Titular      178986          55               Nilto Tatto   \n",
       "22      23  Titular      178902          55                Zeca do Pt   \n",
       "23      24  Titular       74160          55            Patrus Ananias   \n",
       "24      25  Titular      160575          55               Erika Kokay   \n",
       "25      26  Titular      178970          55               João Daniel   \n",
       "26      27  Titular      160535          55                    Marcon   \n",
       "27      28  Titular      160610          55           Valmir Assunção   \n",
       "28      29  Titular      178986          55               Nilto Tatto   \n",
       "29      30  Titular      178902          55                Zeca do Pt   \n",
       "..     ...      ...         ...         ...                       ...   \n",
       "87     300  Titular       74041          55                Luiz Couto   \n",
       "88     301  Titular       74160          55            Patrus Ananias   \n",
       "89     302  Titular      160610          55           Valmir Assunção   \n",
       "90     303  Titular      178970          55               João Daniel   \n",
       "91     304  Titular      178986          55               Nilto Tatto   \n",
       "92     305  Titular      160535          55                    Marcon   \n",
       "93     306  Titular       74041          55                Luiz Couto   \n",
       "94     307  Titular       74160          55            Patrus Ananias   \n",
       "95     308  Titular      160610          55           Valmir Assunção   \n",
       "96     309  Titular      178970          55               João Daniel   \n",
       "97     310  Titular      178986          55               Nilto Tatto   \n",
       "98     311  Titular      160535          55                    Marcon   \n",
       "99     312  Titular       74041          55                Luiz Couto   \n",
       "100    313  Titular       74160          55            Patrus Ananias   \n",
       "101    314  Titular      160610          55           Valmir Assunção   \n",
       "102    315  Titular      178970          55               João Daniel   \n",
       "103    316  Titular      178986          55               Nilto Tatto   \n",
       "104    317  Titular      160535          55                    Marcon   \n",
       "105    318  Titular       74041          55                Luiz Couto   \n",
       "106    321  Titular      141335          55                 Beto Faro   \n",
       "107    324  Titular      160651          55  Rogério Peninha Mendonça   \n",
       "108    325  Titular       74213          55          Antonio Balhmann   \n",
       "109    327  Titular      178893          55    Delegado Edson Moreira   \n",
       "110    328  Titular      166401          55             Nilson Leitão   \n",
       "111    355  Titular      160643          55           Dr. Jorge Silva   \n",
       "112    356  Titular      141483          55           Lindomar Garçon   \n",
       "113    357  Titular       73808          55              Sérgio Brito   \n",
       "114    358  Titular      160531          55         Jhonatan de Jesus   \n",
       "115    359  Titular      141535          55           Rogério Marinho   \n",
       "116    360  Titular      160611          55          Toninho Pinheiro   \n",
       "\n",
       "           projeto   situacao  \\\n",
       "0    PL 10010/2018  Exercício   \n",
       "1     PL 9604/2018  Exercício   \n",
       "2     PL 6136/2016  Exercício   \n",
       "3     PL 6136/2016  Exercício   \n",
       "4     PL 6136/2016  Exercício   \n",
       "5     PL 6136/2016  Exercício   \n",
       "6     PL 6136/2016  Exercício   \n",
       "7     PL 6136/2016  Exercício   \n",
       "8     PL 6136/2016  Exercício   \n",
       "9     PL 6136/2016  Exercício   \n",
       "10    PL 6136/2016  Exercício   \n",
       "11    PL 6136/2016  Exercício   \n",
       "12    PL 6136/2016  Exercício   \n",
       "13    PL 6136/2016  Exercício   \n",
       "14    PL 6136/2016  Exercício   \n",
       "15    PL 6136/2016  Exercício   \n",
       "16    PL 6136/2016  Exercício   \n",
       "17    PL 6136/2016  Exercício   \n",
       "18    PL 6136/2016  Exercício   \n",
       "19    PL 6136/2016  Exercício   \n",
       "20    PL 6136/2016  Exercício   \n",
       "21    PL 6136/2016  Exercício   \n",
       "22    PL 6136/2016  Exercício   \n",
       "23    PL 6136/2016  Exercício   \n",
       "24    PL 6136/2016  Exercício   \n",
       "25    PL 6136/2016  Exercício   \n",
       "26    PL 6136/2016  Exercício   \n",
       "27    PL 6136/2016  Exercício   \n",
       "28    PL 6136/2016  Exercício   \n",
       "29    PL 6136/2016  Exercício   \n",
       "..             ...        ...   \n",
       "87    PL 9263/2017  Exercício   \n",
       "88    PL 9263/2017  Exercício   \n",
       "89    PL 9263/2017  Exercício   \n",
       "90    PL 9263/2017  Exercício   \n",
       "91    PL 9263/2017  Exercício   \n",
       "92    PL 9263/2017  Exercício   \n",
       "93    PL 9263/2017  Exercício   \n",
       "94    PL 9263/2017  Exercício   \n",
       "95    PL 9263/2017  Exercício   \n",
       "96    PL 9263/2017  Exercício   \n",
       "97    PL 9263/2017  Exercício   \n",
       "98    PL 9263/2017  Exercício   \n",
       "99    PL 9263/2017  Exercício   \n",
       "100   PL 9263/2017  Exercício   \n",
       "101   PL 9263/2017  Exercício   \n",
       "102   PL 9263/2017  Exercício   \n",
       "103   PL 9263/2017  Exercício   \n",
       "104   PL 9263/2017  Exercício   \n",
       "105   PL 9263/2017  Exercício   \n",
       "106   PL 2289/2007  Exercício   \n",
       "107   PL 3722/2012  Exercício   \n",
       "108   PL 1176/2015  Exercício   \n",
       "109   PL 5065/2016  Exercício   \n",
       "110   PDC 584/2017  Exercício   \n",
       "111   PL 5919/2013  Exercício   \n",
       "112   PDC 972/2018  Exercício   \n",
       "113   PL 3068/2015  Exercício   \n",
       "114   PL 7813/2017  Exercício   \n",
       "115   PL 9858/2018  Exercício   \n",
       "116   PL 5370/2016  Exercício   \n",
       "\n",
       "                                                   uri  \n",
       "0    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "1    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "2    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "3    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "4    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "5    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "6    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "7    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "8    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "9    https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "10   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "11   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "12   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "13   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "14   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "15   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "16   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "17   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "18   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "19   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "20   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "21   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "22   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "23   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "24   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "25   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "26   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "27   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "28   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "29   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "..                                                 ...  \n",
       "87   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "88   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "89   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "90   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "91   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "92   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "93   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "94   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "95   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "96   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "97   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "98   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "99   https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "100  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "101  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "102  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "103  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "104  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "105  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "106  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "107  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "108  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "109  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "110  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "111  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "112  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "113  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "114  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "115  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "116  https://dadosabertos.camara.leg.br/api/v2/depu...  \n",
       "\n",
       "[117 rows x 8 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "selecionados.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "#nome = selecionados[(selecionados['projeto'] == 'PL 6136/2016')]\n",
    "#nome"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "so_projetos = selecionados['projeto'].value_counts()\n",
    "so_projetos = pd.DataFrame({'projeto':so_projetos.index, 'quantidade':so_projetos.values})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>projeto</th>\n",
       "      <th>quantidade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>PL 6136/2016</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>PL 9263/2017</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>PL 3729/2004</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>PL 5919/2013</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>PL 2289/2007</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>PL 52/2011</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>PL 3615/2012</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>PL 9858/2018</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>PL 9793/2018</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>PL 3068/2015</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>PL 7813/2017</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>PL 5370/2016</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>PL 1486/2015</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>PL 9604/2018</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>PDC 972/2018</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>PL 10010/2018</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>PDC 584/2017</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>PL 5065/2016</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>PL 3722/2012</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>PL 1176/2015</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    index        projeto  quantidade\n",
       "0       0   PL 6136/2016          49\n",
       "1       1   PL 9263/2017          36\n",
       "2       2   PL 3729/2004          15\n",
       "3       3   PL 5919/2013           1\n",
       "4       4   PL 2289/2007           1\n",
       "5       5     PL 52/2011           1\n",
       "6       6   PL 3615/2012           1\n",
       "7       7   PL 9858/2018           1\n",
       "8       8   PL 9793/2018           1\n",
       "9       9   PL 3068/2015           1\n",
       "10     10   PL 7813/2017           1\n",
       "11     11   PL 5370/2016           1\n",
       "12     12   PL 1486/2015           1\n",
       "13     13   PL 9604/2018           1\n",
       "14     14   PDC 972/2018           1\n",
       "15     15  PL 10010/2018           1\n",
       "16     16   PDC 584/2017           1\n",
       "17     17   PL 5065/2016           1\n",
       "18     18   PL 3722/2012           1\n",
       "19     19   PL 1176/2015           1"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "so_projetos.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "def limpeza1(linha):\n",
    "    documento = str(linha[\"n_projeto\"])\n",
    "    documento = documento.strip()\n",
    "    return str(documento)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "lista_projetos[\"n_projeto\"] = lista_projetos.apply(limpeza1, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_projetos_eleitos = pd.merge(lista_projetos, so_projetos, left_on='n_projeto', right_on='projeto')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 45 entries, 0 to 44\n",
      "Data columns (total 17 columns):\n",
      "n_projeto                             45 non-null object\n",
      "autor                                 45 non-null object\n",
      "ementa                                45 non-null object\n",
      "resumo                                45 non-null object\n",
      "votacao_nominal                       45 non-null object\n",
      "votacao_nominal_alternativa_emenda    45 non-null object\n",
      "link_votacao                          0 non-null float64\n",
      "observacao                            0 non-null float64\n",
      "link_emenda                           0 non-null float64\n",
      "indicado_por                          45 non-null object\n",
      "entidade_que_avalia                   45 non-null object\n",
      "favoravel_desfavoravel_indiferente    45 non-null object\n",
      "explicacao                            45 non-null object\n",
      "link_projeto                          45 non-null object\n",
      "chave                                 45 non-null object\n",
      "projeto                               45 non-null object\n",
      "quantidade                            45 non-null int64\n",
      "dtypes: float64(3), int64(1), object(13)\n",
      "memory usage: 6.3+ KB\n"
     ]
    }
   ],
   "source": [
    "df_projetos_eleitos.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_projetos_eleitos.drop('chave',axis=1,inplace=True)\n",
    "df_projetos_eleitos.drop('projeto',axis=1,inplace=True)\n",
    "df_projetos_eleitos.drop('quantidade',axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_projetos_eleitos.to_excel('resultados/projetos_dep_eleitos.xlsx',sheet_name='Sheet1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}