Python Forum

I have below input data and I want to pivot:
Pivoting:
By Surname(as my x-axis), calculate the count & average rank of "Auot>F" "Auot>S" "AuotR>S"

ID	Name   Surname	Status	 Rank
1	A	   AA	    Auot>S	 112
2	B	   BB	    Auot>S	 20
3	A	   AA	    AuotR>S	 28
4	A	   AA	    Auot>S	 35
5	C	   CC	    Auot>S	 32
6	B	   BB	    Auot>F	 69
7	B	   BB	    Auot>S	 72
8	A	   AA	    Auot>S	 12
9	B	   BB	    Auot>S	 15
10	B	   BB	    Auot>F	 45
11	A	   AA	    Auot>F	 56
12	A	   AA	    Auot>S	 28
13	C	   CC	    Auot>S	 23
14	A	   AA	    Auot>S	 56
15	B	   BB	    Auot>S	 28

[python]Row Labels	Auot>F	Auot>S	AuotR>S	Auot>F	Auot>S	AuotR>S
AA	       56	   48.6	    28	    1	    5	    1
BB	       57	   33.75		    2	    4	
CC		           27.5			            2	

I use below code but it do not solve my problem:
pd.pivot_table(rawData,index=["Name"])

try this:

rawData.pivot_table(index='Surname', columns='Status',values='Rank', aggfunc='count')
rawData.pivot_table(index='Surname', columns='Status',values='Rank', aggfunc='mean')