Split array into some equal and some unequal length sections

Hello,

I have an array which is 41683 rows long. I wish to split this into as many new arrays of 60 rows as possible.

However, 41683 does not divide by 60 into whole numbers (694.717); hence I need to write some code that will result in 694 columns x 60 rows and a final columns for the remaining 43 rows (0.717 x 60).

I have tried using:

a = [1:41683]'

b = reshape(a,60,[]) but because 41863 is not completely divisible by 60, I get an error.

Can anyone help please?

Many thanks,

Phil

Answer 1

[Andrei Bobrov]

n = 60;

ii = (1:numel(a))';
out = accumarray([rem(ii-1,n)+1,ceil(ii/n)],a,[],[],nan);

or

out = reshape([a;nan(mod(-numel(a),n),1)],n,[]);

Answer 2

[madhan ravi]

Convert the array to cell and then use reshape()

[Phil Roberts]

Hello,

I tried this and it did not work.

Any other thoughts?

Many thanks in advance.

[madhan ravi]

show what you are trying

Answer 3

[Bruno Luong]

a = [1:41683]'

n = size(a,1);
blk = 60;
lgt = ones(1,floor(n/blk))*blk;
r = n-sum(lgt);
if (r > 0) lgt(end+1) = r;
b = mat2cell(a,lgt,1)