How to do null combination in pandas dataframe

Question

Here's my dataset

Id    Column_A    Column_B    Column_C
1         Null           7        Null
2            8           7        Null
3         Null           8           7
4            8        Null           8

If at least one column is null, Combination will be Null

Id    Column_A    Column_B    Column_C   Combination
1         Null           7        Null         Null
2            8           7        Null         Null
3         Null           8           7         Null
4            8        Null           8         Null

user7864386 · Accepted Answer · 2022-04-08 05:16:19Z

3

Assuming Null is NaN, we could use isna + any:

df['Combination'] = df.isna().any(axis=1).map({True: 'Null', False: 'Notnull'})

If Null is a string, we could use eq + any:

df['Combination'] = df.eq('Null').any(axis=1).map({True: 'Null', False: 'Notnull'})

Output:

   Id Column_A Column_B Column_C Combination
0   1     Null        7     Null        Null
1   2        8        7     Null        Null
2   3     Null        8        7        Null
3   4        8     Null        8        Null

answered Apr 8, 2022 at 5:16

user7864386

Sign up to request clarification or add additional context in comments.

Comments

jezrael · Accepted Answer · 2022-04-08 05:30:06Z

1

Use DataFrame.isna with DataFrame.any and pass to numpy.where:

df['Combination'] = np.where(df.isna().any(axis=1), 'Null','Notnull')
df['Combination'] = np.where(df.eq('Null').any(axis=1), 'Null','Notnull')

answered Apr 8, 2022 at 5:30

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Collectives™ on Stack Overflow

How to do null combination in pandas dataframe

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related