Creating pivot table in pandas with different functions for each value

Question

This is my code and I can't figure out what's wrong with it.

Edit: It says name 'count' not defined

df1.pivot_table(index=["Unit", "Grade"],values = ["Cost", "Quantity","Transaction_num", "Order_num"], aggfunc={'Cost':[np.sum],'Quantity':[np.sum], "Transaction_num":[count],"Order_num":[count]})

I want a sum of total cost and total quantity but I want a distinct count of transaction number and order number.

mozway · Accepted Answer · 2021-08-26 16:15:25Z

2

This means you forgot a parenthesis. Properly indenting code helps ;)

df1.pivot_table(index=['Unit', 'Grade'],
                values=['Cost', 'Quantity', 'Transaction_num', 'Order_num'],
                aggfunc={'Cost': 'sum',
                         'Quantity': 'sum',
                         'Transaction_num': 'count',
                         'Order_num': 'count',
                        }
               )

edited Aug 26, 2021 at 16:15

answered Aug 26, 2021 at 16:13

mozway

267k13 gold badges56 silver badges106 bronze badges

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

3 Comments

alwayzconfused Over a year ago

Ah! Thanks for the help. However, now I get a new error saying name 'count' is not defined

mozway Over a year ago

@alwayzconfused I was fixing it, check the update

alwayzconfused Over a year ago

what do I need to do if I want to find unique count of the last two values?

Collectives™ on Stack Overflow

Creating pivot table in pandas with different functions for each value

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related