Converting categorical data to prespecified numbers

Question

Danielle Leblance 2018-5-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/399698-converting-categorical-data-to-prespecified-numbers

编辑： Walter Roberson 2018-5-8

Hi,

I have a categorical array : ['SC' 'SC' 'SC' 'SC' 'SC' 'SC' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'MI' 'MI' 'MI' 'MI' 'MI' 'MI' 'MI' 'MI' 'MN' 'MN' 'MN' 'MN' 'MN' 'MN'];

I want to convert each category to a number of my choice: for instance SC should be 23, GA=10;MI=13,MN=15 etc... How can I do so?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Guillaume 2018-5-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/399698-converting-categorical-data-to-prespecified-numbers#answer_319285

在 MATLAB Online 中打开

keys = categorical({'SC', 'GA', 'MI', 'MN'});
values = [23, 10, 13, 15];
[found, where] = ismember(yourcategoricalarray, keys)
correspondingvalues = nan(size(yourcategoricalarray));
correspondingvalues(found) = values(where(found));

correspondingvalues will be nan for those entries you don't care about.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Ameer Hamza 2018-5-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/399698-converting-categorical-data-to-prespecified-numbers#answer_319249

在 MATLAB Online 中打开

You can do the do this as follow,

data = {'SC' 'SC' 'SC' 'SC' 'SC' 'SC' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA'...
  'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA'...
  'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA'...
  'GA' 'GA' 'GA' 'GA' 'MI' 'MI' 'MI' 'MI' 'MI' 'MI' 'MI' 'MI' 'MN' 'MN'...
  'MN' 'MN' 'MN' 'MN'};
dataCategorical = categorical(data);
tablePattern = categorical({'SC', 'GA', 'MI', 'MN'});  % make list of all unique pattern
valueValue = [23, 10, 13, 15]; % make list of all values corrosponding to unique patterns
index = (dataCategorical' == tablePattern)*(1:4)';
data2Value = valueValue(index);

6 个评论
显示 4更早的评论隐藏 4更早的评论

Ameer Hamza 2018-5-8

编辑：Walter Roberson 2018-5-8

在 MATLAB Online 中打开

@Danielle Leblance's answer moved here:

dataCategorical = categorical(StateNo); 
tablePattern = categorical({'AL' 'AK' 'AZ' 'AR' ...
      'CA' 'CO' 'CT' ...
      'DE' 'DC'...
      'FL' 'GA' 'HI' ...
      'ID' 'IL' 'IN' 'IA' ...
      'KS' 'KY' 'LA' ...
      'ME' 'MD' 'MA' 'MI' 'MN' 'MS' 'MO' 'MT' ...
      'NE' 'NV' 'NH' 'NJ' 'NM' 'NY' 'NC' 'ND' ...
      'OH' 'OK' 'OR' 'PA' 'RI' ...
      'SC' 'SD' 'TN' 'TX' ...
      'UT' 'VT' 'VA' ...
      'WA' 'WV' 'WI' 'WY' 'WY'}); 
valueValue = [1 2 3 4 5 6 7 9 48 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 50 51];
index = (dataCategorical' == tablePattern)*(1:52)';
data2Value = valueValue(index);

I am receiving an error: Matrix dimensions must agree.

Error in == (line 41) t = (acodes == bcodes) & (acodes ~= 0);

Error in ConvertStateToMyNumber (line 10) index = (dataCategorical' == tablePattern)*(1:52)';

could it be because there are categories that are not included as i simply decided to ignore them. For example I have a catgory XX that I don't care about . There are many of these.

Danielle Leblance 2018-5-8

make them nan. I will look at Guillaume's answer

Guillaume 2018-5-8

Note that you could have used the same method as in my answer (construct nan matrix, then fill with valueValue(index)) with Ameer's method. However using ismember is probably faster and certainly a lot less demanding in memory than the 2D array generated by the implicit expansion of ==

请先登录，再进行评论。