Changing a table shape in python

Asked Apr 14 '21 at 06:18

Active Apr 14 '21 at 06:39

Viewed 78 times

i have a pandas dataframe suchs as:

            Price   Category    Product
4/11/2021   12  S1  ABC
4/12/2021   15  S1  ABC
4/13/2021   13  S2  ABC
4/14/2021   14  S3  ABC
4/11/2021   12  S1  CDE
4/12/2021   15  S1  CDE
4/13/2021   13  S2  CDE
4/14/2021   14  S3  CDE
4/11/2021   12  S1  FGH
4/12/2021   15  S1  FGH
4/13/2021   13  S2  FGH
4/14/2021   14  S3  FGH


and i would like to transform it to a shorter table so the result would like like:
           ABC  CDE FGH
4/11/2021   S1  S1  S1
4/12/2021   S1  S1  S1
4/13/2021   S2  S2  S2
4/14/2021   S3  S3  S3

NOte that the price column is not included.

In R i would use a dcast function but in Python i not know how to do it. I tried a 2-level loop and it is a disaster.

Anybody know a quick way in Python please?

edited Apr 14 '21 at 06:31

Heikura

1,009
3
13
27

asked Apr 14 '21 at 06:18

Rene Chan

What is `print (df.columns.tolist())` ? – jezrael Apr 14 '21 at 06:39
Out[8]: ['Price', 'Category', 'Product'] – Rene Chan Apr 14 '21 at 06:40
OK, so need `df = df.set_index('Product', append=True)['Category'].unstack()` ? – jezrael Apr 14 '21 at 06:41
kindly have a look on: https://stackoverflow.com/questions/38987231/why-did-i-get-a-keyerror-level-not-found – Anurag Dabas Apr 14 '21 at 06:49
@jezrael, your solution works very well, super fast for me. i need to learn more about the setindex together with unstack. Thanks again. – Rene Chan Apr 15 '21 at 03:47
Can you create a quick response so i put you the points please ? – Rene Chan Apr 15 '21 at 03:58

Changing a table shape in python

0 Answers0

Linked