Re: [R] melting a data frame

2013-09-08 Thread Data Analytics Corp.
lt;- 1:nrow(res) dim(res) #[1] 1170 21 A.K. - Original Message - From: Data Analytics Corp. To: R help Cc: Sent: Saturday, September 7, 2013 11:33 PM Subject: [R] melting a data frame Hi, Suppose I have a data frame with 189 columns. The columns are actually 9 blocks of 21 col

Re: [R] melting a data frame

2013-09-08 Thread John Fox
{x1<- dat1[,x]; colnames(x1)<- paste("V",1:21);x1})) >  row.names(res)<- 1:nrow(res) >  dim(res) > #[1] 1170   21 > A.K. > > > > - Original Message - > From: Data Analytics Corp. > To: R help > Cc: > Sent: Saturday, September 7, 20

Re: [R] melting a data frame

2013-09-08 Thread arun
Forgot:  res2<-subset(res1,select= -c(time,id)) A.K. - Original Message - From: arun To: "w...@dataanalyticscorp.com" Cc: R help Sent: Sunday, September 8, 2013 9:49 AM Subject: Re: [R] melting a data frame Hi, You may also try ?reshape() dat2<- dat1 names(dat2)[-

Re: [R] melting a data frame

2013-09-08 Thread arun
"paste" to "paste0"  row.names(res)<- 1:nrow(res) all.equal(res,res2) #[1] TRUE A.K. - Original Message - From: arun To: "w...@dataanalyticscorp.com" Cc: R help Sent: Sunday, September 8, 2013 9:29 AM Subject: Re: [R] melting a data frame Hi, You could tr

Re: [R] melting a data frame

2013-09-08 Thread arun
1:nrow(res)  dim(res) #[1] 1170   21 A.K. - Original Message - From: Data Analytics Corp. To: R help Cc: Sent: Saturday, September 7, 2013 11:33 PM Subject: [R] melting a data frame Hi, Suppose I have a data frame with 189 columns.  The columns are actually 9 blocks of 21

[R] melting a data frame

2013-09-08 Thread Data Analytics Corp.
Hi, Suppose I have a data frame with 189 columns. The columns are actually 9 blocks of 21 columns each, each block representing measures on each of 9 products. There are 130 rows. Suppose I extract the first block of 21 columns and make them into a separate data frame. I then want to take