How to Export Pandas DataFrame to CSV and Excel File
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!!
Program 1
import pandas as pd
#df=pd.read_excel("E://mypandas/employee.xlsx")
#print(df)
#df['totalsalary']=df['HRA']+df['TA']+df['DA']
# print(df)
# df.to_excel("E://mypandas/employee.xlsx",index=False)
# print("Sucess")
#print(df)
df=pd.read_csv("E://mypandas/employee.csv")
df['totalsalary']=df['HRA']+df['TA']+df['DA']
df.to_csv("E://mypandas/employee.csv",index=False)
print("Sucess")
Did we exceed your expectations?
If Yes, share your valuable feedback on Google
