/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

9 votes334 views5 answers
Pandas see all columns
Python
10 votes306 views3 answers
Write json pythonb
Python
1 vote304 views1 answer
Error bar plot python
Python
2 votes338 views1 answer
Python print dictionary line by line
Python
0 vote304 views2 answers
How to make a leaderboard in python
Python
0 vote378 views1 answer
Django set random password
Python
0 vote362 views4 answers
Plot idl
Python
1 vote308 views2 answers
How to get pc name with python
Python
1 vote319 views1 answer
Django link home page
Python
1 vote334 views1 answer
Python sort with comparator
Python