How to extract minimum values in a row and replace them with their variable?
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Alayt Abraham Issak
el 18 de En. de 2019
Comentada: Alayt Abraham Issak
el 22 de En. de 2019
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 comentarios
Respuestas (1)
Kevin Phung
el 18 de En. de 2019
Editada: Kevin Phung
el 18 de En. de 2019
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 comentarios
Kevin Phung
el 21 de En. de 2019
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
Ver también
Categorías
Más información sobre Tables en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!