Re: dbi::CSV works with text, but not numbers

I completely agree with Marshall (++) on the beauty and performance of SQLite.

I also have another suggestion : Post a small sample of your csv file to this site, sufficient to demonstrate the problem. I'm sure our XP-hungry population will be glad to QA test and debug this for you.

This is not an optical illusion, it just looks like one.

Comment on Re: dbi::CSV works with text, but not numbers

Replies are listed 'Best First'.
Re^2: dbi::CSV works with text, but not numbers by Sandy_Bio_Perl (Beadle) on May 20, 2016 at 10:17 UTC
Thank you, NetWallah. Not sure how to upload my csv file, (it has many rows) but I pasted a few rows below. sid name genotype gender tGroup DNABl DNATw2 DNAT +w4 DNATw8 DNATw12 DNATw16 DNATw24 DNATw48 DNATw8-Bl + eAgAbScr eAgABBl eAgAbTw12 eAgAbTw24 eAgAbTw48 ALT +Scr ALTBl ALTTw2 ALTTw4 ALTTw8 ALTTw12 ALTTw16 A +LTTw24 ALTTw48 coreTcellBl coreTcellTw4 coreTcellTw8 c +oreTcellTw12 coreTcellTw16 coreTcellTw24 coreTcellTw48 su +rfaceTcellBl surfaceTcellTw4 surfaceTcellTw8 surfaceTcellTw1 +2 surfaceTcellTw16 surfaceTcellTw24 surfaceTcellTw48 HLA_ +A_1 HLA_A_2 HLA_B_1 HLA_B_2 HLA_DRB1_1 HLA_DRB1_2 H +LA_DRB3_1 HLA_DRB3_2 HLA_DRB4_1 HLA_DRB4_2 HLA_DRB5_1 +HLA_DRB5_2 HLA_X_1 HLA_X_2 1 AUC-001 C Female 3 7.8 3.85 3.47 2.83 2.1 +8 2.69 2.18 2.176 -4.97 + / - + / - + / - + / + - + / - 617 69 47 35 28 34 24 25 22 + 55 xx 130 36.66666667 5 23.33333333 0 50 xx + 201.6666667 0 0 0 0 0201/0207/0209/0215N/0218/0220 +/0224/0229/0230/0231/0233/0234/0242/0243N 0301/04 0702/05/0 +6/07/21/22/23/26/30/33 4001/14/22N/23/33/42/43/45 1101/04/12/ +15/24/27/28/29/32/33/35/37/38/39/43 1501/02/04/05/06/07/08/09/11/ +13 0201/02/03/06/10/11/12/14/15/17/18 0101/05/09/ +11/12/13 2 AUC-002 B Male 3 11.13 10.51 7.69 5.95 6. +74 5.66 5.38 5.152 -5.18 + / - + / - + / - + +/ - + / - 82 61 72 55 73 66 95 87 70 + 31.66666667 65 xx 3.333333333 5 0 65 78.3333333 +3 56.66666667 xx 0 0 0 25 0201/0204/0207/0209/0 +215N/0217/0218/0220/0224/0229/0230/0231/0232N/0233/0239/0242/0243N + 0203 4601/02 4001/4010/4022N 1401/26/32/38/39 +1405 3 AUC-003 C Male 3 9.03 7.7 7.51 5.67 4.74 + 4.3 3.34 2.176 -3.36 + / - + / - + / - + / - + + / - 87 102 83 102 107 89 57 47 26 +33.33333333 46.66666667 18.33333333 15 75 15 0 3 +3.33333333 40 30 0 0 0 5 3101/02/05 2402/2 +403/2409N/2411N/2415/2420/2421/2425/2426/2427 1538 4002/29 + 0801/03/14/16 1101/12/15/19/24/27/28/29/39 + 4 AUC-004 B Male 1 7.23 3.43 2.66 2.18 2.18 + 2.18 2.18 2.176 -5.05 - / + - / + - / + - / ++ - / + 71 335 241 200 66 51 46 31 28 + 107 157 18 xx 168 45 10 120 168 37 xx + 0 0 0 1101/02/03/05 1101/02/03 5502/07 1 +518 0801/03/14/16 1201/02/06 [download]	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: dbi::CSV works with text, but not numbers
by Sandy_Bio_Perl (Beadle) on May 20, 2016 at 10:17 UTC

Thank you, NetWallah. Not sure how to upload my csv file, (it has many rows) but I pasted a few rows below.

sid    name    genotype    gender    tGroup    DNABl    DNATw2    DNAT
+w4    DNATw8    DNATw12    DNATw16    DNATw24    DNATw48    DNATw8-Bl
+    eAgAbScr    eAgABBl    eAgAbTw12    eAgAbTw24    eAgAbTw48    ALT
+Scr    ALTBl    ALTTw2    ALTTw4    ALTTw8    ALTTw12    ALTTw16    A
+LTTw24    ALTTw48    coreTcellBl    coreTcellTw4    coreTcellTw8    c
+oreTcellTw12    coreTcellTw16    coreTcellTw24    coreTcellTw48    su
+rfaceTcellBl    surfaceTcellTw4    surfaceTcellTw8    surfaceTcellTw1
+2    surfaceTcellTw16    surfaceTcellTw24    surfaceTcellTw48    HLA_
+A_1    HLA_A_2    HLA_B_1    HLA_B_2    HLA_DRB1_1    HLA_DRB1_2    H
+LA_DRB3_1    HLA_DRB3_2    HLA_DRB4_1    HLA_DRB4_2    HLA_DRB5_1    
+HLA_DRB5_2    HLA_X_1    HLA_X_2
1    AUC-001    C    Female    3    7.8    3.85    3.47    2.83    2.1
+8    2.69    2.18    2.176    -4.97    + / -    + / -    + / -    + /
+ -    + / -    617    69    47    35    28    34    24    25    22   
+ 55    xx    130    36.66666667    5    23.33333333    0    50    xx 
+   201.6666667    0    0    0    0    *0201/0207/0209/0215N/0218/0220
+/0224/0229/0230/0231/0233/0234/0242/0243N     *0301/04     *0702/05/0
+6/07/21/22/23/26/30/33    *4001/14/22N/23/33/42/43/45    *1101/04/12/
+15/24/27/28/29/32/33/35/37/38/39/43    *1501/02/04/05/06/07/08/09/11/
+13    *0201/02/03/06/10/11/12/14/15/17/18                *0101/05/09/
+11/12/13            
2    AUC-002    B    Male    3    11.13    10.51    7.69    5.95    6.
+74    5.66    5.38    5.152    -5.18    + / -    + / -    + / -    + 
+/ -    + / -    82    61    72    55    73    66    95    87    70   
+ 31.66666667    65    xx    3.333333333    5    0    65    78.3333333
+3    56.66666667    xx    0    0    0    25    *0201/0204/0207/0209/0
+215N/0217/0218/0220/0224/0229/0230/0231/0232N/0233/0239/0242/0243N   
+  *0203     *4601/02     *4001/4010/4022N     *1401/26/32/38/39     *
+1405                                 
3    AUC-003    C    Male    3    9.03    7.7    7.51    5.67    4.74 
+   4.3    3.34    2.176    -3.36    + / -    + / -    + / -    + / - 
+   + / -    87    102    83    102    107    89    57    47    26    
+33.33333333    46.66666667    18.33333333    15    75    15    0    3
+3.33333333    40    30    0    0    0    5    *3101/02/05     *2402/2
+403/2409N/2411N/2415/2420/2421/2425/2426/2427     *1538     *4002/29 
+    *0801/03/14/16     *1101/12/15/19/24/27/28/29/39                 
+                
4    AUC-004    B    Male    1    7.23    3.43    2.66    2.18    2.18
+    2.18    2.18    2.176    -5.05    - / +    - / +    - / +    - / 
++    - / +    71    335    241    200    66    51    46    31    28  
+  107    157    18    xx    168    45    10    120    168    37    xx
+    0    0    0    *1101/02/03/05     *1101/02/03     *5502/07     *1
+518     *0801/03/14/16     *1201/02/06
[download]

[reply]
[d/l]