Borrar filtros
Borrar filtros

Sum data based on buckets/edges (SumIF?)

5 visualizaciones (últimos 30 días)
Ryan Hinrichsen
Ryan Hinrichsen el 1 de Nov. de 2021
Comentada: Ryan Hinrichsen el 1 de Nov. de 2021
I have a data array containing two columns:
Damage value - corresponding to how much damage occurs at that data point
# cycles - how many cycles occur during the data point
I would like to sum the # of cycles for a given set of bins/edges (not always equally spaced). In Excel this would be a very simple SumIF, albeit across a number of cells to populate a table. I can write the same logic in Matlab, but it requires a loop to check each bin/edge set. Is there an elegant single-line solution, similar to histcounts, that will allow me to pass a series of bins/edges and sum the cells that meet that criteria?
In the attached image, the example input data is on the left and the output data I desire is on the right with the thick border around the cells.
Thanks in advance for your assistance!

Respuesta aceptada

Steven Lord
Steven Lord el 1 de Nov. de 2021
See the groupsummary function. The "Specify Group Bins" example on its documentation page looks very similar to what you want to do.
  1 comentario
Ryan Hinrichsen
Ryan Hinrichsen el 1 de Nov. de 2021
Fantastic answer, I have never heard of this function before. Greatly appreciate the help!

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Startup and Shutdown en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by