🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

[SOLVED] Average/deviation by group

User: "andreister"
New Altair Community Member
Updated by Jocelyn
I have a data set  where one of the columns is category. And I want to calculate the mean and standard deviation of some other column, but separately for each category.

Ie., for input like

GroupName...Value
A.......................1
A.......................3
B......................1
B.......................5

I want the output like

GroupName...Value...Mean...StdDev
A.......................1...........2...........1.44          
A.......................3...........2...........1.44
B.......................1...........3...........2.8
B.......................5...........3...........2.8


I know how to get the group means and standard deviations via Aggregate operator, but I dont know how to add the new columns to the original dataset. What am I missing?

Thanks!

Find more posts tagged with

Sort by:
1 - 3 of 31
    User: "MariusHelf"
    New Altair Community Member
    Add an ID attribute before the Aggregate operator, then join the results of Aggregate to the original data using the Join operator and the id attribute.

    Best regards,
    Marius
    User: "andreister"
    New Altair Community Member
    OP
    Ok  great - Join operator was the missing part.

    I put "inner" join and selected my grouping attribute for both left and right subsets, works like a charm.
    User: "MariusHelf"
    New Altair Community Member
    Hi, uncheck the parameter and join by the group attributes instead.