Hi, Can I use formulas for quickly calculate values for a new column using data from other columns (like Excel style)?
Hello!
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