Table column operations

This task allows you to do mathematical operation on a Table column.

It works with the column names, supports basic operations, comparator, parenthesis and some math functions.

Examples

Let's say you have this Table with the column A, B, C, D

A	B	C	D
1	10	11	-9
2	8	10	-6
3	6	9	-3

Here is few example that you can write in the operations config.

• Addition : A + B + C
• Constant : A + 10
• Subtraction : A - C
• Multiplication : A * C
• Division : A / C
• Exponentiation : A ** C
• Modulus : A % C
• Floor division : A // C
• Advanced exemple : (A + B) / (C * D)

Comparaison

This task support comparaison, it will return the string True or False.

Comparaison operators : ==, !=, >, <, >= and <=

Math functions

This task supports basic math functions : sin, cos, exp, log, expm1, log1p, sqrt, sinh, cosh, tanh, arcsin, arccos, arctan, arccosh, arcsinh, arctanh, abs, arctan2 and log10.

Example : log(A)

Define column names

You can define a custom column name in the operations. Example : E = A + B, this will set the result in the E columns.

Multiple operation

Multiple operation are possible but it requires an assignment to a new columns.

For exemple, if you want to create 2 new calculated columns you could do write 2 operation (in 2 different lines) :

E = A + B
F = C - D

The result of the previous operation can also be use for the next operation (here we use the new column E to calculate F) :

E = A + B
F = E - D

Advanced usage

This task uses the eval function of python dataframe. To see all the possibility, check the following link : https://pandas.pydata.org/pandas-docs/stable/user_guide/enhancingperf.html#expression-evaluation-via-eval