From mboxrd@z Thu Jan 1 00:00:00 1970 From: John Hendy Subject: Re: import R data frame into org-mode table Date: Mon, 29 Jul 2013 11:03:09 -0500 Message-ID: References: <87mwpket4b.fsf@med.uni-goettingen.de> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:60128) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1V3puj-00051R-2q for emacs-orgmode@gnu.org; Mon, 29 Jul 2013 12:03:15 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1V3puh-0003a3-9D for emacs-orgmode@gnu.org; Mon, 29 Jul 2013 12:03:13 -0400 Received: from mail-oa0-x22d.google.com ([2607:f8b0:4003:c02::22d]:53318) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1V3puh-0003Zg-55 for emacs-orgmode@gnu.org; Mon, 29 Jul 2013 12:03:11 -0400 Received: by mail-oa0-f45.google.com with SMTP id m1so3308800oag.32 for ; Mon, 29 Jul 2013 09:03:09 -0700 (PDT) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: "Cook, Malcolm" Cc: Rob Stewart , "emacs-orgmode@gnu.org" , Andreas Leha On Mon, Jul 29, 2013 at 10:35 AM, Cook, Malcolm wrote: >>Hi Andreas, > > > >On 17 July 2013 23:09, Andreas Leha wrote: > > > >> Definitely there is: > >> > >> --8<---------------cut here---------------start------------->8--- > >> #+begin_src R :results table :colnames yes > >> read.csv('test.csv') > >> #+end_src > >> > >> #+results: > >> | X | Variant | Xaxis | N | mean | sd | se | > >> |---+---------+-------+---+--------+------+------| > >> | 1 | line1 | 10 | 5 | 111.11 | 9.33 | 3.11 | > >> | 1 | line1 | 20 | 5 | 112.11 | 9.13 | 3.14 | > >> | 1 | line1 | 30 | 5 | 113.11 | 9.43 | 3.1 | > >> | 1 | line2 | 10 | 5 | 101.11 | 8.33 | 2.11 | > >> | 1 | line2 | 20 | 5 | 100.11 | 8.13 | 2.12 | > >> | 1 | line2 | 30 | 5 | 108.11 | 8.03 | 2.1 | > >> > >> --8<---------------cut here---------------end--------------->8--- > > > >Great. I've gone ahead and done this. There are two additional requirements: > >1) My table needs a caption. Will #+CAPTION: just above the > >#+BEGIN_SRC just work? > > Yes > >> Even better, a label, allowing me to also cross > >reference it. > >2) My table is too long for 1 page. It spans multiple pages > >vertically. According to this StackOverflow answer > >http://stackoverflow.com/a/2896850/1526266 , I should instead use > >longtable, not tabular. Is there a way to coerce your above snippet to > >use longtable, instead of tabular which is the default. > > > > Looks like your answer is here: http://orgmode.org/manual/Tables-in-LaTeX-export.html Sort of. Depends on the Org-mode version, and someone will have to chime in on the updated status of various parts of the manual. For 8+, I believe the syntax is different: #+attr_latex: :environment longtable Also, there have been many threads in the past about how to add #+attr_latex lines to results output (mostly graphics/files) successfully. If you simply take the above and add =#+attr_latex: stuff= above the =#+results= line, babel won't recognize it and will just create a new results block. If those on this email are already well aware of this... my apologies for being redundant, but it causes enough confusion that I figured I'd leave another bread crumb trail :) Here's an example of a time that came up on the list: - http://lists.gnu.org/archive/html/emacs-orgmode/2012-07/msg00237.html You need to use any attributes (that includes #+begin/end_center, and any #+attr_backend lines) *in combination with* a named source block. So the full solution should look something like this: #+name: export-table #+begin_src R :results table :colnames yes read.csv('test.csv') #+end_src #+RESULTS: export-table #+attr_latex: :environment longtable | | | I see above that =:results output org= was used. There was some discussion about this for use with the new exporter as I wasn't getting great results: - https://lists.gnu.org/archive/html/emacs-orgmode/2013-03/msg01582.html - http://www.mail-archive.com/emacs-orgmode@gnu.org/msg69748.html If it's working for you, don't worry about it. If not, you may find some help in those threads. I've taken to using the ascii package for output org-mode tables from R. - http://orgmode.org/worg/org-contrib/babel/examples/ascii.html Works great for me. Good luck! John > > >Thanks! > > > >-- > >Rob > >