get rows where values are strings pytoh code example

Example 1: pandas filter string contain

df[df['A'].str.contains("hello")]

Example 2: dataframe column contains string

df[df['A'].str.contains("hello")]

Example 3: column contains substring python

df2 = df.filter(regex='spike')
print(df2)