/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 vote215 views1 answer
Django collectstatic with auto yes
Python Django
12 votes178 views1 answer
Python check if has attribute
Python
0 vote175 views1 answer
Aternos cracked server
Python
0 vote126 views1 answer
Driver code in python
Python
1 vote183 views1 answer
Python json dump utf8
Python
0 vote164 views1 answer
Pandas reemplazar nan por cero
Python
4 votes169 views3 answers
Python create new pandas dataframe with specific columns
Python
0 vote155 views1 answer
Download viper for python ubutunu
Python
0 vote162 views1 answer
Détruire une variable python
Python
5 votes178 views2 answers
Tables in jinja template
Python