Answers for "search for specific data in rows based on a condition pandas"

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 look for values in column with condition

# The common syntax is df.loc[], the condition is put in the bracket

#Eg, look for rows with column1 > 5 and column2 = 3
df.loc[(df['column_1'] > 5) & (df['column_2'] = 3)]