Eliminating Certain Timestamps from an Array

1 次查看（过去 30 天）
Midimistro
Midimistro 2016-5-23
评论： Sean de Wolski 2016-5-24
I have two arrays: "Time" and "Bytes", both of which correspond to one another (aka, are the same size and refer to the same type of data). I need to eliminate certain data points in "Time" containing duplicate timestamps, but at the same time, select those with the higher "Byte" value for that timestamp.
For starters, I know I can use unique() to find the non-duplicate timestamps, but this function doesn't take into consideration finding the max value of Bytes in the process. Is there any simple way of going about this?
Whether the answer is in function form or in-line form doesn't matter to me. If you need an example of data, let me know.

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

采纳的回答

Sean de Wolski
Sean de Wolski 2016-5-23
编辑：Sean de Wolski 2016-5-24
NEW
x = [.01, .01, .03, .04, .04, .04, .07, 1.0] ;%Timestamp
y = [096, 140, 096, 096, 140, 579, 579, 579] ;%Bytes
z = [.01, .02, .03, .04, .04, .06, .09, 1.2]; %TimestampEnd
[ux,~,idx] = unique(x');
zmx = accumarray(idx,(1:numel(x))',[],@(ii)getz(y(ii),z(ii)));
[ux zmx]
Where getz() is in getz.m.
function mxz = getz(y,z)
[~, idxmx] = max(y);
mxz = z(idxmx);
end
OLD
x = [1;2;3;2;3]; % "time stamps"
y = (1:5)'; % Bytes, pick max for each unique x.
[ux,~,idx] = unique(x);
xmx = accumarray(idx,y,[],@max);
[ux xmx]
Use the third output of unique to pivot and apply the max function with accumarray.
  3 个评论
显示 1更早的评论
Midimistro
Midimistro 2016-5-23
I also forgot that there's a third datapoint I forgot to mention that needs to have the same indecies as the new timestamp.
The data is more like this:
x = [.01, .01, .03, .04, .04, .04, .07, 1.0] %Timestamp
y = [096, 140, 096, 096, 140, 579, 579, 579] %Bytes
z = [.01, .02, .03, .04, .04, .06, .09, 1.2] %TimestampEnd
And the results should look something like this:
xnew = [.01, .03, .04, .07, 1.0]
znew = [.02, .03, .06, .09, 1.2]
These new data points are then used within a function to find whether these data points match another set of data points, but that's a separate problem.
Sean de Wolski
Sean de Wolski 2016-5-24
See NEW above.
You need to back index from the max of y into the corresponding z. It's nice to do this in a separate function.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by