[R] How to concatenate a several rows according with a column ?

[arun]

HI,
Try this:
#Reformatted the ddply results to match your desired output.
dat1<-read.table(text="
   a                    b         c             d
      E001234      TSA    IP234   like_domain
      E001234      TSB    IP234   like_domain    
      E001234      TSC    IP234   like_domain
      E001234      TSD    IP234   like_domain
      E001235      TSA    IP235   two_domain
      E001235      TSD    IP235   two_domain
      E001235      TSS    IP235   two_domain
      E001236      TSP    IP236   like_domain
      E001236      TST    IP236   like_domain
    E001237      TSV    IP237   simple_domain 
",sep="",header=TRUE,stringsAsFactors=FALSE)

dat2<-ddply(dat1,.(a,c,d), paste,sep=",")
dat2<-dat2[,c(1,5,2:3)]
colnames(dat2)<-colnames(dat1)
dat3<-data.frame(sapply(dat2,function(x) gsub("c|\\(|\\\"|\\)","",x)))
dat3
#        a                  b     c             d
#1 E001234 TSA, TSB, TSC, TSD IP234   like_domain
#2 E001235      TSA, TSD, TSS IP235    two_domain
#3 E001236           TSP, TST IP236   like_domain
#4 E001237                TSV IP237 simple_domain

A.K.


----- Original Message -----
From: tgodoy <tingola_07 at hotmail.com>
To: r-help at r-project.org
Cc: 
Sent: Friday, August 3, 2012 1:00 PM
Subject: [R] How to concatenate a several rows according with a column ?

Hi, I'm a new user or R and I try to concatenate a several rows according
with the value in a column. 

this is my data.frame and I want to concatenate my data.frame according with
the column "b" and make a new data.frame with the information in the others
columns. 

>table1
         a                    b         c             d
1      E001234      TSA    IP234   like_domain
2      E001234      TSB    IP234   like_domain    
3      E001234      TSC    IP234   like_domain
4      E001234      TSD    IP234   like_domain
5      E001235      TSA    IP235   two_domain
6      E001235      TSD    IP235   two_domain
7      E001235      TSS    IP235   two_domain
8      E001236      TSP    IP236   like_domain
9      E001236      TST    IP236   like_domain
10    E001237      TSV    IP237   simple_domain

I want my table in this way

>table_new
         a                    b                                      c            
d
1      E001234      TSA, TSB, TSC, TSD    IP234   like_domain
2      E001235                TSA, TSD, TSS    IP235   two_domain
3      E001236                 TSP, TSP, TST    IP236   like_domain
4      E001237                                   TSV    IP237  
simple_domain

How can I do this in R? 

Thanks 




--
View this message in context: http://r.789695.n4.nabble.com/How-to-concatenate-a-several-rows-according-with-a-column-tp4639072.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
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.