Replacing numerical values in table with string

Question

Emu 2024-3-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2097721-replacing-numerical-values-in-table-with-string

编辑： Stephen23 2024-3-22

I have a column of numerical data (all 2 digit) which I want to replace with a string.

This is my code which doesn't work. I would like the data to read e.g. 'voc_15'.

for b=1:size(type_data_table,1)

type_data_table.voc_type(b) = ['voc_', num2str(type_data_table{b, 'voc_type'})];

end

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Stephen23 2024-3-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2097721-replacing-numerical-values-in-table-with-string#answer_1429636

编辑：Stephen23 2024-3-22

在 MATLAB Online 中打开

This is MATLAB, so forget about using a loop like that. Either replace the entire column at once or use e.g.:

https://www.mathworks.com/help/matlab/ref/table.convertvars.html

For example:

T = array2table(randi(99,7,3))
T = 7x3 table
    Var1    Var2    Var3
    ____    ____    ____

      2      32      52 
     69      60      82 
     70       4      70 
     70      30       3 
     45      43      62 
      3      99      36 
     55      16      75 
T.Var2 = "voc_"+T.Var2
T = 7x3 table
    Var1      Var2      Var3
    ____    ________    ____

      2     "voc_32"     52 
     69     "voc_60"     82 
     70     "voc_4"      70 
     70     "voc_30"      3 
     45     "voc_43"     62 
      3     "voc_99"     36 
     55     "voc_16"     75 