How to filter based on matching string

Question

Mekala balaji 2018-10-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/423377-how-to-filter-based-on-matching-string

评论： Mekala balaji 2018-10-11

Hi,

I have below cell array, and I want to calculate the summation of the data in column 3 for matching names in column 1 & column 2. I also want to get the indices of matching rows.

Type        Status      Rank
Autostable  Success     23
Auto        Failure     56
Manual      Failure     12
Manual      Disconnect  45
Manual      Success     45
Reinitiate  Success     42
Summation of rank if(output1):
Type: Auto OR Autostable 
Status:Success
Summation of rank if(Output2):
Type: Auto OR Autostable 
Status:Success or Failure
Summation of rank if(Output3):
Type: Auto OR Autostable OR Manual
Status:Success 
Summation of rank if(Output4):
Type: Auto OR Autostable OR Manual
Status:Success OR Failure OR Disconnect
Desired Outputs:
Output1:23
Output2:79
Output3:197
Output4:367

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

请先登录，再进行评论。

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

Answer 1

KSSV 2018-10-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/423377-how-to-filter-based-on-matching-string#answer_340825

Convert your cell arrays into table and use:

Type = {'Autostable'   ; 'Auto' ; 'Manual' ; 'Manual' ; 'Manual' ; 'Reinitiate' }  ;
Status = { 'Success' ; 'Failure'; 'Failure' ; 'Disconnect' ;'Success' ; 'Success'} ;
Rank = [23 56 12 45 45 42]' ;
T = table(Type,Status,Rank) ;
T(contains(T.(1),'Manual'),:)