compare two columns in a excel using pandas

Question

I have data with about 3 different columns in excel.

    COLUMN A = Product name_1
    Column B = type
    column C = PRODUCT NAME_2 .

I wanted to check the names in column C against column A and if it matches, then extract the corresponding column B value. Main excel sheet:

| column a | column b |column c|
| -------- | ---------|--------|
| apple    | 1        |  apple |
| microsoft| 0        |cognizant|
|google    |2         |amazon  |
|cognizant |0         |
|amazon    |1         |

and expected output as below:

    | column A | COLUMN b |
    | -------- | -------- |
    | apple    |  1       |
    | cognizant|  0       |
    |amazon    |  1       |

Can anyone suggest a function of code in which I can do this without actually having to go through all of them row by row?

Thanks

Mayank Porwal · Accepted Answer · 2021-01-20 15:20:27Z

1

Use df.isin:

In [1668]: df[df['column a'].isin(df['column c'])][['column a', 'column b']]
Out[1668]: 
    column_a  column_b
0      apple         1
3  cognizant         0
4     amazon         1

answered Jan 20, 2021 at 15:20

Mayank Porwal

34.2k9 gold badges45 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

compare two columns in a excel using pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related