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

8 visualizzazioni (ultimi 30 giorni)
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

Risposta accettata

Bhaskar R
Bhaskar R il 27 Gen 2020
T.Lettersnumbers = strcat(char(T.Letters), num2str(T.Numbers));

Più risposte (1)

Walter Roberson
Walter Roberson il 27 Gen 2020
T.Lettersnumbers = string(T.Letters) + T.Numbers;

Categorie

Scopri di più su Tables in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by