How to filter based on matching string
36 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposte (1)
KSSV
il 11 Ott 2018
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'),:)
3 Commenti
Vedere anche
Categorie
Scopri di più su Digital Filter Analysis in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!