Matrix Operations on a big dataset

Asked by MountainKing on 28 Jun 2012
Latest activity Edited by Walter Roberson on 28 Jun 2012

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

0 Comments

MountainKing

Products

No products are associated with this question.

0 Answers

Contact us