I really appreciate your help. But if there is a big dataset, I need to write lots of code.
Lisa David Winsemius wrote: > > The solution I offered does exactly that. It also addresses your other > supplemental request. > > -- > David (Dangerfield?) > > On Nov 24, 2009, at 5:57 PM, Lisaj wrote: > >> >> 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 <lisa...@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@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@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. >> >> ______________________________________________ >> 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. > > David Winsemius, MD > Heritage Laboratories > West Hartford, CT > > ______________________________________________ > 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. > > -- View this message in context: http://old.nabble.com/Split-column-tp26498361p26505208.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.
