Finding value with row and column headings

3 visualizaciones (últimos 30 días)
MK
MK el 14 de Mayo de 2021
Respondida: Scott MacKenzie el 14 de Mayo de 2021
Hi,
I have an array which looks like the following:
I would like to find all values which are greater than 0.95 as well as in which column and row I can find it. Precisely, I would like to get the the information that in column H, row G there is a value of 0.9936.
Thanks for help.
  2 comentarios
Matt J
Matt J el 14 de Mayo de 2021
Wll, you first have to read it into Matlab. Have you used readtable or readmatrix to do this? In what form is the data now?
MK
MK el 14 de Mayo de 2021
Yes, I did. The headings are gone and the table looks like this:
The headings are lost, which I would need to get the information of which rows and colums with that specific heading show values above 0.95.

Iniciar sesión para comentar.

Respuestas (1)

Scott MacKenzie
Scott MacKenzie el 14 de Mayo de 2021
Assuming your data are in a matrix named data, try this...
[row, col] = find(data > 0.95);
The variables row and col identify the locations of the elements > 0.95.

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!

Translated by