/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

2 votes229 views2 answers
Useful python snippets
Python
65 votes209 views4 answers
Python csv dict reader
Python
9 votes191 views2 answers
Flask how to run app
Python
5 votes228 views2 answers
How to add icon to tkinter window
Python
0 vote237 views1 answer
Free function in python
Python
2 votes206 views2 answers
Np convert to int
Python
0 vote212 views1 answer
Download folder collab
Python
0 vote220 views1 answer
What is require_self
Python
7 votes207 views2 answers
How to get the remainder of a number when dividing in python
Python
28 votes206 views5 answers
String slicing in python
Python