import pandas as pd
直接生成Excel
df.to_excel(filename)
生成的同时修改sheet名称
df.to_excel(filename,sheet_name='sample')
多个dataframe写入一个文件
with pd.ExcelWriter('stocks.xlsx') as writer:
df1.to_excel(writer, sheet_name='df1')
df2.to_excel(writer, sheet_name='df2')
pass