Converting two matrix to a single table

조회 수: 51(최근 30일)
Ville Koivunen
Ville Koivunen 2019년 9월 12일
답변: Siddharth Bhutiya 2019년 10월 1일
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

답변(1개)

Siddharth Bhutiya
Siddharth Bhutiya 2019년 10월 1일
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

태그

제품


릴리스

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by