getNumericColumns: Filter numeric columns.

In teradata-aster-field/toaster: Big Data in-Database Analytics that Scales with Teradata Aster Distributed Platform

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)
}

teradata-aster-field/toaster documentation built on May 31, 2019, 8:36 a.m.