Sorting a large 3 column data set
显示 更早的评论
I have a large 3 column matrix of xyz elevation data in 1 meter intervals. The data corresponds to a 100 meter by 100 meter grid, and lists the data row by row, meaning that the y term changes by 1 every 100 values. The data begins in the top right corner of the 'grid', as shown:
x y z
0 100 34
1 100 35
2 100 23
...
0 99 54
1 99 45
2 99 37
...
etc.
My problem is that the x and y values start at arbitrarily assigned values, like 499983.5, which make the data hard to work with. How can I make a new matrix with the x and y redefined from 1 to 100? This still needs to account for the fact the dataset starts in the top right corner.
采纳的回答
David Hill
2020-3-31
If I understand you correctly, can you not just subtract off a constant from both x and y coordinates to reset them to where you want them?
M(:,1)=M(:,1)-min(M(:,1))+1;
M(:,2)=M(:,2)-min(M(:,2))+1;
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
