/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 vote252 views1 answer
Pyspark rdd filter
Python
4 votes250 views2 answers
Print prime numbers from 1 to 100 in python in single line
Python
2 votes261 views1 answer
Python subprocess with environment variables
Python
0 vote271 views1 answer
Apyori
Python
0 vote255 views1 answer
Type of tuple in python
Python
3 votes251 views1 answer
Pickle load pickle file
Python
1 vote283 views2 answers
Python str prefix
Python
7 votes256 views1 answer
Smtp email template
Python
0 vote239 views1 answer
Python turn list of strings into list of doubles
Python
4 votes245 views2 answers
Python dictionary sort by value then alphabetically
Python