Add aggregations to a column
UserBird
Dataiker, Alpha Tester Posts: 535 Dataiker
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?
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?
Best Answer
-
Hi Simon,
You could do a grouping recipe and then a join recipe.
Answers
-
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.
