small datasets, it's ok for me. But I couldn't
figure it out.
Thanks
Bart
From: Gabor Grothendieck [EMAIL PROTECTED]
To: Bart Joosen [EMAIL PROTECTED]
CC: r-help@stat.math.ethz.ch
Subject: Re: [R] How to read in this data format?
Date: Thu, 1 Mar 2007 16:46:21 -0500
On 3/1/07, Bart Joosen
]
To: Bart Joosen [EMAIL PROTECTED]
CC: r-help@stat.math.ethz.ch
Subject: Re: [R] How to read in this data format?
Date: Thu, 1 Mar 2007 16:46:21 -0500
On 3/1/07, Bart Joosen [EMAIL PROTECTED] wrote:
Dear All,
thanks for the replies, Jim Holtman has given a solution which fits my
needs
Hi,
I recieved an ascii file, containing following information:
$$ Experiment Number:
$$ Associated Data:
FUNCTION 1
Scan1
Retention Time 0.017
399.8112184
399.87420
399.9372152
Scan2
Retention Time 0.021
399.8112181
399.8742
Well, not extremely elegant, but should work:
1) open your file in some ascii text editor, delete the rubbish at the
beginning up to line Scan 1, and replace all spaces in names - e.g. make
a mass replace of 'Retention Time' by let say 'RetentionTime'.
2) Use read.table(), matrix() and
You can't expect general-purpose tools like read.table in R to be able
to deal with highly specialized file format. Here's what I'd start. It
doesn't put data in the format you specified exactly, but I doubt you'll
need that. This might be sufficient for your purpose:
dat -
Read in the data using readLines, extract out
all desired lines (namely those containing only
numbers, dots and spaces or those with the
word Time) and remove Retention from all
lines so that all remaining lines have two
fields. Now that we have desired lines
and all lines have two fields read
153
Jim Holtman
What is the problem you are trying to solve?
- Original Message
From: Gabor Grothendieck [EMAIL PROTECTED]
To: Bart Joosen [EMAIL PROTECTED]
Cc: r-help@stat.math.ethz.ch
Sent: Thursday, March 1, 2007 12:35:43 PM
Subject: Re: [R] How to read in this data format
[EMAIL PROTECTED]
Cc: r-help@stat.math.ethz.ch
Sent: Thursday, March 01, 2007 6:35 PM
Subject: Re: [R] How to read in this data format?
Read in the data using readLines, extract out
all desired lines (namely those containing only
numbers, dots and spaces or those with the
word Time
Sent: Thursday, March 01, 2007 6:35 PM
Subject: Re: [R] How to read in this data format?
Read in the data using readLines, extract out
all desired lines (namely those containing only
numbers, dots and spaces or those with the
word Time) and remove Retention from all
lines so that all
Gabor,
thanks for the clarification, now I understand the expression.
Thanks to everyone
Bart
From: Gabor Grothendieck [EMAIL PROTECTED]
To: Bart Joosen [EMAIL PROTECTED]
CC: r-help@stat.math.ethz.ch
Subject: Re: [R] How to read in this data format?
Date: Thu, 1 Mar 2007 16:46:21 -0500
On 3
10 matches
Mail list logo