How to transform a XYZ-Array into a XxY-Matrix with Z as values of each Mxy-Component and vice versa?

14 次查看（过去 30 天）
Emerson De Souza
Emerson De Souza 2012-11-18
评论： Ander Del Olmo Sanz 2023-1-25
Hi, I have a table XYZ with three columns (xyz) as below:
1 1 1
1 2 2
1 3 3
2 1 4
2 2 5
2 3 6
3 1 7
3 2 8
3 3 9
and I want to transform it into a Mxy-Matrix with Z as value for each Mxy pair as follows:
1 4 7
2 5 8
3 6 9
On the other hand I may have directly the Matrix Mxy and would like to obtain the XYZ-table.
I already tried mesh, meshgrid, ndgrid, surf and etc... as documented, but nothing worked as I wished. It is possible that I did not understand yet how to use this commands.
I wonder if someone could tell me how to write the command to convert:
1) Table XYZ to Matrix Mxy with Z as values of each Mxy-pair 2) Matrix Mxy to Table XYZ
I thank you in advance for your help
Emerson

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2012-11-18
accumarray(XYZ(:,[2 1]), XYZ(:,3)]
  4 个评论
显示 2更早的评论
Ander Del Olmo Sanz
Ander Del Olmo Sanz 2023-1-25
I have the same problem, but in my case values are not whole number, since it is the measurement of a 3D part, but i want just to sabe the values of Z axis, so what can I do for rationa number with commas, like 5,5 or 7.8 in X and Y axis ?

请先登录，再进行评论。

更多回答（1 个）

Chad Greene
Chad Greene 2016-4-6
Thanks to Walter's excellent suggestion to use accumarray, I wrote an xyz2grid function to do this for GMT data.

类别

在 Help Center 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by