/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

1 vote200 views1 answer
Python program to convert rupees to paise
Python
22 votes162 views3 answers
Python sort list in reverse order
Python
0 vote167 views1 answer
Reassign variable python
Python
0 vote150 views1 answer
Python tkinter importieren
Python
89 votes171 views3 answers
Install opencv for python 2.7
Python
0 vote194 views1 answer
Pyfiglet not coming up cmd
Python
0 vote179 views1 answer
Find number of unique keys in the dictionary
Python
0 vote161 views1 answer
Python how to turn a word into a list
Python
21 votes163 views6 answers
Python linear regression
Python
-1 vote159 views1 answer
Matplotlib limit number of ticks
Python