The mechanics of replacing missing values are very easy in R > tmp <- data.frame(a=1:4,b=c(5,6,NA,8)) > tmp a b 1 1 5 2 2 6 3 3 NA 4 4 8 > tmp[is.na(tmp)] <- 0 > tmp a b 1 1 5 2 2 6 3 3 0 4 4 8 >
But pay attention to Bert's warning. This is most likely the wrong statistical way to respond to the missing values. Rich On Sun, Jul 28, 2013 at 9:19 AM, Neotropical bat risk assessments < neotropical.b...@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. > > > > -- > Bruce W. Miller, PhD. > Neotropical bat risk assessments > > If we lose the bats, we may lose much of the tropical vegetation and the > lungs of the planet > > Using acoustic sampling to map species distributions for >15 years. > > Providing Interactive identification keys to the vocal signatures of New > World Bats > > For various project details see: > > https://sites.google.com/site/batsoundservices/ > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@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. > [[alternative HTML version deleted]] ______________________________________________ R-help@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.
