Hello, R users, I have a dataset that looks like this: id var1 var2 1 1 3 2 3 1 3 2 1 4 1 2 5 2 3 I want to split one column to two columns with 1 = 1 and 1, 2 = 1 and 2, 3 2 and 2: id var1.1 var1.2 var2.1 var2.2 1 1 1 2 2 2 2 2 1 1 3 1 2 1 1 4 1 1 1 2 5 1 2 2 2 Can anyone please help how to get this done? Thanks a lot in advance Lisa -- View this message in context: http://old.nabble.com/Split-column-tp26498361p26498361.html Sent from the R help mailing list archive at Nabble.com.
Try this: cbind(x$id, t(do.call(rbind, lapply(x[-1], sapply, switch, '1' c(1,1), '2' = c(1, 2), '3' = c(2, 2))))) On Tue, Nov 24, 2009 at 1:51 PM, Lisaj <lisajca at gmail.com> wrote:> > Hello, R users, > > I have a dataset that looks like this: > > id ? var1 ? var2 > ?1 ? ? ?1 ? ? ?3 > ?2 ? ? ?3 ? ? ?1 > ?3 ? ? ?2 ? ? ?1 > ?4 ? ? ?1 ? ? ?2 > ?5 ? ? ?2 ? ? ?3 > > I want to split one column to two columns with 1 = 1 and 1, 2 = 1 and 2, 3 > 2 and 2: > > id ? var1.1 ?var1.2 ?var2.1 ?var2.2 > 1 ? ? ? ? 1 ? ? ? 1 ? ? ? 2 ? ? ? 2 > 2 ? ? ? ? 2 ? ? ? 2 ? ? ? 1 ? ? ? 1 > 3 ? ? ? ? 1 ? ? ? 2 ? ? ? 1 ? ? ? 1 > 4 ? ? ? ? 1 ? ? ? 1 ? ? ? 1 ? ? ? 2 > 5 ? ? ? ? 1 ? ? ? 2 ? ? ? 2 ? ? ? 2 > > Can anyone please help how to get this done? Thanks a lot in advance > > Lisa > > -- > View this message in context: http://old.nabble.com/Split-column-tp26498361p26498361.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. >-- Henrique Dallazuanna Curitiba-Paran?-Brasil 25? 25' 40" S 49? 16' 22" O
Not very elegant but this does the trick: df <- cbind( var1=c(1,3,2,1,2), var2=c(3,1,1,2,3) ) out <- df out[ which(df==1, arr.ind=T) ] <- "1&1" out[ which(df==2, arr.ind=T) ] <- "1&2" out[ which(df==3, arr.ind=T) ] <- "2&2" outlist <- apply(out, 2, strsplit, split="&") do.call( "cbind.data.frame", lapply( outlist, do.call, what="rbind" ) ) var1.1 var1.2 var2.1 var2.2 1 1 1 2 2 2 2 2 1 1 3 1 2 1 1 4 1 1 1 2 5 1 2 2 2 Please check. Regards, Adai Lisaj wrote:> Hello, R users, > > I have a dataset that looks like this: > > id var1 var2 > 1 1 3 > 2 3 1 > 3 2 1 > 4 1 2 > 5 2 3 > > I want to split one column to two columns with 1 = 1 and 1, 2 = 1 and 2, 3 > 2 and 2: > > id var1.1 var1.2 var2.1 var2.2 > 1 1 1 2 2 > 2 2 2 1 1 > 3 1 2 1 1 > 4 1 1 1 2 > 5 1 2 2 2 > > Can anyone please help how to get this done? Thanks a lot in advance > > Lisa >
Hi, how can I make tests like Dunnett and Duncan using R? Thanks, -------------------------------------- Silvano Cesar da Costa Departamento de Estat?stica Universidade Estadual de Londrina Fone: 3371-4346
www.rseek.org is great for finding functions/packages that perform specific tests. Sarah On Tue, Nov 24, 2009 at 1:09 PM, Silvano <silvano at uel.br> wrote:> Hi, > > how can I make tests like Dunnett and Duncan using R? > > Thanks, >-- Sarah Goslee http://www.functionaldiversity.org