Find unique column values in NxN cell array

Question

tybo1mos 2022-12-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1868967-find-unique-column-values-in-nxn-cell-array

回答： Paul 2022-12-2

I have a 1000x50 cell array with each column contining multiple duplicate entries.

simplified example:

names = {'red','blue','green';'red','orange','yellow';'orange','orange','red'};

{'red' } {'blue' } {'green' }

{'red' } {'orange'} {'yellow'}

{'orange'} {'orange'} {'red' }

I would to create a simplified array wich contains only the unique values from each of the indiviual columns:

result:

{'red' } {'blue' } {'green' }

{'orange'} {'orange'} {'yellow'}

{'red' }

2 个评论
显示无隐藏无

tybo1mos 2022-12-2

在 MATLAB Online 中打开

My original data is actually in table form. So my prference would be to work from the original table data, and rutun a table with only unique values.

Starting:

color_1     color_2     color_3 
________    ________    ________
'red'       'blue'      'green' 
'red'       'orange'    'yellow'
'orange'    'orange'    'red'  

Reult

color_1     color_2     color_3 
_______    ________    ________
'red'       'blue'      'green' 
'orange'    'orange'    'yellow'
                        'red'  

Paul 2022-12-2

Is that result feasible? I thought each table variable has to have the same number of rows?

请先登录，再进行评论。

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

Answer 1

Paul 2022-12-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1868967-find-unique-column-values-in-nxn-cell-array#answer_1117907

在 MATLAB Online 中打开

Because the resulting variables could all have a different number of elements, I'm converting each variable into a scalar cell that contains the desired data

t = table({'red';'red';'orange'},{'blue';'orange';'orange'},{'green';'yellow';'red'})
t = 3×3 table
       Var1          Var2          Var3   
    __________    __________    __________

    {'red'   }    {'blue'  }    {'green' }
    {'red'   }    {'orange'}    {'yellow'}
    {'orange'}    {'orange'}    {'red'   }
t = varfun(@(x){unique(x,'stable')},t)
t = 1×3 table
     Fun_Var1      Fun_Var2      Fun_Var3 
    __________    __________    __________

    {2×1 cell}    {2×1 cell}    {3×1 cell}
t.(1){:}
ans = 2×1 cell array
    {'red'   }
    {'orange'}
t.(2){:}
ans = 2×1 cell array
    {'blue'  }
    {'orange'}
t.(3){:}
ans = 3×1 cell array
    {'green' }
    {'yellow'}
    {'red'   }