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".

Operators supported:

+ (addition)

- (subtraction)

* (multiplication)

^ (exponentiate)

/ (division)

// (integer division)

% (mod)

< (smaller than)

<= (smaller than or equal to)

== (is equal)

!= (not equal)

>= (greater than or equal to)

> (greater than)

Functions supported:

ceil (ceiling)

floor

round

abs (absolute value)

factorial

exp

log10

sqrt

arccos

arcsin

arctan

cos

sin

tan

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)

gamma

lgamma (logaritmic gamma)

hypot (hypotenuse)

log (log2)

Step-by-step guide

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.

Did this answer your question?