/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 vote98 views1 answer
Pandas filter length of string
Python
0 vote108 views1 answer
Python running mean pandas
Python
2 votes93 views1 answer
Install telethon
Python
19 votes137 views6 answers
Install Django in Windows
Python Django
0 vote140 views1 answer
Django tempalte tag datetime to timestamp
Python Django
0 vote101 views1 answer
Access dynamicall to name attribute python
Python
0 vote98 views1 answer
Convert_text_to_hexadecimal_viva.py in python
Python
0 vote94 views1 answer
Qpushbutton clicked
Python
5 votes112 views3 answers
How to add images in hml while using flask
Python
0 vote68 views1 answer
Check if environment variable exists
Python