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
No products are associated with this question.
0 Comments