Python Pandas pivot on bin

df['bin'] = pd.cut(df.age, [0,4,9,14])

pvtdf = df.pivot_table(index='type', columns=['bin'], values='days', 
                       aggfunc=('count', 'sum')).fillna(0)

#       count                   sum               
# bin  (0, 4] (4, 9] (9, 14] (0, 4] (4, 9] (9, 14]
# type                                            
# a       2.0    0.0     1.0    6.0    0.0     1.0
# b       3.0    0.0     0.0    9.0    0.0     0.0
# c       0.0    1.0     0.0    0.0    1.0     0.0
# d       0.0    1.0     0.0    0.0    4.0     0.0
# e       0.0    0.0     1.0    0.0    0.0     2.0
# f       0.0    1.0     0.0    0.0    0.0     0.0

Source: stackoverflow.com

Similar codes

6 votes369 views3 answers
Login system in django
Python Django
0 vote341 views4 answers
Mergesort
Python
1 vote314 views1 answer
Codeforces - 570b python
Python
0 vote316 views1 answer
How to create frequency table in python
Python
5 votes330 views4 answers
Matplotlib space between subplots
Python
0 vote357 views1 answer
Display full length jupyter
Python
0 vote335 views1 answer
Py2exe no console
Python
30 votes333 views4 answers
How to round a number in python
Python
0 vote328 views1 answer
Numpy convert 1d to 2d
Python
11 votes330 views3 answers
How to do pandas profiling
Python