/Python/Write multiple DataFrames to Excel files

Write multiple DataFrames to Excel files

# Write multiple DataFrames to Excel files
with pd.ExcelWriter('pandas_to_excel.xlsx') as writer:    
    df.to_excel(writer, sheet_name='sheet1')    
    df2.to_excel(writer, sheet_name='sheet2')
    
# Append to an existing Excel file    
path = 'pandas_to_excel.xlsx'
with pd.ExcelWriter(path) as writer:
    writer.book = openpyxl.load_workbook(path)
    df.to_excel(writer, sheet_name='new_sheet1')
    df2.to_excel(writer, sheet_name='new_sheet2')

Source: pythonbasics.org

Similar codes

0 vote302 views1 answer
Map function to change type of element in python
Python
0 vote149 views1 answer
Python glob how to read all txt files in folder
Python
22 votes147 views6 answers
List to dict python
Python
0 vote155 views1 answer
How to create a cubic function in python 3
Python
0 vote178 views1 answer
Def identity_block(X, f, filters, training=True, initializer=random_uniform):
Python
6 votes155 views2 answers
Print image python
Python
0 vote137 views1 answer
AttributeError: module 'psycopg2' has no attribute 'connection'
Python
0 vote136 views1 answer
Computecost pyspark
Python
13 votes156 views5 answers
Finding the maximum value in a list python
Python
4 votes160 views1 answer
How to find the last item of a list
Python