So, here is a `head' of my dataset. Note the `,,' in the 2nd last column.
02-FEB-2009,09:55:04:962,26022009,2500,PE,36,500,44,200,11850,1100,,2865.60
02-FEB-2009,09:55:04:987,26022009,2800,PE,108.75,200,111,50,11700,1450,,2865.60
02-FEB-2009,09:55:04:939,26022009,3100,CE,31.1,3000,36.55,200,3500,5250,,2865.60
02-FEB-2009,09:55:04:989,26022009,2600,PE,52.05,500,57,400,16050,1150,,2865.60
02-FEB-2009,09:55:04:981,26022009,3000,CE,56.25,2000,67,150,21500,13750,,2865.60
02-FEB-2009,09:55:04:991,26022009,2900,CE,81,1000,100,100,18100,4550,1000,2865.60
02-FEB-2009,09:55:04:953,26022009,2800,CE,150,50,159.7,5000,13400,15500,,2865.60
02-FEB-2009,09:55:04:987,26022009,2700,PE,72.15,3000,79,50,19200,5100,,2865.60
02-FEB-2009,09:55:04:615,26022009,2450,CE,256.9,500,678,500,500,500,,2865.60
02-FEB-2009,09:55:04:894,26022009,3300,CE,6,7000,10.8,2000,7000,2550,,2865.60
The documentation says that ",," should be read as "". But instead the
function throws an error (one I can not understand). See here:
R> library(data.table)
data.table 1.8.7 For help type: help("data.table")
R> tt <- fread("sample.csv", verbose=TRUE)
Detected eol as \n only (no \r afterwards), the UNIX and Mac standard.
Starting format detection on line 30 (the last non blank line in the first 30)
Detected sep as ',' and 13 columns
Type codes: 3300320200002
Found first row with 13 fields occuring on line 1 (either column names
or first row of data)
Error in fread("sample.csv", verbose = TRUE) : Unexpected character (
02-F) ending field 12 of line 1
Using na.strings="" does not work either. But I guess that should not
have made a difference anyway?
Then I opened the file in GVim and converted all `,,' to `,NA,' and
re-read the file. This time it works.
R> tt <- fread("sample-with-NA.csv", verbose=TRUE)
Detected eol as \n only (no \r afterwards), the UNIX and Mac standard.
Starting format detection on line 30 (the last non blank line in the first 30)
Detected sep as ',' and 13 columns
Type codes: 3300320200002
Found first row with 13 fields occuring on line 1 (either column names
or first row of data)
The first data row has some non character fields. Treating as a data
row and using default column names.
Count of eol after pos: 101
Subtracted 1 for last eol and any trailing empty lines, leaving 100 data rows
0.000s ( 6%) Memory map (quicker if you rerun)
0.000s ( 40%) Format detection
0.000s ( 7%) Count rows (wc -l)
0.000s ( 2%) Allocation of 100x13 result (xMB) in RAM
0.000s ( 41%) Reading data
0.000s ( 0%) Bumping column type midread and coercing data already read
0.000s ( 3%) Changing na.strings to NA
0.001s Total
I've attached a 100 row sample.csv and a sample-with-NA.csv here for
you to replicate the issue.
Maybe, it is just that I am missing something. Can you explain?
Thanks a lot!
--
ASB.
02-FEB-2009,09:55:04:962,26022009,2500,PE,36,500,44,200,11850,1100,,2865.60
02-FEB-2009,09:55:04:987,26022009,2800,PE,108.75,200,111,50,11700,1450,,2865.60
02-FEB-2009,09:55:04:939,26022009,3100,CE,31.1,3000,36.55,200,3500,5250,,2865.60
02-FEB-2009,09:55:04:989,26022009,2600,PE,52.05,500,57,400,16050,1150,,2865.60
02-FEB-2009,09:55:04:981,26022009,3000,CE,56.25,2000,67,150,21500,13750,,2865.60
02-FEB-2009,09:55:04:991,26022009,2900,CE,81,1000,100,100,18100,4550,1000,2865.60
02-FEB-2009,09:55:04:953,26022009,2800,CE,150,50,159.7,5000,13400,15500,,2865.60
02-FEB-2009,09:55:04:987,26022009,2700,PE,72.15,3000,79,50,19200,5100,,2865.60
02-FEB-2009,09:55:04:615,26022009,2450,CE,256.9,500,678,500,500,500,,2865.60
02-FEB-2009,09:55:04:894,26022009,3300,CE,6,7000,10.8,2000,7000,2550,,2865.60
02-FEB-2009,09:55:04:976,26022009,2900,PE,160.25,1000,173.5,100,7850,150,,2865.60
02-FEB-2009,09:55:04:916,26022009,2850,CE,106,500,200,500,550,500,,2865.60
02-FEB-2009,09:55:04:857,26022009,2650,PE,5,500,79,500,500,1000,,2865.60
02-FEB-2009,09:55:04:959,26022009,2700,CE,201.15,500,270,500,3500,500,,2865.60
02-FEB-2009,09:55:04:959,26022009,2450,PE,5.3,50,45,50,100,50,,2865.60
02-FEB-2009,09:55:05:985,26022009,2700,PE,75.1,250,75.9,100,26000,7850,,2865.60
02-FEB-2009,09:55:05:767,26022009,3300,CE,8,1000,10.8,2000,8050,3200,,2865.60
02-FEB-2009,09:55:05:982,26022009,2800,PE,115,150,119.9,100,14000,3450,100,2865.60
02-FEB-2009,09:55:05:890,26022009,2650,PE,5,500,79,500,550,1050,,2865.60
02-FEB-2009,09:55:05:961,26022009,2600,PE,51.15,100,56,100,15750,2900,,2865.60
02-FEB-2009,09:55:05:947,26022009,3100,CE,31.1,3000,36.55,200,8700,5350,,2865.60
02-FEB-2009,09:55:05:991,26022009,3000,CE,56.25,1750,60,100,28550,14250,250,2865.60
02-FEB-2009,09:55:05:893,26022009,2500,PE,36,500,42,50,12200,5600,100,2865.60
02-FEB-2009,09:55:05:906,26022009,2900,CE,81,1000,100,100,18700,7850,1000,2865.60
02-FEB-2009,09:55:05:086,26022009,2850,PE,3.3,50,142,100,50,1100,,2865.60
02-FEB-2009,09:55:05:973,26022009,2800,CE,151,200,159.7,4950,14700,15550,100,2865.60
02-FEB-2009,09:55:05:758,26022009,2450,PE,5.3,50,40,50,750,100,,2865.60
02-FEB-2009,09:55:05:514,26022009,3200,CE,3.3,50,19.8,1000,50,2350,,2865.60
02-FEB-2009,09:55:05:137,26022009,2450,CE,301,300,678,500,1900,500,,2865.60
02-FEB-2009,09:55:05:698,26022009,2900,PE,160.25,1000,162,50,8100,500,,2865.60
02-FEB-2009,09:55:05:358,26022009,2700,CE,201.15,500,270,500,3550,500,,2865.60
02-FEB-2009,09:55:05:969,26022009,2750,PE,70,50,140,50,1600,50,,2865.60
02-FEB-2009,09:55:06:981,26022009,3000,CE,56.25,1750,60,100,30150,18500,250,2865.60
02-FEB-2009,09:55:06:893,26022009,2700,PE,78.6,4950,79,50,37300,9450,200,2865.60
02-FEB-2009,09:55:06:919,26022009,2800,PE,115,200,119.9,100,21900,4150,100,2865.60
02-FEB-2009,09:55:06:793,26022009,2500,PE,36,500,42,50,12300,5800,100,2865.60
02-FEB-2009,09:55:06:967,26022009,2800,CE,151,200,159.7,4950,15500,15900,100,2865.60
02-FEB-2009,09:55:06:757,26022009,2750,PE,70,50,99,200,1600,950,,2865.60
02-FEB-2009,09:55:06:985,26022009,2900,PE,160.25,1000,162,50,6200,650,,2865.60
02-FEB-2009,09:55:06:956,26022009,2900,CE,90,50,98,50,20750,9450,1050,2865.60
02-FEB-2009,09:55:06:196,26022009,2450,CE,301,300,600,100,2000,600,,2865.60
02-FEB-2009,09:55:06:809,26022009,2700,CE,204,100,230,50,3800,550,,2865.60
02-FEB-2009,09:55:06:961,26022009,2600,PE,51.15,100,54.9,1250,15450,4750,,2865.60
02-FEB-2009,09:55:06:090,26022009,2850,CE,106,500,175,500,550,1000,,2865.60
02-FEB-2009,09:55:06:138,26032009,4000,CE,0.15,250,16.65,250,250,250,,2865.60
02-FEB-2009,09:55:06:981,26022009,3100,CE,34.1,50,36,1000,8850,6350,,2865.60
02-FEB-2009,09:55:06:410,26022009,3200,CE,3.3,50,19.8,1000,50,2400,,2865.60
02-FEB-2009,09:55:06:431,26022009,3300,PE,211.1,5000,530,5100,5950,5100,,2865.60
02-FEB-2009,09:55:06:936,26022009,2450,PE,12,50,36,50,800,150,,2865.60
02-FEB-2009,09:55:07:642,26022009,2900,CE,90,50,100,100,21000,8700,1100,2862.95
02-FEB-2009,09:55:07:636,26022009,2600,PE,51.15,100,54.9,1250,15750,6450,,2862.95
02-FEB-2009,09:55:07:778,26022009,2500,PE,36,500,42,50,12450,6600,100,2862.95
02-FEB-2009,09:55:07:978,26022009,2700,PE,78.6,4950,79,50,40350,14950,200,2862.95
02-FEB-2009,09:55:07:946,26022009,3100,CE,31.1,3000,35,150,8950,6550,50,2862.95
02-FEB-2009,09:55:07:678,26022009,2800,CE,151,200,155,200,17300,16100,100,2862.95
02-FEB-2009,09:55:07:982,26022009,2800,PE,115,100,119.9,100,24050,5500,200,2862.95
02-FEB-2009,09:55:07:896,26022009,2900,PE,160.25,1000,162,50,6500,700,,2862.95
02-FEB-2009,09:55:07:985,26022009,2450,PE,28,50,30,50,950,200,,2862.95
02-FEB-2009,09:55:07:630,26022009,3000,CE,57,1200,60,100,31450,18700,250,2862.95
02-FEB-2009,09:55:07:351,26022009,2450,CE,301,300,600,100,2500,600,,2862.95
02-FEB-2009,09:55:07:996,26022009,2700,CE,204,100,230,50,4400,550,,2862.95
02-FEB-2009,09:55:07:683,26022009,2650,CE,111,400,390,100,1250,100,,2862.95
02-FEB-2009,09:55:07:786,26022009,3200,CE,3.3,50,19.8,1000,50,2500,,2862.95
02-FEB-2009,09:55:07:851,26032009,2200,PE,10,50,32.4,50,50,50,,2862.95
02-FEB-2009,09:55:07:982,26022009,3000,PE,205,100,260,50,21950,50,,2862.95
02-FEB-2009,09:55:07:999,26022009,2850,CE,106,500,175,500,600,1000,,2862.95
02-FEB-2009,09:55:08:478,26022009,2900,PE,160.25,1000,162,50,9000,750,,2858.55
02-FEB-2009,09:55:08:015,26022009,2450,PE,28,50,30,50,950,250,,2858.55
02-FEB-2009,09:55:08:978,26022009,2700,PE,78.6,4950,79.25,50,36500,16200,300,2858.55
02-FEB-2009,09:55:08:997,26022009,2600,PE,52.1,900,54.9,1200,16950,7500,50,2858.55
02-FEB-2009,09:55:08:873,26022009,2500,PE,37,500,42,50,13050,6800,100,2858.55
02-FEB-2009,09:55:08:086,26022009,2700,CE,204,100,215,300,4400,1200,,2858.55
02-FEB-2009,09:55:08:999,26022009,2800,CE,151,150,155,200,22650,16700,150,2858.55
02-FEB-2009,09:55:08:856,26022009,2800,PE,115.6,1000,119,100,21800,5900,200,2858.55
02-FEB-2009,09:55:08:987,26022009,2900,CE,90,50,97,2000,21250,10900,1100,2858.55
02-FEB-2009,09:55:08:125,26022009,2850,PE,3.3,50,142,100,50,1150,,2858.55
02-FEB-2009,09:55:08:139,26022009,3000,PE,205,100,260,50,22450,50,,2858.55
02-FEB-2009,09:55:08:164,26032009,2200,PE,31.1,50,32.4,50,100,50,,2858.55
02-FEB-2009,09:55:08:170,26022009,2750,PE,70,50,99,250,1600,1000,,2858.55
02-FEB-2009,09:55:08:905,26022009,3000,CE,57,1200,60,100,31500,19000,250,2858.55
02-FEB-2009,09:55:08:869,26022009,3100,CE,31.1,3000,35,350,8950,6700,50,2858.55
02-FEB-2009,09:55:08:697,26022009,3100,PE,251,50,318,1200,8050,1200,,2858.55
02-FEB-2009,09:55:08:733,26022009,2850,CE,106,500,175,500,600,1050,,2858.55
02-FEB-2009,09:55:08:919,26022009,3300,CE,8,1000,10.8,2000,13050,3650,,2858.55
02-FEB-2009,09:55:08:740,26022009,3200,CE,10.1,1000,19.8,1000,1050,2500,,2858.55
02-FEB-2009,09:55:08:982,26032009,2900,CE,132,50,193,50,350,50,,2858.55
02-FEB-2009,09:55:08:982,26032009,3000,CE,52.2,50,147,50,200,50,,2858.55
02-FEB-2009,09:55:08:986,26032009,2700,PE,102,100,164,50,250,50,,2858.55
02-FEB-2009,09:55:08:987,26032009,2600,PE,63.3,50,137,50,50,50,,2858.55
02-FEB-2009,09:55:09:998,26022009,2800,PE,112.9,50,114,900,21150,7900,1400,2858.55
02-FEB-2009,09:55:09:884,26022009,2700,CE,204,100,215,300,6050,1500,,2858.55
02-FEB-2009,09:55:09:924,26022009,2700,PE,79,100,79.25,50,36200,16800,300,2858.55
02-FEB-2009,09:55:09:975,26022009,2600,PE,52.1,900,54.9,1200,17000,7650,50,2858.55
02-FEB-2009,09:55:09:757,26022009,2900,CE,90,50,97,2000,23150,10900,1100,2858.55
02-FEB-2009,09:55:09:761,26022009,3000,CE,57,1200,60,50,32200,19450,300,2858.55
02-FEB-2009,09:55:09:359,26022009,2650,PE,5,500,79,500,550,1200,,2858.55
02-FEB-2009,09:55:09:662,26022009,2500,PE,37,500,44,350,13400,8900,200,2858.55
02-FEB-2009,09:55:09:599,26022009,3300,CE,8,1000,10.8,2000,13600,3650,,2858.55
02-FEB-2009,09:55:09:796,26022009,3100,CE,31.1,3000,35,450,4500,6800,50,2858.55
02-FEB-2009,09:55:09:807,26022009,2800,CE,146.2,950,150,900,22500,17600,350,2858.55
02-FEB-2009,09:55:04:962,26022009,2500,PE,36,500,44,200,11850,1100,NA,2865.60
02-FEB-2009,09:55:04:987,26022009,2800,PE,108.75,200,111,50,11700,1450,NA,2865.60
02-FEB-2009,09:55:04:939,26022009,3100,CE,31.1,3000,36.55,200,3500,5250,NA,2865.60
02-FEB-2009,09:55:04:989,26022009,2600,PE,52.05,500,57,400,16050,1150,NA,2865.60
02-FEB-2009,09:55:04:981,26022009,3000,CE,56.25,2000,67,150,21500,13750,NA,2865.60
02-FEB-2009,09:55:04:991,26022009,2900,CE,81,1000,100,100,18100,4550,1000,2865.60
02-FEB-2009,09:55:04:953,26022009,2800,CE,150,50,159.7,5000,13400,15500,NA,2865.60
02-FEB-2009,09:55:04:987,26022009,2700,PE,72.15,3000,79,50,19200,5100,NA,2865.60
02-FEB-2009,09:55:04:615,26022009,2450,CE,256.9,500,678,500,500,500,NA,2865.60
02-FEB-2009,09:55:04:894,26022009,3300,CE,6,7000,10.8,2000,7000,2550,NA,2865.60
02-FEB-2009,09:55:04:976,26022009,2900,PE,160.25,1000,173.5,100,7850,150,NA,2865.60
02-FEB-2009,09:55:04:916,26022009,2850,CE,106,500,200,500,550,500,NA,2865.60
02-FEB-2009,09:55:04:857,26022009,2650,PE,5,500,79,500,500,1000,NA,2865.60
02-FEB-2009,09:55:04:959,26022009,2700,CE,201.15,500,270,500,3500,500,NA,2865.60
02-FEB-2009,09:55:04:959,26022009,2450,PE,5.3,50,45,50,100,50,NA,2865.60
02-FEB-2009,09:55:05:985,26022009,2700,PE,75.1,250,75.9,100,26000,7850,NA,2865.60
02-FEB-2009,09:55:05:767,26022009,3300,CE,8,1000,10.8,2000,8050,3200,NA,2865.60
02-FEB-2009,09:55:05:982,26022009,2800,PE,115,150,119.9,100,14000,3450,100,2865.60
02-FEB-2009,09:55:05:890,26022009,2650,PE,5,500,79,500,550,1050,NA,2865.60
02-FEB-2009,09:55:05:961,26022009,2600,PE,51.15,100,56,100,15750,2900,NA,2865.60
02-FEB-2009,09:55:05:947,26022009,3100,CE,31.1,3000,36.55,200,8700,5350,NA,2865.60
02-FEB-2009,09:55:05:991,26022009,3000,CE,56.25,1750,60,100,28550,14250,250,2865.60
02-FEB-2009,09:55:05:893,26022009,2500,PE,36,500,42,50,12200,5600,100,2865.60
02-FEB-2009,09:55:05:906,26022009,2900,CE,81,1000,100,100,18700,7850,1000,2865.60
02-FEB-2009,09:55:05:086,26022009,2850,PE,3.3,50,142,100,50,1100,NA,2865.60
02-FEB-2009,09:55:05:973,26022009,2800,CE,151,200,159.7,4950,14700,15550,100,2865.60
02-FEB-2009,09:55:05:758,26022009,2450,PE,5.3,50,40,50,750,100,NA,2865.60
02-FEB-2009,09:55:05:514,26022009,3200,CE,3.3,50,19.8,1000,50,2350,NA,2865.60
02-FEB-2009,09:55:05:137,26022009,2450,CE,301,300,678,500,1900,500,NA,2865.60
02-FEB-2009,09:55:05:698,26022009,2900,PE,160.25,1000,162,50,8100,500,NA,2865.60
02-FEB-2009,09:55:05:358,26022009,2700,CE,201.15,500,270,500,3550,500,NA,2865.60
02-FEB-2009,09:55:05:969,26022009,2750,PE,70,50,140,50,1600,50,NA,2865.60
02-FEB-2009,09:55:06:981,26022009,3000,CE,56.25,1750,60,100,30150,18500,250,2865.60
02-FEB-2009,09:55:06:893,26022009,2700,PE,78.6,4950,79,50,37300,9450,200,2865.60
02-FEB-2009,09:55:06:919,26022009,2800,PE,115,200,119.9,100,21900,4150,100,2865.60
02-FEB-2009,09:55:06:793,26022009,2500,PE,36,500,42,50,12300,5800,100,2865.60
02-FEB-2009,09:55:06:967,26022009,2800,CE,151,200,159.7,4950,15500,15900,100,2865.60
02-FEB-2009,09:55:06:757,26022009,2750,PE,70,50,99,200,1600,950,NA,2865.60
02-FEB-2009,09:55:06:985,26022009,2900,PE,160.25,1000,162,50,6200,650,NA,2865.60
02-FEB-2009,09:55:06:956,26022009,2900,CE,90,50,98,50,20750,9450,1050,2865.60
02-FEB-2009,09:55:06:196,26022009,2450,CE,301,300,600,100,2000,600,NA,2865.60
02-FEB-2009,09:55:06:809,26022009,2700,CE,204,100,230,50,3800,550,NA,2865.60
02-FEB-2009,09:55:06:961,26022009,2600,PE,51.15,100,54.9,1250,15450,4750,NA,2865.60
02-FEB-2009,09:55:06:090,26022009,2850,CE,106,500,175,500,550,1000,NA,2865.60
02-FEB-2009,09:55:06:138,26032009,4000,CE,0.15,250,16.65,250,250,250,NA,2865.60
02-FEB-2009,09:55:06:981,26022009,3100,CE,34.1,50,36,1000,8850,6350,NA,2865.60
02-FEB-2009,09:55:06:410,26022009,3200,CE,3.3,50,19.8,1000,50,2400,NA,2865.60
02-FEB-2009,09:55:06:431,26022009,3300,PE,211.1,5000,530,5100,5950,5100,NA,2865.60
02-FEB-2009,09:55:06:936,26022009,2450,PE,12,50,36,50,800,150,NA,2865.60
02-FEB-2009,09:55:07:642,26022009,2900,CE,90,50,100,100,21000,8700,1100,2862.95
02-FEB-2009,09:55:07:636,26022009,2600,PE,51.15,100,54.9,1250,15750,6450,NA,2862.95
02-FEB-2009,09:55:07:778,26022009,2500,PE,36,500,42,50,12450,6600,100,2862.95
02-FEB-2009,09:55:07:978,26022009,2700,PE,78.6,4950,79,50,40350,14950,200,2862.95
02-FEB-2009,09:55:07:946,26022009,3100,CE,31.1,3000,35,150,8950,6550,50,2862.95
02-FEB-2009,09:55:07:678,26022009,2800,CE,151,200,155,200,17300,16100,100,2862.95
02-FEB-2009,09:55:07:982,26022009,2800,PE,115,100,119.9,100,24050,5500,200,2862.95
02-FEB-2009,09:55:07:896,26022009,2900,PE,160.25,1000,162,50,6500,700,NA,2862.95
02-FEB-2009,09:55:07:985,26022009,2450,PE,28,50,30,50,950,200,NA,2862.95
02-FEB-2009,09:55:07:630,26022009,3000,CE,57,1200,60,100,31450,18700,250,2862.95
02-FEB-2009,09:55:07:351,26022009,2450,CE,301,300,600,100,2500,600,NA,2862.95
02-FEB-2009,09:55:07:996,26022009,2700,CE,204,100,230,50,4400,550,NA,2862.95
02-FEB-2009,09:55:07:683,26022009,2650,CE,111,400,390,100,1250,100,NA,2862.95
02-FEB-2009,09:55:07:786,26022009,3200,CE,3.3,50,19.8,1000,50,2500,NA,2862.95
02-FEB-2009,09:55:07:851,26032009,2200,PE,10,50,32.4,50,50,50,NA,2862.95
02-FEB-2009,09:55:07:982,26022009,3000,PE,205,100,260,50,21950,50,NA,2862.95
02-FEB-2009,09:55:07:999,26022009,2850,CE,106,500,175,500,600,1000,NA,2862.95
02-FEB-2009,09:55:08:478,26022009,2900,PE,160.25,1000,162,50,9000,750,NA,2858.55
02-FEB-2009,09:55:08:015,26022009,2450,PE,28,50,30,50,950,250,NA,2858.55
02-FEB-2009,09:55:08:978,26022009,2700,PE,78.6,4950,79.25,50,36500,16200,300,2858.55
02-FEB-2009,09:55:08:997,26022009,2600,PE,52.1,900,54.9,1200,16950,7500,50,2858.55
02-FEB-2009,09:55:08:873,26022009,2500,PE,37,500,42,50,13050,6800,100,2858.55
02-FEB-2009,09:55:08:086,26022009,2700,CE,204,100,215,300,4400,1200,NA,2858.55
02-FEB-2009,09:55:08:999,26022009,2800,CE,151,150,155,200,22650,16700,150,2858.55
02-FEB-2009,09:55:08:856,26022009,2800,PE,115.6,1000,119,100,21800,5900,200,2858.55
02-FEB-2009,09:55:08:987,26022009,2900,CE,90,50,97,2000,21250,10900,1100,2858.55
02-FEB-2009,09:55:08:125,26022009,2850,PE,3.3,50,142,100,50,1150,NA,2858.55
02-FEB-2009,09:55:08:139,26022009,3000,PE,205,100,260,50,22450,50,NA,2858.55
02-FEB-2009,09:55:08:164,26032009,2200,PE,31.1,50,32.4,50,100,50,NA,2858.55
02-FEB-2009,09:55:08:170,26022009,2750,PE,70,50,99,250,1600,1000,NA,2858.55
02-FEB-2009,09:55:08:905,26022009,3000,CE,57,1200,60,100,31500,19000,250,2858.55
02-FEB-2009,09:55:08:869,26022009,3100,CE,31.1,3000,35,350,8950,6700,50,2858.55
02-FEB-2009,09:55:08:697,26022009,3100,PE,251,50,318,1200,8050,1200,NA,2858.55
02-FEB-2009,09:55:08:733,26022009,2850,CE,106,500,175,500,600,1050,NA,2858.55
02-FEB-2009,09:55:08:919,26022009,3300,CE,8,1000,10.8,2000,13050,3650,NA,2858.55
02-FEB-2009,09:55:08:740,26022009,3200,CE,10.1,1000,19.8,1000,1050,2500,NA,2858.55
02-FEB-2009,09:55:08:982,26032009,2900,CE,132,50,193,50,350,50,NA,2858.55
02-FEB-2009,09:55:08:982,26032009,3000,CE,52.2,50,147,50,200,50,NA,2858.55
02-FEB-2009,09:55:08:986,26032009,2700,PE,102,100,164,50,250,50,NA,2858.55
02-FEB-2009,09:55:08:987,26032009,2600,PE,63.3,50,137,50,50,50,NA,2858.55
02-FEB-2009,09:55:09:998,26022009,2800,PE,112.9,50,114,900,21150,7900,1400,2858.55
02-FEB-2009,09:55:09:884,26022009,2700,CE,204,100,215,300,6050,1500,NA,2858.55
02-FEB-2009,09:55:09:924,26022009,2700,PE,79,100,79.25,50,36200,16800,300,2858.55
02-FEB-2009,09:55:09:975,26022009,2600,PE,52.1,900,54.9,1200,17000,7650,50,2858.55
02-FEB-2009,09:55:09:757,26022009,2900,CE,90,50,97,2000,23150,10900,1100,2858.55
02-FEB-2009,09:55:09:761,26022009,3000,CE,57,1200,60,50,32200,19450,300,2858.55
02-FEB-2009,09:55:09:359,26022009,2650,PE,5,500,79,500,550,1200,NA,2858.55
02-FEB-2009,09:55:09:662,26022009,2500,PE,37,500,44,350,13400,8900,200,2858.55
02-FEB-2009,09:55:09:599,26022009,3300,CE,8,1000,10.8,2000,13600,3650,NA,2858.55
02-FEB-2009,09:55:09:796,26022009,3100,CE,31.1,3000,35,450,4500,6800,50,2858.55
02-FEB-2009,09:55:09:807,26022009,2800,CE,146.2,950,150,900,22500,17600,350,2858.55
_______________________________________________
datatable-help mailing list
[email protected]
https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help