/Python/Compare multiple columns in pandas

Compare multiple columns in pandas

Comparing two dataframe columns

comparison_column = np.where(df["col1"] == df["col2"], True, False)

Source: kite.com

Compare multiple columns in pandas

df['Result'] = (df.iloc[:, 1:4].values < df[['E']].values).all(axis=1).astype(int)
print (df)
   A   B   C   D   E  Result
0  V  10   5  18  20       1
1  W   9  18  11  13       0
2  X   8   7  12   5       0
3  Y   7   9   7   8       0
4  Z   6   5   3  90       1

Source: stackoverflow.com

Similar codes

0 vote291 views4 answers
Adaptive_average_pool-2d
Python
1 vote289 views1 answer
Werkzeug.datastructures.filestorage to numpy
Python
1 vote267 views2 answers
Rename files in a folder python
Python
0 vote280 views1 answer
ApiError('d984ac0ae28d4afda0ddb26e348db535', UploadError('path', UploadWriteFailed(reason=WriteError('malformed_path', None), upload_session_id='AAAAAAAAACLukDh6ck8ZUw'))) python
Python
5 votes287 views1 answer
Add bearer token in python request
Python
1 vote260 views1 answer
What is the size of cover in facebook
Python
0 vote277 views1 answer
Downloading datasets from ml.org repository
Python
1 vote246 views1 answer
For i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):
Python
6 votes271 views1 answer
Change maximum recursion depth python
Python
0 vote261 views1 answer
Mechanize python XE #29
Python