清空筛选条件
清空筛选条件

Matrix creation which identify link of vehicles

2 次查看（过去 30 天）
Fayyaz
Fayyaz 2014-7-4
回答： Jos (10584) 2014-7-11
Hello.
I've a matrix 61312*3.
1st column: from 1 to 81 (Origin place of a vehicle) 2nd column: from 1 to 81 (Destination place of a vehicle) 3rd column: from 1 to 246 (where the vehicle has surveyed)
There are 61312 observation (no. of rows) at 246 locations.
I need to create a matrix which shows that from origin (1 to 81) to Destination (1 to 81) which location (1 to 246) these vehicle follow. I think the order of the matrix will be 81*81.
Kindly let me know how should I proceed. thanks in advance.

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

采纳的回答

Andrei Bobrov
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]];
  5 个评论
显示 3更早的评论
Fayyaz
Fayyaz 2014-7-4
@Andrei Bobrov: The order of matrix is 81*246 which is fine, but the problem is in one cell there is a lot of information like brackets, value*double etc.
Fayyaz
Fayyaz 2014-7-4
编辑：Fayyaz 2014-7-4
I've modified the code, as I need a matrix 81*81, but still I don't know how to get rid of such kind of values like 440x1 double
A=combinedfile;
[a,~,ii] = unique(A(:,1));
[b,~,jj] = unique(A(:,2));
out1 = accumarray([ii,jj],A(:,3),[max(ii), max(jj)],@(x){x});
out = [[{nan};num2cell(a(:))],[num2cell(b(:)');out1]];

请先登录，再进行评论。

更多回答（1 个）

Jos (10584)
Jos (10584) 2014-7-11
M = accumarray(A(:,[2 3]), A(:,1), [81 81], @(x) {x})

类别

在 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!

Translated by