[R] converting multiple lines of text to a data frame

Andrew Yee yee at post.harvard.edu
Sat Mar 6 22:56:02 CET 2010


Phil, thanks for your suggestion of unstack, which is just what I was
looking for.

Andrew

On Fri, Mar 5, 2010 at 11:52 PM, Phil Spector <spector at stat.berkeley.edu> wrote:
> Andrew-
>   Maybe something like this:
>
>> dd = read.table(filename)
>> unstack(dd,V2~V1)
>
>  A. B.   C.
> 1  1  2 10.0
> 2 34 20  6.7
> 3  2 78 35.0
>
>                                        - Phil Spector
>                                         Statistical Computing Facility
>                                         Department of Statistics
>                                         UC Berkeley
>                                         spector at stat.berkeley.edu
>
>
>
>
> On Fri, 5 Mar 2010, Andrew Yee wrote:
>
>> I'm trying to find a way for converting multiple lines of text into a
>> table.  I'm not sure if there's a way where you can use read.delim()
>> to read in multiple lines of text and create the following data frame
>> with something akin to rehape()?.  Apologies if there is an obvious
>> way to do this.
>>
>> A: 1
>> B: 2
>> C: 10
>> A: 34
>> B: 20
>> C: 6.7
>> A: 2
>> B: 78
>> C: 35
>>
>> Convert the above lines into the following data frame
>>
>> A             B             C
>> 1              2              10
>> 34            20            6.7
>> 2              78            35
>>
>> Thanks,
>> Andrew
>>
>> ______________________________________________
>> 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.
>



More information about the R-help mailing list