Pandas replace DataFrame values

Question

I am trying to replace the values of a column in a df based on the corresponding index value pair in another df.

For example:

main df:

d = {'var1': [A, B, A, B]}
df = pd.DataFrame(data=d)
df
    var1   
0     A     
1     B     
2     A     
3     B

Data frame with new values:

df2  val1

A     1     
B     2

Result:

I was thinking I could set var1 as a temporary index then join with df2 and then replace the var1 column with val1. Not sure if there is a better way to do this?

Use `map` : `df['var1'].map(df2['val1'])` – Chris Adams Mar 25 '19 at 16:12 — Chris Adams, Mar 25 '19 at 16:12

score 3 · Answer 1 · answered Mar 25 '19 at 16:12

3

Use df.set_index() and series.map():

df.var1=df.var1.map(df_new.set_index('df2')['val1'])
print(df)

   var1
0     1
1     2
2     1
3     2

answered Mar 25 '19 at 16:12

anky

74,114
11
41
70

2

Maybe try something new `df2.val1.get(df.var1)` – BENY Mar 25 '19 at 16:15
1

@Wen-Ben Thank you. :) I will study more on `get()` thanks for teaching me that. :) – anky Mar 25 '19 at 16:17

Pandas replace DataFrame values

1 Answers1

Linked