How to match array data and excel data?

1 次查看(过去 30 天)
I have array data and excel data. I want to match my array data with excel data. For example, I want array data 'I' to match with excel data 'B'. If all contents of data 'I' match all columns in a particular row of data 'B', then the output result is data 'A' in the same row as data 'B'. I will be appreciated if someone guides me. Thank you
I = [0.0673 22.8800 4.5213e+03 2.1387e+03 12.4245 0.6936 3.7715 0.0474 0.2561 16.0428 82.6339];
Data 'B'
Data 'A'
  5 个评论
Nilna Almumtazah
Nilna Almumtazah 2022-12-20
For example, in data 'I', the contents are the same as data 'B' in row 9. So that the results of data 'A' in row 9 will also be obtained.
Nilna Almumtazah
Nilna Almumtazah 2022-12-20
I want to retrieve the row number, provided that the column value matches data 'I'.

请先登录,再进行评论。

回答(1 个)

prasanth s
prasanth s 2022-12-20
if all data type is in array type,
the matching row positions can be obtained using
rows=all(B==I,2)
contents from 'A' obtained using
data=A(rows,:);
  4 个评论
Adam Danz
Adam Danz 2022-12-20
@Nilna Almumtazah, this is either because row I does not have a match in matrix B or it could be due to roundoff error as I mentioned in my initial comment under your question.
@prasanth s' answer works well for integers or for floating point decimals with low precision (few decimal places). But since it only looks for exact matches, it will not handle roundoff error gracefully.
Here's how to apply a tolerance to the comparison:
% M is the matrix
% v is the row vector
rows=all(abs(M-v)<eps(min([M(:);v(:)])),2);
data=M(rows,:);

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Logical 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by