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(“————————————“)...
