Merging two data frames on rows in python

Question

I am trying to merge data frames in python on Fruit, the two tables are below. any suggestions would be great I have tried a variety of things but I cant get it to work. The below two tables are what I currently have.

Thank you in advance.

Table 1:

Fruit    |    appl | orange |  kiwi
Shop     |         |        |         
 :-----------------------------------:                   
1        |    NaN  | 0.275  |   NaN
2        |     0.4 | -0.600 |   0.2
3        |    0.7  |   NaN  |   NaN
4        |    NaN  |   NaN  |   0.2
5        |    0.3  | 0.350  |   NaN
6        |    NaN  | 0.250  |   NaN
7        |    NaN  |   NaN  |   0.2
8        |    0.4  | 0.400  |   NaN

Table 2:

Fruit    |    kiwi| orange |  appl 
 :-----------------------------------:                   
   x     |    0.4 | 0.275  |   0.2

Final Product:

Fruit    |    appl | orange |  kiwi
Shop     |         |        |         
 :-----------------------------------:                   
1        |    NaN  | 0.275  |   NaN
2        |     0.4 | -0.600 |   0.2
3        |    0.7  |   NaN  |   NaN
4        |    NaN  |   NaN  |   0.2
5        |    0.3  | 0.350  |   NaN
6        |    NaN  | 0.250  |   NaN
7        |    NaN  |   NaN  |   0.2
8        |    0.4  | 0.400  |   NaN
 :-----------------------------------:                   
   x     |    0.2  | 0.275  |   0.4

Can you format your table better, and provide some data that is immediately readable from Python? Expected output would also be helpful. — Tai
– Tai, Commented Jan 5, 2018 at 16:22
@Georgy so far I have tried to use pandas but struggling to get the result I want. — lmccann
– lmccann, Commented Jan 5, 2018 at 16:34

zipa · Accepted Answer · 2018-01-05 16:38:46Z

1

To append one dataframe to another with same column order use:

df1.reindex_axis(sorted(df1.columns), axis=1).append(df2.reindex_axis(sorted(df2.columns), axis=1))

Please take note that Fruit Shop and Fruit columns should be set as index of their respective dataframe.

edited Jan 5, 2018 at 16:38

answered Jan 5, 2018 at 16:36

zipa

28k6 gold badges45 silver badges62 bronze badges

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

2 Comments

Pyd Over a year ago

different names in dfs Fruit and fruit shop, you did not handle that

zipa Over a year ago

@pyd Added that those should be set to index.

Karl Anka · Accepted Answer · 2018-01-05 16:42:32Z

0

If I understand your problem correct you could use pd.concat. In your case table_final = pd.concat([table1, table2]). If not specified the concatenation is done on column names, so the column ordering does not matter - apple will be merged with apple.

answered Jan 5, 2018 at 16:42

Karl Anka

2,9092 gold badges21 silver badges34 bronze badges

Collectives™ on Stack Overflow

Merging two data frames on rows in python

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related