/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 vote107 views1 answer
Django admin required decorator
Python
0 vote117 views1 answer
Python how to compress pytorch model
Python
4 votes112 views1 answer
Iterating over 2d array python
Python
6 votes110 views3 answers
Tkinter filedialog filename
Python
-1 vote115 views1 answer
Print(shahzaib)
Python
0 vote103 views1 answer
Numpy.ndarray' object has no attribute 'diff'
Python
14 votes128 views3 answers
Python int to bytes
Python
42 votes113 views4 answers
Replace column values pandas
Python
0 vote119 views1 answer
Exec eval python
Python
3 votes115 views3 answers
Python find file name
Python