Add data from a dataframe to another

Question

I'd like to add data from a dataframe to a another dataframe.

Here my first data frame: df

Here my second dataframe: dff

df.append(dff, ignore_index=True, sort=False)

And it results me that:

try df.merge(dff, on='Postal Code'), or it has to be added based on other logic? — Julia
– Julia, Commented Mar 1, 2019 at 13:06
in fact only df.merge(dff) should be sufficient, since Postal Code is the only common column — erncyp
– erncyp, Commented Mar 1, 2019 at 13:09
try result = pd.concat([df, dff], ignore_index=True, sort=False) — Akhilesh_IN
– Akhilesh_IN, Commented Mar 1, 2019 at 13:09
Please DO NOT post samples in images, it is always recommended to post samples as a text with CODE TAGS @Info Digitalevo kindly edit your post and do let us know then. — RavinderSingh13
– RavinderSingh13, Commented Mar 1, 2019 at 13:15

Erfan · Accepted Answer · 2019-03-01 14:20:02Z

3

Appending is adding two dataframe 'on top of each other' so you add rows. If you want to add new columns to your dataframe from another dataframe, you use join or merge especially if you have a key column where you can merge, which is in your case Postal Code

In pandas we use pd.merge for merging two dataframes with each other like the followng:

df_final = pd.merge(df, dff, on='Postal Code')


    Postal Code     Borough     Neighbourhood   Lattitude   Longitude
0   M1B             Scarborough Rouge           43.806686   -79.194353
1   M1B             Scarborough Malvern         43.806686   -79.194353
2   M1C             Scarborough Port Union      43.784535   -79.160497
3   M1C             Scarborough Rouge Hill      43.784535   -79.160497
4   M1C             Scarborough Highland Creek  43.784535   -79.160497

answered Mar 1, 2019 at 14:20

Erfan

43.3k10 gold badges75 silver badges86 bronze badges

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

Comments

Zoe - Save the data dump · Accepted Answer · 2019-03-01 13:23:14Z

0

I think merge is what you're looking for.

df.merge(dff, on='Postal Code')

should do the trick.

edited Mar 1, 2019 at 13:23

Zoe - Save the data dump

28.4k22 gold badges130 silver badges163 bronze badges

answered Mar 1, 2019 at 13:15

Victor Valente

8111 gold badge10 silver badges27 bronze badges

Collectives™ on Stack Overflow

Add data from a dataframe to another

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related