Latitude, Longitude and Time data from Excel to Matlab

Question

khan 2017-10-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/364192-latitude-longitude-and-time-data-from-excel-to-matlab

评论： KSSV 2017-10-31

hello, I need to import some weather data, which is distributed as shown in the image where latitude and longitude is the coordinates of the station. i just saw few codes and questions asking relevant questions but mine is little different. as shown in the image given, i want to import the data from excel sheet for around 34 years which is supposed to look like (LongitudeXLatitudeXvalues), i want to import the data where i can show them on a spatial grid, later i will be able to replace grids with missing data with NaN values. currently i need help how to import the data in grid structure and show them on a spatial grid based on the given latitude and longitude from each data. any help in this regard will be highly appreciable and properly acknowledged

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

KSSV 2017-10-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/364192-latitude-longitude-and-time-data-from-excel-to-matlab#answer_288613

To load data from excel to matlab use xlsread.

2 个评论
显示无隐藏无

khan 2017-10-31

编辑：khan 2017-10-31

Respected KSSV i know how to import the data but the point i need some clarification for is, how can i put the data on a spatial grid/map based on the latitude and longitude, since the values fro each latitude and longitude are more than one, so i need some other analysis thats why i want to bring the data to matlab and finally i can display them.

KSSV 2017-10-31

Why worry, as you have locations already? It depends on how you want to display them.

请先登录，再进行评论。

Answer 2

Walter Roberson 2017-10-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/364192-latitude-longitude-and-time-data-from-excel-to-matlab#answer_288617

Do the values form a strict grid? It does not look like it to me. You have no two latitudes or longitudes the same. That suggests you have scattered data.

If you have scattered data that you want to interpolate to fill a rectangular grid, then use scatteredInterpolant()

On the other hand, if you have latitudes outside of roughly 40S to 40N, then rectangular grids are not really sufficient to represent the data, due to the distance between degrees longitude getting much compressed as you get further north or south. Interpolation in such cases needs to take into account that your data is not using planar coordinates.