Merge returns empty dataframe in pandas

Question

I run Python 3.6 on Windows 10.

My code is the following:

data1
     Loan_ID    Gender
1   LP001003    Male
2   LP001005    Male
3   LP001006    Male
4   LP001008    Male
5   LP001011    Male

data2
    Loan_ID2    LoanAmount
1   LP001003    128.0
2   LP001005    66.0
3   LP001006    120.0
4   LP001008    141.0
5   LP001011    267.0

data_merged = data1.merge(right= data2, how='inner',left_on='Loan_ID', right_on = 'Loan_ID2',right_index=True, sort=False)

data_merged.shape
(0, 4)

BENY · Accepted Answer · 2018-05-01 15:24:33Z

3

You do not need right_index within merge

df1.merge(df2,left_on='Loan_ID',right_on='Loan_ID2')
Out[54]: 
    Loan_ID Gender  Loan_ID2  LoanAmount
0  LP001003   Male  LP001003       128.0
1  LP001005   Male  LP001005        66.0
2  LP001006   Male  LP001006       120.0
3  LP001008   Male  LP001008       141.0
4  LP001011   Male  LP001011       267.0

answered May 1, 2018 at 15:24

BENY

324k22 gold badges176 silver badges250 bronze badges

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

2 Comments

user8270077 Over a year ago

Could you please explain why the right_index created a problem?

BENY Over a year ago

@user8270077 when you are doing the merge and type right_index you are Use the index from the left DataFrame as the join key(s).

cs95 · Accepted Answer · 2018-05-01 15:23:58Z

2

Try renaming your column in data2, this'll simplify your merge code a bit.

data1.merge(data2.rename(columns={'Loan_ID2' : 'Loan_ID'}), on='Loan_ID')

    Loan_ID Gender  LoanAmount
0  LP001003   Male       128.0
1  LP001005   Male        66.0
2  LP001006   Male       120.0
3  LP001008   Male       141.0
4  LP001011   Male       267.0

answered May 1, 2018 at 15:23

cs95

406k106 gold badges744 silver badges797 bronze badges

Comments

dportman · Accepted Answer · 2018-05-01 15:28:10Z

0

Just remove the right_index part:

data_merged = pd.merge(data1, data2, how='inner',left_on='Loan_ID', right_on = 'Loan_ID2', sort=False)

answered May 1, 2018 at 15:28

dportman

1,11910 silver badges20 bronze badges

Collectives™ on Stack Overflow

Merge returns empty dataframe in pandas

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related