One measure greater than another?

1 次查看（过去 30 天）
Rachael Courts
Rachael Courts 2019-9-17
评论： Walter Roberson 2019-9-17
Hi All,
I have a 697 x 38 which has different column headings such as 'startf, maxf, etc'.
I'm wanting to check if my measurements are true (an answer of 1 indiciting not true?) such that;
startf>fmax
startf<fmax etc..
Currently, I've sectioned off the columns of interests:
T = PWALLVOCSPARTSOFBIPHON
Wanted = T(:,'SFStartFreqHzoffundamental')
Wanted1 = T(:,'MaxFHzfundamental'
I now want to check if wanted is greater than wanted1
I tried:
Wanted > Wanted1 ans =
but thats just producing an error.
In addition, if the answers were shown to be untrue. Such as I have data of a start frequency that is lower than minimum frequency, how do i find which rows these will be located in?
  5 个评论
显示 3更早的评论
Rachael Courts
Rachael Courts 2019-9-17
THANK YOU SO MUCH! parentheses are definitely important, thank-you for explaining it too.
Okay, so the code works perfectly!
The next step, to retrieve the answer of 0 or 1? then locating within the column what row has the incorrect value?
Any suggestions? :)

请先登录，再进行评论。

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

采纳的回答

Guillaume
Guillaume 2019-9-17
Note than an even simpler way to extract data from a table is with dot indexing:
Wanted = T.SFStartFreqHzoffundamental; %equivalent to T{:,'SFStartFreqHzoffundamental'}
Wanted1 = T.MaxFHzfundamental; %equivalent to T{:,'MaxFHzfundamental'}
mask = Wanted > Wanted1;
To keep only the portion of the table for whick mask is true:
Tinvalid = T(mask, :) %Not that this returns a table since we're using () indexing
which can be done in only one line:
Tinvalid = T(T.SFStartFreqHzoffundamental > T.MaxFHzfundamental, :)
If you want to know the row indices, use find:
invalidrows = find(T.SFStartFreqHzoffundamental > T.MaxFHzfundamental)
  3 个评论
显示 1更早的评论
Guillaume
Guillaume 2019-9-17
Well, yes you've got no invalid rows, so you get empty results. If you indeed had invalid rows, you'd see them.
The number of invalid rows is:
nnz(mask)

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by