Answers for "check if dataframe has values R"

check if dataframe contains infinity

df.replace([np.inf, -np.inf], np.nan).dropna(subset=["col1", "col2"], how="all")

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