* orgmode and R? @ 2015-08-03 16:51 Jude DaShiell 2015-08-03 17:58 ` John Kitchin 2015-08-03 19:47 ` Allen S. Rout 0 siblings, 2 replies; 6+ messages in thread From: Jude DaShiell @ 2015-08-03 16:51 UTC (permalink / raw) To: emacs-orgmode 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. -- ^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: orgmode and R? 2015-08-03 16:51 orgmode and R? Jude DaShiell @ 2015-08-03 17:58 ` John Kitchin 2015-08-03 19:47 ` Allen S. Rout 1 sibling, 0 replies; 6+ messages in thread From: John Kitchin @ 2015-08-03 17:58 UTC (permalink / raw) To: Jude DaShiell; +Cc: emacs-orgmode 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 ^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: orgmode and R? 2015-08-03 16:51 orgmode and R? Jude DaShiell 2015-08-03 17:58 ` John Kitchin @ 2015-08-03 19:47 ` Allen S. Rout 2015-08-03 20:05 ` John Kitchin 1 sibling, 1 reply; 6+ messages in thread From: Allen S. Rout @ 2015-08-03 19:47 UTC (permalink / raw) To: emacs-orgmode 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 ^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: orgmode and R? 2015-08-03 19:47 ` Allen S. Rout @ 2015-08-03 20:05 ` John Kitchin 2015-08-03 20:08 ` Cook, Malcolm 0 siblings, 1 reply; 6+ messages in thread From: John Kitchin @ 2015-08-03 20:05 UTC (permalink / raw) To: Allen S. Rout; +Cc: emacs-orgmode 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 ^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: orgmode and R? 2015-08-03 20:05 ` John Kitchin @ 2015-08-03 20:08 ` Cook, Malcolm 2015-08-03 20:29 ` Thomas S. Dye 0 siblings, 1 reply; 6+ messages in thread From: Cook, Malcolm @ 2015-08-03 20:08 UTC (permalink / raw) To: 'John Kitchin', Allen S. Rout; +Cc: emacs-orgmode@gnu.org 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 ^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: orgmode and R? 2015-08-03 20:08 ` Cook, Malcolm @ 2015-08-03 20:29 ` Thomas S. Dye 0 siblings, 0 replies; 6+ messages in thread From: Thomas S. Dye @ 2015-08-03 20:29 UTC (permalink / raw) To: Cook, Malcolm Cc: emacs-orgmode@gnu.org, Allen S. Rout, 'John Kitchin' 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 ^ permalink raw reply [flat|nested] 6+ messages in thread
end of thread, other threads:[~2015-08-03 20:30 UTC | newest] Thread overview: 6+ messages (download: mbox.gz / follow: Atom feed) -- links below jump to the message on this page -- 2015-08-03 16:51 orgmode and R? Jude DaShiell 2015-08-03 17:58 ` John Kitchin 2015-08-03 19:47 ` Allen S. Rout 2015-08-03 20:05 ` John Kitchin 2015-08-03 20:08 ` Cook, Malcolm 2015-08-03 20:29 ` Thomas S. Dye
Code repositories for project(s) associated with this public inbox https://git.savannah.gnu.org/cgit/emacs/org-mode.git This is a public inbox, see mirroring instructions for how to clone and mirror all data and code used for this inbox; as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).