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



Click to Enlarge


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

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250