Python JSON数据加载令人困惑的 "expecting , delimiter"错误

Question

尝试实现此代码并不断收到以下错误。我已经搜索并尝试了一切，但没有什么能让我过去。

import json
import sys
import re
import os
reload(sys)
sys.setdefaultencoding('utf8')
path = '/Users/.../'  #(The actual path is in my code)
textfiles = []
for root, dirs, files in os.walk(r'/Users/.../'):
    for file in files:
        if file.endswith(".txt"):
            textfiles.append(file)
        for filename in textfiles:
            with open(path + filename) as json_data:
                data = json.load(json_data)
                opinion = data['plain_text']
                f = open(path + filename, 'w')
                f.write(opinion)
                f.close()

然后，我不断收到此错误:

ValueError: Expecting , delimiter: line 17 column 3 (char 765)

Answer 1

显然你的问题出在 JSON 文件中。但是是哪一个？哪里？？

如果您放入 try/except 子句，您可以记录并查看哪些文件导致问题，以便您可以更轻松地进行调试。

import json
import sys
import re
import os
reload(sys)
sys.setdefaultencoding('utf8')
path = '/Users/.../'  (The actual path is in my code)
textfiles = []
for root, dirs, files in os.walk(r'/Users/.../'):
    for file in files:
        if file.endswith(".txt"):
            textfiles.append(file)
        for filename in textfiles:
            try:
                with open(path + filename) as json_data:
                    data = json.load(json_data)
                    opinion = data['plain_text']
                    f = open(path + filename, 'w')
                    f.write(opinion)
                    f.close()
            except ValueError as e:
                print(filename) # Gives the filename
                print(e)  # Gives the location of the problem in the file

它还应该继续遍历文件并提供有问题的错误。

您甚至可以保存到 log.txt 以便稍后处理..

这是一个小例子

lst = [1, 2, '3', 4, 5]

for i in lst:
    try:
        l = 123 + i
        print(l)
    except Exception as e:
        print(e)

输出:

124
125
unsupported operand type(s) for +: 'int' and 'str'
127
128