Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re^3: DBD::CSV::st execute failed:

by erix (Prior)
on May 28, 2016 at 10:52 UTC ( [id://1164382]=note: print w/replies, xml ) Need Help??


in reply to Re^2: DBD::CSV::st execute failed:
in thread DBD::CSV::st execute failed:

It might be handy to post a part of the file, perhaps a head -n 20 (that is to say, the first 20 lines) so that experimentation is easier.

(and the actual filename)

Replies are listed 'Best First'.
Re^4: DBD::CSV::st execute failed:
by Sandy_Bio_Perl (Beadle) on May 28, 2016 at 11:48 UTC

    Hello again erix, here are the first 4 colums (sid, genotype, gender and tgroup, together with the first 19 rows of data. Thanks for helping me.

    sid genotype gender tgroup 1 c female 3 2 b male 3 3 c male 3 4 b male 1 5 c female 3 6 b male 1 7 a female 2 8 a male 3 9 d male 1 10 a female 2 11 d male 2 12 d female 2 13 d male 2 14 d female 1 15 d female 4 16 d female 2 17 d male 3 18 c male 1 19 a male 1
Re^4: DBD::CSV::st execute failed:
by Sandy_Bio_Perl (Beadle) on May 28, 2016 at 11:32 UTC

    Thank you erix. The headings of my spreadsheet, which is called newCsv.csv (that is the correct case sensitivity) are

    Headings of spreadsheet are: sid name genotype gender tgroup dnabl dnatw2 dnatw4 dnatw8 dnatw12 dnatw16 dnatw24 dnatw48 dnatw8-bl eagabscr eagabbl eagabtw12 eagabtw24 eagabtw48 altscr altbl alttw2 alttw4 alttw8 alttw12 alttw16 alttw24 alttw48 coretcellbl coretcelltw4 coretcelltw8 coretcelltw12 coretcelltw16 coretcelltw24 coretcelltw48 surfacetcellbl surfacetcelltw4 surfacetcelltw8 surfacetcelltw12 surfacetcelltw16 surfacetcelltw24 surfacetcelltw48 hla_a_1 hla_a_2 hla_b_1 hla_b_2 drb1*_1 drb1*_2 drb3*_1 drb3*_2 drb4*_1 drb4*_2 drb5*_1 drb5*_2 x_1 x_2

    Is that what you wanted?

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others chilling in the Monastery: (4)
As of 2024-03-29 14:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found