Find index of rows in tables with two conditions doesn't work using &&
4 views (last 30 days)
Show older comments
Hello, I am using a readtable to read a CVS file into a uitable. I like the fact that you can operate on columns using the dot notation with the column heading.
I have seleted the columns of itnerest by using the import options object
opts = detectImportOptions(fullpath) % create importoptions object
opts.SelectedVariableNames = ["YPosNanometer","ZPosNanometer","Tilt"]; % Select which columns to read in
T = readtable(fullpath,opts);
I want to be able to find the row index of any row that has a number 0 in both the 1st or 2nd column, i.e. in both the columns with headings "YPosNanometer","ZPosNanometer".
I thought the below would find these indicies
indx=(find(T.YPosNanometer == 0) && find(T.ZPosNanometer == 0))
But I get the error:
Operands to the logical AND (&&) and OR (||) operators must be convertible to logical scalar values. Use the ANY or ALL functions to reduce operands
to logical scalar values.
So how do I achieve the condition I want?
0 Comments
Accepted Answer
Voss
on 15 Oct 2024
Use & to operate on non-scalar arrays:
indx = find(T.YPosNanometer == 0 & T.ZPosNanometer == 0)
More Answers (0)
See Also
Categories
Find more on Numeric Types in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!