How to get row index based on two columns

29 visualizaciones (últimos 30 días)
Mekala balaji
Mekala balaji el 28 de Nov. de 2018
Respondida: Andrei Bobrov el 28 de Nov. de 2018
I have below cell array, I want to get the row index if 2nd column is "Continuous" & 3rd Column is <=80.
12 Continuous 891
72 Continuous 23
82 Continuous 562
222 Break 25
132 Continuous 23
832 Break 23
833 Break 23
Desired output(row index):
2
5

Respuesta aceptada

Andrei Bobrov
Andrei Bobrov el 28 de Nov. de 2018
C = {12 'Continuous' 891
72 'Continuous' 23
82 'Continuous' 562
222 'Break' 25
132 'Continuous' 23
832 'Break' 23
833 'Break' 23};
C = cell2table(C);
rows = find(ismember(T.C2,'Continuous') & T.C3 <= 80);

Más respuestas (1)

Jos (10584)
Jos (10584) el 28 de Nov. de 2018
tf1 = strcmp(YourCellArray(:,2), 'Continuous')
tf2 = cat(1, YourCellArray{:,3}) <= 80
DesiredRows = find(tf1 & tf2)

Productos


Versión

R2016a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by