MATLAB Answers

How can I combine two categorical columns of a tall table?

16 views (last 30 days)
James
James on 28 Mar 2017
Answered: Edric Ellis on 29 Mar 2017
I have a tall table with two categorical columns -- for example:
tx = tall(table(categorical({'a';'b';'b';'b'}), categorical({'x';'x';'y';'y'})));
and I want to create a new column that combines those columns.
For regular tables, I would write:
tx.Var3 = categorical(string(tx.Var1) + " " + string(tx.Var2))
However, this doesn't work with tall tables, since the string.plus method doesn't support tall arrays.
Is there a good way to create this combined column without gathering all the data?

Answers (1)

Edric Ellis
Edric Ellis on 29 Mar 2017
You can use join, like so:
join([string(tx.Var1), string(tx.Var2)])

Community Treasure Hunt

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

Start Hunting!