Re: org-babel and gnuplot

From: Nick Parker <nickp@developernotes.com>
To: John Hendy <jw.hendy@gmail.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: org-babel and gnuplot
Date: Wed, 8 Sep 2010 19:20:19 -0500	[thread overview]
Message-ID: <AANLkTimQ1WmtCvbPmv+V-idkM0MPx78=33_3VMO2rxA5@mail.gmail.com> (raw)
In-Reply-To: <AANLkTimVLmR3gvTSK9S5CNVeED+aaTrz7RWvVWEh7To1@mail.gmail.com>

[-- Attachment #1.1: Type: text/plain, Size: 6834 bytes --]

John,

Thanks for you're input, I'll give it a whirl.

Nick Parker
www.developernotes.com

On Wed, Sep 8, 2010 at 2:04 PM, John Hendy <jw.hendy@gmail.com> wrote:

> Nick,
>
> How about this?? Just fiddled around a little and wonder what you think.
> There might be a better way, but essentially, I've done the following:
>
> - Left y-axis = distance
> - Right y-axis = time
> - I couldn't get the xtic(1) option to work, so I replaced things with what
> I've found to work x:y:xticlabels(col#)
> - Beefed up the points to make them a little easier to see
> - Used your data to "calibrate" your speed
> --- The left y-axis is from 9-21min
> --- The right y-axis is from 1.5min - 3.5min
> --- This means the axes are 'calibrated' to 10mph
>
> What does the "calibration" do? It means that at a quick glance you can see
> your speed based on a target rate you set:
> - if speed/distance are on top of each other, you're right at your target
> - if speed (green) is higher than distance (red), you were faster than your
> target
> - if speed (green) is lower than distance (red), you were slower than your
> target
>
> Resetting your target is as easy as changing (in the code below):
> - Time: yrange [y1:y2]
> - Distance: y2range [y3:y4]
>
> All you have to do is make sure that y3/y1 = y4/y2 = target speed
>
> Also, remove the references to L/R and Red/Green if you'd like from the
> labels. I just tried to make the labels as easy as possible to follow so
> that no matter where you looked for a reference you would be forced to see
> what color/axis matched what value.
>
> I attached a sample graph. Sorry if I overstepped my bounds -- I realize
> it's *your* workout tracker. Take what you like and ditch the rest. I
> wanted to know how to do two different y axes anyway so it helped me learn.
> Code is here:
>
> ------------------- gnuplot code -----------------------
>
> #+tblname: sessions
> | Date        | ID |  Time | Distance |
> |-------------+----+-------+----------|
> | 9/1/2010    |  1 | 14:00 |      2.4 |
> | 9/2/2010    |  2 | 15:13 |      2.5 |
> | 9/10/2010   |  3 | 13:45 |      2.3 |
> | 9/11        |  4 | 12:20 |      2.0 |
> | Spd > 10mph |  5 | 16:35 |      2.8 |
> | Spd = 10mph |  6 |    10 |    1.666 |
> | Spd < 10mph |  7 |    20 |      2.8 |
>
> #+begin_src gnuplot :var data=sessions :file org-running.png :exports both
>   reset
>   set title "Running Stats"
>   set size ratio square
>
>   set xlabel "Date"
>   set xtics nomirror rotate by -45
>
>   set yrange [9:21]
>   set ylabel "Time (min) -- Red"
>   set ytics nomirror
>
>   set y2range [1.5:3.5]
>   set y2label "Distance (mi) -- Green"
>   set y2tics 0,0.5,3.5
>
>   set style data points
>   plot data u 2:3:xticlabels(1) axis x1y1 lw 3 title 'Time (L axis)', \
>        data u 2:4 axis x2y2 lw 3 title 'Distance (R axis)'
> #+end_src
>
> ------------------- end gnuplot code ---------------------
>
>
> Best regards,
> John
>
> On Wed, Sep 8, 2010 at 11:52 AM, Nick Parker <nickp@developernotes.com>wrote:
>
>> John,
>>
>> I am reworking the gnuplot script, it is not done at this point, but this
>> is what I currently have:
>>
>> #+begin_src gnuplot :var data=sessions :file org-running.png :exports both
>>   set title "Running Stats"
>>   set xtics nomirror rotate by -45
>>   set key noenhanced
>>   set style data linespoints
>>   plot "$data" using 2:xtic(1) title columnheader(1), \
>>   for [i=2:3] '' using i title columnheader(i)
>> #+end_src
>>
>> Nick Parker
>> www.developernotes.com
>>
>>
>> On Wed, Sep 8, 2010 at 9:39 AM, John Hendy <jw.hendy@gmail.com> wrote:
>>
>>> Nick,
>>>
>>>
>>> This got me curious to see the output. I tried to generate it on my
>>> computer and get this in the *gnuplot* buffer after running the code:
>>>
>>> -----
>>> gnuplot> plot data using 1:2:3 notitle
>>>                                ^
>>>          warning: Skipping data file with no valid points
>>>                                       ^
>>>          x range is invalid
>>> -----
>>>
>>> This is working for you, though?
>>>
>>> #+tblname: sessions
>>> | Date       |  Time | Distance |
>>> |------------+-------+----------|
>>> | 09/02/2010 | 15:13 |      2.5 |
>>> | 09/01/2010 | 14:00 |      2.4 |
>>>
>>> #+begin_src gnuplot :var data=sessions :file org-running.png :exports
>>> both
>>>   set title "Running Stats"
>>>   set auto x
>>>   set style data histogram
>>>   set style fill solid border -1
>>>   set boxwidth .9
>>>   set xlabel "Date"
>>>   set ylabel "Time"
>>>   plot data using 1:2:3 notitle
>>> #+end_src
>>>
>>>
>>> John
>>>
>>> On Wed, Sep 8, 2010 at 8:10 AM, Nick Parker <nickp@developernotes.com>wrote:
>>>
>>>> Erik,
>>>>
>>>> That was the issue, the :file reference needed to be on the line above.
>>>>  Thanks.
>>>>
>>>>
>>>> Nick Parker
>>>> www.developernotes.com
>>>>
>>>>
>>>> On Tue, Sep 7, 2010 at 10:27 PM, Erik Iverson <eriki@ccbr.umn.edu>wrote:
>>>>
>>>>> On 09/07/2010 10:12 PM, Nick Parker wrote:
>>>>>
>>>>>> Hi John,
>>>>>>
>>>>>> I would actually like to plot different lines per distance, each
>>>>>> that correlate to a date and elapsed-time (x and y axis respectively).
>>>>>>  I get an error with the :file notation, though I read that in a
>>>>>> sample
>>>>>> babel gnuplot example for generating graphs of commit history on the
>>>>>> org-mode git repository.  I tried to reference the variable data
>>>>>> without
>>>>>> the quotes and $ sign without any success.  I will continue to fiddle
>>>>>> with it, I am new to gnuplot.
>>>>>>
>>>>>
>>>>> AFAIK, you can't break source code header argument lines across
>>>>> multiple lines.  Is that how you actually have it in your
>>>>> org file?
>>>>>
>>>>>
>>>>>         #+begin_src gnuplot :var data=sessions
>>>>>>           :file org-running.png :exports both
>>>>>>           set title "Running Stats"
>>>>>>           set auto x
>>>>>>           set style data histogram
>>>>>>           set style fill solid border -1
>>>>>>           set boxwidth .9
>>>>>>           set xlabel "Date"
>>>>>>           set ylabel "Time"
>>>>>>           plot "$data" using 1:2:3 notitle
>>>>>>        #+end_src
>>>>>>
>>>>>>        Nick Parker
>>>>>>        www.developernotes.com <http://www.developernotes.com>
>>>>>>
>>>>>>
>>>>>>        _______________________________________________
>>>>>>        Emacs-orgmode mailing list
>>>>>>        Please use `Reply All' to send replies to the list.
>>>>>>        Emacs-orgmode@gnu.org <mailto:Emacs-orgmode@gnu.org>
>>>>>>
>>>>>>        http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Emacs-orgmode mailing list
>>>>>> Please use `Reply All' to send replies to the list.
>>>>>> Emacs-orgmode@gnu.org
>>>>>> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>

[-- Attachment #1.2: Type: text/html, Size: 10529 bytes --]

[-- Attachment #2: Type: text/plain, Size: 201 bytes --]

_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode