将多个excel表写入一个循环代码表中

Question

sheet1=[FC_filter1,FC_filter2,FC_filter3]
with pd.ExcelWriter(path, mode='a', if_sheet_exists='replace', engine="openpyxl") as writer:
FC_filter1.to_excel(writer, sheet_name='FC_filter1',index='False')
FC_filter2.to_excel(writer, sheet_name='FC_filter2',index='False')
FC_filter3.to_excel(writer, sheet_name='FC_filter3',index='False')

我们能用for循环把这个代码变成一行吗？而不是每次都提到FC_filter1,2,3？

Answer 1

使用带enumerate的sheet1循环来命名从1开始计数的纸张。这假设你的过滤器的名称像1,2,3，。。。如果没有，您可以将数据保存为字典，名称为键(字符串(，df为值，并在for循环中访问它们。

sheet1=[FC_filter1,FC_filter2,FC_filter3]
with pd.ExcelWriter(path, mode='a', if_sheet_exists='replace', engine="openpyxl") as writer:
for i, fc in enumerate(sheet1, 1):
fc.to_excel(writer, sheet_name=f'FC_filter{i}',index='False')