pandas column search string code example

Example 1: python search for word is in column

df[df.column.str.contains("word")]

Example 2: panda search strings in column

# find rows in `df1` which contain "foo" followed by something
df1[df1['col'].str.contains(r'foo(?!$)')]

      col
1  foobar