toaster (version 0.5.5)

getCharacterColumns: Filter character columns.

Description

Selects character columns (names or rows) from table info data frame.

Usage

getCharacterColumns(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

getNumericColumns, 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')
getCharacterColumns(pitchingInfo)
char_cols_df = getCharacterColumns(pitchingInfo, names.only=FALSE)
}