Match all rows of specific columns of dataframe to another dataframe and select a different column value based on the result

Asked Dec 14 '21 at 08:37

Active Dec 14 '21 at 08:42

Viewed 12 times

I have two data frames

Now df1 has 10000 rows and df2 has 200 rows where I have to match each row of df1 to df2 based on col1 and col2 and if it matches take col3 of df2 and add it to df1.

I tried df.iterrows but is very slow and giving improper values. Tried df.merge and np.select as well but not helpful. Is there a best approach to solve this? Please suggest.

NB: If I have to add additional conditions is that possible?

edited Dec 14 '21 at 08:42

Mark Rotteveel

90,369
161
124
175

asked Dec 14 '21 at 08:37

narayanan s

Can you add your code with `df.merge` ? Why cannot work? – jezrael Dec 14 '21 at 08:42

Match all rows of specific columns of dataframe to another dataframe and select a different column value based on the result

0 Answers0