How to Use where() in Python Pandas

Program 1 import pandas as pd df=pd.read_excel(“E:\mypandas\mydata.xlsx”,sheet_name=’Result’) print(df) print(“—————After Where————–“) df.set_index(‘Name’,inplace=True) #print(df.where(df<75,’First’)) #print(df.where(df[‘HSC’]<75,’First’)) df1=df.where(lambda x: x < 80, ‘A+’) print(df1)