How to inner join two matrices?
显示 更早的评论
I have following two matrices of data that contain three columns each, first two columns are GPS data (latitude, longitude) and the third value is elevation angle. I would like to inner join both tables based on their GPS values to calculate the difference in elevation angle between the two matrices. Here is an example;
tbl1 = [
28.057 -80.621 25.3
......];
tbl2 = [
28.057 -80.624 20.6
28.057 -80.621 20.62
.....];
tbl3 should look like the following:
tbl3 = [
28.057 -80.621 25.3 20.6 4.7];
Any idea on how to join these tables? Cheers!
采纳的回答
[~, row1, row2] = intersect(tbl1(:, [1 2]), tbl2(:, [1 2]), 'rows');
tbl3 = [tbl1(row1), tbl2(row2, 3)];
tbl3(:, 5) = diff(tbl3(:, [4 3]), [], 2);
This assumes that the GPS values are exactly identical in both matrices or that they're rounded to the same number of decimals in both.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Cell Arrays 的更多信息
Translated by 
