Matrix Operations on a big dataset
Show older comments
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
Find more on Multidimensional Arrays in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!