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
df.groupby('Company Name').agg(MySum=('Amount', 'sum'), MyCount=('Amount', 'count'))