/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 votes305 views4 answers
If queryset is empty django
Python Django
0 vote261 views1 answer
How to make my discord bot shut down with a command
Python
4 votes272 views7 answers
Int
Python
1 vote291 views1 answer
How to make markdown cell in jupyter notebook
Python
-2 votes260 views6 answers
Django download
Python
34 votes263 views3 answers
How to install pyaudio in python
Python
2 votes270 views1 answer
Normalise list python
Python
1 vote295 views1 answer
Python towers of hanoi recursive
Python
-1 vote270 views1 answer
Python iterate over instances of class
Python
1 vote243 views1 answer
Variable inside class not detecting global variable in python
Python