In [ ]:
import json
with open("raw.json", encoding='utf-8') as fd:
raw = json.load(fd)
column_names = [column['name']
for column in raw['meta']['view']['columns']]
column_names
results = []
for item in raw['data']:
item = {column_name: value
for column_name, value in zip(column_names, item)}
results.append(item)
In [ ]: