I have done a fresh install of package sqldf on my system, but whenever i run any sql queries I get
Error in rsqlite_send_query(conn@ptr, statement) : no such table
regardless of the name or table
I have looked through all guides on setting the package up etc and read the pdf, for some unknown reason it just wont work on my machine where it works fine at work.
example code - "a corrected answer on stacked overflow copied so should just work"
library(sqldf)
apps.rsd <- structure(list(appid = c(173L, 717L, 996L, 209L, 602L, 255L),
cid = c(4L, 15L, 21L, 5L, 13L, 6L),
price = c(0, 0, 0, 1.99, 0, 0.76),
count = c(411, 411, 210, 18, 921, 22),
sum = c(1226, 1870, 871, 66, 3948, 86),
mean = c(2.98296836982968, 4.54987834549878, 4.14761904761905, 3.66666666666667, 4.28664495114007, 3.90909090909091),
sd = c(1.73897694746568, 0.958668345866094, 1.31370760232218, 1.33373734360862, 1.62114131819336),
rcount = c(3, 3, 3, 5, 5, 7),
rsum = c(7, 0, 0, 13, 0, 19),
rsd = c(2.3094010767585, 2.3094010767585, 2.3094010767585, 2.19089023002066, 2.19089023002066, 2.1380899352994)),
.Names = c("appid", "cid", "price", "count", "sum", "mean", "sd", "rcount", "rsum", "rsd"),
class = c("data.table", "data.frame"),
row.names = c(NA, -6L))
sqldf("SELECT appid FROM 'apps.rsd' WHERE rcount > 50")**