We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Cross validation under decision tree

lixuanzhang
7 - Meteor

I tried to use the cross-validation setting under decision tree, however, when I took a look at the confusion matrix, it is still for the original setting 70/30 split. I attached the workflow. 

 

I saw that there is a cross validation tool but I could not find it under predictive analytics tab. 

 

Thank you.

 

Cross validation 1.PNG

3 REPLIES 3
Garabujo7
Alteryx
Alteryx

Hello, you can download the crossvalidation tool from the Alyteryx community.

 

https://community.alteryx.com/t5/Public-Community-Gallery/Cross-Validation-Tool/ta-p/878754

 

It's free, just download it and install it.

 

If you'd like to add the macro to your predictive palette, here are the instructions as well.

 

Garabujo7_0-1666642652230.png

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Add-Macro-to-toolbar/m-p/184976#M47813

 

 

Gabriel

lixuanzhang
7 - Meteor

Thanks! I will try it out. 

lixuanzhang
7 - Meteor

I now have trouble figuring out how the tool works. I would like to do 10 fold so 90% of the data will be used as training data and 10% of data will be used as testing dataset then this should be repeated 10 times. So every record in the dataset will be used in the testing dataset. However,  the cross-validation needs input from the decision tree first, and in my workflow, the decision tree used 100% of the data. I tried to use create sample tool, but I cannot figure out how to connect which tools to which tools. 

 

I attached the file. The AUC values are below 0.5 which is not correct. 

Labels
Top Solution Authors