pandas groupby count as new column

156

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

group by count dataframe -

df.groupby(['col1', 'col2']).size().reset_index(name='counts')

group by count dataframe -

df.groupby(['col1','col2']).size()

group by pandas count -

df[['col1', 'col2', 'col3', 'col4']].groupby(['col1', 'col2']).agg(['mean', 'count'])

Comments

Submit
0 Comments