How to make NxN matrix from excel dataset

5 次查看（过去 30 天）

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 2018-11-8

griddata()

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 2018-11-8

Set N to a smaller value, probably not more than about 1500 or so.

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

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

Translated by