/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 vote140 views1 answer
Python integer to string format
Python
3 votes135 views1 answer
Chech box in tkinter
Python
4 votes152 views2 answers
Random matrix python
Python
19 votes140 views5 answers
Save matplotlib figure
Python
0 vote138 views1 answer
Python red table from pdf
Python
1 vote136 views1 answer
Py exe tkinter
Python
3 votes143 views1 answer
Io.UnsupportedOperation: not readable
Python
0 vote143 views2 answers
Labs fill ggplot2
Python
0 vote143 views1 answer
Multiplication of two or more numbers in python
Python
3 votes160 views2 answers
Python dict order a dict by key
Python