[R] Problems with computing an aggregated score
Hatsch
johannes.heer at googlemail.com
Wed Jul 15 12:37:11 CEST 2009
Hi all,
I have a problem with computing a new variable as an aggregated score of
other variables.
Say, I have 10 variables for 1,000 observations (people). Every variable may
have values between 0 and 8. What I would like to do is computing the mean
of the individual top 3 values for every person.
Exampe: The values for the 10 variables (v1 to v10) for person A, B and C
are as follows:
A 0 1 0 2 5 8 3 0 4 0
B 6 4 3 0 0 0 0 5 0 0
C 0 0 8 0 0 8 0 0 0 0
So, I would like to compute a new variable for the mean of the individual
top 3 values, which would result for person A, B and C in the following:
A (8+5+4)/3 = 5.67
B (6+5+4)/3 = 5
C (8+8+0)/3 = 5.33
Is there any way to do this?
Any clues, hints and suggestions are highly appreciated,
many thanks in advance
Johannes
--
View this message in context: http://www.nabble.com/Problems-with-computing-an-aggregated-score-tp24495390p24495390.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list