python - 从包含 unicode 字符的 csv 文件导出数据

Question

我想从包含 unicode 字符串的 csv 文件导出数据。

之前我尝试过一个 Python 脚本，它仅适用于 ASCII 数据。但它也不支持 unicode 内容:

#! /usr/bin/env python
import csv
csv.register_dialect('custom',delimiter=','
                     doublequote=True,
                     escapechar=None,
                     quotechar='"',
                     quoting=csv.QUOTE_MINIMAL, skipinitialspace=False)
with open('input.csv') as ifile:
 data = csv.reader(ifile, dialect='custom')
 for record in data:
  for i, field in enumerate(record):
   print (" <field%s>" % i + field + "</field%s>" % i)

Traceback (most recent call last): for record in data: _csv.Error: line contains NULL byte

Answer 1

改用这个 unicode-csv 库

https://github.com/jdunck/python-unicodecsv

import unicodecsv as csv

with open('input.csv') as ifile:
  rows = [row for row in csv.reader(ifile, encoding='utf-8')]

print rows