cleans and transforms raw data to tiny data set