toaster (version 0.5.5)

viewTableSummary: Invoke a Data Viewer on table statistics.

Description

view computed column statistics in a spreadsheet-style viewer in R.

Usage

viewTableSummary(tableInfo, types = NULL, include = NULL, except = NULL, basic = FALSE, percentiles = FALSE)

Arguments

tableInfo

data frame with columns statistics to display.

types

vector with types of columns to include: numerical ("numeric"), character ("character" or date/time ("temporal")

include

a vector of column names to include. Output never contains attributes other than in the list.

except

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

basic

logical: if TRUE display minimum, maximum, average, deviation and mode (if present)

percentiles

logical: if TRUE display percentiles

Details

When both parameters basic and percentiles are FALSE view displays all statistics.

See Also

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')
viewTableSummary(pitchingInfo, percentiles=TRUE)

viewTableSummary(pitchingInfo, types=c("numeric", "temporal"))
}