Skip to main content
 首页 » 编程设计

python之将 json 的结果写入 csv

2025年05月04日21bhlsheji

<分区>

我正在使用 DictWriter,因为我认为它会更容易,但我无处可去。我试图将我的 json 文件写入一个 csv 文件,每个字段都在它自己的列中。

json文件:

[ {"district": "4",  
"id": "DEL000027",  
"full_name": "Gerald L. Brady", "party": "Democratic",  
"email": "Gerald.Brady@state.de.us"},  
{"district": "37",  
"id": "DEL000028", "full_name": "Ruth Briggs  King",  
"party": "Republican",  
"email": "Ruth.BriggsKing@state.de.us"}] 

这是我写的脚本:

import json, csv 
 
mainFile = open("vote.json", "r") 
data = json.load(mainFile) 
 
with open('names.csv','w') as csvfile: 
    values = ['full_name', 'party', 'district','email'] 
    writer = csv.DictWriter(csvfile, fieldnames=values) 
 
writer.writeheader() 
for item in data: 
    writer.writerows(item)<----- error but don't know why it's an error