Use values in a dataframe as keys to replace value from a second dataframe

Question

I have the following two dataframes:

near0   near1   near2
SCSCO   LFLAF   GOMAN
VDJUL   MEIRA   L3N05
LOSEN   AMCLF   PIRF2
AOSSF   MEPRI   FLLCA

and

  key   vlaue
SCSCO   _1234
VDJUL   _4321
PIRF2   _5677

How can I replace (or add a new column) such that either

near0   near1   near2
_1234   LFLAF   GOMAN
_4321   MEIRA   L3N05
LOSEN   AMCLF   _5677
AOSSF   MEPRI   FLLCA

or

near0   near1   near2   near0_f   near1_f   near2_f
SCSCO   LFLAF   GOMAN     _1234     LFLAF     GOMAN
VDJUL   MEIRA   L3N05     _4321     MEIRA     L3N05
LOSEN   AMCLF   PIRF2     LOSEN     AMCLF     _5677
AOSSF   MEPRI   FLLCA     AOSSF     MEPRI     FLLCA

hold?

BENY · Accepted Answer · 2020-06-04 23:52:25Z

3

You can do replace pass series

newdf1=df1.replace(df2.set_index('key').vlaue)
   near0  near1  near2
0  _1234  LFLAF  GOMAN
1  _4321  MEIRA  L3N05
2  LOSEN  AMCLF  _5677
3  AOSSF  MEPRI  FLLCA

answered Jun 4, 2020 at 23:52

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Collectives™ on Stack Overflow

Use values in a dataframe as keys to replace value from a second dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related