/Python/Pandas check if any of the values in one column exist in another

Pandas check if any of the values in one column exist in another

df["exists"] = df.drop("target", 1).isin(df["target"]).any(1)
print(df)

    target  A       B       C       exists
0   cat     bridge  cat     brush   True
1   brush   dog     cat     shoe    False
2   bridge  cat     shoe    bridge  True

Source: stackoverflow.com

Similar codes

24 votes138 views1 answer
Print type(x) in python
Python
1 vote96 views1 answer
Not bitwise operator python
Python
0 vote173 views1 answer
Max value indices
Python
0 vote143 views1 answer
Select inverse with conditions pandas
Python
1 vote176 views1 answer
Flask define template folder
Python Flask
6 votes141 views1 answer
Django model form
Python Django
0 vote112 views1 answer
Flask admin forgeign keys show literal
Python
234 votes343 views6 answers
Random in python
Python
2 votes135 views1 answer
Find the number of nan per column pandas
Python
0 vote129 views1 answer
Block content
Python