How to Export Pandas DataFrame to CSV and Excel File
Free Pandas course with real-time 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")
Your opinion matters
Please write your valuable feedback about DataFlair on Google
