Yes, except that patients have different cycle numbers. Such as, one might
have cycle 1,2,3, and another has 1,4,12.
On Jun 6, 2012 12:54 PM, "arun" <smartpink...@yahoo.com> wrote:
> Hi Iglucia,
>
> I am not sure how your dataset looks like. Does it look similar to this:
>
> > dat4<-data.frame(patient=rep(c(1:10),
> rep(3,10)),var=rep(c("cycle0","cycle1","cycle2"),rep(1,3)),value=c(rnorm(15,1,0.5),NA,rnorm(5,1,0.5),NA,rnorm(8,1,0.5)))
> > dat4
> patient var value
> 1 1 cycle0 1.8826827
> 2 1 cycle1 1.0316985
> 3 1 cycle2 1.0084754
> 4 2 cycle0 1.1822553
> 5 2 cycle1 1.5494087
> 6 2 cycle2 0.9173749
> 7 3 cycle0 0.3935503
> 8 3 cycle1 0.7012282
> 9 3 cycle2 0.5213031
> 10 4 cycle0 0.8330390
> 11 4 cycle1 0.6430550
> 12 4 cycle2 0.7751283
> 13 5 cycle0 1.4092714
> 14 5 cycle1 0.8120330
> 15 5 cycle2 0.6255491
> 16 6 cycle0 NA
> 17 6 cycle1 0.1068520
> 18 6 cycle2 0.7556006
> 19 7 cycle0 1.4322698
> 20 7 cycle1 1.6109262
> 21 7 cycle2 0.9650534
> 22 8 cycle0 NA
> 23 8 cycle1 0.3861208
> 24 8 cycle2 1.1349206
> 25 9 cycle0 1.5659958
> 26 9 cycle1 1.8725942
> 27 9 cycle2 1.5676570
> 28 10 cycle0 1.0895054
> 29 10 cycle1 1.1941775
> 30 10 cycle2 1.3932515
>
>
>
>
>
> A.K.
>
>
>
>
>
>
> ----- Original Message -----
> From: lglucia <libgray3...@gmail.com>
> To: r-help@r-project.org
> Cc:
> Sent: Wednesday, June 6, 2012 12:07 AM
> Subject: [R] Combine subsets by factor level
>
> I'm attempting to change a data set by compressing rows into columns.
> Currently there are several rows that all have information about one
> "patient," but at different cycles. I'm trying to make each patient only
> have one row in the data set.
>
> Does anyone know a good way to combine data sets by factor level? I've
> separated the groups into different subsets by cycle, but not every patient
> has data for every cycle (i.e. there are 1200 who have cycle 0, but only
> 200
> of those have a cycle 1, and a different number have cycles higher than
> that, etc). I then made the patient number the identifying label. If there
> is a way to column-combine these subsets by the factor level of these
> patient names, and leave any patients that are missing a cycle as NA?
>
> If anyone has insight on how to do this, or a better way to complete what
> I'm trying to do, I'd appreciate it!
>
> --
> View this message in context:
> http://r.789695.n4.nabble.com/Combine-subsets-by-factor-level-tp4632472.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help@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.
>
>
[[alternative HTML version deleted]]
______________________________________________
R-help@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.
