Answers for "pd check if series contains element"

check if dataframe contains infinity

df.replace([np.inf, -np.inf], np.nan).dropna(subset=["col1", "col2"], how="all")

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))