How best to compare a columns from one set of data with columns from another?

Question

Harry Baker 2021-10-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1570203-how-best-to-compare-a-columns-from-one-set-of-data-with-columns-from-another

回答： Sameer 2024-2-28

I have 2 data sets where the 3 left most columns are markers for that data (ie A 1 1, A 1 2, B 1 1, etc). I need to plot the data in the 4th column in each set against each other but i dont know how to search for the matching set of 3 markers to pair the data up.

Any idea how I could do this?

2 个评论
显示无隐藏无

Matt J 2021-10-23

It depends whether your data sets are in the form of a matrix or a table.

Jan 2021-10-23

Please post some code, which produces a small example of the input array. "(ie A 1 1, A 1 2, B 1 1, etc)." is not clear.

请先登录，再进行评论。

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

Answer 1

Sameer 2024-2-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1570203-how-best-to-compare-a-columns-from-one-set-of-data-with-columns-from-another#answer_1417846

在 MATLAB Online 中打开

Hi Harry,

From my understanding, you have two datasets where the first three columns serve as unique identifiers (markers) for each row, and you want to compare the values in the fourth column of both datasets by matching these identifiers.

You can achieve this using the code below:

% Example datasets
% dataSet1 = [A 1 1 value1; A 1 2 value2; ...]
% dataSet2 = [A 1 1 value1'; A 1 2 value2'; ...]
% Extract the marker columns from both datasets
markers1 = dataSet1(:, 1:3);
markers2 = dataSet2(:, 1:3);
% Extract the data columns from both datasets
data1 = dataSet1(:, 4);
data2 = dataSet2(:, 4);
% Find the matching rows
[commonMarkers, idx1, idx2] = intersect(markers1, markers2, 'rows')
% Now idx1 contains the indices of the matching rows in dataSet1
% and idx2 contains the indices of the matching rows in dataSet2
% Extract the matching data
matchedData1 = data1(idx1)
matchedData2 = data2(idx2)
% Plot the data
figure;
plot(matchedData1, matchedData2, 'o');
xlabel('Data from DataSet1');
ylabel('Data from DataSet2');
title('Plot of Matched Data');