/Python/Pandas groupby count as new column

Pandas groupby count as new column

Group by count dataframe

df.groupby(['col1', 'col2']).size().reset_index(name='counts')

Source: stackoverflow.com

Group by count dataframe

df.groupby(['col1','col2']).size()

Source: stackoverflow.com

Pandas groupby count as new column

In [12]: df.groupby(["item", "color"])["id"].count().reset_index(name="count")
Out[12]:
    item  color  count
0    car  black      2
1  truck   blue      1
2  truck    red      2

Source: stackoverflow.com

Group by pandas count

df[['col1', 'col2', 'col3', 'col4']].groupby(['col1', 'col2']).agg(['mean', 'count'])

Source: stackoverflow.com

Similar codes

0 vote296 views1 answer
Python format inverse
Python
3 votes267 views1 answer
Create virtual env pyhton3
Python
0 vote282 views1 answer
Yamaha palhetas
Python
1 vote295 views1 answer
Log loss python
Python
0 vote280 views4 answers
Python to php
Python
8 votes275 views4 answers
Print pandas version
Python
0 vote296 views1 answer
Day 19: interfaces hackerrank solution in python
Python
0 vote281 views1 answer
Access django server from another machine
Python
5 votes293 views2 answers
Skitlearn decision tree
Python
1 vote364 views1 answer
Django how to set a navbar active
Python