How to use multiple IF conditional statement using python

Question

I am trying to use an Conditional IF statement using python but not getting the expected Output. Please suggest what can be done next to it.

Input Data :

Col1        Col2         Col3    Col4
No Gap     India         80
All Gaps   USA           85
No Gap     India         95
All Gaps   Maxico        90

The code i have been trying so far:

if df['Col1'] == "No Gaps" and df['Col2'] == "India" and df['Col3'] >=85:
    df['Col4'] = "No"
else:
    df['Col4'] = "Yes"

Getting the Error:

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

Please Suggest.

jezrael · Accepted Answer · 2021-04-14 07:03:56Z

2

Use numpy.where:

df['Col4'] = np.where((df['Col1'] == "No Gap") & 
                      (df['Col2'] == "India") & 
                      (df['Col3'] >=85), 'No', 'Yes')
print (df)
       Col1    Col2  Col3 Col4
0    No Gap   India    80  Yes
1  All Gaps     USA    85  Yes
2    No Gap   India    95   No
3  All Gaps  Maxico    90  Yes

answered Apr 14, 2021 at 7:03

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jezrael · Accepted Answer · 2021-04-14 07:07:20Z

0

You can also do this by using apply() method:

df['col4']=df.apply(lambda x:'No' if (x['Col1'] == "No Gap") and (x['Col2'] == "India") and (x['Col3'] >=85) else 'yes',1)

edited Apr 14, 2021 at 7:07

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

answered Apr 14, 2021 at 7:05

Anurag Dabas

24.3k9 gold badges25 silver badges41 bronze badges

1 Comment

Anurag Dabas Over a year ago

Yeah I know @jazrael...I added this in answer :)

Collectives™ on Stack Overflow

How to use multiple IF conditional statement using python

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related