Python aggregate count and sum

In [110]: (df.groupby('Company Name')
   .....:    .agg({'Organisation Name':'count', 'Amount': 'sum'})
   .....:    .reset_index()
   .....:    .rename(columns={'Organisation Name':'Organisation Count'})
   .....: )
Out[110]:
          Company Name   Amount  Organisation Count
0  Vifor Pharma UK Ltd  4207.93                   5

Source: stackoverflow.com

Python aggregate count and sum

df.groupby('Company Name').agg(MySum=('Amount', 'sum'), MyCount=('Amount', 'count'))

Source: stackoverflow.com

Similar codes

3 votes321 views1 answer
Chech box in tkinter
Python
3 votes365 views4 answers
Perfect numbers python
Python
3 votes370 views1 answer
Python docker
Python
0 vote350 views2 answers
User logout in django rest framework
Python
0 vote374 views1 answer
Jupyterlab interactive plot
Python
0 vote331 views3 answers
How to remove vowels from a string in python
Python
32 votes324 views6 answers
Else if python
Python
12 votes308 views1 answer
Python dlete folder
Python
0 vote328 views1 answer
Onetoone vs foreign key django
Python
15 votes314 views3 answers
Abs in python 3
Python