Convert a numerical variable in a table to string

Question

Boushra Dalile 2018-5-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/398860-convert-a-numerical-variable-in-a-table-to-string

编辑： Guillaume 2018-5-4

I have a table T with 5 variables/columns

The 3rd variable (pic), with 75 rows, is basically pic = [70, 40, 60, 70, 50, 65...] How can I convert this one variable in the able to a string? I need to do that so I can carry out strrep later on.

T = string (T(:,3)) is not working. Any ideas where I am going wrong?

Thanks heaps!

3 个评论
显示 1更早的评论隐藏 1更早的评论

Boushra Dalile 2018-5-3

I am trying to piece together a series of replacements if a separate condition is satisfied, specifically:

If Table x (table with variables, and variable 3 (pic) contains numbers such as 10, 30, 40, 60, 30, 70) contains 35, then - replace all '60' with 'z1' - replace all '40' with 'z2' - replace all '30' with 'z3'

If not, - replace all '60' with 'y1' - replace all '40' with 'y2' and so forth.

Guillaume 2018-5-3

编辑：Guillaume 2018-5-4

It seems odd to want to replace numerical value with text. Nonetheless, all this replacement can be done a lot more easily and certainly a lot faster without having to convert any of the numbers to text beforehand.

To show you how to do that, you need to be a bit clearer on what is replaced by what. Give an example using valid matlab syntax.

edit: see Walter's answer for what I mean, using a lookup table will be a lot faster than converting numbers to strings

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2018-5-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/398860-convert-a-numerical-variable-in-a-table-to-string#answer_318574

在 MATLAB Online 中打开

zlookup = {'z1', 'z2', 'z3'};
T3 = T{:,3};
[tf, idx] = ismember(T3, [60, 40, 30]);
out = cell(length(tf),1);
out(tf) = zlookup(idx(tf));
out(~tf) = sprintfc('%g', T3(~tf));
T{:,3} = out;