would like to combine rows of two dataframe where they have same value with panda. since my column header are different its not merging

Question

where value of countyFIPS of df1 = value of FIPS of df2 merge the rows df1

countyFIPS  feb    march  
1001          aa    45
1002          bb     1

df2

FIPS   dec    nov   
1001    ee    45
1002    gf     1

I want the result show like

countyFIPS      feb    march   dec    nov 
    1001          aa    45       ee    45
    1002          bb     1       gf     1

score 1 · Answer 1 · answered Sep 21 '20 at 21:53

1

df.merge(df2, left_on='countyFIPS', right_on='FIPS', how='inner').drop(columns=['FIPS']).

But before this I would like you to take a look at this post. This post already teaches everything required for merging.

answered Sep 21 '20 at 21:53

Anurag Reddy

So countyFIPS and FIPS are not is same order. i dont just cant to join them. they have to compare the value and rearrange in the new dataframe – Raiana Salmin Zaman Sep 21 '20 at 23:17
You can sort them and then join/merge them. – Grayrigel Sep 21 '20 at 23:44
You can use `df.sort_values(by=['col'])`. See the [documentation](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.sort_values.html) – Anurag Reddy Sep 22 '20 at 14:05

Grayrigel · Answer 2 · 2020-09-21T22:07:26.937

1

Just use join as below:

df1.join(df2, how='left').drop(['FIPS'],axis=1)

edited Sep 21 '20 at 22:07

answered Sep 21 '20 at 21:53

Grayrigel

2 Answers2