Using Formulas¶
Excel provides the ability to create complex formulas for computing new values based on arbitrary selections of cells.
![../../../_images/excel-formula.png](../../../_images/excel-formula.png)
Dataiku’s approach to tabular data is similar to Excel’s structured references to columns. Instead of referring to cells within a table, Dataiku formulas refer to column names, and the formula is applied to each row in the table. Formulas are provided as a step in Dataiku’s Prepare recipe, along with an expression editor to validate your formula. The expression editor shows a preview of results of your formula, examples of correct syntax, and a reference guide to functions you can use in formulas.
See also
Prepare recipe lessons in the Visual Recipes Overview course
Formula language in the reference documentation