Removing rows from all columns based on values of one column

107 views (last 30 days)
Hi all, i have a data of 732x26 and one of the column contains unwanted values, i used
logicalIndex = FOMassFlow > MeanFOMassFlow;
FOMassFlow = FOMassFlow(FOMassFlow ~= 0)
to remove the unwanted values of the particular column. How can i remove the rows of the unwanted values in the data of 732x26 ? (example, unwanted values found in column 5 row 6, i would like to remove the entire row 6 in the data of 732 rows by 26 columns)

Accepted Answer

Jos (10584)
Jos (10584) on 20 Feb 2015
Here is an example
X = randi([1 10],10,3) % example data
TF = X(:,3) > 5 % for which rows is column 3 larger than 5
X(TF,:) = [] % remove those rows

More Answers (1)

Shrirang
Shrirang on 20 Feb 2015
Hi Crixus, Suppose name of your data matrix is X which is of size 732*26 and you want to remove row 6 then you can use following syntax X(6,:) = [] this will delete your 6th row in X matrix. I hope this will help you.
  1 Comment
crixus
crixus on 20 Feb 2015
Edited: crixus on 20 Feb 2015
Thanks for your answer, the code would remove the 6th row but does it remove the 6th row based on the unwanted values of say, column 5 row 6 ? The code you provided is more of specifying which row you wanna delete right ?

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!