Skip to Main Content

Data Science & Machine Learning

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ML+APEX->PREDICTION does not work?

Hi, I am testing ML with Apex Oracle and one step is not working correctly for me. I have generated several prediction models with a sample data set on OML table. If I launch this query on this table:
SQL1-> select nh_id, age, COORDINATION, SKILL, STRENGTH, PSYCHOLOGY, DISCIPLINE, INITIAL TEST, TRAINING, PREDICTION (N1_CLASS_MODEL_TD USING *) from oml
I get these results (the prediction value alternates between 0 and 1, and I put only an example of the first 2 rows)
1 23 8 5 5 5 3 3 1 -> Prediction 1
2 33 8 5 5 3 7 2 2 -> Prediction 0
However, if I launch the query on another table from APEX, to predict the value, the prediction value is always 1 !. I am trying to force a 0 with the following query and neither.
SQL2-> select 2 NH, 33 age, 8 COORDINATION, 5 SKILL, 5 STRENGTH, 3 PSYCHOLOGY, 7 DISCIPLINE, 2 INITIAL TEST, 2 TRAINING, PREDICTION (N1_CLASS_MODEL_TD USING d1. *) PREDICTION from i_datosgenerales d1
2 33 8 5 5 3 7 2 2 -> Prediction 1
What am I doing wrong? I can't get a prediction with value 0.
Because the same query gives me different results.
SQL1-> 2 33 8 5 5 3 7 2 2 -> Prediction 0
SQL2-> 2 33 8 5 5 3 7 2 2 -> Prediction 1
Both queries are launched from APEX
Best regards

Comments

Processing

Post Details

Added on Oct 5 2021
1 comment
76 views