/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 vote196 views1 answer
Flask_uploads.exceptions.UploadNotAllowed
Python
0 vote203 views1 answer
Filters rows using the given condition
Python
0 vote222 views1 answer
Delete migrations django and start over deployment heroku
Python Django
23 votes201 views6 answers
Python decorator
Python
45 votes213 views3 answers
Python get day month year
Python
2 votes221 views1 answer
Numpy function for calculation inverse of a matrix
Python
0 vote185 views1 answer
Read excel file in computer
Python
29 votes202 views2 answers
Python string upper method
Python
0 vote209 views1 answer
Python check variable is tuple
Python
134 votes206 views6 answers
Python install pip
Python