[Thread Prev][Thread Next][Index]
[ferret_users] How to manipulate data ( irregular ) after reading from file to make grid
Hey All,
I got csv file, which I can read easily on ferret with 1 line command, but I don't know how to manipulate further to make grid which I am looking forward, please someone help me, it will be very useful.
Here is my problem
$ wc -l test.csv
730 test.csv
$ head -1 test.csv
"pkey1","pkey2","LATITUDE","LONGITUDE","ST_DATE","TEMP","SALT"
$ cut -d',' -f1,2,3,4 test.csv | sort -un | wc -l
82
$ cut -d',' -f1,2,3,4 test.csv | sort -un | head -10
"pkey1","pkey2","LATITUDE","LONGITUDE"
869,1,0,93
869,2,0,93
869,3,0,93
869,4,0,93
869,5,0,93
869,6,0,93
884,1,0,83
884,2,0,83
884,3,0,83
$ ferret
NOAA/PMEL TMAP
FERRET v6.96
Linux 2.6.32-573.7.1.el6.x86_64 64-bit - 12/02/15
2-Dec-16 17:52
yes? columns/skip=1/format=delim/delim="\,"/type="numeric,numeric,numeric,numeric,text,numeric,numeric"/var="pkey1,pkey2,latitude,longitude,st_date,temp,salt" test.csv
yes? sh d
currently SET data sets:
1> ./test.csv (default)
name title I J K L M N
PKEY1 PKEY1 1:730 ... ... ... ... ...
PKEY2 PKEY2 1:730 ... ... ... ... ...
LATITUDE LATITUDE 1:730 ... ... ... ... ...
LONGITUDE
LONGITUDE 1:730 ... ... ... ... ...
ST_DATE ST_DATE 1:730 ... ... ... ... ...
TEMP TEMP 1:730 ... ... ... ... ...
SALT SALT 1:730 ... ... ... ... ...
yes?
I would like to make grid such a way that, when I type "sh d", I want to see like this, since my data is not uniformly spaced, I want to keep in 'M' as string only
yes? sh d
currently SET data sets:
1> ./test.csv (default)
name title I J K L M N
PKEY1 PKEY1 1:82 ... ... ... ... ...
PKEY2 PKEY2 1:82 ... ... ... ... ...
LATITUDE LATITUDE 1:82 ... ... ... ... ...
LONGITUDE
LONGITUDE 1:82 ... ... ... ... ...
ST_DATE ST_DATE 1:82 ... ... ... 1:maxlength ...
TEMP TEMP 1:82 ... ... ... 1:maxlength ...
SALT SALT 1:82 ... ... ... 1:maxlength ...
If I list like this, it should show no of records = maxlength, something like below
list/i=1 st_date,temp,salt
DATA SET: ./test.csv
X: 0.5 to 8.5
Column 1: ST_DATE
Column 2: TEMP
Column 3: SALT
ST_DATE TEMP SALT
1 / 1: "2000-02-13 17:00:00" 14.37 35.14
2 / 2: "2000-02-13 18:00:00" 15.25 35.09
3 / 3: "2000-02-13 19:00:00" 14.42 35.10
4 / 4: "2000-02-13 20:00:00" 14.37 35.14
5 / 5: "2000-02-13 21:00:00" 14.25 35.12
6 / 6: "2000-02-13 22:00:00" 14.32 35.19
7 / 7: "2000-02-13 23:00:00" 14.37 35.14
maxlength / 8: "2000-02-14 00:00:00" 14.30 35.14
Please someone help me.
Thanks in advance.
"pkey1","pkey2","LATITUDE","LONGITUDE","ST_DATE","TEMP","SALT"
869,1,0,93,"2000-02-13 17:00:00",14.37,35.14
869,1,0,93,"2000-02-13 18:00:00",15.25,35.09
869,1,0,93,"2000-02-13 19:00:00",14.42,35.1
869,1,0,93,"2000-02-13 20:00:00",14.37,35.14
869,1,0,93,"2000-02-13 21:00:00",14.25,35.12
869,1,0,93,"2000-02-13 22:00:00",14.32,35.19
869,1,0,93,"2000-02-13 23:00:00",14.37,35.14
869,1,0,93,"2000-02-14 00:00:00",14.3,35.14
869,1,0,93,"2000-02-14 01:00:00",14.44,35.15
869,2,0,93,"2000-02-13 17:00:00",11.88,35.09
869,2,0,93,"2000-02-13 18:00:00",11.95,35.03
869,2,0,93,"2000-02-13 19:00:00",11.88,35.03
869,2,0,93,"2000-02-13 20:00:00",11.83,34.99
869,2,0,93,"2000-02-13 21:00:00",11.83,34.99
869,2,0,93,"2000-02-13 22:00:00",11.65,35.03
869,2,0,93,"2000-02-13 23:00:00",11.65,35.03
869,2,0,93,"2000-02-14 00:00:00",11.72,35.03
869,2,0,93,"2000-02-14 01:00:00",11.79,35.03
869,3,0,93,"2000-02-14 00:00:00",9.77,34.98
869,3,0,93,"2000-02-14 01:00:00",9.77,34.98
869,3,0,93,"2000-02-14 02:00:00",9.77,34.98
869,3,0,93,"2000-02-14 03:00:00",9.81,35.02
869,3,0,93,"2000-02-14 04:00:00",9.88,35.02
869,3,0,93,"2000-02-14 05:00:00",9.93,34.97
869,3,0,93,"2000-02-14 06:00:00",9.93,35.06
869,3,0,93,"2000-02-14 07:00:00",9.98,35.01
869,3,0,93,"2000-02-14 08:00:00",9.93,34.97
869,4,0,93,"2000-02-13 17:00:00",6.95,34.91
869,4,0,93,"2000-02-13 18:00:00",6.97,34.89
869,4,0,93,"2000-02-13 19:00:00",6.86,34.93
869,4,0,93,"2000-02-13 20:00:00",6.7,34.92
869,4,0,93,"2000-02-13 21:00:00",6.72,34.9
869,4,0,93,"2000-02-13 22:00:00",6.7,34.92
869,4,0,93,"2000-02-13 23:00:00",6.81,34.9
869,4,0,93,"2000-02-14 00:00:00",6.7,34.92
869,4,0,93,"2000-02-14 01:00:00",6.7,34.85
869,5,0,93,"2000-02-13 17:00:00",2.77,35.51
869,5,0,93,"2000-02-13 18:00:00",2.77,35.6
869,5,0,93,"2000-02-13 19:00:00",2.77,35.61
869,5,0,93,"2000-02-13 20:00:00",2.77,35.6
869,5,0,93,"2000-02-13 21:00:00",2.77,35.6
869,5,0,93,"2000-02-13 22:00:00",2.77,35.6
869,5,0,93,"2000-02-13 23:00:00",2.77,35.6
869,5,0,93,"2000-02-14 00:00:00",2.77,35.51
869,5,0,93,"2000-02-14 01:00:00",2.77,35.6
869,6,0,93,"2000-02-13 17:00:00",1.14,34.14
869,6,0,93,"2000-02-13 19:00:00",1.12,34.26
869,6,0,93,"2000-02-13 21:00:00",1.12,34.26
869,6,0,93,"2000-02-13 23:00:00",1.14,34.24
869,6,0,93,"2000-02-14 01:00:00",1.12,34.34
869,6,0,93,"2000-02-14 03:00:00",1.12,34.26
869,6,0,93,"2000-02-14 05:00:00",1.12,34.34
869,6,0,93,"2000-02-14 07:00:00",1.14,34.32
869,6,0,93,"2000-02-14 09:00:00",1.14,34.32
884,1,0,83,"2000-12-15 00:00:00",10.54,35.05
884,1,0,83,"2000-12-15 01:00:00",10.54,35.05
884,1,0,83,"2000-12-15 02:00:00",10.47,34.97
884,1,0,83,"2000-12-15 03:00:00",10.4,35.04
884,1,0,83,"2000-12-15 04:00:00",10.49,35.03
884,1,0,83,"2000-12-15 05:00:00",10.54,34.98
884,1,0,83,"2000-12-15 06:00:00",10.54,34.98
884,1,0,83,"2000-12-15 07:00:00",10.54,35.05
884,1,0,83,"2000-12-15 08:00:00",10.56,35.04
884,2,0,83,"2000-12-15 00:00:00",9.15,35.03
884,2,0,83,"2000-12-15 01:00:00",9.17,35.08
884,2,0,83,"2000-12-15 02:00:00",9.15,35.02
884,2,0,83,"2000-12-15 03:00:00",9.08,35.02
884,2,0,83,"2000-12-15 04:00:00",9.11,35.07
884,2,0,83,"2000-12-15 05:00:00",9.11,35.07
884,2,0,83,"2000-12-15 06:00:00",9.13,35.05
884,2,0,83,"2000-12-15 07:00:00",9.08,35.1
884,2,0,83,"2000-12-15 08:00:00",9.13,35.05
884,3,0,83,"2000-12-15 00:00:00",5.69,34.71
884,3,0,83,"2000-12-15 01:00:00",5.75,34.82
884,3,0,83,"2000-12-15 02:00:00",5.69,34.71
884,3,0,83,"2000-12-15 03:00:00",5.66,34.74
884,3,0,83,"2000-12-15 04:00:00",5.6,34.72
884,3,0,83,"2000-12-15 05:00:00",5.69,34.71
884,3,0,83,"2000-12-15 06:00:00",5.66,34.74
884,3,0,83,"2000-12-15 07:00:00",5.66,34.74
884,3,0,83,"2000-12-15 08:00:00",5.8,34.77
884,4,0,83,"2000-12-15 00:00:00",2.48,34.88
884,4,0,83,"2000-12-15 01:00:00",2.53,34.82
884,4,0,83,"2000-12-15 02:00:00",2.5,34.85
884,4,0,83,"2000-12-15 03:00:00",2.48,34.79
884,4,0,83,"2000-12-15 04:00:00",2.48,34.79
884,4,0,83,"2000-12-15 05:00:00",2.5,34.85
884,4,0,83,"2000-12-15 06:00:00",2.57,34.78
884,4,0,83,"2000-12-15 07:00:00",2.5,34.85
884,4,0,83,"2000-12-15 08:00:00",2.53,34.82
884,5,0,83,"2000-12-15 00:00:00",1.37,41.19
884,5,0,83,"2000-12-15 01:00:00",1.37,41.19
884,5,0,83,"2000-12-15 02:00:00",1.37,41.19
884,5,0,83,"2000-12-15 03:00:00",1.37,41.19
884,5,0,83,"2000-12-15 04:00:00",1.37,41.19
884,5,0,83,"2000-12-15 05:00:00",1.37,41.19
884,5,0,83,"2000-12-15 06:00:00",1.37,41.28
884,5,0,83,"2000-12-15 07:00:00",1.37,41.19
884,5,0,83,"2000-12-15 08:00:00",1.37,41.19
884,6,0,93,"2000-12-23 13:00:00",28.54,34.62
884,6,0,93,"2000-12-23 15:00:00",28.56,34.61
884,6,0,93,"2000-12-23 17:00:00",28.56,34.61
884,6,0,93,"2000-12-23 19:00:00",28.56,34.61
884,6,0,93,"2000-12-23 21:00:00",28.64,34.65
884,6,0,93,"2000-12-23 23:00:00",28.64,34.65
884,6,0,93,"2000-12-24 01:00:00",28.64,34.65
884,6,0,93,"2000-12-24 03:00:00",28.62,34.67
884,6,0,93,"2000-12-24 05:00:00",28.64,34.65
884,7,0,93,"2000-12-23 13:00:00",14.18,35.15
884,7,0,93,"2000-12-23 15:00:00",12.23,35.13
884,7,0,93,"2000-12-23 17:00:00",12.82,35.14
884,7,0,93,"2000-12-23 19:00:00",12.99,35.2
884,7,0,93,"2000-12-23 21:00:00",12.73,35.16
884,7,0,93,"2000-12-23 23:00:00",12.51,35.15
884,7,0,93,"2000-12-24 01:00:00",12.21,35.15
884,7,0,93,"2000-12-24 03:00:00",12.21,35.15
884,7,0,93,"2000-12-24 05:00:00",12.4,35.19
884,8,0,93,"2000-12-23 13:00:00",9.58,35.03
884,8,0,93,"2000-12-23 14:00:00",9.64,35.04
884,8,0,93,"2000-12-23 15:00:00",9.74,35.09
884,8,0,93,"2000-12-23 16:00:00",9.76,35.07
884,8,0,93,"2000-12-23 17:00:00",9.78,35.05
884,8,0,93,"2000-12-23 18:00:00",9.78,35.05
884,8,0,93,"2000-12-23 19:00:00",9.81,35.02
884,8,0,93,"2000-12-23 20:00:00",9.76,35.07
884,8,0,93,"2000-12-23 21:00:00",9.76,35.07
884,9,0,93,"2000-12-23 13:00:00",6.8,35.48
884,9,0,93,"2000-12-23 14:00:00",6.71,35.49
884,9,0,93,"2000-12-23 15:00:00",6.71,35.49
884,9,0,93,"2000-12-23 16:00:00",6.78,35.5
884,9,0,93,"2000-12-23 17:00:00",7.08,35.52
884,9,0,93,"2000-12-23 18:00:00",7.08,35.52
884,9,0,93,"2000-12-23 19:00:00",7.08,35.52
884,9,0,93,"2000-12-23 20:00:00",6.94,35.5
884,9,0,93,"2000-12-23 21:00:00",7.03,35.48
884,10,0,93,"2000-12-23 13:00:00",2.7,35.83
884,10,0,93,"2000-12-23 14:00:00",2.74,35.87
884,10,0,93,"2000-12-23 15:00:00",2.74,35.87
884,10,0,93,"2000-12-23 16:00:00",2.72,35.89
884,10,0,93,"2000-12-23 17:00:00",2.74,35.87
884,10,0,93,"2000-12-23 18:00:00",2.79,35.81
884,10,0,93,"2000-12-23 19:00:00",2.79,35.81
884,10,0,93,"2000-12-23 20:00:00",2.79,35.81
884,10,0,93,"2000-12-23 21:00:00",2.77,35.83
884,11,0,93,"2000-12-23 13:00:00",1.14,43.59
884,11,0,93,"2000-12-23 14:00:00",1.14,43.68
884,11,0,93,"2000-12-23 15:00:00",1.33,43.32
884,11,0,93,"2000-12-23 16:00:00",1.33,43.32
884,11,0,93,"2000-12-23 17:00:00",1.35,43.48
884,11,0,93,"2000-12-23 18:00:00",1.33,43.51
884,11,0,93,"2000-12-23 19:00:00",1.28,43.68
884,11,0,93,"2000-12-23 20:00:00",1.26,43.7
884,11,0,93,"2000-12-23 21:00:00",1.23,43.75
906,1,0,76,"2002-03-20 18:00:00",10.68,34.97
906,1,0,76,"2002-03-20 19:00:00",10.58,35.06
906,1,0,76,"2002-03-20 20:00:00",10.55,35.01
906,1,0,76,"2002-03-20 21:00:00",10.52,34.97
906,1,0,76,"2002-03-20 22:00:00",10.45,34.96
906,1,0,76,"2002-03-20 23:00:00",10.42,34.91
906,1,0,76,"2002-03-21 00:00:00",10.39,34.94
906,1,0,76,"2002-03-21 01:00:00",10.42,34.99
906,1,0,76,"2002-03-21 02:00:00",10.49,35
906,2,0,76,"2002-03-20 18:00:00",9.18,35.04
906,2,0,76,"2002-03-20 19:00:00",9.18,35.04
906,2,0,76,"2002-03-20 20:00:00",9.21,35.01
906,2,0,76,"2002-03-20 21:00:00",9.21,35.08
906,2,0,76,"2002-03-20 22:00:00",9.25,34.98
906,2,0,76,"2002-03-20 23:00:00",9.25,35.05
906,2,0,76,"2002-03-21 00:00:00",9.21,35.08
906,2,0,76,"2002-03-21 01:00:00",9.18,35.04
906,2,0,76,"2002-03-21 02:00:00",9.18,35.04
906,3,0,76,"2002-03-20 18:00:00",8.17,35.03
906,3,0,76,"2002-03-20 19:00:00",8.1,35.02
906,3,0,76,"2002-03-20 20:00:00",8.07,34.97
906,3,0,76,"2002-03-20 21:00:00",8.1,34.94
906,3,0,76,"2002-03-20 22:00:00",8.14,34.98
906,3,0,76,"2002-03-20 23:00:00",8.07,35.05
906,3,0,76,"2002-03-21 00:00:00",8.1,35.02
906,3,0,76,"2002-03-21 01:00:00",8.1,34.94
906,3,0,76,"2002-03-21 02:00:00",8.17,35.03
906,4,0,76,"2002-03-20 18:00:00",4.86,34.86
906,4,0,76,"2002-03-20 19:00:00",4.86,34.86
906,4,0,76,"2002-03-20 20:00:00",4.86,34.78
906,4,0,76,"2002-03-20 21:00:00",4.93,34.87
906,4,0,76,"2002-03-20 22:00:00",4.9,34.82
906,4,0,76,"2002-03-20 23:00:00",4.93,34.87
906,4,0,76,"2002-03-21 00:00:00",4.93,34.87
906,4,0,76,"2002-03-21 01:00:00",5,34.89
906,4,0,76,"2002-03-21 02:00:00",5,34.89
906,5,0,76,"2002-03-20 18:00:00",2.28,34.65
906,5,0,76,"2002-03-20 19:00:00",2.24,34.7
906,5,0,76,"2002-03-20 20:00:00",2.24,34.7
906,5,0,76,"2002-03-20 21:00:00",2.33,34.69
906,5,0,76,"2002-03-20 22:00:00",2.35,34.66
906,5,0,76,"2002-03-20 23:00:00",2.35,34.66
906,5,0,76,"2002-03-21 00:00:00",2.35,34.66
906,5,0,76,"2002-03-21 01:00:00",2.35,34.66
906,5,0,76,"2002-03-21 02:00:00",2.35,34.66
906,6,0,76,"2002-03-20 18:00:00",1.38,35.61
906,6,0,76,"2002-03-20 19:00:00",1.38,35.61
906,6,0,76,"2002-03-20 20:00:00",1.38,35.61
906,6,0,76,"2002-03-20 21:00:00",1.38,35.61
906,6,0,76,"2002-03-20 22:00:00",1.38,35.61
906,6,0,76,"2002-03-20 23:00:00",1.38,35.61
906,6,0,76,"2002-03-21 00:00:00",1.38,35.61
906,6,0,76,"2002-03-21 01:00:00",1.38,35.61
906,6,0,76,"2002-03-21 02:00:00",1.35,35.63
906,7,0,83,"2002-03-27 00:00:00",13.7,35.09
906,7,0,83,"2002-03-27 01:00:00",13.7,35.09
906,7,0,83,"2002-03-27 02:00:00",14.2,35.11
906,7,0,83,"2002-03-27 03:00:00",13.67,35.11
906,7,0,83,"2002-03-27 04:00:00",14.26,35.11
906,7,0,83,"2002-03-27 05:00:00",13.7,35.08
906,7,0,83,"2002-03-27 06:00:00",13.67,35.11
906,7,0,83,"2002-03-27 07:00:00",13.61,35.1
906,7,0,83,"2002-03-27 08:00:00",13.61,35.1
906,8,0,83,"2002-03-27 00:00:00",10.94,35.16
906,8,0,83,"2002-03-27 01:00:00",10.89,35.14
906,8,0,83,"2002-03-27 02:00:00",10.94,35.16
906,8,0,83,"2002-03-27 03:00:00",10.89,35.21
906,8,0,83,"2002-03-27 04:00:00",10.94,35.16
906,8,0,83,"2002-03-27 05:00:00",10.87,35.16
906,8,0,83,"2002-03-27 06:00:00",10.89,35.13
906,8,0,83,"2002-03-27 07:00:00",10.89,35.21
906,8,0,83,"2002-03-27 08:00:00",10.89,35.21
906,9,0,83,"2002-03-27 00:00:00",9.7,34.96
906,9,0,83,"2002-03-27 01:00:00",9.61,34.98
906,9,0,83,"2002-03-27 02:00:00",9.7,34.96
906,9,0,83,"2002-03-27 03:00:00",9.61,34.9
906,9,0,83,"2002-03-27 04:00:00",9.68,34.98
906,9,0,83,"2002-03-27 05:00:00",9.5,34.94
906,9,0,83,"2002-03-27 06:00:00",9.63,34.95
906,9,0,83,"2002-03-27 07:00:00",9.66,34.93
906,9,0,83,"2002-03-27 08:00:00",9.7,34.96
906,10,0,83,"2002-03-27 00:00:00",6.35,0.11
906,10,0,83,"2002-03-27 01:00:00",6.32,0.11
906,10,0,83,"2002-03-27 02:00:00",6.35,0.11
906,10,0,83,"2002-03-27 03:00:00",6.32,0.11
906,10,0,83,"2002-03-27 04:00:00",6.37,0.11
906,10,0,83,"2002-03-27 05:00:00",6.32,0.11
906,10,0,83,"2002-03-27 06:00:00",6.23,0.11
906,10,0,83,"2002-03-27 07:00:00",6.3,0.11
906,10,0,83,"2002-03-27 08:00:00",6.35,0.11
906,11,0,83,"2002-03-27 00:00:00",2.66,38.29
906,11,0,83,"2002-03-27 01:00:00",2.66,38.29
906,11,0,83,"2002-03-27 02:00:00",2.66,38.29
906,11,0,83,"2002-03-27 03:00:00",2.66,38.29
906,11,0,83,"2002-03-27 04:00:00",2.66,38.29
906,11,0,83,"2002-03-27 05:00:00",2.66,38.29
906,11,0,83,"2002-03-27 06:00:00",2.62,38.34
906,11,0,83,"2002-03-27 07:00:00",2.64,38.31
906,11,0,83,"2002-03-27 08:00:00",2.59,38.37
906,12,0,83,"2002-03-27 00:00:00",1.37,38.26
906,12,0,83,"2002-03-27 01:00:00",1.37,38.26
906,12,0,83,"2002-03-27 02:00:00",1.37,38.27
906,12,0,83,"2002-03-27 03:00:00",1.37,38.27
906,12,0,83,"2002-03-27 04:00:00",1.37,38.32
906,12,0,83,"2002-03-27 05:00:00",1.37,38.38
906,12,0,83,"2002-03-27 06:00:00",1.37,38.56
906,12,0,83,"2002-03-27 07:00:00",1.37,38.63
906,12,0,83,"2002-03-27 08:00:00",1.37,38.69
906,13,0,93,"2002-04-01 08:00:00",21.72,35.47
906,13,0,93,"2002-04-01 09:00:00",23.44,35.29
906,13,0,93,"2002-04-01 10:00:00",23.49,35.25
906,13,0,93,"2002-04-01 11:00:00",21.6,35.52
906,13,0,93,"2002-04-01 12:00:00",20.99,35.6
906,13,0,93,"2002-04-01 13:00:00",17.52,35.73
906,13,0,93,"2002-04-01 14:00:00",16.72,35.8
906,13,0,93,"2002-04-01 15:00:00",16.6,35.84
906,13,0,93,"2002-04-01 16:00:00",15.51,35.9
906,14,0,93,"2002-04-01 08:00:00",11.87,35.46
906,14,0,93,"2002-04-01 09:00:00",12.41,35.44
906,14,0,93,"2002-04-01 10:00:00",12.61,35.47
906,14,0,93,"2002-04-01 11:00:00",12.41,35.44
906,14,0,93,"2002-04-01 12:00:00",12.31,35.46
906,14,0,93,"2002-04-01 13:00:00",11.77,35.47
906,14,0,93,"2002-04-01 14:00:00",11.75,35.42
906,14,0,93,"2002-04-01 15:00:00",11.73,35.44
906,14,0,93,"2002-04-01 16:00:00",11.31,35.4
906,15,0,93,"2002-04-01 08:00:00",10.16,35.13
906,15,0,93,"2002-04-01 09:00:00",10.3,35.14
906,15,0,93,"2002-04-01 10:00:00",10.3,35.14
906,15,0,93,"2002-04-01 11:00:00",10.32,35.19
906,15,0,93,"2002-04-01 12:00:00",10.11,35.09
906,15,0,93,"2002-04-01 13:00:00",10,35.12
906,15,0,93,"2002-04-01 14:00:00",9.98,35.14
906,15,0,93,"2002-04-01 15:00:00",9.93,35.19
906,15,0,93,"2002-04-01 16:00:00",9.84,35.12
906,16,0,93,"2002-04-01 08:00:00",6.95,35.07
906,16,0,93,"2002-04-01 09:00:00",6.95,35.07
906,16,0,93,"2002-04-01 10:00:00",6.91,34.96
906,16,0,93,"2002-04-01 11:00:00",6.95,35.07
906,16,0,93,"2002-04-01 12:00:00",6.93,35.09
906,16,0,93,"2002-04-01 13:00:00",6.84,35.02
906,16,0,93,"2002-04-01 14:00:00",6.84,35.02
906,16,0,93,"2002-04-01 15:00:00",6.81,35.04
906,16,0,93,"2002-04-01 16:00:00",6.81,35.03
906,17,0,93,"2002-04-01 08:00:00",2.66,35.91
906,17,0,93,"2002-04-01 09:00:00",2.64,36.02
906,17,0,93,"2002-04-01 10:00:00",2.62,35.95
906,17,0,93,"2002-04-01 11:00:00",2.64,36.02
906,17,0,93,"2002-04-01 12:00:00",2.64,35.93
906,17,0,93,"2002-04-01 13:00:00",2.64,35.93
906,17,0,93,"2002-04-01 14:00:00",2.64,35.92
906,17,0,93,"2002-04-01 15:00:00",2.64,36.01
906,17,0,93,"2002-04-01 16:00:00",2.64,36.01
906,18,0,93,"2002-04-01 08:00:00",1.14,34.22
906,18,0,93,"2002-04-01 09:00:00",1.14,34.22
906,18,0,93,"2002-04-01 10:00:00",1.14,34.22
906,18,0,93,"2002-04-01 11:00:00",1.14,34.22
906,18,0,93,"2002-04-01 12:00:00",1.14,34.22
906,18,0,93,"2002-04-01 13:00:00",1.14,34.22
906,18,0,93,"2002-04-01 14:00:00",1.14,34.22
906,18,0,93,"2002-04-01 15:00:00",1.14,34.22
906,18,0,93,"2002-04-01 16:00:00",1.14,34.31
922,1,0,77,"2003-09-10 16:00:00",16.5,35.28
922,1,0,77,"2003-09-10 17:00:00",16.56,35.29
922,1,0,77,"2003-09-10 18:00:00",16.41,35.29
922,1,0,77,"2003-09-10 19:00:00",16.68,35.31
922,1,0,77,"2003-09-10 20:00:00",17.14,35.29
922,1,0,77,"2003-09-10 21:00:00",16.8,35.27
922,1,0,77,"2003-09-10 22:00:00",16.93,35.28
922,1,0,77,"2003-09-10 23:00:00",16.99,35.29
922,1,0,77,"2003-09-11 00:00:00",17.75,35.39
922,2,0,77,"2003-09-10 16:00:00",11.19,35.13
922,2,0,77,"2003-09-10 17:00:00",11.22,35.1
922,2,0,77,"2003-09-10 18:00:00",11.25,35.07
922,2,0,77,"2003-09-10 19:00:00",11.19,35.13
922,2,0,77,"2003-09-10 20:00:00",11.25,35.15
922,2,0,77,"2003-09-10 21:00:00",11.32,35.09
922,2,0,77,"2003-09-10 22:00:00",11.35,35.13
922,2,0,77,"2003-09-10 23:00:00",11.25,35.07
922,2,0,77,"2003-09-11 00:00:00",11.13,35.12
922,3,0,77,"2003-09-10 16:00:00",9.27,35.13
922,3,0,77,"2003-09-10 17:00:00",9.4,35.15
922,3,0,77,"2003-09-10 18:00:00",9.37,35.11
922,3,0,77,"2003-09-10 19:00:00",9.34,35.14
922,3,0,77,"2003-09-10 20:00:00",9.4,35.08
922,3,0,77,"2003-09-10 21:00:00",9.43,35.12
922,3,0,77,"2003-09-10 22:00:00",9.37,35.11
922,3,0,77,"2003-09-10 23:00:00",9.31,35.1
922,3,0,77,"2003-09-11 00:00:00",9.27,35.13
922,4,0,77,"2003-09-10 16:00:00",6.6,35.01
922,4,0,77,"2003-09-10 17:00:00",6.57,34.96
922,4,0,77,"2003-09-10 18:00:00",6.6,34.93
922,4,0,77,"2003-09-10 19:00:00",6.57,34.96
922,4,0,77,"2003-09-10 20:00:00",6.7,34.99
922,4,0,77,"2003-09-10 21:00:00",6.6,34.93
922,4,0,77,"2003-09-10 22:00:00",6.47,34.98
922,4,0,77,"2003-09-10 23:00:00",6.54,34.91
922,4,0,77,"2003-09-11 00:00:00",6.5,34.95
922,5,0,77,"2003-09-10 16:00:00",2.74,34.72
922,5,0,77,"2003-09-10 17:00:00",2.71,34.74
922,5,0,77,"2003-09-10 18:00:00",2.67,34.7
922,5,0,77,"2003-09-10 19:00:00",2.6,34.77
922,5,0,77,"2003-09-10 20:00:00",2.6,34.77
922,5,0,77,"2003-09-10 21:00:00",2.6,34.77
922,5,0,77,"2003-09-10 22:00:00",2.6,34.77
922,5,0,77,"2003-09-10 23:00:00",2.6,34.77
922,5,0,77,"2003-09-11 00:00:00",2.6,34.77
922,6,0,77,"2003-09-10 16:00:00",1.35,35.65
922,6,0,77,"2003-09-10 17:00:00",1.35,35.65
922,6,0,77,"2003-09-10 18:00:00",1.35,35.65
922,6,0,77,"2003-09-10 19:00:00",1.35,35.65
922,6,0,77,"2003-09-10 20:00:00",1.35,35.65
922,6,0,77,"2003-09-10 21:00:00",1.35,35.65
922,6,0,77,"2003-09-10 22:00:00",1.35,35.65
922,6,0,77,"2003-09-10 23:00:00",1.35,35.65
922,6,0,77,"2003-09-11 00:00:00",1.35,35.65
922,7,0,83,"2003-09-01 00:00:00",28.63,34.81
922,7,0,83,"2003-09-20 00:00:00",18.14,35.27
922,7,0,83,"2003-09-20 01:00:00",18.14,35.27
922,7,0,83,"2003-09-20 02:00:00",18.14,35.27
922,7,0,83,"2003-09-20 03:00:00",18.23,35.25
922,7,0,83,"2003-09-20 04:00:00",18.23,35.25
922,7,0,83,"2003-09-20 05:00:00",18.23,35.25
922,7,0,83,"2003-09-20 06:00:00",18.2,35.28
922,7,0,83,"2003-09-20 07:00:00",18.14,35.33
922,8,0,83,"2003-01-01 01:00:00",19.79,28.86
922,8,0,83,"2003-09-01 00:00:00",19.94,28.75
922,8,0,83,"2003-09-20 00:00:00",19.82,28.77
922,8,0,83,"2003-09-20 01:00:00",20.18,28.75
922,8,0,83,"2003-09-20 02:00:00",20.25,28.77
922,8,0,83,"2003-09-20 03:00:00",20.28,28.75
922,8,0,83,"2003-09-20 04:00:00",19.79,28.79
922,8,0,83,"2003-09-20 05:00:00",19.73,28.78
922,8,0,83,"2003-09-20 06:00:00",19.79,28.79
922,9,0,83,"2003-09-01 00:00:00",2.78,38.71
922,9,0,83,"2003-09-20 00:00:00",2.64,38.69
922,9,0,83,"2003-09-20 01:00:00",2.64,38.69
922,9,0,83,"2003-09-20 02:00:00",2.66,38.66
922,9,0,83,"2003-09-20 03:00:00",2.64,38.69
922,9,0,83,"2003-09-20 04:00:00",2.66,38.66
922,9,0,83,"2003-09-20 05:00:00",2.66,38.66
922,9,0,83,"2003-09-20 06:00:00",2.69,38.63
922,9,0,83,"2003-09-20 07:00:00",2.69,38.63
922,10,0,83,"2003-09-01 00:00:00",2.78,38.71
922,10,0,83,"2003-09-20 00:00:00",2.64,38.69
922,10,0,83,"2003-09-20 01:00:00",2.64,38.69
922,10,0,83,"2003-09-20 02:00:00",2.66,38.66
922,10,0,83,"2003-09-20 03:00:00",2.64,38.69
922,10,0,83,"2003-09-20 04:00:00",2.66,38.66
922,10,0,83,"2003-09-20 05:00:00",2.66,38.66
922,10,0,83,"2003-09-20 06:00:00",2.69,38.63
922,10,0,83,"2003-09-20 07:00:00",2.69,38.63
922,11,0,83,"2003-09-01 00:00:00",1.37,42.6
922,11,0,83,"2003-09-20 00:00:00",1.37,42.01
922,11,0,83,"2003-09-20 01:00:00",1.37,42.01
922,11,0,83,"2003-09-20 02:00:00",1.37,42.01
922,11,0,83,"2003-09-20 03:00:00",1.37,42.01
922,11,0,83,"2003-09-20 04:00:00",1.37,42.01
922,11,0,83,"2003-09-20 05:00:00",1.37,42.1
922,11,0,83,"2003-09-20 06:00:00",1.37,42.1
922,11,0,83,"2003-09-20 07:00:00",1.37,42.1
922,12,0,93,"2003-09-25 12:00:00",26.48,48.02
922,12,0,93,"2003-09-25 13:00:00",26.64,47.85
922,12,0,93,"2003-09-25 14:00:00",27.65,46.82
922,12,0,93,"2003-09-25 15:00:00",28.12,46.35
922,12,0,93,"2003-09-25 16:00:00",28.17,46.3
922,12,0,93,"2003-09-25 17:00:00",28.14,46.33
922,12,0,93,"2003-09-25 18:00:00",28.84,45.65
922,12,0,93,"2003-09-25 19:00:00",28.98,45.52
922,12,0,93,"2003-09-25 20:00:00",29.14,45.36
922,13,0,93,"2003-09-25 12:00:00",11.23,36.14
922,13,0,93,"2003-09-25 13:00:00",11.33,36.19
922,13,0,93,"2003-09-25 14:00:00",11.33,36.19
922,13,0,93,"2003-09-25 15:00:00",11.33,36.19
922,13,0,93,"2003-09-25 16:00:00",11.48,36.2
922,13,0,93,"2003-09-25 17:00:00",11.53,36.22
922,13,0,93,"2003-09-25 18:00:00",11.75,36.22
922,13,0,93,"2003-09-25 19:00:00",11.63,36.2
922,13,0,93,"2003-09-25 20:00:00",11.82,36.23
922,14,0,93,"2003-09-25 12:00:00",9.47,35.28
922,14,0,93,"2003-09-25 13:00:00",9.7,35.28
922,14,0,93,"2003-09-25 14:00:00",9.77,35.28
922,14,0,93,"2003-09-25 15:00:00",9.77,35.28
922,14,0,93,"2003-09-25 16:00:00",9.81,35.31
922,14,0,93,"2003-09-25 17:00:00",9.79,35.26
922,14,0,93,"2003-09-25 18:00:00",9.77,35.29
922,14,0,93,"2003-09-25 19:00:00",9.74,35.31
922,14,0,93,"2003-09-25 20:00:00",9.81,35.25
922,15,0,93,"2003-09-25 12:00:00",6.68,34.79
922,15,0,93,"2003-09-25 13:00:00",6.68,34.87
922,15,0,93,"2003-09-25 14:00:00",6.88,34.83
922,15,0,93,"2003-09-25 15:00:00",6.81,34.89
922,15,0,93,"2003-09-25 16:00:00",6.77,34.86
922,15,0,93,"2003-09-25 17:00:00",6.7,34.85
922,15,0,93,"2003-09-25 18:00:00",6.75,34.81
922,15,0,93,"2003-09-25 19:00:00",6.7,34.85
922,15,0,93,"2003-09-25 20:00:00",6.72,34.91
922,16,0,93,"2003-09-25 12:00:00",2.59,23.38
922,16,0,93,"2003-09-25 13:00:00",2.59,26.76
922,16,0,93,"2003-09-25 14:00:00",2.55,33.29
922,16,0,93,"2003-09-25 15:00:00",2.53,34.02
922,16,0,93,"2003-09-25 16:00:00",2.5,34.84
922,16,0,93,"2003-09-25 17:00:00",2.5,35.11
922,16,0,93,"2003-09-25 18:00:00",2.53,34.02
922,16,0,93,"2003-09-25 19:00:00",2.53,34.2
922,16,0,93,"2003-09-25 20:00:00",2.53,34.29
922,17,0,93,"2003-09-25 12:00:00",1.17,34.03
922,17,0,93,"2003-09-25 13:00:00",1.17,34.03
922,17,0,93,"2003-09-25 14:00:00",1.17,34.03
922,17,0,93,"2003-09-25 15:00:00",1.17,34.03
922,17,0,93,"2003-09-25 16:00:00",1.17,34.03
922,17,0,93,"2003-09-25 17:00:00",1.14,34.14
922,17,0,93,"2003-09-25 18:00:00",1.14,34.05
922,17,0,93,"2003-09-25 19:00:00",1.14,34.05
922,17,0,93,"2003-09-25 20:00:00",1.14,34.05
938,1,0,77,"2004-10-18 19:00:00",10.71,35.22
938,1,0,77,"2004-10-18 20:00:00",10.71,35.22
938,1,0,77,"2004-10-18 21:00:00",10.56,35.23
938,1,0,77,"2004-10-18 22:00:00",10.71,35.22
938,1,0,77,"2004-10-18 23:00:00",10.75,35.19
938,1,0,77,"2004-10-19 00:00:00",10.75,35.19
938,1,0,77,"2004-10-19 01:00:00",10.75,35.19
938,1,0,77,"2004-10-19 02:00:00",10.75,35.19
938,1,0,77,"2004-10-19 03:00:00",10.75,35.19
938,2,0,77,"2004-10-18 19:00:00",9.24,35.16
938,2,0,77,"2004-10-18 20:00:00",9.21,35.19
938,2,0,77,"2004-10-18 21:00:00",9.24,35.16
938,2,0,77,"2004-10-18 22:00:00",9.24,35.16
938,2,0,77,"2004-10-18 23:00:00",9.27,35.13
938,2,0,77,"2004-10-19 00:00:00",9.24,35.16
938,2,0,77,"2004-10-19 01:00:00",9.27,35.13
938,2,0,77,"2004-10-19 02:00:00",9.24,35.16
938,2,0,77,"2004-10-19 03:00:00",9.21,35.04
938,3,0,77,"2004-10-18 19:00:00",2.6,34.58
938,3,0,77,"2004-10-18 20:00:00",2.6,34.49
938,3,0,77,"2004-10-18 21:00:00",2.6,34.58
938,3,0,77,"2004-10-18 22:00:00",2.6,34.58
938,3,0,77,"2004-10-18 23:00:00",2.6,34.58
938,3,0,77,"2004-10-19 00:00:00",2.62,34.55
938,3,0,77,"2004-10-19 01:00:00",2.6,34.58
938,3,0,77,"2004-10-19 02:00:00",2.58,34.51
938,3,0,77,"2004-10-19 03:00:00",2.6,34.58
938,4,0,77,"2004-10-18 19:00:00",2.6,34.58
938,4,0,77,"2004-10-18 20:00:00",2.6,34.49
938,4,0,77,"2004-10-18 21:00:00",2.6,34.58
938,4,0,77,"2004-10-18 22:00:00",2.6,34.58
938,4,0,77,"2004-10-18 23:00:00",2.6,34.58
938,4,0,77,"2004-10-19 00:00:00",2.62,34.55
938,4,0,77,"2004-10-19 01:00:00",2.6,34.58
938,4,0,77,"2004-10-19 02:00:00",2.58,34.51
938,4,0,77,"2004-10-19 03:00:00",2.6,34.58
938,5,0,77,"2004-10-18 20:00:00",1.35,38.02
938,5,0,77,"2004-10-18 21:00:00",1.35,38.02
938,5,0,77,"2004-10-18 22:00:00",1.35,38.11
938,5,0,77,"2004-10-18 23:00:00",1.35,38.11
938,5,0,77,"2004-10-19 00:00:00",1.35,38.11
938,5,0,77,"2004-10-19 01:00:00",1.35,38.11
938,5,0,77,"2004-10-19 02:00:00",1.35,38.11
938,5,0,77,"2004-10-19 03:00:00",1.35,38.11
938,5,0,77,"2004-10-19 04:00:00",1.35,38.11
938,6,0,83,"2004-10-26 18:00:00",14.78,34.11
938,6,0,83,"2004-10-26 19:00:00",14.71,34.18
938,6,0,83,"2004-10-26 20:00:00",15.51,34.01
938,6,0,83,"2004-10-26 21:00:00",15.58,33.94
938,6,0,83,"2004-10-26 22:00:00",16.78,33.89
938,6,0,83,"2004-10-26 23:00:00",16.43,33.93
938,6,0,83,"2004-10-27 00:00:00",17.55,33.75
938,6,0,83,"2004-10-27 01:00:00",16.12,34
938,6,0,83,"2004-10-27 02:00:00",15.09,34.11
938,7,0,83,"2004-10-26 18:00:00",10.42,35.5
938,7,0,83,"2004-10-26 19:00:00",10.42,35.5
938,7,0,83,"2004-10-26 20:00:00",10.4,35.45
938,7,0,83,"2004-10-26 21:00:00",10.59,35.49
938,7,0,83,"2004-10-26 22:00:00",10.54,35.46
938,7,0,83,"2004-10-26 23:00:00",10.47,35.46
938,7,0,83,"2004-10-27 00:00:00",10.49,35.44
938,7,0,83,"2004-10-27 01:00:00",10.45,35.48
938,7,0,83,"2004-10-27 02:00:00",10.49,35.44
938,8,0,83,"2004-10-26 18:00:00",9.06,35.05
938,8,0,83,"2004-10-26 19:00:00",9.08,35.03
938,8,0,83,"2004-10-26 20:00:00",9.15,35.04
938,8,0,83,"2004-10-26 21:00:00",9.17,35.02
938,8,0,83,"2004-10-26 22:00:00",9.15,35.04
938,8,0,83,"2004-10-26 23:00:00",9.15,35.04
938,8,0,83,"2004-10-27 00:00:00",9.1,35.01
938,8,0,83,"2004-10-27 01:00:00",9.1,35.01
938,8,0,83,"2004-10-27 02:00:00",9.04,35.08
938,9,0,83,"2004-10-26 19:00:00",2.48,39.11
938,9,0,83,"2004-10-26 20:00:00",2.45,39.14
938,9,0,83,"2004-10-26 21:00:00",2.45,39.14
938,9,0,83,"2004-10-26 22:00:00",2.45,39.14
938,9,0,83,"2004-10-26 23:00:00",2.43,39.07
938,9,0,83,"2004-10-27 00:00:00",2.41,39.1
938,9,0,83,"2004-10-27 01:00:00",2.45,39.14
938,9,0,83,"2004-10-27 02:00:00",2.45,39.14
938,9,0,83,"2004-10-27 03:00:00",2.45,39.14
938,10,0,83,"2004-10-26 19:00:00",1.37,43.3
938,10,0,83,"2004-10-26 20:00:00",1.37,43.29
938,10,0,83,"2004-10-26 21:00:00",1.37,43.28
938,10,0,83,"2004-10-26 22:00:00",1.37,43.38
938,10,0,83,"2004-10-26 23:00:00",1.37,43.38
938,10,0,83,"2004-10-27 00:00:00",1.37,43.38
938,10,0,83,"2004-10-27 01:00:00",1.37,43.38
938,10,0,83,"2004-10-27 02:00:00",1.37,43.47
938,10,0,83,"2004-10-27 03:00:00",1.37,43.47
938,11,0,93,"2004-11-07 12:00:00",11.27,-9999.99
938,11,0,93,"2004-11-07 13:00:00",11.08,-9999.99
938,11,0,93,"2004-11-07 14:00:00",11.13,-9999.99
938,11,0,93,"2004-11-07 15:00:00",11.06,-9999.99
938,11,0,93,"2004-11-07 16:00:00",11.08,-9999.99
938,11,0,93,"2004-11-07 17:00:00",11.1,-9999.99
938,11,0,93,"2004-11-07 18:00:00",11.2,-9999.99
938,11,0,93,"2004-11-07 19:00:00",11.06,-9999.99
938,11,0,93,"2004-11-07 20:00:00",11.01,-9999.99
938,12,0,93,"2004-11-07 12:00:00",10.18,35.33
938,12,0,93,"2004-11-07 13:00:00",10.14,35.36
938,12,0,93,"2004-11-07 14:00:00",10.14,35.36
938,12,0,93,"2004-11-07 15:00:00",10.14,35.36
938,12,0,93,"2004-11-07 16:00:00",10.14,35.36
938,12,0,93,"2004-11-07 17:00:00",10.14,35.36
938,12,0,93,"2004-11-07 18:00:00",10.14,35.36
938,12,0,93,"2004-11-07 19:00:00",10.11,35.38
938,12,0,93,"2004-11-07 20:00:00",10.11,35.38
938,13,0,93,"2004-11-07 12:00:00",6.61,35.18
938,13,0,93,"2004-11-07 13:00:00",6.57,35.14
938,13,0,93,"2004-11-07 14:00:00",6.52,35.1
938,13,0,93,"2004-11-07 15:00:00",6.5,35.21
938,13,0,93,"2004-11-07 16:00:00",6.47,35.15
938,13,0,93,"2004-11-07 17:00:00",6.47,35.15
938,13,0,93,"2004-11-07 18:00:00",6.47,35.15
938,13,0,93,"2004-11-07 19:00:00",6.5,35.12
938,13,0,93,"2004-11-07 20:00:00",6.43,35.11
938,14,0,93,"2004-11-07 12:00:00",2.75,-9999.99
938,14,0,93,"2004-11-07 13:00:00",2.75,-9999.99
938,14,0,93,"2004-11-07 14:00:00",2.75,-9999.99
938,14,0,93,"2004-11-07 15:00:00",2.75,-9999.99
938,14,0,93,"2004-11-07 16:00:00",2.75,-9999.99
938,14,0,93,"2004-11-07 17:00:00",2.75,-9999.99
938,14,0,93,"2004-11-07 18:00:00",2.73,-9999.99
938,14,0,93,"2004-11-07 19:00:00",2.68,-9999.99
938,14,0,93,"2004-11-07 20:00:00",2.66,-9999.99
938,15,0,93,"2004-11-07 12:00:00",1.14,33.88
938,15,0,93,"2004-11-07 13:00:00",1.14,33.78
938,15,0,93,"2004-11-07 14:00:00",1.14,33.96
938,15,0,93,"2004-11-07 15:00:00",1.14,33.96
938,15,0,93,"2004-11-07 16:00:00",1.14,33.61
938,15,0,93,"2004-11-07 17:00:00",1.14,32.8
938,15,0,93,"2004-11-07 18:00:00",1.14,33.87
938,15,0,93,"2004-11-07 19:00:00",1.14,-9999.99
938,15,0,93,"2004-11-07 20:00:00",1.12,-9999.99
958,1,0,77,"2006-09-27 13:00:00",10.53,35.07
958,1,0,77,"2006-09-27 14:00:00",10.4,35.06
958,1,0,77,"2006-09-27 15:00:00",10.35,35.1
958,1,0,77,"2006-09-27 16:00:00",10.53,35.14
958,1,0,77,"2006-09-27 17:00:00",10.46,35.14
958,1,0,77,"2006-09-27 18:00:00",10.56,35.12
958,1,0,77,"2006-09-27 19:00:00",10.42,35.11
958,1,0,77,"2006-09-27 20:00:00",10.23,35.13
958,1,0,77,"2006-09-27 21:00:00",10.19,35.11
958,2,0,77,"2006-09-27 13:00:00",9.63,35.32
958,2,0,77,"2006-09-27 14:00:00",9.68,35.35
958,2,0,77,"2006-09-27 15:00:00",9.65,35.37
958,2,0,77,"2006-09-27 16:00:00",9.63,35.39
958,2,0,77,"2006-09-27 17:00:00",9.63,35.32
958,2,0,77,"2006-09-27 18:00:00",9.79,35.38
958,2,0,77,"2006-09-27 19:00:00",9.63,35.39
958,2,0,77,"2006-09-27 20:00:00",9.68,35.34
958,2,0,77,"2006-09-27 21:00:00",9.7,35.39
958,3,0,77,"2006-09-27 13:00:00",8.05,35.15
958,3,0,77,"2006-09-27 14:00:00",7.91,35.13
958,3,0,77,"2006-09-27 15:00:00",7.77,35.11
958,3,0,77,"2006-09-27 16:00:00",7.82,35.14
958,3,0,77,"2006-09-27 17:00:00",7.84,35.12
958,3,0,77,"2006-09-27 18:00:00",7.91,35.12
958,3,0,77,"2006-09-27 19:00:00",7.98,35.05
958,3,0,77,"2006-09-27 20:00:00",7.82,35.14
958,3,0,77,"2006-09-27 21:00:00",7.68,35.04
958,4,0,77,"2006-09-27 13:00:00",6.43,0.77
958,4,0,77,"2006-09-27 14:00:00",6.54,0.77
958,4,0,77,"2006-09-27 15:00:00",6.54,0.77
958,4,0,77,"2006-09-27 16:00:00",6.54,0.77
958,4,0,77,"2006-09-27 17:00:00",6.54,0.77
958,4,0,77,"2006-09-27 18:00:00",6.54,0.77
958,4,0,77,"2006-09-27 19:00:00",6.56,0.77
958,4,0,77,"2006-09-27 20:00:00",6.61,0.77
958,4,0,77,"2006-09-27 21:00:00",6.54,0.77
958,5,0,77,"2006-09-27 13:00:00",2.69,0.06
958,5,0,77,"2006-09-27 14:00:00",2.69,0.06
958,5,0,77,"2006-09-27 15:00:00",2.6,0.06
958,5,0,77,"2006-09-27 16:00:00",2.64,0.06
958,5,0,77,"2006-09-27 17:00:00",2.69,0.06
958,5,0,77,"2006-09-27 18:00:00",2.74,0.06
958,5,0,77,"2006-09-27 19:00:00",2.74,0.06
958,5,0,77,"2006-09-27 20:00:00",2.74,0.06
958,5,0,77,"2006-09-27 21:00:00",2.71,0.06
958,6,0,77,"2006-09-27 13:00:00",1.35,35.87
958,6,0,77,"2006-09-27 14:00:00",1.35,35.96
958,6,0,77,"2006-09-27 15:00:00",1.35,35.96
958,6,0,77,"2006-09-27 16:00:00",1.35,35.96
958,6,0,77,"2006-09-27 17:00:00",1.35,35.96
958,6,0,77,"2006-09-27 18:00:00",1.35,35.96
958,6,0,77,"2006-09-27 19:00:00",1.35,35.96
958,6,0,77,"2006-09-27 20:00:00",1.35,35.96
958,6,0,77,"2006-09-27 21:00:00",1.35,35.96
958,7,0,83,"2006-09-21 14:00:00",11.4,0.68
958,7,0,83,"2006-09-21 15:00:00",11.33,0.68
958,7,0,83,"2006-09-21 16:00:00",11.33,0.68
958,7,0,83,"2006-09-21 17:00:00",11.3,0.68
958,7,0,83,"2006-09-21 18:00:00",11.37,0.68
958,7,0,83,"2006-09-21 19:00:00",11.58,0.68
958,7,0,83,"2006-09-21 20:00:00",11.54,0.68
958,7,0,83,"2006-09-21 21:00:00",11.54,0.68
958,7,0,83,"2006-09-21 22:00:00",11.47,0.68
958,8,0,83,"2006-09-21 14:00:00",9.01,35.4
958,8,0,83,"2006-09-21 15:00:00",9.11,35.47
958,8,0,83,"2006-09-21 16:00:00",9.08,35.42
958,8,0,83,"2006-09-21 17:00:00",9.08,35.41
958,8,0,83,"2006-09-21 18:00:00",9.08,35.42
958,8,0,83,"2006-09-21 19:00:00",9.11,35.47
958,8,0,83,"2006-09-21 20:00:00",9.15,35.43
958,8,0,83,"2006-09-21 21:00:00",9.13,35.45
958,8,0,83,"2006-09-21 22:00:00",9.15,35.43
958,9,0,83,"2006-09-21 14:00:00",11.6,30.27
958,9,0,83,"2006-09-21 15:00:00",11.92,30.23
958,9,0,83,"2006-09-21 16:00:00",11.92,30.3
958,9,0,83,"2006-09-21 17:00:00",11.67,30.22
958,9,0,83,"2006-09-21 18:00:00",11.74,0.09
958,9,0,83,"2006-09-21 19:00:00",11.67,0.09
958,9,0,83,"2006-09-21 20:00:00",11.83,0.09
958,9,0,83,"2006-09-21 21:00:00",11.94,0.09
958,9,0,83,"2006-09-21 22:00:00",11.94,0.09
958,10,0,83,"2006-09-21 14:00:00",2.62,39.35
958,10,0,83,"2006-09-21 15:00:00",2.66,39.3
958,10,0,83,"2006-09-21 16:00:00",2.62,39.35
958,10,0,83,"2006-09-21 17:00:00",2.64,39.32
958,10,0,83,"2006-09-21 18:00:00",2.66,39.3
958,10,0,83,"2006-09-21 19:00:00",2.66,39.3
958,10,0,83,"2006-09-21 20:00:00",2.73,39.3
958,10,0,83,"2006-09-21 21:00:00",2.76,39.27
958,10,0,83,"2006-09-21 22:00:00",2.73,39.3
958,11,0,83,"2006-09-21 14:00:00",1.39,41.72
958,11,0,83,"2006-09-21 15:00:00",1.39,41.72
958,11,0,83,"2006-09-21 16:00:00",1.37,41.84
958,11,0,83,"2006-09-21 17:00:00",1.39,41.81
958,11,0,83,"2006-09-21 18:00:00",1.39,41.9
958,11,0,83,"2006-09-21 19:00:00",1.39,41.9
958,11,0,83,"2006-09-21 20:00:00",1.39,41.9
958,11,0,83,"2006-09-21 21:00:00",1.39,41.9
958,11,0,83,"2006-09-21 22:00:00",1.39,42
4020,1,0,93,"2006-09-15 18:00:00",9.91,35.44
4020,1,0,93,"2006-09-15 19:00:00",9.91,35.51
4020,1,0,93,"2006-09-15 20:00:00",9.88,35.46
4020,1,0,93,"2006-09-15 21:00:00",9.77,35.5
4020,1,0,93,"2006-09-15 22:00:00",9.77,35.5
4020,1,0,93,"2006-09-15 23:00:00",9.77,35.5
4020,1,0,93,"2006-09-16 00:00:00",9.77,35.5
4020,1,0,93,"2006-09-16 01:00:00",9.88,35.46
4020,1,0,93,"2006-09-16 02:00:00",9.86,35.48
4020,2,0,93,"2006-09-15 18:00:00",2.5,42.25
4020,2,0,93,"2006-09-15 19:00:00",2.53,42.22
4020,2,0,93,"2006-09-15 20:00:00",2.53,42.22
4020,2,0,93,"2006-09-15 21:00:00",2.53,42.22
4020,2,0,93,"2006-09-15 22:00:00",2.53,42.22
4020,2,0,93,"2006-09-15 23:00:00",2.57,42.16
4020,2,0,93,"2006-09-16 00:00:00",2.59,42.13
4020,2,0,93,"2006-09-16 01:00:00",2.59,42.13
4020,2,0,93,"2006-09-16 02:00:00",2.59,42.14
4020,3,0,93,"2006-09-15 18:00:00",1.14,0.18
4020,3,0,93,"2006-09-15 19:00:00",1.14,0.18
4020,3,0,93,"2006-09-15 20:00:00",1.14,0.18
4020,3,0,93,"2006-09-15 21:00:00",1.14,0.18
4020,3,0,93,"2006-09-15 22:00:00",1.14,0.18
4020,3,0,93,"2006-09-15 23:00:00",1.14,0.18
4020,3,0,93,"2006-09-16 00:00:00",1.12,0.18
4020,3,0,93,"2006-09-16 01:00:00",1.14,0.18
4020,3,0,93,"2006-09-16 02:00:00",1.14,0.18
$ wc -l test.csv
730 test.csv
$ head -1 test.csv
"pkey1","pkey2","LATITUDE","LONGITUDE","ST_DATE","TEMP","SALT"
$ cut -d',' -f1,2,3,4 test.csv | sort -un | wc -l
82
$ cut -d',' -f1,2,3,4 test.csv | sort -un | head -10
"pkey1","pkey2","LATITUDE","LONGITUDE"
869,1,0,93
869,2,0,93
869,3,0,93
869,4,0,93
869,5,0,93
869,6,0,93
884,1,0,83
884,2,0,83
884,3,0,83
$ ferret
NOAA/PMEL TMAP
FERRET v6.96
Linux 2.6.32-573.7.1.el6.x86_64 64-bit - 12/02/15
2-Dec-16 17:52
yes? columns/skip=1/format=delim/delim="\,"/type="numeric,numeric,numeric,numeric,text,numeric,numeric"/var="pkey1,pkey2,latitude,longitude,st_date,temp,salt" test.csv
yes? sh d
currently SET data sets:
1> ./test.csv (default)
name title I J K L M N
PKEY1 PKEY1 1:730 ... ... ... ... ...
PKEY2 PKEY2 1:730 ... ... ... ... ...
LATITUDE LATITUDE 1:730 ... ... ... ... ...
LONGITUDE
LONGITUDE 1:730 ... ... ... ... ...
ST_DATE ST_DATE 1:730 ... ... ... ... ...
TEMP TEMP 1:730 ... ... ... ... ...
SALT SALT 1:730 ... ... ... ... ...
yes?
I would like to make grid such a way that, when I type "sh d", I want to see like this, since my data is not uniformly spaced, I want to keep in 'M' as string only
yes? sh d
currently SET data sets:
1> ./test.csv (default)
name title I J K L M N
PKEY1 PKEY1 1:82 ... ... ... ... ...
PKEY2 PKEY2 1:82 ... ... ... ... ...
LATITUDE LATITUDE 1:82 ... ... ... ... ...
LONGITUDE
LONGITUDE 1:82 ... ... ... ... ...
ST_DATE ST_DATE 1:82 ... ... ... 1:maxlength ...
TEMP TEMP 1:82 ... ... ... 1:maxlength ...
SALT SALT 1:82 ... ... ... 1:maxlength ...
If I list like this, it should show no of records = maxlength, something like below
list/i=1 st_date,temp,salt
DATA SET: ./test.csv
X: 0.5 to 8.5
Column 1: ST_DATE
Column 2: TEMP
Column 3: SALT
ST_DATE TEMP SALT
1 / 1: "2000-02-13 17:00:00" 14.37 35.14
2 / 2: "2000-02-13 18:00:00" 15.25 35.09
3 / 3: "2000-02-13 19:00:00" 14.42 35.10
4 / 4: "2000-02-13 20:00:00" 14.37 35.14
5 / 5: "2000-02-13 21:00:00" 14.25 35.12
6 / 6: "2000-02-13 22:00:00" 14.32 35.19
7 / 7: "2000-02-13 23:00:00" 14.37 35.14
maxlength / 8: "2000-02-14 00:00:00" 14.30 35.14
[Thread Prev][Thread Next][Index]
Contact Us
Dept of Commerce /
NOAA /
OAR /
PMEL /
Ferret
Privacy Policy | Disclaimer | Accessibility Statement