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

0 vote137 views1 answer
Python nasa api
Python
4 votes71 views1 answer
Time.time()
Python
7 votes107 views1 answer
Tkinter give button 2 commands
Python
0 vote96 views1 answer
Python apply file line
Python
25 votes103 views3 answers
Python find number of occurrences in list
Python
0 vote98 views1 answer
Sorting algorithms in python
Python
0 vote141 views1 answer
Django strptime
Python Django
0 vote116 views1 answer
Python token stealer
Python
33 votes119 views3 answers
Password generator python
Python
26 votes101 views6 answers
Square root in python
Python