Find index of rows in tables with two conditions doesn't work using &&

2 vues (au cours des 30 derniers jours)
Jason
Jason le 15 Oct 2024
Commenté : Voss le 15 Oct 2024
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?

Réponse acceptée

Voss
Voss le 15 Oct 2024
Use & to operate on non-scalar arrays:
indx = find(T.YPosNanometer == 0 & T.ZPosNanometer == 0)
  2 commentaires
Jason
Jason le 15 Oct 2024
So easy!!!! thanks
Voss
Voss le 15 Oct 2024
You're welcome!

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Numeric Types dans Help Center et File Exchange

Produits


Version

R2023b

Community Treasure Hunt

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

Start Hunting!

Translated by