Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import requests
- import json
- import prettytable
- headers = {'Content-type': 'application/json'}
- data = json.dumps({"seriesid": ['CUUR0000SA0','SUUR0000SA0'],"startyear":"2011", "endyear":"2014"})
- p = requests.post('https://api.bls.gov/publicAPI/v2/timeseries/data/', data=data, headers=headers)
- json_data = json.loads(p.text)
- for series in json_data['Results']['series']:
- x=prettytable.PrettyTable(["series id","year","period","value","footnotes"])
- seriesId = series['seriesID']
- for item in series['data']:
- year = item['year']
- period = item['period']
- value = item['value']
- footnotes=""
- for footnote in item['footnotes']:
- if footnote:
- footnotes = footnotes + footnote['text'] + ','
- 'if 'M01' <= period <= 'M12':'
- x.add_row([seriesId,year,period,value,footnotes[0:-1]])
- output = open(seriesId + '.txt','w')
- output.write (x.get_string())
- output.close()
Advertisement
Add Comment
Please, Sign In to add comment