marksheet in matlab program

Question

busy girl 2020-12-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/687083-marksheet-in-matlab-program

编辑： Image Analyst 2020-12-8

I have following data set in excel file

rollno  name   courses   marks   
     abc     maths     10
    abc      english   10
    abc      science   10 
                                
   def       maths     5
   def       english   5
   def       sciece    5
                               

now i want to get total marks and percentage of each sutdent in next columns in excel file like below ... so how i do write matlab program

rollno  name   courses   marks   total marks  perecentage
12       abc     maths     10
12      abc      english   10
12      abc      science   10 
                                30                  50%
13     def       maths     5
13     def       english   5
12     def       sciece    5
                               15                    60%

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

请先登录，再进行评论。

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

Answer 1

Image Analyst 2020-12-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/687083-marksheet-in-matlab-program#answer_569288

编辑：Image Analyst 2020-12-8

在 MATLAB Online 中打开

You forgot to attach the Excel workbook.

TUTORIAL: How to ask a question (on Answers) and get a fast answer

You'd do something like (untested)

[numbers, strings, raw] = xlsread(fileName);
% Then go down numbers looking for valid rows
rollno = numbers(:, 1);
marks = numbers(:, 4);
% Get rid of nan's
blankRows = isnan(rollno);
rollno = rollno(~blankRows);
marks = marks(~blankRows);
% Find the unique rolnos
uniqueNumbers = unique(rollno(~blankRows))
for rn = 1 : length(uniqueNumbers)
    thisStudentID = uniqueNumbers(rn);
    thisStudentIndexes = rollno == thisStudentID; % Logical vector
    % Get average marks for this student
    aveMarks(thisStudentID) = mean(marks(thisStudentIndexes));
    % Get total marks for this student
    totalMarks(thisStudentID) = sum(marks(thisStudentIndexes));
end