[R] How to replace NA values

[William Revelle]

Bruce,
  use the is.na function, e.g.,


Bats.cast[is.na(Bats.cast)] <- 0

Bill
On Jul 28, 2013, at 8:12 AM, Bruce Miller <batsncats at gmail.com> wrote:

> Hi all,
> 
> I am using reshape2 to reformat a data frame and all is great using:
> 
> Bats.melt <- melt(data = Bats)
> 
> Bats.cast <- dcast(data = Bats.melt, formula = Species ~ Location)
> 
> dput(Bats.cast,'C:/=Bat data working/Nica_new/Bats_niche.robj')
> 
> write.csv(Bat.cast,'C:/=Bat data working/Nica_new/test_Niche.csv')
> 
> 
> The resulting file from both dput and write are great, however in order 
> to run another R analysis I need to replace all the NA values in the 
> output with a zero - 0 value.
> 
> I have just been opening this in Excel and using a simple find NA 
> replace with 0 and saving then reopening in R.
> 
> There must be a simple way to do this in R.
> 
> Any suggestions welcomed.
> 
> 
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> 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.
> 

William Revelle		           http://personality-project.org/revelle.html
Professor			           http://personality-project.org
Department of Psychology   http://www.wcas.northwestern.edu/psych/
Northwestern University	   http://www.northwestern.edu/
Use R for psychology             http://personality-project.org/r
It is 5 minutes to midnight	   http://www.thebulletin.org