Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

comment on

( [id://3333]=superdoc: print w/replies, xml ) Need Help??
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":



  • Are you posting in the right place? Check out Where do I post X? to know for sure.
  • Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
    <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
  • Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
  • Want more info? How to link or How to display code and escape characters are good places to start.
Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others contemplating the Monastery: (5)
As of 2024-03-28 07:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found