/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 votes144 views1 answer
Add two column values of a datframe into one
Python
3 votes152 views2 answers
Pandas - from umeric to string
Python
89 votes154 views4 answers
New env in conda
Python
0 vote201 views1 answer
Get or create django
Python Django
0 vote149 views1 answer
How to show installed tkinter fonts
Python
10 votes123 views1 answer
Registering static files in jango
Python
0 vote147 views3 answers
In is_lodes_form( : Missing id-axis pairings.
Python
1 vote159 views1 answer
Internet Explorer Selenium
Python
0 vote167 views2 answers
Turtle.write("Sun", move=False, align="left", font=("Arial", 8, "normal"))
Python
0 vote138 views1 answer
Text replace
Python