test={"subjects":[ {"episodes_info":"","rate":"7.3","cover_x":1052, "title":"空白","playable":False,"id":"34990918","cover_y":1499,"is_new":True},{"episodes_info":"","rate":"6.1","cover_x":750, "title":"鸠的击退法","playable":False,"id":"35374186","cover_y":1059,"is_new":True} ]} 处理成如下数据: episodes_info,rate,cover_x,title,playable,id,cover_y,is_new null,7.3,1052,空白,false,134990918,499,true null,6.1,750,鸠的击退法,false,35374186,1059,true
时间: 2023-08-10 13:08:37 浏览: 51
test = {
"subjects": [
{
"episodes_info": "",
"rate": "7.3",
"cover_x": 1052,
"title": "空白",
"playable": False,
"id": "34990918",
"cover_y": 1499,
"is_new": True
},
{
"episodes_info": "",
"rate": "6.1",
"cover_x": 750,
"title": "鸠的击退法",
"playable": False,
"id": "35374186",
"cover_y": 1059,
"is_new": True
}
]
}
data = []
for subject in test["subjects"]:
row = [
"null" if subject["episodes_info"] == "" else subject["episodes_info"],
subject["rate"],
subject["cover_x"],
subject["title"],
str(subject["playable"]).lower(),
subject["id"],
subject["cover_y"],
str(subject["is_new"]).lower()
]
data.append(row)
output = "episodes_info,rate,cover_x,title,playable,id,cover_y,is_new\n"
for row in data:
output += ",".join(map(str, row)) + "\n"
print(output)