Calculate column mean and fill to another column without code

Solved!
Sarissa
Level 2
Calculate column mean and fill to another column without code

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?

0 Kudos
1 Solution
Mattsco
Dataiker

Hi, 

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


Mattsco

View solution in original post

3 Replies
Mattsco
Dataiker

Hi, 

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


Mattsco
Sarissa
Level 2
Author

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

Sarissa
Level 2
Author

This worked like a charm. Thank you.