I think it's trivial but I've only started to learn JSL syntax and I'm struggling with this one.
Saying I have a column "myValues" that contains my numeric values and a column "myGroups" that is a categorical variable to group my values together. What formula can I use in a third column to get the mean of "myValues" group by group.
The "ColStat" fumctions is mainly useful in column formulas and cannot return non-repeated values as far as I know.
But Summarize() can. Example:
Summatize(g = group(:mygrps), m = Mean(my values))
Where m is matrix of the mean at each level of g, a list of group names (as strings). Excluded rows are not included.