preparing data for entropy analysis