python to_excel参数解释_python-TypeError：to_excel()为参数’sheet_name’获得了多个值

我试图将不同的数据框保存到不同的工作表,如下所示：

import pandas as pd

from pandas import ExcelWriter

import xlsxwriter

// code

bio = BytesIO()

with pd.ExcelWriter(bio, engine='xlsxwriter') as writer:

dfStats.to_excel(writer, sheet_name='Summary')

dfStockdata.to_excel(writer, sheet_name='HistoricalISIN')

# create the workbook

writer.save() // tried both with and without this line

bio.seek(0)

workbook = bio.read()

excelFile = workbook

但是,我收到以下错误：

TypeError: to_excel() got multiple values for argument 'sheet_name'

我该如何解决？

解决方法:

您可以尝试使用：

writer = pd.ExcelWriter('output//out.xlsx', engine='xlsxwriter')

dfStats.to_excel(writer, sheet_name='Summary')

dfStockdata.to_excel(writer, sheet_name='HistoricalISIN')

writer.save()

标签：pandas,python-3-x,python