参考链接: python json 1-1:使用json.dump/dumps将JSON写入文件/字符串
我正在将一个包含多个记录的csv文件转换为一个带有json数组的文件。解决方案是How to find last line in csv file when using DictReader。这很好用,除了文件中生成的json有反斜杠(\)和双引号;也就是说,它转义字符串。例如:{"Test Name": "Basic Tcp IPerf Test", " \"Status\"": "PASS", " \"Test
Start Time\"": "20190103 08:07:41.662", " \"Test End Time\"":
"20190103 08:08:44.051", " \"Throughput\"": "2095.2746", "
\"Jitter\"": "", " \"Packet Loss %\"": "", " \"Compute/VM\"": "SendVm
(x.x.x.x)", " \"Statistics Sampling Start Time\"": "03 Jan 2019
08:07:44", " \"Statistics Sampling End Time\"": "03 Jan 2019
08:08:42", " \"Min CPU\"": "0", " \"Max CPU\"": "2", " \"Avg CPU\"":
"1", " \"Avg Memory (MB)\" ": "7758"}
有没有一种方法可以在不进行转义的情况下写出json?
代码:csvfile = open('fiile.csv','r')
jsonfile = open('file.json','w')
reader = csv.DictReader(csvfile)
jsonfile.write(json.dumps(list(reader)))