viewTableSummary: Invoke a Data Viewer on table statistics.

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

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

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