grouped difference between two tables

1 次查看（过去 30 天）
Gregory McFadden
Gregory McFadden 2017-11-9
回答： Gregory McFadden 2017-11-16
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
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
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.

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by