Re: [O] import R data frame into org-mode table

[Cook, Malcolm]

>-----Original Message-----
 >From: John Hendy [mailto:address@hidden
 >Sent: Monday, July 29, 2013 11:03 AM
 >To: Cook, Malcolm
 >Cc: Rob Stewart; Andreas Leha; address@hidden
 >Subject: Re: [O] import R data frame into org-mode table
 >
 >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
 >| | |
[Cook, Malcolm] 

Indeed, thanks, and, my worked out example follows using emacs 2.18.9 and 
org-mode version 8.0.6

#+LATEX: \listoftables                                                          
                                                                                
                                                                             
#+LaTeX_HEADER: \usepackage{longtable}                                          
                                                                                
                                                                             
#+name: longtabletest                                                           
                                                                                
                                                                             
#+CAPTION: test of longtable caption                                            
                                                                                
                                                                             
#+begin_src R :results value :colnames yes                                      
                                                                                
                                                                             
data.frame(num=1:260,alpha=rep(LETTERS,10))                                     
                                                                                
                                                                             
#+end_src                                                                       
                                                                                
                                                                             
                                                                                
                                                                                
                                                                             
#+RESULTS:                                                                      
                                                                                
                                                                             
#+attr_latex: :environment longtable                                            
                                                                                
                                                                             
| num | alpha |                                                                 
                                                                                
                                                                             
|-----+-------|                                                                 
                                                                                
                                                                             
|   1 | A     |                                                                 
                                                                                
                                                                             
|   2 | B     |       
...

~Malcolm

 >
 >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
 >>
 >>