Pandas pivot table error

Question

Following code gives

Code:

table_channel = pd.pivot_table(data=df,values = 'Category',index = 
['ID'], aggfunc='count')

Output:

ID    Category
1     2
2     11
3     5
4     3

Right now it's giving total count of different categories of Category column. Need output like:

ID    Category1    Category2  Category3
1         0            1          1
2         5            4          2 and so on

I used this code to rectify but it did not work:

table_channel = pd.pivot_table(df,values = 'Category',columns = 'Category',index = ['ID'], aggfunc='count')

Error is that grouper for Category not 1 dimensional. What is wrong?

It would be great if you could share an example of your data. This error occurs when you have two columns with same name. — zipa
– zipa, Commented Mar 29, 2018 at 12:54

BENY · Accepted Answer · 2018-03-29 13:02:19Z

3

You can using crosstab

pd.crosstab(df.ID,df.Category).add_prefix('Category')
Out[1335]: 
Category  Category2  Category3  Category5  Category11
ID                                                   
1                 1          0          0           0
2                 0          0          0           1
3                 0          0          1           0
4                 0          1          0           0

answered Mar 29, 2018 at 13:02

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Comments

Mysterious · Accepted Answer · 2018-03-29 13:03:59Z

1

Needed to use this code instead:

columns = df.Category.values

answered Mar 29, 2018 at 13:03

Mysterious

8811 gold badge10 silver badges24 bronze badges

Collectives™ on Stack Overflow

Pandas pivot table error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related