PYTHON

export pandas dataframe as excel

df.to_excel(r'C:UsersRonDesktopFile_Name.xlsx', index = False)

#if you omit the file path (must also omit 'r') and 
#enter only file_name.xlsx, it will save to your default file location,
# that is, where the file you're reading from is located.

df to excel

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

export a dataframe to excel pandas

#Python, pandas
#To export a pandas dataframe into Excel

df.to_excel(r'Path where you want to store the exported excel fileFile Name.xlsx', index = False)

pandas write to excel

# Create a Pandas Excel writer using XlsxWriter as the engine.
writer = pd.ExcelWriter('LTD Report Data.xlsx', engine='xlsxwriter')

# Write each dataframe to a different worksheet.
seg_2019.to_excel(writer, sheet_name='Seg 2019', index = False)
seg_2020.to_excel(writer, sheet_name='Seg 2020', index = False)
seg_2021.to_excel(writer, sheet_name='Seg 2021', index = False)
seg_2022.to_excel(writer, sheet_name='Seg 2022', index = False)

# Close the Pandas Excel writer and output the Excel file.
writer.save()

python script to write dataframe on excel

df.to_excel('pandas_to_excel.xlsx', sheet_name='new_sheet_name')

save dataframe as excel file

In [6]: titanic.to_excel("titanic.xlsx", sheet_name="passengers", index=False)

python dataframe to excel

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()  # 保存

python script to write dataframe on excel

import pandas as pd
import openpyxl

df = pd.DataFrame([[11, 21, 31], [12, 22, 32], [31, 32, 33]],
                  index=['one', 'two', 'three'], columns=['a', 'b', 'c'])

print(df)
#         a   b   c
# one    11  21  31
# two    12  22  32
# three  31  32  33

convert excel workbook to dataframe

workbook = pd.ExcelFile('***.xls')
sheets = workbook.sheet_names

df = pd.concat([pd.read_excel(workbook, sheet_name=s)
                .assign(sheet_name=s) for s in sheets])

python script to write dataframe on excel

$ pip install xlwt
$ pip install openpyxl

pandas to excel

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