how to save a pandas DataFrame to an excel file?

Question

I am trying to load data from the web source and save it as a Excel file but not sure how to do it. What should I do?

import requests
import pandas as pd
import xmltodict


url = "https://www.kstan.ua/sitemap.xml"
res = requests.get(url)
raw = xmltodict.parse(res.text)

data = [[r["loc"], r["lastmod"]] for r in raw["urlset"]["url"]]
print("Number of sitemaps:", len(data))
df = pd.DataFrame(data, columns=["links", "lastmod"])

Answer 1

df.to_csv("output.csv", index=False)

OR

df.to_excel("output.xlsx")

Answer 2

You can write the dataframe to excel using the pandas ExcelWriter, such as this:

import pandas as pd
with pd.ExcelWriter('path_to_file.xlsx') as writer:
    dataframe.to_excel(writer)