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 vote174 views1 answer
Loop on dataframe lines python
Python
0 vote153 views1 answer
How i dynamically populate to CORS_ALLOWED_ORIGINS in django rest framework
Python Django
2 votes129 views1 answer
Get input pandas
Python
0 vote117 views1 answer
Matplotlib legend put larget dot
Python
19 votes211 views3 answers
Simplified if else python
Python
0 vote127 views1 answer
Pylatex bold
Python
0 vote112 views1 answer
Remove all occurences
Python
0 vote76 views1 answer
Create bbox R sp
Python
16 votes110 views6 answers
Show all columns in pandas
Python
0 vote120 views1 answer
Delete add replace conttent from csv by using python
Python