Re: import R data frame into org-mode table

[John Hendy <jw.hendy@gmail.com>]

On Mon, Jul 29, 2013 at 10:35 AM, Cook, Malcolm <MEC@stowers.org> wrote:
>>Hi Andreas,
>  >
>  >On 17 July 2013 23:09, Andreas Leha <andreas.leha@med.uni-goettingen.de> 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
>
>