Re: [R] Efficiency question: replacing all NAs with a zero

2010-03-29 Thread Dimitri Liakhovitski
Gabor, thanks a lot! I removed everything from the work space but the data frame - and then DF[is.na(DF)]<-0 has worked! Thanks a lot! Dimitri On Mon, Mar 29, 2010 at 8:45 PM, Gabor Grothendieck wrote: > Its going to be pretty hard to do anything useful if you can`t even do > simple operations li

Re: [R] Efficiency question: replacing all NAs with a zero

2010-03-29 Thread Gabor Grothendieck
Its going to be pretty hard to do anything useful if you can`t even do simple operations like that without overflowing memory but anyways try this (untested): write.table(DF, "DF.csv", sep = ",", quote = FALSE) rm(DF) DF <- read.csv(pipe("sed s/NA/0/g DF.csv")) On Mon, Mar 29, 2010 at 8:33 PM, D

Re: [R] Efficiency question: replacing all NAs with a zero

2010-03-29 Thread Dimitri Liakhovitski
To be specific, my data frame is 4000 by 2200. On Mon, Mar 29, 2010 at 8:33 PM, Dimitri Liakhovitski wrote: > Just tried it. It's definitely faster - but I get the same error: > " Reached total allocation of 1535Mb:" > > On Mon, Mar 29, 2010 at 8:27 PM, Gabor Grothendieck > wrote: >> See if this

Re: [R] Efficiency question: replacing all NAs with a zero

2010-03-29 Thread Dimitri Liakhovitski
Just tried it. It's definitely faster - but I get the same error: " Reached total allocation of 1535Mb:" On Mon, Mar 29, 2010 at 8:27 PM, Gabor Grothendieck wrote: > See if this works for you: > > DF[is.na(DF)] <- 0 > > On Mon, Mar 29, 2010 at 8:21 PM, Dimitri Liakhovitski > wrote: >> Dear R'er

Re: [R] Efficiency question: replacing all NAs with a zero

2010-03-29 Thread Gabor Grothendieck
See if this works for you: DF[is.na(DF)] <- 0 On Mon, Mar 29, 2010 at 8:21 PM, Dimitri Liakhovitski wrote: > Dear R'ers, > > I have a very large data frame (over 4000 rows and 2,500 columns). My > task is very simple - I have to replace all NAs with a zero. My code > works fine on smaller data f

[R] Efficiency question: replacing all NAs with a zero

2010-03-29 Thread Dimitri Liakhovitski
Dear R'ers, I have a very large data frame (over 4000 rows and 2,500 columns). My task is very simple - I have to replace all NAs with a zero. My code works fine on smaller data frames - but I have to deal with a huge one and there are many NAs in each column. R runs out of memory on me ("Reached