pandas filter out specific text 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: get columns containing string
df2 = df.filter(regex='spike')
print(df2)
Example 3: panda search strings in column
df[df['A'].str.contains("hello")]