Faster Looping for Griding/Binning Data

Hi all;

I want to grid my data with following code:

Lat=data(:,7);

Lon=data(:,8);

vprg=data(:,9);

test1=[vprg Lon Lat];

latedges=-10:0.1:10;

lonedges=80:0.1:160;

test2 = zeros(numel(lonedges)-1,numel(latedges)-1);

for i=1:numel(lonedges)-1,

for j=1:1:numel(latedges)-1,

test2(i,j)=size(test1(test1(:,2)>=lonedges(i) & test1(:,2)< lonedges(i+1) & test1(:,3)>= latedges(j) & test1(:,3)< latedges(j+1),:),1);

end

end

However, it is very slow. Probably, there is another option to make it faster. Thank you for your hep.

EK

Answer 1

[Bruno Luong]

test2 = histcounts2(test1(:,2),test1(:,3),lonedges,latedges)

Answer 2

[Sindar]

check out discretize