I'm working on a function within the quantmod package where I want to figure out how to replace the NAs with a zero, such that I don't remove the entire row if I were to use the na.omit function, because I don't want to lose the other values contained in the columns where there isn't an NA. I want the structure to remain.
I have an xts object that contains 6 columns.
1st column (row.names) that contain monthly dates from 2005-01-01 through 2010-01-01.
2nd column has Stock1 that contains stock prices and NA's
3rd column has Stock2 that contains stock prices and Na's
4th column has Stock3 that contains stock prices and Na's
5th column has Stock4 that contains stock prices and Na's
6th column has Stock5 that contains stock prices and Na's
When I execute:
cat("Found", sum(is.na(MY_OBJECT)), "Na's")
NEW_OBJECT <- na.omit(MY_OBJECT) #Returns the new object where the entire row is deleted
Appreciate the feedback.
New code to replace the NA's with zero's without object structure being changed.
NEW_OBJECT <- na.fill(MY_OBJECT, fill = 0.00))