MATLAB: I imported data from a large excel file and now I want to delete the rows that have the values of column “dds” equal to 1 or 7. How to proceed

deleterows

I imported data from a large excel file and now I want to delete the rows that have the values of column "dds" equal to 1 or 7. How can I proceed?

Best Answer

ddscol = 4;   %set according to which column it is in
YourData( ismember(YourData(:,ddscol), [1, 7]), :) = [];   %delete the rows where dds is 1 or 7

Related Solutions

MATLAB: Choose rows that the first column is larger than the second column

A(A(:,1)>A(:,2),:)

MATLAB: Dear all: I have a 5*2 matrix. i want to find out the row and column of a special value.let A=[1 2;4 5; 1 8;2 6;9 7] I want to find the row and column of 9 and 7.how can i do this

If your matrix has the same number of columns as your vector, as in your example, you just have to find the row:

r = find(ismember(A, [9 7], 'rows'))

Related Question