IF conditional statement not working while using Python

Question

I am trying to execute a script under 2 conditions, If both the conditions are satisfied then only further code can be executed.

Input Data: Sheet1

Name        Contact_number  id_number    accuracy
Eric        9786543628      AZ256hy         90
Jack        9786543628      AZ98kds         85
Tom         9784533930      AZ256hc         80
Alan        9778934593      AZ256py         70

Sheet2

Name        Contact_number  id_number 
Eric        9786543628      AZ256hy  
Jack        9786543628      AZ98kds   
Tom         9784533930      AZ256hc   
David       9778984893      JH657lv

Expected Output:

Name        Contact_number  id_number 
    Eric        9786543628      AZ256hy  
    Jack        9786543628      AZ98kds

Code i have been using :

df = pd.read_excel(open(r'input.xlsx', 'rb'), sheet_name='sheet1')
df2 = pd.read_excel(open(r'input.xlsx', 'rb'), sheet_name='sheet2')

if df['id_number'] = df2['id_number']  and df['accuracy'] =>85:
   df['Name'][index] = df2['Name']
   df['Contact_number'][index] = df2['Contact_number']

But while using this condition the if statement is not working with AND condition. Any suggestion ?

@Barmar - Yes Typing error, Corrected it. How looping over the rows in the dataframes can be done ? — Manz
– Manz, Commented Apr 8, 2021 at 18:57
@MayankPorwal - Question has been updated with expected output — Manz
– Manz, Commented Apr 8, 2021 at 19:05

anisoleanime · Accepted Answer · 2021-04-08 19:03:24Z

3

Edit: I made changes to the conditions. This should work

df = pd.read_excel(open(r'input.xlsx', 'rb'), sheet_name='sheet1')
df2 = pd.read_excel(open(r'input.xlsx', 'rb'), sheet_name='sheet2')

df.loc[(df['id_number'] == df2['id_number']) & (df['accuracy']>= 85),['Name','Contact_number', 'id_number']]

edited Apr 8, 2021 at 19:03

answered Apr 8, 2021 at 18:44

anisoleanime

4193 silver badges11 bronze badges

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

2 Comments

Barmar Over a year ago

I suspect this is a copying error, since that wouldn't work without the and condition and they'd get a syntax error in either case.

Mayank Porwal Over a year ago

I don't think this is the right way to compare two series.

Mayank Porwal · Accepted Answer · 2021-04-09 06:19:01Z

2

You can use Series.isin:

In [1998]: res = df1[df1.id_number.isin(df2.id_number) & df1.accuracy.ge(85)]

In [1999]: res
Out[1999]: 
   Name  Contact_number id_number  accuracy
0  Eric      9786543628   AZ256hy        90
1  Jack      9786543628   AZ98kds        85

EDIT: If you want only certain columns:

In [2089]: res = df1[df1.id_number.isin(df2.id_number) & df1.accuracy.ge(85)][['Name', 'Contact_number']]

In [2090]: res
Out[2090]: 
   Name  Contact_number
0  Eric      9786543628
1  Jack      9786543628

edited Apr 9, 2021 at 6:19

answered Apr 8, 2021 at 19:10

Mayank Porwal

34.2k9 gold badges45 silver badges65 bronze badges

3 Comments

Manz Over a year ago

what would be the case if i need to extract only two columns [''Name", "Contact_number"] values after satisfying the condition

Mayank Porwal Over a year ago

Do res[['Name', 'Contact_number']]

Manz Over a year ago

Please suggest how to get only 2 specified columns. how we can get it.

Collectives™ on Stack Overflow

IF conditional statement not working while using Python

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related