How to transform column values of a dataframe to another dataframe with different indexes?

Question

I have two dataframes with equal number of rows.

df_a:

index   Id   X   Y
1       10   x1  - 
2       20   x2  -

-----------

df_b:

index   PostId   Text   
3       10       abcd
4       20       efg

Now how can I transform values of df_b['Text'] to df_a['Y']. resulting this:

df_a:

index   Id   X   Y
1       10   x1  abcd
2       20   x2  efg

Note that indexes of mentioned dataframes are not the same.

jezrael · Accepted Answer · 2020-02-06 11:27:59Z

1

Because of the same number of rows, you can assign numpy array:

df_a['Y'] = df_b['Text'].to_numpy()

Older pandas versions:

df_a['Y'] = df_b['Text'].values

If want to map or merge be free to use some of solution from this answer.

edited Feb 6, 2020 at 11:27

answered Feb 6, 2020 at 11:23

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

9 Comments

ansev Over a year ago

this is trivial

Ali Khatami Over a year ago

@jezrael there is a warning happening: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead

jezrael Over a year ago

@AliKhatami - How is created df_a and df_b ?

jezrael Over a year ago

@AliKhatami - Maybe is necessary copy like explained here or here

ansev Over a year ago

stackoverflow.com/questions/45747589/…

|

Collectives™ on Stack Overflow

How to transform column values of a dataframe to another dataframe with different indexes?

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related