From mboxrd@z Thu Jan 1 00:00:00 1970 From: Dan Davison Subject: Re: graphing from org-tables Date: Tue, 27 Jan 2009 22:06:09 -0500 Message-ID: <20090128030609.GD6989@stats.ox.ac.uk> References: <74FDB779-BB93-414F-ABD3-DBA6DE6C528E@gmail.com> <87r640p2ld.fsf@gmail.com> <20090122162711.GA11250@stats.ox.ac.uk> <87y6x2ssz4.fsf@gmail.com> <0696199E-F0FC-4597-9705-B1660D208325@uva.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1LS0ks-0000nY-Gq for emacs-orgmode@gnu.org; Tue, 27 Jan 2009 22:06:18 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LS0kq-0000kg-Lg for emacs-orgmode@gnu.org; Tue, 27 Jan 2009 22:06:18 -0500 Received: from [199.232.76.173] (port=53772 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LS0kq-0000kT-II for emacs-orgmode@gnu.org; Tue, 27 Jan 2009 22:06:16 -0500 Received: from markov.stats.ox.ac.uk ([163.1.210.1]:38418) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1LS0kq-0003Y1-0X for emacs-orgmode@gnu.org; Tue, 27 Jan 2009 22:06:16 -0500 Received: from blackcap.stats.ox.ac.uk (blackcap.stats [163.1.210.5]) by markov.stats.ox.ac.uk (8.13.6/8.13.6) with ESMTP id n0S36BJs018643 for ; Wed, 28 Jan 2009 03:06:11 GMT Content-Disposition: inline In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org On Mon, Jan 26, 2009 at 09:53:37AM +0100, Carsten Dominik wrote: > < ... > >> (defun org-table-remote-range (id form >> &optional replace keep-empty numbers lispp) >> "Get a field value or a list of values in a range from table at ID. > > In 6.19, there is now built-in unction to access data from arbitrary > tables. > Thanks a lot for writing that function Carsten. I've used that code to extend org-table-R.el so that it can reference remote tables in org files, and also local csv files and csv files on the web. The interface with org-table-R is via #+TBLR lines. These can now occur anywhere in an org file (previously they had to be beneath the table being analysed), with a reference to a remote table containing the data. This reference can take the following forms (these are options to be supplied in the #+TBLR: line) 1. table:name -- The name of a table in the same file (i.e. one named with #+TBLNAME) 2. table:id -- The unique id of an entry in an org file (the first table under that entry is used) 3. csv:path/to/file.csv -- A local csv file 4. csv:"http:www.somewhere.xx/file.csv" -- A csv file on the web org-table-R-apply makes happen whatever is specified in the #+TBLR: and #+TBLR:: lines. Tabular output is sent to the org buffer as a new org table, or alternatively org-table-R may be used to graph the data in the table. Point must be in the first #+TBLR line (previously point had to be in the table itself). The code (with some initial documentation) is at http://www.stats.ox.ac.uk/~davison/software/org-table-R/org-table-R.el I'll try to put together some examples of usage for worg. Dan > - Carsten > > > > _______________________________________________ > 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