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

3 votes276 views2 answers
Who invented python
Python
0 vote282 views1 answer
Tyjacsav
Python
1 vote271 views1 answer
In pandas how to start an index from a specific number
Python
34 votes267 views6 answers
Name columns pandas
Python
0 vote275 views1 answer
Scrapy get raw html content of selector innerhtml
Python
2 votes261 views1 answer
How to reapete the code in python
Python
0 vote274 views1 answer
Test with python
Python
1 vote281 views6 answers
Insertion sort
Python
-1 vote262 views1 answer
Pytube3
Python
1 vote261 views1 answer
Selenium close current driver but don't quit
Python