Using string compare on imported data

1 次查看（过去 30 天）
Jacob Barrett-Newton
评论： Jacob Barrett-Newton 2018-2-11
I am very new to Matlab and have only ever used maple. I am trying to use string compare on huge imported data (26,000 rows) to a specific word to find the row that contains it.
I understand the basics of strcmp and can use it within matlab, but cannot figure out how to use it for a data set. So for example, I am currently working with the code:
s1 = 'RT'; s2 = {ImpD(:,4)}; TF = strcmp(s1, s2); find(TF);
ImpD(:,4) since I am looking for the specific text in the 4th column. I just don't think Matlab is realizing I am referencing the imported data. How can i fix this?
  6 个评论
显示 4更早的评论
Guillaume
Guillaume 2018-2-11
Is it string or char array? People use the two interchangeably but they are actually two very different types. comparisons are easier with strings.
Since ImpD is a table, what is the name of the fourth column?
Jacob Barrett-Newton
Jacob Barrett-Newton 2018-2-11
Well now that i have imported it as a string array, class(ImpD) returns string and class(ImpD{1, 4}) returns char

请先登录，再进行评论。

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

采纳的回答

Guillaume
Guillaume 2018-2-11
If ImpD is a string array with a least four columns:
ismatch = ImpD(:, 4) == "RT"
to find "RT" in the fourth column.
If it were a table as you had initially:
ismatch = ImpD{:, 4} == "RT"
%or
ismatch = ImpD.column4name == "RT" %replace column4name by actual name
If you're going to wrap the above in a loop to find different strings and do something then it is very likely that there is a much better way. A better explanation of what you want to achieve and of the starting point would be required.
  1 个评论
Jacob Barrett-Newton
Jacob Barrett-Newton 2018-2-11
well after I identify which rows contain which bit of text, I can then extract the values from the corresponding columns and plot it. The required text is also imported. Its a table with the text i need in the second column. At the moment now that I can find the row I can just one by one search for it, but like I said being able to loop it would make it a lot cleaner and easier.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by