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

2 votes166 views1 answer
Python read text file into a list
Python
0 vote161 views1 answer
Specific mail.search python UNSEEN SINCE T
Python
0 vote153 views1 answer
Python load a txt file and assign a variable
Python
33 votes154 views6 answers
Python array
Python
2 votes182 views2 answers
How to translate to string to different alphabet python
Python
33 votes126 views5 answers
Float to int python
Python
4 votes205 views5 answers
Min max python
Python
0 vote162 views1 answer
Python for loop float increment
Python
1 vote157 views1 answer
How yo import python lib
Python
8 votes179 views2 answers
How to launch an application using python
Python