Hello Monks! I'm facing a conundrum that I cannot even begin to solve using my limited Perl knowledge.

I have multiple (~50) square correlation matrices that are very large (on the order of 1700 x 1700). A small portion of one might look like: 

       
             rs12272511 rs7107801 rs11027752 rs12421837
rs12272511 1.0 -0.023 -0.511 -0.046
rs7107801 -0.023 1.0 0.040 0.233
rs11027752 0.494 0.514 1.0 0.501
rs12421837 -0.039 -0.040 0.021 1.0

[download]
The matrices are overlapping for about 95% of the ~1700 row/column IDs. For those IDs that are missing in a matrix, I would like to print "0" placeholders. For example, given another matrix: 

             rs12272511 rs11027752 rs12421837
rs12272511  1.0 .844 .276
rs11027752  .267 1.0 -.980
rs12421837 -.876 .374 1.0

[download]
As this second matrix is missing the ID "rs7107801", I would like to add this ID in with a value of "0": 

             rs12272511 rs7107801 rs11027752 rs12421837
rs12272511 1.0 0 .844 .276
rs7107801    0 0 0 0
rs11027752 .267 0 1.0 -.980
rs12421837 -.876 0 .374 1.0

[download]
I will then hopefully be able to use the matrices with placeholders (all matrices will now have equal dimensions) in order to calculate weighted averages. The matrices are all space-delimited. Can someone point me in the right direction?

In reply to combining multiple matrices with placeholders if row and column values in one matrix do not exist in another by mulder4786

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.