MATLAB Answers

Split matrix across the median

36 views (last 30 days)
M
M on 17 Dec 2012
How do I split a matrix across its median? Suppose I have a 5x10 matrix sorted in ascending order. I want to split this into two 5x5 matrices by finding the median of each row.
Then each sub-matrix will be further split k-times, for a huge matrix. The number of rows will remain constant.

  7 Comments

Show 4 older comments
M
M on 17 Dec 2012
Yes, but I can sort it if needed by using A = sort(a,2);
Walter Roberson
Walter Roberson on 17 Dec 2012
We need a specific statement from you about whether there can be any duplicates, and if so then how do you want to handle the case where the median happens to be duplicated.
The answer I gave is for the situation where duplicates are allowed and it is acceptable to split duplicate medians across the two arrays.
M
M on 17 Dec 2012
Yes, there can be duplicates

Sign in to comment.

Accepted Answer

Walter Roberson
Walter Roberson on 17 Dec 2012
If the rows are already sorted in ascending order, then the median is, by definition, right at the middle, so just index appropriately.
A1 = A(:,1:end/2);
A2 = A(:,end/2+1:end);

  4 Comments

Show 1 older comment
Walter Roberson
Walter Roberson on 17 Dec 2012
Note: this code is also fine with cases where the rows are sorted in descending order, or where some rows are ascending and other rows are descending. It does not, however, work for cases where the rows are not individually sorted.
Walter Roberson
Walter Roberson on 17 Dec 2012
For the situation where the array might have an odd number of columns, and the middle value should just be left out, modify to
A1 = A(:,1:floor(end/2));
A2 = A(:,ceil(end/2)+1:end);
M
M on 17 Dec 2012
Thank you, this works on the example matrix. Now I have to test it on the actual data matrix which is 12x416 in size

Sign in to comment.

More Answers (1)

Mark Whirdy
Mark Whirdy on 17 Dec 2012
Edited: Mark Whirdy on 17 Dec 2012
a = rand(5,10);
b = repmat(median(a,1),10);
c1 = a; c1(a<b) = NaN;
c2 = a; c2(a>=b) = NaN;
.... what you're looking for? like Azzi, itshard to know without an example

  7 Comments

Show 4 older comments
Walter Roberson
Walter Roberson on 17 Dec 2012
b = repmat(median(a,2),1,size(a,2));
is the correction for Mark's code.
M
M on 17 Dec 2012
Can you please explain the above line? Why is it needed?
I tried it but it creates another 5x10 matrix
Walter Roberson
Walter Roberson on 17 Dec 2012
Mark's code works by creating a "b" matrix the same size as the "a" matrix, with "b" containing copies of the row medians, and then doing an element-by-element comparison of the matrices. The result after his suggested computations is two matrices the same size as the original matrix, but with NaN in places indicating elements that were split over into the other matrix.

Sign in to comment.

Tags

Products

Community Treasure Hunt

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

Start Hunting!