/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

2 votes209 views2 answers
How split string in python by size
Python
11 votes192 views1 answer
Python check if int is between two values
Python
4 votes176 views1 answer
How to convert types of variablesin python
Python
0 vote201 views2 answers
How to make SAPI.SpVoice say a variable in python
Python
1 vote192 views1 answer
Python ascii caesar cipher
Python
50 votes187 views6 answers
Print random string from list python
Python
1 vote184 views1 answer
What is actually better duracell or energizer
Python
1 vote224 views2 answers
Python3 to python
Python
85 votes195 views6 answers
Python sort dataframe by one column
Python
0 vote193 views1 answer
Pytest temp directory
Python