Hi,
You could also use ddply.
Though, the output format differs a bit from aggregate().
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)
dat2
a b c d
1 E001234 c("TSA", "TSB", "TSC", "TSD") IP234 like_domain
2 E001235 c("TSA", "TSD", "TSS") IP235 two_domain
3 E001236 c("TSP", "TST") IP236 like_domain
4 E001237 TSV IP237 simple_domain
A.K.
----- Original Message -----
From: tgodoy <tingola...@hotmail.com>
To: r-help@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@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.
______________________________________________
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.
