pandas replace values based on values from another column

Question

I have two dataframe (data and priceMapping)

Data:

       Global id   Price
0   AR.1852218.1     
1   AR.1852223.1     0,6
2   AR.1852251.1    0,56
3   AR.1852254.1    
4   AR.1852257.1    0,25
5   AR.1852386.1    0,33
6   AR.1852549.1

priceMapping:

        G.ID       Price
0   AR.1852218.1     0,1
1   AR.1852254.1    0,25
2   AR.1852549.1    0,33

I would like to fill the price that is in the priceMapping dataframe based on the criteria Global id=G.ID.

Thanks in advance for your help.

Laurent

jezrael · Accepted Answer · 2020-10-30 08:34:31Z

2

Use Series.map by Series created by priceMapping and then replace not matched values to original by Series.fillna, because not matched values create missing values:

s = priceMapping.set_index('G.ID')['Price']
Data['Price'] = Data['Global id'].map(s).fillna(Data['Price'])
print (Data)
      Global id Price
0  AR.1852218.1   0,1
1  AR.1852223.1   0,6
2  AR.1852251.1  0,56
3  AR.1852254.1  0,25
4  AR.1852257.1  0,25
5  AR.1852386.1  0,33
6  AR.1852549.1  0,33

Another idea is use Series.replace:

s = priceMapping.set_index('G.ID')['Price']
Data['Price'] = Data['Global id'].replace(s)

edited Oct 30, 2020 at 8:34

answered Oct 30, 2020 at 8:29

jezrael

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

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

Collectives™ on Stack Overflow

pandas replace values based on values from another column

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