Quantcast

Embed R code in online database

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Embed R code in online database

Jokel Meyer
Dear R-List!

I would like to embed R code in an online database such as i.e. a google
spreadsheet in way that users can add data to the database and that R's
calculations are updated automatically and i.e. given out in the
spreadsheet. Maybe even graphs could be updated online? Is there a way to
implement this?

Many thanks!
J.

        [[alternative HTML version deleted]]

______________________________________________
[hidden email] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Embed R code in online database

Barry Rowlingson
On Sat, Feb 11, 2012 at 5:49 PM, Jokel Meyer <[hidden email]> wrote:
> Dear R-List!
>
> I would like to embed R code in an online database such as i.e. a google
> spreadsheet in way that users can add data to the database and that R's
> calculations are updated automatically and i.e. given out in the
> spreadsheet. Maybe even graphs could be updated online? Is there a way to
> implement this?

 There's no way to integrate R into a google spreadsheet as tightly
as, say, letting you put R expressions into formulae for cells.

 There's also, I think, no way to trigger an external action when a
spreadsheet is modified or saved.

 So, I think the only thing you can do, is to periodically check if
the spreadsheet is modified, run an R script, and upload the modified
data to Google.

 I'm not sure what the current state-of-the-art interface from R to
google docs is. Maybe
http://r-forge.r-project.org/projects/rgoogledata/

Barry

______________________________________________
[hidden email] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Loading...