/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

19 votes228 views5 answers
Pandas where retuning NaN
Python
0 vote225 views2 answers
Aes in python
Python
4 votes249 views4 answers
Pandas groupby sum
Python
0 vote238 views3 answers
How to take a screenshot using python
Python
0 vote267 views1 answer
A int and float python
Python
3 votes248 views2 answers
Cv2.cv2 has no attribute face
Python
0 vote249 views1 answer
Extra import on django
Python Django
0 vote242 views1 answer
Colab erase recycle bin drive
Python
0 vote231 views1 answer
Convert math expression as string to int
Python
7 votes235 views2 answers
Add image to jupyter notebook in markdown
Python