Keywords: Pythonic formula, Python syntax, functions
The Apply Pythonic Formula operation enables the use of Python syntax to apply formulas on data. For example,
sum = $a + $b adds the values in field "b" to those in field "a" and inserts the resulting sums into the new field "sum".
// (integer division)
< (smaller than)
<= (smaller than or equal to)
== (is equal)
!= (not equal)
>= (greater than or equal to)
> (greater than)
abs (absolute value)
degrees (radian to degrees)
radians (degrees to radian)
acosh (hyberbolic arc-cosine)
asinh (hyberbolic arc-sin)
atanh (hyberbolic arc-tan)
sinh (hyberbolic sin)
tanh (hyberbolic tan)
lgamma (logaritmic gamma)
1. Open the operation configuration window
Select the field with the text that you want to extract keywords from and click the "Add operation" button at the top of the workspace.
Search for "Apply pythonic formula" or find the operation under "Numerical operations" and click it.
2. Type the formula
The structure of the formula should be:
[Output field name] = [Pythonic formula].
3. Apply the operation
Click "Apply" to run the operation. The output of the applied formula is inserted into the output field.