How to remove the row of matrix which contains same value in specific columns?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
I have a dataset (just a subset of a larger dataset, attached excel file). In the dataset, I want to remove the rows which have 1 in 3rd and 4th column. How can I do it in MATLAB.
0 Kommentare
Antworten (1)
KSSV
am 8 Feb. 2018
Bearbeitet: KSSV
am 8 Feb. 2018
[num,txt,raw] = xlsread('delete_one.xls') ;
num(num(:,3)==1,:) = [] ; % remove rows with one in thrid column
num(num(:,4)==1,:) = [] ; % remove rows with one in fourth column
For flottant numbers better to use:
tol = 10^-3 ;
num(abs(num(:,3)-1)<tol,:) = [] ;
num(abs(num(:,4)-1)<tol,:) = [] ;
0 Kommentare
Siehe auch
Kategorien
Mehr zu Other Formats 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!