import pandas as pd
df.to_excel("File_Name.xlsx', index = False)

{"tags":[{"tag":"textarea","content":"# Save single dataframe to a single sheet\ndf.to_excel(excel_writer= 'file_name.xls',sheet_name='sheet_1',\n startrow=1, startcol=1) # These are optional args\n\n# Alternative approach : use context manager\n# Save multiple dataframes in different sheets\ndf_list = [df1,df2,df3]\nsheet_list = ['sheetA','sheetB','sheetC']\n\nfor df, sheet in zip(df_list,sheet_list):\n\twith pd.ExcelWriter('file_name.xlsx') as writer:\n \t\tdf.to_excel(excel_writer=writer, sheet_name=sheet)","code_language":"python"}]}

#Python, pandas
#To export a pandas dataframe into Excel
df.to_excel(r'Path where you want to store the exported excel file\File Name.xlsx', index = False)

import numpy as np
import pandas as pd
import openpyxl
data_df = pd.DataFrame(mean)
data_df.columns = ['A','B','C','D','E','F','G','H','I','J'] #将第一行的0,1,2,...,9变成A,B,C...
data_df.index = ['a','b','c','d','e','f','g','h','i','j']
writer = pd.ExcelWriter('test.xlsx') # 创建名称为test的excel表格
data_df.to_excel(writer, 'page_1',
float_format='%.2f') # float_format 精度，将data_df写到test表格的第一页中。若多个文件，可以在page_2中写入
writer.save() # 保存

df1 = pd.DataFrame([['a', 'b'], ['c', 'd']], index=['row 1', 'row 2'], columns=['col 1', 'col 2'])
df1.to_excel("output.xlsx")