python to csv参数,如何在Python中使用pandas.to_csv方法指定列类型（我需要字符串）？...

import pandas as pd

data = {'x':['011','012','013'],'y':['022','033','041']}

Df = pd.DataFrame(data = data,type = str)

Df.to_csv("path/to/save.csv")

解决方案

To achieve such result it will be easier to export directly to xlsx file, even without setting dtype of DataFrame.

import pandas as pd

writer = pd.ExcelWriter('path/to/save.xlsx')

data = {'x':['011','012','013'],'y':['022','033','041']}

Df = pd.DataFrame(data = data)

Df.to_excel(writer,"Sheet1")

writer.save()

I've tried also some other methods like prepending apostrophe or quoting all fields with ", but it gave no effect.