我有此格式的json,并且想要转换为CSV文件。
{
"extrapolationLevel": 1,"columnNames": [
"name","usersession.country","application","usersession.osFamily","usersession.startTime","visuallyCompleteTime"
],"values": [
[
"pdp","Serbia","Desktop","Windows",1573215462076,1503
],]
}
我想将此json转换为CSV格式,这是我的脚本
import csv
import json
with open('response_1573222394875.json') as infile:
Data = json.loads(infile.read())
with open("q.csv","w") as outfile:
f = csv.writer(outfile)
f.writerow(["name","visuallyCompleteTime"])
f.writerow([Data["name"],Data["usersession.country"],Data["application"],Data["usersession.osFamily"],Data["usersession.startTime"],Data["visuallyCompleteTime"]])
预期输出
name usersession.country application usersession.osFamilyusersession.startTime visuallyCompleteTime
pdp Serbia Desktop Windows 1573215462076 1503
plp us APP Windows 1573215462076 1548
startpage uk Site Windows 1573215462076 1639
product india Desktop Windows 1573215462076 3194
pdp Vietnam APP Windows 1573215462076 3299
有人可以在这里帮我吗?