Latitude, Longitude and Time data from Excel to Matlab

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

Answer 1

[KSSV]

To load data from excel to matlab use xlsread.

[khan]

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]

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

Answer 2

[Walter Roberson]

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.