/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 vote302 views1 answer
Pydrive list folders
Python
0 vote284 views1 answer
Raising a new style class which doesn't inherit from baseexception python
Python
1 vote296 views1 answer
The operands of the logical operators should be boolean expressions, but python is not very strict. any nonzero number is interpreted as true.
Python
0 vote280 views1 answer
__all__ python
Python
0 vote289 views1 answer
Week of the year pandas
Python
5 votes272 views6 answers
How to find unique values in numpy array
Python
0 vote290 views1 answer
Inject dynamic value into string python
Python
0 vote285 views1 answer
Are logN and (lognN) same
Python
1 vote369 views2 answers
Redirect to the same page django
Python Django
0 vote311 views1 answer
Affinity propagation python
Python