Replace values in a data frame
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