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

36 votes100 views6 answers
Requirement.txt for python
Python
7 votes100 views1 answer
Tuple and list in python
Python
0 vote135 views1 answer
Bootstrap 5 in Django
Python Django
0 vote120 views1 answer
Back button django template
Python Django
0 vote100 views1 answer
Not want to assign all values of a collection of values in python
Python
13 votes101 views5 answers
How to make a timer using python
Python
28 votes89 views6 answers
Pandas create empty dataframe
Python
1 vote90 views1 answer
Get name of month python
Python
4 votes97 views1 answer
Np.random.uniform
Python
8 votes93 views3 answers
Python execute function from string
Python