How to handle multiple text files (geographical info) and finding a particular location from each text file?

1 次查看(过去 30 天)
Hello matlab community,
I have multiple text files. Which contains time,value,lat,lon information. Each text file has a different dimension.
What I want is to extract all the information ( i.e. time,value) in a sorted manner for a particular (lon,lat) location occuring at all the text files which are of different dimension.
For example: I want to find all the values in sorted time format for a lon=100, lat=35, from all the text files.
I can share few text file if requires.
Thanking you in advance.

采纳的回答

Image Analyst
Image Analyst 2021-9-6
2 hours with no answer. Yeah, I guess you need to attach the text files before anyone tries to deal with this problem. We don't know what arrays you have, like arrays for lat, long, time, value, etc. So all I can suggest at this point is to use the sort() function. In the meantime try something like
latLon = [lat(:), longitude(:)]; % Get all lats and lons in an N-by-2 array.
% There may be repeats, so extract only the unique locations.
uniqueLocations = unique(latLon, 'rows');
for row = 1 : size(uniqueLocations, 1)
thisLat = uniqueLocations(row, 1);
thisLon = uniqueLocations(row, 2);
% Find rows with that location
theseRows = lat == thisLat & longitude == thisLon;
% Extract times and values
theseTimes = time(theseRows);
theseValues = values(theseRows);
% Now do something with them.
end
  2 个评论
Subhodh Sharma
Subhodh Sharma 2021-9-7
编辑:Subhodh Sharma 2021-9-7
Thanks for you reply @Image Analyst. But there are thousands of text file. The latitude and longitude is not changing in any order. I don't know whether it would be good to extract all lon and lat at one position.
I have just attached 3 text files for your reference. You can readily see how the location is changing randomly. I don't know how extract all the information ( i.e. time,value) in a sorted manner for a particular (lon,lat) location occuring at all the text files which are of different dimension.
You can choose lon=-101.54 and lat=42.51
Thanking you in advance.

请先登录,再进行评论。

更多回答(0 个)

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by