cleaned data to group by entity