To_Excel Function In Pandas

import pandas as pd

# Create a dictionary
dict = {
    "company": ["Google", "Microsoft", "Apple", "Google", "Microsoft", "Apple"],
    "year": [2017, 2017, 2017, 2018, 2018, 2018],
    "Profit": [20000, 40000, 60000, 80000, 70000, 50000],
}


# Create a dataframe
df = pd.DataFrame(dict, index=[0, 1, 2, 3, 4, 5])


df.to_excel("c:\\temp\\gyan.xlsx", index=False, sheet_name="Test")

Query/Feedback