for each row in dataframe search for string in columns code example
Example 1: get columns containing string
df2 = df.filter(regex='spike')
print(df2)
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