/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 votes214 views2 answers
Background image in python
Python
0 vote251 views1 answer
Django serializer get image list
Python Django
0 vote219 views1 answer
Python combine nested for loops
Python
0 vote233 views2 answers
From django.core.management import execute_from_command_line ImportError: No module named django.core.management
Python
24 votes213 views6 answers
Pd.read_excel
Python
0 vote230 views1 answer
-bash: /usr/local/bin/python3: no such file or directory
Python
1 vote166 views1 answer
Pandas shift all columns
Python
0 vote225 views1 answer
Raise keyerror(key) from none os.environ
Python
1 vote205 views1 answer
GdScript int
Python
30 votes208 views2 answers
Mysql.connector methods python
Python