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

Answers (0)

Categories

Asked:

on 28 Jun 2012

Community Treasure Hunt

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

Start Hunting!