Sounds to me like foreach (and perhaps map) and hashes will help you:

my @array_of_objects = (
    { sex=>'Male', occupation=>'foo' },
    { sex=>'Female', occupation=>'foo' },
    { sex=>'Male', occupation=>'bar' },
    { sex=>'Female', occupation=>'bar' },
    { sex=>'Female', occupation=>'foo' },
);

my %counts;
$counts{ $_->{sex} }++ for @array_of_objects;

my %grouped;
$grouped{ $_->{sex} }{ $_->{occupation} }++ for @array_of_objects;

use Data::Dumper;
print Dumper( \%counts, \%grouped );

__END__

$VAR1 = { 'Female' => 3, 'Male' => 2 };
$VAR2 = { 'Female' => { 'bar' => 1, 'foo' => 2 },
          'Male' => { 'foo' => 1, 'bar' => 1 } };

[download]

Update: Personally, I'd prefer the above, but if you really want a generic function, here's one option. Probably not the most efficient solution because it's recursive, I don't think the morning caffeine has fully kicked in yet ;-) Input and output is the same as above. (Update: huck's solution, posted before the below, is the non-recursive variation of this.)

sub count {
    my ($data, $fields) = @_;
    $fields = [$fields] unless ref $fields;
    my $count = {};
    _dive( $count, $_, @$fields ) for @$data;
    return $count;
}
sub _dive {
    my ($ref, $obj, @path) = @_;
    my $targ = \$ref->{ $obj->{ shift @path } };
    if (!@path) { $$targ++; return $ref }
    $$targ = _dive( $$targ, $obj, @path );
}

print Dumper( count(\@array_of_objects, 'sex') );
print Dumper( count(\@array_of_objects,
    ['sex','occupation']) );

[download]

Update 2: In the above, I'm working with hash references instead of objects. If you want to use real objects and method calls, then in the first example, replace { $_->{sex} }{ $_->{occupation} } with { $_->sex }{ $_->occupation }, and in the second example, replace $obj->{ shift @path } with $obj->${\shift @path}.

In reply to Re: SQL like query over iterable in perl (updated x2) by haukex
in thread SQL like query over iterable in perl by pwagyi

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.