Merge two cells of different size but have one rows in common

Question

Yao Lionel 2023-1-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1900590-merge-two-cells-of-different-size-but-have-one-rows-in-common

回答： Sarthak 2023-3-6

Hello Guys,

I have two Matlab cells that I have one row in common. I have to merge to Add to the first the uncommon rows of the second one.

commonValue=intersect(r_ptf{12,:},r_ptf3{12,:});

Could someone help me out

4 个评论
显示 2更早的评论隐藏 2更早的评论

Yao Lionel 2023-1-25

@Dyuman Joshi is it a good answer for you to help me out

dpb 2023-1-25

When it comes to cell arrays, it's pretty-much impossible to write generic code w/o knowing the content since it could be anything.

As @Dyuman Joshi requested, for somebody to be able to help, we'll need to see a small sample case that illustrates what the content of the two cell arrays is...it doesn't need (and shouldn't be) huge; just make up a test case that illustrates wht your situation is...only 10 or so rows and columns would be more than enough; but it needs to be representative of the real thing.

请先登录，再进行评论。

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

Answer 1

Sarthak 2023-3-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1900590-merge-two-cells-of-different-size-but-have-one-rows-in-common#answer_1186065

在 MATLAB Online 中打开

Hi,

Here are the steps and the code you could refer:

% Find the common value  
commonValue = intersect(r_ptf{12,:}, r_ptf3{12,:});  
% Find the indices of the rows that have the common value in both cells  
idx1 = find(ismember(r_ptf{12,:}, commonValue)); 
 idx2 = find(ismember(r_ptf3{12,:}, commonValue));  
% Remove the rows with the common value from the second cell  
r_ptf3(idx2,:) = [];  
% Merge the two cells by adding the uncommon rows of the second cell to the first cell  
r_ptf = [r_ptf; r_ptf3];