numeric-transform
  • 27 Jul 2022
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

numeric-transform

  • Dark
    Light
  • PDF

Article summary

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?

What's Next