[R] Split column

[Lisaj]

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 <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.
>>
>> ______________________________________________
>> 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.
> 
> David Winsemius, MD
> Heritage Laboratories
> West Hartford, CT
> 
> ______________________________________________
> 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-tp26498361p26505208.html
Sent from the R help mailing list archive at Nabble.com.