/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 vote235 views1 answer
Django send_mail not working in testcase
Python
2 votes177 views1 answer
Django EMAIL_BACKEND console
Python
0 vote244 views1 answer
Add favicon in django admin
Python Django
3 votes182 views3 answers
Kadane's algorithm
Python
0 vote197 views2 answers
Namayandeyab
Python
0 vote190 views1 answer
Progressbar time in python
Python
5 votes207 views6 answers
Valid Palindrome
Python
0 vote166 views1 answer
Python sort list by rule
Python
1 vote187 views1 answer
'set' object is not reversible
Python
0 vote180 views3 answers
How to make index column as a normal column
Python