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

0 vote1.2K views1 answer
How to print cow on python
Python
0 vote141 views1 answer
Dict from group pandas
Python
25 votes153 views6 answers
Pip uninstall all packages
Python
0 vote221 views1 answer
Def f(x) python
Python
81 votes143 views6 answers
How to clear console in python
Python
20 votes295 views3 answers
Python inline if
Python
9 votes137 views3 answers
Print current time hours and minutes in python
Python
41 votes148 views6 answers
Youtube.com
Python
1 vote134 views1 answer
Get all h1 beautifulsoup
Python
1 vote137 views1 answer
User matching query does not exist. django
Python