Dataframe - Add multiple together with sometimes different index

Asked Aug 25 '20 at 02:15

Active Aug 25 '20 at 02:44

Viewed 28 times

I have 3 dataframes that have sometimes different index but still important datasets. combining them with merge or concat doesn't work and leaves to duplicate indexes or removes some of the index values where they are not contained in each of them.

They look like this,

index - potatoes
a     -    1
b     -    2
d     -    3
index - eggs
a     -    1
c     -    2
d     -    3
index - bacon
b     -    1
c     -    1
d     -    3

The output I want is

index - potatoes - eggs - bacon
a     -    1     -  1   - NaN
b     -    2     - NaN  -  1

Whats the best pathway?

edited Aug 25 '20 at 02:44

asked Aug 25 '20 at 02:15

LeCoda

2

what happened to `c` and `d`? Are these dataframes or series? – Marat Aug 25 '20 at 02:37
dataframes - they are separate key-values, so NaN for some index types – LeCoda Aug 25 '20 at 02:38
2

It is unclear to me – BENY Aug 25 '20 at 02:42
2

Why does concat not work? `pd.concat([df1, df2, df3], axis=1)` – RichieV Aug 25 '20 at 02:49
Actually it did work with axis, lol, so simple thanks – LeCoda Aug 25 '20 at 02:51

Dataframe - Add multiple together with sometimes different index

0 Answers0