grouped difference between two tables

2017 11 9
2 个回答
回答已采纳
更新时间：2017 11 16
5 次查看（30 天）

0 个投票

Is there a slick way to apply a function (in my case find the difference) between two tables if they have the same variable names in both tables but different numbers of rows. in my case I have one table of average values generated by varfun using a grouping variable and I want to subtract the values in that table from the second table for all other variables when the grouping variable matches between the two tables. I can easily loop through it and get it that way or create index groups by row, but as I have not used tables a whole lot, I am hoping there is a neat/efficient way that I have not thought of.
thanks

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

 采纳的回答

Gregory McFadden
Gregory McFadden 2017-11-16

0 个投票

What I ended up doing, as I know the table columns and order for both tables, was to use an outer join and then split the table into two, subtracting one from the other. it worked quite well.

更多回答（1 个）

Peter Perkins
Peter Perkins 2017-11-16

0 个投票

With one grouping var, you can get the correspondence between rows using ismember. Given that, you can get the differences using braces on the two tables to pull out the numeric data, something like
t3 = t1{:,j} - t2{i,j}
where i is the output of ismember and j is the vars you want to subtract.

类别

在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by