Python - Transform DataFrame for Merge

Question

I have two different dataframes.

One looks like:

     Date          StoreID     MerchandiseType     Count
     04/01/2020    1           Hat                 2
     04/01/2020    1           Shirt               4

The other looks like:

     Date        StoreID     Hat    Shirt
     04/01/2020  1           2      4

I would like to transform dataframe 2, so that it is structured like dataframe 1 and then union. Any suggestions?

score 0 · Accepted Answer · answered Apr 27 '20 at 15:38

0

Do:

df2 = df2.melt(id_vars=['Date', 'StoreID'], value_vars=['Hat', 'Shirt'])

This will give you the right format and then you can merge.

Output:

answered Apr 27 '20 at 15:38

whege

1,391
1
5
13

No idea why I made it more complicated. Thank you! – dcrowley01 Apr 27 '20 at 15:43
No worries, glad to help! – whege Apr 27 '20 at 15:43

Python - Transform DataFrame for Merge

1 Answers1