Python数据框使用引号(“)导出到csv [英] Python data frame Export to csv with Quotation marks (")

问题描述

如何使用双引号将python数据帧导出到csv.我试过下面的代码，但它不在输出文件中.我需要"column1"，"column2"，column3"之类的结果...请帮助.

How to export python dataframe to csv with double quotes. I have tried with below code but its not coming in output file. I need results like "column1","column2",column3"... Please help.

exportPath=exportPath+'\\data2Upload.csv'
header=['Country','Indicator','Unit','Frequency','Date','Value']
data.to_csv(exportPath,columns=header,sep=',',quotechar='"',index=False)

推荐答案

您可以使用csv.QUOTE_ALL属性告诉熊猫默认情况下引用所有内容:

You can tell pandas to quote everything by default using the csv.QUOTE_ALL property:

data.to_csv(exportPath, columns=header,sep=",",quotechar='"',index=False,
            quoting=csv.QUOTE_ALL)

官方Python文档: https://docs.python.org /2/library/csv.html#csv.QUOTE_ALL

Official Python docs: https://docs.python.org/2/library/csv.html#csv.QUOTE_ALL

这篇关于Python数据框使用引号(“)导出到csv的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！