How to make NxN matrix from excel dataset

3 次查看（过去 30 天）
Ravindu Lokuliyana
Ravindu Lokuliyana 2018-11-8
评论： Walter Roberson 2018-11-8
Hi there,
I got excel dataset which has longitude(1xn)), latitude(1xn) and elevation(1xn) as described in the attached file.
How can I convert elevation dataset into NxN matrix?
Note: Data points are randomly distributed. not in exact order as described in the example.

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

采纳的回答

Walter Roberson
Walter Roberson 2018-11-8
griddata()
  4 个评论
显示 2更早的评论
Ravindu Lokuliyana
Ravindu Lokuliyana 2018-11-8
Thank you very much. It works well for me.
But I got large excel data values (more than 300,000) in my file. In that case it's somewhat hard to execute.
If you have further suggestions, I would greatly appreciate.
Walter Roberson
Walter Roberson 2018-11-8
Set N to a smaller value, probably not more than about 1500 or so.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by