/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

11 votes223 views2 answers
Dataframe column contains string
Python
0 vote228 views1 answer
Explorer gives new window
Python
0 vote152 views2 answers
Smooth interpolation python
Python
1 vote216 views1 answer
Numpy series reset index
Python
1 vote200 views1 answer
Pandas shift columns up until value
Python
0 vote186 views1 answer
Pytorch torchaudio torchvision cu113
Python
2 votes196 views1 answer
Remove duplicates based on two columns in dataframe
Python
2 votes186 views3 answers
Normalize numpy array
Python
3 votes174 views2 answers
Python Tkinter button Image
Python
1 vote188 views1 answer
Django don't redirect on submission
Python