How to inner join two matrices?

5 次查看（过去 30 天）
Mohammed
Mohammed 2016-10-20
评论： Mohammed 2016-10-21
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!

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

采纳的回答

Guillaume
Guillaume 2016-10-20
编辑：Guillaume 2016-10-21
[~, 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.
  3 个评论
显示 1更早的评论
Guillaume
Guillaume 2016-10-21
编辑：Guillaume 2016-10-21
Sorry, forgot to specify the dimension in diff (and got the wrong column destination). It should have read:
tbl3(:, 5) = diff(tbl3(:, [4 3]), [], 2);
Fixed now.
Mohammed
Mohammed 2016-10-21
Works like charm, however it is missing single parenthesis :). thanks again for sharing your knowledge.
tbl3(:, 5) = diff(tbl3(:, [4 3]), [], 2);

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Resampling Techniques 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by