Python Pandas - Find and replace across two dataframes

Question

I searched a lot but I can't solve my problem - maybe someone can give me a hint:

I have two Panda Dataframes, df1 and df2, with these columns:

EAN PRODUCT-NAME OLD-DESCRIPTION PURCHASE-PRICE SALES-PRICE

EAN NEW-PRODUCT-NAME NEW-DESCRIPTION

I want to locate a product in df1 by the EAN number, and replace it's name and description with the new name & description in the corresponding product in df2. It is important to know, that the first dataset is bigger and not every product will get a new name and description. I can't just replace the whole columns.

I have to go take the EAN numbers in df2, search for them in df1 to find the right product, and replace the name and description in df2.

I tried various methods like replace, isin, and even thought about nesting two loopsto solve the problem. But I might think to complicated...

Sapperlott · Accepted Answer · 2022-06-01 14:48:11Z

1

EAN column is not common between both tables. df1 is way bigger.

I thought about something like this, but this is not elegant at all...

for x in df1.index:
   for y in df2.index:
      if df1.loc[x, "EAN"] == df2.loc[y, "EAN"]:
         print ("Found!") 
         df1["OLD-DESCRIPTION"] = df2["NEW-DESCRIPTION"]

edited Jun 1, 2022 at 14:48

answered Jun 1, 2022 at 12:03

Sapperlott

413 bronze badges

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

Comments

Vivs · Accepted Answer · 2022-06-01 11:49:56Z

0

Assumption : EAN column is common between 2 table

df3=pd.merge(df1,df2 , on= 'EAN',how= 'Outer')

further you can filter colums which you need and also rename it as needed.

answered Jun 1, 2022 at 11:49

Vivs

4854 silver badges11 bronze badges

Collectives™ on Stack Overflow

Python Pandas - Find and replace across two dataframes

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related