How do I find the corresponding dates for maximum prices?

2 次查看（过去 30 天）
stelios loizidis
stelios loizidis 2021-4-5
评论： stelios loizidis 2021-4-5
Hello. I have a matrix A with dimensions 366x24 which contains values and a matrix B which contains dates-time (366x24 datetime). For each row of matrix A I found the maximum value (366X1). What I'm trying to do is find out on what date these maximum values correspond. Below is the code I wrote but the results it gives me are wrong.
Max_values=max(A,[],2);
Time_1=find(A==Max_values);
Time_of_max_values=B(Time_1);
Your help is important!

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

回答（1 个）

Walter Roberson
Walter Roberson 2021-4-5
[Max_values, Max_index] = max(A,[],2);
Time_of_max_values = B(Max_index)
This assumes that if multiple copies of the same maximum value appear in a row, that you only want to see one of them. If that is not true, then you need a redesign as each row would have a variable number of times associated.
arrayfun(@(rowidx) B(A(rowidx,:) == max(A(rowidx,:))), (1:size(A,1)).', 'uniform', 0)
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2021-4-5
Could you confirm that the year shown ins 1012? Not even 2012, but over 1000 years ago??
Can you attach your matrices for testing?
stelios loizidis
stelios loizidis 2021-4-5
Sorry. I mean 2012.
As for the matrices unfortunately i can not upload them

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by