Effacer les filtres
Effacer les filtres

finding the maximum within a specific range

2 vues (au cours des 30 derniers jours)
Salma fathi
Salma fathi le 25 Juil 2022
Commenté : Salma fathi le 25 Juil 2022
Hello,
for the attached table we would like to find the index of the max point of the variable NE8 within the range of (200,400) applied on the variable GDALT. This might be a simpel task and I am complicating it but if anyone can help.

Réponse acceptée

Githin George
Githin George le 25 Juil 2022
Modifié(e) : Githin George le 25 Juil 2022
Hi Salma,
My understanding is that for rows having GDALT in range 200-400 you would like to find the row where NE8 is maximum.
Please see if this code helps
txt = readtable("table.txt");
% I'm adding an Index Column, in case you specifically want the index
txt.INDEX = (1:height(txt))';
subTable = txt(txt.GDALT >=200 & txt.GDALT <=400, :);
% getting idx in the subtable using max function
[~,idx] = max(subTable.NE8,[],'omitnan');
% this row contains the required result. You can use the index from this
% row.
result = subTable(idx,:)
Hope this helps.
  3 commentaires
Githin George
Githin George le 25 Juil 2022
Modifié(e) : Githin George le 25 Juil 2022
I've corrected the mistake in last line. The last element in result will contain the 'index' from original column.
Salma fathi
Salma fathi le 25 Juil 2022
Thank you so much this helped me alot and solved my problem. Appreciate the help.

Connectez-vous pour commenter.

Plus de réponses (1)

KSSV
KSSV le 25 Juil 2022
T =readtable('https://in.mathworks.com/matlabcentral/answers/uploaded_files/1075965/table.txt') ;
NE8 = T.NE8 ;
idx = NE8>200 & NE8<400 ;
val = max(NE8(idx))
val = 0×1 empty double column vector
It looks like there is no data in the given range.

Catégories

En savoir plus sur Logical dans Help Center et File Exchange

Tags

Produits


Version

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by