* Re: org tables and R
[not found] <20081231084619.2353434807@mail2.panix.com>
@ 2008-12-31 19:54 ` Tom Breton (Tehom)
2008-12-31 20:51 ` Dan Davison
0 siblings, 1 reply; 2+ messages in thread
From: Tom Breton (Tehom) @ 2008-12-31 19:54 UTC (permalink / raw)
To: emacs-orgmode
Dan writes:
> There are more details below. The code is at
>
> http://www.stats.ox.ac.uk/~davison/software/org-table-R/org-table-R.el
>
> It would be great to get any feedback on this. My thought was that
> something like this has the potential to provide a unified plotting
> and table formula interface, which might be attractive to people who
> know and/or like and/or want to learn R. There's lots more that could
> be done with this, and there must be all sorts of bugs in it at this
> stage. But if there's any interest in it then it could be
> improved. Anyway, read on if you're interested in hearing more details
> about the options and actions available.
>
> Dan
Looks like you did a lot of work on this.
> - rownames:<integer>
> Specifies that column n contains the names of the rows of the
> table. These must be unique.
For column names, are you interpreting the existing table column name
syntax? (a special leftmost column with "!" in it (or "^" or "_"))
Or no column names?
> - replace:t
> The original org-table is replaced by the text output (which will be
> an org-table if the result is like a 1- or 2-dimensional array).
Does replace:nil do the opposite?
> - columns:<lisp-list>
> This specifies the columns that the off-the-shelf action will
> operate on (e.g. the columns you want to plot). The simplest case
> is columns:j, where j is an integer. This could also be written
> columns:(j). columns:((1)(2 3)) says that you want a graphic in
> which columns 2 and 3 are plotted on the y-axis, and column 1 is
> plotted on the x-axis. [...]
You might want to accept column names as well as column numbers.
Tom
^ permalink raw reply [flat|nested] 2+ messages in thread
* Re: Re: org tables and R
2008-12-31 19:54 ` org tables and R Tom Breton (Tehom)
@ 2008-12-31 20:51 ` Dan Davison
0 siblings, 0 replies; 2+ messages in thread
From: Dan Davison @ 2008-12-31 20:51 UTC (permalink / raw)
To: Tom Breton (Tehom); +Cc: emacs-orgmode
Hi Tom,
On Wed, Dec 31, 2008 at 02:54:29PM -0500, Tom Breton (Tehom) wrote:
>
> Dan writes:
> [...]
> > - replace:t
> > The original org-table is replaced by the text output (which will be
> > an org-table if the result is like a 1- or 2-dimensional array).
>
> Does replace:nil do the opposite?
Yes.
>
> > - columns:<lisp-list>
> > This specifies the columns that the off-the-shelf action will
> > operate on (e.g. the columns you want to plot). The simplest case
> > is columns:j, where j is an integer. This could also be written
> > columns:(j). columns:((1)(2 3)) says that you want a graphic in
> > which columns 2 and 3 are plotted on the y-axis, and column 1 is
> > plotted on the x-axis. [...]
>
> You might want to accept column names as well as column numbers.
Sorry, I should have mentioned. You can already do that, without changes to
the code. E.g.
| author | date |
|-----------------+---------------------------------|
| Carsten Dominik | Thu, 12 Jun 2008 12:51:54 +0200 |
| Carsten Dominik | Wed, 11 Jun 2008 08:57:39 +0200 |
| Adam Spiers | Wed, 11 Jun 2008 12:06:23 +0100 |
| Eddward DeVilla | Wed, 11 Jun 2008 12:15:11 -0500 |
| Eddward DeVilla | Wed, 11 Jun 2008 20:09:50 -0500 |
| Harri Kiiskinen | Wed, 04 Jun 2008 16:38:37 +0200 |
| Carsten Dominik | Thu, 12 Jun 2008 14:15:49 +0200 |
| Harri Kiiskinen | Thu, 12 Jun 2008 14:31:49 +0200 |
#+TBLR: columns:("author" "date") action:tabulate
#+TBLR:: x[,2] <- substr(x[,2], 1, 3)
turns into
| | Thu | Wed |
|-----------------+-----+-----|
| Adam Spiers | 0 | 1 |
| Carsten Dominik | 2 | 1 |
| Eddward DeVilla | 0 | 2 |
| Harri Kiiskinen | 1 | 1 |
and of course you can do it in the R code:
| rowname | col1 | col2 |
|---------+------+------|
| row 1 | 1 | 2 |
| row 2 | 3 | 4 |
| total | | |
#+TBLR:: x[3,] <- x["row 1",] + x["row 2",]
#+TBLR: rownames:1 replace:nil
turns into
| rownames(x) | col1 | col2 |
|-------------+------+------|
| row 1 | 1 | 2 |
| row 2 | 3 | 4 |
| total | 4 | 6 |
Dan
>
> Tom
>
>
>
>
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Remember: use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
--
http://www.stats.ox.ac.uk/~davison
^ permalink raw reply [flat|nested] 2+ messages in thread
end of thread, other threads:[~2008-12-31 20:52 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
[not found] <20081231084619.2353434807@mail2.panix.com>
2008-12-31 19:54 ` org tables and R Tom Breton (Tehom)
2008-12-31 20:51 ` Dan Davison
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).