MATLAB Answers

Finding matching strings from a table and making a new table

1 view (last 30 days)
SChow
SChow on 18 Feb 2020
Commented: Stephen Cobeldick on 18 Feb 2020
I have a huge table of size 18792010x57 (57) are the number of columns.
As an example say the table (T) that looks like:
'A' 'B' 'C' 'D'......'BC'
'AFG' 'NCD' 22 1..... 2
'CAN' 'NCD' 36 7......4
'AFG' 'HER' 21 3......3
'BER' 'NCD' 32 1......5
'CAN' 'HER' 31 1......3
I want to make a separtate table (T_1) just for AFG like:
'A' 'B' 'C' 'D'......'BC'
'AFG' 'NCD' 22 1..... 2
'AFG' 'HER' 21 3......3
I am using readtable function to read the table and the used the below line but it returns an error --> 'Undefined operator '==' for input arguments of type 'cell'
T_1 = T(T.A == 'AFG')

  1 Comment

Stephen Cobeldick
Stephen Cobeldick on 18 Feb 2020
This is not a good sign:
T_1
Putting numbers into variable names indicates that you are doing something wrong.
Splitting up into multiple tables is unlikely to be required, it is usually easier to process the data in one table:

Sign in to comment.

Accepted Answer

Bhaskar R
Bhaskar R on 18 Feb 2020
T_1 = T(strcmp(T.A, 'AFG'), :);

  0 Comments

Sign in to comment.

More Answers (0)

Sign in to answer this question.