Merge two columns of same table into one

Question

Adnan Habib 2020-4-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/517444-merge-two-columns-of-same-table-into-one

评论： Adnan Habib 2020-4-13

采纳的回答： Akira Agata

Hi,

I have a table with 3 columns like the following:

A B C

'4618' '1193' 3

'9810' '1224' 1

'7810' '27845' 1

'6324' '1627' 6

'8954' '1678' 1

'9629' '2061' 1

I have only shown a small portion of the table, actually it is a 3079X3 table. A and B are cells and C is a double. I want the table to look like this:

AB C

'46181193' 3

'98101224' 1

'781027845' 1

'63241627' 6

'89541678' 1

'96292061' 1

I have tried using horzcat but it didn't work. Can someone please help me out with the code?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Akira Agata 2020-4-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/517444-merge-two-columns-of-same-table-into-one#answer_425651

在 MATLAB Online 中打开

Assuming columns A and B are cell array of characters, how about the following?

% Sample input table
A = {'123';'234';'345'};
B = {'1111';'2222';'3333'};
C = [1;2;3];
T1 = table(A,B,C);
% Create output table
AB = strcat(T1.A,T1.B);
T2 = table(AB,C);