Is There A Method For Filtering Array Data Based On 2 Values?

1 次查看（过去 30 天）
Brad
Brad 2013-7-8
I’ve got a < 12 x 2 double > array that looks like this;
58570 1
58571 1
58572 1
58573 2
58574 2
58575 7
58576 7
58577 11
58580 11
58581 11
58582 123
58583 123
Column 1 is UTC time, column 2 is a vehicle ID.
I’m looking to filter this data such that the greatest UTC for each vehicle ID is stored in a separate array. Using the above array, the end result would look like this:
58572 1
58574 2
58576 7
58581 11
58583 123
Any ideas on how to accomplish this would be appreciated. Thanks.

请先登录，再回答此问题。

采纳的回答

Matt J
Matt J 2013-7-8
[~,idx]=unique(data(:,2),'last');
data=data(idx,:);
  1 个评论
Brad
Brad 2013-7-8
Matt, this runs like a champs and is compact. And I ran RIGHT OVER IT when looking in the documentation.
Thanks for taking a look at this.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Filter Analysis 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by