Pandas merge with MultiIndex for repeated columns
Try concat
, with keys
parameter and join='inner'
:
print(pd.concat([left_feet, right_feet], axis=1, keys=['Left','Right'], join='inner')) Left Right Length Width Length Width1 30 10 30 102 25 9 24 8
Because need merge
or join
first create MultiIndex
es and then join:
left_feet.columns = pd.MultiIndex.from_product([['left'], left_feet.columns])right_feet.columns = pd.MultiIndex.from_product([['right'], right_feet.columns])feet = pd.merge(left_feet, right_feet, left_index=True, right_index=True)print(feet) left right Length Width Length Width1 30 10 30 102 25 9 24 8