Pandas where

In [20]: df
Out[20]:
   A  B  C
0  1  2  1
1  2  3  0
2  3  4  0
3  4  5  1

# Note that df.C is a mask
# Note that this is np.where, not df.where. That is different.
In [21]: df['D'] = np.where(df.C, df.A, df.B)

In [22]: df
Out[22]:
   A  B  C  D
0  1  2  1  1
1  2  3  0  3
2  3  4  0  4
3  4  5  1  4

Source: stackoverflow.com

Similar codes

12 votes159 views1 answer
Create new env in anaconda
Python
3 votes166 views2 answers
Cv2.cv2 has no attribute face
Python
0 vote148 views1 answer
Python disable logging on unittest
Python
0 vote168 views1 answer
Top automotive blogs
Python
5 votes168 views1 answer
Pandas predict average moving
Python
34 votes152 views5 answers
Remove substring python
Python
0 vote241 views1 answer
Convert method to str python
Python
7 votes158 views1 answer
Pandas insert column in the beginning
Python
8 votes149 views2 answers
Python iterate backwards through list
Python
0 vote144 views1 answer
Python get cookie from browser
Python