Filter Only Data Meeting Certain Criteria out of Excel Spreadsheet
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
Star Strider
am 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 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!