Calculate column mean and fill to another column without code

Sarissa

Is there an easy way to do this for a newbie (who is not Python/R fluent)? I would like to take the mean of a column ("Score") and fill all the rows in another column ("Score_Mean") with that value. Can that be done without code...just with the UI for Dataiku 7?

Mattsco

Hi,

Yes, you can use the window recipe and you fill only the Aggregations part with "Avg" of the column you want.

Sarissa

Thank you! I will give that a try. I must have been half asleep when I tried that last night...

Sarissa

This worked like a charm. Thank you.