Replacing multiple cells with median if value of first column is the same

Question

Rasmus Larsen 2015-11-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/252153-replacing-multiple-cells-with-median-if-value-of-first-column-is-the-same

评论： Rasmus Larsen 2015-11-1

I have a 302451x3 matrix with stock quotes (bid / offers). Timestamp (in seconds) is in the first column.

If the timestamp is the same for several quotes (the rows) i want to replace all the rows with this timestamp with 1 single row that has that particular timestamp and with the median of the bid / offers in the other columns.

For example the first 60 rows share the same timestamp (34287) and the bids range from 87.57 to 87.67. The median is 87.60.

How do i replace these 60 rows with 1 row where the timestamp 34287 is the value in the first column and this 87.60 median is the value in the second column?

Hope you understand

2 个评论
显示无隐藏无

Geoff Hayes 2015-11-1

Rasmus - are all of your rows in chronological order?

Rasmus Larsen 2015-11-1

编辑：Rasmus Larsen 2015-11-1

The timestamps are (column 1)!

Like as an example i have data the attached image.

So for this part of the data i would like to turn it into 3 rows of data with 34287, 34288 and 34289 in column 1 and the respective medians in the other two columns.

I have 302,451 rows of data like this and i tried using the unique() function on the timestamps and i see there are 20,359 unique values. So i'd like to turn the 302,451 rows into 20,359 as in the style above.

Thanks!

请先登录，再进行评论。

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

Answer 1

the cyclist 2015-11-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/252153-replacing-multiple-cells-with-median-if-value-of-first-column-is-the-same#answer_198086

在 MATLAB Online 中打开

This is the type of task that accumarray is designed to carry out:

M = [32767 2 3;
     32767 3 4;
     32767 4 5;
     32768 3 4;
     32768 4 5;
     32769 4 5;
     32769 5 6;
     32770 5 6];
[uniqueDatenum,~,idx] = unique(M(:,1));
medianBid = accumarray(idx,M(:,2),[],@median);
medianOffer = accumarray(idx,M(:,3),[],@median);
medianM = [uniqueDatenum,medianBid,medianOffer]

I suggest a careful reading and understanding of the accumarray documentation I linked to.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Rasmus Larsen 2015-11-1

Wow that's a lot easier than i thought!

Thanks a lot :)

请先登录，再进行评论。

Replacing multiple cells with median if value of first column is the same

2 个评论
显示无隐藏无

采纳的回答

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

Replacing multiple cells with median if value of first column is the same

2 个评论 显示 无隐藏 无

采纳的回答

1 个评论 显示 -1更早的评论隐藏 -1更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

2 个评论
显示无隐藏无

1 个评论
显示 -1更早的评论隐藏 -1更早的评论