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

4 次查看(过去 30 天)
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 个评论
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 CenterFile Exchange 中查找有关 Text Data Preparation 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by