How to delete columns if there is'nt enough data?

2 次查看（过去 30 天）
Gerrit Liedtke
Gerrit Liedtke 2018-5-7
编辑： Ameer Hamza 2018-5-7
Hi,
I want to delete some columns of my data if there are less than 13 observations in it. If I would use rmmissing and 'MinNumMissing' then the column would be deleted if there are 13 values missing.
Thanks for help.
  3 个评论
显示 1更早的评论
Bob Thompson
Bob Thompson 2018-5-7
编辑：Bob Thompson 2018-5-7
I would suggest using a for loop with an if statement that looks for nan values.
for k = 1:size(data,2);
if sum(~isnan(data(:,k)))<13;
data = [data(:,1:k-1),data(:,k+1:end)];
end
end
You would need to have some check for first and last rows, but that should get you started on what I was thinking about.

请先登录，再进行评论。

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

回答（2 个）

David Fletcher
David Fletcher 2018-5-7
prunedData = rmmissing(dataMatrix,2,'MinNumMissing',13)
Ameer Hamza
Ameer Hamza 2018-5-7
编辑：Ameer Hamza 2018-5-7
Do it as follow
data = data(:, sum(~isnan(data))>=13)

类别

在 Help Center 和 File Exchange 中查找有关 Correlation and Convolution 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by