my $categorized_data = {
     Male   => map { id => $_->{id}, name => $_->{name} }
               grep { $_->{sex} eq 'Male' } @data,
     Female => map { id => $_->{id}, name => $_->{name} }
               grep { $_->{sex} eq 'Female' } @data,
};