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!