/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 vote116 views1 answer
Count how many times a value shows in python list
Python
0 vote159 views2 answers
ImportError: /usr/local/lib/python3.7/dist-packages/cv2/cv2.cpython-37m-arm-linux-gnueabihf.so: undefined symbol: __atomic_fetch_add_8
Python
0 vote81 views1 answer
Keras callbacks
Python
0 vote143 views1 answer
Repeat every entru n times
Python
0 vote128 views2 answers
How to display csv in pandas
Python
55 votes121 views3 answers
Python read values from file
Python
5 votes149 views2 answers
Django admin password reset
Python Django
2 votes134 views1 answer
Python IRR calculation
Python
0 vote81 views1 answer
Keras.utils.plot_model keeps telling me to install pydot and graphviz
Python
0 vote149 views1 answer
Isolationforest estimators
Python