Find does not work properly

3 views (last 30 days)
Hi guys! I use the find command but it does not return what I expect.
for i=1:9:500
c=c+1;
d=find(Horizon{i:i+9,8} <= 2);
m=mean(Horizon{i:i+9,8});
report12{c,7}=m;
%if isnan(m)==0
%report12{c,1}=Horizon{i,1};
%report12{c,2}=Horizon{i+9,1};
end
For any value of i and then i+9 my d is always equal to: d= [1,2,3,4,5,6,7,8,9,10,11], of course if each value verifies the condition. What I really expect is filling d with the Horizon row index. let 's say:
d=find(Horizon{440:450,8} <= 2);
d=[440, 441,445,450] assuming only 4 values verifiy the condition
  4 Comments
Stephen23
Stephen23 on 16 Jun 2021
Edited: Stephen23 on 16 Jun 2021
Excel worksheets are not a particularly reliable way to transfer data. Save and MATLAB data without loss of precision using a .mat file.
How are you importing the Excel file data into MATLAB?
Riccardo Tronconi
Riccardo Tronconi on 16 Jun 2021
In matlab is an output of another function so I have it .mat.
Instead of 20 rows in this subset are 16 but the logic behind it is the same:
  1. 1:8
  2. 9:16

Sign in to comment.

Accepted Answer

Steven Lord
Steven Lord on 16 Jun 2021
Please provide a small sample of the Horizon variable from where you expected the find call to return data but it does not. My suspicion is that the elements in that section of Horizon display as 2 but the stored values are actually slightly larger than 2.
format % default display format
x = 2.000000001 % displays as 2
x = 2.0000
x <= 2 % but is not less than or equal to 2
ans = logical
0
  1 Comment
Riccardo Tronconi
Riccardo Tronconi on 16 Jun 2021
Thanks for your time. You can find a better explanation above :)

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!