concatenating a column to a data frame by key python code example

Example: python dataframe left join

>>> left.merge(right, on='user_id', how='left')