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

82 votes158 views6 answers
Arch Linux
Python
2 votes170 views2 answers
Label encoder python
Python
-1 vote159 views1 answer
Rewrite the equation shown in Figure 2.4 as a Python expression and get the result of the equation: Pay special attention to the order of operations.
Python
0 vote187 views1 answer
Preventing players from changing existing entries in tic tac toe game
Python
1 vote151 views2 answers
How to download python freegames
Python
0 vote161 views1 answer
How to set and run flask app on terminal
Python
2 votes145 views2 answers
Python how to sum two lists
Python
1 vote185 views1 answer
Iterate over dictionary django
Python
4 votes122 views2 answers
How to scatter plot in matplotlib of two sets
Python
11 votes145 views6 answers
How to capitalize first letter in python
Python