How can i group a the elements of a Matrix and returns an aggregation function in SQL style?

1 visualizzazione (ultimi 30 giorni)
Hi guys! I'll show you an example of what I'd like to do: I have a matrix A
A = [
1 2 3
2 1 2
1 2 6
2 1 4
]
Suppose I want to group by the first two columns and return for each of those the mean value of the third column. The output matrix will be
A_group = [
1 2 4.5
2 1 3
]
Is there any function that implements such a functionality? Thanks
  3 Commenti
Rik
Rik il 15 Lug 2018
I don't understand your question, but if you already have the sum, can't you just divide that by the number of elements?
Luigi Treccozzi
Luigi Treccozzi il 15 Lug 2018
I don't know what that number is before I aggregate. I thought at this solution but I don't know how can I count them. Anyway, my question is: How can I aggregate some rows in a matrix? Look at the example. Of course I have some more complex matrix on which to work

Accedi per commentare.

Risposte (0)

Categorie

Scopri di più su Creating and Concatenating Matrices in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by