import json
import tablib
with open('coursera-introduction-psychology.json','r',encoding='utf-8',errors='ignore') as f:
rows=json.load(f)
headers = tuple(
[i for i in rows[0].keys()]
)
data=[]
for row in rows:
body =[]
for v in row.values():
body.append(v)
data.append(tuple(body))
data = tablib.Dataset(*data,headers=headers)
open('data.xls','wb').write(data.xls)
首先要先安装一下tablib库,就最简单的pip install tablib就好了,代码可以直接使用,换一下文件名和路径就好了。