/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 vote368 views1 answer
How to work with django ornm __in
Python Django
5 votes377 views3 answers
How to save unzipped files in python
Python
1 vote318 views1 answer
Python better while loop that count up
Python
0 vote336 views1 answer
Como fazer um bot spamm no discord com python
Python
0 vote396 views1 answer
How to create my own exception in python
Python
0 vote332 views1 answer
Accessing list inside dict python
Python
0 vote337 views1 answer
How to convert utf-16 file to utf-8 in python
Python
1 vote339 views2 answers
Check if response is 200 python
Python
0 vote341 views1 answer
Tqdm for jupyter notebook
Python
0 vote320 views1 answer
Pil
Python