[Thread Prev][Thread Next][Index]

Re: data problem



Toni,
Just a guess, but it appears that Ferret is setting the precision for the output of the "wrong" columns based on the large numbers at the end. To test this I would delete the last two lines of the data file and try reading it again. If everything looks ok, you may have to set the precision manually for the output. Lynn

On Friday, June 18, 2004, at 10:51 AM, Toni Mira wrote:

Hi Ferreters,

I am having an strange problem with a ASCII file.
It contains 8 columns, but when I run:

yes? file/form=free/skip=2/var=a,b,c,d,e,f,g,h data.dat
yes? list a,b,c,d,e,f,g,h

I get:

DATA SET: ./data.dat
X: 0.5 to 54.5
Column 1: A
Column 2: B
Column 3: C
Column 4: D
Column 5: E
Column 6: F
Column 7: G
Column 8: H
A B C D E F G H
1 / 1: 6.2 0.822 0.738 3.8 0. 0. 1.330E+00 1.481E+00
2 / 2: 12.5 1.157 1.002 6.2 0. 0. 1.543E+00 1.784E+00
3 / 3: 18.8 1.392 1.173 8.8 0. 0. 1.761E+00 2.089E+00
4 / 4: 25.0 1.561 1.291 11.2 0. 0. 1.977E+00 2.391E+00
5 / 5: 31.2 1.681 1.369 13.8 0. 0. 2.197E+00 2.698E+00
6 / 6: 37.5 1.765 1.420 16.2 0. 0. 2.422E+00 3.010E+00
7 / 7: 43.8 1.819 1.449 18.8 0. 0. 2.653E+00 3.331E+00
8 / 8: 50.0 1.850 1.462 21.2 0. 0. 2.892E+00 3.661E+00
9 / 9: 56.2 1.863 1.461 23.8 0. 0. 3.139E+00 4.003E+00
10 / 10: 62.5 1.860 1.450 26.2 0. 0. 3.396E+00 4.358E+00
11 / 11: 68.8 1.845 1.430 28.8 0. 0. 3.663E+00 4.728E+00
12 / 12: 75.0 1.819 1.402 31.2 0. 0. 3.943E+00 5.115E+00
13 / 13: 81.2 1.784 1.369 33.8 0. 0. 4.237E+00 5.521E+00
14 / 14: 87.5 1.742 1.331 36.2 0. 0. 4.546E+00 5.948E+00
15 / 15: 93.8 1.694 1.289 38.8 0. 0. 4.872E+00 6.399E+00
16 / 16: 100.0 1.640 1.244 41.2 0. 0. 5.217E+00 6.876E+00
17 / 17: 106.2 1.582 1.197 43.8 0. 0. 5.580E+00 7.377E+00
18 / 18: 112.5 1.523 1.148 46.2 0. 0. 5.961E+00 7.905E+00
19 / 19: 118.8 1.457 1.096 48.8 0. 0. 6.380E+00 8.483E+00
20 / 20: 125.0 1.389 1.042 51.2 0. 0. 6.828E+00 9.103E+00
21 / 21: 131.2 1.320 0.988 53.8 0. 0. 7.311E+00 9.770E+00
22 / 22: 137.5 1.249 0.933 56.2 0. 0. 7.832E+00 1.049E+01
23 / 23: 143.8 1.177 0.877 58.8 0. 0. 8.396E+00 1.127E+01
24 / 24: 150.0 1.105 0.822 61.2 0. 0. 9.011E+00 1.212E+01
25 / 25: 156.2 1.033 0.767 63.8 0. 0. 9.683E+00 1.305E+01
26 / 26: 162.5 0.961 0.712 66.2 0. 0. 1.042E+01 1.407E+01
27 / 27: 168.8 0.890 0.658 68.8 0. 0. 1.123E+01 1.519E+01
28 / 28: 175.0 0.820 0.605 71.2 0. 0. 1.214E+01 1.644E+01
29 / 29: 181.2 0.751 0.554 73.8 0. 0. 1.315E+01 1.783E+01
30 / 30: 187.5 0.684 0.504 76.2 0. 1. 1.427E+01 1.938E+01
31 / 31: 193.8 0.618 0.454 78.8 0. 1. 1.557E+01 2.118E+01
32 / 32: 200.0 0.555 0.407 81.2 0. 1. 1.700E+01 2.317E+01
33 / 33: 206.2 0.494 0.362 83.8 0. 1. 1.867E+01 2.547E+01
34 / 34: 212.5 0.436 0.319 86.2 0. 1. 2.058E+01 2.812E+01
35 / 35: 218.8 0.381 0.279 88.8 0. 1. 2.281E+01 3.120E+01
36 / 36: 225.0 0.330 0.241 91.2 0. 1. 2.542E+01 3.481E+01
37 / 37: 231.2 0.282 0.206 93.8 0. 1. 2.850E+01 3.906E+01
38 / 38: 237.5 0.238 0.173 96.2 0. 1. 3.216E+01 4.412E+01
39 / 39: 243.8 0.198 0.144 98.8 1. 1. 3.653E+01 5.018E+01
40 / 40: 250.0 0.163 0.118 101.2 1. 1. 4.179E+01 5.745E+01
41 / 41: 256.2 0.131 0.096 103.8 1. 1. 4.812E+01 6.620E+01
42 / 42: 262.5 0.105 0.076 106.2 1. 1. 5.569E+01 7.667E+01
43 / 43: 268.8 0.083 0.060 108.8 1. 1. 6.465E+01 8.907E+01
44 / 44: 275.0 0.065 0.047 111.2 1. 1. 7.505E+01 1.035E+02
45 / 45: 281.2 0.051 0.037 113.8 1. 1. 8.684E+01 1.197E+02
46 / 46: 287.5 0.040 0.029 116.2 1. 1. 9.994E+01 1.379E+02
47 / 47: 293.8 0.031 0.023 118.8 1. 1. 1.147E+02 1.582E+02
48 / 48: 300.0 0.024 0.018 121.2 1. 1. 1.322E+02 1.826E+02
49 / 49: 306.2 0.018 0.013 123.8 1. 1. 1.557E+02 2.150E+02
50 / 50: 312.5 0.012 0.009 126.2 1. 1. 1.928E+02 2.663E+02
51 / 51: 318.8 0.006 0.005 128.8 1. 1. 2.716E+02 3.753E+02
52 / 52: 325.0 0.000 0.000 131.2 3. 4. 9.087E+04 1.257E+05
53 / 53: 331.2 0.000 0.000 133.8 9363014. 7415051. 9.664E+29 1.337E+30
54 / 54: 337.5 0.000 0.000 136.2 9999949. 9999949. 1.366E+30 1.889E+30

Why Ferret can not read correctly some columns?
I am attaching the data file.

Thanks in advance.

Toni


COMPANY
NAME
0.6250000E+01 0.8223196E+00 0.7384809E+00 0.3750000E+01 0.5355120E-01 0.5963226E-01 0.1329954E+01 0.1480975E+01
0.1250000E+02 0.1157465E+01 0.1001507E+01 0.6250000E+01 0.7924550E-01 0.9159790E-01 0.1543323E+01 0.1783721E+01
0.1875000E+02 0.1391786E+01 0.1173044E+01 0.8750000E+01 0.1002382E+00 0.1189551E+00 0.1760637E+01 0.2089022E+01
0.2500000E+02 0.1560950E+01 0.1290576E+01 0.1125000E+02 0.1183411E+00 0.1431756E+00 0.1977159E+01 0.2391456E+01
0.3125000E+02 0.1681243E+01 0.1369369E+01 0.1375000E+02 0.1342778E+00 0.1649224E+00 0.2197191E+01 0.2697701E+01
0.3750000E+02 0.1764514E+01 0.1419915E+01 0.1625000E+02 0.1485968E+00 0.1847450E+00 0.2422143E+01 0.3010082E+01
0.4375000E+02 0.1818907E+01 0.1449078E+01 0.1875000E+02 0.1616703E+00 0.2030417E+00 0.2653274E+01 0.3330555E+01
0.5000000E+02 0.1850279E+01 0.1461601E+01 0.2125000E+02 0.1737638E+00 0.2201094E+00 0.2891768E+01 0.3660895E+01
0.5625000E+02 0.1862991E+01 0.1460911E+01 0.2375000E+02 0.1850735E+00 0.2361765E+00 0.3138784E+01 0.4002794E+01
0.6250000E+02 0.1860385E+01 0.1449571E+01 0.2625000E+02 0.1957489E+00 0.2514218E+00 0.3395507E+01 0.4357949E+01
0.6875000E+02 0.1845080E+01 0.1429546E+01 0.2875000E+02 0.2059080E+00 0.2659899E+00 0.3663172E+01 0.4728112E+01
0.7500000E+02 0.1819179E+01 0.1402388E+01 0.3125000E+02 0.2156452E+00 0.2799990E+00 0.3943106E+01 0.5115151E+01
0.8125000E+02 0.1784390E+01 0.1369339E+01 0.3375000E+02 0.2250385E+00 0.2935482E+00 0.4236751E+01 0.5521077E+01
0.8750000E+02 0.1742132E+01 0.1331416E+01 0.3625000E+02 0.2341533E+00 0.3067224E+00 0.4545690E+01 0.5948101E+01
0.9375000E+02 0.1693588E+01 0.1289461E+01 0.3875000E+02 0.2430458E+00 0.3195950E+00 0.4871696E+01 0.6398680E+01
0.1000000E+03 0.1639775E+01 0.1244187E+01 0.4125000E+02 0.2517651E+00 0.3322315E+00 0.5216751E+01 0.6875564E+01
0.1062500E+03 0.1582500E+01 0.1196940E+01 0.4375000E+02 0.2605081E+00 0.3448820E+00 0.5579732E+01 0.7377218E+01
0.1125000E+03 0.1522732E+01 0.1148405E+01 0.4625000E+02 0.2693965E+00 0.3577141E+00 0.5961329E+01 0.7904599E+01
0.1187500E+03 0.1457196E+01 0.1095937E+01 0.4875000E+02 0.2777576E+00 0.3698694E+00 0.6379871E+01 0.8483042E+01
0.1250000E+03 0.1389396E+01 0.1042245E+01 0.5125000E+02 0.2861110E+00 0.3820106E+00 0.6828463E+01 0.9103028E+01
0.1312500E+03 0.1319858E+01 0.9876839E+00 0.5375000E+02 0.2944919E+00 0.3941864E+00 0.7310963E+01 0.9769887E+01
0.1375000E+03 0.1249055E+01 0.9325719E+00 0.5625000E+02 0.3029351E+00 0.4064451E+00 0.7831866E+01 0.1048985E+02
0.1437500E+03 0.1177420E+01 0.8772013E+00 0.5875000E+02 0.3114753E+00 0.4188361E+00 0.8396439E+01 0.1127021E+02
0.1500000E+03 0.1105356E+01 0.8218408E+00 0.6125000E+02 0.3201483E+00 0.4314076E+00 0.9010886E+01 0.1211953E+02
0.1562500E+03 0.1033236E+01 0.7667422E+00 0.6375000E+02 0.3289908E+00 0.4442126E+00 0.9682563E+01 0.1304800E+02
0.1625000E+03 0.9614153E+00 0.7121438E+00 0.6625000E+02 0.3380428E+00 0.4573056E+00 0.1042021E+02 0.1406769E+02
0.1687500E+03 0.8902324E+00 0.6582722E+00 0.6875000E+02 0.3473455E+00 0.4707454E+00 0.1123433E+02 0.1519313E+02
0.1750000E+03 0.8200131E+00 0.6053465E+00 0.7125000E+02 0.3569457E+00 0.4845962E+00 0.1213754E+02 0.1644177E+02
0.1812500E+03 0.7510735E+00 0.5535799E+00 0.7375000E+02 0.3668933E+00 0.4989281E+00 0.1314520E+02 0.1783488E+02
0.1875000E+03 0.6841902E+00 0.5035307E+00 0.7625000E+02 0.3775048E+00 0.5141682E+00 0.1426625E+02 0.1938482E+02
0.1937500E+03 0.6177454E+00 0.4539654E+00 0.7875000E+02 0.3877342E+00 0.5289173E+00 0.1556624E+02 0.2118221E+02
0.2000000E+03 0.5550160E+00 0.4073126E+00 0.8125000E+02 0.3994150E+00 0.5456370E+00 0.1700474E+02 0.2317121E+02
0.2062500E+03 0.4942542E+00 0.3622452E+00 0.8375000E+02 0.4113842E+00 0.5627709E+00 0.1866664E+02 0.2546914E+02
0.2125000E+03 0.4362799E+00 0.3193555E+00 0.8625000E+02 0.4240586E+00 0.5808829E+00 0.2058320E+02 0.2811927E+02
0.2187500E+03 0.3813834E+00 0.2788388E+00 0.8875000E+02 0.4375382E+00 0.6001103E+00 0.2281032E+02 0.3119895E+02
0.2250000E+03 0.3298492E+00 0.2408879E+00 0.9125000E+02 0.4519340E+00 0.6206071E+00 0.2541856E+02 0.3480577E+02
0.2312500E+03 0.2819519E+00 0.2056883E+00 0.9375000E+02 0.4673671E+00 0.6425388E+00 0.2849682E+02 0.3906266E+02
0.2375000E+03 0.2379504E+00 0.1734137E+00 0.9625000E+02 0.4839615E+00 0.6660763E+00 0.3215629E+02 0.4412342E+02
0.2437500E+03 0.1980795E+00 0.1442205E+00 0.9875000E+02 0.5018370E+00 0.6913828E+00 0.3653400E+02 0.5017765E+02
0.2500000E+03 0.1625365E+00 0.1182384E+00 0.1012500E+03 0.5210874E+00 0.7185850E+00 0.4179332E+02 0.5745116E+02
0.2562500E+03 0.1314621E+00 0.9555683E-01 0.1037500E+03 0.5417484E+00 0.7477276E+00 0.4811745E+02 0.6619756E+02
0.2625000E+03 0.1049135E+00 0.7620437E-01 0.1062500E+03 0.5637494E+00 0.7787061E+00 0.5568940E+02 0.7666980E+02
0.2687500E+03 0.8282709E-01 0.6012365E-01 0.1087500E+03 0.5868562E+00 0.8111894E+00 0.6465174E+02 0.8906526E+02
0.2750000E+03 0.6497481E-01 0.4713903E-01 0.1112500E+03 0.6106471E+00 0.8445882E+00 0.7505439E+02 0.1034529E+03
0.2812500E+03 0.5092422E-01 0.3692833E-01 0.1137500E+03 0.6346011E+00 0.8781772E+00 0.8683550E+02 0.1197473E+03
0.2875000E+03 0.4003026E-01 0.2901721E-01 0.1162500E+03 0.6583938E+00 0.9115121E+00 0.9993974E+02 0.1378718E+03
0.2937500E+03 0.3149210E-01 0.2282052E-01 0.1187500E+03 0.6823782E+00 0.9450963E+00 0.1146675E+03 0.1582420E+03
0.3000000E+03 0.2448202E-01 0.1773537E-01 0.1212500E+03 0.7080553E+00 0.9810326E+00 0.1322449E+03 0.1825536E+03
0.3062500E+03 0.1829080E-01 0.1324636E-01 0.1237500E+03 0.7385378E+00 0.1023661E+01 0.1557335E+03 0.2150412E+03
0.3125000E+03 0.1240703E-01 0.8982359E-02 0.1262500E+03 0.7801213E+00 0.1081749E+01 0.1928038E+03 0.2663144E+03
0.3187500E+03 0.6494300E-02 0.4699842E-02 0.1287500E+03 0.8513587E+00 0.1181128E+01 0.2716122E+03 0.3753174E+03
0.3250000E+03 0.5862745E-04 0.4239503E-04 0.1312500E+03 0.2554455E+01 0.3569998E+01 0.9087470E+05 0.1256941E+06
0.3312500E+03 0.8755313E-41 0.6331066E-41 0.1337500E+03 0.9363014E+07 0.7415051E+07 0.9664327E+30 0.1336729E+31
0.3375000E+03 0.0000000E+00 0.0000000E+00 0.1362500E+03 0.9999949E+07 0.9999949E+07 0.1365989E+31 0.1889376E+31

Lynn deWitt
Pacific Fisheries Environmental Lab
1352 Lighthouse Ave
Pacific Grove, CA 93907
(831)648-9036



[Thread Prev][Thread Next][Index]

Dept of Commerce / NOAA / OAR / PMEL / TMAP

Contact Us | Privacy Policy | Disclaimer | Accessibility Statement