Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!!
Program 1
import pandas as pd
df=pd.read_excel("D://mypandas/studentinfo.xlsx")
print(df)
df.set_index('Name',inplace=True)
print(df)
print("------------------------------------------")
df1=df.where(lambda x:x<80,'A+')
print(df1)
df1.to_excel("D://resultdata/agrade.xlsx")
print("------------------------------------------")
df2=df.where(lambda x:x>80,'B+')
print(df2)
df2.to_excel("D://resultdata/bgrade.xlsx")
print("--------Success--------------")
# print(df)
# print("------------------------------------")
# df=df.where(df['SSC']<80,'First')
# print(df)
# print(df)
# print("------------------------------------")
# df1=df.where(df<80,'First')
# #print(df.where(df<80,'First'))
# print("------------------------------------")
# print(df1)
# df2=df.where(df>80,'Second')
# print("------------------------------------")
# print(df2)
#df.where(condition,repalce value)
