How to install sqldf to R with version 2.10?
On 17/03/2012 16:25, Uwe Ligges wrote:
On 17.03.2012 17:20, Joshua Ulrich wrote:
On Sat, Mar 17, 2012 at 9:56 AM, zhu free<freezhu8 at gmail.com> wrote:
Hi, How to install sqldf to R with version 2.10? I used the R in the cluster of university and there seems no way to update the R version to 2.14. However, I do need sqldf. I tried to install and there is the problem of namespace. How could I solve the problem of namespace and run sqldf on R with version 2.10? Thank you!
Download and unpack the sqldf source, add a NAMESPACE file, then build the Windows binary using R-2.10.x and Rtools210 or Rtools211.
I don't think the OP is using Windows on a cluster. The point is that the new sqldf may not be compatible with the old
And in any case, there is no 'R 2.10', as the posting guide points out.
release of R - and I don't have such an old version around for testing. Anyway: Go to CRAN and the package's archive, you will find old versions of the package that may work with the old R-2.10.x
And possibly older versions of all the packages it depends on/imports to. But, I do have R 2.10.1 around, so I can reproduce the problem: * installing *source* package ?sqldf? ... ** R ** demo ** inst ** preparing package for lazy loading Loading required package: proto Error : package 'gsubfn' does not have a name space ERROR: lazy loading failed for package ?sqldf? So the unstated problem is that sqldf does not work with gsubfn in R < 2.14.0. And the solution as Uwe said is to use an older version of sqldf (at least). 'zhu free' really does need to study the posting guide at http://www.r-project.org/posting-guide.html, and learn to post answerable questions.
Uwe Ligges
All these steps are documented throughout the "Writing R Extensions" manual. http://cran.r-project.org/doc/manuals/R-exts.html HTH, -- Joshua Ulrich | FOSS Trading: www.fosstrading.com
Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595