Code for Base Matrix

5 views (last 30 days)
Fayyaz
Fayyaz on 4 Jul 2014
Edited: Andrei Bobrov on 4 Jul 2014
Hello All.
I've a matrix, A=61312*3
1st column: from 1 to 246 (survey no, total 61312 surveys at 246 location, for a vehicle from origin to destination) 2nd column: from 1 to 81 (Origin) 3rd column: from 1 to 81 (Destination)
I need to create a base matrix (81*81) which shows the no. of vehicles among these origins and destinations.
Kindly help me out.

Accepted Answer

Andrei Bobrov
Andrei Bobrov on 4 Jul 2014
Edited: Andrei Bobrov on 4 Jul 2014
[a,~,ii] = unique(A(:,2));
[b,~,jj] = unique(A(:,3));
out1 = accumarray([ii,jj],A(:,1),[max(ii), max(jj)],@(x){x});
out = [[{nan};num2cell(a(:))],[num2cell(b(:)');out1]];
ADD
out1 = accumarray([ii,jj],1);
out = [[nan;a(:)],[b(:)';out1]];
  2 Comments
Fayyaz
Fayyaz on 4 Jul 2014
Thanks for this. Actually I need the total sum for each 1 to 81 origin and destination. Your code was OK for my previous link question, but unfortunately not for this. Can you check it again? or let me know if you didn't understand my question well.
Andrei Bobrov
Andrei Bobrov on 4 Jul 2014
Hi Muhammad! Please try code after word ADD in this answer.

Sign in to comment.

More Answers (0)

Categories

Find more on Phased Array Design and Analysis in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!