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

1 visualización (últimos 30 días)
Claire el 8 de Jul. de 2020
Comentada: Tommy el 8 de Jul. de 2020
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

Respuesta aceptada

Tommy el 8 de Jul. de 2020
Does it need to be a loop? I believe this will work:
groups = findgroups(yourArray(:,1));
avg = splitapply(@mean, yourArray(:,2), groups);
  2 comentarios
Claire el 8 de Jul. de 2020
I guess it didn't have to be a loop, that worked perfectly! Thank you so much!!!

Iniciar sesión para comentar.

Más respuestas (0)


Más información sobre Logical en Help Center y File Exchange.


Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by