Removing unique numbers whilst comparing two structures

Question

Manny Kins 2019-4-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/458477-removing-unique-numbers-whilst-comparing-two-structures

编辑： Manny Kins 2019-4-25

采纳的回答： Stephen23

I have two structs, one called AllPositions_CA with X and Y fields containing this type of layout:

X Y

1x17051 double 1x17051 double

1x17267 double 1x17267 double

1x17579 double 1x17579 double

1x17971 double 1x17971 double

1x17959 double 1x17959 double

1x17947 double 1x17947 double

1x17854 double 1x17854 double

1x641 double 1x641 double

1x17918 double 1x17918 double

1x17544 double 1x17544 double

This structure has a length 114 (I have only shown 10)

I have a second structure called PositionA which has X and Y fields containing this type of layout:

X Y

1x42 double 1x42 double

1x44 double 1x44 double

1x43 double 1x43 double

1x44 double 1x44 double

1x43 double 1x43 double

1x44 double 1x44 double

1x42 double 1x42 double

This particular structure has length of 18000 (I have only shown 10)

I want to be able to take ALL X and Y values as pairs in AllPositions_CA and compare them to X and Y pair values in PositionA and remove any values which are present in PositionA but are not present in AllPositions_CA and put them into a new structure whilst retaining the layout of the structure PositionA. For example after the removal of some values from PositionA the new structure will look like:

X Y

1x40 double 1x40 double

1x39 double 1x39 double

1x41 double 1x41 double

1x40 double 1x40 double

1x42 double 1x42 double

1x41 double 1x41 double

1x39 double 1x39 double

1x40 double 1x40 double

1x43 double 1x43 double

1x38 double 1x38 double

I have looked into intersect and setdiff but cannot get my head around how to loop one structure through another to find differences and return the desired final layout as above.

Thanks

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

Image Analyst 2019-4-25

Please attach AllPositions_CA in a .mat file with the paper clip icon.

Also, see Stephen's answer below.

Manny Kins 2019-4-25

编辑：Manny Kins 2019-4-25

Hi Jan, Image Analyst, I apologise for not wording my question clearly. I wanted to remove all unmatched values whilst keeping the X and Y values paired, so the comparison was for both the X and Y values. Stephens example is pretty much spot on with what I wanted:

So if I had structures:

C = struct('X',{[0,1,3],[3,4]}, 'Y',{[5,6,8],[8,9]});

A = struct('X',{[0,2,3],[3,10]},'Y',{[5,7,8],[8,11]});

and I wanted to remove all (X/Y pair matched) values then the final struct would look like:

X Y

[0,3] [5,8]

3 8

keeping only the matched pair values and removing the rest.

请先登录，再进行评论。

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

Answer 1

Stephen23 2019-4-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/458477-removing-unique-numbers-whilst-comparing-two-structures#answer_372238

编辑：Stephen23 2019-4-25

在 MATLAB Online 中打开

A loop and ismember makes this clear and easy. An alternative would be to merge the X and Y data, and then call setdiff in the loop with its 'rows' option.

I assume that you wanted to match both the X and Y values simultaneously, i.e. you want to match coordinate pairs, not individual values. (you did not specify this explicitly in your question).

Here is a simple working example with a loop:

C = struct('X',{[0,1,3],[3,4]}, 'Y',{[5,6,8],[8,9]});
A = struct('X',{[0,2,3],[3,10]},'Y',{[5,7,8],[8,11]});
Z = struct('X',{},'Y',{}); % new structure.
CX = [C.X]; % All of C.X.
CY = [C.Y]; % All of C.Y.
for k = 1:numel(C)
	idx = ismember(A(k).X,CX) & ismember(A(k).Y,CY);
	Z(k).X = A(k).X(~idx); % copy non matching to Z.
	Z(k).Y = A(k).Y(~idx); % copy non matching to Z.
	A(k).X(~idx) = []; % optional: remove from A.
	A(k).Y(~idx) = []; % optional: remove from A.
end

Giving (for example):

>> A.X
ans =
     0     3
ans =
     3
>> Z.X
ans =
     2
ans =
    10

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

Stephen23 2019-4-25

@Guillaume: yes, I noticed that too, and made a few small changes to allow for that.

Manny Kins 2019-4-25

Hi Stephen, Guillaume, thank you for your help. I know the question I asked was worded quite confusingly but somehow you managed to decipher it and give exactly what I wanted! I did indeed want to match both the X and Y values simultaneously, and the additional option of removing the values from the initial array itself was very useful. Much appreciated.

请先登录，再进行评论。