[R] RGoogleDocs stopped working

am neither a programmer nor a developer, just a very enthusiastic RGoogleDocs user who probably perseveres more than is good for him. Farrel Buchinsky [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.e

[R] Rcurl giving SSL grief

I posted the question on StackOverflow at http://stackoverflow.com/questions/3442781/rgoogledocs-or-rcurl-giving-ssl-certificate-problem Is it a breach of etiquette to cross post? Farrel Buchinsky [[alternative HTML version deleted]] ___

Re: [R] RGoogleDocs not working for me with " wise" service

, then sorry for asking you to do more work. However, that is the price you pay when you do something so useful. Thanks. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Jun 9, 2010 at 18:17, Harlan Harris wrote: > It works! How fantastic a capability, and how embarrassing that I mis

Re: [R] RGoogleDocs not working for me with " wise" service

Harlan Harris harris.name> writes: > > Hello, > > I'm trying to figure out how to use the RGoogleDocs package from OmegaHat, > and am having a bit of trouble. I emailed Duncan Temple Lang directly, but > didn't receive a response, so I thought I'd try here to see if anyone else > can help. > >

Re: [R] Form using R

Tal Galili gmail.com> writes: > > Hi Nilza, > I just wrote a more detailed answer to your question in the following post: > Google spreadsheets + google forms + R = Easily collecting and importing > data for analysis

Re: [R] Have you used RGoogleDocs and RGoogleData?

.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" fro

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 wrote: >

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 wrote: > > I will try to have someth

Re: [R] Have you used RGoogleDocs and RGoogleData?

re 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 B

[R] Have you used RGoogleDocs and RGoogleData?

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

Re: [R] Reading from Google Docs

Is anyone using RGoogleDocs? If so have you used it in the last few weeks and is it working as it used to. Look at the problem I have run into. Farrel Buchinsky On Sat, Nov 28, 2009 at 14:25, Farrel Buchinsky wrote: > Thank you for the interest in my problem. > > > I have bee

Re: [R] Reading from Google Docs

"Sat, 28 Nov 2009 19:04:22 GMT" "Sat, 28 Nov 2009 19:04:22 GMT" Cache-Control X-Content-Type-Options &quo

Re: [R] Reading from Google Docs

Please oh please could someone help me or at least confirm that they are having the same problem. Why am I getting the error message from RGoogleDocs > getDocs(sheets.con) Error in getDocs(sheets.con) : problems connecting to get the list of documents How do I troubleshoot? Far

Re: [R] Reading from Google Docs

l",sheets.con) Those opening lines of script used to work flawlesly. Now I get. Error in getDocs(con) : problems connecting to get the list of documents Yet I got it to work earlier while I had been toying with RGoogleData package in another session. Could RGoogleData have opened something for R

Re: [R] Reading from Google Docs

s Library directory then everything will work. Please let me know. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Nov 25, 2009 at 15:15, Charlie Sharpsteen wrote: > On Wed, Nov 25, 2009 at 12:02 PM, Farrel Buchinsky > wrote: > > I reinstalled from a binary that Duncan

Re: [R] Reading from Google Docs

rning message: package 'RGoogleDocs' was built under R version 2.9.1 and help will not work correctly Please re-install it But alas reinstalling it does not take away the error message. Farrel Buchinsky Google Voice Tel: (412) 567-7870 Sent from Pittsburgh, Pennsylvania, United States On

Re: [R] RGoogleDocs: getDocs() - "problems connecting to get the list of documents"

It is working for me. Are you using the latest version as in Version: 0.2-2? Blackett, Matthew wrote: > > Hi > > I have been using RGoogleDocs successfully for some time now but something > seems to have happened which is preventing me from accessing my data in > google spreadsheets. > > I get

Re: [R] space in column name

No" "Ref.Pv.Name" "DOS" "Pt.Last.Name" "Pt.First.Name" "MRN" "CPT" "CPT.Desc" "DxCd1" "DxCd2" "DxCd3" "DxCd4" [15] "DOE"

[R] space in column name

do if I want to do something such as this > alltime[grep("MIDDLE EAR EXPLORE",alltime$CPT Desc,] Error: unexpected symbol in "alltime[grep("MIDDLE EAR EXPLORE",alltime$CPT Desc" Farrel Buchinsky Sent from Pittsburgh, Pennsylvania, United States [[alternative

Re: [R] Reading from Google Docs

getting with version 0.2-1.You then sent me link to 0.2-2 (in source code) which is what worked. Is it possible that that the windows binary version you put in omegahat was 0.2-1 and not 0.2-2? I did not know how to tell what version had been installed. Farrel Buchinsky Google Voice Tel: (412) 567

[R] Getting value rather than formula in RGoogleDocs

Spreadsheets as a csv then that does not happen. I am using the following line of code in R y2009<-sheetAsMatrix(ts2$y2009,header=TRUE, as.data.frame=TRUE, trim=TRUE) Farrel Buchinsky Google Voice Tel: (412) 567-7870 [[alternative HTML version dele

Re: [R] Reading from Google Docs

erogative to distribute his work as he wishes? Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Jul 8, 2009 at 12:59, Farrel Buchinsky wrote: > Does changing the path in Windows work in real time or does one need to > restart the computer for the changes to take effect. > Farrel B

Re: [R] Reading from Google Docs

Does changing the path in Windows work in real time or does one need to restart the computer for the changes to take effect. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Jul 8, 2009 at 12:04, Gabor Grothendieck wrote: > Its safer just to temporarily add it to your p

Re: [R] Reading from Google Docs

Forgive my naivte, but how do I make windows find tar. In other words from where do I issue the command and what is the command. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Jul 8, 2009 at 10:09, Duncan Murdoch wrote: > On 08/07/2009 10:02 AM, Farrel Buchinsky wrote: > >

Re: [R] Reading from Google Docs

particular there is a choice of the types of documentation to be installed. Farrel Buchinsky Google Voice Tel: (412) 567-7870 2009/6/19 Uwe Ligges > See the manual "R Installation and Administration" for information on how > to install source packages on Windows. > > Uwe L

Re: [R] Reading from Google Docs

y download directory or should I do it in C:\Program Files\R\R-2.9.0\library or should I manually create C:\Program Files\R\R-2.9.0\library\RGoogleDocs and do it all there or will the Rcmd INSTALL RGoogleDocs_0.2-2.tar.gz command do that for me. Yes, you assumed correctly. I am using Windows XP. Farrel

Re: [R] Reading from Google Docs

What do you mean by "cd the.directory.containing.RGoogleDocs" Do you mean the directory where I downloaded the RGoogleDocs_0.2-2.tar.gz to? Or do you mean that I must create a directory called RGoogleDocs under Library and then change to that directory? Farrel Buchinsky Google Voice Tel:

Re: [R] Reading from Google Docs

.gz almost everywhere. I also once got * checking for file 'RGoogleDocs/DESCRIPTION' ... No and there it stopped Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Mon, Mar 2, 2009 at 22:16, Gabor Grothendieck wrote: > Download and install each of R, Rtools and MiKTeX. > Ea

Re: [R] RGoogleDocs: can now see documents but cannot get content.

Where do I get 0.2-2 from?If I go to http://www.omegahat.org/RGoogleDocs/ I can only find Last Release: 0.2-1<http://www.omegahat.org/RGoogleDocs/RGoogleDocs_0.2-1.tar.gz> (08 May 2009) Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, May 20, 2009 at 12:28, Duncan Temple Lang

Re: [R] Tinn R

I posted a screen capture at http://groups.google.com/group/r-help-archive/web/TinnRplayswithR.png On Jun 8, 5:07 pm, "Karin & Martijn" wrote: > Dear R-users, > > I have installed the latest version of Tinn R (Version 2.2.0.2). > With the older versions it was possible to run Tinn R next to R an

Re: [R] Tinn R

screencapture using Jing from Techsmith which is free. Farrel On Jun 8, 5:07 pm, "Karin & Martijn" wrote: > Dear R-users, > > I have installed the latest version of Tinn R (Version 2.2.0.2). > With the older versions it was possible to run Tinn R next to R and then > select

Re: [R] RGoogleDocs: can now see documents but cannot get content.

I already downloaded 0.2-2 -If my memory serves me correctly. If we just go by date, have you updated the files on the server since May 18? Farrel Buchinsky Google Voice Tel: (412) 567-7870 Sent from Pittsburgh, Pennsylvania, United States On Wed, May 20, 2009 at 12:28, Duncan Temple Lang wrote

[R] Converting a list to a data frame or columns at the least

rbind(strsplit (teacher$Date.and.Time.of.Lesson," ")) do.call(rbind(data.frame(strsplit (teacher$Date.and.Time.of.Lesson," " Farrel Buchinsky [[alternative HTML version deleted]] __ R-help@r-project.org mailing list h

[R] RGoogleDocs: can now see documents but cannot get content.

sheet and con = sh...@connection. I have tried many ways but just get: Error in !includeEmpty : invalid argument type Windows Vista (with UAC disabled) R 2.9.0 Farrel Buchinsky [[alternative HTML version deleted]] __ R-help@r-project.org mailing

Re: [R] RGoogleDocs

This is exactly the problem that I was having. I see that you (Duncan) have updated from version 0.2-0 to 0.2-1. Cannot wait to try it. Do you have a compiled version of it for easy use in a Windows environment? If this works it is going to be utterly amazing. Google forms allows one to collect d

[R] Do you use R for data manipulation?

Is R an appropriate tool for data manipulation and data reshaping and data organizing? I think so but someone who recently joined our group thinks not. The new recruit believes that python or another language is a far better tool for developing data manipulation scripts that can be then used by sev

[R] Printing data as a narrative or form letter rather than as a table

, registration.nr, first.name, last.name, human.contact, comment... Human subject 1 dob=5/5/2003, date.of.dx=5/8/2003, registration.nr=568956TJGH, first.name=Farrel, last.name=Buchinsky, human.contact=yes, comment=Spoke with human subject on Tuesday December 27, 2008. They asked questions about the

[R] Reading from Google Spreadsheets with RGoogleDocs

can I troubleshoot this apparently last remaining problem? Farrel J. Buchinsky, MD Director, Respiratory Papillomatosis Program Allegheny-Singer Research Institute 320 E. North Avenue Pittsburgh, PA 15212-4772 __ R-help@r-project.org mailing list http

Re: [R] Reading from Google Docs

= "http://docs.google.com/feeds/documents/private/full/-/spreadsheet";) assignment of an object of class "NULL" is not valid for slot "access" in an object of class "GoogleSpreadsheet"; is(value, "character") is not TRUE Tried google searching and got

[R] two different date formats in the same variable

ternatively how would one code (presumably using regular expressions) a transforamtion or substitution only on the errant entries and thereby turn 06/25/04 into 06/25/2004 and 03/03/59 into 03/03/1959? sessionInfo() R version 2.8.1 (2008-12-22) i386-pc-mingw32 Farrel Buchinsky ___

Re: [R] readline() is reading the entire line and not just the user input

Indeed. I can also get it to work if I type directly in Rterm. But not when running from Tinn-R. If this is a Tinn-R problem (relating to however command lines get from Tinn-R to the Rterm) then perhaps I should post it in the Tinn-R problem. Farrel Buchinsky Sent from: Pittsburgh Pennsylvania

[R] readline() is reading the entire line and not just the user input

fied R user? ") Are you a satisfied R user? > ANSWER [1] "ANSWER <- readline(prompt=\"Are you a satisfied R user? \")" My R environment: Windows XP with service pack 3; R 2.8.1, tinn-R 2.2.0.2 Farrel Buchinsky _

Re: [R] Reading from Google Docs

an I find someone who will give me a couple of basic steps at a time? I am desperate to say goodbye to individual static Microsoft Access or Microsoft Excel spreadsheets being the repository for my data. Farrel Buchinsky Sent from: Pittsburgh Pennsylvania United States. >> > Yes,

Re: [R] forward slash vs double backslash R and Tinn-R

the whole slash thing? Farrel Buchinsky On Fri, Jan 23, 2009 at 11:10, Farrel Buchinsky wrote: > I installed the newest version of R and once again ran into problem > with Tinn-R failing when trying to use the R explorer. I had this > problem once before and solved it when I

[R] forward slash vs double backslash R and Tinn-R

aste(Sys.getenv('APPDATA'), '\\Tinn-R\\tmp\\', sep=''), c('', 'search.txt', 'objects.txt', 'file.r', 'selection.r', 'block.r', 'lines.r'), sep='') BUT IT FAILS. Farrel Buchinsky

[R] R "Threatens" SAS According to The NYT

The article was dugg on Digg. http://digg.com/software/Data_Analysts_Captivated_by_R_s_Power_3 If you Digg, why not digg this. Farrel Buchinsky __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the

Re: [R] Reading from Google Docs

I took the liberty of replacing all the xmlParse in auth.R with xmlTreeParse. Alas still no joy. getDocs(con) Error in UseMethod("xpathApply") : no applicable method for "xpathApply" Farrel Buchinsky GrandCentral Tel: (412) 567-7870 On Mon, Dec 15, 2008 at 20:00, Farrel B

Re: [R] Reading from Google Docs

parser xmlParent(XML) Get parent node of XMLInternalNode or ancestor nodes xmlStopParser(XML) Terminate an XML parser xmlTreeParse(XML) XML Parser Farrel Buchinsky GrandCentral Tel: (412) 567-7870 On Mon, Dec 15, 2008 at 19:56, Duncan Temple Lang wr

Re: [R] Reading from Google Docs

the future, we might" to my attention I can see that I should not have tried it. Farrel Buchinsky GrandCentral Tel: (412) 567-7870 On Mon, Dec 15, 2008 at 19:28, Duncan Temple Lang wrote: > > > Farrel Buchinsky wrote: >> >> Great. I have previously installed 7zip. &g

Re: [R] Reading from Google Docs

- auth.R8,183 9/24/2008 12:44:23 1 file(s), 0 folder(s)8,183 bytes =======

[R] Reading from Google Docs

on a Windows machine. Farrel Buchinsky GrandCentral Tel: (412) 567-7870 __ 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, min

Re: [R] converting multiple columns from POSIX* to Date

I got the whole thing to work, with Hadley Wickham's help. is.POSIXt <- function(x) inherits(x, "POSIXt") dates <- sapply(df, is.POSIXt) df[dates] <-lapply(df[dates], as.Date) Farrel Buchinsky On Fri, Dec 12, 2008 at 11:26, Farrel Buchinsky wrote: > > Some

Re: [R] converting multiple columns from POSIX* to Date

the first row but it is also returning the value as numbers rather than dates. I am now playing around with Hadley Wickham's plyr package. So far looking good but still need to work out a few things. Farrel Buchinsky GrandCentral Tel: (412) 567-7870 On Wed, Dec 10, 2008 at 19:08, Marc Sch

Re: [R] converting multiple columns from POSIX* to Date

I will try that but I am somewhat skeptical since when I go class(date.of.birth) I get not just one word but two: "POSIXt" "POSIXct". Will that not mess up the logical test When I tried the following: lapply(as.list(dataframename),class)=="POSIXt" every it

[R] converting multiple columns from POSIX* to Date

t I could then search for to find how to do it. Farrel Buchinsky __ 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, mini

[R] Power calculations where two samples are of unequal size

I have used the function power.t.test() (power calculations for one and two sample t tests) but have noted that it handles the samples as being the same size. How does one handle sample sizes that are different. In other words how does one handle unbalanced designs. Farrel Buchinsky

[R] outputting (writing) output into a dataframe

ts but I actually want it to output into a data frame so that I can plot it? Farrel Buchinsky __ 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

Re: [R] Tinn-R explorer used to be my friend

inn-R as "Run as administrator". I do not quite understand that because I am an administrator on my machine. But who am I to ask questions --- it works. If you cannot do it I am quite prepared to show you using crossloop. Farrel Buchinsky On Fri, Oct 3, 2008 at 18:04, Farrel Buchinsky

[R] Tinn-R explorer used to be my friend

) R>Configure>Permanent(Rprofile.site). Is this a known bug or am I just getting tripped up. Farrel Buchinsky GrandCentral Tel: (412) 567-7870 [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://sta

[R] Reading OpenOffice Calc spreadsheet into R

calc files into R? Farrel Buchinsky __ 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

[R] using as.POSIXlt on multiple columns or multiple objects

But I got: Error in list(initial$Started, initial$Finished, full.ques$started.ful, : could not find function "list<-" I am clearly missing some basic R issue here. What am I missing? -- Farrel Buchinsky __ R-help@r-project.org

Re: [R] Differentiate alphanumeric vs numeric strings

"123AS23", "A123", "398457") > > grep("^[[:digit:]]*$", x) # index > [1] 1 4 > > grep("^[[:digit:]]*$", x, value=TRUE) # values > [1] "12345" "398457" > > > > > > > > > On Thu, Apr

[R] Differentiate alphanumeric vs numeric strings

e is. What is it and where should I have found it? -- Farrel Buchinsky GrandCentral Tel: (412) 567-7870 [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read th

Re: [R] merging more than 2 data frames

I have created a merged data frame and in turn merged that with another dataframe. I could see how it could become a pain if you had lots of dataframes. I would try running a for loop...but have never done it. "joseph" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi > merge() t

Re: [R] genetics package not working

e lays out exactly the format that is being used. "Farrel Buchinsky" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > >From crawling around the internet it appears to me as if genetics has > >given > way to GeneticsBase and is part of bioconductor. T

Re: [R] Tinn-R not working well with latest R

I can easily get R to open without an error. I simply removed the Tinn-R related lines from the Rprofile.site file C:\Program Files\R-2.6.2\etc\Rprofile.site but then when I try to manually load the svIDE library by entering library(svIDE) from the command line, I get a similar error. So when y

[R] Tinn-R not working well with latest R

rror, several great features in Tinn-R are not working properly. Any solutions or workarounds? -- Farrel [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the p

Re: [R] Analyzing Publications from Pubmed via XML

) Does "somefunction" exist? If there are any further questions do you think I should migrate this conversation to the bioconductor mailing list? Farrel Buchinsky __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r

Re: [R] Analyzing Publications from Pubmed via XML

[[i]]) } I am now trying to work through that approach to see what I can come up with. -- Farrel Buchinsky __ 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/

Re: [R] Analyzing Publications from Pubmed via XML

task for me. Is that not true? On Dec 13, 2007 9:12 PM, Rajarshi Guha <[EMAIL PROTECTED]> wrote: > > On Dec 13, 2007, at 9:03 PM, Farrel Buchinsky wrote: > > > I would like to track in which journals articles about a particular > > disease > > are being publi

[R] Analyzing Publications from Pubmed via XML

n RSS feed into a CSV file? -- Farrel Buchinsky GrandCentral Tel: (412) 567-7870 [[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 ht

Re: [R] Calculating proportions from a data frame rather than a table

and accross all studies prop.table(addmargins(coinf.table,1),1)# to see proportions for all studies added together On 10/3/07, Farrel Buchinsky <[EMAIL PROTECTED]> wrote: > Genius! Thank you very much. > Yes indeed I should have thought of that. For some reason I have a > mental blan

Re: [R] Calculating proportions from a data frame rather than a table

Genius! Thank you very much. Yes indeed I should have thought of that. For some reason I have a mental blank about the use of row.names and instead I repeatedly put that kind of data as a column in the data frame. Thank you for the rescue. __ R-help@r-pr

Re: [R] Calculating proportions from a data frame rather than a table

epayan Sarkar <[EMAIL PROTECTED]> wrote: > > On 10/3/07, Farrel Buchinsky <[EMAIL PROTECTED]> wrote: > > Your solution would work if the data frame contained the raw data. In > that > > case the table function as you outlined would be a table crossing all > the >

Re: [R] Calculating proportions from a data frame rather than a table

# > Attention: > This e-mail message is privileged and confidential. If you are not the > intended recipient please delete the message and notify the sender. > Any views or opinions presented are solely those of the author. > > This e-mail has b

Re: [R] Calculating proportions from a data frame rather than a table

here). Can I post an .Rdata file here? If so I would be able to show you what I mean. On 10/3/07, John Kane <[EMAIL PROTECTED]> wrote: > > > --- Farrel Buchinsky <[EMAIL PROTECTED]> wrote: > > > How do you create a table from a data frame? I tried > > as.t

Re: [R] Calculating proportions from a data frame rather than a table

wrote: > > What am I missing here? > > Cannot you just create the table from the data.frame > and apply prop.table()to it? > > --- Farrel Buchinsky <[EMAIL PROTECTED]> wrote: > > > When one has raw data it is easy to create a table > > of one variable ag

[R] Calculating proportions from a data frame rather than a table

th papers. I have thought of going through the reshape package but I suspect that there is an easier way to convert a data frame to a table. Is there? -- Farrel Buchinsky [[alternative HTML version deleted]] __ R-help@r-project.org mailing l

[R] ifelse and dates do not work together: What workaround?

you to the posting guide and its recommended reading of the help page might still be helpful. -- Farrel Buchinsky GrandCentral Tel: (412) 567-7870 __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting gui