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

35 votes207 views2 answers
Convert into date python
Python
67 votes200 views6 answers
Activate venv
Python
1 vote214 views1 answer
Py get mouse coordinates
Python
0 vote220 views1 answer
Igraph adjacency matrix python
Python
3 votes215 views1 answer
Access the value in settings django
Python
0 vote225 views1 answer
Numpy mask without losing shape
Python
17 votes194 views6 answers
Int to list python
Python
0 vote214 views1 answer
Python calculate variance by hand
Python
0 vote224 views1 answer
Django queryset to form
Python Django
0 vote217 views1 answer
K-means clustering and disabling clusters
Python