db_read_toc: Read 'toc' measurements from RRD database and return as an...

In LEEF-UZH/LEEF.analysis: Access Functions, Tests and Basic Analysis of the RRD Data from the LEEF Project

Read toc measurements from RRD database and return as an tbl_SQLiteConnection.

Description

This function does not actually fetch the data, but returns an tbl_SQLiteConnection object which can be further processed / filtered using dplyr. See https://db.rstudio.com/r-packages/dplyr/ for details. To fetch the actual data, execute collect().

Usage

db_read_toc(
  db = getOption("RRDdb", "LEEF.RRD.sqlite"),
  from_timestamp = 20210920,
  to_timestamp = 21000101,
  duplicates = mean
)

Arguments

db	fully qualified path to the sqlite database. Default, read from option RRDdb. If not set, defaults to option RRDdb; if this is not set, defaults to LEEF.RRD.sqlite
from_timestamp	integer. Earliest timestamp to return. Default: 20210920
to_timestamp	integer. Latest timestamp to return. Default: 21000101
duplicates	function which will be used to combine duplicates. If NULL, co summarising is done. Default is 'mean'.

Value

Link to the table density in the RRD to be used with dplyr and friends

LEEF-UZH/LEEF.analysis documentation built on Feb. 8, 2025, 11:18 a.m.