From adrian_d at eskimo.com  Fri Feb 27 15:26:00 2009
From: adrian_d at eskimo.com (Adrian Dragulescu)
Date: Fri, 27 Feb 2009 06:26:00 -0800 (PST)
Subject: [Rd] R-Google interface: Google summer of code
In-Reply-To: <bd93cdad0902270602mc4dede7w58635467e711c56d@mail.gmail.com>
References: <bd93cdad0902270602mc4dede7w58635467e711c56d@mail.gmail.com>
Message-ID: <Pine.LNX.4.64.0902270620010.2887@shell.eskimo.com>


There is an R package that does what you want.

http://www.omegahat.org/RGoogleDocs/ by Duncan Temple Lang.

It is still in beta but can be used.  I've run into some issues when 
google changes the location of your spreadsheet and redirects you to 
another site.  I could not make it follow the new link.  I'm sure little 
kinks like this can all be worked out if one only has time.

If there is a student out there that wants to work on this, it would be a 
great project.

Adrian Dragulescu



On Fri, 27 Feb 2009, Farrel Buchinsky wrote:

> I use R for data management and ongoing data analysis for amongst other
> things, a multi-center medical research project. I have found Google
> spreadsheets to be a fantastic way for all collaborators to be on the same
> page. Furthermore, Google Forms allows one to capture data from respondents
> and effortlessly write it to a google spreadsheet.
> Currently, one has to manually download the spreadsheet as a csv file and
> then read that into R. Since data changes frequently and is almost never
> final it would be far preferable for R to read a google spreadsheet
> directly. RODBC package does something similar for Microsoft Access and
> Microsoft Excel.
>
> I am a surgeon-scientist whose programing experience is extremely limited.
> Is there a willing mentor who would want to take such a project and propose
> it for the Google summer of code project?
>
> The mentor could chose his or her scope. For instance at it's most basic the
> project's goal could be to simply read a spreadsheet from google spreadsheet
> into a R dataframe. The scope could widen to allow R to also write to Google
> spreadsheet. If one wanted something even more challenging then one could
> create code that allows one to post R script to a R server allowing the
> server to read Google Spreadsheets, processes the data and present the
> output to a web client.
>
>
> Farrel Buchinsky
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-devel at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel
>



[Rd] R-Google interface: Google summer of code
Adrian Dragulescu