首先，你的JSON具有嵌套对象，因此通常无法直接将其转换为CSV。你需要将其更改为以下内容：
{ "pk": 22, "model": "auth.permission", "prename": "add_logentry", "content_type": 8, "name": "Can add log entry"},......]这是从中生成CSV的代码：
import csvimport jsonx = """[ { "pk": 22, "model": "auth.permission", "fields": { "prename": "add_logentry", "name": "Can add log entry", "content_type": 8 } }, { "pk": 23, "model": "auth.permission", "fields": { "prename": "change_logentry", "name": "Can change log entry", "content_type": 8 } }, { "pk": 24, "model": "auth.permission", "fields": { "prename": "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 linef.writerow(["pk", "model", "prename", "name", "content_type"])for x in x: f.writerow([x["pk"], x["model"], x["fields"]["prename"], x["fields"]["name"], x["fields"]["content_type"]])你将获得以下输出：
pk,model,prename,name,content_type22,auth.permission,add_logentry,Can add log entry,823,auth.permission,change_logentry,Can change log entry,824,auth.permission,delete_logentry,Can delete log entry,8
