python json 转csv_如何在python中将json转换为csv-CSDN博客

本文链接：https://blog.csdn.net/weixin_42472263/article/details/114387557

下面是我的JSON文件输入

{"userID": "679d3bad-155e-4b39-9ff7-7d564f408942", "Is salary credited before 5th": "Yes", "Avg Salary of last 3 months": 15453.33, "Avg Salary of last 6 months": 15290.5, "Avg Balance before salary of last 3 months": 113.15, "Avg Balance before salary of last 6 months": 105.22}

代码

with open('/Users/vrindabv/Documents/PycharmProjects/BankStatementEngine/test.json', "r") as f:

BankData = json.loads(f.read())

x = json.loads(json.dumps(BankData))

f = csv.writer(open("/Users/vrindabv/Documents/PycharmProjects/BankStatementEngine/test.csv", "w"))

f.writerow(["userID", "Is salary credited before 5th", "Avg Salary of last 3 months", "Avg Salary of last 6 months", "Avg Balance before salary of last 3 months", "Avg Balance before salary of last 6 months"])

for y in x:

f.writerow([x["userID"], x["Is salary credited before 5th"],

x["Avg Salary of last 3 months"],

x["Avg Salary of last 6 months"],

x["Avg Balance before salary of last 3 months"],

x["Avg Balance before salary of last 6 months"]])

产量

userID,Is salary credited before 5th,Avg Salary of last 3 months,Avg Salary of last 6 months,Avg Balance before salary of last 3 months,Avg Balance before salary of last 6 months

679d3bad-155e-4b39-9ff7-7d564f408942,Yes,15453.33,15290.5,113.15,105.22

所以,我在这里得到了我的答案,但不是打印一次,而是打印7次。我怎么修理这个?