UnicodeDecodeError:“ascii”编解码器无法解码位置304中0xc3中的字节:序号不在范围(128)内

2024-04-26 00:48:45 发布

您现在位置:Python中文网/ 问答频道 /正文

我刚刚离开了工作的PC(使用Python2.7),有一个脚本,我刚刚完成(转载如下)。工作上很顺利,我只想加一两件事。但我回到家中,使用的是Mac版本的Python(3.2.2),出现了以下错误:

Traceback (most recent call last):
  File "/Users/Downloads/sda/alias.py", line 25, in <module>
    for row_2 in in_csv:
  File "/Library/Frameworks/Python.framework/Versions/3.2/lib/python3.2/encodings/ascii.py", line 26, in decode
    return codecs.ascii_decode(input, self.errors)[0]
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 304: ordinal not in range(128)

我的代码在这里:

import csv
inname = "Fund_Aliases.csv"
outname = "output.csv"

def first_word(value):
    return value.split(" ", 1)[0]

with open(inname, "r") as infile:
    with open(outname, "w") as out file:
      in_csv = csv.reader(infile)
      out_csv = csv.writer(outfile)

     column_names = next(in_csv)
     out_csv.writerow(column_names)

      id_index = column_names.index("id")
      name_index = column_names.index("name")

      try:
          row_1 = next(in_csv)
          written_row = False

          for row_2 in in_csv:
            if first_word(row_1[name_index]) == first_word(row_2[name_index]) and row_1[id_index] != row_2[id_index]:
                if not written_row:
                    out_csv.writerow(row_1)

                out_csv.writerow(row_2)
                written_row = True
            else:
                written_row = False

            row_1 = row_2
      except StopIteration:
        # No data rows!
        pass

Tags: csvnameinidindexnamesasciicolumn
1条回答
网友
1楼 · 发布于 2024-04-26 00:48:45

看起来Fund_Aliases.csv不是ascii文件。

根据Python3 docs

Since open() is used to open a CSV file for reading, the file will by default be decoded into unicode using the system default encoding (see locale.getpreferredencoding()). To decode a file using a different encoding, use the encoding argument of open:

with open('some.csv', newline='', encoding='utf-8') as f:
    reader = csv.reader(f)

因此,请尝试指定encoding参数。

相关问题 更多 >