Find index where value exceeds threshold

315 次查看（过去 30 天）
Martin Pott
Martin Pott 2014-8-7
评论： Image Analyst 2018-2-11
Dear all,
I want to be able to find indices where values exceed a certain threshold. So if my variable of interest is called 'returns' and is formatted in a t x n matrix, I would like to find all indices in 'returns' that exceed a value X.
I'm working on a project that uses in- and out-of-sample stock returns to check the expediency of my model. Therefore, I don't want to just delete return outliers, but check manually if they make sense.
Thanks in advance.

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

回答（2 个）

Andrew Reibold
Andrew Reibold 2014-8-7
编辑：Andrew Reibold 2014-8-7
This should answer your problem! :-)
idx = find(returns > X)
Now if you have an MxN matrix, the idx returned is the single index number as if you concatenated all the rows.
Do you need help turning it into two index numbers? I can do that too.
  4 个评论
显示 2更早的评论
Yoni Sher
Yoni Sher 2018-2-11
Isn't 'find' inefficient? is there some other function that is better?
Image Analyst
Image Analyst 2018-2-11
No. Use tic and toc to time it and you'll see it's plenty fast enough for you.

请先登录，再进行评论。

Image Analyst
Image Analyst 2014-8-7
Look at this simple example:
m=magic(4) % Sample data
linearIndexes = find(m>8) % Find elements with value more than 8
[rows, columns] = ind2sub(size(m), linearIndexes)
In the command window:
m =
16 2 3 13
5 11 10 8
9 7 6 12
4 14 15 1
linearIndexes =
1
3
6
8
10
12
13
15
rows =
1
3
2
4
2
4
1
3
columns =
1
1
2
2
3
3
4
4

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by