Creating heading for table that changes depending on datainput

Question

Håkon Haavik Nystad 2018-1-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/377210-creating-heading-for-table-that-changes-depending-on-datainput

评论： Håkon Haavik Nystad 2018-1-15

Capture.PNG

    grades_incl_final=[cellstr(data.StudentID) cellstr(data.Name) num2cell(grades) num2cell([computeFinalGrades(grades)]')];
    array=[grades_incl_final];
    table=array2table(array);
    table.Properties.VariableNames = {'StudentID' 'StudentName' 'Assignment1' 'Assignment2' 'Assignment3' 'FinalGrade'}
    disp(table)

Hi This code creates the table that you can see in the attached picture. My problem is that I want to be able to put more than three assignments into the table. In other words the headings should change depending on the amount of assignments in the 'data' file. If it is easier it is okay if the heading for the assignments are just 1,2,3,4... Can someone tell me how I can do this?

2 个评论
显示无隐藏无

Guillaume 2018-1-15

Don't call your table table since that will prevent you from constructing tables the proper way with the table function.
There is no point constructing a cell array to then convert into a table. You can create the table directly.
What is the class of data? and what is the class of data.StudentID and data.Name ?

Håkon Haavik Nystad 2018-1-15

It is a csv file. An studentID and Name are headings in the table. So data.StudentID and data.Name are taken from the table/csv file

请先登录，再进行评论。

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

Answer 1

Guillaume 2018-1-15

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/377210-creating-heading-for-table-that-changes-depending-on-datainput#answer_300184

在 MATLAB Online 中打开

Assuming data is also a table:

t = [data(:, {'StudentID', 'Name'}), ...   copy part of original table
     array2table(grades, 'VariableNames', compose('Assignment%d', 1:size(grades, 2))), ... conversion of grades to table
     table(computeFinalGrades(grades).', 'VariableNames', {'FinalGrade'})] %add final grade

Note that you will have to clear table so you can use the table function that you've clobbered with your table variable.

The bit where I generate the column name for the grades is

compose('Assignment%d', 1:size(grades, 2))

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

请先登录，再进行评论。

Answer 2

Matt J 2018-1-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/377210-creating-heading-for-table-that-changes-depending-on-datainput#answer_300183

编辑：Matt J 2018-1-15

在 MATLAB Online 中打开

     headings=arrayfun(@(i) ['Assignment' num2str(i)],1:numberOfAssignments,'uni',0);
   headings=[{'StudentID' 'StudentName'}, headings, {'FinalGrade'}];
     grades_incl_final=[cellstr(data.StudentID) cellstr(data.Name) num2cell(grades) num2cell([computeFinalGrades(grades)]')];
    array=[grades_incl_final];
    T=array2table(array);
    T.Properties.VariableNames = headings;
    disp(T)