MATLAB: How to effectively assign values to different location in a TABLE

Question

Dear all, Pertaining to the above subject. I want to assign the elements in vector S to the TABLE at each of the locations as defined in the vector NUMS

nums =[5;6;7;12;13;14;16;17;18];
v1_threshold = 0.1:0.1:0.2;
table  = cell2table (repmat({nan},20,(numel(v1_threshold))));
S =[1,1,1,1,1,1,1,0,1];

The expected output in the TABLE should be something like

Table = {NaN;NaN;NaN;NaN;1;1;1;NaN;NaN;NaN;NaN;1;1;1;NaN;1;0;1;NaN;NaN} % Element in column 1 of TABLE
Table ={NaN;NaN;NaN;NaN;NaN;NaN;NaN;NaN;NaN;NaN;NaN;NaN;NaN;NaN;NaN;NaN;NaN;NaN;NaN;NaN} % Element in column 2 of TABLE

Initially, I thought the code should be something like

VV = num2cell (S);
for i =1:length (VV)
table (nums(i),1) = VV (i) ;
end

However, I am interested to know if there is a way to avoid the FOR loop?

I really appreciate if someone can show what I have been missing?

Answer 1

This question is really unclear. The best I can guess is that you want to assign S into specified rows of one variable in a table that's been pre-allocated with all NaN.

The first thing, as I said in at least one other thread, is that you should stay away from cell arrays. All you have are numbers.

The second thing is don't name one of your variables "table".

The following does what my best guess is at what you want:

>> i =[5;6;7;12;13;14;16;17;18];
>> S =[1,1,1,1,1,1,1,0,1];
>> t = array2table(nan(20,3));
>> t.Var1(i) = S
t =
  20×3 table
    Var1    Var2    Var3
    ____    ____    ____
    NaN     NaN     NaN 
    NaN     NaN     NaN 
    NaN     NaN     NaN 
    NaN     NaN     NaN 
      1     NaN     NaN 
      1     NaN     NaN 
      1     NaN     NaN 
    NaN     NaN     NaN 
    NaN     NaN     NaN 
    NaN     NaN     NaN 
    NaN     NaN     NaN 
      1     NaN     NaN 
      1     NaN     NaN 
      1     NaN     NaN 
    NaN     NaN     NaN 
      1     NaN     NaN 
      0     NaN     NaN 
      1     NaN     NaN 
    NaN     NaN     NaN 
    NaN     NaN     NaN