Back to Prql

Derive

web/book/src/reference/stdlib/transforms/derive.md

0.13.12319 B
Original Source

Derive

Computes one or more new columns.

prql
derive {
  name = expression,
  # or
  column,
}

Examples

prql
from employees
derive gross_salary = salary + payroll_tax
prql
from employees
derive {
  gross_salary = salary + payroll_tax,
  gross_cost = gross_salary + benefits_cost
}