/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

5 votes175 views5 answers
Closure
Python
1 vote169 views1 answer
How to make all time greeter using python
Python
1 vote159 views1 answer
Tqdm parallel
Python
1 vote195 views1 answer
Django add to cart
Python Django
0 vote177 views1 answer
How to detect the body with cv2
Python
0 vote158 views1 answer
Remove item from list if it exists python
Python
0 vote154 views1 answer
Driver code in python
Python
0 vote160 views2 answers
Py search and get objects from array
Python
1 vote161 views2 answers
How to download python freegames
Python
0 vote166 views1 answer
Convert from R to python
Python