Effacer les filtres
Effacer les filtres

Removing rows from all columns based on values of one column

56 vues (au cours des 30 derniers jours)
crixus
crixus le 20 Fév 2015
Modifié(e) : crixus le 21 Fév 2015
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)

Réponse acceptée

Jos (10584)
Jos (10584) le 20 Fév 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
  1 commentaire
crixus
crixus le 21 Fév 2015
Modifié(e) : crixus le 21 Fév 2015
THANKS FOR YOUR SOLUTION. IT WORKS !

Connectez-vous pour commenter.

Plus de réponses (1)

Shrirang
Shrirang le 20 Fév 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 commentaire
crixus
crixus le 20 Fév 2015
Modifié(e) : crixus le 20 Fév 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 ?

Connectez-vous pour commenter.

Catégories

En savoir plus sur Matrix Indexing dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by