CODE EXAMPLE FOR PYTHON

python aggregate count and sum

(df.groupby('Company Name')
.agg({'Organisation Name':'count', 'Amount': 'sum'})
.reset_index()
.rename(columns={'Organisation Name':'Organisation Count'})

         Company Name   Amount  Organisation Count
0  Vifor Pharma UK Ltd  4207.93                   5