python 保存csv 编码_用Python保存UTF8 CSV

我一直在努力解决这个问题，并且读了很多帖子，但我似乎不能让它发挥作用。我需要保存一个UTF-8csv文件。在

首先，我的超简单方法是：#!/usr/bin/env python

# -*- coding: utf-8 -*-

import csv

import sys

import codecs

f = codecs.open("output.csv", "w", "utf-8-sig")

writer = csv.writer(f, delimiter=',', quotechar='"', quoting=csv.QUOTE_MINIMAL)

cells = ["hello".encode("utf-8"), "nǐ hǎo".encode("utf-8"), "你好".encode("utf-8")]

writer.writerow(cells)

这会导致错误：

^{pr2}$

#!/usr/bin/env python

# -*- coding: utf-8 -*-

import csv

import sys

import codecs

import cStringIO

class UnicodeWriter:

"""

A CSV writer which will write rows to CSV file "f",

which is encoded in the given e