Matrix Operations on a big dataset
Afficher commentaires plus anciens
Hello Matlab Gurus!
I have a big data with 11 columns and thousand of rows.
C1 C2 C3 C4 C5 C6 C7 C8 C9 C10 C11
1 1 1
1 1 1
1 1 2
1 1 2
1 2 1
1 2 1
1 2 2
1 2 2
2 1 1
2 1 2
For each unique set of (C1 C2 C3) I need to find a min & a max value from C5 & C11 together, and report their difference. Also, I need to report the values on C4(“SP”) & C8(“FP") corresponding to the min and max (from C5 or C11!).
So the new matrix will look like:
1 1 1 min diff SP FP
1 1 2 min diff SP FP
1 2 1 min diff SP FP
1 2 2 min diff SP FP
2 1 1 min diff SP FP
2 2 1 min diff SP FP
Thank you
Réponses (0)
Catégories
En savoir plus sur Multidimensional Arrays dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!