I want to replace strings in a column of a structure (see the picture) with numbers/codes. Can someone help with this??

1 次查看（过去 30 天）
Marco
Marco 2023-9-14
评论： Walter Roberson 2023-9-14
I have several strings in a column of a structure. They were imported to matlab through eeglab. The strings that I'm interested in are "stm+" and "resp" (you can see the picture attached). I want to replace them with number 1 and 3, respectively.
  2 个评论
Walter Roberson
Walter Roberson 2023-9-14
Do you want to replace them with "1" and "3" or with numeric 1 and 3? Because if you want to replace them with numeric 1 and 3, you would have to deal with the fact that the rest of the column is going to remain string.

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2023-9-14
codestrings = {'bgin', 'resp', 'stm+', 'TRSP'};
codevals = [-2, 3, 1, -4];
[found, index] = ismember(YourTable.columnlabel, codestrings);
codes = nan(height(YourTable), 1);
codes(found) = codevals(index(found));
This inserts nan for any unrecognized string, and whatever value is in codevals for recognized strings.
  2 个评论
Marco
Marco 2023-9-14
Thank you! I could use only the first 3 lines. FYI, I run this:
index=num2cell(index);
and
[YourTable.columnlabel]=index{:};
So I could replace the whole column in the structure I need.
Thanks!
Walter Roberson
Walter Roberson 2023-9-14
You could have just used
YourTable.columnlabel = codes;
codes was already constructed as a column vector the correct size (the nan initialization took care of that), and when you use dot notation to assign to a table variable, the type of the variable will be changed if needed.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by