CODEWITHSUNDEEP
pythonpandasnumpydataframe
CentAu
CentAu

Reputation: 11160

Pandas, conditional column assignment based on column values

How can I have conditional assignment in pandas by based on the values of two columns? Conceptually something like the following:

Column_D = Column_B / (Column_B + Column_C) if Column_C is not null else Column_C

Concrete example:

import pandas as pd
import numpy as np
df = pd.DataFrame({'b': [2,np.nan,4,2,np.nan], 'c':[np.nan,1,2,np.nan,np.nan]})


     b    c
0  2.0  NaN
1  NaN  1.0
2  4.0  2.0
3  2.0  NaN
4  NaN  NaN

I want to have a new column d whose result is division of column b by sum of b and c, if c is not null, otherwise the value should be the value at column c. Something conceptually like the following:

df['d'] = df['b']/(df['b']+df['c']) if not df['c'].isnull() else df['c']

desired result:

     b    c         d
0  2.0  NaN       NaN
1  NaN  1.0       1.0
2  4.0  2.0       0.66
3  2.0  NaN       NaN
4  NaN  NaN       NaN

How can I achieve this?

Upvotes: 6

Views: 10383

Answers (1)

MaxU - stand with Ukraine
MaxU - stand with Ukraine

Reputation: 210832

try this (if you want to have your desired result set - checking b column):

In [30]: df['d'] = np.where(df.b.notnull(), df.b/(df.b+df.c), df.c)

In [31]: df
Out[31]:
     b    c         d
0  2.0  NaN       NaN
1  NaN  1.0  1.000000
2  4.0  2.0  0.666667
3  2.0  NaN       NaN
4  NaN  NaN       NaN

or this, checking c column:

In [32]: df['d'] = np.where(df.c.notnull(), df.b/(df.b+df.c), df.c)

In [33]: df
Out[33]:
     b    c         d
0  2.0  NaN       NaN
1  NaN  1.0       NaN
2  4.0  2.0  0.666667
3  2.0  NaN       NaN
4  NaN  NaN       NaN

Upvotes: 11

Related Questions