/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

0 vote233 views1 answer
Python drop extension
Python
0 vote235 views1 answer
Var colors python
Python
4 votes230 views2 answers
How to use ternary operater in python
Python
2 votes234 views1 answer
Flask minimul app
Python
3 votes237 views1 answer
How to make a empty folder using os in pyhon
Python
0 vote256 views2 answers
Check if variable is function python
Python
0 vote204 views1 answer
Neo4j python
Python
18 votes244 views6 answers
Turtle python
Python
0 vote252 views1 answer
Python max value of list of tuples
Python
5 votes294 views3 answers
How to save unzipped files in python
Python