Python中Pandas数据帧的导出列表

Question

我正在尝试将pandas数据帧的列表导出到excel

list_of_df_to_dump = [df1,df2,...,df100]
list_of_tab_names = ['df1','df2',...,'df100']

writer = ExcelWriter(excel_name + '.xlsx')
for i,j in list_of_df_to_dump,list_of_tab_names:
     i.to_excel(writer,j,index = False)
writer.save()

我得到以下错误：

^{pr2}$

有什么想法可以解决这个问题，或者用其他方法来完成同样的事情？我不知道这个列表会在多长时间内手动完成

Answer 1

您必须使用zip来迭代两个列表中的项对。请尝试以下修复：

list_of_df_to_dump = [df1,df2,...,df100]
list_of_tab_names = ['df1','df2',...,'df100']

writer = ExcelWriter(excel_name + '.xlsx')
for df, tab_name in zip(list_of_df_to_dump, list_of_tab_names):
     df.to_excel(writer, tab_name, index=False)
writer.save()