Calculate an average of the column
Hugo_Wsld
Registered, Frontrunner 2022 Participant Posts: 12 ✭✭✭✭
Hello everyone,
Pease, could you let me know how to calculate the average of the column of this table below ?
I don't want to calculate the average of the rows, but the average of the column only
Many thanks, in advance
Regards,
Hugo
Best Answer
-
Manuel Alpha Tester, Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Dataiku DSS Adv Designer, Registered Posts: 193 ✭✭✭✭✭✭✭Hu Hugo,
You can use the metric functionality:
- on the dataset, select the Status tab > Edit > Column Statistics (see image)
- Define the AVG for the column you want
- Now go back to the Metrics tab and click 9/7 Metrics button
- Add your metric to display
- Click compute
More information here:
- documentation: https://doc.dataiku.com/dss/latest/scenarios/metrics.html
- Video from academy:
//play.vidyard.com/87rWjK4juKSWWA6GsDLQcU.html?
I hope this helps
Answers
-
Tashhh Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1 ✭Hello,
I tried to calculate the avg and sum of a column but I got "INFINITY" as an output value.
How can I solve this please?
You'll find attached the metrics values as well as a snippet of the dataframe that I'm working on.
Thanks