filter cell array with strings

Question

Qiana Curcuru 2021-10-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1574098-filter-cell-array-with-strings

编辑： Ive J 2021-10-28

i have a cell array and want to create a chart by filtering values. basically i want to filter by cat1 and cat3.

For example, i want to pull out all rows where 'cat' is the value for cat1 and then pull out rows where '100' is the value for cat3 (i.e. row 1 and 6 in this case)

my cell array looks like:

{cat1} {cat2} {cat3}
{'cat'}  {4}  {100}
{'dog'}  {4}  {100}
{'bird'} {4}  {100}
{'cat'}  {5}  {100}
{'dog'}  {4}  {200}
{'cat'}  {5}  {100}

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

请先登录，再进行评论。

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

Answer 1

Ive J 2021-10-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1574098-filter-cell-array-with-strings#answer_819048

编辑：Ive J 2021-10-28

在 MATLAB Online 中打开

Try to work with tables, they're more versatile. Also check groupfilter for more advanced filtering schemes.

tab = array2table(string(yourCell))
     cat1     cat2    cat3
    ______    ____    ____
    "cat"      4      100 
    "dog"      4      100 
    "bird"     4      100 
    "cat"      5      100 
    "dog"      4      200 
    "cat"      5      100 
    
idx = tab.cat1 == "cat" & tab.cat3 == 100;
newTab = tab(idx, :)
    cat1     cat2    cat3
    _____    ____    ____
    "cat"     4      100 
    "cat"     5      100 
    "cat"     5      100 