python json到csv,json.decoder. jsondecodeerror:从:第1行第67列(char

Question

json.decoder.JSONDecodeError: Unterminated string starting at: line 1 column 67 (char 66)

Python无法识别JSON中的某些字符。我尝试了很多编码，但仍然不能正确显示。JSON文件非常大，我想跳过无法识别的行并继续工作

下面是我的代码，帮我修改一下使用参数'ignore'

# -*-coding:utf-8-*-
import csv
import json
import sys
import codecs

def trans(path):
jsonData = codecs.open('‪C:/Users/jeri/Desktop/1.json', 'r', encoding='utf-8')
# csvfile = open(path+'.csv', 'w')
# csvfile = open(path+'.csv', 'wb')
csvfile = open('‪C:/Users/jeri/Desktop/1.csv', 'w', encoding='utf-8',
newline='')
writer = csv.writer(csvfile, delimiter=',')
flag = True
for line in jsonData:
dic = json.loads(line)
if flag:
keys = list(dic.keys())
print(keys)
writer.writerow(keys)
flag = False
writer.writerow(list(dic.values()))
jsonData.close()
csvfile.close()
if __name__ == '__main__':
path = str(sys.argv[0])
print(path)
trans(path)

Answer 1

尝试创建一个全新的文件并将json数据粘贴到那里并将扩展名更改为。json尝试导入该文件并查看是否可以修复错误