How to insert vector to table?

Question

Sierra 2022-9-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1794120-how-to-insert-vector-to-table

回答： Robert U 2022-9-5

for example, I want to insert vector into NoshellRings. I've tried but error occured.

It said that The value cannot be replaced because the number of elements on the left and right sides is different.

Please let me know how to solve this.

Thanks.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

dpb 2022-9-3

You must either have exactly the same number of elements in the vector as height() of the table or have an indexing expression for the values to be replaced that contains exactly the same number of locations to replace as the number of elments in the vector. No tolerances allowed.

You've not provided enough information for us to be able to know what either of the vector size is, but the table has 4779 rows so to replace the whole variable the vector has to have 4779 elements, no more, no fewer.

You can replace parts of the whole thing, of course, but then you have to have something like

tVariableName.NoshellRings(1:3)=vector; % if your vector is 3-elements long and you want to replace the first 3

The indexing expression can be explict indices as above or a logical addressing vector, but the count simply has to match.

请先登录，再进行评论。

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

Answer 1

Robert U 2022-9-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1794120-how-to-insert-vector-to-table#answer_1042050

在 MATLAB Online 中打开

Hi Sierra,

if you want to save vectors in table elements you can use cell arrays:

testTable = table;
testTable.Sex = ['M';'M';'F';'M';'I'];
testTable.Length = [0.455; 0.350; 0.53; 0.44; 0.33];
testTable.NoShellRings = [4; 7; 9; 10; 7];
testVector = [1 2 3 4 5];
testTable.NoShellRings = arrayfun(@(dIn) {dIn},testTable.NoShellRings);
testTable.NoShellRings{3} = testVector
testTable = 5×3 table
    Sex    Length    NoShellRings 
    ___    ______    _____________

     M     0.455     {[        4]}
     M      0.35     {[        7]}
     F      0.53     {[1 2 3 4 5]}
     M      0.44     {[       10]}
     I      0.33     {[        7]}

If you want to replace portions of the table with values given in a vector you follow dpb's comment.

testTable = table;
testTable.Sex = ['M';'M';'F';'M';'I'];
testTable.Length = [0.455; 0.350; 0.53; 0.44; 0.33];
testTable.NoShellRings = [4; 7; 9; 10; 7];
testVector = [2 3 4; 6 7 8];    % testVector = [index; value];
testTable.NoShellRings(testVector(1,:)) =  testVector(2,:)
testTable = 5×3 table
    Sex    Length    NoShellRings
    ___    ______    ____________

     M     0.455          4      
     M      0.35          6      
     F      0.53          7      
     M      0.44          8      
     I      0.33          7      