Asked by shima kasaei
on 14 Aug 2019

I have .xlsx file with data of the points of a specific domain, data are not organized but each x,y has its own data which is called wz in my file, all of the z coordinates are the same as the data is for a plane of a same z.

I want to organize data in a matrix whose rows represent of y (ascending), and columns represent of x coordinate in ascending order, and the matrix fills with data (wz) for each specific x and y coordinate.

I want to do this in order to use 'pcolor' command to be abld to plot the color fill map.

Here is a part of my data:

wz Points:0 Points:1 Points:2

-24 5.6 0.01 0.05

-95 5.6 7.50E-10 0.05

-24 5.6 0.01 0.05

-1.40E+02 5.6 0 0.05

-95 5.6 0 0.05

-1.40E+02 5.6 7.50E-10 0.05

-0.88 5.6 0.02 0.05

-24 5.6 0.01 0.05

-0.93 5.6 0.02 0.05

-0.06 5.6 0.03 0.05

-0.063 5.6 0.03 0.05

-0.0034 5.6 0.04 0.05

-0.063 5.6 0.03 0.05

-0.00051 5.6 0.04 0.05

0.0023 5.6 0.05 0.05

-0.00032 5.6 0.05 0.05

-0.0037 5.6 0.06 0.05

-0.0014 5.6 0.06 0.05

0.0008 5.6 0.07 0.05

-0.00083 5.6 0.07 0.05

-0.00051 5.6 0.08 0.05

0.00056 5.6 0.08 0.05

0.0012 5.6 0.09 0.05

I would appreciate any help.

Thanks,

Answer by Neuropragmatist
on 14 Aug 2019

If I understand correctly you have an excel file with 4 columns. One column contains x values, one y values, one z values (which are all the same) and another column contains some data values. You want to load the data and plot it all as an image with the data values at each x,y position?

This is certainly doable but it would be easier with the full dataset, maybe you could provide the xlsx file?

In the meantime, you can use xlsread or readtable to get the data into matlab:

Are the x,y coordinates actually row,column indices? If so you can use sub2ind to convert them to linear indices if you know the original size of the image:

However, in the small snippet you give above it looks like they are decimal numbers, which would mean the data are actually scattered x,y points? If so you would need to use scatteredInterpolant to generate the image you want:

Lastly, I would recommend imagesc over pcolor:

Hope this helps,

M.

shima kasaei
on 14 Aug 2019

Thank you so much for your reply, the .xlsx data is the same as you understand, the columns order is data (wz), x coordinat, y coordinate, and z coordinate.

And about scatter data, I have a plane of mesh (square mesh) and the coordinates are for the boundary points of each cell, however, I want to plot each x,y,z coordinate in a color which represents the value of data (wz).

I think I should not use interpolation as they are not related to each other.

Please correct me if I am wrong.

Thanks,

Neuropragmatist
on 14 Aug 2019

OK, maybe you could upload one of the files for us to look at?

Because there are so many potential problems with the x,y coordinates that it would be easier to just look at a whole set.

M.

Sign in to comment.

Opportunities for recent engineering grads.

Apply Today
## 1 Comment

## dpb (view profile)

## Direct link to this comment

https://www.mathworks.com/matlabcentral/answers/476154-organize-data-in-matrix#comment_735107

Sign in to comment.