Description Usage Arguments Details Value Examples
dpColumnPropertiesR
calculates the column properties of an R data frame.
1 2 | dpColumnPropertiesR(in_project_id, in_table_id, input_tbl,
collapse_with = "|")
|
in_project_id |
character The UUID ID for the project in which this table is to be included. |
in_table_id |
integer The table sequence number for table to analize. |
input_tbl |
data.frame The data frame to analize. |
collapse_with |
= "|" character The characer string used with |
The data frame is typically loaded from a text file, Excel sheet, or other tabular structure.
For DBMS resident data you should use dpColumnPropertiesSQL to avoid downloading all rows to R.
data.frame with a row for each column in input_tbl and columns:
project_id - UUID of project with this table
table_id - of table with these columns
column_id - integer sequence of column
column_name - from table meta-data
column_type - from table meta-data. NULL if no meta-data in which case all columns loaded as text
column_content_type - most predominate type discovered in text date. NULL not text.
column_dommain - as discovered by scan. PLACE HOLDER FOR VER 0.2 (URL, ZIP, Phone, Date, Age, ...)
num_rows - number of rows in table (nrow(input_tbl))
num_nulls - number NA's in column
num_distinct - number distinct values in column
num_empty - if character, number null-strings (as distinct from NAs), else NA
num_numeric - if character, number represinting numbers, else NA
num_date - if character, number representing dates or timestamps, else NA
mean - NA if not numeric
minimum - smallest value as string
first_quartile - value at 25
second_quartile - value at 50
third_quartile - value at 75
maximum - largest value as string
min_length - minimum number of characters or significant digits
max_lenght - maximum number of characters or significant digits
head - collapsed head()
limited to 250 characters
tail - collapsed tail()
limited to 250 characters
bottom - collapsed head(sort())
limited to 250 characters
top - collapsed tail(sort())
limited to 250 characters
1 2 3 4 5 6 7 | ## Not run:
dpProjID <- dpTables$project_id[1]
dpTblID <- 1
Tbl <- read_csv(dpTables$table_source[dpTblID])
dpColProp <- dpColumnPropertiesR(dpProjID, dpTblID, Tbl)
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.