search for: avarg

Displaying 1 result from an estimated 1 matches for "avarg".

Did you mean: vaarg
2006 May 30
2
average by group...
I have a dataframe with 700,000 rows and 2 vectors (columns): ?group? and ?score?. I wish to calculate a third vector of length 700000: the average score by group. Even though the avarge value will repeat, I wish to return the average for that particular group for each row. (I know I can do this by calculating each group?s average and then using the merge command, but as my calculations get more complex and my data set gets larger, the merge command seems to be fairly slow.)