Here our task is to help a client to choose between the first and the second house (from the table above). We need to compare the index scores (which are provided by two different companies). The first house has index_1 of NaN , the second house has index_1 of 38.05 where as first house has index_2 of -0.41111, second house has index_2 of NaN. Under such a scenario how can we make a comparison and conclude one house is better than other, since NaN makes no sense here?
As per my understanding one company has not rated house one (as per index_1) while the other company has not rated house two (as per index_2). That means one house each has not been rated by both the companies. So how can we make a comparison in such a case?