如何在Python中使用pandas.to_csv方法指定列类型(我需要字符串)? [英] How to specify column type(I need string) using pandas.to_csv method in Python?

问题描述

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")

我得到的结果似乎是这样的

推荐答案

要获得这种结果，即使不设置DataFrame的dtype，也可以将其直接直接导出到xlsx文件.

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.

这篇关于如何在Python中使用pandas.to_csv方法指定列类型(我需要字符串)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！