Description Usage Arguments Examples
Counts nulls per column in the table.
1 2 3 |
channel |
object as returned by |
tableName |
name of the table in Aster. |
tableInfo |
pre-built summary of columns to use (require when |
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. |
output |
Default output is a data frame in |
percent |
logical: if TRUE then percent of NULL values instead of absolute count returned. To avoid division by zero small error is introduced by incrementing by 1 total count of rows in the table. |
schema |
NULL or character: optional schema to restric table search to signle schema. In general,
table search performed across whole database. Including |
where |
specifies criteria to satisfy by the table rows before applying computation.
The creteria are expressed in the form of SQL predicates (inside |
stringsAsFactors |
logical: should data frame returned have column with variables
(table column names) as factor? Applies only when the output is in |
test |
logical: if TRUE show what would be done, only (similar to parameter |
1 2 3 4 5 6 7 8 9 10 | if (interactive()) {
# initialize connection to Dallas database in Aster
conn = odbcDriverConnect(connection="driver={Aster ODBC Driver};
server=<dbhost>;port=2406;database=<dbname>;uid=<user>;pwd=<pw>")
null_counts = getNullCounts(conn, "baseball.batting",
include=c('g','ab','r','h','so','bb','cs'),
where='yearid > 2000')
}
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.