Merging the matched rows of two matrices/files

Question

Vijay 2020-9-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/602614-merging-the-matched-rows-of-two-matrices-files

编辑： Vijay 2020-10-8

采纳的回答： Vijay

A.mat
B.mat

在 MATLAB Online 中打开

I have two sets of data as in the attached files A and B (where length(A)>length(B)).

I need to

(i) Match:

Match the IDs in column 1 then compare the numbers in column 2 of A and B, and identify the rows with relatively closer numbers in column 2.

For instance B(1,:) -->

3000 70.0800000000000 0

and A(2,:) -->

3000 70.0200000000000 2981.87406731008

(ii) Merge:

Follwing to the match in (i), place the element '0' from column 3 of B in a newly created 4th column in A and leave '.' as the place holders in the remaining rows that doesn't have matching column 2 elements with B

For instance in A(1:2, :) ...

3000 69.9400000000000 2982.16721456415 .
3000 70.0200000000000 2981.87406731008 0

Any help to sort this will be highly appreciated.

Thank you

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

KSSV 2020-9-30

Read about ismembertol.

请先登录，再进行评论。

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

Answer 1

Vijay 2020-10-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/602614-merging-the-matched-rows-of-two-matrices-files#answer_508851

编辑：Vijay 2020-10-8

在 MATLAB Online 中打开

The following loop worked in this case

A(:,4)=100;  
    for o=1:size(B,1)
        for p=1:size(A,1)
            if abs(A(p,2)-B(o,2))<=0.05 
                A(p,4) = B(o,3);
            end
        end
    end
nh1=num2cell(A);
nh1(A == 100) = {'.'};
DT = array2table(nh1);

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

请先登录，再进行评论。

Answer 2

Aman Vyas 2020-10-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/602614-merging-the-matched-rows-of-two-matrices-files#answer_506156

Hi,

You can try to use ismembertol which gives or reports members within some tolerance.

You can have a look at this link:

https://www.mathworks.com/help/matlab/ref/ismembertol.html

Also you can utilise other ismember syntax as per the functionality you want to achieve for code.

You can refer to this

Hope it helps !

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

Vijay 2020-10-6

编辑：Vijay 2020-10-8

Hi Aman and KSSV,

Thank you so much for your response. I tried the ismembertol function. This function works great but somehow not helpful in my case as it brings more rows in LIA than that in B. The intention is to merge 3rd column elements of B as the 4th column for the matched rows in A.

I did this creating a 4th column in A with a dummy variable and comparing the A-B with a tolerance of 0.05 as shoown in my answer below.

请先登录，再进行评论。