I think you have to separate heads and data of a table.

your current structure is problematic, because HoHs are unsorted and you can't distinguish what the row/column headers are

{ 
   columns  => { Male  => 0, Female  => 1 }, 
   rows     => { "0-9" => 0, "10-19" => 1, "20-29" => 2 },
   data     => [
                  [220, 175, 260],
                  [180, 142, 265]
               ]
}

[download]
(untested)

You need to look-up indices to get the data now.

This could be encapsulated in a tied hash or an object class.¹

"Age Group" makes it a bit more complicated, not sure what it is, how would you call it?

Maybe a "CATEGORY" field of the rows?

I hope you get the point and this helps. :)

Cheers Rolf
(addicted to the Perl Programming Language and ☆☆☆☆ :)

PS: Je suis Charlie!

PS: pretty sure someone will come up with a CPAN² module now... :)

update

¹) for instance you could bless the hash above into a class My::Table . Then $obj->rows returns a list of names, and $obj->entry("Male","0-9") returns the entry, and so on.

²) like Data::Table

In reply to Re: Building data structure from multi-row/column table by LanX
in thread Building data structure from multi-row/column table by rwx---

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.