Matrix Creation Code Problem

2014 7 4
1 个回答
回答已采纳
更新时间：2014 7 6
9 次查看（30 天）

0 个投票

Hello.
I've a matrix 61312*3.
1st column: from 1 to 81 (Originating Place)
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 of the location (1 to 246) these vehicle follows. I think the order of the matrix will be 81*81, but there can be more than one value in a cell because of many surveyed location.
With the help of this forum, I've done below coding.
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]];
I get the matrix at the end, but the problems are some cells contains brackets while some contain vaules*1 double (i.e. 440*1 double).
Kindly let me know how should I get rid of these problems. Thanks in advance.

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

 采纳的回答

Andrei Bobrov
Andrei Bobrov 2014-7-6
编辑：Andrei Bobrov 2014-7-6

1 个投票

use
[a,~,ii] = unique(A(:,1));
[b,~,jj] = unique(A(:,2));
f = @(x)x(1); % or f = @(x)x(end); or f = @(x)x(randperm(numel(x),1));
out1 = accumarray([ii,jj],A(:,3),[max(ii), max(jj)],f);
out = [nan,b(:)';a(:),out1];

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Fayyaz
Fayyaz 2014-7-6
Hi Andrei, thanks for this.
Now the other problems solved, but this time I get only one value in the cell in the matrix, but there can be more than one values in the cell, because the vehicles can go through many locations (through 1 to 246) from Origin (1 to 81) to Destination (1 to 81)
Andrei Bobrov
Andrei Bobrov 2014-7-6
You want 3d matrix?
Fayyaz
Fayyaz 2014-7-6
编辑：Fayyaz 2014-7-6
I want a matrix 81*81, but there should be multiple values in cells i.e. from Origin (1*81) to Destination (1*81), a vehicle can go through multiple locations i.e. (1 to 246). I don't know whether it should be 3d or not.
Fayyaz
Fayyaz 2014-7-6
@Andrei, the previous code was perfect, except instead of brackets there should be zero, and instead of 440*1 double, it should be 1.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Graphics Performance 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by