Scanning a column in matrix with repeated values

1 次查看（过去 30 天）
Sunny
Sunny 2018-12-19
评论： Sunny 2018-12-20
There are four coulmns (Subject, Number, ID, ANS) in a table named 'List'. I initialized a structure with each cell having zero matrices for unique value in subject list based on below code. Once this is done I want to scan the column Subject(which has repeated values) and place the ANS value of each row in the Zero matrix of that subject number at 'IDxNumber' (index). This repeates for every subject value found in the Subject column which is 10 next.
List table
Subject Number ID ANS
9 1 10 -1
9 2 10 1
9 3 10 -1
10 1 5 1
10 2 6 -1
c = 1;
for b = 1:max(List.Subject)
for a = 1:length(List.Subject)
if List.Subject(a) == b
count_id = sum(List.Subject(:) == b);
Subject_Assist{c} = zeros(101,count_id);
c = c+1;
end
end
end
  2 个评论
the cyclist
the cyclist 2018-12-19
编辑：the cyclist 2018-12-19
What MATLAB data type is List? Is it really a table? Or is it a cell array or some other data type? The reason I ask is that sometimes people use the term "table" a little more loosely.
I've added a solution below under the assumption that it is really a table.

请先登录，再进行评论。

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

采纳的回答

the cyclist
the cyclist 2018-12-19
编辑：the cyclist 2018-12-19
This code does the initialization. I'm still trying to figure out what you mean about filling it in.
[Edited afterward to fill in.]
% The original data
Subject = [9;9;9;10;10];
Number = [1;2;3;1;2];
ID = [10;10;10;5;6];
ANS = [-1;1;-1;1;-1];
% The original table
List = table(Subject,Number,ID,ANS);
% Find the unique subjects, and their corresponding rows
[uniqueSubject,~,indexFromUniqueBackToAll] = unique(List.Subject);
numberUniqueSubjects = numel(uniqueSubject);
% Create a cell array with one element per subject
output = cell(numberUniqueSubjects,1);
% For each subject ...
for ns = 1:numberUniqueSubjects
% Index that subject;s rows
indexThisSubjectsRows = find(indexFromUniqueBackToAll==ns);
numberRowsThisSubject = numel(indexThisSubjectsRows);
% initialize a matrix of zeros of apprpriate size
output{ns} = zeros(101,numberRowsThisSubject);
% Fill in ANS at the indicated rows
for ni = 1:numberRowsThisSubject
output{ns}(List.ID(indexThisSubjectsRows(ni)),List.Number(indexThisSubjectsRows(ni))) = List.ANS(indexThisSubjectsRows(ni));
end
end
  5 个评论
显示 3更早的评论
the cyclist
the cyclist 2018-12-19
If you want to upload a MAT file with your full table List, I can try to take a look.
Sunny
Sunny 2018-12-20
I figured out the issue its due to NaN. Thanks

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by