create or change variable

Question

HI ,

I'm very new to alteryx . I have a data set containing wine features with one column called "quality". (0 to 10) . I would like

1) change or create a column base on the quality column so I could see all the number between 0-to 5 = non profitable and 6 and up to profitable .

2) I don't know how to do it : with the same column "quality" , separate the number like this depending if it's white or red. It's the profit for each wine .

Wine quality

White wine

Red wine

9-10

50 CAD

60 CAD

7-8

25 CAD

20 CAD

6

5 CAD

1-5

0 CAD

How can I manage to do that ? I have attavhed my workflow .

thank you very much for any tip or help on this .

case 2.yxmd

domax37 · Answer

Hi Phil .

Last question for you and thank you again for your help   . FInd attached my workflow , I'm still trying to figure out if those results are ok or very bad. From the ROC curve I would choose the random forest one . But I don't see what you said about the false negative and false positive.

I split my data 75%-25% and also split red and white. Acuracy are around 71-75% , is this good ?

Case2v1.yxmd

PhilipL · Answer

Hi @domax37

The Intelligence Suite is an additionally licensed component that can be added to Designer that includes what is called Assisted Modeling/Machine Learning. It gives analysts with limited Data Science experience (like myself) access to advanced predictive modeling features, but more importantly the proper guidance through the modeling process.

Designer on its own can do these things well, but you need the data science knowledge to make it happen. Intelligence Suite takes care of that for those of us who need help with key steps like selecting the correct model for our use case, properly profiling and prepping the data variables, and managing the model output.

I like to say that Intelligence Suite is like hiring a chauffeur when you own a car but you don't know how to drive it. Your account manager can get you set up with a demonstration and maybe even a trial if you are interested.

Hope this helps.

Phil

domax37 · Answer

Thank you ! what is the inteligence suite ? It's something outside of Designer Alteryx?

Can I do the same thing within Designer ?

thanks

catherine