Code for Base Matrix

Question

Fayyaz 2014-7-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/140263-code-for-base-matrix

编辑： Andrei Bobrov 2014-7-4

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Andrei Bobrov 2014-7-4

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/140263-code-for-base-matrix#answer_143640

编辑：Andrei Bobrov 2014-7-4

在 MATLAB Online 中打开

[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 个评论
显示无隐藏无

Fayyaz 2014-7-4

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.