how to find the row name which corresponds to a certain value in a table

9 visualizaciones (últimos 30 días)
mohamed
mohamed el 18 de Mzo. de 2016
Comentada: Guillaume el 18 de Mzo. de 2016
hello i named the rows of a table as follows
MT={'A','B','C','D','E'};
the other elements in the table are [S,Rd,Ratio,doi,kd] i want to display the MT at max(s), this is the code i used
for i=1:x
kd(i)=input('perm of damaged zone: ');
doi(i)=input('depth of invasion: ');
rd(i)=doi(i)+rw';
s(i)=((ko/kd(i))-1)*(log(rd(i)/rw))';
Rd=[rd]';
S=[s]';
ji=log(re/rw);
jd(i)=log(re/rw);
jo(i)=(log(re/rw))+(s(i));
R(i)=jd(i)/jo(i);
Ratio=[R]';
table(S,Rd,Ratio,doi,kd,'RowName',MT)

Respuestas (1)

Guillaume
Guillaume el 18 de Mzo. de 2016
t = table(S,Rd,Ratio,doi,kd,'RowName',MT);
[~, maxrow] = max(t.S); %get row index of max
maxrowname = t.Properties.RowNames(maxrow) %get string corresponding to row index
  2 comentarios
mohamed
mohamed el 18 de Mzo. de 2016
Editada: mohamed el 18 de Mzo. de 2016
thank you
but can u tell me what does ~ this means?
Guillaume
Guillaume el 18 de Mzo. de 2016
It means ignore this output. You don't care about the value of the max (1st output), just its position (2nd output).

Iniciar sesión para comentar.

Categorías

Más información sobre Numeric Types en Help Center y File Exchange.

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by