How to get the minimum value of a whole column in a formula?

Highlighted
UserBird Dataiker
Dataiker
How to get the minimum value of a whole column in a formula?
In a more general way, this about being able to reach the whole dataset and not only the cells on the same row from the formula. I'm not sure whether this is possible or not.
0 Kudos
1 Reply
jereze Dataiker
Dataiker
Re: How to get the minimum value of a whole column in a formula?

Hi,



That's not possible (in DSS 3.x at least). The processors of the prepare recipe are not aware of all the rows (they only work row by row). The Formula is one of these processors. (See more about the prepare recipe in the doc).



As an alternative, you can use a code recipe (SQL, Python, R...) or try to do that with the group recipe.



In a Python notebook, with the library pandas, a df.describe() would do the job.



I hope that helps,

Jeremy

Jeremy, Product Manager at Dataiku
0 Kudos
Labels (2)