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 (최근 30일)
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

채택된 답변

Bhaskar R
Bhaskar R 2020년 1월 27일
T.Lettersnumbers = strcat(char(T.Letters), num2str(T.Numbers));

추가 답변 (1개)

Walter Roberson
Walter Roberson 2020년 1월 27일
T.Lettersnumbers = string(T.Letters) + T.Numbers;

카테고리

Help CenterFile Exchange에서 Tables에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by