toaster (version 0.5.5)

getNumericColumns: Filter numeric columns.

Description

Select numeric columns (names or rows) from table info data frame.

Usage

getNumericColumns(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, getTemporalColumns, 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>")

pitchingInfo = getTableSummary(channel=conn, 'pitching_enh')
getNumericColumns(pitchingInfo)
num_cols_df = getNumericColumns(pitchingInfo, names.only=FALSE)
}