Python Intersection of two Dataframe

Question

I need to intersect data frame. So I executed the following code. But I cannot get the result I want.

df1 = pd.Dataframe([
      ['psy', 180, 75],
      ['psy', 180, 75]
], columns = ['name', 'height', 'weight'])

df2 = pd.Dataframe([
      ['psy', 180, 75],
      ['df', 160, 65],
      ['ddqq', 170, 75],
      ['psy', 180, 75]
], columns = ['name', 'height', 'weight'])

print(pd.merge(df1, df2, how='inner'))

Output

  name  height  weight
0 psy   180     75
1 psy   180     75
2 psy   180     75
3 psy   180     75

But I want the below results.

 name  height  weight
0 psy   180     75
1 psy   180     75

How can I get the following result? Please Tell me...

I think it is because the same name psy for 2 rows pandas is confused how to join. You can try by name=ing them psy1 and psy2 then you will get desired result. — Epsi95
– Epsi95, Commented Nov 5, 2021 at 4:27

Derek O · Accepted Answer · 2021-11-05 18:32:07Z

1

You can drop duplicates from one of the DataFrames. For example:

pd.merge(df1, df2.drop_duplicates(), how='inner')

Output:

  name  height  weight
0  psy     180      75
1  psy     180      75

edited Nov 5, 2021 at 18:32

answered Nov 5, 2021 at 4:50

Derek O

20.2k4 gold badges32 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

Python Intersection of two Dataframe

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