I'm working with a real estate data set. Several thousand rows are missing bathroom data. I'd like to write a formula for a new column that creates bathroom data based on the average bathroom by bedrooms data in the rest of the data set.
For example, if baths is missing then beds /= 9 is 5.
Or, is there a better way to estimate the bathroom data for the missing values?
