python将dataframe写入csv_python - 将Pandas DataFrame写入CSV文件_python_酷徒编程知识库

python 2

(其中"df"是你的DataFrame對象。)for column in df.columns:

for idx in df[column].index:

x = df.get_value(idx,column)

try:

x = unicode(x.encode('utf-8','ignore'),errors ='ignore') if type(x) == unicode else unicode(str(x),errors='ignore')

df.set_value(idx,column,x)

except Exception:

print 'encoding error: {0} {1}'.format(idx,column)

df.set_value(idx,column,'')

continue

然後嘗試：df.to_csv(file_name)

你可以通過以下方式檢查列的編碼：for column in df.columns:

print '{0} {1}'.format(str(type(df[column][0])),str(column))

警告errors ='ignore'將省略字元，例如，IN: unicode('Regenexxxae',errors='ignore')

OUT: u'Regenexx'

python 3for column in df.columns:

for idx in df[column].index:

x = df.get_value(idx,column)

try:

x = x if type(x) == str else str(x).encode('utf-8','ignore').decode('utf-8','ignore')

df.set_value(idx,column,x)

except Exception:

print('encoding error: {0} {1}'.format(idx,column))

df.set_value(idx,column,'')

continue