The R Project SVN R-packages

Rev

Rev 3324 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 3324 Rev 3432
Line 4... Line 4...
4 
\docType{package}
 4 
\docType{package}
5 
\title{ SQLite data frames }
 5 
\title{ SQLite data frames }
6 
\description{ S3 and utility methods to implement SQLite data frames. }
 6 
\description{ S3 and utility methods to implement SQLite data frames. }
7 
\details{
 7 
\details{
8 
This package aims to transparently operate on data frames stored in
 8 
This package aims to transparently operate on data frames stored in
- 
 
 9 
SQLite databases. The following functions are known to be working with
9 
SQLite databases.
 10 
SQLiteDF types:\\
- 
 
 11 
 
- 
 
 12 
\strong{sqlite.vector}
- 
 
 13 
\itemize{
- 
 
 14 
\item{Math, Summary, Ops groups}{except for those with 2 args in Math
- 
 
 15 
like \code{round}, and \code{\%\%} and \code{\%/\%} in Ops}
- 
 
 16 
\item{summary}{out of the box works for numeric, integer, character.
- 
 
 17 
Also works for logical, factor using "group by", however factor's do not
- 
 
 18 
handle NA's specially. }
- 
 
 19 
\item{length}{Ok}
- 
 
 20 
\item{\code{\[}}{not yet \code{\[<-}}
- 
 
 21 
\item{sort}{sorts to a new sqlite.vector}
- 
 
 22 
}
- 
 
 23 
 
- 
 
 24 
\strong{sqlite.data.frame}
- 
 
 25 
\itemize{
- 
 
 26 
\item{length}{returns no. of variables}
- 
 
 27 
\item{dimnames, names, row.names}{returns names of variables and rows}
- 
 
 28 
\item{dim, nrow, ncol}{dimension of variables}
- 
 
 29 
\item{\code{\$}, \code{[[}}{returns columns as sqlite.vector. no assignments yet}
- 
 
 30 
\item{\code{[}}{works for numeric & integer indexing (ranges and vectors),
- 
 
 31 
logical indexes with recycling. does not support negative and character (row/column name) indexing.}
- 
 
 32 
\item{is.list}{returns false, so that other functions can }
- 
 
 33 
\item{rbind}{works only when rbind()-ing data frames with the same names()}
- 
 
 34 
\item{with}{Ok}
- 
 
 35 
\item{as.data.frame}{just returns itself}
- 
 
 36 
\item{as.list}{returns a list of sqlite.vector for each variable}
- 
 
 37 
\item{rbind}{currently works only with data.frame's}
- 
 
 38 
\item{lapply, sapply}{out of the box}
- 
 
 39 
\item{summary}{out of the box, after implementing sqlite.vector}
- 
 
 40 
}
10 
}
 41 
}
11 
\author{
 42 
\author{
12 
Miguel A. R. Manese
 43 
Miguel A. R. Manese
13 
Maintainer: Miguel A. R. Manese <jjonphl@gmail.com>
 44 
Maintainer: Miguel A. R. Manese <jjonphl@gmail.com>
14 
}
 45 
}