Python CSV 到 JSON 引用嵌套对象

Question

我正在使用以下内容将 CSV 文件转换为 JSON。问题是，任何嵌套对象都会被引用。我该如何解决这个问题，以便将输出传递到端点？

def csvToJson(tokenHeader):

data = []

with open('CSV/quiz-questions.csv') as questionFile:

    csv.field_size_limit(sys.maxsize)

    csvReader = csv.DictReader(questionFile)

    for row in csvReader:

        row = {key: (None if value == "" else value) for key, value in row.items()}

        row = {key: ([] if value == "[]" else value) for key, value in row.items()}

        data.append(json.dumps(row, indent=4, ensure_ascii=False))

输出片段：

"question": "{'guid': ...

Answer 1

我通过在写作方面处理事情来解决这个问题。将我的问题传递到 CSV 中时，我正在用我的嵌套对象创建一个字典。从 CSV 读取时，这会引起头痛。所以现在我使用这一行来修复我的嵌套对象：question = {key: (json.dumps(value) if key in ['question', etc. etc.] else value) for key, value in question.items()}

Answer 2

您可以使用此函数将 csv 读入具有列的字典列表：值结构：import csvdef open_csv(path):    '''return a list of dictionaries    '''    with open(path, 'r') as file:        reader = csv.DictReader(file)        # simple way to do the replacements, but do you really need to do this?        return [{k: [] if v == '[]' else v or None                 for k, v in dict(row).items()}                for row in reader]data = open_csv('test.txt')# output to json because it looks better, null is Noneimport jsonprint(json.dumps(data, indent=4))测试.csvname,age,hobby,countriesfoo,31,,"['123', 'abc']"bar,60,python programming,[]输出：[    {        "name": "foo",        "age": "31",        "hobby": null,        "countries": "['123', 'abc']"    },    {        "name": "bar",        "age": "60",        "hobby": "python programming",        "countries": []    }]