data cleansing second aggregation