Message-ID: <26504785.post@talk.nabble.com>
Date: 2009-11-24T22:57:06Z
From: Lisa
Subject: Split column
In-Reply-To: <da79af330911240949g65dbcfddh6bd634578edf90c8@mail.gmail.com>
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.