pandas pivot table: How to find count for each group in Index and Column

  pivot, python

I am new to pivot table. I just want the count of each Age Grp by Mth. I tried

pivot1=pd.pivot_table(df,index=[ "Age Grp "], columns=["Mth"], values=["Age Grp"], aggfunc=pd.Series.nunique)

but get ValueError: Grouper for ‘age’ not 1-dimensional

DF

 |Age Grp | Mth  | 
 | 0-4    |  1   |  
 | 5 -9   | 5    |  
 | 0-4    | 10   | 
 | 10-14  | 5  |  


Desired Outcome

     Mth  |  1    | 5 | 10 |
 |Age Grp |                |
 | 0-4    |  1   |   0  | 1|
 | 5 -9   | 0    |   1  | 0|
 | 10-14  |  0   |   1  | 0|

Source: Python Questions

LEAVE A COMMENT