Both of these applications fulfill a great need of mine: to read data directly from google spreadsheets that are private to myself and one or two collaborators. Thanks to the authors. I had been using RGoogleDocs for the about 6 months (maybe more) but have had to stop using it in the past month since for some reason that I do not understand it no longer reads google spreadsheets. I loved it. Its loss depresses me. I started using RGoogleData which works. I have noticed that both packages read data slowly. RGoogleData is much slower than RGoogleDocs used to be. Both seem a lot slower than if one manually downloaded a google spreadsheet as a csv and then used read.csv function - but then I would not be able to use scripts and execute without finding and futzing. Can anyone explain in English why these packages read slower than a csv download? Can anyone explain what the core difference is between the two packages? Can anyone share their experience with reading Google data straight into R? Farrel Buchinsky Google Voice Tel: (412) 567-7870 Sent from Pittsburgh, Pennsylvania, United States [[alternative HTML version deleted]]
Hello there Farrel, I see no one is answering you yet, and I don't have answers to give you, but I did see this thread: http://tolstoy.newcastle.edu.au/R/e5/help/08/12/10204.html <http://tolstoy.newcastle.edu.au/R/e5/help/08/12/10204.html>That might be of use to you. Best, Tal ----------------Contact Details:------------------------------------------------------- Contact me: Tal.Galili@gmail.com | 972-52-7275845 Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) | www.r-statistics.com/ (English) ---------------------------------------------------------------------------------------------- On Thu, Dec 10, 2009 at 4:47 AM, Farrel Buchinsky <fjbuch@gmail.com> wrote:> Both of these applications fulfill a great need of mine: to read data > directly from google spreadsheets that are private to myself and one or two > collaborators. Thanks to the authors. I had been using RGoogleDocs for the > about 6 months (maybe more) but have had to stop using it in the past month > since for some reason that I do not understand it no longer reads google > spreadsheets. I loved it. Its loss depresses me. I started using > RGoogleData > which works. > > I have noticed that both packages read data slowly. RGoogleData is much > slower than RGoogleDocs used to be. Both seem a lot slower than if one > manually downloaded a google spreadsheet as a csv and then used read.csv > function - but then I would not be able to use scripts and execute without > finding and futzing. > > Can anyone explain in English why these packages read slower than a csv > download? > Can anyone explain what the core difference is between the two packages? > Can anyone share their experience with reading Google data straight into R? > > Farrel Buchinsky > Google Voice Tel: (412) 567-7870 > > Sent from Pittsburgh, Pennsylvania, United States > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org 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. >[[alternative HTML version deleted]]
Farrel,
Please read the manuals. On the RGoogleData package page you can read:
"The package provides R access to Google services through the Google
supported Java API.
[...]
A package with very similar functionality is maintained by Duncan Temple
Lang at \url{http://www.omegahat.org/RGoogleDocs/}. The approach taken
there is to use \code{RCurl} and \code{XML} to interact with the lower
level Google HTML protocol. You should check it out too."
Regarding the questions you have about speed. Google spreadsheets is
labeled Labs, mabye there are performance issues on Google side. The
approach for both RGoogleDocs and RGoogleData is to make requests to the
Google servers and parse the XML results. RGoogleDocs parses using a C
library, RGoogleData uses a Java library. Going through the Java
interface is an extra step, so that might explain the speed difference.
Check ?downloadDocument if you want to download the entire document. It
should be fast. You can load it into R after that.
Best,
Adrian
On Wed, 9 Dec 2009, Farrel Buchinsky wrote:
> Both of these applications fulfill a great need of mine: to read data
> directly from google spreadsheets that are private to myself and one or two
> collaborators. Thanks to the authors. I had been using RGoogleDocs for the
> about 6 months (maybe more) but have had to stop using it in the past month
> since for some reason that I do not understand it no longer reads google
> spreadsheets. I loved it. Its loss depresses me. I started using
RGoogleData
> which works.
>
> I have noticed that both packages read data slowly. RGoogleData is much
> slower than RGoogleDocs used to be. Both seem a lot slower than if one
> manually downloaded a google spreadsheet as a csv and then used read.csv
> function - but then I would not be able to use scripts and execute without
> finding and futzing.
>
> Can anyone explain in English why these packages read slower than a csv
> download?
> Can anyone explain what the core difference is between the two packages?
> Can anyone share their experience with reading Google data straight into R?
>
> Farrel Buchinsky
> Google Voice Tel: (412) 567-7870
>
> Sent from Pittsburgh, Pennsylvania, United States
>
Hi Farrel I have taken a look at the problems using RGoogleDocs to read spreadsheets and was able to reproduce the problem I believe you were having. A few minor, but important, changes and I can read spreadsheets again and apparently still other types of documents. I have put an updated version of the source of the package with these changes. It is available from http://www.omegahat.org/RGoogleDocs/RGoogleDocs_0.4-1.tar.gz There is a binary for Windows in http://www.omegahat.org/RGoogleDocs/RGoogleDocs_0.4-1.zip Hopefully this will cure the problems you have been experiencing. I'd appreciate knowing either way. Thanks, D. Farrel Buchinsky wrote:> Both of these applications fulfill a great need of mine: to read data > directly from google spreadsheets that are private to myself and one or two > collaborators. Thanks to the authors. I had been using RGoogleDocs for the > about 6 months (maybe more) but have had to stop using it in the past month > since for some reason that I do not understand it no longer reads google > spreadsheets. I loved it. Its loss depresses me. I started using RGoogleData > which works. > > I have noticed that both packages read data slowly. RGoogleData is much > slower than RGoogleDocs used to be. Both seem a lot slower than if one > manually downloaded a google spreadsheet as a csv and then used read.csv > function - but then I would not be able to use scripts and execute without > finding and futzing. > > Can anyone explain in English why these packages read slower than a csv > download? > Can anyone explain what the core difference is between the two packages? > Can anyone share their experience with reading Google data straight into R? > > Farrel Buchinsky > Google Voice Tel: (412) 567-7870 > > Sent from Pittsburgh, Pennsylvania, United States > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org 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.