How can I find all the minimum values in table using a for-loop (which has Ties)?

 Month = [01 02 03 04 05 06]';
 Price = [99 58 94 58 87 91]';
 Count = [10 30 20 27 05 04]';
 T = table(Month, Price, Count)
m = 1 
    for i = 2:size(T,1)
        if (T.Price(i) <= T.Price(m))
            m = i;
        end 
    end  
T(m,'Month')

I have this code that finds the minimum price and tells me which month has the minimum price. However, the answer I am getting is only the 4th month, whereas there is a minimum in the 2nd month as well. How can I get this code to show me all months with the minimum price? How can I store the answer in a vertical vector? Thanks in advance!

Answer 1

[madhan ravi]

Month = [01 02 03 04 05 06]';
Price = [99 58 94 58 87 91]';
Count = [10 30 20 27 05 04]';
A = Price
ind = 1;
minval = A(ind);
for i =1:numel(A)
  if A(i) < minval
    minval = A(i);
    ind = i;
  elseif A(i) == minval
    ind = [ind i]; % add current index
  end
end

Months_with_less_price = Month(ind)

[madhan ravi]

You don’t need loop to do these operations , this way is efficient

[Alfred Ofosu]

Thank you. I have this answer but I need to do this in a loop as it required by prof. :)

[madhan ravi]

do you still need to do this or its ok?

[Alfred Ofosu]

I still need to do this.

[madhan ravi]

see updated answer

[Kevin Chng]

+1 nice

[Alfred Ofosu]

Thanks a lot, Madhan. Well done!

[madhan ravi]

Thank you @Kevin

[madhan ravi]

Anytime :) @Alfred

Answer 2

[Kevin Chng]

   Month = [01 02 03 04 05 06]';
   Price = [99 58 94 58 87 91]';
   [minimun,idx]= min(Price);
   MinMonth=Month(Price==minimun);

%minimun is your minimun value, % MinMonth is the month having minimun value

[Alfred Ofosu]

Thank you

[Alfred Ofosu]

what is idx, If I may ask?

[Kevin Chng]

which indexing is the minimun number in the vector, however, it has limitation, which is only return one of the index of your minimum number.

In your case, it will return 2. you may ignore it and change to

     minimun= min(Price);

[Alfred Ofosu]

Thanks Kelvin for your time and help!