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 vote226 views1 answer
Transform image to rgb python
Python
0 vote248 views1 answer
Django strptime
Python Django
0 vote215 views1 answer
Django delete session
Python Django
-1 vote238 views1 answer
Parametric relu in keras convolution layer
Python
0 vote268 views1 answer
Screen.onkey python
Python
0 vote205 views1 answer
Plot row vs column in dataframe python
Python
11 votes207 views5 answers
Convert dataframe column to float
Python
0 vote216 views1 answer
Python list files in folder with wildcard
Python
0 vote218 views1 answer
How to get the author on discord.py
Python
0 vote213 views1 answer
Python PowerPoint
Python