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 stackoverflow.com/questions/47152691/how-to-pivot-a-dataframe — Bharath M Shetty
– Bharath M Shetty, Commented Nov 29, 2017 at 11:44
There is not possible use pivot_table df.pivot_table(index='SellerID', columns='businessDate', values='sales_total', aggfunc='sum')? — jezrael
– jezrael, Commented Nov 29, 2017 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
– code base 5000, Commented Nov 29, 2017 at 14:03
@codebase5000 - there is not necessary aggfunc, because default aggfunc='mean' :) — jezrael
– jezrael, Commented Nov 29, 2017 at 14:04

epattaro · Accepted Answer · 2017-11-29 12:46:19Z

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, 2017 at 12:46

epattaro

2,4981 gold badge22 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

code base 5000 Over a year ago

if I have another values column, can I specify that? like TaxTotal?

epattaro Over a year ago

Ty - I do work out a lot.

Dave Liu Over a year ago

This is concise and intuitive; beautiful brain of yours

Collectives™ on Stack Overflow

Pivot Column values to be Column Names using Pandas

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related