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 vote184 views1 answer
Python get timestamp of today
Python
1 vote152 views1 answer
For i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):
Python
0 vote216 views1 answer
Get date only from datetimefiel django
Python Django
0 vote218 views0 answer
Python
2 votes163 views1 answer
Python read text file look for string
Python
0 vote122 views2 answers
Video to text python
Python
0 vote166 views2 answers
Python string find
Python
0 vote167 views1 answer
Python decorator *args **kwargs
Python
0 vote177 views1 answer
Spacy Vietnamese
Python
1 vote161 views1 answer
How to convert string to function name in python
Python