Displaying 1 result from an estimated 1 matches for "normvalu".
Did you mean:
normvalue
2012 Nov 29
7
Fast Normalize by Group
Hi,
I have a very large data set (aprox. 100,000 rows.)
The data comes from around 10,000 "groups" with about 10 entered per group.
The values are in one column, the group ID is an integer in the second column.
I want to normalize the values by group:
for(g in unique(groups){
x[group==g] / sum(x[group==g])
}
This works find in a loop, but is slow. Is there a faster way to do