if text in pandas row code example

Example 1: filter by row contains pandas

In [3]: df[df['ids'].str.contains("ball")]  # removes all rows where 'ball' not in row['ids']
Out[3]:
     ids  vals
0  aball     1
1  bball     2
3  fball     4

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