/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 vote190 views1 answer
Redirect stdout to variable python
Python
0 vote171 views1 answer
Fast way to load mongodb data into python list
Python
15 votes140 views2 answers
Python randomise between 0 or 1
Python
2 votes134 views1 answer
Rename multiple pandas columns with list
Python
4 votes148 views1 answer
Matplotlib plot dashed
Python
0 vote141 views1 answer
How to print a matrix in python
Python
0 vote153 views3 answers
Matlab to python
Python
0 vote149 views1 answer
Pymupdf extract all text from pdf
Python
1 vote145 views1 answer
How to change the values of a column in numpy array
Python
2 votes140 views2 answers
Python include another python file
Python