how to apply if else to result of an operation on dataframe pandas

Question

For e.g. to get a row out of dataframe if it contains certain text got result using following link

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

where hello is present in column A of dataframe or not

this command prints the output

but i want to apply an if else on result such that if (it contains): do this else: do that

if i directly apply if else i get an error

if(df[df['A'].str.contains("hello")]):
    print("present")   // or any action
else:
    print("Not present")

error:Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()

How to apply if else to result

I think `np.where` is what need. – jezrael Jan 20 '21 at 12:58 — jezrael, Jan 20 '21 at 12:58

score -1 · Answer 1 · answered Jan 20 '21 at 13:00

-1

Do this:

if any(df[df['A'].str.contains("hello")]):
    print("present")  # or any action
else:
    print("Not present")

answered Jan 20 '21 at 13:00

Suhas Mucherla

1 Answers1