How can I delete rows in which a specific value is present?

Question

Vishnu Roy 2021-10-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1573738-how-can-i-delete-rows-in-which-a-specific-value-is-present

回答： Star Strider 2021-10-28

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

请先登录，再进行评论。

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

Answer 1

Yongjian Feng 2021-10-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1573738-how-can-i-delete-rows-in-which-a-specific-value-is-present#answer_818763

在 MATLAB Online 中打开

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

请先登录，再进行评论。

Answer 2

Star Strider 2021-10-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1573738-how-can-i-delete-rows-in-which-a-specific-value-is-present#answer_818768

在 MATLAB Online 中打开

Try something like this —

D = randi(9, 10, 12);
D(randi(numel(D),1,3)) = 999.25
D = 10×12
0000    5.0000    5.0000    7.0000    8.0000    1.0000    1.0000    8.0000    4.0000    5.0000    8.0000    5.0000
0000    9.0000    7.0000    2.0000    1.0000    5.0000    9.0000    2.0000    9.0000    1.0000    1.0000    2.0000
0000    6.0000    6.0000    3.0000    4.0000    5.0000    8.0000    8.0000    2.0000    8.0000    4.0000  999.2500
0000    4.0000    3.0000    5.0000    3.0000    3.0000    7.0000    2.0000    9.0000    4.0000    6.0000  999.2500
0000    8.0000    2.0000    5.0000    4.0000    4.0000    2.0000    6.0000    3.0000    8.0000    4.0000    4.0000
0000    5.0000    7.0000    9.0000    5.0000    5.0000    5.0000    9.0000    9.0000    6.0000    4.0000    8.0000
0000    5.0000    3.0000    5.0000    5.0000    3.0000    6.0000    5.0000    4.0000    3.0000    6.0000    6.0000
0000    1.0000  999.2500    2.0000    7.0000    2.0000    1.0000    8.0000    5.0000    6.0000    5.0000    7.0000
0000    7.0000    6.0000    4.0000    8.0000    3.0000    9.0000    3.0000    2.0000    5.0000    2.0000    5.0000
0000    7.0000    6.0000    4.0000    3.0000    3.0000    1.0000    2.0000    3.0000    7.0000    8.0000    3.0000
D = D(~any(D==999.25,2),:)
D = 7×12
   5     5     7     8     1     1     8     4     5     8     5
   9     7     2     1     5     9     2     9     1     1     2
   8     2     5     4     4     2     6     3     8     4     4
   5     7     9     5     5     5     9     9     6     4     8
   5     3     5     5     3     6     5     4     3     6     6
   7     6     4     8     3     9     3     2     5     2     5
   7     6     4     3     3     1     2     3     7     8     3