find out in which row an element is equal to a specific number

29 次查看（过去 30 天）
Locks
Locks 2013-5-1
评论： BN 2020-3-31
hi,
I have the following problem:
I have a matrix with 20 columns and over 200'000 rows. somewhere in this matrix there seems to be some strange datas which I would like to delete. If I am looking for the rownumbers where the value is higher than a specific value, lets say I am looking for all the values in the first row that are larger than 1500
If I do this:
data18(:,1)>1500
I get a logical array, but what I am looking for is the exact row number, what do I need to do?

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

采纳的回答

James Tursa
James Tursa 2013-5-1
编辑：James Tursa 2013-5-1
If you are looking for rows where any value is > 1500, then
find(any(data18>1500,2))
Or if you are only interested in rows where the 1st column is > 1500, then
find(data18(:,1)>1500)
  4 个评论
显示 2更早的评论
James Tursa
James Tursa 2017-11-3
The 2 forces the any( ) function to work on the rows instead of the columns (which is the default).

请先登录，再进行评论。

更多回答（3 个）

Youssef Khmou
Youssef Khmou 2013-5-1
编辑：Youssef Khmou 2013-5-1
hi try :
[x,y]=find(data18(:,1)>1500);
N/A
N/A 2016-5-14
How would you implement this in a loop for a variety of values?
partha sarkar
partha sarkar 2019-12-11
how to check whether aparticular value in a array is euqal to a given value

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by