Averaging values in Column B based on serial date in column A

Hello

I have an array that looks like:

col A col B

737585 1

737585 2

737585 3

737586 4

737586 5

737586 6

where column A is the serial date and column B is the respective value. I need a for loop that will average the values in col B that have the same serial date as in column A. Thank you!

ex: serial date: 737585 avg: 1+2+3/3 = 2

Answer 1

[Tommy]

Does it need to be a loop? I believe this will work:

groups = findgroups(yourArray(:,1));
avg = splitapply(@mean, yourArray(:,2), groups);

[Claire]

I guess it didn't have to be a loop, that worked perfectly! Thank you so much!!!

[Tommy]

Happy to help!