Replacing numerical values in table with string

8 Ansichten (letzte 30 Tage)
Emu
Emu am 22 Mär. 2024
Bearbeitet: Stephen23 am 22 Mär. 2024
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

Antworten (1)

Stephen23
Stephen23 am 22 Mär. 2024
Bearbeitet: Stephen23 am 22 Mär. 2024
This is MATLAB, so forget about using a loop like that. Either replace the entire column at once or use e.g.:
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

Kategorien

Mehr zu Matrix Indexing finden Sie in Help Center und File Exchange

Produkte


Version

R2023b

Community Treasure Hunt

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

Start Hunting!

Translated by