- Use readmatrix to read in your data since it appears that you are matching rows and your data appear to be homogenous, all numeric. You'll read in the two data sets as two separate matrix variables.
- It looks like your data do not have more than 7 decimal places so roundoff error shouldn't be a problem. If it turns out that your data are more decimal places that what appears in your screenshots, you'll need to decide how you deal with precision issues that may arise. Let's cross that bridge if we come to it.
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'
回答(1 个)
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
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 Center 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!