Matrix Operations on a big dataset

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 Elementary Math 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!

Translated by