MATLAB: Last non nan observation findnan Hi, I have a matrix and I want to find in each column the last non nan observation. Is there a neat way of doing it quickly? Regards Best Answer I'm not sure if you're looking for the indices (row number) or the actual value of the last non nan observation. So here are both: B = ~isnan(A); % indices Indices = arrayfun(@(x) find(B(:, x), 1, 'last'), 1:size(A, 2)); % values Values = arrayfun(@(x,y) A(x,y), Indices, 1:size(A, 2)); Related SolutionsMATLAB: Find the last NaN value in cell array and compare it with the next column Yeah...the nonnumeric content of the cells containing hex strings changes things...those all return a logical array and not just a single true/false.i1=cellfun(@(c)all(isnan(c)), A(:,11)); % A is your array, of course...Alternatively, if it is known that the only locations that aren't hex strings are [NaN] and there aren't other numeric values besides NaN, i1=cellfun(@isnumeric, A(:,11)); % A is your array, of course... MATLAB: Is there a simpler way to find the index of the first non NaN value in a vector X= [NaN NaN 1 2 3 4 5]; first_non_NaN_index_of_X = find(~isnan(X), 1); Related QuestionCorrelation between two row matricesI have a matrix (10,2), but when im using find(isnan) on this it becomes (1,10) can someone tell me why? i delet 10 of the nansFill NaNs in array with last valueFinding NON in matrixParsing a vector by NaN into separte, unequal vectors into a cell array
Best Answer