tranforming table to matrix
in [Matlab]
|
Prev: extract daily data
Next: converting matrices
From: Jos (10584) on 15 Jun 2010 09:27 "matevz pavlic" <matevzpavlic(a)gmail.com> wrote in message <hv7sik$r6c$1(a)fred.mathworks.com>... > Hi all, > i have a table (from CSV file). I would like to make a matrix out of it in a way that forst column would be i, second column would be j and third would the value. I there a easy way to do this? > Thnks, m By using the word "i", "j" and "value" I think you mean that in your new matrix, the element at position (i,j) should be "value". If so, this would be one of the ways: csvdata = [1 1 10 ; 2 2 3 ; 2 1 9] % i = csvdata(:,1) j = csvdata(:,2) value = csvdata(:,3) M = accumarray([i j],value) hth Jos
From: matevz pavlic on 15 Jun 2010 09:36 Hi, that is what i would like yes...however when i try to do this accumaray i get this message : "??? Error using ==> accumarray First input SUBS must contain positive integer subscripts."
From: Jos (10584) on 15 Jun 2010 10:29 "matevz pavlic" <matevzpavlic(a)gmail.com> wrote in message <hv7vk5$esp$1(a)fred.mathworks.com>... > Hi, > > that is what i would like yes...however when i try to do this accumaray i get this message : > "??? Error using ==> accumarray > First input SUBS must contain positive integer subscripts." So, your first input to accumarray are NOT positive integers ... Therefore, take a look at your data! What would you expect to happen when, for instance "i" (or "j") is -1, or 0.5 ? Jos
From: matevz pavlic on 15 Jun 2010 14:36 Hi, Yes, i would thought so to..but all my data is integer and positive.... Tnanks, m
From: dpb on 15 Jun 2010 14:44
matevz pavlic wrote: > Hi, > Yes, i would thought so to..but all my data is integer and positive.... > Tnanks, m Well, clearly the first argument isn't... Before the call, insert find(SUBS<=0) where SUBS is your variable name in the first argument position to the accumarray() call. If it does not return [] (and it won't), then guess what... -- |