[R] get the values of unique ID
Jane Yu
jyuzh at yahoo.com
Thu Mar 27 20:09:23 CET 2003
Hi, All,
I wonder anyone can help me find a faster algorithm to
get the values of unique ID (most ID has 2-3 values,
varies).
My data looks like:
ID Values
1 250
2 300
1 251
3 5000
4 600
10 521
3 5500
I would like output to look like:
ID, avg(values), stdev(values), value 1,val 2,val3,...
I used 2 for loops trying to get the values
for (i in 1:n){
value <- NULL
for(j in 1:m){
if(data[j,1] == uniqueid[i]){
value <- c(value, data[j,2])
....
}
}
}
Since both n and m are about 10000, the algorithm is
really slow. I believe there is some function out
there that can do better than this in R.
Thanks
-Jindan
More information about the R-help
mailing list