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

5 votes152 views3 answers
Openpyxl delete rows
Python
46 votes228 views6 answers
How to replace nan with 0 in pandas
Python
0 vote142 views1 answer
For lopp python
Python
0 vote191 views1 answer
Python qt always on top
Python
0 vote189 views2 answers
Django pagination class based views
Python Django
1 vote174 views1 answer
Redirected but the response is missing a Location: header.
Python
0 vote221 views1 answer
How to get only non-blank entry of list in python
Python
0 vote144 views1 answer
"not equal to" python symbol
Python
0 vote159 views2 answers
How to take unknown number of inputs in python
Python
0 vote147 views1 answer
Python pprint on file
Python