Answers for "filter dataframe based on contains"

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

pandas filter dataframe if an elemnt is in alist

In [30]:
df[df['id'].isin(['foo','bar'])]

Out[30]:
   value   id
0      1  foo
1      2  bar