Python Forum

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

You're currently viewing a stripped down version of our content. View the full version with proper formatting.

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 Grp' 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     |

Python Forum

JaneTan