Finding matching strings from a table and making a new table

1 次查看（过去 30 天）
SChow
SChow 2020-2-18
评论： Stephen23 2020-2-18
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 个评论
Stephen23
Stephen23 2020-2-18
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:
https://www.mathworks.com/help/matlab/matlab_prog/grouping-variables-for-splitting-data.html

请先登录，再进行评论。

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

采纳的回答

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

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by