queryActigraph function

Query ActiGraph File

This function executes a SELECT query on an ActiGraph AGD file.

queryActigraph(datfile, qry)

Arguments

• datfile: An AGD file.
• qry: An SQL SELECT statement.

Returns

A data frame with query results.

Details

AGD files are actually SQLite databases. This function requires the RSQLite package. The user is encouraged to directly interface with the database by creating a connection with the DBI package. This has been tested with AGD files produced with ActiLife v6.11.

Examples

## Not run:

dat <- queryActigraph("actfile.agd", "SELECT * FROM data LIMIT 5")

queryActigraph("actfile.agd", "SELECT * FROM settings")

## directly interface using DBI package
con <- DBI::dbConnect(RSQLite::SQLite(), "actfile.agd")
DBI::dbListTables(con)
DBI::dbDisconnect(con)
## End(Not run)

See Also

readActigraph

Author(s)

Cole Beck cole.beck@vumc.org