Pandas DataFrame where() Method

Program 1

Pandas Dataset 1

Pandas Dataset 2

Pandas Dataset 3

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)