Thread Subject:

creating a regular matrix from an irregular matrix

hello,

i'm trying to create a regular matrix of 9 by 62 from a vector of 541 values. the 451 values are split into groups that have the same values and i used the "unique" function to find out how many such groups i have, and it turns out that there are 62 groups.
the problem is that the number of values in each group rages from 1 to 9, and when i try to use the "find" command it gives me an error, since i'm trying to create an irregular matrix. my question is how do i fill in the blank spaces in my irregular matrix with either NaN (idealy) or 0 so that i end up with a 9 by 62 matrix.

thanks alot for any help anyone can give

"Liviu Parpalea" <liviu142000@yahoo.ca> wrote in message <gqjbht$cn0$1@fred.mathworks.com>...
> hello,
>
> i'm trying to create a regular matrix of 9 by 62 from a vector of 541 values. the 451 values are split into groups that have the same values and i used the "unique" function to find out how many such groups i have, and it turns out that there are 62 groups.
> the problem is that the number of values in each group rages from 1 to 9, and when i try to use the "find" command it gives me an error, since i'm trying to create an irregular matrix. my question is how do i fill in the blank spaces in my irregular matrix with either NaN (idealy) or 0 so that i end up with a 9 by 62 matrix.
>
> thanks alot for any help anyone can give

% I'm not exactly sure how you want to fill the new matrix,
% but you can try something like:

new_matrix = repmat(NaN,9,62); % preallocate

% and if v is your vector, then

new_matrix(1:length(v)) = v; % use linear indexing

% I'm sure there are other (better) solutions
% depending on your needs.

"Liviu Parpalea" <liviu142000@yahoo.ca> wrote in message <gqjbht$cn0$1@fred.mathworks.com>...
> hello,
>
> i'm trying to create a regular matrix of 9 by 62 from a vector of 541 values. the 451 values are split into groups that have the same values and i used the "unique" function to find out how many such groups i have, and it turns out that there are 62 groups.
> the problem is that the number of values in each group rages from 1 to 9, and when i try to use the "find" command it gives me an error, since i'm trying to create an irregular matrix. my question is how do i fill in the blank spaces in my irregular matrix with either NaN (idealy) or 0 so that i end up with a 9 by 62 matrix.
>
> thanks alot for any help anyone can give

  Call your original vector v. If v is a column vector, do this:

 u = sort(v);
 t = [true;diff(u)~=0];
 p = cumsum(t);
 q = ones(1,size(t,1));
 f = find(t);
 q(f(2:end)) = f(1:end-1)-f(2:end)+1;
 q = cumsum(q);
 M = accumarray(p,q,u));

The unused spaces in M will be zeros. This works unless some of the elements in v are also zero.

Roger Stafford

"Roger Stafford" <ellieandrogerxyzzy@mindspring.com.invalid> wrote in message <gqjj71$4r9$1@fred.mathworks.com>...
> .....
> M = accumarray(p,q,u));
> .....

  Oops! I meant to write:

 M = accumarray(p,q,u);

for the last line.

Roger Stafford

"Roger Stafford" <ellieandrogerxyzzy@mindspring.com.invalid> wrote in message <gqjjvd$omv$1@fred.mathworks.com>...
> "Roger Stafford" <ellieandrogerxyzzy@mindspring.com.invalid> wrote in message <gqjj71$4r9$1@fred.mathworks.com>...
> > .....
> > M = accumarray(p,q,u));
> > .....
>
> Oops! I meant to write:
>
> M = accumarray(p,q,u);
>
> for the last line.
>
> Roger Stafford

  A second oops for that last line (blush). It should read:

 M = accumarray([p,q],u);

Roger Stafford

"Roger Stafford" <ellieandrogerxyzzy@mindspring.com.invalid> wrote in message <gqlb9d$j1f$1@fred.mathworks.com>...

>
> A second oops for that last line (blush). It should read:
>
> M = accumarray([p,q],u);
>
> Roger Stafford

Also q should be initialized in column:

q = ones(size(t,1),1)

Bruno

"Bruno Luong" <b.luong@fogale.findmycountry> wrote in message <gqlc3m$bug$1@fred.mathworks.com>...
> Also q should be initialized in column:
>
> q = ones(size(t,1),1)
>
> Bruno

  Yes, you're right, Bruno. Thanks.

Roger Stafford