Python CSV 解析 "§"字符

Question

我正在尝试在 python 中解析包含 § 字符的 .csv 文件，例如:

Name;Paragraph
Spam;§15

以及以下代码:

import csv
pathAndFileName = r"D:\Spam\test.csv"
with open(pathAndFileName, newline='') as csvFile:
    reader = csv.DictReader(csvFile, delimiter=';', quotechar='"')
    csvObject= []
    for row in reader:
        csvObject.append(row)
    print(csvObject)

然而，出于某种原因，它被解析成这样:

[OrderedDict([('Name', 'Spam'), ('Paragraph', '§15')])]

因此，显然 § 字符被解析为 §。

发生这种情况有原因吗？我该如何解决？

Answer 1

使用encoding='utf-8'

示例 2.csv:

Name;Paragraph
Spam;§15

因此:

import csv
pathAndFileName = r"example2.csv"
with open(pathAndFileName, newline='', encoding='utf-8') as csvFile:
    reader = csv.DictReader(csvFile, delimiter=';', quotechar='"')
    csvObject= []
    for row in reader:
        csvObject.append(row)
    print(csvObject)

输出:

[OrderedDict([('Name', 'Spam'), ('Paragraph', '§15')])]