/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

2 votes347 views2 answers
Get title attribute beautiful soup
Python
0 vote355 views2 answers
Openpyxl _cells_by_row
Python
79 votes351 views6 answers
Python current working directory
Python
2 votes342 views1 answer
Convert python pandas series dtype to datetime
Python
42 votes350 views4 answers
Pickle.dump python
Python
1 vote324 views1 answer
How to find what is the response from the server with python
Python
0 vote337 views1 answer
HTTPSConnectionPool(host='files.pythonhosted.org', port=443): Read timed out
Python
0 vote346 views1 answer
Python message from byte
Python
-1 vote338 views2 answers
If __name__=='__main__':
Python
0 vote352 views1 answer
List of lists to table python
Python