Row index exceeds matrix dimensions

1 次查看(过去 30 天)
Hi
I have a 143x4 matrix, which looks like this
A=[ 1 556037.025 6237642.046 5.964;
1 556037.035 6237642.041 5.960;
1 556037.028 623742.041 5.967;
2 556032.654 623730.067 10.368;
2 556032.652 623730.060 10. 364;
4 556042.000 623730.000 5.000;
4 556042.002 623730.005 5.010] ;
Column 1 is the point number, column 2-4 are X,Y,Z coordinates.
Each point is measured between 1 and 5 times.
My code is:
A=load('Test.txt');
A=sortrows(A);
T=array2table(A);
m=varfun(@mean,T,'GroupingVariables',1);
out=A;
out(:,2:end)=out(:,2:end) - m{A(:,1),3:end}
I get the error Row index exceeds table dimensions
I have tried to test different scenarios and the error occurs when a point is missing, for example if there is no point number 7, so the first column goes from 6 to 8.
Any idea what is wrong?
  4 个评论
Peter Larsen
Peter Larsen 2019-4-24
Hi
It works until the numbers in column 1 skips a number (See updated revision). If the point number skips from 2 to 4 without having a point number 3, the error occurs

请先登录,再进行评论。

采纳的回答

Andrei Bobrov
Andrei Bobrov 2019-4-24
T = array2table(A);
m = varfun(@mean,T,'GroupingVariables',1);
out = A;
[~,~,ii] = unique(A(:,1));
out(:,2:end) = out(:,2:end) - m{ii,3:end};

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Matrices and Arrays 的更多信息

产品


版本

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by