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 vote131 views1 answer
Flask current_app config
Python Flask
0 vote145 views1 answer
Get hwid python
Python
4 votes134 views1 answer
Flask image
Python Flask
110 votes274 views6 answers
Python while
Python
0 vote143 views1 answer
Matplotlib legend put larget dot
Python
168 votes237 views6 answers
How to upgrade pip in python
Python
50 votes148 views6 answers
Python uppercase
Python
0 vote134 views2 answers
Python - create frequency table between two columns
Python
3 votes150 views2 answers
Raising custom exception python
Python
0 vote143 views1 answer
Fastest sorting algorithm java
Python