orgmode and R?

orgmode and R?

[Jude DaShiell]

Can the orgmode spreadsheet access R either directly or indirectly through 
maybe babel?  If this is possible, do any tutorials exist with some worked 
examples?  I have R and emacs-R-mode installed so I can access R from 
emacs at least.



--

Re: orgmode and R?

[John Kitchin]

I don't know much about R, but here is a hack to do somthing like this
with python. I have not tested it beyond what you see here.

You can use emacs lisp in an org-mode spreadsheet as a formula. We will hack that to let us use Python. We will do that by making a lisp function that evaluates a python string and returns the results.

| x | y |    |
|---+---+----|
| 1 | 2 |  3 |
| 2 | 4 |  6 |
| 3 | 6 | 18 |
|---+---+----|
|   |   |    |
#+TBLFM: @2$3=@2$1 + @2$2
#+TBLFM: @3$3='(+ @3$1 @3$2);N
#+TBLFM: @4$3='(python "@4$1 * @4$2");N

#+BEGIN_SRC emacs-lisp
(defun python (string)
  "Send string to a python interpreter and return result."
  (python-shell-send-string-no-output
    string
    (or (python-shell-get-process)
        (run-python))))
#+END_SRC




Jude DaShiell writes:

> Can the orgmode spreadsheet access R either directly or indirectly through
> maybe babel?  If this is possible, do any tutorials exist with some worked
> examples?  I have R and emacs-R-mode installed so I can access R from
> emacs at least.

--
Professor John Kitchin
Doherty Hall A207F
Department of Chemical Engineering
Carnegie Mellon University
Pittsburgh, PA 15213
412-268-7803
@johnkitchin
http://kitchingroup.cheme.cmu.edu

Re: orgmode and R?

[Allen S. Rout]

On 08/03/2015 12:51 PM, Jude DaShiell wrote:
> Can the orgmode spreadsheet access R either directly or indirectly through 
> maybe babel?  If this is possible, do any tutorials exist with some worked 
> examples?  I have R and emacs-R-mode installed so I can access R from 
> emacs at least.
> 

Yes.

http://orgmode.org/worg/org-contrib/babel/languages/ob-doc-R.html

is the first hit on "org-mode R" from google.

There is extensive art on the topic.


- Allen S. Rout

Re: orgmode and R?

[John Kitchin]

I think the question was about using R in table formulas, not just using
R in src-block.

As far as I know it is possible to use emacs-lisp pretty directly, but
not other languages in the table formulas.

Allen S. Rout writes:

> On 08/03/2015 12:51 PM, Jude DaShiell wrote:
>> Can the orgmode spreadsheet access R either directly or indirectly through
>> maybe babel?  If this is possible, do any tutorials exist with some worked
>> examples?  I have R and emacs-R-mode installed so I can access R from
>> emacs at least.
>>
>
> Yes.
>
> http://orgmode.org/worg/org-contrib/babel/languages/ob-doc-R.html
>
> is the first hit on "org-mode R" from google.
>
> There is extensive art on the topic.
>
>
> - Allen S. Rout

--
Professor John Kitchin
Doherty Hall A207F
Department of Chemical Engineering
Carnegie Mellon University
Pittsburgh, PA 15213
412-268-7803
@johnkitchin
http://kitchingroup.cheme.cmu.edu

Re: orgmode and R?

[Cook, Malcolm]

It is possible to send a org table to R as a data.frame, which could edit it, add columns, and produce a new data.frame which, with :results value, will be understood by org as an table.


> -----Original Message-----
> From: emacs-orgmode-bounces+mec=stowers.org@gnu.org [mailto:emacs-
> orgmode-bounces+mec=stowers.org@gnu.org] On Behalf Of John Kitchin
> Sent: Monday, August 03, 2015 3:06 PM
> To: Allen S. Rout <asr@ufl.edu>
> Cc: emacs-orgmode@gnu.org
> Subject: Re: [O] orgmode and R?
> 
> I think the question was about using R in table formulas, not just using R in
> src-block.
> 
> As far as I know it is possible to use emacs-lisp pretty directly, but not other
> languages in the table formulas.
> 
> Allen S. Rout writes:
> 
> > On 08/03/2015 12:51 PM, Jude DaShiell wrote:
> >> Can the orgmode spreadsheet access R either directly or indirectly
> >> through maybe babel?  If this is possible, do any tutorials exist
> >> with some worked examples?  I have R and emacs-R-mode installed so I
> >> can access R from emacs at least.
> >>
> >
> > Yes.
> >
> > http://orgmode.org/worg/org-contrib/babel/languages/ob-doc-R.html
> >
> > is the first hit on "org-mode R" from google.
> >
> > There is extensive art on the topic.
> >
> >
> > - Allen S. Rout
> 
> --
> Professor John Kitchin
> Doherty Hall A207F
> Department of Chemical Engineering
> Carnegie Mellon University
> Pittsburgh, PA 15213
> 412-268-7803
> @johnkitchin
> http://kitchingroup.cheme.cmu.edu

Re: orgmode and R?

[Thomas S. Dye]

Yes, certainly.

#+name: eg
| a | b |
| c | d |

#+name: table-eg
#+begin_src R :var table=eg
print(table[,1])
#+end_src

#+results: table-eg
| a |
| c |

hth,
Tom

Cook, Malcolm <MEC@stowers.org> writes:

> It is possible to send a org table to R as a data.frame, which could edit it, add columns, and produce a new data.frame which, with :results value, will be understood by org as an table.
>
>
>> -----Original Message-----
>> From: emacs-orgmode-bounces+mec=stowers.org@gnu.org [mailto:emacs-
>> orgmode-bounces+mec=stowers.org@gnu.org] On Behalf Of John Kitchin
>> Sent: Monday, August 03, 2015 3:06 PM
>> To: Allen S. Rout <asr@ufl.edu>
>> Cc: emacs-orgmode@gnu.org
>> Subject: Re: [O] orgmode and R?
>> 
>> I think the question was about using R in table formulas, not just using R in
>> src-block.
>> 
>> As far as I know it is possible to use emacs-lisp pretty directly, but not other
>> languages in the table formulas.
>> 
>> Allen S. Rout writes:
>> 
>> > On 08/03/2015 12:51 PM, Jude DaShiell wrote:
>> >> Can the orgmode spreadsheet access R either directly or indirectly
>> >> through maybe babel?  If this is possible, do any tutorials exist
>> >> with some worked examples?  I have R and emacs-R-mode installed so I
>> >> can access R from emacs at least.
>> >>
>> >
>> > Yes.
>> >
>> > http://orgmode.org/worg/org-contrib/babel/languages/ob-doc-R.html
>> >
>> > is the first hit on "org-mode R" from google.
>> >
>> > There is extensive art on the topic.
>> >
>> >
>> > - Allen S. Rout
>> 
>> --
>> Professor John Kitchin
>> Doherty Hall A207F
>> Department of Chemical Engineering
>> Carnegie Mellon University
>> Pittsburgh, PA 15213
>> 412-268-7803
>> @johnkitchin
>> http://kitchingroup.cheme.cmu.edu

-- 
Thomas S. Dye
http://www.tsdye.com