check if substring is present in string python dataframe contains code example

Example 1: column contains substring python

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

Example 2: 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))