How to filter Pandas rows by another Dataframe columns?

Question

Say I have two Pandas dataframes like this:

df1 = pd.DataFrame([['asdf'], ['zxcv'], ['qwer'], ['hjkl']])
df2 = pd.DataFrame([['b','0'],['asdf','1'],['c','2'],['hjkl','3']])

How to I filter out df2 to only contain rows if it has a value from df1?

I want to get a dataframe like this from the operation

df3 = pd.DataFrame([['asdf','1'], ['hjkl', '3']])

DYZ · Accepted Answer · 2017-02-03 20:59:19Z

2

It's just a matter of merging:

pd.merge(df1,df2)
#      0  1
#0  asdf  1
#1  hjkl  3

answered Feb 3, 2017 at 20:59

DYZ

57.3k10 gold badges73 silver badges101 bronze badges

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

1 Answer 1