R help - May 2010 - How to replace all <NA> values in a data.frame with another ( not 0) value

I need to replace <NA> occurrences in multiple columns  in a data.frame 
with "000/000"

how do I achieve this?

Thanks

Nevil Amos

Try: "x[which(is.na(x)),] <- 000/000", where is  x is your data
frame

-----
Lanna Jin

lannajin at gmail.com
510-898-8525
-- 
View this message in context:
http://r.789695.n4.nabble.com/How-to-replace-all-NA-values-in-a-data-frame-with-another-not-0-value-tp2125458p2125464.html
Sent from the R help mailing list archive at Nabble.com.

Whoops, my bad.  Maybe try using "gsub"

-----
Lanna Jin

lannajin at gmail.com
510-898-8525
-- 
View this message in context:
http://r.789695.n4.nabble.com/How-to-replace-all-NA-values-in-a-data-frame-with-another-not-0-value-tp2125458p2125471.html
Sent from the R help mailing list archive at Nabble.com.

Hi Nevil,

You can try a method like this

x <- c(rnorm(5),rep(NA,3),rnorm(5)) # sample data
dat <- data.frame(x,x)                       # make sample dataframe
dat2 <- as.matrix(dat)                     # conver to matrix
y <- which(is.na(dat)==TRUE)         # get index of NA values
dat2[y] <- "000/000"                         # replace all na
values
with "000/000"

Muhammad






Nevil Amos wrote:
> I need to replace <NA> occurrences in multiple columns  in a
data.frame
> with "000/000"
>
> how do I achieve this?
>
> Thanks
>
> Nevil Amos
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

?replace


Something like this should work

replace(df1, is.na(df1), "000/000")

--- On Tue, 5/4/10, Nevil Amos <nevil.amos at gmail.com> wrote:
> From: Nevil Amos <nevil.amos at gmail.com>
> Subject: [R] How to replace all <NA> values in a data.frame with
another ( not 0) value
> To: r-help at stat.math.ethz.ch
> Received: Tuesday, May 4, 2010, 8:54 AM
> I need to replace <NA>
> occurrences in multiple columns? in a data.frame with
> "000/000"
> 
> how do I achieve this?
> 
> Thanks
> 
> Nevil Amos
> 
> ______________________________________________
> R-help at r-project.org
> mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained,
> reproducible code.
>

000/000 returns NaN, which is no different than NA unless you want it as 
string i.e. "000/000"

Muhammad





Lanna Jin wrote:
> Try: "x[which(is.na(x)),] <- 000/000", where is  x is your
data frame
>
> -----
> Lanna Jin
>
> lannajin at gmail.com
> 510-898-8525
>

try x[is.na(x)] <- "000/000"

Bart
-- 
View this message in context:
http://r.789695.n4.nabble.com/How-to-replace-all-NA-values-in-a-data-frame-with-another-not-0-value-tp2125458p2125509.html
Sent from the R help mailing list archive at Nabble.com.

Hi

r-help-bounces at r-project.org napsal dne 04.05.2010 14:54:14:
> I need to replace <NA> occurrences in multiple columns  in a
data.frame
> with "000/000"
Be careful if you replace NA in numeric columns. 
> str(test)
'data.frame':   10 obs. of  3 variables:
 $ mp: num  20.9 19.9 20.1 20.2 18.9 ...
 $ so: num  18.8 18.6 18.2 17.9 18.1 ...
 $ le: num  48 49.1 48.8 42.6 46.1 ...
> test[2,2] <- NA
> test[is.na(test)] <- "000/000"
> str(test)
'data.frame':   10 obs. of  3 variables:
 $ mp: num  20.9 19.9 20.1 20.2 18.9 ...
 $ so: chr  "18.75" "000/000" "18.25"
"17.89" ...
 $ le: num  48 49.1 48.8 42.6 46.1 ...
> 
numeric column is now character and you can not use it for further 
analysis without some fiddling around.

Regards
Petr


> 
> how do I achieve this?
> 
> Thanks
> 
> Nevil Amos
> 
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide 
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.