From: Nick Dokos <nicholas.dokos@hp.com>
To: emacs-orgmode Mode <emacs-orgmode@gnu.org>
Cc: nicholas.dokos@hp.com
Subject: Re: Plotting (with gnuplot) using dates timestamps
Date: Mon, 26 Mar 2012 10:37:12 -0400 [thread overview]
Message-ID: <27136.1332772632@alphaville> (raw)
In-Reply-To: Message from Steven Buczkowski <steven.buczkowski@gmail.com> of "Mon, 26 Mar 2012 10:07:58 EDT." <1332770878.2404.3.camel@ascraeus>
Steven Buczkowski <steven.buczkowski@gmail.com> wrote:
> On Mon, 2012-03-26 at 15:37 +0200, Alan Schmitt wrote:
> > Hello,
> >
> > I'm trying to plot the following table, but the dates part is all wrong. Is there a way to tell gnuplot what the date format is?
> >
> > #+tblname: data-table
> > | Date | HP | HC |
> > |------------------+--------+--------|
> > | [2011-08-20 Sat] | 006815 | 008399 |
> > | [2011-08-29 Mon] | 006840 | 008438 |
> > | [2011-09-11 Sun] | 006946 | 008552 |
> > | [2011-12-11 Sun] | 007805 | 009603 |
> > | [2012-03-04 Sun] | 008800 | 010826 |
> > | [2012-03-11 Sun] | 008876 | 010930 |
> > | [2012-03-25 Sun] | 009015 | 011121 |
> >
>
> In straight gnuplot, I would do something like the following:
>
> gnuplot> set xdata time
> gnuplot> set timefmt '[%Y-%m-%d %a]'
>
The "set xdata time" line is indeed what makes the difference:
without it, gnuplot doesn't know that this is a time series.
But there are some additional details: when babel prepares the
data, the data file that will be fed to gnuplot ends up like this
(not sure this is documented though):
,----
| 2011-08-20-00:00:00 6815 8399
| 2011-08-29-00:00:00 6840 8438
| 2011-09-11-00:00:00 6946 8552
| 2011-12-11-00:00:00 7805 9603
| 2012-03-04-00:00:00 8800 10826
| 2012-03-11-00:00:00 8876 10930
| 2012-03-25-00:00:00 9015 11121
`----
so the script should look something like this:
--8<---------------cut here---------------start------------->8---
reset
set xdata time
set timefmt "%Y-%m-%d-%H:%M:%S"
set format x "%Y-%m-%d"
set xrange ["2011-08-01":"2012-04-01"]
set title "Consumption"
set size ratio square
set xlabel "Date"
set yrange [6800:9100]
set ylabel "HP"
set ytics nomirror
set y2range [8000:12000]
set y2label "HC"
set y2tics nomirror
set style data points
plot data using 1:2 axis x1y1 title 'HP', \
data using 1:3 axis x1y2 title 'HC'
--8<---------------cut here---------------end--------------->8---
BTW, going into gnuplot and saying "help time/date" helps :-)
I have trouble navigating the gnuplot help system, but I think
it is complete.
Nick
next prev parent reply other threads:[~2012-03-26 14:37 UTC|newest]
Thread overview: 157+ messages / expand[flat|nested] mbox.gz Atom feed top
2012-03-26 13:37 Plotting (with gnuplot) using dates timestamps Alan Schmitt
2012-03-26 14:00 ` Allen S. Rout
2012-03-26 14:06 ` Michael Brand
2012-03-26 14:07 ` Steven Buczkowski
[not found] ` <steven.buczkowski@gmail.com>
2012-03-26 14:37 ` Nick Dokos [this message]
2012-03-26 14:59 ` Alan Schmitt
2012-03-26 15:48 ` Karl Voit
2012-03-26 17:02 ` Alan Schmitt
2012-03-26 17:06 ` Karl Voit
2012-03-26 17:11 ` Ian Barton
2012-03-27 7:59 ` Karl Voit
2012-03-30 1:09 ` Mueen Nawaz
-- strict thread matches above, loose matches on Subject: below --
2013-01-18 10:34 Wish: switch active time-stamps to inactive when CANCELED Karl Voit
2013-01-18 11:04 ` Daimrod
2013-01-18 11:08 ` Karl Voit
2013-01-18 11:24 ` Daimrod
2013-01-18 21:22 ` Karl Voit
2013-01-18 21:59 ` Viktor Rosenfeld
2013-01-18 22:50 ` Daimrod
2013-01-20 15:39 ` Karl Voit
2013-01-23 13:18 ` Bastien
2013-01-23 17:21 ` Viktor Rosenfeld
2013-01-24 14:11 ` Bastien
2013-01-18 23:10 ` Samuel Wales
2013-01-26 11:06 ` Bastien
2012-08-26 13:54 comma as decimal point: bug? Rainer Thiel
2012-08-26 20:57 ` Nicolas Goaziou
2012-08-26 21:05 ` Bastien
2012-08-26 21:08 ` Nicolas Goaziou
2012-08-27 16:19 ` Bastien
2012-08-27 15:44 ` Karl Voit
2012-08-26 20:59 ` Bastien
2012-08-27 9:08 ` Rainer Thiel
2012-08-27 12:30 ` AW
2012-08-20 17:03 Replacement for org-make-link Karl Voit
2012-08-19 10:56 What HW/SW issues influence org/Emacs performance? Karl Voit
2012-08-19 11:23 ` Achim Gratz
2012-08-19 16:45 ` Luis Anaya
2012-08-13 21:50 table: referencing row of other table Karl Voit
2012-03-05 14:44 [bug] org-agenda-write does not handle date stamps without day of week Karl Voit
2012-03-16 16:14 ` Karl Voit
2012-03-17 14:04 ` Simon Thum
2012-03-19 9:13 ` Carsten Dominik
2011-10-18 16:52 Recurring events with exceptions Karl Voit
2011-10-18 17:04 ` Brian Wightman
2011-10-18 17:35 ` Karl Voit
2011-10-18 18:15 ` Skip Collins
2011-10-18 18:46 ` Tassilo Horn
2011-10-18 19:57 ` Eric S Fraga
2011-10-19 0:34 ` Skip Collins
2011-10-19 10:02 ` Eric S Fraga
2011-10-21 21:48 ` Skip Collins
2011-10-22 8:38 ` Sync with Outlook/Exchange (was: Recurring events with exceptions) Karl Voit
2011-10-24 7:13 ` Recurring events with exceptions Eric S Fraga
2011-09-30 14:32 How to debug "Specified time is not representable" Karl Voit
2011-09-30 14:52 ` Jambunathan K
2011-10-03 11:50 ` Karl Voit
2011-10-04 7:40 ` Jambunathan K
2011-10-04 11:42 ` Karl Voit
2011-10-04 12:13 ` Carsten Dominik
2011-10-04 11:41 ` Carsten Dominik
2011-10-04 11:47 ` Karl Voit
2011-06-07 15:55 Referencing elemts of a table Karl Voit
2011-06-07 17:22 ` Michael Brand
2011-06-08 0:05 ` kinouchou
2011-06-08 3:54 ` Jambunathan K
2011-06-08 4:25 ` Nick Dokos
2011-06-08 12:49 ` Karl Voit
2011-06-08 13:47 ` Michael Brand
[not found] ` <devnull@Karl-Voit.at>
2011-06-08 13:49 ` Nick Dokos
2011-06-24 14:32 ` org-time-stamp loses repeater interval Karl Voit
2011-06-24 16:08 ` Bernt Hansen
2011-06-24 16:01 ` Nick Dokos
2011-06-24 17:40 ` Michael Brand
2011-06-24 18:00 ` Nick Dokos
2011-06-26 11:30 ` Bug: " Karl Voit
2011-06-27 16:23 ` Bastien
2011-06-28 13:40 ` Karl Voit
2011-06-28 14:28 ` Bastien
2011-06-28 15:04 ` Nick Dokos
2011-06-28 15:13 ` Karl Voit
2011-06-28 15:33 ` Nick Dokos
2011-06-28 16:03 ` Karl Voit
2011-06-28 15:48 ` Bastien
2011-06-28 16:05 ` Karl Voit
2011-06-28 17:27 ` Bastien
2011-06-28 18:43 ` Karl Voit
2011-06-28 23:02 ` Bastien
2011-06-28 23:10 ` Nick Dokos
2011-06-28 23:58 ` Bastien
2011-06-29 1:44 ` Nick Dokos
2011-06-29 7:28 ` Sebastien Vauban
2011-06-29 9:30 ` Bastien
2011-06-29 14:34 ` Nick Dokos
2011-07-02 13:29 ` Bastien
2011-06-29 12:47 ` Karl Voit
2011-07-02 13:26 ` Bastien
2011-07-02 13:26 ` Bastien
2011-09-30 15:31 ` How to debug "Specified time is not representable" Nick Dokos
2011-10-18 17:26 ` Recurring events with exceptions Nick Dokos
2011-10-18 20:38 ` Karl Voit
2012-03-16 17:52 ` [bug] org-agenda-write does not handle date stamps without day of week Nick Dokos
2012-03-16 18:53 ` Karl Voit
2012-03-17 6:45 ` Nick Dokos
2012-03-19 9:12 ` Carsten Dominik
2012-03-20 5:54 ` Carsten Dominik
2012-03-20 12:26 ` Karl Voit
2012-03-20 13:47 ` Carsten Dominik
2012-04-10 17:38 ` Bastien
2012-04-10 17:44 ` Nick Dokos
2012-04-10 18:03 ` Bastien
2012-03-20 13:39 ` Nick Dokos
2012-03-21 16:32 ` Karl Voit
2012-03-21 16:57 ` Carsten Dominik
2012-03-26 16:10 ` Plotting (with gnuplot) using dates timestamps Nick Dokos
2012-08-13 22:27 ` table: referencing row of other table Nick Dokos
2012-08-13 22:44 ` Karl Voit
2012-08-19 12:32 ` What HW/SW issues influence org/Emacs performance? Nick Dokos
2012-08-19 13:04 ` Karl Voit
2012-08-20 17:23 ` Replacement for org-make-link Nick Dokos
2012-08-20 17:54 ` Bastien
2012-08-20 19:29 ` Karl Voit
2012-08-27 16:09 ` comma as decimal point: bug? Nick Dokos
2012-08-27 16:17 ` Karl Voit
2013-01-18 14:07 ` Wish: switch active time-stamps to inactive when CANCELED Nick Dokos
2013-01-18 21:24 ` Karl Voit
2013-01-18 21:59 ` Nick Dokos
2013-01-20 16:05 ` Karl Voit
2013-01-20 18:16 ` Viktor Rosenfeld
2013-01-21 10:18 ` Memnon Anon
2013-01-21 11:39 ` OT: Learning ELISP (was: Wish: switch active time-stamps to inactive when CANCELED) Karl Voit
2013-01-21 21:56 ` OT: Learning ELISP Jonathan Arkell
2013-01-23 14:40 ` Using Org/babel for Emacs config files (was: OT: Learning ELISP) Karl Voit
2013-01-23 15:52 ` Using Org/babel for Emacs config files David Bjergaard
2013-01-23 22:06 ` Using Org/babel for Emacs config files (was: OT: Learning ELISP) Darlan Cavalcante Moreira
2013-01-23 22:32 ` Kyle Machulis
2013-01-24 13:27 ` [OT] open url in emacs was: Re: Using Org/babel for Emacs config files Andreas Leha
2013-01-24 13:29 ` Bastien
2013-01-24 14:13 ` Andreas Leha
2013-01-24 15:19 ` Bastien
2013-01-24 19:48 ` Andreas Leha
2013-01-25 4:48 ` Jambunathan K
2013-01-26 8:34 ` Andreas Leha
2013-01-26 13:05 ` Jambunathan K
2013-01-28 9:41 ` Andreas Leha
2013-01-24 15:18 ` Daimrod
2013-01-24 1:04 ` Thorsten Jolitz
2013-01-24 1:33 ` Thomas S. Dye
2013-01-24 8:42 ` Thorsten Jolitz
2013-01-24 11:36 ` full outline functionality in .el files: how? (was: Re: Using Org/babel for Emacs config files) Gregor Zattler
2013-01-24 12:48 ` full outline functionality in .el files: how? Bastien
2013-01-24 13:40 ` Thorsten Jolitz
2013-01-24 13:46 ` Bastien
2013-01-24 14:17 ` Thorsten Jolitz
2013-01-24 15:57 ` Bastien
2013-01-24 13:36 ` Thorsten Jolitz
2013-01-25 18:08 ` Memnon Anon
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=27136.1332772632@alphaville \
--to=nicholas.dokos@hp.com \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).