Way to concatenate tables with some but not all variables in common?

3 次查看（过去 30 天）
Gabe
Gabe 2017-7-6
编辑： Sterling Baird 2020-9-5
I am trying to concatenate several similar tables that have mostly the same variables, but a few differences. In the cases of different variables I'd want to pad values with NaN.
For example:
A =
var1 var2
____ ____
1 2
B =
var1 var3
____ ____
1 3
C=somefunction(A,B)
C =
var1 var2 var3
____ ____ ____
1 2 NaN
1 NaN 3
Is there any canned function that does this?
  2 个评论
Peter Perkins
Peter Perkins 2017-7-7
Gabe, hacking outerjoin to do vertical concatenation is super clever, but I think it isn't going to work for you, because the common variables that you'd use as the "key" (Var1 in your example) have values in common. At least in your example they do.
I think you'd be safer just finding the setxor of the two lists of var names, and creating the vars you need using NaNs.

请先登录，再进行评论。

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

回答（1 个）

Sterling Baird
Sterling Baird 2020-9-5
编辑：Sterling Baird 2020-9-5
Here is a "canned" FEX function (tblvertcat) I just refactored using some old code I wrote a while ago and based on a MATLAB Answers post. It can be used for an arbitrary number of tables, and supports double, char, cell, struct, etc.

类别

在 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