DataFlair

pandas dataframe where method

Pandas DataFrame where() Method 0

Pandas Tutorials

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

How to Use where() in Python Pandas 0

Pandas Tutorials

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)