Pandas add dataframes side to side with different indexes

Question

I have dataframes like this:

        Sender                    USD_Equivalent
725     ABC                               5777527.31
330     CFE                               4717812.90
12      CDE                               3085838.19

        Sender                    USD_Equivalent
707     AAP                               1962412.94
149     EFF                               1777705.37
189     EFG                               1744705.37

And I want them like this :

Sender     USD_Equivalent   Sender   USD_Equivalent
 ABC         5777527.31      AAP       1962412.94
 CFE         4717812.90      EFF       1777705.37
 CDE         3085838.19      EFG       1744705.37

Thanks

`pd.concat` with `ignore_index` keyword should work. – hilberts_drinking_problem Jul 31 '17 at 16:17 — hilberts_drinking_problem, Jul 31 '17 at 16:17
Why would you want duplicate column names? – Zero Jul 31 '17 at 16:17 — Zero, Jul 31 '17 at 16:17

score 5 · Accepted Answer · answered Jul 31 '17 at 16:18

5

pd.concat([d.reset_index(drop=True) for d in [df1, df2]], axis=1)

  Sender  USD_Equivalent Sender  USD_Equivalent
0    ABC      5777527.31    AAP      1962412.94
1    CFE      4717812.90    EFF      1777705.37
2    CDE      3085838.19    EFG      1744705.37

answered Jul 31 '17 at 16:18

piRSquared

285,575
57
475
624

1

There's always a room for improvement +1 – Bharath M Shetty Jul 31 '17 at 16:27

Pandas add dataframes side to side with different indexes

1 Answers1

Linked