It is often necessary to replace values in a column in data.frame, for example NAs with 0s.

The following code will replace NA values with 0, in variable x:

x[ is.na(x) ] <- 0

Similarly, one can deal with inf values:

x[ is.infinite(x) ] <- 0

This page provided the original spark.

Make sure that replacing inf with zero does not bias your analysis.

To selectively change unwanted values from data:

newdata<-olddata
newdata[newdata<0.25]<-NA # example, make small values in the oldata column NA

Tag Data