[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