New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

Add aggregations to a column

Solved!
UserBird
Dataiker
Dataiker
Add aggregations to a column
If I have data like this:

A 1
B 2
A 2
B 3

I want to create a third column that would produce either sum, min, max, avg over first column.
Example for max:

A 1 2
B 2 3
A 2 2
B 3 3



How can I do it in DSS?
0 Kudos
1 Solution
Mattsco
Dataiker
Dataiker

Hi Simon, 

You could do a grouping recipe and then a join recipe. 



Mattsco

View solution in original post

2 Replies
jereze
Dataiker
Dataiker

Hi Simon,



Hum, you could do that in Python, R or SQL.

Personally, I would use Window Functions in SQL. If you are working on Mac OS X, here is an easy way to install PostgreSQL on your mac.

Jeremy, Product Manager at Dataiku
Mattsco
Dataiker
Dataiker

Hi Simon, 

You could do a grouping recipe and then a join recipe. 



Mattsco

View solution in original post

Labels (2)
A banner prompting to get Dataiku DSS