tranforming table to matrix
in [Matlab]
|
Prev: extract daily data
Next: converting matrices
From: Kelly Kearney on 15 Jun 2010 14:55 "matevz pavlic" <matevzpavlic(a)gmail.com> wrote in message <hv7u3t$70l$1(a)fred.mathworks.com>... > Hi, > > yes i allready read it into Matlab. Dimensions are now 39744 x 3. I would like them to be 192x206 and the third column to be value of matrix. Hope this explains it... > m My vec2grid function will take a list of coordinates and rearrange them onto a grid, assuming the unique x and y values to be the rows and columns of your new grid: http://www.mathworks.com/matlabcentral/fileexchange/21617-vec2grid However, as someone else pointed out, you seem to have more data points in your original matrix than in your final desired grid. If you have replicates, you need to figure out what you want to do with repeated coordinates (average the z value?) before using vec2grid (otherwise it will simply use the last value z-value encountered for each x-y pair). If the points in your list are scattered, use griddata instead. -Kelly
From: matevz pavlic on 16 Jun 2010 06:56 hi, thanks for the help... Maybe i should explain a bit more. I have a DEM (elevation model) which is in GIS as a surface (X coor, Y coor and data (z)). Now would like to (with a lot of help) create a small program, which should check this grid and determine various things on it (the path to the steepest descent etc...). But i have a problem, because I can not directly import the grid (surface) from GIS to MATLAB. That's why i made a table with a column of X, Y and Z. Now i would like to convert this table to a matrice so that program could (maybe eventualy) work. Hope this explains it better, m
From: dpb on 16 Jun 2010 10:35 matevz pavlic wrote: > hi, thanks for the help... > > Maybe i should explain a bit more. I have a DEM (elevation model) which > is in GIS as a surface (X coor, Y coor and data (z)). Now would like to > (with a lot of help) create a small program, which should check this > grid and determine various things on it (the path to the steepest > descent etc...). But i have a problem, because I can not directly import > the grid (surface) from GIS to MATLAB. That's why i made a table with a > column of X, Y and Z. Now i would like to convert this table to a > matrice so that program could (maybe eventualy) work. Hope this explains > it better, m a) Why don't you simply read in the file as an array that you would prefer, or b) a = [x y z]; would concatenate columns into an array. Again, give us a _SHORT_ sample of the data set and the desired output instead of words... --
From: us on 16 Jun 2010 10:56
"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 nice words... now, show CSSMers a small example of what data you have and the output you'd like to see... us |