@@ -0,0 +1,913 @@
+import requests%0Aimport untangle%0Aimport pandas as pd%0A%0A%0Atable = %5B%5D%0Ayear = '2015'%0Atipos = %5B'PEC', 'PL', 'PLP', 'MPV'%5D%0A%0Afor tipo in tipos:%0A%0A    url = 'http://www.camara.gov.br/SitCamaraWS/Proposicoes.asmx/' + %5C%0A            'ListarProposicoesVotadasEmPlenario?ano=2015&tipo=%25s' %25 tipo%0A%0A    page = requests.get(url)%0A    xml = page.content%0A%0A    doc = untangle.parse(xml)%0A%0A%0A    for project in doc.proposicoes.proposicao:%0A        table.append(%5B project.codProposicao.cdata,%0A                      project.nomeProposicao.cdata.split()%5B0%5D,%0A                      project.nomeProposicao.cdata.split()%5B1%5D.split('/')%5B0%5D,%0A                      project.nomeProposicao.cdata.split('/')%5B1%5D,%0A                      project.dataVotacao.cdata %5D)%0A%0Adf = pd.DataFrame(table, columns = %5B'pCode', 'pType', 'pId', 'pYear', 'votingDate'%5D)%0A%0Awith open('voted_projects.csv', 'w') as fp:%0A  fp.write( df%5B%5B'pType', 'pId', 'pYear'%5D%5D.to_csv(sep=';') )%0A

Create get_voted_projects.py