emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Achim Gratz <Stromeko@nexgo.de>
To: emacs-orgmode@gnu.org
Subject: Re: using gnuplot's "splot" and "every" commands on org-mode table data
Date: Thu, 09 May 2013 22:23:58 +0200	[thread overview]
Message-ID: <87y5bngaw1.fsf@Rainer.invalid> (raw)
In-Reply-To: 87zjw4xqhr.fsf@ucl.ac.uk

Eric S Fraga writes:
> At present, there is no mechanism for selective deletion of these line
> separators upon export (that I know of: I would be happy to be corrected
> on this!).  For the paper I submitted last week for publication, the
> only post-org editing I had to do was delete a number \hline
> specifications in the exported LaTeX file.  Not a major problem,
> obviously, but it would be nice to not have to do even that!

Seems to me that one of the variants below would do what you wanted:

--8<---------------cut here---------------start------------->8---
* Example table with multiple lines

** Data :noexport:
  #+NAME: raw-table
  |   | Strategy | Average performance |
  |---+----------+---------------------|
  | / |          |                8.69 |
  | / |          |                9.72 |
  | / |          |                9.03 |
  |---+----------+---------------------|
  |   |        1 |                9.15 |
  |---+----------+---------------------|
  | / |          |                9.15 |
  | / |          |                7.60 |
  | / |          |                7.46 |
  |---+----------+---------------------|
  |   |        2 |                8.07 |
  |---+----------+---------------------|
  #+TBLFM: @5$3=vmean(@-I..@-II);%.2f::@9$3=vmean(@-I..@-II);%.2f

** Results

#+BEGIN_SRC elisp :var table=raw-table :colnames yes :exports results
table
#+END_SRC

#+RESULTS:
|   | Strategy | Average performance |
|---+----------+---------------------|
| / |          |                8.69 |
| / |          |                9.72 |
| / |          |                9.03 |
|   |        1 |                9.15 |
| / |          |                9.15 |
| / |          |                 7.6 |
| / |          |                7.46 |
|   |        2 |                8.07 |

#+BEGIN_SRC elisp :var table=raw-table :hlines yes :exports results
  (delq nil
        (let (hl)
          (mapcar (lambda (tl)
                    (if (listp tl)
                        (unless (equal (car tl) "/")
                          (cdr tl))
                      (unless hl
                        (setq hl t)
                        tl)))
                      table)))
#+END_SRC

#+RESULTS:
| Strategy | Average performance |
|----------+---------------------|
|        1 |                9.15 |
|        2 |                8.07 |

--8<---------------cut here---------------end--------------->8---


> Maybe there is a need for three different line separators: ~ for headers
> (to be used as Achim indicates above but possibly helpful for exporters
> as well), = for lines that should appear in exported output and - for
> those that will not appear.  Header lines would typically export as
> well.  All three would be used for formula definitions (i.e. @I
> references) but would solely differ in how they are processed by the
> exporters.

We should keep "---" as lines to be exported and perhaps use ":::" for
those that are just introducing convenience for table calculations as
"===" looks far too heavy to me for that purpose.


Regards,
Achim.
-- 
+<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+

SD adaptation for Waldorf microQ V2.22R2:
http://Synth.Stromeko.net/Downloads.html#WaldorfSDada

  reply	other threads:[~2013-05-09 20:24 UTC|newest]

Thread overview: 34+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2013-05-01 14:39 using gnuplot's "splot" and "every" commands on org-mode table data Paul Stansell
2013-05-03 16:09 ` Eric Schulte
2013-05-06 18:57   ` Achim Gratz
2013-05-09 12:54     ` Eric S Fraga
2013-05-09 20:23       ` Achim Gratz [this message]
2013-05-09 20:42         ` Eric S Fraga
2013-05-11 10:39           ` Achim Gratz
2013-05-11 12:20             ` Rick Frankel
2013-05-21 12:36             ` Eric S Fraga
2013-05-07 17:14   ` Paul Stansell
2013-05-07 18:25     ` Eric Schulte
2013-05-07 18:39       ` Paul Stansell
2013-05-08 12:46         ` Eric Schulte
2013-05-08 15:48           ` Paul Stansell
2013-05-13 21:43             ` Eric Schulte
2013-05-17 15:00               ` Eric Schulte
2013-05-17 20:18                 ` Paul Stansell
2013-05-17 20:39                   ` Eric Schulte
2013-05-17 21:33                     ` Paul Stansell
2013-08-30 17:16                       ` Paul Stansell
2013-08-30 19:13                         ` Achim Gratz
2013-05-07 18:19   ` Paul Stansell
2013-05-08 12:41     ` Eric Schulte
2013-05-08 16:00       ` Paul Stansell
2013-05-12 18:55       ` Achim Gratz
2013-05-13 21:38         ` Eric Schulte
2013-05-14  7:06           ` Achim Gratz
2014-03-25 18:42           ` Achim Gratz
2013-05-11 10:51   ` Achim Gratz
2013-09-23 14:54   ` Paul Stansell
2013-09-23 23:32     ` Eric Schulte
2013-09-24 12:05       ` Paul Stansell
2013-09-25 18:21         ` Eric Schulte
2013-09-25 20:01           ` Paul Stansell

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=87y5bngaw1.fsf@Rainer.invalid \
    --to=stromeko@nexgo.de \
    --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).