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 vote151 views1 answer
How to make a script that reads from Database and then writes to the csv file and then uploads the file to Google Drive in python
Python
0 vote163 views1 answer
Query first 5 element in django
Python Django
44 votes128 views3 answers
Find sum numbers in a list in python
Python
17 votes182 views3 answers
ModuleNotFoundError: No module named 'rest_api_framework'
Python
-2 votes140 views1 answer
Images download
Python
0 vote123 views1 answer
Timeout python
Python
0 vote131 views1 answer
Dir template
Python
0 vote144 views1 answer
Django model get field verbose name
Python
47 votes123 views6 answers
Pandas read csv
Python
0 vote133 views1 answer
Django on_delete rules
Python