toaster (version 0.5.5)

getTemporalColumns: Filter Date and Time Table Columns.

Description

Selects date and time columns (names or rows) from table info data frame.

Usage

getTemporalColumns(tableInfo, names.only = TRUE, include = NULL, except = NULL)

Arguments

tableInfo

data frame obtained by calling getTableSummary.

names.only

logical: if TRUE returns column names only, otherwise full rows of tableInfo.

include

a vector of column names to include. Output is restricted to this list.

except

a vector of column names to exclude. Output never contains names from this list.

See Also

getCharacterColumns, getNumericColumns, getTableSummary

Examples

if(interactive()){
# initialize connection to Lahman baseball database in Aster 
conn = odbcDriverConnect(connection="driver={Aster ODBC Driver};
                         server=<dbhost>;port=2406;database=<dbname>;uid=<user>;pwd=<pw>")

masterInfo = getTableSummary(channel=conn, 'master')
getTemporalColumns(masterInfo)
date_cols_df = getTemporalColumns(masterInfo, names.only=FALSE)
}