Skip to content

Instantly share code, notes, and snippets.

@turicas
Created December 4, 2015 10:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save turicas/dd7fbac2960223caaa90 to your computer and use it in GitHub Desktop.
Save turicas/dd7fbac2960223caaa90 to your computer and use it in GitHub Desktop.
# coding: utf-8
# requirements: requests rows xmltodict
from collections import OrderedDict
import requests
import rows
import xmltodict
class PtBrDateField(rows.fields.DateField):
INPUT_FORMAT = '%d/%m/%Y'
url = 'http://www.camara.gov.br/SitCamaraWS/Proposicoes.asmx/ListarProposicoesVotadasEmPlenario?ano=2015&tipo='
fields = OrderedDict([('codigo', rows.fields.IntegerField),
('nome', rows.fields.TextField),
('data_votacao', PtBrDateField)])
response = requests.get(url)
result = xmltodict.parse(response.content)
table = rows.Table(fields=fields)
for proposicao in result['proposicoes']['proposicao']:
table.append({'codigo': proposicao['codProposicao'],
'nome': proposicao['nomeProposicao'],
'data_votacao': proposicao['dataVotacao'], })
rows.export_to_csv(table, 'proposicoes.csv')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment