Merge rows with similar names

Question

Vlatko Milic 2021-10-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1569423-merge-rows-with-similar-names

评论： Vlatko Milic 2021-10-27

Hi,

I have a table consisting of ten columns. In the first column, each row has a unique name. However, many rows have the same starting four letters. I would like to merge the rows with the same starting letters, and perform some calculations based on these rows.

Thanks in advance!

3 个评论
显示 1更早的评论隐藏 1更早的评论

Vlatko Milic 2021-10-22

I mean concatenate. I.e. to group the into the same rows, or vectors. I know how to do it if I had the same row names all over, however, it is only in the beginning the row names are the same.

Thanks Stephen

Image Analyst 2021-10-22

@Vlatko Milic, you keep forgetting to attach your data in a .mat file with the paperclip icon. Here's another chance to read the posting guidelines:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

请先登录，再进行评论。

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

Answer 1

Pranjal Kaura 2021-10-26

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1569423-merge-rows-with-similar-names#answer_816698

在 MATLAB Online 中打开

Hey Vlatko,

It's my understanding that you want to group/merge rows with similar names. The criteria for 'similarity' is that they must have the same first 4 letters. You also mention that you know how to merge/group these rows when using complete row names for judging similarity, but are facing issues while merging using only a subset of the row name.

Here is a code snippet using which you can identify which rows are similar, using only the first 'n' letters. This will provide you with a number (say group number) for every row. 'Similar' rows would have the same number You can then merge them using your custom code.

A = ["Pizza", "Hello", "Hellbound", "Yesterday", "Yesss", "Yesman"]; % your first column
n = 3; %number of initial alphabets to consider
A2 = extractBetween(A(:), 1, n);
A_groups = unique(A2);
[~,A_groupNum] = ismember(A2, A_groups) %this will assign a number to every row. Similar rows would have the same number