pandas :to_excel()float_format [英] Pandas: to_excel() float_format
问题描述
我试图让float_format
参数与pandas的to_excel()
函数一起使用,但似乎没有任何作用.
代码:
df = pd.DataFrame({
'date':['1/15/2016','2/1/2016','2/15/2016','3/15/2016'],
'numA':[1000,2000,3000,4000.3],
'numB':[10000,20000.2,30000,40000]
})
writer = pd.ExcelWriter('c:/.../pandas_excel_test.xlsx', engine = 'xlsxwriter')
print df.dtypes
df.to_excel(writer,
index = False,
float_format = '%.2f',
)
但是Excel文件看起来像这样:
我确认dtype为:
date object
numA float64
numB float64
dtype: object
有人知道如何正确格式化to_excel()
中的浮点数吗?
我相信Excel格式会更改浮点数的显示方式.我尝试了to_csv
方法,并且float_format
起作用了.对于excel,告诉excel如何显示该列会有所帮助:
df = pd.DataFrame({
'date':['1/15/2016','2/1/2016','2/15/2016','3/15/2016'],
'numA':[1000,2000,3000,4000.3],
'numB':[10000,20000.2,30000,40000]
})
writer = pd.ExcelWriter('c:/.../pandas_excel_test.xlsx', engine = 'xlsxwriter')
df.to_excel(writer, index=False, sheet_name='Sheet1')
workbook = writer.book
worksheet = writer.sheets['Sheet1']
format1 = workbook.add_format({'num_format': '0.00'})
worksheet.set_column('C:C', None, format1) # Adds formatting to column C
writer.save()
结果:
更多信息: http://xlsxwriter.readthedocs.io/example_pandas_column_formats.html >
I'm trying to get the float_format
parameter working with pandas' to_excel()
function, but it doesn't seem to do anything.
Code:
df = pd.DataFrame({
'date':['1/15/2016','2/1/2016','2/15/2016','3/15/2016'],
'numA':[1000,2000,3000,4000.3],
'numB':[10000,20000.2,30000,40000]
})
writer = pd.ExcelWriter('c:/.../pandas_excel_test.xlsx', engine = 'xlsxwriter')
print df.dtypes
df.to_excel(writer,
index = False,
float_format = '%.2f',
)
But the Excel file looks like this:
I confirmed dtypes as:
date object
numA float64
numB float64
dtype: object
Does anyone know how to properly format floats in to_excel()
?
I believe Excel formatting changes how floats are displayed. I tried to_csv
method and float_format
worked. For excel, telling excel how to display the column helps:
df = pd.DataFrame({
'date':['1/15/2016','2/1/2016','2/15/2016','3/15/2016'],
'numA':[1000,2000,3000,4000.3],
'numB':[10000,20000.2,30000,40000]
})
writer = pd.ExcelWriter('c:/.../pandas_excel_test.xlsx', engine = 'xlsxwriter')
df.to_excel(writer, index=False, sheet_name='Sheet1')
workbook = writer.book
worksheet = writer.sheets['Sheet1']
format1 = workbook.add_format({'num_format': '0.00'})
worksheet.set_column('C:C', None, format1) # Adds formatting to column C
writer.save()
Result:
More info: http://xlsxwriter.readthedocs.io/example_pandas_column_formats.html
这篇关于 pandas :to_excel()float_format的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!