%%capture # ^ capture here just supresses any output !pip install flatterer

!wget http://api.nobelprize.org/v1/prize.json -q -O prize.json !cat prize.json

import flatterer output = flatterer.flatten('prize.json', dataframe=True) print(output)

output['fields']

output['data']['prizes']

output['data']['prizes_laureates']

output = flatterer.flatten('prize.json', 'nobel_prize', xlsx=True, sqlite=True, force=True) # force=True deletes directory if already exists. print(output)