Finding Maximum Value of a Table/Categorical Array

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!

Answer 1

[Paresh yeole]

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

[Claire Hollow]

I tried doing that but got the following error:

Error using cellstr (line 49)

Conversion to cellstr from table is not

possible.

Error in c02_warmestday (line 10)

tmax = str2double(cellstr(tmax));

I'm very thrown off because there is no line 49 either.

[Paresh yeole]

pass tmax as a array (categorical array in your case)