Posts Tagged ‘ google docs ’

R-Function to Read Data from Google Docs Spreadsheets

March 13, 2012
By
R-Function to Read Data from Google Docs Spreadsheets

I used this idea posted on Stack Overflow to plug together a function for reading data from Google Docs spreadsheets into R. google_ss <- function(gid = NA, key = NA) { if (is.na(gid)) {stop("\nWorksheetnumber (gid) is missing\n")} if (is....

Read more »

How to Download and Run Google Docs Script from within the R-Console

November 14, 2011
By
How to Download and Run Google Docs Script from within the R-Console

...There is not much to it:upload a txt file with your script, share it for anyone with the link, then simply run something like the below code. ps: When using the code for your own purpose mind to change "https" to "http" and to i...

Read more »

Google spreadsheets + google forms + R = Easily collecting and importing data for analysis

March 13, 2010
By

Someone on the R mailing list (link) asked: how can you easily (daily) collect data from many people into a spreadsheet and then analyse it using R. The answer people gave to it where on various ways of using excel.  But excel files (at least for now),  are not “on the cloud”.  A better answer might be to create a...

Read more »