Matrix calculation indexing conditional
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Zeynab Mousavikhamene
el 13 de Ag. de 2019
Comentada: Andrei Bobrov
el 15 de Ag. de 2019
I have a matrxi of 500 rows and 6 columns. I need to sum all the rows of 2nd column of the matrix if their 3rd column and 4th coumns equal to specific numbers.
How can I do that?
Lets explain more: One column is the time. An other column is radius. We can have multiple rows of the same time. Or multiple rows that have the same radius. An other coulmn is number of cells. I want to say for all times=2 and all radius=3 sum the number of cells.
2 comentarios
Respuesta aceptada
Andrei Bobrov
el 13 de Ag. de 2019
Editada: Andrei Bobrov
el 13 de Ag. de 2019
Let A - your array (500 x 6):
T = array2table(A);
T_out = varfun(@sum,T,'InputVariables',2,'GroupingVariables',3:4);
9 comentarios
Andrei Bobrov
el 15 de Ag. de 2019
GroupCount this is numbers of the same rows in the sub-matrix of two columns - [time, radius]
Más respuestas (0)
Ver también
Categorías
Más información sobre Creating and Concatenating Matrices 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!