remove rows in cell if a column is equal to a number
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
So this is a simplified version of what I have, I want to remove the rows in X that match the number in the cell Y, so all I would have left is the first row. My real data has over a million rows, is there a quick way to do this? Thanks for your help!
X =
'B737' 'DAL1240' [10]
'MD88' 'DAL1542' [ 9]
'B747' 'DAL1284' [ 9]
'B737' 'DAL1532' [ 4]
'A320' 'DAL1417' [ 4]
Y =
[9]
[4]
0 Kommentare
Antworten (1)
C.J. Harris
am 14 Nov. 2012
X = {'B737' 'DAL1240' [10]
'MD88' 'DAL1542' [ 9]
'B747' 'DAL1284' [ 9]
'B737' 'DAL1532' [ 4]
'A320' 'DAL1417' [ 4]};
Y = {[9]
[4]};
X(ismember(cell2mat(X(:,3)),cell2mat(Y)), :) = [];
2 Kommentare
Azzi Abdelmalek
am 14 Nov. 2012
Bearbeitet: Azzi Abdelmalek
am 14 Nov. 2012
Tiffany you have to accept one of the answers that answers your question by clicking on accept this answer
Siehe auch
Kategorien
Mehr zu Large Files and Big Data finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!