Effacer les filtres
Effacer les filtres

How to remove the row of matrix which contains same value in specific columns?

2 vues (au cours des 30 derniers jours)
Abhinav
Abhinav le 8 Fév 2018
Modifié(e) : KSSV le 8 Fév 2018
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.

Réponses (1)

KSSV
KSSV le 8 Fév 2018
Modifié(e) : KSSV le 8 Fév 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,:) = [] ;

Catégories

En savoir plus sur Data Import from MATLAB 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