Append rows of string in a table

Question

Sergiu Panainte 2020-7-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/568362-append-rows-of-string-in-a-table

评论： Star Strider 2020-7-21

Imagine the following table:

id = {1; 1; 2; 2; 3};
someStr = {"how are"; "you"; "I am"; "fine"; "some text" }; 
T = table(id, someStr); 

What I am trying to do is to append lines with same id. In the end the table must look like this:

idNew = {1; 2; 3};
someStrNew = {"how are you"; "I am fine"; "some text"};
Tnew = table(idNew, someStrNew); 

Is there a way to do this in matlab?

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2020-7-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/568362-append-rows-of-string-in-a-table#answer_468837

在 MATLAB Online 中打开

I can get it to work with character arrays, however not with string objects. I cannot get the char (or similar functions, such as convertStringsToChars) conversion from string objects to character arrays to work inside these functions.

Try this:

id = {1; 1; 2; 2; 3};
% someStr = {"how are"; "you"; "I am"; "fine"; "some text" };             % Commented Out
someStr = {'how are'; 'you'; 'I am'; 'fine'; 'some text' }; 
Out = accumarray([id{:}]', (1:numel(id))', [], @(x){someStr(x)'});
Out = cellfun(@(x)strjoin(x), Out, 'Uni',0)

producing:

Out =
  3×1 cell array
    {'how are you'}
    {'I am fine'  }
    {'some text'  }

You would likely have to extract everything from the table first. Using table objects have their advantages, however here they simply introduce an additional level of complexity.