/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 vote138 views2 answers
Closures in python
Python
59 votes135 views6 answers
How to get current date in python
Python
0 vote171 views1 answer
Onetoone vs foreign key django
Python Django
0 vote150 views1 answer
How to change the colour of axes in matplotlin
Python
0 vote137 views1 answer
Highlighting the shortest path in a Networkx graph
Python
0 vote144 views1 answer
Group by, aggregate multiple column -pandas
Python
8 votes157 views1 answer
How to run python in atom
Python
3 votes162 views1 answer
Matplotlib text too small
Python
1 vote146 views2 answers
Fast fourier transform python
Python
33 votes152 views4 answers
How to install pyaudio
Python