Groups > comp.graphics.apps.gnuplot > #451

parsing of alphanumeric columns; plotting fences

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.42!gegeweb.eu!nntpfeed.proxad.net!proxad.net!feeder1-1.proxad.net!198.186.190.251.MISMATCH!news-out.readnews.com!transit4.readnews.com!postnews.google.com!e35g2000yqc.googlegroups.com!not-for-mail
From	derrapf <derrapf@googlemail.com>
Newsgroups	comp.graphics.apps.gnuplot
Subject	parsing of alphanumeric columns; plotting fences
Date	Tue, 19 Jul 2011 04:29:49 -0700 (PDT)
Organization	http://groups.google.com
Lines	39
Message-ID	<e44e6bca-e10c-4de7-ab2f-4e156ad287ac@e35g2000yqc.googlegroups.com> (permalink)
NNTP-Posting-Host	82.210.232.252
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
X-Trace	posting.google.com 1311077439 29492 127.0.0.1 (19 Jul 2011 12:10:39 GMT)
X-Complaints-To	groups-abuse@google.com
NNTP-Posting-Date	Tue, 19 Jul 2011 12:10:39 +0000 (UTC)
Complaints-To	groups-abuse@google.com
Injection-Info	e35g2000yqc.googlegroups.com; posting-host=82.210.232.252; posting-account=7pnSVAkAAAAuOuaNOY21Z45JzPn6wOfx
User-Agent	G2/1.0
X-HTTP-Via	1.1 wipx01.wirtgen.dmz:8080 (squid/2.7.STABLE9)
X-Google-Web-Client	true
X-Google-Header-Order	HUALESRCVFNK
X-HTTP-UserAgent	Mozilla/5.0 (Windows NT 5.1; rv:2.0) Gecko/20100101 Firefox/4.0,gzip(gfe)
Xref	x330-a1.tempe.blueboxinc.net comp.graphics.apps.gnuplot:451

Show key headers only | View raw

Hi alle
Searched a lot but did not find an answer.
May somebody of you has an idea:
I have a data file providing the following tab separated data format:

#date                time          total
2011-06-27        13:19:26    2339
2011-06-27        13:35:50    3322
2011-06-27        13:37:13    2740
2011-06-27        14:19:26    2339

Where "total" should be the z-coordinate, time the x-coordinate, and
date the y-coordinate
I would like to have the totals of each day in a kind of 3D fences
plot, so that I can compare
the totals of each day easily (see also: "fence plot" in
http://www.gnuplot.info/demo/surface1.html).

To manage the x-coordinate from column 2, I set up:

set xdata time
set timefmt "%H:%M:%S"
set format x "%H:%M:%S"

But how can I now extract the day as an y-coordinate from column 1?

My approach to plot some kind of fence was:

splot     "datafile.txt" using 2:$1[9:10]:13:xticlabels(2) with lines

but that did not work. I always get an error:
"internal error: substring range operator applied to non-STRING type"

Would it be easier if I created a separate data-file for each day?
If yes how could I then plot fences of each day?

I appreciate any help

Best regards Ralf

Back to comp.graphics.apps.gnuplot | Previous | Next — Next in thread | Find similar

Thread

parsing of alphanumeric columns; plotting fences derrapf <derrapf@googlemail.com> - 2011-07-19 04:29 -0700
  Re: parsing of alphanumeric columns; plotting fences Hans-Bernhard Bröker <HBBroeker@t-online.de> - 2011-07-19 21:54 +0200
    Re: parsing of alphanumeric columns; plotting fences derrapf <derrapf@googlemail.com> - 2011-07-21 06:02 -0700
      Re: parsing of alphanumeric columns; plotting fences Hans-Bernhard Bröker <HBBroeker@t-online.de> - 2011-07-21 20:24 +0200
        Re: parsing of alphanumeric columns; plotting fences derrapf <derrapf@googlemail.com> - 2011-07-22 16:22 -0700
          Re: parsing of alphanumeric columns; plotting fences Hans-Bernhard Bröker <HBBroeker@t-online.de> - 2011-07-23 15:04 +0200

csiph-web