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 vote99 views2 answers
Python test if you can convert to int
Python
0 vote56 views1 answer
Freqtrade - Informative Pairs
Python
2 votes99 views2 answers
Create django user command line
Python
0 vote92 views1 answer
Django created at field
Python
1 vote98 views1 answer
Replace url with text python
Python
1 vote96 views2 answers
All column except pandas
Python
0 vote165 views1 answer
Txt file duplicate line remover python
Python
3 votes105 views2 answers
How to create a network scanner in python
Python
0 vote107 views1 answer
Access nested set with array params python
Python
6 votes98 views4 answers
Argparse required arguments
Python