CODEWITHSUNDEEP
pythonpandas
richie
richie

Reputation: 18638

using python pandas lookup another dataframe and return corresponding values

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.

Upvotes: 24

Views: 44515

Answers (1)

Zeugma
Zeugma

Reputation: 32095

Use merge function:

df2.merge(df1)

Upvotes: 29

Related Questions