Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: Consolidating biological data into occurance of each biological unit per sample in table

by CountZero (Bishop)
on Jan 13, 2013 at 09:39 UTC ( #1013094=note: print w/ replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    use Modern::Perl;
    
    ...
    occurence4    A    a__bear;c__
    occurence5    C    a__wolf;c__grey
    occurence6    C    a__bear;c__brown
    
  2. or download this
    occurence1 (A) is a bear colored black
    occurence2 (B) is a wolf colored grey
    occurence3 (A) is a wolf colored white
    occurence4 (A) is a bear colored 
    occurence5 (C) is a wolf colored grey
    occurence6 (C) is a bear colored brown
    
  3. or download this
    use Modern::Perl;
    use DBI;
    
    ...
        $sth->execute( $id, $sample_id, $animal, $color );
    }
    $dbh->commit;
    
  4. or download this
    SELECT sampleid, animal, count(*) FROM sightings GROUP BY sampleid, an
    +imal
    
  5. or download this
    "A","bear","6"
    "A","wolf","4"
    "B","bear","2"
    "B","wolf","7"
    "C","bear","6"
    "C","wolf","5"
    
  6. or download this
    SELECT sampleid, color, count(*) FROM sightings GROUP BY sampleid, col
    +or
    
  7. or download this
    "A","black","1"
    "A","brown","3"
    "A","grey","1"
    ...
    "C","grey","3"
    "C","unknown","2"
    "C","white","1"
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1013094]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (16)
As of 2014-09-17 16:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (90 votes), past polls