[R] Import fixed-format ascii file with mixed record types
dwinsemius at comcast.net
Mon Feb 1 20:54:21 CET 2010
On Feb 1, 2010, at 2:33 PM, trece por ciento wrote:
> Thanks David, but can read.fwf cope with different record types?
I do not see any facility for that goal.
> For example, if recordtype is the 4th character, I could have:
> 011125678 ---> This is record Type 1
> 011136779 ---> This is record Type 1
> 011124943 ---> This is record Type 1
> 011286711 ---> This is record Type 2
> 011234872 ---> This is record Type 2
> 011135628 ---> This is record Type 1
> So, how can I tell read.fwf to take the correct type into account?
It would be easier on the readers of the list if you would offer a
more complete description of the problem. Problems which are unfolded
bit by bit are rather annoying to some. Is there a website or document
that describes this data resource? Perhaps an alternate strategy that
used a database interface would be more appropriate?
> Thanks again,
> --- On Mon, 2/1/10, David Winsemius <dwinsemius at comcast.net> wrote:
> From: David Winsemius <dwinsemius at comcast.net>
> Subject: Re: [R] Import fixed-format ascii file with mixed record
> To: "trece por ciento" <el13porciento at yahoo.com>
> Cc: r-help at r-project.org
> Date: Monday, February 1, 2010, 12:01 PM
> On Feb 1, 2010, at 11:40 AM, trece por ciento wrote:
>> I need to import several ascii files in fixed format with two
>> different record types. The data comes from European Labor Force
>> Surveys, wich is a household survey. The first record type is for
>> people over 16 years, and the second much sorter is for people aged
>> 15 or less (this record has a filler with several blanks to get the
>> same record length).
>> The files tipically have 160000 records, with 176 characters per
>> record, the data is numeric, corresponding to 102 variables, mostly
>> integers (seven variables have two decimals). My opertating system
>> is Windows XP.
>> My questions:
>> 1. Wich do you think is the best way to import the files into R?
>> 2. Could you give me any references or examples?
> There are examples in the help page.
>> Thanking you in advance,
>> [[alternative HTML version deleted]]
>> R-help at r-project.org mailing list
>> 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
David Winsemius, MD
West Hartford, CT
More information about the R-help