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

6 votes328 views2 answers
Max int value in python
Python
-1 vote345 views2 answers
Logarithms python
Python
0 vote353 views2 answers
The find() method in BeautifulSoup ____.
Python
1 vote382 views1 answer
Browser pop up yes no selenium python
Python
0 vote283 views2 answers
Convert scientific notation to decimal python
Python
1 vote341 views1 answer
Groupby year datetime pandas
Python
0 vote338 views1 answer
Python map function using lambda function as one of the parameters
Python
0 vote369 views1 answer
Parquet pyspark
Python
9 votes355 views2 answers
How to read video in opencv python
Python
0 vote363 views1 answer
Difference in django project view and app view
Python Django