Good morning!
I've got some problems parsing a CSV file with Gnuplot 4.2.3.
Example data:
"Date","muxping augds01 (ms)",,,,,"muxping fhids01 (ms)",,,,,"muxping
svnds01 (ms)",,,,,"dspstat -n 10 augds01 (ms)",,,,,"dspstat -n 10 fhids01
(ms)",,,,,"dspstat -n 10 svnds01 (ms)",,,,
"Date","Average","# Peaks","# Peaks >1min","# Peaks >2min","# Peaks
>3min","Average","# Peaks","# Peaks >1min","# Peaks >2min","# Peaks
>3min","Average","# Peaks","# Peaks >1min","# Peaks >2min","# Peaks
>3min","Average","# Peaks","# Peaks >1min","# Peaks >2min","# Peaks
>3min","Average","# Peaks","# Peaks >1min","# Peaks >2min","# Peaks
>3min","Average","# Peaks","# Peaks >1min","# Peaks >2min","# Peaks >3min"
16.07.2008
00:00,80.09,2,0,0,0,182.63,1,0,0,0,66.73,0,0,0,0,741.27,0,0,0,0,1848.84,2,0,0,0,632.38,0,0,0,0
16.07.2008
01:00,50.13,5,0,0,0,187.32,3,0,0,0,39,4,0,0,0,506.75,23,1,1,1,1764.85,3,0,0,0,417.9,5,1,0,0
16.07.2008
02:00,52.63,12,2,0,0,157.7,1,0,0,0,40.65,5,1,0,0,527.12,21,2,1,1,1571.17,3,0,0,0,442.22,3,1,0,0
16.07.2008
03:00,54.19,3,0,0,0,170.36,2,0,0,0,40.41,6,0,1,0,549.81,11,2,0,0,1579.5,1,0,0,0,412.34,6,0,0,1
16.07.2008
04:00,53.5,7,0,0,0,154.1,1,0,0,0,41.28,3,0,0,0,545.08,6,1,0,0,1594.57,1,0,0,0,414.9,6,1,0,0
16.07.2008
05:00,51.78,1,0,0,0,164.77,4,0,0,0,42.45,6,0,0,0,533.4,3,0,0,0,1705.83,3,0,0,0,418.38,8,2,1,0
I want to graph columns 27 and 28. Or, for a start, just col. 27.
I did:
set ylabel "ms"
set y2label "# Peaks"
set xdata time
set format x "%d.%m.%y\n%H:%M"
set datafile separator ","
set yrange [0:*]
set y2range [0:*]
set xlabel "Zeitpunkt"
set y2tics
set ytics nomirror
set timefmt "%d.%m.%Y %H:%M"
plot "values.csv" using 1:27 title 27 axes x1y1 with linespoints
But, when run in interactive mode, I get:
gnuplot> set timefmt "%d.%m.%Y %H:%M"
gnuplot> plot "values.csv" using 1:27 title 27 axes x1y1 with linespoints
"Date","Average","# Peaks","# Peaks >1min","# Peaks >2min","# Peaks
>3min","A...
values.csv:2: illegal day of month
Is the problem, that I have 2 header lines in my CSV file?
"Date","muxping augds01 (ms)",,,,,"muxping fhids01 (ms)",,,,,"muxping
svnds01 (ms)",,,,,"dspstat -n 10 augds01 (ms)",,,,,"dspstat -n 10 fhids01
(ms)",,,,,"dspstat -n 10 svnds01 (ms)",,,,
"Date","Average","# Peaks","# Peaks >1min","# Peaks >2min","# Peaks
>3min","Average","# Peaks","# Peaks >1min","# Peaks >2min","# Peaks
>3min","Average","# Peaks","# Peaks >1min","# Peaks >2min","# Peaks
>3min","Average","# Peaks","# Peaks >1min","# Peaks >2min","# Peaks
>3min","Average","# Peaks","# Peaks >1min","# Peaks >2min","# Peaks
>3min","Average","# Peaks","# Peaks >1min","# Peaks >2min","# Peaks >3min"
Best regards,
Michael
|
