/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

3 votes160 views2 answers
Python discord webhook
Python
0 vote180 views1 answer
Python time function in for loop
Python
2 votes182 views1 answer
Python pandas cumulative return
Python
-2 votes139 views2 answers
Extract directory python
Python
0 vote151 views1 answer
App = Flask(_name_) NameError: name '_name_' is not defined
Python
12 votes118 views3 answers
Write list to text file python
Python
11 votes199 views5 answers
Capitalize first letter in python
Python
2 votes157 views2 answers
Python how to get script directory
Python
0 vote159 views1 answer
Start ipython with any version
Python
44 votes188 views6 answers
Python list files in current directory
Python