Replacing numerical values in table with string

11 次查看（过去 30 天）
Emu
Emu 2024-3-22
编辑： 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

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

回答（1 个）

Stephen23
Stephen23 2024-3-22
编辑：Stephen23 2024-3-22
Ran in:
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

类别

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

标签

产品


版本

R2023b

Community Treasure Hunt

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

Start Hunting!

Translated by