Replace column value with another column value if condition met

Question

I have a df in which I first split col1 at "-". This results "None" values in col3 if delimiter does not exist in the col1.

Now, if col3 is "None", I want to replace it with col2 values (inplace replacement)

#df
 col1 col2 col3
45-65 45 65   
   56 56 None

#desired df
 col1 col2 col3
45-65 45 65   
   55 55 55

How can I do this in pandas.

BeRT2me · Accepted Answer · 2022-04-22 03:14:28Z

1

df = df.ffill(axis=1)
print(df)

Output:

    col1 col2 col3
0  45-65   45   65
1     56   56   56

answered Apr 22, 2022 at 3:14

BeRT2me

13.3k2 gold badges18 silver badges39 bronze badges

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

1 Answer 1