[R] error with sqldf v0-1.4

martin trobec trobecgeologygroup at shaw.ca
Sun Dec 14 19:30:11 CET 2008




Gabor Grothendieck wrote:
> 
> I can't reproduce this.
> 
> Make sure you are using the same version of sqldf as shown
> below, try it in a fresh session and if you still get an error provide the
> data in reproducible form using dput, i.e. dput(kdv)
> 



Hi Gabor

Please find attached the kdv.dat file you requested using dput(kdv), and I 
have also attached my session log as a txt file.

My operating system is winxp home sp3, if this is important.

Appreciate your help, attachments below

Martin

session output:
> str(kdv)
'data.frame':   71 obs. of  3 variables:
 $ dpss: num  0.117 0.144 0.164 0.166 0.165 ...
 $ npdp: num  0.1264 0.0325 0.0109 0.0033 0.0055 ...
 $ logk: num  1.12 1.29 1.41 1.41 1.42 ...
> library(sqldf)
Loading required package: DBI
Loading required package: RSQLite
Loading required package: gsubfn
Loading required package: proto
> sqldf("select * from kdv")
Error in get("fun", env = this, inherits = TRUE)(this, ...) : 
  could not find function "combine"
> packageDescription("sqldf")$Version
[1] "0-1.4"
> 

and the dataset output from dput(kdv.dat):
structure(list(dpss = c(0.1174, 0.1438, 0.1636, 0.166, 0.1649, 
0.1661, 0.1713, 0.1705, 0.1643, 0.1571, 0.1569, 0.1591, 0.154, 
0.1207, 0.0783, 0.0309, 0.0359, 0.0325, 0.0175, 0.0025, 0.0052, 
0.0598, 0.1157, 0.1241, 0.1202, 0.1198, 0.1228, 0.1033, 0.0703, 
0.0946, 0.1247, 0.1366, 0.1122, 0.059, 0.0589, 0.0768, 0.0939, 
0.1096, 0.1171, 0.1095, 0.1392, 0.1276, 0.1171, 0.1275, 0.1376, 
0.1364, 0.1352, 0.134, 0.1223, 0.1085, 0.0962, 0.0871, 0.0306, 
0.0487, 0.0668, 0.0828, -3e-04, -0.0163, -0.0271, -0.014, -9e-04, 
0.0072, 0.014, 0.0184, 0.021, 0.0236, 0.0261, 0.0275, 0.0288, 
0.0341, 0.0393), npdp = c(0.1264, 0.0325, 0.0109, 0.0033, 0.0055, 
0.0245, 0.0245, 0.0129, 0.0273, 0.037, 0.0264, 0.0282, 0.0383, 
0.0505, 0.0546, 0.2887, 0.2974, 0.232, 0.209, 0.2131, 0.208, 
0.1454, 0.0899, 0.0835, 0.0892, 0.0922, 0.1035, 0.1396, 0.1872, 
0.0952, 0.0466, 0.0167, 0.0247, 0.0946, 0.242, 0.2049, 0.1757, 
0.1486, 0.129, 0.1253, 0.1138, 0.105, 0.0942, 0.0679, 0.048, 
0.0482, 0.0494, 0.0532, 0.0619, 0.07, 0.0751, 0.0714, 0.107, 
0.0981, 0.0942, 0.0958, 0.2625, 0.2618, 0.2678, 0.2547, 0.2463, 
0.2472, 0.2494, 0.2534, 0.2562, 0.2453, 0.2166, 0.1927, 0.1868, 
0.1877, 0.2062), logk = c(1.122903649, 1.292479808, 1.405156753, 
1.414112258, 1.418506787, 1.450318405, 1.542765692, 1.522641121, 
1.444016675, 1.345795076, 1.184265443, 0.865145447, 0.78650298, 
0.839069329, 0.733478141, -1.728158393, -1.562249437, -1.442492798, 
-1.348721986, -1.271646218, -1.206209615, -0.909036923, -0.337903555, 
-0.221704009, -0.153230046, -0.23128792, -0.326518303, -0.581036169, 
-1.367542708, 0.26245109, 0.687528961, 0.604226053, 0.582790368, 
0.131650738, -1.396855627, -1.153044675, -0.998266287, -0.70158362, 
-0.643018599, -0.732828272, -0.090818524, -0.290475644, 0.048519488, 
0.266983885, 0.247113642, 0.094086627, -0.070172519, 0.043205039, 
-0.21903497, -0.215525356, -0.573326112, -0.70289635, -0.886056648, 
-0.731188096, -0.301899454, -0.396855627, -1.732828272, -1.596879479, 
-1.493494968, -1.410050399, -1.3400838, -1.279014256, -1.226213555, 
-1.179142011, -1.13667714, -1.097997109, -1.062482108, -0.664943481, 
-0.736837535, -0.871600731, -0.651111277)), .Names = c("dpss", 
"npdp", "logk"), class = "data.frame", row.names = c(NA, -71L


-- 
View this message in context: http://www.nabble.com/error-with-sqldf-v0-1.4-tp21001041p21003078.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list