Obtain all table elements from a column which correspond to certain string in another column

Question

Davindra Usov 2023-3-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1923495-obtain-all-table-elements-from-a-column-which-correspond-to-certain-string-in-another-column

评论： Davindra Usov 2023-3-22

Hello,

I have a table with two columns. The first is a column of strings & the second numbers. I want to obtain all the elements in column 2 that correspond to the string 'Bonus' in column 1.

How can I do this?

Thank you

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

请先登录，再进行评论。

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

Answer 1

Voss 2023-3-5

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1923495-obtain-all-table-elements-from-a-column-which-correspond-to-certain-string-in-another-column#answer_1185695

在 MATLAB Online 中打开

% a table
str = {'Onus';'Bonus';'Loan us';'On us';'Bonus';'Money';'Bonus'};
num = [1;2;3;2;4;3;1];
t = table(str,num)
t = 7×2 table
        str        num
    ___________    ___

    {'Onus'   }     1 
    {'Bonus'  }     2 
    {'Loan us'}     3 
    {'On us'  }     2 
    {'Bonus'  }     4 
    {'Money'  }     3 
    {'Bonus'  }     1 
% get the numbers corresponding to 'Bonus'
bonus_nums = t{strcmp(t{:,1},'Bonus'),2}
bonus_nums = 3×1
     2
     4
     1