Filter Only Data Meeting Certain Criteria out of Excel Spreadsheet
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(1 个)
Star Strider
2023-6-21
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 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!