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

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.

[Bob Thompson]

Since you can't have uneven array column lengths, what values do you have in place of the missing observations?

[Gerrit Liedtke]

I have NaN when a observation is missing

[Bob Thompson]

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.

Answer 1

[David Fletcher]

prunedData = rmmissing(dataMatrix,2,'MinNumMissing',13)

Answer 2

[Ameer Hamza]

Do it as follow

data = data(:, sum(~isnan(data))>=13)