Re: [R] Have you used RGoogleDocs and RGoogleData?
Dear Adrian
Are you able to help me with problems that I am having with RGoogleData? I
would greatly appreciate it if you could give me some general trouble
shooting ideas or better yet if you could fix the problem.
I believe that I updated to the latest version of RGoogleData as evidenced
by
packageDescription(RGoogleData)
Package: RGoogleData
Type: Package
Title: An R interface to Google Data (Docs, Calendar, Contacts, Finance,
etc.)
Version: 0.2.0
Date: 2009-12-11
Depends: rJava
Author: Adrian A. Dragulescu
Maintainer: Adrian A. Dragulescu adrian.dragule...@gmail.com
Description: Provide R access to Google Data API.
License: GPL-3
Repository: R-Forge
Repository/R-Forge/Project: rgoogledata
Repository/R-Forge/Revision: 6
Date/Publication: 2009-12-13 21:43:52
Packaged: 2009-12-14 21:05:13 UTC; rforge
Built: R 2.10.1; ; 2009-12-14 23:02:39 UTC; windows
-- File: C:/PROGRA~2/R/R-210~1.1/library/RGoogleData/Meta/package.rds
But Alas
My previous script has stopped working.
library(RGoogleData)
ps -readline(prompt=get the password in )
con -googleConnect(fjb...@gmail.com,ps)
allXls - getSpreadsheets(con)
xls - allXls[[which(sapply(allXls, slot, title) == OnCall)]]
allWks - getWorksheets(xls)# get the worksheets
Error in .jcall(RJavaTools, Ljava/lang/Object;, invokeMethod, cl, :
java.lang.ClassCastException: com.google.gdata.data.TextContent cannot be
cast to com.google.gdata.data.OutOfLineContent
I also tried:
target -downloadDocument(doc=OnCall,
filepath=C:/Users/fbuchinsky/Documents/My Dropbox/OnCalltrial.csv,
fileformat=csv, sheetIndex=1)
Error in regexpr(%3A, d...@key) :
trying to get slot key from an object of a basic class (character)
with no slots
Farrel Buchinsky
Sent from Pittsburgh, Pennsylvania, United States
On Thu, Dec 10, 2009 at 10:38, Adrian Dragulescu adria...@eskimo.comwrote:
I will try to have something in place by Monday to allow you to download a
specific sheet not default to the first. I will let you know.
Adrian
On Thu, 10 Dec 2009, Farrel Buchinsky wrote:
Thank you Adrian. Your response was very informative.
?downloadDocument filled me with excitement untill I read, If you try to
download a spreadsheet with multiple worksheets into a 'csv' or 'tsv'
format, only the first worksheet will be downloaded.
So now there is a convenient fast way to read data under two circumstances
1. if the spreadsheet has been
published
http://blog.revolution-computing.com/2009/09/how-to-use-a-google-spreadsheet-as-data-in-r.html
2. if one only wants the first sheet (RGoogleData's downloadDocument()).
Farrel Buchinsky
Google Voice Tel: (412) 567-7870
Sent from Pittsburgh, Pennsylvania, United States
On Thu, Dec 10, 2009 at 09:32, Adrian Dragulescu adria...@eskimo.com
wrote:
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
Re: [R] Have you used RGoogleDocs and RGoogleData?
Farrel Buchinsky wrote: It Works! Thanks a lot! Its great. Thanks for letting me know. Glad that fixed things for you. What were your few minor, but important, changes - in a nutshell. I will not understand unless you describe it as high level issues. Basically, recognizing the type of a document, e.g. a spreadsheet or word processing document or generic document. The changes made the detection more robust or more consistent with any changes at Google. D. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Fri, Dec 11, 2009 at 19:07, Duncan Temple Lang dun...@wald.ucdavis.eduwrote: 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@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]] __ 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. __ 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.
Re: [R] Have you used RGoogleDocs and RGoogleData?
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@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. __ 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.
Re: [R] Have you used RGoogleDocs and RGoogleData?
It Works! Thanks a lot! Its great. What were your few minor, but important, changes - in a nutshell. I will not understand unless you describe it as high level issues. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Fri, Dec 11, 2009 at 19:07, Duncan Temple Lang dun...@wald.ucdavis.eduwrote: 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@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]] __ 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.
Re: [R] Have you used RGoogleDocs and RGoogleData?
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.htmlThat might be of use to you. Best, Tal Contact Details:--- Contact me: tal.gal...@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 fjb...@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]] __ 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.
Re: [R] Have you used RGoogleDocs and RGoogleData?
Thank you Adrian. Your response was very informative.
?downloadDocument filled me with excitement untill I read, If you try to
download a spreadsheet with multiple worksheets into a 'csv' or 'tsv'
format, only the first worksheet will be downloaded.
So now there is a convenient fast way to read data under two circumstances
1. if the spreadsheet has been
publishedhttp://blog.revolution-computing.com/2009/09/how-to-use-a-google-spreadsheet-as-data-in-r.html
2. if one only wants the first sheet (RGoogleData's downloadDocument()).
Farrel Buchinsky
Google Voice Tel: (412) 567-7870
Sent from Pittsburgh, Pennsylvania, United States
On Thu, Dec 10, 2009 at 09:32, Adrian Dragulescu adria...@eskimo.comwrote:
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
[[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.
Re: [R] Have you used RGoogleDocs and RGoogleData?
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
__
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.
Re: [R] Have you used RGoogleDocs and RGoogleData?
I will try to have something in place by Monday to allow you to download
a specific sheet not default to the first. I will let you know.
Adrian
On Thu, 10 Dec 2009, Farrel Buchinsky wrote:
Thank you Adrian. Your response was very informative.
?downloadDocument filled me with excitement untill I read, If you try to
download a spreadsheet with multiple worksheets into a 'csv' or 'tsv'
format, only the first worksheet will be downloaded.
So now there is a convenient fast way to read data under two circumstances
1. if the spreadsheet has been
publishedhttp://blog.revolution-computing.com/2009/09/how-to-use-a-google-spreadsheet-as-data-in-r.html
2. if one only wants the first sheet (RGoogleData's downloadDocument()).
Farrel Buchinsky
Google Voice Tel: (412) 567-7870
Sent from Pittsburgh, Pennsylvania, United States
On Thu, Dec 10, 2009 at 09:32, Adrian Dragulescu adria...@eskimo.comwrote:
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
__
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.
Re: [R] Have you used RGoogleDocs and RGoogleData?
That would be fantastic. How about an option whereby all the worksheets are
downloaded and read into dataframes and appear as a a list of dataframes?
Farrel Buchinsky
Google Voice Tel: (412) 567-7870
On Thu, Dec 10, 2009 at 10:38, Adrian Dragulescu adria...@eskimo.comwrote:
I will try to have something in place by Monday to allow you to download a
specific sheet not default to the first. I will let you know.
Adrian
On Thu, 10 Dec 2009, Farrel Buchinsky wrote:
Thank you Adrian. Your response was very informative.
?downloadDocument filled me with excitement untill I read, If you try to
download a spreadsheet with multiple worksheets into a 'csv' or 'tsv'
format, only the first worksheet will be downloaded.
So now there is a convenient fast way to read data under two circumstances
1. if the spreadsheet has been
published
http://blog.revolution-computing.com/2009/09/how-to-use-a-google-spreadsheet-as-data-in-r.html
2. if one only wants the first sheet (RGoogleData's downloadDocument()).
Farrel Buchinsky
Google Voice Tel: (412) 567-7870
Sent from Pittsburgh, Pennsylvania, United States
On Thu, Dec 10, 2009 at 09:32, Adrian Dragulescu adria...@eskimo.com
wrote:
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
[[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.
[R] Have you used RGoogleDocs and RGoogleData?
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.
