Replacing columns with different Dataframe

Question

I have two dataframes,namely 'df' and 'df1'

df
Out[14]: 
      first country  Rating
0    Robert      US     100
1     Chris     Aus      99
2  Scarlett      US     100

df1
Out[17]: 
        last        Role
0     Downey     IronMan
1  Hemsworth        Thor
2  Johansson  BlackWidow

Expected output:

      first       last        Role  Rating
0    Robert     Downey     IronMan     100
1     Chris  Hemsworth        Thor      99
2  Scarlett  Johansson  BlackWidow     100

I need to drop off the 'country' column and replace with another dataframe(ie. 'df1')

I understand,I can join dataframes and drop 'country' column,but I need columns exactly in this order.

Have you tried to rearange the columns after you have joined them? Also, what is the output when you join them? — MacOS
– MacOS, Commented May 28, 2020 at 18:41

Bruno Mello · Accepted Answer · 2020-05-28 18:41:59Z

1

IIUC:

new_df = df.merge(df1, on='Role').drop('country', axis=1)
new_df = new_df[['first', 'last', 'Role', 'Rating']]

answered May 28, 2020 at 18:41

Bruno Mello

4,6881 gold badge16 silver badges46 bronze badges

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

1 Comment

Mohamed Muhsin Over a year ago

Is there any way I can do it without explicitly giving the column names?

Balaji Ambresh · Accepted Answer · 2020-05-28 18:48:04Z

0

Could you give this a shot?

df1.join(df2, lsuffix='', rsuffix='r_')[["first", "last", "Role", "Rating"]]

Output:

      first       last        Role  Rating
0    Robert     Downey     IronMan     100
1     Chris  Hemsworth        Thor      99
2  Scarlett  Johansson  BlackWidow     100

answered May 28, 2020 at 18:48

Balaji Ambresh

5,0022 gold badges7 silver badges17 bronze badges

2 Comments

Mohamed Muhsin Over a year ago

Thanks Balaji ! It works.. But is there any way to get it without explicitly mentioning column names?. If I can get by slicing or something, that would be great.. Its hard to mention all the column names for large datasets..

Balaji Ambresh Over a year ago

Can't you get the final list of columns from the column names of the dataframe using df.columns.tolist() ?

user3226869 · Accepted Answer · 2020-05-28 19:40:23Z

0

@Moahmed you can try the below approach:

df2 = pd.concat([df,df1], axis = 1)

df2 = df2[['first','last','Role','Rating']]

df2.head()

answered May 28, 2020 at 19:40

user3226869

113 bronze badges

Collectives™ on Stack Overflow

Replacing columns with different Dataframe

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related