When Otherwise function

Definition: This will allow you to get average of a column which has numbers. Make sure that the data type is correct like integer, float etc.

Example: You can type a command like

When student_age < 17 then junior_student else senior_student

With the above condition it will create a new column and if th studen_age is less than 17 then it writes “junior_student” else “senior_student”

Note 1

If you have entered some command on Ask On Data and it is asking for variables/input for that command but you want to abort that operation, then simply type "Abort".

Note 2

We will keep on retraining Ask On Data ML algorithm, hence its accuracy will keep on increasing and it will be capable of understanding more syntaxes in simple language

Reach out on support@askondata.com for any questions or help