[R] For loop

arun smartpink111 at yahoo.com
Fri Nov 30 17:15:28 CET 2012


Hi,
Try this:
dat1<-read.table(text="
id    time     res
1    2    0.64
1    3    0.78
1    3    6.5
1    3    4.5
1    4    4
1    5    3.4
2    10    5.7
2    11    5.8
2    11    9.3
2    11    3.4
2    12    3.4
2    13    6.7
3    3    5.6
3    3    3.4
3    4    2.3
3    5    5.6
3    12    9.8
3    10    7
3    24    6
3    16    4
",sep="",header=TRUE,stringsAsFactors=TRUE)
res<-dat1[!duplicated(dat1[,1:2]),]
 res
#   id time  res
#1   1    2 0.64
#2   1    3 0.78
#5   1    4 4.00
#6   1    5 3.40
#7   2   10 5.70
#8   2   11 5.80
#11  2   12 3.40
#12  2   13 6.70
#13  3    3 5.60
#15  3    4 2.30
#16  3    5 5.60
#17  3   12 9.80
#18  3   10 7.00
#19  3   24 6.00
#20  3   16 4.00
row.names(res)<-1:nrow(res)

A.K.



----- Original Message -----
From: bibek sharma <mbhpathak at gmail.com>
To: R-help at r-project.org
Cc: 
Sent: Friday, November 30, 2012 10:59 AM
Subject: [R] For loop

Hello user,
I have large data containing  subject id, time and response where
subjects are measured repeatedly. However some time are duplicates. I
only want data with unique time points per id. I mean if time is
repeated, then take only one.
Here is a sample data.

id    time     res
1    2    0.64
1    3    0.78
1    3    6.5
1    3    4.5
1    4    4
1    5    3.4
2    10    5.7
2    11    5.8
2    11    9.3
2    11    3.4
2    12    3.4
2    13    6.7
3    3    5.6
3    3    3.4
3    4    2.3
3    5    5.6
3    12    9.8
3    10    7
3    24    6
3    16    4

for 1st subject I want this,

id    time     res
1    2    0.64
1    3    0.78
1    4    4
1    5    3.4
Any suggestions are much appreciated!
Thanks,
Bikek

______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.





More information about the R-help mailing list