help with exporting functions to excel

[sandeep_ganga]

If you are trying to export to new csv/excel file having head(), describe(), mean(),median(), mode() etc of given input file, you may try below and see if that helps.

import pandas as pd
 
data = pd.read_csv("inputbook.csv",encoding='latin-1')
data.columns = [c.replace(' ', '_') for c in data.columns] 
data.columns = [c.replace("'", '') for c in data.columns]

info_dict = data.head()
descdata=data.describe()
meandata=data.mean()
mediandata=data.median()
modedata=data.mode()

db=pd.DataFrame(columns=['------------empty line-----------------'])


open("output.csv", 'w')  #empty the csv file
descdata.to_csv("output.csv", mode='a', header=True)
db.to_csv('output.csv',mode='a',header=True)  #add empty line
info_dict.to_csv('output.csv', mode='a', header=True)
db.to_csv('output.csv',mode='a',header=True)  #add empty line
meandata.to_csv('output.csv',mode='a',header=True)
db.to_csv('output.csv',mode='a',header=True)  #add empty line
mediandata.to_csv('output.csv',mode='a',header=True)
db.to_csv('output.csv',mode='a',header=True)  #add empty line
modedata.to_csv('output.csv',mode='a',header=True)

Best Regards,
Sandeep

GANGA SANDEEP KUMAR