Removing rows from all columns based on values of one column

Question

crixus 2015-2-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/179379-removing-rows-from-all-columns-based-on-values-of-one-column

编辑： crixus 2015-2-21

采纳的回答： Jos (10584)

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)

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jos (10584) 2015-2-20

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/179379-removing-rows-from-all-columns-based-on-values-of-one-column#answer_168667

在 MATLAB Online 中打开

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

crixus 2015-2-21

编辑：crixus 2015-2-21

THANKS FOR YOUR SOLUTION. IT WORKS !

请先登录，再进行评论。

Answer 2

Shrirang 2015-2-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/179379-removing-rows-from-all-columns-based-on-values-of-one-column#answer_168664

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

crixus 2015-2-20

编辑：crixus 2015-2-20

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 ?

请先登录，再进行评论。