Python add pandas.core.series.Series to excel

I’m working with an excel from which I want to extract certain information and display it in another excel. Using pandas and openpyxl I was able to get the rows I needed to copy (whos type is “pandas.core.series.Series”) but I don’t know how to copy just those rows to an excel. Any ideas?

Answer

To export a pandas.Series to Excel.

df.to_excel("output.xlsx", sheet_name="Sheet_Name_1")

Documentation.