concatinate two dataframe using primary key code example
Example: how to concat on the basis of particular columns in pandas
In [6]: result = pd.concat(frames, keys=['x', 'y', 'z'])
In [6]: result = pd.concat(frames, keys=['x', 'y', 'z'])