Code for Base Matrix
2 次查看(过去 30 天)
显示 更早的评论
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.
0 个评论
采纳的回答
Andrei Bobrov
2014-7-4
编辑:Andrei Bobrov
2014-7-4
[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 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Phased Array Design and Analysis 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!