/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 vote139 views1 answer
Get text content dynamo civil 3d
Python
0 vote195 views1 answer
Write a python program to find fibonacci series upto a certain limit using while loop
Python
0 vote144 views1 answer
Get a list of ids from queryset django
Python
2 votes174 views2 answers
How to check django rest framework version
Python Django
1 vote128 views1 answer
Extract first letter of column python
Python
1 vote127 views1 answer
Numpy random float array between 0 and 1
Python
0 vote147 views1 answer
Field 'id' expected a number but got <django.db.models.fields.related_descriptors.create_forward_many_to_many_manager.<locals>.ManyRelatedManager object at 0x7fb02044de80>
Python
0 vote128 views1 answer
Mak a scipy csr sparse matrix
Python
0 vote146 views1 answer
Django strptime
Python
0 vote134 views1 answer
Bash escape double quote windows batch
Python