Applying Pythonic formula

The Apply Pythonic Formula operation applies a custom formula using Python syntax. Written by Zafer Çavdar
Updated over a week ago

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.