[R] data normalization

york8866 yu_york at hotmail.com
Wed Jun 20 02:08:27 CEST 2012


I have a dataframe such like the following:

ID	TIME	DV
1	0	0.880146038
1	1	0.88669051
1	3	0.610784702
1	5	0.756046666
2	0	0.456263368
2	1	0.369991537
2	3	0.508798346
2	5	0.441037014
3	0	0.854905349
3	1	0.960457553
3	3	0.609434409
3	5	0.655006334
.	.	.
.	.	.


I would like to generate another column with the normalized values of DV.
for each ID, normalize to the value at TIME 0.  
I was able to use 2 loops to do the normalization, however, as 2 loops took
a long time for the calculation, I don't know whether there's a better way
to do it. 
I have the following code with only 1 loop, but it did not work.  Can anyone
help with this? Thanks,

IDS <- unique(data.frame$ID)
for(WhichID in IDS) 
{
subset <- data.frame[,"ID"] == WhichID
DVREAL <- data.frame[subset,"DV"]
DVNORM[WhichID] <- DVREAL/DVREAL[1]
}







--
View this message in context: http://r.789695.n4.nabble.com/data-normalization-tp4633911.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list