Formula for table column

Hi, Can I use formulas for quickly calculate values for a new column using data from other columns (like Excel style)?


You can use any of the platform’s built-in functions in the AddNewColumn dialog.
This dialog opens from the toolbar when a table view is open.

You can also use any custom scripts here (R, NodeJS, Python, ect.).

For example, screenshot shows the use of custom script (BMI on Python) and a built-in function (if):

Paying your attention to the syntax for using the script: Namespace:ScriptName

List of built-in functions can be found here, collection of demo scripts in various languages ​​here, AddNewColumn dialog Wiiki page here.

Good luck using Datagrok!

Thanks! very helpful