2 df left join with one same co,lumn code example

Example: how to concat on the basis of particular columns in pandas

In [6]: result = pd.concat(frames, keys=['x', 'y', 'z'])