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

5 votes203 views2 answers
Numpy calculate standard deviation
Python
1 vote158 views1 answer
How to run the server in django
Python
0 vote162 views1 answer
Z transform in python
Python
0 vote175 views1 answer
Nlp = spacy.load('en') error
Python
2 votes191 views2 answers
How to read then overwrite a file with python
Python
0 vote171 views1 answer
Python yyyymmdd
Python
0 vote164 views1 answer
Python class optional attributes
Python
0 vote168 views1 answer
How to convert a matrix string back to a matrix python
Python
1 vote213 views1 answer
Passing user instance django form submission
Python Django
0 vote166 views1 answer
Run python script on remote server
Python