How can I return the minimum value that is not zero inside a for loop?
조회 수: 2 (최근 30일)
이전 댓글 표시
Hi,
I have a for loop that find the min, max and mean of a set of data for each month that is entered and I want the minimum function to return the minimum value that is not zero. I know if i have matrix A i can use,
min(A(A>0);
But in this loop it does not allow me to do this, here is the code I am using,
for i = unique(months)' %allows function to work with any number of months
maxs(i,:) = max(hourdata(months==i,1:end));
mins(i,:) = min(hourdata(months==i,1:end));
means(i,:) = mean(hourdata(months==i,1:end));
end
I tried using the following for the minimum value but it does not like it,
mins(i,:) = min(hourdata(hourdata>0(months==i,1:end)));
I get the error 'Unbalanced or unexpected parenthesis or bracket'.
Any help would be greatly appreciated.
댓글 수: 0
답변 (1개)
Fangjun Jiang
2016년 2월 12일
편집: Fangjun Jiang
2016년 2월 12일
How about using a temp variable?
temp=hourdata(months==i,1:end);
temp(temp<=0)=inf;
mins(i,:) = min(temp,[],1);
clear temp
댓글 수: 2
Fangjun Jiang
2016년 2월 12일
편집: Fangjun Jiang
2016년 2월 12일
I see. To keep the matrix formation, you can temporarily replace those zero and negative values with a very large number and then do the min() operation.
I also see a potential problem when a particular month has only one row of data. In that case, the statement inside the for-loop will return a 1x1 scalar, rather than a 1x24 vector which is desired. So please use the optional input argument of min() function.
See if the update code works.
참고 항목
카테고리
Help Center 및 File Exchange에서 Loops and Conditional Statements에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!