/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

5 votes326 views3 answers
Convert list to dataframe
Python
0 vote347 views1 answer
Majority in array python
Python
0 vote297 views2 answers
Business logic code where located in django rest framework
Python
3 votes386 views2 answers
Install flask on linux mint for python3
Python Flask
7 votes409 views2 answers
Pandas profile
Python
0 vote324 views1 answer
Install gTTs
Python
1 vote338 views1 answer
How to make basic inventory setup in python
Python
0 vote353 views1 answer
How to append variable python
Python
6 votes367 views3 answers
Flask get ip of user
Python Flask
0 vote350 views1 answer
Pandas cumulative mean
Python