How to merge using index items with Pandas

Question

I have two dataframes df_a and df_b. Both dataframes have index with three items (id / sub_id / sort_id).

I would like to merge these two dataframes with index items.

** df_a **
                      | c1 | c2 | c3 | 
id | sub_id | sort_id |    |    |    | 
 1 |      1 |       3 |   a|   b|   c| 
 2 |      1 |       1 |   a|   b|   c| 
 3 |      1 |       2 |   a|   b|   c| 

** df_b **
                      | c1 | c2 | c3 | 
id | sub_id | sort_id |    |    |    | 
 1 |      1 |       3 |   x|   y|   z| 
 2 |      1 |       1 |   x|   y|   z| 
 3 |      1 |       2 |   x|   y|   z|

However I had a KeyError: 'id'

df_merge = pd.merge(df_a, df_b, how='left', left_index=True, right_index=True, left_on=['id','sub_id','sort_id'], right_on=['id','sub_id','sort_id'])

How can I merge these two dataframes?

sacuL · Accepted Answer · 2018-11-27 03:32:15Z

2

Since you are trying to merge on the index, you specify left_index=True, right_index=True, which is correct, but then you can't specify left_on or right_on (the information is redundant, and not accepted):

>>> pd.merge(df_a, df_b, left_index=True, right_index=True)
                  c1_x c2_x c3_x c1_y c2_y c3_y
id sub_id sort_id                              
1  1      3          a    b    c    x    y    z
2  1      1          a    b    c    x    y    z
3  1      2          a    b    c    x    y    z

answered Nov 27, 2018 at 3:32

sacuL

51.6k9 gold badges88 silver badges115 bronze badges

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

Collectives™ on Stack Overflow

How to merge using index items with 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