If-Else-Pandas

Sat 17 May 2025

title: "If Else Pandas" author: "Rj" date: 2019-04-24 description: "-" type: technical_note draft: false source: http://pandas.pydata.org/pandas-docs/version/0.24/user_guide/cookbook.html#idioms

import numpy as np
import pandas as pd

df = pd.DataFrame({
    'maths' : [80, 89, 90, 20],
    'science' : [40, 50, 90, 100],
    'language' : [20, 30, 90, 95]
})

df
maths science language
0 80 40 20
1 89 50 30
2 90 90 90
3 20 100 95 
df['masc_pass'] = np.where((df['maths'] > 50) & (df['science'] > 50), 'pass', 'fail')

df
maths science language masc_pass
0 80 40 20 fail
1 89 50 30 fail
2 90 90 90 pass
3 20 100 95 fail 
df['pass'] = np.where((df['maths'] > 50) & (df['science'] > 50) & (df['language'] > 50), 'pass', 'fail')

df
maths science language masc_pass pass
0 80 40 20 fail fail
1 89 50 30 fail fail
2 90 90 90 pass pass
3 20 100 95 fail fail

Score: 5

Category: data-wrangling