Hello monks!
I have an array like the following:
ID	ORGANISM	NUMBER
protein1	organism1	0.843534
protein2	organism2	2.45
protein3	organism3	9.5322
protein4	organism4	0.3475474
protein1	organism6	9.4534
protein2	organism7	0.43534
protein2	organism8	1.2434
protein3	organism9	0.000003
protein3	orgnanism10	1.23325
The elements in the array are split with tabs. What I want to do is make a unique array that will hold only protein1, protein2, protein3 and protein4 and, if a protein is found more than once, I will hold the one that has the smallest number.
The desired output is, for the above example:
protein1	organism1	0.843534
protein2	organism7	0.43534
protein3	organism9	0.000003
protein4	organism4	0.3475474
I tried searching the manual, but I have the problem of how to check the numbers and compare them in order to decide which number to keep for each protein...
Thank you for any help!

In reply to create unique array by Anonymous Monk

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.