/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

3 votes234 views1 answer
How to connect templates in django
Python
0 vote199 views1 answer
Create bbox R sp
Python
2 votes260 views2 answers
Super in django manager
Python Django
0 vote241 views1 answer
Convert math expression as string to int
Python
10 votes242 views2 answers
Adding static file and its usage in Django
Python
6 votes260 views2 answers
ModelForm
Python
2 votes242 views1 answer
Private variables python
Python
0 vote236 views1 answer
How to download from youtube in discord.py
Python
-1 vote219 views1 answer
Show all text contained in a line pandaq
Python
1 vote257 views2 answers
Python pandas shape
Python