pandas merge dataframe based on same value in columns

Question

i have 2 dataframe as below:

   student_name student_id   
1  may          0000  
2  june         1111  
3  july         2222 

  member_id member_name school_name
1 A0        april       MIT
2 B0        may         NIT
3 C0        june        LIT

i want to join the 2 dataframe in a way to produce result as below.

student_name student_id member_id member_name school_name
may          0000       B0        may         NIT
june         1111       C0        june        LIT

i am think in sql way where student_name = member_name. but i hardly able to do it in pandas.

i have try pandas merge which can base on one same name column. can you teach me a simple method to make the required results.

thank you.

EdChum · Accepted Answer · 2015-11-02 13:17:46Z

9

Use merge and pass the columns to merge on for left_param and right_param respectively:

In [27]:
df.merge(df1, left_on='student_name', right_on='member_name')

Out[27]:
  student_name  student_id member_id member_name school_name
0          may           0        B0         may         NIT
1         june        1111        C0        june         LIT

answered Nov 2, 2015 at 13:17

EdChum

397k204 gold badges836 silver badges583 bronze badges

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

2 Comments

pinky Over a year ago

how to do if i only need to school_name column? i am google-ing the pandas merge details, but if u can enlighten me abit more. thank you. student_name student_id school_name

EdChum Over a year ago

Just sub-select from the merged df: merged['student_name','student_id','school_name']

Collectives™ on Stack Overflow

pandas merge dataframe based on same value in columns

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related