[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] import R data frame into org-mode table
From: |
John Hendy |
Subject: |
Re: [O] import R data frame into org-mode table |
Date: |
Mon, 29 Jul 2013 11:03:09 -0500 |
On Mon, Jul 29, 2013 at 10:35 AM, Cook, Malcolm <address@hidden> wrote:
>>Hi Andreas,
> >
> >On 17 July 2013 23:09, Andreas Leha <address@hidden> 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/address@hidden/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
>
>
- [O] import R data frame into org-mode table, Rob Stewart, 2013/07/16
- Re: [O] import R data frame into org-mode table, Andreas Leha, 2013/07/17
- Re: [O] import R data frame into org-mode table, Rob Stewart, 2013/07/29
- Re: [O] import R data frame into org-mode table, Cook, Malcolm, 2013/07/29
- Re: [O] import R data frame into org-mode table,
John Hendy <=
- Re: [O] import R data frame into org-mode table, Nick Dokos, 2013/07/29
- Re: [O] import R data frame into org-mode table, Cook, Malcolm, 2013/07/29
- Re: [O] import R data frame into org-mode table, Nick Dokos, 2013/07/29
- Re: [O] import R data frame into org-mode table, Cook, Malcolm, 2013/07/30
Re: [O] import R data frame into org-mode table, Thomas S. Dye, 2013/07/17