Articles → Pandas → To_Excel Function In Pandas

To_Excel Function In Pandas






Purpose





Example


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")



Output


Picture showing the output of to_excel function in pandas
Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Thursday, May 9, 2019

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250