Finding Maximum Value of a Table/Categorical Array
5 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Claire Hollow
il 10 Giu 2020
Commentato: Paresh yeole
il 10 Giu 2020
Hello! I have a question I can not get past. I have a 23000x1 table (named TMAX). It is a categorical array so it is mostly numbers but where the data is missing it is filled in with 'NA'. I am simply just looking to find the maximum value in the table. I did try
max(tmax);
but I get the error
Error using max
Invalid data type. First argument must be
numeric or logical.
I am not how to get past the NA's in there. Would even be open to switching them to NaN, whatever is simplest. Thank you in advance for the help!
0 Commenti
Risposta accettata
Paresh yeole
il 10 Giu 2020
Modificato: Paresh yeole
il 10 Giu 2020
first convert categorical to numeric array :
tmax = str2double(cellstr(tmax));
tmax(tmax == 'NA') = NaN;
max(tmax)
convert the 'NA' into NaN.
max function by default ignores the NaN values
2 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Numeric Types in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!