How to effectively assign values to different location in a TABLE?
20 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
balandong
am 3 Aug. 2017
Kommentiert: balandong
am 4 Aug. 2017
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?
0 Kommentare
Akzeptierte Antwort
Peter Perkins
am 3 Aug. 2017
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
Weitere Antworten (1)
Cong Ba
am 3 Aug. 2017
Bearbeitet: Cong Ba
am 3 Aug. 2017
%%copied from your question
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];
VV = num2cell(S);
%%assign the column without using for loop
table(nums,1) = VV';
Siehe auch
Kategorien
Mehr zu Data Type Conversion finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!