clean up data and predict missing data