[P/M/K] Merge different dataframes

Merge different dataframes

It’s a really confusing problem when there are a few different dataframes with correlation provided in one dataset. Now I know how to merge it together.

d = pd.merge(d, items, on=['item_id'], how='left').drop('item_group', axis=1

train = train.set_index('item_id').join(items.set_index('item_id')).drop('item_name', axis=1).reset_index()