Azzera filtri
Azzera filtri

Sum data based on buckets/edges (SumIF?)

6 visualizzazioni (ultimi 30 giorni)
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!

Risposta accettata

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

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Startup and Shutdown in Help Center e File Exchange

Prodotti


Release

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by