/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 vote346 views2 answers
Aes in python
Python
0 vote367 views1 answer
Staticmethod vs classmethod python
Python
3 votes332 views3 answers
Python iterar claves
Python
50 votes336 views4 answers
How to read files in python with
Python
0 vote347 views1 answer
Python die
Python
0 vote510 views1 answer
ImportError: cannot import name 'MigrateCommand' from 'flask_migrate'
Python Flask
3 votes365 views3 answers
Python program to count vowels in a string
Python
2 votes334 views1 answer
How to get micro symbol in python
Python
2 votes330 views2 answers
Python add list to dictionary in loop
Python
0 vote364 views1 answer
Bash escape double quote windows batch
Python