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

0 vote342 views1 answer
List square python
Python
15 votes346 views3 answers
How to delete in python
Python
0 vote372 views1 answer
Convert price to float python
Python
49 votes348 views6 answers
Python measure time
Python
0 vote327 views1 answer
If query empty print python
Python
0 vote337 views1 answer
Reveal a defined function in python
Python
63 votes364 views3 answers
How to calculate sum of a list in python
Python
0 vote368 views1 answer
Access dict elements with dot
Python
122 votes357 views6 answers
Rename columns in python
Python
2 votes374 views3 answers
Fibonacci series python using function
Python