vlookup in pandas python

Question

I have two dataframes I want to check if a column from first dataframe contains values that are in the column of second dataframe, and if it does, create a column and add 1 to the row where it contains a value from first column first df:

A header	Another header
First	apple
Second	orange
third	banana
fourth	tea

desired output in second df second df:

A header	Another header	match
First	sheet	0
Second	chair	0
third	apple	1
fourth	orange	1

jezrael · Accepted Answer · 2022-10-26 09:30:46Z

1

Use Series.isin and convert boolean to 1/0 values by casting:

df2['match'] = df2['Another header'].isin(df1['Another header']).astype(int)

Or by numpy.where:

df2['match'] = np.where(df2['Another header'].isin(df1['Another header']), 1, 0)

answered Oct 26, 2022 at 9:30

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

vlookup in pandas python

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