/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 vote122 views1 answer
Conditional Statements to Skip Items enumerate python
Python
0 vote143 views1 answer
Find & set values in pandas Dataframe
Python
60 votes139 views6 answers
List files in directory python
Python
1 vote130 views2 answers
Np matrix drop zero column
Python
26 votes156 views4 answers
Python send email with attachment
Python
0 vote131 views1 answer
Python interview questions github
Python
0 vote147 views1 answer
Introduction to sets python3
Python
0 vote120 views1 answer
How to add to end of linked list python
Python
0 vote119 views1 answer
Python opens windows store
Python
1 vote129 views1 answer
Python shortest path of list of nodes site:stackoverflow.com
Python