Question about extracting rows from a table based on string

Hello everyone
I wanted to store all winter ("Win") values of the rrr24 column in my data set in a new array
So I tried to do it like:
C_Winter = temp(strcmp((temp.seasons,'Win'),rrr24));
But this error appears,
C_Winter = temp(strcmp((temp.seasons,'Win'),rrr24));
Error: Invalid expression. When calling a function or indexing a variable,
use parentheses. Otherwise, check for mismatched delimiters.
I tried some other ways but all of them leads to error. Do you know what should I do?
Thank you.

5 Kommentare

Stephen23
Stephen23 am 7 Aug. 2020
Bearbeitet: Stephen23 am 7 Aug. 2020
"Do you know what should I do?"
Match the parentheses:
temp(strcmp((temp.seasons,'Win'),rrr24))
% 0 12 2 10
Why are you including the column rrr24 index inside of the strcmp function call?
I don't see anything like that shown in the strcmp documentation or the table indexing documentation:
BN
BN am 7 Aug. 2020
Bearbeitet: BN am 7 Aug. 2020
Thank you, I deleted extra columns and change it to:
t = strcmp(temp.season,'Win');
now it resulted a logical vector, i tried to use it as index:
temp (t)
But error:
Subscripting into a table using one subscript (as in t(i)) or three or more
subscripts (as in t(i,j,k)) is not supported. Always specify a row
subscript and a variable subscript, as in t(rows,vars).
Stop me.
Do you know how can I do? Thanks
Thank you I just found it:
t = temp(strcmp(temp.season,'Win'),:);
dpb
dpb am 7 Aug. 2020
Bearbeitet: dpb am 9 Aug. 2020
The above is all columns, you said you wanted the one variable...alternatively, remove the string from the 'seasons' variable...
temp.seasons=categorical(temp.seasons); % convert to categorical variable type
C_Winter=temp.rrr24(temp.seasons=='Win'); % pick winter seasons from rrr24 array
Thank you

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Kategorien

Mehr zu Matrices and Arrays finden Sie in Hilfe-Center und File Exchange

Produkte

Version

R2020a

Gefragt:

BN
am 7 Aug. 2020

Bearbeitet:

dpb
am 9 Aug. 2020

Community Treasure Hunt

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

Start Hunting!

Translated by