This content has been marked as final. Show 3 replies
The ROC result is for binary target only. How many distinct values does your target column contain?
You are rignt, I have 6 categories/ target values. In the old Oracle Data Miner software, it was possible to set the "preferred target value" during model building, so ROC curve was generated for this target value and the "other values".
So in SQL Developer Data Miner, is it possible to set preferred target value (in a multi categorical target value set) to get ROC curve?
Thank you for your reply!
We don't have "preferred target value" during model building in the new data miner. However, you can use the Transform node to transform your target into 2 classes (preferred target value and others). You then use the output from the Transform node as input source for your model build.
Here is a process to transform your target into 2 classes:
- Create a Transform node
- In Transform node, select the target column, click "Add Transformation" icon on the toolbar
- In the Add Transform dialog, select "Custom" Binning Type, click "Generate Default Bins" button (accept default settings)
- In the "Custom bin values" listbox, remove the non-preferred target values (select the values and click the "Remove Transformation" icon on the toolbar)
- Now, you should have one preferred target value in the "Custom bin values" listbox, click OK to finish
You can now connect the Transform node to a Build node. In the Build node, select the transformed target (it should have the "_BIN" suffix in the name) as the Target for model build.
Hope this help!