Need to Use Random Forest Classifier to Replace MIssing Value in Spreadsheets
Hi everyone = i have been using =MODE() etc to impute missing values in column arrays. Sick of this. Seems unsophisticated, and not much fun, either. A more high level ML guy told me that he uses the Random Forest Classifier to rid himself of all the empty cells (which for me are all just in the form of tons of zeros).
2 QUESTIONS: First, what settings do I use to have the classifier leave the existing data undisturbed data undisturbed with the exception of the the zeros (which I want it to replace in some mysterious fashion far more inteligently than I can understand), and second