/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

2 votes202 views2 answers
Pandas if nan, then the row above
Python
3 votes202 views3 answers
Pandas date_range
Python
0 vote236 views1 answer
Python request webhook
Python
0 vote202 views1 answer
Get the values of your aws tags from ec2 instance
Python
0 vote189 views3 answers
EMAIL_BACKEND where to read
Python
0 vote169 views1 answer
Userregisterform
Python
0 vote209 views1 answer
Import CreateAPIView django
Python
-1 vote161 views2 answers
Beautifulsoup docs
Python
40 votes185 views6 answers
How to print error in try except python
Python
0 vote199 views1 answer
Python search resultset from finadall
Python