Re: [R] read.table

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Thu 14 Jul 2005 - 07:26:43 EST

Try reading it into and transposing the matrix afterwards. Don't know if that would work but its worth a try. Actually if you are having problems read it into a vector, check that its of the required size, just in case, and then turn it into a matrix and transpose it.

On 7/13/05, Weiwei Shi <helprhelp@gmail.com> wrote:
> there is another problem since last time i forgot "byrow" :(
> > trn<-matrix(scan('train1.dat', sep='|', na.string='.'), nrow=273529, ncol=195, byrow=T)
> Read 53338155 items
> Error: cannot allocate vector of size 416704 Kb
>
> please help with this 'simple' reading task.
>
> weiwei
>
> On 7/13/05, Weiwei Shi <helprhelp@gmail.com> wrote:
> > that sort of works for my purpose.
> >
> > btw, is there a bettter way to get data.frame by passing around
> > matrix(). Since I could not find data.frame() with nrow or ncol
> > arguments. so i have to use matrix first and then as.data.frame to
> > convert it.
> >
> > is there any other (better) way?
> >
> > weiwei
> >
> > On 7/13/05, Gabor Grothendieck <ggrothendieck@gmail.com> wrote:
> > >
> > > You could use the nlines= argument to scan to read in a
> > > portion at a time.
> > >
> > >
> > >
> > > On 7/13/05, Weiwei Shi <helprhelp@gmail.com> wrote:
> > > >
> > > > add:
> > > > I used
> > > > trn<-matrix(scan('train1.dat', sep='|', na.string='.'), nrow=273529,
> > > ncol=195)
> > > >
> > > > it is done.
> > > > so it seems that I just have no patience to wait for half an hour :)
> > > >
> > > > but i still have that question:
> > > > is there a way to track the process if it takes too long. Could we
> > > > stop in the middle to see at which line it "hesitates" to move on?
> > > >
> > > > regards,
> > > >
> > > > weiwei
> > > >
> > > >
> > > > On 7/13/05, Weiwei Shi <helprhelp@gmail.com> wrote:
> > > > > Hi,
> > > > > I have a question on read.table.
> > > > >
> > > > > I have a dataset with 273,000 lines and 195 columns. I used the
> > > > > read.table to load the data into R:
> > > > > trn<-read.table('train1.dat', header=F, sep='|', na.strings='.')
> > > > > I found it takes forever.
> > > > >
> > > > > then I run 1/10 of the data (test) using read.table again. And this
> > > > > time it finished quickly. So, there might be something wrong in my
> > > > > data format causing that problem.
> > > > >
> > > > > then, my question is, is there a way in R to track at which line,
> > > > > something wrong occurs?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Weiwei
> > > > >
> > > > >
> > > > > --
> > > > > Weiwei Shi, Ph.D
> > > > >
> > > > > "Did you always know?"
> > > > > "No, I did not. But I believed..."
> > > > > ---Matrix III
> > > > >
> > > >
> > > >
> > > > --
> > > > Weiwei Shi, Ph.D
> > > >
> > > > "Did you always know?"
> > > > "No, I did not. But I believed..."
> > > > ---Matrix III
> > > >
> > > > ______________________________________________
> > > > R-help@stat.math.ethz.ch mailing list
> > > > https://stat.ethz.ch/mailman/listinfo/r-help
> > > > PLEASE do read the posting guide!
> > > http://www.R-project.org/posting-guide.html
> > > >
> > >
> > >
> >
> >
> > --
> > Weiwei Shi, Ph.D
> >
> > "Did you always know?"
> > "No, I did not. But I believed..."
> > ---Matrix III
> >
>
>
> --
> Weiwei Shi, Ph.D
>
> "Did you always know?"
> "No, I did not. But I believed..."
> ---Matrix III
>



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Thu Jul 14 07:43:03 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:33:38 EST