[R] transform
Val
valkremk at gmail.com
Sat Oct 1 02:23:06 CEST 2016
Hi all,
I want to standardize a variable based on certain condition
Here is my sample of data
obs, Year, bb, kk, y
1, 2001, 25 ,100, 12.6
2, 2001, 15 ,111, 24.7
3, 2001, 53, 110, 13.8
4, 2001, 50, 75, 9.6
5, 2001, 125, 101, 31.5
6, 2001, 205, 407, 65.7
7, 2001, 250, 75, 69.1
If the value of "bb" is greater than 75 and the value of "kk" is
greater than 100 then I want get the mean and STD values of "y". In
this example obs 5 and 6 satisfy the condition. The mean is 48.6 and
STDEV is 24.18
Then I want to transform the "y" values with mean = 10 and SDTEV of 3.
w= ((y- 48.6)/24.183)*3 +10
My question, how can i pas those mean and STDEV values to create the
new variable (w)?
The result looks as follows
obs, Year, bb, kk, y, w
1, 2001, 25 ,100 , 12.6, 5.534062435
2, 2001, 15, 111, 24.7, 7.035113672
3, 2001, 53, 110, 13.8, 5.68292702
4, 2001, 50, 75, 9.6, 7.642977396
5, 2001, 125, 101, 31.5, 7.878679656
6, 2001, 205, 407, 65.7, 12.12132034
7, 2001, 250, 75 , 69.1, 12.54310334
Thank you in advance
More information about the R-help
mailing list