在python中导出utf-8 csv文件

Question

在python中导出utf-8 csv文件时遇到错误。错误说AttributeError: 'int' object has no attribute 'encode'首先，我使用pyodbc连接Microsoft Access数据库并在那里获取数据。MDB = "E:/Research/2000-01.mdb"; DRV = '{Microsoft Access Driver (*.mdb)}'; PWD = 'pw'con = pyodbc.connect('DRIVER={};DBQ={};PWD={}'.format(DRV,MDB,PWD))cur = con.cursor()SQL = 'SELECT * FROM 200001;'rows = cur.execute(SQL).fetchall()cur.close()con.close()然后使用该类，class UnicodeWriter:    """    A CSV writer which will write rows to CSV file "f",    which is encoded in the given encoding.    """def __init__(self, f, dialect=csv.excel, encoding="utf-8", **kwds):    # Redirect output to a queue    self.queue = cStringIO.StringIO()    self.writer = csv.writer(self.queue, dialect=dialect, **kwds)    self.stream = f    self.encoder = codecs.getincrementalencoder(encoding)()def writerow(self, row):    self.writer.writerow([s.encode("utf-8") for s in row])    # Fetch UTF-8 output from the queue ...    data = self.queue.getvalue()    data = data.decode("utf-8")    # ... and reencode it into the target encoding    data = self.encoder.encode(data)    # write to the target stream    self.stream.write(data)    # empty queue    self.queue.truncate(0)def writerows(self, rows):    for row in rows:        self.writerow(row)我开始写utf-8 csv文件with open("E:/Research/200001.txt", 'wb') as f:    writer = UnicodeWriter(f)    writer.writerows(rows)看起来每一行都包含一些整数和日期时间的东西。有解决这个问题的想法吗？非常感谢！

Answer 1

您可能需要先执行以下操作，然后再执行以下操作writer.writerows：

rows = [[unicode(x) for x in row] for row in rows]

或者，我的猜测是试图写数据库行ID的麻烦。因此，您也可以尝试将其切成薄片：

rows = [row[1:] for row in rows]