Python code for AGGREGATE function in excel

You can see examples of the AGGREGATE function below:

python code for the AGGREGATE function

import pandas as pd

df =pd.read_csv("example.csv") 

out=df.aggregate({"Height":['max', 'min'],"Age":['max', 'min'],"Weight":['min', 'max']})

print(out)

Height Age Weight

max 210 29 240
min 195 21 180

AGGREGATE function

The AGGREGATE function is one of the math functions of Excel.

This function has multiple argument lists.

AGGREGATE arguments

This function has just 1 Argument:

The argument of AGGREGATE function is number.

Function_num is the number 1 to 19 that specifies the summary function for the aggregate.

The argument of AGGREGATE function is required and not optional.

AGGREGATE(number) = number

Related posts:

Excel ACOTH Function Excel LOGNORM.INV Function Excel ISNONTEXT Function Excel DMAX Function