|
> |07/30/2009 03:03 PM
> |
> >------
---|
|>
| Subject: |
|>
>-------
I just answered essentially the same question from another person offline
within the last day. Anyways:
"Date" class variables are stored as numbers, i.e. days since
the Epoch, in R and when transferred to sqlite get transferred
as numbers. Try this:
> library(sqldf)
> DF <- data.frame(a = Sys.
How about update R/sqldf?
> require(sqlf)
Loading required package: sqlf
Warning message:
In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return
= TRUE, :
there is no package called 'sqlf'
>
> testframe<-data.frame(sdate=rep(paste
+ ("day",1:5,sep=""),each=5),bext=runif(25
-|
|>
| Subject: |
|>
>---------
Hi Rizzi,
how about a reproducible example/data.frame?
:-)
milton
On Thu, Jul 30, 2009 at 1:46 PM, wrote:
>
> Hello,
>
> I am having a problem using sqldf. I'm trying to choose a subset of
> observations from a data set based on the date and maximum value of a
> variable by date.
>
> Here is
Hello,
I am having a problem using sqldf. I'm trying to choose a subset of
observations from a data set based on the date and maximum value of a
variable by date.
Here is the code I am using:
test<-sqldf("select distinct * from bextuse group by sdate having
bext=max(bext)",method="raw");
The
7 matches
Mail list logo
