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

    [download]
[reply]
[d/l]
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?

[reply]
[d/l]

In Section Seekers of Perl Wisdom