Hello,
I am trying to upload data I have on a Google Spreadsheet within R to
perform some analysis. I regularly update such data and need to perform
data analysis in the quickiest possible way - i.e. without need to publish
the data, so I was wondering how to make work this piece of code (source
http://www.r-bloggers.com/datagrabbing-commonly-formatted-sheets-from-a-google-spreadsheet-guardian-2014-university-guide-data/)
with my dataset (see
https://docs.google.com/spreadsheet/ccc?key=0AkvLBhzbLcz5dHljNGhUdmNJZ0dOdGJLTVRjTkRhTkE#gid=0
):
library(RCurl)
gsqAPI = function(key,query,gid=0){
tmp=getURL( paste( sep="",'https://spreadsheets.google.com/tq?',
'tqx=out:csv','&tq=', curlEscape(query), '&key=', key, '&gid=', gid),
ssl.verifypeer = FALSE )
return( read.csv( textConnection( tmp ), stringsAsFactors=F ) )
}
handler=function(key,i){
tmp=gsqAPI(key,"select * where B!=''", i)
subject=sub(".Rank",'',colnames(tmp)[1])
colnames(tmp)[1]="Subject.Rank"
tmp$subject=subject
tmp
}
key='0AkvLBhzbLcz5dHljNGhUdmNJZ0dOdGJLTVRjTkRhTkE'
gdata=handler(key,0)
The code is currently returning the following:
Error in `$<-.data.frame`(`*tmp*`, "subject", value = "COL1") :
replacement has 1 row, data has 0
Thank you in advance,
Luca
[[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.
