Finding Maximum Value of a Table/Categorical Array
조회 수: 14 (최근 30일)
이전 댓글 표시
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
채택된 답변
Paresh yeole
2020년 6월 10일
편집: Paresh yeole
2020년 6월 10일
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
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Numeric Types에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!