/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 vote124 views1 answer
While my_input != "exit":
Python
0 vote114 views1 answer
Are logN and (lognN) same
Python
1 vote158 views1 answer
Python how to make notepad
Python
8 votes145 views3 answers
Django sort queryset
Python Django
22 votes107 views4 answers
ModuleNotFoundError: No module named 'sklearn.cross_validation'
Python
1 vote139 views2 answers
How to access cookies in django
Python Django
0 vote126 views1 answer
How to get a user's avatar with their id in discord.py?
Python
4 votes99 views1 answer
To_csv without index
Python
0 vote144 views1 answer
Http404 django
Python Django
11 votes108 views4 answers
Invert dictionary python
Python