Pandas: Combine two dataframe with the samse structure

Asked Jan 15 '18 at 15:03

Active Jan 15 '18 at 15:03

Viewed 49 times

I'm using python 2.7 and I have two dataframes like this:

df1

| index |  colA   |  colB  | colC |
-----------------------------------
|   1   |    A    |  None  |   X  |
|   2   |   None  |  None  |   D  |
|   3   |    B    |   C    | None |

df2

| index |  colA   |  colB  | colC |
-----------------------------------
|   1   |   None  |  None  | None |
|   2   |    Y    |   Z    | None |
|   3   |   None  |   None | None |

My objective is to combine them in one dataframe containing a minimum of None values. both dataframes have same index.

df3

| index |  colA   |  colB  | colC |
-----------------------------------
|   1   |    A    |  None  |   X  |
|   2   |    Y    |   Z    |   D  |
|   3   |    B    |   C    | None |

asked Jan 15 '18 at 15:03

Omar14

2,007
4
21
34

2

It seems dupe, need `df = df1.combine_first(df2)` or `df = df1.fillna(df2)` – jezrael Jan 15 '18 at 15:04
do you know the difference between combine_first, fillna and update ? – Omar14 Jan 18 '18 at 11:29
Nort easy answering, maybe you can create question for it. – jezrael Jan 18 '18 at 11:38
Ok i will do it . – Omar14 Jan 18 '18 at 11:49

Pandas: Combine two dataframe with the samse structure

0 Answers0