using python pandas lookup another dataframe and return corresponding values

Question

I have two dataframes;

df1 as;

Name      Role
Jim       Accounts
Sam       Purchase
Rhea      Sales

df2 as;

Name     Date
Jim      1/1/2000
Jim      2/1/2000
Jim      3/1/2000
Sam      1/1/2000
Sam      2/1/2000
Rhea     1/1/2000
Rhea     2/1/2000

I want to lookup df1 and have the output as;

    Name     Date          Role
    Jim      1/1/2000      Accounts
    Jim      2/1/2000      Accounts
    Jim      3/1/2000      Accounts
    Sam      1/1/2000      Purchase
    Sam      2/1/2000      Purchase
    Rhea     1/1/2000      Sales
    Rhea     2/1/2000      Sales

I'm unable to figure out Pandas' lookup feature.

You don't seem to have the right terminology, in pandas you are looking for either merge or join. — bdiamante
– bdiamante, Commented Jul 3, 2013 at 14:40

Zeugma · Accepted Answer · 2019-10-05 01:45:35Z

29

Use merge function:

df2.merge(df1)

edited Oct 5, 2019 at 1:45

answered Jul 3, 2013 at 14:42

Zeugma

32.3k9 gold badges73 silver badges85 bronze badges

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

Collectives™ on Stack Overflow

using python pandas lookup another dataframe and return corresponding values

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