How to remove the row of matrix which contains same value in specific columns?
2 views (last 30 days)
Show older comments
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 Comments
Answers (1)
KSSV
on 8 Feb 2018
Edited: KSSV
on 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 Comments
See Also
Categories
Find more on Other Formats in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!