find common rows based on specific columns in a dataframe

Question

I have a dataframe, I would like to find the common rows based on a specific columns.

packing_id  col1  col2  col3 col4
1            1.0  2.0
2            2.0  2.0
3            1.0  1.0
4            3.0  3.0
.             .    .
.             .    .

I would like to find the rows where the col1 and col2 values are the same. I tried np.where(df.col1==df.col2) but it is not the right approach. I would appreciate your advice. Thanks.

Does this answer your question? Pandas conditional creation of a series/dataframe column — Vishnudev Krishnadas
– Vishnudev Krishnadas, Commented Mar 24, 2021 at 8:23

jezrael · Accepted Answer · 2021-03-24 08:21:47Z

1

I think your soluton is good, only add 2 parameters to np.where:

df['new'] = np.where(df.col1==df.col2, 'same', 'no same')

If need filter them:

df1 = df[df.col1==df.col2]

answered Mar 24, 2021 at 8:21

jezrael

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

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

Comments

Sam · Accepted Answer · 2021-03-24 08:24:25Z

1

This should be work. Thanks

df[df.col1==df.col2]

answered Mar 24, 2021 at 8:24

Sam

4142 gold badges7 silver badges24 bronze badges

Collectives™ on Stack Overflow

find common rows based on specific columns in a dataframe

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related