community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

DUMMY ENCODING (Categories to Numerical)

Alteryx Partner

Hello Community,

 

I forgot to mention the Dummy Encoding macro I had uploaded in the gallery few weeks back. It converts all the categorical values to numerical ones through dummy encoding. It is very helpful in Regression problems. Please find attached the macro.

 

Cheers !

Highlighted
ACE Emeritus
ACE Emeritus

Very nice.  I'd love to see something similar to what's possible with R's vtreat or some of the transformations available in sklearn, which can be saved for use at scoring time. (e.g. apply vtreat in R to the training data, and save that exact "treatment plan" off; then at scoring time, load it up to ensure we are treating the "data to score" in the same way we treated the training data; similarly concepts apply with sklearn.prep objects in Python).

Cheers!

John

Labels