How can I delete rows in which a specific value is present?
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Vishnu Roy
il 28 Ott 2021
Risposto: Star Strider
il 28 Ott 2021
I have a dataset of 12 columns and 70,000 rows. I want to delete the rows in which any of the columns has a value 999.25 as it represents null in my data set. What would be the simplest way of doing this as a beginner?
0 Commenti
Risposta accettata
Yongjian Feng
il 28 Ott 2021
How about this?
dataset = ones(100, 12); % use your own data instead here
sz = size(dataset);
rowCount = sz(1);
for i=1:rowCount
if any(dataset(i, :) == 999.25)
dataset(i, :) = []; % delete row
end
end
0 Commenti
Più risposte (1)
Star Strider
il 28 Ott 2021
Try something like this —
D = randi(9, 10, 12);
D(randi(numel(D),1,3)) = 999.25
D = D(~any(D==999.25,2),:)
This searches for any ‘999.25’ value by row, and then keeps only the rows without that particular value.
.
0 Commenti
Vedere anche
Categorie
Scopri di più su Database Toolbox in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!