Split column
I have a further question. If there is NA (missing data) in the original dataset, just like this: id var1 var2 1 1 3 2 3 1 3 NA 1 4 1 2 5 2 3 how to deal with it? The converted dataset should be this: id var1.1 var1.2 var2.1 var2.2 1 1 1 2 2 2 2 2 1 1 3 NA NA 1 1 4 1 1 1 2 5 1 2 2 2 Thanks. Lisa The
Henrique Dallazuanna wrote:
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
______________________________________________ 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.
View this message in context: http://old.nabble.com/Split-column-tp26498361p26504785.html Sent from the R help mailing list archive at Nabble.com.