필터 지우기
필터 지우기

Latitude, Longitude and Time data from Excel to Matlab

조회 수: 3 (최근 30일)
khan
khan 2017년 10월 31일
댓글: 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

답변 (2개)

KSSV
KSSV 2017년 10월 31일
To load data from excel to matlab use xlsread.
  댓글 수: 2
khan
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
KSSV 2017년 10월 31일
Why worry, as you have locations already? It depends on how you want to display them.

댓글을 달려면 로그인하십시오.


Walter Roberson
Walter Roberson 2017년 10월 31일
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.

카테고리

Help CenterFile Exchange에서 电子表格에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!