Onehotencode function is giving more columns which are filled with zeros than the number of categories.

Question

Yagiz Dereboy 2021-9-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1449954-onehotencode-function-is-giving-more-columns-which-are-filled-with-zeros-than-the-number-of-categori

回答： Yagiz Dereboy 2021-9-11

采纳的回答： Mohammad Sami

a = readtable("mushrooms.csv");

aa = categorical(table2array(a));

b = onehotencode(aa(:,1),2);

first column has 2 categories but function creates 23 columns. Which is also the total number of columns in variable a. Also other variables behave the same too and seemingly 2 spesific column in each onehotencoded variable has the true onehotencoded variables. Can you help me please?

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

请先登录，再进行评论。

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

Answer 1

Mohammad Sami 2021-9-10

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1449954-onehotencode-function-is-giving-more-columns-which-are-filled-with-zeros-than-the-number-of-categori#answer_784374

在 MATLAB Online 中打开

Because you are converting the entire matrix in to a categorical matrix, the categories for the entire matrix are common. If you want to have different categories for each column. you will have to convert each columm to caterogical separately.

a = repmat(1:10,10,1);
b = categorical(a)
b = 10×10 categorical array
     1      2      3      4      5      6      7      8      9      10 
     1      2      3      4      5      6      7      8      9      10 
     1      2      3      4      5      6      7      8      9      10 
     1      2      3      4      5      6      7      8      9      10 
     1      2      3      4      5      6      7      8      9      10 
     1      2      3      4      5      6      7      8      9      10 
     1      2      3      4      5      6      7      8      9      10 
     1      2      3      4      5      6      7      8      9      10 
     1      2      3      4      5      6      7      8      9      10 
     1      2      3      4      5      6      7      8      9      10 
categories(b(:,1))
ans = 10×1 cell array
    {'1' }
    {'2' }
    {'3' }
    {'4' }
    {'5' }
    {'6' }
    {'7' }
    {'8' }
    {'9' }
    {'10'}
c = array2table(a);
c = varfun(@categorical,c)
c = 10×10 table
    categorical_a1    categorical_a2    categorical_a3    categorical_a4    categorical_a5    categorical_a6    categorical_a7    categorical_a8    categorical_a9    categorical_a10
    ______________    ______________    ______________    ______________    ______________    ______________    ______________    ______________    ______________    _______________

          1                 2                 3                 4                 5                 6                 7                 8                 9                 10       
          1                 2                 3                 4                 5                 6                 7                 8                 9                 10       
          1                 2                 3                 4                 5                 6                 7                 8                 9                 10       
          1                 2                 3                 4                 5                 6                 7                 8                 9                 10       
          1                 2                 3                 4                 5                 6                 7                 8                 9                 10       
          1                 2                 3                 4                 5                 6                 7                 8                 9                 10       
          1                 2                 3                 4                 5                 6                 7                 8                 9                 10       
          1                 2                 3                 4                 5                 6                 7                 8                 9                 10       
          1                 2                 3                 4                 5                 6                 7                 8                 9                 10       
          1                 2                 3                 4                 5                 6                 7                 8                 9                 10       
categories(c{:,1})
ans = 1×1 cell array
    {'1'}