/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

1 vote188 views1 answer
How to change the values of a column in numpy array
Python
2 votes161 views1 answer
How to autosave in python
Python
0 vote186 views1 answer
How to delete all item in treeview tkinter
Python
3 votes166 views1 answer
Python3 return a list of indexes of a specific character in a string
Python
1 vote182 views1 answer
Pandas timedelta to seconds
Python
0 vote169 views1 answer
Php echo shorthand example
Python
19 votes166 views1 answer
How to change the scale of a picture in pygame
Python
0 vote157 views1 answer
Foreign key django createview
Python
2 votes197 views1 answer
How to align text in tkinter
Python
2 votes178 views1 answer
Running selenium on google colab
Python