Filter Only Data Meeting Certain Criteria out of Excel Spreadsheet
1 view (last 30 days)
Show older comments
I'm trying to plot some data imported from Excel in MatLAB. The data is angle and latitude over the period of a year, so there is quite a lot of data (around 525,600 lines). However, I only care about data that's in the latitude range of 60 to 85 degrees. Is there a way in MatLAB to filter out only the 60-85 degree angle data?
0 Comments
Answers (1)
Star Strider
on 21 Jun 2023
Use ‘logical indexing’ to return the desired values —
Lat = 90*rand(10,1);
Angle = pi*rand(size(Lat));
Data = table(Lat,Angle)
Lv = 60 <= Data.Lat & Data.Lat <= 85 % Logical Vector
DesiredResult = Data(Lv,:)
Make appropriate changes to work with your data.
.
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!