- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
The numeric-transform parser will load data from a column in a source data table and map values to other values before producing a numeric variable within a collection.
It inherits attributes and behaviors from its parent: parser - numeric.
The numeric-transform parser contains a set of attributes for converting numeric values from a source column into new values before loading into a numeric variable within a collection.
Attribute - operator
The operator attribute is required.
{
"parser_type": "numeric-transform",
"column": "cccc",
// The value of the operator attribute is a numeric operator
// which can either be applied directly to a value,
// or used in conjunction with a constant.
//
// Options without constant include:
// "log" - log base 10
// "ln"
// "log2"
// "boxcox10"
// "log_pseduo" - adds a pseudocount of 1 to all input values
// "ln_pseudo" - adds a pseudocount of 1 to all input values
// "log2_pseudo" - adds a pseudocount of 1 to all input values
// "sin"
// "cos"
// "tan"
// "asin"
// "acos"
// "atan"
// "abs"
// "floor"
// "ceiling"
// "round"
// "sqrt"
// "exp"
//
// Options which require constant include:
// "+"
// "-"
// "*"
// "/"
// "%"
// "^"
// "log+" - adds logs of both value and constant
// "ln+" - adds logs of both value and constant
// "log2+" - adds logs of both value and constant
// "boxcox10+" - adds logs of both value and constant
// "log-" - subtracts log of constant from log of value
// "ln-" - subtracts log of constant from log of value
// "log2-" - subtracts log of constant from log of value
// "boxcox10-" - subtracts log of constant from log of value
//
"operator": "ln",
"collection": "collection_name",
"collection": "variable_name"
}
Attribute - constant
The constant attribute is optional.
{
"parser_type": "numeric-transform",
"column": "cccc",
"operator": "*",
// The constant attribute is used in conjunction
// with operator to transform values.
//
"constant": 10
"collection": "collection_name",
"collection": "variable_name"
}
Was this article helpful?