Check out Building a Data-Centric Culture at the ALMA Observatory on November 5th Read More

Calculate column mean and fill to another column without code

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
3 Replies
Dataiker
Dataiker

Hi, 

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


Mattsco
Level 2
Author

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

Level 2
Author

This worked like a charm. Thank you.