Last data update: 2014.03.03
|
R: Invoke a Data Viewer on table statistics.
viewTableSummary | R Documentation |
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"))
}
Results
|