/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

12 votes345 views3 answers
Python datetime day of year
Python
10 votes312 views3 answers
Python import function from file
Python
-1 vote289 views1 answer
Django migrate not creating tables
Python
4 votes296 views4 answers
Python save output to file
Python
0 vote419 views1 answer
Tables in discord.py
Python
-1 vote316 views2 answers
Python array use numpy arange
Python
0 vote321 views1 answer
Request.body django
Python
18 votes319 views3 answers
Regex findall
Python
4 votes337 views1 answer
Re python3
Python
11 votes320 views1 answer
Selecting items in a column of a dataframe
Python