Sub heading in matlab table

Question

Davindra Usov 2023-1-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1894975-sub-heading-in-matlab-table

评论： Davindra Usov 2023-1-17

fru.jpg

Hello,

I am trying to create the table shown in the image attached. So far my code generates the table with all the headings but without the 'old fruit' and 'new fruit' headings. How do I add these headings into my code?

table.Properties.VariableNames(1:4) = {'apples','oranges','strawberries','grapefruit'}

writetable(table,'fruit.csv')

thank you

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

请先登录，再进行评论。

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

Answer 1

Adam Danz 2023-1-16

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1894975-sub-heading-in-matlab-table#answer_1149885

编辑：Adam Danz 2023-1-16

在 MATLAB Online 中打开

There isn't an option to arrange subheadings as described in your attached image.

However, there are several ways to rearrange the table to contain subheadings.

Option 1: nested subheaders

MATLAB R2018b or later

apples = table([3;4],[1;4],'VariableNames',{'old','new'});
oranges = table([3;4],[1;4],'VariableNames',{'old','new'});
strawberries = table([3;4],[1;4],'VariableNames',{'old','new'});
grapefruit = table([3;4],[1;4],'VariableNames',{'old','new'});
fruit = table(apples, oranges, strawberries, grapefruit)
fruit = 2×4 table
      apples       oranges      strawberries    grapefruit
    old    new    old    new     old    new     old    new
    __________    __________    ____________    __________

     3      1      3      1       3      1       3      1 
     4      4      4      4       4      4       4      4 

Option 2: nested subheaders version 2

MATLAB R2018b or later

old = table([3;4],[6;4],[5;3],[1;2], 'VariableNames', {'apples','ornages','strawberries', 'grapefruit'});
new = table([1;4],[1;13],[2;11],[3;3], 'VariableNames', {'apples','ornages','strawberries', 'grapefruit'});
fruit = table(old,new)
fruit = 2×2 table
                          old                                                new                      
    apples    ornages    strawberries    grapefruit    apples    ornages    strawberries    grapefruit
    _______________________________________________    _______________________________________________

      3          6            5              1           1          1             2             3     
      4          4            3              2           4         13            11             3     

Option 3: Store subheaders in a table variable

MATLAB R2013b or later

Note that the use of subheadings above makes indexing difficult. Here's a recommendation that preserves the labels but allows for easier indexing:

fruit = table(["old";"old";"new";"new"], ...
    [3;4;1;4],[6;4;1;13],[5;3;2;11],[1;2;3;3], ...
    'VariableNames', {'age','apples','oranges','strawberries','grapefruit'})
fruit = 4×5 table
     age     apples    oranges    strawberries    grapefruit
    _____    ______    _______    ____________    __________

    "old"      3          6             5             1     
    "old"      4          4             3             2     
    "new"      1          1             2             3     
    "new"      4         13            11             3     