python df merge two table at once code example

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

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