How can I replace a pair of coordinates (x;y) in a table by values from a list of reference coordinates?

Question

Mathieu Petremann 2023-4-12

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1945749-how-can-i-replace-a-pair-of-coordinates-x-y-in-a-table-by-values-from-a-list-of-reference-coordin

评论： Mathieu Petremann 2023-4-13

Hi,

I need your help to create a short script.

I have two series of data in Excel with pixel coordinate one for x and one for y, in two columns, for all existing spots counted in every location of a sample.

I aslo have some reference values selected for every unique pair of coordinates also (X;Z) in two columns, plus two extra columns for the corresponding absolute position on the sample (Abs_Len) and the relative position (Rel_Len).

I would like to create a new matrix of two columns that replace every pair of x;y by the corresponding Abs_Len and Rel_Len according to the reference columns X;Y.

Thansk for your help

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

Antoni Garcia-Herreros 2023-4-12

Could you upload the Excel file?

请先登录，再进行评论。

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

Answer 1

Antoni Garcia-Herreros 2023-4-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1945749-how-can-i-replace-a-pair-of-coordinates-x-y-in-a-table-by-values-from-a-list-of-reference-coordin#answer_1214299

在 MATLAB Online 中打开

Hello Mathieu,

You can try something like this:

However, I did not find any X, Y pair of values present in both len and IHC.

clear all
close all
len = readmatrix('SAMPL01_R.xlsx','Sheet','len');
IHC = readmatrix('SAMPL01_R.xlsx','Sheet','IHC');
OHC = readmatrix('SAMPL01_R.xlsx','Sheet','OHC');
for i=1:size(len,1)
    x=len(i,3); % X value in len
    y=len(i,4); % Y value in len
    fIHC=find(ismember(IHC(:,3:4),[x,y],'rows')); % Find the indices where IHC is equal to X and Y
    fOHC=find(ismember(OHC(:,3:4),[x,y],'rows')); % Find the indices where O is equal to X and Y
    if ~isempty(fIHC)
        for j=1:length(fIHC) % Loop through IHC indices
            IHC(fIHC(j),5:6)=len(i,5:6); % Add len_mume and len_rel to IHC
        end
    end
    if ~isempty(fOHC)
        for j=1:length(fOHC) % Loop through OHC indices
            OHC(fOHC(j),5:6)=len(i,5:6); % Add len_mume and len_rel to OHC
        end
    end
end
OHCMat=OHC(OHC(:,5)>0,:); % Create the matrix with only the matching values
IHCMat=IHC(IHC(:,5)>0,:);

Let me know if that helps,

2 个评论
显示无隐藏无

Mathieu Petremann 2023-4-12

Hello Antoni,

Thanks a lot. Indeed the file I sent was not the best exemple.

But I will try the script tomorrow with other files.

That should still help me a lot!

I will let you know.

Best,

Mathieu

Mathieu Petremann 2023-4-13

Hello Antoni,

I tested it with another file and it works perfectly.

Thanks a lot!

Mathieu

请先登录，再进行评论。

Answer 2

Mathieu Petremann 2023-4-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1945749-how-can-i-replace-a-pair-of-coordinates-x-y-in-a-table-by-values-from-a-list-of-reference-coordin#answer_1214229

SAMPL01_R.xlsx

Hi,

Here is the file.

The len sheet is my reference table and I want to attribute the refence len_mume and len_rel to the IHC and OHC sheets for the corresponding coordinates.

Thanks!