Pivot Column values to be Column Names using Pandas

Question

I have a table (simplified view) like this:

SellerID businessDate sales_total
A-123    1/1/2017     12.05
A-123    1/1/2017     126.75
B-223    1/1/2017     2.75
B-223    1/1/2017     31.75
C-444    1/1/2017     55.55
A-123    1/2/2017     12.05
A-123    1/2/2017     126.75
B-223    1/2/2017     10.75
C-444    1/2/2017     31.75
C-444    1/2/2017     55.55

And the data continues like that

What I would like to do is have the date values as the columns and the sales total for each SellerID as a single row like this:

SellerID  1/1/2017 1/2/2017 .....
A-123     300      100      .....
B-223     150      60       .....
C-444     120      55       .....
D-555     0        149      .....

My thinking is that I can easily find the daily best seller, and find the SellerID's who fall within below 3-std deviations of the mean for each selling day to find SellerID's who might not be performing well.

Thank you

Are the values count? or is that mean? If its plain pivoting read this https://stackoverflow.com/questions/47152691/how-to-pivot-a-dataframe — Bharath M Shetty, Nov 29 '17 at 11:44
There is not possible use `pivot_table` `df.pivot_table(index='SellerID', columns='businessDate', values='sales_total', aggfunc='sum')`? — jezrael, Nov 29 '17 at 11:45
@jezrael the df.pivot_table works great, if I want to get the mean of the counts with the aggfunc do I pass a list of strings? — code base 5000, Nov 29 '17 at 14:03
@codebase5000 - there is not necessary `aggfunc`, because default `aggfunc='mean'` :) — jezrael, Nov 29 '17 at 14:04

score 1 · Accepted Answer · answered Nov 29 '17 at 12:46

1

Using pandas, one can easily pivot table a dataframe, for your specific example, one can solve it as in the image bellow:

answered Nov 29 '17 at 12:46

epattaro

2,330
1
16
29

if I have another values column, can I specify that? like TaxTotal? – code base 5000 Nov 29 '17 at 16:19
Ty - I do work out a lot. – epattaro Mar 13 '22 at 12:44
This is concise and intuitive; beautiful brain of yours – Dave Liu Mar 15 '22 at 19:26

Pivot Column values to be Column Names using Pandas

1 Answers1