Tabluate data using common terms in varaible names

Question

DavidL88 2021-6-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/864320-tabluate-data-using-common-terms-in-varaible-names

编辑： Scott MacKenzie 2021-6-25

Is there a way to place the data below in a table with column names MLD, MOD, WG and OUT and rows by ab, ac, ad, ae, using the common terms in the varaiable names?

Table

MLD MOD WG OUT

ab

ac

ad

ae

ab_MLD = 2
ac_MLD = 5
ad_MLD = 2 
ae_MLD = 5
ab_MOD = 6
ac_MOD = 3
ad_MOD = 9
ae_MOD = 4
ab_WG = 14
ac_WG = 3
ad_WG = 4
ae_WG = 1
ab_OUT = 2
ac_OUT = 6
ad_OUT = 3
ae_OUT = 5

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Scott MacKenzie 2021-6-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/864320-tabluate-data-using-common-terms-in-varaible-names#answer_733425

编辑：Scott MacKenzie 2021-6-25

在 MATLAB Online 中打开

If I understand your question correctly, you want to extract the row and column names from the variable names. If so...

ab_MLD = 2
ac_MLD = 5
ad_MLD = 2 
ae_MLD = 5
ab_MOD = 6
ac_MOD = 3
ad_MOD = 9
ae_MOD = 4
ab_WG = 14
ac_WG = 3
ad_WG = 4
ae_WG = 1
ab_OUT = 2
ac_OUT = 6
ad_OUT = 3
ae_OUT = 5
s = convertCharsToStrings(who);
data = [ab_MLD, ac_MLD, ad_MLD, ae_MLD; ...
   ab_MOD, ac_MOD, ad_MOD, ae_MOD; ...
   ab_WG, ac_WG, ad_WG, ae_WG; ...
   ab_OUT, ac_OUT, ad_OUT, ae_OUT]';
r = unique(extractBefore(s, '_')); % row names
c = unique(extractAfter(s, '_')); % column names
T = array2table(data, 'rownames', r, 'variablenames', c)

T =

4×4 table

MLD MOD OUT WG

___ ___ ___ __

ab 2 6 14 2

ac 5 3 3 6

ad 2 9 4 3

ae 5 4 1 5

There are a few caveats here. The script must begin with a clean workspace and the line assigning the variable names must immediately follow the assignment statements.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

DavidL88 2021-6-25

That worked thanks.

请先登录，再进行评论。

Answer 2

Mohammad Sami 2021-6-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/864320-tabluate-data-using-common-terms-in-varaible-names#answer_733270

在 MATLAB Online 中打开

You can specify the rownames property of the table.

a = array2table(zeros(4,4),'RowNames',{'ab' 'ac' 'ad' 'ae'},'VariableNames',{'MLD' 'MOD' 'WG' 'OUT'});
a{'ab','MLD'} = 2
a = 4×4 table
          MLD    MOD    WG    OUT
          ___    ___    __    ___

    ab     2      0     0      0 
    ac     0      0     0      0 
    ad     0      0     0      0 
    ae     0      0     0      0 
a{:,'MLD'} = [2;5;2;5]
a = 4×4 table
          MLD    MOD    WG    OUT
          ___    ___    __    ___

    ab     2      0     0      0 
    ac     5      0     0      0 
    ad     2      0     0      0 
    ae     5      0     0      0 
a{:,:} = [2 6 14 2; 5 3 3 6; 2 9 4 3; 5 4 1 5]
a = 4×4 table
          MLD    MOD    WG    OUT
          ___    ___    __    ___

    ab     2      6     14     2 
    ac     5      3      3     6 
    ad     2      9      4     3 
    ae     5      4      1     5 