How to extract minimum values in a row and replace them with their variable?
조회 수: 1 (최근 30일)
이전 댓글 표시
I have four colums and 928 rows in a table. I would like to extract the smallest number in each row and replace it with the variable (title/name) at the top of the column in which the value came from.
I have managed to extract the smallest number by changing the table into an array. However, I was not able to change that small value into the name of the column. Moreover, I do not prefer changing the table into arrays becasue I would like to have my final result in a table format.
How may I do so? Find the smallest value in a row and replace it with its title in a table?
댓글 수: 8
답변 (1개)
Kevin Phung
2019년 1월 18일
편집: Kevin Phung
2019년 1월 18일
If you want to have both numeric and strings in your table, those table elements will have to be cell arrays.
for example, if you have :
a = {1 2 3 4 5}; % your data values, stored in cells.
table1 = table(a',a',a')
tableVarNames = {'a','b','c'}; %your column names
table1.Properties.VariableNames = tableVarNames
to change a table element from numeric to a string, running :
table1{1,3} = tableVarNames(1)
will give you:
table1 =
5×3 table
a b c
___ ___ ___
[1] [1] 'a'
[2] [2] [2]
[3] [3] [3]
[4] [4] [4]
[5] [5] [5]
So something like this will find the minimum for each row and replace it with variable names:
for i = 1:size(table1,1)
[M,I] = min(cell2mat(table1{i,:})) %M is the minimum value, I is the indice
table1{i,I} = tableVarNames(I); %changes that value to a variableName
end
댓글 수: 4
Kevin Phung
2019년 1월 21일
You got the error because your AB table needs to be cell arrays.
Can you try table2cell for your ABTable.
so:
ABTable = table2cell(Subset) % this is now a matrix of cells, NOT a table
tableVarNames = {'Plmt','S107','S108','S11','S112'} % your variable names
for i = 1:size(ABtable,1)
[M,I] = min(cell2mat(ABtable{i,:})) %M is the minimum value, I is the indice
Subset{i,I} = tableVarNames(I); %makes changes to your main table, Subset
end
참고 항목
카테고리
Help Center 및 File Exchange에서 Tables에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!