/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

27 votes126 views3 answers
Replace error with nan pandas
Python
0 vote124 views1 answer
How do i activate python on windows
Python
0 vote149 views1 answer
Pie auto percentage in python
Python
1 vote153 views1 answer
Flask redirect to url
Python
10 votes132 views4 answers
Pandas
Python
0 vote126 views1 answer
Python discover methods of object/module
Python
0 vote160 views1 answer
How to get max id in mongodb python
Python
0 vote129 views1 answer
Change value in excel in python
Python
3 votes135 views3 answers
Generate n different random numbers python
Python
0 vote133 views1 answer
InvalidVersionSpec: Invalid version ' 0 . 7 . 1 2 ': invalid character(s)
Python