I have a df,
delta1 delta2
0 -1
2 0
-1 0
0 0
I am wondering how to assign values of delta2 to delta1 only if delta1 > 0 and delta2 <= 0; the result look like,
delta1 delta2
0 -1
0 0
-1 0
0 0
Using numpy.where:
df['delta1'] = np.where(df.delta1.gt(0) & df.delta2.le(0), df.delta2, df.delta1)
delta1 delta2
0 0 -1
1 0 0
2 -1 0
3 0 0
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With