如何在熊猫的数据帧上使用Excel内置格式(会计格式)

Question

我正在尝试在熊猫中输出我的数据帧以超越。

data = {'Names':['A', 'B', 'C', 'D'], Attending Cost’: [1, 1, 1, 1], 'Summary':[2, 2, 2, 2]}
data_2 = pd.DataFrame.from_dict(data)
writer = pd.ExcelWriter("test", engine='xlsxwriter')                
data_2.to_excel(writer, sheet_name='Sheet1', 
startrow=5)
writer.save()

我希望我可以在最后两列中使用Excel的内置会计格式，但我不知道该怎么做。任何帮助，不胜感激。

Answer 1

您走在正确的轨道上，您只需要将 excel 的会计格式添加到您的工作簿中。因此，继续使用您当前的代码：

data = {'Names':['A', 'B', 'C', 'D'], Attending Cost’: [1, 1, 1, 1], 'Summary':[2, 2, 2, 2]}
data_2 = pd.DataFrame.from_dict(data)
writer = pd.ExcelWriter("test", engine='xlsxwriter')                
data_2.to_excel(writer, sheet_name='Sheet1', 
startrow=5)
# get the clsx writer workbook and worksheet objects
workbook = writer.book
worksheet = writer.sheets['Sheet1']
# Add your accountancy format
format1 = workbook.add_format({'num_format': 44})
# Set format without assigning column width for columns C and D
worksheet.set_column('C:C', None, format1)
worksheet.set_column('D:D', None, format1)
# Close the pandas Excel Writer and output Excel File
writer.save()

可以在此处找到格式的完整列表。