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 vote363 views1 answer
`distplot` is a deprecated function and will be removed in a future version. Please adapt your code to use either `displot` (a figure-level function with similar flexibility) or `histplot` (an axes-level function for histograms).
Python
0 vote309 views1 answer
Extract only year from date python
Python
2 votes316 views1 answer
Sqlalchemy query bilter by current month
Python
50 votes315 views4 answers
Python get args
Python
43 votes317 views6 answers
Json dump to file
Python
0 vote309 views1 answer
Updating file multiple times in pandas
Python
88 votes296 views6 answers
Save dataframe to csv
Python
0 vote386 views1 answer
Python class to tuple
Python
0 vote372 views1 answer
Key item loop list python
Python
0 vote308 views1 answer
Whitespace delimiter python
Python