Excelwriter python

>>> df1 = pd.DataFrame([["AAA", "BBB"]], columns=["Spam", "Egg"])
>>> df2 = pd.DataFrame([["ABC", "XYZ"]], columns=["Foo", "Bar"])
>>> with ExcelWriter("path_to_file.xlsx") as writer:
...     df1.to_excel(writer, sheet_name="Sheet1")
...     df2.to_excel(writer, sheet_name="Sheet2")

Source: pandas.pydata.org

Similar codes

1 vote146 views1 answer
Python return specific elements from list
Python
3 votes143 views4 answers
How to convert comma separated string to list in python
Python
1 vote143 views1 answer
Python how to change an element in a multi dimensional list
Python
1 vote139 views1 answer
Python make a shop menu
Python
1 vote140 views1 answer
Does the total number of subatomuc particles change during fusion
Python
0 vote166 views1 answer
Type conversions in python
Python
41 votes146 views2 answers
Print backwards python
Python
0 vote160 views1 answer
"jupyter (notebook OR lab)" ipynb "not trusted"
Python
0 vote151 views1 answer
Comparison python
Python
0 vote158 views1 answer
What does triple quotes mean in python
Python