Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
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 scrutinizing the Monastery: (7)
As of 2015-07-04 21:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (60 votes), past polls