R help - Nov 2000 - R help for a newby

Hello,

    I'm trying to read a file that has ascci data in it. The format of the
data
is in this order: test_number(integer) 4 double readings. Simple,ok, but for 
life of me I can't get R to put it into the internal format I need. What I
want
to do is to make an array called dat and dim it 10000 rows by 5 columns.
That seems simple enough, I start out by:

dat <- array(0,dim=c(10000,5)) this looks ok. 
The next thing I did was to scan in the data.
dat
<-scan("mydata-file",what=array(""),sep="\n").
I get the data into the dat array but its looks like a string.
ie "1000 34.5  34.7  35  35.6".
what I want is to make each of these data point go into 
the appropriate array index ie:
dat[1][1]   dat[1][2]  dat[1][3]   dat[1][4]   dat[1][5]
    1000     34.5        34.7         35           35.6

Any help would be greatly appreciated.

Thank you
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
https://stat.ethz.ch/pipermail/r-help/attachments/20001112/f981c178/attachment.html

tmed <tmed at pacbell.net> writes:
> Hello,
> 
>     I'm trying to read a file that has ascci data in it. The format of
> the data
> is in this order: test_number(integer) 4 double readings. Simple,ok, but
> for=20
> life of me I can't get R to put it into the internal format I need.
What > I want
> to do is to make an array called dat and dim it 10000 rows by 5 columns.
> That seems simple enough, I start out by:
> 
> dat <- array(0,dim=3Dc(10000,5)) this looks ok.=20
> The next thing I did was to scan in the data.
> dat
<-scan("mydata-file",what=3Darray(""),sep=3D"\n").
> I get the data into the dat array but its looks like a string.
> ie "1000 34.5  34.7  35  35.6".
> what I want is to make each of these data point go into=20
> the appropriate array index ie:
> dat[1][1]   dat[1][2]  dat[1][3]   dat[1][4]   dat[1][5]
>     1000     34.5        34.7         35           35.6
>
> Any help would be greatly appreciated.
matrix(scan("mydata-file"), ncol=5, byrow=TRUE)

or

do.call("cbind", scan("mydata-file", what=rep(0,5)))

or

as.matrix(read.table("mydata-file"))
 
should all work ("should" being code for "I didn't actually
try"). I'd
expect the middle one to be the most efficient, but who knows.

BTW: Accessing an element of a matrix is dat[1,1] in R, not dat[1][1]
as in C.
> ------=_NextPart_000_0005_01C04CA5.30664F20
> Content-Type: text/html;
> 	charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
Um, please try to avoid that stuff. It looks bad in some peoples
mailers, and I think it also messes with the list digests.

-- 
   O__  ---- Peter Dalgaard             Blegdamsvej 3  
  c/ /'_ --- Dept. of Biostatistics     2200 Cph. N   
 (*) \(*) -- University of Copenhagen   Denmark      Ph: (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk)             FAX: (+45) 35327907
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

Hello,

	Yesterday I asked a question about how to read data from a file
that had test numbers in the first column followed by 4 readings. I received
three responses to my question with in an hour. Thanks to all who responded.
After trying out your responses - which seem to work. I noticed that some of
the data had only one or two reading after the test number. 

	My next question: what's the command to fill a matrix with an unknown
value of column data. The nice people who responded to me yesterday used
matrix(scan("data.file"),rcol=5, byrow=TRUE). I would have to imagine
the
solution is some variation on this theme. I tried several last night
myself, but 
with no success.  I hope that you will bear with me though  this leaning curve.
I HAVE tried to read the documentation, but there is so much information that
it's some what overwhelming. I'm sure all of you  know how important it
is to be able to succeed in using a new tool to prevent being frustrated and 
giving up prematurely. I am truly in awe over this tool, its power is
amazing.  
I hope you will bear with me as I continue in the mastery of this incredible
tool.

	Thanks for all your help,

	Tom Likins
	



-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._