/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 vote154 views1 answer
Python inject into process
Python
14 votes142 views4 answers
How to detect keypress in python
Python
0 vote149 views1 answer
Scikit learn library in python
Python
0 vote133 views1 answer
Use nltk to remove stop words
Python
1 vote131 views1 answer
Import pycocotools._mask as _mask error Expected 80, got 88
Python
0 vote134 views1 answer
Gui apps
Python
0 vote129 views1 answer
Intellij python
Python
-2 votes211 views1 answer
Dlib python install error
Python
42 votes162 views6 answers
Python round 1 decimal place
Python
0 vote135 views1 answer
Grepper how to use fraction
Python