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

0 vote327 views1 answer
Django form is onvalid
Python Django
1 vote338 views1 answer
Count how many times a value shows in python list
Python
3 votes334 views2 answers
Swap list items in python
Python
2 votes373 views1 answer
Add header to table in pandas
Python
0 vote342 views1 answer
Pytorch dataloader to numpy array
Python
0 vote344 views1 answer
Compile python folder
Python
1 vote358 views2 answers
Merge multiple excel workssheets into a single dataframe
Python
1 vote328 views1 answer
Get attribute in selenium python
Python
1 vote325 views1 answer
Change shortcuts in pychar,
Python
8 votes326 views1 answer
Python get actual timestamp
Python