I have a table that contains different columns. I want to create a new column “Outcome” based on conditional statements derived from 3 columns.

Columns: Column1, Column2 and Column3

New column to be created: Outcome

Column3 contains just two values: 0 and 100

My Code:

if ((df['Column1'] <= 10) & (df['Column2'] <= 15) & (df['Column3'] == 100)):
   df['Outcomes'] = "No Flood"
elif ((df['Column1'] > 10) & (df['Column2'] >= 15) & (df['Column3'] == 100)):
   df['Outcomes'] = "Flood"
elif (df['Column3'] == 0):
   df['Outcomes'] = "No Rain"

The error i’m getting: ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().