MATLAB Answers

How can I work with categorical variables in Neural Network Toolbox 6.0 (R2008a)?

91 views (last 30 days)
I want to use the NEWSOM neural network for clustering. My dataset contains both numerical and categorical variables; in the documentation, however, I can only find how to work with numerical variables.

Accepted Answer

MathWorks Support Team
MathWorks Support Team on 22 Mar 2013
The ability to work with categorical variables is not available in the Neural Network Toolbox. It is supported with the Statistics Toolbox.
To work around this issue, you need to represent your categories as numerical values. In general there are two approaches:
1. Represent each category as an integer. For example if you have categories 'small', 'medium' and 'large' you could say 'small' = 0, 'medium' = 1, 'large' = 2. Although in general this idea should work fine when you only have categorical variables, you may need to pay attention to scaling when you also have numerical variables. The idea is that a numeric change for one input of the net (for example integers representing one of your categorical variables) should have roughly the same importance as the same numeric change to another input (for example one of your numerical variables). There are several tools in the Neural Network Toolbox that help you scale your inputs, see the "Processing Functions" section in the Neural Network Toolbox documentation.
Normally start with MAPMINMAX if this does not perform well you could try MAPSTD or possibly PROCESSPCA. You can apply these functions manually, or you can apply them automatically to an input by setting the 'processFcns' property for the input.
2. Use 1-of-N encoding. For example if you once again have the 'small', 'medium' and 'large' categories you could say 'small' = [1 0 0], 'medium' = [0 1 0], 'large' = [0 0 1]. When you use this method scaling should not be as much as an issue as in the other method. Also this type of encoding might work better for "unordered" categories. For small,medium,large assigning 0,1,2 in the other method seemed pretty straightforward but what if you have 'red', 'green', 'blue'? Then (for argument's sake ignoring frequency of light) there is no natural ordering so it is difficult to say whether 'red' = 0, 'green' = 1, 'blue' = 2 is better (will work better) than 'red' = 2, 'green' = 1, 'blue' = 0. The 1-of-N encoding 'red' = [1 0 0], 'green' = [0 1 0], 'blue'= [0 0 1], should not have this problem.
Narmada Herath
Narmada Herath on 26 Jul 2019
If you have additional questions feel free to contact MathWorks Technical Support at
who may be able to assist further.

Sign in to comment.

More Answers (1)

SK on 2 Jan 2020
Hello: I am working to predict electricity demand (load) and I am having many categorical variables as inputs to a Neural Network Time Series NARX app (eg: months (12 categories spelled out January -December), days (seven categories: 1 - 7), and Hours in each day (1 thru 24). When I load my excel data table to assign "Inputs" as my variables, the Matlab is not able to read and display my categorical variable "Months" because the values are spelled out January thru December. Should I write a simple line code such as below, or is there a different way to flag those variables as Categorical for NARX neural networks? I prefer not to convert Months into 1-12 as Matlab will assume some scale (Month 12 is higher than Month 6, etc). Thank you in advance!
T.HE = categorical(T.HE); T.MONTH = categorical(T.MONTH);T.WEEKDAY = categorical(T.WEEKDAY);

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!