Skip to content
Back to formatted view

Raw Message

Message-ID: <1CEB66C9-1379-4496-8E14-25DA0D5F8E37@comcast.net>
Date: 2012-05-07T04:20:24Z
From: David Winsemius
Subject: question about transforming data into data frame object
In-Reply-To: <SNT139-W33DF3A48704DC4AEF1472C1120@phx.gbl>

On May 6, 2012, at 3:56 PM, E Atescelik wrote:

> Hi,I had a question about transforming data into data frame object  
> with two columns.  I have data "genal2.txt" (see attachment)  My  
> data frame called "genal2frame" has to be in the form:  
> genal2frame[1:6,]
>           y             mut
> 1    0.5105618    0.005
> 2    0.3428392    0.005
> 3    0.5490900    0.005
> 4    0.4460895    0.010
> 5    0.5214594    0.010
> 6    0.4009612    0.010  Thanks in advance! Kind regards,Esra  
> Atescelik   		 	   		  <genal2.txt>

dat <- read.table("genal2.txt", header=TRUE)
tdat <- as.data.frame(t(dat))
tdat$time <- sub("X0\\.", "", rownames(tdat))
names(tdat) <- c("x.1","x.2","x.3","grp")
longdat <- reshape(tdat, idvar=4, direction="long", varying=1:3)
longdat[order(longdat$grp), c("x", "grp") ]

-- 
David Winsemius, MD
West Hartford, CT