pythonpa'chong 读取json文件，包含多层嵌套怎么拆分？

Question

这种格式的json文件数据怎么处理？想转成excel文件格式。
{"name":"red","score":{"chinese":100,"math":90,"english":98}}

Answer 1

是变成这个样子吗？

import json
import pandas as pd

data = '{"name":"red","score":{"chinese":100,"math":90,"english":98}}'
d = json.loads(data)
a = d['score']
a['name'] = d['name']
b = pd.DataFrame.from_dict(a,orient='index').T
b.to_excel('test.xls')

结果实例

这样就ok了