Converting two matrix to a single table

27 views (last 30 days)
Ville Koivunen
Ville Koivunen on 12 Sep 2019
Hello
How could I easily construct a single table from two matrix so that the corresponding values of these matrices are represented in
table columns which have written headings.
Here is an example needed
M1 =
3 3
8 NaN
M2 =
6 1
5 4
Outcome Table =
M1value M2 value
3 6
3 1
8 5
NaN 4

Answers (1)

Siddharth Bhutiya
Siddharth Bhutiya on 1 Oct 2019
You can flatten your matrices into column vectors (M1(:)) and then create a table from that. I see that you want the data in row major form, so you would have to transpose your matrix before flattening it.
M1 = M1';
M2 = M2';
t = table(M1(:),M2(:),'VariableNames',["M1 Value","M2 Value"])
t =
4×2 table
M1 Value M2 Value
________ ________
3 6
3 1
8 5
NaN 4

Categories

Find more on Tables in Help Center and File Exchange

Products


Release

R2018b

Community Treasure Hunt

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

Start Hunting!