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 vote87 views1 answer
:: python
Python
0 vote132 views1 answer
Comment all selected lines in python
Python
0 vote134 views2 answers
Python suppress print output from function
Python
35 votes141 views2 answers
How to run cmd line commands in python
Python
0 vote126 views1 answer
Unable to import flask pylint
Python
0 vote148 views1 answer
Object deconstruction python
Python
0 vote145 views1 answer
Python calling method from constructor
Python
4 votes141 views1 answer
Python gt index in for cycle
Python
0 vote131 views1 answer
Creating venv on vscode linux
Python
0 vote130 views1 answer
Python how to convert csv to array
Python