In [1]: df1 = pd.DataFrame({'x': [1, 2, 3], 'y': ['a', 'b', 'c']})
In [2]: df2 = pd.DataFrame({'y': ['b', 'c', 'd'], 'z': [4, 5, 6]})
In [3]: df1
Out[3]: 
   x  y
0  1  a
1  2  b
2  3  c   
In [4]: df2
Out[4]: 
   y  z
0  b  4
1  c  5
2  d  6
Inner join:
Uses the intersection ...