Finding value with row and column headings

3 Ansichten (letzte 30 Tage)
MK
MK am 14 Mai 2021
Beantwortet: Scott MacKenzie am 14 Mai 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 Kommentare
Matt J
Matt J am 14 Mai 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 am 14 Mai 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.

Melden Sie sich an, um zu kommentieren.

Antworten (1)

Scott MacKenzie
Scott MacKenzie am 14 Mai 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.

Kategorien

Mehr zu Tables finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by