python - Print specific rows that are common between two dataframes

Question

i have a dataframe (df1) like this

id    link 
1     google.com
2     yahoo.com
3     gmail.com

i have another dataframe(df2) like this:

id    link           numberOfemployees   
1     linkedin.com        15
2     facebook.com        70
3     gmail.com           90
4     google.com          1000
5     twitter.com         155
6     yahoo.com           2

I want to write a new dataframe that contains the rows of df1 and their numberOfemployees from df2. is it feasable?

and anot

Answer 1

You could try this simple solution:

df2[df2.link.isin(df1.link)]