pandas check if column contains string 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: 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

Example 4: python check if dataframe series contains string

mel_count=a['Names'].str.contains('Mel').sum()
if mel_count>0:
    print ("There are {m} Mels".format(m=mel_count))