/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

3 votes159 views1 answer
Print decimal formatting in python
Python
0 vote185 views1 answer
Discord python bot how to change someone's nickname
Python
0 vote183 views1 answer
Flask print request headers
Python Flask
-2 votes157 views1 answer
Stats.norm.cdf(2,loc=mean, scale=std_dev)
Python
0 vote184 views1 answer
Create a colun in pandas using groupby
Python
5 votes146 views3 answers
Update in django orm
Python
1 vote160 views1 answer
Python regex get string before character
Python
0 vote147 views1 answer
ImportError: cannot import name ABC
Python
0 vote202 views1 answer
No module named 'bootstrap4' django
Python Django
0 vote198 views1 answer
Request.body django
Python Django