Jan-20-2019, 07:24 AM
I don't want to replace empty with '0's or remove them. But, I want to replace the empty cell with mean of the above rows.
1.25 in row3 is becasue: The row3 in column1 in original data is an empty cell, and I replace with the mean of row1& row2(of column1)i.e, meanof 1 & 1.5 is 1.25.
About 2.80: is: Because in original data, the row7 is empty, and it is replace with mean of row4,row5,row6
I did not take the average of row1~row6, because row3 was empty in original data, I omit row1~row3.
Row10 was empty in original data, and it is replace with the average of row8 &row9 (brcasue row7 was empty in original data, adn removed all rows up to row7.
1.25 in row3 is becasue: The row3 in column1 in original data is an empty cell, and I replace with the mean of row1& row2(of column1)i.e, meanof 1 & 1.5 is 1.25.
About 2.80: is: Because in original data, the row7 is empty, and it is replace with mean of row4,row5,row6
I did not take the average of row1~row6, because row3 was empty in original data, I omit row1~row3.
Row10 was empty in original data, and it is replace with the average of row8 &row9 (brcasue row7 was empty in original data, adn removed all rows up to row7.