stites stites - 18 days ago 9
Python Question

search for "does-not-contain" on a dataframe in pandas

I've done some searching and can't figure out how to filter a dataframe by

df["col"].str.contains(word)
, however I'm wondering if there is a way to do the reverse: filter a dataframe by that set's compliment. eg: to the effect of
!(df["col"].str.contains(word))
.

Can this be done through a
DataFrame
method?

Answer

You can use the invert (~) operator (which acts like a not for boolean data):

~df["col"].str.contains(word)

contains also accepts a regular expression...