import pandas as pd
left = pd.DataFrame({‘key’: [‘K0’, ‘K1’, ‘K3’],
‘A’: [‘A0’, ‘A1’, ‘A3’],
‘B’: [‘B0’, ‘B1’, ‘B3’]})
right = pd.DataFrame({‘key’: [‘K0’, ‘K1’, ‘K2’, ‘K3’,‘k4’],
‘C’: [‘C0’, ‘C1’, ‘C2’, ‘C3’,‘c4’],
‘D’: [‘D0’, ‘D1’, ‘D2’, ‘D3’,‘d4’],
})
result = pd.merge(left, right, on=‘key’)