MATLAB: I have a 101 by 23 matrix, where first column is the ID of persons. I want to extract each value of every person <1.5, and store them in a new matrix, SO resultant matrix should have all values <1.5 and rest can be substituted to 0.

Question

   [numData,~,rawData] = xlsread('C3.csv'); 
    lowscale = zeros(size(numData));
    lowscale = numData(any(numData < 1.5),:);
    

This code is giving me all values which are also > 1.5

Answer 1

lowscale = numData;
lowscale(lowscale < 1.5) = 0;