Merge two table columns (column 1: categorical data; column 2: double el) into one (column 3: categorical or string el) and replace columns 1,2 with 3 in the table

2 visualizaciones (últimos 30 días)
Dear All,
I have a table with 4 columns, column 1: T.Letters = A; BC, DEF, G, HI .. etc (categorical array)
column 2: T.Numbers = 1;2;3;4;1;2;1;2;3 .. etc (double array)
How can I combine columns 1 and 2 into column 3: T.Lettersnumbers = A1; BC2; DEF3; G4; HI1 .. (containing categorical or string elements 'HI1'),
then insert it into the table in lieu of columns 1 and 2.
Many thanks,
Vio

Respuesta aceptada

Bhaskar R
Bhaskar R el 27 de En. de 2020
T.Lettersnumbers = strcat(char(T.Letters), num2str(T.Numbers));

Más respuestas (1)

Walter Roberson
Walter Roberson el 27 de En. de 2020
T.Lettersnumbers = string(T.Letters) + T.Numbers;

Categorías

Más información sobre Categorical Arrays en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by