/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

49 votes319 views6 answers
Plot using matplotlib
Python
1 vote323 views1 answer
Adding variable in python
Python
1 vote508 views5 answers
Last index in python
Python
0 vote318 views1 answer
Pygame.K_KP_ENTER
Python
0 vote314 views1 answer
Python if something exception
Python
0 vote337 views2 answers
SyntaxError: Non-ASCII character '\xe2' in file /root/Downloads/la_southwest_college/handy/accountDetails.py on line 116, but no encoding declared; see http://python.org/dev/peps/pep-0263/ for details
Python
0 vote330 views1 answer
Long type python
Python
1 vote303 views1 answer
Convert to lowercase command python
Python
0 vote421 views1 answer
Fill in the empty function so that it returns the sum of all the divisors of a number, without including it. A divisor is a number that divides into another without a remainder.
Python
0 vote308 views1 answer
Install open3d jetson nano aarch64
Python