[R] Data separated by spaces, getting data into R using field lengths

Lauri Nikkinen lauri.nikkinen at iki.fi
Tue Sep 8 14:07:25 CEST 2009


Thanks, I tried it but I got

> varlength <- c(2, 2, 18, 5, 18)
> read.fwf("c:temppi.txt", widths=varlength)
  V1 V2                 V3    V4   V5
1 DF 12  This is an exampl e 1 T  his
2 DF 12  This is an 1232 T his i    s
3 DF 14  This is 12334 Thi s is   an
4 DF 15  This 23 This is a n exa mple

Which is not the way I want it.

structure(list(V1 = structure(c(1L, 1L, 1L, 1L), .Label = "DF", class
= "factor"),
    V2 = c(12L, 12L, 14L, 15L), V3 = structure(c(4L, 3L, 2L,
    1L), .Label = c(" This 23 This is a", " This is 12334 Thi",
    " This is an 1232 T", " This is an exampl"), class = "factor"),
    V4 = structure(c(1L, 2L, 4L, 3L), .Label = c("e 1 T", "his i",
    "n exa", "s is "), class = "factor"), V5 = structure(c(2L,
    4L, 1L, 3L), .Label = c("an ", "his", "mple", "s"), class =
"factor")), .Names = c("V1",
"V2", "V3", "V4", "V5"), class = "data.frame", row.names = c(NA,
-4L))

Any ideas?
-L

2009/9/8 Duncan Murdoch <murdoch at stats.uwo.ca>:
> On 9/8/2009 7:53 AM, Lauri Nikkinen wrote:
>>
>> I have a text file similar to this (separated by spaces):
>>
>> x <- "DF12 This is an example 1 This
>> DF12 This is an 1232 This is
>> DF14 This is 12334 This is an
>> DF15 This 23 This is an example
>> "
>>
>> and I know the field lengths of each variable (there is 5 variables in
>> this data set), which are:
>>
>> varlength <- c(2, 2, 18, 5, 18)
>>
>> How can I import this kind of data into R, using the varlength
>> variable as an field separator indicator?
>
> See ?read.fwf.
>
> Duncan Murdoch
>




More information about the R-help mailing list