python json转csv_python – 如何将JSON转换为CSV？

我不知道这个问题是否已经解决已经或不，但让我粘贴我已经做了参考。

首先，您的JSON具有嵌套对象，因此通常无法直接转换为CSV。

你需要改变，像这样：

{

"pk": 22,

"model": "auth.permission",

"codename": "add_logentry",

"content_type": 8,

"name": "Can add log entry"

},

......]

这里是我的代码生成CSV从：

import csv

import json

x = """[

{

"pk": 22,

"model": "auth.permission",

"fields": {

"codename": "add_logentry",

"name": "Can add log entry",

"content_type": 8

}

},

{

"pk": 23,

"model": "auth.permission",

"fields": {

"codename": "change_logentry",

"name": "Can change log entry",

"content_type": 8

}

},

{

"pk": 24,

"model": "auth.permission",

"fields": {

"codename": "delete_logentry",

"name": "Can delete log entry",

"content_type": 8

}

}

]"""

x = json.loads(x)

f = csv.writer(open("test.csv", "wb+"))

# Write CSV Header, If you dont need that, remove this line

f.writerow(["pk", "model", "codename", "name", "content_type"])

for x in x:

f.writerow([x["pk"],

x["model"],

x["fields"]["codename"],

x["fields"]["name"],

x["fields"]["content_type"]])

您将获得输出：

pk,model,codename,name,content_type

22,auth.permission,add_logentry,Can add log entry,8

23,auth.permission,change_logentry,Can change log entry,8

24,auth.permission,delete_logentry,Can delete log entry,8