I want to compare name column in two dataframes df1 and df2 , output the matching rows from dataframe df1 and store the result in new dataframe df3. How do i do this in Pandas ?

df1

place name qty unit
NY    Tom   2  10
TK    Ron   3  15
Lon   Don   5  90
Hk    Sam   4  49

df2

place name price 
PH    Tom   7    
TK    Ron   5    

Result:

df3

place name qty unit
NY    Tom   2  10
TK    Ron   3  15

Option 1

Using df.isin:

In [1362]: df1[df1.name.isin(df2.name)]
Out[1362]: place name  qty  unit
0    NY  Tom    2    10
1    TK  Ron    3    15

Option 2

Performing an inner-join with df.merge:

In [1365]: df1.merge(df2.name.to_frame())
Out[1365]: place name  qty  unit
0    NY  Tom    2    10
1    TK  Ron    3    15

Option 3

Using df.eq:

In [1374]: df1[df1.name.eq(df2.name)]
Out[1374]: place name  qty  unit
0    NY  Tom    2    10
1    TK  Ron    3    15