Calculated column — calculatedColumn

Add a column computed from an expression over existing columns.

Use cases

• Derive total = price * quantity or margin = revenue - cost.
• Build a ratio or percentage from two columns.

What it does

Evaluates a column-based arithmetic expression and appends the result as a new column. All original columns are preserved unchanged.

Configuration

The editor offers formula templates that fill the expression from your upstream column names.

Generated Python code

df_2 = df_1.eval('total = price * quantity')

Tips & common mistakes

• Arithmetic expressions only (column names, numbers, + - * /, parentheses). For if/else logic use Conditional column; for ranks/running totals use Window function.
• Reference columns by their exact name; quote names with spaces per pandas eval rules.

See also

• Conditional column · Window function