Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

I want to convert the decision tree description into VBA for an Excel sheet.

Hac

Has this been done? If so, can you point me in the right direction? I am not an experienced VBA person.

Find more posts tagged with

AI Studio

Excel

Decision Tree

Accepted answers

Telcontar120

RapidMiner is the text operator I am most familiar with. You could try looking at the text processing tutorials on RapidMiner Academy if you want to get a feel for how they work. It sounds like perhaps tokenizing by linguistic sentences may give you the building blocks you would need, but a lot of it would be specific to the format required in your VBA implementation.
Why do you need to implement your DT in an Excel workbook with VBA at all? Once you have built your model, RapidMiner is built to do your scoring for you, just by feeding it the raw data for new cases you can easily output your predictions and confidences directly.

All comments

Telcontar120

Well, you can export the tree rules from the description pretty easily as text. After that I think you are going to need some kind of text parsing tool to handle the conversion. You might be able to build this inside RapidMiner if you know all the other parts of the VBA code you need and are comfortable using the Process Documents and related text mining operators, but there may be more direct way of handling this directly within VBA as well (I am no VBA expert either).

Hac

I have extracted the text with no problem. I am not used the text mining operators in Rapid Miner and did not think that would be an option. The good part is that the tree description is short. Any recommendations for a text parsing tool?

Telcontar120

Hac

Please close this discussion.