Get the numbers of rows where values change
13 次查看(过去 30 天)
显示 更早的评论
Hi,
I have an array of data, structured like this:
Latitude Longitude Height
23 54 7
23 54 3
23 54 8
23 55 4
23 55 2
24 54 0
24 54 1
24 55 2
24 55 7
How can I get the numbers of the rows where either Latitude or Longitude changes (so from the example above the output would be rows 3, 5 and 7)?
2 个评论
Image Analyst
2020-7-16
By the time you get down to row 3, nothing has changed yet. Row 3 is still the same as rows 1 and 2. Don't you mean 4, 6, and 8? Those are the actual rows where a change is first encountered.
采纳的回答
Image Analyst
2020-7-16
By the time you get down to row 3, nothing has changed yet. Row 3 is still the same as rows 1 and 2. Don't you mean 4, 6, and 8? Those are the actual rows where a change is first encountered.
Try this:
m = [
23 54 7
23 54 3
23 54 8
23 55 4
23 55 2
24 54 0
24 54 1
24 55 2
24 55 7]
latChanged = [0; diff(m(:, 1))] % Logical -- use find() if you want row numbers.
lonChanged = [0; diff(m(:, 2))] % Logical -- use find() if you want row numbers.
eitherChanged = find(latChanged | lonChanged) % Row numbers where either lat OR lon changed.
更多回答(1 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Exploration 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!