python中csv文件的JSON键和值

Question

这是我的文件_t.JSON am正在将请求内容写入csv/JSON文件

{"w1":"R"}
{"w2":"R2"}
{"w3":"R3"}
{"w4":"R4"}
{"w5":"R5"}

我希望我下面的代码能给我下面的结果输出.csv在

^{pr2}$

这是我的密码

import csv

f1 = file ("output.csv","w")

f2 = file ("file_t.JSON","rU")

with open("file_t.JSON") as f:
    csvr = csv.reader(f, delimiter=' ')
    csvr.next()
    for rec in csvr:
        key, values_txt = rec
        values = values_txt.split(',')
        print key, values
        f1.write(values)

它不是打印，而是写入输出文件。在

Answer 1

逐行读取JSON文件，并使用^{}将每一行转换为Python字典。然后将其写入CSV文件：

import csv
import json

with open("file_t.JSON") as infile, open('output.csv', 'w') as outfile:
    writer = csv.writer(outfile, delimiter=' ')
    for line in infile:
        d = json.loads(line)
        writer.writerows(d.items())